Hey,
not trying to insult anyone here,
but you look like you should start with the basics,
aka read a basic SQL tutorial for concept of join, then
(join, 2 tables properly indexed )
--do one time
CREATE INDEX ON my_table_1 USING GIST(geom) ;
CREATE INDEX ON my_table_2 USING GIST(geom) ;
--your q
> I'm trying to perform an intersection using two tables, one table contains
> a regular grid of polygon geometries the other table contains parcels
> polygons. I need to perform an intersection to extract the parcels as
> lines with a label point for each polygon in the grid table. My novice
> a
Is there a reason you don't simply join and insist on looping? Index the
geometry fields and joining on st_contains or something should have decent
performance.
Jim
On September 2, 2015 2:32:40 PM EDT, Travis Kirstine
wrote:
>I'm trying to perform an intersection using two tables, one table
>
I'm trying to perform an intersection using two tables, one table contains
a regular grid of polygon geometries the other table contains parcels
polygons. I need to perform an intersection to extract the parcels as
lines with a label point for each polygon in the grid table. My novice
approach wa