Re: [gdal-dev] Converting WFS to shapefile

Hi, Run ogrinfo WFS:https://geodata.nationaalgeoregister.nl/aan/wfs and you'll see 1: aan:aan (title: aan) (Multi Surface) Use the typeName as it appears. Works for me with ogr2ogr -f "ESRI Shapefile" --debug ON -s_srs "EPSG:4326" -t_srs "EPSG:28992" "Perceel-aan.shp" "WFS:https://geodata.natio

Re: [gdal-dev] TypeError Wrong number or type of arguments for overloaded function 'CoordinateTransformation_TransformPoint'.

Hi, At least you must fix this error first "ERROR 1: PROJ: proj_create_from_database: C:\Users\Deployment\.conda\envs\sw_py37_cv45\Library\share\proj\proj.db lacks DATABASE.LAYOUT.VERSION.MAJOR / DATABASE.LAYOUT.VERSION.MINOR metadata. It comes from another PROJ installation." Your proj.db databa

Re: [gdal-dev] Renaming Sponsorships tiers to align with NumFOCUS ones

+1 -Jukka Rahkonen- Even Rouault-2 wrote > PSC, > > We've had a request from NumFOCUS to align the titles of the GDAL > sponsorship tiers with the ones of NumFOCUS, to limit the risk of > confusion, which was one topic discussed during last meeting. > > For reference, the ones of NumFOCUS ar

Re: [gdal-dev] Motion: adopt RFC 83: guidelines for the use of GDAL project sponsorship

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Motion: > > adopt RFC 83: guidelines for the use of GDAL project sponsorship ( > https://github.com/OSGeo/gdal/pull/3855 ) > > Starting with my +1 > > Even > > -- > http://www.spatialys.com > My software is free, but my time generally not

Re: [gdal-dev] Renaming of GDAL Advisory Board

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > We just had a meeting with NumFOCUS staff, and they suggested we should > rename the GDAL Advisory Board to something else. The issue is with the > Board term which is a legal term and may implicate that it is a deciding > body, which it is

Re: [gdal-dev] GDAL Reproject Run as a Batch under QGIS

Hi, This seems to be a wrong mailing list. Use qgis-users https://lists.osgeo.org/mailman/listinfo/qgis-user instead or gis.stackexcange site. Before you write a new mail or question please try to improve your question a bit. What is not working? Do you know if reprojecting a whole directory of fi

Re: [gdal-dev] VRT layer definition question

gt; 0.034318505618178,0.034922734033886,"3" > 0.008330436091964,0.013543226571866,"4" > > > > Message: 2 > Date: Mon, 31 May 2021 13:41:55 -0700 (MST) > From: jratike80 < > jukka.rahkonen@ > > > To: > gdal-dev@.osgeo > Subject: Re:

Re: [gdal-dev] VRT layer definition question

Hi, Please add couple of rows from your CSV file. Maybe the lon and lat fields are otherwise OK but GDAL does not recognize them to contain numbers but perhaps text. You can also check what sort of attributes ogrinfo reports with ogrinfo file1.csv -al -so -Jukka Rahkonen- Al Piszcz wrote > I

Re: [gdal-dev] Motion: adopt RFC 81: support for coordinate epochs in geospatial formats

Hi, I guess that by "data" you mean datasets like GeoJSON file or GeoTIFF image. For individual coordinates folks in the Finnish Geospatial Institute (FGI) do conversions like in this cs2cs example echo 2258573.56109 1010806.43899 5859099.49087 2021.26 | cs2cs -d 4 --area finland EPSG:7789 EPSG

Re: [gdal-dev] Motion: adopt RFC 81: support for coordinate epochs in geospatial formats

Hi, The group description of Features and Geometries JSON SWG https://www.ogc.org/projects/groups/featgeojsonswg does not mention dynamic coordinate systems but I can at least try to add the topic into the agenda in the kick-off on next Tuesday (2021-06-01) even I am just on observer in the group.

Re: [gdal-dev] "OGR_SQLITE_SYNCHRONOUS" and "OGR_SQLITE_CACHE" accessible through Python bindings?

Hi, By reading https://sqlite.org/asyncvfs.html you could try if setting the journal mode into WAL with a PRAGMA command would help. -Jukka Rahkonen- Met Bas wrote > Write speeds to GeoPackages appear to be going extremely slow in my use > case. > GPKG/SQLite journal files are being created at

Re: [gdal-dev] Removing trailing decimals from contour labels of shape files

Hi, You may ask help from mapserver-users for the Mapserver side. It is possible to format the labels by expressions. See the example in https://mapserver.org/mapfile/class.html#class "More advanced Expressions can be used to specify the labels. Since version 6.0, there are functions available f

Re: [gdal-dev] Motion: adopt RFC 81: support for coordinate epochs in geospatial formats

+1 For me the RFC feels good. Existing data formats like GeoTIFF and GeoJSON can deliver the 4D spatiotemporal coordinates correctly by using the epoch attached as metadata when the whole dataset is using the same epoch. None of the formats dealt in the RFC should get broken. If some software doe

Re: [gdal-dev] About gdal RasterizeLayer

Hi, I tried if someone who don't know Python could do about the same with gdal_rasterize https://gdal.org/programs/gdal_rasterize.html and I had some success. gdal_rasterize -dialect sqlite -sql "select st_buffer(geometry,0.01) from states" -burn 100 -of GTIFF -ot byte -tr 0.1 0.1 -add states.sh

Re: [gdal-dev] New JP2Grok Driver for JPEG 2000

Hi, gdal_translate -of gtiff -co compress=jpeg p4433h.tif -co NUM_THREADS=ALL_CPUS comp.tif Time: 4.7 seconds (with GDAL 3.3.0 gisinternals build) Time: 11.5 seconds (with GDAL 3.1.4 OSGeo4W build) -Jukka- -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html __

Re: [gdal-dev] New JP2Grok Driver for JPEG 2000

Hi Even, You are right, Kakadu 8.x supports HTJ2K. I just had a try with the kdu_compress demo utility from KDU805 demo apps. The speed was good, actually amazing. As a test image I used a 12000x12000 RGB image. The kdu_compress command I took from this high qualite white-paper https://htj2k.com/

Re: [gdal-dev] Motion: promote GDAL 3.2.3 RC1

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Not sure if anyone has given this a try, but anyway: > > Motion: > > Adopt GDAL 3.2.3 RC1 as final 3.2.3 release > > Starting with my +1 > > Even > > -- > http://www.spatialys.com > My software is free, but my time generally not. > > ___

Re: [gdal-dev] Convert GEOCS

Hi, There is a command, gdaltransform https://gdal.org/programs/gdaltransform.html. However, it seems that both coordinate systems mean the same for Proj library and no conversion in coordinates happen. That you can test with projinfo that is a Proj utility. projinfo -s epsg:4326 -t epsg:4674 Can

Re: [gdal-dev] Motion: promote GDAL 3.3.0 RC1

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Having heard no issues being reported regarding RC1 > > Motion: > > Adopt GDAL 3.3.0 RC1 as final 3.3.0 release > > Starting with my +1 > > Even > > -- > http://www.spatialys.com > My software is free, but my time generally not. > >

Re: [gdal-dev] GDAL question

Hi, You can't update with ogr2ogr. Use ogrinfo instead. I believe that you will find good examples from gis.stackexchange https://gis.stackexchange.com/search?q=ogrinfo+update -Jukka Rahkonen- Peter P wrote > It is works, Thanks > > Now I trying update row. > In SQL will be: /UPDATE "table1" S

Re: [gdal-dev] gdal_retile JAVA bindings

Hi, The gdal_retile.py utility is a Python script and as far as I know nobody has ported it into Java so far. Even the GeoServer documents advice to use it as it stands https://docs.geoserver.org/stable/en/user/tutorials/imagepyramid/imagepyramid.html. It is about 1000 lines of Python code https:/

Re: [gdal-dev] GDAL question

Hi, Please check your GeoJSON before fighting with Python. "Name" placed into here {"type": "FeatureCollection", "Name": "testName", will probably be just skipped. If you used lower case "name" {"type": "FeatureCollection", "name": "testName", then "testName would be used as a name of the layer

Re: [gdal-dev] gdal-dev Digest, Vol 203, Issue 38

Hi, The reason is that by the GetCapabilities and DescribeCoverage requests GDAL is unable to create GetCoverage request that works. There may be a bug in GDAL, or missing special handling that the combination of WCS 1.0.x or 1.1.x + MapServer would require. Different WCS versions are handled by d

Re: [gdal-dev] WCS server error. Coverage not found

Hi Elena, Check the service with direct http calls from the browser: 1) The capabilities https://www.juntadeandalucia.es/medioambiente/mapwms/REDIAM_WCS_mdt?SERVICE=WCS&version=2.0.1&request=GetCapabilities Result: OK 2) Describe one coverage https://www.juntadeandalucia.es/medioambiente/mapwms/R

Re: [gdal-dev] GDAL question

Hi, Ogr2ogr by default converts all the columns so you should not need to do anything. Test first ogr2ogr from the command line without mixing Python into the soup. If you still do not get your "name" attribute converted you may have something special in your data, like a few first features in the

Re: [gdal-dev] Registered Content-Type for VRT?

Hi, Do you count ArcMap or ArcGIS Pro as self standing software or rather as applications that use GDAL? They read VRTs pretty well but for writing some developer tools are required https://pro.arcgis.com/en/pro-app/latest/help/data/imagery/supported-raster-dataset-file-formats.htm. -Jukka Rahkon

Re: [gdal-dev] "gdalbuildvrt does not support rotated geo transforms"

Hi, Try with gdalinfo, it should reveal the rotation. And with gdalwarp you can convert the image into north-up. -Jukka Rahkonen- Lorenzo Di Giacomo wrote > Hi, do you know why this happens when i try to merge tiles of a specific > tiff? > How can check if a tiff had a rotated geo transforms? A

Re: [gdal-dev] Gdal Java

Hi, >From this resolved issue I can see that somebody has had success a couple of years ago https://github.com/OSGeo/gdal/issues/1333. The bug report is extraordinary good with build instructions and test program. -Jukka Rahkonen- paul.malm wrote > Hi list, > is there someone out there who has

Re: [gdal-dev] Gdal Java

Hi, Perhaps you could ask from the Geotools/Geoserver teams how they manage to get their GDAL plugin https://docs.geotools.org/stable/userguide/library/coverage/imageio.html https://docs.geoserver.org/stable/en/user/data/raster/gdal.html to work. -Jukka Rahkonen- paul.malm wrote > Hi, > further

Re: [gdal-dev] Adding gcps to a raster using gdal_translate can result in data loss.

Hi, Please give an exact example. Preferably with a raster that can be created from command line with gdal_create followed by other required commands. Or alternatively Python code that re-produces the issue. -Jukka Rahkonen- Hays Barrett wrote > If the gcps stretch the image beyond the dimensi

Re: [gdal-dev] interpreting gdalcompare results

Hi, There is some documentation in https://gdal.org/programs/gdalcompare.html: Synopsis: gdalcompare.py [-sds] golden_file new_file The file that is considered correct, referred to as the golden file. The file being compared to the golden file, referred to as the new file. In your report the

Re: [gdal-dev] Motion: RFC 78: gdal-utils package

+0 I have a positive feeling but unfortunately I do not really understand the topic well enough to say yes or no. -Jukka Rahkonen- Idan Miara wrote > Hi all, > > Having heard no further comments regarding RFC78 > ;. > > Motion: > > Adopt RFC 78: gdal

Re: [gdal-dev] OSGeo.OGR.Geometry: Union the mutiple geometries at a time

Hi, I can't imagine any connection between Union and Convex/Concave hull. Union of the points in the example image is a MultiPoint geometry. The hull is a single geometry that encloses the input geometries, in this case it is a polygon. There is no need to consider hulls when doing Union. Generall

Re: [gdal-dev] OSGeo.OGR.Geometry: Union the mutiple geometries at a time

Hi, Please explain what do you mean by "Concave Hull-based union geometry". Union is union as it is defined in the OpenGIS Simple Features Implementation Specification for SQL 1.1 standard. There is only one possible correct result from union. The source code is available if you are interested in

Re: [gdal-dev] gdal_retile: output isn't georeferenced?

Hi, Expected behavior is documented in https://gdal.org/programs/gdal_retile.html. -s_srs Source spatial reference to use. The coordinate systems that can be passed are anything supported by the OGRSpatialReference.SetFromUserInput() call, which includes EPSG, PCS, and GCSes (i.e. EPSG:4296

Re: [gdal-dev] nearblack on multi GB images very slow

Hi, Are your multigigabyte originals tiled or striped tiffs? -Jukka Rahkonen- mhw-at-yg wrote > I have a lot of multi GB images that are unfortunately jpeg-in-geotiff > encoded before nodata was properly defined. As a result they all suffer > from > the jagged edges problem. >

Re: [gdal-dev] Vector Tile size change in Ogr2Ogr

Hi, Bounds and other metadata are explained in https://github.com/mapbox/mbtiles-spec/blob/master/1.3/spec.md. "The metadata table SHOULD contain these four rows: bounds (string of comma-separated numbers): The maximum extent of the rendered map area. Bounds must define an area covered by all zo

Re: [gdal-dev] Vector Tile size change in Ogr2Ogr

-- 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] Motion: Motion: promote GDAL 3.2.2 RC1

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Having heard no issues being reported regarding RC1 > > Motion: > > Adopt GDAL 3.2.2 RC1 as final 3.2.2 release > > Starting with my +1 > > Even > > -- > http://www.spatialys.com > > ___ > gdal

Re: [gdal-dev] Wiki page with current maintainers per sub-system

Hi, I cannot maintain any driver myself but I could be listed as someone who is willing to sponsor the maintenance work that is needed to keep the OpenJUMP JML driver alive. Of course it depends on the price, if there are other users to share the costs, if any service provider or individual is wil

Re: [gdal-dev] GML duplicated FID

Hi, It would be interesting to know how you manage to generate duplicate fids with Geoserver but perhaps it is better to discuss about that in geoserver-users. -Jukka Rahkonen- Martin Landa wrote > Hi all, > > I have an issue with GML generated by GeoServer. There are features > with duplicate

Re: [gdal-dev] Motion (V2): remove and deprecate a few drivers

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Updating my yesterday motion with the feedback received (only second > bullet updated with a more restricted set of drivers) > > Motion: > > - remove the vector drivers BNA, AeronavFAA, HTF, OpenAir, SEGUKOOA, > SEGY, SUA, XPlane and raster

Re: [gdal-dev] Unexpected behavior on gdal2tiles.py

Hi, Tiles created by gdal2tiles are never georeferenced directly but only through the tileset definition. I had a try with your coordinate system with raster profile and by looking at the generated tilemapresource.xml it seems to me that the tileset is correct and tiles georeferenced right. Client

Re: [gdal-dev] GDAL SVG to BMP conversion

Hi, You can test it with any SVG file ogrinfo matplotlib.svg --debug on ... SVG: matplotlib.svg seems to be a SVG file, but not a Cloudmade vector one. ... I recommend to use some other tools. -Jukka Rahkonen- Shaw, Theodore wrote > I'm attempting to convert SVG files output by Gdspy to large

Re: [gdal-dev] Unexpected behavior on gdal2tiles.py

Hi, By looking at the messages the installation on Machine B has an error: "It [means proj.db] comes from another PROJ installation." Because of that error gdal2tiles "works". If you fix the installation on Machine B it will fail for the same reason than Machine A: "Cannot find coordinate operatio

Re: [gdal-dev] New JPEG 2000 Driver

Hi, In my opinion it is GDAL's mandate to favor projects that use the same type of license than GDAL itself. Both proprietary and more copy-left licenses makes it a bit harder to handle the whole system. Individual developers may have their own opinions about what licensing model is the best when

Re: [gdal-dev] New JPEG 2000 Driver

Greg Troxel-2 wrote > Even Rouault < > even.rouault@ > > writes: > >> Can you transparently tell us why Grok is AGPL licensed ? Do you sell >> commercial licenses for people who couldn't comply with the AGPL license >> ? > > Certainly a good question. I have no idea in this case and my comme

Re: [gdal-dev] Motion: adopt RFC79: Listing of Service Providers on GDAL website

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > I motion to adopt RFC79: Listing of Service Providers on GDAL website: > https://github.com/OSGeo/gdal/pull/3473 > > Starting with my +1 > > Even > > -- > http://www.spatialys.com > ___ > gdal-dev

Re: [gdal-dev] The proper way to call gdal "scripts" on Windows?

Hi, OSGeo4W creates .bat file for each Python script. As an example gdal_calc.bat: @echo off call "%OSGEO4W_ROOT%\bin\o4w_env.bat" python "%OSGEO4W_ROOT%\bin\gdal_calc.py" %* o4w_env.bat launches a bunch of other .bat files. Have a look and be astonished! One of those sets Python: SET PYTHON

Re: [gdal-dev] Call for discussion on RFC 79: Listing of Service Providers on GDAL website

GDAL - Dev mailing list wrote > Hi Even, > > On Tue, Feb 23, 2021 at 2:56 AM Even Rouault < > even.rouault@ > > > wrote: > >> Hi, >> >> Please find https://github.com/OSGeo/gdal/pull/3473 which proposes to >> list >> service providers offering GDAL related services on the GDAL website. As >> me

Re: [gdal-dev] warp ARGB -> RGB gtiff-jpeg?

Hi, It is very cheap to use gdal_translate and VRT as intermediate format. As far as I know it is not possible to drop alpha with gdalwarp even it is possible to add alpha -dstalpha. -Jukka Rahkonen- Idan Miara wrote > Hi All, > > Is it possible to use gdal_warp for warping the RGB bands of a

Re: [gdal-dev] Requesting a transparent image from a WMS server...

Hi, Try gdal_translate "WMS:https://maps-public.geo.nyu.edu:443/geoserver/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=sdr%3Anyu_2451_43745&SRS=EPSG:4326&BBOX=-119.265762329102,35.2621765136719,-118.825294494629,35.4424705505371&format=image/png&transparent=TRUE"; service.xml -of WMS Not

Re: [gdal-dev] break a bounding box into smaller boxes

Hi, Ok, so obviously you are talking about WFS service, not WMS. Why don't you use paging with COUNT and STARTINDEX https://www.mapserver.org/ogc/wfs_server.html? -Jukka Rahkonen- MRRAJESH wrote > We are expecting feature information from our own map server for a given > BBOX. At present we

Re: [gdal-dev] break a bounding box into smaller boxes

Hi, I would guess that Mapserver does not care about your BBOX but by the same you create GetMap requests with &WIDTH= and &HEIGHT= that exceeds the limit that is configured on the server with MAP-MAXSIZE https://mapserver.org/mapfile/map.html. So you must split your requests smaller by the reque

Re: [gdal-dev] Create cloud optimized geotiff without re-encoding?

Hi, I made a couple of simple tests by following https://trac.osgeo.org/gdal/wiki/CloudOptimizedGeoTIFF, here are the results: Create a jpeg compressed GeoTIFF and couple of overviews gdal_translate -of GTiff -co tiled=yes -co compress=jpeg p4433h.tif p2-jpeg.tif gdaladdo --config COMPRESS_OVERV

Re: [gdal-dev] How I get a list of CRS supported for a WMS service with gdal?

Hi, GDAL is not made to build a CRS list. See https://gdal.org/drivers/raster/wms.html "[CRS] Image projection (optional, defaults to EPSG:4326, WMS version 1.3.0 or above only)" You can get the full list from GetCapabilities that you fetch by other means and write one of the supported codes into

Re: [gdal-dev] WMTS services error

This is something that is undefined in the standard. I would say that the bug is on the IGN side and I would like to know what problem they have had with http://www.opengis.net/def/crs/EPSG/0/4326. What GDAL might do better is to have an option to flip the axes with the WMTS XML definition file.

Re: [gdal-dev] WMTS services error

Hi, By reading the documentation https://gdal.org/drivers/raster/wmts.html it could be possible to edit the automatically created XML service definition file or write it by hand from a scratch. -Jukka Rahkonen- Travis Kirstine wrote > Elena > > This appears to be a bug in wmts driver in gdal,

Re: [gdal-dev] GeoTiff writer refuses to set 42113 (NoData) from Python

Hi, There is a common belief that problems with images happen only with exactly that confidential multigigabyte image that user is playing with. That is uncommon and usually the problem can be repeated with any other image with similar structure. If you have GDAL v. 3.2 you can use https://gdal.

Re: [gdal-dev] mosaicking files with partial overlap and binary mask

Hi Daniele, Test data, please. -Jukka Rahkonen- Daniele Romagnoli-3 wrote > Thanks for the feedback, Patrick. > I have downloaded the latest build from GisInternals and it worked as > expected. > I have another question. > It looks like warping an input file containing a binary mask isn't > pr

Re: [gdal-dev] Fwd: ogr2ogr crash attempting to drop table in filegdb

Hi, SQL in ogr2ogr is only for SELECT. For any other purpose use ogrinfo. An example: ogrinfo -sql "alter table point_p rename column test to foo" point.gpkg -dialect sqlite -Jukka Rahkonen- janhec wrote > Dear list, > > About the filegdb driver > Attempting: > ogr2ogr -f FILEGDB test.gdb bag

Re: [gdal-dev] no such function: ST_Line_Interpolate_Point when Spatialite and GDAL are installed and quite up-to-date

Hi, This is how you can test with ogrinfo if the function is available for you. Use just any vector data source instead of "point.jml". Test data is generated by the SQL but ogr2ogr requires some datasource (I have been wondering if it could be dummy.dum or something like that for a dummy format).

Re: [gdal-dev] JPEG/PNG 12 bits GDAL python

Hi, With my GDAL 3.1.4 from OSGeo4W converting a single band Float32 DEM file into JPEG compressed TIFF and into plain JPEG succeeded with these commands: gdal_translate L2431.tif -co COMPRESS=JPEG -ot uint16 -co NBITS=12 out.tif gdal_translate L2431.tif -of JPEG -ot uint16 -co NBITS=12 out.jpg

Re: [gdal-dev] OGC KML compliance

Done. Even there should be no need to report the results again (all tests were OK) I would recommend to try the TEAM Engine just for fun. It was a pleasant experience for me. -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > if anyone cares about GDAL still being mentionned as a OGC KML referen

Re: [gdal-dev] GDAL workshop for FOSSGIS 2021

Hi, I do not believe that anybody is jealous of you because of the workshop. And if a rival candidate appears (unlikely) it is up to the organizer to select the workshop that they consider as the best. We support fair play. -Jukka Rahkonen- Markus Metz-3 wrote > Hi, > > we from mundialis, main

Re: [gdal-dev] gdal_translate receiving "Warning 6: driver GTiff does not support creation option WEBP_LOSSLESS"

Hi, I would also have a try by actually using -co WEBP_LOSSLESS=True even by the error message it is perhaps automatically applied. -Jukka Rahkonen- Marty J. Sullivan wrote > Hello, > > I am attempting to create a COG format GeoTIFF with WEBP_LOSSLESS > compression using GDAL. > > I have comp

Re: [gdal-dev] Considering drivers removal ?

Hi, The joy of being a Windows user is that it is so easy to use old GDAL versions if the binaries still happen to be on some dusty backup disk. Even the FWTools including GDAL 1.7.0 from 2010 seemed to work fine and include quite a many later removed drivers. A few comments about the driver list

Re: [gdal-dev] List all the (possible) errors of a single transaction

Hi, One workaround is to use -skipfailures and compare afterwards which IDs in the source data are not present in the target table. Skipfailures is forcing the transaction size into one row and it may be deadly slow if the output is GeoPackage because initializing/committing a transaction in SQLit

Re: [gdal-dev] ogr2ogr from gpx to postgis - track_fid not maintained for track_points

Hi, For my mind the behavior is consistent. FID (in this case named as ogc_fid) is a unique feature ID and tracks table contains tracks so it is natural that FID is increasing when more tracks are added - and it must increase or otherwise the FID is not unique. The track_points table contains poin

Re: [gdal-dev] Motion: promote GDAL 3.2.1 RC1

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Having heard no issues being reported regarding RC1 > > Motion: > > Adopt GDAL 3.2.1 RC1 as final 3.2.1 release > > Starting with my +1 > > Even > > -- > Spatialys - Geospatial professional services > http://www.spatialys.com > __

Re: [gdal-dev] exporting all tables from PG schema

Hi, I would have a try with open option LIST_ALL_TABLES=YES https://gdal.org/drivers/vector/pg.html. "LIST_ALL_TABLES=YES/NO: This may be “YES” to force all tables, including non-spatial ones, to be listed." It is probably worth reading https://gdal.org/drivers/vector/gpkg.html as well, about the

Re: [gdal-dev] Doubts to Convert TopoJson to SHP File

Hi, Do you know in which coordinate system the topojson data are? If GDAL can't recognize it automatically (check with ogrinfo) you can give it manually, for example " -a_srs EPSG:4326". That should trigger the creation of the .prj file. -Jukka Rahkonen- Moises Silva wrote > Hi, > >I am ne

Re: [gdal-dev] Duplicate pixels in VRT

Hi, Check what are the extents of two adjacert images reported by GDAL 2 and 3, as well as the sizes in pixels, and if images are of type "pixel is area" or "pixel is point". DEM kind of images are sometimes intentionally produced to have overlap. -Jukka Rahkonen- Jon Morris wrote > Hello all,

Re: [gdal-dev] Exporting triggers/constraints from PG to GPKG

Hi, You are right, ogr2ogr converts just the data from the table/view/query and metadata that defines the coordinate system. I believe it would be very hard to handle the creation of triggers and constraints and insert data in the right order into SQLite, Oracle, MSSQL etc. -Jukka Rahkonen- gh

Re: [gdal-dev] ogr2ogr question

Hi, No, -overwrite does not truncate but it drops the table. However, with the PostgreSQL driver it is also possible to truncate the table by using this documented method https://gdal.org/drivers/vector/pg.html#vector-pg. Check the configuration options "OGR_TRUNCATE: If set to “YES”, the conten

Re: [gdal-dev] Geotransform for non-North-up images?

Hi, The geotransform parameters are the same than in the ESRI wordfile. I tried once to understand how the parameters behave when the image is rotated and wrote an OpenOffice spreadsheet about that. You can have a try and play with the parameters. I hope I have understood it right. I was not so su

Re: [gdal-dev] gdal_translate -scale

Hi, If your output is 8 bit you can just use -scale without min/max values. From https://gdal.org/programs/gdal_translate.html: "Rescale the input pixels values from the range src_min to src_max to the range dst_min to dst_max. If omitted the output range is 0 to 255. If omitted the input range i

Re: [gdal-dev] promote_to_multi and python API

Hi, You do not need to call ogr2ogr because there is a python library equivalent "gdal.VectorTranslate". You can find a PROMOTE_TO_MULTI example from the autotests https://github.com/OSGeo/gdal/blob/master/autotest/utilities/test_ogr2ogr_lib.py#L539 -Jukka Rahkonen- Martin Landa wrote > Hi, >

Re: [gdal-dev] MBTiles generation docs question

Hi, I am adding some related links: - Open GDAL ticket (where you already added your comment) https://github.com/OSGeo/gdal/issues/3126 - Question in gis.stackexchange https://gis.stackexchange.com/questions/376827/gdaladdo-zoom-level-not-supported The issue is that at the moment GDAL does not ha

Re: [gdal-dev] MBTiles generation docs question

Hi, I would guess that the appropriate zoom level is the one with pixel size closest to the pixel size of the source file after it has been warped into EPSG:3857. Please add gdalinfo report about the source image. -Jukka Rahkonen- Evert Etienne (SITEMARK) wrote > Dear, > > I have a question

Re: [gdal-dev] gdal_translate, exporting "Byte - Eight bit unsigned integer" single band tiff to gpkg using -ot Byte results in 4 bands raster with changed values

It might be good to read also about the open options in https://gdal.org/drivers/raster/gpkg.html "BAND_COUNT=1/2/3/4: Number of bands of the dataset exposed after opening. Some conversions will be done when possible and implemented, but this might fail in some cases, depending on the BAND_COUNT v

Re: [gdal-dev] gdal_create: input file option

Hi, Great, allowing to override all automatically captured parameters is probably a good feature. I believe that some users will find this new option useful. Next challenge could be to burn vertical and horizontal gridlines for warping and resampling tests. -Jukka- Even Rouault-2 wrote > On m

Re: [gdal-dev] ogr2ogr project/transform CRS in the same database table

> Oh, I see. That's great. > > But what if the Database does not have ST_Transform support? Could we > still > achieve a similar approach by means of ogr2ogr? > > (I should have mentioned this in my first email). > > Thanks again! > Hector > > On Tue, 1 Dec 20

Re: [gdal-dev] ogr2ogr project/transform CRS in the same database table

Hi, No, unfortunately it is not possible with one ogr2ogr command. You need two commands and you must use ogrinfo. Here an example about adding another geometry column and populating it with EPSG:3857 version of original EPSG:4326 geometries. ogrinfo PG:"host=localhost port=5432 dbname=test user

Re: [gdal-dev] warp srs: xyz format point cloud

Hi, Because you are changing from the raster world into vector world I would it somehow - convert raster in native CRS into xyz - write a vector VRT file for converting xyz data into points - re-project the point dataset with ogr2ogr Converting data into PostGIS raster could be more elegant and a

Re: [gdal-dev] gdalwarp from EPSG:25832 to EPSG:4326 with error latitude or longitude exceeded limits?

...20...30...40...50...60...70...80...90...100 - done. -Jukka- jratike80 wrote > Hi, > > What you have wrong is the input coordinate system, not the output as you > tested. -- Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html __

Re: [gdal-dev] gdalwarp from EPSG:25832 to EPSG:4326 with error latitude or longitude exceeded limits?

Hi, What you have wrong is the input coordinate system, not the output as you tested. Compare https://epsg.org/crs/wkt/id/25832 with https://epsg.org/crs/wkt/id/4647 and notice the difference in false easting. Now run gdalwarp right gdalwarp -s_srs epsg:4647 -t_srs epsg:4326 test_00.tif test_432

Re: [gdal-dev] ogr2ogr is not working for a geojson file

Hi, What is your GDAL version (current is 3.2)? Do you get the same error with ogr2ogr command line without launching it from Java? -Jukka Rahkonen- Ravi Teja Krishna Wuyyuru wrote > Hi,  > > > >       I have tried converting the file in Centos and Macos but I am facing > an error as said be

Re: [gdal-dev] ogr2ogr is not working for a geojson file

Hi, I don't know that Java stuff but at least there does not seem to be anything wrong with your data nor ogr2ogr. Your command runs without errors on Windows and ogr2ogr binary (GDAL version 3.2). -Jukka Rahkonen- Ravi Teja Krishna Wuyyuru wrote > Hi team, > >       I am using ogr2ogr with

Re: [gdal-dev] Motion: adopt RFC 77 Drop Python 2 support in favor of Python 3.6

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > given the positive feedback of the discussion phase, and since our CI is > now > ready for it, I motion to adopt > > RFC 77: Drop Python 2 support in favor of Python 3.6 > https://github.com/OSGeo/gdal/pull/3142 > > Starting with my +1 > >

Re: [gdal-dev] GDAL_WCS Driver and gdal_translate

Hi, Just a note to remind that earlier in thread "gdal-dev Digest, Vol 198, Issue 14" it was noticed that the GDAL WCS driver most probably has a bug and certain WCS coverages from Geoserver do not work. It seems to be related with the native CRS EPSG:4326. So if you test now with Geoserver, don't

Re: [gdal-dev] Passing open options along dataset name in a string ?

Hi, I have done some helpdesk work within the GDAL community and I know well that the open options and config options are confusing. I also know that they exists for a reason but simplified and uniform way to use them would be nice. Some comments on comments: >> gdalinfo my.tif -oo GEOREF_SOURCE

Re: [gdal-dev] gdal-dev Digest, Vol 198, Issue 14

Hi Ari, I fear that user cannot control this with the switches. This is the reason for the error: ``` WCS: Requesting http://demo.geo-solutions.it/geoserver/wcs?SERVICE=WCS&REQUEST=GetCoverage&VERSION=2.0.1&COVERAGEID=nurc__mosaic&SUBSET=Long(6.3953399152693953,6.3953399152693953)&SUBSET=Lat(46.5

Re: [gdal-dev] Location change on gdalwarp reprojection

Hi, The bounds do not mean exactly what you think. Re-projecting a rectangular image from EPSG:27573 into EPSG:4326 rotates the image somewhat counter-clockwise. This image is from another context https://www.usgs.gov/media/images/landsat-1-8-landsatlook-image-examples but you can get the idea. Th

Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

Hi, It should work. Write your two first ogr2ogr commands (the initial one and first to append) as a whole but without OCI connection details. The -nln parameter must appear in the append command if I remember right. -Jukka Rahkonen- Kreß, Marius wrote > Dear GDAL developers and users, > > I

Re: [gdal-dev] WCS_GDAL Driver Image SubSet Request

Hi, Do you want to make is somehow impossible to request data beyound the BoundingBox that you defined in the XML file? If you just want to get data from the rectangle that you or your users define, gdal_translate with the regular -spat option should work out-of-the-box. -Jukka Rahkonen- julie

Re: [gdal-dev] Spherical Mercator Projection mismatching major/minor axis

Hi, This does not really belong to my knowledge area but I'll have a try anyway. Check what you have after reading the proj string instead. Here with Python >>> from osgeo import osr >>> spatialRef = osr.SpatialReference() >>> spatialRef.ImportFromProj4("+proj=merc +a=6378137 +b=6378137 +lat_ts=

Re: [gdal-dev] Retrieving 3DEP data via GDAL's WCS driver...

Hi, By adding "-- debug on" into your command it is possible to get details about what GDAL is doing. Here are the main parts from the log gdal_translate "WCS:https://elevation.nationalmap.gov:443/arcgis/services/3DEPElevation/ImageServer/WCSServer?version=2.0.1&coverage=DEP3Elevation"; test.tif

Re: [gdal-dev] Motion: promote GDAL 3.2.0 RC1

+1 -Jukka Rahkonen- Even Rouault-2 wrote > Hi, > > Having heard about no critical ([1]) issues regarding RC1 > > Motion: > > Adopt GDAL 3.2.0 RC1 as final 3.2.0 release > > Starting with my +1 > > Even > > [1] The only regression I'm aware of currently is regarding the > possibility to >

Re: [gdal-dev] https://stackoverflow.com/questions/61342237/gdal-translate-missing-spatial-reference-system

Hi, But you did not find out what is special in the spatial reference of your source image and why GDAL 3.0.2 did not find it while 2.4.1 had no problem. First step would be to run gdalinfo with 2.4.1 and 3.0.2 and compare the reports. -Jukka Rahkonen- Laurynas Gedminas wrote > OK, so the issu

  1   2   3   4   >