I'm very sorry it is difficult to understand what you mean. Maybe with a real drawing and link here to it, or to some screenshots? ;-)
Cheers, Rémi-C 2013/12/12 <isla...@infomed.sld.cu> > thanks for the quick answer Rémi, but, thats right thats one of answers, > but my idea was not complete,because there is a > 3rd shape, your answer works fine for the 1st and 2dn shapes, but not with > the 3rd, because the 3rd has not suares inside, > the 3rd shape have big triangles inside,the idea is that i need some > routine that merge or blend the spatial data and with it the attributes > of respective data, i need some ideas for do that, and am working on it, > but not sucess, please i need help, thanks for all. > > > 1-the first shapefile > __________________ > | | > | | > | 1 | shp=A > | | > | | > |_________________| > num of poligons=1 > > > 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 | > |________|________| > num of poligons = 6 > > 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 > > > 3-and the second shapefile > __________________ > | / | > | / | > | 3 / | shp=C > | / | > | / 4 | > |_____/___________| > num of poligons = 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,3 / | > | 1,2,3 | /1,2,4 | > | | / | > |______________|____/_________| > | |1,2/ | shp=A and B > | |,3/ | > | 1,2,3 | / 1,2,4 | > | |/ | > |______________/______________| > | /| | > | / | | > | 1,2,3 /1,| 1,2,4 | > | /2,4| | > |_________/____|______________| > num of poligons = 9 > > > 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,dni01C numeric,dni02C numeric, > dni03C numeric,dni04C numeric,dni05C numeric,dni06C numeric, > dni07C numeric,dni08C numeric,dni09C numeric,dni10C numeric, > dni11C numeric,dni12C numeric,dniannC numeric,the_geom geometry > > "Rémi Cura" <remi.c...@gmail.com> escribió: > > > 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 <isla...@infomed.sld.cu> >> >> 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 < >>>> >>>>> isla...@infomed.sld.cu> 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 >>>>> postgis-users@lists.osgeo.org >>>>> 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 >>> postgis-users@lists.osgeo.org >>> 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 postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users