[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Getting error: GEOSBuffer: TopologyException using st_buffer
From: Trang Nguyen <Trang.Nguyen () inrix ! com>
Date: 2015-10-11 6:39:20
Message-ID: 7BA3BA5B1126A649BF2B6E9A6C43B528E794A7 () COREXH11 ! inrix ! corpnet ! local
[Download RAW message or body]
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','kansa \
s_9','kansas_310','kansas_311','kansas_315','kansas_301','kansas_302','kansas_307','ka \
nsas_306','kansas_305','kansas_204','kansas_201','kansas_3','kansas_2','kansas_1') \
and segment_id in ('5062926','5062931','5062932','4062933','5055496','5063065','506282 \
6','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
[Attachment #3 (text/html)]
<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','5062 \
826','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>
[Attachment #4 (unknown)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]