Seems like If you want : for each little square, get the id of big square overlaping. If this is simply this, you don't need the "intersection" function, but only the "intersects" function :
You could do something like this SELECT ss.id, bs.id , ss.geom FROM smal_square_table AS ss, big_square_table AS bs WHERE ST_Intersects(ss.geom,bs.geom)=TRUE Cheers, Rémi-C 2013/12/12 <[email protected]> > Hi, >> >> Try pg 21 of this: http://presentations.opengeo. >> org/2011_FOSS4G/postgis-power.pdf >> >> That will give you the metacode. >> >> Overlays. (he sighs.) Be glad you only have 2 layers... . >> >> Best, >> Steve >> > Hey steve thanks for the book is really good as a resume, but the only > apart that it have to do with my problem is the intersection of 2 shapes > "SELECT > a.*, b.*, > ST_Intersection(a.geom, b.geom) > FROM > a, b > WHERE > ST_Intersects(a.geom, b.geom);" > > but my problem is different, i got as a mention 2 shapes with the same > projection and place, > and are the same but one is from one study, and the other is from other > stufy, but are the same > place and each one have data, the only things that they got different are > the size of the squares,the data they got and the > name of the columns are the same, but the values are different cause the > type of the study > ,there is one that have the squares more smaller that the other, but i > dont want lose any data, i need that in the map it has seen like > the figure "A and B" but in the data each row got the values of A and the > values of B > > 1-the first shapefile > __________________ > | | > | | > | 1 | shp=A > | | > | | > |_________________| > > The one big country, this is a multipolygon shape > > DATA=>dni01 numeric,dni02 numeric,dni03 numeric, > dni04 numeric,dni05 numeric,dni06 numeric, > dni07 numeric,dni08 numeric,dni09 numeric, > dni10 numeric,dni11 numeric,dni12 numeric, > dniann numeric,the_geom geometry > > > 2-and the second shapefile > __________________ > | 2 | 2 | > |________|________| > | 2 | 2 | shp=B > |________|________| > | 2 | 2 | > |________|________| > The same country, but this time in little pieces, the states, this is a > multipolygon shape too > > DATA=>dni01 numeric,dni02 numeric,dni03 numeric, > dni04 numeric,dni05 numeric,dni06 numeric, > dni07 numeric,dni08 numeric,dni09 numeric, > dni10 numeric,dni11 numeric,dni12 numeric, > dniann numeric,the_geom geometry > > > and i want join the 2 shapes in only one shapefile getting something like > this > > __________________ > | 1,2 | 1,2 | > |________|________| > | 1,2 | 1,2 | shp=A and B > |________|________| > | 1,2 | 1,2 | > |________|________| > > DATA=>dni01A numeric,dni02A numeric,dni03A numeric,dni04A numeric, > dni05A numeric,dni06A numeric,dni07A numeric,dni08A numeric, > dni09A numeric,dni10A numeric,dni11A numeric,dni12A numeric, > dniannA numeric,dni01B numeric,dni02B numeric,dni03B numeric, > dni04B numeric,dni05B numeric,dni06B numeric,dni07B numeric, > dni08B numeric,dni09B numeric,dni10B numeric,dni11B numeric, > dni12B numeric,dniannB numeric,the_geom geometry > > i think that this is posible to do with postgis, but i dont know why, am > looking in quantumGIS but i lose data cause the big suare overlap the little > ones and i lose data cause there is some places that i get NULL. > > please help > thanks for all > > > >> >> >> >> >> On Mon, Dec 9, 2013 at 11:03 AM, J.Alejandro Martinez Linares < >>> [email protected]> wrote: >>> >>> Hi People, i need your help, let say that i have 2 shapefiles >>> >>> 1-the first shapefile >>> __________________ >>> | | >>> | | >>> | 1 | shp=B >>> | | >>> | | >>> |_________________| >>> >>> One big country, this is a multipolygon shape >>> >>> 2-and the second shapefile >>> __________________ >>> | 2 | 2 | >>> |________|________| >>> | 2 | 2 | shp=B >>> |________|________| >>> | 2 | 2 | >>> |________|________| >>> The same country, but this time in little pieces, the states, this is >>> a multipolygon shape too >>> >>> and i want join the 2 shapes in only one shapefile getting something >>> like this >>> >>> __________________ >>> | 1,2 | 1,2 | >>> |________|________| >>> | 1,2 | 1,2 | shp=A and B >>> |________|________| >>> | 1,2 | 1,2 | >>> |________|________| >>> >>> i think that this is posible, please help me to get somthing like >>> this i need it. >>> >>> >>> >>> -- >>> >>> Este mensaje le ha llegado mediante el servicio de correo electronico >>> que ofrece Infomed para respaldar el cumplimiento de las misiones del >>> Sistema Nacional de Salud. La persona que envia este correo asume el >>> compromiso de usar el servicio a tales fines y cumplir con las regulaciones >>> establecidas >>> >>> Infomed: http://www.sld.cu/ >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >>> >> > > > > > ---------------------------------------------------------------- > This message was sent using IMP, the Internet Messaging Program. > > > > -- > > Este mensaje le ha llegado mediante el servicio de correo electronico que > ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema > Nacional de Salud. La persona que envia este correo asume el compromiso de > usar el servicio a tales fines y cumplir con las regulaciones establecidas > > Infomed: http://www.sld.cu/ > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
