<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi forum,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The following query is returning an exception:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">ERROR: GEOSBuffer: TopologyException: assigned depths do not match at -10560000 4740000<o:p></o:p></p>
<p class="MsoNormal">SQL state: XX000<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am assuming it is related to: st_contains(st_buffer(st_transform(waypoints,3857), 30.0),st_transform(segment_geom,3857))
<o:p></o:p></p>
<p class="MsoNormal">Could someone tell me what the exception is about?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">select pkey, trip_id, zone_id, segment_id, <o:p></o:p></p>
<p class="MsoNormal">st_astext(ST_MakeLine((zone_wp_pts).geom)) zone_wp_intersection,<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">from (select <o:p></o:p></p>
<p class="MsoNormal">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'
<o:p></o:p></p>
<p class="MsoNormal">and st_intersects(segment_geom, waypoints) <o:p></o:p></p>
<p class="MsoNormal">and st_contains(st_buffer(st_transform(waypoints,3857), 30.0),st_transform(segment_geom,3857))
<o:p></o:p></p>
<p class="MsoNormal">and st_intersects(zone_geom, waypoints)<o:p></o:p></p>
<p class="MsoNormal">) as zone_intersect <o:p></o:p></p>
<p class="MsoNormal">where <o:p></o:p></p>
<p class="MsoNormal">st_intersects((zone_wp_pts).geom, zone_geom) <o:p></o:p></p>
<p class="MsoNormal">group by pkey, trip_id, zone_id, segment_id, <o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">order by pkey, zone_id<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Trang<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>