search

jncc / marine-habitat-classification

Marine Habitat Classification subsite
1 stars 1 forks source link

Clean AccessDB #1

Closed paul-gilbertson closed 7 years ago

meganevparry commented 7 years ago

There are copies of tables and old tables which aren’t needed – WEB_ddBIOTOPE, WEB_SLIDES-backup, WEB_BIOT_RELATION pre 6 May 2016, WEB_BIOT_SPECIES pre 26 feb 2016, WEB_BIOTOPE pre 26 feb 2016

WEB_BIOT_SPECIES I’m not sure what the FAITH column is for. temp1_STRENGTH and temp2_SED_ABUND appear to be empty and I’m not sure what they are for.

WEB_BIOTOPE All fields required

WEB_BIOTOPE_HIERARCHY This will be used to create the hierarchy – I expect this information is required in some format.

WEB_ddBIOTOPE I’m not sure what this table is for

WEB_OLD_CODE This information is required.

WEB_SLIDES This information is required. The orientation isn’t necessarily needed, but was presumably used on for the old website.

paul-gilbertson commented 7 years ago

Is there a clean copy somewhere?

meganevparry commented 7 years ago

WEB_SLIDES - not sure why these are assigned an NBNKey as an identifier, I would have thought it would be better to have BIOTOPE_KEY

meganevparry commented 7 years ago

I've saved a cleaned version (marbiotope-deepsea_MPcleaned.mdb) here: Z:\Prog110-FutureData\Marine\Data\Marine Habitat Classifications

I've deleted out the tables where the information was explicitly necessary, but I presume there was a reason they were included originally. They must have been used to create the old web pages.

paul-gilbertson commented 7 years ago

Perfect, closing issue.

ulric-wilson commented 7 years ago

Table WEB_ddlBIOTOPE provided the source for the Drop Down List (ddl) used on the Biotope Search page.