GeoCSV (CSV with lat/lon columns)
Open BetaGeoCSV is the simplest geo-format: a plain CSV file with separate latitude and longitude columns that opens anywhere — from Excel and Google Sheets to pandas, QGIS, and DuckDB. That universality is why it is chosen for exchanging POI lists between the Excel team, analysts, and GIS engineers. Our exporter writes OSM features as rows with lat and lon columns, adding name, type, layer, and non-empty attributes; for lines and polygons the centroid is used. The file is encoded in UTF-8 with BOM so Cyrillic opens correctly in Excel. A single layer yields a .csv file, multiple layers a ZIP. Honestly: it is a flat table of points — the full shape of lines and polygons is not preserved here; for those use GeoJSON or GeoPackage.
முக்கிய அம்சங்கள்
GeoCSV வடிவம் பற்றி
GeoCSV is not a separate technology but a convention: an ordinary CSV table in which two columns are set aside for latitude and longitude. There is nothing to comply with, but such a file opens everywhere — from Excel and Google Sheets to pandas, R, QGIS and DuckDB.
The format is chosen for people rather than machines: a list of features has to go to a colleague who does not work in GIS, be published on an open data portal, or be loaded into someone else's system that only accepts "a file with coordinates".
The file has a row per feature: lat and lon columns, next to them the name, the type, the map layer and the non-empty OpenStreetMap tags. For lines and polygons the centroid is used — one point per feature. The encoding is UTF-8 with BOM, so that non-Latin text opens in Excel with a double click, without the import wizard. One layer means one .csv, several layers mean a ZIP.
The shape of streets and blocks is not preserved in such a table. If you need the whole geometry rather than points, take GeoJSON, GeoPackage or Shapefile.
GeoCSV கோப்புகளை எந்த நிரல் திறக்கிறது
OSM2CDR இலிருந்து ஏற்றுமதி செய்யப்பட்ட GeoCSV (CSV with lat/lon columns) (.csv) கோப்புகளைப் பின்வரும் நிரல்களும் பயன்பாடுகளும் திறக்கலாம், திருத்தலாம் மற்றும் அவற்றுடன் வேலை செய்யலாம்:
Format specifications
- Open standard
- 2D only
- Lossy compression
- Stores feature attributes
- Output: 1 file
- A flat CSV with separate lat/lon columns plus attributes, UTF-8 with BOM for Excel; lines and polygons collapse to their centroid, so full shapes are not preserved.
GeoCSV வரைபடங்களை யார் பயன்படுத்துகிறார்கள்
GeoCSV ஐ எவ்வாறு ஏற்றுமதி செய்வது
ஏற்றுமதிக்குப் பிறகு எப்படித் திறப்பது
- Excel, Google Sheets, LibreOffice Calc — open with a double click; if the columns end up glued into one, use "Data → From Text/CSV" and set the delimiter to comma.
- QGIS (free) — drag the .csv onto the canvas or use "Add Delimited Text Layer": the program will suggest the lon and lat columns as WGS84 coordinates on its own.
- Python — pandas.read_csv("map.csv"), then geopandas.points_from_xy(df.lon, df.lat) turns the table into a geo layer.
- Google My Maps and similar services — CSV import with latitude and longitude columns works out of the box, and the points land on the map.
- DuckDB — read_csv_auto('map.csv') reads the file directly, and from there the spatial extension's functions work.
GeoCSV இல் பிரபலமான வரைபடங்கள்
GeoCSV (CSV with lat/lon columns) வரைபட ஏற்றுமதிகளைப் பெறுங்கள்
OpenStreetMap இலிருந்து தொழில்முறை GeoCSV வரைபடங்களைப் பதிவிறக்கம் செய்யுங்கள். உடனடி உருவாக்கம், எந்தப் பகுதியும்.