Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Question Unanswered: See if lat / long falls within a polygon using mysql

    Estoy tratando de saber si '5 0.03529 -754.368 'se encuentra dentro del polígono, ¿me pueden ayudar, ¿cómo puedo hacer eso?

    Veo que los dos campos tienen formatos diferentes, ¿cómo puedo solucionar esto?

    select within ('5 0.03529 -754.368 ', PyPolygon) de manuelitapolygon

    PyPolygon = 'POLYGON ((5,035247876391217 -75.43594128570524,5.035158505114919 -75.43594598760016,5.03507011299693 -75.43596004176999,5.034983668480416 -75.43598329423428,5.0349001186705165 -75.43601549023417,5.034820378957751 -75.43605627702355,5.034745322988647 -75,436105207733864)) "

  2. #2
    Join Date
    Apr 2012
    Posts
    2
    this is the result

    select contains (PyPolygon, GeomFromText('Point(8.30941
    -73.6010)')) from manuelitapolygon

    now I´m searching how can I use this if lat and long are variables

    'Ponit(lat long)' don't work

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •