Open Data

  1. Technical Aspects of Working with Open Data
    1. Data Formats
      1. Tabular Formats
        1. CSV (Comma-Separated Values)
          1. TSV (Tab-Separated Values)
            1. Excel Formats
            2. Hierarchical and Semi-Structured Formats
              1. JSON (JavaScript Object Notation)
                1. XML (eXtensible Markup Language)
                  1. YAML
                  2. Geospatial Formats
                    1. Shapefile
                      1. GeoJSON
                        1. KML (Keyhole Markup Language)
                          1. GML (Geography Markup Language)
                          2. Linked Data Formats
                            1. RDF (Resource Description Framework)
                              1. Turtle
                            2. Methods of Access
                              1. Direct File Downloads
                                1. Downloading from Data Portals
                                  1. Versioning and Updates
                                  2. Application Programming Interfaces
                                    1. RESTful APIs
                                      1. GraphQL
                                        1. SOAP APIs
                                          1. API Authentication and Rate Limits
                                          2. Data Dumps and Bulk Access
                                            1. Scheduled Data Releases
                                              1. Archive Files
                                              2. Query Endpoints
                                                1. SPARQL for Linked Data
                                                  1. SQL Query Interfaces
                                                2. Tools for Data Handling
                                                  1. Data Discovery and Portals
                                                    1. Search and Catalog Tools
                                                      1. Metadata Browsers
                                                      2. Data Cleaning and Wrangling Tools
                                                        1. OpenRefine
                                                          1. Trifacta
                                                            1. Spreadsheet Software
                                                            2. Data Analysis and Visualization Libraries
                                                              1. Python Libraries
                                                                1. R Libraries
                                                                  1. Visualization Platforms
                                                                  2. Data Storage Solutions
                                                                    1. Relational Databases
                                                                      1. NoSQL Databases
                                                                        1. Cloud Storage Services
                                                                      2. Data Quality and Metadata
                                                                        1. Assessing Data Quality
                                                                          1. Accuracy
                                                                            1. Completeness
                                                                              1. Timeliness
                                                                                1. Consistency
                                                                                  1. Validity
                                                                                    1. Uniqueness
                                                                                    2. Importance of Metadata
                                                                                      1. Descriptive Metadata
                                                                                        1. Structural Metadata
                                                                                          1. Administrative Metadata
                                                                                            1. Provenance and Lineage
                                                                                            2. Data Dictionaries and Codebooks
                                                                                              1. Variable Definitions
                                                                                                1. Value Labels
                                                                                                  1. Data Collection Methods