what is a "sea"? - Githubissues

dustymc commented 7 years ago

SABI Goal Redo indexing of DarwinCore field ‘Higher Geography’ and Features in Arctos PostgreSQL. Currently, data entry is manual, not by geocoordinates; thus, key functions are broken.

Our definition of "sea" is lacking. http://handbook.arctosdb.org/documentation/higher-geography.html#seas

Suggestion: Limit seas to things in https://en.wikipedia.org/wiki/List_of_seas

Current data; BOLD are not in the wiki list. Links to geography and specimens below.

Amundsen Sea
Barents Sea
Barrow Strait
Bass Strait
Beaufort Sea
Bellingshausen Sea
Bering Sea
Bering Strait
Bristol Bay
Carribean Sea
- this was misspelled in Arctos!
Chukchi Sea
East Siberian Sea
Greenland Sea
Gulf of Alaska
Gulf of California
~~Gulf of Chiriquí~~
Gulf of Mexico
Gulf of Saint Lawrence
Kachemak Bay
Kamishak Bay
Mediterranean
- merged with Mediterranean Sea; used inappropriate source, DMNS:Inv specimens may need review.
Mediterranean Sea
North Sea
Persian Gulf
Red Sea
Ross Sea
Salton Sea
Sea of Japan
Sea of Okhotsk
Spencer Gulf
Sulu Sea
Tirrenian Sea
- This does not seem to be a recognized spelling in any language. I updated to "Tyrrhenian Sea"
Visayan Sea
Wadden Sea


begin
    for r in (
        select
          geog_auth_rec.higher_geog,
          geog_auth_rec.geog_auth_rec_id
        from
          geog_auth_rec
        where
          geog_auth_rec.sea IN (
            'Barrow Strait',
            'Bering Strait',
            'Bristol Bay',
            'Kachemak Bay',
            'Kamishak Bay',
            'Salton Sea'
          )
         order by higher_geog
    ) loop
        dbms_output.put_line( r.higher_geog);
        dbms_output.put_line('http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=' || r.geog_auth_rec_id);
        for c in (
            select
              collection.guid_prefix,
              count(*) c
            from
              collection,
              cataloged_item,
              specimen_event,
              collecting_event,
              locality
            where
              collection.collection_id=cataloged_item.collection_id and
              cataloged_item.collection_object_id=specimen_event.collection_object_id and
              specimen_event.collecting_event_id=collecting_event.collecting_event_id and
              collecting_event.locality_id=locality.locality_id and 
              locality.geog_auth_rec_id=r.geog_auth_rec_id
            group by 
                collection.guid_prefix
             order by
                collection.guid_prefix
        ) loop
            dbms_output.put_line('    ' || c.guid_prefix || ' @ ' || c.c || ' specimens'); 
            dbms_output.put_line('      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=' || c.guid_prefix || '&geog_auth_rec_id=' || r.geog_auth_rec_id); 
        end loop;
    end loop;
end;
/

North America, Barrow Strait, Canada, Northwest Territories, Cornwallis Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=99
    UAM:Mamm @ 8 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=99
North America, Bering Strait, United States, Alaska, Nome Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=639
    UAM:Inv @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=639
    UAM:Mamm @ 15 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=639
North America, Bering Strait, United States, Alaska, Shishmaref Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=800
    UAM:Fish @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=800
    UAM:Inv @ 11 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=800
    UAM:Mamm @ 38 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=800
North America, Bering Strait, United States, Alaska, Teller Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=906
    UAM:Inv @ 3 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=906
    UAM:Mamm @ 39 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=906
North America, Bering Strait, United States, Alaska, Teller Quad, Little Diomede Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=910
    CHAS:Bird @ 9 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=CHAS:Bird&geog_auth_rec_id=910
    DMNS:Bird @ 13 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=DMNS:Bird&geog_auth_rec_id=910
    DMNS:Mamm @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=DMNS:Mamm&geog_auth_rec_id=910
    MSB:Host @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MSB:Host&geog_auth_rec_id=910
    MSB:Mamm @ 3 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MSB:Mamm&geog_auth_rec_id=910
    NBSB:Bird @ 9 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=NBSB:Bird&geog_auth_rec_id=910
    UAM:EH @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:EH&geog_auth_rec_id=910
    UAM:Ento @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Ento&geog_auth_rec_id=910
    UAM:Fish @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=910
    UAM:Inv @ 4 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=910
    UAM:Mamm @ 4763 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=910
    UWYMV:Bird @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UWYMV:Bird&geog_auth_rec_id=910
North America, Bristol Bay, United States, Alaska
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=1006124
    UAM:Bird @ 329 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Bird&geog_auth_rec_id=1006124
    UAM:Fish @ 11 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=1006124
    UAM:Inv @ 17 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=1006124
    UAM:Mamm @ 171 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=1006124
    UAMObs:Mamm @ 19 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAMObs:Mamm&geog_auth_rec_id=1006124
North America, Bristol Bay, United States, Alaska, Bristol Bay Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=286
    UAM:Inv @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=286
    UAM:Mamm @ 3 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=286
    UAMObs:Mamm @ 5 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAMObs:Mamm&geog_auth_rec_id=286
North America, Bristol Bay, United States, Alaska, Chignik Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=306
    MSB:Host @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MSB:Host&geog_auth_rec_id=306
    UAM:Fish @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=306
    UAM:Mamm @ 34 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=306
North America, Bristol Bay, United States, Alaska, Cold Bay Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=318
    UAM:Inv @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=318
    UAM:Mamm @ 16 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=318
North America, Bristol Bay, United States, Alaska, Hagemeister Island Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=436
    UAM:Inv @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=436
    UAM:Mamm @ 25 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=436
North America, Bristol Bay, United States, Alaska, Hagemeister Island Quad, Walrus Islands
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=4580
    UAM:Mamm @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=4580
North America, Bristol Bay, United States, Alaska, Hagemeister Island Quad, Walrus Islands, Crooked Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=437
    UAM:Inv @ 4 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=437
    UAM:Mamm @ 8 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=437
North America, Bristol Bay, United States, Alaska, Hagemeister Island Quad, Walrus Islands, High Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=1006052
    UAM:Mamm @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=1006052
North America, Bristol Bay, United States, Alaska, Naknek Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=630
    UAM:Fish @ 5 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=630
    UAM:Inv @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=630
    UAM:Mamm @ 31 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=630
    UAMObs:Mamm @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAMObs:Mamm&geog_auth_rec_id=630
North America, Bristol Bay, United States, Alaska, Nushagak Bay Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=654
    UAM:Bird @ 10 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Bird&geog_auth_rec_id=654
    UAM:Mamm @ 53 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=654
    UAMObs:Mamm @ 9 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAMObs:Mamm&geog_auth_rec_id=654
North America, Bristol Bay, United States, Alaska, Nushagak Bay Quad, Walrus Islands, Round Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=655
    UAM:Ento @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Ento&geog_auth_rec_id=655
    UAM:Fish @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=655
    UAM:Inv @ 4 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=655
    UAM:Mamm @ 92 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=655
North America, Bristol Bay, United States, Alaska, Port Moller Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=710
    UAM:Inv @ 6 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=710
    UAM:Mamm @ 12 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=710
North America, Kachemak Bay, United States, Alaska, Seldovia Quad, Yukon Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=757
    MSB:Mamm @ 14 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MSB:Mamm&geog_auth_rec_id=757
    UAM:ES @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:ES&geog_auth_rec_id=757
    UAM:Inv @ 4 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=757
    UAM:Mamm @ 13 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=757
North America, Kamishak Bay, United States, Alaska, Iliamna Quad
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=1342
    UAM:Mamm @ 11 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=1342
North America, Kamishak Bay, United States, Alaska, Iliamna Quad, Nordyke Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=1341
    KNWR:Ento @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=KNWR:Ento&geog_auth_rec_id=1341
    UAM:Mamm @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=1341
North America, Salton Sea, United States, California, Imperial County, Bird Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=10004157
    MVZ:Bird @ 8 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Bird&geog_auth_rec_id=10004157
North America, Salton Sea, United States, California, Imperial County, Echo Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=10003972
    MVZ:Bird @ 6 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Bird&geog_auth_rec_id=10003972
    MVZ:Egg @ 5 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Egg&geog_auth_rec_id=10003972
    MVZ:Herp @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Herp&geog_auth_rec_id=10003972
    MVZ:Mamm @ 2 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Mamm&geog_auth_rec_id=10003972
North America, Salton Sea, United States, California, Imperial County, Pelican Island
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=10003973
    MVZ:Bird @ 4 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Bird&geog_auth_rec_id=10003973
    MVZ:Egg @ 9 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=MVZ:Egg&geog_auth_rec_id=10003973
North Pacific Ocean, Bering Strait
http://arctos.database.museum/Locality.cfm?Action=editGeog&geog_auth_rec_id=1149
    UAM:EH @ 1 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:EH&geog_auth_rec_id=1149
    UAM:Fish @ 11 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Fish&geog_auth_rec_id=1149
    UAM:Inv @ 18 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Inv&geog_auth_rec_id=1149
    UAM:Mamm @ 72 specimens
      http://arctos.database.museum/SpecimenResults.cfm?guid_prefix=UAM:Mamm&geog_auth_rec_id=1149

sharpphyl commented 7 years ago

As most of our specimens are marine, it is tempting to want to include more bays, straits, gulfs and other bodies of water in Higher Geography. For us, these smaller bodies of water are similar to county divisions. But we can certainly live with the expanded list of Seas and limit smaller bodies of water to Localities.

sharpphyl commented 5 years ago

Does this need comment? You added some seas at our request so, for use, we can close this issue unless there are loose ends to tie up.

dustymc commented 5 years ago

It's still random data so I think this should stay open somewhere -perhaps moved to documentation or deprioritized.

Jegelewicz commented 3 years ago

I don't know what to document - I think seas are still a problem. Moving back to main repo for code table cleanup label.

sharpphyl commented 3 years ago

Doesn't this issue intertwine with #128 and 2876. Seas are water bodies along with bays, gulfs, straits, lakes etc. It seems this is part of a bigger question.

dustymc commented 2 years ago

Tabling - we don't seem to be interested, https://github.com/ArctosDB/arctos/issues/3272 would allow Arctos to standardize geography.

ArctosDB / arctos

what is a "sea"? #3770