datacommonsorg/mixer

Validate translator can work when containedInPlace, geoOverlaps are ARRAY columns of Place table

pradh opened this issue · 1 comments

pradh commented

We are adding repeated fields to Place table, starting with linkedContainedInPlace.

Before moving containedInPlace/geoOverlaps, we should validate if the sample query like below can still work:

>>> import datacommons
>>> query = 'SELECT DISTINCT ?dcid WHERE { ?a typeOf County . ?a dcid "geoId/06085" . ?a containedInPlace ?b . ?b containedInPlace ?c . ?c dcid ?dcid}'
>>> datacommons.query(query)
[{'?dcid': 'usc/PacificDivision'}, {'?dcid': 'country/USA'}]

Verified this works.