2012-11-16 conference call¶
Upcoming¶
- No meeting on Wednesday 11/21
- Meeting next at working group
To do¶
send Brad the 3-4 key wiki pagesflag FIA cultivated plots- 95% of FIA plots are cultivated; 2717 of 1 million plots are old growth (in BIEN2)
- script:
nimoy:/home/boyle/bien2/geoscrub/fia/flag_fia_oldGrowth.sql
change old growth age threshold from 250 to 80 years old
- flag cultivated specimens
- scripts:
nimoy:/home/boyle/bien2/geoscrub/cultivated/cult_by_herbaria
,,cult_by_locality
but NOTcult_by_taxon
cult_by_city
- translate scripts to PostgreSQL
- scripts:
set up command-line interface to the DBprint out VegBIEN schema posterflag which subproviders are herbaria- determine which data exports are privileged
From Martha¶
- Brad will send BIEN group a summary of what has been done on the database and what is in analytical database.
- Martha send Brian E a list of potential agenda items and copy Brad.
After meeting¶
reload GBIF, MO, NY
Schema/mappings¶
remove mapping for SALVIAS access level 4 in plotadd families that don't match to family_higher_plant_groupsee if any geoscrub countries are not in the newWorldCountries.countryNameStd- yes:
- Brunei
- Côte d'Ivoire
- Democratic Republic of the Congo
- East Timor
- Falkland Islands
- Iran
- Laos
- Moldova
- North Korea
- Pitcairn Islands
- Reunion
- Russia
- Saint Vincent and the Grenadines
- South Korea
- Syria
- Virgin Islands, U.S.
- query:
SELECT geoscrub_output.countrystd FROM ( SELECT DISTINCT countrystd FROM geoscrub.geoscrub_output WHERE countrystd IS NOT NULL ) geoscrub_output LEFT JOIN "newWorld"."newWorldCountries" ON "newWorldCountries"."countryNameStd" = geoscrub_output.countrystd WHERE "newWorldCountries"."countryNameStd" IS NULL -- no match ORDER BY geoscrub_output.countrystd
- yes:
change coordinates.coordsaccuracy_deg units to madd coordsaccuracy_m to analytical DBrename sourcecontributor.roletype to sourcecontributor.rolemake sourcecontributor.roletype an enum containing owner, etc.make sourcecontributor.position an enum containing PI, etc.: This is actually the order in which the person's name appears in a list of authors, so it has instead been renamed to order- map SALVIAS PIs to sourcecontributor or locationeventcontributor with position = PI, role = owner
map geoscrub.county