[postgis-tickets] [PostGIS] #5520: ST_ReducePrecision not rounding coordinates as expected

PostGIS trac at osgeo.org
Thu Aug 31 08:27:05 PDT 2023


#5520: ST_ReducePrecision not rounding coordinates as expected
----------------------+---------------------------
 Reporter:  andre286  |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  high      |  Milestone:  PostGIS 3.4.1
Component:  postgis   |    Version:  3.4.x
 Keywords:            |
----------------------+---------------------------
 SELECT st_astext(ST_ReducePrecision(
 'LINESTRING(657012.415312 6475619.607621,657028.616 6475595.798,657028.622
 6475595.817,657029.229 6475595.029,
 657031.971 6475596.084,657035.913 6475590.114,657033.656
 6475588.204,657052.066 6475561.165,
 657056.317 6475550.033,657066.679 6475523.534,657069.809
 6475524.233,657072.182 6475517.718,657069.671 6475516.487,
 657075.57 6475500,657082.237 6475481.366,657092.356 6475454.489,657095.282
 6475455.589,657097.89 6475448.718,657094.899 6475447.428,657100.462
 6475432.085,
 657102.713494 6475426.040564,657105.93 6475417.32,657111.59
 6475412.5,657116.22 6475408.47,657121.73 6475413.23,657131.18 6475404.07)'
 ,0.001))

 result:
 LINESTRING(657012.415 6475619.608,657028.616 6475595.798,657028.622
 6475595.817,657029.229 6475595.029,657031.971
 6475596.084,657035.9130000001 6475590.114,657033.656
 6475588.204,657052.066 6475561.165,657056.317 6475550.033,657066.679
 6475523.534,657069.809 6475524.233,657072.182 6475517.718,657069.671
 6475516.487,657075.5700000001 6475500,657082.237 6475481.366,657092.356
 6475454.489,657095.282 6475455.589,657097.89 6475448.718,657094.899
 6475447.428,657100.462 6475432.085,657102.713 6475426.041,657105.93
 6475417.32,657111.59 6475412.5,657116.22 6475408.47,657121.73
 6475413.23,657131.18 6475404.07)

 Version:
 POSTGIS="3.3.3 2355e8e" [EXTENSION] PGSQL="130" GEOS="3.11.1-CAPI-1.17.1"
 PROJ="9.1.1" LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1"
 WAGYU="0.5.0 (Internal)"
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5520>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list