osm-to-csv

All POI features retain their original OpenStreetMap identifiers. Certain tagged values of the original OSM features are extracted in specific attributes as denoted in the header of each CSV file: Detailed geometry (WKT) in WGS84; Lon/lat coordinates for the centroid (in WGS84); Name (usually in local language); International name (usually in English or transliterated in Latin characters); Alternative name; POI classification (in 14 categories and 167 subcategories) based on OSM tags; Address (street, house number, postcode, city, country); Contact (phone number, fax number, website, operator); Opening hours; Full description (if listed in OSM); Link to a photo/image; Link to Wikipedia article; Date of last update, while the remaining tagged values are listed under the ‘OTHER_TAGS’ column. Geometries of OpenStreetMap POIs are represented as Well-Known Text (WKT) literals according to the OGC standard. Original OpenStreetMap nodes, ways or relations are suitably converted into WKT geometries, i.e., (multi)points, (multi)linestrings, (multi)polygons, geometry collections, etc.