payload.js 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269
  1. /*
  2. * Licensed to the Apache Software Foundation (ASF) under one
  3. * or more contributor license agreements. See the NOTICE file
  4. * distributed with this work for additional information
  5. * regarding copyright ownership. The ASF licenses this file
  6. * to you under the Apache License, Version 2.0 (the
  7. * "License"); you may not use this file except in compliance
  8. * with the License. You may obtain a copy of the License at
  9. *
  10. * http://www.apache.org/licenses/LICENSE-2.0
  11. *
  12. * Unless required by applicable law or agreed to in writing,
  13. * software distributed under the License is distributed on an
  14. * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  15. * KIND, either express or implied. See the License for the
  16. * specific language governing permissions and limitations
  17. * under the License.
  18. */
  19. /* eslint-disable sort-keys, no-magic-numbers */
  20. export default {
  21. cache_key: null,
  22. cached_dttm: null,
  23. cache_timeout: 86400,
  24. error: null,
  25. form_data: {
  26. datasource: '10__table',
  27. viz_type: 'deck_arc',
  28. slice_id: 71,
  29. url_params: {},
  30. granularity_sqla: 'dttm',
  31. time_grain_sqla: null,
  32. time_range: ' : ',
  33. start_spatial: {
  34. type: 'latlong',
  35. latCol: 'LATITUDE',
  36. lonCol: 'LONGITUDE',
  37. },
  38. end_spatial: {
  39. type: 'latlong',
  40. latCol: 'LATITUDE_DEST',
  41. lonCol: 'LONGITUDE_DEST',
  42. },
  43. row_limit: 5000,
  44. filter_nulls: true,
  45. adhoc_filters: [
  46. {
  47. clause: 'WHERE',
  48. expressionType: 'SIMPLE',
  49. filterOptionName: '1b92e906-53a1-48e2-8e45-056fc5c9d2dc',
  50. comparator: '',
  51. operator: 'IS NOT NULL',
  52. subject: 'LATITUDE',
  53. },
  54. {
  55. clause: 'WHERE',
  56. expressionType: 'SIMPLE',
  57. filterOptionName: '0ec864e8-e3e1-42cc-b0f8-4620dfc1c806',
  58. comparator: '',
  59. operator: 'IS NOT NULL',
  60. subject: 'LATITUDE_DEST',
  61. },
  62. {
  63. clause: 'WHERE',
  64. expressionType: 'SIMPLE',
  65. filterOptionName: 'ecf4d524-eb35-45a8-b928-91398ebcf498',
  66. comparator: '',
  67. operator: 'IS NOT NULL',
  68. subject: 'LONGITUDE',
  69. },
  70. {
  71. clause: 'WHERE',
  72. expressionType: 'SIMPLE',
  73. filterOptionName: '5297586e-9c42-4c5a-bd5d-8a5fed4d698f',
  74. comparator: '',
  75. operator: 'IS NOT NULL',
  76. subject: 'LONGITUDE_DEST',
  77. },
  78. ],
  79. mapbox_style: 'mapbox://styles/mapbox/light-v9',
  80. viewport: {
  81. altitude: 1.5,
  82. bearing: 8.546256357301871,
  83. height: 642,
  84. latitude: 44.596651438714254,
  85. longitude: -91.84340711201104,
  86. maxLatitude: 85.05113,
  87. maxPitch: 60,
  88. maxZoom: 20,
  89. minLatitude: -85.05113,
  90. minPitch: 0,
  91. minZoom: 0,
  92. pitch: 60,
  93. width: 997,
  94. zoom: 2.929837070560775,
  95. },
  96. autozoom: true,
  97. color_picker: {
  98. a: 1,
  99. b: 135,
  100. g: 122,
  101. r: 0,
  102. },
  103. target_color_picker: {
  104. r: 0,
  105. g: 122,
  106. b: 135,
  107. a: 1,
  108. },
  109. dimension: null,
  110. color_scheme: 'bnbColors',
  111. label_colors: {},
  112. stroke_width: 1,
  113. legend_position: 'tr',
  114. legend_format: null,
  115. js_columns: [],
  116. where: '',
  117. having: '',
  118. filters: [
  119. {
  120. col: 'LATITUDE',
  121. op: 'IS NOT NULL',
  122. val: '',
  123. },
  124. {
  125. col: 'LATITUDE_DEST',
  126. op: 'IS NOT NULL',
  127. val: '',
  128. },
  129. {
  130. col: 'LONGITUDE',
  131. op: 'IS NOT NULL',
  132. val: '',
  133. },
  134. {
  135. col: 'LONGITUDE_DEST',
  136. op: 'IS NOT NULL',
  137. val: '',
  138. },
  139. ],
  140. },
  141. is_cached: false,
  142. query:
  143. 'SELECT "LATITUDE" AS "LATITUDE",\n "LONGITUDE" AS "LONGITUDE",\n "LONGITUDE_DEST" AS "LONGITUDE_DEST",\n "LATITUDE_DEST" AS "LATITUDE_DEST"\nFROM flights\nWHERE "LATITUDE" IS NOT NULL\n AND "LATITUDE_DEST" IS NOT NULL\n AND "LONGITUDE" IS NOT NULL\n AND "LONGITUDE_DEST" IS NOT NULL\nLIMIT 5000\nOFFSET 0',
  144. status: 'success',
  145. stacktrace: null,
  146. rowcount: 5000,
  147. data: {
  148. features: [
  149. {
  150. sourcePosition: [-149.99618999999998, 61.174319999999994],
  151. targetPosition: [-122.30931000000001, 47.44898],
  152. cat_color: null,
  153. __timestamp: null,
  154. },
  155. {
  156. sourcePosition: [-118.40807, 33.94254],
  157. targetPosition: [-80.09559, 26.683159999999997],
  158. cat_color: null,
  159. __timestamp: null,
  160. },
  161. {
  162. sourcePosition: [-122.37483999999999, 37.619],
  163. targetPosition: [-80.94313000000001, 35.214009999999995],
  164. cat_color: null,
  165. __timestamp: null,
  166. },
  167. {
  168. sourcePosition: [-118.40807, 33.94254],
  169. targetPosition: [-80.29056, 25.79325],
  170. cat_color: null,
  171. __timestamp: null,
  172. },
  173. {
  174. sourcePosition: [-122.30931000000001, 47.44898],
  175. targetPosition: [-149.99618999999998, 61.174319999999994],
  176. cat_color: null,
  177. __timestamp: null,
  178. },
  179. {
  180. sourcePosition: [-122.37483999999999, 37.619],
  181. targetPosition: [-93.21692, 44.88055],
  182. cat_color: null,
  183. __timestamp: null,
  184. },
  185. {
  186. sourcePosition: [-115.15233, 36.08036],
  187. targetPosition: [-93.21692, 44.88055],
  188. cat_color: null,
  189. __timestamp: null,
  190. },
  191. {
  192. sourcePosition: [-118.40807, 33.94254],
  193. targetPosition: [-80.94313000000001, 35.214009999999995],
  194. cat_color: null,
  195. __timestamp: null,
  196. },
  197. {
  198. sourcePosition: [-122.37483999999999, 37.619],
  199. targetPosition: [-97.0372, 32.89595],
  200. cat_color: null,
  201. __timestamp: null,
  202. },
  203. {
  204. sourcePosition: [-115.15233, 36.08036],
  205. targetPosition: [-84.42694, 33.640440000000005],
  206. cat_color: null,
  207. __timestamp: null,
  208. },
  209. {
  210. sourcePosition: [-104.667, 39.85841],
  211. targetPosition: [-84.42694, 33.640440000000005],
  212. cat_color: null,
  213. __timestamp: null,
  214. },
  215. {
  216. sourcePosition: [-115.15233, 36.08036],
  217. targetPosition: [-80.29056, 25.79325],
  218. cat_color: null,
  219. __timestamp: null,
  220. },
  221. {
  222. sourcePosition: [-118.40807, 33.94254],
  223. targetPosition: [-93.21692, 44.88055],
  224. cat_color: null,
  225. __timestamp: null,
  226. },
  227. {
  228. sourcePosition: [-111.97776999999999, 40.78839],
  229. targetPosition: [-84.42694, 33.640440000000005],
  230. cat_color: null,
  231. __timestamp: null,
  232. },
  233. {
  234. sourcePosition: [-122.30931000000001, 47.44898],
  235. targetPosition: [-93.21692, 44.88055],
  236. cat_color: null,
  237. __timestamp: null,
  238. },
  239. {
  240. sourcePosition: [-149.99618999999998, 61.174319999999994],
  241. targetPosition: [-122.30931000000001, 47.44898],
  242. cat_color: null,
  243. __timestamp: null,
  244. },
  245. {
  246. sourcePosition: [-149.99618999999998, 61.174319999999994],
  247. targetPosition: [-122.30931000000001, 47.44898],
  248. cat_color: null,
  249. __timestamp: null,
  250. },
  251. {
  252. sourcePosition: [-122.37483999999999, 37.619],
  253. targetPosition: [-95.33972, 29.98047],
  254. cat_color: null,
  255. __timestamp: null,
  256. },
  257. {
  258. sourcePosition: [-149.99618999999998, 61.174319999999994],
  259. targetPosition: [-122.5975, 45.58872],
  260. cat_color: null,
  261. __timestamp: null,
  262. },
  263. ],
  264. mapboxApiKey:
  265. 'pk.eyJ1Ijoia3Jpc3R3IiwiYSI6ImNqbGg1N242NTFlczczdnBhazViMjgzZ2sifQ.lUneM-o3NucXN189EYyXxQ',
  266. },
  267. };