Addresses - Flat

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 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:

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:

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	date	This is the create date for a parcel. Parcels are created independent of addresses.
1.1.7	parcel_date_map_drop	date	This is the retire date for a parcel. Parcels are retired independent of addresses. An unretired address that is linked to a retired parcel is an "invalid address" and needs to be corrected.
	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