[postgis-users] problem intersection with postgis on multipolygon

David TECHER davidtecher at yahoo.fr
Fri Dec 12 11:17:28 PST 2003


Hi

I have to use function intersection for 3 tables with
thousand lines.

All my 'the_geom' tables are 'MULTIPOLYGON'

But when I used intersection() on it, postgresql
scratched :(

So I gave up this function and use the geos project to
make a *.exe program that parse a xml file with my
data from 'the_geom column':

<run>
<a>
MULTIPOLYGON....
</a>
<b>
.......
</b>
<test>.....

When I opened ma data from the_geom column, I 

use geometryn(the_geom,integer) to see every geometric
data..

I saw that I have POLYGON((.....),(.....),(....))

Is it possible?????

Because when I use JTS to find the intersection from
the xml file or geos it said:

Exception...Number of points must be 0 or >3

Please help 
thanks

Notice: I uses shp2pgsql to convert my data from
mapInfo to postgis

My configuration is

Windows XP¨, postgresql-7.3.4, postgis 0.8.0, geos 1.0
proj 4.4.7

_________________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com



More information about the postgis-users mailing list