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

Duplicate divisions for Canadian county "Pelly Crossing" #260

Open
craigsc opened this issue Dec 7, 2024 · 0 comments
Open

Duplicate divisions for Canadian county "Pelly Crossing" #260

craigsc opened this issue Dec 7, 2024 · 0 comments

Comments

@craigsc
Copy link

craigsc commented Dec 7, 2024

See below for full records that I believe are duplicates. I think they should be collapsed into 085656393fffffff0187c3df66f7c927 which seems like it contains more complete data (and more accurate point geo data):

D select * from divisions where country = 'CA' and names.primary = 'Pelly Crossing' and subtype = 'county';
100% ▕████████████████████████████████████████████████████████████▏
                  id = 08565614bfffffff01d108e0c73d95b3
            geometry = \x00\x00\x00\x00\x01\xC0a\x12\x92\xB3\x96\x9A\xE2@Oi\x0E\xB9\xD7&\xC3
                bbox = {'xmin': -136.58041, 'xmax': -136.5804, 'ymin': 62.820755, 'ymax': 62.820763}
             country = CA
             version = 0
             sources = [{'property': , 'dataset': OpenStreetMap, 'record_id': R11935437, 'update_time': NULL, 'confidence': NULL}]
             subtype = county
               class =
               names = {'primary': Pelly Crossing, 'common': {en=Pelly Crossing}, 'rules': NULL}
            wikidata =
        division_ids =
         is_disputed =
        perspectives =
          local_type = {en=county}
              region = CA-YT
         hierarchies = [[{'division_id': 085f1a177fffffff01487e61c3243082, 'subtype': country, 'name': Canada}, {'division_id': 085684d5bfffffff01e53fe452efaf76, 'subtype': region, 'name': Yukon}, {'division_id': 08565614bfffffff01d108e0c73d95b3, 'subtype': county, 'name': Pelly Crossing}]]
  parent_division_id = 085684d5bfffffff01e53fe452efaf76
               norms =
          population =
capital_division_ids =
capital_of_divisions =
         division_id =
               theme = divisions
                type = division

                  id = 085656393fffffff0187c3df66f7c927
            geometry = \x00\x00\x00\x00\x01\xC0a\x12_\xD9\xBA\x1B\x19@OiQ\x96\xCB\x89\x00
                bbox = {'xmin': -136.5742, 'xmax': -136.57419, 'ymin': 62.822796, 'ymax': 62.822803}
             country = CA
             version = 0
             sources = [{'property': , 'dataset': OpenStreetMap, 'record_id': R9561046, 'update_time': NULL, 'confidence': NULL}, {'property': /properties/geometry, 'dataset': OpenStreetMap, 'record_id': N2682751746, 'update_time': NULL, 'confidence': NULL}]
             subtype = county
               class =
               names = {'primary': Pelly Crossing, 'common': {en=Pelly Crossing}, 'rules': NULL}
            wikidata = Q998348
        division_ids =
         is_disputed =
        perspectives =
          local_type = {en=county}
              region = CA-YT
         hierarchies = [[{'division_id': 085f1a177fffffff01487e61c3243082, 'subtype': country, 'name': Canada}, {'division_id': 085684d5bfffffff01e53fe452efaf76, 'subtype': region, 'name': Yukon}, {'division_id': 085656393fffffff0187c3df66f7c927, 'subtype': county, 'name': Pelly Crossing}]]
  parent_division_id = 085684d5bfffffff01e53fe452efaf76
               norms =
          population =
capital_division_ids =
capital_of_divisions =
         division_id =
               theme = divisions
                type = division
                ```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant