Here is an example based on Ontario Province…
- Province: Ontario
- City Toronto
- Site 1: TAB
- Site 2: TNT
- Site 3: THU
- Site 4: TNC
- City: London
- Site 1: LON-W (London Greenway South)
- Site 2: LON-A (London Greenway North)
- City: Kingston
- Site: KCB (Kingston Cataraqui Bay)
- City: Sudbury
- Site: SUD (Sudbury)
- City: Peel Region
- Site: PEEL-G (Peel G.E. Booth)
- City Toronto
After our email exchanges and taking into account your comment, we end-up with this proposal:
parSiteID | SiteID | name | popServed | PopCount |
---|---|---|---|---|
TRT | TAB | Toronto Ashbridges Bay | 1447246 | |
TRT | THC | Toronto Highland Creek | 507980 | |
TRT | TNT | Toronto North Toronto | 192089 | |
TRT | THU | Toronto Humber | 674800 | |
ON | TRT | Toronto | Can be derived | 2794356 |
LON | LON-W | London Greenway South | 114300 | |
LON | LON-A | London Greenway North | 139700 | |
ON | LON | London | 422324 | |
ON | KCB | Kingston Cataraqui Bay | 55000 | |
ON | SUD | Sudbury | 84609 | |
ON | PEEL-G | Peel G.E. Booth | 1089738 | |
ON | ONTARIO | 14223942 |
Any additional comment or just a sign-off will? @matthomson @NHizon