Re: [gdal-dev] Long Term Prognosis for JPEG 2000

I would second COGs using WebP etc compressions. With internal tiling and overviews it's great for easy hosting and access from cloud providers. Also, support for Geotifff is great within desktop, serverside, and in browser. On Tue, 30 Mar 2021, 05:42 Javier Jimenez Shaw, wrote: > What about

Re: [gdal-dev] Linking error when building Informix OGR driver

I tried a full clean, configure, and make and I still get the same message. I've also tried recording the libraries in the linking process e.g -lifglx before and after -lifdmi -lifsql -lifasf -lifgen -lifos -lifgls and -lifglx before and after libgdal.so, but it still doesn't work.

Re: [gdal-dev] Linking error when building Informix OGR driver

' failed make[1]: *** [gdalinfo] Error 1 make[1]: Leaving directory '/home/informix/dev/gdal/gdal/apps' GNUmakefile:120: recipe for target 'apps-target' failed make: *** [apps-target] Error 2 On Tue, Aug 25, 2020 at 9:10 PM Mateusz Loskot wrote: > On Tue, 25 Aug 2020 at 12:58, Jeremy Palmer wr

[gdal-dev] Linking error when building Informix OGR driver

Hi All, I'm getting linking issues trying to build the Informix driver. I've installed the informix SDK and added the following libraries to /etc/ld.so.conf.d/informix-client-sdk.conf and then run sudo ldconfig: /opt/IBM/Informix_Client-SDK/lib /opt/IBM/Informix_Client-SDK/lib/dmi

[gdal-dev] OGR Informix driver status

Hi All, Does anyone know the status of this driver? https://gdal.org/drivers/vector/idb.html. I see no test suite, but some patches were applied back in 2017. Is it still used in production by anyone of this list? Does it have any known significant limitations? e.g catalog or layer metadata

Re: [gdal-dev] gdal_translate (3.1.0dev) "never" finishes on large jpeg cogs... REALLLLLY long time to unload.

Hi Andy, On Wed, Apr 22, 2020 at 8:33 AM Ritchie, Andrew C wrote: > > > Sorry I should’ve run more tests to clarify the situation re BIGTIFFs. It > looks like gdal_translate honors -co BIGTIFF=NO for the raster but not the > mask. > What's the output size of your COG when it successful

Re: [gdal-dev] gdal_translate (3.1.0dev) "never" finishes on large jpeg cogs... REALLLLLY long time to unload.

Hi Andrew, On Wed, Apr 22, 2020 at 6:11 AM Even Rouault wrote: > Andrew, > > > > > When I create a mask band in a large lzw-compressed or jpeg-compressed > tif > > > using the COG driver it dramatically increases processing time over > writing > > > RGBA (hours instead of minutes), so the issue

Re: [gdal-dev] Add padding to an image

quot;too broad" or "unclear what you're asking", or > perhaps > "primarily opinion-based". > > Could you explain what you mean with padding, and if you would rather use > some GDAL program or for example Python? > > -Jukka Rahkonen- > > > &g

[gdal-dev] Add padding to an image

Hi All, What the best way to pad an output RGBA image with gdal tools? Thanks in advance. Cheers Jeremy ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] OGR Python API to Load Esri JSON

Hi All, Is there a OGR Python API to load Esri JSON into an OGR geometry object, much like CreateGeometryFromJson? I’ve seen the arcgis2geojson library but wanted to avoid that dependency. Cheers, Jeremy ___ gdal-dev mailing list

Re: [gdal-dev] [SeasonOfDocs] Offers for GDAL documenting

I think we could do with documenting the https://trac.osgeo.org/gdal/wiki/ConfigOptions in a more complete way and including it in the main website documentation. We could also consider including all config options that apply to a driver such as

Re: [gdal-dev] GDAL VRT with Cloud Optimized GeoTIFFs and AWS

, which I estimate can bring the size down to about 200GB total. Cheers Jeremy On Sat, Mar 2, 2019 at 9:15 AM Jeremy Palmer wrote: > Hi All, > > Does anyone have any tips or experience in trying to serve RGB large > imagery multi file datasets hosted on S3 to application server

[gdal-dev] GDAL VRT with Cloud Optimized GeoTIFFs and AWS

Hi All, Does anyone have any tips or experience in trying to serve RGB large imagery multi file datasets hosted on S3 to application servers/containers for bulk tile rendering? Is this possible using VRTs and is the performance manageable when compared to other mounted storage options? Thanks,

Re: [gdal-dev] Use GDAL on AWS Lambda

I have no direct experience, but there are plenty of resources on the web for how to install GDAL on Lambda: https://github.com/mmcfarland/foss4g-lambda-demo (presentation https://vimeo.com/234947418) https://github.com/joshtkehoe/lambda-python-gdal Both are using python 2.7, but the steps

Re: [gdal-dev] connect mssql from linux

But does the ODBC driver support the BCP (bulk copy) API? That was the original reason to use the native client. On Wed, May 9, 2018 at 8:06 AM, Mateusz Loskot wrote: > FYI, the SQL Server Native Client is not the best choice to connect to the > latest MSSQL. > You may want

Re: [gdal-dev] connect mssql from linux

Note I alway found the FreeTDS driver would truncate values on rows that contained large geometries. Can't remember the size limit though. Would be interesting to know why the LINUX native driver doesn't work. On Mon, May 7, 2018 at 9:33 AM, Martin Landa wrote: > Hi, > >

Re: [gdal-dev] GDAL way to set open options in QGIS?

Hi Even, On Tue, Feb 20, 2018 at 1:31 AM, Even Rouault wrote: > > No, I did reproduce the issue. The reason was that the path to the mbtiles > in the VRT was not tagged as relative. So either add the -relative switch > in your ogr2vrt.py invokation, or grab its

Re: [gdal-dev] GDAL way to set open options in QGIS?

the invalid geometries be causing the issue? Note I can add the mbtiles file directly but then it shows all the data from every zoom level. On Mon, Feb 19, 2018 at 9:47 AM, Jeremy Palmer <palmer...@gmail.com> wrote: > Hi Jürgen, > > On 19/02/2018 09:18, "Jürgen E. Fischer" > &g

Re: [gdal-dev] GDAL way to set open options in QGIS?

Hi Jürgen, On 19/02/2018 09:18, "Jürgen E. Fischer" Wasn't just in the message - the typo is fixed in r41535. Thanks. Make sense now. Cheers Jeremy ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] GDAL way to set open options in QGIS?

Thanks Even. I get a warning message when using ogr2vrt.py on trunk 41534: jpalmer$ ogr2vrt.py --version GDAL 2.3.0dev, released 2017/99/99 jpalmer$ ogr2vrt.py parcels.mbtiles parcels.vrt -oo ZOOM_LEVEL_AUTO=YES Warning 6: driver MBTiles : type 'booleean' for ZOOM_LEVEL_AUTO open option is not

[gdal-dev] GDAL way to set open options in QGIS?

I'm trying to open the new MBTiles vector tiles driver format in QGIS. Is it somehow possible to set GDAL open options either within QGIS or some sort of environment variable? Cheers Jeremy ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] Vector Tiles in OGR

Ok thanks. On Wed, Feb 14, 2018 at 8:00 AM, Even Rouault wrote: > > > > > Great news. Is it possible to provide a user defined list of resolutions > > > for the custom scheme which are not power of two? > > > > Not implemented, but could potentially be done > > > >

Re: [gdal-dev] Vector Tiles in OGR

> > > > > OK, I've added a TILING_SCHEME dataset creation option to define such as > custom tiling scheme. See > > https://trac.osgeo.org/gdal/changeset/41470#file1 > > for how to use it and how it impacts metadata.json > > > > Note that this is only implement for file tilesets and not for MBTILES

Re: [gdal-dev] Coordinates Axis Order for EPSG:2193

Hi Even, On Fri, Feb 9, 2018 at 7:16 AM, Even Rouault wrote: > > > > Yes, use "EPSGA:2193" > > note the A after EPSG for Axis > > > > If using EPSG, axis will be stripped off for lat-long geodetic SRS, and > northing-easting projected SRS. > > Whereas EPSGA always

[gdal-dev] Coordinates Axis Order for EPSG:2193

Is there a way to report the axis order that GDAL understands internally for automatically swapping coordinates axis order when dealing with OGC/GML services? EPSG is defined as North/East order and is correct in http://epsg-registry.org/export.htm?wkt=urn:ogc:def:crs:EPSG::2193 However when I

Re: [gdal-dev] Compiling ECW 3.3 on MacOSX

Hi All On Sat, Jan 6, 2018 at 11:21 AM, Even Rouault wrote: > > Also do you think > > > https://trac.osgeo.org/gdal/browser/branches/2.2/autotest/ > gdrivers/ecw.py > > > is setup to test the 3.3 SDK nicely? If so I can verify the patch on > LINUX > > > and MacOSX

Re: [gdal-dev] Compiling ECW 3.3 on MacOSX

Hi John, On Fri, Jan 5, 2018 at 5:22 AM, John Daniel wrote: > Hello Jeremy, > I do have a handy patch for this library. I will send it to you in a > private e-mail. It isn’t a small patch so I don’t think I should put it on > the mailing list. > Thanks so much for the patch.

[gdal-dev] Compiling ECW 3.3 on MacOSX

I'm trying to compile ECW support for GDAL using the older 3.3 SDK for MacOSX 10.13. I downloaded the source for libecwj2-3.3-2006-09-06.zip and applied the cumulative patch : ​ https://trac.osgeo.org/gdal/attachment/wiki/ECW/libecwj2-3.3.patch. I then ran the following standard build commands:

Re: [gdal-dev] OGR GeoJSON output

Thanks Both. On Mon, Dec 18, 2017 at 10:58 AM, Sean Gillies wrote: > Even, > > I found an example in the jq Cookbook of doing it with nothing other than > jq. > > https://github.com/stedolan/jq/wiki/Cookbook#convert-a- > csv-file-with-headers-to-json > > The "sed for JSON"

[gdal-dev] OGR GeoJSON output

I have a table without a geometry field and would like to create a simple JSON file containing property key-pairs values without the GeoJSON schema. Is this possible with ogr2ogr? Thanks, Jeremy ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] Write overviews directly to S3

Hi Peter, On 19/05/2017, at 4:38 AM, Peter Schmitt > wrote: We have come up with one technique to read/write directly to/from s3 using /vsis3/ and a simple file writer class a colleague wrote:

Re: [gdal-dev] Write overviews directly to S3

Hi Even, On 18/05/2017, at 9:12 PM, Even Rouault > wrote: > > Is is possible to directly write external overview to a S3 bucket? With GDAL > 2.1.2 I get an error reporting that seek is not supported when writing to > vsis3: No,

[gdal-dev] Write overviews directly to S3

Hi All, Is is possible to directly write external overview to a S3 bucket? With GDAL 2.1.2 I get an error reporting that seek is not supported when writing to vsis3: gdaladdo /vsis3/my-bucket/data/1000.tif 2 ERROR 6: Seek not supported on writable /vsis3 files ERROR 1: _tiffSeekProc:Resource

Re: [gdal-dev] Call for discussion on RFC 67 : Null values in OGR

Hi Even, Change is most welcomed, especially for WFS/GML. Would there also be changes required to the CSV driver given the new EMPTY_STRING_AS_NULL GDAL 2.1 open option? Cheers, Jeremy On 26/01/2017, at 7:54 AM, Even Rouault >

Re: [gdal-dev] How to hide the GML in WFS

From: Even Rouault [even.roua...@spatialys.com] Sent: Tuesday, 2 June 2015 8:10 p.m. To: gdal-dev@lists.osgeo.org Cc: Jeremy Palmer Subject: Re: [gdal-dev] How to hide the GML in WFS You couldn't. In the case of GML returned by a WFS service, the GML

[gdal-dev] How to hide the GML in WFS

How do you hide the gml_id field from a WFS service? I think I'm setting the correct configuration options, but it doesn't seem to work: ogrinfo --config GML_EXPOSE_GML_ID NO --config GML_EXPOSE_FID NO -al -so

[gdal-dev] WMTS support in GDAL

Is it now possible to read WMTS sources using the GDAL WMS driver? The case looking at is using a service such as https://data.linz.govt.nz/set/2-nz-aerial-imagery/webservices/ and which has custom tile matrix specification and a RESTFul Tile access API. Cheers, Jeremy Palmer Data Services

Re: [gdal-dev] Does gdal_calc.py not calculate arithmetic with in the same file?

Hi Cleo, Just been dealing with this type of issue. It’s likely that the byte datatype is overflowing. Try something like: --calc (A.astype(int)-B.astype(int))/(A.astype(int)+B.astype(int)) Actually you might only need to cast one of the bands from byte to int, so the syntax could be:

Re: [gdal-dev] ArcGIS RestAPI JSON Polygons

Looking at the ogresrijsonreader.cpp code I can see I assumed that a esriPolygon was just a OGC Polygon, so with outer ring first and then inner rings. Fixing the code to support multi polygons should basically be a matter of calling OGRGeometryFactory::organizePolygons. Thanks Even. Anyway

Re: [gdal-dev] ArcGIS RestAPI JSON Polygons

My apology for confusion. I guess, your request is valid then you may want to open ticket. No probs. Thanks I've raise a ticket here: http://trac.osgeo.org/gdal/ticket/5538 Cheers Jeremy This message contains information, which may be in confidence and may be subject to legal privilege. If

Re: [gdal-dev] ArcGIS RestAPI JSON Polygons

http://resources.arcgis.com/en/help/arcgis-rest-api/index.html#//02r300n100 Can you? There is no geometry of multipolygon specified. AFAIU, for multipolygon ESRI REST produces a hybrid: a Polygon that contains detached rings (or rings not in other rings, so they are not holes) and

Re: [gdal-dev] ArcGIS RestAPI JSON Polygons

Might be. I just pointed out that OGR GeoJSON driver is dedicated to GeoJSON specifically, not any JSON-encoded format of geometry. But doesn't the OGR GeoJSON driver have specific Esri JSON code? http://trac.osgeo.org/gdal/browser/trunk/gdal/ogr/ogrsf_frmts/geojson/ogresrijsonreader.cpp

[gdal-dev] ArcGIS RestAPI JSON Polygons

, Jeremy Palmer LINZ Data Service Manager Landonline Geospatial Services E jpal...@linz.govt.nz | DDI +64 4 498 3537 | M +64 27 2747 862 Wellington Office, Level 7, Radio New Zealand House, 155 The Terrace PO Box 5501, Wellington 6145, New Zealand | T 04 460 0110 W www.linz.govt.nzhttp

Re: [gdal-dev] GDAL/OGR 1.11.0 Release Candidate 1 available for testing

I've just been testing GDAL/OGR 1.11.0 and the MBTiles driver does not seem to be reading transparency information. Not sure if this is new to 1.11.0 or was an issue there before. Ticket here: http://trac.osgeo.org/gdal/ticket/5439 Cheers, Jeremy This message contains information, which may

Re: [gdal-dev] Ogr2ogr and default value of -gt

I do not believe it is so much about performance but perhaps at some time RDBMS whith is accessed through a slow network would get a timeout and decides to do a rollback. And RDBMS must also reserve resources for being able to rollback the whole transaction. The -gt option is still there and

[gdal-dev] Force application of ntv2 grid

Hi gdal-devs, I'm trying to shift shapefile data using a custom NTv2 grid file. The logical source and destination coordinate systems are the same (geographic coordinates EPSG:4167), I only want to shift the data. The type of command I'm trying to run is: ogr2ogr -f Esri Shapefile -a_srs

[gdal-dev] ECW lossless JPEG 2000 compression issue

Hi Devs, I'm using the GDAL ECW plugin with the ECW 3.3 SDK (2006-09-06) on windows and LINUX. I have built the ECW lib and GDAL plugin from source and have applied all the suggested patches from here: http://trac.osgeo.org/gdal/wiki/ECW However I'm getting quality issues with when reading

Re: [gdal-dev] ECW lossless JPEG 2000 compression issue

2000 compression issue Jeremy Palmer JPalmer at linz.govt.nz writes: Has anyone else had issues when reading lossless JPEG 2000 files in the 3.3 SDK? Have I got all of the patches applied? You are out of luck with 3.x SDK. You need SDK 4.2 or above, see http://trac.osgeo.org/gdal/ticket/2805

Re: [gdal-dev] [Qgis-developer] QGIS 2.0.0 Final Tagged - call for

Hi GDAL devs, It is possible get the OSGeo4W 32bit GDAL 1.10 binary packaged soon? Thanks Jeremy On Mon, 09. Sep 2013 at 20:56:51 +1200, Jeremy Palmer wrote: Can I suggest to the windows packagers (especially OSGeo4w admins) that QGIS is linked to gdal 1.10 so Esri FileGDB support works. I

Re: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux

: Even Rouault [even.roua...@mines-paris.org] Sent: Tuesday, 13 August 2013 7:23 p.m. To: Jeremy Palmer Cc: 'Even Rouault'; 'gdal-dev@lists.osgeo.org'; 'qgis-develo...@lists.osgeo.org' Subject: RE: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux Selon Jeremy Palmer jpal...@linz.govt.nz

Re: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux

From: Jeremy Palmer Sent: Tuesday, 13 August 2013 9:50 p.m. To: Even Rouault Cc: 'gdal-dev@lists.osgeo.org'; 'qgis-develo...@lists.osgeo.org' Subject: RE: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux Nope I get a crash when opening now via OGRSFDriverRegistrar::Open

Re: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux

Any chance to get this change back-ported to 1.10 so QGIS 2.0 will work with FIleGDBs? I've just done that (although the changeset is a bit more substantial/risky than the usual fixes done in stable branch). Thanks! I see the QGIS dev team is looking to release 2.0 about the 7th of Sept.

Re: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux

guessing the fix for this should really be done at the Esri library level, but because we have no control over this maybe something can be done in the OGR library to reuse FileGDBAPI Geodatabase handles? Cheers, Jeremy -Original Message- From: Jeremy Palmer Sent: Sunday, 11 August 2013 9:08

Re: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux

a.m. To: gdal-dev@lists.osgeo.org Cc: Jeremy Palmer; 'qgis-develo...@lists.osgeo.org' Subject: Re: [gdal-dev] QGIS hanging when opening a FileGDB on 64 bit Linux Le lundi 12 août 2013 22:12:11, Jeremy Palmer a écrit : Further to this I see that when you open a FIleGDB in QGIS 3 OGROpen calls made

[gdal-dev] MSSQLSpatial support for non-spatial tables

Hi gdal devs, I've attached a patch to http://trac.osgeo.org/gdal/ticket/5155 to support listing, reading and writing of non-spatial tables within the MSSQLSpatial driver. The change also allows the user to set the MSSQLSPATIAL_LIST_ALL_TABLES=YES configuration option to be able to read and

[gdal-dev] WFS and HTTP compression

Hi All, I've being doing some bandwidth analysis when using GDAL/OGR trunk with a Geoserver WFS 1.1.0 server. I've found that gzip HTTP compression is not used when requesting the data in the GML2 and GML3 output format if OGR_WFS_USE_STREAMING is set to YES. However when requesting the

Re: [gdal-dev] WFS and HTTP compression

Because it doesn't take the same code path (GML uses /vsicurl_steaming/ while other output formats use CPLHttpFetch() that downloads the whole file into memory and then parses it). I've just added GZip compression request in /vsicurl_streaming/ (can be turned off by setting CPL_CURL_GZIP to

[gdal-dev] Missing Python Geometry Methods

Any reason these methods are missing from the python geometry API: swapXY() Polygonize() ?? This message contains information, which is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this

[gdal-dev] Python API

Hi All, I've got a few questions about the support and future of some method calls within the OGR Python API. 1/ What is preferred way to method to access geometries from features? is it feature.geometry() or feature.GetGeometryRef()? geometry() seems funny as it's not well documented and is

Re: [gdal-dev] WFS Axis order issue with projected coordinate system

2013 9:52 p.m. To: gdal-dev@lists.osgeo.org Cc: Jeremy Palmer Subject: Re: [gdal-dev] WFS Axis order issue with projected coordinate system Funny thing is ogrinfo reports the SRS with the correct axis order. Of course I can add SRSNAME=EPSG:2193 to the URL, but I'd rather the GDAL internals

Re: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0

@lists.osgeo.org Subject: Re: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0 Jeremy Palmer JPalmer at linz.govt.nz writes: So could it be a http streaming issue? Actually the error that is reported in your debug log file has happened also in the same location: mismatched tag at line 2, column 3621905

Re: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0

No problem at all. I'm sure it has something do with the new streaming option in GDAL/OGR 1.10. If I run the query with the OGR_WFS_USE_STREAMING config set to NO it works: ogrinfo --config OGR_WFS_USE_STREAMING NO -dialect sqlite -sql select id, shape from \v:x1571\ WHERE id = 3241251

[gdal-dev] ogr WFS GML parse error with WFS 1.1.0

When use WFS to pull a large GML object it fails: ogrinfo -dialect sqlite -sql select id, shape from \v:x1571\ WHERE id = 3241251 WFS:'http://wfs.data.linz.govt.nz/84f646e35be34843abd9cee6085b50d6/v/x1571/wfs' ERROR 1: XML parsing of GML file failed : mismatched tag at line 2, column 3621825

Re: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0

about mid last week. From: gdal-dev-boun...@lists.osgeo.org [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of Jeremy Palmer Sent: Wednesday, 27 February 2013 10:49 a.m. To: gdal-dev@lists.osgeo.org Subject: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0 When

Re: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0

with WFS 1.1.0 Jeremy Palmer JPalmer at linz.govt.nz writes: When use WFS to pull a large GML object it fails: ogrinfo -dialect sqlite -sql select id, shape from \v:x1571\ WHERE id = 3241251 WFS:'http://wfs.data.linz.govt.nz/84f646e35be34843abd9cee6085b50d6/v/x1571/wfs' ERROR 1: XML

Re: [gdal-dev] ogr WFS GML parse error with WFS 1.1.0

should be fixed by r25691 Thanks. That works when using SimplifyPreserveTopology :) This message contains information, which is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.

Re: [gdal-dev] OGR WFS from behind NTLMv2 proxy server

Try setting GDAL_HTTP_PROXY=host:port and GDAL_HTTP_PROXYUSERPWD=user:pass as environmenet variables / configuration options. Still can't get it to work. Returns: ERROR 1: HTTP error code : 407 ERROR 1: Error returned by server : HTTP error code : 407 (0) ERROR 1: HTTP error code : 407 ERROR

[gdal-dev] OGR WFS from behind NTLMv2 proxy server

: HTTP error code : 407 (0) FAILURE: Cheers, Jeremy Palmer LINZ Data Service Manager Landonline Geospatial Services E jpal...@linz.govt.nzmailto:jpal...@linz.govt.nz | DDI +64 4 4983537 | M +64 27 2747 862 Wellington Office, Level 7, Radio New Zealand House, 155 The Terrace PO Box 5501, Wellington

[gdal-dev] WFS paging - STARTINDEX should start at 0 not 1

Hi, When using OGR WFS driver and paging support the first feature is missed when I query a Geoserver 2.1.X WFS 1.1.0 service. This is because OGR assumes the WFS STARTINDEX parameter is 1-based. However it now seems that the OGC standard of STARTINDEX has been clarified zero-based. This was

Re: [gdal-dev] WFS paging - STARTINDEX should start at 0 not 1

ok thanks Even. - Original Message - From: Even Rouault even.roua...@mines-paris.org To: gdal-dev@lists.osgeo.org gdal-dev@lists.osgeo.org Cc: Jeremy Palmer jpal...@linz.govt.nz, Robert Coup robert.c...@koordinates.com, Hamish Campbell hamish.campb...@koordinates.com Sent: 03/01/2013 7

Re: [gdal-dev] FileGDB -preserve_fid

At first sight, I would say it is a limitation of the FileGDB API. In FGdbLayer::CreateFeature( OGRFeature *poFeature ), you can see the following commented code : /* Cannot write to FID field - it is managed by GDB*/ //std::wstring wfield_name = StringToWString(m_strOIDFieldName);

Re: [gdal-dev] FileGDB -preserve_fid

Great thanks. -Original Message- From: gdal-dev-boun...@lists.osgeo.org [mailto:gdal-dev-boun...@lists.osgeo.org] On Behalf Of rburhum Sent: Friday, 14 December 2012 8:41 a.m. To: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] FileGDB -preserve_fid Although FileGDB does have

Re: [gdal-dev] FileGDB -preserve_fid

Thanks Even. It seems that just using the -sql options works nicely - you don't even need to do the column rename :) -Original Message- From: Even Rouault [mailto:even.roua...@mines-paris.org] Sent: Friday, 14 December 2012 7:56 a.m. To: Jeremy Palmer Cc: gdal-dev@lists.osgeo.org

[gdal-dev] FileGDB -preserve_fid

Hi, I'm trying to copy data from PostgreSQL to FileGDB. My PostgreSQL table has a primary key column and ogr indenties it as the FID e.g CREATE TABLE public.test_fileGDB ( id INTEGER PRIMARY KEY, data1 TEXT, shape GEOMETRY(POINT, 4167) ); INSERT INTO public.test_fileGDB (id, data1,

Re: [gdal-dev] EPSG 8.0 Upgrade

] On Behalf Of Frank Warmerdam [warmer...@pobox.com] Sent: Saturday, 8 December 2012 8:03 a.m. To: Jeremy Palmer Cc: gdal-dev; meta...@lists.osgeo.org Subject: Re: [gdal-dev] EPSG 8.0 Upgrade Jeremy, Unfortunately I do not automatically pickup references to grid shift files from the EPSG database

Re: [gdal-dev] 64bit integers

Thanks. Any idea if the 64bit proposal is going to happen any time soon? If not, is there an option to implement functionality to cast 64bit fields to string in 1.9.X? This function could still be useful once 64bit integers are implemented. Cheers Jeremy - Original Message - From:

[gdal-dev] 64bit integers

I have a WFS layer with a 64bit integer field (sufi): http://wfs.data.linz.govt.nz/83de09e2215a4d0c914dbfe28bb71557/v/x1208/wfs?service=WFS When using ogr this 64bit integer field gets truncated to 32bit without any warning. E.g ogrinfo -al

[gdal-dev] Setting CS for FileGDB layers

Hi All, When creating an Esri FileGDB layer the spatial reference system has to be defined using the Esri WKT definition. Otherwise you get an General function failure error. In particular the WKT coordinate system code name needs to match the name within the Esri WKT database which is

Re: [gdal-dev] Setting CS for FileGDB layers

. To: gdal-dev@lists.osgeo.org Cc: Jeremy Palmer Subject: Re: [gdal-dev] Setting CS for FileGDB layers Le dimanche 30 septembre 2012 09:52:56, Jeremy Palmer a écrit : Hi All, When creating an Esri FileGDB layer the spatial reference system has to be defined using the Esri WKT definition. Otherwise you

Re: [gdal-dev] Setting CS for FileGDB layers

Sorry my bad. I was still calling MorphToESRI on my cs object before creating the layer. Everything is working great now. From: gdal-dev-boun...@lists.osgeo.org [gdal-dev-boun...@lists.osgeo.org] On Behalf Of Jeremy Palmer Sent: Monday, 1 October 2012 6

Re: [gdal-dev] Layer creation option FID (Spatialite, MSSQL)

Yes it could be implemented. The limiting factor is the available spare time ;-) Thanks - that's what I thought. What do you mean by working correctly? Did you find issues? No I only looked at the code and didn't actually test it. I just wanted to ask the devs to determine if this was

[gdal-dev] Layer creation option FID (Spatialite, MSSQL)

Any limiting factors in improving the Spatialite and MSSQLSpatial drivers to allow defining the feature ID column LCO like the PostgreSQL (FID) or FileGDB (OID_NAME) drivers? Also, do Spatialite, MSSQL user defined tables with PKs already set work correctly in OGR? Thanks Jeremy This

[gdal-dev] OGR WFS WFSLayerMetadata broken

I'm trying to setup a simple python script to query the WFS layers from a service. When using the special WFSLayerMetadata layer it seems to get screwed up. After the first comma within an abstract is found the field alignment becomes broken.. If I look here

[gdal-dev] RE: Copying FIDs into existing PG schema

Any chance? Should I log a bug report? Hi When using the config PG_USE_COPY option the copy command does not include the destination FID in the field list. In my case the destination FID field is a primary key with a not null constraint, so the copy fails. e.g. ogr2ogr --config

RE: [gdal-dev] Copying FIDs into existing PG schema

-dev@lists.osgeo.org Cc: Jeremy Palmer Subject: Re: [gdal-dev] Copying FIDs into existing PG schema Is there a specific reason for the OGRPGTableLayer::BuildCopyFields (and CreateFeatureViaCopy) checking that the field must exist in the layer FieldDefn before adding it to the copy field

[gdal-dev] Copying FIDs into existing PG schema

Hi When using the config PG_USE_COPY option the copy command does not include the destination FID in the field list. In my case the destination FID field is a primary key with a not null constraint, so the copy fails. e.g. ogr2ogr --config PG_USE_COPY TRUE -append -preserve_fid -f PostgreSQL

[gdal-dev] Loading data in MSSQL using ogr2ogr

Hi, I'm trying to load a CSV file into an existing MSSQL 2008 table using ogr2ogr: ogr2ogr -preserve_fid --debug on -append -skip failures -f MSSQLSpatial MSSQL:server=\SQL_SERVER_2008;Integrated Security=true;database=;tables=test_csv_table_1(shape) test1.vrt -nln test_csv _table_1

[gdal-dev] How to append data into an existing database table

Hi All, I've got an existing spatial table in PostgreSQL with has an existing primary key (non-serial) and shape column: CREATE TABLE test_1 ( id integer NOT NULL, appellation TEXT, affected_surveys TEXT, parcel_intent TEXT NOT NULL, topology_type VARCHAR(100) NOT NULL,

RE: [gdal-dev] How to append data into an existing database table

] Sent: Tuesday, 10 January 2012 11:24 a.m. To: gdal-dev@lists.osgeo.org Cc: Jeremy Palmer Subject: Re: [gdal-dev] How to append data into an existing database table Le lundi 09 janvier 2012 22:47:21, Jeremy Palmer a écrit : Hi All, I've got an existing spatial table in PostgreSQL with has

RE: [gdal-dev] How to append data into an existing database table

Ah ok. I was hoping to avoid that. -Original Message- From: Even Rouault [mailto:even.roua...@mines-paris.org] Sent: Tuesday, 10 January 2012 1:49 p.m. To: Jeremy Palmer Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] How to append data into an existing database table Le