Hi Brent,<br><br>Unfortunately the data is already out of Postgres, so I don't have that option anymore. I was hoping there might be some way of invoking a geos function in ogr2ogr.<br><br>Thanks though,<br><br>Roger<br>
--<br><br><div class="gmail_quote">On Wed, Apr 22, 2009 at 2:25 PM, <span dir="ltr"><<a href="mailto:pcreso@pcreso.com">pcreso@pcreso.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
Yep.<br>
<br>
In your ogr2ogr query string query try<br>
"select buffer(area, nn.nn) as geom from table where...;"<br>
<br>
PostGIS will buffer it before sending it to GDAL for export to shapefile.<br>
<br>
Or if you are repeatedly doing this, create a view in PostGIS with the buffer, & select this with GDAL, whichever suits....<br>
<br>
Brent Wood<br>
<br>
<br>
<br>
--- On Thu, 4/23/09, Roger André <<a href="mailto:randre@gmail.com">randre@gmail.com</a>> wrote:<br>
<br>
> From: Roger André <<a href="mailto:randre@gmail.com">randre@gmail.com</a>><br>
> Subject: [gdal-dev] Is it possible to Buffer using ogr2ogr?<br>
> To: "gdal-dev" <<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>><br>
> Date: Thursday, April 23, 2009, 4:59 AM<br>
<div><div></div><div class="h5">> Hi All,<br>
><br>
> I'm trying to port some of my existing PostGIS based<br>
> workflow to ogr utilities and shapefiles. Is it possible<br>
> to buffer a feature that I've selected via the ogr2ogr<br>
> "-where" clause? I'd like end up with a<br>
> single, buffered feature in a stand-alone shapefile when<br>
> I'm done.<br>
><br>
><br>
> Thanks,<br>
><br>
> Roger<br>
><br>
><br>
</div></div>> -----Inline Attachment Follows-----<br>
><br>
> _______________________________________________<br>
> gdal-dev mailing list<br>
> <a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br>