GeoAnalytics Dataset

[hqx]

Hi Team,

My customer required to connect to Google Bigquery to load the Geo Data using Load data editor but failed. I realized that the dataset seems wrong with additional data and using curve "(" bracket instead of  square "[" bracket but I am not sure whether I am correct and need some help on this.

The following are part of the data provided and please let me know how to correct it if the Geo data is incorrect.

 

If you need the actual data for further investigation, please do let me know and I will send it to you.

Thank you very much and have a nice day!

Best regards,

James Wong

[Patric_Nordstrom]

This is wkt, which GeoOperations reads natively, just use the load operation:

Note that the geometry field needs to be renamed.

regions:
LOAD
region,
geometry as region_geom_wkt
FROM [lib://Patrics Share:DataFiles/region_geo_simplify.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);


region_poly:
Load * Extension
GeoOperations.ScriptEval(
'Select region, region_geom_wkt as region_poly from Load()
', regions);