About this Dataset

San Francisco Addresses With Units - Enterprise Addressing System

SUMMARY All active addresses from the City's Enterprise Addressing System (EAS), including sub-addresses, such as units. Includes references to parcel and street centerline data (Note: not all addresses are associated with parcels). Updated nightly. For base addresses (not including units) see the Addresses - Enterprise Address System dataset. HOW THE DATASET IS CREATED This dataset is an extract from the Enterprise Addressing System, maintained by San Francisco's Department of Technology. UPDATE PROCESS This dataset updates nightly. RELATED DATASETS

the Addresses - Enterprise Address System dataset
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:51.990614
Tags: addresses, city-reference-data, dbi, eas, ref-basemap, unit

Tables

Table 1

@usgov.city_of_san_francisco_addresses_with_units_enterprise__35e0c3d6.table_1

38.14 MB
387,817 rows
34 columns

CREATE TABLE table_1 (
  "eas_fullid" VARCHAR,
  "eas_baseid" BIGINT,
  "address_number" BIGINT,
  "address_number_suffix" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "street_full_name" VARCHAR,
  "cnn" BIGINT,
  "eas_subid" BIGINT,
  "unit_number" VARCHAR,
  "parcel_number" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "zip_code" BIGINT,
  "address" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "point" VARCHAR,
  "supdist" VARCHAR,
  "numbertext" VARCHAR,
  "supervisor" BIGINT,
  "supdistpad" BIGINT,
  "supname" VARCHAR,
  "nhood" VARCHAR,
  "complete_landmark_name" VARCHAR,
  "landmark_aliases" VARCHAR,
  "direct_source" VARCHAR,
  "data_as_of" VARCHAR,
  "data_updated_at" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE
);