Re: [postgis-users] Bounding Box intersection

2012-07-14 Thread Mike Toews 
On 14 July 2012 00:35, Ed Linde edoli...@gmail.com wrote:
 Hi All,
 I have a table with linestring geometries, and I have the co-ordinates of a
 rectangle/ bounding box.
 I want to get only a restricted set of geometries that lie within or
 intersect with this box. Is there a
 way to construct this box on the fly and get only the relevant set of
 geometries?

Hi Ed,

You could use ST_MakeEnvelope [1] to make a box on the fly:

SELECT *
FROM roads
WHERE geom  ST_MakeEnvelope(10, 10, 11, 11, 4326);

-Mike

[1] http://postgis.refractions.net/docs/ST_MakeEnvelope.html
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] Census loader

2012-07-14 Thread Eric Aspengren 
Well now. I see to have discovered, finally, why I was having trouble
getting the census loader to work. The script generated wasn't complete.
I seem to have a corrupted .sql file. I don't even know where that is in
the install. Where would that file be and where can I find a full
version of that .sql file to fix it?

Eric Aspengren

___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users