| Table of Contents |
|---|
Introduction
We have worked with the San Francisco Fire Department and other agencies to provide a set of flattened data products. Flattening just means that we provide a single table representation of what is actually mutilple multiple tables in a relational database. In this case we are joining four tables in EAS. You can see the data model here. The flattening is accomplished using this database view.
Availability
The flattened data products are refreshed from our production system every weekday.
These data are available in the following locations
Comma Separated Value File (CSV)
A CSV file is available 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.
ESRI SDE
A table is available on the SFGIS ArcSDE server. If you want access to this file please let us know and we'll provide you with the credentials. The name of the table is eas_addresses_flat_export.
ESRI Shapefile
We also export these data to the public via Socrata. The URLs for these datasets are:
- https://data.sfgov.org/Geography/Addresses-Enteprise-Addressing-System/pf3h-w4up
- https://data.sfgov.org/Facilities-and-Structures/Addresses-with-Units-Enterprise-Addressing-System-/kvej-w5kb
Business Contacts
| contact | dept | context |
|---|---|---|
| Jesus Mora | SFFD | |
| Michelle Malick | SFFD | |
| Derek Entwhistle | SFFD | |
| Mike Wynn | Planning | Accela |
| Alton Chin | Planning | Accela |
Data Model
The file structure is as follows:
...