Tuesday, December 2, 2014

MAP3D (Topobase) can't split linestring due to duplicate points

Apparently if you look at the geometry using the API (feature) the collection of the linestring has double starting points and double endpoints.

A validation on oracle doesn't detect the problem in the collection of the linestring.

Performing a spatial function, either rectify or a simplify, on the geometry will solve the problem.

select * from tb_job where name = 'Aansluiting 67 G split';
exec job3.setjob(45);
select * from in_geo_segment where FID = 43141;
update in_geo_segment set geom = SDO_UTIL.SIMPLIFY(geom,0.01,0.005) where fid = 43141;
commit;

select * from tb_job where name = 'Aansluiting 108 G split';
exec job3.setjob(48);
select * from in_geo_segment where FID = 46655;
update in_geo_segment set geom = SDO_UTIL.SIMPLIFY(geom,0.01,0.005) where fid = 46655;
update in_geo_segment set geom = SDO_UTIL.SIMPLIFY(geom,0.01,0.005) where fid = 46651;
update in_geo_segment set geom = SDO_UTIL.SIMPLIFY(geom,0.01,0.005) where fid = 47169;
commit;