Need to add or modify fields in database

[Greenman126]

Below I have summarized the Fields and Tags that need to be modified/added

Database Modifications MapStatusTag NumberOfPits EntranceDescriptionTag AlternateNameTags GeologicAgeTag PhysiographicProvinceTag (people tag) CartographerNameTag (people tag) Physiographic ProvinceTag BiologyTag ArcheologyTag HydrologyTag (combine both hydrology tags) OtherTags

ReportedBy (people Tag)

File

• Map
• Trip Report
• Article
• Notes
• Data
• Shapefile/GIS
• Photos

Cartographer

Physiographic Province is supposed to be added, but could we do this as a derived value based on location and bounding boxes we create?

Biology

Archeology

Entrance fields Hydrology and Hydrology Frequency fields can be combined into just hydrology.

Hydrology

• Insurgence
• Resurgence
• Dry
• Ephemeral
• Intermittent,
• Perennial

Location Verification

• Unverified
• Approximate
• Point taken in field by gps
• Lidar / GIS Assisted
• Historic topo point

[Greenman126]

Howard suggested we add an "Alternate Names" field in the database

I think this is a good idea. If we made a field called alternate names, can we fill it with "Tags" sort of like we do elsewhere? Then, could we link it so that if you search for a cave name, it'll also search through the alternate names?