Timeline for Is there any easy way of transforming the result of a SpatiaLite query on GeoJSON?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 7, 2021 at 19:26 | comment | added | user30184 | The SQLite dialect actually imports the data from the shapefile into a temporary SQLite database and the connection to the native .qix index is lost. It might be used with more simple use case like running ogr2ogr with -spat option, but maybe not even then. | |
| May 7, 2021 at 15:13 | vote | accept | raylight | ||
| May 7, 2021 at 15:13 | comment | added | raylight |
About the query, I've tried creating a new Shapefile and SpatiaLite database changing the projection with -s_srs EPSG:31983 -t_srs EPSG:4326 and took out the 4326 from the ST_GeomFromText function, but for some reason it was not working... This is actually an issue I'm trying to solve. But using this query this way is the only way that is working so far (I can see the circle when I convert it to Shapefile and I open it with QGIS).
|
|
| May 7, 2021 at 15:09 | comment | added | raylight |
Thanks! The first command solved the issue for me... Actually, I know that I can create an index as a .qix file from a Shapefile. But apparently I can't use this index together with the SQLite SQL dialect. So in my particular case, the case was taking 6 seconds to finish. The original answer of the question I've mentioned talked about creating an index for the Shapefile. But the final conclusion was that it was not possible. That's why I was trying with SpatiaLite now.
|
|
| May 7, 2021 at 10:20 | history | edited | user30184 | CC BY-SA 4.0 |
added 364 characters in body
|
| May 7, 2021 at 10:03 | history | answered | user30184 | CC BY-SA 4.0 |