| 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.
Business Contacts
...
| contact | dept | context |
|---|---|---|
| Jesus Mora | SFFD | |
| Michelle Malick | SFFD | |
| Derek Entwhistle | SFFD | |
| Mike Wynn | Planning | Accela |
| Alton Chin | Planning | Accela |
...
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:
...