All Questions
31
questions
4
votes
1
answer
204
views
How can I use ogr2ogr to left join a CSV to a GPKG file and produce a GeoJSON output in a scalable way?
I have a large GPKG and a CSV file, and I'd like to (left) join the CSV to the GPKG on one of the columns. A visualisation of what I'm trying to achieve:
Reproducible example
We can create an example ...
1
vote
1
answer
58
views
QGIS - Export layer with one polygon subdivided as multiple rows to CSV
I have a GeoJSON file with quite precise boundaries of world's countries. I had to simplify it because Snowflake, where I want to keep the data, has 16MB limit and Canadian polygon is always too large....
0
votes
1
answer
484
views
Read GeoJSON object in a CSV file column and transform it to geometry
I have a column ('geo_shape') that contains GeoJSON object type of linestring geometry and, so far, I didn't manage to read and transform it to a GeoPandas/shapefile type of geometry.
Here is a way ...
0
votes
1
answer
522
views
Python from GeoJSON to js file
I have created a GeoJSON file from a csv file and now I want to create a .js file to use in Leaflet map.
I´ve managed to append the "var data =" but the output file doesn´t have proper ...
1
vote
1
answer
58
views
Leaflet GeoCSV popups are not being displayed
I am using the Leaflet GeoCSV plug in to try and add markers with popups to my map.
With the help of this post, I have been able to add the markers to the map, but I still want to add a popup to the ...
2
votes
1
answer
6k
views
Loading of local CSV file blocked by CORS policy in Leaflet
I am using the the Leaflet Geocsv plug in to display markers with popups from a csv file.
When trying to aacess the file my Chrome Browser puts out this error message:
Access to XMLHttpRequest at '...
0
votes
1
answer
142
views
Leaflet GeoCSV Marker not visible on map
I am trying to load data for a Marker from a csv file and I am using the GeoCSV plugin for that.
I downloaded the js file and added it to my code and also created a csv file in Excel which looks like ...
0
votes
1
answer
314
views
Import format in kepler.gl from QGIS
I try to export layer from QGIS to CSV, JSON or GeoJSON to add data in kepler.gl.
I think I tried all options : geometrycollection or not, GeoJSON newline limited or not, comma, semicolon, CSV with ...
1
vote
0
answers
204
views
Converting GeoJSON point into polygon in React
I have a JSON file of areas making polygon. I have saved those files in SQL Server database so i convert GeoJSON into CSV and import in my database and now i want to connect database with React.js.
...
4
votes
2
answers
3k
views
GeoJSON to CSV with geometry using QGIS
I downloaded a GeoJSON file from vangdata.carto.com and I'm trying to convert it to CSV that has geometry data in tact. I'm trying to achieve the same result as a CSV file when exported from public....
1
vote
1
answer
96
views
How to ensure the values set in the CSV are captured within the GeoJSON feature values when merging CSV attributes into a GeoJSON
I create a GeoJSON but the merged values are null. The length of the datasets do not match -- is this a potential issue? If so, how do I merge for all covid matches. (FYI this isnt Covid19 related COV ...
7
votes
3
answers
2k
views
Reading GeoJSON-String from CSV as Geometry in QGIS
I have a CSV which contains the geometry information as a GeoJSON string, e.g.
{ "type": "MultiLineString",
"coordinates": [
[[10, 10], [20, 20], [10, 40]],
...
1
vote
2
answers
702
views
Leaflet markers from CSV with multiple columns employing omnivore [duplicate]
Goal: Show markers for lat-lon positions from a CSV file. The other columns need to be placed in pop-up as attributes.
CSV file can be seen at: airport.csv
Code:
headers = ['iata', 'title', 'city', ...
4
votes
1
answer
284
views
Join non-spatial CSV to GeoJSON data source using ogr2ogr and SQLite dialect
I am attempting to do a simple join of a non-spatial CSV file to a GeoJSON data source using the built-in SQL capabilities in ogr2ogr. I have successfully managed to do this using the OGR SQL dialect ...
2
votes
1
answer
596
views
Join a CSV file to GeoJSON using ogr2ogr in a Python script?
I have a CSV which I would like to join to a GeoJSON.
I found this answer which I tried to implement but I can't get it to work just yet.
Here's an extract of my python:
join_command = ['ogr2ogr', '...