Re: [gdal-dev] ogr2ogr no longer works with non super user in PG after update

2024-06-11 Thread Alexandre Gacon via gdal-dev
porting a shapefile > since there is a layer metadata item set on the shapefile layer when > reading it, that gets automatically imported by ogr2ogr. You can workaround > the issue by specifying the "-nomd" ogr2ogr option > > Even > Le 11/06/2024 à 17:33, Alexandre Gacon via gda

[gdal-dev] ogr2ogr no longer works with non super user in PG after update

2024-06-11 Thread Alexandre Gacon via gdal-dev
gr or is there a way to dismiss this message? Regards -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] GDAL Maintainers Meeting Minutes

2024-02-02 Thread Alexandre Gacon via gdal-dev
ket. > > The next GDAL Maintainers Meeting is 02/22/2024 at 9:00 EDT. Any PSC > members are welcome to join by reaching out to me for an invite. > > Howard > ___ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > ___

Re: [gdal-dev] ogr2ogr preserve fid behavior

2022-10-14 Thread Alexandre Gacon
; > -Jukka Rahkonen- > > > > *Lähettäjä:* gdal-dev *Puolesta *Alexandre > Gacon > *Lähetetty:* torstai 13. lokakuuta 2022 11.13 > *Vastaanottaja:* gdal-dev > *Aihe:* [gdal-dev] ogr2ogr preserve fid behavior > > > > Hello, > > > > I am trying to upload

[gdal-dev] ogr2ogr preserve fid behavior

2022-10-13 Thread Alexandre Gacon
quot;id" column as primary key with the values of my input ? -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Alexandre Gacon
ns väg 12 Kristianstad > mobile: +46 733 206831 > mailto: andreas.oxenstie...@t-kartor.com > www.t-kartor.com > ___ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/gdal-dev > -- Al

Re: [gdal-dev] gdal og2ogr: insert/update postgis table from SHP?

2022-06-06 Thread Alexandre Gacon
lause? (non-geom field and geom field?). When, like me, we have a > shp input and a postgis table output, should we rather prioritize the > approach with -append -addfield (or -update) rather than the approach with > -sql? > For input shp, the name of geometry field (that shoud be set into sql > query) is always "geom"? If not, what would be the way to find out? > > > Thanks a lot. > ___ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/gdal-dev > -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-27 Thread Alexandre Gacon
er. > > > > -Jukka Rahkonen- > > > > *Lähettäjä:* gdal-dev *Puolesta *Alexandre > Gacon > *Lähetetty:* maanantai 23. toukokuuta 2022 17.39 > *Vastaanottaja:* Jan Heckman > *Kopio:* gdal-dev > *Aihe:* Re: [gdal-dev] ogr2ogr Postgres upload performance > > > > I w

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-24 Thread Alexandre Gacon
but I don't think that the main problem is there. I wonder if using partitioned tables won't be a good choice ? Regards Alexandre Le lun. 23 mai 2022 à 21:57, Alexandre Gacon a écrit : > Hi, > > Thank you for the input. I will give a try to different combination and > shar

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-23 Thread Alexandre Gacon
_INDEX=NO -nln bygning3 > echo %time% > %cc% --config PG_USE_COPY no -nln bygning4 > echo %time% > pause > > === > > > > > Med venlig hilsen / Kind regards > > Bo Victor Thomsen > > Den 23-05-2022 kl. 15:03 skrev Alexandre Gacon: >

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-23 Thread Alexandre Gacon
te the SI after all is done. > I don't know how to turn off SI creation in the command line. > > On Mon, May 23, 2022 at 3:04 PM Alexandre Gacon > wrote: > >> Hello, >> >> I am using ogr2ogr to upload data from several geopackages to a postgis >> database.

[gdal-dev] ogr2ogr Postgres upload performance

2022-05-23 Thread Alexandre Gacon
(using INSERT instead of COPY). How could I data insertion for the other files? Force PG_USE_COPY ? Increase the value of GT ? Postpone spatial index creation ? Should I concatenate all the geopackages first and then insert the data in Postgis? Thank you for your help -- Alexandre Gacon

Re: [gdal-dev] Adding labels / specifying styles

2013-05-02 Thread Alexandre Gacon
. Is it possible ? How ? Thank you very much in advance for your help. Benoît __**_ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/**mailman/listinfo/gdal-devhttp://lists.osgeo.org/mailman/listinfo/gdal-dev -- Alexandre Gacon

[gdal-dev] Submiting patch on Postgres driver

2012-05-10 Thread Alexandre Gacon
Hi, I have added an option on the Postgres driver for OGR to avoid computation of the SRID of a spatial request when the SRID is known. Is it possible to add it to the code repository ? -- Alexandre Gacon ogr_pg.patch Description: Binary data

Re: [gdal-dev] Submiting patch on Postgres driver

2012-05-10 Thread Alexandre Gacon
Where can I create a osgeo login ? Regards Alexandre 2012/5/10 Jean-Claude Repetto jrepe...@free.fr On 05/10/12 08:27, Alexandre Gacon wrote: Hi, I have added an option on the Postgres driver for OGR to avoid computation of the SRID of a spatial request when the SRID is known

[gdal-dev] OGR and Postgis : use simpler request to determine the spatial projection

2012-04-25 Thread Alexandre Gacon
Hi, We use currently GDAL/OGR C++ API to execute complicated requests on a postgis database. Apparently, GDAL executes the request also to find the spatial reference of the result. Is it possible to bypass this behavior and thus to avoid the execution of our request ? -- Alexandre Gacon

Re: [gdal-dev] Differences in behavior between pgsql query and use of GDAL API

2011-06-14 Thread Alexandre Gacon
of a limitation in GDAL ? Should I used WKB instead of WKT to have the same result ? Regards, Alexandre Gacon 2011/6/13 Luca Sigfrido Percich sigfr...@tiscali.it Hi Alexandre, if I well understood your problem, you're already doing half of the job (the queries)in PostGIS, so why not doing everything

[gdal-dev] Differences in behavior between pgsql query and use of GDAL API

2011-06-13 Thread Alexandre Gacon
all my computations in postgis ? -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] Ask for performance tips

2011-06-09 Thread Alexandre Gacon
? -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] GDAL in Citrix

2011-05-18 Thread Alexandre Gacon
Hi Paul, I don't know what do you mean but our product which uses the GDAL dll works well over CITRIX for a lot of customers. Regards, Alexandre Gacon 2011/5/18 Paul Bartschi pbarts...@fs.fed.us Hello, I have received a request to deploy GDAL through Citrix. Are there any known issues

[gdal-dev] GDAL stucked when trying to get a OGRCoordinateTransformation while being in a thread

2011-05-06 Thread Alexandre Gacon
srs from IGNF). If I copy/paste the definition of the IGNF file instead of using the preceding definition, the call works. Apparently, it's a problem with PROJ which seems to have a problem with the access to the IGNF file. Regards -- Alexandre Gacon

[gdal-dev] Unable to compile OCI driver

2011-02-07 Thread Alexandre Gacon
path but it has no effect. Any idea ? -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Unable to compile OCI driver

2011-02-07 Thread Alexandre Gacon
Hi, I found the problem : my colleague send me a 64bits version of the OCI. When compiling a 32 bits version of GDAL, it logically fails. Regards, Alexandre On Mon, Feb 7, 2011 at 3:48 PM, Frank Warmerdam warmer...@pobox.com wrote: On 11-02-07 04:08 AM, Alexandre Gacon wrote: Hi all, I

Re: [gdal-dev] C++ interface to lists of coordinate systems in data dir ?

2010-09-08 Thread Alexandre Gacon
http://lists.osgeo.org/mailman/listinfo/gdal-dev -- Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] OGR VRT Schema Support

2009-10-30 Thread Alexandre Gacon
Hi Franck, Does the field definitions will replace the need to define a csvt file for defining the types of a CSV file read with the VRT format to get geographical coordinates ? Best regards, Alexandre Gacon On Fri, Oct 30, 2009 at 9:18 AM, Frank Warmerdam warmer...@pobox.comwrote: Folks

[gdal-dev] Help with coordinate transformations in OGR

2009-09-28 Thread Alexandre Gacon
(EPSG:15939) which seems to handle my problem : is-there any mean to use it with OGR ? Best Regards, -- Alexandre Gacon Sent from Paris, France ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

[gdal-dev] [OGR] Build GDAL 1.6 with OGDI enabled

2009-01-22 Thread Alexandre Gacon
GDAL with the OGDI driver (But we lost the abality of GDAL 1.6 to read files inside zip/gzip files). Could you think of a better solution ? Perhaps encapsulating the cpl_vsil_gzip methods code in #ifdef HAVE_ZLIB would be a first solution. Best regards, Alexandre Gacon PS : this problem

[gdal-dev] OGR : problem with the OGDI driver

2009-01-21 Thread Alexandre Gacon
steps work fine too). The OGDI driver is listed under the gdal utilities (gdalinfo --formats) but it doesn't appear with ogrinfo --formats. What is wrong ? Best regards, Alexandre Gacon ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http