Thanks for the reply. I think i was assuming it was going to be a more complicated task than it need be.
Time for me to start experimenting with some code. Martin. On 30 June, 12:50, Rossko <[email protected]> wrote: > > 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.
