Re: [gdal-dev] Ogr2ogr, SQLite and overwriting existing database

. ERROR 1: sqlite driver failed to create foo.sqlite -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 9. toukokuuta 2018 19:43 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Aihe: Re: [gdal-dev] O

[gdal-dev] Ogr2ogr, SQLite and overwriting existing database

Hi, What is the expected behavior if user asks ogr2ogr to create a SQLite database that already exists? The driver page http://www.gdal.org/drv_sqlite.html tells that "The SQLite driver supports creating new SQLite database files, or adding tables to existing ones. Note that a new database

[gdal-dev] OGR_STYLE BRUSH(fc:#0000FF) converts into MapInfo Brush (1, 255)

Hi MITAB-folks, See this: https://gis.stackexchange.com/questions/281584/export-to-tab-with-styling-using-ogr2ogr Is it right or wrong to convert blue fill into Brush (1,255)? -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] Quete_string_fields creation option for CSV

Even Rouault wrote: Re: [gdal-dev] Quete_string_fields creation option for CSV   > Actually I've reworked this to be   > STRING_QUOTING=IF_NEEDED/IF_AMBIGUOUS/ALWAYS (Starting with GDAL 2.3): > whether to double-quote strings. IF_AMBIGUOUS means that string values that > look like numbers will

[gdal-dev] Quete_string_fields creation option for CSV

Hi, See this https://gis.stackexchange.com/questions/279960/ogr2ogr-create-csv-with-strings-wrapped-in-double-quotes The GDAL CSV driver supports quoted string fields in reading but I suppose that data can't be written like that. -Jukka Rahkonen-

Re: [gdal-dev] GDAL can't open MBTiles sample from the MapBox site

eo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] GDAL can't open MBTiles sample from the MapBox site On mercredi 28 mars 2018 14:28:14 CEST Rahkonen Jukka (MML) wrote: > Hi, > On page https://www.mapbox.com/help/define-mbtiles/ there is a link into > https://www.mapbox.com/help/data

[gdal-dev] GDAL can't open MBTiles sample from the MapBox site

Hi, On page https://www.mapbox.com/help/define-mbtiles/ there is a link into https://www.mapbox.com/help/data/trails.mbtiles My GDAL 2.3.0dev does list MBTiles as a supported format but it can't still open this database gdalinfo trails.mbtiles ERROR 4: `trails.mbtiles' not recognized as a

[gdal-dev] Adding WRITE_ID creation option for GeoJSON

Hi, Am I right that there is no option to force the writing of "id" member to GeoJSON features? I have noticed that if I run ogr2ogr with -preserve_fid option then the "id" member is added { "type": "Feature", "id": 0, "properties": However, if I don't use -preserve_fid I have not discovered

Re: [gdal-dev] Motion: adopt RFC 71: Migration to GitHub

+1 -Jukka Rahkonen- > Hi, > I move to adopt RFC 71: Migration to GitHub https://trac.osgeo.org/gdal/wiki/rfc71_github_migration > Starting with my +1, > Best regards, > Even ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] Motion: promote GDAL 2.2.4 RC1 for release

+1 -Jukka Rahkonen- >> Motion: promote GDAL 2.2.4 RC1 for release > Friendly nudge to PSC members to please cast their votes. > Even ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] Any good alternative for the Timeline of Trac available in GitHub?

Hi, I see that GDAL is going to move into GitHub. What I will certainly miss it the Timeline of Trac. For a curious reader like me it gives an excellent view to anything that happens in the project. Is it so that the closest to Timeline that GitHub can offer is the Pulse view (for example

Re: [gdal-dev] Validate_gpkg and TEXT with length

Even Rouault wrote: >Jukka,   >> >> I checked some .gpkg database that is created by FME with the >> validate_gpkg.py script. It gives this error: >> >> __main__.GPKGCheckException: Req 5: table stand has column >> standnumberextension of unexpected type TEXT ( 2 ) >> >> Excerpt from the

[gdal-dev] Validate_gpkg and TEXT with length

Hi, I checked some .gpkg database that is created by FME with the validate_gpkg.py script. It gives this error: __main__.GPKGCheckException: Req 5: table stand has column standnumberextension of unexpected type TEXT ( 2 ) Excerpt from the standard: TEXT{(maxchar_count)} Variable length string

Re: [gdal-dev] QGIS3 - Save Map as Image dialog bug?

, some user may know the answer for you, your problem may teach something for other users, and in the ideal world the developers are also reading the users mails. -Jukka Rahkonen- Lähettäjä: Idan Miara [mailto:i...@miara.com] Lähetetty: 1. maaliskuuta 2018 12:34 Vastaanottaja: Rahkonen Jukka (MML

Re: [gdal-dev] Check validity of geometries before writing them into vector tiles?

Even Rouault wrote: > Perhaps you could play with the SIMPLIFICATION and SIMPLIFICATION_MAX_ZOOM > options ? Sure, as I wrote I admit that my test did not make much sense, but trying things before reading the manual sometimes reveals something interesting.   > Perhaps you should also use an

[gdal-dev] Check validity of geometries before writing them into vector tiles?

Hi, I admit that my test was somewhat lunatic but I took some random dataset from Finland with 68101 polygons and converted data into MVT with default settings which means that minzoom was 0. As a result 12196 of the source polygons were written into the 0-level protobuf tile (in EPSG:3067

Re: [gdal-dev] Vector Tiles in OGR

Even Rouault wrote: >On mardi 13 février 2018 02:06:47 CET jratike80 wrote: >> Even Rouault-2 wrote >> >> > On lundi 22 janvier 2018 23:40:55 CET Even Rouault wrote: >> >> Hi, >> >> >> >> > P.S. @Even: Any news on a GDAL/OGR MVT reader? >> >> >> >> Yes, a new OGR MVT reader has just been

Re: [gdal-dev] Does ogr2ogr -overwrite truncate also the spatial index in GeoPackage?

Hi, That was the case, once I updated into recent trunk the error message disappeared. -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 6. helmikuuta 2018 14:54 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.ra

[gdal-dev] Does ogr2ogr -overwrite truncate also the spatial index in GeoPackage?

Hi, Title says most of it. Running "ogr2ogr -f gpkg -update -overwrite" for a vector table in GeoPackage gives an error: ERROR 1: Spatial index already existing I wonder if the overwrite mode still does the right thing. Is the R-Tree table truncated automatically by the triggers together with

[gdal-dev] Cloud Optimized Vectors?

Hi, Cloud optimised tiffs hosted on a HTTP file server work pretty well without a need to set up a special tile/WMS/WCS server https://trac.osgeo.org/gdal/wiki/CloudOptimizedGeoTIFF That made me think that how would a Cloud Optimized vector format look like? Obviously it should offer fast

Re: [gdal-dev] Why gdal_rasterize fails with MBTiles output?

to believe that there is something wrong with srs of input vectors. -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 18. joulukuuta 2017 13:12 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Aihe: Re: [gdal-dev] Why gdal

[gdal-dev] Why gdal_rasterize fails with MBTiles output?

Hi, Captured from gis.stackexchange https://gis.stackexchange.com/questions/264899/create-mbtiles-from-geojson-in-raster-format I made some test data in EPSG:3857 and while GeoTIFF output works fine with GDAL 2.3dev gdal_rasterize -ot Byte -burn 255 -burn 0 -burn 0 -ts 4950 4950 -of GTiff

[gdal-dev] Sub-optimal access to cloud optimized GeoTIFF

Hi, This image http://193.166.24.122/gtk/mp_50_750.tif should be prepared as adviced in https://trac.osgeo.org/gdal/wiki/CloudOptimizedGeoTIFF and the validation script agrees on that. python c:\temp\validate_cloud_optimized_geotiff.py mp_50_750.tif Result:

[gdal-dev] Wiki page for WCS discussion and best practices created

Hi, As an initial step I created a new page about WCS into the developers section of the GDAL wiki https://trac.osgeo.org/gdal/wiki/WCS%2Binteroperability I suppose that all who have OSGeo user account can edit the page. -Jukka Rahkonen- ___

[gdal-dev] Question about GeoPackage and views

Hi, I was reading the GeoPackage standard and only now read carefully the requirement 29 "A GeoPackage MAY contain tables or updateable views containing vector features. Every such feature table or view in a GeoPackage SHALL have a column with column type INTEGER and 'PRIMARY KEY

[gdal-dev] VRT KernelFilteredSource and overviews

Hi, I was playing with kernel filters in VRT and using this really applies sharpen filter on-the-fly when looking the image at native resolution with QGIS: Red image.tif 1 3 0 -1 0 -1 5 -1 0 -1 0 However,

Re: [gdal-dev] Gdal_edit and TIFFTAG_EXTRASAMPLES

- Lähettäjä: Even Rouault <even.roua...@spatialys.com> Lähetetty: 1. lokakuuta 2017 22:54 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] Gdal_edit and TIFFTAG_EXTRASAMPLES Updates: 1) I've improved the GTiff

[gdal-dev] Gdal_edit and TIFFTAG_EXTRASAMPLES

Hi, I have been searching an easy way to change the interpretion of 4-channel images between RGBA and RGB+undefined. Wouldn't if be useful to make gdal_edit to support also changing the TIFFTAG_EXTRASAMPLES metadata? Or do we have some other easy way for performing that task? -Jukka Rahkonen-

[gdal-dev] KML recognized as GML by ogr2ogr

Hi, See https://gis.stackexchange.com/questions/256861/kml-to-shapefile-problems-ogr2ogr I have verified with todays GDAL 2.3.0dev from gisinternals that ogrinfos open the KML file form that question with LIBKML driver while ogr2ogr opens it with GML driver and fails. -Jukka Rahkonen-

[gdal-dev] ESRI json REST service and first page of data

Hi, Based on https://gis.stackexchange.com/questions/256668/ogr2ogr-get-geojson-from-map-server-misses-features-and-creates-duplicates it is possible that ESRI REST service may return different first features when query is sent without "resultRecordCount" and "resultOffset" than if the query

[gdal-dev] Case sensitive open option in GMLAS?

Hi, I get this error with GMLAS driver and "-oo remove_unused_layers=yes" Warning 6: driver GMLAS does not support open option remove_usused_layers Warning disappears with -oo REMOVE_UNUSED_LAYERS=yes. The very similar open option "-oo remove_unused_fields" does not give an error. -Jukka

[gdal-dev] How to read CSV with GeoJSON correctly?

Hi, I was thinking about this question on gis.stackexchange https://gis.stackexchange.com/questions/254536/how-to-convert-txt-containing-two-columns-id-and-geojson-geometry I copy-pasted the CSV example and edited it to use semicolon as field separator. Then I read

[gdal-dev] Tilesize in JPEG2000 and gdalinfo

Hi, If I run gdalinfo against the JPEG2000 image in http://kartat.kapsi.fi/files/orto/etrs-tm35fin/mara_v_25000_50/2013/N53/02m/1/N5144H.jp2 the JP2ECW driver reports the blocksize as (256x256) and JPEG2000OpenJPEG driver reports that the block size is (1024x1024). What interests me would be

Re: [gdal-dev] Geopackage raster and COPY_SRC_OVERVIEWS

overviews. Let's see if someone appears with funding or just implements it. -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 28. elokuuta 2017 15:03 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Aihe: Re: [gd

[gdal-dev] Geopackage raster and COPY_SRC_OVERVIEWS

Hi, I wonder if it could be feasible to support similar COPY_SRC_OVERVIEWS option than GeoTIFF driver does for existing overview levels which match with the power of two series. Some people have constructed GeoTIFFs or virtual VRT rasters which have overviews from different raster sources

Re: [gdal-dev] Schema of gpkg_metadata in Geopackage

oua...@spatialys.com> Lähetetty: 23. elokuuta 2017 16:55 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] Schema of gpkg_metadata in Geopackage On mercredi 23 août 2017 13:33:07 CEST Rahkonen Jukka (MML) wrote: > Hi, > > GDAL 2.3-dev creates gpkg

[gdal-dev] Schema of gpkg_metadata in Geopackage

Hi, GDAL 2.3-dev creates gpkg_metadata table as CREATE TABLE gpkg_metadata (id INTEGER CONSTRAINT m_pk PRIMARY KEY ASC NOT NULL UNIQUE,md_scope TEXT NOT NULL DEFAULT 'dataset',md_standard_uri TEXT NOT NULL,mime_type TEXT NOT NULL DEFAULT 'text/xml',metadata TEXT NOT NULL DEFAULT ''); In GPKG

[gdal-dev] How to drop a raster layer from GeoPackage?

Hi, There is an interesting question in gis.stackexchange about how to remove a raster layer from GeoPackage https://gis.stackexchange.com/questions/252782/remove-a-raster-from-geopackage. I had a try and gdalmanage did not have any effect on the GeoPackage database but the workflow with

Re: [gdal-dev] Autodetect "0012" as string in CSV

-Jukka- Lähettäjä: Even Rouault <even.roua...@spatialys.com> Lähetetty: 18. elokuuta 2017 14:30 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] Autodetect "0012" as string in CSV On vendredi 18 août 20

[gdal-dev] Autodetect "0012" as string in CSV

Hi, The schema of a CSV file like this "00012",012345,1234,234.65,"text" is autodetected this way: ogrinfo csvtext.csv -oo autodetect_type=yes -al INFO: Open of `csvtext.csv' using driver `CSV' successful. Layer name: csvtext Geometry: None Feature Count: 1 Layer SRS WKT: (unknown)

[gdal-dev] Interesting issue with ogr2ogr and -tps

Hi, There is a well written question in gis.stackexchange about how the -tps option in ogr2ogr behaves https://gis.stackexchange.com/questions/245391/ogr2org-tps-spline-method-creates-progressive-error Does anybody have a clue about what happens? -Jukka Rahkonen-

Re: [gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile

Hmm, but how about other formats? Is there some general workaround? For example conversion into shapefiles fails because of this error while geopackage seems to be OK. -Jukka- Lähettäjä: Rahkonen Jukka (MML) Lähetetty: 19. toukokuuta 2017 18:32 Vastaanottaja: 'Even Rouault' <even.r

Re: [gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile

Hi, That's it. I think I should have known to read carefully the PG driver manual http://www.gdal.org/drv_pg.html. -Jukka- Even Rouault wrote: Re: [gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile On vendredi 19 mai 2017 15:15:02 CEST Rahkonen Jukka (MML) wrote: >

[gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile

Hi, See this gis.stackexchange question https://gis.stackexchange.com/questions/240900/shp2pgsql-segmentation-fault. I have confirmed that Europe_coastline.shp from this zip

Re: [gdal-dev] Wrong namespaces in GML 3.2 written by GDAL

the noise. -Jukka- Even Rouault wrote: Re: [gdal-dev] Wrong namespaces in GML 3.2 written by GDAL On jeudi 27 avril 2017 17:01:27 CEST Rahkonen Jukka (MML) wrote: > Hi, > > With GML 3.2 output GDAL 2.2-dev writes into the schema > > xmlns:gml="http://www.opengis.net/g

[gdal-dev] Wrong namespaces in GML 3.2 written by GDAL

Hi, With GML 3.2 output GDAL 2.2-dev writes into the schema xmlns:gml="http://www.opengis.net/gml/3.2; xmlns:gmlsf="http://www.opengis.net/gmlsf/2.0; The first one redirects to http://schemas.opengis.net/gml/3.2.1/gml.xsd. The latter one gives "Not found". I guess that the schema is nowadays in

Re: [gdal-dev] SQLite-SQL problem with some layer names

Hi, Hi, I had a try with editing the .dox file that is used for generating http://www.gdal.org/ogr_sql_sqlite.html with changeset #37971. Could you check if the text makes sense and appears right? -Jukka-

[gdal-dev] SQLite-SQL problem with some layer names

Hi, I have problems in using the SQLite dialect if layer names contains numbers or underscores. I am on Windows. ogrinfo -dialect sqlite 3d.shp -sql "select * from 3d" INFO: Open of `3d.shp' using driver `ESRI Shapefile' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select * from

Re: [gdal-dev] [Geoserver-devel] GML lat-lon coverages and interoperability

Hi, Even wrote: However I'm not sure in which way GDAL is involved in this discussion :-) I am preparing for the future when GDAL will have a support for WCS 2.0.1 and it will try to read EPSG:4326 coverage data from GeoServers witch describe coverage like this:

Re: [gdal-dev] GML lat-lon coverages and interoperability

23:03 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML); Andrea Aime; geoserver-de...@lists.sourceforge.net Aihe: Re: [gdal-dev] GML lat-lon coverages and interoperability On lundi 3 avril 2017 13:19:18 CEST Rahkonen Jukka (MML) wrote: > Great, first hit from Andrea. I am

Re: [gdal-dev] GML lat-lon coverages and interoperability

61.7282236) ( 24d50'32.16"E, 61d43'41.61"N) -Jukka- Lähettäjä: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Puolesta Andrea Aime Lähetetty: 3. huhtikuuta 2017 16:31 Vastaanottaja: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Kopio: 'gdal-dev@lists.osgeo.org' (

Re: [gdal-dev] GML lat-lon coverages and interoperability

3. huhtikuuta 2017 15:58 Vastaanottaja: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Kopio: 'gdal-dev@lists.osgeo.org' (gdal-dev@lists.osgeo.org) <gdal-dev@lists.osgeo.org>; geoserver-de...@lists.sourceforge.net Aihe: Re: [gdal-dev] GML lat-lon coverages and interoperabi

[gdal-dev] GML lat-lon coverages and interoperability

Cross posting intentionally. TL;DR I wonder if all projects under the OSGeo umbrella, starting from GDAL and Geoserver, could make a common agreement on not to use GridFunctions in GML coverages if they are not strictly needed. The other alternative would be to make all projects to support

Re: [gdal-dev] Ogrinfo does not open any more raster-only geopackage

Even Rouault wrote: Re: [gdal-dev] Ogrinfo does not open any more raster-only geopackage > Hi Jukka, > I could only reproduce with a .gpkg that didn't have a gpkg_geometry_columns > table. Which is valid, but not what GDAL creates, so I guess this comes from > another software ? That

[gdal-dev] Ogrinfo does not open any more raster-only geopackage

Hi, Recent GDAL 2.2-dev versions can't open geopackage that contains only raster data. ogrinfo -ro -sql "PRAGMA journal_mode" raster.gpkg I found a 2.2-dev version from 2016-12-09 and that does run my PRAGMA query. Could it be possible to get this possibility back? -Jukka Rahkonen-

[gdal-dev] GeoPackege, views and spatial index

Hi, I can create a spatial view into GeoPackage database by following the document http://www.geopackage.org/modeling_guidelines.html and I can open such a view with QGIS. But have I understood right that there is no way in GeoPackage to link the R-Tree spatial index of the main table with the

Re: [gdal-dev] sqlite -> spatialite (rowid)

kuuta 2017 18:01 Vastaanottaja: Rahkonen Jukka (MML) Kopio: Even Rouault; gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] sqlite -> spatialite (rowid) On Tue, 7 Mar 2017 15:07:04 +0000, Rahkonen Jukka (MML) wrote: > Hi, > > I have a slight feeling that there may be some trouble if attribute

Re: [gdal-dev] sqlite -> spatialite (rowid)

test also cases where ROWID differs from OID and _ROWID_? -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 7. maaliskuuta 2017 16:51 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi>; a.furi...@lqt.it Aih

[gdal-dev] WFS driver and GML application schema

Hi, What if a WFS server is returning GML that has complex schema, does GDAL know to open the response as GML application schema data automatically or with some open option? I ask because I can see "succeeds as GML" in the debug log: HTTP:

[gdal-dev] Reading SQLite in WAL mode as read-only

Hi, I saw this changeset https://trac.osgeo.org/gdal/changeset/37594 and started to think that how GDAL is reading SQLite db that is in WAL journal mode from zip, tar, vsicurl or from non-writeble directory if it is documented to be generally not possible http://www.sqlite.org/draft/wal.html?

Re: [gdal-dev] Testing of OGR generated GeoPackage datasets with other implementations

Hi Right, ne_10m_admin_0_countries_france_no_ogr_feature_count.gpkg opens with MapInfo 15.2. -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 2. maaliskuuta 2017 15:49 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.ra

[gdal-dev] FW: Don't we have any ideas for GSoC 2017?

tps://aka.ms/ghei36> From: gdal-dev <gdal-dev-boun...@lists.osgeo.org<mailto:gdal-dev-boun...@lists.osgeo.org>> on behalf of Casper Børgesen (CABO) <c...@niras.dk<mailto:c...@niras.dk>> Sent: Tuesday, February 28, 2017 5:16:19 AM To: R

[gdal-dev] Don't we have any ideas for GSoC 2017?

Hi, OSGeo is accepted as an organization for the Google Summer of Code 2017 but there are no GDAL related ideas on https://wiki.osgeo.org/wiki/Google_Summer_of_Code_2017_Ideas. Could we raise some of the old ideas or discover some brand new ones? -Jukka Rahkonen-

[gdal-dev] Precision of classification in gdal_sieve.py

Hi, See this gis.stackexchange question about gdal_sieve http://gis.stackexchange.com/questions/227709/why-is-all-0-after-using-gdal-sieve-on-a-raster-layer. By the documentation http://www.gdal.org/gdal_sieve.html it is not clear with which precision the pixels are classified to have the same

Re: [gdal-dev] GMLAS does not resolve schema from WFS data

beFeatureType=application%2Fgml%2Bxml%3B+version%3D3.2=cp:CadastralParcel=xmlns(cp,http%3A%2F%2Finspire.ec.europa.eu%2Fschemas%2Fcp%2F4.0) -Jukka- Even Rouault wrote: Re: [gdal-dev] GMLAS does not resolve schema from WFS data On mercredi 18 janvier 2017 10:52:28 CET Rahkonen Jukka (M

[gdal-dev] GMLAS does not resolve schema from WFS data

Hi, I downloaded one CadastralParcel from an INSPIRE service with curl curl -k -o inspire-cp.gml "https://inspire-wfs.maanmittauslaitos.fi/inspire-wfs/cp?service=WFS=2.0.0=GetFeature=cp:CadastralParcel=1; Then I tried to check what I have with ogrinfo but it fails ogrinfo GMLAS:inspire-cp.gml

Re: [gdal-dev] Wrong interpretation of DIMENSION features in GDAL DXF driver

Sorry, Nabble did not include my ogr2ogr command to the mailing list mail, reposting. You can do the join as suggested in http://www.geopackage.org/modeling_guidelines.html by converting the first geometry with all the attributes into GeoPackage as you have done, and then adding another

[gdal-dev] Creating JPEG compressed external overviews fails

Hi, This has worked for me and still works with GDAL version GDAL 2.0dev, released 2011/12/29 gdaladdo -r average -ro --config COMPRESS_OVERVIEW JPEG --config PHOTOMETRIC_OVERVIEW YCBCR --config INTERLEAVE_OVERVIEW PIXEL input.tif 2 4 8 16 32 64 However, GDAL 2.2.0dev, released 2016/99/99

Re: [gdal-dev] Call for discussion on RFC 64: Triangle, Polyhedral surface and TIN

Hi, Perhaps some problem with markup, the WKT dows show in Nabble http://osgeo-org.1560.x6.nabble.com/gdal-dev-Call-for-discussion-on-RFC-64-Triangle-Polyhedral-surface-and-TIN-tc5298840.html MULTIPOLYGON ((( 553 352, 327 363, 442 486, 553 352 )), (( 327 363, 553 352, 422 186, 327 363 )))

Re: [gdal-dev] How does GDAL OSM driver deal with closed ways?

Djordje Spasic wrote: I will definitively read through the links you gave me Jukka. Thank you. Until then, do you mind if I ask just for a tiny clarification? > The default rendering style file has such a list https://github.com/openstreetmap/osm2pgsql/blob/master/default.style Is this the

Re: [gdal-dev] osm_id vs osm_way_id?

Hi, ogr2ogr creates these ids: - for point data node_id becomes ”osm_id” - for linestrings way_id becomes “osm_id” - for multilinestrings relation_id becomes “osm_id” - for other relations relation_id becomes “osm_id” - for polygons which come

[gdal-dev] Append new data to GeoPackege raster table as overview

Hi, Let's say that I have these raster maps with 2048 m and 1024 m pixel sizes http://kartat.kapsi.fi/files/taustakarttasarja_jhs180/taustakartta_8m/2048m/etrs89/png/Taustakartta_8milj.png

Re: [gdal-dev] How does WMTS driver detect DataWindow?

Hi, I got to understand why WMTS service has so large WGS84 bounding box in GetCapabilities. It is because the native EPSG:3067 bounding box is first converted into WGS84 by using a densified polygon geometry. The WGS84BoundingBox is then the envelope of this warped polygon. Because of

Re: [gdal-dev] How does WMTS driver detect DataWindow?

@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> Aihe: Re: [gdal-dev] How does WMTS driver detect DataWindow? On lundi 28 novembre 2016 15:33:31 CET Rahkonen Jukka (MML) wrote: > Hi, > > While playing with gdal_translate and WMST my colleague

[gdal-dev] ElasticSearch and native geometry

Hi, What if somebody would like to use ElasticSearch for queries but still somehow get the native geometries included in the output? The geometry must be re-projected into EPSG:4326 for creating either geo_point or geo_shape, but can anybody suggest a clever way for saving the native

[gdal-dev] Question about how GDAL makes an ElasticSearch index

Hi, It seems that all examples about how to query ElasticSearch with GDAL in http://www.gdal.org/drv_elasticsearch.html are failing with ElasticSearch versions 2.x. Reason is the breaking change "A field can no longer be referenced using its short name. Instead, the full path to the field is

[gdal-dev] GDAL and ElasticSearch 5.0

Hi, I tried to test new ElasticSearch version with no success and I wonder what is wrong. My command and debug data follows. ogr2ogr -f "ElasticSearch" http://localhost:9200 -s_srs epsg:3067 -t_srs epsg:4326 test_es50.shp --debug on GDAL: GDALOpen(test_es50.shp, this=02454920)

Re: [gdal-dev] Why are fields required in osmconf.ini file?

You need to have both: include all_tags in osmconf.ini and define with the ogr2ogr command that field “all_tags” in PostGIS should be initialized as hstore. If you do not define column type all_tags will probably become text type column. Make a test and you will see it. -Jukka Rahkonen-

Re: [gdal-dev] Ogr2ogr -dim and Oracle

Hi, Probably SDO_COORD_REF_SYS is what to use nowadays even I guess that it points to MDSYS tables. Looks like something has changed with Oracle 10.2 and I believe that it is very hard to use so old Oracle version without paying much extra.

Re: [gdal-dev] Ogr2ogr -dim and Oracle

Hi, I would also check how ogr2ogr options –a_srs and –t_srs behave or if the OCI driver option –lco SRID is still needed. -Jukka- Lähettäjä: Michael Smith [mailto:michael.smith.e...@gmail.com] Lähetetty: 17. marraskuuta 2016 13:49 Vastaanottaja: Rahkonen Jukka (MML) <jukka.ra

[gdal-dev] Ogr2ogr -dim and Oracle

Hi, I noticed that Even was editing the ogr2ogr help about the -dim parameter and remembered that I think that it does not have an effect on the OCI driver. For forcing a new Oracle table into 2D you must use the OCI drivers own layer creation option "DIM" instead

Re: [gdal-dev] How to replace an osm key?

web while I am not. SQL is so close to English and that you can think that you are making a (comma separated) shopping list “SELECT milk,bread,juice FROM Wal-Mart”. -Jukka- Lähettäjä: Djordje Spasic [mailto:issworld2...@yahoo.com] Lähetetty: 14. marraskuuta 2016 17:21 Vastaanottaja

Re: [gdal-dev] How to replace an osm key?

uot; And they both work. The problem is that: once the .shp file is created, and I open it, all shapes have the "building:level" value for the "bldg_level" field. Here is a screenshot: https://www.dropbox.com/s/nmlkkzr85w225qb/sql_choosing_keys.jpg?dl=0 Why is this ha

Re: [gdal-dev] How to replace an osm key?

;no such column: height" error message raised? Is something wrong with the SQL syntax? Thank you for the reply. Kind regards, Djordje ---- On Friday, November 11, 2016 6:46 PM, Rahkonen Jukka (MML) <jukka.rahko...@maanmittauslaitos.fi> wrote: Hi, If you se

Re: [gdal-dev] How to replace an osm key?

Lähettäjä: Djordje Spasic<mailto:issworld2...@yahoo.com> Lähetetty: ‎11.‎11.‎2016 19:10 Vastaanottaja: Rahkonen Jukka (MML)<mailto:jukka.rahko...@maanmittauslaitos.fi>; gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> Aihe: Re: [gdal-dev] How to replace an osm key? Thank y

Re: [gdal-dev] How to replace an osm key?

on points and relations (other_relations for GDAL). I also aimed at a general answer that could be useful for all tags and layers in OSM data. -Jukka Rahkonen- Lähettäjä: Djordje Spasic [mailto:issworld2...@yahoo.com] Lähetetty: 11. marraskuuta 2016 16:38 Vastaanottaja: Rahkonen Jukka (MML

Re: [gdal-dev] How to replace an osm key?

Hi, Ogrinfo and ogr2ogr usually accept the same syntax and therefore I gave the ogrinfo example. I apologize, it can’t be self-evident for all GDAL users. You can do the whole thing with one command like this: ogr2ogr.exe --config OSM_USE_CUSTOM_INDEXING NO -skipfailures -f "ESRI Shapefile"

[gdal-dev] Make gdal_polygonize to support the mask band

Hi, Once again someone wants to get the footprints of valid data in images http://gis.stackexchange.com/questions/216624/creating-a-shapefile-for-footprint-of-tasters-valid-data-areas-with-gdal. A year ago, in here https://lists.osgeo.org/pipermail/gdal-dev/2015-October/042859.html Even

[gdal-dev] Attach database and GeoPackage

Hi, I have been thinking that it could be nice to be able to open GeoPackage with attached database https://www.sqlite.org/lang_attach.html. Attaching database that contains spatial tables would probably give too much troubles because reading the spatial metadata of the attached db through the

[gdal-dev] Should GDAL handle this KML superoverlay?

Hi, I have some images which are georeferenced with a KML file and they show fine with Google Earth. However, GDAL does not know what to do with them. I put some test data here: http://latuviitta.org/downloads/shaded.kmz http://latuviitta.org/downloads/shaded.kml

[gdal-dev] Ogr and long list of errors due to missing SQLite module

Hi, If a GeoPackage file is touched with recent Spatialite-gui it creates automatically a virtual GPKG table for each native spatial GPKG table. If I now use ogrinfo or ogr2ogr with such database it will print an error for each virtual layer like ERROR 1: no such module: VirtualGPKG Warning

[gdal-dev] RFC 64 wiki page is empty

Hi, There is no contents in https://trac.osgeo.org/gdal/wiki/rfc64_triangle_polyhedralsurface_tin but it would be nice to have something. I suppose that RFC was defined and implemented in https://github.com/avyavkumar/gdal/wiki -Jukka Rahkonen- ___

[gdal-dev] Gdal_grid with a mask layer?

Hi, I have depth data from a lake as scattered points and I would like to convert them into raster DEM. Unfortunately this lake is not a rectangular, north oriented one but it has a curvy shoreline and lots of islands. In my first trials the resulting DEM leaks away from the water to the dry

[gdal-dev] GPKG: Drop table but how to drop the rest?

Hi, I wonder if it could be possible to do something like "DROP CASCADING" in GeoPackage and delete the spatial index by the same. It will for sure be unusable once the table is dropped. I feel that SQLite does not support that because cascading drop seems to require that parent and child

Re: [gdal-dev] Preserve Source Raster Resolution When Merging

Sam Wilson wrote: > Hi, > I'm attempting to merge (or maybe the proper term is mosaic) overlapping > raster datasets of varying resolutions. I'd like to have the higher > resolution datasets override the lower resolution datasets where available. > I've been able to get close using various

Re: [gdal-dev] Issues with MapInfo Conversion to GeoJson using ogr2ogr

Suman Humagain wrote: > Hi folks, > I am converting the Mapinfo files to GeoJson format using the ogr2ogr tool. > The things are working great and its converting fine but i am getting > different polylines than i have drawn in the mapinfo. Some extra polylines > are created in the intersections.

Re: [gdal-dev] Motions: Promote 1.11.5 RC 1, 2.0.3 RC2 and and 2.1.1 RC2 for release

+1 for all three. -Jukka Rahkonen- Lähettäjä: Even Rouault<mailto:even.roua...@spatialys.com> Lähetetty: ‎12.‎7.‎2016 12:15 Vastaanottaja: Rahkonen Jukka (MML)<mailto:jukka.rahko...@maanmittauslaitos.fi> Aihe: Fwd: [gdal-dev] Motions: Promote 1.11.5

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Andrea wrote: >Hi Jukka, >Rahkonen Jukka (MML) wrote >> Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN >> bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is >> not mentioned in a bunch of documents

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Andrea Borruso wrote: >thank you very much. I had read that page, but stupidly I did not think >that "ALTER TABLE tablename ADD [COLUMN] columnname columntype" meant >strictly that I could only use it in this way. >My wrong intepretion was that I could use "alter table add" SQL command >and its

Re: [gdal-dev] How to append to all layers with ogr2ogr?

Hi, Did you try to add another GML file into existing GeoPackege? First run OK: ogr2ogr -f gpkg -update -append mtk.gpkg /vsizip/K2344R_mtk.zip Secong run gives an error: ogr2ogr -f gpkg -update -append mtk.gpkg /vsizip/K2433L_mtk.zip ERROR 1: Layer Kunta already exists, and -append not

<    1   2   3   4   >