Spatial data
We'd like to make spatial (polygon) queries for accessions in Genesys.
Use case
https://www.genesys-pgr.org/explore/map has the Select area that allows user to select a rectangle (min&max for accession collecting site latitude&longitude). If we allow user to select a polygon (https://leafletjs.com/reference-1.4.0.html#polygon), can the API make a query to the database to find accessions where accessionGeo is inside the selected polygon?
- https://mariadb.com/kb/en/library/geographic-geometric-features/
- https://www.baeldung.com/hibernate-spatial
Other cases
-
FaoInstitutelocation haslat&long