| Table of Contents |
|---|
...
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 coordination with the business users listed below.
...
User Contacts
| 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:
...