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

Data Preparation and Formatting Guidance

PreviousOpen Data Portals Managed by State EntitiesNextColumn Headers and Order

Last updated 1 year ago

Was this helpful?

Referenced from:

This section covers format and structure standards for datasets being shared with others. These standards are designed to make sure that field level information is shared as consistently as possible to minimize:

  1. Errors

  2. Rework

  3. Repetitive questions

This reference covers:

This section is adopted from with many thanks to . The bulk of which made its way into this section with additions and modifications.

Want to provide feedback on future data prep and data quality guides?

.

📣
📈2. Prepare Data for Publishing
Column headers and order
Date and time formats
Text formats
Numeric formats
Address formats
guidance published by DataSF
Singapore's Open Data Program for providing a Data Quality Guide for Tabular Data
Fill out the form to indicate interest