[postgis-users] Getting error: GEOSBuffer: TopologyException using st_buffer

[Trang Nguyen]

Hi forum,

The following query is returning an exception:

ERROR: GEOSBuffer: TopologyException: assigned depths do not match at -10560000 4740000
SQL state: XX000

I am assuming it is related to:  st_contains(st_buffer(st_transform(waypoints,3857), 30.0),st_transform(segment_geom,3857))
Could  someone tell me what the exception is about?

select pkey, trip_id, zone_id, segment_id,
st_astext(ST_MakeLine((zone_wp_pts).geom)) zone_wp_intersection,
startts, endts, startloc, endloc, probe_id, provider_id, movement_type, mode, trip_dist_m, trip_mean_speed_metersph, trip_max_speed_metersph, is_start_home, is_end_home, waypoints, match_cond
from (select
st_dumppoints(waypoints) as zone_wp_pts,  -- get actual points in waypoints that intersect with zonepkey, trip_id, startts, endts, startloc, endloc, probe_id, provider_id, movement_type, mode, trip_dist_m, trip_mean_speed_metersph, trip_max_speed_metersph, is_start_home, is_end_home, waypoints, match_cond, zone_id, zone_geom, segment_id, segment_geom from od1.v_trip_zone_segment where startts>=TIMESTAMP '2015-04-16T12:20:29.000Z' and startts<TIMESTAMP '2015-04-17T17:20:30.000Z' and endts<TIMESTAMP '2015-04-17T17:20:30.000Z' and zone_id in ('kansas_303','kansas_601','kansas_603','kansas_604','kansas_10','kansas_11','kansas_9','kansas_310','kansas_311','kansas_315','kansas_301','kansas_302','kansas_307','kansas_306','kansas_305','kansas_204','kansas_201','kansas_3','kansas_2','kansas_1') and segment_id in ('5062926','5062931','5062932','4062933','5055496','5063065','5062826','5062825','5062824','5062643','5062644','5062645','5062646','5055551','5062839','5062849','5062895','5063081') and segment_mapversion='1501'
and st_intersects(segment_geom, waypoints)
and st_contains(st_buffer(st_transform(waypoints,3857), 30.0),st_transform(segment_geom,3857))
and st_intersects(zone_geom, waypoints)
) as zone_intersect
where
st_intersects((zone_wp_pts).geom, zone_geom)
group by pkey, trip_id, zone_id, segment_id,
startts, endts, startloc, endloc, probe_id, provider_id, movement_type, mode, trip_dist_m, trip_mean_speed_metersph, trip_max_speed_metersph, is_start_home, is_end_home, waypoints, match_cond
order by pkey, zone_id

Thanks,
Trang

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151011/c972e8dc/attachment.html>