sfgov/streetuse-permits-b6tj-gt35

  • banner
  • chairs
  • display
  • excavation
  • food
  • + 9

Street-Use Permits

Street-Use Permits

All street-use permits issued by SF Public Works whose status is active or approved and for Excavation and TempOcc permits: not past their end date.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
permit_addresspermit_addresspermit_addressTextaddress of permit
CurbRampWorkcurbrampworkcurbrampworkCheckboxindicates curb ramp installation/modification is involved
Location (zip)location_ziplocation_zipText
Location (city)location_citylocation_cityText
Location (state)location_statelocation_stateText
Location (address)location_addresslocation_addressText
cnncnncnnNumberCNN of location on which project occurs
XxxNumberCA State Plane III
permit_zipcodepermit_zipcodepermit_zipcodeNumberzipcode of permit location
LocationlocationlocationPointLocation formatted for mapping
Cross Street 1cross_street_1cross_street_1TextCross street 1
LongitudelongitudelongitudeNumberWGS84
StatusstatusstatusTextpermit status: active or approved
AgentagentagentTextName of person or company to which permit is issued
permit_end_datepermit_end_datepermit_end_dateCalendar datepermit end date
InspectorinspectorinspectorTextDPW inspector assigned to permit
Approved Dateapproved_dateapproved_dateCalendar datepermit approved date
Cross Street 2cross_street_2cross_street_2TextCross street 2
streetnamestreetnamestreetnameTextStreet name
Permit Purposepermit_purposepermit_purposeTexta description of the permit
permit_numberpermit_numberpermit_numberTextPermit Number
Permit Typepermit_typepermit_typeTextPermit type abbreviation
AgentPhoneagentphoneagentphoneTextphone number of agent
permit_start_datepermit_start_datepermit_start_dateCalendar datepermit start date
24/7 ContactcontactcontactText24/7 contact name / phone number
YyyNumberCA State Plane III
LatitudelatitudelatitudeNumberWGS84

Upstream Metadata