Javier de la Torre jatorre

## dark_matter_blue.json
{
  "version": 8,
  "name": "Dark Matter",
  "metadata": {
    "mapbox:autocomposite": false,
    "mapbox:groups": {
      "101da9f13b64a08fa4b6ac1168e89e5f": {
        "collapsed": false,
        "name": "Places"
      },

## style.json
{
  "version": 8,
  "name": "Dark Matter",
  "metadata": {"maputnik:renderer": "mbgljs"},
  "sources": {
    "carto": {
      "type": "vector",
      "url": "https://tiles.basemaps.cartocdn.com/vector/carto.streets/v1/tiles.json"
    },
    "carto_data": {

## geo2bq.sh
#!/bin/bash

if [ -f "$1" ]; then
    for fullpath in "$1"
    do
        filename="${fullpath##*/}"                      # Strip longest match of */ from start
        dir="${fullpath:0:${#fullpath} - ${#filename}}" # Substring from 0 thru pos of filename
        base="${filename%.[^.]*}"                       # Strip shortest match of . plus at least one non-dot char from end
        ext="${filename:${#base} + 1}"                  # Substring from len of base thru end
        if [[ -z "$base" && -n "$ext" ]]; then          # If we have an extension and no base, it's really the base

## intersection_in_h3.sql
--We create some fake isochrones
with pois AS (

SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.9519882,40.262146],[-3.9358521,40.262146],[-3.9337921,40.2614594],[-3.9324188,40.2600861],[-3.9303589,40.2593994],[-3.9276123,40.2593994],[-3.9255524,40.2587128],[-3.9241791,40.2573395],[-3.9221191,40.2566528],[-3.9193726,40.2566528],[-3.9173126,40.2573395],[-3.9131927,40.2614594],[-3.9090729,40.2628326],[-3.9076996,40.2642059],[-3.9035797,40.2655792],[-3.8967133,40.2724457],[-3.8925934,40.273819],[-3.8912201,40.2751923],[-3.8871002,40.2765656],[-3.8857269,40.2779388],[-3.883667,40.2786255],[-3.8781738,40.2786255],[-3.8761139,40.2793121],[-3.8747406,40.2806854],[-3.8706207,40.2820587],[-3.8665009,40.2861786],[-3.862381,40.2875519],[-3.8610077,40.2916718],[-3.8568878,40.2957916],[-3.8562012,40.2978516],[-3.8562012,40.3033447],[-3.8568878,40.3054047],[-3.8610077,40.306778],[-3.8637543,40.3095245],[-3.8651276,40.3136444],[-3.8665009,40.3150177],[-3.8678741,40.3191376],[-3.8692474,40.3205109],[-

## gist:5fef10d812aa3fca64f742f6e4ec95cd
CREATE TEMP FUNCTION calculate_mapbox_price(num_tiles INT64, max_zoom INT64, min_zoom INT64)
    RETURNS FLOAT64
    DETERMINISTIC
    LANGUAGE js
AS """


var sku;


## index.html

<!DOCTYPE html>
<html>
<head>
  <meta charset='utf-8' />
  <title>team-ricky.suk_sandbox.openaq_wildfire | CARTO BigQuery Tiler</title>
  <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
  <script src='https://storage.googleapis.com/bqtilerjslibs/mbgl1.12.0.js'></script>
  <link href='https://storage.googleapis.com/bqtilerjslibs/mbgl1.12.0.css' rel='stylesheet' />
  <link href="https://fonts.googleapis.com/css2?family=Open+Sans&display=swap" rel="stylesheet">

## gist:91e28bf2c6470823508d4a7ca19554b0

<!DOCTYPE html>
<html>
<head>
  <meta charset='utf-8' />
  <title>cartobq.maps.ookla2 | CARTO BigQuery Tiler</title>
  <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
  <script src='https://storage.googleapis.com/bqtilerjslibs/mbgl1.12.0.js'></script>
  <link href='https://storage.googleapis.com/bqtilerjslibs/mbgl1.12.0.css' rel='stylesheet' />
  <link href="https://fonts.googleapis.com/css2?family=Open+Sans&display=swap" rel="stylesheet">

## positron (2).json
{
  "version": 8,
  "name": "Positron",
  "metadata": {"maputnik:renderer": "mbgljs"},
  "sources": {
    "carto": {
      "type": "vector",
      "url": "https://tiles.basemaps.cartocdn.com/vector/carto.streets/v1/tiles.json"
    }
  },

## positron-modified.json
{
  "version": 8,
  "name": "Positron",
  "metadata": {"maputnik:renderer": "mbgljs"},
  "sources": {
    "carto": {
      "type": "vector",
      "url": "https://tiles.basemaps.cartocdn.com/vector/carto.streets/v1/tiles.json"
    }
  },

## gist:ded44ab09480ae1ec5ac5fb05ee66700
CALL cartobq.tiler.ST_PointAggregationAsMVT(
--SQL to use as the source (use geom as name for geography)
'''(SELECT ST_Centroid(geometry) as geom
FROM `bigquery-public-data.geo_openstreetmap.planet_layers`
where  layer_name ='building')''',

--Name and location where the Tileset will be stored. Replace:
'`cartobq.maps.osm_buildings_weekly`',

--Options on how to generate the Tileset
	{
	"version": 8,
	"name": "Dark Matter",
	"metadata": {
	"mapbox:autocomposite": false,
	"mapbox:groups": {
	"101da9f13b64a08fa4b6ac1168e89e5f": {
	"collapsed": false,
	"name": "Places"
	},
	{
	"version": 8,
	"name": "Dark Matter",
	"metadata": {"maputnik:renderer": "mbgljs"},
	"sources": {
	"carto": {
	"type": "vector",
	"url": "https://tiles.basemaps.cartocdn.com/vector/carto.streets/v1/tiles.json"
	},
	"carto_data": {
	#!/bin/bash

	if [ -f "$1" ]; then
	for fullpath in "$1"
	do
	filename="${fullpath##/}" # Strip longest match of / from start
	dir="${fullpath:0:${#fullpath} - ${#filename}}" # Substring from 0 thru pos of filename
	base="${filename%.[^.]*}" # Strip shortest match of . plus at least one non-dot char from end
	ext="${filename:${#base} + 1}" # Substring from len of base thru end
	if [[ -z "$base" && -n "$ext" ]]; then # If we have an extension and no base, it's really the base
	--We create some fake isochrones
	with pois AS (

	SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.9519882,40.262146],[-3.9358521,40.262146],[-3.9337921,40.2614594],[-3.9324188,40.2600861],[-3.9303589,40.2593994],[-3.9276123,40.2593994],[-3.9255524,40.2587128],[-3.9241791,40.2573395],[-3.9221191,40.2566528],[-3.9193726,40.2566528],[-3.9173126,40.2573395],[-3.9131927,40.2614594],[-3.9090729,40.2628326],[-3.9076996,40.2642059],[-3.9035797,40.2655792],[-3.8967133,40.2724457],[-3.8925934,40.273819],[-3.8912201,40.2751923],[-3.8871002,40.2765656],[-3.8857269,40.2779388],[-3.883667,40.2786255],[-3.8781738,40.2786255],[-3.8761139,40.2793121],[-3.8747406,40.2806854],[-3.8706207,40.2820587],[-3.8665009,40.2861786],[-3.862381,40.2875519],[-3.8610077,40.2916718],[-3.8568878,40.2957916],[-3.8562012,40.2978516],[-3.8562012,40.3033447],[-3.8568878,40.3054047],[-3.8610077,40.306778],[-3.8637543,40.3095245],[-3.8651276,40.3136444],[-3.8665009,40.3150177],[-3.8678741,40.3191376],[-3.8692474,40.3205109],[-
	CREATE TEMP FUNCTION calculate_mapbox_price(num_tiles INT64, max_zoom INT64, min_zoom INT64)
	RETURNS FLOAT64
	DETERMINISTIC
	LANGUAGE js
	AS """


	var sku;

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset='utf-8' />
	<title>team-ricky.suk_sandbox.openaq_wildfire \| CARTO BigQuery Tiler</title>
	<meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' />
	<script src='https://storage.googleapis.com/bqtilerjslibs/mbgl1.12.0.js'></script>
	<link href='https://storage.googleapis.com/bqtilerjslibs/mbgl1.12.0.css' rel='stylesheet' />
	<link href="https://fonts.googleapis.com/css2?family=Open+Sans&display=swap" rel="stylesheet">
	{
	"version": 8,
	"name": "Positron",
	"metadata": {"maputnik:renderer": "mbgljs"},
	"sources": {
	"carto": {
	"type": "vector",
	"url": "https://tiles.basemaps.cartocdn.com/vector/carto.streets/v1/tiles.json"
	}
	},
	CALL cartobq.tiler.ST_PointAggregationAsMVT(
	--SQL to use as the source (use geom as name for geography)
	'''(SELECT ST_Centroid(geometry) as geom
	FROM `bigquery-public-data.geo_openstreetmap.planet_layers`
	where layer_name ='building')''',

	--Name and location where the Tileset will be stored. Replace:
	'`cartobq.maps.osm_buildings_weekly`',

	--Options on how to generate the Tileset