emireadcode

WITH
  nyc AS (
  SELECT
    *
  FROM
    PROJECT.DATASET.nyc
  LIMIT
    10000)

SELECT

emireadcode

WITH
  nyc AS (
  SELECT
    *
  FROM
    PROJECT.DATASET.nyc
  LIMIT
    10000)
    
SELECT

emireadcode

CALL `carto-un`.carto.CREATE_TILESET(
  R'''(
        select id, all_tags, st_geogpoint(longitude, latitude) as geom from bigquery-public-data.geo_openstreetmap.planet_nodes
  )
  ''',
  R'''`project.dataset.osm_nodes_tiles_17_and_down`''',
  STRUCT(
    "OSM Nodes" AS name,
    "OSM nodes raw data for zooms 17 and below" AS description,
    NULL AS legend,

emireadcode

CALL `carto-un`.carto.CREATE_POINT_AGGREGATION_TILESET(
  R'''(
    select id, st_geogpoint(longitude, latitude) as geom from bigquery-public-data.geo_openstreetmap.planet_nodes
  )''',
  '`project.dataset.osm_nodes_points_17`',
  R'''
    {
      "zoom_min": 0,
      "zoom_max": 17,
      "aggregation_resolution": 7,

emireadcode

CALL `carto-un`.carto.CREATE_SPATIAL_INDEX_TILESET(
  'project.dataset.osm_nodes_10',
  'project.dataset.osm_nodes_tiles_10',
  R'''{
    "spatial_index_column": "h3:h3",
    "resolution": 10,
    "resolution_min": 0,
    "resolution_max": 6,
    "aggregation_resolution": 4,
    "properties": {