[postgis-users] Subdividing a polygon (rectangle) into equal segments (smaller rectangles)

[christophe vergon]

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 at 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 at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130815/55c9d9a9/attachment.html>