Hi,
If you'd choosed to subdivise in equal parts you might have 3 lines and 4 columns (or 4 l * 3 c). So when a point A (ax,ay) is in a "primary" boxe, the related position in sub-boxes is: i E {0,3) \ pcxi= Message du 15/08/13 00:17 > De : "René Fournier" > A : "postgis-users@lists.osgeo.org" > Copie à : > Objet : [postgis-users] Subdividing a polygon (rectangle) into equal segments > (smaller rectangles) > >Hi everyone,Just wondering how to go about something:Currently, I have a table >with thousands of polygons (rectangles). I can query the table to see which of >them contains a given point (lat/lng). With the resulting rectangle, I further >need to determine *where* in the rectangle the given point (lat/lng) lies.The >reason is that each of the rectangles are actually subdivided into 12 smaller, >equal rectangles, numbered/lettered A-L. How would you go about doing this? It >doesn't seem like something I can compute in the initial query to retrieve the >containing rectangle… Any ideas?…Rene _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users