sfgov/utility-excavation-moratorium-streets-5wbp-dwzt

  • excavation
  • five
  • moratorium
  • paving
  • permits
  • + 3

Utility Excavation Moratorium Streets

Utility Excavation Moratorium Streets

Street segments and intersections that have been paved within the last 5 years

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Location (city)location_citylocation_cityText
Location (address)location_addresslocation_addressText
Neighborhoods:@computed_region_jwn9_ihcz:@computed_region_jwn9_ihczNumberThis column was automatically created in order to record in what polygon from the dataset 'Neighborhoods' (jwn9-ihcz) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
SF Find Neighborhoods:@computed_region_6qbp_sg9q:@computed_region_6qbp_sg9qNumberThis column was automatically created in order to record in what polygon from the dataset 'SF Find Neighborhoods' (6qbp-sg9q) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Current Police Districts:@computed_region_qgnn_b9vv:@computed_region_qgnn_b9vvNumberThis column was automatically created in order to record in what polygon from the dataset 'Current Police Districts' (qgnn-b9vv) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Current Supervisor Districts:@computed_region_26cr_cadq:@computed_region_26cr_cadqNumberThis column was automatically created in order to record in what polygon from the dataset 'Current Supervisor Districts' (26cr-cadq) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Analysis Neighborhoods:@computed_region_ajp5_b2md:@computed_region_ajp5_b2mdNumberThis column was automatically created in order to record in what polygon from the dataset 'Analysis Neighborhoods' (ajp5-b2md) the point in column 'point' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Location (state)location_statelocation_stateText
LocationlocationlocationPointLocation formatted for mapping
XxxNumberCA State Plane III
ModifiedDatemodifieddatemodifieddateCalendar datedate record was added or modified
EffectiveDateeffectivedateeffectivedateCalendar dateDate Location was paved
pointpointpointPoint
ExpirationDateexpirationdateexpirationdateCalendar dateEnd of utility excavtion moratorium for location
LimitslimitslimitsTextA description of location combining from_st, to_st, cardinal and addrange
CNNcnncnnNumberCNN of street segment or intersection
StreetnamestreetnamestreetnameTextStreet name
JobOrderNumjobordernumjobordernumTextJob Order Number - a code for funding - under which street was paved
LongitudelongitudelongitudeNumberWGS84
LatitudelatitudelatitudeNumberWGS84
YyyNumberCA State Plane III
IDididNumberUnique ID
Location (zip)location_ziplocation_zipText

Upstream Metadata