Skip to main content
Solved

BigQuery Reader geometry field


kartemann

When using the GoogleBigQueryConnector transformer, I can see my geometry field 'geo' that I created.

 

When I use the Google BigQuery reader, the field 'geo' shows up, but using an inspector connected to the reader, all records show <missing> in the 'geo' field.

Is this a known issue? If so, how can I get around this? I'm hoping to get geometry features from the reader.

 

Thank you in advance!

 

 

Best answer by debbiatsafe

Hi @kartemann

According to our documentation, the GoogleBigQuery reader does not support spatial data. If you wish to access the geo field, I would recommend using the GoogleBigQueryConnector instead of the reader.

BigQuery spatial data is stored as Well Known Text in the coordinate system EPSG:4326. You can then use the GeometryReplacer transformer and set Geometry Encoding parameter as OGC Well Known Text and the Geometry Source parameter as the geo column. Then use the CoordinateSystemSetter to set the coordinate system as EPSG:4326.

Note: you will need to set the Attributes to Expose in the GoogleBigQueryConnector in order to be able to specify the geo column in the GeographyReplacer.

I hope this information helps.

View original
Did this help you find an answer to your question?

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • Best Answer
  • March 6, 2020

Hi @kartemann

According to our documentation, the GoogleBigQuery reader does not support spatial data. If you wish to access the geo field, I would recommend using the GoogleBigQueryConnector instead of the reader.

BigQuery spatial data is stored as Well Known Text in the coordinate system EPSG:4326. You can then use the GeometryReplacer transformer and set Geometry Encoding parameter as OGC Well Known Text and the Geometry Source parameter as the geo column. Then use the CoordinateSystemSetter to set the coordinate system as EPSG:4326.

Note: you will need to set the Attributes to Expose in the GoogleBigQueryConnector in order to be able to specify the geo column in the GeographyReplacer.

I hope this information helps.


kartemann
  • Author
  • March 9, 2020
debbiatsafe wrote:

Hi @kartemann

According to our documentation, the GoogleBigQuery reader does not support spatial data. If you wish to access the geo field, I would recommend using the GoogleBigQueryConnector instead of the reader.

BigQuery spatial data is stored as Well Known Text in the coordinate system EPSG:4326. You can then use the GeometryReplacer transformer and set Geometry Encoding parameter as OGC Well Known Text and the Geometry Source parameter as the geo column. Then use the CoordinateSystemSetter to set the coordinate system as EPSG:4326.

Note: you will need to set the Attributes to Expose in the GoogleBigQueryConnector in order to be able to specify the geo column in the GeographyReplacer.

I hope this information helps.

Thank you Debbi,

I was able to do what I needed with your guidance.

 

Thanks again,


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings