<div dir="ltr">I'm getting very long processing time from ST_Union (on a shape of europe at 1/100000 it's been running since 2 hours and hasn't finished yet; on my previous one of 1/1000000 it took ~1 hour)<br>
Any other alternative and quicker ways to accomplish the same operation?<br>I just executed st_buffer(st_collect(the_geom)) but still waiting. Should it take as long? ST_Collect by itself executes fast but it's result violates the geometry check constraint. <br>
<br><br><br><div class="gmail_quote">On Fri, Aug 1, 2008 at 5:31 PM, danny <span dir="ltr"><<a href="mailto:whatevar89@gmail.com">whatevar89@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">Thanks Robert.<br><br>I actually exported from ogr2ogr and it created a shape that worked fine in ArcView.<br><br>Best<div><div></div><div class="Wj3C7c"><br> <br><br><br><div class="gmail_quote">On Fri, Aug 1, 2008 at 5:19 PM, Burgholzer,Robert <span dir="ltr"><<a href="mailto:rwburgholzer@deq.virginia.gov" target="_blank">rwburgholzer@deq.virginia.gov</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Could ArcView perhaps want some columns
other than just the shape? Perhaps you could put a numeric ID or something
else in there.</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Just a thought,</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Robert W. Burgholzer</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Surface Water Modeler</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Office of Water Supply and Planning</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Virginia Department of Environmental
Quality</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"><a href="mailto:rwburgholzer@deq.virginia.gov" target="_blank">rwburgholzer@deq.virginia.gov</a></span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">804-698-4405</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Open Source Modeling Tools:</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"><a href="http://sourceforge.net/projects/npsource/" target="_blank">http://sourceforge.net/projects/npsource/</a></span></font></p>
</div>
<p style="margin-left: 0.5in;"><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma;"><div>-----Original Message-----<br>
<b><span style="font-weight: bold;">From:</span></b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>]
<b><span style="font-weight: bold;">On Behalf Of </span></b>danny<br>
</div><div><div></div><div><b><span style="font-weight: bold;">Sent:</span></b> Friday, August 01, 2008 9:30
AM<br>
<b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion<br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Merge
all polygons from a dataset</div></div></span></font></p><div><div></div><div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
<div>
<p style="margin-right: 0in; margin-bottom: 12pt; margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">Many
thanks, Regina! Indeed ST_Union generated the polygon, invisible in PgAdmin!! <br>
<br>
It creates a nice layer when I open it in uDig. <br>
<br>
However when I export it with pgsql2shp, the shape is unreadable by ArcView
with the errmsg: Number of shapes does not match the number of table records.<br>
<br>
Here's how I created the layer:<br>
<br>
create table europe_contour();<br>
SELECT addgeometrycolumn('db, 'europe_contour', 'the_geom', 32767,'MULTIPOLYGON',
2 );<br>
insert into europe_contour(the_geom) values( (select st_union(the_geom) from
europe));<br>
<br>
Then I generate the shapefile: <br>
<br>
"c:\Program Files\PostgreSQL\8.3\bin\pgsql2shp.exe" -u postgres -P
password -f europe_contour db europe_contour<br>
<br>
Any suggestions perhaps on anything I've wrong?<br>
<br>
</span></font></p>
<div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">On Fri, Aug 1, 2008 at 1:15 PM, Obe, Regina <<a href="mailto:robe.dnd@cityofboston.gov" target="_blank">robe.dnd@cityofboston.gov</a>>
wrote:</span></font></p>
<div>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">Erik,</span></font></p>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">How were you using
ST_Union and what exactly do you mean by no result. no result as it looks
blank? If you are using something like PgAdmin III - it will look blank
because it exceeds the buffer supported by PgAdmin III.</span></font></p>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">SELECT the_geom is null </span></font></p>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">FROM (somequery or table)
as foo</span></font></p>
<div>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">LIMIT 1</span></font></p>
</div>
<div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">will tell you if its
actually returning no geometry</span></font></p>
</div>
<div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">Hope that helps,</span></font></p>
</div>
<div>
<p style="margin-left: 0.5in;"><font size="2" color="blue" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: blue;">Regina</span></font></p>
</div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
<div style="margin-left: 0.5in; text-align: center;" align="center"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr size="2" width="100%" align="center">
</span></font></div>
<p style="margin-right: 0in; margin-bottom: 12pt; margin-left: 0.5in;"><b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma;"> <a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>danny<br>
<b><span style="font-weight: bold;">Sent:</span></b> Friday, August 01, 2008 6:12
AM<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> [postgis-users] Merge all
polygons from a dataset</span></font></p>
<div>
<div>
<div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">Hello everybody,<br>
<br>
I've converted a shapefile of Europe to PostGIS. I would like to merge all the
countries together so that I only have one polygon left, the whole contour of
Europe. I have tried ST_Union that gives me no result. I've tried several other
functions to no avail. Does anybody know how I should proceed?<br>
<br>
Many thanks,<br>
<br>
Erik</span></font></p>
</div>
</div>
</div>
</div>
<div>
<div style="margin-left: 0.5in; text-align: center;" align="center"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr size="1" width="100%" align="center">
</span></font></div>
<p style="margin-left: 0.5in;"><b><font size="3" face="Times New Roman"><span style="font-size: 12pt; font-weight: bold;">The substance of this message,
including any attachments, may be confidential, legally privileged and/or
exempt from disclosure pursuant to Massachusetts law. It is intended solely for
the addressee. If you received this in error, please contact the sender and
delete the material from any computer. </span></font></b></p>
</div>
<div style="margin-left: 0.5in; text-align: center;" align="center"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr size="1" width="100%" align="center">
</span></font></div>
<p style="margin-left: 0.5in;"><b><font size="2" color="#339900" face="Times New Roman"><span style="font-size: 10pt; color: rgb(51, 153, 0); font-weight: bold;">Help make the earth a greener place. If at all possible resist printing
this email and join us in saving paper. </span></font></b></p>
<p style="margin-right: 0in; margin-bottom: 12pt; margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></span></font></p>
</div>
<p style="margin-left: 0.5in;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div></div></div>
</blockquote></div><br></div>