Geojson with properties, extracted from bigquery

bigquery-geojson-with-properties.json

[
  {
    "json": "{\"type\":\"MultiLineString\",\"coordinates\":\"[[[11.36588,61.13079], ... , [11.007229,61.572116]]]\",\"properties\":{\"description\":\"Stengt på grunn ... . \"}}"
  },
  ...
  {
    "json": "{\"type\":\"LineString\",\"coordinates\":\"[[10.402729,62.429979], ... ,[10.335529,62.561779]]\",\"properties\":{\"description\":\"Stengt på grunn ... .\"}}"
  }
]

query.sql

SELECT 
 TO_JSON_STRING(t) as json 
FROM
 (SELECT
   JSON_VALUE(geojson, "$.type") as type,
   JSON_QUERY(geojson, "$.coordinates") as coordinates,
   STRUCT(description) as properties
  FROM
  (SELECT 
    ST_ASGEOJSON(correctedGeography) geojson,
    description
   FROM `dataset.table`
   LIMIT 10)) as t