Geomunion works but is painfully slow (minutes rather than seconds). Any suggestions on how to get a collect (or something similar) to work?
Thanks, John _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Obe, Regina Sent: Tuesday, July 17, 2007 2:42 PM To: PostGIS Users Discussion Subject: RE: [postgis-users] You've found a bug! That's strange. I never thought shape files ever supported geometry collections. Are you sure that last time you ran it maybe your collect returned all multipoint or multipolygons and now with a newer dataset your have a mixed back resulting in one or more records being a geometrycollection? What happens when you replace collect with geomunion? thanks, Regina _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Cole Sent: Tuesday, July 17, 2007 3:03 PM To: 'PostGIS Users Discussion' Subject: [postgis-users] You've found a bug! Running pgsql2shp with the following query on a tiger lkA table, I get a notice that I've found a bug :-) This query worked with 8.1. "select coalesce(fedirp || ' ', '') || fename || coalesce(' ' || fetype, '') || coalesce(' ' || fedirs, '') as name, case when substring(fename, '(Old)') is not null then null else substring(fename, '(?:I[[:space:]]?-?|Highway|Hwy|County[[:space:]]Road|Co[[:space:]]Rd|County |State[[:space:]]Route|Parish|Parish[[:space:]]Road|S[[:space:]]R|C[[:space: ]]R|Sr|Co|Carretera|St[[:space:]]Rt|C Rd|Co R|County[[:space:]]Route|Cr-?)+[[:space:]]?([[:digit:]]+)') end as hwy_num, cfcc, transform(simplify(segmentize(transform(collect(the_geom), 1000000), 1), 3), 4326) as the_geom from TGR01001 where substring(cfcc, '(A[456789])+') is not null group by cfcc, hwy_num, fedirp, fename, fetype, fedirs order by cfcc desc" Preparing table for user query... Done. Initializing... type 'GEOMETRYCOLLECTION' is not Supported at this time. The DBF file will be created but not the shx or shp files. You've found a bug! (pgsql2shp.c:2869) Thanks, John This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
