Skip to main content

Data Dictionary

Column Type Label Description
closure_id text Street closure ID

This is a unique identifier for each street closure. Each street closure is associated with a permit. closure_id is formed by joining permit_id and sequence_num, separated by a dash.
permit_id text Permit ID

This is a unique identifier for each permit. Permits may appear in the table multiple times since this table breaks permits down into the associated street closures.
permit_type text Permit type

The nature of the permit. These values are just a few words and are selected from a list of options.
work_description text

Description of services performed by company
work_type text Work type

A basic description of the work necessitating the permit. These values are just a few words and are selected from a list of options.
applicant_name text Applicant

The individual applying for the permit. This may be someone who is independent of an organization or a representative of the organization. In some cases, the organization itself is listed here as well. (This field contains several representations of who applied for the permit. Care should be taken when interpreting this information.)
contractor_name text Contractor

The business/entity performing the work on the permits (e.g., "People's Gas" or "John Doe's Construction").
special_instructions text Special instructions

Unstructured text field with unique information about the work to be performed. This field often has empty values.
weekday_hours text Weekday hours

Weekday hours that a street closure will be in effect.
weekend_hours text Weekend hours

Weekend hours that a street closure will be in effect. (Weekend and weekday operations often take place at different hours of the day.)
from_date date From date

Start date of the street closure.
to_date date To date

End date of the street closure.
active bool Is active

A boolean indicating whether the street closure is currently active (as of the last data update).
primary_street text Primary street

The street that is closed.
from_street text From street

The first of two streets that serve as the terminus of the street closure. from_street and to_street are almost always cross streets relative to primary_street
to_street text To street

The other street that serve as the terminus of the street closure.
full_closure bool Full closure

Details if the full street is closed or if some traffic is allowed in a subset of travel lanes.
travel_lane bool Is travel lane

Details if the street closure impacts a travel lane.
parking_lane bool Is parking lane

Details if the street closure impacts a parking lane. Both parking and travel lanes may be impacted by street closures.
metered_parking bool Is metered parking

Details if the closure impacts parking associated with meters.
sidewalk bool Is sidewalk

Details if the closure impacts parking associated with sidewalks.
segment_num int4 Segment number

Indicator of which street segment a record represents WITHIN ALL street segments contained in a permit. See dataset description for more information.
total_segments int4 Total segments

The total number of segments that are contained within a street closure permit. Used in conjuction with segment_num, as an example, one can surmise that a given record is (for example) "segment number 3 out of 7" for a given permit. This field can be used in isolation to determine how many times a street closure is divided into component segments.
roadway_id text Roadway ID

A GIS line segment representing a section of roadway. This value is useful for mapping street closures.
geometry text Geometry

Lat/Long for vertices of a roadway line segment. These values represent a single segment of roadway (see general notes). The first and last coordinates are the endpoints of the segment. If there are additional coordinate pairs, which is usually the case, they represent vertices where two lines meet. This can be interpreted as a change in the trajectory of the roadway segment.
wkt text Geometry in Well-Known Text

This is a different standardized format for the geometry field (representing the line section of roadway labelled by the cartegraph_id field).

Additional Information

Field Value
Data last updated 14 August 2025
Metadata last updated 14 August 2025
Created 25 May 2023
Format CSV
License Creative Commons Attribution
Dataspatial activeTrue
Dataspatial last geom updated5 months ago
Dataspatial statusactive
Dataspatial wkt fieldwkt
Datastore activeTrue
Has viewsTrue
Ida9a1d93a-9d3b-4c18-bd80-82ed6f86404a
Package id9be8e626-504e-44b8-a28a-ed52e8d70e3a
Position0
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.