Suppose I have a table with a geometry column containing polygons created from points of lat and long values (SRID: 4326). Given an arbitrary lat and long location (again SRID: 4326) I want to query for polygons that contain the arbitrary point.

PostGIS documentation recommends using Geography for large areas:

If your data is contained in a small area, you might find that choosing an appropriate projection and using GEOMETRY is the best solution, in terms of performance and functionality available.

And MySQL 5.8 has no dedicated geography type it seems.

How can I determine what the maximum "small area" described above is? In other words how can I determine the maximum area polygon I can store in PostGIS 2.3 and MySQL 5.8 Geometry columns before the results of a function like ST_Contains will be wrong?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.