[gdal-dev] OCI driver in ogr_fdw postgresql extension

2022-01-20 Thread 黄宁
I want to read geo data from an oracle database. How should I create a server? I will try to create a server in this way. but can not connect to an oracle. CREATE SERVER ociserver FOREIGN DATA WRAPPER ogr_fdw OPTIONS ( datasource 'OCI:username/password@host:port:sid', format 'OCI' ); Thank y

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Mike
In the case if FileGDB, which driver you use to read the FileGDB makes a big difference. On Thu, Jan 20, 2022 at 8:59 AM Jon Morris wrote: > Hi Sean, > > > > That seems to be the best option. I was testing on Shapefile initially, > but after I posted, I tried a memory layer and got quite differe

Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Peter Löwe
Done. Congratulations to both GDAL and PROJ for minting their DOI ! Best, Peter > Gesendet: Donnerstag, 20. Januar 2022 um 16:49 Uhr > Von: "Even Rouault" > An: "Peter Löwe" > Cc: gdal-dev@lists.osgeo.org, "proj" > Betreff: Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook o

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Jon Morris
Hi Sean, That seems to be the best option. I was testing on Shapefile initially, but after I posted, I tried a memory layer and got quite different results. Ultimately, our output format is determined by clients (it's usually Shapefile or File GDB), so we'll just have to let them know there are

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Jon Morris
Hi Ian, That's more or less what I was doing, calling GetNextFeature twice. I figured GetFeatureCount would be doing that under the hood anyway, but it didn't seem to run any faster. Jon e: jon.mor...@jbarisk.com t: +44 (0)1756 799919 www.jbarisk.com All JBA Risk Management's email messages c

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Jon Morris
Hi Roman, I'm not sure how you would determine the kill time. Each individual call to GetFeatureCount is fairly quick, but when you're doing it a lot, in a loop, they add up. Here's an example output from the Python profiler: ncalls tottime percall cumtime percall filename:lineno(functio

Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Even Rouault
Ok, I went ahead with a manual upload of GDAL 3.4.1: https://zenodo.org/record/5884352 , with concept DOI being https://zenodo.org/record/5884351 Can you ask the zenodo help desk to link the later with the github releases of https://github.com/OSGeo/GDAL ? Same for PROJ 8.2.1: https://zenodo

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Sean Gillies
Hi Jon, The performance of GetFeatureCount, filters, and GetNextFeature depends a lot on the data format. If your data is in Postgres, for example, these operations are super fast because the database keeps the number of rows (features) in memory and has highly optimized views of selected rows. If

Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Peter Löwe
Hi, FYI here's the confirmation by Zenodo about the combined use of manual and automated software versioning: "It is possible to link manual releases to the GitHub integration automated workflow. You can go ahead and publish the two manual releases and share them here. We will then link them to

Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Peter Löwe
Hello Robert, hello Darafei, all,   DataCite also provides a citation service, which might work better: https://citation.crosscite.org/   Best, Peter       Gesendet: Donnerstag, 20. Januar 2022 um 11:05 Uhr Von: "Robert Coup" An: "Darafei Komяpa Praliaskouski" Cc: "gdal-dev@lists.osgeo

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Ian Turton
I'm not sure if it's a shortcut but couldn't you do a getFeatures loop with a counter and break after 2 times round the loop, then your counter would be 0,1 or 2 for your 3 cases. Ian On Thu, 20 Jan 2022 at 09:00, Jon Morris wrote: > I'm writing applications using the GDAL Python bindings and

Re: [gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Roman Breitfuss-Schiffer
Hi Jon! I don't know if there's an alternative to GetFeatureCount. At least I couldn't find one in the API documentation. Maybe there's a workaround I'm not aware of... What you could do is wrap the call of GetFeatrueCount in a function which is killed after some time (2 approaches are discu

Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Robert Coup
Hi Darafei, On Thu, 20 Jan 2022 at 09:55, Darafei "Komяpa" Praliaskouski wrote: > > Looking at this list, I don't know whether we effectively double the > amount of contributors, want to get introduced to Howard Łoskot, or should > do something about people separator and/or name-surname inversio

Re: [gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Komяpa
Hello, > *Cite as * > >> Rouault, Even, Warmerdam, Frank, Schwehr, Kurt, Kiselev, Andrey, Butler, >> Howard, Łoskot, Mateusz, Szekeres, Tamas, Tourigny, Etienne, Landa, Martin, >> Miara, Idan, Elliston, Ben, Kumar, Chaitanya, Plesea, Lucian, Morissette, >> Daniel, Jolma, Ari, & Dawson, Nyall. (20

[gdal-dev] Fwd: DOI for the GDAL project / Springer Handbook of Geoinformatics

2022-01-20 Thread Peter Löwe
Hello gdal-dev-list, regarding the current discussion on how to register DOI for GDAL, I've contacted the helpdesks of Zenodo and DataCite. DataCite is the organisation providing the global DOI-infrastructure. Zenodo is an open access repository where a growing number of OSGeo projects already

[gdal-dev] Faster alternative to GetFeatureCount?

2022-01-20 Thread Jon Morris
I'm writing applications using the GDAL Python bindings and when I profile for performance, GetFeatureCount frequently comes out near the top. I'm often using it to check whether a spatial or attribute filter has returned any features and don't need the full count. When the layer contains millio