Reference Data Index

Below is a table of the reference datasets mentioned in this document. View all the reference data below in the open data portal.

Dataset	Description and Constraints	Reference Columns	Page(s)
Addresses - Enterprise Addressing System	The EAS is the system of record for DBI when assigning official addresses. Coordinates are most often associated with the center of a parcel or close to it, rather than at the door or entry. This still allows associations, but it means that in certain cases a building footprint cannot be spatially matched via intersection or "point in polygon" with it's address(es).	address_number	Address Numbers
Addresses with Units - Enterprise Addressing System	Same general limitations as the Addresses dataset above, but also includes sub-addresses like units. Unit numbers are formally referenced for condos because the City records these for the purposes of properly tying deeds and other property records to a specific unit and owner. Rental units are not formally recorded by the City.	address_number	Address Numbers
Building Footprints	The footprint extents are collapsed from an earlier 3D building model provided by Pictometry of 2010, and have been refined from a version of building masses publicly available on the open data portal for over two years. The building masses were manually split with reference to parcel lines, but using vertices from the building mass wherever possible. These split footprints correspond closely to individual structures even where there are common walls; the goal of the splitting process was to divide the building mass wherever there was likely to be a firewall. An arbitrary identifier was assigned based on a descending sort of building area for 177,023 footprints. The centroid of each footprint was used to join a property identifier from a draft of the San Francisco Enterprise GIS Program's cartographic base, which provides continuous coverage with distinct right-of-way areas as well as selected nearby parcels from adjacent counties.	sf16_bldgid unique identifier for footprint mblr for reference to property identifiers including parcels and right of way	Building Footprints
Department Code List	These department codes are maintained in the City's Financial System of Record. Department Groups, Divisions, Sections, Units, Sub Units and Departments are nested in the dataset from left to right. Each nested unit has both a code and an associated name. The dataset represents a flattened tree (hierarchy) so that each leaf on the tree has it's own row. Thus certain rows will have repeated codes across columns. Data changes as needed.	Nested (right to left): department_group_code division_code section_code unit_code sub_unit_code department_code	Department Names and Codes
Current Subdivision Parcels	These are the current active recorded parcels. The geography can be used as reference but should not be used for anything requiring precision.	block_num lot_num blklot	Parcels
List of Streets and Intersections	A list of street segments and intersections sorted by street name and ascending address number. This data set is based on the City's GIS basemap and contains CNN id numbers for each record.	cnn as number For segments: from_cnn and to_cnn define the node IDs at each end	Street Centerlines and Nodes
Recorded Parcel Geography with Transaction Date History	These are the current and historic parcels with recorded dates. Historic parcels only go back to about 1995 with some exceptions. Useful for tying historic administrative records to a location. The geography can be used as reference but should not be used for anything requiring precision.	block_num lot_num blklot	Parcels
San Francisco Assessor Blocks	Just the blocks without lots	block_num	Parcels
San Francisco Basemap Street Centerlines	A geographic reference of the all basemap streets including centerline node network identifiers and jurisdictions and street names by segment	cnn as number cnntext as text f_node_cnn as the starting (from) node ID t_node_cnn as the ending (to) node ID fullstreetname composed of streetname & streettype	Street Centerlines and Nodes & Street Names
Street Names	Contains a list of officially valid street names contained in the City's Basemap	fullstreetname composed of streetname & streettype	Street Names
Street Segment and Intersection (CNN) Change Log	A list of Street Segment and Intersection (CNN) changes including new, dropped, realigned, divided and split records.	oldcnn as number newcnn as number	Street Centerlines and Nodes