IMPORT POI Statement

The following GBFS columns are available for population through the Alchemy IMPORT POI command.

This table shows the different POI (point of interest) types. The polygon TYPE field should contain one of the type values listed below (in the left-hand column).

To import POIs from CSV format text files, use the following format.

IMPORT POI [name = %name, geom = wkt(%point)] FROM "csv://src_file";

poi_label,poi_type,poi_location
Hamburger Heaven,5800,POINT(-118.265676 34.046188)

Note
Note the formatting of our point. For Well Known Text, the location should be formatted as 'Longitude Latitude', reversing the conventional GeoBase standard of 'Latitude Longitude'. Note also the use of a space as a separator rather than a comma.

The IMPORT POI statement required to import data from the example CSV file shown above is:

IMPORT POI [
  label = %poi_label,
  type = %poi_type,
  geom = wkt(%poi_location)
] FROM "csv://mycsvfile.csv";

The 'poi_label' column provides a name for each POI and the 'poi_type' the type of POI (refer to the 'POI Types' table above). The 'poi_location' column provides POI points stored as WKT.