Hi,<br><br>I'm trying to calculate a minimum bbox/extent for a group of polygons with a similar attribute. For this specific case, I am trying to find a bbox/extent for all of the voting precincts within the same county.
<br><br>here is the sql I'm executing:<br>=====================<br>select<br>distinct<br> extent(the_geom) as the_extent<br>from<br> shp_precincts<br>where<br> county_id = 72<br>;<br>=====================<br>
<br>'the_geom' is a polygon representing a voting precinct, and the where clause subsets to all voting precincts belonging to a specific county. I get the following error which I don't understand or know how to correct:
<br><br>=====================<br>ERROR: could not identify an ordering operator for type box2d<br>HINT: Use an explicit ordering operator or modify the query.<br>=====================<br>
<br>Any help is appreciated in resolving this. What I ultimately want to do is have a result set that has a bounding box for each county based on the polygons of precincts that belong to that county.<br clear="all"><br>
tia,<br>Matt<br>-- <br>It is from the wellspring of our despair and the places that we are broken that we come to repair the world.<br>-- Murray Waas