Skip to main content

Kamus Data

Kolom Tipe Label Deskripsi
CRASH_CRN float8
DISTRICT float8
CRASH_COUNTY float8
MUNICIPALITY float8
POLICE_AGCY text
CRASH_YEAR float8
CRASH_MONTH float8
DAY_OF_WEEK float8
TIME_OF_DAY float8
HOUR_OF_DAY float8
ILLUMINATION float8 Code that defines lighting at crash scene

1 – Daylight 2 – Dark – no street lights 3 – Dark – street lights 4 – Dusk 5 – Dawn 6 – Dark – unknown roadway lighting 8 – Other 9 – Unknown (expired)
WEATHER float8 Code for the weather type at time of crash

1 – No adverse conditions 2 – Rain 3 – Sleet (hail) 4 – Snow 5 – Fog
ROAD_CONDITION float8 Roadway Surface Condition Code

0 – Dry 1 – Wet 2 – Sand/ mud/ dirt/ oil/ or gravel 3 – Snow covered 4 – Slush 5 – Ice 6 – Ice Patches 7 – Water – standing or moving 8 – Other 9 – Unknown (expired)
COLLISION_TYPE float8 Collision category that defines the crash

0 – Non collision 1 – Rear-end 2 – Head-on 3 – Rear-to-rear (Backing) 4 – Angle 5 – Sideswipe (same dir.) 6 – Sideswipe (Opposite dir.) 7 – Hit fixed object 8 – Hit pedestrian 9 – Other or Unknown
RELATION_TO_ROAD float8 Code for the crash’s relativity to the road

1 – On roadway 2 – Shoulder 3 – Median 4 – Roadside (off trafficway; on vehicle area) 5 – Outside trafficway (in area not meant for vehicles) 6 – In parking lane 7 – Gore (intersection of ramp and highway) 9 – Unknown
INTERSECT_TYPE float8 Code that defines the Intersection Type

00 – Mid-block 01 – Four way intersection 02 – “T” intersection 03 – “Y” intersection 04 – Traffic circle or Round About 05 – Multi-leg intersection 06 – On ramp 07 – Off ramp 08 – Crossover 09 – Railroad crossing 10 – Other 99 – Unknown (expired)
TCD_TYPE float8 Traffic Control Device Type Code

Code that defines the Traffic Control Device 0 - Not applicable 1 - Flashing traffic signal 2 - Traffic signal 3 - Stop sign 4 - Yield sign 5 - Active RR crossing controls 6 - Passive RR crossing controls 7 - Police officer or flagman 8 - Other Type TCD 9 - Unknown
URBAN_RURAL float8 Code to classify crash as Urban or Rural

1 – RURAL 2 – SMALL URBAN AREA (pop. To 49,999) 3 – URBANIZED AREA (pop. 50,000 to 199,999) 4 – URBANIZED AREA (pop. 200,000 or more)
LOCATION_TYPE float8 Code that defines the crash location

0 – Not applicable 1 – Underpass 2 – Ramp 3 – Bridge 4 – Tunnel 5 – Toll Booth 6 – Cross over related 7 – Driveway or Parking Lot 8 – Ramp and bridge 9 – Unknown
SCH_BUS_IND text
SCH_ZONE_IND text
TOTAL_UNITS float8
PERSON_COUNT float8
VEHICLE_COUNT float8
AUTOMOBILE_COUNT float8
MOTORCYCLE_COUNT float8
BUS_COUNT float8
SMALL_TRUCK_COUNT float8
HEAVY_TRUCK_COUNT float8
SUV_COUNT float8
VAN_COUNT float8
BICYCLE_COUNT float8
FATAL_COUNT float8
INJURY_COUNT float8
MAJ_INJ_COUNT float8
MOD_INJ_COUNT float8
MIN_INJ_COUNT float8
UNK_INJ_DEG_COUNT float8
UNK_INJ_PER_COUNT float8
UNBELTED_OCC_COUNT float8
UNB_DEATH_COUNT float8
UNB_MAJ_INJ_COUNT float8
BELTED_DEATH_COUNT float8
BELTED_MAJ_INJ_COUNT float8
MCYCLE_DEATH_COUNT float8
MCYCLE_MAJ_INJ_COUNT float8
BICYCLE_DEATH_COUNT float8
BICYCLE_MAJ_INJ_COUNT float8
PED_COUNT float8
PED_DEATH_COUNT float8
PED_MAJ_INJ_COUNT float8
COMM_VEH_COUNT float8
MAX_SEVERITY_LEVEL float8
DRIVER_COUNT_16YR float8
DRIVER_COUNT_17YR float8
DRIVER_COUNT_18YR float8
DRIVER_COUNT_19YR float8
DRIVER_COUNT_20YR float8
DRIVER_COUNT_50_64YR float8
DRIVER_COUNT_65_74YR float8
DRIVER_COUNT_75PLUS float8
LATITUDE text
LONGITUDE text
DEC_LAT float8
DEC_LONG float8
EST_HRS_CLOSED float8
LANE_CLOSED float8
LN_CLOSE_DIR float8 Direction of traffic in closed lane (s)

1 – North 2 – South 3 – East 4 – West 5 – North And South 6 – East and West 7 – All (N,S,E,W)
NTFY_HIWY_MAINT text
RDWY_SURF_TYPE_CD float8 Code for the Roadway surface type

1 - Concrete 2 - Blacktop 3 - Brick or Block 4 - Slag, Gravel, or Stone 5 - Dirt 8 - Other 9 - Unknown
SPEC_JURIS_CD float8 Special Jurisdiction Code

0 – No Special Jurisdiction 1 – National Park 2 – Military 3 – Indian Reservation 4 – College/University Campus 5 – Other Federal Sites 8 - Other 9 – Unknown
TCD_FUNC_CD float8 Code for Traffic Control Device state

0 – No Controls 1 – Device not Functioning 2 – Device Functioning improperly 3 – Device Functioning properly 4 – Emergency Preemptive Signal 9 – Unknown
TFC_DETOUR_IND text
WORK_ZONE_IND text
WORK_ZONE_TYPE float8
WORK_ZONE_LOC float8
CONS_ZONE_SPD_LIM float8
WORKERS_PRES text
WZ_CLOSE_DETOUR text
WZ_FLAGGER text
WZ_LAW_OFFCR_IND text
WZ_LN_CLOSURE text
WZ_MOVING text
WZ_OTHER text
WZ_SHLDER_MDN text
FLAG_CRN float8
INTERSTATE float8
STATE_ROAD float8
LOCAL_ROAD float8
LOCAL_ROAD_ONLY float8
TURNPIKE float8
WET_ROAD float8
SNOW_SLUSH_ROAD float8
ICY_ROAD float8
SUDDEN_DEER float8
SHLDR_RELATED float8
REAR_END float8
HO_OPPDIR_SDSWP float8
HIT_FIXED_OBJECT float8
SV_RUN_OFF_RD float8
WORK_ZONE float8
PROPERTY_DAMAGE_ONLY float8
FATAL_OR_MAJ_INJ float8
INJURY float8
FATAL float8
NON_INTERSECTION float8
INTERSECTION float8
SIGNALIZED_INT float8
STOP_CONTROLLED_INT float8
UNSIGNALIZED_INT float8
SCHOOL_BUS float8
SCHOOL_ZONE float8
HIT_DEER float8
HIT_TREE_SHRUB float8
HIT_EMBANKMENT float8
HIT_POLE float8
HIT_GDRAIL float8
HIT_GDRAIL_END float8
HIT_BARRIER float8
HIT_BRIDGE float8
OVERTURNED float8
MOTORCYCLE float8
BICYCLE float8
HVY_TRUCK_RELATED float8
VEHICLE_FAILURE float8
TRAIN_TROLLEY float8
PHANTOM_VEHICLE float8
ALCOHOL_RELATED float8
DRINKING_DRIVER float8
UNDERAGE_DRNK_DRV float8
UNLICENSED float8
CELL_PHONE float8
NO_CLEARANCE float8
RUNNING_RED_LT float8
TAILGATING float8
CROSS_MEDIAN float8
CURVE_DVR_ERROR float8
LIMIT_65MPH float8
SPEEDING float8
SPEEDING_RELATED float8
AGGRESSIVE_DRIVING float8
FATIGUE_ASLEEP float8
DRIVER_16YR float8
DRIVER_17YR float8
DRIVER_65_74YR float8
DRIVER_75PLUS float8
UNBELTED float8
PEDESTRIAN float8
DISTRACTED float8
CURVED_ROAD float8
DRIVER_18YR float8
DRIVER_19YR float8
DRIVER_20YR float8
DRIVER_50_64YR float8
VEHICLE_TOWED float8
FIRE_IN_VEHICLE float8
HIT_PARKED_VEHICLE float8
MC_DRINKING_DRIVER float8
DRUGGED_DRIVER float8
INJURY_OR_FATAL float8
COMM_VEHICLE float8
IMPAIRED_DRIVER float8
DEER_RELATED float8
DRUG_RELATED float8
HAZARDOUS_TRUCK float8
ILLEGAL_DRUG_RELATED float8
ILLUMINATION_DARK float8
MINOR_INJURY float8
MODERATE_INJURY float8
MAJOR_INJURY float8
NHTSA_AGG_DRIVING float8
PSP_REPORTED float8
RUNNING_STOP_SIGN float8
TRAIN float8
TROLLEY float8
ROADWAY_CRN float8
RDWY_SEQ_NUM float8
ADJ_RDWY_SEQ float8
ACCESS_CTRL float8
ROADWAY_COUNTY float8
LANE_COUNT float8
RDWY_ORIENT text
ROAD_OWNER float8

1 - Interstate - non turnpike 2 - State highway 3 - County road 4 - Local road or street 5 - East-West portion of turnpike 6 - Turnpike spur (extension) 7 - Private Road 9 - Other or Unknown
ROUTE text
SPEED_LIMIT float8
SEGMENT float8
OFFSET float8
STREET_NAME text

Informasi Tambahan

Field Nilai
Data last updated 1 September 2016
Metadata last updated 21 Mei 2023
Dibuat 17 Agustus 2016
Format CSV
Lisensi Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Id6a7016bd-f98c-4bed-b646-a416d60ad766
Mimetypetext/csv
Package idf0f9d2cf-ecd1-4d6b-9291-78707af92b3c
Position1
Revision id3a25ee84-d939-463d-b044-cc378fbbf90d
Stateactive
Url typedatapusher

Data Use Agreement

You must agree to the terms below to access the site.

Terms of use

The Western Pennsylvania Regional Data Center (WPRDC) is a project led by the University Center of Social and Urban Research (UCSUR) at the University of Pittsburgh ("University") in collaboration with City of Pittsburgh and The County of Allegheny in Pennsylvania. The WPRDC and the WPRDC Project is supported by a grant from the Richard King Mellon Foundation.

This Data Use Agreement covers the terms and conditions that you must agree to before you access or use the Data on deposit with the WPRDC. By using the data available on the WPRDC website portal, you agree to the terms and conditions of your access to the WPRDC and your use of the Data on deposit with the WPRDC.

Intending to be legally bound, you agree to the following:

  1. Effective Date: The effective date of the Agreement is the date of your signature or click through acceptance of these terms, and the terms shall continue to bind you with every subsequent attempt to access or use Data from the WPRDC.
  2. Definitions: "Data" for purposes of this Agreement, shall mean all information of varying formats which has been deposited with the WPRDC by The City, The County, and other third parties, to make such information available for public access. Data may cover, but is not limited to topics including property ownership, budgets, transportation, education, public safety, public services, and geographic information. Data may consist of, but is not limited to administrative records created by government or other organizations, statistical information designed to improve the function of government and organizations, and information created about government and organizations. The Data on deposit with the WPRDC is not intended to and should not contain Non-Public Information, as defined below.
  3. "Non-Public Information" for the purposes of this Agreement shall mean information that may not be disclosed to the public for the following reasons: The information is exempt from disclosure or the information is prohibited from being disclosed under State and Federal Laws and regulations including the Pennsylvania Right to Know Act, 65 P.S § 67.101 et seq., the Criminal History Record Information Act, 18 Pa.C.S. §§ 9101-9183, the Health Insurance Portability and Accountability Act (HIPAA), and other applicable privacy laws; The information is covered by a contractual non-disclosure obligation; The information is covered by confidentiality and fiduciary obligations; or The information is private, proprietary or privileged. "User" shall mean any individual who seeks access to or uses WPRDC Data. "Third Party Links" shall mean any website links to other data and data resources provided by the WPRDC portal/website.
  4. Grant of Access and Use of WPRDC Data: Subject to the compliance with the User Terms and Conditions set forth below, UCSUR hereby grants User permission to access and use the Data from the WPRDC pursuant to the license terms, restrictions, or designations placed upon the Data by the Data owner and depositor. This grant shall not include permission to use Non-Public Information which is inadvertently deposited in the WPRDC.
  5. User Terms and Conditions:

    The User is subject to the following terms and conditions with respect to the User's access and use of WPRDC Data.

    1. User shall accept complete responsibility for its access to and use of the Data derived from the WPRDC, or any derivatives User makes of the Data.
    2. User shall abide by the licensing terms if provided by the data owner and WPRDC as publisher.
    3. User shall abide by the terms and conditions of any Third Party Links when accessing data from the WPRDC through such Third Party Links.
    4. User agrees to immediately notify the WPRDC Project Manager, Robert Gradeck, at 412-624-9177 or via email at rmg44@pitt.edu when Non-Public Information is suspected or discovered through User access to the WPRDC. User agrees to refrain from use of any Non-Public Information inadvertently on deposit and accessible from the WPRDC.
    5. User understands that UCSUR may, on its own and without notice, remove Data and Third Party Data Links from the WPRDC.
    6. User understands and agrees that there is no obligation for UCSUR to update or provide customized Data under this Agreement.
    7. User shall comply with all Federal, State, and local laws and regulations governing regarding use of the Data and Third Party Data Links.
    8. User shall provide feedback, questions, concerns, or comments regarding access or use of Data on deposit with the WPRDC by contacting the WPRDC Project Manager, Robert Gradeck, at 412-624-9177 or rmg44@pitt.edu.
  6. Ownership of Data: Ownership of the Data in the WPRDC and through Third Party Links shall remain and belong to the person or party that created it and/or deposited it in the WPRDC. Nothing in this Agreement shall be construed as a transfer or assignment of ownership of any data, copyrights, or other intellectual property.
  7. Disclaimers/No Warranties/As Is and As Available: DISCLAIMER. THE UNIVERSITY, THE CITY, AND THE COUNTY OF ALLEGHENY HEREBY DISCLAIM ALL IMPLIED AND EXPRESS WARRANTIES OF ANY KIND WITH REGARD TO DATA MADE AVAILABLE IN THE WPRDC AND ACCESSED BY USER THROUGH THE WPRDC, INCLUDING, BUT NOT LIMITED TO, THE WARRANTIES OF MERCHANTABILITY AND OF FITNESS FOR ANY PARTICULAR PURPOSE SPECIFIC PURPOSE. THE UNIVERSITY DOES NOT WARRANT THE COMPLETENESS OR ACCURACY OF THE DATA MADE AVAILABLE THROUGH THE WPRDC. USER HEREBY ACKNOWLEDGES AND ACCEPTS THE ABOVE DISCLAIMERS AND USES ALL OF THE DATA IN THE WPRDC AT ITS OWN RISK AND ON AN "AS IS" AND "AS AVAILABLE" BASIS.
  8. Indemnification: User agrees to indemnify, release, and hold harmless the University of Pittsburgh, UCSUR, The City of Pittsburgh, and The County of Allegheny, to include its elected officials, officers, appointees, employees and agents, from any and all liability for claims arising out of my access to and/or use of Data made available through the WPRDC.
  9. Assignability: User agrees that this Agreement may not be assigned by User. This Agreement may be assigned at any time by University without prior notice to Licensee.
  10. Governing Law, Jurisdiction, and Venue: User agrees that this Agreement shall be construed and enforced according to the laws of the Commonwealth of Pennsylvania and the sole jurisdiction and venue for the resolution of any dispute arising from or relating to the Agreement shall be the state and federal courts located within the County of Allegheny, Pennsylvania.

Through clicking the button below, the User represents that they are over the age of 18 and understands and agrees to the terms and conditions set forth above.