Introduction
We have worked with the San Francisco Fire Department to provide a flat file export.
This is now available to anyone on in a CSV file on our secure FTP server.
The data is refreshed from our production system every weekday.
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.
Change Control
This integration point is being used by external production systems. As such, we shall not make any changes without coordinating with the business users listed below.
| contact | dept | context |
|---|---|---|
| Jesus Mora | SFFD | |
| Michelle Malick | SFFD | |
| Derek Entwhistle | SFFD | |
| Mike Wynn | Planning | Accela |
| Alton Chin | Planning | Accela |
Data Model
This file is a flattened version of EAS addresses which use this data model.
The export is based on a database view in EAS called vw_addresses_flat_export(see the DDL here).
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 | the create date for a parcel | |
| 1.1.7 | parcel_date_map_drop | the retire date for a parcel | |
| 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 |
0 Comments