SF Street Use Permits
Opened this issue · 1 comments
Definition: Street use permits issued by SF Public Works for sidewalk work, excavations, water breaks, etc.
Data Source: https://data.sfgov.org/City-Infrastructure/Street-Use-Permits/b6tj-gt35
ETL: [forthcoming]
Template: [Salutation] A new permit has been issued for [Permit Type], at [streetname] between [Cross Street 1] and [Cross Street 2], from [permit_start_date] to [permit_end_date].
Example: Hello! A new permit has been issued for Excavation, at GEARY BLVD between BAKER ST \ SAINT JOSEPHS AVE and LYON ST, from 10/07/2014 12:00:00 AM to 11/20/2014 12:00:00 AM.
Categories to filter for:
Emergency
Excavation
NightNoise
Sidewalk
TempOccup
For [permit_start_date] and [permit_end_date], it'd be great to filter out the 12:00:00 AM at the end.