{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "MIRE_TBL_Intersection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "JunctionID_T", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "IntersectionID", "type": "esriFieldTypeInteger", "alias": "IntersectionID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IntersectionID" }, { "name": "JunctionID_T", "type": "esriFieldTypeString", "alias": "Unique junction identifier (text)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "JunctionID_T" }, { "name": "RoadCrossing1", "type": "esriFieldTypeString", "alias": "Location Identifier for Road 1 Crossing", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RoadCrossing1" }, { "name": "RoadCrossing2", "type": "esriFieldTypeString", "alias": "Location Identifier for Road 2 Crossing", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RoadCrossing2" }, { "name": "GeometryType", "type": "esriFieldTypeSmallInteger", "alias": "Intersection/Junction Geometry Type", "domain": { "type": "codedValue", "name": "dIntersectionGeomtryType", "description": "110 - Type of geometry configuration", "codedValues": [ { "name": "T-Intersection", "code": 1 }, { "name": "Y-Intersection", "code": 2 }, { "name": "Cross-Intersection (four legs)", "code": 3 }, { "name": "Five or more legs and not circular", "code": 4 }, { "name": "Roundabout", "code": 5 }, { "name": "Other circular intersection (e.g., rotaries, neighborhood traffic circles)", "code": 6 }, { "name": "Midblock pedestrian crossing", "code": 7 }, { "name": "Restricted crossing U-turn (i.e., RCUT, J-turn, Superstreet) intersection", "code": 8 }, { "name": "Median U-turn (i.e., MUT, Michigan Left, Thru-turn) intersection", "code": 9 }, { "name": "Displaced left-turn (i.e., DLT, continuous flow, CFI) intersection", "code": 10 }, { "name": "Jughandle (i.e., New Jersey jughandle) intersection", "code": 11 }, { "name": "Continuous green T-intersection", "code": 12 }, { "name": "Quadrant (i.e., quadrant roadway) intersection", "code": 13 }, { "name": "Other", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GeometryType" }, { "name": "TrafficControl", "type": "esriFieldTypeSmallInteger", "alias": "Intersection/Junction Traffic Control", "domain": { "type": "codedValue", "name": "dIntersectionTrafficControl", "description": "111 - Traffic control present at intersection/junction", "codedValues": [ { "name": "Uncontrolled", "code": 1 }, { "name": "Two-way", "code": 2 }, { "name": "All-way stop", "code": 3 }, { "name": "Yield sign", "code": 4 }, { "name": "Signalized", "code": 5 }, { "name": "Flash Beacon (include Rectangular Rapid Flash Beacon)", "code": 7 }, { "name": "Railroad crossing, gates and flashing lights", "code": 8 }, { "name": "Railroad crossing, flashing lights only", "code": 9 }, { "name": "Railroad crossing, stop-sign controlled", "code": 10 }, { "name": "Railroad crossing, crossbucks only", "code": 11 }, { "name": "Other", "code": 12 }, { "name": "Pedestrian Hybrid Beacon (PHB or High-Intensity Activated Crosswalk {HAWK])", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TrafficControl" }, { "name": "modeType", "type": "esriFieldTypeSmallInteger", "alias": "Type of Intersection/Junction", "domain": { "type": "codedValue", "name": "dIntersectionModeType", "description": "112 - Type of junction based on converging modes", "codedValues": [ { "name": "Roadway/roadway (not interchange related)", "code": 1 }, { "name": "Roadway/roadway (interchange ramp terminal)", "code": 2 }, { "name": "Roadway/roadway grade crossing", "code": 3 }, { "name": "Roadway/pedestrian crossing (e.g. midblock crossing, pedestrian path or trail)", "code": 4 }, { "name": "Roadway/bicycle path or trail", "code": 5 }, { "name": "Other", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "modeType" }, { "name": "RoadCrossing3", "type": "esriFieldTypeString", "alias": "Location Identifier for Addtional Road Crossing Points", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RoadCrossing3" }, { "name": "NumLegs", "type": "esriFieldTypeInteger", "alias": "Number of Legs", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumLegs" }, { "name": "SchoolZoneIndicator", "type": "esriFieldTypeSmallInteger", "alias": "School Zone Indicator", "domain": { "type": "codedValue", "name": "dBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SchoolZoneIndicator" }, { "name": "RailroadCrossingID", "type": "esriFieldTypeString", "alias": "Railroad Crossing Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RailroadCrossingID" }, { "name": "IntersectingAcuteAngle", "type": "esriFieldTypeDouble", "alias": "Intersecting angle (degrees)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IntersectingAcuteAngle" }, { "name": "OffsetDistance", "type": "esriFieldTypeDouble", "alias": "Intersection/Junction offset distance (feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OffsetDistance" }, { "name": "SignalType", "type": "esriFieldTypeSmallInteger", "alias": "Signalization Presence/Type", "domain": { "type": "codedValue", "name": "dIntersectionSignalizationType", "description": "119 - Signalization Presence/Type", "codedValues": [ { "name": "Uncoordinated fixed time", "code": 1 }, { "name": "Uncoordinated traffic actuated", "code": 2 }, { "name": "Coordinated progressive", "code": 3 }, { "name": "Coordinated real-time adaptive", "code": 4 }, { "name": "No signal systems exist", "code": 5 }, { "name": "Railroad crossing signal (signal, gates, bells)", "code": 6 }, { "name": "Other", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SignalType" }, { "name": "Lighting", "type": "esriFieldTypeSmallInteger", "alias": "Intersection/Junction Lighting", "domain": { "type": "codedValue", "name": "dBoolean", "description": "", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lighting" }, { "name": "NumCircularLanes", "type": "esriFieldTypeSmallInteger", "alias": "Number of Circulatory Lanes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumCircularLanes" }, { "name": "CircularLaneWidth", "type": "esriFieldTypeDouble", "alias": "Circulatory Lane Width (feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CircularLaneWidth" }, { "name": "InscribedDiameter", "type": "esriFieldTypeDouble", "alias": "Inscribed diameter (feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InscribedDiameter" }, { "name": "CirIntBikeFacility", "type": "esriFieldTypeSmallInteger", "alias": "Circular Intersection - Bicycle Facility", "domain": { "type": "codedValue", "name": "dIntersectionCircularBikeType", "description": "124 - Circular Intersection - Bicycle Facility", "codedValues": [ { "name": "None", "code": 1 }, { "name": "Separate bicycle path", "code": 2 }, { "name": "Circulatory bicycle lane", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CirIntBikeFacility" } ], "indexes": [ { "name": "R275_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MIRE_TBL_Intersection", "description": "", "prototype": { "attributes": { "InscribedDiameter": null, "CirIntBikeFacility": null, "IntersectionID": null, "JunctionID_T": null, "RoadCrossing1": null, "RoadCrossing2": null, "GeometryType": null, "TrafficControl": null, "modeType": null, "RoadCrossing3": null, "NumLegs": null, "SchoolZoneIndicator": null, "RailroadCrossingID": null, "IntersectingAcuteAngle": null, "OffsetDistance": null, "SignalType": null, "Lighting": null, "NumCircularLanes": null, "CircularLaneWidth": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }