airbnb/superset

/*
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */

/* eslint-disable sort-keys */
/* eslint-disable no-magic-numbers */
export default {
  cache_key: null,
  cached_dttm: null,
  cache_timeout: 86400,
  error: null,
  form_data: {
    color_picker: { a: 1, b: 0, g: 255, r: 14 },
    datasource: '5__table',
    extruded: true,
    granularity_sqla: 'dttm',
    grid_size: 120,
    groupby: [],
    mapbox_style: 'mapbox://styles/mapbox/satellite-streets-v9',
    point_radius: 'Auto',
    point_radius_fixed: { type: 'fix', value: 2000 },
    point_radius_unit: 'Pixels',
    row_limit: 5000,
    size: 'count',
    spatial: { latCol: 'LAT', lonCol: 'LON', type: 'latlong' },
    time_grain_sqla: null,
    viewport: {
      bearing: 155.80099696026355,
      latitude: 37.7942314882596,
      longitude: -122.42066918995666,
      pitch: 53.470800300695146,
      zoom: 12.699690845482069,
    },
    viz_type: 'deck_grid',
    slice_id: 69,
    time_range: ' : ',
    adhoc_filters: [
      {
        clause: 'WHERE',
        expressionType: 'SIMPLE',
        filterOptionName: '72912258-6f4f-4f04-a570-58317ca49b11',
        comparator: '',
        operator: 'IS NOT NULL',
        subject: 'LAT',
      },
      {
        clause: 'WHERE',
        expressionType: 'SIMPLE',
        filterOptionName: '7e19669b-48ef-4be8-a7e1-8378dedb4c00',
        comparator: '',
        operator: 'IS NOT NULL',
        subject: 'LON',
      },
    ],
    where: '',
    having: '',
    filters: [
      { col: 'LAT', op: 'IS NOT NULL', val: '' },
      { col: 'LON', op: 'IS NOT NULL', val: '' },
    ],
  },
  is_cached: false,
  query:
    'SELECT "LAT" AS "LAT",\n       "LON" AS "LON",\n       COUNT(*) AS count\nFROM\n  (SELECT datetime,\n          ROUND(LON*10000000)/10000000 as LON,\n          ROUND(LAT*10000000)/10000000 as LAT, NUMBER , STREET,\n                                                        UNIT,\n                                                        CITY,\n                                                        DISTRICT,\n                                                        REGION,\n                                                        POSTCODE,\n                                                        ID occupancy,\n                                                        radius_miles,\n                                                        geohash,\n                                                        delimited\n   FROM long_lat) AS expr_qry\nWHERE "LAT" IS NOT NULL\n  AND "LON" IS NOT NULL\nGROUP BY "LAT",\n         "LON"\nORDER BY count DESC\nLIMIT 5000\nOFFSET 0',
  status: 'success',
  stacktrace: null,
  rowcount: 5000,
  data: {
    features: [
      { position: [-122.4221936, 37.7786083], weight: 2415 },
      { position: [-122.4101989, 37.7878771], weight: 2391 },
      { position: [-122.4205965, 37.8054735], weight: 1349 },
      { position: [-122.4125137, 37.7908413], weight: 1004 },
      { position: [-122.4088144, 37.7912984], weight: 816 },
      { position: [-122.3934248, 37.7776271], weight: 610 },
      { position: [-122.390972, 37.789376], weight: 460 },
      { position: [-122.3804676, 37.7334388], weight: 453 },
      { position: [-122.4214063, 37.7813858], weight: 453 },
      { position: [-122.3961419, 37.7905823], weight: 422 },
      { position: [-122.3922757, 37.7858294], weight: 376 },
      { position: [-122.3903881, 37.7826463], weight: 359 },
      { position: [-122.3936422, 37.7870311], weight: 353 },
      { position: [-122.435635, 37.7852314], weight: 306 },
      { position: [-122.3971336, 37.7790975], weight: 301 },
      { position: [-122.3921161, 37.7864536], weight: 300 },
      { position: [-122.390611, 37.7876797], weight: 292 },
      { position: [-122.4055041, 37.804244], weight: 291 },
      { position: [-122.4136476, 37.7910263], weight: 264 },
      { position: [-122.4224908, 37.7867552], weight: 247 },
      { position: [-122.4123203, 37.7784493], weight: 240 },
      { position: [-122.4368896, 37.7822303], weight: 239 },
      { position: [-122.389625, 37.7806302], weight: 237 },
    ],
    mapboxApiKey:
      'pk.eyJ1Ijoia3Jpc3R3IiwiYSI6ImNqbGg1N242NTFlczczdnBhazViMjgzZ2sifQ.lUneM-o3NucXN189EYyXxQ',
    metricLabels: ['count'],
  },
};