[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