Import flow

[knutole]

csv

1. Upload

POST to /v2/data/import/chunked returns { "file_id": "file_dmbzzoaofdwasalhbzpz" }

1.1 Get file object

GET @ https://dev.systemapic.com/v2/data/import?fileUuid=file_dmbzzoaofdwasalhbzpz&access_token=pk.P5Mv...fvCFCW71IGFzdU

Returns:

{
  "file": {
    "_id": "575ea1bbca4e0f5715323f3b",
    "lastUpdated": "2016-06-13T12:06:19.390Z",
    "created": "2016-06-13T12:06:19.388Z",
    "type": "postgis",
    "dataSize": "2775",
    "originalName": "FB_fet_vann_des15.xlsx - Sheet1 (2).csv",
    "name": "FB_fet_vann_des15.xlsx - Sheet1 (2)",
    "createdBy": "user-61d3ee1e-da43-430d-af4a-41a09315661d",
    "uuid": "file_dmbzzoaofdwasalhbzpz",
    "__v": 0,
    "access": {
      "clients": [],
      "projects": [],
      "users": []
    },
    "data": {
      "image": {
        "crunched": []
      },
      "postgis": {
        "database_name": "jusbvxawxw",
        "table_name": "file_dmbzzoaofdwasalhbzpz",
        "data_type": "vector",
        "original_format": "csv",
        "metadata": "{\"extent\":[\"11.2428390463193\",\"59.8826226974976\",\"11.2486811937403\",\"59.8864235789197\"],\"columns\":{\"gid\":{\"max\":4,\"min\":1,\"avg\":2.5},\"type\":{\"min\":0,\"max\":0},\"arsen\":{\"max\":0.23,\"min\":0,\"avg\":0.0575},\"bly\":{\"max\":1,\"min\":0,\"avg\":0.2675},\"kadmium\":{\"max\":0.0088,\"min\":0,\"avg\":0.0022},\"kobber\":{\"max\":5.8,\"min\":1,\"avg\":2.45},\"krom\":{\"max\":0.32,\"min\":0,\"avg\":0.08},\"mercury\":{\"max\":0.0005,\"min\":0.0005,\"avg\":0.0005},\"nikkel\":{\"max\":1,\"min\":0,\"avg\":0.46},\"acenaften\":{\"min\":0,\"max\":0},\"acenaftyle\":{\"min\":0,\"max\":0},\"antracen\":{\"min\":0,\"max\":0},\"benzo[a]an\":{\"min\":0,\"max\":0},\"benzo[a]py\":{\"min\":0,\"max\":0},\"benzo[b]fl\":{\"min\":0,\"max\":0},\"benzo[ghi]\":{\"min\":0,\"max\":0},\"benzo[k]fl\":{\"min\":0,\"max\":0},\"dibenzo[a,\":{\"min\":0,\"max\":0},\"fenantren\":{\"min\":0,\"max\":0},\"fluoranten\":{\"min\":0,\"max\":0},\"fluoren\":{\"min\":0,\"max\":0},\"indeno[1,2\":{\"min\":0,\"max\":0},\"krysen/tri\":{\"min\":0,\"max\":0},\"naftalen\":{\"min\":0,\"max\":0},\"pyren\":{\"min\":0,\"max\":0},\"sum pah 16\":{\"min\":0,\"max\":0},\"sink\":{\"max\":3000,\"min\":18,\"avg\":956},\"sum_thc_c5\":{\"min\":0,\"max\":0},\"thc_c5-c8\":{\"min\":0,\"max\":0},\"thc_c10_c1\":{\"min\":0,\"max\":0},\"thc_c12_c1\":{\"min\":0,\"max\":0},\"thc_c16_c3\":{\"min\":0,\"max\":0},\"thc_c8_c10\":{\"min\":0,\"max\":0},\"ammonium\":{\"max\":0.24,\"min\":0.15,\"avg\":0.1925},\"nitrat\":{\"max\":3000,\"min\":18,\"avg\":956},\"tota-_nitr\":{\"min\":0,\"max\":0},\"benzen\":{\"min\":0,\"max\":0},\"etylbenzen\":{\"min\":0,\"max\":0},\"m_p_xylen\":{\"min\":0,\"max\":0},\"o_xylen\":{\"min\":0,\"max\":0},\"toluen\":{\"min\":0,\"max\":0},\"xylener_su\":{\"min\":0,\"max\":0},\"_columns\":[\"gid\",\"type\",\"arsen\",\"bly\",\"kadmium\",\"kobber\",\"krom\",\"mercury\",\"nikkel\",\"acenaften\",\"acenaftyle\",\"antracen\",\"benzo[a]an\",\"benzo[a]py\",\"benzo[b]fl\",\"benzo[ghi]\",\"benzo[k]fl\",\"dibenzo[a,\",\"fenantren\",\"fluoranten\",\"fluoren\",\"indeno[1,2\",\"krysen/tri\",\"naftalen\",\"pyren\",\"sum pah 16\",\"sink\",\"sum_thc_c5\",\"thc_c5-c8\",\"thc_c10_c1\",\"thc_c12_c1\",\"thc_c16_c3\",\"thc_c8_c10\",\"ammonium\",\"nitrat\",\"tota-_nitr\",\"benzen\",\"etylbenzen\",\"m_p_xylen\",\"o_xylen\",\"toluen\",\"xylener_su\"]},\"extent_geojson\":{\"type\":\"Polygon\",\"coordinates\":[[[11.2428390463193,59.8826226974976],[11.2428390463193,59.8864235789197],[11.2486811937403,59.8864235789197],[11.2486811937403,59.8826226974976],[11.2428390463193,59.8826226974976]]]},\"total_area\":138064.4293375557,\"row_count\":\"4\",\"size_bytes\":\"16 kB\",\"geometry_type\":\"ST_Point\"}"
      }
    },
    "styleTemplates": [],
    "format": [],
    "keywords": [],
    "files": []
  },
  "layer": null
}

1.2 Get CartoCSS from style JSON:

POST @ /v2/layers/carto/json
Payload:

{
  "style": {
    "point": {
      "enabled": true,
      "color": {
        "column": false,
        "range": [
          -426.6,
          105.9
        ],
        "staticVal": "yellow",
        "value": [
          "#ff0000",
          "#ffff00",
          "#00ff00",
          "#00ffff",
          "#0000ff"
        ]
      },
      "opacity": {
        "column": false,
        "range": [
          -426.6,
          105.9
        ],
        "value": 0.5
      },
      "pointsize": {
        "column": false,
        "range": [
          0,
          10
        ],
        "value": 1
      }
    },
    "polygon": {
      "enabled": false,
      "color": {
        "column": false,
        "range": [
          -426.6,
          105.9
        ],
        "staticVal": "red",
        "value": [
          "#ff0000",
          "#ffff00",
          "#00ff00",
          "#00ffff",
          "#0000ff"
        ]
      },
      "opacity": {
        "column": false,
        "range": [
          -426.6,
          105.9
        ],
        "value": 0.5
      },
      "line": {
        "width": {
          "column": false,
          "range": false,
          "value": 1
        },
        "opacity": {
          "column": false,
          "range": [
            -426.6,
            105.9
          ],
          "value": 0.5
        },
        "color": {
          "column": false,
          "range": [
            -426.6,
            105.9
          ],
          "staticVal": "green",
          "value": [
            "#ff0000",
            "#ffff00",
            "#00ff00",
            "#00ffff",
            "#0000ff"
          ]
        }
      }
    },
    "line": {
      "enabled": false,
      "width": {
        "column": false,
        "range": false,
        "value": 1
      },
      "opacity": {
        "column": false,
        "value": 0.5
      },
      "color": {
        "column": false,
        "range": [
          -426.6,
          105.9
        ],
        "staticVal": "green",
        "value": [
          "#ff0000",
          "#ffff00",
          "#00ff00",
          "#00ffff",
          "#0000ff"
        ]
      }
    }
  },
  "access_token": "pk.P5M...ZIpU1fvCFCW71IGFzdU"
}

Returns:

@point_opacity: 1;
@marker_size_factor: 5;
[zoom<10] { marker-width: 0.2 * @marker_size_factor; }
[zoom=10] { marker-width: 0.3 * @marker_size_factor; }
[zoom=11] { marker-width: 0.5 * @marker_size_factor; }
[zoom=12] { marker-width: 1   * @marker_size_factor; }
[zoom=13] { marker-width: 1   * @marker_size_factor; }
[zoom=14] { marker-width: 2   * @marker_size_factor; }
[zoom=15] { marker-width: 4   * @marker_size_factor; }
[zoom=16] { marker-width: 6   * @marker_size_factor; }
[zoom=17] { marker-width: 8   * @marker_size_factor; }
[zoom>=18] { marker-width: 12  * @marker_size_factor; }

#layer {
    marker-allow-overlap: true;
    marker-clip: false;
    marker-comp-op: screen;
    marker-opacity: @point_opacity;
    marker-fill: yellow;
}

2. Create layers

Code: model.file.js#L621

2.1 Create tile layer

Code: model.file.js#L665
POST @ /v2/tiles/create:

{
  "geom_column": "the_geom_3857",
  "geom_type": "geometry",
  "raster_band": "",
  "srid": "",
  "affected_tables": "",
  "interactivity": "",
  "attributes": "",
  "access_token": "pk.SdoBgqc5Qh8f9mVx7v4r7NKUmYqDZMb9LM7qmhES",
  "cartocss_version": "2.0.1",
  "cartocss": "@point_opacity: 1;\n@marker_size_factor: 5;\n[zoom<10] { marker-width: 0.2 * @marker_size_factor; }\n[zoom=10] { marker-width: 0.3 * @marker_size_factor; }\n[zoom=11] { marker-width: 0.5 * @marker_size_factor; }\n[zoom=12] { marker-width: 1   * @marker_size_factor; }\n[zoom=13] { marker-width: 1   * @marker_size_factor; }\n[zoom=14] { marker-width: 2   * @marker_size_factor; }\n[zoom=15] { marker-width: 4   * @marker_size_factor; }\n[zoom=16] { marker-width: 6   * @marker_size_factor; }\n[zoom=17] { marker-width: 8   * @marker_size_factor; }\n[zoom>=18] { marker-width: 12  * @marker_size_factor; }\n\n#layer {\n\n\tmarker-allow-overlap: true;\n\tmarker-clip: false;\n\tmarker-comp-op: screen;\n\n\tmarker-opacity: @point_opacity;\n\n\tmarker-fill: yellow;\n\n}",
  "sql": "(SELECT * FROM file_ubevgeekwaybeghjtlcq) as sub",
  "file_id": "file_ubevgeekwaybeghjtlcq",
  "return_model": true,
  "projectUuid": "project-a348dbfe-d0c1-46b1-a871-db0d9154ec57"
}

Returns:

{
  "layerUuid": "layer_id-ca38d7a1-b3c1-4b91-b306-79f3b96f7687",
  "options": {
    "layer_id": "layer_id-ca38d7a1-b3c1-4b91-b306-79f3b96f7687",
    "sql": "(SELECT * FROM file_cvjjddbekifxaezcvqwq) as sub",
    "cartocss": "@point_opacity: 1;\n@marker_size_factor: 5;\n[zoom<10] { marker-width: 0.2 * @marker_size_factor; }\n[zoom=10] { marker-width: 0.3 * @marker_size_factor; }\n[zoom=11] { marker-width: 0.5 * @marker_size_factor; }\n[zoom=12] { marker-width: 1   * @marker_size_factor; }\n[zoom=13] { marker-width: 1   * @marker_size_factor; }\n[zoom=14] { marker-width: 2   * @marker_size_factor; }\n[zoom=15] { marker-width: 4   * @marker_size_factor; }\n[zoom=16] { marker-width: 6   * @marker_size_factor; }\n[zoom=17] { marker-width: 8   * @marker_size_factor; }\n[zoom>=18] { marker-width: 12  * @marker_size_factor; }\n\n#layer {\n\n\tmarker-allow-overlap: true;\n\tmarker-clip: false;\n\tmarker-comp-op: screen;\n\n\tmarker-opacity: @point_opacity;\n\n\tmarker-fill: yellow;\n\n}",
    "file_id": "file_cvjjddbekifxaezcvqwq",
    "database_name": "vutnqpexon",
    "table_name": "file_cvjjddbekifxaezcvqwq",
    "metadata": "{\"extent\":[\"11.2428390463193\",\"59.8826226974976\",\"11.2486811937403\",\"59.8864235789197\"],\"columns\":{\"gid\":{\"max\":4,\"min\":1,\"avg\":2.5},\"type\":{\"min\":0,\"max\":0},\"arsen\":{\"max\":0.23,\"min\":0,\"avg\":0.0575},\"bly\":{\"max\":1,\"min\":0,\"avg\":0.2675},\"kadmium\":{\"max\":0.0088,\"min\":0,\"avg\":0.0022},\"kobber\":{\"max\":5.8,\"min\":1,\"avg\":2.45},\"krom\":{\"max\":0.32,\"min\":0,\"avg\":0.08},\"mercury\":{\"max\":0.0005,\"min\":0.0005,\"avg\":0.0005},\"nikkel\":{\"max\":1,\"min\":0,\"avg\":0.46},\"acenaften\":{\"min\":0,\"max\":0},\"acenaftyle\":{\"min\":0,\"max\":0},\"antracen\":{\"min\":0,\"max\":0},\"benzo[a]an\":{\"min\":0,\"max\":0},\"benzo[a]py\":{\"min\":0,\"max\":0},\"benzo[b]fl\":{\"min\":0,\"max\":0},\"benzo[ghi]\":{\"min\":0,\"max\":0},\"benzo[k]fl\":{\"min\":0,\"max\":0},\"dibenzo[a,\":{\"min\":0,\"max\":0},\"fenantren\":{\"min\":0,\"max\":0},\"fluoranten\":{\"min\":0,\"max\":0},\"fluoren\":{\"min\":0,\"max\":0},\"indeno[1,2\":{\"min\":0,\"max\":0},\"krysen/tri\":{\"min\":0,\"max\":0},\"naftalen\":{\"min\":0,\"max\":0},\"pyren\":{\"min\":0,\"max\":0},\"sum pah 16\":{\"min\":0,\"max\":0},\"sink\":{\"max\":3000,\"min\":18,\"avg\":956},\"sum_thc_c5\":{\"min\":0,\"max\":0},\"thc_c5-c8\":{\"min\":0,\"max\":0},\"thc_c10_c1\":{\"min\":0,\"max\":0},\"thc_c12_c1\":{\"min\":0,\"max\":0},\"thc_c16_c3\":{\"min\":0,\"max\":0},\"thc_c8_c10\":{\"min\":0,\"max\":0},\"ammonium\":{\"max\":0.24,\"min\":0.15,\"avg\":0.1925},\"nitrat\":{\"max\":3000,\"min\":18,\"avg\":956},\"tota-_nitr\":{\"min\":0,\"max\":0},\"benzen\":{\"min\":0,\"max\":0},\"etylbenzen\":{\"min\":0,\"max\":0},\"m_p_xylen\":{\"min\":0,\"max\":0},\"o_xylen\":{\"min\":0,\"max\":0},\"toluen\":{\"min\":0,\"max\":0},\"xylener_su\":{\"min\":0,\"max\":0},\"_columns\":[\"gid\",\"type\",\"arsen\",\"bly\",\"kadmium\",\"kobber\",\"krom\",\"mercury\",\"nikkel\",\"acenaften\",\"acenaftyle\",\"antracen\",\"benzo[a]an\",\"benzo[a]py\",\"benzo[b]fl\",\"benzo[ghi]\",\"benzo[k]fl\",\"dibenzo[a,\",\"fenantren\",\"fluoranten\",\"fluoren\",\"indeno[1,2\",\"krysen/tri\",\"naftalen\",\"pyren\",\"sum pah 16\",\"sink\",\"sum_thc_c5\",\"thc_c5-c8\",\"thc_c10_c1\",\"thc_c12_c1\",\"thc_c16_c3\",\"thc_c8_c10\",\"ammonium\",\"nitrat\",\"tota-_nitr\",\"benzen\",\"etylbenzen\",\"m_p_xylen\",\"o_xylen\",\"toluen\",\"xylener_su\"]},\"extent_geojson\":{\"type\":\"Polygon\",\"coordinates\":[[[11.2428390463193,59.8826226974976],[11.2428390463193,59.8864235789197],[11.2486811937403,59.8864235789197],[11.2486811937403,59.8826226974976],[11.2428390463193,59.8826226974976]]]},\"total_area\":138064.4293375557,\"row_count\":\"4\",\"size_bytes\":\"16 kB\",\"geometry_type\":\"ST_Point\"}",
    "data_type": "vector",
    "geom_column": "the_geom_3857",
    "geom_type": "geometry",
    "raster_band": 0,
    "srid": 3857,
    "cartocss_version": "2.0.1"
  }
}

2.2 Create [wu] layer:

Code: model.file.js#L688

POST @ /v2/layers/create:

{
  "projectUuid": "project-a348dbfe-d0c1-46b1-a871-db0d9154ec57",
  "metadata": "{\"extent\":[\"11.2428390463193\",\"59.8826226974976\",\"11.2486811937403\",\"59.8864235789197\"],\"columns\":{\"gid\":{\"max\":4,\"min\":1,\"avg\":2.5},\"type\":{\"min\":0,\"max\":0},\"arsen\":{\"max\":0.23,\"min\":0,\"avg\":0.0575},\"bly\":{\"max\":1,\"min\":0,\"avg\":0.2675},\"kadmium\":{\"max\":0.0088,\"min\":0,\"avg\":0.0022},\"kobber\":{\"max\":5.8,\"min\":1,\"avg\":2.45},\"krom\":{\"max\":0.32,\"min\":0,\"avg\":0.08},\"mercury\":{\"max\":0.0005,\"min\":0.0005,\"avg\":0.0005},\"nikkel\":{\"max\":1,\"min\":0,\"avg\":0.46},\"acenaften\":{\"min\":0,\"max\":0},\"acenaftyle\":{\"min\":0,\"max\":0},\"antracen\":{\"min\":0,\"max\":0},\"benzo[a]an\":{\"min\":0,\"max\":0},\"benzo[a]py\":{\"min\":0,\"max\":0},\"benzo[b]fl\":{\"min\":0,\"max\":0},\"benzo[ghi]\":{\"min\":0,\"max\":0},\"benzo[k]fl\":{\"min\":0,\"max\":0},\"dibenzo[a,\":{\"min\":0,\"max\":0},\"fenantren\":{\"min\":0,\"max\":0},\"fluoranten\":{\"min\":0,\"max\":0},\"fluoren\":{\"min\":0,\"max\":0},\"indeno[1,2\":{\"min\":0,\"max\":0},\"krysen/tri\":{\"min\":0,\"max\":0},\"naftalen\":{\"min\":0,\"max\":0},\"pyren\":{\"min\":0,\"max\":0},\"sum pah 16\":{\"min\":0,\"max\":0},\"sink\":{\"max\":3000,\"min\":18,\"avg\":956},\"sum_thc_c5\":{\"min\":0,\"max\":0},\"thc_c5-c8\":{\"min\":0,\"max\":0},\"thc_c10_c1\":{\"min\":0,\"max\":0},\"thc_c12_c1\":{\"min\":0,\"max\":0},\"thc_c16_c3\":{\"min\":0,\"max\":0},\"thc_c8_c10\":{\"min\":0,\"max\":0},\"ammonium\":{\"max\":0.24,\"min\":0.15,\"avg\":0.1925},\"nitrat\":{\"max\":3000,\"min\":18,\"avg\":956},\"tota-_nitr\":{\"min\":0,\"max\":0},\"benzen\":{\"min\":0,\"max\":0},\"etylbenzen\":{\"min\":0,\"max\":0},\"m_p_xylen\":{\"min\":0,\"max\":0},\"o_xylen\":{\"min\":0,\"max\":0},\"toluen\":{\"min\":0,\"max\":0},\"xylener_su\":{\"min\":0,\"max\":0},\"_columns\":[\"gid\",\"type\",\"arsen\",\"bly\",\"kadmium\",\"kobber\",\"krom\",\"mercury\",\"nikkel\",\"acenaften\",\"acenaftyle\",\"antracen\",\"benzo[a]an\",\"benzo[a]py\",\"benzo[b]fl\",\"benzo[ghi]\",\"benzo[k]fl\",\"dibenzo[a,\",\"fenantren\",\"fluoranten\",\"fluoren\",\"indeno[1,2\",\"krysen/tri\",\"naftalen\",\"pyren\",\"sum pah 16\",\"sink\",\"sum_thc_c5\",\"thc_c5-c8\",\"thc_c10_c1\",\"thc_c12_c1\",\"thc_c16_c3\",\"thc_c8_c10\",\"ammonium\",\"nitrat\",\"tota-_nitr\",\"benzen\",\"etylbenzen\",\"m_p_xylen\",\"o_xylen\",\"toluen\",\"xylener_su\"]},\"extent_geojson\":{\"type\":\"Polygon\",\"coordinates\":[[[11.2428390463193,59.8826226974976],[11.2428390463193,59.8864235789197],[11.2486811937403,59.8864235789197],[11.2486811937403,59.8826226974976],[11.2428390463193,59.8826226974976]]]},\"total_area\":138064.4293375557,\"row_count\":\"4\",\"size_bytes\":\"16 kB\",\"geometry_type\":\"ST_Point\"}",
  "title": "FB_fet_vann_des15.xlsx - Sheet1 (2)",
  "description": "Description: Layer created from FB_fet_vann_des15.xlsx - Sheet1 (2)",
  "file": "file_ubevgeekwaybeghjtlcq",
  "style": "{\"point\":{\"enabled\":true,\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"yellow\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]},\"opacity\":{\"column\":false,\"range\":[-426.6,105.9],\"value\":0.5},\"pointsize\":{\"column\":false,\"range\":[0,10],\"value\":1}},\"polygon\":{\"enabled\":false,\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"red\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]},\"opacity\":{\"column\":false,\"range\":[-426.6,105.9],\"value\":0.5},\"line\":{\"width\":{\"column\":false,\"range\":false,\"value\":1},\"opacity\":{\"column\":false,\"range\":[-426.6,105.9],\"value\":0.5},\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"green\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]}}},\"line\":{\"enabled\":false,\"width\":{\"column\":false,\"range\":false,\"value\":1},\"opacity\":{\"column\":false,\"value\":0.5},\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"green\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]}}}",
  "data": {
    "postgis": {
      "layer_id": "layer_id-d65fc6b8-323c-4736-bacb-12e984b9c8d8",
      "sql": "(SELECT * FROM file_ubevgeekwaybeghjtlcq) as sub",
      "cartocss": "@point_opacity: 1;\n@marker_size_factor: 5;\n[zoom<10] { marker-width: 0.2 * @marker_size_factor; }\n[zoom=10] { marker-width: 0.3 * @marker_size_factor; }\n[zoom=11] { marker-width: 0.5 * @marker_size_factor; }\n[zoom=12] { marker-width: 1   * @marker_size_factor; }\n[zoom=13] { marker-width: 1   * @marker_size_factor; }\n[zoom=14] { marker-width: 2   * @marker_size_factor; }\n[zoom=15] { marker-width: 4   * @marker_size_factor; }\n[zoom=16] { marker-width: 6   * @marker_size_factor; }\n[zoom=17] { marker-width: 8   * @marker_size_factor; }\n[zoom>=18] { marker-width: 12  * @marker_size_factor; }\n\n#layer {\n\n\tmarker-allow-overlap: true;\n\tmarker-clip: false;\n\tmarker-comp-op: screen;\n\n\tmarker-opacity: @point_opacity;\n\n\tmarker-fill: yellow;\n\n}",
      "file_id": "file_ubevgeekwaybeghjtlcq",
      "database_name": "vutnqpexon",
      "table_name": "file_ubevgeekwaybeghjtlcq",
      "metadata": "{\"extent\":[\"11.2428390463193\",\"59.8826226974976\",\"11.2486811937403\",\"59.8864235789197\"],\"columns\":{\"gid\":{\"max\":4,\"min\":1,\"avg\":2.5},\"type\":{\"min\":0,\"max\":0},\"arsen\":{\"max\":0.23,\"min\":0,\"avg\":0.0575},\"bly\":{\"max\":1,\"min\":0,\"avg\":0.2675},\"kadmium\":{\"max\":0.0088,\"min\":0,\"avg\":0.0022},\"kobber\":{\"max\":5.8,\"min\":1,\"avg\":2.45},\"krom\":{\"max\":0.32,\"min\":0,\"avg\":0.08},\"mercury\":{\"max\":0.0005,\"min\":0.0005,\"avg\":0.0005},\"nikkel\":{\"max\":1,\"min\":0,\"avg\":0.46},\"acenaften\":{\"min\":0,\"max\":0},\"acenaftyle\":{\"min\":0,\"max\":0},\"antracen\":{\"min\":0,\"max\":0},\"benzo[a]an\":{\"min\":0,\"max\":0},\"benzo[a]py\":{\"min\":0,\"max\":0},\"benzo[b]fl\":{\"min\":0,\"max\":0},\"benzo[ghi]\":{\"min\":0,\"max\":0},\"benzo[k]fl\":{\"min\":0,\"max\":0},\"dibenzo[a,\":{\"min\":0,\"max\":0},\"fenantren\":{\"min\":0,\"max\":0},\"fluoranten\":{\"min\":0,\"max\":0},\"fluoren\":{\"min\":0,\"max\":0},\"indeno[1,2\":{\"min\":0,\"max\":0},\"krysen/tri\":{\"min\":0,\"max\":0},\"naftalen\":{\"min\":0,\"max\":0},\"pyren\":{\"min\":0,\"max\":0},\"sum pah 16\":{\"min\":0,\"max\":0},\"sink\":{\"max\":3000,\"min\":18,\"avg\":956},\"sum_thc_c5\":{\"min\":0,\"max\":0},\"thc_c5-c8\":{\"min\":0,\"max\":0},\"thc_c10_c1\":{\"min\":0,\"max\":0},\"thc_c12_c1\":{\"min\":0,\"max\":0},\"thc_c16_c3\":{\"min\":0,\"max\":0},\"thc_c8_c10\":{\"min\":0,\"max\":0},\"ammonium\":{\"max\":0.24,\"min\":0.15,\"avg\":0.1925},\"nitrat\":{\"max\":3000,\"min\":18,\"avg\":956},\"tota-_nitr\":{\"min\":0,\"max\":0},\"benzen\":{\"min\":0,\"max\":0},\"etylbenzen\":{\"min\":0,\"max\":0},\"m_p_xylen\":{\"min\":0,\"max\":0},\"o_xylen\":{\"min\":0,\"max\":0},\"toluen\":{\"min\":0,\"max\":0},\"xylener_su\":{\"min\":0,\"max\":0},\"_columns\":[\"gid\",\"type\",\"arsen\",\"bly\",\"kadmium\",\"kobber\",\"krom\",\"mercury\",\"nikkel\",\"acenaften\",\"acenaftyle\",\"antracen\",\"benzo[a]an\",\"benzo[a]py\",\"benzo[b]fl\",\"benzo[ghi]\",\"benzo[k]fl\",\"dibenzo[a,\",\"fenantren\",\"fluoranten\",\"fluoren\",\"indeno[1,2\",\"krysen/tri\",\"naftalen\",\"pyren\",\"sum pah 16\",\"sink\",\"sum_thc_c5\",\"thc_c5-c8\",\"thc_c10_c1\",\"thc_c12_c1\",\"thc_c16_c3\",\"thc_c8_c10\",\"ammonium\",\"nitrat\",\"tota-_nitr\",\"benzen\",\"etylbenzen\",\"m_p_xylen\",\"o_xylen\",\"toluen\",\"xylener_su\"]},\"extent_geojson\":{\"type\":\"Polygon\",\"coordinates\":[[[11.2428390463193,59.8826226974976],[11.2428390463193,59.8864235789197],[11.2486811937403,59.8864235789197],[11.2486811937403,59.8826226974976],[11.2428390463193,59.8826226974976]]]},\"total_area\":138064.4293375557,\"row_count\":\"4\",\"size_bytes\":\"16 kB\",\"geometry_type\":\"ST_Point\"}",
      "data_type": "vector",
      "geom_column": "the_geom_3857",
      "geom_type": "geometry",
      "raster_band": 0,
      "srid": 3857,
      "cartocss_version": "2.0.1"
    }
  }
}

Returns:

{
  "__v": 0,
  "lastUpdated": "2016-06-11T17:45:58.352Z",
  "created": "2016-06-11T17:45:58.352Z",
  "style": "{\"point\":{\"enabled\":true,\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"yellow\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]},\"opacity\":{\"column\":false,\"range\":[-426.6,105.9]},\"pointsize\":{\"column\":false,\"range\":[0,10],\"staticVal\":2},\"blend\":{\"mode\":\"screen\"},\"targets\":[]},\"polygon\":{\"enabled\":false,\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"red\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]},\"opacity\":{\"column\":false,\"range\":[-426.6,105.9],\"value\":0.5},\"line\":{\"width\":{\"column\":false,\"range\":false,\"value\":1},\"opacity\":{\"column\":false,\"range\":[-426.6,105.9],\"value\":0.5},\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"green\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]}}},\"line\":{\"enabled\":false,\"width\":{\"column\":false,\"range\":false,\"value\":1},\"opacity\":{\"column\":false,\"value\":0.5},\"color\":{\"column\":false,\"range\":[-426.6,105.9],\"staticVal\":\"green\",\"value\":[\"#ff0000\",\"#ffff00\",\"#00ff00\",\"#00ffff\",\"#0000ff\"]}}}",
  "metadata": "{\"extent\":[\"11.2428390463193\",\"59.8826226974976\",\"11.2486811937403\",\"59.8864235789197\"],\"columns\":{\"gid\":{\"max\":4,\"min\":1,\"avg\":2.5},\"type\":{\"min\":0,\"max\":0},\"arsen\":{\"max\":0.23,\"min\":0,\"avg\":0.0575},\"bly\":{\"max\":1,\"min\":0,\"avg\":0.2675},\"kadmium\":{\"max\":0.0088,\"min\":0,\"avg\":0.0022},\"kobber\":{\"max\":5.8,\"min\":1,\"avg\":2.45},\"krom\":{\"max\":0.32,\"min\":0,\"avg\":0.08},\"mercury\":{\"max\":0.0005,\"min\":0.0005,\"avg\":0.0005},\"nikkel\":{\"max\":1,\"min\":0,\"avg\":0.46},\"acenaften\":{\"min\":0,\"max\":0},\"acenaftyle\":{\"min\":0,\"max\":0},\"antracen\":{\"min\":0,\"max\":0},\"benzo[a]an\":{\"min\":0,\"max\":0},\"benzo[a]py\":{\"min\":0,\"max\":0},\"benzo[b]fl\":{\"min\":0,\"max\":0},\"benzo[ghi]\":{\"min\":0,\"max\":0},\"benzo[k]fl\":{\"min\":0,\"max\":0},\"dibenzo[a,\":{\"min\":0,\"max\":0},\"fenantren\":{\"min\":0,\"max\":0},\"fluoranten\":{\"min\":0,\"max\":0},\"fluoren\":{\"min\":0,\"max\":0},\"indeno[1,2\":{\"min\":0,\"max\":0},\"krysen/tri\":{\"min\":0,\"max\":0},\"naftalen\":{\"min\":0,\"max\":0},\"pyren\":{\"min\":0,\"max\":0},\"sum pah 16\":{\"min\":0,\"max\":0},\"sink\":{\"max\":3000,\"min\":18,\"avg\":956},\"sum_thc_c5\":{\"min\":0,\"max\":0},\"thc_c5-c8\":{\"min\":0,\"max\":0},\"thc_c10_c1\":{\"min\":0,\"max\":0},\"thc_c12_c1\":{\"min\":0,\"max\":0},\"thc_c16_c3\":{\"min\":0,\"max\":0},\"thc_c8_c10\":{\"min\":0,\"max\":0},\"ammonium\":{\"max\":0.24,\"min\":0.15,\"avg\":0.1925},\"nitrat\":{\"max\":3000,\"min\":18,\"avg\":956},\"tota-_nitr\":{\"min\":0,\"max\":0},\"benzen\":{\"min\":0,\"max\":0},\"etylbenzen\":{\"min\":0,\"max\":0},\"m_p_xylen\":{\"min\":0,\"max\":0},\"o_xylen\":{\"min\":0,\"max\":0},\"toluen\":{\"min\":0,\"max\":0},\"xylener_su\":{\"min\":0,\"max\":0},\"_columns\":[\"gid\",\"type\",\"arsen\",\"bly\",\"kadmium\",\"kobber\",\"krom\",\"mercury\",\"nikkel\",\"acenaften\",\"acenaftyle\",\"antracen\",\"benzo[a]an\",\"benzo[a]py\",\"benzo[b]fl\",\"benzo[ghi]\",\"benzo[k]fl\",\"dibenzo[a,\",\"fenantren\",\"fluoranten\",\"fluoren\",\"indeno[1,2\",\"krysen/tri\",\"naftalen\",\"pyren\",\"sum pah 16\",\"sink\",\"sum_thc_c5\",\"thc_c5-c8\",\"thc_c10_c1\",\"thc_c12_c1\",\"thc_c16_c3\",\"thc_c8_c10\",\"ammonium\",\"nitrat\",\"tota-_nitr\",\"benzen\",\"etylbenzen\",\"m_p_xylen\",\"o_xylen\",\"toluen\",\"xylener_su\"]},\"extent_geojson\":{\"type\":\"Polygon\",\"coordinates\":[[[11.2428390463193,59.8826226974976],[11.2428390463193,59.8864235789197],[11.2486811937403,59.8864235789197],[11.2486811937403,59.8826226974976],[11.2428390463193,59.8826226974976]]]},\"total_area\":138064.4293375557,\"row_count\":\"4\",\"size_bytes\":\"16 kB\",\"geometry_type\":\"ST_Point\"}",
  "file": "file_ubevgeekwaybeghjtlcq",
  "legend": "",
  "description": "Description: Layer created from FB_fet_vann_des15.xlsx - Sheet1 (2)",
  "title": "FB_fet_vann_des15.xlsx - Sheet1 (2)",
  "uuid": "layer-850ac749-4362-4745-ac6f-cfc83732ef6d",
  "_id": "575c4e562129f4327c601b76",
  "data": {
    "postgis": {
      "layer_id": "layer_id-0e035204-d8f5-4d50-882c-844a5c02dbd3",
      "sql": "(SELECT * FROM file_ubevgeekwaybeghjtlcq) as sub",
      "cartocss": "@point_opacity: 1;\n@marker_size_factor: 2;\n[zoom<10] { marker-width: 0.2 * @marker_size_factor; }\n[zoom=10] { marker-width: 0.3 * @marker_size_factor; }\n[zoom=11] { marker-width: 0.5 * @marker_size_factor; }\n[zoom=12] { marker-width: 1   * @marker_size_factor; }\n[zoom=13] { marker-width: 1   * @marker_size_factor; }\n[zoom=14] { marker-width: 2   * @marker_size_factor; }\n[zoom=15] { marker-width: 4   * @marker_size_factor; }\n[zoom=16] { marker-width: 6   * @marker_size_factor; }\n[zoom=17] { marker-width: 8   * @marker_size_factor; }\n[zoom>=18] { marker-width: 12  * @marker_size_factor; }\n\n#layer {\n\n\tmarker-allow-overlap: true;\n\tmarker-clip: false;\n\tmarker-comp-op: screen;\n\n\tmarker-opacity: @point_opacity;\n\n\tmarker-fill: yellow;\n\n}",
      "file_id": "file_ubevgeekwaybeghjtlcq",
      "database_name": "vutnqpexon",
      "table_name": "file_ubevgeekwaybeghjtlcq",
      "metadata": "{\"extent\":[\"11.2428390463193\",\"59.8826226974976\",\"11.2486811937403\",\"59.8864235789197\"],\"columns\":{\"gid\":{\"max\":4,\"min\":1,\"avg\":2.5},\"type\":{\"min\":0,\"max\":0},\"arsen\":{\"max\":0.23,\"min\":0,\"avg\":0.0575},\"bly\":{\"max\":1,\"min\":0,\"avg\":0.2675},\"kadmium\":{\"max\":0.0088,\"min\":0,\"avg\":0.0022},\"kobber\":{\"max\":5.8,\"min\":1,\"avg\":2.45},\"krom\":{\"max\":0.32,\"min\":0,\"avg\":0.08},\"mercury\":{\"max\":0.0005,\"min\":0.0005,\"avg\":0.0005},\"nikkel\":{\"max\":1,\"min\":0,\"avg\":0.46},\"acenaften\":{\"min\":0,\"max\":0},\"acenaftyle\":{\"min\":0,\"max\":0},\"antracen\":{\"min\":0,\"max\":0},\"benzo[a]an\":{\"min\":0,\"max\":0},\"benzo[a]py\":{\"min\":0,\"max\":0},\"benzo[b]fl\":{\"min\":0,\"max\":0},\"benzo[ghi]\":{\"min\":0,\"max\":0},\"benzo[k]fl\":{\"min\":0,\"max\":0},\"dibenzo[a,\":{\"min\":0,\"max\":0},\"fenantren\":{\"min\":0,\"max\":0},\"fluoranten\":{\"min\":0,\"max\":0},\"fluoren\":{\"min\":0,\"max\":0},\"indeno[1,2\":{\"min\":0,\"max\":0},\"krysen/tri\":{\"min\":0,\"max\":0},\"naftalen\":{\"min\":0,\"max\":0},\"pyren\":{\"min\":0,\"max\":0},\"sum pah 16\":{\"min\":0,\"max\":0},\"sink\":{\"max\":3000,\"min\":18,\"avg\":956},\"sum_thc_c5\":{\"min\":0,\"max\":0},\"thc_c5-c8\":{\"min\":0,\"max\":0},\"thc_c10_c1\":{\"min\":0,\"max\":0},\"thc_c12_c1\":{\"min\":0,\"max\":0},\"thc_c16_c3\":{\"min\":0,\"max\":0},\"thc_c8_c10\":{\"min\":0,\"max\":0},\"ammonium\":{\"max\":0.24,\"min\":0.15,\"avg\":0.1925},\"nitrat\":{\"max\":3000,\"min\":18,\"avg\":956},\"tota-_nitr\":{\"min\":0,\"max\":0},\"benzen\":{\"min\":0,\"max\":0},\"etylbenzen\":{\"min\":0,\"max\":0},\"m_p_xylen\":{\"min\":0,\"max\":0},\"o_xylen\":{\"min\":0,\"max\":0},\"toluen\":{\"min\":0,\"max\":0},\"xylener_su\":{\"min\":0,\"max\":0},\"_columns\":[\"gid\",\"type\",\"arsen\",\"bly\",\"kadmium\",\"kobber\",\"krom\",\"mercury\",\"nikkel\",\"acenaften\",\"acenaftyle\",\"antracen\",\"benzo[a]an\",\"benzo[a]py\",\"benzo[b]fl\",\"benzo[ghi]\",\"benzo[k]fl\",\"dibenzo[a,\",\"fenantren\",\"fluoranten\",\"fluoren\",\"indeno[1,2\",\"krysen/tri\",\"naftalen\",\"pyren\",\"sum pah 16\",\"sink\",\"sum_thc_c5\",\"thc_c5-c8\",\"thc_c10_c1\",\"thc_c12_c1\",\"thc_c16_c3\",\"thc_c8_c10\",\"ammonium\",\"nitrat\",\"tota-_nitr\",\"benzen\",\"etylbenzen\",\"m_p_xylen\",\"o_xylen\",\"toluen\",\"xylener_su\"]},\"extent_geojson\":{\"type\":\"Polygon\",\"coordinates\":[[[11.2428390463193,59.8826226974976],[11.2428390463193,59.8864235789197],[11.2486811937403,59.8864235789197],[11.2486811937403,59.8826226974976],[11.2428390463193,59.8826226974976]]]},\"total_area\":138064.4293375557,\"row_count\":\"4\",\"size_bytes\":\"16 kB\",\"geometry_type\":\"ST_Point\"}",
      "data_type": "vector",
      "geom_column": "the_geom_3857",
      "geom_type": "geometry",
      "raster_band": 0,
      "srid": 3857,
      "cartocss_version": "2.0.1"
    }
  },
  "tooltip": "{\"title\":\"\",\"description\":false,\"metaFields\":{\"gid\":{\"title\":false,\"on\":true},\"type\":{\"title\":false,\"on\":true},\"arsen\":{\"title\":false,\"on\":true},\"bly\":{\"title\":false,\"on\":true},\"kadmium\":{\"title\":false,\"on\":true},\"kobber\":{\"title\":false,\"on\":true},\"krom\":{\"title\":false,\"on\":true},\"mercury\":{\"title\":false,\"on\":true},\"nikkel\":{\"title\":false,\"on\":true},\"acenaften\":{\"title\":false,\"on\":true},\"acenaftyle\":{\"title\":false,\"on\":true},\"antracen\":{\"title\":false,\"on\":true},\"benzo[a]an\":{\"title\":false,\"on\":true},\"benzo[a]py\":{\"title\":false,\"on\":true},\"benzo[b]fl\":{\"title\":false,\"on\":true},\"benzo[ghi]\":{\"title\":false,\"on\":true},\"benzo[k]fl\":{\"title\":false,\"on\":true},\"dibenzo[a,\":{\"title\":false,\"on\":true},\"fenantren\":{\"title\":false,\"on\":true},\"fluoranten\":{\"title\":false,\"on\":true},\"fluoren\":{\"title\":false,\"on\":true},\"indeno[1,2\":{\"title\":false,\"on\":true},\"krysen/tri\":{\"title\":false,\"on\":true},\"naftalen\":{\"title\":false,\"on\":true},\"pyren\":{\"title\":false,\"on\":true},\"sum pah 16\":{\"title\":false,\"on\":true},\"sink\":{\"title\":false,\"on\":true},\"sum_thc_c5\":{\"title\":false,\"on\":true},\"thc_c5-c8\":{\"title\":false,\"on\":true},\"thc_c10_c1\":{\"title\":false,\"on\":true},\"thc_c12_c1\":{\"title\":false,\"on\":true},\"thc_c16_c3\":{\"title\":false,\"on\":true},\"thc_c8_c10\":{\"title\":false,\"on\":true},\"ammonium\":{\"title\":false,\"on\":true},\"nitrat\":{\"title\":false,\"on\":true},\"tota-_nitr\":{\"title\":false,\"on\":true},\"benzen\":{\"title\":false,\"on\":true},\"etylbenzen\":{\"title\":false,\"on\":true},\"m_p_xylen\":{\"title\":false,\"on\":true},\"o_xylen\":{\"title\":false,\"on\":true},\"toluen\":{\"title\":false,\"on\":true},\"xylener_su\":{\"title\":false,\"on\":true},\"_columns\":{\"title\":false,\"on\":true}},\"timeSeries\":false}",
  "legends": "{\"enable\":true,\"layerMeta\":true,\"opacitySlider\":true,\"layerName\":\"FB_fet_vann_des15.xlsx - Sheet1 (2)\",\"point\":{\"all\":{\"color\":{\"column\":false,\"value\":\"yellow\"},\"opacity\":{\"column\":false,\"value\":1},\"pointsize\":{\"column\":false,\"value\":2},\"isOn\":true},\"target\":[]},\"polygon\":{\"all\":{},\"target\":[]},\"line\":{\"all\":{},\"target\":[]},\"html\":\"<div class=\\\"legend-each-container\\\"><div class=\\\"legend-each-name\\\">FB_fet_vann_des15.xlsx - Sheet1 (2)</div><div class=\\\"legend-each-color\\\" style=\\\"background:rgba(255,255,0,1);;width: 10px; height: 10px; border-radius: 10px;top: 5px; left: 9px; \\\"></div></div>\",\"gradient\":\"\"}",
  "opacity": 1
}

[knutole]

1. Need csv_meta connected to file/layer
2. Use csv_meta to create cartocss with t1
3. Use csv_meta for legends, popup