Town and PT Integration into Site Table

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)

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

Looks good to me! I believe this follows the intended implementation of parSiteID.

2 Likes

Hey Asma! This is exactly right. If you were wanting to nest sites within cities, and cities within provinces, this is the exact approach I would take. You could even next provinces within countries and countries within planets if you wanted to take it that far!

One small addition that I will add though is that popServed and popCount have both been taken out of the sites table and instead are recorded as measures in the newest (still to-be-released) version. So they’ll be treated as site measures moving forward. But even within version 2, I think you’re fine to leave “popServed” blank for entities like cities, provinces, etc. They aren’t really "serving/servicing folks, so much as people are living there. But up to you!

TL;DR - this looks perfect :slight_smile:

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.