{ "cells": [ { "cell_type": "markdown", "id": "a85f9417", "metadata": {}, "source": [ "# 采用Plotly展示\n", "\n", "## 从数据库查询\n", "我们将之前保存的全国主要城市的天气信息从数据库中读取。" ] }, { "cell_type": "code", "execution_count": 11, "id": "60ddd2d4", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "C:\\Users\\renb\\PycharmProjects\\weather_dashapp\n" ] } ], "source": [ "import os\n", "import sys\n", "\n", "module_path = os.path.abspath(os.path.join('../..'))\n", "print(module_path)\n", "if module_path not in sys.path:\n", " sys.path.append(module_path)" ] }, { "cell_type": "code", "execution_count": 12, "id": "e0d14d37", "metadata": {}, "outputs": [], "source": [ "from weather_book.weather_app.models.db_models import engine,WeatherInfo\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 13, "id": "be992c5f", "metadata": {}, "outputs": [], "source": [ "df = pd.read_sql_table(WeatherInfo.__tablename__,engine)" ] }, { "cell_type": "code", "execution_count": 14, "id": "5d7eb60d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(89664, 14)" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.shape" ] }, { "cell_type": "markdown", "id": "ebe8847c", "metadata": {}, "source": [ "这里我们仅仅展示一个时刻的信息,所以我们需要对每个城市的数据“去重”,仅仅保留最后一个数据。\n", "```需要强调的是:如果数据库比较乱,每个城市最后一个数据对应的时间戳并不相同。```" ] }, { "cell_type": "code", "execution_count": 15, "id": "94994611", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(1237, 14)" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.drop_duplicates(subset=['city'], keep='last',inplace=True)\n", "df.shape" ] }, { "cell_type": "code", "execution_count": 16, "id": "9ad01a8d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
cloudcoverlifted_indexprec_typeprec_amounttemp2mrh2mweathertimestampwind_directionwind_speedlongitudelatitudecityid
5823115none0912clearday2022-02-10 06:00:00W3121.466731.1667Shanghai63.0
5887215rain4431rainday2022-02-10 06:00:00NW2113.259023.1288Guangzhou127.0
5951115none0510clearday2022-02-10 06:00:00NW4116.391439.9050Beijing191.0
6015115none0711clearday2022-02-10 06:00:00NW4114.054022.5350Shenzhen255.0
6079915none31147cloudyday2022-02-10 06:00:00S2112.529232.9987Nanyang319.0
\n", "
" ], "text/plain": [ " cloudcover lifted_index prec_type prec_amount temp2m rh2m weather \\\n", "5823 1 15 none 0 9 12 clearday \n", "5887 2 15 rain 4 4 31 rainday \n", "5951 1 15 none 0 5 10 clearday \n", "6015 1 15 none 0 7 11 clearday \n", "6079 9 15 none 3 11 47 cloudyday \n", "\n", " timestamp wind_direction wind_speed longitude latitude \\\n", "5823 2022-02-10 06:00:00 W 3 121.4667 31.1667 \n", "5887 2022-02-10 06:00:00 NW 2 113.2590 23.1288 \n", "5951 2022-02-10 06:00:00 NW 4 116.3914 39.9050 \n", "6015 2022-02-10 06:00:00 NW 4 114.0540 22.5350 \n", "6079 2022-02-10 06:00:00 S 2 112.5292 32.9987 \n", "\n", " city id \n", "5823 Shanghai 63.0 \n", "5887 Guangzhou 127.0 \n", "5951 Beijing 191.0 \n", "6015 Shenzhen 255.0 \n", "6079 Nanyang 319.0 " ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.head()" ] }, { "cell_type": "code", "execution_count": 19, "id": "72b0a7b6", "metadata": {}, "outputs": [ { "data": { "text/html": [ " \n", " " ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "lat": [ 31.1667, 23.1288, 39.905, 22.535, 32.9987, 38.8671, 30.66, 35.0606, 39.1467, 38.0422, 33.625, 36.6116, 36.7167, 30.5872, 35.2333, 25.8292, 34.261, 36.6667, 23.0292, 29.5628, 43.9, 32.9773, 29.875, 38.3037, 32.05, 31.8639, 21.1967, 26.8968, 31.9829, 33.3936, 22.8192, 34.2667, 41.8039, 39.6292, 34.7492, 34.4259, 37.3997, 32.1264, 28.4419, 34.6587, 27.3019, 24.9139, 30.25, 30.45, 21.6618, 25.0433, 30.7991, 27.705, 23.5533, 31.7542, 29.0397, 36.45, 25.5102, 36.1167, 31.2152, 32.0654, 35.2992, 36.2001, 22.6293, 37.4513, 26.4515, 46.6384, 47.3398, 29.1046, 23.3735, 34.4996, 33.9331, 31.304, 27.3328, 31.2231, 24.5093, 33.8626, 28.6842, 34.35, 32.4831, 27.5494, 27.1172, 31.4669, 30.9273, 30, 35.0304, 33.735, 23.1115, 33.5, 34.5906, 25.7989, 25.2667, 29.7048, 30.5, 34.7936, 22.5833, 31.8122, 31.5667, 36.7831, 30.7522, 38.9, 37.7348, 45.75, 32.3912, 28.7596, 24.2998, 42.2663, 26.5794, 39.5196, 40.8108, 36.0812, 27.9991, 28.8918, 34.0244, 29.5872, 30.1256, 23.05, 30.7083, 23.0961, 24.4797, 32.3062, 27.9814, 27.8407, 27.7378, 31.1289, 31.334, 37.3806, 24.3264, 34.3609, 30.4673, 33.0794, 34.8667, 36.0617, 40.9739, 35.7639, 30.5098, 35.229, 32.9354, 34.5809, 37.8733, 41.5757, 24.6928, 29.5854, 38.2655, 43.1715, 36.1953, 39.9398, 32.2109, 43.8225, 43.6172, 23.7503, 27.7233, 21.95, 38.4178, 41.1144, 42.2841, 24.8011, 22.7664, 35.5806, 26.6667, 46.5979, 25.4394, 30.8695, 23.4833, 27.8431, 29.3498, 44.5861, 40.7094, 35.4164, 40.6562, 26.6448, 23.67, 25.0881, 40.8151, 33.535, 37.5, 30.9475, 26.2658, 21.8556, 25.1211, 33.583, 35.7278, 32.4353, 30.2018, 43.85, 40.7503, 23.8864, 32.4831, 40.1167, 33.868, 46.8081, 24.3495, 26.2456, 40.6653, 34.7736, 31.7135, 35.5412, 28.9545, 33.9562, 36.6239, 36.5952, 23.2993, 28.45, 24.8141, 23.7333, 41.8708, 27.6333, 22.4167, 24.4164, 45.2937, 42.0127, 22.2769, 37.9278, 41.2643, 36.5448, 20.02, 34.1299, 50.2458, 39.3408, 30.82, 31.3867, 38.4795, 35.0833, 29.2942, 41.292, 29.1255, 21.4667, 46.6388, 31.65, 21.6146, 24.9633, 28.1958, 30.1697, 23.4, 20.9147, 29.7132, 34.3422, 31.8775, 30.6583, 36.008, 27.778, 35.7497, 21.9135, 28.1188, 36.7833, 28.3147, 28.3797, 27.2578, 25.7232, 35.91, 44.8249, 21.654, 40.8523, 28.2333, 33.58, 37.9874, 38.9355, 32.3852, 32.9387, 47.7235, 36.1833, 30.6667, 26.8808, 31.9087, 33.9317, 29.3081, 34.6, 26.5944, 27.795, 38.5158, 27.6961, 29.7169, 26.4179, 26.5849, 30.3833, 34.1511, 30.0162, 32.6877, 47.3139, 30.0372, 30.652, 43.5036, 32.1724, 35.99, 30.3972, 37.5139, 36.8833, 28.8523, 39.6271, 31.169, 22.3559, 32.1287, 33.4433, 32.8534, 24.1878, 31.9948, 46.0635, 19.5, 39.737, 21.4283, 31.8131, 22.2486, 36.3619, 36.186, 34.1736, 45.768, 30.8706, 34.3662, 36.6967, 30.2965, 30.1003, 22.6896, 39.6896, 29.65, 36.2481, 22.1717, 36.08, 36.9758, 34.85, 36.3833, 32.532, 37.1792, 47.4585, 31.1817, 37.6804, 44.5323, 34.9057, 29.1409, 38.7094, 29.8182, 36.6941, 30.6326, 32.7847, 38.4451, 26.4103, 35.2125, 34.7513, 30.5333, 29.2785, 34.538, 27.7389, 25.091, 31.6783, 30.0533, 22.9297, 30.1772, 36.8667, 31.7761, 36.8494, 34.3962, 31.6189, 35.4599, 48.48, 40.1881, 26.7345, 35.0833, 39.0099, 31.5833, 40.0059, 36.8625, 28.9008, 34.5221, 31.2575, 30.9333, 22.3762, 27.8983, 31.4515, 40.6328, 24.7355, 27.0284, 28.8049, 40.4019, 37.7333, 34.2189, 32.0058, 29.5908, 27.8116, 29.2649, 30.7005, 30.9933, 37.1653, 34.4161, 35.7004, 28.8417, 31.054, 44.4167, 25.6005, 28.2861, 25.0208, 29.8518, 35.6, 39.3257, 25.8833, 31.0236, 29.3395, 40.2248, 34.7879, 37.3, 39.1235, 42.95, 37.0659, 42.5279, 31.9579, 28.1277, 37.9423, 18.2536, 28.0667, 39.4887, 31.1375, 23.3448, 30.9793, 25.0461, 45.2116, 38.074, 36.8528, 29.7211, 27.1, 42.8322, 37.359, 41.2407, 19.6167, 38.0005, 32.2739, 33.2605, 30.8258, 39.7396, 41.7646, 38.371, 27.2, 42.9392, 29.4761, 30.32, 41.1664, 32.7816, 43.9167, 36.9329, 46.4078, 22.0057, 42.8976, 22.7697, 19.2431, 41.5933, 42.9044, 31.7117, 22.1879, 41.1676, 39.45, 30.6412, 27.1167, 41.42, 35.4043, 41.802, 26.2672, 38.7299, 36.8622, 35.7911, 43.3667, 23.3715, 31.3446, 39.6708, 37.3606, 28.6804, 32.3849, 48.2395, 47.2489, 37.1449, 26.5555, 28.7412, 23.3629, 27.0387, 42.9688, 43.7192, 35.0907, 29.4774, 34.867, 32.5408, 44.3429, 40.5944, 45.3357, 44.0222, 45.542, 44.5735, 25.1307, 43.513, 29.6792, 45.505, 25.4352, 23.3689, 37.2652, 31.4766, 31.1282, 32.0691, 37.0282, 43.9, 31.0304, 35.5914, 35.4603, 45.1804, 45.5928, 46.9804, 30.388, 24.7868, 44.3, 38.4261, 30.6267, 27.6858, 38.4177, 34.9136, 39.9432, 48.0033, 30.3866, 48.6433, 35.0476, 24.4935, 49.2842, 39.83, 24.9211, 41.9377, 25.9755, 39.232, 32.2381, 44.9164, 46.0726, 39.8143, 35.0364, 37.1012, 23.7147, 33.2937, 28.3185, 47.21, 26.7039, 35.08, 36.5726, 41.03, 27.3417, 35.6, 22.9311, 34.5664, 29.6334, 49.5881, 40.4348, 25.2938, 39.7114, 38.827, 27.7562, 28.5902, 44.898, 39.8112, 42.8679, 22.8711, 41.1231, 37.9069, 36.4028, 23.2938, 44.0608, 28.65, 44.1447, 29.7204, 42.5404, 35.2175, 40.1411, 25.8519, 42.77, 23.6236, 41.8082, 23.0236, 24.6728, 19.102, 44.4196, 23.2893, 44.1523, 22.7807, 23.2723, 46.7468, 38.1522, 23.0701, 36.2601, 23.6636, 34.7473, 22.7837, 21.5833, 47.8666, 19.7386, 44.419, 23.921, 39.2333, 32.8082, 45.3503, 22.9078, 22.7135, 30.05, 37.7527, 37.4313, 39.1098, 23.1399, 42.9627, 37.5455, 39.0259, 27.844, 37.0694, 24.3512, 47.1414, 25.476, 39.4421, 22.5111, 30.4355, 23.5193, 41.2671, 36.935, 40.4027, 27.4367, 23.8163, 21.27, 41.7277, 40.9937, 34.7953, 50.7833, 35.3754, 18.7787, 47.3404, 39.5529, 24.4629, 23.5899, 25.079, 35.1379, 23.7081, 23.5517, 35.62, 22.534, 45.5266, 28.6331, 39.5189, 24.0515, 38.4633, 23.4976, 43.3126, 35.7904, 23.6271, 23.2374, 37.8822, 49.175, 35.7261, 38.443, 23.2589, 37.4264, 38.0874, 34.7904, 23.5329, 23.5792, 37.2714, 37.9869, 35.6415, 47.246, 35.6091, 35.5449, 37.1989, 34.3686, 23.5613, 38.1345, 39.9733, 37.9803, 23.5226, 39.1373, 39.9686, 37.3512, 39.9101, 38.0824, 38.5515, 29.3489, 38.9786, 22.961, 41.2013, 44.2, 40.3703, 24.0376, 25.7356, 23.6032, 28.236, 45.7564, 39.3444, 25.1496, 38.8556, 30.6218, 25.3916, 37.9513, 39.3515, 34.9984, 37.613, 23.6742, 25.5086, 23.7472, 25.867, 38.1902, 23.3014, 23.9303, 36.5653, 22.5586, 19.6819, 19.3649, 35.1395, 23.2445, 27.91, 25.1945, 41.317, 37.8792, 44.1256, 23.1863, 37.7965, 35.419, 40.7536, 32.7378, 24.1263, 21.3298, 47.0004, 23.0188, 22.7815, 23.6128, 35.5104, 23.8787, 19.9991, 45.2819, 39.8879, 39.014, 50.2411, 39.1891, 46.3909, 40.4146, 28.591, 23.5723, 37.9679, 40.6687, 46.2664, 40.3741, 27.193, 48.0263, 28.6282, 37.941, 47.6018, 34.7575, 25.9452, 30.9504, 39.05, 37.7771, 36.3283, 38.7823, 37.1889, 42.2669, 35.6918, 38.2727, 34.4362, 39.5683, 37.659, 40.4202, 36.4971, 36.8531, 36.4791, 42.6229, 39.7603, 30.9412, 46.69, 38.3063, 24.2634, 41.8513, 28.1565, 21.5989, 26.88, 37.8862, 27.1017, 39.2739, 38.28, 26.6897, 37.1146, 44.3998, 25.6814, 31.1116, 47.9117, 38.246, 30.8938, 24.0505, 31.0554, 38.7631, 31.9046, 27.8205, 34.5658, 37.4453, 34.9124, 36.502, 22.1635, 38.5383, 23.3916, 38.2897, 25.6163, 48.2363, 35.6119, 34.7481, 44.27, 37.0183, 39.41, 38.0828, 23.1277, 37.0359, 38.4858, 38.9358, 23.6193, 46.8719, 40.1399, 22.8728, 30.9113, 37.7701, 36.2814, 26.6895, 30.6263, 36.9836, 24.2591, 37.9007, 37.9799, 38.9564, 36.5047, 41.7957, 27.9951, 25.053, 27.6909, 43.9673, 24.5032, 39.5054, 37.8615, 35.9423, 38.619, 37.9351, 37.8683, 31.0504, 22.0628, 27.1157, 26.3164, 38.6457, 37.0103, 23.4718, 33.7663, 36.3533, 24.5004, 26.9949, 36.557, 22.3775, 37.9416, 37.9841, 39.2836, 23.721, 22.4776, 38.0658, 39.3237, 40.0892, 39.7119, 38.4682, 26.3363, 26.3815, 23.4372, 26.047, 20.8414, 24.616, 40.1376, 25.7408, 23.4792, 37.7604, 39.3658, 26.1708, 36.437, 34.5851, 38.6084, 19.3441, 24.6907, 37.2241, 23.3228, 23.0505, 28.7232, 21.8526, 38.0228, 44.1874, 38.1024, 37.1256, 35.8092, 38.1329, 22.3352, 23.7784, 40.7695, 38.0694, 45.7686, 38.3804, 38.3849, 27.7527, 22.9307, 26.5477, 23.4338, 37.6273, 34.7201, 36.9985, 39.8151, 19.0372, 38.3198, 37.9752, 37.7526, 39.1773, 21.6172, 39.0887, 39.5275, 23.9475, 38.1536, 34.8839, 18.4199, 38.7206, 23.746, 47.8804, 26.1984, 50.5667, 26.7723, 45.1714, 26.3342, 39.2832, 38.029, 24.7265, 37.9987, 40.5723, 39.2618, 36.2221, 40.9717, 27.2388, 37.9383, 36.1148, 35.9427, 38.7048, 38.2621, 27.2116, 42.0608, 23.6861, 39.2694, 22.3017, 36.378, 36.2965, 39.5204, 43.9749, 22.2198, 23.9062, 22.3067, 39.0786, 35.5782, 40.8035, 39.1468, 38.8663, 39.9514, 38.6803, 36.0708, 37.1341, 36.464, 39.8634, 37.9398, 36.8624, 39.8489, 24.367, 37.3757, 30.5009, 23.3974, 35.5077, 21.8662, 23.1499, 23.0825, 39.4323, 37.7492, 30.5783, 39.5503, 39.4812, 38.0887, 37.0749, 33.7116, 38.4042, 37.7562, 24.8695, 38.2639, 26.3909, 39.4905, 36.578, 24.5218, 39.8189, 43.2181, 35.8511, 39.9435, 42.8781, 24.6817, 39.8728, 38.1338, 39.9905, 35.3678, 26.86, 26.3584, 25.2499, 27.595, 38.7914, 34.4727, 39.0524, 22.5833, 32.2056, 39.561, 40.1884, 22.2915, 38.7952, 43.7826, 37.6546, 39.1221, 19.2429, 24.1736, 24.4702, 38.1993, 22.0974, 32.9421, 25.8308, 30.9694, 40.5515, 37.3885, 37.8136, 36.5796, 41.0896, 19.7738, 34.5568, 23.962, 26.9052, 23.8334, 22.1539, 38.5162, 38.0584, 24.1169, 37.0017, 25.4831, 42.7918, 22.864, 40.9942, 27.3401, 18.6151, 39.2922, 40.0121, 34.1418, 25.3595, 24.8391, 22.1888, 38.3242, 27.1746, 30.6344, 27.8886, 41.5417, 26.8377, 23.2538, 35.0675, 26.8794, 37.836, 24.095, 24.1989, 32.3227, 45.9313, 38.0808, 37.6063, 44.05, 23.3129, 33.8614, 41.68, 41.2136, 26.6247, 25.8864, 21.9053, 24.5738, 25.5909, 40.783, 43.3198, 19.9327, 37.9763, 41.7676, 39.9534, 19.1607, 25.6063, 37.9033, 34.943, 27.35, 39.9703, 27.012, 34.0622, 35.7166, 39.4062, 35.4969, 22.7073, 28.2582, 34.7847, 22.6174, 39.3512, 39.2012, 33.032, 24.8345, 37.7051, 22.2479, 23.0636, 32.5992, 36.4609, 38.86, 26.8239, 39.753, 19.4275, 23.0093, 34.8537, 24.4166, 38.0094, 24.2752, 23.8099, 25.3561, 19.3908, 33.1871, 22.4546, 23.6012, 40.1149, 26.6615, 35.5885, 28.039, 37.4377, 47.1601, 37.8917, 39.7866, 38.6951, 28.1887, 34.009, 22.9764, 35.6634, 41.0955, 37.6306, 36.9996, 44.6961, 38.8967, 37.7952, 24.6168, 26.2663, 22.9745, 38.206, 27.3576, 34.7015, 37.9356, 33.0166, 35.7056, 41.3351, 26.4497, 35.7033, 36.0448, 26.4727, 25.1494, 38.0605, 37.8364, 24.8098, 26.621, 35.7754, 40.1759, 23.2524, 39.652, 34.9016, 43.834, 39.4343, 40.7158, 25.7716, 37.4509, 35.3041, 37.9766, 23.1427, 36.5643, 34.7356, 24.5067, 37.8572, 35.9167, 42.2357, 39.7034, 39.7804, 27.7607, 19.5283, 41.2636, 19.6593, 36.2979, 25.6988, 26.524, 27.3649, 27.454, 39.9373, 27.1892, 35.2695, 28.2939, 26.997, 27.7814, 38.5077, 26.4789, 44.1977, 42.2552, 37.1411, 41.0354, 37.7773, 35.9484, 25.6539, 23.4558, 24.9692, 41.0937, 37.8286, 37.2739, 41.5494, 26.1274, 26.8272, 24.6642, 25.6681, 26.2697, 38.1584, 34.0629, 24.9232, 25.974, 25.9644, 37.6043, 40.0186, 35.6613, 26.8394, 40.5004, 37.5777, 36.0608, 38.2833, 39.3831, 24.6011, 37.442, 35.5307, 27.0782, 36.4008, 35.6871, 40.6239, 23.9423, 23.663, 18.9524, 25.8061, 37.0165, 35.706, 33.3792, 26.6549, 37.5546, 38.3107, 40.8754, 35.2698, 27.1548, 23.9918, 31.2322758 ], "lon": [ 121.4667, 113.259, 116.3914, 114.054, 112.5292, 115.4845, 104.0633, 118.3425, 117.2056, 114.5086, 114.6418, 114.4894, 119.1, 114.2881, 115.4333, 114.9336, 117.1859, 116.9833, 113.1056, 106.5528, 125.2, 114.0253, 121.5492, 116.8452, 118.7667, 117.2808, 110.4031, 112.5857, 120.8873, 120.1339, 108.315, 108.9, 123.4258, 118.1742, 113.6605, 115.6467, 121.2664, 114.0672, 117.9633, 112.4245, 105.2863, 118.5858, 120.1675, 114.875, 110.9178, 102.7061, 106.0784, 106.9336, 116.3649, 116.5078, 111.6839, 115.9833, 103.8029, 120.4, 107.4947, 112.1531, 113.8851, 117.0809, 110.1507, 116.3105, 111.5953, 126.9808, 123.9512, 119.6494, 116.6941, 109.4684, 118.2831, 120.6164, 103.7144, 121.5397, 117.6612, 115.7742, 115.8872, 108.7167, 119.9, 109.9592, 114.9793, 104.7385, 113.911, 120.5833, 110.998, 113.2999, 114.4152, 119.1331, 119.1801, 113.0267, 110.2833, 116.0021, 117.0333, 114.3403, 113.0833, 119.9692, 120.2833, 118.0497, 120.75, 121.6, 115.686, 126.6333, 119.4363, 104.64, 116.1191, 118.9223, 106.7078, 116.7006, 114.8811, 111.5087, 120.6561, 105.4409, 113.8201, 105.0635, 104.6397, 112.4667, 111.2803, 109.6092, 118.0819, 118.3115, 116.3577, 113.1469, 111.9974, 104.395, 118.3622, 118.0125, 109.4281, 107.1751, 106.6336, 107.026, 117.55, 103.8318, 117.9322, 115.03, 105.5737, 113.2304, 117.3531, 105.7311, 112.5425, 120.4486, 108.085, 103.7575, 109.7388, 124.3644, 113.097, 119.5881, 119.4551, 87.6125, 122.264, 114.6923, 109.1885, 108.6167, 112.7233, 121.1292, 123.8365, 113.5927, 115.3331, 104.6263, 119.5167, 125.008, 119.0103, 120.0958, 111.3167, 112.9228, 104.7645, 129.5997, 120.8378, 119.4331, 109.8345, 118.1728, 116.63, 117.0244, 111.6629, 105.349, 122.1, 118.7518, 117.6302, 111.9627, 99.169, 114.0109, 107.64, 105.8398, 115.0326, 126.55, 120.83, 100.0871, 117.0164, 124.3833, 109.9244, 130.3653, 102.5432, 105.934, 122.2297, 111.195, 118.3605, 106.6819, 118.8763, 116.789, 101.7787, 109.4863, 116.1586, 119.9167, 118.5792, 109.2333, 123.8917, 113.85, 107.3667, 111.5478, 130.965, 121.6486, 113.5678, 102.6329, 123.1772, 104.1766, 110.32, 118.7734, 127.4886, 112.4292, 108.4, 120.9766, 106.2254, 117.15, 117.2036, 123.761, 110.4844, 109.1, 131.1545, 120.7333, 110.2794, 118.3811, 115.7833, 121.2665, 110.0833, 110.0806, 118.3151, 118.0097, 120.5512, 117.4849, 106.2782, 120.6526, 114.2887, 110.8481, 120.9621, 119.9556, 112.554, 121.3718, 111.7351, 119.3735, 117.78, 126.5451, 110.6294, 122.7474, 117, 119.03, 106.1919, 100.4553, 120.5634, 119.8404, 128.8893, 117.6667, 113.1667, 100.2208, 120.2653, 116.4459, 120.0698, 105.92, 104.8333, 114.9242, 114.9845, 111.6659, 120.2314, 112.8457, 101.7149, 113.4, 113.4733, 122.0988, 109.0235, 130.2775, 121.1546, 113.8274, 124.8088, 120.0142, 119.3801, 114.8842, 105.1884, 118.7333, 121.1409, 121.9972, 112.5853, 110.9369, 112.7581, 114.8994, 120.3037, 113.4042, 119.575, 125.9773, 109.5833, 98.5049, 110.7749, 121.6574, 112.785, 119.1072, 116.772, 112.839, 131.0063, 105.3784, 118.3369, 118.4797, 108.9378, 114.9699, 109.2674, 122.9664, 91.1, 119.9625, 111.7846, 114.35, 120.7136, 114.35, 119.75, 120.4604, 119.9333, 126.9632, 115.0189, 112.73, 125.6965, 108.9422, 113.1087, 116.1008, 113.4653, 114.1847, 120.5474, 119.4432, 116.0897, 112.3913, 114.735, 112.9854, 120.6833, 120.2282, 113.3796, 112.5223, 104.9011, 117.7353, 119.9519, 111.0186, 111.7732, 120.5333, 104.7406, 115.7061, 113.7249, 113.8229, 113.7975, 124.8738, 117.9593, 110.6293, 112.5833, 106.3694, 105.972, 118.6973, 117.7424, 120.0284, 110.8786, 113.6783, 117.7667, 112.6877, 102.2706, 121.1043, 122.5021, 118.6434, 106.0327, 113.0745, 122.3499, 117.2167, 113.7693, 120.2547, 120.8176, 106.4133, 88.8799, 121.0104, 103.624, 122.4867, 113.0424, 114.98, 112.3595, 116.9507, 126.95, 103.8166, 117.2083, 98.4972, 115.5539, 116.9833, 115.8678, 116.0333, 113.1079, 105.2868, 116.1944, 113.392, 120.8333, 116.386, 89.1822, 114.4753, 125.678, 119.1595, 121.2288, 115.2118, 109.5019, 115.5375, 115.9918, 97.1777, 112.6956, 104.28, 101.5436, 127.962, 116.57, 119.3904, 112.4037, 119.6333, 93.5155, 120.396, 119.3957, 110.75, 115.5541, 119.1619, 115.3618, 111.791, 118.6978, 86.1527, 117.3329, 120.2, 126.0561, 113.448, 112.23, 80.25, 117.9899, 81.3167, 116.6403, 125.3252, 100.7948, 125.1381, 112.9578, 110.4642, 121.7932, 129.5067, 112.2551, 112.3131, 121.3558, 75.9833, 116.5689, 109.95, 123.33, 114.0593, 120.7621, 107.5143, 112.7134, 114.502, 112.9259, 128.2333, 104.2437, 104.1994, 106.8114, 115.3803, 121.45, 111.6695, 126.5037, 132.0341, 111.7718, 106.4646, 118.6225, 103.1545, 118.3215, 126.7388, 127.337, 112.9317, 119.2853, 110.4417, 111.5098, 129.4621, 115.0243, 122.7765, 87.2961, 131.8666, 129.3825, 113.3472, 123.5003, 115.6611, 124.2863, 105.1907, 103.3881, 111.7793, 92.0569, 104.1695, 108.0351, 111.9103, 81.35, 112.1, 110.706, 110.4292, 124.82, 84.8711, 128.045, 111.4505, 112.3735, 86.0333, 77.25, 118.9861, 111.4279, 115.3204, 112.7852, 116.8036, 122.7365, 106.7756, 126.1408, 104.6394, 110.3902, 120.7283, 97.73, 102.4778, 126.4179, 113.2302, 117.777, 119.8133, 130.5212, 122.0719, 113.0946, 108.0764, 79.9327, 103.2585, 113.5203, 109.7318, 123.61, 107.5087, 109.03, 111.7176, 113.08, 117.4869, 103.2167, 113.2018, 110.0866, 111.8746, 117.4525, 113.1565, 117.4148, 76.1753, 110.499, 118.0267, 105.6946, 82.0726, 98.2862, 130.3585, 113.0684, 126.1815, 112.17, 94.9042, 113.353, 131.1187, 121.25, 125.8443, 113.88, 129.0039, 106.6545, 94.6616, 98.8562, 129.4197, 102.8097, 126.9137, 114.0927, 102.9149, 108.6391, 84.9012, 116.2672, 87.9793, 100.9782, 113.2182, 82.979, 114.5771, 113.8693, 111.6743, 116.6028, 111.8609, 113.1445, 108.05, 88.1166, 110.0058, 125.1702, 115.7774, 106.769, 110.8136, 126.28, 114.0603, 113.2803, 101.9667, 114.7775, 112.027, 116.0139, 113.853, 129.8413, 115.5663, 111.0683, 105.0451, 115.6591, 114.1293, 129.2577, 100.5505, 114.23, 113.3161, 120.3645, 116.4055, 125.3529, 101.6736, 115.5126, 109.678, 108.8847, 110.3193, 82.9364, 118.6735, 109.9378, 121.5167, 103.8612, 109.5117, 123.18, 113.1933, 100.135, 116.5924, 101.502, 110.764, 102.496, 99.0653, 111.21, 113.249, 119.6506, 104.4181, 112.2837, 105.0573, 111.1203, 116.2435, 129.7572, 118.62, 116.5679, 116.3152, 77.4162, 125.219, 111.7108, 106.309, 116.2388, 112.5679, 114.3159, 116.08, 116.6165, 116.7263, 79.7267, 106.2027, 111.4633, 127.106, 111.2304, 106.6801, 112.1767, 107.2075, 116.2715, 114.3906, 119.6406, 106.1949, 116.7134, 116.0744, 119.5515, 112.3193, 119.5468, 106.339, 106.2465, 102.6767, 116.073, 114.141, 116.6433, 87.55, 113.7483, 112.0427, 101.3239, 113.074, 103.6301, 130.5759, 115.4954, 102.0742, 105.7001, 120.7212, 100.6846, 110.9877, 114.6853, 102.91, 113.6995, 116.915, 101.2356, 103.7624, 116.3167, 116.1205, 115.657, 112.9189, 104.6839, 99.9337, 110.3637, 110.0962, 111.2174, 111.5342, 112.48, 101.2759, 117.7264, 114.6517, 80.4144, 116.4728, 115.892, 110.8281, 114.7237, 108.7695, 112.7668, 109.9177, 89.4666, 104.3929, 103.228, 104.3433, 117.62, 115.7309, 110.3332, 130.2519, 119.2314, 111.0768, 120.172, 113.2729, 123.4161, 117.493, 103.9396, 114.6122, 114.3782, 114.4157, 126.276, 115.2087, 103.5461, 125.866, 104.4211, 113.5602, 126.0819, 105.1135, 108.5238, 101.9167, 115.8657, 114.962, 102.8031, 101.0826, 104.0571, 125.7404, 105.0531, 106.2496, 104.0306, 116.5941, 114.3775, 114.0865, 101.564, 101.9917, 114.941, 126.2614, 114.2834, 120.8872, 126.1, 114.3879, 105.0809, 114.6091, 120.3824, 111.5907, 107.9767, 114.8204, 106.7332, 113.5516, 111.6751, 100.7463, 115.7594, 131.1478, 105.656, 121.0518, 123.4978, 114.7394, 120.8009, 116.8538, 118.1057, 116.4876, 102.2167, 99.7043, 105.8215, 114.9804, 110.8517, 102.1082, 113.2217, 116.1096, 113.0755, 116.5472, 106.6795, 129.5059, 110.5746, 106.1269, 123.99, 115.5773, 115.9235, 115.0591, 104.7029, 115.6922, 112.9643, 115.7102, 112.0701, 127.5118, 118.303, 112.7802, 120.9573, 114.5312, 100.6131, 104.8043, 120.4409, 103.1265, 98.2826, 114.5035, 114.549, 116.1626, 112.3335, 81.8715, 103.5516, 100.5231, 107.1837, 119.357, 116.4046, 116.5642, 115.0575, 103.3146, 116.2681, 115.0838, 114.9478, 109.5167, 112.8292, 103.3817, 104.3893, 115.9438, 109.8243, 99.8336, 110.1305, 115.3048, 108.6667, 111.2708, 109.4731, 112.8008, 114.5928, 114.6909, 118.974, 102.8231, 112.7289, 115.1232, 115.9856, 119.6019, 118.9845, 116.8918, 105.9841, 107.1839, 104.6714, 106.7418, 109.8489, 97.8818, 94.6638, 108.9023, 115.6918, 114.6373, 116.3138, 105.848, 112.9794, 105.7262, 115.0568, 110.6096, 101.6382, 79.7964, 103.4354, 112.515, 120.019, 100.9265, 116.2845, 86.8946, 114.7658, 112.0664, 108.0121, 114.9421, 112.8018, 98.8253, 114.8549, 111.7911, 132.9746, 116.55, 106.2664, 103.8906, 111.7237, 106.0375, 114.4664, 114.5324, 109.0549, 110.8417, 119.0219, 109.8283, 114.7207, 115.2106, 114.8524, 116.3751, 110.0319, 115.6617, 115.8564, 115.5361, 115.3248, 105.2758, 109.8553, 113.2437, 104.899, 125.3, 107.7946, 123.7167, 107.8883, 82.5731, 105.9324, 116.1727, 115.2174, 112.2884, 114.0183, 115.0301, 116.3421, 115.3246, 115.2737, 105.185, 114.4453, 102.2476, 104.1717, 111.5601, 115.9504, 108.7463, 86.5686, 116.5284, 116.0797, 113.051, 106.0869, 115.2071, 112.8168, 81.5328, 112.8531, 116.6984, 113.1469, 116.1076, 107.3699, 80.37, 75.9411, 115.8124, 118.1511, 77.3106, 112.8744, 114.8833, 104.4513, 118.6645, 115.9499, 105.9915, 119.421, 116.274, 101.622, 120.3413, 115.8842, 102.0121, 110.6996, 99.2462, 116.3698, 116.0583, 115.2357, 120.8193, 116.1063, 116.0761, 114.556, 111.5541, 110.2575, 106.3567, 114.5834, 99.1067, 114.6789, 108.0764, 76.7389, 114.102, 112.3486, 118.188, 81.8372, 102.4788, 116.912, 89.9814, 102.6918, 117.939, 85.5333, 117.1037, 103.7074, 103.1306, 106.2347, 105.6589, 105.4174, 116.0917, 105.7062, 116.2017, 101.866, 96.4751, 115.9865, 118.1392, 113.3695, 115.8646, 82.5089, 114.7392, 115.9814, 110.612, 115.3268, 115.7723, 106.2284, 106.7567, 104.687, 106.5785, 120.8095, 117.6616, 115.5529, 114.7144, 111.7577, 108.2722, 110.3658, 105.9722, 103.1925, 98.8679, 115.9286, 110.7082, 114.5648, 115.2891, 98.3085, 111.8933, 104.8416, 88.6536, 114.5443, 118.8791, 105.502, 109.9308, 118.8143, 119.5262, 105.1214, 103.9143, 100.3122, 110.871, 114.8869, 105.3716, 120.3637, 107.2531, 82.604, 105.5292, 115.5815, 107.613, 105.3081, 116.6708, 113.7591, 112.9104, 108.3812, 83.6039, 106.0469, 78.2799, 80.8667, 102.2283, 109.874, 125.75, 79.2319, 106.0077, 106.3532, 110.7151, 103.113, 106.3163, 115.5754, 84.0147, 110.875, 114.6259, 109.9711, 119.5431, 110.5809, 107.0084, 115.8744, 105.8771, 105.02, 117.0013, 103.6042, 107.3127, 102.8771, 116.6126, 107.4914, 111.8223, 120.2118, 104.7762, 112.6275, 118.1039, 116.7168, 109.6099, 104.6721, 115.7883, 112.3794, 115.5467, 108.6148, 104.9936, 116.1244, 105.695, 114.0923, 108.8129, 114.5697, 109.8283, 116.3271, 116.8032, 98.4672, 103.203, 105.102, 110.4662, 107.048, 112.5832, 111.8238, 118.1375, 106.5485, 99.9866, 103.8584, 115.8463, 123.8, 115.711, 113.8239, 115.6067, 106.2086, 105.3416, 103.7982, 103.3923, 111.4408, 114.4857, 105.0029, 120.5123, 77.6529, 115.4905, 112.5945, 104.6671, 115.8343, 117.0239, 105.1535, 108.3295, 110.3566, 96.7333, 109.5855, 86.2614, 107.1359, 111.1029, 102.8343, 104.8126, 105.0802, 112.6701, 115.5016, 98.2961, 107.2398, 104.5345, 119.5909, 111.412, 117.8649, 111.521, 81.1581, 116.8386, 114.8733, 106.973, 115.4829, 104.6802, 77.3417, 103.5489, 105.6401, 101.5978, 112.8385, 109.4972, 103.8471, 122.9455, 116.8954, 118.2004, 100.6614, 109.6328, 117.8596, 110.846, 98.0937, 104.9614, 107.4755, 107.3684, 106.6649, 118.6401, 100.0488, 105.986, 106.6108, 106.4376, 108.0233, 100.8814, 105.1253, 86.8928, 86.8607, 114.2293, 116.9304, 110.5216, 102.0273, 106.7793, 103.6522, 104.9558, 119.0408, 102.5953, 104.1046, 113.5339, 102.4502, 103.9938, 112.2935, 105.872, 105.3089, 106.0661, 105.3672, 104.7218, 105.4233, 105.3376, 109.9024, 119.7878, 111.1049, 109.177, 95.8, 110.0658, 113.4128, 113.867, 118.7119, 114.9898, 103.3811, 105.0207, 105.5256, 106.7353, 105.2571, 118.1081, 116.7865, 101.8853, 108.6787, 109.2134, 111.4908, 104.1824, 104.9516, 108.5876, 114.9316, 110.3, 117.6978, 106.093, 99.8371, 112.2868, 121.4692071 ], "radius": 20, "type": "densitymapbox", "z": [ 1, 2, 1, 1, 9, 8, 1, 1, 1, 1, 9, 1, 9, 9, 3, 1, 4, 9, 9, 9, 9, 9, 1, 1, 1, 1, 1, 9, 1, 1, 6, 6, 9, 1, 1, 1, 9, 2, 9, 1, 1, 8, 9, 1, 1, 9, 9, 9, 7, 1, 7, 4, 1, 9, 1, 2, 1, 8, 9, 1, 9, 9, 1, 9, 9, 9, 9, 1, 1, 1, 6, 9, 5, 2, 1, 6, 9, 9, 9, 1, 8, 1, 1, 9, 1, 1, 9, 5, 9, 7, 9, 4, 1, 9, 5, 6, 6, 1, 1, 4, 1, 1, 9, 7, 1, 9, 8, 8, 9, 4, 1, 4, 9, 4, 5, 8, 9, 4, 9, 9, 8, 1, 1, 9, 9, 8, 1, 6, 1, 2, 1, 1, 9, 1, 4, 8, 9, 1, 3, 9, 4, 9, 9, 9, 5, 9, 9, 9, 9, 5, 9, 1, 9, 9, 7, 9, 5, 9, 9, 9, 9, 8, 9, 1, 9, 9, 1, 1, 8, 1, 9, 4, 7, 1, 9, 8, 9, 1, 1, 9, 6, 8, 9, 1, 1, 4, 9, 1, 1, 9, 4, 1, 8, 2, 7, 9, 1, 9, 1, 9, 8, 7, 9, 9, 9, 8, 9, 1, 1, 1, 9, 1, 1, 9, 9, 9, 6, 4, 1, 1, 9, 9, 9, 9, 9, 7, 8, 9, 2, 9, 9, 5, 4, 1, 1, 4, 9, 1, 9, 9, 7, 1, 1, 9, 1, 1, 8, 6, 9, 3, 1, 1, 1, 1, 9, 1, 1, 9, 9, 9, 1, 8, 7, 1, 9, 1, 6, 9, 1, 1, 6, 9, 1, 1, 1, 1, 4, 6, 9, 9, 9, 9, 4, 1, 9, 4, 5, 6, 5, 9, 6, 1, 9, 8, 9, 1, 1, 1, 1, 1, 9, 1, 2, 1, 4, 1, 9, 4, 9, 1, 7, 8, 9, 2, 6, 1, 5, 8, 9, 1, 1, 1, 5, 1, 9, 1, 1, 4, 9, 1, 1, 9, 6, 2, 1, 5, 8, 9, 1, 6, 1, 1, 1, 6, 1, 6, 9, 9, 1, 4, 4, 2, 8, 9, 5, 9, 1, 1, 1, 1, 1, 9, 9, 4, 8, 1, 9, 5, 9, 1, 1, 1, 7, 2, 9, 1, 9, 1, 8, 3, 9, 1, 4, 9, 9, 9, 9, 9, 9, 4, 6, 9, 2, 8, 1, 9, 5, 1, 9, 9, 1, 9, 8, 1, 9, 1, 1, 9, 3, 1, 9, 9, 3, 4, 9, 9, 1, 9, 9, 1, 1, 2, 9, 9, 8, 9, 7, 1, 8, 9, 4, 8, 3, 1, 1, 8, 1, 9, 5, 1, 9, 9, 5, 9, 1, 8, 7, 1, 1, 3, 5, 8, 1, 9, 9, 1, 9, 9, 8, 4, 1, 9, 8, 1, 1, 2, 1, 1, 1, 1, 9, 9, 9, 9, 2, 8, 9, 1, 9, 1, 1, 1, 9, 1, 9, 9, 6, 3, 3, 1, 8, 9, 9, 1, 7, 9, 9, 9, 1, 6, 7, 9, 1, 7, 1, 4, 6, 8, 9, 8, 1, 9, 7, 9, 1, 1, 1, 8, 9, 1, 9, 9, 9, 9, 9, 9, 9, 9, 2, 9, 9, 9, 1, 9, 1, 1, 1, 1, 6, 1, 9, 4, 9, 1, 1, 9, 9, 1, 7, 1, 9, 6, 1, 9, 8, 1, 9, 2, 9, 7, 2, 1, 1, 9, 1, 1, 1, 9, 1, 7, 4, 9, 1, 6, 1, 1, 8, 9, 7, 1, 7, 1, 7, 1, 7, 9, 1, 1, 1, 7, 1, 7, 1, 1, 1, 1, 2, 9, 9, 1, 9, 9, 6, 9, 9, 1, 9, 2, 1, 9, 1, 8, 3, 9, 6, 9, 9, 8, 1, 1, 1, 1, 1, 9, 1, 9, 4, 2, 2, 6, 1, 1, 1, 1, 1, 9, 6, 2, 9, 9, 9, 5, 1, 9, 9, 1, 1, 1, 9, 8, 1, 9, 1, 4, 6, 4, 5, 1, 9, 9, 1, 3, 9, 9, 1, 1, 8, 9, 1, 2, 1, 9, 1, 9, 1, 2, 1, 1, 1, 8, 1, 9, 1, 1, 9, 9, 2, 2, 9, 1, 1, 1, 9, 1, 1, 9, 1, 1, 1, 1, 9, 9, 9, 1, 1, 1, 1, 1, 1, 9, 9, 1, 1, 9, 9, 1, 9, 9, 1, 9, 1, 1, 1, 1, 9, 9, 9, 2, 1, 8, 1, 7, 9, 9, 9, 1, 9, 7, 1, 9, 1, 9, 1, 4, 9, 1, 1, 9, 4, 9, 6, 7, 1, 1, 1, 1, 1, 9, 1, 1, 9, 1, 1, 1, 9, 9, 9, 1, 1, 1, 9, 1, 2, 1, 1, 1, 9, 1, 1, 8, 7, 2, 2, 1, 5, 9, 8, 9, 9, 9, 9, 2, 1, 1, 1, 1, 4, 1, 9, 1, 9, 1, 1, 1, 2, 9, 2, 9, 8, 1, 1, 9, 1, 6, 9, 1, 1, 9, 1, 2, 1, 1, 2, 1, 1, 1, 2, 3, 1, 1, 8, 9, 1, 9, 1, 9, 1, 1, 1, 2, 1, 7, 2, 7, 1, 1, 1, 1, 1, 1, 1, 9, 9, 2, 1, 1, 6, 6, 1, 1, 1, 1, 2, 4, 9, 9, 9, 8, 4, 1, 1, 4, 1, 6, 1, 9, 1, 1, 1, 1, 8, 9, 9, 1, 1, 9, 6, 1, 1, 7, 8, 1, 1, 1, 9, 9, 8, 3, 9, 8, 1, 1, 1, 6, 9, 9, 1, 8, 1, 7, 2, 9, 9, 2, 1, 1, 9, 9, 1, 9, 9, 9, 1, 9, 1, 9, 9, 7, 8, 1, 1, 1, 4, 6, 1, 1, 8, 8, 9, 8, 9, 9, 9, 1, 9, 1, 6, 6, 7, 3, 7, 1, 1, 2, 1, 1, 9, 1, 9, 2, 9, 9, 2, 9, 1, 1, 1, 9, 8, 5, 2, 1, 9, 9, 9, 5, 9, 2, 3, 1, 9, 6, 8, 1, 7, 9, 2, 1, 9, 9, 1, 9, 8, 9, 4, 2, 1, 1, 9, 9, 8, 9, 8, 1, 9, 8, 8, 1, 1, 9, 1, 1, 9, 1, 9, 9, 1, 9, 2, 1, 1, 2, 9, 1, 6, 1, 3, 1, 1, 1, 1, 9, 9, 9, 1, 2, 1, 9, 9, 2, 9, 2, 8, 9, 3, 1, 1, 2, 9, 9, 2, 6, 9, 2, 4, 9, 9, 1, 6, 2, 2, 5, 1, 1, 1, 2, 1, 9, 9, 1, 1, 9, 1, 1, 6, 9, 2, 7, 1, 9, 1, 9, 1, 2, 1, 1, 4, 1, 1, 1, 9, 9, 2, 8, 1, 1, 8, 2, 1, 3, 1, 1, 5, 9, 9, 9, 3, 1, 9, 1, 9, 9, 1, 4, 3, 2, 1, 8, 5, 9, 8, 9, 3, 1, 3, 5, 2, 9, 9, 4, 9, 1, 8, 9, 8, 2, 6, 4, 1, 1, 1, 1, 7, 2, 2, 4, 4, 1, 9, 2, 9, 1, 5, 3, 2, 9, 1, 1, 9, 5, 1, 9, 9, 4, 9, 9, 8, 1, 2, 4, 9, 8, 1, 2, 1, 1, 9, 1, 1, 8, 1, 5, 9, 9, 7, 3, 9, 7, 2, 1, 1, 8, 1, 1, 9, 9, 1, 6, 7, 9, 3, 6, 6, 9, 2, 4, 1, 9, 9, 5, 8, 1, 1, 1, 1, 1, 1, 1, 9, 1, 1, 1, 8, 1, 2, 9, 5, 1, 9, 2, 1, 2, 1, 4, 4, 2, 9 ] } ], "layout": { "mapbox": { "center": { "lat": 28, "lon": 112 }, "style": "stamen-terrain", "zoom": 3 }, "margin": { "b": 0, "l": 0, "r": 0, "t": 0 }, "template": { "data": { "bar": [ { "error_x": { "color": "#2a3f5f" }, "error_y": { "color": "#2a3f5f" }, "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "bar" } ], "barpolar": [ { "marker": { "line": { "color": "#E5ECF6", "width": 0.5 }, "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "barpolar" } ], "carpet": [ { "aaxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "baxis": { "endlinecolor": "#2a3f5f", "gridcolor": "white", "linecolor": "white", "minorgridcolor": "white", "startlinecolor": "#2a3f5f" }, "type": "carpet" } ], "choropleth": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "choropleth" } ], "contour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "contour" } ], "contourcarpet": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "contourcarpet" } ], "heatmap": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmap" } ], "heatmapgl": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "heatmapgl" } ], "histogram": [ { "marker": { "pattern": { "fillmode": "overlay", "size": 10, "solidity": 0.2 } }, "type": "histogram" } ], "histogram2d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2d" } ], "histogram2dcontour": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "histogram2dcontour" } ], "mesh3d": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "type": "mesh3d" } ], "parcoords": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "parcoords" } ], "pie": [ { "automargin": true, "type": "pie" } ], "scatter": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter" } ], "scatter3d": [ { "line": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatter3d" } ], "scattercarpet": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattercarpet" } ], "scattergeo": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergeo" } ], "scattergl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattergl" } ], "scattermapbox": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scattermapbox" } ], "scatterpolar": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolar" } ], "scatterpolargl": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterpolargl" } ], "scatterternary": [ { "marker": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "type": "scatterternary" } ], "surface": [ { "colorbar": { "outlinewidth": 0, "ticks": "" }, "colorscale": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "type": "surface" } ], "table": [ { "cells": { "fill": { "color": "#EBF0F8" }, "line": { "color": "white" } }, "header": { "fill": { "color": "#C8D4E3" }, "line": { "color": "white" } }, "type": "table" } ] }, "layout": { "annotationdefaults": { "arrowcolor": "#2a3f5f", "arrowhead": 0, "arrowwidth": 1 }, "autotypenumbers": "strict", "coloraxis": { "colorbar": { "outlinewidth": 0, "ticks": "" } }, "colorscale": { "diverging": [ [ 0, "#8e0152" ], [ 0.1, "#c51b7d" ], [ 0.2, "#de77ae" ], [ 0.3, "#f1b6da" ], [ 0.4, "#fde0ef" ], [ 0.5, "#f7f7f7" ], [ 0.6, "#e6f5d0" ], [ 0.7, "#b8e186" ], [ 0.8, "#7fbc41" ], [ 0.9, "#4d9221" ], [ 1, "#276419" ] ], "sequential": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ], "sequentialminus": [ [ 0, "#0d0887" ], [ 0.1111111111111111, "#46039f" ], [ 0.2222222222222222, "#7201a8" ], [ 0.3333333333333333, "#9c179e" ], [ 0.4444444444444444, "#bd3786" ], [ 0.5555555555555556, "#d8576b" ], [ 0.6666666666666666, "#ed7953" ], [ 0.7777777777777778, "#fb9f3a" ], [ 0.8888888888888888, "#fdca26" ], [ 1, "#f0f921" ] ] }, "colorway": [ "#636efa", "#EF553B", "#00cc96", "#ab63fa", "#FFA15A", "#19d3f3", "#FF6692", "#B6E880", "#FF97FF", "#FECB52" ], "font": { "color": "#2a3f5f" }, "geo": { "bgcolor": "white", "lakecolor": "white", "landcolor": "#E5ECF6", "showlakes": true, "showland": true, "subunitcolor": "white" }, "hoverlabel": { "align": "left" }, "hovermode": "closest", "mapbox": { "style": "light" }, "paper_bgcolor": "white", "plot_bgcolor": "#E5ECF6", "polar": { "angularaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "radialaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "scene": { "xaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "yaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" }, "zaxis": { "backgroundcolor": "#E5ECF6", "gridcolor": "white", "gridwidth": 2, "linecolor": "white", "showbackground": true, "ticks": "", "zerolinecolor": "white" } }, "shapedefaults": { "line": { "color": "#2a3f5f" } }, "ternary": { "aaxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "baxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" }, "bgcolor": "#E5ECF6", "caxis": { "gridcolor": "white", "linecolor": "white", "ticks": "" } }, "title": { "x": 0.05 }, "xaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 }, "yaxis": { "automargin": true, "gridcolor": "white", "linecolor": "white", "ticks": "", "title": { "standoff": 15 }, "zerolinecolor": "white", "zerolinewidth": 2 } } } } }, "text/html": [ "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import plotly.graph_objects as go\n", "import plotly.offline as pyo\n", "pyo.init_notebook_mode()\n", "fig = go.Figure(go.Densitymapbox(lat=df.latitude, lon=df.longitude, z=df.cloudcover,\n", " radius=20))\n", "fig.update_layout(mapbox_style=\"stamen-terrain\", mapbox_center_lon=112,mapbox_center_lat=28,mapbox_zoom=3)\n", "fig.update_layout(margin={\"r\":0,\"t\":0,\"l\":0,\"b\":0})\n", "fig.show()" ] }, { "cell_type": "markdown", "id": "890cd2d6", "metadata": {}, "source": [ "## 总结\n", "至此我们就完成了该项目。当然了由于是入门级教程,很多内容只涉及到相关的点,没有进一步深入。\n", "\n", "不过我个人认为,这是最快的学习方式,就是实践中不断学习,然后总结,再学习。" ] }, { "cell_type": "code", "execution_count": null, "id": "419a7f93", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "dash", "language": "python", "name": "dash" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.6" } }, "nbformat": 4, "nbformat_minor": 5 }