I'm having trouble carrying over the attributes from the input layers in my PostGIS intersection below:
CREATE TABLE intersection_output AS (SELECT ST_Intersection(a.the_geom, b.the_geom) FROM nyct2010 as a, test_buffer as b WHERE ST_Intersects(a.the_geom, b.the_geom))I've tried this, but doesn't seem to work:
ST_Intersection(a.the_geom a.geoid, b.the_geom.observation)
أكثر...
CREATE TABLE intersection_output AS (SELECT ST_Intersection(a.the_geom, b.the_geom) FROM nyct2010 as a, test_buffer as b WHERE ST_Intersects(a.the_geom, b.the_geom))I've tried this, but doesn't seem to work:
ST_Intersection(a.the_geom a.geoid, b.the_geom.observation)
أكثر...