About this Dataset

Parcels With Overlay Attributes

A. SUMMARY This dataset is derived from parcels and several other overlay administrative boundaries (listed below). The dataset was developed by DataSF as a convenience for matching parcels to districts where appropriate. This can be simpler than running a geospatial process every time you want to join parcels to a boundary. The districts provided here run along streets and are non-overlapping so that the parcels will be contained within a single district. The boundaries included are: 1. Analysis Neighborhoods 2. Supervisor Districts 3. Police Districts 4. Planning Districts B. HOW THE DATASET IS CREATED A script runs daily that overlays parcels with each of the boundaries to produce the composite dataset. C. UPDATE PROCESS Updated daily by a script based on the upstream parcels dataset which is also updated daily. D. HOW TO USE THIS DATASET You can use this dataset to match to administrative districts provided here to datasets that contain a parcel number. This can be a simpler process than running these joins spatially. In short, we pre-process the spatial overlays to make joins simpler and more performant.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:18.174332
Tags: boundaries, city-reference-data

Tables

Table 1

@usgov.city_of_san_francisco_parcels_with_overlay_attributes.table_1

8.02 MB
235687 rows
17 columns


CREATE TABLE table_1 (
  "parcel_number" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "planning_district" VARCHAR,
  "planning_district_number" DOUBLE,
  "police_district" VARCHAR,
  "police_company" VARCHAR,
  "the_geom" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);