Take the 2-minute tour ×  Due to the size, number, and
performance of my polygon queries (polygon in polygon) I would
like to pre-process my data and separate the polygons into
grids. My data is pretty uniform in my area of interest so like
12 even grids would work well. I may adjust this number later
based on performance. Basically I am going to create 12 tables
with associated spatial indexes or possibly I will just create a
single table with a partition key of my grid. This will reduce
my total index size 12x and hopefully increase performance. From
the query side I will direct the query to the appropriate table.
The key is for me to be able to figure out how to group polygons
into these grids. If the polygon falls within multiple grids
then I would likely create a record in each and de-duplicate
upon query. I wouldn't expect this to happen very often.
Essentially I will have a "grid" that I want to intersect my
polygon and figure out what grids the polygon falls in.
share|improve this question add com