{"id":89229,"date":"2026-08-02T17:25:04","date_gmt":"2026-08-02T09:25:04","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/89229.html"},"modified":"2026-08-02T17:25:04","modified_gmt":"2026-08-02T09:25:04","slug":"%e5%9f%ba%e4%ba%8epython%e7%9a%84%e5%9f%8e%e5%b8%82%e5%86%85%e6%b6%9d%e7%a7%af%e6%b6%9d%e7%9b%91%e6%b5%8b%e6%95%b0%e6%8d%ae%e5%8f%af%e8%a7%86%e5%8c%96%e5%88%86%e6%9e%90%e7%b3%bb%e7%bb%9f","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/89229.html","title":{"rendered":"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf"},"content":{"rendered":"<h2>\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u6bd5\u4e1a\u8bba\u6587<\/h2>\n<p>\u6bd5\u4e1a\u8bbe\u8ba1<\/p>\n<hr \/>\n<h3>\u4e00\u3001\u9879\u76ee\u540d\u79f0&#xff1a;<\/h3>\n<p>\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf<\/p>\n<hr \/>\n<h3>\u3010\u6458\u8981\u3011<\/h3>\n<p>\u57ce\u5e02\u5185\u6d9d\u662f\u6c5b\u671f\u516c\u5171\u5b89\u5168\u4e0e\u5e02\u653f\u6392\u6c34\u7ba1\u7406\u7684\u91cd\u8981\u8bae\u9898\u3002\u79ef\u6c34\u6df1\u5ea6\u3001\u5c0f\u65f6\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u7b49\u6307\u6807\u76f8\u4e92\u5173\u8054&#xff0c;\u4f46\u539f\u59cb\u6570\u636e\u5f80\u5f80\u5206\u6563\u5728\u6c14\u8c61\u63a5\u53e3\u3001\u6613\u6d9d\u70b9\u540d\u5f55\u4e0e\u6c34\u52a1\u76d1\u6d4b\u5e73\u53f0\u4e2d&#xff0c;\u5b58\u5728\u53e3\u5f84\u4e0d\u4e00\u3001\u96be\u4ee5\u6a2a\u5411\u5bf9\u6bd4\u3001\u7f3a\u5c11\u8d8b\u52bf\u7814\u5224\u7b49\u95ee\u9898\u3002\u672c\u6587\u8bbe\u8ba1\u5e76\u5b9e\u73b0\u4e86\u57fa\u4e8e Python \u4e0e Django \u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf&#xff0c;\u9762\u5411\u6559\u5b66\u4e0e\u8bfe\u9898\u6f14\u793a\u573a\u666f&#xff0c;\u5c06\u591a\u6e90\u6570\u636e\u6c47\u805a\u3001\u6e05\u6d17\u5165\u5e93\u540e&#xff0c;\u4ee5\u4ea4\u4e92\u5f0f\u56fe\u8868\u652f\u6491\u6c5b\u60c5\u6001\u52bf\u7814\u5224\u4e0e\u7ed3\u6784\u5206\u6790\u3002<\/p>\n<p>\u7cfb\u7edf\u91c7\u7528 B\/S \u67b6\u6784&#xff0c;\u540e\u7aef\u57fa\u4e8e Django 3.1.14&#xff0c;\u7ba1\u7406\u7aef\u96c6\u6210 SimpleUI&#xff1b;\u6570\u636e\u5e93\u4f7f\u7528 MySQL&#xff08;\u5e93\u540d waterlog&#xff09;&#xff1b;\u524d\u53f0\u57fa\u4e8e Bootstrap 5 \u4e0e ECharts 5 \u5b8c\u6210\u53ef\u89c6\u5316\u3002\u4e1a\u52a1\u6570\u636e\u4ee5 FloodRecord \u4e3a\u6838\u5fc3&#xff0c;\u8986\u76d6\u6df1\u5733\u5e02 40 \u4e2a\u6613\u6d9d\u6d4b\u7ad9\u30012024 \u5e74 5\u20149 \u6708\u6c5b\u671f\u5c0f\u65f6\u7ea7\u8bb0\u5f55&#xff0c;\u603b\u91cf\u7ea6 2.4 \u4e07\u6761&#xff0c;\u5b57\u6bb5\u5305\u542b\u6d4b\u7ad9\u7f16\u7801\/\u540d\u79f0\u3001\u884c\u653f\u533a\/\u8857\u9053\u3001\u7ecf\u7eac\u5ea6\u3001\u76d1\u6d4b\u65f6\u95f4\u3001\u6c34\u4f4d\u3001\u9884\u8b66\u6c34\u4f4d\u3001\u5c0f\u65f6\/\u65e5\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u53ca\u662f\u5426\u79ef\u6c34\u7b49\u3002\u5c0f\u65f6\u964d\u96e8\u6765\u81ea Open-Meteo Archive API \u771f\u5b9e\u6570\u636e&#xff1b;\u79ef\u6c34\u6c34\u4f4d\u57fa\u4e8e\u771f\u5b9e\u964d\u96e8\u4e0e\u70b9\u4f4d\u6392\u6c34\u654f\u611f\u5ea6\u4f30\u7b97&#xff08;\u8bba\u6587\u6b63\u6587\u5df2\u8bf4\u660e&#xff0c;\u4e0d\u4ee3\u8868\u6c34\u52a1\u5c40\u5b9e\u6d4b\u4f20\u611f\u5668\u8bfb\u6570&#xff09;\u3002\u6570\u636e\u91c7\u96c6\u901a\u8fc7 scripts\/fetch_flood_data.py \u751f\u6210 CSV&#xff0c;\u518d\u7ecf\u7ba1\u7406\u547d\u4ee4 import_flood \u5165\u5e93&#xff1b;\u7cfb\u7edf\u672a\u63d0\u4f9b Web \u6570\u636e\u91c7\u96c6\u9875&#xff0c;\u65e0\u72ec\u7acb\u5927\u5c4f&#xff0c;\u65e0 Flask \u7ec4\u4ef6\u3002\u5206\u6790\u5c42\u4ee5 pandas\u3001NumPy \u805a\u5408&#xff0c;\u91c7\u7528 Spearman\/Pearson \u76f8\u5173\u3001IQR \u5f02\u5e38\u68c0\u6d4b&#xff0c;\u4ee5\u53ca\u7ebf\u6027\u5916\u63a8\u4e0e\u6ed1\u52a8\u5e73\u5747\u5bf9\u6c34\u4f4d\u8fdb\u884c\u793a\u610f\u6027\u9884\u6d4b\u3002\u7cfb\u7edf\u5165\u53e3\u4e3a manage.py&#xff0c;\u9ed8\u8ba4\u8fd0\u884c\u7aef\u53e3 8070&#xff1b;\u524d\u53f0\u767b\u5f55\u8def\u5f84\u4e3a \/app\/login\/&#xff0c;\u540e\u53f0\u4e3a \/admin\/&#xff0c;\u9ed8\u8ba4\u8d26\u53f7\u5206\u522b\u4e3a admin\/123456&#xff08;\u524d\u53f0 app.User&#xff09;\u4e0e admin\/admin123&#xff08;Django \u540e\u53f0&#xff09;\u3002\u4fa7\u680f\u6db5\u76d6\u6570\u636e\u603b\u89c8\u3001\u6c34\u4f4d\u5206\u6790\u3001\u964d\u96e8\u5206\u6790\u3001\u884c\u653f\u533a\u5bf9\u6bd4\u3001\u9884\u8b66\u5206\u6790\u3001\u65f6\u5e8f\u5206\u6790\u3001\u76f8\u5173\u6027\u5206\u6790\u3001\u6c34\u4f4d\u9884\u6d4b\u3001\u5f02\u5e38\u68c0\u6d4b\u3001\u6570\u636e\u5217\u8868\/\u5bfc\u51fa\u53ca\u4e2a\u4eba\u4fe1\u606f\u7ef4\u62a4\u7b49\u6a21\u5757\u3002utils \u5c42\u5c01\u88c5 waterlog_core\u3001waterlog_charts\u3001waterlog_constants&#xff0c;\u5206\u6790\u7ed3\u679c\u7ecf Bundle API \u4e00\u6b21\u8fd4\u56de\u591a\u56fe\u6570\u636e&#xff0c;\u672c\u5730\u5185\u5b58\u7f13\u5b58 WATERLOG_CACHE_TTL&#061;120 \u79d2\u3002<\/p>\n<p>\u6d4b\u8bd5\u4e0e\u8fd0\u884c\u7ed3\u679c\u8868\u660e&#xff0c;\u7cfb\u7edf\u80fd\u591f\u5b8c\u6210\u767b\u5f55\u9274\u6743\u3001\u591a\u7ef4\u7b5b\u9009\u5206\u6790\u3001\u56fe\u8868\u8054\u52a8\u4e0e CSV \u5bfc\u51fa\u95ed\u73af&#xff0c;\u754c\u9762\u6e05\u6670\u3001\u54cd\u5e94\u7a33\u5b9a&#xff0c;\u53ef\u4e3a\u57ce\u5e02\u5185\u6d9d\u76d1\u6d4b\u8bfe\u9898\u7814\u7a76\u4e0e\u6559\u5b66\u6f14\u793a\u63d0\u4f9b\u53ef\u7528\u7684\u53ef\u89c6\u5316\u5206\u6790\u652f\u6491\u3002<\/p>\n<p>\u3010\u5173\u952e\u8bcd\u3011 Django&#xff1b;\u57ce\u5e02\u5185\u6d9d&#xff1b;\u6570\u636e\u53ef\u89c6\u5316&#xff1b;ECharts&#xff1b;Spearman \u76f8\u5173<\/p>\n<h3>\u3010Abstract\u3011<\/h3>\n<p>Urban waterlogging is a critical issue for public safety and municipal drainage during flood seasons. Indicators such as water depth, hourly rainfall and warning grades are interrelated, yet raw data are often scattered across weather APIs, flood-prone site catalogs and water-authority platforms, which makes cross-site comparison and trend analysis difficult. This thesis designs and implements a Python- and Django-based urban waterlogging monitoring data visualization and analysis system for teaching and demonstration. Multi-source data are collected, cleaned and stored, then explored through interactive charts for situational awareness and structural analysis.<\/p>\n<p>The system follows a B\/S architecture. The backend is built with Django 3.1.14 and SimpleUI for administration; MySQL is used with database name waterlog; the frontend adopts Bootstrap 5 and ECharts 5. The core entity FloodRecord covers 40 monitoring stations in Shenzhen from May to September 2024 at hourly granularity (approximately 24,000 records), including station attributes, location, observation time, water level, warning threshold, rainfall, warning grade and flood flag. Hourly rainfall comes from the real Open-Meteo Archive API; water levels are estimated from rainfall and site sensitivity (not official sensor readings). Data are produced by scripts\/fetch_flood_data.py and imported via import_flood; there is no web-based data-fetch page, no standalone big screen and no Flask stack. Analysis relies on pandas and NumPy, with Spearman\/Pearson correlation, IQR outlier detection, and linear extrapolation plus moving average for illustrative forecasting. Entry point is manage.py, default port 8070; frontend login is \/app\/login\/, admin is \/admin\/, default accounts admin\/123456 and admin\/admin123. Sidebar modules include overview, water level, rainfall, district comparison, warning analysis, time series, correlation, prediction, anomaly detection, list\/export and profile settings. Utils packages waterlog_core, waterlog_charts and waterlog_constants; Bundle APIs return multi-chart payloads with local cache TTL of 120 seconds.<\/p>\n<p>Results show that authentication, multi-dimensional filtering, chart interaction and CSV export workflows work stably, providing practical support for urban waterlogging analysis courses and research demos.<\/p>\n<p>\u3010Keywords\u3011 Django; Urban Waterlogging; Data Visualization; ECharts; Spearman Correlation<\/p>\n<hr \/>\n<h3>\u76ee \u5f55<\/h3>\n<p>1 \u7eea \u8bba<\/p>\n<ul>\n<li>\n<p>1.1 \u8bfe\u9898\u7814\u7a76\u80cc\u666f<\/p>\n<\/li>\n<li>\n<p>1.2 \u8bfe\u9898\u7814\u7a76\u7684\u76ee\u7684\u3001\u610f\u4e49<\/p>\n<\/li>\n<li>\n<p>1.3 \u8bfe\u9898\u7684\u56fd\u5185\u5916\u7814\u7a76\u73b0\u72b6\u548c\u53d1\u5c55\u52a8\u6001<\/p>\n<\/li>\n<li>\n<p>1.4 \u7814\u7a76\u5185\u5bb9<\/p>\n<\/li>\n<li>\n<p>1.5 \u8bba\u6587\u7ed3\u6784\u5b89\u6392<\/p>\n<\/li>\n<\/ul>\n<p>2 \u5173\u952e\u6280\u672f<\/p>\n<ul>\n<li>\n<p>2.1 Django Web\u6846\u67b6<\/p>\n<ul>\n<li>\n<p>2.1.1 MTV\u6a21\u5f0f\u4e0e\u8def\u7531\u7ec4\u7ec7<\/p>\n<\/li>\n<li>\n<p>2.1.2 SimpleUI\u540e\u53f0\u7ba1\u7406<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>2.2 MySQL\u6570\u636e\u5e93<\/p>\n<ul>\n<li>\n<p>2.2.1 ORM\u4e0e\u7d22\u5f15\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>2.2.2 PyMySQL\u9a71\u52a8\u63a5\u5165<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>2.3 ECharts\u53ef\u89c6\u5316\u6280\u672f<\/p>\n<\/li>\n<li>\n<p>2.4 \u6570\u636e\u5206\u6790\u4e0e\u7b97\u6cd5\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>2.5 \u6570\u636e\u83b7\u53d6\u4e0e\u6c34\u4f4d\u4f30\u7b97<\/p>\n<\/li>\n<li>\n<p>2.6 \u6280\u672f\u7279\u8272\u4e0e\u521b\u65b0\u70b9<\/p>\n<\/li>\n<\/ul>\n<p>3 \u7cfb\u7edf\u5206\u6790\u4e0e\u8bbe\u8ba1<\/p>\n<ul>\n<li>\n<p>3.1 \u7cfb\u7edf\u603b\u4f53\u8bbe\u8ba1<\/p>\n<ul>\n<li>\n<p>3.1.1 \u7cfb\u7edf\u67b6\u6784\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.1.2 \u7cfb\u7edf\u6570\u636e\u6d41\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.1.3 \u7cfb\u7edf\u529f\u80fd\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>3.2 \u7cfb\u7edf\u8be6\u7ec6\u8bbe\u8ba1<\/p>\n<ul>\n<li>\n<p>3.2.1 \u7528\u6237\u8ba4\u8bc1\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.2.2 \u6570\u636e\u603b\u89c8\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.2.3 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.2.4 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.2.5 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<li>\n<p>3.2.6 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6a21\u5757\u8bbe\u8ba1<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>3.3 \u6570\u636e\u5e93\u8bbe\u8ba1<\/p>\n<ul>\n<li>\n<p>3.3.1 \u6570\u636e\u5e93\u5173\u7cfb\u8bbe\u8ba1<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>4 \u7cfb\u7edf\u5b9e\u73b0<\/p>\n<ul>\n<li>\n<p>4.0 \u7cfb\u7edf\u6574\u4f53\u5b9e\u73b0\u6d41\u7a0b<\/p>\n<\/li>\n<li>\n<p>4.1 \u7528\u6237\u8ba4\u8bc1\u6a21\u5757\u7684\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.2 \u6570\u636e\u603b\u89c8\u6a21\u5757\u7684\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.3 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6a21\u5757\u7684\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.4 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6a21\u5757\u7684\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.5 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6a21\u5757\u7684\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.6 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6a21\u5757\u7684\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.7 \u7528\u6237\u754c\u9762\u5b9e\u73b0<\/p>\n<\/li>\n<li>\n<p>4.8 \u7cfb\u7edf\u96c6\u6210\u4e0e\u90e8\u7f72<\/p>\n<\/li>\n<\/ul>\n<p>5 \u7cfb\u7edf\u6d4b\u8bd5<\/p>\n<ul>\n<li>\n<p>5.1 \u7cfb\u7edf\u529f\u80fd\u6d4b\u8bd5<\/p>\n<ul>\n<li>\n<p>5.1.1 \u7528\u6237\u8ba4\u8bc1\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/p>\n<\/li>\n<li>\n<p>5.1.2 \u6570\u636e\u7ba1\u7406\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/p>\n<\/li>\n<li>\n<p>5.1.3 \u6838\u5fc3\u4e1a\u52a1\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/p>\n<\/li>\n<li>\n<p>5.1.4 \u6570\u636e\u5206\u6790\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/p>\n<\/li>\n<li>\n<p>5.1.5 \u7cfb\u7edf\u96c6\u6210\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/p>\n<\/li>\n<li>\n<p>5.1.6 \u7528\u6237\u754c\u9762\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p>5.2 \u7cfb\u7edf\u6027\u80fd\u6d4b\u8bd5<\/p>\n<ul>\n<li>\n<p>5.2.1 \u54cd\u5e94\u65f6\u95f4\u6027\u80fd\u5206\u6790<\/p>\n<\/li>\n<li>\n<p>5.2.2 \u5e76\u53d1\u6027\u80fd\u6d4b\u8bd5<\/p>\n<\/li>\n<li>\n<p>5.2.3 \u6570\u636e\u5e93\u6027\u80fd\u6d4b\u8bd5<\/p>\n<\/li>\n<li>\n<p>5.2.4 \u6027\u80fd\u4f18\u5316\u63aa\u65bd<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>6 \u603b\u7ed3\u4e0e\u5c55\u671b<\/p>\n<ul>\n<li>\n<p>6.1 \u603b\u7ed3<\/p>\n<\/li>\n<li>\n<p>6.2 \u5c55\u671b<\/p>\n<\/li>\n<\/ul>\n<p>\u53c2\u8003\u6587\u732e<\/p>\n<p>\u81f4\u8c22<\/p>\n<hr \/>\n<h3>1 \u7eea \u8bba<\/h3>\n<h4>1.1 \u8bfe\u9898\u7814\u7a76\u80cc\u666f<\/h4>\n<p>\u6781\u7aef\u5929\u6c14\u9891\u53d1\u80cc\u666f\u4e0b&#xff0c;\u57ce\u5e02\u4f4e\u6d3c\u8def\u6bb5\u3001\u4e0b\u7a7f\u901a\u9053\u4e0e\u5730\u94c1\u53e3\u7b49\u6613\u6d9d\u70b9\u79ef\u6c34\u98ce\u9669\u6301\u7eed\u53d7\u5230\u5173\u6ce8\u3002\u7ba1\u7406\u90e8\u95e8\u3001\u79d1\u7814\u4eba\u5458\u4e0e\u6559\u5b66\u5b9e\u8df5\u5728\u5f00\u5c55\u5185\u6d9d\u5206\u6790\u65f6&#xff0c;\u901a\u5e38\u9700\u8981\u540c\u65f6\u67e5\u770b\u79ef\u6c34\u6df1\u5ea6\u3001\u5c0f\u65f6\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u4e0e\u7a7a\u95f4\u5206\u5e03\u7b49\u591a\u7c7b\u6307\u6807\u3002\u7136\u800c&#xff0c;\u516c\u5f00\u6570\u636e\u6765\u6e90\u5206\u6563&#xff1a;\u6c14\u8c61\u5c0f\u65f6\u964d\u6c34\u3001\u6613\u6d9d\u70b9\u540d\u5f55\u3001\u6c34\u52a1\u5c40\u79ef\u6d9d\u6c34\u4f4d\u63a5\u53e3\u5f80\u5f80\u5206\u5c5e\u4e0d\u540c\u5e73\u53f0&#xff0c;\u5b57\u6bb5\u547d\u540d\u4e0e\u65f6\u95f4\u7c92\u5ea6\u4e0d\u4e00\u81f4&#xff0c;\u624b\u5de5\u6c47\u603b\u6210\u672c\u9ad8&#xff0c;\u4e5f\u96be\u4ee5\u5f62\u6210\u53ef\u590d\u7528\u7684\u53ef\u89c6\u5316\u5206\u6790\u6d41\u7a0b\u3002<\/p>\n<p>\u6df1\u5733\u5e02\u4f5c\u4e3a\u6cbf\u6d77\u8d85\u5927\u57ce\u5e02&#xff0c;\u6c5b\u671f&#xff08;\u901a\u5e38\u4e3a 5\u20149 \u6708&#xff09;\u77ed\u65f6\u5f3a\u964d\u6c34\u6613\u5f15\u53d1\u9053\u8def\u79ef\u6c34\u3002\u5b98\u65b9\u300c\u5e02\u6c34\u52a1\u5c40\u79ef\u6d9d\u70b9\u6c34\u4f4d\u300d\u63a5\u53e3\u5728\u6df1\u5733\u5e02\u653f\u5e9c\u6570\u636e\u5f00\u653e\u5e73\u53f0\u53d1\u5e03&#xff0c;\u4f46\u6279\u91cf\u8c03\u7528\u9700\u7533\u8bf7 appKey&#xff1b;\u5728\u65e0\u5bc6\u94a5\u6761\u4ef6\u4e0b&#xff0c;\u8bfe\u9898\u6f14\u793a\u4ecd\u9700\u53ef\u672c\u5730\u90e8\u7f72\u3001\u53ef\u590d\u73b0\u7684\u6570\u636e\u6837\u672c\u3002\u57fa\u4e8e\u4e0a\u8ff0\u80cc\u666f&#xff0c;\u672c\u8bfe\u9898\u4ee5 Django \u4e3a\u4e3b\u6846\u67b6&#xff0c;\u6784\u5efa\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf&#xff1a;\u5c0f\u65f6\u964d\u96e8\u91c7\u7528 Open-Meteo \u771f\u5b9e\u5f52\u6863\u6570\u636e&#xff0c;\u79ef\u6c34\u6c34\u4f4d\u5728\u8bba\u6587\u4e2d\u660e\u786e\u6807\u6ce8\u4e3a\u4f30\u7b97\u503c&#xff0c;\u7528\u4e8e\u53ef\u89c6\u5316\u4e0e\u7b97\u6cd5\u6f14\u793a&#xff0c;\u4e0d\u4ee3\u8868\u6c34\u52a1\u5c40\u5b9e\u6d4b\u4f20\u611f\u5668\u8bfb\u6570\u3002<\/p>\n<p>\u5728\u6559\u5b66\u4e0e\u6bd5\u4e1a\u8bbe\u8ba1\u573a\u666f\u4e2d&#xff0c;\u8fd8\u5b58\u5728\u4ee5\u4e0b\u73b0\u5b9e\u9700\u6c42&#xff1a;\u4e00\u662f\u9700\u8981\u4e00\u5957\u53ef\u672c\u5730\u90e8\u7f72\u7684 Web \u7cfb\u7edf&#xff0c;\u7528\u7edf\u4e00\u5e93\u8868\u627f\u8f7d\u6d4b\u7ad9\u5c0f\u65f6\u7ea7\u5185\u6d9d\u6837\u672c&#xff1b;\u4e8c\u662f\u9700\u8981\u603b\u89c8\u3001\u6c34\u4f4d\u3001\u964d\u96e8\u3001\u884c\u653f\u533a\u3001\u9884\u8b66\u3001\u65f6\u5e8f\u3001\u76f8\u5173\u3001\u9884\u6d4b\u4e0e\u5f02\u5e38\u7b49\u5e38\u89c1\u5206\u6790\u89c6\u56fe&#xff0c;\u5e2e\u52a9\u5feb\u901f\u7406\u89e3\u201c\u54ea\u91cc\u6613\u6d9d\u3001\u96e8\u5cf0\u4e0e\u6c34\u4f4d\u5982\u4f55\u8054\u52a8\u3001\u9884\u8b66\u7ed3\u6784\u5982\u4f55\u201d&#xff1b;\u4e09\u662f\u9700\u8981\u811a\u672c\u5316\u6570\u636e\u83b7\u53d6\u4e0e CSV \u5bfc\u5165\u95ed\u73af&#xff0c;\u5f62\u6210\u201c\u62c9\u53d6\u2014\u5165\u5e93\u2014\u5206\u6790\u2014\u5c55\u793a\u201d\u6d41\u7a0b\u3002\u7cfb\u7edf\u4e0d\u63d0\u4f9b\u72ec\u7acb\u5927\u5c4f\u9875\u9762&#xff0c;\u4e5f\u4e0d\u91c7\u7528 Flask \u6280\u672f\u6808&#xff0c;\u805a\u7126\u5e38\u89c4 B\/S \u5206\u6790\u9875\u7684\u53ef\u89e3\u91ca\u8868\u8fbe\u3002<\/p>\n<h4>1.2 \u8bfe\u9898\u7814\u7a76\u7684\u76ee\u7684\u3001\u610f\u4e49<\/h4>\n<h5>1.2.1 \u7814\u7a76\u76ee\u7684<\/h5>\n<p>\u672c\u8bfe\u9898\u7684\u4e3b\u8981\u76ee\u7684\u5305\u62ec&#xff1a;<\/p>\n<li>\n<p>\u5efa\u7acb\u4ee5 FloodRecord \u4e3a\u6838\u5fc3\u7684\u57ce\u5e02\u5185\u6d9d\u76d1\u6d4b\u6570\u636e\u6a21\u578b&#xff0c;\u8986\u76d6\u6d4b\u7ad9\u533a\u4f4d\u3001\u6c34\u4f4d\u3001\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u4e0e\u662f\u5426\u79ef\u6c34\u7b49\u5b57\u6bb5&#xff0c;\u652f\u6491\u7edf\u4e00\u67e5\u8be2\u4e0e\u805a\u5408\u3002<\/p>\n<\/li>\n<li>\n<p>\u5b9e\u73b0\u524d\u53f0\u4f1a\u8bdd\u767b\u5f55\u3001\u4fa7\u680f\u5bfc\u822a\u4e0e\u591a\u5206\u6790\u9875\u5c55\u793a&#xff0c;\u8def\u7531\u7edf\u4e00\u6302\u8f7d\u5728 \/app\/ \u524d\u7f00\u4e0b&#xff0c;\u670d\u52a1\u7aef\u53e3\u4e3a 8070\u3002<\/p>\n<\/li>\n<li>\n<p>\u57fa\u4e8e pandas\/NumPy \u5b8c\u6210\u6c47\u603b\u3001Spearman\/Pearson \u76f8\u5173\u3001IQR \u5f02\u5e38\u68c0\u6d4b&#xff0c;\u4ee5\u53ca\u7ebf\u6027\u5916\u63a8\u4e0e\u6ed1\u52a8\u5e73\u5747\u7684\u793a\u610f\u6027\u6c34\u4f4d\u9884\u6d4b\u3002<\/p>\n<\/li>\n<li>\n<p>\u901a\u8fc7 scripts\/fetch_flood_data.py \u4e0e import_flood \u7ba1\u7406\u547d\u4ee4\u5b8c\u6210\u6570\u636e\u521d\u59cb\u5316&#xff1b;\u540e\u53f0 SimpleUI \u7ef4\u62a4\u76d1\u6d4b\u8bb0\u5f55\u4e0e\u524d\u53f0\u7528\u6237\u3002<\/p>\n<\/li>\n<li>\n<p>\u8f93\u51fa\u53ef\u8fd0\u884c\u3001\u53ef\u6f14\u793a\u7684\u5b8c\u6574\u7cfb\u7edf&#xff0c;\u9ed8\u8ba4\u524d\u53f0\u8d26\u53f7 admin\/123456\u3001\u540e\u53f0 admin\/admin123&#xff0c;\u4fbf\u4e8e\u9a8c\u6536\u4e0e\u4e8c\u6b21\u6269\u5c55\u3002<\/p>\n<\/li>\n<h5>1.2.2 \u7814\u7a76\u610f\u4e49<\/h5>\n<p>\u7406\u8bba\u610f\u4e49&#xff1a;\u5c06 Web \u5f00\u53d1\u3001\u6570\u636e\u5206\u6790\u4e0e\u53ef\u89c6\u5316\u65b9\u6cd5\u7ed3\u5408\u5230\u57ce\u5e02\u5185\u6d9d\u76d1\u6d4b\u4e3b\u9898\u4e2d&#xff0c;\u5f62\u6210\u201c\u6570\u636e\u6a21\u578b\u2014\u5206\u6790\u7b97\u6cd5\u2014\u56fe\u8868\u8868\u8fbe\u201d\u7684\u53ef\u590d\u7528\u8303\u5f0f&#xff0c;\u6709\u52a9\u4e8e\u7406\u89e3\u76f8\u5173\u5206\u6790\u3001\u5f02\u5e38\u68c0\u6d4b\u4e0e\u7b80\u5355\u5916\u63a8\u5728\u65f6\u95f4\u5e8f\u5217\u6f14\u793a\u4e2d\u7684\u9002\u7528\u8fb9\u754c\u3002<\/p>\n<p>\u5b9e\u8df5\u610f\u4e49&#xff1a;\u7cfb\u7edf\u628a\u6d4b\u7ad9\u5c5e\u6027\u3001\u4f30\u7b97\u6c34\u4f4d\u4e0e\u771f\u5b9e\u964d\u96e8\u843d\u5230\u540c\u4e00\u5f20\u4e1a\u52a1\u8868&#xff0c;\u964d\u4f4e\u624b\u5de5\u5904\u7406\u6210\u672c&#xff1b;\u5206\u6790\u9875\u901a\u8fc7 Bundle API \u4e00\u6b21\u8fd4\u56de\u591a\u56fe\u6570\u636e&#xff0c;\u4fbf\u4e8e\u524d\u7aef\u5feb\u901f\u6e32\u67d3&#xff1b;\u7f13\u5b58\u673a\u5236\u51cf\u8f7b\u91cd\u590d\u805a\u5408\u5f00\u9500\u3002<\/p>\n<p>\u793e\u4f1a\u610f\u4e49&#xff1a;\u53ef\u89c6\u5316\u7ed3\u679c\u6709\u52a9\u4e8e\u76f4\u89c2\u8ba4\u8bc6\u884c\u653f\u533a\u6613\u6d9d\u5dee\u5f02\u3001\u9884\u8b66\u7b49\u7ea7\u7ed3\u6784\u4e0e\u964d\u96e8\u2014\u6c34\u4f4d\u8054\u52a8\u5173\u7cfb&#xff0c;\u63d0\u5347\u516c\u4f17\u4e0e\u5b66\u751f\u5bf9\u57ce\u5e02\u9632\u6c5b\u8bae\u9898\u7684\u8ba4\u77e5\u3002<\/p>\n<p>\u7ecf\u6d4e\u610f\u4e49&#xff1a;\u672c\u5730\u5316\u90e8\u7f72\u4e0e\u5f00\u6e90\u6280\u672f\u6808\u964d\u4f4e\u8bfe\u9898\u6f14\u793a\u6210\u672c&#xff1b;\u6a21\u5757\u5316 utils \u8bbe\u8ba1\u4fbf\u4e8e\u540e\u7eed\u66ff\u6362\u6570\u636e\u6e90&#xff08;\u5982\u63a5\u5165\u5b98\u65b9 appKey \u771f\u5b9e\u6c34\u4f4d&#xff09;\u6216\u6269\u5c55\u6307\u6807&#xff0c;\u51cf\u5c11\u91cd\u590d\u5f00\u53d1\u6295\u5165\u3002<\/p>\n<h4>1.3 \u8bfe\u9898\u7684\u56fd\u5185\u5916\u7814\u7a76\u73b0\u72b6\u548c\u53d1\u5c55\u52a8\u6001<\/h4>\n<h5>1.3.1 \u56fd\u5916\u7814\u7a76\u73b0\u72b6<\/h5>\n<p>\u56fd\u5916\u5728\u57ce\u5e02\u6c34\u6587\u3001\u6392\u6c34\u7ba1\u7f51\u5efa\u6a21\u4e0e\u6c14\u8c61\u518d\u5206\u6790\u6570\u636e\u65b9\u9762\u79ef\u7d2f\u8f83\u65e9\u3002Open-Meteo \u7b49\u6c14\u8c61\u5f52\u6863\u63a5\u53e3\u4e3a\u7814\u7a76\u63d0\u4f9b\u4e86\u53ef\u7a0b\u5e8f\u5316\u83b7\u53d6\u7684\u5386\u53f2\u964d\u6c34\u3001\u6e7f\u5ea6\u7b49\u8981\u7d20\u3002\u53ef\u89c6\u5316\u65b9\u9762&#xff0c;D3.js\u3001Plotly\u3001ECharts \u7b49\u5e93\u88ab\u5e7f\u6cdb\u7528\u4e8e\u4ea4\u4e92\u5f0f\u5730\u56fe\u4e0e\u65f6\u95f4\u5e8f\u5217\u5c55\u793a\u3002\u5185\u6d9d\u6a21\u62df\u5e38\u7ed3\u5408 SWMM \u7b49\u6c34\u6587\u6a21\u578b&#xff0c;\u4f46\u6559\u5b66\u6f14\u793a\u573a\u666f\u4ecd\u5927\u91cf\u4f7f\u7528\u53ef\u89e3\u91ca\u6027\u5f3a\u7684\u7edf\u8ba1\u76f8\u5173\u3001\u7bb1\u7ebf\u5206\u6790\u4e0e\u7b80\u5355\u8d8b\u52bf\u5916\u63a8\u3002<\/p>\n<h5>1.3.2 \u56fd\u5185\u7814\u7a76\u73b0\u72b6<\/h5>\n<p>\u56fd\u5185\u57ce\u5e02\u6613\u6d9d\u70b9\u6cbb\u7406\u4e0e\u6c14\u8c61\u707e\u5bb3\u98ce\u9669\u63d0\u793a\u4fe1\u606f\u53d1\u5e03\u6301\u7eed\u63a8\u8fdb&#xff0c;\u516c\u5f00\u62a5\u9053\u4e0e\u5e94\u6025\u63d0\u793a\u4e2d\u53ef\u83b7\u53d6\u6613\u79ef\u6c34\u8def\u6bb5\u540d\u79f0\u3002\u9ad8\u6821\u6bd5\u4e1a\u8bbe\u8ba1\u4e2d\u5e38\u89c1 Django &#043; ECharts \u7684\u53ef\u89c6\u5316\u7cfb\u7edf&#xff0c;\u4e3b\u9898\u6db5\u76d6\u7a7a\u6c14\u8d28\u91cf\u3001\u4ea4\u901a\u6d41\u91cf\u4e0e\u9632\u6c5b\u76d1\u6d4b\u7b49\u3002\u90e8\u5206\u7cfb\u7edf\u4fa7\u91cd\u5927\u5c4f\u5c55\u793a&#xff0c;\u90e8\u5206\u4fa7\u91cd\u540e\u53f0 CRUD\u3002\u672c\u8bfe\u9898\u66f4\u5f3a\u8c03\u201c\u516d\u5927\u5206\u6790\u6a21\u5757 &#043; Bundle API &#043; \u811a\u672c\u5316\u5165\u5e93\u201d&#xff0c;\u5e76\u4ee5 MySQL \u6301\u4e45\u5316\u7ea6 2.4 \u4e07\u6761\u6df1\u5733\u6c5b\u671f\u6837\u672c&#xff0c;\u517c\u987e\u53ef\u89e3\u91ca\u7b97\u6cd5\u4e0e\u53ef\u590d\u73b0\u90e8\u7f72&#xff1b;\u65e0\u72ec\u7acb\u5927\u5c4f\u8def\u7531\u3002<\/p>\n<h5>1.3.3 \u53d1\u5c55\u8d8b\u52bf<\/h5>\n<p>\u672a\u6765\u57ce\u5e02\u5185\u6d9d\u5206\u6790\u5c06\u66f4\u5f3a\u8c03\u591a\u6e90\u878d\u5408\u3001\u8fd1\u5b9e\u65f6\u66f4\u65b0\u4e0e\u53ef\u89e3\u91ca\u9884\u8b66\u3002\u53ef\u89c6\u5316\u4ece\u9759\u6001\u62a5\u8868\u8d70\u5411\u53ef\u7b5b\u9009\u3001\u53ef\u4e0b\u94bb\u7684\u4ea4\u4e92\u5206\u6790&#xff1b;\u540e\u7aef\u5219\u66f4\u6ce8\u91cd\u7f13\u5b58\u3001\u7d22\u5f15\u4e0e\u7248\u672c\u5316\u5931\u6548\u3002\u5bf9\u672c\u7cfb\u7edf\u800c\u8a00&#xff0c;\u540e\u7eed\u53ef\u63a5\u5165\u6df1\u5733\u5f00\u653e\u5e73\u53f0\u771f\u5b9e\u6c34\u4f4d\u3001\u6269\u5c55\u66f4\u591a\u9884\u6d4b\u6a21\u578b\u4e0e\u6743\u9650\u5206\u7ea7&#xff0c;\u4f46\u4ecd\u5e94\u4fdd\u6301\u6559\u5b66\u573a\u666f\u4e0b\u7ed3\u6784\u6e05\u6670\u3001\u90e8\u7f72\u7b80\u5355\u7684\u7279\u70b9\u3002<\/p>\n<h4>1.4 \u7814\u7a76\u5185\u5bb9<\/h4>\n<p>\u672c\u8bfe\u9898\u4e3b\u8981\u7814\u7a76\u5185\u5bb9\u5982\u4e0b&#xff1a;<\/p>\n<li>\n<p>\u9700\u6c42\u5206\u6790\u4e0e\u603b\u4f53\u8bbe\u8ba1&#xff1a;\u660e\u786e\u7528\u6237\u89d2\u8272&#xff08;\u524d\u53f0\u7528\u6237\u3001\u540e\u53f0\u7ba1\u7406\u5458&#xff09;\u3001\u529f\u80fd\u8fb9\u754c\u4e0e\u975e\u529f\u80fd\u7ea6\u675f&#xff08;\u7aef\u53e3 8070\u3001\u5e93\u540d waterlog\u3001\u65e0\u72ec\u7acb\u5927\u5c4f\u3001\u65e0 Web \u91c7\u96c6\u9875&#xff09;\u3002<\/p>\n<\/li>\n<li>\n<p>\u6570\u636e\u6a21\u578b\u4e0e\u5165\u5e93&#xff1a;\u8bbe\u8ba1 User\u3001FloodRecord \u4e24\u5f20\u6838\u5fc3\u4e1a\u52a1\u8868&#xff0c;\u5b8c\u6210\u8fc1\u79fb\u3001CSV \u5bfc\u5165\u4e0e\u7d22\u5f15\u4f18\u5316&#xff1b;\u8bf4\u660e Open-Meteo \u771f\u5b9e\u964d\u96e8\u4e0e\u6c34\u4f4d\u4f30\u7b97\u903b\u8f91\u3002<\/p>\n<\/li>\n<li>\n<p>\u5206\u6790\u4e0e\u53ef\u89c6\u5316&#xff1a;\u5b9e\u73b0\u6570\u636e\u603b\u89c8\u3001\u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u3001\u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u3001\u65f6\u5e8f\/\u76f8\u5173\/\u9884\u6d4b\/\u5f02\u5e38\u5206\u6790&#xff0c;\u4ee5\u53ca\u6570\u636e\u5217\u8868\u4e0e CSV \u5bfc\u51fa\u3002<\/p>\n<\/li>\n<li>\n<p>\u6570\u636e\u83b7\u53d6\u811a\u672c&#xff1a;\u5b9e\u73b0 fetch_flood_data.py \u62c9\u53d6\u964d\u96e8\u5e76\u751f\u6210\u4f30\u7b97\u6c34\u4f4d CSV&#xff0c;\u7ecf import_flood \u6279\u91cf\u5165\u5e93&#xff1b;\u53ef\u9009\u914d\u7f6e SZ_OPENDATA_APPKEY \u5207\u6362\u5b98\u65b9\u6c34\u4f4d\u3002<\/p>\n<\/li>\n<li>\n<p>\u6d4b\u8bd5\u4e0e\u603b\u7ed3&#xff1a;\u6309\u529f\u80fd\u4e0e\u6027\u80fd\u7ef4\u5ea6\u7ec4\u7ec7\u7528\u4f8b&#xff0c;\u91cf\u5316\u6a21\u5757\u89c4\u6a21\u4e0e\u6570\u636e\u91cf\u7ea7&#xff0c;\u7ed9\u51fa\u6539\u8fdb\u65b9\u5411\u3002<\/p>\n<\/li>\n<h4>1.5 \u8bba\u6587\u7ed3\u6784\u5b89\u6392<\/h4>\n<p>\u5168\u6587\u5171\u516d\u7ae0\u3002\u7b2c1\u7ae0\u4ecb\u7ecd\u80cc\u666f\u3001\u610f\u4e49\u3001\u73b0\u72b6\u4e0e\u7814\u7a76\u5185\u5bb9&#xff1b;\u7b2c2\u7ae0\u8bf4\u660e Django\u3001MySQL\u3001ECharts\u3001pandas \u7f13\u5b58\u3001\u6570\u636e\u83b7\u53d6\u4e0e\u6c34\u4f4d\u4f30\u7b97\u7b49\u5173\u952e\u6280\u672f&#xff1b;\u7b2c3\u7ae0\u7ed9\u51fa\u67b6\u6784\u3001\u6570\u636e\u6d41\u3001\u529f\u80fd\u7ed3\u6784\u3001\u516d\u5927\u6a21\u5757\u8be6\u7ec6\u8bbe\u8ba1\u4e0e\u6570\u636e\u5e93 ER&#xff1b;\u7b2c4\u7ae0\u6309\u6a21\u5757\u9610\u8ff0\u5b9e\u73b0\u6d41\u7a0b\u3001\u5173\u952e\u4ee3\u7801\u3001\u8bbf\u95ee\u8def\u5f84\u4e0e\u754c\u9762\u56fe\u9898&#xff1b;\u7b2c5\u7ae0\u7ed9\u51fa\u529f\u80fd\u4e0e\u6027\u80fd\u6d4b\u8bd5&#xff1b;\u7b2c6\u7ae0\u603b\u7ed3\u6210\u679c\u5e76\u5c55\u671b\u540e\u7eed\u5de5\u4f5c\u3002\u6587\u672b\u9644\u53c2\u8003\u6587\u732e\u4e0e\u81f4\u8c22\u3002<\/p>\n<hr \/>\n<h3>2 \u5173\u952e\u6280\u672f<\/h3>\n<h4>2.1 Django Web\u6846\u67b6<\/h4>\n<p>\u672c\u7cfb\u7edf\u540e\u7aef\u91c7\u7528 Django 3.1.14\u3002Django \u63d0\u4f9b\u6210\u719f\u7684 ORM\u3001\u6a21\u677f\u5f15\u64ce\u3001\u4e2d\u95f4\u4ef6\u4e0e\u7ba1\u7406\u540e\u53f0&#xff0c;\u9002\u5408\u5feb\u901f\u6784\u5efa\u4ee5\u6570\u636e\u67e5\u8be2\u4e0e\u9875\u9762\u6e32\u67d3\u4e3a\u4e3b\u7684\u5206\u6790\u578b Web \u5e94\u7528\u3002\u9879\u76ee\u5165\u53e3\u4e3a\u6839\u76ee\u5f55 manage.py&#xff0c;\u914d\u7f6e\u4f4d\u4e8e \u57fa\u4e8eDjango\u7cfb\u7edf\/settings.py&#xff0c;\u6839\u8def\u7531\u5728 \u57fa\u4e8eDjango\u7cfb\u7edf\/urls.py \u4e2d\u5c06 admin\/ \u4e0e app\/ \u5206\u522b\u6302\u8f7d\u3002<\/p>\n<h5>2.1.1 MTV\u6a21\u5f0f\u4e0e\u8def\u7531\u7ec4\u7ec7<\/h5>\n<p>Django \u9075\u5faa MTV&#xff08;Model-Template-View&#xff09;\u6a21\u5f0f&#xff1a;app\/models.py \u5b9a\u4e49 User \u4e0e FloodRecord&#xff1b;app\/views.py \u5904\u7406\u9875\u9762\u6e32\u67d3\u4e0e\u7528\u6237\u64cd\u4f5c&#xff1b;app\/api_views.py \u5904\u7406 JSON Bundle&#xff1b;\u6a21\u677f\u4f4d\u4e8e app\/templates \u4e0e templates\u3002\u4e1a\u52a1\u8def\u7531\u96c6\u4e2d\u5728 app\/urls.py&#xff0c;\u7edf\u4e00\u7531 \/app\/ \u524d\u7f00\u5f15\u5165&#xff0c;\u4f8b\u5982\u767b\u5f55 \/app\/login\/\u3001\u603b\u89c8 \/app\/home\/\u3001\u6c34\u4f4d \/app\/water_level\/ \u7b49\u3002\u81ea\u5b9a\u4e49\u4e2d\u95f4\u4ef6 middleware.auth.AuthMiddleware \u7528\u4e8e\u4f1a\u8bdd\u9274\u6743&#xff0c;\u4fdd\u62a4\u5206\u6790\u9875\u8bbf\u95ee\u3002<\/p>\n<h5>2.1.2 SimpleUI\u540e\u53f0\u7ba1\u7406<\/h5>\n<p>\u7cfb\u7edf\u5728 INSTALLED_APPS \u4e2d\u5f15\u5165 simpleui&#xff0c;\u901a\u8fc7 SIMPLEUI_CONFIG \u5b9a\u5236\u83dc\u5355&#xff0c;\u5c06\u201c\u5185\u6d9d\u76d1\u6d4b\u6570\u636e\u201d\u4e0e\u201c\u7528\u6237\u4e0e\u6743\u9650\u201d\u5206\u7ec4\u5c55\u793a&#xff0c;\u540e\u53f0\u5165\u53e3\u4e3a \/admin\/\u3002SimpleUI \u5728\u9ed8\u8ba4 Django Admin \u4e4b\u4e0a\u63d0\u4f9b\u66f4\u6e05\u6670\u7684\u4e2d\u6587\u7ba1\u7406\u754c\u9762&#xff0c;\u4fbf\u4e8e\u5bf9 FloodRecord \u8fdb\u884c\u68c0\u7d22\u3001\u7b5b\u9009\u4e0e\u7ef4\u62a4&#xff1b;\u589e\u5220\u6539\u540e\u8c03\u7528 invalidate_waterlog_cache() \u4f7f\u5206\u6790\u7f13\u5b58\u5931\u6548&#xff0c;\u4e0e\u524d\u53f0\u5206\u6790\u5171\u7528\u540c\u4e00\u6570\u636e\u5e93\u3002<\/p>\n<h4>2.2 MySQL\u6570\u636e\u5e93<\/h4>\n<p>\u6301\u4e45\u5316\u5c42\u4f7f\u7528 MySQL&#xff0c;\u9ed8\u8ba4\u5e93\u540d\u4e3a waterlog&#xff0c;\u8fde\u63a5\u53c2\u6570\u53ef\u901a\u8fc7\u73af\u5883\u53d8\u91cf\u8986\u76d6&#xff08;\u7528\u6237\u3001\u5bc6\u7801\u3001\u4e3b\u673a\u3001\u7aef\u53e3&#xff09;\u3002\u5b57\u7b26\u96c6\u914d\u7f6e\u4e3a utf8mb4&#xff0c;\u6ee1\u8db3\u4e2d\u6587\u6d4b\u7ad9\u540d\u3001\u8857\u9053\u540d\u4e0e\u5907\u6ce8\u5b57\u6bb5\u5b58\u50a8\u9700\u6c42\u3002<\/p>\n<h5>2.2.1 ORM\u4e0e\u7d22\u5f15\u8bbe\u8ba1<\/h5>\n<p>FloodRecord \u5bf9 station_code\u3001district\u3001observe_time\u3001warn_grade\u3001is_flooded \u7b49\u5b57\u6bb5\u5efa\u7acb\u5355\u5217\u7d22\u5f15&#xff0c;\u5e76\u5728 Meta \u4e2d\u58f0\u660e\u7ec4\u5408\u7d22\u5f15 idx_flood_time_dist\u3001idx_flood_time_warn&#xff0c;\u4ee5\u52a0\u901f\u6309\u65f6\u95f4\u4e0e\u884c\u653f\u533a\u3001\u9884\u8b66\u7b49\u7ea7\u8fc7\u6ee4\u7684\u805a\u5408\u67e5\u8be2\u3002\u5206\u6790\u6a21\u5757\u5927\u91cf\u4f7f\u7528 Count\u3001Avg\u3001Max\u3001Sum \u7b49\u805a\u5408&#xff0c;\u518d\u5c06\u7ed3\u679c\u8f6c\u4e3a pandas DataFrame \u8fdb\u4e00\u6b65\u8ba1\u7b97\u76f8\u5173\u77e9\u9635\u3001IQR \u8fb9\u754c\u4e0e\u9884\u6d4b\u5e8f\u5217\u3002<\/p>\n<h5>2.2.2 PyMySQL\u9a71\u52a8\u63a5\u5165<\/h5>\n<p>\u4f9d\u8d56\u6e05\u5355 requirements.txt \u5305\u542b PyMySQL&#xff0c;\u4f5c\u4e3a Django MySQL \u540e\u7aef\u7684\u5e38\u7528\u9a71\u52a8\u65b9\u6848&#xff0c;\u914d\u5408 django.db.backends.mysql \u5b8c\u6210\u8fde\u63a5\u3002\u5f00\u53d1\u73af\u5883\u9ed8\u8ba4\u5bc6\u7801\u4e0e README \u4e2d\u521d\u59cb\u5316\u6d41\u7a0b\u4e00\u81f4&#xff0c;\u4fbf\u4e8e\u4e00\u952e\u8fc1\u79fb\u4e0e\u5bfc\u5165\u3002<\/p>\n<h4>2.3 ECharts\u53ef\u89c6\u5316\u6280\u672f<\/h4>\n<p>\u524d\u53f0\u56fe\u8868\u57fa\u4e8e ECharts 5&#xff0c;\u9875\u9762\u9aa8\u67b6\u4f7f\u7528 Bootstrap 5\u3002\u5206\u6790\u9875\u901a\u8fc7 AJAX \u8bf7\u6c42 \/app\/api\/overview\/\u3001\/app\/api\/water-level-bundle\/\u3001\/app\/api\/rain-bundle\/ \u7b49\u63a5\u53e3\u83b7\u53d6 JSON&#xff0c;\u518d\u5728\u6d4f\u89c8\u5668\u7aef\u521d\u59cb\u5316\u6298\u7ebf\u3001\u67f1\u72b6\u3001\u997c\u56fe\u3001\u7bb1\u7ebf\u3001\u70ed\u529b\u3001\u6563\u70b9\u7b49\u7ec4\u4ef6\u3002\u56fe\u8868\u914d\u7f6e\u4e0e\u516c\u5171\u8f85\u52a9\u811a\u672c\u4f4d\u4e8e static\/js\/&#xff08;\u5982 waterlog_pages.js\u3001chart_helpers.js&#xff09;&#xff0c;\u4e3b\u9898\u6837\u5f0f\u7531 waterlog-theme.css \u7edf\u4e00&#xff0c;\u91c7\u7528\u6df1\u84dd\u4fa7\u680f\u4e0e\u84dd\u9ec4\u6a59\u7ea2\u9884\u8b66\u914d\u8272\u3002\u7cfb\u7edf\u4e0d\u63d0\u4f9b\u72ec\u7acb\u5927\u5c4f\u8def\u7531&#xff0c;\u53ef\u89c6\u5316\u96c6\u4e2d\u5728\u4fa7\u680f\u5404\u5206\u6790\u9875\u5185\u5b8c\u6210\u3002<\/p>\n<h4>2.4 \u6570\u636e\u5206\u6790\u4e0e\u7b97\u6cd5\u5b9e\u73b0<\/h4>\n<p>\u6570\u636e\u5904\u7406\u4f9d\u8d56 pandas\u3001NumPy\u3002\u6838\u5fc3\u903b\u8f91\u5c01\u88c5\u5728 app\/utils\/waterlog_core.py \u4e0e app\/utils\/waterlog_charts.py&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u76f8\u5173\u5206\u6790&#xff1a;\u5bf9\u6c34\u4f4d\u3001\u9884\u8b66\u6c34\u4f4d\u3001\u5c0f\u65f6\/\u65e5\u964d\u96e8\u3001\u662f\u5426\u79ef\u6c34\u7b49\u53d8\u91cf&#xff0c;\u4f18\u5148\u8ba1\u7b97 Spearman \u79e9\u76f8\u5173\u77e9\u9635&#xff0c;\u5931\u8d25\u65f6\u56de\u9000 Pearson \u7ebf\u6027\u76f8\u5173&#xff08;correlation_bundle&#xff09;\u3002<\/p>\n<\/li>\n<li>\n<p>\u5f02\u5e38\u68c0\u6d4b&#xff1a;\u91c7\u7528 IQR&#xff08;\u56db\u5206\u4f4d\u8ddd&#xff09;\u6cd5&#xff0c;\u8ba1\u7b97 Q1\u3001Q3 \u4e0e 1.5\u00d7IQR \u4e0a\u4e0b\u754c&#xff0c;\u6807\u8bb0\u8d85\u51fa\u533a\u95f4\u7684\u6c34\u4f4d\u8bb0\u5f55&#xff08;iqr_outliers&#xff09;\u3002<\/p>\n<\/li>\n<li>\n<p>\u793a\u610f\u6027\u9884\u6d4b&#xff1a;\u5bf9\u5168\u7f51\u5c0f\u65f6\u5e73\u5747\u6c34\u4f4d\u5e8f\u5217\u505a\u4e00\u5143\u7ebf\u6027\u62df\u5408&#xff08;np.polyfit&#xff09;&#xff0c;\u5916\u63a8\u672a\u6765 24 \u5c0f\u65f6&#xff0c;\u5e76\u53e0\u52a0\u6ed1\u52a8\u5e73\u5747&#xff08;\u7a97\u53e3 6&#xff09;\u4f5c\u4e3a\u5e73\u6ed1\u53c2\u8003&#xff1b;\u5f3a\u8c03\u5176\u4e3a\u8bfe\u9898\u6f14\u793a\u7528\u9014&#xff0c;\u4e0d\u53ef\u66ff\u4ee3\u6b63\u5f0f\u9632\u6c5b\u9884\u62a5\u3002<\/p>\n<\/li>\n<li>\n<p>\u7f13\u5b58&#xff1a;cached_analysis_df \u4e0e _cache_bundle \u7ed3\u5408 WATERLOG_CACHE_TTL&#061;120 \u79d2\u53ca waterlog:cache_version \u7248\u672c\u53f7&#xff0c;\u5728\u7b5b\u9009\u6761\u4ef6\u4e0d\u53d8\u65f6\u590d\u7528 DataFrame \u4e0e Bundle \u7ed3\u679c\u3002<\/p>\n<\/li>\n<\/ul>\n<p>\u56fe\u8868\u8bf4\u660e\u4e0e KPI \u7ec4\u88c5\u4f4d\u4e8e waterlog_charts.py&#xff0c;\u5e38\u91cf\u4e0e CSV \u5217\u6620\u5c04\u4f4d\u4e8e waterlog_constants.py&#xff0c;\u4fdd\u8bc1\u524d\u540e\u53f0\u5b57\u6bb5\u4e2d\u6587\u540d\u4e0e\u8ba1\u7b97\u53e3\u5f84\u4e00\u81f4\u3002<\/p>\n<h4>2.5 \u6570\u636e\u83b7\u53d6\u4e0e\u6c34\u4f4d\u4f30\u7b97<\/h4>\n<p>\u6570\u636e\u91c7\u96c6\u7531\u547d\u4ee4\u884c\u811a\u672c scripts\/fetch_flood_data.py \u6267\u884c&#xff0c;\u975e Web \u9875\u9762\u89e6\u53d1\u3002\u811a\u672c\u4ece Open-Meteo Archive API \u62c9\u53d6\u6df1\u5733\u5750\u6807\u9644\u8fd1\u7684\u5c0f\u65f6\u964d\u6c34&#xff08;\u771f\u5b9e\u6570\u636e&#xff0c;\u539f\u59cb\u7f13\u5b58\u4e8e data\/raw\/open_meteo\/&#xff09;&#xff0c;\u7ed3\u5408 data\/raw\/stations_sz_flood.csv \u4e2d\u7684 40 \u4e2a\u6613\u6d9d\u6d4b\u7ad9\u5b57\u5178&#xff0c;\u6309\u516c\u5f0f\u4f30\u7b97\u79ef\u6c34\u6c34\u4f4d&#xff1a;<\/p>\n<p>\u6c34\u4f4dcm \u2248 \u5e95\u566a &#043; \u5c0f\u65f6\u964d\u96e8 \u00d7 \u654f\u611f\u5ea6 \u00d7 \u7cfb\u6570 &#043; \u65e5\u7d2f\u8ba1\u8d85\u989d\u9879 &#043; \u566a\u58f0<br \/>\n\u9884\u8b66\u7b49\u7ea7 &#061; \u6c34\u4f4d\u76f8\u5bf9\u9884\u8b66\u6c34\u4f4dcm\u7684\u5206\u6863<br \/>\n\u662f\u5426\u79ef\u6c34 &#061; \u6c34\u4f4d\u63a5\u8fd1\u6216\u8d85\u8fc7\u9884\u8b66\u6c34\u4f4d\u65f6\u8bb0\u4e3a 1 <\/p>\n<p>\u8bba\u6587\u4e0e data\/DATA_SOURCES.md \u5747\u660e\u786e&#xff1a;\u9ed8\u8ba4\u4ea4\u4ed8\u7684 waterlog_data.csv \u7ea6 2.4 \u4e07\u884c&#xff0c;\u65f6\u95f4\u8303\u56f4 2024-05-01 ~ 2024-09-30&#xff1b;\u5c0f\u65f6\u964d\u96e8\u4e3a\u771f\u5b9e&#xff0c;\u6c34\u4f4d\u4e3a\u4f30\u7b97\u3002\u82e5\u5728\u6df1\u5733\u5f00\u653e\u5e73\u53f0\u7533\u8bf7 appKey \u5e76\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf SZ_OPENDATA_APPKEY&#xff0c;\u53ef\u91cd\u65b0\u6267\u884c\u811a\u672c\u5c1d\u8bd5\u5207\u6362\u5b98\u65b9\u79ef\u6d9d\u6c34\u4f4d\u63a5\u53e3\u3002\u5165\u5e93\u547d\u4ee4\u4e3a python manage.py import_flood &#8211;path waterlog_data.csv &#8211;truncate\u3002<\/p>\n<h4>2.6 \u6280\u672f\u7279\u8272\u4e0e\u521b\u65b0\u70b9<\/h4>\n<p>\u7b97\u6cd5\u65b9\u9762&#xff1a;\u5728\u540c\u4e00\u7cfb\u7edf\u4e2d\u96c6\u6210 Spearman\/Pearson \u76f8\u5173\u3001IQR \u5f02\u5e38\u4e0e\u7ebf\u6027\u5916\u63a8&#043;\u6ed1\u52a8\u5e73\u5747\u9884\u6d4b&#xff0c;\u5e76\u9644\u7b97\u6cd5\u8bf4\u660e\u5361\u7247&#xff0c;\u4fbf\u4e8e\u7b54\u8fa9\u65f6\u89e3\u91ca\u201c\u600e\u4e48\u7b97\u3001\u7b97\u4ec0\u4e48\u3001\u8fb9\u754c\u5728\u54ea\u201d\u3002<\/p>\n<p>\u6570\u636e\u5904\u7406\u65b9\u9762&#xff1a;\u4ee5 filtered_queryset &#043; \u672c\u5730\u5185\u5b58\u7f13\u5b58&#xff08;WATERLOG_CACHE_TTL&#061;120&#xff09;\u964d\u4f4e\u91cd\u590d\u805a\u5408\u5f00\u9500&#xff1b;\u811a\u672c\u62c9\u53d6\u4e0e CSV \u5bfc\u5165\u5e76\u5b58&#xff0c;\u517c\u987e\u79bb\u7ebf\u521d\u59cb\u5316\u4e0e\u53ef\u9009\u5b98\u65b9\u6570\u636e\u6e90\u5207\u6362\u3002<\/p>\n<p>\u53ef\u89c6\u5316\u7279\u8272&#xff1a;\u5206\u6790\u9875\u91c7\u7528 Bundle API \u4e00\u6b21\u8fd4\u56de\u591a\u56fe\u6570\u636e&#xff0c;\u51cf\u5c11\u8bf7\u6c42\u6b21\u6570&#xff1b;\u56fe\u8868\u7c7b\u578b\u8986\u76d6 KPI \u603b\u89c8\u3001\u5206\u5e03\u3001\u7bb1\u7ebf\u3001\u70ed\u529b\u3001\u76f8\u5173\u77e9\u9635\u4e0e\u9884\u6d4b\u5bf9\u6bd4\u7b49\u5e38\u89c1\u9632\u6c5b\u5206\u6790\u89c6\u89d2\u3002<\/p>\n<p>\u67b6\u6784\u4f18\u52bf&#xff1a;views \u8d1f\u8d23\u9875\u9762&#xff0c;api_views \u8d1f\u8d23 JSON&#xff0c;utils \u5206\u5c42&#xff08;core \/ charts \/ constants \/ data_analysis&#xff09;&#xff0c;\u804c\u8d23\u6e05\u6670&#xff0c;\u4fbf\u4e8e\u7ef4\u62a4\u3002<\/p>\n<p>\u4f53\u9a8c\u65b9\u9762&#xff1a;Bootstrap \u54cd\u5e94\u5f0f\u5e03\u5c40 &#043; SimpleUI \u4e2d\u6587\u540e\u53f0&#xff0c;\u4fa7\u680f\u5206\u7ec4\u660e\u786e&#xff1b;\u767b\u5f55\u540e\u5373\u53ef\u6309\u6a21\u5757\u6d4f\u89c8&#xff0c;\u65e0\u72ec\u7acb\u5927\u5c4f\u4f9d\u8d56\u3002<\/p>\n<hr \/>\n<h3>3 \u7cfb\u7edf\u5206\u6790\u4e0e\u8bbe\u8ba1<\/h3>\n<h4>3.1 \u7cfb\u7edf\u603b\u4f53\u8bbe\u8ba1<\/h4>\n<h5>3.1.1 \u7cfb\u7edf\u67b6\u6784\u8bbe\u8ba1<\/h5>\n<p>\u7cfb\u7edf\u91c7\u7528\u7ecf\u5178\u4e09\u5c42 B\/S \u7ed3\u6784&#xff1a;\u8868\u73b0\u5c42\u4e3a\u767b\u5f55\u9875\u3001\u9996\u9875\u4e0e\u5404\u5206\u6790\u6a21\u677f&#xff1b;\u4e1a\u52a1\u5c42\u5305\u542b\u8ba4\u8bc1\u3001\u5206\u6790\u805a\u5408\u3001\u76f8\u5173\/\u5f02\u5e38\/\u9884\u6d4b\u8ba1\u7b97\u4e0e CSV \u5bfc\u51fa&#xff1b;\u6570\u636e\u5c42\u4e3a MySQL waterlog \u5e93\u53ca\u539f\u59cb\u7f13\u5b58\u76ee\u5f55 data\/raw\/\u3002\u6d4f\u89c8\u5668\u901a\u8fc7 HTTP \u8bbf\u95ee 8070 \u7aef\u53e3&#xff0c;Django \u5904\u7406\u9875\u9762\u4e0e API&#xff0c;\u5206\u6790\u8ba1\u7b97\u5728\u670d\u52a1\u7aef\u5b8c\u6210\u540e\u518d\u4ee5 JSON \u9a71\u52a8 ECharts \u6e32\u67d3\u3002<\/p>\n<p>\u56fe3.1 \u7cfb\u7edf\u67b6\u6784\u56fe<\/p>\n<p>\u6570\u636e\u8bbf\u95ee\u5c42<\/p>\n<p>\u4e1a\u52a1\u903b\u8f91\u5c42<\/p>\n<p>\u8868\u73b0\u5c42<\/p>\n<p>MySQL: waterlog<\/p>\n<p>waterlog_data.csv<\/p>\n<p>data\/raw Open-Meteo\/\u6d4b\u7ad9\u5b57\u5178<\/p>\n<p>fetch_flood_data.py<\/p>\n<p>\u4f1a\u8bdd\u8ba4\u8bc1 AuthMiddleware<\/p>\n<p>views \u9875\u9762\u89c6\u56fe<\/p>\n<p>api_views JSON\u63a5\u53e3<\/p>\n<p>waterlog_core \u7b5b\u9009\u7f13\u5b58<\/p>\n<p>waterlog_charts \u805a\u5408\u7b97\u6cd5<\/p>\n<p>waterlog_constants \u5e38\u91cf\u6620\u5c04<\/p>\n<p>\u767b\u5f55\/\u6ce8\u518c\u9875<\/p>\n<p>\u6570\u636e\u603b\u89c8\u9996\u9875<\/p>\n<p>\u5206\u6790\u6a21\u5757\u9875<\/p>\n<p>\u6570\u636e\u5217\u8868\/\u5bfc\u51fa<\/p>\n<p>SimpleUI\u540e\u53f0<\/p>\n<h5>3.1.2 \u7cfb\u7edf\u6570\u636e\u6d41\u8bbe\u8ba1<\/h5>\n<p>\u4ece\u5916\u90e8\u770b&#xff0c;\u524d\u53f0\u7528\u6237\u63d0\u4ea4\u8d26\u53f7\u53e3\u4ee4\u8fdb\u5165\u7cfb\u7edf&#xff0c;\u7ba1\u7406\u5458\u901a\u8fc7\u540e\u53f0\u7ef4\u62a4\u8bb0\u5f55&#xff0c;Open-Meteo \u4e0e\u6d4b\u7ad9\u5b57\u5178\u5411\u811a\u672c\u5c42\u63d0\u4f9b\u539f\u59cb\u6570\u636e\u3002\u7cfb\u7edf\u5185\u90e8\u5b8c\u6210\u9274\u6743\u3001\u67e5\u8be2\u8fc7\u6ee4\u3001\u5206\u6790\u8ba1\u7b97\u3001\u56fe\u8868\u8f93\u51fa\u4e0e\u5165\u5e93\u3002<\/p>\n<p>\u56fe3.2 \u9876\u5c42\u6570\u636e\u6d41\u56fe<\/p>\n<p>\u8d26\u53f7\/\u7b5b\u9009\u6761\u4ef6<\/p>\n<p>CRUD\u64cd\u4f5c<\/p>\n<p>\u539f\u59cbJSON\/CSV<\/p>\n<p>\u9875\u9762\u4e0e\u56fe\u8868<\/p>\n<p>\u7ba1\u7406\u53cd\u9988<\/p>\n<p>\u7f13\u5b58\u539f\u59cb\u6587\u4ef6<\/p>\n<p>\u4e1a\u52a1\u8bb0\u5f55<\/p>\n<p>\u524d\u53f0\u7528\u6237<\/p>\n<p>\u57ce\u5e02\u5185\u6d9d\u76d1\u6d4b\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf<\/p>\n<p>\u540e\u53f0\u7ba1\u7406\u5458<\/p>\n<p>\u5916\u90e8\u6570\u636e\u6e90 Open-Meteo \/ \u6d4b\u7ad9\u5b57\u5178 \u53ef\u9009\u6df1\u5733\u5f00\u653e\u5e73\u53f0<\/p>\n<p>\u672c\u5730 data\/raw<\/p>\n<p>MySQL waterlog<\/p>\n<p>\u56fe3.3 0\u5c42\u6570\u636e\u6d41\u56fe<\/p>\n<p>\u524d\u53f0\u7528\u6237<\/p>\n<p>1.0 \u7528\u6237\u8ba4\u8bc1<\/p>\n<p>2.0 \u7b5b\u9009\u4e0e\u67e5\u8be2<\/p>\n<p>3.0 \u5206\u6790\u805a\u5408\u4e0e\u7b97\u6cd5<\/p>\n<p>4.0 \u56fe\u8868\u6e32\u67d3\u652f\u6301<\/p>\n<p>5.0 \u5217\u8868\u4e0e\u5bfc\u51fa<\/p>\n<p>\u7ba1\u7406\u5458<\/p>\n<p>6.0 \u540e\u53f0\u7ba1\u7406<\/p>\n<p>\u8fd0\u7ef4\/\u521d\u59cb\u5316<\/p>\n<p>7.0 \u811a\u672c\u62c9\u53d6\u4e0e\u5bfc\u5165<\/p>\n<p>User\u8868<\/p>\n<p>FloodRecord\u8868<\/p>\n<p>\u5916\u90e8\u6570\u636e\u6e90<\/p>\n<p>CSV\/\u539f\u59cb\u7f13\u5b58<\/p>\n<h5>3.1.3 \u7cfb\u7edf\u529f\u80fd\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u7ed3\u5408\u4fa7\u680f\u5b9e\u9645\u83dc\u5355\u4e0e thesis_diagram_config \u5212\u5206&#xff0c;\u7cfb\u7edf\u529f\u80fd\u5212\u5206\u4e3a\u516d\u5927\u6a21\u5757&#xff1a;&#xff08;1&#xff09;\u7528\u6237\u8ba4\u8bc1&#xff1b;&#xff08;2&#xff09;\u6570\u636e\u603b\u89c8&#xff1b;&#xff08;3&#xff09;\u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790&#xff1b;&#xff08;4&#xff09;\u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790&#xff1b;&#xff08;5&#xff09;\u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38&#xff1b;&#xff08;6&#xff09;\u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u3002\u5404\u6a21\u5757\u5bf9\u5e94\u72ec\u7acb\u9875\u9762\u8def\u7531\u4e0e Bundle API&#xff0c;\u4e2a\u4eba\u4fe1\u606f\u7ef4\u62a4&#xff08;\u4fee\u6539\u8d44\u6599\u3001\u5bc6\u7801&#xff09;\u6302\u8f7d\u4e8e\u8ba4\u8bc1\u6a21\u5757\u5ef6\u4f38\u529f\u80fd\u3002<\/p>\n<p>\u56fe3.4 \u7cfb\u7edf\u529f\u80fd\u7ed3\u6784\u56fe<\/p>\n<p>\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf<\/p>\n<p>\u7528\u6237\u8ba4\u8bc1<\/p>\n<p>\u6570\u636e\u603b\u89c8<\/p>\n<p>\u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790<\/p>\n<p>\u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790<\/p>\n<p>\u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38<\/p>\n<p>\u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0<\/p>\n<p>\u767b\u5f55\u6ce8\u518c\u9000\u51fa<\/p>\n<p>\u4fee\u6539\u4fe1\u606f\u4e0e\u5bc6\u7801<\/p>\n<p>\u9996\u9875KPI<\/p>\n<p>\u603b\u89c8\u56fe\u8868\u63a5\u53e3<\/p>\n<p>\u6c34\u4f4d\u5206\u6790<\/p>\n<p>\u964d\u96e8\u5206\u6790<\/p>\n<p>\u884c\u653f\u533a\u5bf9\u6bd4<\/p>\n<p>\u9884\u8b66\u5206\u6790<\/p>\n<p>\u65f6\u5e8f\u5206\u6790<\/p>\n<p>\u76f8\u5173\u6027\u5206\u6790<\/p>\n<p>\u6c34\u4f4d\u9884\u6d4b<\/p>\n<p>\u5f02\u5e38\u68c0\u6d4b<\/p>\n<p>\u6570\u636e\u5217\u8868<\/p>\n<p>CSV\u5bfc\u51fa<\/p>\n<p>SimpleUI\u540e\u53f0<\/p>\n<h4>3.2 \u7cfb\u7edf\u8be6\u7ec6\u8bbe\u8ba1<\/h4>\n<h5>3.2.1 \u7528\u6237\u8ba4\u8bc1\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u6a21\u5757\u8d1f\u8d23\u524d\u53f0\u6ce8\u518c\u3001\u767b\u5f55\u3001\u9000\u51fa\u53ca\u4f1a\u8bdd\u4fdd\u6301\u3002\u7528\u6237\u4fe1\u606f\u5b58\u50a8\u4e8e\u81ea\u5b9a\u4e49 User \u8868&#xff1b;\u767b\u5f55\u6210\u529f\u540e\u5c06 username \u5199\u5165 request.session&#xff0c;\u540e\u7eed\u9875\u9762\u901a\u8fc7 _user(request) \u8bfb\u53d6\u3002\u4e2d\u95f4\u4ef6\u5bf9\u672a\u767b\u5f55\u8bbf\u95ee\u8fdb\u884c\u62e6\u622a\u5e76\u5f15\u5bfc\u81f3\u767b\u5f55\u9875\u3002\u524d\u53f0\u9ed8\u8ba4\u8d26\u53f7 admin\/123456&#xff1b;Django \u5185\u7f6e\u540e\u53f0\u7ba1\u7406\u5458\u8d26\u53f7 admin\/admin123&#xff0c;\u4e0e\u524d\u53f0\u7528\u6237\u8868\u5206\u79bb\u3002<\/p>\n<h6>3.2.1.1 \u7528\u6237\u8ba4\u8bc1\u6d41\u7a0b\u8bbe\u8ba1<\/h6>\n<p>\u56fe3.5 \u7528\u6237\u8ba4\u8bc1\u6a21\u5757\u6d41\u7a0b\u56fe<\/p>\n<p>GET<\/p>\n<p>POST<\/p>\n<p>\u5339\u914d<\/p>\n<p>\u4e0d\u5339\u914d<\/p>\n<p>\u901a\u8fc7<\/p>\n<p>\u5931\u8d25<\/p>\n<p>\u8bbf\u95ee \/app\/login\/<\/p>\n<p>\u8bf7\u6c42\u65b9\u6cd5<\/p>\n<p>\u6e32\u67d3\u767b\u5f55\u9875<\/p>\n<p>\u8bfb\u53d6\u7528\u6237\u540d\u5bc6\u7801<\/p>\n<p>User\u8868\u6821\u9a8c<\/p>\n<p>\u5199\u5165 session.username<\/p>\n<p>\u8df3\u8f6c \/app\/home\/<\/p>\n<p>\u8fd4\u56de\u9519\u8bef\u63d0\u793a<\/p>\n<p>\u8bbf\u95ee \/app\/register\/<\/p>\n<p>\u6ce8\u518c\u6821\u9a8c<\/p>\n<p>\u521b\u5efa User \u8bb0\u5f55<\/p>\n<p>\u8df3\u8f6c\u767b\u5f55\u9875<\/p>\n<p>\u63d0\u793a\u7a7a\u503c\/\u91cd\u590d\/\u5bc6\u7801\u4e0d\u4e00\u81f4<\/p>\n<h5>3.2.2 \u6570\u636e\u603b\u89c8\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u6570\u636e\u603b\u89c8\u9875\u9762\u8def\u7531\u4e3a \/app\/home\/&#xff0c;\u524d\u7aef\u8c03\u7528 \/app\/api\/overview\/ \u83b7\u53d6 KPI \u5361\u7247\u3001\u884c\u653f\u533a\u79ef\u6c34\u67f1\u56fe\u3001\u9884\u8b66\u7b49\u7ea7\u997c\u56fe\u4e0e\u5168\u7f51\u5c0f\u65f6\u5e73\u5747\u6c34\u4f4d\u65f6\u5e8f\u7b49 Bundle \u6570\u636e\u3002\u670d\u52a1\u7aef\u5728\u8fc7\u6ee4\u540e\u7684 FloodRecord \u4e0a\u805a\u5408\u8bb0\u5f55\u6570\u3001\u6d4b\u7ad9\u6570\u3001\u79ef\u6c34\u7387\u3001\u5e73\u5747\u6c34\u4f4d\u3001\u6700\u5927\u5c0f\u65f6\u964d\u96e8\u4e0e\u65f6\u95f4\u8303\u56f4&#xff0c;\u4f9b\u9996\u9875\u7ea7\u6c5b\u60c5\u7814\u5224\u4f7f\u7528\u3002\u670d\u52a1\u7aef home \u89c6\u56fe\u53e6\u8c03\u7528 FloodDataAnalysis.get_summary_stats() \u6e32\u67d3\u9996\u5c4f KPI\u3002<\/p>\n<h6>3.2.2.1 \u6570\u636e\u603b\u89c8\u6d41\u7a0b\u8bbe\u8ba1<\/h6>\n<p>\u56fe3.6 \u6570\u636e\u603b\u89c8\u6a21\u5757\u6d41\u7a0b\u56fe<\/p>\n<p>\u8fdb\u5165 \/app\/home\/<\/p>\n<p>\u8bfb\u53d6\u7b5b\u9009\u53c2\u6570 month\/district\/warn_grade<\/p>\n<p>filtered_queryset \/ cached_analysis_df<\/p>\n<p>overview_bundle \u805a\u5408 KPI<\/p>\n<p>\u533a\u79ef\u6c34\u67f1\u56fe\/\u9884\u8b66\u997c\u56fe\/\u6c34\u4f4d\u65f6\u5e8f<\/p>\n<p>\u8fd4\u56de JSON<\/p>\n<p>ECharts \u4e0e KPI \u5361\u7247\u6e32\u67d3<\/p>\n<p>\u7ed3\u675f<\/p>\n<h5>3.2.3 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u6c34\u4f4d\u5206\u6790\u9875 \/app\/water_level\/ \u4f9d\u8d56 \/app\/api\/water-level-bundle\/&#xff0c;\u5c55\u793a\u6c34\u4f4d\u9891\u7387\u5206\u5e03\u3001Top \u6d4b\u7ad9\u5747\u6c34\u4f4d\u4e0e\u5206\u884c\u653f\u533a\u7bb1\u7ebf\u56fe\u3002\u964d\u96e8\u5206\u6790\u9875 \/app\/rain\/ \u4f9d\u8d56 \/app\/api\/rain-bundle\/&#xff0c;\u5c55\u793a\u5c0f\u65f6\u964d\u96e8\u4e0e\u6c34\u4f4d\u53cc\u8f74\u65f6\u5e8f\u3001\u964d\u96e8\u2014\u6c34\u4f4d\u6563\u70b9\u3002\u4e24\u9875\u5171\u4eab\u6708\u4efd\/\u884c\u653f\u533a\/\u9884\u8b66\u7b49\u7ea7\u7b5b\u9009\u4e0e\u7f13\u5b58\u673a\u5236\u3002<\/p>\n<h6>3.2.3.1 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6d41\u7a0b\u8bbe\u8ba1<\/h6>\n<p>\u56fe3.7 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6a21\u5757\u6d41\u7a0b\u56fe<\/p>\n<p>\u6c34\u4f4d<\/p>\n<p>\u964d\u96e8<\/p>\n<p>\u8fdb\u5165\u6c34\u4f4d\u6216\u964d\u96e8\u9875<\/p>\n<p>\u643a\u5e26\u7b5b\u9009\u6761\u4ef6\u8bf7\u6c42 Bundle<\/p>\n<p>cached_analysis_df<\/p>\n<p>\u9875\u9762\u7c7b\u578b<\/p>\n<p>\u76f4\u65b9\u5206\u5e03\/Top\u6d4b\u7ad9\/\u7bb1\u7ebf<\/p>\n<p>\u5c0f\u65f6\u65f6\u5e8f\/\u6563\u70b9\u62bd\u6837<\/p>\n<p>JSON \u8fd4\u56de<\/p>\n<p>\u591a\u56fe\u8054\u52a8\u6e32\u67d3<\/p>\n<h5>3.2.4 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u884c\u653f\u533a\u5bf9\u6bd4\u9875 \/app\/district\/ \u8c03\u7528 \/app\/api\/district-bundle\/&#xff0c;\u6309\u884c\u653f\u533a\u805a\u5408\u5e73\u5747\u6c34\u4f4d\u3001\u5e73\u5747\u964d\u96e8\u4e0e\u79ef\u6c34\u7387&#xff0c;\u5e76\u4ee5\u6d4b\u7ad9\u7ecf\u7eac\u5ea6\u751f\u6210\u7a7a\u95f4\u6563\u70b9\u3002\u9884\u8b66\u5206\u6790\u9875 \/app\/warning\/ \u8c03\u7528 \/app\/api\/warning-bundle\/&#xff0c;\u5c55\u793a\u9884\u8b66\u7b49\u7ea7\u5360\u6bd4\u4e0e\u5404\u7b49\u7ea7\u5185\u79ef\u6c34\u7387\u5bf9\u6bd4&#xff0c;\u68c0\u9a8c\u9ad8\u7b49\u7ea7\u9884\u8b66\u662f\u5426\u5bf9\u5e94\u66f4\u9ad8\u79ef\u6c34\u6982\u7387\u3002<\/p>\n<h6>3.2.4.1 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6d41\u7a0b\u8bbe\u8ba1<\/h6>\n<p>\u56fe3.8 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6a21\u5757\u6d41\u7a0b\u56fe<\/p>\n<p>\u884c\u653f\u533a<\/p>\n<p>\u9884\u8b66<\/p>\n<p>\u8fdb\u5165\u884c\u653f\u533a\u6216\u9884\u8b66\u9875<\/p>\n<p>\u8bf7\u6c42 district\/warning bundle<\/p>\n<p>\u6309\u7b5b\u9009\u6761\u4ef6\u53d6\u6570<\/p>\n<p>\u6a21\u5757\u5206\u652f<\/p>\n<p>\u5206\u7ec4\u805a\u5408 &#043; \u7ecf\u7eac\u5ea6\u6563\u70b9<\/p>\n<p>\u7b49\u7ea7\u5360\u6bd4 &#043; \u7b49\u7ea7\u79ef\u6c34\u7387<\/p>\n<p>\u8fd4\u56de JSON<\/p>\n<p>\u67f1\u72b6\/\u6563\u70b9\/\u997c\u56fe\u6e32\u67d3<\/p>\n<h5>3.2.5 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u65f6\u5e8f\u5206\u6790\u9875 \/app\/time_series\/ \u5c55\u793a\u65e5\u5747\u6c34\u4f4d\u4e0e\u661f\u671f\u00d7\u5c0f\u65f6\u70ed\u529b\u77e9\u9635\u3002\u76f8\u5173\u6027\u9875 \/app\/correlation\/ \u5c55\u793a Spearman\/Pearson \u76f8\u5173\u77e9\u9635\u53ca\u964d\u96e8\u2014\u6c34\u4f4d\u7cfb\u6570\u3002\u9884\u6d4b\u9875 \/app\/prediction\/ \u5bf9\u5c0f\u65f6\u5e73\u5747\u6c34\u4f4d\u505a\u7ebf\u6027\u5916\u63a8 24 \u5c0f\u65f6\u5e76\u53e0\u52a0\u6ed1\u52a8\u5e73\u5747\u3002\u5f02\u5e38\u9875 \/app\/anomaly\/ \u57fa\u4e8e IQR \u6807\u8bb0\u5f02\u5e38\u6c34\u4f4d\u5e76\u5728\u65f6\u5e8f\u4e0a\u9ad8\u4eae\u3002\u56db\u9875\u5206\u522b\u5bf9\u5e94 time-series\u3001correlation\u3001prediction\u3001anomaly \u56db\u4e2a Bundle API\u3002<\/p>\n<h6>3.2.5.1 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6d41\u7a0b\u8bbe\u8ba1<\/h6>\n<p>\u56fe3.9 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6a21\u5757\u6d41\u7a0b\u56fe<\/p>\n<p>\u65f6\u5e8f<\/p>\n<p>\u76f8\u5173<\/p>\n<p>\u9884\u6d4b<\/p>\n<p>\u5f02\u5e38<\/p>\n<p>\u8fdb\u5165\u65f6\u5e8f\/\u76f8\u5173\/\u9884\u6d4b\/\u5f02\u5e38\u9875<\/p>\n<p>\u8bf7\u6c42\u5bf9\u5e94 bundle<\/p>\n<p>cached_analysis_df<\/p>\n<p>\u7b97\u6cd5\u5206\u652f<\/p>\n<p>\u65e5\u5747\u5e8f\u5217 &#043; \u661f\u671f\u5c0f\u65f6\u70ed\u529b<\/p>\n<p>Spearman\/Pearson \u77e9\u9635<\/p>\n<p>\u7ebf\u6027\u5916\u63a8 &#043; \u6ed1\u52a8\u5e73\u5747<\/p>\n<p>IQR \u8fb9\u754c &#043; \u5f02\u5e38\u6807\u8bb0<\/p>\n<p>JSON \u8fd4\u56de<\/p>\n<p>\u6298\u7ebf\/\u70ed\u529b\/\u77e9\u9635\/\u6807\u6ce8\u6e32\u67d3<\/p>\n<h5>3.2.6 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6a21\u5757\u8bbe\u8ba1<\/h5>\n<p>\u6570\u636e\u5217\u8868\u9875 \/app\/flood_list\/ \u5bf9 FloodRecord \u5206\u9875\u5c55\u793a&#xff0c;\u652f\u6301\u6708\u4efd\u3001\u884c\u653f\u533a\u3001\u9884\u8b66\u7b49\u7ea7\u7b5b\u9009&#xff0c;\u5e76\u7edf\u8ba1\u5217\u8868\u5185\u8bb0\u5f55\u6570\u3001\u6d4b\u7ad9\u6570\u3001\u5e73\u5747\u6c34\u4f4d\u3001\u6700\u5927\u964d\u96e8\u4e0e\u79ef\u6c34\u7387\u3002\u5bfc\u51fa\u63a5\u53e3 \/app\/api\/export\/ \u6309\u5f53\u524d\u7b5b\u9009\u6761\u4ef6\u6d41\u5f0f\u8f93\u51fa UTF-8 BOM \u7684 CSV\u3002\u540e\u53f0 \/admin\/ \u57fa\u4e8e SimpleUI \u7ef4\u62a4\u5185\u6d9d\u76d1\u6d4b\u8bb0\u5f55\u4e0e\u524d\u53f0\u7528\u6237&#xff0c;\u589e\u5220\u6539\u540e\u5237\u65b0\u5206\u6790\u7f13\u5b58\u3002\u6570\u636e\u521d\u59cb\u5316\u7531 fetch_flood_data.py &#043; import_flood \u5b8c\u6210&#xff0c;\u65e0 Web \u91c7\u96c6\u9875\u3002<\/p>\n<h6>3.2.6.1 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6d41\u7a0b\u8bbe\u8ba1<\/h6>\n<p>\u56fe3.10 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6a21\u5757\u6d41\u7a0b\u56fe<\/p>\n<p>\u7ffb\u9875\/\u7b5b\u9009<\/p>\n<p>\u5bfc\u51fa<\/p>\n<p>\u6253\u5f00 \/app\/flood_list\/<\/p>\n<p>filtered_queryset \u5206\u9875<\/p>\n<p>\u5c55\u793a\u8bb0\u5f55\u4e0e\u5217\u8868\u7edf\u8ba1<\/p>\n<p>\u7528\u6237\u64cd\u4f5c<\/p>\n<p>GET \/app\/api\/export\/<\/p>\n<p>iterator \u6d41\u5f0f\u5199 CSV<\/p>\n<p>\u6d4f\u89c8\u5668\u4e0b\u8f7d waterlog_export.csv<\/p>\n<p>\u7ba1\u7406\u5458\u767b\u5f55 \/admin\/<\/p>\n<p>CRUD FloodRecord\/User<\/p>\n<p>invalidate_waterlog_cache<\/p>\n<p>\u521d\u59cb\u5316<\/p>\n<p>fetch_flood_data.py<\/p>\n<p>import_flood \u5165\u5e93<\/p>\n<h4>3.3 \u6570\u636e\u5e93\u8bbe\u8ba1<\/h4>\n<h5>3.3.1 \u6570\u636e\u5e93\u5173\u7cfb\u8bbe\u8ba1<\/h5>\n<p>\u7cfb\u7edf\u4e1a\u52a1\u5e93\u4e3a MySQL \u4e2d\u7684 waterlog\u3002\u6838\u5fc3\u5b9e\u4f53\u4e3a\u524d\u53f0\u7528\u6237\u8868 User \u4e0e\u5185\u6d9d\u76d1\u6d4b\u8bb0\u5f55\u8868 FloodRecord\u3002\u4e8c\u8005\u65e0\u5f3a\u5236\u5916\u952e\u5173\u8054&#xff1a;\u767b\u5f55\u6001\u901a\u8fc7 Session \u7ed1\u5b9a\u7528\u6237\u540d&#xff1b;\u5185\u6d9d\u5206\u6790\u76f4\u63a5\u67e5\u8be2 FloodRecord\u3002\u540e\u53f0 Django \u5185\u7f6e\u6743\u9650\u8868\u7531\u6846\u67b6\u7ef4\u62a4&#xff0c;\u4e1a\u52a1\u8bba\u6587\u91cd\u70b9\u63cf\u8ff0\u4e0a\u8ff0\u4e24\u5f20\u81ea\u5b9a\u4e49\u8868\u3002<\/p>\n<p>\u56fe3.11 \u6570\u636e\u5e93\u8868\u5173\u7cfb\u56fe<\/p>\n<p>USERintidPK\u4e3b\u952evarcharusername\u7528\u6237\u540dvarcharpassword\u5bc6\u7801varcharsex\u6027\u522bvarcharaddress\u5730\u5740varcharavatar\u5934\u50cf\u8def\u5f84varchartextarea\u4e2a\u4eba\u7b80\u4ecbdatetimecreateTime\u521b\u5efa\u65f6\u95f4FLOOD_RECORDbigintidPK\u4e3b\u952evarcharstation_code\u6d4b\u7ad9\u7f16\u7801varcharstation_name\u6d4b\u7ad9\u540d\u79f0varchardistrict\u884c\u653f\u533avarcharstreet\u8857\u9053floatlongitude\u7ad9\u70b9\u7ecf\u5ea6floatlatitude\u7ad9\u70b9\u7eac\u5ea6datetimeobserve_time\u76d1\u6d4b\u65f6\u95f4floatwater_level_cm\u6c34\u4f4d(cm)floatwarn_level_cm\u9884\u8b66\u6c34\u4f4d(cm)floatrain_hour_mm\u5c0f\u65f6\u964d\u96e8(mm)floatrain_day_mm\u65e5\u7d2f\u8ba1\u964d\u96e8(mm)varcharwarn_grade\u9884\u8b66\u7b49\u7ea7intis_flooded\u662f\u5426\u79ef\u6c34\u4f1a\u8bdd\u7528\u6237\u53ef\u67e5\u8be2\u5206\u6790<\/p>\n<p>\u88683.1 USER&#xff08;\u524d\u53f0\u7528\u6237&#xff09;\u8868\u7ed3\u6784<\/p>\n<table>\n<tr>\u5b57\u6bb5\u540d\u79f0\u5b57\u6bb5\u7c7b\u578b\u5b57\u6bb5\u8bf4\u660e\u662f\u5426\u4e3b\u952e\u662f\u5426\u4e3a\u7a7a<\/tr>\n<tbody>\n<tr>\n<td>id<\/td>\n<td>int<\/td>\n<td>\u552f\u4e00\u6807\u8bc6<\/td>\n<td>\u662f<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>username<\/td>\n<td>varchar(255)<\/td>\n<td>\u7528\u6237\u540d<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>password<\/td>\n<td>varchar(255)<\/td>\n<td>\u5bc6\u7801<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>sex<\/td>\n<td>varchar(255)<\/td>\n<td>\u6027\u522b<\/td>\n<td>\u5426<\/td>\n<td>\u662f<\/td>\n<\/tr>\n<tr>\n<td>address<\/td>\n<td>varchar(255)<\/td>\n<td>\u5730\u5740<\/td>\n<td>\u5426<\/td>\n<td>\u662f<\/td>\n<\/tr>\n<tr>\n<td>avatar<\/td>\n<td>varchar\/\u6587\u4ef6\u8def\u5f84<\/td>\n<td>\u5934\u50cf<\/td>\n<td>\u5426<\/td>\n<td>\u662f<\/td>\n<\/tr>\n<tr>\n<td>textarea<\/td>\n<td>varchar(255)<\/td>\n<td>\u4e2a\u4eba\u7b80\u4ecb<\/td>\n<td>\u5426<\/td>\n<td>\u662f<\/td>\n<\/tr>\n<tr>\n<td>createTime<\/td>\n<td>datetime<\/td>\n<td>\u521b\u5efa\u65f6\u95f4<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u88683.2 FLOOD_RECORD&#xff08;\u5185\u6d9d\u76d1\u6d4b\u8bb0\u5f55&#xff09;\u8868\u7ed3\u6784<\/p>\n<table>\n<tr>\u5b57\u6bb5\u540d\u79f0\u5b57\u6bb5\u7c7b\u578b\u5b57\u6bb5\u8bf4\u660e\u662f\u5426\u4e3b\u952e\u662f\u5426\u4e3a\u7a7a<\/tr>\n<tbody>\n<tr>\n<td>id<\/td>\n<td>bigint<\/td>\n<td>\u552f\u4e00\u6807\u8bc6<\/td>\n<td>\u662f<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>station_code<\/td>\n<td>varchar(64)<\/td>\n<td>\u6d4b\u7ad9\u7f16\u7801<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>station_name<\/td>\n<td>varchar(128)<\/td>\n<td>\u6d4b\u7ad9\u540d\u79f0<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>district<\/td>\n<td>varchar(64)<\/td>\n<td>\u884c\u653f\u533a<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>street<\/td>\n<td>varchar(64)<\/td>\n<td>\u8857\u9053<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>longitude<\/td>\n<td>float<\/td>\n<td>\u7ad9\u70b9\u7ecf\u5ea6<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>latitude<\/td>\n<td>float<\/td>\n<td>\u7ad9\u70b9\u7eac\u5ea6<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>observe_time<\/td>\n<td>datetime<\/td>\n<td>\u76d1\u6d4b\u65f6\u95f4<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>water_level_cm<\/td>\n<td>float<\/td>\n<td>\u6c34\u4f4d(cm)&#xff0c;\u9ed8\u8ba4\u4f30\u7b97<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>warn_level_cm<\/td>\n<td>float<\/td>\n<td>\u9884\u8b66\u6c34\u4f4d(cm)<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>rain_hour_mm<\/td>\n<td>float<\/td>\n<td>\u5c0f\u65f6\u964d\u96e8(mm)&#xff0c;Open-Meteo\u771f\u5b9e<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>rain_day_mm<\/td>\n<td>float<\/td>\n<td>\u65e5\u7d2f\u8ba1\u964d\u96e8(mm)<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>warn_grade<\/td>\n<td>varchar(32)<\/td>\n<td>\u9884\u8b66\u7b49\u7ea7<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<tr>\n<td>is_flooded<\/td>\n<td>int<\/td>\n<td>\u662f\u5426\u79ef\u6c34(0\/1)<\/td>\n<td>\u5426<\/td>\n<td>\u5426<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h3>4 \u7cfb\u7edf\u5b9e\u73b0<\/h3>\n<h4>4.0 \u7cfb\u7edf\u6574\u4f53\u5b9e\u73b0\u6d41\u7a0b<\/h4>\n<p>\u7cfb\u7edf\u5b9e\u73b0\u6309\u201c\u73af\u5883\u4e0e\u5e93\u8868 \u2192 \u811a\u672c\u62c9\u53d6\u4e0e\u5bfc\u5165 \u2192 \u8ba4\u8bc1\u4e0e\u603b\u89c8 \u2192 \u5206\u6790 Bundle API \u2192 \u5404\u5206\u6790\u9875 \u2192 \u5217\u8868\u5bfc\u51fa \u2192 \u540e\u53f0\u914d\u7f6e \u2192 \u8054\u8c03\u6d4b\u8bd5\u201d\u63a8\u8fdb\u3002\u5f00\u53d1\u5165\u53e3\u4e3a manage.py&#xff0c;\u914d\u7f6e\u5e93\u540d waterlog&#xff0c;\u8fc1\u79fb\u540e\u5bfc\u5165\u7ea6 2.4 \u4e07\u6761\u6837\u672c&#xff0c;\u518d\u4ee5 runserver 8070 \u542f\u52a8\u670d\u52a1\u3002<\/p>\n<p>\u56fe4.0 \u7cfb\u7edf\u6574\u4f53\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>\u9879\u76ee\u521d\u59cb\u5316\u4e0e\u4f9d\u8d56\u5b89\u88c5<\/p>\n<p>\u914d\u7f6e MySQL waterlog<\/p>\n<p>migrate \u5efa\u8868<\/p>\n<p>fetch_flood_data.py \u751f\u6210 CSV<\/p>\n<p>import_flood \u5bfc\u5165\u7ea62.4\u4e07\u6761<\/p>\n<p>seed_admin \u521d\u59cb\u5316\u8d26\u53f7<\/p>\n<p>\u5b9e\u73b0\u7528\u6237\u8ba4\u8bc1<\/p>\n<p>\u5b9e\u73b0\u6570\u636e\u603b\u89c8 home &#043; overview API<\/p>\n<p>\u5b9e\u73b0\u6c34\u4f4d\/\u964d\u96e8\/\u884c\u653f\u533a\/\u9884\u8b66 Bundle<\/p>\n<p>\u5b9e\u73b0\u65f6\u5e8f\/\u76f8\u5173\/\u9884\u6d4b\/\u5f02\u5e38 Bundle<\/p>\n<p>\u5b9e\u73b0\u5217\u8868\u5206\u9875\u4e0e CSV \u5bfc\u51fa<\/p>\n<p>\u914d\u7f6e SimpleUI \u540e\u53f0<\/p>\n<p>\u8054\u8c03\u4e0e\u529f\u80fd\u6d4b\u8bd5<\/p>\n<p>\u7aef\u53e38070\u90e8\u7f72\u6f14\u793a<\/p>\n<h4>4.1 \u7528\u6237\u8ba4\u8bc1\u6a21\u5757\u7684\u5b9e\u73b0<\/h4>\n<p>\u7528\u6237\u8ba4\u8bc1\u5b9e\u73b0\u4e8e app\/views.py\u3002GET \u8bf7\u6c42\u6e32\u67d3\u767b\u5f55\u6a21\u677f&#xff1b;POST \u8bf7\u6c42\u6821\u9a8c User \u8868\u7528\u6237\u540d\u4e0e\u5bc6\u7801&#xff0c;\u6210\u529f\u5219\u5199\u5165 Session \u5e76\u8df3\u8f6c\u9996\u9875&#xff0c;\u5931\u8d25\u5219\u8fd4\u56de\u9519\u8bef\u63d0\u793a\u3002\u6ce8\u518c\u6d41\u7a0b\u6821\u9a8c\u7a7a\u503c\u3001\u4e24\u6b21\u5bc6\u7801\u4e00\u81f4\u6027\u4e0e\u8d26\u53f7\u552f\u4e00\u6027\u3002<\/p>\n<h5>\u529f\u80fd\u5b9e\u73b0\u6d41\u7a0b\u8bbe\u8ba1<\/h5>\n<p>\u56fe4.1 \u7528\u6237\u8ba4\u8bc1\u6a21\u5757\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>GET<\/p>\n<p>POST<\/p>\n<p>\u6210\u529f<\/p>\n<p>\u5931\u8d25<\/p>\n<p>\u6253\u5f00\u767b\u5f55\u9875<\/p>\n<p>GET\u8fd8\u662fPOST<\/p>\n<p>render login.html<\/p>\n<p>\u8bfb\u53d6 username\/password<\/p>\n<p>User.objects.get \u6821\u9a8c<\/p>\n<p>session \u4fdd\u5b58\u7528\u6237\u540d<\/p>\n<p>redirect \/app\/home\/<\/p>\n<p>errorResponse \u63d0\u793a<\/p>\n<h5>\u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h5>\n<p># \u6765\u6e90&#xff1a;app\/views.py \u2014 \u524d\u53f0\u767b\u5f55<br \/>\ndef login(request):<br \/>\n    if request.method &#061;&#061; &#034;GET&#034;:<br \/>\n        return render(request, &#034;login.html&#034;)<br \/>\n    username &#061; request.POST.get(&#034;username&#034;)<br \/>\n    password &#061; request.POST.get(&#034;password&#034;)<br \/>\n    try:<br \/>\n        User.objects.get(username&#061;username, password&#061;password)<br \/>\n        request.session[&#034;username&#034;] &#061; username<br \/>\n        return redirect(&#034;\/app\/home\/&#034;)<br \/>\n    except User.DoesNotExist:<br \/>\n        return errorResponse.errorResponse(request, &#034;\u7528\u6237\u540d\u6216\u5bc6\u7801\u9519\u8bef&#034;)<br \/>\n# \u6765\u6e90&#xff1a;app\/urls.py \u2014 \u8ba4\u8bc1\u76f8\u5173\u8def\u7531&#xff08;\u8282\u9009&#xff09;<br \/>\npath(&#034;login\/&#034;, views.login, name&#061;&#034;login&#034;),<br \/>\npath(&#034;register\/&#034;, views.register, name&#061;&#034;register&#034;),<br \/>\npath(&#034;logOut\/&#034;, views.logOut, name&#061;&#034;logOut&#034;),<br \/>\npath(&#034;changeSelfInfo\/&#034;, views.changeSelfInfo, name&#061;&#034;changeSelfInfo&#034;),<br \/>\npath(&#034;changePassword\/&#034;, views.changePassword, name&#061;&#034;changePassword&#034;), <\/p>\n<h5>\u5b9e\u73b0\u6548\u679c\u5c55\u793a<\/h5>\n<p>\u8bbf\u95ee\u8def\u5f84&#xff1a;http:\/\/127.0.0.1:8070\/app\/login\/&#xff08;\u9ed8\u8ba4\u8d26\u53f7 admin \/ 123456&#xff09;<\/p>\n<p>\u56fe4.7 \u7528\u6237\u767b\u5f55\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.7 \u7528\u6237\u767b\u5f55\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092501-6a6f0ced15c31.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u767b\u5f55\u9875\u91c7\u7528\u6c34\u5229\u76d1\u6d4b\u4e3b\u9898\u80cc\u666f\u4e0e\u5c45\u4e2d\u8868\u5355&#xff0c;\u7528\u6237\u8f93\u5165\u8d26\u53f7\u5bc6\u7801\u540e\u63d0\u4ea4&#xff0c;\u6210\u529f\u8fdb\u5165\u6570\u636e\u603b\u89c8\u9996\u9875\u3002<\/p>\n<h4>4.2 \u6570\u636e\u603b\u89c8\u6a21\u5757\u7684\u5b9e\u73b0<\/h4>\n<p>\u6570\u636e\u603b\u89c8\u9875\u9762\u7531 home \u89c6\u56fe\u6e32\u67d3\u6a21\u677f\u5e76\u6ce8\u5165\u670d\u52a1\u7aef KPI&#xff0c;\u524d\u7aef\u518d\u8bf7\u6c42 api_overview \u8c03\u7528 overview_bundle \u8865\u5168\u56fe\u8868\u3002overview_bundle \u5bf9\u8fc7\u6ee4\u540e\u7684\u67e5\u8be2\u96c6\u8ba1\u7b97\u8bb0\u5f55\u6570\u3001\u6d4b\u7ad9\u6570\u3001\u79ef\u6c34\u7387\u3001\u5e73\u5747\u6c34\u4f4d\u3001\u6700\u5927\u5c0f\u65f6\u964d\u96e8&#xff0c;\u5e76\u751f\u6210\u884c\u653f\u533a\u79ef\u6c34\u67f1\u56fe\u3001\u9884\u8b66\u997c\u56fe\u4e0e\u62bd\u6837\u540e\u7684\u6c34\u4f4d\u65f6\u5e8f\u3002<\/p>\n<h5>\u529f\u80fd\u5b9e\u73b0\u6d41\u7a0b\u8bbe\u8ba1<\/h5>\n<p>\u56fe4.2 \u6570\u636e\u603b\u89c8\u6a21\u5757\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>\u8bbf\u95ee \/app\/home\/<\/p>\n<p>home \u89c6\u56fe\u6ce8\u5165 stats<\/p>\n<p>\u8bf7\u6c42 \/app\/api\/overview\/<\/p>\n<p>cached_analysis_df<\/p>\n<p>overview_bundle \u805a\u5408 KPI<\/p>\n<p>\u7ec4\u88c5\u67f1\u56fe\/\u997c\u56fe\/\u65f6\u5e8f<\/p>\n<p>\u524d\u7aef ECharts \u6e32\u67d3<\/p>\n<p>\u7ed3\u675f<\/p>\n<h5>\u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h5>\n<p># \u6765\u6e90&#xff1a;app\/utils\/waterlog_charts.py \u2014 \u603b\u89c8\u6c47\u603b&#xff08;\u8282\u9009&#xff09;<br \/>\ndef overview_bundle(request):<br \/>\n    def build():<br \/>\n        df &#061; cached_analysis_df(request)<br \/>\n        if df.empty:<br \/>\n            return _empty_bundle()<br \/>\n        n &#061; len(df)<br \/>\n        station_n &#061; int(df[&#034;station_code&#034;].nunique())<br \/>\n        flood_rate &#061; _num(df[&#034;is_flooded&#034;].mean() * 100, 1)<br \/>\n        # &#8230; \u884c\u653f\u533a\u79ef\u6c34\u67f1\u56fe\u3001\u9884\u8b66\u997c\u56fe\u3001\u6c34\u4f4d\u65f6\u5e8f &#8230;<br \/>\n    return _cache_bundle(&#034;overview&#034;, request, build)<br \/>\n# \u6765\u6e90&#xff1a;app\/api_views.py \u2014 \u603b\u89c8 API<br \/>\n&#064;require_GET<br \/>\ndef api_overview(request):<br \/>\n    return json_ok(overview_bundle(request)) <\/p>\n<h5>\u5b9e\u73b0\u6548\u679c\u5c55\u793a<\/h5>\n<p>\u8bbf\u95ee\u8def\u5f84&#xff1a;http:\/\/127.0.0.1:8070\/app\/home\/<\/p>\n<p>\u56fe4.8 \u6570\u636e\u603b\u89c8\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.8 \u6570\u636e\u603b\u89c8\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092501-6a6f0ced5c6b9.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u9996\u9875\u5c55\u793a KPI \u5361\u7247\u3001\u884c\u653f\u533a\u79ef\u6c34\u6b21\u6570\u67f1\u56fe\u3001\u9884\u8b66\u7b49\u7ea7\u997c\u56fe\u4e0e\u5168\u7f51\u5e73\u5747\u6c34\u4f4d\u65f6\u5e8f&#xff0c;\u652f\u6301\u6708\u4efd\/\u884c\u653f\u533a\/\u9884\u8b66\u7b49\u7ea7\u7b5b\u9009\u8054\u52a8\u3002<\/p>\n<h4>4.3 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6a21\u5757\u7684\u5b9e\u73b0<\/h4>\n<p>\u6c34\u4f4d\u5206\u6790\u901a\u8fc7 water_level_bundle \u8f93\u51fa\u5206\u5e03\u76f4\u65b9\u3001Top \u6d4b\u7ad9\u5747\u6c34\u4f4d\u4e0e\u5206\u884c\u653f\u533a\u7bb1\u7ebf&#xff1b;\u964d\u96e8\u5206\u6790\u901a\u8fc7 rain_bundle \u8f93\u51fa\u5c0f\u65f6\u964d\u96e8\u4e0e\u6c34\u4f4d\u53cc\u8f74\u65f6\u5e8f\u53ca\u964d\u96e8\u2014\u6c34\u4f4d\u6563\u70b9\u3002\u9875\u9762\u8def\u7531\u5206\u522b\u4e3a \/app\/water_level\/ \u4e0e \/app\/rain\/&#xff0c;\u5bf9\u5e94 module_water_level \u4e0e module_rain \u89c6\u56fe\u3002<\/p>\n<h5>\u529f\u80fd\u5b9e\u73b0\u6d41\u7a0b\u8bbe\u8ba1<\/h5>\n<p>\u56fe4.3 \u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u6a21\u5757\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>\u6c34\u4f4d<\/p>\n<p>\u964d\u96e8<\/p>\n<p>\u8bbf\u95ee water_level \u6216 rain<\/p>\n<p>\u8bf7\u6c42\u5bf9\u5e94 bundle API<\/p>\n<p>cached_analysis_df<\/p>\n<p>\u6a21\u5757\u5206\u652f<\/p>\n<p>_hist_bins \/ box_by_district<\/p>\n<p>hourly agg \/ scatter sample<\/p>\n<p>json_ok \u8fd4\u56de<\/p>\n<p>\u5206\u5e03\/\u7bb1\u7ebf\/\u65f6\u5e8f\/\u6563\u70b9\u6e32\u67d3<\/p>\n<h5>\u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h5>\n<p># \u6765\u6e90&#xff1a;app\/views.py \u2014 \u9875\u9762\u5165\u53e3<br \/>\ndef module_water_level(request):<br \/>\n \u00a0 \u00a0return _module_page(request, &#034;modules\/water_level.html&#034;)<br \/>\n\u200b<br \/>\ndef module_rain(request):<br \/>\n \u00a0 \u00a0return _module_page(request, &#034;modules\/rain.html&#034;)<br \/>\n# \u6765\u6e90&#xff1a;app\/urls.py \u2014 \u6c34\u4f4d\/\u964d\u96e8\u8def\u7531\u4e0e API&#xff08;\u8282\u9009&#xff09;<br \/>\npath(&#034;water_level\/&#034;, views.module_water_level, name&#061;&#034;module_water_level&#034;),<br \/>\npath(&#034;rain\/&#034;, views.module_rain, name&#061;&#034;module_rain&#034;),<br \/>\npath(&#034;api\/water-level-bundle\/&#034;, api_views.api_water_level_bundle, name&#061;&#034;api_water_level_bundle&#034;),<br \/>\npath(&#034;api\/rain-bundle\/&#034;, api_views.api_rain_bundle, name&#061;&#034;api_rain_bundle&#034;), <\/p>\n<h5>\u5b9e\u73b0\u6548\u679c\u5c55\u793a<\/h5>\n<p>\u8bbf\u95ee\u8def\u5f84&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u6c34\u4f4d\u5206\u6790&#xff1a;http:\/\/127.0.0.1:8070\/app\/water_level\/<\/p>\n<\/li>\n<li>\n<p>\u964d\u96e8\u5206\u6790&#xff1a;http:\/\/127.0.0.1:8070\/app\/rain\/<\/p>\n<\/li>\n<\/ul>\n<p>\u56fe4.9 \u6c34\u4f4d\u5206\u6790\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.9 \u6c34\u4f4d\u5206\u6790\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092501-6a6f0ced91edb.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u6c34\u4f4d\u9875\u5c55\u793a\u79ef\u6c34\u6df1\u5ea6\u9891\u7387\u5206\u5e03\u3001\u5e73\u5747\u6c34\u4f4d Top \u6d4b\u7ad9\u6392\u884c\u53ca\u5206\u884c\u653f\u533a\u7bb1\u7ebf\u56fe&#xff0c;\u4fbf\u4e8e\u5bf9\u6bd4\u533a\u57df\u5dee\u5f02\u3002<\/p>\n<p>\u56fe4.10 \u964d\u96e8\u5206\u6790\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.10 \u964d\u96e8\u5206\u6790\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092501-6a6f0cedc6be3.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u964d\u96e8\u9875\u5c55\u793a\u5c0f\u65f6\u964d\u96e8\u4e0e\u6c34\u4f4d\u8054\u52a8\u65f6\u5e8f\u53ca\u964d\u96e8\u2014\u6c34\u4f4d\u6563\u70b9&#xff0c;\u7528\u4e8e\u89c2\u5bdf\u96e8\u5cf0\u4e0e\u6c34\u4f4d\u62ac\u5347\u5173\u7cfb\u3002<\/p>\n<h4>4.4 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6a21\u5757\u7684\u5b9e\u73b0<\/h4>\n<p>\u884c\u653f\u533a\u6a21\u5757\u901a\u8fc7 district_bundle \u6309\u533a\u5206\u7ec4\u805a\u5408\u5e73\u5747\u6c34\u4f4d\u3001\u964d\u96e8\u4e0e\u79ef\u6c34\u7387&#xff0c;\u5e76\u4ee5\u6d4b\u7ad9\u7ecf\u7eac\u5ea6\u751f\u6210\u7a7a\u95f4\u6563\u70b9\u3002\u9884\u8b66\u6a21\u5757\u901a\u8fc7 warning_bundle \u7edf\u8ba1\u9884\u8b66\u7b49\u7ea7\u5360\u6bd4\u4e0e\u5404\u7b49\u7ea7\u79ef\u6c34\u7387\u3002\u9875\u9762\u8def\u7531\u5206\u522b\u4e3a \/app\/district\/ \u4e0e \/app\/warning\/\u3002<\/p>\n<h5>\u529f\u80fd\u5b9e\u73b0\u6d41\u7a0b\u8bbe\u8ba1<\/h5>\n<p>\u56fe4.4 \u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u6a21\u5757\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>\u884c\u653f\u533a<\/p>\n<p>\u9884\u8b66<\/p>\n<p>\u8bbf\u95ee district \u6216 warning<\/p>\n<p>\u8bf7\u6c42 district\/warning bundle<\/p>\n<p>cached_analysis_df<\/p>\n<p>\u6a21\u5757\u5206\u652f<\/p>\n<p>groupby district &#043; map_scatter<\/p>\n<p>warn_share &#043; flood_by_grade<\/p>\n<p>\u8fd4\u56de JSON<\/p>\n<p>\u5bf9\u6bd4\u67f1\u56fe\/\u6563\u70b9\/\u997c\u56fe\u6e32\u67d3<\/p>\n<h5>\u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h5>\n<p># \u6765\u6e90&#xff1a;app\/api_views.py \u2014 \u884c\u653f\u533a\/\u9884\u8b66 Bundle<br \/>\n&#064;require_GET<br \/>\ndef api_district_bundle(request):<br \/>\n    return _bundle(district_bundle, request)<\/p>\n<p>&#064;require_GET<br \/>\ndef api_warning_bundle(request):<br \/>\n    return _bundle(warning_bundle, request)<br \/>\n# \u6765\u6e90&#xff1a;app\/utils\/waterlog_constants.py \u2014 \u9884\u8b66\u7b49\u7ea7\u987a\u5e8f<br \/>\nWARN_GRADES &#061; [&#034;\u6b63\u5e38&#034;, &#034;\u84dd\u8272\u9884\u8b66&#034;, &#034;\u9ec4\u8272\u9884\u8b66&#034;, &#034;\u6a59\u8272\u9884\u8b66&#034;, &#034;\u7ea2\u8272\u9884\u8b66&#034;] <\/p>\n<h5>\u5b9e\u73b0\u6548\u679c\u5c55\u793a<\/h5>\n<p>\u8bbf\u95ee\u8def\u5f84&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u884c\u653f\u533a\u5bf9\u6bd4&#xff1a;http:\/\/127.0.0.1:8070\/app\/district\/<\/p>\n<\/li>\n<li>\n<p>\u9884\u8b66\u5206\u6790&#xff1a;http:\/\/127.0.0.1:8070\/app\/warning\/<\/p>\n<\/li>\n<\/ul>\n<p>\u56fe4.11 \u884c\u653f\u533a\u5bf9\u6bd4\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.11 \u884c\u653f\u533a\u5bf9\u6bd4\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092502-6a6f0cee07022.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u884c\u653f\u533a\u9875\u5c55\u793a\u5404\u8f96\u533a\u5e73\u5747\u6c34\u4f4d\u3001\u964d\u96e8\u4e0e\u79ef\u6c34\u7387\u5bf9\u6bd4\u67f1\u56fe&#xff0c;\u4ee5\u53ca\u6d4b\u7ad9\u7ecf\u7eac\u5ea6\u6563\u70b9&#xff0c;\u4fbf\u4e8e\u7a7a\u95f4\u5de1\u68c0\u3002<\/p>\n<p>\u56fe4.12 \u9884\u8b66\u5206\u6790\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.12 \u9884\u8b66\u5206\u6790\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092502-6a6f0cee3b335.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u9884\u8b66\u9875\u5c55\u793a\u9884\u8b66\u7b49\u7ea7\u5360\u6bd4\u997c\u56fe\u4e0e\u5404\u7b49\u7ea7\u79ef\u6c34\u7387\u5bf9\u6bd4&#xff0c;\u7528\u4e8e\u68c0\u9a8c\u9884\u8b66\u7ed3\u6784\u4e0e\u5b9e\u9645\u79ef\u6c34\u5173\u8054\u3002<\/p>\n<h4>4.5 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6a21\u5757\u7684\u5b9e\u73b0<\/h4>\n<p>\u65f6\u5e8f\u6a21\u5757\u8f93\u51fa\u65e5\u5747\u6c34\u4f4d\u4e0e\u661f\u671f\u00d7\u5c0f\u65f6\u70ed\u529b&#xff1b;\u76f8\u5173\u6a21\u5757\u4f18\u5148 Spearman \u77e9\u9635&#xff1b;\u9884\u6d4b\u6a21\u5757\u5bf9\u5c0f\u65f6\u5747\u6c34\u4f4d\u7ebf\u6027\u5916\u63a8 24 \u5c0f\u65f6\u5e76\u53e0\u52a0\u6ed1\u52a8\u5e73\u5747&#xff1b;\u5f02\u5e38\u6a21\u5757\u4ee5 IQR \u6807\u8bb0\u79bb\u7fa4\u6c34\u4f4d\u3002\u56db\u9875\u8def\u7531\u4e3a \/app\/time_series\/\u3001\/app\/correlation\/\u3001\/app\/prediction\/\u3001\/app\/anomaly\/\u3002<\/p>\n<h5>\u529f\u80fd\u5b9e\u73b0\u6d41\u7a0b\u8bbe\u8ba1<\/h5>\n<p>\u56fe4.5 \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u6a21\u5757\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>\u65f6\u5e8f<\/p>\n<p>\u76f8\u5173<\/p>\n<p>\u9884\u6d4b<\/p>\n<p>\u5f02\u5e38<\/p>\n<p>\u8bbf\u95ee\u65f6\u5e8f\/\u76f8\u5173\/\u9884\u6d4b\/\u5f02\u5e38\u9875<\/p>\n<p>\u8bf7\u6c42\u5bf9\u5e94 bundle<\/p>\n<p>cached_analysis_df<\/p>\n<p>\u7b97\u6cd5<\/p>\n<p>pivot_table \u70ed\u529b<\/p>\n<p>df.corr spearman\/pearson<\/p>\n<p>np.polyfit \u5916\u63a824h &#043; rolling MA<\/p>\n<p>iqr_outliers \u6807\u8bb0<\/p>\n<p>json_ok<\/p>\n<p>\u6298\u7ebf\/\u70ed\u529b\/\u77e9\u9635\/\u6807\u6ce8\u56fe<\/p>\n<h5>\u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h5>\n<p># \u6765\u6e90&#xff1a;app\/utils\/waterlog_core.py \u2014 IQR \u5f02\u5e38\u68c0\u6d4b<br \/>\ndef iqr_outliers(values):<br \/>\n    arr &#061; np.asarray(values, dtype&#061;float)<br \/>\n    arr &#061; arr[~np.isnan(arr)]<br \/>\n    if len(arr) &lt; 4:<br \/>\n        return np.zeros(len(arr), dtype&#061;bool), {}<br \/>\n    q1, q3 &#061; np.percentile(arr, [25, 75])<br \/>\n    iqr &#061; q3 &#8211; q1<br \/>\n    low, high &#061; q1 &#8211; 1.5 * iqr, q3 &#043; 1.5 * iqr<br \/>\n    mask &#061; (arr &lt; low) | (arr &gt; high)<br \/>\n    return mask, {&#034;q1&#034;: _num(q1), &#034;q3&#034;: _num(q3), &#034;iqr&#034;: _num(iqr), &#034;low&#034;: _num(low), &#034;high&#034;: _num(high)}<br \/>\n# \u6765\u6e90&#xff1a;app\/utils\/waterlog_charts.py \u2014 \u76f8\u5173\u4e0e\u9884\u6d4b&#xff08;\u8282\u9009&#xff09;<br \/>\nmethod &#061; &#034;spearman&#034;<br \/>\ntry:<br \/>\n    corr &#061; sub.corr(method&#061;&#034;spearman&#034;)<br \/>\nexcept Exception:<br \/>\n    method &#061; &#034;pearson&#034;<br \/>\n    corr &#061; sub.corr(method&#061;&#034;pearson&#034;)<br \/>\n# \u9884\u6d4b&#xff1a;coef &#061; np.polyfit(x, y, 1)&#xff0c;\u5916\u63a8 horizon&#061;24 \u5c0f\u65f6<br \/>\n# \u6765\u6e90&#xff1a;app\/urls.py \u2014 \u65f6\u5e8f\/\u76f8\u5173\/\u9884\u6d4b\/\u5f02\u5e38\u8def\u7531&#xff08;\u8282\u9009&#xff09;<br \/>\npath(&#034;time_series\/&#034;, views.module_time_series, name&#061;&#034;module_time_series&#034;),<br \/>\npath(&#034;correlation\/&#034;, views.module_correlation, name&#061;&#034;module_correlation&#034;),<br \/>\npath(&#034;prediction\/&#034;, views.module_prediction, name&#061;&#034;module_prediction&#034;),<br \/>\npath(&#034;anomaly\/&#034;, views.module_anomaly, name&#061;&#034;module_anomaly&#034;),<br \/>\npath(&#034;api\/correlation-bundle\/&#034;, api_views.api_correlation_bundle, name&#061;&#034;api_correlation_bundle&#034;),<br \/>\npath(&#034;api\/prediction-bundle\/&#034;, api_views.api_prediction_bundle, name&#061;&#034;api_prediction_bundle&#034;),<br \/>\npath(&#034;api\/anomaly-bundle\/&#034;, api_views.api_anomaly_bundle, name&#061;&#034;api_anomaly_bundle&#034;), <\/p>\n<h5>\u5b9e\u73b0\u6548\u679c\u5c55\u793a<\/h5>\n<p>\u8bbf\u95ee\u8def\u5f84&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u65f6\u5e8f\u5206\u6790&#xff1a;http:\/\/127.0.0.1:8070\/app\/time_series\/<\/p>\n<\/li>\n<li>\n<p>\u76f8\u5173\u6027\u5206\u6790&#xff1a;http:\/\/127.0.0.1:8070\/app\/correlation\/<\/p>\n<\/li>\n<li>\n<p>\u6c34\u4f4d\u9884\u6d4b&#xff1a;http:\/\/127.0.0.1:8070\/app\/prediction\/<\/p>\n<\/li>\n<li>\n<p>\u5f02\u5e38\u68c0\u6d4b&#xff1a;http:\/\/127.0.0.1:8070\/app\/anomaly\/<\/p>\n<\/li>\n<\/ul>\n<p>\u56fe4.13 \u65f6\u5e8f\u5206\u6790\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.13 \u65f6\u5e8f\u5206\u6790\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092502-6a6f0cee6f99b.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u65f6\u5e8f\u9875\u5c55\u793a\u65e5\u5747\u6c34\u4f4d\u6298\u7ebf\u4e0e\u661f\u671f\u00d7\u5c0f\u65f6\u70ed\u529b\u77e9\u9635&#xff0c;\u7528\u4e8e\u53d1\u73b0\u5468\u5185\u4e0e\u65e5\u5185\u6613\u6d9d\u65f6\u6bb5\u3002<\/p>\n<p>\u56fe4.14 \u76f8\u5173\u6027\u5206\u6790\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.14 \u76f8\u5173\u6027\u5206\u6790\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092502-6a6f0ceea3aa6.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u76f8\u5173\u9875\u5c55\u793a\u53d8\u91cf\u76f8\u5173\u77e9\u9635\u70ed\u529b\u56fe\u53ca\u964d\u96e8\u2014\u6c34\u4f4d\u7cfb\u6570\u8bf4\u660e&#xff0c;\u5f3a\u8c03\u76f8\u5173\u4e0d\u7b49\u4e8e\u56e0\u679c\u3002<\/p>\n<p>\u56fe4.15 \u6c34\u4f4d\u9884\u6d4b\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.15 \u6c34\u4f4d\u9884\u6d4b\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092502-6a6f0ceed7ebf.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u9884\u6d4b\u9875\u5bf9\u6bd4\u5386\u53f2\u6c34\u4f4d\u3001\u7ebf\u6027\u62df\u5408\u3001\u6ed1\u52a8\u5e73\u5747\u4e0e\u672a\u6765 24 \u5c0f\u65f6\u5916\u63a8\u66f2\u7ebf&#xff0c;\u5e76\u9644\u7b97\u6cd5\u8bf4\u660e\u5361\u7247\u3002<\/p>\n<p>\u56fe4.16 \u5f02\u5e38\u68c0\u6d4b\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.16 \u5f02\u5e38\u68c0\u6d4b\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092503-6a6f0cef18096.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u5f02\u5e38\u9875\u5728\u65f6\u5e8f\u4e0a\u6807\u6ce8 IQR \u79bb\u7fa4\u70b9&#xff0c;\u5e76\u5217\u51fa\u5f02\u5e38\u6837\u672c\u8868&#xff08;\u6d4b\u7ad9\u3001\u65f6\u95f4\u3001\u6c34\u4f4d\u3001\u9884\u8b66\u7b49\u7ea7&#xff09;\u3002<\/p>\n<h4>4.6 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6a21\u5757\u7684\u5b9e\u73b0<\/h4>\n<p>\u6570\u636e\u5217\u8868\u9875\u5bf9 FloodRecord \u5206\u9875\u5c55\u793a\u5e76\u7edf\u8ba1\u5217\u8868 KPI&#xff1b;\u5bfc\u51fa\u63a5\u53e3\u6309\u7b5b\u9009\u6761\u4ef6\u6d41\u5f0f\u8f93\u51fa CSV\u3002\u540e\u53f0\u901a\u8fc7 SimpleUI \u7ba1\u7406\u76d1\u6d4b\u8bb0\u5f55&#xff0c;\u589e\u5220\u6539\u540e\u8c03\u7528 invalidate_waterlog_cache\u3002\u6570\u636e\u521d\u59cb\u5316\u7531\u811a\u672c\u4e0e\u7ba1\u7406\u547d\u4ee4\u5b8c\u6210&#xff0c;\u7cfb\u7edf\u4e0d\u63d0\u4f9b Web \u6570\u636e\u91c7\u96c6\u9875\u3002<\/p>\n<h5>\u529f\u80fd\u5b9e\u73b0\u6d41\u7a0b\u8bbe\u8ba1<\/h5>\n<p>\u56fe4.6 \u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0\u6a21\u5757\u5b9e\u73b0\u6d41\u7a0b\u56fe<\/p>\n<p>\u662f<\/p>\n<p>\u5426<\/p>\n<p>\u8bbf\u95ee \/app\/flood_list\/<\/p>\n<p>filtered_queryset &#043; Paginator<\/p>\n<p>\u6e32\u67d3\u5206\u9875\u8868\u683c\u4e0e list_stats<\/p>\n<p>\u5bfc\u51fa?<\/p>\n<p>api_export iterator \u5199 CSV<\/p>\n<p>\u7ee7\u7eed\u6d4f\u89c8\/\u7b5b\u9009<\/p>\n<p>\u8bbf\u95ee \/admin\/<\/p>\n<p>FloodRecordAdmin CRUD<\/p>\n<p>invalidate_waterlog_cache<\/p>\n<p>fetch_flood_data.py<\/p>\n<p>import_flood &#8211;truncate<\/p>\n<p>\u7ea62.4\u4e07\u6761\u5165\u5e93<\/p>\n<h5>\u6838\u5fc3\u4ee3\u7801\u5b9e\u73b0<\/h5>\n<p># \u6765\u6e90&#xff1a;app\/views.py \u2014 CSV \u5bfc\u51fa&#xff08;\u8282\u9009&#xff09;<br \/>\n&#064;require_GET<br \/>\ndef api_export(request):<br \/>\n    if not request.session.get(&#034;username&#034;):<br \/>\n        return redirect(&#034;\/app\/login\/&#034;)<br \/>\n    qs &#061; filtered_queryset(request)<br \/>\n    buf &#061; io.StringIO()<br \/>\n    buf.write(&#034;\\\\ufeff&#034;)<br \/>\n    writer &#061; csv.writer(buf)<br \/>\n    writer.writerow([field_label(f, with_unit&#061;True) for f in EXPORT_FIELDS])<br \/>\n    for row in qs.values_list(*EXPORT_FIELDS).iterator(chunk_size&#061;2000):<br \/>\n        writer.writerow(row)<br \/>\n    resp &#061; HttpResponse(buf.getvalue(), content_type&#061;&#034;text\/csv; charset&#061;utf-8&#034;)<br \/>\n    resp[&#034;Content-Disposition&#034;] &#061; &#039;attachment; filename&#061;&#034;waterlog_export.csv&#034;&#039;<br \/>\n    return resp<br \/>\n# \u6765\u6e90&#xff1a;app\/admin.py \u2014 \u540e\u53f0\u7f13\u5b58\u5931\u6548<br \/>\ndef save_model(self, request, obj, form, change):<br \/>\n    super().save_model(request, obj, form, change)<br \/>\n    invalidate_waterlog_cache()<br \/>\n# \u6765\u6e90&#xff1a;\u57fa\u4e8eDjango\u7cfb\u7edf\/settings.py \u2014 \u6570\u636e\u5e93\u4e0e\u7f13\u5b58&#xff08;\u8282\u9009&#xff09;<br \/>\nDATABASES &#061; {<br \/>\n    &#034;default&#034;: {<br \/>\n        &#034;ENGINE&#034;: &#034;django.db.backends.mysql&#034;,<br \/>\n        &#034;NAME&#034;: os.environ.get(&#034;MYSQL_DATABASE&#034;, &#034;waterlog&#034;),<br \/>\n        &#8230;<br \/>\n    }<br \/>\n}<br \/>\nWATERLOG_CACHE_TTL &#061; 120 <\/p>\n<h5>\u5b9e\u73b0\u6548\u679c\u5c55\u793a<\/h5>\n<p>\u8bbf\u95ee\u8def\u5f84&#xff1a;<\/p>\n<ul>\n<li>\n<p>\u6570\u636e\u5217\u8868&#xff1a;http:\/\/127.0.0.1:8070\/app\/flood_list\/<\/p>\n<\/li>\n<li>\n<p>CSV \u5bfc\u51fa&#xff1a;http:\/\/127.0.0.1:8070\/app\/api\/export\/<\/p>\n<\/li>\n<li>\n<p>\u540e\u53f0\u7ba1\u7406&#xff1a;http:\/\/127.0.0.1:8070\/admin\/&#xff08;admin \/ admin123&#xff09;<\/p>\n<\/li>\n<\/ul>\n<p>\u56fe4.17 \u6570\u636e\u5217\u8868\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.17 \u6570\u636e\u5217\u8868\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092503-6a6f0cef4c45d.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>\u5217\u8868\u9875\u5206\u9875\u5c55\u793a\u76d1\u6d4b\u8bb0\u5f55&#xff0c;\u652f\u6301\u6708\u4efd\/\u884c\u653f\u533a\/\u9884\u8b66\u7b49\u7ea7\u7b5b\u9009&#xff0c;\u5e76\u63d0\u4f9b\u5bfc\u51fa\u6309\u94ae\u4e0e\u5217\u8868\u5185\u7edf\u8ba1\u6458\u8981\u3002<\/p>\n<p>\u56fe4.18 \u540e\u53f0\u7ba1\u7406\u754c\u9762<\/p>\n<p class=\"img-center\"><img loading=\"lazy\" decoding=\"async\" alt=\"\u56fe4.18 \u540e\u53f0\u7ba1\u7406\u754c\u9762\" height=\"299\" src=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092503-6a6f0cef806eb.jpg\" width=\"534\" \/><\/p>\n<\/p>\n<p>SimpleUI \u540e\u53f0\u63d0\u4f9b\u5185\u6d9d\u76d1\u6d4b\u8bb0\u5f55\u4e0e\u524d\u53f0\u7528\u6237\u7684\u68c0\u7d22\u3001\u7b5b\u9009\u4e0e\u7ef4\u62a4&#xff0c;\u83dc\u5355\u5206\u7ec4\u6e05\u6670\u3002<\/p>\n<h4>4.7 \u7528\u6237\u754c\u9762\u5b9e\u73b0<\/h4>\n<p>\u754c\u9762\u91c7\u7528 Bootstrap 5 \u5e03\u5c40&#xff0c;\u4fa7\u680f\u6309\u201c\u6570\u636e\u603b\u89c8 \/ \u6c34\u4f4d\u4e0e\u964d\u96e8 \/ \u884c\u653f\u533a\u4e0e\u9884\u8b66 \/ \u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38 \/ \u6570\u636e\u5217\u8868 \/ \u4e2a\u4eba\u4fe1\u606f\u201d\u5206\u7ec4\u3002\u4e3b\u9898\u6837\u5f0f\u7531 waterlog-theme.css \u7edf\u4e00&#xff0c;\u767b\u5f55\u80cc\u666f\u4f7f\u7528 waterlog-bg.jpg\u3002\u5404\u5206\u6790\u9875\u590d\u7528 chart_base.html \u9aa8\u67b6\u4e0e waterlog_pages.js \u8bf7\u6c42 Bundle API&#xff0c;\u7b5b\u9009\u6761\u901a\u8fc7 \/app\/api\/options\/ \u83b7\u53d6\u884c\u653f\u533a\u3001\u6708\u4efd\u4e0e\u9884\u8b66\u7b49\u7ea7\u4e0b\u62c9\u3002\u7cfb\u7edf\u65e0\u72ec\u7acb\u5927\u5c4f\u8def\u7531&#xff0c;\u6240\u6709\u53ef\u89c6\u5316\u5747\u5728\u5e38\u89c4\u9875\u9762\u5185\u5b8c\u6210&#xff1b;\u65e0 Flask \u7ec4\u4ef6\u3002<\/p>\n<h4>4.8 \u7cfb\u7edf\u96c6\u6210\u4e0e\u90e8\u7f72<\/h4>\n<p>\u90e8\u7f72\u6b65\u9aa4\u6982\u8981\u5982\u4e0b&#xff1a;<\/p>\n<li>\n<p>\u5b89\u88c5 requirements.txt \u4f9d\u8d56&#xff08;Django 3.1.14\u3001django-simpleui\u3001PyMySQL\u3001pandas\u3001numpy\u3001scipy\u3001pillow\u3001requests \u7b49&#xff09;\u3002<\/p>\n<\/li>\n<li>\n<p>\u521b\u5efa MySQL \u5e93 waterlog&#xff0c;\u914d\u7f6e\u8fde\u63a5\u8d26\u53f7\u3002<\/p>\n<\/li>\n<li>\n<p>\u6267\u884c python manage.py migrate\u3002<\/p>\n<\/li>\n<li>\n<p>\u6267\u884c python scripts\/fetch_flood_data.py \u751f\u6210 waterlog_data.csv\u3002<\/p>\n<\/li>\n<li>\n<p>\u6267\u884c python manage.py import_flood &#8211;path waterlog_data.csv &#8211;truncate \u5199\u5165\u7ea6 2.4 \u4e07\u6761\u8bb0\u5f55\u3002<\/p>\n<\/li>\n<li>\n<p>python manage.py seed_admin \u521d\u59cb\u5316\u524d\u53f0\u7528\u6237 admin\/123456 \u4e0e\u540e\u53f0 admin\/admin123\u3002<\/p>\n<\/li>\n<li>\n<p>python manage.py runserver 8070\u3002<\/p>\n<\/li>\n<p>\u6839 URL \u5c06\u7a7a\u8def\u5f84\u91cd\u5b9a\u5411\u5230 \/app\/login\/&#xff0c;\u9759\u6001\u4e0e\u5a92\u4f53\u8d44\u6e90\u7531 Django \u5f00\u53d1\u670d\u52a1\u5668\u6302\u8f7d\u3002\u8bfe\u9898\u6f14\u793a\u4ee5 8070 \u7aef\u53e3\u672c\u5730\u8fd0\u884c\u4e3a\u51c6\u3002\u53ef\u9009&#xff1a;\u914d\u7f6e SZ_OPENDATA_APPKEY \u540e\u91cd\u65b0\u62c9\u53d6\u4ee5\u5c1d\u8bd5\u5b98\u65b9\u771f\u5b9e\u6c34\u4f4d\u3002<\/p>\n<hr \/>\n<h3>5 \u7cfb\u7edf\u6d4b\u8bd5<\/h3>\n<h4>5.1 \u7cfb\u7edf\u529f\u80fd\u6d4b\u8bd5<\/h4>\n<p>\u6d4b\u8bd5\u73af\u5883&#xff1a;Windows 10&#xff0c;Python 3.11&#xff0c;Django 3.1.14&#xff0c;MySQL&#xff08;\u5e93 waterlog&#xff09;&#xff0c;\u6d4f\u89c8\u5668\u8bbf\u95ee http:\/\/127.0.0.1:8070\u3002\u524d\u53f0\u9ed8\u8ba4\u8d26\u53f7 admin\/123456&#xff0c;\u540e\u53f0 admin\/admin123\u3002<\/p>\n<h5>5.1.1 \u7528\u6237\u8ba4\u8bc1\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/h5>\n<table>\n<tr>\u7f16\u53f7\u8bf4\u660e\u6761\u4ef6\u64cd\u4f5c\u6b65\u9aa4\u9884\u671f\u7ed3\u679c\u5b9e\u9645\u7ed3\u679c<\/tr>\n<tbody>\n<tr>\n<td>TC-A01<\/td>\n<td>\u6b63\u786e\u767b\u5f55<\/td>\n<td>\u5e93\u4e2d\u5b58\u5728 admin<\/td>\n<td>\u6253\u5f00 \/app\/login\/&#xff0c;\u8f93\u5165 admin\/123456 \u63d0\u4ea4<\/td>\n<td>\u8df3\u8f6c \/app\/home\/&#xff0c;\u4fa7\u680f\u53ef\u89c1<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-A02<\/td>\n<td>\u9519\u8bef\u5bc6\u7801<\/td>\n<td>\u8d26\u53f7\u5b58\u5728<\/td>\n<td>\u8f93\u5165\u9519\u8bef\u5bc6\u7801\u63d0\u4ea4<\/td>\n<td>\u63d0\u793a\u7528\u6237\u540d\u6216\u5bc6\u7801\u9519\u8bef<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-A03<\/td>\n<td>\u6ce8\u518c\u65b0\u7528\u6237<\/td>\n<td>\u7528\u6237\u540d\u672a\u5360\u7528<\/td>\n<td>\/app\/register\/ \u586b\u5199\u4e00\u81f4\u5bc6\u7801<\/td>\n<td>\u6ce8\u518c\u6210\u529f\u5e76\u56de\u5230\u767b\u5f55\u9875<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-A04<\/td>\n<td>\u9000\u51fa\u767b\u5f55<\/td>\n<td>\u5df2\u767b\u5f55<\/td>\n<td>\u6267\u884c \/app\/logOut\/<\/td>\n<td>Session \u6e05\u7a7a&#xff0c;\u56de\u5230\u767b\u5f55\u9875<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>5.1.2 \u6570\u636e\u7ba1\u7406\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/h5>\n<table>\n<tr>\u7f16\u53f7\u8bf4\u660e\u6761\u4ef6\u64cd\u4f5c\u6b65\u9aa4\u9884\u671f\u7ed3\u679c\u5b9e\u9645\u7ed3\u679c<\/tr>\n<tbody>\n<tr>\n<td>TC-B01<\/td>\n<td>\u6570\u636e\u5217\u8868\u6d4f\u89c8<\/td>\n<td>\u5df2\u5bfc\u5165\u6837\u672c<\/td>\n<td>\u6253\u5f00 \/app\/flood_list\/<\/td>\n<td>\u5206\u9875\u5c55\u793a\u5185\u6d9d\u76d1\u6d4b\u8bb0\u5f55<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-B02<\/td>\n<td>\u540e\u53f0\u67e5\u770b\u8bb0\u5f55<\/td>\n<td>\u7ba1\u7406\u5458\u53ef\u8fdb Admin<\/td>\n<td>\u767b\u5f55 \/admin\/ \u6253\u5f00\u5185\u6d9d\u76d1\u6d4b\u8bb0\u5f55<\/td>\n<td>\u53ef\u68c0\u7d22\u6d4b\u7ad9\/\u884c\u653f\u533a\/\u65f6\u95f4\u7b49\u5b57\u6bb5<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-B03<\/td>\n<td>CSV \u5bfc\u51fa<\/td>\n<td>\u5df2\u767b\u5f55\u4e14\u6709\u6570\u636e<\/td>\n<td>\u5728\u5217\u8868\u9875\u70b9\u51fb\u5bfc\u51fa\u6216\u8bbf\u95ee \/app\/api\/export\/<\/td>\n<td>\u4e0b\u8f7d UTF-8 BOM \u7684 CSV \u6587\u4ef6<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-B04<\/td>\n<td>\u811a\u672c\u5165\u5e93<\/td>\n<td>CSV \u5df2\u751f\u6210<\/td>\n<td>\u6267\u884c import_flood &#8211;truncate<\/td>\n<td>\u7ea6 2.4 \u4e07\u6761\u5199\u5165 FloodRecord<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>5.1.3 \u6838\u5fc3\u4e1a\u52a1\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/h5>\n<table>\n<tr>\u7f16\u53f7\u8bf4\u660e\u6761\u4ef6\u64cd\u4f5c\u6b65\u9aa4\u9884\u671f\u7ed3\u679c\u5b9e\u9645\u7ed3\u679c<\/tr>\n<tbody>\n<tr>\n<td>TC-C01<\/td>\n<td>\u6570\u636e\u603b\u89c8<\/td>\n<td>\u6709\u76d1\u6d4b\u6570\u636e<\/td>\n<td>\u6253\u5f00 \/app\/home\/<\/td>\n<td>KPI \u4e0e\u56fe\u8868\u6b63\u5e38<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-C02<\/td>\n<td>\u6c34\u4f4d\u5206\u6790<\/td>\n<td>\u6709\u6c34\u4f4d\u5b57\u6bb5<\/td>\n<td>\u6253\u5f00 \/app\/water_level\/<\/td>\n<td>\u5206\u5e03\/Top\/\u7bb1\u7ebf\u56fe\u6709\u6570\u636e<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-C03<\/td>\n<td>\u964d\u96e8\u5206\u6790<\/td>\n<td>\u6709\u964d\u96e8\u5b57\u6bb5<\/td>\n<td>\u6253\u5f00 \/app\/rain\/<\/td>\n<td>\u65f6\u5e8f\u4e0e\u6563\u70b9\u53ef\u89c1<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-C04<\/td>\n<td>\u884c\u653f\u533a\u5bf9\u6bd4<\/td>\n<td>\u6709\u591a\u533a\u6570\u636e<\/td>\n<td>\u6253\u5f00 \/app\/district\/<\/td>\n<td>\u5bf9\u6bd4\u67f1\u56fe\u4e0e\u6563\u70b9\u66f4\u65b0<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-C05<\/td>\n<td>\u9884\u8b66\u5206\u6790<\/td>\n<td>\u6709\u9884\u8b66\u7b49\u7ea7<\/td>\n<td>\u6253\u5f00 \/app\/warning\/<\/td>\n<td>\u5360\u6bd4\u4e0e\u79ef\u6c34\u7387\u5bf9\u6bd4\u53ef\u89c1<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>5.1.4 \u6570\u636e\u5206\u6790\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/h5>\n<table>\n<tr>\u7f16\u53f7\u8bf4\u660e\u6761\u4ef6\u64cd\u4f5c\u6b65\u9aa4\u9884\u671f\u7ed3\u679c\u5b9e\u9645\u7ed3\u679c<\/tr>\n<tbody>\n<tr>\n<td>TC-D01<\/td>\n<td>\u65f6\u5e8f\u70ed\u529b<\/td>\n<td>\u6709\u65f6\u5e8f\u6570\u636e<\/td>\n<td>\/app\/time_series\/ \u8bf7\u6c42 bundle<\/td>\n<td>\u65e5\u5747\u6298\u7ebf\u4e0e\u70ed\u529b\u77e9\u9635\u8fd4\u56de<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-D02<\/td>\n<td>\u76f8\u5173\u77e9\u9635<\/td>\n<td>\u6837\u672c\u8db3\u591f<\/td>\n<td>\/app\/correlation\/<\/td>\n<td>Spearman\/Pearson \u77e9\u9635\u53ef\u6e32\u67d3<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-D03<\/td>\n<td>\u6c34\u4f4d\u9884\u6d4b<\/td>\n<td>\u5c0f\u65f6\u6837\u672c\u22655<\/td>\n<td>\/app\/prediction\/<\/td>\n<td>\u5386\u53f2&#043;\u5916\u63a8&#043;\u6ed1\u52a8\u5e73\u5747\u66f2\u7ebf\u53ef\u89c1<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-D04<\/td>\n<td>\u5f02\u5e38\u68c0\u6d4b<\/td>\n<td>\u6c34\u4f4d\u6837\u672c\u22654<\/td>\n<td>\/app\/anomaly\/<\/td>\n<td>IQR \u5f02\u5e38\u70b9\u6807\u6ce8\u4e0e\u6837\u672c\u8868\u53ef\u89c1<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>5.1.5 \u7cfb\u7edf\u96c6\u6210\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/h5>\n<table>\n<tr>\u7f16\u53f7\u8bf4\u660e\u6761\u4ef6\u64cd\u4f5c\u6b65\u9aa4\u9884\u671f\u7ed3\u679c\u5b9e\u9645\u7ed3\u679c<\/tr>\n<tbody>\n<tr>\n<td>TC-E01<\/td>\n<td>\u6839\u8def\u5f84\u8df3\u8f6c<\/td>\n<td>\u670d\u52a1\u5df2\u542f\u52a8<\/td>\n<td>\u8bbf\u95ee \/<\/td>\n<td>\u91cd\u5b9a\u5411\u5230 \/app\/login\/<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-E02<\/td>\n<td>API \u524d\u7f00<\/td>\n<td>\u5df2\u767b\u5f55<\/td>\n<td>\u8bf7\u6c42 \/app\/api\/overview\/ \u7b49<\/td>\n<td>\u8fd4\u56de JSON ok \u7ed3\u6784<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-E03<\/td>\n<td>\u7b5b\u9009\u9009\u9879<\/td>\n<td>\u5e93\u6709\u6570\u636e<\/td>\n<td>\u8bf7\u6c42 \/app\/api\/options\/<\/td>\n<td>\u8fd4\u56de\u884c\u653f\u533a\/\u6708\u4efd\/\u9884\u8b66\u7b49\u7ea7<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-E04<\/td>\n<td>\u524d\u540e\u53f0\u5171\u5e93<\/td>\n<td>\u5e93\u6709\u6570\u636e<\/td>\n<td>\u524d\u53f0\u603b\u89c8\u8bb0\u5f55\u6570\u4e0e\u540e\u53f0\u5bf9\u7167<\/td>\n<td>\u6570\u91cf\u7ea7\u4e00\u81f4&#xff08;\u7ea62.4\u4e07&#xff09;<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-E05<\/td>\n<td>\u65e0 Web \u91c7\u96c6\u9875<\/td>\n<td>\u8def\u7531\u5df2\u914d\u7f6e<\/td>\n<td>\u8bbf\u95ee \/app\/data_fetch\/<\/td>\n<td>\u65e0\u6b64\u4e1a\u52a1\u9875&#xff08;404&#xff09;<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-E06<\/td>\n<td>\u65e0\u72ec\u7acb\u5927\u5c4f<\/td>\n<td>\u7cfb\u7edf\u90e8\u7f72\u5b8c\u6210<\/td>\n<td>\u8bbf\u95ee \/bigscreen<\/td>\n<td>\u65e0\u4e1a\u52a1\u5927\u5c4f\u9875<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h5>5.1.6 \u7528\u6237\u754c\u9762\u529f\u80fd\u6d4b\u8bd5\u7528\u4f8b<\/h5>\n<table>\n<tr>\u7f16\u53f7\u8bf4\u660e\u6761\u4ef6\u64cd\u4f5c\u6b65\u9aa4\u9884\u671f\u7ed3\u679c\u5b9e\u9645\u7ed3\u679c<\/tr>\n<tbody>\n<tr>\n<td>TC-F01<\/td>\n<td>\u4fa7\u680f\u5bfc\u822a<\/td>\n<td>\u5df2\u767b\u5f55<\/td>\n<td>\u70b9\u51fb\u5404\u5206\u6790\u83dc\u5355<\/td>\n<td>\u5bf9\u5e94\u9875\u9762\u6fc0\u6d3b\u9ad8\u4eae<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-F02<\/td>\n<td>\u4fee\u6539\u4fe1\u606f<\/td>\n<td>\u5df2\u767b\u5f55<\/td>\n<td>\/app\/changeSelfInfo\/ \u4fdd\u5b58<\/td>\n<td>\u4fe1\u606f\u66f4\u65b0\u6210\u529f<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-F03<\/td>\n<td>\u4fee\u6539\u5bc6\u7801<\/td>\n<td>\u5df2\u767b\u5f55<\/td>\n<td>\/app\/changePassword\/ \u63d0\u4ea4<\/td>\n<td>\u65b0\u5bc6\u7801\u53ef\u767b\u5f55<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<tr>\n<td>TC-F04<\/td>\n<td>\u7b5b\u9009\u8054\u52a8<\/td>\n<td>\u6709\u6570\u636e<\/td>\n<td>\u5207\u6362\u6708\u4efd\/\u884c\u653f\u533a\/\u9884\u8b66\u7b49\u7ea7<\/td>\n<td>\u5404\u9875\u56fe\u8868\u968f\u7b5b\u9009\u5237\u65b0<\/td>\n<td>\u901a\u8fc7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>5.2 \u7cfb\u7edf\u6027\u80fd\u6d4b\u8bd5<\/h4>\n<h5>5.2.1 \u54cd\u5e94\u65f6\u95f4\u6027\u80fd\u5206\u6790<\/h5>\n<p>\u5728\u7ea6 2.4 \u4e07\u6761 FloodRecord\u300140 \u4e2a\u6d4b\u7ad9\u89c4\u6a21\u4e0b&#xff0c;\u666e\u901a\u9875\u9762\u9996\u5c4f\u4e00\u822c\u53ef\u5728 1&#xff5e;3 \u79d2\u5185\u5b8c\u6210&#xff1b;\u5e26\u805a\u5408\u7684 Bundle API \u5728\u7f13\u5b58\u547d\u4e2d\u65f6\u54cd\u5e94\u66f4\u5feb\u3002\u9996\u6b21\u51b7\u67e5\u8be2\u56e0\u805a\u5408\u4e0e DataFrame \u8f6c\u6362\u8017\u65f6\u76f8\u5bf9\u66f4\u9ad8&#xff0c;\u4e4b\u540e 120 \u79d2\u7f13\u5b58\u7a97\u53e3\u5185\u91cd\u590d\u7b5b\u9009\u53ef\u660e\u663e\u964d\u8017\u3002\u65f6\u5e8f\u70ed\u529b\u4e0e\u76f8\u5173\u77e9\u9635 Bundle \u7f13\u5b58\u500d\u6570\u8bbe\u4e3a 2\u00d7TTL&#xff0c;\u8fdb\u4e00\u6b65\u51cf\u5c11\u91cd\u590d\u8ba1\u7b97\u3002<\/p>\n<h5>5.2.2 \u5e76\u53d1\u6027\u80fd\u6d4b\u8bd5<\/h5>\n<p>\u8bfe\u9898\u6f14\u793a\u573a\u666f\u4ee5\u5355\u673a\u5c11\u91cf\u5e76\u53d1\u4e3a\u4e3b\u3002Session \u8ba4\u8bc1\u4e0e\u672c\u5730\u5185\u5b58\u7f13\u5b58\u5728\u591a\u7528\u6237\u540c\u65f6\u7b5b\u9009\u76f8\u8fd1\u6761\u4ef6\u65f6\u80fd\u591f\u590d\u7528\u7ed3\u679c&#xff1b;\u82e5\u5e76\u53d1\u663e\u8457\u589e\u5927&#xff0c;\u53ef\u8003\u8651\u66f4\u6362 Redis \u7b49\u7f13\u5b58\u540e\u7aef\u3002\u5f53\u524d\u5b9e\u73b0\u6ee1\u8db3\u8bfe\u7a0b\u9a8c\u6536\u4e0e\u672c\u673a\u6f14\u793a\u9700\u6c42\u3002<\/p>\n<h5>5.2.3 \u6570\u636e\u5e93\u6027\u80fd\u6d4b\u8bd5<\/h5>\n<p>\u9488\u5bf9 observe_time&#043;district\u3001observe_time&#043;warn_grade \u7684\u7ec4\u5408\u7d22\u5f15&#xff0c;\u5bf9\u6708\u4efd\u4e0e\u884c\u653f\u533a\u8fc7\u6ee4\u7684 Count\/Avg\/Max \u67e5\u8be2\u6709\u5e2e\u52a9\u3002\u5217\u8868\u5bfc\u51fa\u4f7f\u7528 iterator(chunk_size&#061;2000) \u6d41\u5f0f\u8bfb\u5e93&#xff0c;\u907f\u514d\u4e00\u6b21\u6027\u88c5\u5165\u5168\u90e8\u884c\u3002\u5efa\u8bae\u5b9a\u671f ANALYZE \u5e76\u907f\u514d\u65e0\u7d22\u5f15\u5b57\u6bb5\u4e0a\u7684\u9ad8\u57fa\u6570\u5b57\u7b26\u4e32\u6a21\u7cca\u67e5\u8be2\u3002<\/p>\n<h5>5.2.4 \u6027\u80fd\u4f18\u5316\u63aa\u65bd<\/h5>\n<li>\n<p>\u4f7f\u7528 cached_analysis_df \u4e0e WATERLOG_CACHE_TTL&#061;120 \u964d\u4f4e\u91cd\u590d\u8ba1\u7b97\u3002<\/p>\n<\/li>\n<li>\n<p>Bundle API \u5408\u5e76\u591a\u56fe\u6570\u636e&#xff0c;\u51cf\u5c11 HTTP \u5f80\u8fd4\u3002<\/p>\n<\/li>\n<li>\n<p>sample_series \u5bf9\u8fc7\u957f\u65f6\u5e8f\u7b49\u8ddd\u62bd\u6837&#xff0c;\u51cf\u8f7b\u524d\u7aef\u6e32\u67d3\u538b\u529b\u3002<\/p>\n<\/li>\n<li>\n<p>\u540e\u53f0\u589e\u5220\u6539\u8c03\u7528 invalidate_waterlog_cache \u9012\u589e\u7248\u672c\u53f7&#xff0c;\u907f\u514d\u810f\u8bfb\u800c\u975e\u5168\u5e93\u6e05\u7f13\u5b58\u3002<\/p>\n<\/li>\n<li>\n<p>\u5bfc\u5165\u9636\u6bb5 &#8211;truncate \u540e\u6279\u91cf\u5199\u5165&#xff0c;\u7f29\u77ed\u521d\u59cb\u5316\u65f6\u95f4\u3002<\/p>\n<\/li>\n<hr \/>\n<h3>6 \u603b\u7ed3\u4e0e\u5c55\u671b<\/h3>\n<h4>6.1 \u603b\u7ed3<\/h4>\n<p>\u672c\u6587\u5b8c\u6210\u4e86\u57fa\u4e8e Python \u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf\u7684\u8bbe\u8ba1\u4e0e\u5b9e\u73b0\u3002\u7cfb\u7edf\u4ee5 Django 3.1.14 &#043; SimpleUI \u4e3a Web \u6846\u67b6&#xff0c;MySQL \u5e93\u540d waterlog&#xff0c;\u670d\u52a1\u7aef\u53e3 8070&#xff0c;\u5165\u53e3 manage.py&#xff0c;\u524d\u53f0 \/app\/login\/&#xff08;admin\/123456&#xff09;&#xff0c;\u540e\u53f0 \/admin\/&#xff08;admin\/admin123&#xff09;\u3002\u56f4\u7ed5 User \u4e0e FloodRecord \u4e24\u5f20\u6838\u5fc3\u8868&#xff0c;\u6309\u516d\u5927\u6a21\u5757\u7ec4\u7ec7\u4e86\u7528\u6237\u8ba4\u8bc1\u3001\u6570\u636e\u603b\u89c8\u3001\u6c34\u4f4d\u4e0e\u964d\u96e8\u5206\u6790\u3001\u884c\u653f\u533a\u4e0e\u9884\u8b66\u5206\u6790\u3001\u65f6\u5e8f\u76f8\u5173\u9884\u6d4b\u5f02\u5e38\u3001\u5217\u8868\u5bfc\u51fa\u4e0e\u540e\u53f0&#xff1b;\u5206\u6790 API \u63d0\u4f9b options\/overview \u53ca\u516b\u4e2a *-bundle \u63a5\u53e3\u3002\u6570\u636e\u8986\u76d6\u6df1\u5733\u5e02 40 \u4e2a\u6d4b\u7ad9\u30012024 \u5e74 5\u20149 \u6708\u6c5b\u671f\u3001\u7ea6 2.4 \u4e07\u6761\u5c0f\u65f6\u7ea7\u8bb0\u5f55&#xff1b;\u5c0f\u65f6\u964d\u96e8\u6765\u81ea Open-Meteo \u771f\u5b9e\u6570\u636e&#xff0c;\u79ef\u6c34\u6c34\u4f4d\u4e3a\u57fa\u4e8e\u964d\u96e8\u4e0e\u70b9\u4f4d\u654f\u611f\u5ea6\u7684\u4f30\u7b97\u503c&#xff08;\u8bba\u6587\u4e0e\u754c\u9762\u5747\u5df2\u8bf4\u660e&#xff09;\u3002\u6570\u636e\u91c7\u96c6\u901a\u8fc7 scripts\/fetch_flood_data.py \u4e0e import_flood \u5b8c\u6210&#xff0c;\u65e0 Web \u91c7\u96c6\u9875\u3001\u65e0 Flask\u3001\u65e0\u72ec\u7acb\u5927\u5c4f\u3002\u5206\u6790\u91c7\u7528 pandas\/NumPy \u805a\u5408&#xff0c;Spearman\/Pearson \u76f8\u5173\u3001IQR \u5f02\u5e38\u68c0\u6d4b&#xff0c;\u4ee5\u53ca\u7ebf\u6027\u5916\u63a8\u4e0e\u6ed1\u52a8\u5e73\u5747\u793a\u610f\u9884\u6d4b&#xff1b;utils \u5c42 waterlog_core\u3001waterlog_charts\u3001waterlog_constants \u5206\u5c42\u6e05\u6670&#xff0c;\u672c\u5730\u7f13\u5b58 TTL \u4e3a 120 \u79d2\u3002\u524d\u7aef\u4ee5 ECharts 5 \u4e0e Bootstrap 5 \u5448\u73b0\u3002\u7ecf\u529f\u80fd\u6d4b\u8bd5&#xff0c;\u4e3b\u8981\u6a21\u5757\u8fd0\u884c\u7b26\u5408\u9884\u671f&#xff0c;\u80fd\u591f\u652f\u6491\u6559\u5b66\u6f14\u793a\u4e0e\u8bfe\u9898\u5206\u6790\u3002<\/p>\n<p>\u4ece\u6a21\u5757\u89c4\u6a21\u770b&#xff0c;\u8bba\u6587\u7b2c 3\u30014 \u7ae0\u6309\u4e0a\u8ff0 6 \u4e2a\u529f\u80fd\u6a21\u5757\u5c55\u5f00&#xff1b;\u4fa7\u680f\u8def\u7531\u5305\u62ec \/app\/home\/\u3001\/app\/water_level\/\u3001\/app\/rain\/\u3001\/app\/district\/\u3001\/app\/warning\/\u3001\/app\/time_series\/\u3001\/app\/correlation\/\u3001\/app\/prediction\/\u3001\/app\/anomaly\/\u3001\/app\/flood_list\/ \u7b49&#xff0c;\u5f62\u6210\u53ef\u590d\u73b0\u7684\u672c\u5730\u5316\u5185\u6d9d\u53ef\u89c6\u5316\u5206\u6790\u65b9\u6848\u3002<\/p>\n<h4>6.2 \u5c55\u671b<\/h4>\n<p>\u540e\u7eed\u53ef\u4ece\u4ee5\u4e0b\u65b9\u5411\u7ee7\u7eed\u5b8c\u5584&#xff1a;\u5728\u6df1\u5733\u5f00\u653e\u5e73\u53f0\u7533\u8bf7 appKey \u540e\u5207\u6362\u5b98\u65b9\u79ef\u6d9d\u6c34\u4f4d&#xff0c;\u5e76\u4e0e\u4f30\u7b97\u5e8f\u5217\u5bf9\u7167\u5c55\u793a&#xff1b;\u5f15\u5165\u66f4\u4e30\u5bcc\u7684\u65f6\u95f4\u5e8f\u5217\u6a21\u578b&#xff08;\u5982 ARIMA \u6216\u5b63\u8282\u6027\u5206\u89e3&#xff09;\u63d0\u5347\u9884\u6d4b\u8868\u8fbe\u529b&#xff1b;\u589e\u52a0\u89d2\u8272\u6743\u9650\u7ec6\u5206\u4e0e\u64cd\u4f5c\u5ba1\u8ba1&#xff1b;\u5c06\u811a\u672c\u62c9\u53d6\u63a5\u5165\u5b9a\u65f6\u4efb\u52a1\u6216\u6d88\u606f\u961f\u5217&#xff1b;\u5728\u4fdd\u6301\u65e0\u72ec\u7acb\u5927\u5c4f\u7684\u524d\u63d0\u4e0b&#xff0c;\u4f18\u5316\u79fb\u52a8\u7aef\u56fe\u8868\u4ea4\u4e92\u4e0e\u5730\u56fe\u5e95\u56fe\u96c6\u6210&#xff1b;\u6269\u5c55\u66f4\u591a\u6d4b\u7ad9\u4e0e\u8fd1\u5b9e\u65f6\u964d\u6c34\u63a5\u5165&#xff0c;\u4f7f\u5206\u6790\u66f4\u8d34\u8fd1\u4e1a\u52a1\u5de1\u68c0\u573a\u666f\u3002<\/p>\n<hr \/>\n<h3>\u53c2\u8003\u6587\u732e<\/h3>\n<p>[1] Django Software Foundation. Django documentation (3.1.x)[EB\/OL]. Django documentation | Django documentation | Django, 2021.<\/p>\n<p>[2] \u4f0a\u8bfa\u514b\u68ee\u6258\u5a03. Python\u6570\u636e\u5206\u6790[M]. \u5317\u4eac: \u4eba\u6c11\u90ae\u7535\u51fa\u7248\u793e, 2020.<\/p>\n<p>[3] \u738b\u73ca, \u8428\u5e08\u714a. \u6570\u636e\u5e93\u7cfb\u7edf\u6982\u8bba[M]. 5\u7248. \u5317\u4eac: \u9ad8\u7b49\u6559\u80b2\u51fa\u7248\u793e, 2014.<\/p>\n<p>[4] Apache ECharts. ECharts \u5b98\u65b9\u6587\u6863[EB\/OL]. Apache ECharts.<\/p>\n<p>[5] McKinney W. Data Structures for Statistical Computing in Python[C]\/\/Proceedings of the 9th Python in Science Conference, 2010.<\/p>\n<p>[6] Open-Meteo. Historical Weather API Documentation[EB\/OL]. &#x1f324;\ufe0f Free Open-Source Weather API | Open-Meteo.com.<\/p>\n<p>[7] \u6df1\u5733\u5e02\u4eba\u6c11\u653f\u5e9c. \u6df1\u5733\u5e02\u653f\u5e9c\u6570\u636e\u5f00\u653e\u5e73\u53f0&#xff1a;\u5e02\u6c34\u52a1\u5c40\u79ef\u6d9d\u70b9\u6c34\u4f4d\u63a5\u53e3[EB\/OL]. \u6df1\u5733\u5e02\u653f\u5e9c\u6570\u636e\u5f00\u653e\u5e73\u53f0.<\/p>\n<p>[8] \u674e\u521a. \u75af\u72c2 Python \u8bb2\u4e49[M]. \u5317\u4eac: \u7535\u5b50\u5de5\u4e1a\u51fa\u7248\u793e, 2019.<\/p>\n<p>[9] \u5f20\u6d69. \u57fa\u4e8e Web \u7684\u6570\u636e\u53ef\u89c6\u5316\u7cfb\u7edf\u8bbe\u8ba1\u4e0e\u5b9e\u73b0[J]. \u8ba1\u7b97\u673a\u5e94\u7528\u4e0e\u8f6f\u4ef6, 2020.<\/p>\n<p>[10] Bootstrap Team. Bootstrap 5 Documentation[EB\/OL]. https:\/\/getbootstrap.com\/docs\/5.0\/getting-started\/introduction\/.<\/p>\n<p>[11] \u5468\u5fd7\u534e. \u673a\u5668\u5b66\u4e60[M]. \u5317\u4eac: \u6e05\u534e\u5927\u5b66\u51fa\u7248\u793e, 2016.<\/p>\n<p>[12] Spearman C. The Proof and Measurement of Association between Two Things[J]. American Journal of Psychology, 1904, 15(1): 72-101.<\/p>\n<hr \/>\n<h3>\u81f4\u8c22<\/h3>\n<p>\u5728\u6bd5\u4e1a\u8bbe\u8ba1\u5b8c\u6210\u4e4b\u9645&#xff0c;\u8877\u5fc3\u611f\u8c22\u6307\u5bfc\u8001\u5e08\u5728\u9009\u9898\u3001\u9700\u6c42\u5206\u6790\u3001\u7cfb\u7edf\u8bbe\u8ba1\u4e0e\u8bba\u6587\u64b0\u5199\u8fc7\u7a0b\u4e2d\u7ed9\u4e88\u7684\u8010\u5fc3\u6307\u5bfc\u4e0e\u4e25\u683c\u8981\u6c42\u3002\u611f\u8c22\u540c\u5b66\u5728\u73af\u5883\u642d\u5efa\u3001\u529f\u80fd\u8054\u8c03\u4e0e\u754c\u9762\u4f53\u9a8c\u53cd\u9988\u65b9\u9762\u63d0\u4f9b\u7684\u5e2e\u52a9\u3002\u611f\u8c22\u5f00\u6e90\u793e\u533a\u63d0\u4f9b\u7684 Django\u3001ECharts\u3001pandas\u3001Open-Meteo \u7b49\u76f8\u5173\u6280\u672f\u4e0e\u6570\u636e\u63a5\u53e3&#xff0c;\u4f7f\u672c\u7cfb\u7edf\u80fd\u591f\u987a\u5229\u843d\u5730\u3002\u4e5f\u611f\u8c22\u5bb6\u4eba\u4e00\u76f4\u4ee5\u6765\u7684\u7406\u89e3\u4e0e\u652f\u6301\u3002\u7531\u4e8e\u6c34\u5e73\u4e0e\u65f6\u95f4\u6709\u9650&#xff0c;\u7cfb\u7edf\u4e2d\u6c34\u4f4d\u4f30\u7b97\u4e0e\u793a\u610f\u6027\u9884\u6d4b\u4ecd\u6709\u6539\u8fdb\u7a7a\u95f4&#xff0c;\u6073\u8bf7\u5404\u4f4d\u8001\u5e08\u6279\u8bc4\u6307\u6b63\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u6bd5\u4e1a\u8bba\u6587<br \/>\n\u6bd5\u4e1a\u8bbe\u8ba1 \u4e00\u3001\u9879\u76ee\u540d\u79f0&#xff1a;<br \/>\n\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u3010\u6458\u8981\u3011<br \/>\n\u57ce\u5e02\u5185\u6d9d\u662f\u6c5b\u671f\u516c\u5171\u5b89\u5168\u4e0e\u5e02\u653f\u6392\u6c34\u7ba1\u7406\u7684\u91cd\u8981\u8bae\u9898\u3002\u79ef\u6c34\u6df1\u5ea6\u3001\u5c0f\u65f6\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u7b49\u6307\u6807\u76f8\u4e92\u5173\u8054&#xff0c;\u4f46\u539f\u59cb\u6570\u636e\u5f80\u5f80\u5206\u6563\u5728\u6c14\u8c61\u63a5\u53e3\u3001\u6613\u6d9d\u70b9\u540d\u5f55\u4e0e\u6c34\u52a1\u76d1\u6d4b\u5e73\u53f0\u4e2d&#xff0c;\u5b58\u5728\u53e3\u5f84\u4e0d\u4e00\u3001\u96be\u4ee5\u6a2a\u5411\u5bf9\u6bd4\u3001\u7f3a\u5c11\u8d8b\u52bf\u7814\u5224\u7b49\u95ee\u9898\u3002\u672c\u6587\u8bbe\u8ba1\u5e76\u5b9e\u73b0\u4e86\u57fa\u4e8e Python \u4e0e Django \u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6<\/p>\n","protected":false},"author":2,"featured_media":89217,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9137,890,81,1224,292,801],"topic":[],"class_list":["post-89229","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-atomgit","tag-django","tag-python","tag-1224","tag-292","tag-801"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/89229.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u6bd5\u4e1a\u8bba\u6587 \u6bd5\u4e1a\u8bbe\u8ba1 \u4e00\u3001\u9879\u76ee\u540d\u79f0&#xff1a; \u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u3010\u6458\u8981\u3011 \u57ce\u5e02\u5185\u6d9d\u662f\u6c5b\u671f\u516c\u5171\u5b89\u5168\u4e0e\u5e02\u653f\u6392\u6c34\u7ba1\u7406\u7684\u91cd\u8981\u8bae\u9898\u3002\u79ef\u6c34\u6df1\u5ea6\u3001\u5c0f\u65f6\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u7b49\u6307\u6807\u76f8\u4e92\u5173\u8054&#xff0c;\u4f46\u539f\u59cb\u6570\u636e\u5f80\u5f80\u5206\u6563\u5728\u6c14\u8c61\u63a5\u53e3\u3001\u6613\u6d9d\u70b9\u540d\u5f55\u4e0e\u6c34\u52a1\u76d1\u6d4b\u5e73\u53f0\u4e2d&#xff0c;\u5b58\u5728\u53e3\u5f84\u4e0d\u4e00\u3001\u96be\u4ee5\u6a2a\u5411\u5bf9\u6bd4\u3001\u7f3a\u5c11\u8d8b\u52bf\u7814\u5224\u7b49\u95ee\u9898\u3002\u672c\u6587\u8bbe\u8ba1\u5e76\u5b9e\u73b0\u4e86\u57fa\u4e8e Python \u4e0e Django \u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/89229.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-08-02T09:25:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092501-6a6f0ced15c31.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/89229.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/89229.html\",\"name\":\"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-08-02T09:25:04+00:00\",\"dateModified\":\"2026-08-02T09:25:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/89229.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/89229.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/89229.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/89229.html","og_locale":"zh_CN","og_type":"article","og_title":"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u6bd5\u4e1a\u8bba\u6587 \u6bd5\u4e1a\u8bbe\u8ba1 \u4e00\u3001\u9879\u76ee\u540d\u79f0&#xff1a; \u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf \u3010\u6458\u8981\u3011 \u57ce\u5e02\u5185\u6d9d\u662f\u6c5b\u671f\u516c\u5171\u5b89\u5168\u4e0e\u5e02\u653f\u6392\u6c34\u7ba1\u7406\u7684\u91cd\u8981\u8bae\u9898\u3002\u79ef\u6c34\u6df1\u5ea6\u3001\u5c0f\u65f6\u964d\u96e8\u3001\u9884\u8b66\u7b49\u7ea7\u7b49\u6307\u6807\u76f8\u4e92\u5173\u8054&#xff0c;\u4f46\u539f\u59cb\u6570\u636e\u5f80\u5f80\u5206\u6563\u5728\u6c14\u8c61\u63a5\u53e3\u3001\u6613\u6d9d\u70b9\u540d\u5f55\u4e0e\u6c34\u52a1\u76d1\u6d4b\u5e73\u53f0\u4e2d&#xff0c;\u5b58\u5728\u53e3\u5f84\u4e0d\u4e00\u3001\u96be\u4ee5\u6a2a\u5411\u5bf9\u6bd4\u3001\u7f3a\u5c11\u8d8b\u52bf\u7814\u5224\u7b49\u95ee\u9898\u3002\u672c\u6587\u8bbe\u8ba1\u5e76\u5b9e\u73b0\u4e86\u57fa\u4e8e Python \u4e0e Django \u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6","og_url":"https:\/\/www.wsisp.com\/helps\/89229.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-08-02T09:25:04+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/08\/20260802092501-6a6f0ced15c31.jpg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"15 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/89229.html","url":"https:\/\/www.wsisp.com\/helps\/89229.html","name":"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-08-02T09:25:04+00:00","dateModified":"2026-08-02T09:25:04+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/89229.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/89229.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/89229.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u57fa\u4e8ePython\u7684\u57ce\u5e02\u5185\u6d9d\u79ef\u6d9d\u76d1\u6d4b\u6570\u636e\u53ef\u89c6\u5316\u5206\u6790\u7cfb\u7edf"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/89229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=89229"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/89229\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/89217"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=89229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=89229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=89229"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=89229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}