Map of Abil in CSV format
A map built from OpenStreetMap data, ready to download
Customize the map
Open this place's area in the constructor and adjust everything to your needs
Open in constructor →Map passport
What this map contains by default
This is how the map is built as-is — every setting can be changed in the constructor.
About CSV
Map of Abil in CSV: 100% green areas — in the WGS 84 coordinate system, units are meters.
Which layers are in the file
This file for the selected area contains:
- Water
- Greenery
Geometry by layer
- Water — table rows with WKT geometry (Polygon)
- Greenery — table rows with WKT geometry (Polygon)
What the file carries
The CSV file for Abil: the whole map comes as a single file, the file is plain text and opens in any editor, all features lie in one collection, and the source layer name stays in the _layer field, the geometry is written as a WKT string in its own column, OpenStreetMap tags are kept as feature attributes.
File size
The expected size of the CSV file for Abil is about 1 MB; the exact size depends on the chosen layers and area.
Coordinate systems
WGS 84 (EPSG:4326), selectable in the wizard
Units
Meters (projected in the chosen coordinate system)
| Category | GIS |
| File extension | .csv |
| Tier | Open Beta |
How to use CSV for Abil
- Excel — do not open the file with a double click, otherwise non-Latin text turns into gibberish: Data → Get Data → From Text/CSV, encoding UTF-8, comma as the separator.
- QGIS — Layer → Add Layer → Add Delimited Text Layer; choose the WKT column as the geometry, coordinate system EPSG:4326.
- Python — pandas.read_csv for the table, and for the geometry shapely.wkt.loads on the WKT column, or geopandas straight away if you need spatial analysis.
Programs that open CSV
FAQ: CSV for Abil
Can I open the CSV map in Excel?
Yes, the file opens in Excel, Google Sheets, or any spreadsheet application.
How to import CSV into PostGIS?
Via ogr2ogr or COPY with ST_GeomFromText().
How do I open the file in Excel without garbled characters?
Through Data → Get Data → From Text/CSV, specifying UTF-8 encoding and a comma as the separator. When opened with a double click, Excel guesses the encoding from its own settings and often gets non-Latin text wrong.
What are the _layer, lat and lon columns?
_layer is the name of the source map layer, it lets the combined table be split back into roads, buildings and the rest. lat and lon are the coordinates of a representative point of the object: for a line and a polygon that is a point on the object itself, handy for quickly marking it on a map.
What coordinate system do the coordinates come in?
In WGS84 (EPSG:4326) — ordinary latitude and longitude, rounded to seven decimal places. That is roughly centimeter precision, excessive for most tasks and sufficient for any.
