Uploading a CSV

Uploading a CSV

Summary:

Admins have the ability to upload a CSV file into XMAP/PostGIS, as long as the csv file contains columns with coordinates or geom, in either a projection of 27700 or 4326.

Prerequisites:

Column names should not contain special characters, start with numbers and ideally follow the first three best practice for table/column names

The CSV file must contain named coordinate columns, and supports the following pairs: 
  1. lon, lng, long, longitude, x, easting, east
  2. lat, latitude, y, northing, north
Alternatively, if your CSV contains a column with wkt values, then any of these column names ares acceptable. 
  1. wkt, geom, geometry, the_geom, wkb_geometry

How to:

Go to Admin >> Data >> Upload File
  1. Change FORMAT to CSV
  2. Choose the destination database and schema
  3. Set a projection for the data (optional but recommended) either 27700 or 4326
  4. drag and drop or choose a CSV to upload. 
  5. Click on the UPLOAD button
  6. In the processing area, wait from the file to be ready. 
  7. Once ready, click on the Start Ready Files button. 
 
  1. Once the CSV is successful Done you can add the table into a Collection.