Skip to main content

Data Dictionary

Column Type Label Description
OBJECTID_1 numeric OBJECTID_1
objectid_2 numeric objectid_2
objectid numeric objectid
length numeric length
streetcl_i numeric streetcl_i
prefix text prefix
name text name
type text type
suffix text suffix
dir text dir
streetname text streetname
alternaten text alternaten
lleft numeric lleft
hleft numeric hleft
lrgt numeric lrgt
hrgt numeric hrgt
fromstreet text fromstreet
tostreet text tostreet
zipl text zipl
zipr text zipr
mcdl text mcdl
mcdr text mcdr
owner text owner
beltway text beltway
majorrd text majorrd
no_lanes numeric no_lanes
cfcc text cfcc
gdtlink text gdtlink
oneway text oneway
stcl_code numeric stcl_code
unique_id numeric unique_id
route_no text route_no
std_rng text std_rng
cltype text cltype
halfvac text halfvac
cen20lt text cen20lt
cen20rg text cen20rg
zone_left text zone_left
zone_right text zone_right
hood_left text hood_left
hood_right text hood_right
dpw_zon_lt numeric dpw_zon_lt
dpw_zon_rt numeric dpw_zon_rt
fire_zn_lt text fire_zn_lt
fire_zn_rt text fire_zn_rt
ward_lt numeric ward_lt
ward_rg numeric ward_rg
nh_l text nh_l
nh_r text nh_r
council_lt numeric council_lt
council_rt numeric council_rt
vote_dt_lt text vote_dt_lt
vote_dt_rt text vote_dt_rt
class text class
paveddate text paveddate
strtfromto text strtfromto
measurlgth numeric measurlgth
roadwidth numeric roadwidth
cdbg text cdbg
roadclass text roadclass
paveclass text paveclass
segpavclas text segpavclas
segname text segname
pghdb_sde_Pavement_len numeric pghdb_sde_Pavement_len
uniqueidse numeric uniqueidse
shape_leng numeric shape_leng
carteid numeric carteid
cen2010lt text cen2010lt
cen2010rg text cen2010rg
council201 text council201
council2_1 text council2_1
saltroute text saltroute
saltrte text saltrte
test numeric test
cwsaltrte text cwsaltrte
saltrtediv text saltrtediv
retired text retired
areasqft numeric areasqft
rsroadclas text rsroadclas
rsleft_not text rsleft_not
rsright_no text rsright_no
rsft_penal numeric rsft_penal
rstf_penal numeric rstf_penal
rsfromutur text rsfromutur
rstouturnr text rstouturnr
rsleftno_l numeric rsleftno_l
rsrightno_ numeric rsrightno_
rsclass text rsclass
created_user text created_user
created_date text created_date
last_edited_user text last_edited_user
last_edited_date text last_edited_date
sweep_left text sweep_left
sweep_right text sweep_right
estimatedoci numeric estimatedoci
olddpw_div_l numeric olddpw_div_l
olddpw_div_r numeric olddpw_div_r
bikelanetype1 text bikelanetype1
bikelanetype2 text bikelanetype2
bikelaneinstalled text bikelaneinstalled
speedlimit numeric speedlimit
num_lanes numeric num_lanes
class_snow text class_snow
snowresponse text snowresponse
replaced text replaced
truckroutes text truckroutes
route_type text route_type
route_num text route_num
roadclosure text roadclosure
roadclosure_fromdate text roadclosure_fromdate
roadclosure_todate text roadclosure_todate
update_es text update_es
update_sr text update_sr
update_addr text update_addr
domi_class text domi_class
GlobalID text GlobalID
future_pave_date text future_pave_date
paser_score numeric paser_score
Shape__Length numeric Shape__Length

Additional Information

Field Value
Data last updated October 30, 2026
Metadata last updated November 4, 2026
Created June 4, 2025
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Etl sha256b788f97574c3223e1e13472bf00e493d66827a69655d7d428bbe8a84b8e5c8ba
Has viewsTrue
Hash9218af1385b9f1bb56c244db82932328c2dd6a1d9fe7df043e53a1a316363e8c
Iddd13c2e7-4a83-40aa-a040-08a27385759b
Package id9ebd073b-f637-4f33-a7c2-619d23dd085a
Position3
PreviewTrue
Preview rows19,683
Size11.3 MiB
Stateactive
Total record count19,683
Tracking summary{'total': 0, 'recent': 0}
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, Liz Monk at monk.epitt.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, Liz Monk at monk.e@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.