Addresses - Flat
Introduction
We have worked with the San Francisco Fire Department and other agencies to provide a set of flattened data products. Flattening just means that we provide a single table representation of what is actually multiple tables in a relational database. In this case we are joining four tables in EAS. You can see the data model here. The flattening is accomplished using this database view.
Availability
The flattened data products are refreshed from our production system every weekday.
These data are available in the following locations
Comma Separated Value File (CSV)
A CSV file is available on our secure FTP server. If you want access to this file please let us know and we'll provide you with the credentials. The path is: /SFGISRO/Data/EAS/eas_flat_file_export.zip. The zip file size is about 6 MB; unzipped it is about 35 MB. An example of the data is here.
ESRI SDE
A table is available on the SFGIS ArcSDE server. If you want access to this file please let us know and we'll provide you with the credentials. The name of the table is eas_addresses_flat_export.
ESRI Shapefile
We also export these data to the public via Socrata. The URLs for these datasets are:
- https://data.sfgov.org/Geography/Addresses-Enteprise-Addressing-System/pf3h-w4up
- https://data.sfgov.org/Facilities-and-Structures/Addresses-with-Units-Enterprise-Addressing-System-/kvej-w5kb
Business Contacts
| contact | dept | context |
|---|---|---|
| Jesus Mora | SFFD | |
| Michelle Malick | SFFD | |
| Derek Entwhistle | SFFD | |
| Mike Wynn | Planning | Accela |
| Alton Chin | Planning | Accela |
Data Model
The file structure is as follows:
| available in version | column name | data type | description |
|---|---|---|---|
eas_address_base_id | int | eas primary key for base address table | |
base_address_num | int | ||
base_address_suffix | string | ||
base_address_create_tms | timestamp | ||
base_address_retire_tms | timestamp | ||
street_name | string | ||
street_type | string | ||
| 1.1.8 | street_post_direction | string | EAST, WEST, NORTH, SOUTH e.g. MISSION BAY BLVD NORTH |
| 1.1.8 | street_full_street_name | string | concatenation of street_name, street_type, and street_post_direction |
street_cnn | int | ||
eas_unit_address_id | int | eas primary key for unit address table | |
| longitude | double | ||
| latitude | double | ||
unit_address_base_flg | boolean | This is an artifact of the relational data model. If false, this is a typical unit address. If true, the unit_number value goes along with the base address (not typical). In the vast majority of cases, a base address will not have a unit number itself, even though there may be units for that address. | |
unit_address | string | The unit address number, letter, or fraction. For example: "A", "1/2", or "7". For legacy reasons, it is currently limited to 1 character. We are planning to expand it to 10 characters. | |
| unit_address_create_tms | timestamp | ||
| unit_address_retire_tms | timestamp | ||
| 1.1.7 | map_block_lot | string | the map_block_lot field for parcels |
| block_lot | string | the block_lot (or assessor parcel number) field for a parcel | |
| 1.1.7 | parcel_date_map_add | date | This is the create date for a parcel. Parcels are created independent of addresses. |
| 1.1.7 | parcel_date_map_drop | date | This is the retire date for a parcel. Parcels are retired independent of addresses. An unretired address that is linked to a retired parcel is an "invalid address" and needs to be corrected. |
| eas_address_x_parcel_id | int | eas primary key to lookup parcels for a unit address | |
| address_x_parcel_create_tms | timestamp | the create time stamp for when a parcel was linked to an address | |
| address_x_parcel_retire_tms | timestamp | the retire time stamp for when a parcel was linked to an address | |
| zipcode | int |