Layer: mercer_crashes.public.crashes (ID:9)

View In: Map Viewer

Name: mercer_crashes.public.crashes

Display Field: cross_street_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: mercer_crashes.public.crashes

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[57,140,90,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ESRI_OID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

crash_id (type: esriFieldTypeString, alias: crash_id, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
municipality (type: esriFieldTypeString, alias: municipality, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
crash_date (type: esriFieldTypeDateOnly, alias: crash_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
crash_day (type: esriFieldTypeString, alias: crash_day, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
crash_time (type: esriFieldTypeTimeOnly, alias: crash_time, SQL Type: sqlTypeOther, nullable: true, editable: true)
pd_code (type: esriFieldTypeString, alias: pd_code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
police_dept (type: esriFieldTypeString, alias: police_dept, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
police_station (type: esriFieldTypeString, alias: police_station, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
total_killed (type: esriFieldTypeInteger, alias: total_killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
total_injured (type: esriFieldTypeInteger, alias: total_injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
peds_killed (type: esriFieldTypeInteger, alias: peds_killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
peds_injured (type: esriFieldTypeInteger, alias: peds_injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
severity (type: esriFieldTypeString, alias: severity, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
intersection (type: esriFieldTypeString, alias: intersection, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
alcohol (type: esriFieldTypeString, alias: alcohol, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
hazmat (type: esriFieldTypeString, alias: hazmat, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
crash_type_code (type: esriFieldTypeString, alias: crash_type_code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
total_vehicles (type: esriFieldTypeInteger, alias: total_vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
crash_location (type: esriFieldTypeString, alias: crash_location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
location_direction (type: esriFieldTypeString, alias: location_direction, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
route (type: esriFieldTypeString, alias: route, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
route_suffix (type: esriFieldTypeString, alias: route_suffix, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
sri (type: esriFieldTypeString, alias: sri, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
milepost (type: esriFieldTypeString, alias: milepost, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
road_system (type: esriFieldTypeString, alias: road_system, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
road_character (type: esriFieldTypeString, alias: road_character, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
road_horiz_align (type: esriFieldTypeString, alias: road_horiz_align, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
road_grade (type: esriFieldTypeString, alias: road_grade, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
road_surface_type (type: esriFieldTypeString, alias: road_surface_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
surface_condition (type: esriFieldTypeString, alias: surface_condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
light_condition (type: esriFieldTypeString, alias: light_condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
environmental_condition (type: esriFieldTypeString, alias: environmental_condition, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
road_divider (type: esriFieldTypeString, alias: road_divider, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
temp_tcz (type: esriFieldTypeString, alias: temp_tcz, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
dist_cross_street (type: esriFieldTypeString, alias: dist_cross_street, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
um (type: esriFieldTypeString, alias: um, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
direc_from_cross_street (type: esriFieldTypeString, alias: direc_from_cross_street, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
cross_street_name (type: esriFieldTypeString, alias: cross_street_name, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
is_ramp (type: esriFieldTypeString, alias: is_ramp, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ramp_route_name (type: esriFieldTypeString, alias: ramp_route_name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
ramp_route_direction (type: esriFieldTypeString, alias: ramp_route_direction, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
posted_speed (type: esriFieldTypeString, alias: posted_speed, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
posted_speed_cross_street (type: esriFieldTypeString, alias: posted_speed_cross_street, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
first_harm (type: esriFieldTypeString, alias: first_harm, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
cell_phone_used (type: esriFieldTypeString, alias: cell_phone_used, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
other_prop_dmg (type: esriFieldTypeString, alias: other_prop_dmg, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
badge_no (type: esriFieldTypeString, alias: badge_no, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
numetric_id (type: esriFieldTypeString, alias: numetric_id, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
longitude_geocode (type: esriFieldTypeDouble, alias: longitude_geocode, SQL Type: sqlTypeOther, nullable: true, editable: true)
latitude_geocode (type: esriFieldTypeDouble, alias: latitude_geocode, SQL Type: sqlTypeOther, nullable: true, editable: true)
crash_year (type: esriFieldTypeString, alias: crash_year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
ESRI_OID (type: esriFieldTypeOID, alias: ESRI_OID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/6/2024 4:32:43 PM

Schema Last Edit Date: 12/6/2024 4:32:43 PM

Data Last Edit Date: 12/6/2024 4:32:43 PM

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