Re: [gdal-dev] odbc issue

2022-09-16 Thread Richard Greenwood
Filemaker is an old proprietary database isn't it? Is there a reason that you have to use it? QGIS has quite a bit of data processing power built in and easily connects to many FOSS databases. So I wonder if you might be better off using something better than Filemaker in the first place. Can you g

Re: [gdal-dev] New behaviour of "PROMOTE_TO_MULTI" ?

2022-07-25 Thread Richard Greenwood
Have you tried -nlt MultiPolygon? On Mon, Jul 25, 2022 at 2:54 AM Bo Victor Thomsen < bo.victor.thom...@gmail.com> wrote: > I have a MapInfo .tab file containing polygons, both simple and > multipolygons (and only polygons). > > Using this command: (all ogr2ogr commands are one-liners, but exampl

Re: [gdal-dev] gdal2tiles vs COG

2022-07-05 Thread Richard Greenwood
On Tue, Jul 5, 2022 at 1:30 AM Javier Jimenez Shaw wrote: > Hi > > Do you know if there is any performance comparison between gdal2tiles and > COG? > > To display our geotiffs we are currently running gdal2tiles and storing > the (gazillion) tiles in Amazon S3. Then a webpage with openlayers is >

Re: [gdal-dev] sqlite3_prepare_v2 no such function: envelope

2021-12-03 Thread Richard Greenwood
t; Check the spatialite version: > > ogrinfo -dialect sqlite -sql "select spatialite_version()" parks.shp > > > > -Jukka Rahkonen- > > > > *Lähettäjä:* gdal-dev *Puolesta *Richard > Greenwood > *Lähetetty:* perjantai 3. joulukuuta 2021 21.22 > *Vas

[gdal-dev] sqlite3_prepare_v2 no such function: envelope

2021-12-03 Thread Richard Greenwood
I have an ogr2ogr statement that works in OGR 3.3.3 but not 3.4.0. The statement is: ogr2ogr out parks.shp -dialect sqlite -sql "select envelope(geometry) from parks" And the error in 3.4.0 is ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2 no such function: envelope Is this expected? I'm on two

Re: [gdal-dev] gdalbuildvrt files not recognized

2021-02-05 Thread Richard Greenwood
I think that wildcard expansion has been an on and off problem with some of the GDAL utilities on Windows. If you Google "gdalbuildvrt wildcard expansion" you'll find at least three tickets, the most recent of which is: https://github.com/OSGeo/gdal/issues/1749 I think the safest and easiest is to

Re: [gdal-dev] Fw: Building GDAL with ECW support

2021-02-02 Thread Richard Greenwood
I used this docker image successfully on a SID file and it claims support for ECW format also: https://hub.docker.com/r/klokantech/gdal/ And then, as Richard Duivenvoorde suggested, convert your ECW to a geotiff. A geotiff with YCbCr JPEG compression and overviews can be nearly as small as a SID or

Re: [gdal-dev] ogr2ogr from gpx to postgis - track_fid not maintained for track_points

2021-01-02 Thread Richard Greenwood
On Sat, Jan 2, 2021 at 7:59 AM Michael Saupe wrote: > Hi Evan, > > thank you for the explanation. That makes sense. However, in my opinion > ogr2ogr behavior is not really consistent in this case: The column ogc_fid > , which is in fact the track id, is incremented on each gpx file import ( > reg

Re: [gdal-dev] Contour Line Thinning

2021-01-01 Thread Richard Greenwood
On Fri, Jan 1, 2021 at 2:36 PM Stephen Woodbridge < stephenwoodbridg...@gmail.com> wrote: > Hi all, > > I'm contouring bathemetry data using gdal_contour and it works really > great. The problem I have is that when depth falls off rapidly like at > the continental shelf or into a canyon, I get too

Re: [gdal-dev] Encoding when creating pdf

2020-11-05 Thread Richard Greenwood
Do your shapefiles include a code page file (*.cpg)? If not, maybe that would help. On Wed, Nov 4, 2020 at 2:57 AM Aneta Muslić wrote: > Hello, > > I am using gdal version 2.4.4 in my c# app. > As a part of my project I am creating pdf with gdal_translate command. > GDAL translate command is > *

[gdal-dev] incorrect coordinate system with ogr2ogr -f "MapInfo file"

2020-08-12 Thread Richard Greenwood
I recently upgraded to gdal 3.0 and 3.1 on two computers. When using ogr2ogr to create MapInfo files the coordinate system of the resulting MapInfo files is incorrect. The coordinate system is epsg:3739 which uses US Survey Feet. I used MapInfo to convert the native binary file to MapInfo's externa

Re: [gdal-dev] geojson to shp and vice versa

2019-11-30 Thread Richard Greenwood
I don't know anything about iterating thru a .zip file, but just in case you aren't already familiar with it, ogr2ogr has -sql and -where options that can be used to filter geometry types. So if you have different geometry type in a single source file you can use for example: -where "OGR_GEOMETR

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

2019-03-04 Thread Richard Greenwood
What are the advantages of storing the imagery in S3 as opposed to EBS? I'm using the throughput optimized magnetic EBS which I is a little less expensive than S3. I did some testing a couple years ago and didn't see enough performance gain to justify SSD. Have you tested S3 against any of the EBS

Re: [gdal-dev] -srcnodata in gdalwarp and gdalbuildvrt

2018-03-30 Thread Richard Greenwood
Perfect. Thanks so much! And thank you for showing the syntax for gdalwarp as well as how to use gdal_edit.py. I would not have figured out these options without you help. Best regards, Rich On Thu, Mar 29, 2018 at 1:23 PM, Even Rouault wrote: > On mercredi 28 mars 2018 18:16:45 CEST Rich

[gdal-dev] -srcnodata in gdalwarp and gdalbuildvrt

2018-03-28 Thread Richard Greenwood
I have a question that is probably more "user" than "developer". Is there different place that I should post my question? I don't think that I understand -srcnodata. I assume that -srcnodata "0 0 0" on a 3 band image means that all 3 bands have to be 0 to be "no data" but I think what I'm seeing i

Re: [gdal-dev] ogr2ogr mapinfo reporjection

2017-05-30 Thread Richard Greenwood
7, 90, > 51.17233, 49.839, 15.013, 5400088.438* > > > > instead of > > > > *CoordSys Earth Projection 3, 1019, "m", 4.367487, 90, 49.839, > 51.172333, 15.0130001, 5400088.438001 Bounds (0, 0) > (30, 30)

Re: [gdal-dev] ogr2ogr PROMOTE_TO_MULTI with linestrings?

2017-05-16 Thread Richard Greenwood
You could use -nlt geometry but that won't convert simple objects to multi objects. You could do it in steps: 1. use -where to get lines and -nlt MultiLine 2. use -where to get polys with -nlt MutliPolygon 3. combine the two tables into a single Geometry table Rich On Mon, May 15, 2017

Re: [gdal-dev] ogr2ogr mapinfo reporjection

2017-05-08 Thread Richard Greenwood
When you say that the coordsys header is wrong, are you looking at it in MapInfo or in a text editor? If you look at the MIF file coordinates in a text editor do they look like they have been correctly transformed, and it is just the header that is wrong? On Mon, May 8, 2017 at 7:39 AM, Jonathan B

Re: [gdal-dev] compiling gdal with esri file gdb

2017-03-11 Thread Richard Greenwood
! Rich On Sat, Mar 11, 2017 at 8:21 AM, Richard Greenwood < richard.greenw...@gmail.com> wrote: > > > On Sat, Mar 11, 2017 at 7:20 AM, Even Rouault > wrote: > >> On samedi 11 mars 2017 07:15:27 CET Richard Greenwood wrote: >> >> > On Sat, Mar 11, 2017 at 1:

Re: [gdal-dev] compiling gdal with esri file gdb

2017-03-11 Thread Richard Greenwood
On Sat, Mar 11, 2017 at 7:20 AM, Even Rouault wrote: > On samedi 11 mars 2017 07:15:27 CET Richard Greenwood wrote: > > > On Sat, Mar 11, 2017 at 1:34 AM, Damian Dixon > > > > > > wrote: > > > > Have you tried OpenFileGDB? (you will need GDAL

Re: [gdal-dev] compiling gdal with esri file gdb

2017-03-11 Thread Richard Greenwood
> It works fine > Fuad > > > Original Message > Subject: Re: [gdal-dev] compiling gdal with esri file gdb > From: Damian Dixon > To: Richard Greenwood > CC: GDAL List > > > Have you tried OpenFileGDB? (you will need GDAL 2.2 or newer for cu

Re: [gdal-dev] compiling gdal with esri file gdb

2017-03-11 Thread Richard Greenwood
on Windows to convert the file. The way > shared libraries work on Windows means that the proj4 issue you are seeing > on Linux should not occur. > > I don't know where you would get a Windows build of GDAL with FileGDB > enabled. Someone on the list probably does. > > >

Re: [gdal-dev] compiling gdal with esri file gdb

2017-03-10 Thread Richard Greenwood
If any of you can share any pointers on how to even get it to compile I'd appreciate it. I just need to access a esri file geodatabase that has curves and see if I can get them into postgis. If I have to have a separate build of gdal just for that I don't care. But I'm not too good with compiling g

[gdal-dev] compiling gdal with esri file gdb

2017-03-08 Thread Richard Greenwood
I have an ESRI file gdb with curves that I need to import so I'm trying to build gdal 2.2 with filegdb. I'm on Ubuntu 16.04 with gcc 5.4. I checked out the the svn gdal and built it with any problems. Next I got the ESRI FileGDB_API_1_5_64 and copied the contents of the lib and include directories

[gdal-dev] ogr2ogr non-spatial

2009-05-10 Thread Richard Greenwood
, -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] gdal in ESRI products

2008-09-05 Thread Richard Greenwood
; Kenton Williams > GIS Analyst / Tech Lead > Penobscot Bay Media, LLC > Camden, ME > http://www.penbaymedia.com > > -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] gdal in ESRI products

2008-09-05 Thread Richard Greenwood
o GDAL? I am preparing a presentation on Open Source Geospatial software for a regional ESRI users group. (I don't use ESRI software much, but I can't make it to Cape Town and I need some continuing education credits...) Thanks, Rich -- Richard Greenwood [EMAIL PROTECTED] www.g

[gdal-dev] gdal in ESRI products

2008-09-04 Thread Richard Greenwood
I seem to remember a couple years ago someone saying that ESRI was going to be using some gdal libraries in one or more of their products. Does anyone know if this ever happened or provide any details? Thanks, Rich -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com

Re: [gdal-dev] Guidance sought on using gdal-translate

2008-08-03 Thread Richard Greenwood
bably hasn't been rectified. GRASS has a great ortho rectification module for working on single images. If your image does not have a collar, then you are really guessing. And in any case, if you can get some info from who ever produced the image, you could greatly reduce the guessing. Rich -- Richard Greenwood [EMAIL PROTECTED] www.greenwoodmap.com ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev