sfgov/addresses-with-units-enterprise-addressing-system-ramy-di5m
 
Readme
Updated 18 hours ago
Indexed 2 hours ago

Addresses with Units - Enterprise Addressing System

All active addresses from the City's Enterprise Addressing System (EAS), including sub-addresses, such as units. Includes references to parcel and street centerline data (Note: not all addresses are associated with parcels). Updated nightly. See EAS Base Addresses for base addresses not including units.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
EAS BaseIDeas_baseideas_baseidNumberThe unique identifier for the base address record. For example, the address excluding any sub-units
EAS SubIDeas_subideas_subidNumberThe unique identifier for the sub-address within a base address. For example, a unit or apartment within a building
EAS FullIDeas_fullideas_fullidTextThe full unique identifier of the entire row (unique across the dataset)
AddressaddressaddressTextThe full location of a record often including the street number, name and type; city; state; and zip code
Unit Numberunit_numberunit_numberTextThe letters, numbers, words, or combination thereof used to distinguish different subaddresses of the same type when several occur within the same feature
Address Numberaddress_numberaddress_numberNumberThe numeric identifier for a land parcel, house, building, or other location along a thoroughfare or within a community
Address Number Suffixaddress_number_suffixaddress_number_suffixTextThe portion of the Complete Address Number that follows the Address Number itself
Street Namestreet_namestreet_nameTextThe portion of the Complete Street Name that identifies the particular thoroughfare
Street Typestreet_typestreet_typeTextA word or phrase that follows the Street Name and identifies a type of thoroughfare in a Complete Street Name
Parcel Numberparcel_numberparcel_numberTextAn asessor's parcel number, or APN, is a number assigned to parcels of real property by the Office of the Assessor Recorder for purposes of identification and record-keeping. It is sometimes referred to as the blocklot in City data. It is made up of two parts, the Assessor Block Number and the Assessor Lot Number. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c
BlockblockblockTextThe full assessor's parcel number is comprised of two parts, the first being the block number. Blocks are assigned by the Office of the Assessor Recorder. You can see a block map here: https://data.sfgov.org/d/ndp2-nsue Blocks are officially recorded in physical block maps. You can find PDFs of those here: https://data.sfgov.org/d/2367-5au8
LotlotlotTextThe full assessor's parcel number is comprised of two parts, the second being the lot number. Lots are assigned by the Office of the Assessor Recorder and are captured within blocks. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c
CNNcnncnnNumberCenterline Network Number is the primary key/identifier for a street segment or node assigned by the Department of Public Works in the city's official basemap. Segments refer to lines representing the street, nodes represent points where two or more segments intersect. CNN IDs are often found encoded as text (CNNTEXT) or numbers (CNN). Basemap street segments are available here: https://data.sfgov.org/d/7hfy-8sz8; Basemap intersections (nodes) are here: https://data.sfgov.org/d/ctsg-7znq
LongitudelongitudelongitudeNumberA geographic coordinate expressed in decimal degrees that specifies the east-west position of a point on the Earth's surface and assuming a WGS84 coordinate system.
LatitudelatitudelatitudeNumberA geographic coordinate expressed in decimal degrees that specifies the north-south position of a point on the Earth's surface and assuming a WGS84 coordinate system.
ZIP Codezip_codezip_codeNumberA system of 5-digit codes that identifies the individual Post Office or metropolitan area delivery station associated with an address.
pointpointpointPointThe system representation of the coordinate (latitude and longitude) for the purposes of mapping within the open data portal.
supdistsupdistsupdistTextFull name of Supervisorial District.
supervisorsupervisorsupervisorNumberSupervisor District Number
supdistpadsupdistpadsupdistpadTextSupervisor District Number with zero padding (01,02,...)
numbertextnumbertextnumbertextTextSupervisor District Number as text (ONE, TWO, ...)
supnamesupnamesupnameTextLast name of current Supervisor of District.
nhoodnhoodnhoodTextSan Francisco Neighborhood for analysis, per DataSF.
SF Find Neighborhoods:@computed_region_6qbp_sg9q:@computed_region_6qbp_sg9qNumber
Current Police Districts:@computed_region_qgnn_b9vv:@computed_region_qgnn_b9vvNumber
Current Supervisor Districts:@computed_region_26cr_cadq:@computed_region_26cr_cadqNumber
Analysis Neighborhoods:@computed_region_ajp5_b2md:@computed_region_ajp5_b2mdNumber
Upstream Metadata