San Francisco Street-Use Permits Since 1996

San Francisco Public Works provides all street space permits received since 1996, including those approved, pending, closed, or withdrawn. The dataset is extracted from the agency's source system and transmitted via an automated pipeline. It is updated daily at 12am with a one-day lag.

Use Cases

• Track permit status and review progress based on the permit status field.
• Identify permits covering multiple streets or locations based on the permit_number field.
• Perform incremental data loading based on the data_as_of field.
• Analyze historical trends in street-use permits since 1996.

Strengths

• Historical coverage includes permits received since 1996.
• Daily updates at 12am with a one-day lag.
• Includes permits in all statuses: approved, pending, closed, or withdrawn.

Limitations

• Description metadata is limited; actual data quality requires manual inspection after download.
• Column-level documentation is absent; field semantics must be inferred after download.
• Some data fields from early system versions may not have been validated.

Provenance

Source

City of San Francisco

Collection Method

Extracted by SF Public Works from its source system and transmitted via an automated pipeline.

Time Range

Since 1996

Freshness

Updated daily at 12am with a one-day lag.

Geography

San Francisco