[postgis-devel] [PostGIS] #1979: TopoGeo_AddLinestring:

PostGIS trac at osgeo.org
Thu Sep 6 01:04:33 PDT 2012


#1979: TopoGeo_AddLinestring:
----------------------+-----------------------------------------------------
 Reporter:  amartin   |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.2
Component:  topology  |     Version:  2.0.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 {{{
 SELECT TopoGeo_AddLineString('prueba',indiv_geom, 0.8)
 FROM (SELECT (ST_Dump(p_geom)).geom as indiv_geom
  FROM (SELECT ST_GeomFromText('MULTILINESTRING ((535695.149659
 4352913.865809, 535688.723014 4352898.92539, 535723.74701 4352895.150892,
 535753.102703 4352892.178469, 535795.04699 4352887.189505, 535796.627126
 4352887.671191, 535833.621825 4352884.315548, 535876.015985
 4352880.471036), (535835.196958 4352883.587799, 535876.015985
 4352880.471036), (535721.65 4352723.95, 535856.49208 4352710.87767),
 (535716.757204 4352776.376076, 535709.98 4352820.5, 535707.36 4352839.32,
 535706.76 4352849.87, 535702.8 4352855.33, 535692.11 4352866.25, 535687.41
 4352875.78, 535687.44 4352887.6, 535688.11 4352897.4, 535688.497742
 4352897.353794), (535721.65 4352723.95, 535718.85 4352752.09, 535717.5
 4352771.54, 535716.757204 4352776.376076), (535856.49208 4352710.87767,
 535871.413761 4352859.350046, 535858.408056 4352862.146972, 535849.178201
 4352866.7619, 535839.8085 4352874.733138, 535835.613111 4352880.746528,
 535835.196958 4352883.587799), (535688.497742 4352897.353794,
 535688.721074 4352898.927358, 535695.149659 4352913.865809))',25830) AS
 p_geom) AS geom_squery) AS lines;

 }}}

 This query creates 8 different edges (as seen in edge_data table) but
 returns only 7 (one of them is allways repeated)

 Eg: edge_id 2 appears twice in query results but edge 8 is actually
 created in the edge_data table

 Query result:
 {{{
 "topogeo_addlinestring"
 "2"
 "3"
 "4"
 "5"
 "6"
 "7"
 "2"
 "9"
 }}}

 Might be related to ticket [http://trac.osgeo.org/postgis/ticket/1968
 #1968]

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1979>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list