CSV 📄

CSV (Comma-Separated Values)

Open Beta
.csv · text/csv

带 WKT 几何的 CSV 是一种通用的地理数据交换文本格式。可在任意电子表格应用中打开,便于导入数据库,也常用于数据处理脚本。

立即导出 CSV ✨ Open Beta — 免费无限制

主要特点

文本格式
WKT 几何
可在 Excel 中打开
便于导入到数据库

关于 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 文件的程序

以下程序可以打开、编辑和处理从 OSM2CDR 导出的 CSV (Comma-Separated Values)(.csv)文件:

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

格式规格

谁在使用 CSV 地图

🏗
数据交换
Passing geodata to where there is no GIS: anyone can open a table.
💻
数据库导入
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.
🎨
数据处理脚本
Processing with Python or R scripts without installing geo libraries.
🗺
ETL 数据管道
An intermediate layer in an ETL pipeline between the export and the target system.

如何导出 CSV

1
选择区域
在 osm2cdr 的交互式地图上绘制矩形或多边形
2
选择 CSV
从 127 种可用导出格式中选择 CSV (Comma-Separated Values)
3
导出
点击导出,1–5 分钟内收到您的 .csv 文件
4
下载
下载完成的 CSV 文件并在 Excel 中打开

导出后如何打开

CSV 格式的热门地图

Free

导出 CSV (Comma-Separated Values) 地图

从 OpenStreetMap 下载专业的 CSV 地图。即时生成,任意区域。

免费 / 导出
立即导出 CSV →

常见问题

我能在 Excel 中打开 CSV 地图吗?
如何把 CSV 导入 PostGIS?
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?

与其他格式比较

相关格式

经常一起导出

Related Articles