Skip to content

Instantly share code, notes, and snippets.

@volkanunsal

volkanunsal/request.json

Created March 29, 2019 17:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save volkanunsal/5c8ebc91efb57b8785aec9442a1b8b24 to your computer and use it in GitHub Desktop.
Save volkanunsal/5c8ebc91efb57b8785aec9442a1b8b24 to your computer and use it in GitHub Desktop.
Download ZIP
Carto response missing `metadata.layers[0].tilejson.raster`
Raw
request.json
{
"analyses": [
{
"id": "hoboken_parcels_2018",
"type": "source",
"params": {
"query": "SELECT cartodb_id, the_geom, the_geom_webmercator FROM hoboken_parcels_2018"
}
},
{
"id": "nyc_parcels-analysis",
"type": "source",
"params": {
"query": "SELECT cartodb_id, unitsres, numbldgs, bldgarea, the_geom, the_geom_webmercator FROM nyc_parcels"
}
},
{
"id": "building-permit-analysis",
"type": "source",
"params": {
"query": "SELECT cartodb_id, proposed_dwelling_units, proposed_zoning_sqft, the_geom, the_geom_webmercator FROM dob_job_application_filings_merge"
}
},
{
"id": "employment-analysis",
"type": "source",
"params": {
"query": "SELECT *, ACS_14_5YR_DP03_HC01_VC85 as median_income FROM acs_14_5yr_dp03"
}
}
],
"layers": [
{
"id": "hoboken_parcels_2018-layer",
"type": "cartodb",
"cartocss": "#layer0 {polygon-opacity:0.4; polygon-fill: #FFB927; [zoom > 14] {line-width: 0.6; line-color: white;} [zoom > 18] {polygon-opacity: 0;}}",
"options": {
"source": {
"id": "hoboken_parcels_2018"
}
}
},
{
"id": "nyc_parcels-analysis-layer",
"type": "cartodb",
"cartocss": "#layer0 {polygon-opacity:0.4; polygon-fill: #FFB927; [zoom > 14] {line-width: 0.6; line-color: white;} [zoom > 18] {polygon-opacity: 0;}}",
"options": {
"source": {
"id": "nyc_parcels-analysis"
}
}
}
],
"dataviews": {
"c-0": {
"type": "formula",
"source": {
"id": "hoboken_parcels_2018"
},
"options": {
"column": "cartodb_id",
"operation": "count"
}
},
"c-1": {
"type": "formula",
"source": {
"id": "nyc_parcels-analysis"
},
"options": {
"column": "cartodb_id",
"operation": "count"
}
},
"c-2": {
"type": "formula",
"source": {
"id": "building-permit-analysis"
},
"options": {
"column": "cartodb_id",
"operation": "count"
}
},
"c-3": {
"type": "formula",
"source": {
"id": "building-permit-analysis"
},
"options": {
"column": "proposed_dwelling_units",
"operation": "avg"
}
},
"c-4": {
"type": "formula",
"source": {
"id": "employment-analysis"
},
"options": {
"column": "median_income",
"operation": "avg"
}
},
"c-5": {
"type": "formula",
"source": {
"id": "nyc_parcels-analysis"
},
"options": {
"column": "unitsres",
"operation": "sum"
}
},
"c-6": {
"type": "formula",
"source": {
"id": "nyc_parcels-analysis"
},
"options": {
"column": "numbldgs",
"operation": "sum"
}
},
"c-7": {
"type": "formula",
"source": {
"id": "nyc_parcels-analysis"
},
"options": {
"column": "bldgarea",
"operation": "avg"
}
}
}
}
Raw
response.json
{
"layergroupid": "d4c80a36bbcf4f083956912f75b3e77c:1553546039119",
"metadata": {
"layers": [
{
"type": "mapnik",
"id": "hoboken_parcels_2018-layer",
"meta": {
"stats": {
"estimatedFeatureCount": 18728
},
"aggregation": {
"png": false,
"mvt": false
}
},
"tilejson": {
"vector": {
"tilejson": "2.2.0",
"tiles": [
"https://cartocdn-gusc-a.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/hoboken_parcels_2018-layer/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-b.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/hoboken_parcels_2018-layer/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/hoboken_parcels_2018-layer/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-d.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/hoboken_parcels_2018-layer/{z}/{x}/{y}.mvt"
]
}
}
},
{
"type": "mapnik",
"id": "nyc_parcels-analysis-layer",
"meta": {
"stats": {
"estimatedFeatureCount": 857284
},
"aggregation": {
"png": false,
"mvt": false
}
},
"tilejson": {
"vector": {
"tilejson": "2.2.0",
"tiles": [
"https://cartocdn-gusc-a.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/nyc_parcels-analysis-layer/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-b.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/nyc_parcels-analysis-layer/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/nyc_parcels-analysis-layer/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-d.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/nyc_parcels-analysis-layer/{z}/{x}/{y}.mvt"
]
}
}
}
],
"dataviews": {
"c-0": {
"url": {
"http": "http://2.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-0",
"https": "https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-0"
}
},
"c-1": {
"url": {
"http": "http://0.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-1",
"https": "https://cartocdn-gusc-a.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-1"
}
},
"c-2": {
"url": {
"http": "http://2.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-2",
"https": "https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-2"
}
},
"c-3": {
"url": {
"http": "http://0.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-3",
"https": "https://cartocdn-gusc-a.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-3"
}
},
"c-4": {
"url": {
"http": "http://3.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-4",
"https": "https://cartocdn-gusc-d.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-4"
}
},
"c-5": {
"url": {
"http": "http://1.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-5",
"https": "https://cartocdn-gusc-b.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-5"
}
},
"c-6": {
"url": {
"http": "http://3.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-6",
"https": "https://cartocdn-gusc-d.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-6"
}
},
"c-7": {
"url": {
"http": "http://1.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-7",
"https": "https://cartocdn-gusc-b.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/dataview/c-7"
}
}
},
"analyses": [
{
"nodes": {
"hoboken_parcels_2018": {
"status": "ready",
"url": {
"http": "http://1.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/7f5b3343334e0b6922d9640f84ed58a6e1091b61",
"https": "https://cartocdn-gusc-b.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/7f5b3343334e0b6922d9640f84ed58a6e1091b61"
},
"query": "SELECT cartodb_id, the_geom, the_geom_webmercator FROM hoboken_parcels_2018"
}
}
},
{
"nodes": {
"nyc_parcels-analysis": {
"status": "ready",
"url": {
"http": "http://2.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/a352230b090b28b7bb86d25d000501ba27cec2a1",
"https": "https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/a352230b090b28b7bb86d25d000501ba27cec2a1"
},
"query": "SELECT cartodb_id, unitsres, numbldgs, bldgarea, the_geom, the_geom_webmercator FROM nyc_parcels"
}
}
},
{
"nodes": {
"building-permit-analysis": {
"status": "ready",
"url": {
"http": "http://2.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/50a5e36e8cd033b49be6814d246e3f7a35e47879",
"https": "https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/50a5e36e8cd033b49be6814d246e3f7a35e47879"
},
"query": "SELECT cartodb_id, proposed_dwelling_units, proposed_zoning_sqft, the_geom, the_geom_webmercator FROM dob_job_application_filings_merge"
}
}
},
{
"nodes": {
"employment-analysis": {
"status": "ready",
"url": {
"http": "http://0.gusc.cartocdn.com/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/2ac0b68f5507aee252e2736235683023d893bb0b",
"https": "https://cartocdn-gusc-a.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/analysis/node/2ac0b68f5507aee252e2736235683023d893bb0b"
},
"query": "SELECT *, ACS_14_5YR_DP03_HC01_VC85 as median_income FROM acs_14_5yr_dp03"
}
}
}
],
"tilejson": {
"vector": {
"tilejson": "2.2.0",
"tiles": [
"https://cartocdn-gusc-a.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-b.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-c.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/{z}/{x}/{y}.mvt",
"https://cartocdn-gusc-d.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/{z}/{x}/{y}.mvt"
]
}
},
"url": {
"vector": {
"urlTemplate": "https://cartocdn-gusc-{s}.global.ssl.fastly.net/swc28/api/v1/map/d4c80a36bbcf4f083956912f75b3e77c:1553546039119/{z}/{x}/{y}.mvt",
"subdomains": [
"a",
"b",
"c",
"d"
]
}
}
},
"cdn_url": {
"templates": {
"http": {
"subdomains": [
"0",
"1",
"2",
"3"
],
"url": "http://{s}.gusc.cartocdn.com"
},
"https": {
"subdomains": [
"a",
"b",
"c",
"d"
],
"url": "https://cartocdn-gusc-{s}.global.ssl.fastly.net"
}
},
"http": "gusc.cartocdn.com",
"https": "cartocdn-gusc.global.ssl.fastly.net"
},
"last_updated": "2019-03-25T20:33:59.119Z"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment