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
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
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
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
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
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
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
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
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
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
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
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
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
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] =
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
15 matches
Mail list logo