About this Dataset

San Francisco Addresses - Enterprise Addressing System

SUMMARY Active base addresses from San Francisco's Enterprise Addressing System (EAS). This dataset does not include sub-addresses, such as units, and does not include a block/lot value for each record. For units and block/lot values, see the Addresses with Units - Enterprise Addressing 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

Addresses with Units - Enterprise Addressing System
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:07.397343
Tags: addresses, city-reference-data, dbi, eas, ref-basemap

Tables

Table 1

@usgov.city_of_san_francisco_addresses_enterprise_addressing_system.table_1

17.8 MB
224,016 rows
29 columns

CREATE TABLE table_1 (
  "eas_baseid" BIGINT,
  "address_number" BIGINT,
  "address_number_suffix" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "cnn" BIGINT,
  "street_full_name" VARCHAR,
  "parcel_number" 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
);