SXSW SQL

sxsw_sql_iso.sql

WITH iso_walk AS (
  SELECT
    name,
    cdb_isochrone(
      the_geom,
      ‘walk’,
      Array[120,300,600,900,1200,1800]
    ) isochrone
  FROM nerikcarto.sxsw_venues
)

INSERT INTO
nerikcarto.sxsw_iso
(type, name, the_geom, data_range, the_geom_webmercator)
  SELECT
    ‘walk’ as type,
    iso_walk.name,
    (iso_walk.isochrone).the_geom,
    (iso_walk.isochrone).data_range,
    ST_Transform(
      (iso_walk.isochrone).the_geom,
      3857
    ) as the_geom_webmercator
  FROM iso_walk