CReSIS/OLD_OPS

Alter Geoserver Crossovers SQL Views

Closed this issue · 1 comments

treystaff commented

Geoserver uses the crossover errors SQL views created in provisions. This query is very slow and inefficient. An alternative SQL view should be defined in Geoserver. See the getCrossovers() SQL for an example of how this could be done.

When the new Geoserver view is created:

  1. Remove the crossover errors views creation from provisions.
  2. Edit the Crossover wiki page to reflect these changes.
  3. If speedup is significant enough, re-enable crossovers in the geoportal. If not, edit crossover errors SLD in geoserver to limit crossovers from rendering until zoomed in.
treystaff commented

Closing w/ a30f65e

Still need to possibly limit crossovers to zoomed in view. Still need to re-enable in geoportal.