[gdal-dev] Error in Derived Band in Virtual raster

2019-12-01 Thread bhandari
Hell All I have defined a derived Virtual Raster as follows. GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433],AUTHORITY["EPSG","4326"]] 7.8318056012634287e+

Re: [gdal-dev] Spatialite functions missing when reading GeoPackage

2019-12-01 Thread Jürgen E . Fischer
Hi Jukka, On Sun, 01. Dec 2019 at 19:40:46 +, Rahkonen Jukka (MML) wrote: > This works with GDAL from OSGeo4W, GDAL 3.0.2, released 2019/10/28 > > ogrinfo any.gpkg -dialect sqlite -sql "select spatialite_version()" > INFO: Open of `any.gpkg' > using driver `GPKG' successful. > > Layer

Re: [gdal-dev] ogr2ogr: strange results joininig non-spatial CSV to spatial data using SQLite dialect

2019-12-01 Thread aborruso
It works, thank you very much -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Spatialite functions missing when reading GeoPackage

2019-12-01 Thread Even Rouault
Hi Jukka, > Obviously mod_spatialite is not loaded in the gpkg case but I wonder if the > issue is in GDAL-dev or in the gisinternals build. Probably in gisinternals. I've submitted this (untested) patch to it: https://github.com/gisinternals/buildsystem/pull/148 Even -- Spatialys - Geospatial

[gdal-dev] Spatialite functions missing when reading GeoPackage

2019-12-01 Thread Rahkonen Jukka (MML)
Hi, This works with GDAL from OSGeo4W, GDAL 3.0.2, released 2019/10/28 ogrinfo any.gpkg -dialect sqlite -sql "select spatialite_version()" INFO: Open of `any.gpkg' using driver `GPKG' successful. Layer name: SELECT Geometry: None Feature Count: 1 Layer SRS WKT: (unknown) spatialite_version

Re: [gdal-dev] ogr2ogr: strange results joininig non-spatial CSV to spatial data using SQLite dialect

2019-12-01 Thread Even Rouault
> Why do I not have three rows of result using simply join? You just hit a long-standing bug. Restricted when the joint layer is in a format like CSV that has no fast feature count capability. Just fixed in master and backported to 3.0 and 2.4 branches Even -- Spatialys - Geospatial profession

[gdal-dev] ogr2ogr: strange results joininig non-spatial CSV to spatial data using SQLite dialect

2019-12-01 Thread aborruso
Hi, I have this geosjon (map.geojson) { "type": "FeatureCollection", "features": [ { "type": "Feature", "properties": {"id": 1}, "geometry": { "type": "Point", "coordinates": [-78.653, 35.7874] } }, { "type": "Feature", "propertie

Re: [gdal-dev] geojson to shp and vice versa

2019-12-01 Thread Kristijan Cindrić
Thanks Richard, in the end I opted for a client side solution ( https://github.com/calvinmetcalf/shapefile-js) which handles geometry collections with multiple geometry types great. Chtis ned, 1. pro 2019. u 03:36 Richard Greenwood napisao je: > I don't know anything about iterating thru a .zi