Reverse Geocoding

[azzahrah]

howto build reverse geocoding with many polygon and polylinestring as source of data, the part i want to build is:

1. indexing many polygon, and query like ST_Contains(POINT, GeometryField)
2. indexing multiple PolylineString and query like ST_Intersects(Box,GeometryField)

TIA

[gdey]

I think we have some of the primitives for this, but I'll have to look. I know I have created an index using bbox's to a geometry. And then did a search on which bbox best contains a point, before asking the geom if it contains the point. But I don't know off the top of my head.