Layers:

Layer: COLLISION_CRASH_2007_2017 (0)


Name: COLLISION_CRASH_2007_2017

Display Field: COUNTY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The City of Philadelphia has migrated metadata for this data set to the City-wide Metadata Catalog. For any questions about the migration and administration of the Metadata Catalog, please contact maps@phila.gov. To view the metadata for this layer, please visit: https://metadata.phila.gov/#home/datasetdetails/5543865420583086178c4eba/representationdetails/5c410c6431621f086214c7cd/

Copyright Text:

Min. Scale: 17934.4900123716

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8380153.53084138
YMin: 4847997.28694719
XMax: -8344230.73112847
YMax: 4885972.69124295
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[243,198,19,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}}},"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)
• crn (type: esriFieldTypeInteger, alias: CRN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• district (type: esriFieldTypeInteger, alias: DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• county (type: esriFieldTypeInteger, alias: COUNTY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• municipality (type: esriFieldTypeInteger, alias: MUNICIPALITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_year (type: esriFieldTypeInteger, alias: CRASH_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_month (type: esriFieldTypeInteger, alias: CRASH_MONTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• day_of_week (type: esriFieldTypeInteger, alias: DAY_OF_WEEK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• time_of_day (type: esriFieldTypeInteger, alias: TIME_OF_DAY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hour_of_day (type: esriFieldTypeInteger, alias: HOUR_OF_DAY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• illumination (type: esriFieldTypeInteger, alias: ILLUMINATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• weather (type: esriFieldTypeInteger, alias: WEATHER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• road_condition (type: esriFieldTypeInteger, alias: ROAD_CONDITION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• collision_type (type: esriFieldTypeInteger, alias: COLLISION_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• relation_to_road (type: esriFieldTypeInteger, alias: RELATION_TO_ROAD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• work_zone_type (type: esriFieldTypeString, alias: WORK_ZONE_TYPE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• work_zone_loc (type: esriFieldTypeString, alias: WORK_ZONE_LOC, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• work_zone_ind (type: esriFieldTypeString, alias: WORK_ZONE_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• intersect_type (type: esriFieldTypeInteger, alias: INTERSECT_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tcd_type (type: esriFieldTypeInteger, alias: TCD_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• location_type (type: esriFieldTypeInteger, alias: LOCATION_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• urban_rural (type: esriFieldTypeInteger, alias: URBAN_RURAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fatal_count (type: esriFieldTypeInteger, alias: FATAL_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• injury_count (type: esriFieldTypeInteger, alias: INJURY_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• person_count (type: esriFieldTypeInteger, alias: PERSON_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_units (type: esriFieldTypeInteger, alias: TOTAL_UNITS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sch_bus_ind (type: esriFieldTypeString, alias: SCH_BUS_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• sch_zone_ind (type: esriFieldTypeString, alias: SCH_ZONE_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• latitude (type: esriFieldTypeString, alias: LATITUDE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• longitude (type: esriFieldTypeString, alias: LONGITUDE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• arrival_tm (type: esriFieldTypeInteger, alias: ARRIVAL_TM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cons_zone_spd_lim (type: esriFieldTypeString, alias: CONS_ZONE_SPD_LIM, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• dispatch_tm (type: esriFieldTypeInteger, alias: DISPATCH_TM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• est_hrs_closed (type: esriFieldTypeString, alias: EST_HRS_CLOSED, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• lane_closed (type: esriFieldTypeInteger, alias: LANE_CLOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ln_close_dir (type: esriFieldTypeString, alias: LN_CLOSE_DIR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ntfy_hiwy_maint (type: esriFieldTypeString, alias: NTFY_HIWY_MAINT, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• spec_juris_cd (type: esriFieldTypeString, alias: SPEC_JURIS_CD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• tcd_func_cd (type: esriFieldTypeInteger, alias: TCD_FUNC_CD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tfc_detour_ind (type: esriFieldTypeString, alias: TFC_DETOUR_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• workers_pres (type: esriFieldTypeString, alias: WORKERS_PRES, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_close_detour (type: esriFieldTypeString, alias: WZ_CLOSE_DETOUR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_flagger (type: esriFieldTypeString, alias: WZ_FLAGGER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_law_offcr_ind (type: esriFieldTypeString, alias: WZ_LAW_OFFCR_IND, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_ln_closure (type: esriFieldTypeString, alias: WZ_LN_CLOSURE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_moving (type: esriFieldTypeString, alias: WZ_MOVING, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_other (type: esriFieldTypeString, alias: WZ_OTHER, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• wz_shlder_mdn (type: esriFieldTypeString, alias: WZ_SHLDER_MDN, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• vehicle_count (type: esriFieldTypeInteger, alias: VEHICLE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• automobile_count (type: esriFieldTypeInteger, alias: AUTOMOBILE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• motorcycle_count (type: esriFieldTypeInteger, alias: MOTORCYCLE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bus_count (type: esriFieldTypeInteger, alias: BUS_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• small_truck_count (type: esriFieldTypeInteger, alias: SMALL_TRUCK_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• heavy_truck_count (type: esriFieldTypeInteger, alias: HEAVY_TRUCK_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• suv_count (type: esriFieldTypeInteger, alias: SUV_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• van_count (type: esriFieldTypeInteger, alias: VAN_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bicycle_count (type: esriFieldTypeInteger, alias: BICYCLE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maj_inj_count (type: esriFieldTypeInteger, alias: MAJ_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mod_inj_count (type: esriFieldTypeInteger, alias: MOD_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• min_inj_count (type: esriFieldTypeInteger, alias: MIN_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tot_inj_count (type: esriFieldTypeInteger, alias: TOT_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unk_inj_deg_count (type: esriFieldTypeInteger, alias: UNK_INJ_DEG_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unk_inj_per_count (type: esriFieldTypeInteger, alias: UNK_INJ_PER_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_16yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_16YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_17yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_17YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_18yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_18YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_19yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_19YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_20yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_20YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_50_64yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_50_64YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_65_74yr (type: esriFieldTypeInteger, alias: DRIVER_COUNT_65_74YR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_count_75plus (type: esriFieldTypeInteger, alias: DRIVER_COUNT_75PLUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unbelted_occ_count (type: esriFieldTypeInteger, alias: UNBELTED_OCC_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unb_death_count (type: esriFieldTypeInteger, alias: UNB_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unb_maj_inj_count (type: esriFieldTypeInteger, alias: UNB_MAJ_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• belted_death_count (type: esriFieldTypeInteger, alias: BELTED_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• belted_maj_inj_count (type: esriFieldTypeInteger, alias: BELTED_MAJ_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mcycle_death_count (type: esriFieldTypeInteger, alias: MCYCLE_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mcycle_maj_inj_count (type: esriFieldTypeInteger, alias: MCYCLE_MAJ_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bicycle_death_count (type: esriFieldTypeInteger, alias: BICYCLE_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bicycle_maj_inj_count (type: esriFieldTypeInteger, alias: BICYCLE_MAJ_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_count (type: esriFieldTypeInteger, alias: PED_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_death_count (type: esriFieldTypeInteger, alias: PED_DEATH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ped_maj_inj_count (type: esriFieldTypeInteger, alias: PED_MAJ_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• max_severity_level (type: esriFieldTypeInteger, alias: MAX_SEVERITY_LEVEL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comm_veh_count (type: esriFieldTypeInteger, alias: COMM_VEH_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dec_lat (type: esriFieldTypeDouble, alias: DEC_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dec_long (type: esriFieldTypeDouble, alias: DEC_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rdwy_surf_type_cd (type: esriFieldTypeString, alias: RDWY_SURF_TYPE_CD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• county_name (type: esriFieldTypeString, alias: COUNTY_NAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)

Templates:

Name: COLLISION_CRASH_2007_2017
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/7/2025 8:47:53 PM

Schema Last Edit Date: 5/7/2025 8:47:53 PM

Data Last Edit Date: 5/7/2025 8:47:53 PM