Save path in MySQL POINT

Navigation
0

I need to save a complete path set by GeoPuntos ( POINT ) in mysql to be displayed in an application

asked by Max Sandoval 16.04.2016 в 20:27
source

2 answers

1

In mysql since version 5.6, it has geolocation functions , you can use a POLYGON type, get the number of coordinates you want to give example:

  

POLYGON ((-75.57381551 6.25798087, -75.57918235 6.24777741, -75.57440132   6.234515846, -75.57946533 6.196375053, -75.58360264 6.18617211, -75.60424492 6.162620258, -75.631635636057197 6.14764380890139, -75.638598650668399 6.15055592935419, -75.624286383400005 6.1564761251, -75.5952756107 6.1772549559, -75.58530182 6.188866026, -75.581181943399997 6.1982522933, -75.576439797904897 6.23223344905877, -75.58028542 6.244681524, -75.58208786 6.245897352, -75.58204494 6.250291376, -75.5803927 6.250909949, -75.57580076 6.258802026, -75.57381551 6.25798087))

Details of the operation of the field .

    
answered by 21.09.2016 в 16:37
0

You can use the MULTIPOINT data type if you want to save several points in a single field link

    
answered by 07.08.2018 в 00:10
Show dynamic directives with AngularJS Avoid the step to the previous form but has closed the current one, vb Devexpress