Text Search on catalogs

[adamkorynta]

Looking into: #288 Oracle provides really useful features for text search: https://docs.oracle.com/en/database/oracle/oracle-database/19/ccref/oracle-text-CONTAINS-query-operators.html

Called out in the issue, searching on location-id, public name, long name, description, map label, nearest city, and location kind are useful.

I can see this also broadening to time series catalog: search for location (everything included above?) + time series id parts + parameter description (for spelled out abbreviations).

Anything else useful to include? Should this concept expand to ratings or levels? All catalogs as a rule?

[MikeNeilson]

Eventually yeah, but we should probably start small to avoid getting slapped with massive performance issues changing everything.

[adamkorynta]

absolutely!