Re: [postgis-users] shp2pgsql - how to continue when error occurs

etable As dup >>         GROUP BY      dup.dupcolumn1, dup.dupcolumn2, dup.dupcolum3) >> >> (http://www.postgresonline.com/journal/archives/22-Deleting-Duplicate-Records-in-a-Table.html) >> 4- Enforce UK >> >> >> -Imran >> >> >> --- On Tue,

[postgis-users] shp2pgsql - how to continue when error occurs

Hi all, I'm trying to merge multiple shapefiles to postgis table. I know that there is some duplicates in different files. I thought that I could just check duplicatiness when loading shapes with shp2pgsql. So I first created an empty table and added a unique constraint to the field that I know t

[postgis-users] merging dual carriageway motorway lines

Hi all, I have a road network loaded to PostGIS. Now I'm trying to find a way to merge parallel lines of a dual carriageway motorway to single a line? Or is there any? -Lauri ___ postgis-users mailing list postgis-users@postgis.refractions.net http://po

[postgis-users] st_union drops M values

Hi all, I aked this before but no answers. Does anybody have any ideas? I'm trying to make a union of geometries with M-values. But ST_Union seems to drop all the M-values. Or am I doing something wrong? Here is a sample query: select st_asewkt(st_union('LINESTRINGM(0 0 0, 1 1 1)'::geometry,'LI

[postgis-users] st_union and linestringM

Hi all, I'm trying to make a union of geometries with M-values. But ST_Union seems to drop all the M-values. Or am I doing something wrong? Here is a sample query: select st_asewkt(st_union('LINESTRINGM(0 0 0, 1 1 1)'::geometry,'LINESTRINGM(1 1 1, 2 2 2)'::geometry)); Output of this is "MULTILI