If you wish to import data from a CSV file into Data Share or any other PostgreSQL database this can be done using the Spatial Data Transformation Task.
| Info |
|---|
| If you CSV contains Easting & Northing attributes, and you wish to spatialise your data, then you may wish to read Spatialise a CSV file with Easting & Northing attributes for more information. |
Task Name
Enter a name for the task.
Source Data
Select Comma-Delimited Text File as the Source Data.
...
| Code Block | ||
|---|---|---|
| ||
<FileConType> <Name>Comma-Delimited Text File</Name> <FormatName>CSV</FormatName> <Direction>Both</Direction> <FileFilter>Comma-Delimited Text files (*.csv)|*.csv</FileFilter> </FileConType> |
Filename
Enter the path to the .csv file that you wish to Import.
Output
Select the PostgreSQL database where you wish to store this data.
Table
Enter the table name where you wish to store the data in the database.