[postgis-users] Database extraction to Shapefile, based on bounding box

[Burgholzer,Robert]

This works on my machine:

 

pgsql2shp db_name "select * from proj_points where projectid = 2 limit
5" -f test_shp -P my_password -u dbuser 

 

where the quote is in selects, and could easily be a PostGIS boundary
box, I think.

 

HTH,

r.b.

 

Robert W. Burgholzer

Surface Water Modeler

Office of Water Supply and Planning

Virginia Department of Environmental Quality

rwburgholzer at deq.virginia.gov

804-698-4405

Open Source Modeling Tools:

http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Robert Hicks
Sent: Friday, September 19, 2008 1:02 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Database extraction to Shapefile,based on
bounding box

 

Hello all, I am trying to query my Postgres database and retrieve a
subset from a table based on lat/lon information and ultimately convert
the data to a shapefile. Is this possible? I have extracted data using
pqsql2shp but never a subset.

Thanks!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080919/54317eec/attachment.html>