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.

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.

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

Unstructured text field with a detailed description of the work.

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

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.)

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

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

Weekday hours that a street closure will be in effect.

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

Start date of the street closure.

End date of the street closure.

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

The street that is closed.

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

The other street that serve as the terminus of the street closure.

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

Details if the street closure impacts a travel lane.

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

Details if the closure impacts parking associated with meters.

Details if the closure impacts parking associated with sidewalks.

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

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.

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

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.

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