Create query for dividing mysql spatial area into Xm2 rectangles
$30-250 USD
Σε Εξέλιξη
Αναρτήθηκε περίπου 11 χρόνια πριν
$30-250 USD
Πληρωμή κατά την παράδοση
I need a query that will take a mysql spatial polygon and that will generate a list of lat/lon points.
It should take as input a polygon (ie. a country) and a box size (for instance 500m). A list should then be returned with all center coordinates of squares with a size of 500x500m in this polygon.
So it should take two arguments:
- the polygon
- the box size of all rectangles within the polygon
And it should return:
- A list with all the centers (lat/lon) of the rectangles in the polygon
It doen't have to be in mysql. As long as I get a list with all the coordinates in a polygon of a specific size.