Changes between Initial Version and Version 1 of Ticket #3957
- Timestamp:
- 12/27/17 00:13:03 (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #3957 – Description
initial v1 1 1 In the Quantum, I draw a point, and the line emerging from it. 2 2 3 1) select ST_x(ST_StartPoint(geo)),ST_y(ST_StartPoint(geo)),ST_StartPoint(geo),geo from devicelink WHERE "gid"=17178; 3 1) 4 {{{ 5 select ST_x(ST_StartPoint(geo)),ST_y(ST_StartPoint(geo)),ST_StartPoint(geo),geo from devicelink WHERE "gid"=17178; 6 }}} 4 7 5 2) SELECT ST_x(geo),ST_y(geo),geo FROM map.devices WHERE ip='192.168.1.1';6 8 7 1) 36.1191425241613;56.7842403055775;"0101000020E6100000F46AEE0F400F4240825480FC61644C40";"0102000020E610000002000000F46AEE0F400F4240825480FC61644C401998EA8F410F4240DCEC82F163644C40" 9 2) 10 {{{ 11 SELECT ST_x(geo),ST_y(geo),geo FROM map.devices WHERE ip='192.168.1.1'; 12 }}} 8 13 9 2) 36.1191425241613;56.7842403055775;"0101000020E6100000F76AEE0F400F4240835480FC61644C40" 14 15 1) 16 {{{ 17 36.1191425241613;56.7842403055775;"0101000020E6100000F46AEE0F400F4240825480FC61644C40";"0102000020E610000002000000F46AEE0F400F4240825480FC61644C401998EA8F410F4240DCEC82F163644C40" 18 }}} 19 20 21 2) 22 {{{ 23 36.1191425241613;56.7842403055775;"0101000020E6100000F76AEE0F400F4240835480FC61644C40" 24 }}} 25 10 26 11 27