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

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

16.97 MB
224016 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
);