Before beginning the process of creating a new dataset, log in to your Socrata domain. Once logged in, there will be a gray navigation bar at the top of the page. From there open the ‘Create’ drop down and select ‘Dataset’’ to start making your new dataset.
Note: Don't see the “Create” button? Please check that you have the appropriate user role to upload a dataset, here.
Upon creating a new dataset you will be prompted for a ‘Dataset Name’ and then brought to the draft page for the dataset. The top of the page will provide four data actions: Add Data, Review & Configure Data, Edit Dataset Metadata, and Edit Column Metadata. Both Review & Configure Data and Edit Column Metadata will be available after the first data is initially uploaded.
**The dataset title can be edited later on before publishing, so feel free to put in placeholder text if you need more time.**
There are a number of options for populating this dataset. Click on the ‘Add Data’ button to get started with selecting a Data Source.
Uploading a Data File
From this tab, you can upload tabular & geospatial data, in the formats of .csv, .tsv, .xls, .xlsx, .zip (shapefile), .json (GeoJSON), .geojson, .kml, .kmz, by dragging the file into the right-hand box or by browsing for the source file on your computer. You can also upload unstructured data files. For a full list, see our article on accepted source files.
Import Data from a URL
From this tab, you can import a tabular or geospatial dataset (.csv, .tsv, .xls, .xlsx, .zip (shapefile), .json (GeoJSON), .geojson, .kml, .kmz file types) that is hosted externally.
Link to an External Data Source
Alternatively, you can link to an External Data Source. You will be able to link multiple files to one dataset and link multiple datasets to the overall External Data Source.
After importing tabular data, a data table preview will be available for you to review and modify.
Edit Data Inline
You can now edit individual cells directly in the dataset, more information on this can be found here.
Guessing Column Data Types
The import process does its best to guess what each column represents - numbers, text, dates and times or true/false values. It does this by taking a sample from the beginning of a file and trying out every possible type for every column. The data type with the fewest errors is selected.
We recommend that you review the data types we automatically guess for you, and you can override any guess by making a different selection in the data type dropdown, under the column name.
This is particularly important when importing a file with a large number of columns. As mentioned above, during the import process, a sample is taken from the beginning of the file. If the number of columns is quite large, the number of rows sampled may decrease, and the system will be less certain of the correct data type.
Any records with errors recognized by the tool will not be imported at all. Note that this is a departure from our previous upload tool’s handling of errors. More details of the errors can be accessed underneath the column data type:
Or by using the ‘Export Errors’ button:
This will only export records that could not be uploaded. The file will also contain more detail on why a row will not be imported.
If the errors cannot be resolved by selecting a different data type, you can update your dataset in an external tool, then select the new data source to import with by going back to the ‘Choose Data Source’ tab from the ‘Preview’ screen.
Note: After a data source has been imported, changing the data source to Link to an External Source will no longer be possible. The restriction also exists if you start with linking to an External Data Source, you will not be able to change to importing a data source.
If you need to change or import a new version of the source file to this dataset, you can do so from this page. Additionally, from the Data Sources list, you can revert to a previously imported dataset
Dataset Level Formatting
From the Preview window, you will be able to configure the dataset by designating the Header Row, Column Separator, Character Encoding of the source file and Quote Character. From the sidebar, you can add a new column or a georeferenced location column using location data from the dataset.
Column Level Formatting and Transformations
From the data table preview, you can perform the column level actions: selecting a Data Type, formatting how column data is rendered, performing Data Transforms, removing columns from the dataset, and reordering the columns.
Adding a Georeference Column
From the data table preview, you can add a georeference column to your dataset using the component columns already in your dataset. There are three tabs that give options to create this column. Lat/Long can be used when you have both a column for latitude and longitude in your dataset. Address (separated) is used when fields such as street, city, state, and zip are separated out into different columns. And finally, Combined Address is used when there is a single column that contains the complete address.
There are a few other configuration options on this page as well. You can check Do not import original columns if you would like to remove the component columns from the dataset. There are also options to handle geocoding errors. Treat value as empty will still import the row and just treat the cell as blank in the dataset. Skip row will treat the row as an error and the entire row will not import to the dataset.
Finally, you can run the geocoder right from this window and preview how the column will display before deciding to publish your dataset.
Adding a Column
You can add new columns to your dataset by clicking on the "Add Column" button on the left-hand side of the data table preview. In this modal, you can choose the Display Name, Field Name, Description, Source Column, and Data Type of the new column.
Before a dataset can be published, all required fields for the dataset metadata must be filled out. These fields can be accessed from the dataset draft page by clicking the ‘Edit Metadata’ button.
Metadata is descriptive data about the dataset. Here are the different kinds of information you can provide about your platform dataset.
Dataset Title (required): The minimum amount of metadata required is a title for the platform dataset. This has to be unique from all other datasets and views on the site.
Brief Description: Any details you want to provide to elaborate on the title, even summarizing the different metadata information you are providing.
Category: You can select from a list of default categories which best encompasses the kind of data your dataset will hold. These defaults are No category, Business, Education, Fun, Government and Personal. Administrators can configure more categories as options.
Tags and Keywords: You can add in words which will help make your dataset more searchable on the data portal. Multiple tags can be entered as comma seperated.
Licensing & Attribution: You can set the licensing terms for the data file, to appropriately reference your sources if people which to share it. To view the licensing options we support refer to the article Which licensing option should I use? You can name the Individual or Organization where you sourced the data from and provide a link if one is available.
Attachments: You will be able to attach files such as PDFs and images once the data file has already been imported by going to the About panel > Edit Metadata once the data file has been fully imported.
Column Metadata & Ordering
Column metadata is descriptive information about the columns in the dataset. From this tab, you will also be able to edit the Name and API Field Name of the dataset columns.
NOTE: Valid field name characters are all lower case, alphanumeric and underscore. It must start with a letter or underscore and cannot contain special characters or spaces.
In this tab, you can also set the visibility and set the order of columns in the dataset.
Column order is set by drag-and-drop, and visibility is set by toggling hidden and unhidden.
Collaboration and Publishing
Prior to publishing the dataset, it will exist as a working copy and can be accessed from the Asset Inventory. This allows you to complete different stages of the dataset at different times and can be completed by different contributors.
Any changes made to the dataset, such as schema modifications, changing data sources, etc., will show up in the revision log on the right-hand side of the dataset draft page. You will be able to view the changes made to the data schema by clicking on the ‘Schema’ link in the revision log. This will bring you to the data preview version of the changes that were made. To use those settings, select ‘Save’ from the bottom right corner of the data table.
Once you are finished creating the dataset and are ready to publish, click the ‘Publish Dataset’ button on the action bar. Then, select the desired visibility permissions for the dataset and click ‘Publish.’ Once you hit publish, you can move on from the page as the upload is now in progress. Once complete, you can select Go to Primer to view your brand new dataset.
You have now finished publishing a dataset using the Socrata Data Management Experience!
After a dataset is published, you can change the privacy of a dataset by navigating to the Manage panel > Permissions.