California Open Data Publisher's Handbook
Documents and ResourcesCA Open Data Portal
  • Introduction
  • ☑️1. Review the Pre-Publishing Checklist
  • 📈2. Prepare Data for Publishing
  • 📙3. Create Metadata and Data Dictionary
  • 🔼4. Upload the Dataset
  • 👍5. Get Final Publishing Approval
  • 🔄6. Update and Maintain the Dataset
  • 📣Feedback & Help
  • Reference
    • The What and Why of Open Data
    • Open Data Portals Managed by State Entities
    • Data Preparation and Formatting Guidance
      • Column Headers and Order
      • Date and Time
      • Text
      • Numeric
      • Addresses
    • Metadata Field Definitions
    • Data Dictionary: What to Include
    • Detailed Steps for Uploading Data to the Portal
    • Email Templates
    • Glossary
    • Acknowledgements
    • Version and Changelog
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
Export as PDF
  1. Reference
  2. Data Preparation and Formatting Guidance

Numeric

  • 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 and indicate rounding in metadata

  • 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)

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

PreviousTextNextAddresses

Last updated 3 years ago

Was this helpful?