[Answered ]-Geodjango with Mysql coordinates/polygons precision


Thank you for your help. Finally I’ve used a two-phase approach:

** – First step** is to check for a list of results using shape__contains

** – Second step** is to loop through those results and check if a point is inside those polygons using polygon.intersects(locationPoint)



Quote Justin Bronn:

“MySQL is a crippled spatial database…”

Instead of contains it actually executes bbcontains, and is well known for unreliable results. https://code.djangoproject.com/ticket/13430

I’d suggest moving to PostgreSQL.
I don’t have answer if it’s not an option.


Leave a comment