Re: [gdal-dev] SQL "LEFT JOIN"

2009-07-13 Thread Brian Hamlin
ok, well n that case, given your test data, an expression that works is ogr2ogr -sql "SELECT soils.*, DRCLASSDCD FROM soils soils LEFT JOIN 'master.dbf'.master master ON soils.MUKEY = master.MUKEY" -f geoJSON out.json soils.shp substitute a Shp file directory, etc to suit your purposes

Re: [gdal-dev] SQL "LEFT JOIN"

2009-07-13 Thread Emilio Mayorga
Kris, This statement worked for me a few months back: ogr2ogr -sql "SELECT basinid,basinname,area,basinorder,mouth_lon,mouth_lat FROM stn30test srcgeom LEFT JOIN 'dbffilelongname.dbf'.dbffilelongname jointbl ON srcgeom.basinid = jointbl.basinid" -f "ESRI Shapefile" stn30test_join.shp stn30test.sh

Re: [gdal-dev] SQL "LEFT JOIN"

2009-07-13 Thread Kris R. DeLaney
et al: Actually, the SQL page at the OGR2OGR site shows syntax for DBF joins: http://www.gdal.org/ogr/ogr_sql.html (scroll down the page a ways for actual examples) Unfortunately, I could not get any of these examples to work either. Maybe someone else can ??? I am trying to avoid going

Re: [gdal-dev] Question about gdal2wktraster

2009-07-13 Thread Mateusz Loskot
Pierre Racine wrote: > Jorge, > > 4267 should be the right CS (http://spatialreference.org/ref/epsg/4267/). Actually, it isn't. What gdalinfo reports for the file cea.tif is a projected CS, this one to be precise: http://www.remotesensing.org/geotiff/proj_list/cylindrical_equal_area.html "There

RE: [gdal-dev] Question about gdal2wktraster

2009-07-13 Thread Pierre Racine
Jorge, 4267 should be the right CS (http://spatialreference.org/ref/epsg/4267/). however, the bounding box seems different also. You should compare what bounding box you get using your driver with "SELECT astext(extent) FROM raster_columns" in PostGIS... "SELECT astext(extent) FROM raster_colu

[gdal-dev] Python ReprojectImage()

2009-07-13 Thread Kyle Shannon
Hello all, I can seem to get idle to display the function prototype for ReprojectImage(). Are the arguments the same as the C++ function? I have noticed some of the Python bindings take slightly different args. Thanks regards, Kyle # === Kyle Shannon Physical Science Technician

[gdal-dev] Building GDAL error

2009-07-13 Thread Peisheng Zhao
Hi all, I am trying to compile GDAL-1.6.1 with lipdap 3.8.2: ./configure --with-threads --with-ogr --with-geos --without-libtool --with-proj=/tools/share/COTS/proj-4.6.1 --without-python --without-perl --with-libtiff=internal --with-geotiff=internal --with-hdf4=/tools/share/COTS/HDF4.2r4 --with

Re: [gdal-dev] GDALClose

2009-07-13 Thread Frank Warmerdam
Adeel Raza wrote: Hi Frank, I recently called GDALClose() on a virtual dataset (created from GDALAutoCreateWarpedVRT()), and it was causing writing violation errors and privileged instruction errors on the line following the GDALClose() call. Can you shed any light on this matter? Thanks. A

Re: [gdal-dev] GDALClose

2009-07-13 Thread Adeel Raza
Hi Frank, I recently called GDALClose() on a virtual dataset (created from GDALAutoCreateWarpedVRT()), and it was causing writing violation errors and privileged instruction errors on the line following the GDALClose() call. Can you shed any light on this matter? Thanks. Best Regards, Adeel

Re: [gdal-dev] SQL "LEFT JOIN"

2009-07-13 Thread Dylan Beaudette
On Monday 13 July 2009, Brian Hamlin wrote: > On Jul 12, 2009, at 4:56 PM, Kris R. DeLaney wrote: > > Re:  GDAL 1.6.0, released 2008/11/26 > >   > > I have be unable to use OGR2OGR to accomplish an SQL LEFT JOIN of a > > shapefile with the attributes of a master dbf table.  If my syntax is > > not

Re: [gdal-dev] GDALClose

2009-07-13 Thread Frank Warmerdam
Adeel Raza wrote: Hi, Should GDALClose() be called on virtual or MEM datasets? Adeel, Yes, it will generally result in release of associated resources. Best regards, -- ---+-- I set the clouds in motion - turn up | Fr

[gdal-dev] GDALClose

2009-07-13 Thread Adeel Raza
Hi, Should GDALClose() be called on virtual or MEM datasets? Regards, Adeel Raza. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] SQL "LEFT JOIN"

2009-07-13 Thread Brian Hamlin
On Jul 12, 2009, at 4:56 PM, Kris R. DeLaney wrote: Re:  GDAL 1.6.0, released 2008/11/26   I have be unable to use OGR2OGR to accomplish an SQL LEFT JOIN of a shapefile with the attributes of a master dbf table.  If my syntax is not correct, I hope someone can show me where it is wrong.   The

Re: [gdal-dev] polygon to grid?

2009-07-13 Thread Frank Warmerdam
Lewis, Ambrose J. wrote: Hi All: I’m relatively new to GDAL/OGR, so please forgive a dumb question! I have a grid file (DTED elevations) and a shapefile of polygons (building locations and an APEX attribute representing their height). I’d like to combine these together so that my new[x,y] =

[gdal-dev] polygon to grid?

2009-07-13 Thread Lewis, Ambrose J.
Hi All: I'm relatively new to GDAL/OGR, so please forgive a dumb question! I have a grid file (DTED elevations) and a shapefile of polygons (building locations and an APEX attribute representing their height). I'd like to combine these together so that my new[x,y] = DTED elevation[x,y] + buildin