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 [EMAIL PROTECTED] 804-698-4405 Open Source Modeling Tools: http://sourceforge.net/projects/npsource/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Hicks Sent: Friday, September 19, 2008 1:02 PM To: postgis-users@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!
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
