Name: Dist2CollisionsClean.csv

Display Field: PRIMARY_ROAD_NAME

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)
• TCR_ID (type: esriFieldTypeInteger, alias: TCR_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeInteger, alias: CRASH_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJURED (type: esriFieldTypeInteger, alias: INJURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KILLED (type: esriFieldTypeInteger, alias: KILLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HIGHEST_INJURY (type: esriFieldTypeString, alias: HIGHEST_INJURY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HIT_RUN_TYPE (type: esriFieldTypeString, alias: HIT_RUN_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• REPORT_NO (type: esriFieldTypeString, alias: REPORT_NO, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TIMS_CASEID (type: esriFieldTypeInteger, alias: TIMS_CASEID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIMARY_ROAD_NAME (type: esriFieldTypeString, alias: PRIMARY_ROAD_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LON (type: esriFieldTypeDouble, alias: LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTANCE (type: esriFieldTypeDouble, alias: DISTANCE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIRECTION_FROM_INT (type: esriFieldTypeString, alias: DIRECTION_FROM_INT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CRASH_DT (type: esriFieldTypeDate, alias: CRASH_DT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SEQUENCE_NO (type: esriFieldTypeInteger, alias: SEQUENCE_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NCIC (type: esriFieldTypeDouble, alias: NCIC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PARTY_AT_FAULT (type: esriFieldTypeInteger, alias: PARTY_AT_FAULT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCF (type: esriFieldTypeString, alias: PCF, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PRIMARY_COLLISION_FACTOR (type: esriFieldTypeString, alias: PRIMARY_COLLISION_FACTOR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VC_VIOLATION_ID (type: esriFieldTypeInteger, alias: VC_VIOLATION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VC_SUB_SECTION (type: esriFieldTypeString, alias: VC_SUB_SECTION, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WEATHER (type: esriFieldTypeString, alias: WEATHER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LIGHTING (type: esriFieldTypeString, alias: LIGHTING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROADWAY_SURFACE (type: esriFieldTypeString, alias: ROADWAY_SURFACE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROADWAY_CONDITIONS (type: esriFieldTypeString, alias: ROADWAY_CONDITIONS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TRAFFIC_CONTROL_DEVICES (type: esriFieldTypeString, alias: TRAFFIC_CONTROL_DEVICES, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MOTOR_VEH_INVOLVED_WITH (type: esriFieldTypeString, alias: MOTOR_VEH_INVOLVED_WITH, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• VEH_INVOLVED_WITH_OBJECT (type: esriFieldTypeString, alias: VEH_INVOLVED_WITH_OBJECT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GUARDRAIL (type: esriFieldTypeString, alias: GUARDRAIL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PEDESTRIAN_ACTIONS (type: esriFieldTypeString, alias: PEDESTRIAN_ACTIONS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PEDESTRIAN_INVOLVED (type: esriFieldTypeString, alias: PEDESTRIAN_INVOLVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BICYCLE_INVOLVED (type: esriFieldTypeString, alias: BICYCLE_INVOLVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MOTORCYCLE_INVOLVED (type: esriFieldTypeString, alias: MOTORCYCLE_INVOLVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PED_UNDER_18_INJ (type: esriFieldTypeString, alias: PED_UNDER_18_INJ, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BICYCLIST_UNDER_18 (type: esriFieldTypeString, alias: BICYCLIST_UNDER_18, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• COLLISION_PATTERN (type: esriFieldTypeString, alias: COLLISION_PATTERN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SUP_DIST (type: esriFieldTypeInteger, alias: SUP_DIST, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMUNITY (type: esriFieldTypeString, alias: COMMUNITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Community_Group (type: esriFieldTypeString, alias: Community_Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TIME (type: esriFieldTypeString, alias: TIME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TIME_ROUNDED (type: esriFieldTypeString, alias: TIME_ROUNDED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TIME_GROUPS (type: esriFieldTypeString, alias: TIME_GROUPS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MONTH (type: esriFieldTypeInteger, alias: MONTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DAY (type: esriFieldTypeInteger, alias: DAY, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Dist2CollisionsClean.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/12/2025 4:08:56 PM

Schema Last Edit Date: 5/12/2025 4:08:56 PM

Data Last Edit Date: 5/12/2025 4:08:56 PM

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