CSV (Comma-Separated Values)
Open Betaقالب CSV با هندسهٔ WKT یک قالب متنی همگانی برای تبادل دادههای جغرافیایی است. در هر برنامهٔ صفحهگسترده باز میشود، بهآسانی به پایگاههای داده وارد میشود و در اسکریپتهای پردازش داده استفاده میشود.
ویژگیهای کلیدی
دربارهٔ قالب CSV
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.
چه برنامهای فایلهای CSV را باز میکند
برنامهها و نرمافزارهای زیر میتوانند فایلهای CSV (Comma-Separated Values) (.csv) صادرشده از OSM2CDR را باز و ویرایش کنند و با آنها کار کنند:
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.
چه کسانی از نقشههای CSV استفاده میکنند
چگونه CSV را خروجی بگیریم
نحوه باز کردن پس از خروجی
- 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.
نقشههای محبوب در CSV
خروجی نقشهٔ CSV (Comma-Separated Values) را دریافت کنید
نقشههای حرفهای CSV را از OpenStreetMap دانلود کنید. تولید آنی برای هر ناحیه.
پرسشهای متداول
مقایسه با قالبهای دیگر
Convert to CSV and back
CSV guides and tutorials
قالبهای مرتبط
قالبهایی که اغلب همراه با هم خروجی گرفته میشوند
Related Articles
WKB and WKT: Geometry Formats for Developers
WKB and WKT: binary and text geometry formats. PostGIS, Shapely, GEOS. When to use which, conversion, performance, and e
guideData Products: Ready-Made Geodata Extracts for Analysis
274 geodata extracts from OpenStreetMap: POIs, buildings, roads, water bodies. How to choose, download, and use for area
formatCSV for Geodata — Simplest Tabular Format for POIs, Coordinates and Addresses
CSV (RFC 4180) is the simplest tabular text format: lat/lon columns or WKT geometry, readable in Excel/pandas/R/QGIS; th