sfgov/addresses-with-units-enterprise-addressing-system-ramy-di5m

 
External

Addresses with Units - Enterprise Addressing System

  • addresses
  • city reference data
  • dbi
  • eas
  • ref:basemap
  • And 1 more...

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
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
supervisorsupervisorsupervisorNumberSupervisor District Number
pointpointpointPointThe system representation of the coordinate (latitude and longitude) for the purposes of mapping within the open data portal.
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.
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
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
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
Street Typestreet_typestreet_typeTextA word or phrase that follows the Street Name and identifies a type of thoroughfare in a Complete Street Name
AddressaddressaddressTextThe full location of a record often including the street number, name and type; city; state; and zip code
Street Namestreet_namestreet_nameTextThe portion of the Complete Street Name that identifies the particular thoroughfare
Address Numberaddress_numberaddress_numberNumberThe numeric identifier for a land parcel, house, building, or other location along a thoroughfare or within a community
EAS SubIDeas_subideas_subidNumberThe unique identifier for the sub-address within a base address. For example, a unit or apartment within a building
nhoodnhoodnhoodTextSan Francisco Neighborhood for analysis, per DataSF.
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.
EAS BaseIDeas_baseideas_baseidNumberThe unique identifier for the base address record. For example, the address excluding any sub-units
EAS FullIDeas_fullideas_fullidTextThe full unique identifier of the entire row (unique across the dataset)
numbertextnumbertextnumbertextTextSupervisor District Number as text (ONE, TWO, ...)
ZIP Codezip_codezip_codeNumberA system of 5-digit codes that identifies the individual Post Office or metropolitan area delivery station associated with an address.
Address Number Suffixaddress_number_suffixaddress_number_suffixTextThe portion of the Complete Address Number that follows the Address Number itself
supnamesupnamesupnameTextLast name of current Supervisor of District.
supdistpadsupdistpadsupdistpadTextSupervisor District Number with zero padding (01,02,...)
supdistsupdistsupdistTextFull name of Supervisorial District.
Analysis Neighborhoods:@computed_region_ajp5_b2md:@computed_region_ajp5_b2mdNumber
Current Supervisor Districts:@computed_region_26cr_cadq:@computed_region_26cr_cadqNumber
Current Police Districts:@computed_region_qgnn_b9vv:@computed_region_qgnn_b9vvNumber
SF Find Neighborhoods:@computed_region_6qbp_sg9q:@computed_region_6qbp_sg9qNumber

Upstream Metadata