Move tileIndex to AccessionData
Querying for lat, lon
takes forever, current filtering by latitude takes 30s:
By moving tileIndex
property from AccessionGeo
to AccessionData
we will have better access to georeferenced accessions.
Update liquibase to add tileIndex, copy current data from AccessionGeo
to Accession
and AccessionHistoric
, but also keep it in Geo.
Add database index on tileIndex
.
Update tileIndex (prepersist) in AccessionData
.
Updated querying for lat/lon
In addition to querying by latitude
and longitude
ranges, add criteria on Accession
to have tileIndex not null
.