Getting error: GEOSBuffer: TopologyException using st_buffer

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users