Name: Stop Controlled Intersections with 5+ Angle Crashes

Display Field: Major_Rd_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 177587.117526725
YMin: 2663125.1077354
XMax: 1069588.27118489
YMax: 3144406.79838531
Spatial Reference: 103379 (103379)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[205,102,102,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.75}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• INTERSECTION_ID (type: esriFieldTypeString, alias: INTERSECTION_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INTERSECTION_SOURCE (type: esriFieldTypeString, alias: INTERSECTION_SOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LRS_DATE_ESTABLISH (type: esriFieldTypeDate, alias: LRS_DATE_ESTABLISH, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LRS_DATE_RETIRE (type: esriFieldTypeDate, alias: LRS_DATE_RETIRE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FilterPoint (type: esriFieldTypeString, alias: FilterPoint, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Major_Rd_LRS_ID (type: esriFieldTypeString, alias: Major Rd LRS ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Minor_Rd_LRS_ID (type: esriFieldTypeString, alias: Minor Rd LRS ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Major_Rd_Mile_Post (type: esriFieldTypeDouble, alias: Major Rd Mile Post, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Minor_Rd_Mile_Post (type: esriFieldTypeDouble, alias: Minor Rd Mile Post, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Major_Rd_Name (type: esriFieldTypeString, alias: Major Rd Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Minor_Rd_Name (type: esriFieldTypeString, alias: Minor Rd Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Junction_Type (type: esriFieldTypeString, alias: Junction Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [RRN: Roadway/Roadway (Not Interchange Related)], [RRI: Roadway/Roadway (Interchange Ramp Terminal)], [RPC: Roadway/Pedestrian Crossing], ... 3 more ...)
• Leg_Count (type: esriFieldTypeSmallInteger, alias: Leg Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Geometry (type: esriFieldTypeString, alias: Geometry, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [TI: T-Intersection], [YI: Y-Intersection], [CI: Cross-Intersection (4 Legs)], ... 7 more ...)
• TrafficControl (type: esriFieldTypeString, alias: TrafficControl, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [UC: Uncontrolled], [TW: Two-Way Stop], [AW: All-Way Stop], ... 8 more ...)
• Signal_Type (type: esriFieldTypeString, alias: Signal Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [NS: No Signal], [O: Other], [SUT: Signal Unknown Type], ... 1 more ...)
• Offset_Intersection (type: esriFieldTypeString, alias: Offset Intersection, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• Intersection_Offset_Distance (type: esriFieldTypeDouble, alias: Intersection Offset Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Intersection_ID_of_Offset_Inter (type: esriFieldTypeString, alias: Intersection ID of Offset Intersection, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Town (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Major_Rd_Facility_Type (type: esriFieldTypeSmallInteger, alias: Major Rd Facility Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Mainline roadway], [3: Tunnel], [4: Doubledeck], ... 9 more ...)
• Minor_Rd_Facility_Type (type: esriFieldTypeSmallInteger, alias: Minor Rd Facility Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Mainline roadway], [3: Tunnel], [4: Doubledeck], ... 9 more ...)
• Major_Rd_Functional_Class (type: esriFieldTypeSmallInteger, alias: Major Rd Functional Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: Principal Arterial - Other Freeways or Expressways], [3: Principal Arterial - Other], ... 4 more ...)
• Minor_Rd_Functional_Class (type: esriFieldTypeSmallInteger, alias: Minor Rd Functional Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Interstate], [2: Principal Arterial - Other Freeways or Expressways], [3: Principal Arterial - Other], ... 4 more ...)
• Lighting (type: esriFieldTypeString, alias: Lighting, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• Number_of_lanes_in_circular_int (type: esriFieldTypeSmallInteger, alias: Number of lanes in circular intersection, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Circular_Lane_Width (type: esriFieldTypeDouble, alias: Circular Lane Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Circular_inscribed_diamete (type: esriFieldTypeDouble, alias: Circular inscribed diamete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Presence_and_type_of_bike_facil (type: esriFieldTypeString, alias: Presence and type of bike facility at intersection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N: None], [SCP: Separate Cycle Path], [CBL: Circulatory Bike Lane])
• HSM_ID (type: esriFieldTypeInteger, alias: HSM_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Priority (type: esriFieldTypeDouble, alias: Priority, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HSM_Intersection (type: esriFieldTypeString, alias: HSM_Intersection, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• HSM_Related_Intersection (type: esriFieldTypeString, alias: HSM_Related_Intersection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RPA (type: esriFieldTypeString, alias: RPA, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Review_Complete (type: esriFieldTypeString, alias: Review Complete, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [P: Partial])
• Delete_Intersection_ (type: esriFieldTypeString, alias: Delete Intersection?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• Reviewer_Comments (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EquipmentDB_ID (type: esriFieldTypeString, alias: EquipmentDB_ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FilterPoint_1 (type: esriFieldTypeString, alias: FilterPoint, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Located_in_an_Urban_Area (type: esriFieldTypeString, alias: Located in an Urban Area, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• MassDOT_District (type: esriFieldTypeString, alias: MassDOT District, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• StreetviewURL (type: esriFieldTypeString, alias: StreetviewURL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• School (type: esriFieldTypeString, alias: School, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• QA_QC_Comments (type: esriFieldTypeString, alias: QA/QC Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• QA_QC_Complete_ (type: esriFieldTypeString, alias: QA/QC Complete?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Name_of_Data_Collector (type: esriFieldTypeString, alias: Name of Data Collector, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [KeiltyM_Con: KeiltyM_Con], [ChaudharyG_Con: ChaudharyG_Con], [GordonA_Con: GordonA_Con], ... 25 more ...)
• Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ramp_Terminal (type: esriFieldTypeString, alias: Ramp Terminal, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• NearStateSignal (type: esriFieldTypeString, alias: NearStateSignal, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• MassDOT_Rd (type: esriFieldTypeString, alias: MassDOT_Rd, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• StateSignl (type: esriFieldTypeString, alias: StateSignl, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• TOWN_1 (type: esriFieldTypeString, alias: TOWN, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• District_Name (type: esriFieldTypeString, alias: District Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• District_Number (type: esriFieldTypeSmallInteger, alias: District Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MPO (type: esriFieldTypeString, alias: MPO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RPA_1 (type: esriFieldTypeString, alias: RPA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RPA_ID (type: esriFieldTypeInteger, alias: RPA_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RPA_NAME (type: esriFieldTypeString, alias: RPA_NAME, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• MPO_int (type: esriFieldTypeInteger, alias: MPO_int, SQL Type: sqlTypeOther, nullable: true, editable: true)
• City_ID (type: esriFieldTypeInteger, alias: City_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RTA (type: esriFieldTypeString, alias: RTA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RTA_NAME (type: esriFieldTypeString, alias: RTA_NAME, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ANGLECRASHES (type: esriFieldTypeInteger, alias: Angle Crashes within 150ft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FourTravelLanes (type: esriFieldTypeString, alias: Four Travel Lanes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EligibilityComment (type: esriFieldTypeString, alias: Eligibility Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Eligible (type: esriFieldTypeString, alias: Eligible? Y/N, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])

Templates:

Name: Stop Controlled Intersections with 5+ Angle Crashes
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/13/2024 3:23:49 PM

Schema Last Edit Date: 11/8/2024 8:06:33 PM

Data Last Edit Date: 11/13/2024 3:23:49 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat