0

I have a BigQuery table with polygons data:

| id (int)  | polygon_shape (string)     |
+-----------+----------------------------+
| 1         | {"type": "Polygon", "coordinates": [[[-11.6422, 36.6872], [-11.642038, 36.68726], [-11.64215117, 36.6872864]]]} |
| 2         | {"type": "Polygon", "coordinates": [[[-12.6432, 35.6852], [-12.642038, 35.68826], [-12.64215117, 35.6872860]]]} |

And I want to draw this polygon on a map in looker or may be be able to create some kind aggregation based on polygon (I have a working connection and able to create views and models for other tables).

I am trying to understand how can I access this info.

What is the right way to define a dimension for this kind of data? Should I extract the "coordinates" key to a different json field? May be just convert "polygon_shape" column to a json type? Or GeoJson (ST_ASGEOJSON)?

Feeling a bit confused and would really appreciate any help

Nina
  • 89
  • 1
  • 7
  • Hi @Nina, Does this [stack link](https://stackoverflow.com/questions/74726436) help you? – Prajna Rai T Dec 09 '22 at 16:12
  • Thanks @PrajnaRaiT, it looks really interesting. But unfortunately not as I need something from within Looker. Thanks anyway it can very handy for my other work on polygons. – Nina Dec 15 '22 at 13:36

0 Answers0