We are working with Michelle Malick and Jesus Mora at the San Francisco Fire Department to provide a flat file export.
This file is a flattened version of EAS addresses which use this data model.
This data will be available in a CSV file 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.
The file structure is as follows:
| 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 | |
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 | |
| parcel_block_lot | string | |
| eas_address_x_parcel_id | int | eas primary key to lookup parcels for a unit address |
| address_x_parcel_create_tms | timestamp | |
| address_x_parcel_retire_tms | timestamp | |
| zipcode | int |
Add Comment