Readme
Updated 4 days ago
‧ Indexed 3 hours ago
Sign Permits
List of sign permit applications for displaying outdoor signs in Cambridge.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Address (zip) | geocoded_column_zip | geocoded_column_zip | Text | |
| Cost | cost | cost | Number | Cost of the sign. |
| Address (city) | geocoded_column_city | geocoded_column_city | Text | |
| Address (state) | geocoded_column_state | geocoded_column_state | Text | |
| Police Neighborhood Regions | :@computed_region_guic_hr4a | :@computed_region_guic_hr4a | Number | |
| Census Blocks 2010 | :@computed_region_e4yd_rwk4 | :@computed_region_e4yd_rwk4 | Number | |
| cambridge_neighborhoods | :@computed_region_rffn_qbt6 | :@computed_region_rffn_qbt6 | Number | |
| BZA | bza | bza | Text | Sign requires a variance from the Board of Zoning Appeal |
| Description | description | description | Text | Description of the work necessary to place the sign. |
| Existing Signs | existing_signs | existing_signs | Text | Any existing signs that will remain on site. |
| Expiration Date | expiration_date | expiration_date | Calendar date | The expiration date of the sign permit. |
| License Number | license_number | license_number | Text | |
| Issue Date | issue_date | issue_date | Calendar date | The date that the Inspectional Services Department issued the sign permit. |
| Longitude | longitude | longitude | Number | |
| Address (address) | geocoded_column_address | geocoded_column_address | Text | |
| Submission Date | submission_date | submission_date | Calendar date | Application submission date. |
| Status | status | status | Text | Application status |
| Latitude | latitude | latitude | Number | |
| cambridge_cdd_zoning | :@computed_region_swkg_bavi | :@computed_region_swkg_bavi | Number | |
| Police Response Districts | :@computed_region_v7jj_366k | :@computed_region_v7jj_366k | Number | |
| Address | geocoded_column | geocoded_column | Point | Location of the sign |
| Public Way | public_way | public_way | Text | Will one or more of the proposed signs extend six (6) inches into the public sidewalk? |
| ID | id | id | Number | Permit ID. |
Upstream Metadata