[gdal-dev] Open a string (json) as STACIT in python

I’m building a stac item collection programmatically and I want to open that item collection in gdal using the python bindings. It all works if I save to a file or from a url (and I prefix with “STACIT:”) but I cannot seem to be able to open a variable containing json as STACIT. I have tried

[gdal-dev] Converting parquet to geopackage

Using gdal3.8 (ghcr.io/osgeo/gdal:ubuntu-full-3.8.0) , got an error I haven’t seen before: ReadNext() failed: Couldn't deserialize thrift: TProtocolException: Exceeded size limit Deserializing page header failed. This happened at 92% Command: ogr2ogr -f gpkg /data/overturemaps_2023_11_14.gpkg

Re: [gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with spatial

Ivan, I've never tried OS authentication. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: Ivan Lucena > Date: Wednesday, October 14, 2015 at 9:44 AM To: Michael Smith

Re: [gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with spatial

Note that you can also use what Oracle calls the ezconnect syntax which is user/pass@host:port/service_name. Then no TNS is needed. Also note that port only needs to be specified if its not 1521. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 10/14/15, 3:56

Re: [gdal-dev] [EXTERNAL] Re: [GSOC] Support for m coordinates in OGRGeometries

Oracle definitely supports M. Mike Michael Smith US Army Corps Remote Sensing GIS/Center michael.sm...@usace.army.mil On 3/17/15, 11:20 PM, Even Rouault even.roua...@spatialys.com wrote: Selon Daniel Morissette dmorisse...@mapgears.com: FWIW I think support for M would be a very

Re: [gdal-dev] [EXTERNAL] How to use TRUNCATE lco with Oracle Spatial driver

Aileen, With the TRUNCATE option, do not use –append since append will disable the use of layer creation options. Use ogr2ogr -s_srs EPSG:27700 -t_srs EPSG:27700 -f OCI OCI::x/@XE PG:dbname=postgis active_schema=planning host=localhost user= password=! open_country -nln

Re: [gdal-dev] [EXTERNAL] ogr oracle unable to create index

Martin, The error indicates that there already is an index by that name. If you drop the index manually, then the spatial index will get created. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 4/15/14, 4:24 PM, Martin Landa landa.mar...@gmail.com wrote: Hi all, when

Re: [gdal-dev] [EXTERNAL] Re: ogr oracle multiple geometries

Oracle does support multiple geometry columns per table. Mike On 4/15/14, 6:29 PM, Even Rouault even.roua...@mines-paris.org wrote: Le mardi 15 avril 2014 23:43:13, Martin Landa a écrit : Hi, when importing my testing GML file to Oracle DB I discovered that layers with multiple geometries

Re: [gdal-dev] [EXTERNAL] oci and oracle express 11

Martin, You need a bit more info in the connection ogrinfo -ro OCI:user/password@hostname/sid -sql select count(*) from emp Where hostname is the server name (or something like localhost) and sid is the oracle instance name. if this is XE, then the sid is xe So try ogrinfo -ro

Re: [gdal-dev] [EXTERNAL] oci and oracle express 11

What does lsrnctl status Return? That will report back the status of the listener and the host, port and sid info. Mike On 4/9/14, 6:47 PM, Martin Landa landa.mar...@gmail.com wrote: Hi Micheal, 2014-04-10 0:39 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil

Re: [gdal-dev] [EXTERNAL] oci and oracle express 11

give you some more information. Does sqlplus connect and allow access? Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 4/9/14, 7:11 PM, Martin Landa landa.mar...@gmail.com wrote: 2014-04-10 1:00 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil: What does

Re: [gdal-dev] [EXTERNAL] oci and oracle express 11

If user/passwd@xe works in sqlplus, you can use that in OGR. Its using the same libs to connect. Try ogrinfo -ro OCI:user/passwd@xe Mike On 4/9/14, 8:01 PM, Martin Landa landa.mar...@gmail.com wrote: Hi, 2014-04-10 1:40 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil

Re: [gdal-dev] [EXTERNAL] /vsicurl/ and gz files

Jose, You can use /vsigzip/ with /vsicurl Try gdalinfo /vsigzip/vsicurl/http://www.globalbedo.org/GlobAlbedo29/tiles/2004/h17v04/GlobAlbedo.2004001.h17v04.nc.gz Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: Jose Gomez-Dans

Re: [gdal-dev] [EXTERNAL] Minimum user rights needed for Oracle driver

Jukka, Basically, you need read access to the schema.table in question. The spatial views are automatically available if a user has read access to the table. So the minimum access is GRANT SELECT on SCHEMA.TABLENAME to USERNAME; ALL_SDO_GEOM_METADATA is a view that contains metadata

Re: [gdal-dev] [EXTERNAL] Minimum user rights needed for Oracle driver

-- Michael Smith US Army Corps Remote Sensing GIS/Center On 10/1/13 4:58 PM, Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil wrote: Jukka, Basically, you need read access to the schema.table in question. The spatial views are automatically available if a user has read access

Re: [gdal-dev] [EXTERNAL] Minimum user rights needed for Oracle driver

Sensing GIS/Center On 10/1/13 4:58 PM, Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil wrote: Jukka, Basically, you need read access to the schema.table in question. The spatial views are automatically available if a user has read access to the table. So the minimum access is GRANT

Re: [gdal-dev] FileGDB Driver coordinate system support

The ESRI FileGDB api only supports certain projections, BC Albers (epsg:3005) is evidently not one of them. Its in ESRI API issue. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center From: Hailey Eckstrand haileyeckstr...@gmail.commailto:haileyeckstr...@gmail.com Date: Wednesday,

[gdal-dev] Overflow in geojson values

I'm reading a geojson feed put out by the USGS (http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_day.geojson) but the time/updated values are overflowing. Are there any settings to allow the data to come across as bigint or strings? For example:

Re: [gdal-dev] Overflow in geojson values

Unfortunately, that¹s after the data has been read and overflowed. The time should be 1375291903959. Updated should be 1375295733317. Mike On 8/1/13 2:21 PM, Kyle Shannon k...@pobox.com wrote: On Thu, Aug 1, 2013 at 11:36 AM, Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil wrote

Re: [gdal-dev] FileGDB for rasters

Martin, The current FileGDB api available from ESRI does not support rasters. It would probably be implemented fairly soon after ESRI provides such capability in their api. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 2/3/13 9:00 AM, Martin Landa landa.mar...@gmail.com

Re: [gdal-dev] Q: on gdalwarp of ecw file

I've found setting PHOTOMETRIC=YCBCR to allow much higher compression when using jpeg compression in gtifs. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center From: Jan Hartmann j.l.h.hartm...@uva.nlmailto:j.l.h.hartm...@uva.nl Date: Tuesday, December 18, 2012 5:47 AM To: Jukka

Re: [gdal-dev] Q: on gdalwarp of ecw file

/photometric-rgb-ycbcr/ On 12/18/2012 12:59 PM, Smith, Michael ERDC-RDE-CRREL-NH wrote: I've found setting PHOTOMETRIC=YCBCR to allow much higher compression when using jpeg compression in gtifs. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center From: Jan Hartmann j.l.h.hartm

Re: [gdal-dev] ORA-01406 error when reading many attributes from Oracle

Jukka, If the field is 17 char wide (rather than 17 bytes wide) then that is your problem. A varchar2 column can use either char or byte specifications. http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements001.htm#i 45694 If neither char or byte is specified, it defaults to your

Re: [gdal-dev] About sqlite tileindex and Mapserver

Jukka, Perhaps you can document this on the Wiki as a Spatialite example in addition to the example for Oracle (https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Dat abase-RASTERS) Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 8/24/12 7:12 AM,

Re: [gdal-dev] When and why ogrinfo sends update for Oracle?

Jukka, I'm responsible for the code the calculates the min/max extents for inserting/updating the USER_SDO_GEOM_METADATA view. This is supposed to only be run via ogr2ogr when loading/updating tables (I didn;t write that part, just the query to get those extents). There shouldn't be any updating

Re: [gdal-dev] When and why ogrinfo sends update for Oracle?

-- Michael Smith US Army Corps Remote Sensing GIS/Center On 8/22/12 8:01 AM, Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil wrote: Jukka, I'm responsible for the code the calculates the min/max extents for inserting/updating the USER_SDO_GEOM_METADATA view. This is supposed

Re: [gdal-dev] When and why ogrinfo sends update for Oracle?

Jukka, Actually, it doesn't matter since only one value is used in the query, min or max return the same result. Its just using the min function with the group by to aggregate the values into one row. All the other values are null. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps

Re: [gdal-dev] gdaltindex

Mapserver does. I've used Oracle as a source for a tile index so sqlite should work as well. See https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Data base-RASTERS for using Oracle And you could add SQLite to the Wiki as well (if it works). Mike On 8/21/12 5:24 PM, Even

Re: [gdal-dev] [Proposed new feature] A 'SQLite SQL dialect for OGR

This is wicked cool. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 8/18/12 1:03 PM, Even Rouault even.roua...@mines-paris.org wrote: Hi folks, I've attached in http://trac.osgeo.org/gdal/attachment/ticket/4782/sqlite_dialect.patch a patch that adds a SQLite alternate

Re: [gdal-dev] OSM Driver and World Planet file (pbf format)

OK, I'll retest with these changes. Thanks! Mike On 7/24/12 6:08 PM, Even Rouault even.roua...@mines-paris.org wrote: Le lundi 23 juillet 2012 19:25:22, Smith, Michael ERDC-CRREL-NH a écrit : Even, [osmusr@bigserver-proc osm]$ ogr2ogr -progress -f oci oci:user/pass@tns:tmp

[gdal-dev] OSM Driver and World Planet file (pbf format)

I'm finding that the new OSM Driver (I tested again with r24699) has a problem when working with the whole planet file. When I tried with the US Northeast subset, I got multipolygons and multilinestring entries. When reading the whole planet file, I did not. It gets to 70% and then ends (but

Re: [gdal-dev] Problem with gdalwarp

Jeff, The coordinates you are using with -te are not in the coordinate system of the image. From the docs -te xmin ymin xmax ymax:set georeferenced extents of output file to be created (in target SRS). Convert the lat/lon coordinates you are using to the srs of the image and then try it.

[gdal-dev] How to use RPC Metadata from NITF Files in a MapServer TileIndex

I have a large number of NITF JP2K files. These files have IGEOLO metadata to the second accuracy so reprojecting these images leads to poor results. The images also have rpc metadata and using the -rpc option in gdalwarp reprojects them quite well. These files are source epsg:4326 and need to

Re: [gdal-dev] How to use RPC Metadata from NITF Files in a MapServer TileIndex

PHOTOMETRIC_OVERVIEW YCBCR --config INTERLEAVE_OVERVIEW PIXEL $1.tif 2 4 8 16 32 Mike On 6/17/12 12:38 PM, Even Rouault even.roua...@mines-paris.org wrote: Le dimanche 17 juin 2012 18:24:29, Smith, Michael ERDC-RDE-CRREL-NH a écrit : I have a large number of NITF JP2K files. These files have IGEOLO metadata

Re: [gdal-dev] How to use RPC Metadata from NITF Files in a MapServer TileIndex

Thanks Even. This is working well. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 6/17/12 1:10 PM, Even Rouault even.roua...@mines-paris.org wrote: Actually, you'll need to add --config GDAL_TIFF_INTERNAL_MASK YES to the 2 following commands : gdal_translate -b 1 -b 2