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,