Re: [gdal-dev] elevation profile

2010-02-11 Thread Even Rouault
No. This must be done by the calling application. Le Thursday 11 February 2010 23:20:56 Michele Sanges, vous avez écrit : > Hello all, > > opening a raster file with values of elevation (for example DEM or DTED > files), is there a GDAL C++ API to get all the values of elevation > between two plac

[gdal-dev] elevation profile

2010-02-11 Thread Michele Sanges
Hello all, opening a raster file with values of elevation (for example DEM or DTED files), is there a GDAL C++ API to get all the values of elevation between two places (elevation profile)? Thanks. Best regards. -- Michele Sanges ___ gdal-dev mail

Re: [gdal-dev] Spatial Filters and PostGIS

2010-02-11 Thread Miller, Craig
I haven't done any performance testing. I was just looking to understand how to best structure my code/queries to insure that it will continue to work well with extremely large datasets. On Thu, Feb 11, 2010 at 11:50 AM, Even Rouault wrote: > Le Thursday 11 February 2010 19:53:41 Frank Warm

Re: [gdal-dev] Spatial Filters and PostGIS

2010-02-11 Thread Even Rouault
Le Thursday 11 February 2010 19:53:41 Frank Warmerdam, vous avez écrit : Craig, Since GDAL 1.6.0, spatial filtering on layers returned by ExecuteSQL() should be rather fast (http://trac.osgeo.org/gdal/changeset/14291). I see a OGRPGResultLayer::SetSpatialFilter() method that appends an intersec

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Noli Sicad
Even, Thanks for pointing this out. Kumar noticed that the "- f" there was space in between. The correct syntax is "-f" This one (below) is working. ogr2ogr - f SQLite Harvest.sqlite HarvestArea1.csv -dsco SPATIALITE=YES Noli On 2/12/10, Even Rouault wrote: > I'm not sure if the version of

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Even Rouault
I'm not sure if the version of sqlite3.dll included in latest FWTools is recent enough to support reading and/or creation of spatialite databases. See http://bugzilla.maptools.org/show_bug.cgi?id=2099 Le Thursday 11 February 2010 13:15:23 Chaitanya kumar CH, vous avez écrit : > Noli, > > There w

Re: [gdal-dev] Motion: Extend Commit Access to Gaige Paulsen

2010-02-11 Thread Daniel Morissette
Frank Warmerdam wrote: Motion: Extend GDAL/OGR Commit Access to Gaige Paulsen. +1 Daniel -- Daniel Morissette http://www.mapgears.com/ ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] Spatial Filters and PostGIS

2010-02-11 Thread Miller, Craig
Thanks for the confirmation. I'll tweak my queries accordingly. Craig On Thu, Feb 11, 2010 at 10:53 AM, Frank Warmerdam wrote: > Miller, Craig wrote: > >> I was browsing the PostGIS driver code today and noticed that when used >> with ExecuteSQL the spatial filters appear to be getting applied

Re: [gdal-dev] Spatial Filters and PostGIS

2010-02-11 Thread Frank Warmerdam
Miller, Craig wrote: I was browsing the PostGIS driver code today and noticed that when used with ExecuteSQL the spatial filters appear to be getting applied on the client side instead of the PostGIS side. Am I understanding the code correctly? Craig, Yes, that is correct. When using Exec

[gdal-dev] Spatial Filters and PostGIS

2010-02-11 Thread Miller, Craig
I was browsing the PostGIS driver code today and noticed that when used with ExecuteSQL the spatial filters appear to be getting applied on the client side instead of the PostGIS side. Am I understanding the code correctly? No worries if it is, I'll just modify my SQL to included bbox info so I

Re: [gdal-dev] How to calculate total change in headings?

2010-02-11 Thread Christopher Barker
Roger André wrote: Not a GDAL question at all, but one which might amuse some of you, and which has been unsolveable in a satisfactory fashion for me. fun with circular math... Given a list of compass headings in degrees, how can you reliably calculate the total change in direction? Here's

Re: [gdal-dev] wcs extraction

2010-02-11 Thread Bruno Binet
Thanks you very much Frank for the clarification. You confirm what I understood. Best regards, Bruno On 11 February 2010 16:54, Frank Warmerdam wrote: > Bruno Binet wrote: >> >> Hi list, >> >> I'm currently trying to use the wcs gdal driver to extract data from a >> wcs service (mapserver), usin

Re: [gdal-dev] wcs extraction

2010-02-11 Thread Frank Warmerdam
Bruno Binet wrote: Hi list, I'm currently trying to use the wcs gdal driver to extract data from a wcs service (mapserver), using a specfic projection, extent and resolution. I managed to extract the all dataset in the original projection, and format (geotiff). But I would like to be able to spe

Re: Re: [gdal-dev] Problems with C# ogr_wrap.dll

2010-02-11 Thread Tamas Szekeres
Tom, It depends on the platform target settings and the your current framework, which kind of binaries should be used, see the table below: Platform targetExecuting environment (Framework version) binary package should be used /x86 x86

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Noli Sicad
Kumar, OK. I did this command as you suggested. ogr2ogr - f SQLite Harvest.sqlite HarvestArea1.csv -dsco SPATIALITE=YES But still no Harvest.sqlite is created. Please tell what is the right order of the arguments. Suggest any command combination. Noli On 2/11/10, Chaitanya kumar CH wrote: >

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Chaitanya kumar CH
Noli, Your destination file has to be before the source file. On Thu, Feb 11, 2010 at 6:19 PM, Noli Sicad wrote: > Yes, this is what I am trying to ask. > > from file:///C:/Program%20Files/FWTools2.4.7/html/drv_sqlite.html > > # Duplicate the sample database provided with SpatiaLite (does not

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Noli Sicad
Yes, this is what I am trying to ask. from file:///C:/Program%20Files/FWTools2.4.7/html/drv_sqlite.html # Duplicate the sample database provided with SpatiaLite (does not need explicit linking with SpatiaLite) ogr2ogr -f SQLite testspatialite.sqlite test-2.3.sqlite -dsco SPATIALITE=YES from fi

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Chaitanya kumar CH
Noli, There was a problem with the order of the arguments in your command. http://gdal.org/ogr2ogr.html On Thu, Feb 11, 2010 at 5:37 PM, Noli Sicad wrote: > OK. Sorry > This is the error, > > FAILURE: > Unable to open datasource `harvest.sqlite' with the following drivers. > -> ESRI Shapefile

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Noli Sicad
OK. Sorry This is the error, FAILURE: Unable to open datasource `harvest.sqlite' with the following drivers. -> ESRI Shapefile -> MapInfo File -> UK .NTF -> SDTS -> TIGER -> S57 -> DGN -> VRT -> REC -> Memory -> BNA -> CSV -> NAS -> GML -> GPX -> KML -> GeoJSON

Re: [gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Chaitanya kumar CH
Noli, There must have been some error message. What did you get? On Thu, Feb 11, 2010 at 5:11 PM, Noli Sicad wrote: > Hi, > > I downloaded FWTools 2.4.7 (Jan 19, 2010) for windows and installed. > I suppose there is support for converting CSV table to SQLite Table in > this version. Now, how d

[gdal-dev] FWTools 2.4.7 ogr2org How to convert CSV to SQLite table

2010-02-11 Thread Noli Sicad
Hi, I downloaded FWTools 2.4.7 (Jan 19, 2010) for windows and installed. I suppose there is support for converting CSV table to SQLite Table in this version. Now, how do i convert my CSV table to SQLite ogr2org - f SQLite HarvestArea1.csv Harvest.sqlite -dsco SPATIALITE=YES It seems that this