Name: Pedestrian Crash

Display Field: county_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: -7664320.5269
YMin: 5580825.3535
XMax: -7640306.4128
YMax: 5618320.1753
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,175,122,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":25,"labelingInfo":null}

HasZ: false

HasM: true

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• accident_date (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• accident_day_of_week (type: esriFieldTypeString, alias: Day of Week, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• accident_time (type: esriFieldTypeString, alias: Time of Crash, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• accident_year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• contrib_circ_env1_descr (type: esriFieldTypeString, alias: Contributing Circumstance Env 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• contrib_circ_env2_descr (type: esriFieldTypeString, alias: Contributing Circumstance Env 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• contrib_circ_road1_descr (type: esriFieldTypeString, alias: Contributing Circumstance Road 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• contrib_circ_road2_descr (type: esriFieldTypeString, alias: Contributing Circumstance Road 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• county_name (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• element_id (type: esriFieldTypeDouble, alias: Element ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• injury_count (type: esriFieldTypeDouble, alias: Number of Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• light_condition_descr (type: esriFieldTypeString, alias: Light Condition, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• location_type (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• loc_first_harmful_event_descr (type: esriFieldTypeString, alias: Location of First Harmful Event, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• no_of_a_inj (type: esriFieldTypeDouble, alias: Suspected Serious Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
• no_of_b_inj (type: esriFieldTypeDouble, alias: Suspected Minor Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
• no_of_c_inj (type: esriFieldTypeDouble, alias: Possible Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• no_of_k_inj (type: esriFieldTypeDouble, alias: Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• no_of_non_inj (type: esriFieldTypeDouble, alias: Property Damage only, SQL Type: sqlTypeOther, nullable: true, editable: true)
• node_id (type: esriFieldTypeDouble, alias: Node, SQL Type: sqlTypeOther, nullable: true, editable: true)
• reporting_agency_descr (type: esriFieldTypeString, alias: Reporting Agency Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• road_surf_cond_descr (type: esriFieldTypeString, alias: Road Surface Condition, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• road_grade_descr (type: esriFieldTypeString, alias: Road Grade, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• school_bus_related_descr (type: esriFieldTypeString, alias: School Bus Related, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• traffic_control_device_descr (type: esriFieldTypeString, alias: Traffic Control Device, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• type_of_crash_descr (type: esriFieldTypeString, alias: Type of Crash, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• type_of_location_descr (type: esriFieldTypeString, alias: Type of Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• weather_condition_descr (type: esriFieldTypeString, alias: Weather Condition, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• workzone_in_or_near_descr (type: esriFieldTypeString, alias: In or Near Work Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• workzone_location_descr (type: esriFieldTypeString, alias: Work Zone Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• workzone_type_descr (type: esriFieldTypeString, alias: Work Zone Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• workzone_workers_present_descr (type: esriFieldTypeString, alias: Work Zone Workers Present, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• workzone_police_present_descr (type: esriFieldTypeString, alias: Work Zone Police Present, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• primary_route_number (type: esriFieldTypeString, alias: Primary Route Number, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• report_number (type: esriFieldTypeString, alias: Report Number, SQL Type: sqlTypeOther, length: 25, 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)
• BICYCLE_YN (type: esriFieldTypeString, alias: Bicycle Y/N, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ACCIDENT_MONTH_NAME (type: esriFieldTypeString, alias: Accident Month, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• TOWN_NAME (type: esriFieldTypeString, alias: Townname, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• REGION_NAME (type: esriFieldTypeString, alias: DOT Region, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SPEED_LIMIT (type: esriFieldTypeDouble, alias: Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEDERAL_URBAN_GROUP_DESCR (type: esriFieldTypeString, alias: Federal Urban Group, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PRIMARY_ROUTE_MP (type: esriFieldTypeDouble, alias: Mile Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACCIDENT_HOUR (type: esriFieldTypeDouble, alias: Accident Hour, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INJURY_LEVEL (type: esriFieldTypeString, alias: Injury Level, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• TRF_CNTRL_DEV_OPRATIONL_DESCR (type: esriFieldTypeString, alias: Traffic Control Device, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FACTORED_AADT (type: esriFieldTypeDouble, alias: FAADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIORITY (type: esriFieldTypeDouble, alias: HCP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRIVER_ACTION1_UNIT1_DESCR (type: esriFieldTypeString, alias: Driver Action 1 Unit 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_ACTION2_UNIT1_DESCR (type: esriFieldTypeString, alias: Driver Action 2 Unit 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_ACTION1_UNIT2_DESCR (type: esriFieldTypeString, alias: Driver Action 1 Unit 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DRIVER_ACTION2_UNIT2_DESCR (type: esriFieldTypeString, alias: Driver Action 2 Unit 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATE_URBAN_RURAL_DESCR (type: esriFieldTypeString, alias: STATE_URBAN_RURAL_DESCR, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: PedCrash
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/1/2023 5:02:12 AM

Schema Last Edit Date: 3/1/2023 5:02:12 AM

Data Last Edit Date: 2/27/2023 8:01:13 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat