[Geowanking] bounding points in lat/lon
joshua at burri.to
Wed Apr 16 13:55:09 PDT 2003
in case it wasn't obvious, both ben and I are suggesting you give up on
the bounding box.
is a good explanation of many different ways to index spacial data.
Joshua Schachter editor: http://memepool.com/
joshua at burri.to also: http://muxway.org/
and also: http://geourl.org/
On Wed, 16 Apr 2003, Daniel Smith wrote:
> At 4:18 PM -0400 4/16/03, VTP wrote:
> >Maybe i'm missing something here. If i understand, you want the database to
> >do the comparison for you, but it's not a spatially-aware database.
> Not necessarily. I'm still at the point of figuring out
> the bounding box around a point...
> >1. Convert your Latlon to UTM
> >2. add/subtract the desired distance from the UTM point (linear meters,
> >3. Convert the 4 points back to Latlon
> >4. Use the extents of those 4 points to do your SQL query
> Worth a look. thanks!
> Thanks Joshua for the PostGIS ref, and the insane
> SQL statement (is this what you are doing in GeoURL?)
> I just discovered http://www.freegis.org/ ...
> Daniel L. Smith - Sonoma County, CA - AIM: SonomaDaniel
> JavaJoint.com - daniel.org - ThereAndThen.org
> Geowanking mailing list
> Geowanking at lists.burri.to
More information about the Geowanking