mbari-org / SeafloorMappingDB

Make MBARI seafloor mapping datasets more accessible and useful
GNU General Public License v3.0
3 stars 6 forks source link

Add panel to overview page to search on Missions by attributes like missiontype, etc. #124

Open jbpaduan opened 2 years ago

jbpaduan commented 2 years ago

Examples: the mission types testing iceberg configuration repeat mapping

jbpaduan commented 2 years ago

Aside: the "mission type" table appears to be redundant with the "platform type" but it isn't exactly.

jbpaduan commented 2 years ago

How do you think "failed", "testing", "dont_use", "use_with_caution", and "patch_test" would best be captured? They might be buried in the Notes file or part of the title of the thumbnail (defined in the process.cmd code), but there's not been any strict strings used, so far.

jbpaduan commented 2 years ago

The "patch_test" boolean should be "yes" if there's a patch test within a full survey, AND if that's the only thing that was done, as when the "testing" boolean might also be "yes". We adjust the vehicle attitude settings derived from a patch test going forward in our processing, until the next one, so it would be useful to know when they've happened.

jbpaduan commented 2 years ago

Booleans we have for Mission: repeat_survey test_survey failed_survey dont_use_survey use_survey_with_caution patch_test

jbpaduan commented 2 years ago

I too worry that a stand-alone file in each mission directory might get stale, though these particular status properties are unlikely to change (unless we do a lot of work on to rehabilitate a nasty survey, in which case we'd be eager to update it if we're successful).

As to utilizing what is part of our work-flow, we've unfortunately been inconsistent with recording the intentions or ultimate outcomes in the Notes files and process.cmd files. That could be fixed by going backward (not too painful, just takes time). And we can easily - and need to, anyway - do better going forward.

MBARIMike commented 2 years ago

I've worked out how to display a map, table, and set of form fields for making these kind of searches using Django's Class Based Views. For an example see: https://emdb.shore.mbari.org/navfiles/ (internal to MBARI only). This can be done for this database too.

jbpaduan commented 5 months ago

The pull-downs are working well now on the Missions page. Someday it would be great for them to be an option on the Overview page as well.

MBARIMike commented 5 months ago

Another option is to have the single "Search SMDB Missions..." text box on the Overview home page query appropriate fields now that we're populating more of them from the spreadsheets. The current query performed from what's entered there is:

            missions = missions.filter(
                Q(name__icontains=search_string)
                | Q(notes_text__icontains=search_string)
            )

I think searching the Notes text returns too many "false positives". Maybe we can replace that with a search of region_names and Expedition names, and maybe more.