📄

CSV (Comma-Separated Values)

Open Beta

.csv · text/csv

WKT-geomeetriaga CSV on universaalne tekstivorming geoandmete vahetamiseks. Avaneb mis tahes tabelirakenduses, imporditakse hõlpsalt andmebaasidesse ning kasutatakse andmetöötlusskriptides.

Ekspordi CSV kohe ✨ Avatud beeta — tasuta, ilma piiranguteta

Põhiomadused

✓Tekstiformaat

✓WKT-geomeetria

✓Avaneb Excelis

✓Lihtne import andmebaasi

Vormingu CSV kohta

CSV is a simple table: a row per object, columns separated by commas. Geography is put into it in two ways, and we use both at once: the full geometry of an object is written as text in WKT format, and next to it come the latitude and longitude of a representative point — for a line and a polygon that is a point on the object itself, not a nominal center outside it.

The format is chosen when the map is needed as data rather than as a picture: to count objects in a table, to merge with an export from your own system, to load into a database, to hand to a colleague without a GIS, to run through a script. CSV is read by literally everything — from Excel to pandas.

The output is a single file in UTF-8 encoding. One layer gives an ordinary table; if several layers are selected, they are gathered into one file, and the first column _layer shows where the row came from — it makes splitting the data back apart easy. OSM attributes go as separate columns, and the coordinates are in WGS84 rounded to seven decimal places, which is about a centimeter.

Milline programm avab CSV-faile

Järgmised programmid ja rakendused suudavad avada, redigeerida ning töödelda OSM2CDR-ist eksporditud CSV (Comma-Separated Values) (.csv) faile:

📈Excel 💻Google Sheets 💻Python (pandas) 📐R 💻PostGIS 🌎QGIS

Format specifications

Open standard
2D only
Lossless (no quality loss)
Stores feature attributes
Output: 1 file
RFC 4180 CSV with WKT geometry column or lat/lon pairs. UTF-8 encoded. Opens in Excel, LibreOffice, pandas, QGIS.

Kes kasutab CSV-kaarte

🏗

Andmevahetus

Passing geodata to where there is no GIS: anyone can open a table.

💻

Andmebaasi import

Loading into PostgreSQL, MySQL or a warehouse with a single import command.

📊

Excel/Google Sheets

Work in a familiar spreadsheet: filters, pivots, counting objects by type.

🎨

Töötlusskriptid

Processing with Python or R scripts without installing geo libraries.

🗺

ETL-konveierid

An intermediate layer in an ETL pipeline between the export and the target system.

Kuidas eksportida vormingusse CSV

Vali ala

Joonista interaktiivsel kaardil aadressil osm2cdr.ru ristkülik või polügon

Vali CSV

Vali 127 saadaoleva eksportvormingu hulgast CSV (Comma-Separated Values)

Ekspordi

Klõpsa „Ekspordi“ ja saa oma .csv-fail 1–5 minutiga

Laadi alla

Laadi alla valmis CSV-fail ja ava see programmis Excel

Kuidas pärast eksporti avada

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.
PostGIS — load the table with the COPY command and turn the text into geometry through ST_GeomFromText with SRID 4326.
Google Sheets and My Maps — accept the latitude and longitude columns directly, if a point representation of the objects is enough.

Populaarsed kaardid vormingus CSV

Free

Hangi kaardiekspordid vormingus CSV (Comma-Separated Values)

Laadi alla professionaalsed CSV-kaardid OpenStreetMapi andmetest. Kohene genereerimine, mis tahes ala.

Tasuta / eksport

Ekspordi CSV kohe →

Korduma kippuvad küsimused

Kas saan CSV-kaardi Excelis avada? ▼

Kuidas CSV-d PostGIS-i importida? ▼

How do I open the file in Excel without garbled characters? ▼

What are the _layer, lat and lon columns? ▼

What coordinate system do the coordinates come in? ▼

Võrdle teiste vormingutega

⚖ CSV vs GEOJSON ⚖ EXCEL vs CSV ⚖ GEOJSON vs CSV

Seotud vormingud

Sageli koos eksporditavad vormingud

CSV+💻GeoJSON 🌎Shapefile 🗺GPX

format