When uploading CSV files, keep the following in mind:
CSV files must be in UTF-8 encoding.
CSV files must contain coordinates (latitude and longitude) for points only or WKT (well known text) for points, lines or polygons.
CSV files must be comma (,) separated.
If a row of data is invalid, that row will not be included in the resulting tileset.
The first line of your CSV file must contain column headers.
- Latitude
- latitude
- lat
- y
- Longitude
- longitude
- lon
- long
- x
- WKT
- wkt
On import we will try to auto discover the types in each column (String, text, date etc.)
To define column types a .csvt file can be used. The .csvt file has to have the same name as the .csv file it describes. It enables definition of the following data types: Integer, Real, String, Date (YYYY-MM-DD), Time (HH:MM:SS+nn) and DateTime (YYYY-MM-DD HH:MM:SS+nn) and geometry column types (WKT, lat, X, lon, Y). A .csvt file contains only one line and the types for each column have to be quoted and comma separated, e.g.
"Integer","WKT","String"
Precision can also be applied
"Integer","Real","String(500)"
Example
Here’s an example of how to format a CSV file to upload in Azimap
Using coordinates:
Longitude,Latitude,Location
5.378596061,43.30555421,Aix-Marseille Université
4.818459624,43.94667526,Université d'Avignon et des Pays de Vaucluse
2.268366887,49.87415686,Université de Picardie Jules-Verne
Using WKT:
WKT,Location,
POINT (5.37859606137696 43.3055542091523),Aix-Marseille Université,
POINT (4.81845962403882 43.946675258397),Université d'Avignon et des Pays de Vaucluse,
POINT (2.26836688680064 49.8741568567644),Université de Picardie Jules-Verne,