[postgis-tickets] [PostGIS] #3957: ST_StartPoint - not works correctly

PostGIS trac at osgeo.org
Mon Dec 25 10:45:08 PST 2017


#3957: ST_StartPoint - not works correctly
---------------------+---------------------------
 Reporter:  sanyasi  |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.4.3
Component:  postgis  |    Version:  2.4.x
 Keywords:           |
---------------------+---------------------------
 In the Quantum, I draw a point, and the line emerging from it.

 1) select
 ST_x(ST_StartPoint(geo)),ST_y(ST_StartPoint(geo)),ST_StartPoint(geo),geo
 from devicelink WHERE "gid"=17178;

 2) SELECT ST_x(geo),ST_y(geo),geo FROM map.devices WHERE ip='192.168.1.1';

 1)
 36.1191425241613;56.7842403055775;"0101000020E6100000F46AEE0F400F4240825480FC61644C40";"0102000020E610000002000000F46AEE0F400F4240825480FC61644C401998EA8F410F4240DCEC82F163644C40"

 2)
 36.1191425241613;56.7842403055775;"0101000020E6100000F76AEE0F400F4240835480FC61644C40"


 "PostgreSQL 9.5.10 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit POSTGIS="2.4.2 r16113" PGSQL="95"
 GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.10.1, released 2013/08/26" LIBXML="2.9.1" L (...)"


 POSTGIS="2.3.2" works correctly

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3957>
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