<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left> </DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=779165411-24012007><FONT face=Arial><FONT
color=#0000ff><FONT size=2>H<SPAN
class=779165411-24012007>allo,</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=779165411-24012007></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>I have a problem with a
polygon:</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>I want to create
</SPAN></FONT></FONT></FONT></SPAN><SPAN class=779165411-24012007><FONT
face=Arial><FONT color=#0000ff><FONT size=2><SPAN class=779165411-24012007>a
shape-File from a geometry, which is a multipolygon by
definition</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>with the
statement:</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007><FONT size=2><FONT size=2>
<P>pgsql2shp -f abc verdis_beta wsw_shp
</P></FONT></DIV></FONT></SPAN></FONT></FONT></FONT></SPAN>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=779165411-24012007></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007> and get the
following error message:</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007><FONT
size=2></FONT></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007><FONT size=2>ERROR: Cannot have multiple
geometry types in a shapefile.</FONT></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007></SPAN></FONT></FONT></FONT></SPAN><SPAN
class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=779165411-24012007><FONT size=2>Use option -t(unimplemented
currently,sorry...) to specify what type of geometry you want
dumped</FONT></SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007><FONT
size=2></FONT></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>where is the
error?</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=779165411-24012007></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=779165411-24012007></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>And another
question:</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>I think that I perhaps have overlapping
geometrys in my table and they can not build a
shapefile.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007>When I tryed to take the function
"overlaps" to test my table (with 600,000 polygons) , the
duration is very long, even on a small part of my data.
</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT size=+0><FONT size=+0><SPAN
class=779165411-24012007><FONT face=Arial color=#0000ff size=2>How
can I accelerate the overlaps-function ?</FONT></DIV>
<DIV
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px"><FONT
face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px"><SPAN
class=779165411-24012007><FONT face=Arial color=#0000ff size=2>Regards Rolf
Stüwe</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff
size=2> </FONT></SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=779165411-24012007><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=779165411-24012007><FONT
size=2> </DIV></FONT></SPAN></FONT></FONT></FONT></SPAN></BODY></HTML>