📐
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

Numeric

PreviousTextNextLocation (coordinates)

Last updated 5 years ago

Was this helpful?

  • No commas

    • e.g. "1000" instead of "1,000"

  • No units of measurement

    • Units should be in metadata instead

  • Express as full number where possible

    • e.g. "1200000" instead of "1.2" (million)

    • If rounded, indicate in metadata

  • No rounding if possible

    • Give raw numbers as far as possible

    • If rounding is needed, try to provide at least 2 decimal places of precision

  • Percentages can be expressed as either a proportion out of 1 or 100.

    • e.g. 20% can be expressed as 20 or 0.2

    • The representation of percentages must be consistent throughout your dataset (e.g. among different percentage fields)

    • Agencies must indicate how percentages are expressed in the data dictionary

Is anything wrong, unclear, missing?

Leave a comment.