Re: [postgis-users] perform intersection on large tables

> 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 >

Re: [postgis-users] perform intersection on large tables

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

Re: [postgis-users] perform intersection on large tables

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