Name: Crosswalk_Survey_V2

Display Field: CrosswalkName

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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: globalid

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CrosswalkName (type: esriFieldTypeString, alias: Crosswalk Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CollectedDateTime (type: esriFieldTypeDate, alias: Collected Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Collector (type: esriFieldTypeString, alias: Collector:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PostedSpeedLimit (type: esriFieldTypeString, alias: Posted Speed Limit:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MajorRoadName (type: esriFieldTypeString, alias: Major Road Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TravelLanesMajorRoad (type: esriFieldTypeString, alias: Number of travel lanes on major road:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrossWalkLocation (type: esriFieldTypeString, alias: Determine the type of cross walk location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Midblock: Midblock], [Intersection: At intersection (unsignalized)])
• CrosswalkPavMarkings (type: esriFieldTypeString, alias: Crosswalk Striping:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Continental: Continental], [Standard: Standard], [Zebra: Zebra], ... 1 more ...)
• InvenPavMarkings (type: esriFieldTypeString, alias: Striping Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Good: Good - Visible and reflective], [Fair: Fair - Visible, but not as reflective or fading in spots], [Poor: Poor - Partially visible, but fading it noticeable throughout], ... 1 more ...)
• InventorySignage (type: esriFieldTypeString, alias: Inventory Signage Condition Inventory signage condition within 150-ft of crosswalk on major road, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PedWarningSigns (type: esriFieldTypeString, alias: Advanced pedestrian warning signage?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PedWarningSignsNote (type: esriFieldTypeString, alias: Take a photo of the advanced pedestrian warning signage in the "Photographs" section at the end of the survey., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PedWarningDownArrow (type: esriFieldTypeString, alias: Pedestrian warning signage with down arrows at crosswalk?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• PedWarningDownArrowNote (type: esriFieldTypeString, alias: Take a photo of the pedestrian warning signage with down arrows in the "Photographs" section at the end of the survey., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WheelChairRamp (type: esriFieldTypeString, alias: Wheelchair Ramp Present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [OneSide: One Side], [BothSides: Both Sides], [None: None])
• SidewalkPresent (type: esriFieldTypeString, alias: Sidewalk Present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [OneSide: One Side], [BothSides: Both Sides], [None: None])
• SidewalkCondition (type: esriFieldTypeString, alias: Sidewalk Condition (if present), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SidewalkConditionOther (type: esriFieldTypeString, alias: Other Sidewalk Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SidewalkDeficiencies (type: esriFieldTypeString, alias: Sidewalk Deficiencies, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ProxtoPedGenerator (type: esriFieldTypeString, alias: Proximity to Pedestrian Generator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ProxtoPedGeneratorOther (type: esriFieldTypeString, alias: Other Proximity to Pedestrian Generator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GeneralObservations (type: esriFieldTypeString, alias: General Observation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OtherGeneralObservations (type: esriFieldTypeString, alias: Other General Observations, SQL Type: sqlTypeOther, length: 255, 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)

Templates:

Name: Crosswalk_Survey_V2
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• EditDate: -2209161600000
• Editor:
• Creator:
• CrosswalkName:
• CollectedDateTime: -2209161600000
• Collector:
• PostedSpeedLimit:
• MajorRoadName:
• TravelLanesMajorRoad:
• CrossWalkLocation:
• CrosswalkPavMarkings:
• InvenPavMarkings:
• InventorySignage:
• PedWarningSigns:
• PedWarningSignsNote:
• PedWarningDownArrow:
• PedWarningDownArrowNote:
• WheelChairRamp:
• SidewalkPresent:
• SidewalkCondition:
• SidewalkConditionOther:
• SidewalkDeficiencies:
• ProxtoPedGenerator:
• ProxtoPedGeneratorOther:
• GeneralObservations:
• OtherGeneralObservations:
• CreationDate: -2209161600000

Relationships:

• StateRoadCrosswalks_Scoring (0) -- Related To: StateRoadCrosswalks_Scoring (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/3/2024 7:52:09 AM

Schema Last Edit Date: 5/3/2024 7:52:09 AM

Data Last Edit Date: 5/3/2024 6:47:46 AM

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