payload.json

{
  "layers": [
    {
      "options": {
        "cartocss": "#nyc_parcels {polygon-opacity:0.6; polygon-fill: #FFB927; [zoom > 14] {line-width: 0.6; line-color: white;}}",
        "cartocss_version": "2.1.1",
        "interactivity": "cartodb_id,borough,lotarea,landuse_name,yearbuilt,the_geom,ownername,lotarea,lotfront,lotdepth,assesstot,assessland,numbldgs,yearbuilt,bldgarea,numfloors,landuse,block,lot,bbl,unitstotal,condono,unitsres,easements,resarea,comarea,officearea,factryarea,otherarea,builtfar,residfar,commfar,zonedist1,borough,address",
        "sql": "SELECT\n        source.* FROM (SELECT * FROM nyc_parcels) source,\n        (SELECT ST_GeomFromGeoJSON('{\"type\":\"MultiPolygon\",\"coordinates\":[[[[-73.9793586730957,40.7153870771602],[-74.0231323242188,40.6965181180946],[-74.0301704406738,40.7174688416884],[-73.9793586730957,40.7153870771602]]]]}') the_geom) target\n      WHERE\n        ST_Intersects(ST_SetSRID(source.the_geom, 4326),\n        ST_SetSRID(target.the_geom, 4326))",
        "layerIndex": 0
      },
      "id": "1",
      "type": "cartodb",
      "visible": true
    },
    {
      "options": {
        "cartocss": "#layer {polygon-opacity: 0;polygon-fill: #43618F;line-color: #FFF;line-width: 1;line-opacity: 1; [total_population > 0][total_population < 1000]{polygon-opacity: 0.3;}[total_population > 1000][total_population <= 2000]{polygon-opacity: 0.5;}[total_population > 2000][total_population <= 3000]{polygon-opacity: 0.6;}[total_population > 3000]{polygon-opacity: 0.8;}}",
        "cartocss_version": "2.1.1",
        "interactivity": "cartodb_id,total_population,under_5_years,_5_to_9_years,_10_to_14_years,_15_to_19_years,_20_to_24_years,_25_to_34_years,_35_to_44_years,_45_to_54_years,_55_to_59_years,_60_to_64_years,_65_to_74_years,_75_to_84_years,_85_years_and_over,total_population",
        "sql": "SELECT\n        source.* FROM (SELECT *, ACS_14_5YR_DP05_HC01_VC03 as total_population, ACS_14_5YR_DP05_HC01_VC08 as under_5_years, ACS_14_5YR_DP05_HC01_VC09 as _5_to_9_years, ACS_14_5YR_DP05_HC01_VC10 as _10_to_14_years, ACS_14_5YR_DP05_HC01_VC11 as _15_to_19_years, ACS_14_5YR_DP05_HC01_VC12 as _20_to_24_years, ACS_14_5YR_DP05_HC01_VC13 as _25_to_34_years, ACS_14_5YR_DP05_HC01_VC14 as _35_to_44_years, ACS_14_5YR_DP05_HC01_VC15 as _45_to_54_years, ACS_14_5YR_DP05_HC01_VC16 as _55_to_59_years, ACS_14_5YR_DP05_HC01_VC17 as _60_to_64_years, ACS_14_5YR_DP05_HC01_VC18 as _65_to_74_years, ACS_14_5YR_DP05_HC01_VC19 as _75_to_84_years, ACS_14_5YR_DP05_HC01_VC20 as _85_years_and_over FROM acs_14_5yr_dp05) source,\n        (SELECT ST_GeomFromGeoJSON('{\"type\":\"MultiPolygon\",\"coordinates\":[[[[-73.9793586730957,40.7153870771602],[-74.0231323242188,40.6965181180946],[-74.0301704406738,40.7174688416884],[-73.9793586730957,40.7153870771602]]]]}') the_geom) target\n      WHERE\n        ST_Intersects(ST_SetSRID(source.the_geom, 4326),\n        ST_SetSRID(target.the_geom, 4326))",
        "layerIndex": 1
      },
      "id": "7",
      "type": "cartodb",
      "visible": false
    },
    {
      "options": {
        "cartocss": "#dob_job_application_filings_merge {marker-fill-opacity: 0.25;marker-line-color: #081B47;marker-line-width: 0.2;marker-line-opacity: 0.3;marker-placement: point;marker-type: ellipse;marker-width: 10;marker-allow-overlap: true;marker-fill: #5197c9; [zoom > 16] {marker-width: 10;marker-line-width: 0;marker-fill-opacity: 0.5;}}",
        "cartocss_version": "2.1.1",
        "interactivity": "cartodb_id,fee_width,center,job_status,job_type",
        "sql": "SELECT\n        source.* FROM (SELECT proposed_dwelling_units,proposed_zoning_sqft,cartodb_id,the_geom,the_geom_webmercator,GREATEST(4,POWER(LOG(total_est_fee_duplicate), 2)) fee_width,st_asgeojson(st_centroid(the_geom)) as center,job_status,job_type,total_est_fee_duplicate FROM dob_job_application_filings_merge) source,\n        (SELECT ST_GeomFromGeoJSON('{\"type\":\"MultiPolygon\",\"coordinates\":[[[[-73.9793586730957,40.7153870771602],[-74.0231323242188,40.6965181180946],[-74.0301704406738,40.7174688416884],[-73.9793586730957,40.7153870771602]]]]}') the_geom) target\n      WHERE\n        ST_Intersects(ST_SetSRID(source.the_geom, 4326),\n        ST_SetSRID(target.the_geom, 4326))",
        "layerIndex": 2
      },
      "id": "8",
      "type": "cartodb",
      "visible": false
    },
    {
      "options": {
        "cartocss": "#acs_14_5yr_dp03 {polygon-opacity: 0;polygon-fill: #43618F;line-color: #FFF;line-width: 1;line-opacity: 1;  [median_income > 0][median_income < 9000]{polygon-opacity: 0.3;}[median_income > 9000][median_income <= 55000]{polygon-opacity: 0.5;}[median_income > 55000][median_income <= 100000]{polygon-opacity: 0.6;}[median_income > 100000]{polygon-opacity: 0.8;}}",
        "cartocss_version": "2.1.1",
        "interactivity": "cartodb_id,median_income,employed,workers_commuting_to_work,workers_commute_to_work_by_walking,average_travel_time_to_commute_to_work",
        "sql": "SELECT\n        source.* FROM (SELECT *, ACS_14_5YR_DP03_HC01_VC85 as median_income,ACS_14_5YR_DP03_HC01_VC03 as employed,ACS_14_5YR_DP03_HC01_VC27 as workers_commuting_to_work,ACS_14_5YR_DP03_HC01_VC31 as workers_commute_to_work_by_walking,ACS_14_5YR_DP03_HC01_VC36 as average_travel_time_to_commute_to_work FROM acs_14_5yr_dp03) source,\n        (SELECT ST_GeomFromGeoJSON('{\"type\":\"MultiPolygon\",\"coordinates\":[[[[-73.9793586730957,40.7153870771602],[-74.0231323242188,40.6965181180946],[-74.0301704406738,40.7174688416884],[-73.9793586730957,40.7153870771602]]]]}') the_geom) target\n      WHERE\n        ST_Intersects(ST_SetSRID(source.the_geom, 4326),\n        ST_SetSRID(target.the_geom, 4326))",
        "layerIndex": 3
      },
      "id": "9",
      "type": "cartodb",
      "visible": false
    },
    {
      "options": {
        "cartocss": "#layer {marker-opacity:0.2;marker-fill: #FF0000;}",
        "cartocss_version": "2.1.1",
        "interactivity": "cartodb_id,the_geom,status",
        "sql": "SELECT\n        source.* FROM (SELECT * FROM projects_production) source,\n        (SELECT ST_GeomFromGeoJSON('{\"type\":\"MultiPolygon\",\"coordinates\":[[[[-73.9793586730957,40.7153870771602],[-74.0231323242188,40.6965181180946],[-74.0301704406738,40.7174688416884],[-73.9793586730957,40.7153870771602]]]]}') the_geom) target\n      WHERE\n        ST_Intersects(ST_SetSRID(source.the_geom, 4326),\n        ST_SetSRID(target.the_geom, 4326))",
        "layerIndex": 4
      },
      "id": "5",
      "type": "cartodb",
      "visible": false
    },
    {
      "options": {
        "cartocss": "#layer {polygon-opacity:0.2; polygon-fill: #FF0000;}",
        "cartocss_version": "2.1.1",
        "interactivity": "cartodb_id,the_geom,bid_name",
        "sql": "SELECT\n        source.* FROM (select * from bid) source,\n        (SELECT ST_GeomFromGeoJSON('{\"type\":\"MultiPolygon\",\"coordinates\":[[[[-73.9793586730957,40.7153870771602],[-74.0231323242188,40.6965181180946],[-74.0301704406738,40.7174688416884],[-73.9793586730957,40.7153870771602]]]]}') the_geom) target\n      WHERE\n        ST_Intersects(ST_SetSRID(source.the_geom, 4326),\n        ST_SetSRID(target.the_geom, 4326))",
        "layerIndex": 5
      },
      "id": "199",
      "type": "cartodb",
      "visible": false
    }
  ]
}