sfgov/addresses-enterprise-addressing-system-3mea-di5p

 
External

Addresses - Enterprise Addressing System

  • addresses
  • city reference data
  • dbi
  • eas
  • ref:basemap

Addresses - Enterprise Addressing System

Active base addresses from San Francisco's Enterprise Addressing System (EAS). This dataset does not include sub-addresses, such as units, and does not include a block/lot value for each record. For units and block/lot values, see the "Addresses with Units - Enterprise Addressing System" dataset.

Note: this dataset now includes as of 12/17/2020, base addresses that may not have any block/lot value associated.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
supdistpadsupdistpadsupdistpadTextSupervisor District Number as text with zero padding (01, 02, ...)
numbertextnumbertextnumbertextTextSupervisor District number as text (ONE, TWO, ...)
nhoodnhoodnhoodTextSan Francisco Neighborhood as per DataSF.
supervisorsupervisorsupervisorNumberSupervisor District Number
Address Number Suffixaddress_number_suffixaddress_number_suffixTextThe portion of the Complete Address Number that follows the Address Number itself if one exists
Street Typestreet_typestreet_typeTextA word or phrase that follows the Street Name and identifies a type of thoroughfare in a Complete Street Name
EAS BaseIDeas_baseideas_baseidNumberThe unique identifier for the base address record. For example, the address excluding any sub-units
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
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.
ZIP Codezip_codezip_codeNumberA system of 5-digit codes that identifies the individual Post Office or metropolitan area delivery station associated with an address.
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
supdistsupdistsupdistTextFull name of Supervisorial District
supnamesupnamesupnameTextLast name of current Supervisor for District
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
Address Numberaddress_numberaddress_numberNumberThe numeric identifier for a land parcel, house, building, or other location along a thoroughfare or within a community
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.
pointpointpointPointThe system representation of the coordinate (latitude and longitude) for the purposes of mapping within the open data portal.

Upstream Metadata