How to get this PostGIS Intersection carry fields from input layers into output layer

المشرف العام

Administrator
طاقم الإدارة
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)

أكثر...
 
أعلى