Importing Geospatial Data with the Socrata Data Management Experience

Before you import: Requirements for your geospatial file

  • Make sure your file is one of the following supported upload formats: .zip (shapefile), .json (GeoJSON), .geojson, .kml, and .kmz
  • If an ESRI shapefile, the .zip requires these files - .shp (can have multiple), .dbf (can have multiple), .prj.

Note: We now support the import of multilayer shapefiles, although only one layer can be imported per dataset (see more in section Multilayer Files).

The Import Process

If you have never used the new import experience generally, take a look at this article.

1.  Before beginning the process of creating a new dataset, log in to your Socrata domain.

2.  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.

3.  Upon clicking the link you will be prompted for a ‘Dataset Name’ and then brought to the draft page for the dataset, where you can select a data source and edit your dataset’s metadata.

4.  Click on the ‘Add Data’ button to get started with selecting a Data Source.

5.  From this tab, you can upload your geospatial data, in the formats of .zip (shapefile), .json (GeoJSON), .geojson, .kml, and .kmz, by dragging the file into the right-hand box or by browsing for the source file on your computer.

6.  After importing your data, a data table preview will be available for you to review and modify. Datasets will be listed as tabular, with a "geometry" field for point, multipoint, line, multiline, polygon, or multipolygon. There will also be a primer page for geospatial data, just like any other tabular dataset.

7.  After the dataset has been imported, processed, and the schema configured, click “Save" in the bottom right.

8.  Then, publish your geospatial data!

Unlike in the past, importing shapefiles will not create a map by default. Instead, you will have a tabular dataset that includes a Well-Known Text (WKT) column containing the map geometries. Your new dataset will have a Primer page just like any other Socrata dataset. The map can then be built and customized using the Socrata Visualization tool. For more information on creating map visualizations, see the following articles:

Multilayer Files

When uploading a multilayer shapefile you will now be given the option to choose a single layer to import to the dataset. To start, follow the above steps 1-6. Once this is complete you will be on a Data Preview Page. You will now have a layer dropdown available from the left-hand menu bar labeled Layers/Sheets. As seen in the screenshot below, you will have a list of layers to choose from and import to the dataset. Simply choose the desired layer to import, which will refresh the data preview, and click Save!

Note: At this time, we do not support downloading the original file.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.