search

jncc / bh3-automation

Automation of the Extent of Physical Damage marine biodiversity indicator
MIT License
1 stars 1 forks source link

Missing EUNIS L3 code / sensitivity mappings #12

Open mattdebont opened 3 years ago

mattdebont commented 3 years ago

Update to the OSPAR habitat map has made it clear that there are a bunch of missing L3 code mappings (lut.sensitivity_broadscale_habitats), this is leaving large areas off the output maps, which is very noticeable when compared to previous runs

mattdebont commented 3 years ago

Current list of non mapped codes from the new habitat maps pulled out with 

SELECT eunis_l3 FROM static.uk_habitat_map_wgs84_20210727
    WHERE eunis_l3 NOT IN (SELECT eunis_l3_code FROM lut.sensitivity_broadscale_habitats)
    GROUP by eunis_l3
    ORDER by eunis_l3

"A" "A.25" "A1" "A1 + A2.2" "A1 + A3" "A1.1" "A1.1 + A1.2" "A1.1 + A1.2 + A1.3" "A1.1 + A1.2 + A3.2" "A1.1 + A1.3" "A1.1 + A1.4" "A1.2" "A1.2 + A1.3" "A1.2 + A1.4" "A1.2 + A2.4" "A1.3" "A1.3 + A1.4" "A1.3 + A2.4" "A1.4" "A1.4 + A5.5" "A2" "A2.1" "A2.1 + A2.2" "A2.1 + A2.4" "A2.2" "A2.2 + A2.3" "A2.3" "A2.3 + A2.4" "A2.3 + A2.5" "A2.4" "A2.4 + A2.8" "A2.5" "A2.5 + B1.3" "A2.6" "A2.7" "A2.8" "A3" "A3 + A4" "A3.1 + A4.1" "A3.1 + A4.2" "A3.1 + A5.1" "A3.1 + A5.4" "A3.2 + A4.1" "A3.2 + A4.1 +A4.2" "A3.2 + A4.2" "A3.2 + A5.4" "A3.7" "A3.7 + A4.1 + A5.1" "A4" "A4.1 + A4.2" "A4.1 + A4.2 + A4.3" "A4.1 + A4.2 + A5.1 + A5.2" "A4.1 + A4.7" "A4.1 + A5.1" "A4.1 + A5.2" "A4.1 + A5.4" "A4.1 + A5.6" "A4.2 + A5.1" "A4.2 + A5.4" "A4.7" "A5" "A5.1 + A5.2" "A5.1 + A5.3" "A5.1 + A5.4" "A5.1 + A5.5" "A5.1 +A5.4" "A5.2 + A5.3" "A5.2 + A5.4" "A5.3 + A5.4" "A5.4 + A5.5" "A5.7" "A6.2 + A6.5" "A6.3 + A6.4" "A6.3 + A6.4 + A6.5" "A6.9" "B" "B1" "B1.1" "B1.2" "B1.3" "B1.3 + B1.4" "B1.4" "B2" "B2 + B2.1" "B2.1" "B2.3" "B2.4" "B3" "B3.1" "B3.3" "E2.6" "F4.2" "J" "Na" "X32" "X33" "non_ENG_20" "non_ENG_21" "non_ENG_22" "non_ENG_23" "non_ENG_24"