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 | ||
unit_address | string | ||
| 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 |
0 Comments