redirect link on BCMI that directs to the corresponding search on NRCED

bcgov / NRPTI

Natural Resources Public Transparency Initiative

Apache License 2.0

5 stars 14 forks source link

redirect link on BCMI that directs to the corresponding search on NRCED #1262

Closed jakemorr closed 3 months ago

jakemorr commented 3 months ago

As a member of the public I want a link to all relevant records of a mine on BCMI So That I can see their history of compliance

Additional Context

Linking to NRCED will help show all the inspections
BCMI only tracks major mines and mines of note
Only need the mines within BCMI
The link will show a pre-searched of BCMI
There is not a perfect match of mine names - some use abbreviation

Acceptance Criteria

on each Mine page on BCMI, I want a link on BCMI that redirects to the corresponding search on NRCED

Keegnan commented 3 months ago

Reaching out to Colin might help with coming up with a better solution with some of the names and creating a proper mapping table with the mine names.

Keegnan commented 3 months ago

Completing this as the first slice - Adding a link to all BCMI mines to existing records in NRCED.

sggerard commented 3 months ago

Should be able to use company name to match. Need to make changes to NCRED first to support searching NRPTI by companyName.

e.g. including &or[issuedTo.companyName]=KGHM%20Ajax%20Mining%20Inc)

sggerard commented 3 months ago

Using company name doesn't work as one company can have multiple mines, additionally there are other issues such as case and and vs &.

The projectName field on Inspections in NRPTI seems like a good candidate, it appears to store the mine name. However the NRIS-EPD doesn't currently set that field. NRIS-EMLI does based on the locationName field but it varies. (e.g Silvertip instead of Silvertip mine. However the locationID field matches the mine_no of the CORE mine but this is not a field that we are currently capturing.

It appears the best approach for correctly joining NRIS to CORE is to:

Store mine_no (e.g 0100525) against BCMI Mine records as part of the CORE importer.
Update the NRIS-EPD and NRIS-EMLI importers to do a lookup of mine name based on location.locationID = mine_no and store the mine name in the projectName field.
Allow searching of projectName in NCRED

sggerard commented 3 months ago

Changes deployed to test environments for both BCMI & NRPTI. A link to NRCED shows on the Compliance Oversight tab of each mine in BCMI.

https://bcmi-f00029-dev.apps.silver.devops.gov.bc.ca/p/5fa1e3f54635c865df00c575/compliance