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

2024-03-11 Thread Smith, Michael ERDC-RDE-CRREL-NH CIV via gdal-dev
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 wit

[gdal-dev] Converting parquet to geopackage

2023-11-16 Thread Smith, Michael ERDC-RDE-CRREL-NH CIV via gdal-dev
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

2015-10-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
Ivan, I've never tried OS authentication. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: Ivan Lucena mailto:lucena_i...@hotmail.com>> Date: Wednesday, October 14, 2015 at 9:44 AM To: Michael Smith mailto:michael.sm...@erdc.dren.mil>>, Jukka Rahkonen mailto:j

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

2015-10-14 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 AM

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

2015-03-18 Thread Smith, Michael ERDC-RDE-CRREL-NH
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" wrote: >Selon Daniel Morissette : > >> FWIW I think support for M would be a very welcome addition. An >> immediate use I'd see fo

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

2014-06-20 Thread Smith, Michael ERDC-RDE-CRREL-NH
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] Re: ogr oracle multiple geometries

2014-04-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
Oracle does support multiple geometry columns per table. Mike On 4/15/14, 6:29 PM, "Even Rouault" 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 are not handled by

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

2014-04-15 Thread Smith, Michael ERDC-RDE-CRREL-NH
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" wrote: >Hi all, > >when playing with Oracle I

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

2014-04-09 Thread Smith, Michael ERDC-RDE-CRREL-NH
If /@xe works in sqlplus, you can use that in OGR. Its using the same libs to connect. Try ogrinfo -ro OCI:/@xe Mike On 4/9/14, 8:01 PM, "Martin Landa" wrote: >Hi, > >2014-04-10 1:40 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH >: >> Hmm, this one should have wor

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

2014-04-09 Thread Smith, Michael ERDC-RDE-CRREL-NH
p" That might 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" wrote: >2014-04-10 1:00 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH >: >> Wh

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

2014-04-09 Thread Smith, Michael ERDC-RDE-CRREL-NH
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" wrote: >Hi Micheal, > >2014-04-10 0:39 GMT+02:00 Smith, Michael ERDC-RDE-CRREL-NH >: > >[...] >

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

2014-04-09 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 OCI:user/pass

Re: [gdal-dev] [EXTERNAL] Gdal 1.10.1 with OCI and ODBC doesn't compile right

2014-04-07 Thread Smith, Michael ERDC-RDE-CRREL-NH
David, For using OCI with GDAL and --with-oci-lib, you need both oci-lib and oci-include For example: --with-oci-include=/home/oracle/local/instantclient_11_2 --with-oci-lib=/home/oracle/local/instantclient_11_2 And for the lib, you need to symlink libclntsh.so.11.x -> libclntsh.so libocci.s

[gdal-dev] HOW-TO convert USGS topo to GTiff

2014-03-27 Thread Smith, Michael
I have had several people send me follow-up emails about converting the USGS eTopos (you can download these from store.usgs.gov), so I thought it might make sense to just post this to the list as a HOW-TO. Apologies for cross-post. The challenge is to take the GeoPDF that you download from USGS

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

2013-10-10 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 mailto:jgomezd...@gmail.com>> Date

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

2013-10-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
cky because our db admins tend to be jealous >about the MDSYS area. > >Nothing to worry about USER/ALL_SDO_INDEX_METADATA, is it handled >automatically together with read/write rights to tables and views? > >-Jukka- > >Smith, Michael wro

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

2013-10-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
-- Michael Smith US Army Corps Remote Sensing GIS/Center On 10/1/13 4:58 PM, "Smith, Michael ERDC-RDE-CRREL-NH" 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

2013-10-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 information

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

2013-08-07 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 mailto:haileyeckstr...@gmail.com>> Date: Wednesday, August 7, 2013 6:09 PM To:

Re: [gdal-dev] Overflow in geojson values

2013-08-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
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" wrote: >On Thu, Aug 1, 2013 at 11:36 AM, Smith, Michael ERDC-RDE-CRREL-NH > wrote: >> I'm rea

[gdal-dev] Overflow in geojson values

2013-08-01 Thread Smith, Michael ERDC-RDE-CRREL-NH
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: {"type":"Feature","properties":{"mag"

Re: [gdal-dev] FileGDB for rasters

2013-02-03 Thread Smith, Michael ERDC-RDE-CRREL-NH
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" wrote: >Hi, > >I fou

Re: [gdal-dev] GDAL/OGR 1.10.0 Beta1 Question

2013-01-22 Thread Smith, Michael ERDC-CRREL-NH
The EXIF metadata is data from Digital Cameras (see http://en.wikipedia.org/wiki/Exchangeable_image_file_format). This changes just puts the metadata in a specific domain. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 1/22/13 3:13 PM, "reina...@geodesign.com.br" wrote: >

[gdal-dev] substitute pixel values

2013-01-09 Thread Smith, Michael
I have some DEMs that are created from lidar. For reasons related to seeing currents and wind effect, we did not ask for the water to be flattened, but rather it shows waves. This is cool, and what we wanted. BUT of course now we want to create a second set of DEMs with a nice flat ocean. I

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

2012-12-18 Thread Smith, Michael ERDC-RDE-CRREL-NH
e: [gdal-dev] Q: on gdalwarp of ecw file Any ideas why this should be so, Mike? Is this the case for all images? I found a few pointers with Google, like the one below, but I am still unsure about the reasons. http://boatfloater.wordpress.com/2012/02/13/photometric-rgb-ycbcr/ On 12/18/2012 12

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

2012-12-18 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 mailto:j.l.h.hartm...@uva.nl>> Date: Tuesday, December 18, 2012 5:47 AM To: Jukka Rahkonen mailto:jukka.ra

Re: [gdal-dev] how to gdalwarp 4-band orthoimagery

2012-12-14 Thread Smith, Michael
lists.osgeo.org Cc: Smith, Michael Subject: Re: [gdal-dev] how to gdalwarp 4-band orthoimagery Le vendredi 14 décembre 2012 19:17:07, Smith, Michael a écrit : > Seems like this is a straightforward issue but finding it difficult to > solve online. > > > > I have a new crop of 4-band

[gdal-dev] how to gdalwarp 4-band orthoimagery

2012-12-14 Thread Smith, Michael
Seems like this is a straightforward issue but finding it difficult to solve online. I have a new crop of 4-band orthoimages, as GeoTIFFs. I want to create mosaics of some tiles. There is a slight pixel overlap at the edges. When I run gdalwarp it always treats the 4th band as alpha, which

Re: [gdal-dev] Convert kml to Shapefile and conserve polygon's colors with Ogr2Ogr

2012-10-22 Thread Smith, Michael ERDC-CRREL-NH
Wael, First, make sure you are using the libkml driver and not the kml driver. The libkml driver can read the style information. Then you can get that information in your shapefile by specifically requesting the ogr_style column. Try adding -sql 'select *, ogr_style as style from Layer0' Mike

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

2012-10-17 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 NL

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

2012-08-24 Thread Smith, Michael ERDC-RDE-CRREL-NH
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, "Rahkon

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

2012-08-22 Thread Smith, Michael ERDC-RDE-CRREL-NH
t;sdo_ub else null end) maxy > >-Jukka- > >Smith, Michael > >> >> 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 og

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

2012-08-22 Thread Smith, Michael ERDC-RDE-CRREL-NH
Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 8/22/12 8:01 AM, "Smith, Michael ERDC-RDE-CRREL-NH" wrote: >Jukka, > >I'm responsible for the code the calculates the min/max extents for >inserting/updating the USER_SDO_GEOM_METADATA view. This

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

2012-08-22 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 g

Re: [gdal-dev] gdaltindex

2012-08-21 Thread Smith, Michael ERDC-RDE-CRREL-NH
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

2012-08-18 Thread Smith, Michael ERDC-RDE-CRREL-NH
This is "wicked cool". Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center On 8/18/12 1:03 PM, "Even Rouault" 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 SQL dialect that ca

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

2012-07-24 Thread Smith, Michael ERDC-RDE-CRREL-NH
OK, I'll retest with these changes. Thanks! Mike On 7/24/12 6:08 PM, "Even Rouault" 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/pas

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

2012-07-23 Thread Smith, Michael ERDC-CRREL-NH
tween = 50006 OSM: nNodeSelectIn = 94362 VSI: ~VSIUnixStdioFilesystemHandler() : nTotalBytesRead = 12682608949 (note that I removed some alter table lines for clarity) Mike On 7/23/12 9:16 AM, "Smith, Michael ERDC-CRREL-NH" wrote: >Even, > >It stopped cleanly (no segfault)

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

2012-07-23 Thread Smith, Michael ERDC-CRREL-NH
og to a file. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 7/23/12 7:05 AM, "Even Rouault" wrote: >Le lundi 23 juillet 2012 12:56:12, Smith, Michael ERDC-RDE-CRREL-NH a >écrit : >> I'm finding that the new OSM Driver (I tested aga

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

2012-07-23 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 wit

Re: [gdal-dev] Problem reading shapefile via /vsizip

2012-07-13 Thread Smith, Michael ERDC-CRREL-NH
Ticket created http://trac.osgeo.org/gdal/ticket/4748 Mike On 7/13/12 6:30 AM, "Smith, Michael ERDC-CRREL-NH" wrote: >EvenR, > >This is GDAL trunk. > >I will check with --debug on. > >Mike > > > >On 7/13/12 6:19 AM, "Even Rouault&

Re: [gdal-dev] Problem reading shapefile via /vsizip

2012-07-13 Thread Smith, Michael ERDC-CRREL-NH
EvenR, This is GDAL trunk. I will check with --debug on. Mike On 7/13/12 6:19 AM, "Even Rouault" wrote: >Selon "Smith, Michael ERDC-CRREL-NH" : > >Michael, > >Do you use GDAL trunk, or 1.9.X ? It might be possible that fixes for >subtle >bugs co

[gdal-dev] Problem reading shapefile via /vsizip

2012-07-11 Thread Smith, Michael ERDC-CRREL-NH
Reading a zipped shapefile (with 4 shapefiles in it) via vsicurl and vsizip ogrinfo /vsizip//vsicurl/http://www.srh.noaa.gov/images/shv/shp/Day1_Conv_Outlook/Day1_Conv_Outlook.latest.zip -ro CATEGORICAL Layer name: CATEGORICAL Geometry: Polygon Feature Count: 1 Extent: (-119.60, 24.217000) -

Re: [gdal-dev] Problem with gdalwarp

2012-07-08 Thread Smith, Michael ERDC-RDE-CRREL-NH
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. Mi

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

2012-06-17 Thread Smith, Michael ERDC-RDE-CRREL-NH
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" wrote: >Actually, you'll need to add "--config GDAL_TIFF_INTERNAL_MASK YES" to >the 2 >following commands : > >gdal_translate -b 1 -b 2 -b 3 -mask 4 -co "TI

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

2012-06-17 Thread Smith, Michael ERDC-RDE-CRREL-NH
addo --config COMPRESS_OVERVIEW JPEG --config PHOTOMETRIC_OVERVIEW YCBCR --config INTERLEAVE_OVERVIEW PIXEL $1.tif 2 4 8 16 32 Mike On 6/17/12 12:38 PM, "Even Rouault" wrote: >Le dimanche 17 juin 2012 18:24:29, Smith, Michael ERDC-RDE-CRREL-NH a >écrit : >> I have a large number of N

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

2012-06-17 Thread Smith, Michael ERDC-RDE-CRREL-NH
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 b

RE: [gdal-dev] aux/lyr/rrd raster dataset?

2012-04-27 Thread Smith, Michael
They are all extra things that GDAL does not need: LYR is an ArcGIS layer file, it just stores symbology and so on about how to represent data in ArcMap. AUX is an auxiliary statistics file which ArcGIS generates for doing stretches, histograms, etc RRD is a pyramid file which ArcGIS generates to

Re: [gdal-dev] DBF indexing?

2012-04-25 Thread Smith, Michael ERDC-CRREL-NH
CREATE INDEX Some OGR SQL drivers support creating of attribute indexes. Currently this includes the Shapefile driver. An index accelerates very simple attribute queries of the form fieldname = value, which is what is used by the JOIN capability. To create an attribute index on the nation_id field

Re: [gdal-dev] gdal_translate crash on certain filenames

2012-04-17 Thread Smith, Michael ERDC-CRREL-NH
Looks like its a specific driver getting in the way http://trac.osgeo.org/gdal/ticket/4390 M From: Jay Jennings mailto:jennings@geoeye.com>> Date: Tuesday, April 17, 2012 6:11 PM To: "gdal-dev@lists.osgeo.org" mailto:gdal-dev@lists.osgeo.org>> Subject: [gdal

RE: [gdal-dev] Switching from ArcGIS to GDAL

2012-02-27 Thread Smith, Michael
Hi Jon - alas for we ArcGIS users, which even here in 2012 is still a single-threaded application. Who needs more than one CPU core anyway? So your ArcGIS choice is to split your batch up into 12 groups and run the processes simultaneously (which will then take all your CPUs), or use something els

Re: [gdal-dev] End User Questions :( KML Raster to Shapefile

2012-01-16 Thread Smith, Michael ERDC-CRREL-NH
Dennis, ogr2ogr can convert a kml file to a shapefile if built with the kml or libkml drivers (I recommend the libkml driver, it offers many more features). Mike From: Dennis Burgess mailto:dmburg...@linktechs.net>> Date: Mon, 16 Jan 2012 17:11:09 -0600 To: mailto:gdal-dev@lists.osgeo.org>> S

RE: [gdal-dev] GeoPDF translation

2011-12-13 Thread Smith, Michael
Thanks to those of you who pointed out the obvious -co "GDAL_PDF_DPI" which I somehow overlooked in the online docs. RTFM right... That said, I ran a test script using that CO and GDAL yields a warning message and then makes the export at 150dpi anyway. gdal_translate -co "GDAL_PDF_DPI=300" -c

RE: [gdal-dev] editor that color codes mapfile syntax?

2011-12-13 Thread Smith, Michael
http://sites.google.com/site/gianpierocampanella/files * Michael Smith State GIS Manager, Maine Office of GIS, Maine OIT Board Member, Maine GeoLibrary Board Member, Maine GIS Users Group State Rep, National States Geographic Information Council | MEGIS | GeoLibrary | MEGUG | NS

[gdal-dev] GeoPDF translation

2011-12-13 Thread Smith, Michael
I am trying to convert the historic USGS topo maps (GeoPDFs) into GeoTIFFs with GDAL 1.8 . A very straightforward thing to do is gdal_translate in.pdf out.tiff This works fine but the TIFF looks as if the PDF was exported at 150dpi, which is a pretty crappy resolution. Using something else (

Re: [gdal-dev] Extract centroids

2011-11-03 Thread Smith, Michael ERDC-CRREL-NH
This may not be the simplest way but you could use mapserver to draw the polygon layer as a point layer (at the centroids) and then use the wfs export format capability to export back to shapefile. Mike -- Michael Smith US Army Corps Remote Sensing GIS/Center From: Chaitanya kumar CH mailto:ch

Re: [gdal-dev] OGR FileGDB driver: Failed at creating table ... (General function failure.)

2011-09-15 Thread Smith, Michael ERDC-CRREL-NH
I've run into this. It seems to be that there are only certain projections that are supported in FileGDB. I tried to convert data in to the Spherical Mercator projection and none of the projections I used (either epsg, esri epsg, or esri wkt) would work. I believe that Even R. determined that it wa

RE: [gdal-dev] FileGDB OGR driver test

2011-07-30 Thread Smith, Michael ERDC-CRREL-NH
It is prefork [msmith@linux_wms_bm ~]$ httpd -V Server version: Apache/2.2.15 (Unix) Server built: Jul 23 2010 05:08:08 Server's Module Magic Number: 20051115:24 Server loaded: APR 1.4.2, APR-Util 1.3.9 Compiled using: APR 1.4.2, APR-Util 1.3.9 Architecture: 64-bit Server MPM: Prefork t

Re: [gdal-dev] FileGDB OGR driver test

2011-07-14 Thread Smith, Michael ERDC-CRREL-NH
Peter, In this case, the OSM data came from Cloudmade shapefiles for Colorado Highways and I converted it to a FileGDB using v10 ArcCatalog. -- Mike Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 7/14/11 2:58 AM, "Peter Halls" wrote: >Jeff, > > how was the OSM da

Re: [gdal-dev] FileGDB OGR driver test

2011-07-13 Thread Smith, Michael ERDC-CRREL-NH
Or anyone to download and test, just so its clear. Mike -- Mike Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 7/13/11 3:05 PM, "Smith, Michael ERDC-CRREL-NH" wrote: >Yes, it is ok for you to download and test. This is OSM data that I >created usi

Re: [gdal-dev] FileGDB OGR driver test

2011-07-13 Thread Smith, Michael ERDC-CRREL-NH
Yes, it is ok for you to download and test. This is OSM data that I created using ArcCatalog 10. Jeff also has a layer of US States that I created from OGR. It did have the extents. Mike -- Mike Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 7/13/11 2:54 PM, "Paul R

[gdal-dev] GDAL/OGR projection problem only with epsg:3785/900913

2011-07-01 Thread Smith, Michael ERDC-CRREL-NH
All, I¹m using GDAL (1.9dev r22508) and getting errors only when reprojecting (raster or vector) to any of the Google Mercator projections. On a number of linux boxes I have, this works fine, but, on a couple its a problem. The only difference on the problem boxes that I can see is that they have

Re: [gdal-dev] Problem Compiling with Oracle (--with-oci)

2011-06-21 Thread Smith, Michael D ERDC-CRREL-NH
I have the expat 1.95 added via standed RHEL repo and using oracle instant client (11.2) without a problem with GDAL from SVN I use ./configure \ --with-libtiff=internal \ --with-geotiff=internal \ --with-jpeg=internal \ --with-libz=internal \ --with-png=internal \ --with-

RE: [gdal-dev] LoadLayers (FGDB)

2011-05-06 Thread Smith, Michael ERDC-CRREL-NH
I can also supply more FGDB's with different types of layers, numbers, binary attachments, etc. Let me know if there is a specific type or types of layers/feature classes/feature datasets you need. Mike -Original Message- From: gdal-dev-boun...@lists.osgeo.org [mailto:gdal-dev-boun...@l

Re: [gdal-dev] FGDB Opening Sample File

2011-04-29 Thread Smith, Michael ERDC-CRREL-NH
, "Paul Ramsey" wrote: > Are they tables or links between tables? I can see this is going to > be a hard project to do without ArcGIS handy :) > > P. > > On Thu, Apr 28, 2011 at 10:26 AM, Smith, Michael ERDC-CRREL-NH > wrote: >> Relations are joins to non-spatia

Re: [gdal-dev] FGDB Opening Sample File

2011-04-28 Thread Smith, Michael ERDC-CRREL-NH
Relations are joins to non-spatial tables containing domain values etc. They are relational tables. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 4/28/11 1:19 PM, "Even Rouault" wrote: > Le jeudi 28 avril 2011 02:11:30, Paul Ramsey a écrit : >> >> I assume

Re: [gdal-dev] Re: FileGDB OGR driver test

2011-04-12 Thread Smith, Michael ERDC-CRREL-NH
I have a test v10 filegdb with points, lines, polygons (all with Z and M but I think the measures aren't populated). There are also some non geometry tables and some relationship classes. Its available at http://12.189.158.78:8081/downloads/test_fgdb.gdb.zip Mike -- Michael Smith Remote Sens

Re: [gdal-dev] Re: FileGDB OGR driver test

2011-04-12 Thread Smith, Michael ERDC-CRREL-NH
Even, How do you configure gdal/ogr to build with the linux api? I'm working on getting some example datasets together. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 4/12/11 2:28 PM, "Even Rouault" wrote: > Le mardi 12 avril 2011 19:08:24, Hermann Peifer a

Re: [gdal-dev] Re: FileGDB OGR driver test

2011-04-12 Thread Smith, Michael ERDC-CRREL-NH
Hermann, You can use the FileGDB driver with Linux. The FileGDB api has been available on Linux since Beta 2. I plan to do some testing in the next couple of days. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 4/12/11 1:08 PM, "Hermann Peifer" wrote: > On

Re: [gdal-dev] OGR2OGR PGeo reprojection with -sql

2011-04-11 Thread Smith, Michael D ERDC-CRREL-NH
case the SQL will be evaluated by OGR SQL > engine and not by the ODBC engine. The OGRSQL engine should be able to > retrieve the SRS from the layer. > >> >> On Mon, Apr 11, 2011 at 9:51 PM, Smith, Michael D ERDC-CRREL-NH < >> >> michael.sm...@usace.army.mil&g

[gdal-dev] OGR2OGR PGeo reprojection with -sql

2011-04-11 Thread Smith, Michael D ERDC-CRREL-NH
All, Using GDAL trunk, I can read and reproject a personal geodatabase using the internal projection as the source projection. However, when I use ­sql (as I need to add a new field to the output), the source projection can no longer be read. C:\temp>ogr2ogr -t_srs EPSG:4326 -f "ESRI Shapefile"

Re: [gdal-dev] accessing zip files by URL

2011-03-24 Thread Smith, Michael D ERDC-CRREL-NH
Joaquim, For .tar.gz, you can use /vsitar Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers Hanover, NH On 3/24/11 2:03 PM, "Joaquim Luis" wrote: > Even, Chaitanya > > Thanks for hint. > > I did read the http://trac.osgeo.org/gdal/wiki/UserDocs/ReadInZip but it

Re: [gdal-dev] RFC28 OGR SQL Expressions now in trunk

2010-09-14 Thread Smith, Michael ERDC-CRREL-NH
Frank, I was testing accesing the OGR_STYLE value from a kmz file using the LIBKML driver. Previously this had worked. u4rt9...@maps:/htdocs/dhs/marine$ ogr2ogr -f OCI oci:"user/p...@tns:marinetest MarineTraffic.kmz -nln MArineTest3 -lco dim=2 -lco srid-8265 -lco launder=yes -lco precision=no -sq

Re: [gdal-dev] Compiling GDAL --with-oci

2010-06-04 Thread Smith, Michael D ERDC-CRREL-NH
Ivan, Oracle express edition does support SDO_GEOMETRY. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers Hanover, NH On 6/4/10 3:05 AM, "Lucena, Ivan" wrote: > Iván Sánchez Ortega wrote: >> El 04/06/2010 10:46, Mateusz Loskot escribió: >>> open config.log and

Re: [gdal-dev] export SDO to SHP?

2010-05-26 Thread Smith, Michael ERDC-CRREL-NH
ogr2ogr -f "ESRI Shapefile" some_shapefile.shp OCI:user/p...@tns:schema.table_name Will do just that. Mike -- Michael Smith US Army Corps of Engineers Remote Sensing/GIS Center Hanover, NH On 5/26/10 1:53 AM, "Imran Rajjad" wrote: > Hi list, > > is it possile to import and SDO table in

Re: [gdal-dev] GDAL for BNG to Lat/Long, WGS84

2010-03-02 Thread Smith, Michael ERDC-USACE-NH
Frank and Scott, For Google Earth output (rather than Google Maps which would be in "google mercator") the output projection should be EPSG:4326, or WGS1984 Latitude Longitude. Mike -- Michael Smith RSGIS Center US Army Corps of Engineers On 3/2/10 12:52 AM, "Frank Warmerdam" wrote: > sc

Re: [gdal-dev] Why does OCI driver fail with SRID?

2009-11-30 Thread Smith, Michael ERDC-CRREL-NH
Jukka, To set the SRID when loading to Oracle, you have to use the layer creation option -lco srid=2393 Mike -- Michael Smith RSGIS Center US Army Corps of Engineers On 11/30/09 7:25 AM, "Jukka Rahkonen" wrote: > Hi, > > Short question: I cannot get ogr2ogr to co-operate with me and Or

[gdal-dev] how to batch rgb2pct

2009-09-24 Thread Smith, Michael
I have a .bat file which I'm trying to run, here are a few lines: rgb2pct v:\historic_topos\rects\w\arnold-pond-w.tif v:\historic_topos\8bits\w\arnold-pond-w.tif rgb2pct v:\historic_topos\rects\w\attean-w.tif v:\historic_topos\8bits\w\attean-w.tif rgb2pct v:\historic_topos\rects\w\baker-lake-w.ti

[gdal-dev] Use an existing image for projection

2009-01-26 Thread Smith, Michael
Related to my previous post, is there simply a way to specify an existing image as the template for projection? My problem is that the SID files I received are all in the same projection, yet some have the projection info encoded and others don't. This causes problems as I make mosaics with gdalw

[gdal-dev] Help with Maine state plane US feet

2009-01-26 Thread Smith, Michael
I am trying to work with several aerial photos which are in Maine State Plane West, NAD83, US feet. This is a commonly-used projection in Maine (along with Maine East), yet it is not found in the pcs.csv file that comes with FWTools/GDAL. In fact although there are several iterations of state pla

[gdal-dev] RE: Border slivers and JPEG2000 compression

2008-12-30 Thread Smith, Michael
pixels with value 0 in a TIFF to stay 0 in a resulting JP2 (with Kakadu) in GDAL? ** Michael Smith State GIS Manager Maine Office of GIS > _ > From: Smith, Michael > Sent: Monday, December 15, 2008 5:04 PM > To:

RE: [gdal-dev] JPEG compression in TIF doesn't work

2008-12-19 Thread Smith, Michael
821.275, 5121943.297) ( 69d37'30.07"W, 46d14'57.69"N) Upper Right ( 461549.275, 5135906.297) ( 69d29'59.88"W, 46d22'32.30"N) Lower Right ( 461549.275, 5121943.297) ( 69d29'55.76"W, 46d14'59.92"N) Center ( 456685.275, 5128924.797) ( 69d33

[gdal-dev] JPEG compression in TIF doesn't work

2008-12-19 Thread Smith, Michael
I have an 8-bit tif aerial photo, when I try to compress it with JPEG compression in any of the following examples: gdal_translate -ot Byte -of GTiff -co "COMPRESS=JPEG" -co "JPEG_QUALITY=100" allagash-lake.tif test_jpeg100_tif.tif gdal_translate -ot Byte -of GTiff -co "COMPRESS=JPEG" -co "JPEG_QU

RE: [gdal-dev] Border slivers and JPEG2000 compression

2008-12-18 Thread Smith, Michael
-Original Message- From: Matt Wilkie [mailto:matt.wil...@gov.yk.ca] Sent: Tuesday, December 16, 2008 1:50 PM To: Smith, Michael Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] Border slivers and JPEG2000 compression Hi Micheal, try the nearblack utility (which is a relatively new

[gdal-dev] Border slivers and JPEG2000 compression

2008-12-15 Thread Smith, Michael
I have several orthophotos which are TIFFs, and they align with the USGS quadrangle corners, which means they are rotated slightly, leaving small uneven slivers along the edges where pixel value is 0 (the data for these are available from adjacent tiles). All the pixels inside the 'real' area of t