Revisions to How to split polygons with another polygon and inheritage data?

update SQL query

Source Link

edit approved Jul 11, 2016 at 11:34

3.7k
2
28
53

I think you're looking for this:

createCREATE TABLE tableC asAS 
  (selectSELECT st_intersectionST_Intersection(a.geom, b.geom) asAS geom, a.name asAS name 
   fromFROM tableA asAS a, tableB asAS b
   whereWHERE st_intersectsST_Intersects(a.geom, b.geom));

By looking at each intersection separately, you can access all the included data.

I think you're looking for this:

create tableC as 
  (select st_intersection(a.geom, b.geom) as geom, a.name as name 
   from tableA as a, tableB as b
   where st_intersects(a.geom, b.geom));

By looking at each intersection separately, you can access all the included data.

I think you're looking for this:

CREATE TABLE tableC AS 
  (SELECT ST_Intersection(a.geom, b.geom) AS geom, a.name AS name 
   FROM tableA AS a, tableB AS b
   WHERE ST_Intersects(a.geom, b.geom));

By looking at each intersection separately, you can access all the included data.

thanks

Source Link

edited Oct 1, 2013 at 8:49

lynxlynxlynx

4.3k
3
31
46

I think you're looking for this:

create tableC as 
  (select st_intersection(a.geom, gb.geom) as geom, a.name as name 
   from tableA as a, tableB as b
   where st_intersects(a.geom, gb.geom));

By looking at each intersection separately, you can access all the included data.

I think you're looking for this:

create tableC as 
  (select st_intersection(a.geom, g.geom) as geom, a.name as name 
   from tableA as a, tableB as b
   where st_intersects(a.geom, g.geom));

By looking at each intersection separately, you can access all the included data.

I think you're looking for this:

create tableC as 
  (select st_intersection(a.geom, b.geom) as geom, a.name as name 
   from tableA as a, tableB as b
   where st_intersects(a.geom, b.geom));

By looking at each intersection separately, you can access all the included data.

Source Link

created Oct 1, 2013 at 8:05

lynxlynxlynx

4.3k
3
31
46

I think you're looking for this:

create tableC as 
  (select st_intersection(a.geom, g.geom) as geom, a.name as name 
   from tableA as a, tableB as b
   where st_intersects(a.geom, g.geom));

By looking at each intersection separately, you can access all the included data.

Stack Exchange Network

Return to Answer