Please help, I have a polygon layer representing building footprints. I want to create new view in postgis that will contain rectangle representing bounding box and also another view that will have ...
I want to create a query to select all ways and their nodes that exist within a bounding box using postGIS. The bounding box shall includes all details as osmosis "--bounding-box" command will ...
I'm going to say thanks in advance. I'm very new to GIS and this forum is a tremendous help. My simple questions have been solved; here's one that might be a little trickier. Given a polygon in a ...
Is there an easy way to get the bounding box for an entire table in PostGIS? Thanks
Using the PostGIS shp2pgsql -s 4326 ... I generated the sql file and created my spatially enabled table. When executing my query: select box2d(ST_extent(the_geom)) from feature_data; I'm returned ...
I have a PostGIS db, and I want to find the points that lie within some region (a bounding box). I have two sets of coordinates, from which I can get all four rectangle points that form the box (if ...