Member Avatar for newbie14
newbie14 0 Posting Pro

Dear All,
I have been using the MBRWithin function for quite a lot of times. Suddenly I notice on google map this 'POINT(101.11857 4.34475)') is out of the geo fence which I specify but it still give a value of 1 in mysql any reason or tweaking need to be done?

SELECT MBRWithin(GeomFromText('POINT(101.11857  4.34475)'),GeomFromText('POLYGON((101.12112522125244 4.3531723687957164,101.11846446990967 4.351417913665312,101.13138198852539 4.336397898951581,101.13477230072021 4.33211863778494,101.14065170288086 4.321933898868271,101.14992141723633 4.306699328215635,101.15455627441406 4.30978050198082,101.1397933959961 4.334600612212089,101.12112522125244 4.3531723687957164,101.12112522125244 4.3531723687957164))')) As geoFenceStatus
  • 1 Contributor
  • 0 Replies
  • 69 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.