> Now i've spent a while searching for info on geospatial databases but
> not found anything that suggests how i can store my data - the data
> will be a value between 1 and 4 for each 100m square of the area that
> the map represents.
Row = location, value
> What geospatial types can i save my data as so i can easily create a
> query to return coverage for a lat/lng?
You needn't use geopspatial thingies at all for simple querying, if
you store your lats and longs seperately
Row = lat , long , value
it is easy to get a rectangle's worth
Select where (westbound > long > eastbound) and (southbound >
lat ....
with some tweaking if your data or queries cross the dateline. This
is quite adequate for selection of data to populate a client map.
Won't do if you are looking for complex analysis of irregular areas.
However it could be used in conjunction with other methods, e.g. to
obtain a radius around a point first select a subset in a containing
square, then do more complicated individual radius testing which is
just arithmatic.
(In practice a radius-around-point query can be constructed directly,
and will only become inefficient with very large datasets. See
Google's classic "store locator" example, all done with no spatial
database.)
The spatial stuff becomes useful if you would be seeking complexity
e.g. points lying in the intersection of two irregular polygons
--
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-maps-api?hl=en.
