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
-
FaoInstitute
location haslat&long