Name: StreetIntersectionDetail

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• INTERSECTID (type: esriFieldTypeString, alias: Intersection Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CONTFORM (type: esriFieldTypeString, alias: Control Form, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Accuated: Accuated], [Fixed: Fixed], [Semi-Accuated: Semi-Accuated], ... 1 more ...)
• DETECTTYPE (type: esriFieldTypeString, alias: Detector Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [In Pavement: In Pavement], [Non Intrusive: Non Intrusive], [Non Motorized: Non Motorized])
• CROSSWALK (type: esriFieldTypeString, alias: Pedestrian Crosswalk, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CROSSTYPE (type: esriFieldTypeString, alias: Crosswalk Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Decorative Concrete: Decorative Concrete], [Paint (Non-reflective): Paint (Non-reflective)], [Paint (Reflective): Paint (Reflective)], ... 3 more ...)
• PEDHEADS (type: esriFieldTypeString, alias: Pedestrian Crossing Signals, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PEDBUTTON (type: esriFieldTypeString, alias: Pedestrian Crossing Buttons, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ADACOMPLY (type: esriFieldTypeString, alias: ADA Compliant, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ILLUMINATE (type: esriFieldTypeString, alias: Illuminated, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• NBAPPSPEED (type: esriFieldTypeString, alias: Northbound Approach Speed, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [25 MPH: 25 MPH], [35 MPH: 35 MPH], [40 MPH: 40 MPH], ... 9 more ...)
• SBAPPSPEED (type: esriFieldTypeString, alias: Southbound Approach Speed, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [25 MPH: 25 MPH], [35 MPH: 35 MPH], [40 MPH: 40 MPH], ... 9 more ...)
• EBAPPSPEED (type: esriFieldTypeString, alias: Eastbound Approach Speed, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [25 MPH: 25 MPH], [35 MPH: 35 MPH], [40 MPH: 40 MPH], ... 9 more ...)
• WBAPPSPPED (type: esriFieldTypeString, alias: Westbound Approach Speed, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [25 MPH: 25 MPH], [35 MPH: 35 MPH], [40 MPH: 40 MPH], ... 9 more ...)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TrafficLight (type: esriFieldTypeString, alias: TrafficLight, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• IntersectionHasIntersectionDetails (17) -- Related To: StreetIntersection (67)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/7/2021 7:15:38 PM

Schema Last Edit Date: 10/7/2021 7:15:38 PM

Data Last Edit Date: 10/7/2021 7:15:38 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat