San Francisco Addresses With Units - Enterprise Addressing System by US Government | Demographics and Population Studies

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

36.37 MB
387817 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
);