📐
DataSF | Data Standards Handbook
  • Introduction
  • Data Structure and Formats
    • Data Structure and Formats
      • Column Headers & Order
      • Date and Time
      • Text
      • Numeric
      • Location (coordinates)
      • Location (addresses)
  • Standard Reference Data
    • Reference Data Overview
    • Reference: General Admin
      • Department Names and Codes
    • Reference: Demographics
      • Sexual Orientation & Gender Identity
      • Race and Ethnicity
        • City and County of San Francisco
          • San Francisco Recommended Standard
            • Appendices
          • Department of Public Health’s Ethnicity Guidelines
        • State of California
        • Federal Government
    • Reference: Basemap
      • Overview
      • Parcels
      • Building Footprints
      • Address Numbers
      • Street Names
      • Street Suffix Abbreviations
      • Street Centerlines and Nodes
    • Reference: Boundaries
      • Census
      • Neighborhoods
      • Supervisor Districts
      • Zoning Use Districts
  • Appendix
    • Reserved Column Names
    • Reference Data Index
    • Contributing
    • Acknowledgements
    • License
    • See our other explainers
Powered by GitBook
On this page

Was this helpful?

  1. Data Structure and Formats
  2. Data Structure and Formats

Location (coordinates)

PreviousNumericNextLocation (addresses)

Last updated 5 years ago

Was this helpful?

  • Coordinates in or

  • Only EPSG 4326 coordinates can be mapped within the open data portal

  • Should be represented in two columns

    • EPSG 4326: latitude and longitude or

    • EPSG 2227: x_coord and y_coord

    • Note: all EPSG 4326 coordinates will be loaded into the open data portal to support mapping and presented in an additional single location column there called the_geom. EPSG 2227 coordinates will be represented as the two original columns

  • In positive/negative floating point

    • e.g. latitude: 37.761146; longitude: -122.436235

  • EPSG should be indicated in metadata

Is anything wrong, unclear, missing?

EPSG 4326
EPSG 2227
Leave a comment.