Name: Crashes_XYTableToPoint

Display Field: MAIN_ROAD_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: 447375.14
YMin: 4478600
XMax: 627050
YMax: 4566498.03
Spatial Reference: 26912 (26912)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"158f49b0273858c3ec59ac4338837ac5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAATCAYAAACk9eypAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA7UlEQVQokZWSMVLDMBBFn8CkcO1LqHcb01LnEPS0dgoV2IdITR3OENXudQnXZiYZZilsIZBlPGwnad9/0qwy/lnZYud40XyiAbjH8fro0sDxohH1jLDnbt4ToLaOXf6CKYcAmL7gOtaoOflnKTTX8Q14CsDt45BsDlBBY2vaqpsAkT1q47UyBWbf2q1SaExfzAbcJiQ4TDl4g4MNYOqZr/SQn7iNh78BeQ+AKQcaewbWoLMfYBhcW3U0dgkIA7v85Jfx11haFNZPeQnElig9ZfhtidLTgLck0tcMk0VBnL4OtFWH6YvU0ZohmQ7wBUizT9PKvJazAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":14,"angle":0,"xoffset":0,"yoffset":6}},"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CRASH_ID (type: esriFieldTypeInteger, alias: CRASH_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PUBLIC_SAFETY_CASE_NUMBER (type: esriFieldTypeInteger, alias: PUBLIC_SAFETY_CASE_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_DATETIME (type: esriFieldTypeString, alias: CRASH_DATETIME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• YEAR_ (type: esriFieldTypeString, alias: YEAR_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• YEAR_X (type: esriFieldTypeDouble, alias: YEAR_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YEAR_Y (type: esriFieldTypeDouble, alias: YEAR_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REGION_ID (type: esriFieldTypeInteger, alias: REGION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROUTE (type: esriFieldTypeInteger, alias: ROUTE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROUTE_DIRECTION (type: esriFieldTypeString, alias: ROUTE_DIRECTION, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RouteID (type: esriFieldTypeString, alias: RouteID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROADWAY_TYPE (type: esriFieldTypeString, alias: ROADWAY_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EXIT_NUMBER (type: esriFieldTypeString, alias: EXIT_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RAMP_ID (type: esriFieldTypeInteger, alias: RAMP_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MILEPOINT (type: esriFieldTypeDouble, alias: MILEPOINT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAT_UTM_Y (type: esriFieldTypeDouble, alias: LAT_UTM_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONG_UTM_X (type: esriFieldTypeDouble, alias: LONG_UTM_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAIN_ROAD_NAME (type: esriFieldTypeString, alias: MAIN_ROAD_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOCATION_DESC__RAW_DATA_ (type: esriFieldTypeString, alias: LOCATION_DESC__RAW_DATA_, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CRASH_SEVERITY (type: esriFieldTypeInteger, alias: CRASH_SEVERITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IMPROPER_RESTRAINT (type: esriFieldTypeString, alias: IMPROPER_RESTRAINT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UNRESTRAINED (type: esriFieldTypeString, alias: UNRESTRAINED, 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)
• BICYCLIST_INVOLVED (type: esriFieldTypeString, alias: BICYCLIST_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)
• ROADWAY_GEOMETRY_RELATED (type: esriFieldTypeString, alias: ROADWAY_GEOMETRY_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROADWAY_DEPARTURE (type: esriFieldTypeString, alias: ROADWAY_DEPARTURE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AGGRESSIVE_DRIVING (type: esriFieldTypeString, alias: AGGRESSIVE_DRIVING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DROWSY_DRIVING (type: esriFieldTypeString, alias: DROWSY_DRIVING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DISREGARD_TRAFFIC_CONTROL_DEV (type: esriFieldTypeString, alias: DISREGARD_TRAFFIC_CONTROL_DEV, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DISTRACTED_DRIVING (type: esriFieldTypeString, alias: DISTRACTED_DRIVING, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DUI (type: esriFieldTypeString, alias: DUI, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPEED_RELATED (type: esriFieldTypeString, alias: SPEED_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WILD_ANIMAL_RELATED (type: esriFieldTypeString, alias: WILD_ANIMAL_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DOMESTIC_ANIMAL_RELATED (type: esriFieldTypeString, alias: DOMESTIC_ANIMAL_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OVERTURN_ROLLOVER (type: esriFieldTypeString, alias: OVERTURN_ROLLOVER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• COMMERCIAL_MOTOR_VEH_INVOLVED (type: esriFieldTypeString, alias: COMMERCIAL_MOTOR_VEH_INVOLVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• INTERSTATE_HIGHWAY (type: esriFieldTypeString, alias: INTERSTATE_HIGHWAY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TEENAGE_DRIVER_INVOLVED (type: esriFieldTypeString, alias: TEENAGE_DRIVER_INVOLVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OLDER_DRIVER_INVOLVED (type: esriFieldTypeString, alias: OLDER_DRIVER_INVOLVED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROUTE_TYPE (type: esriFieldTypeString, alias: ROUTE_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• COLLISION_WITH_FIXED_OBJECT (type: esriFieldTypeString, alias: COLLISION_WITH_FIXED_OBJECT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• INTERSECTION_RELATED (type: esriFieldTypeString, alias: INTERSECTION_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROADWAY_JUNCT_FEATURE (type: esriFieldTypeInteger, alias: ROADWAY_JUNCT_FEATURE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORK_ZONE_RELATED (type: esriFieldTypeString, alias: WORK_ZONE_RELATED, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HORIZONTAL_ALIGNMENT (type: esriFieldTypeInteger, alias: HORIZONTAL_ALIGNMENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VERTICAL_ALIGNMENT (type: esriFieldTypeInteger, alias: VERTICAL_ALIGNMENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LIGHT_CONDITION (type: esriFieldTypeInteger, alias: LIGHT_CONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WEATHER_CONDITION (type: esriFieldTypeInteger, alias: WEATHER_CONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MANNER_COLLISION (type: esriFieldTypeInteger, alias: MANNER_COLLISION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAY_SURF_CONDITION (type: esriFieldTypeInteger, alias: ROADWAY_SURF_CONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAY_CONTRIB_CIRCUM (type: esriFieldTypeInteger, alias: ROADWAY_CONTRIB_CIRCUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_NUMBER_ROADWAY_LANES (type: esriFieldTypeInteger, alias: TOTAL_NUMBER_ROADWAY_LANES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMBER_VEHICLES_INVOLVED (type: esriFieldTypeInteger, alias: NUMBER_VEHICLES_INVOLVED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIRST_HARMFUL_EVENT (type: esriFieldTypeInteger, alias: FIRST_HARMFUL_EVENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FIRST_HARMFUL_EVT_LOC (type: esriFieldTypeInteger, alias: FIRST_HARMFUL_EVT_LOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_DETAIL_ID (type: esriFieldTypeInteger, alias: VEHICLE_DETAIL_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_NUM (type: esriFieldTypeInteger, alias: VEHICLE_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EVENT_SEQ_1 (type: esriFieldTypeInteger, alias: EVENT_SEQ_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EVENT_SEQ_2 (type: esriFieldTypeInteger, alias: EVENT_SEQ_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EVENT_SEQ_3 (type: esriFieldTypeInteger, alias: EVENT_SEQ_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EVENT_SEQ_4 (type: esriFieldTypeInteger, alias: EVENT_SEQ_4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MOST_HARMFUL_EVENT (type: esriFieldTypeInteger, alias: MOST_HARMFUL_EVENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAFFIC_CONTROL_DEVICE (type: esriFieldTypeInteger, alias: TRAFFIC_CONTROL_DEVICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_MANEUVER (type: esriFieldTypeInteger, alias: VEHICLE_MANEUVER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRAVEL_DIRECTION (type: esriFieldTypeInteger, alias: TRAVEL_DIRECTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VEHICLE_CONTRIB_CIRCUM_ID (type: esriFieldTypeInteger, alias: VEHICLE_CONTRIB_CIRCUM_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROADWAY_DESCRIPTION_ID (type: esriFieldTypeInteger, alias: ROADWAY_DESCRIPTION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POSTED_SPEED (type: esriFieldTypeInteger, alias: POSTED_SPEED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ESTIMATED_TRAVEL_SPEED (type: esriFieldTypeInteger, alias: ESTIMATED_TRAVEL_SPEED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MV_BODY_TYPE (type: esriFieldTypeInteger, alias: MV_BODY_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATE (type: esriFieldTypeDate, alias: DATE, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)

Templates:

Name: Crashes_XYTableToPoint
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/16/2023 1:49:15 PM

Schema Last Edit Date: 10/16/2023 1:49:15 PM

Data Last Edit Date: 10/16/2023 1:49:15 PM

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