0

Is there a bounding box type or a nearest equivalent for specifying a column the will store an extent (SE-NW) and how would I then query the database to find entries where a point exists within it?

My use case is that I am wanting to create a table that will list a collection of GPX files covering different areas and I want to be able to search for entries that cover a given point.

My current question is for MariaDB, but I am also evaluating Postresql+Postgis for our environment.

  • I would suggest to read something about MariaDB and spatial from the web and make more focused questions after that. – user30184 Mar 23 '16 at 17:40
1

See postgreSQL geometric Type: http://www.postgresql.org/docs/current/static/datatype-geometric.html

For bounding box, you can use "box" type.

Some Postgis functions return BBOX, like this aggregate: http://postgis.net/docs/ST_Extent.html

For intersection, you can use Postgis function like ST_Intersects: http://postgis.org/docs/ST_Intersects.html

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.