Create a Dataset by Uploading a File

You can create a dataset by uploading a file in a format supported by Spatial Studio.

The supported file formats are as follows:

• Excel file

• Shapefile

• GeoJSON file

• CSV file

• KML file

Note: Compute environment is required if you are uploading a large file that exceeds 50 MB. See Create a Compute Environment for more information.

Also, note the following:

• WKT or GeoJSON geometry text values in Excel or CSV files are supported.

  If you are uploading a file with WKT text values, then only WKT strings representing geodetic coordinates (longitude and latitude) are supported.

• Three dimensional coordinates are supported in GeoJSON files.

1. Navigate to the Datasets page.

2. Click Create Dataset.

   The Create Dataset window opens.

3. Select the Local File option.

4. Upload any one of the supported file types.

5. Click Create.

   The Create Dataset window opens displaying the data columns.

6. Select a value in Upload to connection drop-down.

7. Optionally, review and edit any other parameters as required.

8. Click Submit.

   The new dataset gets added and listed on the Datasets page.

Upload a Shapefile

You can create a dataset by uploading a shapefile.

A shapefile contains the geospatial data which can be referenced in multiple files with specific file extensions. The following lists a few selected files that contribute to shapefile format:

• .shp - Stores the geometry data

• .shx - Stores the index of the geometry

• .dbf - Stores the attribute information of geometry features

• .prj - Stores the coordinate system information

• .cpg - Specifies the character set to be used

Note that shapefiles containing WKT v2 projection files are supported in Spatial Studio.

1. Navigate to the Datasets page and click Create Dataset.

2. Select Local File.

3. Click to upload the shape file.

   The File Upload window opens.

4. Select all the required files from your system.

   Note: It is mandatory to upload .shp, .shx, and .dbf files.

   The Create dataset from shapefile dialog opens as shown:

   Figure 1: Create dataset from shapefile

   

   Description of the illustration shapefile.png

5. Select the connection to upload the shapefile from the Upload to connection drop-down list.

6. Optionally, change the Table name.

7. Optionally, change the destination Dataset name.

8. Optionally, select the Coordinate System to be used.

   • If your shapefile includes a .prj file referencing a custom Geographic Coordinate System (GEOGCS), then Spatial Studio will assign a best-matched geodetic SRID from the target Spatial database, as shown in the preceding figure.

   • If your shapefile does not contain a .prj file, then the system uses the default EPSG:4326 GEOGCS.

9. Optionally, select the required Character set.

   Spatial Studio automatically detects the character set to be used in the following order of priority:

   • Extracts the charset-name from a .cpg file, if present.

   • Uses the character set specified in the .dbf file header.

   • Otherwise, uses the default ISO-8859-1.

   You can preview the file attributes using the detected character set. However, you can still choose to switch to a different Character set and preview the refreshed contents.

10. Click Submit.

    The dataset gets created from a shapefile.