Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Check National grid refs are transferred to SEAD #24

Open
visead opened this issue Dec 10, 2019 · 1 comment
Open

Check National grid refs are transferred to SEAD #24

visead opened this issue Dec 10, 2019 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@visead
Copy link
Contributor

visead commented Dec 10, 2019

BugsCEp stores National Grid References as TSite.NGR.
For each site, these need to be stored in SEAD in tbl_site_natgridrefs.natgridref with appropriate national grid reference method in tbl_methods.
E.g.
Irish sites according to
68 "The Irish National Grid System, established by the Ordnance Survey of Ireland." "Irish National Grid" 17 "Irish Grid Reference System"

UK sites according to
67 "The United Kingdom National Grid system, established by the Ordnance Survey under the name OSGB36." "OSGB36" 17 "UK Ordnance Survey National Grid"

A country may have more than one grid reference method historically.
These methods need entering into table methods with

Note: Although this structure might be overkill for most sites, it allows users to store/search on different grid systems for countries which have had multiple such. E.g. Older Swedish sites may be registered with RT90, but newer ones with Sweref99TM. Then again, a search on the correct grid ref will return a correct result without needing to know the system.

We should discuss implementation pros and cons...

@visead visead added the bug Something isn't working label Dec 10, 2019
@visead
Copy link
Contributor Author

visead commented Feb 19, 2020

Phil will write mapping between BugsCEP and SEAD and add to import checklist.
Might be best to add to extra post import script https://github.com/humlab-sead/sead_change_control/blob/master/bugs/deploy/20191213_BUGS_IMPORT_POST_APPLY.sql as more complicated to work into Erik's program.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants