sfgov/large-utility-excavation-permits-i926-ujnc

  • excavation
  • large
  • paving
  • permits
  • plan
  • + 3

Large Utility Excavation Permits

Large Utility Excavation Permits

Large excavation permits issued by SF Public Works that are currently active or approved plus permits whose end date passed within the last year. This is a special data set created for the Dig Once Program. Large excavation permits are 1000 square feet in size or larger.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Permit_Statuspermit_statuspermit_statusTextstatus of permit
LocationlocationlocationPointLocation formatted for mapping
Location (address)location_addresslocation_addressText
Permit_Purposepermit_purposepermit_purposeTextDescription of permit
Permit_Renewed_From_Permit_Numberpermit_renewed_from_permit_numberpermit_renewed_from_permit_numberTextPermit number the particular permit was renewed from
latitudelatitudelatitudeNumberWGS84
Permit_Start_Datepermit_start_datepermit_start_dateCalendar datestart date of permit
XxxNumberCA State Plane III
Location (state)location_statelocation_stateText
Cross_Street_2cross_street_2cross_street_2TextCross street 2
Location (city)location_citylocation_cityText
cnncnncnnNumberCNN of street segment or intersection
Location (zip)location_ziplocation_zipText
AgentagentagentTextName of company to which permit is issued
Permit_End_Datepermit_end_datepermit_end_dateCalendar dateend date of permit
Street_Namestreet_namestreet_nameTextStreet name
Permit_Reasonpermit_reasonpermit_reasonTexttype of work to be done on utility
Permit_Numberpermit_numberpermit_numberTextPermit number
longitudelongitudelongitudeNumberWGS84
YyyNumberCA State Plane III
Cross_Street_1cross_street_1cross_street_1TextCross street 1

Upstream Metadata