Repository navigation
Expand file tree
/
Copy pathdata.sql
More file actions
271 lines (224 loc) · 86.6 KB
/
Copy pathdata.sql
File metadata and controls
271 lines (224 loc) · 86.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `citizen`
--
LOCK TABLES `citizen` WRITE;
/*!40000 ALTER TABLE `citizen` DISABLE KEYS */;
INSERT INTO `citizen` VALUES (1,'张三','zhangsan','e1644c223f8663e2f303a6769c876d8bcfad8c69bea216adbffe63e097923a04','fd17994ece29d340ace89e705245dfee5681a47a1a8e8a9768571f8b4ad2c434','2025-06-21 04:45:34','2025-06-26 20:02:15',0,NULL,NULL),(2,'李四','lisi','25358e02e336ed9a5e7ce8ff985c83c3a7a60ef65f7761b456893025e2898eda','86125f2cec354ad56521e70966e3dfaffd007b35fda0b63d2eb591523f2f2fca','2025-06-21 05:44:29','2025-06-21 05:44:30',0,NULL,NULL),(4,'赵网格','zhaowg','d4e5f6g7h8i9j0k1l2m3n4o5p6q7r8s9t0uvw','160e5950f4af3fe3dfef1b7fc6534140a5817af6f4e1b09d459f657e97c99c6c','2025-01-20 09:15:00','2025-06-25 20:59:25',1,'[\"非法砍伐\", \"草地退化\", \"工业废水排放\", \"河流富营养化\", \"工业废气排放\", \"建筑扬尘\", \"建筑工地噪音\", \"交通噪音\", \"生活垃圾堆积\", \"医疗废物违规处理\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"和平区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"苏家屯区\"}]'),(5,'钱巡查','qianxc','e5f6g7h8i9j0k1l2m3n4o5p6q7r8s9t0uvwx','34eba83e3577b7935d44b5706b716d3e3c82b7b115d5be30b6c9239e91176dae','2025-02-05 14:20:33','2025-06-21 08:45:10',1,'[\"工业固废堆放\", \"餐饮油烟污染\", \"化工厂泄漏\", \"娱乐场所噪音\", \"农田塑料污染\", \"黑臭水体\", \"非法砍伐\", \"草地退化\", \"工业废水排放\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"大连市\", \"level_3\": \"中山区\"}]'),(6,'孙环保','sunhb','f6g7h8i9j0k1l2m3n4o5p6q7r8s9t0uvwxy','71d3ddb0dbb48a8f7a91b0dcaec28c1582bd581c922e881430760784dbc93087','2025-03-12 11:30:15','2025-06-21 08:46:52',1,'[\"工业废气排放\", \"建筑扬尘\", \"建筑工地噪音\", \"交通噪音\", \"生活垃圾堆积\", \"医疗废物违规处理\", \"工业固废堆放\", \"餐饮油烟污染\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"抚顺市\", \"level_3\": \"新抚区\"}]'),(7,'周管理','zhougl','g7h8i9j0k1l2m3n4o5p6q7r8s9t0uvwxyz','80700f23da2f4b1023f1c259e981f7d2716db88f4c155cad354532728d95e02e','2025-01-05 08:30:00','2025-06-26 14:06:59',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"本溪市\", \"level_3\": \"平山区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"抚顺市\", \"level_3\": \"新抚区\"}]'),(8,'吴系统','wuxt','h8i9j0k1l2m3n4o5p6q7r8s9t0uvwxyza','052cf902edd2836a440c7a38f1a33c75cf39cee8f94ab933189043aa35740d1f','2025-02-15 10:45:22','2025-06-26 14:17:28',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"丹东市\", \"level_3\": \"振兴区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"大连市\", \"level_3\": \"中山区\"}]'),(9,'郑总监','zhengzj','i9j0k1l2m3n4o5p6q7r8s9t0uvwxyzab','a3c7bd86da5dadf52a5aca9ad376ebde3c84c801343f2718dee44c00bcdaaecb','2025-03-20 13:15:45','2025-06-20 20:26:34',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"锦州市\", \"level_3\": \"古塔区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"营口市\", \"level_3\": \"站前区\"}]'),(16,'韩巡查','hanxc','p6q7r8s9t0uvwxyzabcdefghi','f66eac52be32ca80a05cb0c822fc4c8b4ab733579daa75afefe9df1c1b384244','2025-04-20 09:30:45','2025-06-21 08:49:01',1,'[\"化工厂泄漏\", \"娱乐场所噪音\", \"农田塑料污染\", \"黑臭水体\", \"非法砍伐\", \"草地退化\", \"工业废水排放\", \"河流富营养化\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"营口市\", \"level_3\": \"站前区\"}]'),(17,'杨环保','yanghb','q7r8s9t0uvwxyzabcdefghij','d76fa523ffa953b370c1b7fd1e69066881bf4a4f8c013dad8d702d6ad19c7117','2025-05-01 14:15:33','2025-06-17 16:30:22',1,'[\"工业废气排放\", \"建筑扬尘\", \"建筑工地噪音\", \"交通噪音\", \"生活垃圾堆积\", \"医疗废物违规处理\", \"工业固废堆放\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"辽阳市\", \"level_3\": \"白塔区\"}]'),(18,'朱网格','zhuwg','r8s9t0uvwxyzabcdefghijk','6a0cb2310bbfadac275da91d2358903d58f6a4cf2a658fe8af6e46eb72b5f35b','2025-05-10 11:45:00','2025-06-18 09:15:45',1,'[\"餐饮油烟污染\", \"化工厂泄漏\", \"娱乐场所噪音\", \"农田塑料污染\", \"黑臭水体\", \"非法砍伐\", \"草地退化\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"盘锦市\", \"level_3\": \"兴隆台区\"}]'),(31,'沈阳沈河网格','syshwg','e1f2g3h4i5j6k7l8m9n0o1p2q3r','eacc7ad1d3dc690d7cd37e3a6778c56cbefe88f53481cb5ffd812fdd4783d344','2025-06-01 09:00:00','2025-06-18 13:30:45',1,'[\"工业废水排放\", \"河流富营养化\", \"工业废气排放\", \"建筑扬尘\", \"建筑工地噪音\", \"交通噪音\", \"生活垃圾堆积\", \"医疗废物违规处理\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"沈河区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"苏家屯区\"}]'),(32,'沈阳铁西巡查','sytxxc','f2g3h4i5j6k7l8m9n0o1p2q3r4s','c6308113e32aa848d97faa4c6e6e4ca252180370c2a2b788a5764b4ca7784567','2025-06-02 10:15:22','2025-06-17 15:20:33',1,'[\"工业固废堆放\", \"餐饮油烟污染\", \"化工厂泄漏\", \"娱乐场所噪音\", \"农田塑料污染\", \"黑臭水体\", \"非法砍伐\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"铁西区\"}]'),(33,'沈阳皇姑环保','syhghb','g3h4i5j6k7l8m9n0o1p2q3r4s5t','a07fd92afb187c8923ea9c23279e641f53ac722a1c0159a96bf3fd27b7aa706c','2025-06-03 11:30:45','2025-06-18 09:45:12',1,'[\"草地退化\", \"工业废水排放\", \"河流富营养化\", \"工业废气排放\", \"建筑扬尘\", \"建筑工地噪音\", \"交通噪音\", \"生活垃圾堆积\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"皇姑区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"苏家屯区\"}]'),(34,'沈阳大东网格','syddwg','h4i5j6k7l8m9n0o1p2q3r4s5t6u','64352a1cbd6101f8ba8c6cae82e19ff1758305a932aa0087840ac7c1e2616cd7','2025-06-04 12:45:15','2025-06-17 16:30:22',1,'[\"医疗废物违规处理\", \"工业固废堆放\", \"餐饮油烟污染\", \"化工厂泄漏\", \"娱乐场所噪音\", \"农田塑料污染\", \"黑臭水体\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"大东区\"}]'),(35,'沈阳于洪巡查','syxhxc','i5j6k7l8m9n0o1p2q3r4s5t6u7v','bc8540f265fa0e24b689b94ea89345eccc6fa5791628cce5da663dcf5532794a','2025-06-05 13:15:33','2025-06-18 10:30:45',1,'[\"非法砍伐\", \"草地退化\", \"工业废水排放\", \"河流富营养化\", \"工业废气排放\", \"建筑扬尘\", \"建筑工地噪音\", \"交通噪音\", \"生活垃圾堆积\"]','[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"于洪区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"苏家屯区\"}]'),(36,'沈阳苏家屯管理','sysjtgl','j6k7l8m9n0o1p2q3r4s5t6u7v8w','8fcc01c952aeddfa12af0597b9eb1f627178e9b0e6ddc6b5f3d9f0215b6cd845','2025-06-01 08:30:00','2025-06-26 21:36:15',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"苏家屯区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"和平区\"}]'),(37,'沈阳浑南系统','syhnxt','k7l8m9n0o1p2q3r4s5t6u7v8w9x','d8825e5a5e478992358536e09a6f08a3b1f823216228afe6a35a1d7fde3b6a07','2025-06-02 09:45:22','2025-06-21 23:12:38',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"浑南区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"沈河区\"}]'),(38,'沈阳沈北总监','sysbzj','l8m9n0o1p2q3r4s5t6u7v8w9x0y','794ca403aa8159ac8081cee6b77da6eaab769051b66ef855b247e7314d29fb13','2025-06-03 10:15:45','2025-06-20 20:40:54',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"沈北新区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"铁西区\"}]'),(39,'沈阳辽中管理','sylzgl','m9n0o1p2q3r4s5t6u7v8w9x0y1z','c0f599ca999838cd24589bc9139dddeb0f24c98cf72780a63bb44d32f6959444','2025-06-04 11:30:12','2025-06-20 20:47:13',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"辽中区\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"皇姑区\"}]'),(40,'沈阳康平系统','sykpxt','n0o1p2q3r4s5t6u7v8w9x0y1z2a','4139f2951a0dcfdc476ff290ba66e9582c3301cb089324eee007d9a881a8d644','2025-06-05 12:45:15','2025-06-20 20:49:02',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"康平县\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"大东区\"}]'),(41,'沈阳法库总监','sykpzj','o1p2q3r4s5t6u7v8w9x0y1z2a3b','495e5ce6dcb93fc83b8ffe449b0d8ce1e88c2266438e12e8eedd406408f4e8a6','2025-06-06 13:15:33','2025-06-20 20:50:21',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"法库县\"}, {\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"于洪区\"}]'),(42,'沈阳新民管理','synmgl','p2q3r4s5t6u7v8w9x0y1z2a3b4c','81a8ee5145f441689de007237d67d30791d169b817bbe46846e3b71613a10b2e','2025-06-07 14:30:00','2025-06-20 20:52:09',2,NULL,'[{\"level_1\": \"辽宁省\", \"level_2\": \"沈阳市\", \"level_3\": \"新民市\"}]'),(43,'冯决策','fengjc','69798e66b91d2ae2a869f680e984b21463d53ab03a8982559b8be348c66aee46','cf9c835a73c23b611ceb64a65a2f3476bfed125cc52c21ca7bd9e684a1b96fb4','2025-06-21 15:23:48','2025-06-25 21:15:46',3,NULL,NULL);
/*!40000 ALTER TABLE `citizen` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:29
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `complaint`
--
LOCK TABLES `complaint` WRITE;
/*!40000 ALTER TABLE `complaint` DISABLE KEYS */;
INSERT INTO `complaint` VALUES ('NEU120250619220255679394','zhangsan','工业废气排放','{\"lat\": \"41.79678077096892\", \"lng\": \"123.42585084473608\", \"address\": \"辽宁省沈阳市和平区十纬路20号\", \"division\": \"辽宁省沈阳市和平区\"}','空气明显污浊','null','[]','2025-06-19 22:02:55','{\"attributes\": [{\"name\": \"能见度(m)\", \"value\": 785.0, \"sortWay\": 2, \"description\": \"烟羽影响下的最小可视距离\"}, {\"name\": \"AQI估算值\", \"value\": 32.0, \"sortWay\": 2, \"description\": \"参考：轻微呛咳≈150，强烈刺激≈300\"}]}',1,1),('NEU120250620155004888244','zhangsan','黑臭水体','{\"lat\": \"41.780860245476276\", \"lng\": \"123.42355118263053\", \"address\": \"辽宁省沈阳市和平区光荣街65号\", \"division\": \"辽宁省沈阳市和平区\"}','河水发黑','null','[]','2025-06-20 15:50:04','{\"attributes\": [{\"name\": \"黑臭长度(m)\", \"value\": 961.0, \"sortWay\": 2, \"description\": \"水体发黑发臭的河段长度\"}, {\"name\": \"气泡密度(个/m²)\", \"value\": 5.8, \"sortWay\": 2, \"description\": \"水面每平方米气泡数量\"}]}',-1,0),('NEU120250620155222982803','zhangsan','交通噪音','{\"lat\": \"41.78817557618833\", \"lng\": \"123.41032812552365\", \"address\": \"辽宁省沈阳市和平区南三马路6号\", \"division\": \"辽宁省沈阳市和平区\"}','过往车辆鸣笛扰民','已经连续好几天睡不着觉了','[]','2025-06-20 15:52:22','{\"attributes\": [{\"name\": \"高峰分贝值(dB)\", \"value\": 73.0, \"sortWay\": 2, \"description\": \"站在路边测得的最大噪音值\"}, {\"name\": \"影响距离(m)\", \"value\": 944.0, \"sortWay\": 2, \"description\": \"噪音明显可闻的最远距离\"}]}',1,1),('NEU120250620155309084179','zhangsan','化工厂泄漏','{\"lat\": \"41.787314992693034\", \"lng\": \"123.42642576026246\", \"address\": \"辽宁省沈阳市和平区十四纬路16丙\", \"division\": \"辽宁省沈阳市和平区\"}','过往车辆鸣笛扰民','已经连续好几天睡不着觉了','[]','2025-06-20 15:53:09','{\"attributes\": [{\"name\": \"蒸气扩散(m)\", \"value\": 479.0, \"sortWay\": 2, \"description\": \"可见蒸气/烟雾扩散半径\"}, {\"name\": \"刺激距离(m)\", \"value\": 362.0, \"sortWay\": 2, \"description\": \"引发咳嗽/流泪的最远距离\"}]}',0,0),('NEU120250620155726645635','lisi','生活垃圾堆积','{\"lat\": \"41.80227333219184\", \"lng\": \"123.46546283198626\", \"address\": \"辽宁省沈阳市沈河区盛京路34号\", \"division\": \"辽宁省沈阳市沈河区\"}','小区楼下垃圾桶无人清理','两天前就开始了','[]','2025-06-20 15:57:26','{\"attributes\": [{\"name\": \"堆积体积(m³)\", \"value\": 19.4, \"sortWay\": 2, \"description\": \"目测垃圾总体积\"}, {\"name\": \"虫鼠密度(个/m²)\", \"value\": 9.5, \"sortWay\": 2, \"description\": \"每平方米可见虫鼠数\"}]}',-1,0),('NEU120250620160126460273','zhangsan','工业废气排放','{\"lat\": \"41.81823490479479\", \"lng\": \"123.38503184236268\", \"address\": \"辽宁省沈阳市铁西区小北一中路\", \"division\": \"辽宁省沈阳市铁西区\"}','工厂烟囱冒黑烟','感觉空气有异味','[]','2025-06-20 16:01:26','{\"attributes\": [{\"name\": \"能见度(m)\", \"value\": 906.0, \"sortWay\": 2, \"description\": \"烟羽影响下的最小可视距离\"}, {\"name\": \"AQI估算值\", \"value\": 19.0, \"sortWay\": 2, \"description\": \"参考：轻微呛咳≈150，强烈刺激≈300\"}]}',1,1),('NEU120250620160533260729','lisi','医疗废物违规处理','{\"lat\": \"41.52839856662896\", \"lng\": \"123.30741824630057\", \"address\": \"辽宁省沈阳市苏家屯区\", \"division\": \"辽宁省沈阳市苏家屯区\"}','医疗废弃物直接就扔在医院门口的垃圾桶','感觉空气有异味','[]','2025-06-20 16:05:33','{\"attributes\": [{\"name\": \"暴露面积(m²)\", \"value\": 339.0, \"sortWay\": 2, \"description\": \"未封装医疗废物面积\"}, {\"name\": \"针头密度(个/m²)\", \"value\": 75.7, \"sortWay\": 2, \"description\": \"每平方米可见针头数\"}]}',1,1),('NEU120250620160830522415','zhangsan','非法砍伐','{\"lat\": \"41.78946642960739\", \"lng\": \"123.32121621893384\", \"address\": \"辽宁省沈阳市于洪区\", \"division\": \"辽宁省沈阳市于洪区\"}','有人在砍路边的树','今天上午看到有人在砍行道树，砍了好几棵，一看就不是好人','[]','2025-06-20 16:08:30','{\"attributes\": [{\"name\": \"裸土面积(m²)\", \"value\": 988.0, \"sortWay\": 2, \"description\": \"树木移除后裸露面积\"}, {\"name\": \"树桩密度(个/100m²)\", \"value\": 66.3, \"sortWay\": 2, \"description\": \"每百平方米树桩数量\"}]}',1,1),('NEU120250620163426579318','zhangsan','娱乐场所噪音','{\"lat\": \"41.86966305939098\", \"lng\": \"124.00076637112195\", \"address\": \"辽宁省抚顺市新抚区\", \"division\": \"辽宁省抚顺市新抚区\"}','KTV太吵了','跟老板说过很多次都没用','[]','2025-06-20 16:34:26','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 71.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 79.5, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',1,1),('NEU120250620163643970247','lisi','化工厂泄漏','{\"lat\": \"38.924510904973296\", \"lng\": \"121.65155044790818\", \"address\": \"辽宁省大连市中山区一德街83号\", \"division\": \"辽宁省大连市中山区\"}','化工厂方向突然冒浓烟','非常刺鼻','[]','2025-06-20 16:36:43','{\"attributes\": [{\"name\": \"蒸气扩散(m)\", \"value\": 912.0, \"sortWay\": 2, \"description\": \"可见蒸气/烟雾扩散半径\"}, {\"name\": \"刺激距离(m)\", \"value\": 213.0, \"sortWay\": 2, \"description\": \"引发咳嗽/流泪的最远距离\"}]}',1,1),('NEU120250620163957720637','lisi','餐饮油烟污染','{\"lat\": \"38.90908076905424\", \"lng\": \"121.6401632197815\", \"address\": \"辽宁省大连市中山区\", \"division\": \"辽宁省大连市中山区\"}','楼下酒店把油烟排到下水道','下水道口能闻到油烟味','[]','2025-06-20 16:39:57','{\"attributes\": [{\"name\": \"PM2.5估算值(μg/m³)\", \"value\": 92.2, \"sortWay\": 2, \"description\": \"参考：可见油烟≈150+，浓烟≈300+\"}, {\"name\": \"影响半径(m)\", \"value\": 308.0, \"sortWay\": 2, \"description\": \"油烟明显可闻的范围直径\"}]}',1,1),('NEU120250620164134725120','zhangsan','建筑扬尘','{\"lat\": \"38.922892709534594\", \"lng\": \"121.66660933399524\", \"address\": \"辽宁省大连市中山区福利街13号\", \"division\": \"辽宁省大连市中山区\"}','建筑工地扬尘严重','下水道口能闻到油烟味','[]','2025-06-20 16:41:34','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": 39.3, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": 342.0, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}',1,1),('NEU120250620164331913557','zhangsan','河流富营养化','{\"lat\": \"38.942651422679106\", \"lng\": \"121.64763712162451\", \"address\": \"辽宁省大连市西岗区\", \"division\": \"辽宁省大连市西岗区\"}','河流入海口一段有很多藻类','昨晚还没看到，今早起床就有了','[]','2025-06-20 16:43:31','{\"attributes\": [{\"name\": \"藻类覆盖率(%)\", \"value\": 16.9, \"sortWay\": 2, \"description\": \"藻类覆盖水面百分比\"}, {\"name\": \"浑浊度(cm)\", \"value\": 3.5, \"sortWay\": 2, \"description\": \"可见水深（如能见底为100cm）\"}]}',-1,0),('NEU120250620164605516833','lisi','交通噪音','{\"lat\": \"41.6975353145781\", \"lng\": \"123.33846368472541\", \"address\": \"辽宁省沈阳市苏家屯区\", \"division\": \"辽宁省沈阳市苏家屯区\"}','车辆鸣笛，吵到睡不着','出差住酒店，附近街道车流量大，噪音真的很大','[]','2025-06-20 16:46:05','{\"attributes\": [{\"name\": \"高峰分贝值(dB)\", \"value\": 80.0, \"sortWay\": 2, \"description\": \"站在路边测得的最大噪音值\"}, {\"name\": \"影响距离(m)\", \"value\": 324.0, \"sortWay\": 2, \"description\": \"噪音明显可闻的最远距离\"}]}',1,1),('NEU120250620164852761605','zhangsan','工业废水排放','{\"lat\": \"40.665951669334646\", \"lng\": \"122.24727401564499\", \"address\": \"辽宁省营口市站前区福生路\", \"division\": \"辽宁省营口市站前区\"}','工业区违规排水','河水都黑了','[]','2025-06-20 16:48:52','{\"attributes\": [{\"name\": \"色度变化(m)\", \"value\": 308.0, \"sortWay\": 2, \"description\": \"污染水体的可见扩散距离\"}, {\"name\": \"异味强度(m)\", \"value\": 470.0, \"sortWay\": 2, \"description\": \"明显异味可闻的最远距离\"}]}',1,1),('NEU120250620164936096143','lisi','交通噪音','{\"lat\": \"40.683023501350654\", \"lng\": \"122.25647266406718\", \"address\": \"辽宁省营口市站前区辽河大街东77-甲2\", \"division\": \"辽宁省营口市站前区\"}','好吵啊','河水都黑了','[]','2025-06-20 16:49:36','{\"attributes\": [{\"name\": \"高峰分贝值(dB)\", \"value\": 71.0, \"sortWay\": 2, \"description\": \"站在路边测得的最大噪音值\"}, {\"name\": \"影响距离(m)\", \"value\": 617.0, \"sortWay\": 2, \"description\": \"噪音明显可闻的最远距离\"}]}',0,0),('NEU120250620165022033166','lisi','娱乐场所噪音','{\"lat\": \"40.67470700530543\", \"lng\": \"122.27486996091152\", \"address\": \"辽宁省营口市站前区良辰路\", \"division\": \"辽宁省营口市站前区\"}','空气中有臭味','河水都黑了','[]','2025-06-20 16:50:22','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 84.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 21.0, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',0,0),('NEU120250620165102240919','lisi','农田塑料污染','{\"lat\": \"40.565182049279464\", \"lng\": \"122.28176894722814\", \"address\": \"辽宁省营口市西市区\", \"division\": \"辽宁省营口市西市区\"}','真的好吵啊','河水都黑了','[]','2025-06-20 16:51:02','{\"attributes\": [{\"name\": \"残膜密度(个/m²)\", \"value\": 69.0, \"sortWay\": 2, \"description\": \"每平方米塑料残片数\"}, {\"name\": \"板结面积(m²)\", \"value\": 839.0, \"sortWay\": 2, \"description\": \"土壤硬化区域面积\"}]}',-1,0),('NEU120250620165451525399','lisi','工业固废堆放','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','厂房里运出来的废料就堆在空地上','异味很大，还没人处理','[]','2025-06-20 16:54:51','{\"attributes\": [{\"name\": \"堆放面积(m²)\", \"value\": 130.0, \"sortWay\": 2, \"description\": \"固废占地面积\"}, {\"name\": \"渗滤半径(m)\", \"value\": 733.0, \"sortWay\": 2, \"description\": \"污染物液体扩散距离\"}]}',1,1),('NEU120250620165712002862','zhangsan','草地退化','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','草地变荒地','几年前政府拨款造的草坪没人管','[]','2025-06-20 16:57:12','{\"attributes\": [{\"name\": \"沙化面积(m²)\", \"value\": 476.0, \"sortWay\": 2, \"description\": \"植被消失的沙化区域\"}, {\"name\": \"侵蚀沟深度(cm)\", \"value\": 97.8, \"sortWay\": 2, \"description\": \"地表侵蚀沟最大深度\"}]}',1,1),('NEU120250620165830446630','zhangsan','黑臭水体','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','河水突然变得很黑','几个月前还不是这样的','[]','2025-06-20 16:58:30','{\"attributes\": [{\"name\": \"黑臭长度(m)\", \"value\": 672.0, \"sortWay\": 2, \"description\": \"水体发黑发臭的河段长度\"}, {\"name\": \"气泡密度(个/m²)\", \"value\": 24.7, \"sortWay\": 2, \"description\": \"水面每平方米气泡数量\"}]}',1,0),('NEU120250620165902469028','lisi','娱乐场所噪音','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','河水突然变得很黑','几个月前还不是这样的','[]','2025-06-20 16:59:02','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 70.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 88.4, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',0,0),('NEU120250620170033356585','zhangsan','娱乐场所噪音','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','楼下的夜市很吵','凌晨两点还有酒鬼大喊大叫','[]','2025-06-20 17:00:33','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 73.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 57.8, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',1,1),('NEU120250620170159300585','zhangsan','工业废气排放','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','工业区内很多工厂都在违规排放废气','几年了都没人敢管','[]','2025-06-20 17:01:59','{\"attributes\": [{\"name\": \"能见度(m)\", \"value\": 598.0, \"sortWay\": 2, \"description\": \"烟羽影响下的最小可视距离\"}, {\"name\": \"AQI估算值\", \"value\": 3.0, \"sortWay\": 2, \"description\": \"参考：轻微呛咳≈150，强烈刺激≈300\"}]}',1,1),('NEU120250620170330870207','zhangsan','建筑扬尘','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','工业区修新厂房尘土飞扬','几年了都没人敢管','[]','2025-06-20 17:03:30','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": 50.2, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": 470.0, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}',1,1),('NEU120250620170722433187','lisi','农田塑料污染','{\"lat\": \"41.69882800527914\", \"lng\": \"123.18323649260122\", \"address\": \"辽宁省沈阳市铁西区浑河二十三西街\", \"division\": \"辽宁省沈阳市铁西区\"}','农田里很多塑料袋','很多都是半埋在土里','[]','2025-06-20 17:07:22','{\"attributes\": [{\"name\": \"残膜密度(个/m²)\", \"value\": 55.2, \"sortWay\": 2, \"description\": \"每平方米塑料残片数\"}, {\"name\": \"板结面积(m²)\", \"value\": 573.0, \"sortWay\": 2, \"description\": \"土壤硬化区域面积\"}]}',1,1),('NEU120250620171007376691','zhangsan','工业废水排放','{\"lat\": \"41.82968489977373\", \"lng\": \"123.56038107791036\", \"address\": \"辽宁省沈阳市沈河区马官桥北街\", \"division\": \"辽宁省沈阳市沈河区\"}','排水口能看出来水很黑','我今天亲眼看到的','[]','2025-06-20 17:10:07','{\"attributes\": [{\"name\": \"色度变化(m)\", \"value\": 976.0, \"sortWay\": 2, \"description\": \"污染水体的可见扩散距离\"}, {\"name\": \"异味强度(m)\", \"value\": 362.0, \"sortWay\": 2, \"description\": \"明显异味可闻的最远距离\"}]}',-1,0),('NEU120250620171422430681','lisi','娱乐场所噪音','{\"lat\": \"41.16450017918989\", \"lng\": \"122.07650285245835\", \"address\": \"辽宁省盘锦市兴隆台区双兴中路141号\", \"division\": \"辽宁省盘锦市兴隆台区\"}','小区附近的小吃摊很吵','半个月了，物业去交涉也没用','[]','2025-06-20 17:14:22','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 76.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 79.3, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',1,1),('NEU120250620171617032063','zhangsan','建筑工地噪音','{\"lat\": \"41.276045625723\", \"lng\": \"123.18115812113334\", \"address\": \"辽宁省辽阳市白塔区民主路33号\", \"division\": \"辽宁省辽阳市白塔区\"}','ahkhokbhhb','半个月了，物业去交涉也没用','[]','2025-06-20 17:16:17','{\"attributes\": [{\"name\": \"设备分贝值(dB)\", \"value\": 71.0, \"sortWay\": 2, \"description\": \"离声源最近居民家测得值\"}, {\"name\": \"夜间施工(h)\", \"value\": 45.0, \"sortWay\": 2, \"description\": \"晚10点后持续施工时间\"}]}',1,1),('NEU120250620171903758497','lisi','生活垃圾堆积','{\"lat\": \"41.80172823090811\", \"lng\": \"123.29477010472009\", \"address\": \"辽宁省沈阳市于洪区沈大路65号\", \"division\": \"辽宁省沈阳市于洪区\"}','一周都没人来清理我们小区里的垃圾','现在我们家小孩都不愿意下楼玩了，太脏了','[]','2025-06-20 17:19:03','{\"attributes\": [{\"name\": \"堆积体积(m³)\", \"value\": 15.3, \"sortWay\": 2, \"description\": \"目测垃圾总体积\"}, {\"name\": \"虫鼠密度(个/m²)\", \"value\": 41.4, \"sortWay\": 2, \"description\": \"每平方米可见虫鼠数\"}]}',1,1),('NEU120250620172509626966','lisi','化工厂泄漏','{\"lat\": \"41.91219279215771\", \"lng\": \"123.50518918737733\", \"address\": \"辽宁省沈阳市大东区\", \"division\": \"辽宁省沈阳市大东区\"}','化工厂方向传来很大的声响，好像爆炸了','是不是泄露了','[]','2025-06-20 17:25:09','{\"attributes\": [{\"name\": \"蒸气扩散(m)\", \"value\": 652.0, \"sortWay\": 2, \"description\": \"可见蒸气/烟雾扩散半径\"}, {\"name\": \"刺激距离(m)\", \"value\": 840.0, \"sortWay\": 2, \"description\": \"引发咳嗽/流泪的最远距离\"}]}',1,1),('NEU120250620173321211685','zhangsan','交通噪音','{\"lat\": \"41.76773357379823\", \"lng\": \"123.42240135157776\", \"address\": \"辽宁省沈阳市和平区文体西路6号\", \"division\": \"辽宁省沈阳市和平区\"}','近期主干道车流量变大，噪声影响变大','是不是泄露了','[]','2025-06-20 17:33:21','{\"attributes\": [{\"name\": \"高峰分贝值(dB)\", \"value\": 68.0, \"sortWay\": 2, \"description\": \"站在路边测得的最大噪音值\"}, {\"name\": \"影响距离(m)\", \"value\": 905.0, \"sortWay\": 2, \"description\": \"噪音明显可闻的最远距离\"}]}',1,1),('NEU120250620183709817012','lisi','非法砍伐','{\"lat\": \"41.77720226477214\", \"lng\": \"123.40630371683895\", \"address\": \"辽宁省沈阳市和平区和平南大街91-甲2号\", \"division\": \"辽宁省沈阳市和平区\"}','有人在砍行道树','沿街的行道树几乎全被砍掉了','[]','2025-06-20 18:37:09','{\"attributes\": [{\"name\": \"裸土面积(m²)\", \"value\": 689.0, \"sortWay\": 2, \"description\": \"树木移除后裸露面积\"}, {\"name\": \"树桩密度(个/100m²)\", \"value\": 58.9, \"sortWay\": 2, \"description\": \"每百平方米树桩数量\"}]}',1,1),('NEU120250620183918753027','zhangsan','交通噪音','{\"lat\": \"41.8260438000918\", \"lng\": \"123.4316236634254\", \"address\": \"辽宁省沈阳市皇姑区庐山路6号\", \"division\": \"辽宁省沈阳市皇姑区\"}','昨天晚上有人长时间按喇叭','沿街的行道树几乎全被砍掉了','[]','2025-06-20 18:39:18','{\"attributes\": [{\"name\": \"高峰分贝值(dB)\", \"value\": 89.0, \"sortWay\": 2, \"description\": \"站在路边测得的最大噪音值\"}, {\"name\": \"影响距离(m)\", \"value\": 224.0, \"sortWay\": 2, \"description\": \"噪音明显可闻的最远距离\"}]}',0,0),('NEU120250620184203877818','zhangsan','建筑工地噪音','{\"lat\": \"41.79995364280187\", \"lng\": \"123.31647316584116\", \"address\": \"辽宁省沈阳市于洪区黄海路33号\", \"division\": \"辽宁省沈阳市于洪区\"}','住户装修噪音扰民','专挑中午装修，影响其他住户休息','[]','2025-06-20 18:42:03','{\"attributes\": [{\"name\": \"设备分贝值(dB)\", \"value\": 82.0, \"sortWay\": 2, \"description\": \"离声源最近居民家测得值\"}, {\"name\": \"夜间施工(h)\", \"value\": 32.4, \"sortWay\": 2, \"description\": \"晚10点后持续施工时间\"}]}',1,1),('NEU120250620185728685267','lisi','农田塑料污染','{\"lat\": \"40.67876344201284\", \"lng\": \"122.26543446731691\", \"address\": \"辽宁省营口市站前区新兴大街东49\", \"division\": \"辽宁省营口市站前区\"}','有人偷埋塑料在农田里','专挑中午装修，影响其他住户休息','[]','2025-06-20 18:57:28','{\"attributes\": [{\"name\": \"残膜密度(个/m²)\", \"value\": 37.9, \"sortWay\": 2, \"description\": \"每平方米塑料残片数\"}, {\"name\": \"板结面积(m²)\", \"value\": 930.0, \"sortWay\": 2, \"description\": \"土壤硬化区域面积\"}]}',0,0),('NEU120250620190017212576','zhangsan','工业固废堆放','{\"lat\": \"41.81142436799772\", \"lng\": \"123.47640419309779\", \"address\": \"辽宁省沈阳市大东区津桥路20号\", \"division\": \"辽宁省沈阳市大东区\"}','工厂把废料堆放在路边','已经堆积成山','[]','2025-06-20 19:00:17','{\"attributes\": [{\"name\": \"堆放面积(m²)\", \"value\": 525.0, \"sortWay\": 2, \"description\": \"固废占地面积\"}, {\"name\": \"渗滤半径(m)\", \"value\": 635.0, \"sortWay\": 2, \"description\": \"污染物液体扩散距离\"}]}',1,1),('NEU120250620190410666329','lisi','医疗废物违规处理','{\"lat\": \"41.86515065682348\", \"lng\": \"123.91970328190155\", \"address\": \"辽宁省抚顺市新抚区迎宾四路4号\", \"division\": \"辽宁省抚顺市新抚区\"}','有人医疗废弃物直接带走了','那个人没有穿医生的衣服','[]','2025-06-20 19:04:10','{\"attributes\": [{\"name\": \"暴露面积(m²)\", \"value\": 603.0, \"sortWay\": 2, \"description\": \"未封装医疗废物面积\"}, {\"name\": \"针头密度(个/m²)\", \"value\": 0.8, \"sortWay\": 2, \"description\": \"每平方米可见针头数\"}]}',1,1),('NEU120250620190750425118','lisi','黑臭水体','{\"lat\": \"41.80409427135942\", \"lng\": \"123.37640810946688\", \"address\": \"辽宁省沈阳市铁西区贵和街6-1号7门\", \"division\": \"辽宁省沈阳市铁西区\"}','今天看到门口的小河水的颜色不对','感觉以后不是这样的','[]','2025-06-20 19:07:50','{\"attributes\": [{\"name\": \"黑臭长度(m)\", \"value\": 426.0, \"sortWay\": 2, \"description\": \"水体发黑发臭的河段长度\"}, {\"name\": \"气泡密度(个/m²)\", \"value\": 78.8, \"sortWay\": 2, \"description\": \"水面每平方米气泡数量\"}]}',1,1),('NEU120250620191758706411','zhangsan','建筑扬尘','{\"lat\": \"41.80227333219184\", \"lng\": \"123.46546283198626\", \"address\": \"辽宁省沈阳市沈河区盛京路34号\", \"division\": \"辽宁省沈阳市沈河区\"}','小区住户装修，水泥灰飘得到处都是','跟住户交涉过，没用','[]','2025-06-20 19:17:58','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": 85.6, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": 922.0, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}',1,1),('NEU120250620192649951493','lisi','娱乐场所噪音','{\"lat\": \"41.812697312761415\", \"lng\": \"123.38215726473074\", \"address\": \"辽宁省沈阳市铁西区北二中路7号-3门\", \"division\": \"辽宁省沈阳市铁西区\"}','楼下的迪厅好吵','跟住户交涉过，没用','[]','2025-06-20 19:26:49','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 90.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 24.9, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',1,1),('NEU120250620193012175946','zhangsan','餐饮油烟污染','{\"lat\": \"41.81142436799772\", \"lng\": \"123.47640419309779\", \"address\": \"辽宁省沈阳市大东区津桥路20号\", \"division\": \"辽宁省沈阳市大东区\"}','大排档违规排放油烟','店家直接把抽油烟机的油烟往街道上排','[]','2025-06-20 19:30:12','{\"attributes\": [{\"name\": \"PM2.5估算值(μg/m³)\", \"value\": 25.1, \"sortWay\": 2, \"description\": \"参考：可见油烟≈150+，浓烟≈300+\"}, {\"name\": \"影响半径(m)\", \"value\": 558.0, \"sortWay\": 2, \"description\": \"油烟明显可闻的范围直径\"}]}',1,1),('NEU120250620193319617933','zhangsan','河流富营养化','{\"lat\": \"41.79549006595432\", \"lng\": \"123.42412609815692\", \"address\": \"辽宁省沈阳市和平区十纬路5-1号\", \"division\": \"辽宁省沈阳市和平区\"}','一夜之间突然冒出好多藻类','感觉有点像书上说的富营养化','[]','2025-06-20 19:33:19','{\"attributes\": [{\"name\": \"藻类覆盖率(%)\", \"value\": 79.3, \"sortWay\": 2, \"description\": \"藻类覆盖水面百分比\"}, {\"name\": \"浑浊度(cm)\", \"value\": 43.8, \"sortWay\": 2, \"description\": \"可见水深（如能见底为100cm）\"}]}',1,1),('NEU120250620193554021949','lisi','化工厂泄漏','{\"lat\": \"38.924510904973296\", \"lng\": \"121.65155044790818\", \"address\": \"辽宁省大连市中山区一德街83号\", \"division\": \"辽宁省大连市中山区\"}','化工厂有好几处冒烟','会不会爆炸，好害怕','[]','2025-06-20 19:35:54','{\"attributes\": [{\"name\": \"蒸气扩散(m)\", \"value\": 828.0, \"sortWay\": 2, \"description\": \"可见蒸气/烟雾扩散半径\"}, {\"name\": \"刺激距离(m)\", \"value\": 758.0, \"sortWay\": 2, \"description\": \"引发咳嗽/流泪的最远距离\"}]}',1,1),('NEU120250620193912264300','lisi','建筑扬尘','{\"lat\": \"41.86971677653633\", \"lng\": \"123.91079209124257\", \"address\": \"辽宁省抚顺市新抚区东一路5-1号\", \"division\": \"辽宁省抚顺市新抚区\"}','隔壁小区建筑工地粉尘多到呼吸困难','真的很呛','[]','2025-06-20 19:39:12','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": 22.8, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": 952.0, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}',-1,0),('NEU120250620194357350525','lisi','非法砍伐','{\"lat\": \"40.67876344201284\", \"lng\": \"122.26543446731691\", \"address\": \"辽宁省营口市站前区新兴大街东49\", \"division\": \"辽宁省营口市站前区\"}','我家门前的小树林被砍掉了将近三分之一','平时都是外出务工，半年没回来，自家种的林子就被别人砍掉了','[]','2025-06-20 19:43:57','{\"attributes\": [{\"name\": \"裸土面积(m²)\", \"value\": 144.0, \"sortWay\": 2, \"description\": \"树木移除后裸露面积\"}, {\"name\": \"树桩密度(个/100m²)\", \"value\": 40.6, \"sortWay\": 2, \"description\": \"每百平方米树桩数量\"}]}',1,1),('NEU120250620194704672053','zhangsan','生活垃圾堆积','{\"lat\": \"41.276892118486515\", \"lng\": \"123.1924351410234\", \"address\": \"辽宁省辽阳市白塔区新华路230号\", \"division\": \"辽宁省辽阳市白塔区\"}','很多人在路口电线杆下放置垃圾','张贴警告也没用，环卫工人也不会处理，已经臭了','[]','2025-06-20 19:47:04','{\"attributes\": [{\"name\": \"堆积体积(m³)\", \"value\": 88.1, \"sortWay\": 2, \"description\": \"目测垃圾总体积\"}, {\"name\": \"虫鼠密度(个/m²)\", \"value\": 18.9, \"sortWay\": 2, \"description\": \"每平方米可见虫鼠数\"}]}',1,1),('NEU120250620195120425757','lisi','黑臭水体','{\"lat\": \"41.161200112483094\", \"lng\": \"122.07364952667646\", \"address\": \"辽宁省盘锦市兴隆台区工业街\", \"division\": \"辽宁省盘锦市兴隆台区\"}','工厂旁边的水塘都臭了','很臭非常臭','[]','2025-06-20 19:51:20','{\"attributes\": [{\"name\": \"黑臭长度(m)\", \"value\": 370.0, \"sortWay\": 2, \"description\": \"水体发黑发臭的河段长度\"}, {\"name\": \"气泡密度(个/m²)\", \"value\": 93.6, \"sortWay\": 2, \"description\": \"水面每平方米气泡数量\"}]}',1,1),('NEU120250620195347030433','lisi','医疗废物违规处理','{\"lat\": \"41.80764316698414\", \"lng\": \"123.45804611421369\", \"address\": \"辽宁省沈阳市沈河区中街路48号\", \"division\": \"辽宁省沈阳市沈河区\"}','wddwdw','vdsdsvdv','[]','2025-06-20 19:53:47','{\"attributes\": [{\"name\": \"暴露面积(m²)\", \"value\": 800.0, \"sortWay\": 2, \"description\": \"未封装医疗废物面积\"}, {\"name\": \"针头密度(个/m²)\", \"value\": 8.2, \"sortWay\": 2, \"description\": \"每平方米可见针头数\"}]}',-1,0),('NEU120250620195533305502','lisi','餐饮油烟污染','{\"lat\": \"41.80495462788032\", \"lng\": \"123.37813285604604\", \"address\": \"辽宁省沈阳市铁西区北四中路5号-1号-2门\", \"division\": \"辽宁省沈阳市铁西区\"}','油烟对着我们家阳台排','vdsdsvdv','[]','2025-06-20 19:55:33','{\"attributes\": [{\"name\": \"PM2.5估算值(μg/m³)\", \"value\": 7.8, \"sortWay\": 2, \"description\": \"参考：可见油烟≈150+，浓烟≈300+\"}, {\"name\": \"影响半径(m)\", \"value\": 230.0, \"sortWay\": 2, \"description\": \"油烟明显可闻的范围直径\"}]}',1,1),('NEU120250620195655213871','lisi','建筑扬尘','{\"lat\": \"41.82758857610686\", \"lng\": \"123.43016271118397\", \"address\": \"辽宁省沈阳市皇姑区岐山中路11-4号\", \"division\": \"辽宁省沈阳市皇姑区\"}','建筑翻修尘土飞扬','vdsdsvdv','[]','2025-06-20 19:56:55','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": 48.5, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": 995.0, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}',1,1),('NEU120250620195834281647','zhangsan','娱乐场所噪音','{\"lat\": \"41.814673159447075\", \"lng\": \"123.47597629219284\", \"address\": \"辽宁省沈阳市大东区大什字街239号\", \"division\": \"辽宁省沈阳市大东区\"}','楼下的大排档整天吵吵闹闹的','半夜还有人大喊大叫','[]','2025-06-20 19:58:34','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": 76.0, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": 60.4, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}',1,1),('NEU120250620195922049094','zhangsan','建筑工地噪音','{\"lat\": \"41.79647826433089\", \"lng\": \"123.32104554088694\", \"address\": \"辽宁省沈阳市于洪区渤海路\", \"division\": \"辽宁省沈阳市于洪区\"}','hhhhhjk','wscwwdc','[]','2025-06-20 19:59:22','{\"attributes\": [{\"name\": \"设备分贝值(dB)\", \"value\": 74.0, \"sortWay\": 2, \"description\": \"离声源最近居民家测得值\"}, {\"name\": \"夜间施工(h)\", \"value\": 53.0, \"sortWay\": 2, \"description\": \"晚10点后持续施工时间\"}]}',0,0),('NEU120250621080301257938','zhangsan','工业废水排放','{\"lat\": \"41.79481781338693\", \"lng\": \"123.43116881335514\", \"address\": \"辽宁省沈阳市和平区东纬路17号\", \"division\": \"辽宁省沈阳市和平区\"}','疑似工业废水排放','工厂排放出难闻水体','[]','2025-06-21 08:03:01','{\"attributes\": [{\"name\": \"色度变化(m)\", \"value\": -1.0, \"sortWay\": 2, \"description\": \"污染水体的可见扩散距离\"}, {\"name\": \"异味强度(m)\", \"value\": -1.0, \"sortWay\": 2, \"description\": \"明显异味可闻的最远距离\"}]}',1,2),('NEU120250621081459406945','zhangsan','建筑扬尘','{\"lat\": \"41.795758964992075\", \"lng\": \"123.41981423170901\", \"address\": \"辽宁省沈阳市和平区和平北大街103号\", \"division\": \"辽宁省沈阳市和平区\"}','疑似建筑扬尘','工厂排放出难闻水体','[]','2025-06-21 08:14:59','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": 150.0, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": 15.0, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}',1,1),('NEU120250621192551212523','zhangsan','工业废气排放','{\"lat\": \"41.66696696292582\", \"lng\": \"123.35800977264647\", \"address\": \"辽宁省沈阳市苏家屯区美杨路16\", \"division\": \"辽宁省沈阳市苏家屯区\"}','测试标题','测试备注','[\"e57e07ae-c878-43e9-819f-4cc971158bd1.png\"]','2025-06-21 19:25:51','{\"attributes\": [{\"name\": \"能见度(m)\", \"value\": 40.0, \"sortWay\": 2.0, \"description\": \"烟羽影响下的最小可视距离\"}, {\"name\": \"AQI估算值\", \"value\": 40.0, \"sortWay\": 2.0, \"description\": \"参考：轻微呛咳≈150，强烈刺激≈300\"}]}',1,1);
/*!40000 ALTER TABLE `complaint` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:29
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `complaintprogress`
--
LOCK TABLES `complaintprogress` WRITE;
/*!40000 ALTER TABLE `complaintprogress` DISABLE KEYS */;
INSERT INTO `complaintprogress` VALUES ('NEU120250608190726404674',-1,'调监控发现不实','2025-06-14 22:40:35','johnsmith',6,NULL,NULL),('NEU120250617192930363176',-1,'4','2025-06-17 20:02:03','user_test1',31,NULL,NULL),('NEU120250620164936096143',-1,'内容与举报类型不符','2025-06-20 17:38:02','zhengzj',32,NULL,NULL),('NEU120250620165022033166',-1,'内容与举报类型不符','2025-06-20 17:38:54','zhengzj',33,NULL,NULL),('NEU120250620165902469028',-1,'内容与类型不符','2025-06-20 17:51:13','youzj',34,NULL,NULL),('NEU120250620155309084179',-1,'内容与类型不符','2025-06-20 17:54:54','sysjtgl',35,NULL,NULL),('NEU120250620185728685267',-1,'内容与举报类型不符','2025-06-20 20:26:56','zhengzj',36,NULL,NULL),('NEU120250620183918753027',-1,'举报内容具有时效性，无法核实','2025-06-20 20:48:30','sylzgl',37,NULL,NULL),('NEU120250620195922049094',-1,'无效内容，无法确定具体情况','2025-06-20 20:50:57','sykpzj',38,NULL,NULL),('NEU120250619220255679394',0,'','2025-06-21 08:06:14','zhaowg',39,'[\"e68d863e-5efc-485a-a277-2630327f41ea.jpg\"]','{\"attributes\": [{\"name\": \"气味强度\", \"value\": 2.0, \"sortWay\": 2, \"description\": \"废气气味强度（1-5级）\"}, {\"name\": \"能见度\", \"value\": 500.0, \"sortWay\": 1, \"description\": \"空气能见度（米）\"}]}'),('NEU120250620155222982803',0,'','2025-06-21 08:06:27','zhaowg',40,'[\"0557bd30-1df7-48f3-b7de-e93f6ad01189.jpg\"]','{\"attributes\": [{\"name\": \"车流量\", \"value\": 1280.0, \"sortWay\": 2, \"description\": \"每小时车辆通过数\"}, {\"name\": \"峰值噪音\", \"value\": 74.0, \"sortWay\": 2, \"description\": \"最高分贝值（dB）\"}]}'),('NEU120250620173321211685',0,'车流量和峰值噪音均处于正常区间','2025-06-21 08:06:56','zhaowg',41,'[\"ccd18044-cb08-4245-b547-57a268926668.jpg\"]','{\"attributes\": [{\"name\": \"车流量\", \"value\": 400.0, \"sortWay\": 2, \"description\": \"每小时车辆通过数\"}, {\"name\": \"峰值噪音\", \"value\": 44.0, \"sortWay\": 2, \"description\": \"最高分贝值（dB）\"}]}'),('NEU120250619220255679394',1,'网格员数据测算不准','2025-06-21 08:09:38','sysjtgl',42,'[\"d6f6ed27-2bcd-4ed3-9968-433972891f4b.jpg\"]','{\"attributes\": [{\"name\": \"PM2.5\", \"value\": 81.0, \"sortWay\": 2, \"description\": \"PM2.5浓度（μg/m³）\"}, {\"name\": \"SO2浓度\", \"value\": 132.0, \"sortWay\": 2, \"description\": \"二氧化硫浓度（mg/m³）\"}]}'),('NEU120250620155222982803',1,'','2025-06-21 08:10:09','sysjtgl',43,'[\"9f4685dc-7ef2-49c3-82eb-3597052b6da4.jpg\"]','{\"attributes\": [{\"name\": \"等效声级\", \"value\": 73.0, \"sortWay\": 2, \"description\": \"Leq等效连续声级（dB）\"}, {\"name\": \"超标时长\", \"value\": 3.0, \"sortWay\": 2, \"description\": \"每日超标小时数\"}]}'),('NEU120250621081459406945',0,'','2025-06-21 08:19:33','zhaowg',44,'[\"aa9bfc39-55a1-4a61-a126-49e0a8dac29e.jpg\"]','{\"attributes\": [{\"name\": \"影响范围\", \"value\": 46.0, \"sortWay\": 2, \"description\": \"扬尘影响半径（米）\"}, {\"name\": \"扬尘浓度\", \"value\": 2.0, \"sortWay\": 2, \"description\": \"扬尘可见度等级（1-5）\"}]}'),('NEU120250620173321211685',1,'','2025-06-21 08:21:14','sysjtgl',45,'[\"86d9f582-e992-4b9c-b72b-45815171941b.jpg\"]','{\"attributes\": [{\"name\": \"等效声级\", \"value\": 68.0, \"sortWay\": 2, \"description\": \"Leq等效连续声级（dB）\"}, {\"name\": \"超标时长\", \"value\": 3.5, \"sortWay\": 2, \"description\": \"每日超标小时数\"}]}'),('NEU120250621080301257938',0,'','2025-06-21 08:25:16','zhaowg',46,'[\"e5b6230a-3585-4038-a159-aca91be9f84b.jpg\"]','{\"attributes\": [{\"name\": \"pH值\", \"value\": 5.4, \"sortWay\": 1, \"description\": \"水体酸碱度\"}, {\"name\": \"COD浓度\", \"value\": 48.0, \"sortWay\": 2, \"description\": \"化学需氧量（mg/L）\"}]}'),('NEU120250621080301257938',1,'','2025-06-21 08:26:10','sysjtgl',47,'[\"42b10a25-82d8-476e-9846-2348fc07733f.jpg\"]','{\"attributes\": [{\"name\": \"重金属含量\", \"value\": 5.5, \"sortWay\": 2, \"description\": \"重金属超标倍数\"}, {\"name\": \"毒性等级\", \"value\": 44.0, \"sortWay\": 2, \"description\": \"废水毒性等级（1-5级）\"}]}'),('NEU120250621080301257938',2,'','2025-06-21 08:29:26','zhaowg',48,'[\"ee36998f-6903-45b1-854f-5a68463415a7.jpg\"]','{\"attributes\": [{\"name\": \"整改完成度\", \"value\": 95.0, \"sortWay\": 1, \"description\": \"整改措施完成百分比\"}, {\"name\": \"复查水质\", \"value\": 97.0, \"sortWay\": 1, \"description\": \"复查水质达标率\"}]}'),('NEU120250620193319617933',0,'','2025-06-21 19:50:53','zhaowg',49,'[\"982ba65f-5426-4d92-8a39-d7f9ad892929.jpg\"]','{\"attributes\": [{\"name\": \"藻类覆盖率\", \"value\": 76.0, \"sortWay\": 2, \"description\": \"水面藻类覆盖百分比\"}, {\"name\": \"水体透明度\", \"value\": 38.0, \"sortWay\": 1, \"description\": \"水体能见度（cm）\"}]}');
/*!40000 ALTER TABLE `complaintprogress` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:29
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `complaintprogresstask`
--
LOCK TABLES `complaintprogresstask` WRITE;
/*!40000 ALTER TABLE `complaintprogresstask` DISABLE KEYS */;
INSERT INTO `complaintprogresstask` VALUES ('NEU120250620163643970247',0,'2025-06-20 17:34:40','2025-06-24 23:59:59','qianxc',1,14,NULL),('NEU120250620163957720637',0,'2025-06-20 17:35:56','2025-06-21 23:59:59','qianxc',1,15,NULL),('NEU120250620165712002862',0,'2025-06-20 17:51:58','2025-06-21 23:59:59','zhuwg',0,16,NULL),('NEU120250620165830446630',0,'2025-06-20 17:52:19','2025-06-21 23:59:59','zhuwg',0,17,NULL),('NEU120250620170033356585',0,'2025-06-20 17:52:26','2025-06-21 23:59:59','zhuwg',0,18,NULL),('NEU120250620171422430681',0,'2025-06-20 17:52:41','2025-06-21 23:59:59','zhuwg',0,19,NULL),('NEU120250619220255679394',0,'2025-06-20 17:55:35','2025-06-21 23:59:59','zhaowg',2,20,NULL),('NEU120250620155222982803',0,'2025-06-20 17:55:39','2025-06-21 23:59:59','zhaowg',2,21,NULL),('NEU120250620172509626966',0,'2025-06-20 18:00:15','2025-06-21 23:59:59','syddwg',0,22,NULL),('NEU120250620160830522415',0,'2025-06-20 18:00:50','2025-06-21 23:59:59','syxhxc',0,23,NULL),('NEU120250620171903758497',0,'2025-06-20 18:00:56','2025-06-21 23:59:59','syxhxc',0,24,NULL),('NEU120250620190410666329',0,'2025-06-20 20:00:28','2025-06-22 23:59:59','sunhb',0,25,NULL),('NEU120250620193912264300',0,'2025-06-20 20:00:40','2025-06-22 23:59:59','sunhb',1,26,NULL),('NEU120250620193554021949',0,'2025-06-20 20:02:10','2025-06-22 23:59:59','qianxc',1,27,NULL),('NEU120250620164852761605',0,'2025-06-20 20:27:44','2025-06-22 23:59:59','hanxc',1,28,NULL),('NEU120250620194357350525',0,'2025-06-20 20:27:52','2025-06-22 23:59:59','hanxc',1,29,NULL),('NEU120250620171617032063',0,'2025-06-20 20:29:10','2025-06-22 23:59:59','yanghb',0,30,NULL),('NEU120250620194704672053',0,'2025-06-20 20:29:35','2025-06-21 23:59:59','yanghb',0,31,NULL),('NEU120250620195120425757',0,'2025-06-20 20:31:44','2025-06-22 23:59:59','zhuwg',0,32,NULL),('NEU120250620173321211685',0,'2025-06-20 20:34:15','2025-06-21 23:59:59','zhaowg',2,33,NULL),('NEU120250620183709817012',0,'2025-06-20 20:34:29','2025-06-24 23:59:59','zhaowg',0,34,'[{\"detail\": \"数据不足\", \"report_date\": \"2025-06-20 21:22:07\", \"retract_date\": \"2025-06-21 08:07:19\", \"agent_username\": \"sysjtgl\"}]'),('NEU120250620193319617933',0,'2025-06-20 20:34:40','2025-06-30 23:59:59','zhaowg',2,35,NULL),('NEU120250620170722433187',0,'2025-06-20 20:45:52','2025-06-24 23:59:59','sytxxc',0,36,NULL),('NEU120250620190750425118',0,'2025-06-20 20:46:12','2025-06-22 23:59:59','sytxxc',0,37,NULL),('NEU120250620192649951493',0,'2025-06-20 20:46:31','2025-06-27 23:59:59','sytxxc',0,38,NULL),('NEU120250620195533305502',0,'2025-06-20 20:46:43','2025-06-29 23:59:59','sytxxc',0,39,NULL),('NEU120250620195655213871',0,'2025-06-20 20:48:36','2025-06-23 23:59:59','syhghb',0,40,NULL),('NEU120250620190017212576',0,'2025-06-20 20:49:38','2025-06-22 23:59:59','syddwg',0,41,NULL),('NEU120250620193012175946',0,'2025-06-20 20:49:47','2025-06-23 23:59:59','syddwg',0,42,NULL),('NEU120250620195834281647',0,'2025-06-20 20:49:59','2025-06-30 23:59:59','syddwg',0,43,NULL),('NEU120250621080301257938',0,'2025-06-21 08:04:07','2025-06-30 23:59:59','zhaowg',2,44,NULL),('NEU120250619220255679394',2,'2025-06-21 08:12:41','2025-06-30 23:59:59','zhaowg',1,45,NULL),('NEU120250621081459406945',0,'2025-06-21 08:15:53','2025-06-29 23:59:59','zhaowg',2,46,NULL),('NEU120250620173321211685',2,'2025-06-21 08:21:35','2025-06-30 23:59:59','zhaowg',0,47,NULL),('NEU120250621080301257938',2,'2025-06-21 08:26:35','2025-06-30 23:59:59','zhaowg',2,48,NULL),('NEU120250621192551212523',0,'2025-06-21 19:46:10','2025-06-24 23:59:59','zhaowg',0,49,NULL);
/*!40000 ALTER TABLE `complaintprogresstask` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:29
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `complaintprogressuploaded`
--
LOCK TABLES `complaintprogressuploaded` WRITE;
/*!40000 ALTER TABLE `complaintprogressuploaded` DISABLE KEYS */;
INSERT INTO `complaintprogressuploaded` VALUES ('NEU120250620163957720637',0,'连着三栋居民楼低层用户都受到影响','2025-06-20 21:25:56','qianxc',33,'[\"73a533d3-8e91-406a-ba72-4bb7beb3f3bc.jpg\"]','{\"attributes\": [{\"name\": \"可见油烟\", \"value\": 3.0, \"sortWay\": 2, \"description\": \"油烟可见度等级（1-5级）\"}, {\"name\": \"影响范围\", \"value\": 314.0, \"sortWay\": 2, \"description\": \"受影响的居民户数\"}]}'),('NEU120250620193554021949',0,'泄露情况属实','2025-06-20 21:27:36','qianxc',34,'[\"1108d2d1-59b7-4ebe-9e5c-942623b0f58b.jpg\"]','{\"attributes\": [{\"name\": \"泄漏范围\", \"value\": 68.0, \"sortWay\": 2, \"description\": \"泄漏影响半径（米）\"}, {\"name\": \"气味强度\", \"value\": 1.0, \"sortWay\": 2, \"description\": \"化学品气味强度（1-5级）\"}]}'),('NEU120250620163643970247',0,'','2025-06-20 21:28:04','qianxc',35,'[\"1934472c-a61b-4b64-9d9a-a90f6d185c98.jpg\"]','{\"attributes\": [{\"name\": \"泄漏范围\", \"value\": 120.0, \"sortWay\": 2, \"description\": \"泄漏影响半径（米）\"}, {\"name\": \"气味强度\", \"value\": 3.0, \"sortWay\": 2, \"description\": \"化学品气味强度（1-5级）\"}]}'),('NEU120250620193912264300',0,'','2025-06-20 22:34:36','sunhb',36,'[\"81489181-361a-4042-80d5-2dce74f88f4c.jpg\"]','{\"attributes\": [{\"name\": \"影响范围\", \"value\": 50.0, \"sortWay\": 2, \"description\": \"扬尘影响半径（米）\"}, {\"name\": \"扬尘浓度\", \"value\": 2.0, \"sortWay\": 2, \"description\": \"扬尘可见度等级（1-5）\"}]}'),('NEU120250620164852761605',0,'水体污染严重','2025-06-20 22:37:13','hanxc',37,'[\"dac69933-670f-41cb-ab08-afc4a7646f11.jpg\"]','{\"attributes\": [{\"name\": \"pH值\", \"value\": 4.8, \"sortWay\": 1, \"description\": \"水体酸碱度\"}, {\"name\": \"COD浓度\", \"value\": 41.0, \"sortWay\": 2, \"description\": \"化学需氧量（mg/L）\"}]}'),('NEU120250620194357350525',0,'','2025-06-20 22:50:58','hanxc',38,'[\"246952d4-6fed-4c4c-b01f-494646091164.jpg\"]','{\"attributes\": [{\"name\": \"破坏面积\", \"value\": 48.0, \"sortWay\": 2, \"description\": \"植被破坏的面积（单位：平方米）\"}, {\"name\": \"树木数量\", \"value\": 32.0, \"sortWay\": 2, \"description\": \"被砍伐的树木数量\"}]}'),('NEU120250619220255679394',2,'','2025-06-21 08:24:06','zhaowg',41,'[\"219cebdf-0138-415d-b717-f413cffd2d2a.jpg\"]','{\"attributes\": [{\"name\": \"减排措施\", \"value\": 3.0, \"sortWay\": 1, \"description\": \"减排措施实施数量\"}, {\"name\": \"空气质量改善\", \"value\": 89.0, \"sortWay\": 1, \"description\": \"空气质量改善百分比\"}]}');
/*!40000 ALTER TABLE `complaintprogressuploaded` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:30
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `complainttype`
--
LOCK TABLES `complainttype` WRITE;
/*!40000 ALTER TABLE `complainttype` DISABLE KEYS */;
INSERT INTO `complainttype` VALUES ('交通噪音','噪音污染','{\"steps\": [{\"tip\": \"网格员记录交通流量\", \"needingAttributes\": {\"attributes\": [{\"name\": \"车流量\", \"value\": -1, \"sortWay\": 2, \"description\": \"每小时车辆通过数\"}, {\"name\": \"峰值噪音\", \"value\": -1, \"sortWay\": 2, \"description\": \"最高分贝值（dB）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门评估长期影响\", \"needingAttributes\": {\"attributes\": [{\"name\": \"等效声级\", \"value\": -1, \"sortWay\": 2, \"description\": \"Leq等效连续声级（dB）\"}, {\"name\": \"超标时长\", \"value\": -1, \"sortWay\": 2, \"description\": \"每日超标小时数\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员跟进降噪措施\", \"needingAttributes\": {\"attributes\": [{\"name\": \"隔音屏长度\", \"value\": -1, \"sortWay\": 1, \"description\": \"新增隔音屏长度（米）\"}, {\"name\": \"限速措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"实施的限速措施数量\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"高峰分贝值(dB)\", \"value\": -1, \"sortWay\": 2, \"description\": \"站在路边测得的最大噪音值\"}, {\"name\": \"影响距离(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"噪音明显可闻的最远距离\"}]}','icon_noise.png'),('农田塑料污染','固体废物污染','{\"steps\": [{\"tip\": \"网格员评估污染范围\", \"needingAttributes\": {\"attributes\": [{\"name\": \"污染面积\", \"value\": -1, \"sortWay\": 2, \"description\": \"受污染农田面积（亩）\"}, {\"name\": \"塑料密度\", \"value\": -1, \"sortWay\": 2, \"description\": \"单位面积塑料残留量（kg/亩）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"农业专家评估影响\", \"needingAttributes\": {\"attributes\": [{\"name\": \"土壤影响\", \"value\": -1, \"sortWay\": 2, \"description\": \"对土壤影响等级（1-5级）\"}, {\"name\": \"降解年限\", \"value\": -1, \"sortWay\": 2, \"description\": \"完全降解预计年限\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督清理\", \"needingAttributes\": {\"attributes\": [{\"name\": \"清理面积\", \"value\": -1, \"sortWay\": 1, \"description\": \"已清理农田面积（亩）\"}, {\"name\": \"替代措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"推广可降解材料面积（亩）\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"残膜密度(个/m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"每平方米塑料残片数\"}, {\"name\": \"板结面积(m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"土壤硬化区域面积\"}]}','塑料污染.png'),('化工厂泄漏','空气污染','{\"steps\": [{\"tip\": \"网格员初步评估泄漏\", \"needingAttributes\": {\"attributes\": [{\"name\": \"泄漏范围\", \"value\": -1, \"sortWay\": 2, \"description\": \"泄漏影响半径（米）\"}, {\"name\": \"气味强度\", \"value\": -1, \"sortWay\": 2, \"description\": \"化学品气味强度（1-5级）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保专家检测危害\", \"needingAttributes\": {\"attributes\": [{\"name\": \"有毒物质\", \"value\": -1, \"sortWay\": 2, \"description\": \"检测到有毒物质种类\"}, {\"name\": \"浓度超标\", \"value\": -1, \"sortWay\": 2, \"description\": \"超标倍数（相对于安全标准）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督处置\", \"needingAttributes\": {\"attributes\": [{\"name\": \"处置进度\", \"value\": -1, \"sortWay\": 1, \"description\": \"泄漏处置完成百分比\"}, {\"name\": \"环境恢复\", \"value\": -1, \"sortWay\": 1, \"description\": \"环境恢复程度评分（1-10）\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"蒸气扩散(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"可见蒸气/烟雾扩散半径\"}, {\"name\": \"刺激距离(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"引发咳嗽/流泪的最远距离\"}]}','化工厂.png'),('医疗废物违规处理','固体废物污染','{\"steps\": [{\"tip\": \"网格员记录废物类型\", \"needingAttributes\": {\"attributes\": [{\"name\": \"废物重量\", \"value\": -1, \"sortWay\": 2, \"description\": \"违规处理医疗废物重量（kg）\"}, {\"name\": \"危险等级\", \"value\": -1, \"sortWay\": 2, \"description\": \"医疗废物危险等级（1-3级）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门评估风险\", \"needingAttributes\": {\"attributes\": [{\"name\": \"污染范围\", \"value\": -1, \"sortWay\": 2, \"description\": \"可能受污染面积（平方米）\"}, {\"name\": \"健康风险\", \"value\": -1, \"sortWay\": 2, \"description\": \"对公众健康风险等级（1-5级）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督处置\", \"needingAttributes\": {\"attributes\": [{\"name\": \"专业处置量\", \"value\": -1, \"sortWay\": 1, \"description\": \"专业处置的废物量（kg）\"}, {\"name\": \"消毒面积\", \"value\": -1, \"sortWay\": 1, \"description\": \"现场消毒面积（平方米）\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"暴露面积(m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"未封装医疗废物面积\"}, {\"name\": \"针头密度(个/m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"每平方米可见针头数\"}]}','icon_solidrubbish.png'),('娱乐场所噪音','噪音污染','{\"steps\": [{\"tip\": \"网格员测量夜间噪音\", \"needingAttributes\": {\"attributes\": [{\"name\": \"夜间分贝\", \"value\": -1, \"sortWay\": 2, \"description\": \"夜间噪音值（dB）\"}, {\"name\": \"超时经营\", \"value\": -1, \"sortWay\": 2, \"description\": \"超时经营小时数\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门评估影响\", \"needingAttributes\": {\"attributes\": [{\"name\": \"影响居民\", \"value\": -1, \"sortWay\": 2, \"description\": \"受影响的居民户数\"}, {\"name\": \"历史违规\", \"value\": -1, \"sortWay\": 2, \"description\": \"历史违规次数\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督整改\", \"needingAttributes\": {\"attributes\": [{\"name\": \"隔音措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"新增隔音措施数量\"}, {\"name\": \"营业调整\", \"value\": -1, \"sortWay\": 1, \"description\": \"营业时间调整符合度\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"夜间分贝值(dB)\", \"value\": -1, \"sortWay\": 2, \"description\": \"场所外20米处测得值\"}, {\"name\": \"超时时长(h)\", \"value\": -1, \"sortWay\": 2, \"description\": \"晚10点后持续营业时间\"}]}','icon_noise.png'),('工业固废堆放','固体废物污染','{\"steps\": [{\"tip\": \"网格员测量堆放规模\", \"needingAttributes\": {\"attributes\": [{\"name\": \"堆放面积\", \"value\": -1, \"sortWay\": 2, \"description\": \"固废堆放占地面积（平方米）\"}, {\"name\": \"堆放高度\", \"value\": -1, \"sortWay\": 2, \"description\": \"固废堆放平均高度（米）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门检测成分\", \"needingAttributes\": {\"attributes\": [{\"name\": \"有害物质\", \"value\": -1, \"sortWay\": 2, \"description\": \"含有害物质种类数\"}, {\"name\": \"淋溶风险\", \"value\": -1, \"sortWay\": 2, \"description\": \"淋溶污染风险等级（1-5级）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督清理\", \"needingAttributes\": {\"attributes\": [{\"name\": \"清理量\", \"value\": -1, \"sortWay\": 1, \"description\": \"已清理固废量（吨）\"}, {\"name\": \"防护措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"采取的防护措施数量\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"堆放面积(m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"固废占地面积\"}, {\"name\": \"渗滤半径(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"污染物液体扩散距离\"}]}','化工厂.png'),('工业废气排放','空气污染','{\"steps\": [{\"tip\": \"网格员记录气味和能见度\", \"needingAttributes\": {\"attributes\": [{\"name\": \"气味强度\", \"value\": -1, \"sortWay\": 2, \"description\": \"废气气味强度（1-5级）\"}, {\"name\": \"能见度\", \"value\": -1, \"sortWay\": 1, \"description\": \"空气能见度（米）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门检测空气质量\", \"needingAttributes\": {\"attributes\": [{\"name\": \"PM2.5\", \"value\": -1, \"sortWay\": 2, \"description\": \"PM2.5浓度（μg/m³）\"}, {\"name\": \"SO2浓度\", \"value\": -1, \"sortWay\": 2, \"description\": \"二氧化硫浓度（mg/m³）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督减排\", \"needingAttributes\": {\"attributes\": [{\"name\": \"减排措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"减排措施实施数量\"}, {\"name\": \"空气质量改善\", \"value\": -1, \"sortWay\": 1, \"description\": \"空气质量改善百分比\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"能见度(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"烟羽影响下的最小可视距离\"}, {\"name\": \"AQI估算值\", \"value\": -1, \"sortWay\": 2, \"description\": \"参考：轻微呛咳≈150，强烈刺激≈300\"}]}','mti-废气.png'),('工业废水排放','水体污染','{\"steps\": [{\"tip\": \"网格员采集水样\", \"needingAttributes\": {\"attributes\": [{\"name\": \"pH值\", \"value\": -1, \"sortWay\": 1, \"description\": \"水体酸碱度\"}, {\"name\": \"COD浓度\", \"value\": -1, \"sortWay\": 2, \"description\": \"化学需氧量（mg/L）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门实验室检测\", \"needingAttributes\": {\"attributes\": [{\"name\": \"重金属含量\", \"value\": -1, \"sortWay\": 2, \"description\": \"重金属超标倍数\"}, {\"name\": \"毒性等级\", \"value\": -1, \"sortWay\": 2, \"description\": \"废水毒性等级（1-5级）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督整改\", \"needingAttributes\": {\"attributes\": [{\"name\": \"整改完成度\", \"value\": -1, \"sortWay\": 1, \"description\": \"整改措施完成百分比\"}, {\"name\": \"复查水质\", \"value\": -1, \"sortWay\": 1, \"description\": \"复查水质达标率\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"色度变化(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"污染水体的可见扩散距离\"}, {\"name\": \"异味强度(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"明显异味可闻的最远距离\"}]}','14污水废水.png'),('建筑工地噪音','噪音污染','{\"steps\": [{\"tip\": \"网格员测量噪音分贝\", \"needingAttributes\": {\"attributes\": [{\"name\": \"噪音值\", \"value\": -1, \"sortWay\": 2, \"description\": \"分贝值（dB）\"}, {\"name\": \"持续时间\", \"value\": -1, \"sortWay\": 2, \"description\": \"每日噪音持续时间（小时）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门评估影响\", \"needingAttributes\": {\"attributes\": [{\"name\": \"影响范围\", \"value\": -1, \"sortWay\": 2, \"description\": \"受影响的居民户数\"}, {\"name\": \"违规时段\", \"value\": -1, \"sortWay\": 2, \"description\": \"在禁止时段施工的小时数\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督整改\", \"needingAttributes\": {\"attributes\": [{\"name\": \"降噪措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"采取的降噪措施数量\"}, {\"name\": \"投诉减少\", \"value\": -1, \"sortWay\": 1, \"description\": \"整改后投诉减少百分比\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"设备分贝值(dB)\", \"value\": -1, \"sortWay\": 2, \"description\": \"离声源最近居民家测得值\"}, {\"name\": \"夜间施工(h)\", \"value\": -1, \"sortWay\": 2, \"description\": \"晚10点后持续施工时间\"}]}','icon_noise.png'),('建筑扬尘','空气污染','{\"steps\": [{\"tip\": \"网格员评估扬尘范围\", \"needingAttributes\": {\"attributes\": [{\"name\": \"影响范围\", \"value\": -1, \"sortWay\": 2, \"description\": \"扬尘影响半径（米）\"}, {\"name\": \"扬尘浓度\", \"value\": -1, \"sortWay\": 2, \"description\": \"扬尘可见度等级（1-5）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门检测颗粒物\", \"needingAttributes\": {\"attributes\": [{\"name\": \"PM10\", \"value\": -1, \"sortWay\": 2, \"description\": \"PM10浓度（μg/m³）\"}, {\"name\": \"TSP\", \"value\": -1, \"sortWay\": 2, \"description\": \"总悬浮颗粒物浓度（mg/m³）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督防尘措施\", \"needingAttributes\": {\"attributes\": [{\"name\": \"防尘网覆盖率\", \"value\": -1, \"sortWay\": 1, \"description\": \"工地防尘网覆盖百分比\"}, {\"name\": \"洒水频率\", \"value\": -1, \"sortWay\": 1, \"description\": \"每日洒水降尘次数\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"PM10估算值(μg/m³)\", \"value\": -1, \"sortWay\": 2, \"description\": \"参考：薄尘≈150，浓尘≈500\"}, {\"name\": \"扬尘高度(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"可见扬尘的垂直扩散高度\"}]}','扬尘.png'),('河流富营养化','水体污染','{\"steps\": [{\"tip\": \"网格员观察藻类情况\", \"needingAttributes\": {\"attributes\": [{\"name\": \"藻类覆盖率\", \"value\": -1, \"sortWay\": 2, \"description\": \"水面藻类覆盖百分比\"}, {\"name\": \"水体透明度\", \"value\": -1, \"sortWay\": 1, \"description\": \"水体能见度（cm）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保专家分析污染源\", \"needingAttributes\": {\"attributes\": [{\"name\": \"氮磷含量\", \"value\": -1, \"sortWay\": 2, \"description\": \"氮磷超标倍数\"}, {\"name\": \"污染源数量\", \"value\": -1, \"sortWay\": 2, \"description\": \"主要污染源数量\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督治理\", \"needingAttributes\": {\"attributes\": [{\"name\": \"治理进度\", \"value\": -1, \"sortWay\": 1, \"description\": \"治理措施实施百分比\"}, {\"name\": \"水质改善\", \"value\": -1, \"sortWay\": 1, \"description\": \"水质改善程度评分（1-10）\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"藻类覆盖率(%)\", \"value\": -1, \"sortWay\": 2, \"description\": \"藻类覆盖水面百分比\"}, {\"name\": \"浑浊度(cm)\", \"value\": -1, \"sortWay\": 2, \"description\": \"可见水深（如能见底为100cm）\"}]}','水体富营养化.png'),('生活垃圾堆积','固体废物污染','{\"steps\": [{\"tip\": \"网格员评估堆积情况\", \"needingAttributes\": {\"attributes\": [{\"name\": \"堆积体积\", \"value\": -1, \"sortWay\": 2, \"description\": \"垃圾堆积体积（立方米）\"}, {\"name\": \"堆积时间\", \"value\": -1, \"sortWay\": 2, \"description\": \"垃圾堆积天数\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门检测污染\", \"needingAttributes\": {\"attributes\": [{\"name\": \"臭气强度\", \"value\": -1, \"sortWay\": 2, \"description\": \"臭气等级（1-5级）\"}, {\"name\": \"渗滤液风险\", \"value\": -1, \"sortWay\": 2, \"description\": \"渗滤液污染风险等级（1-3级）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督清理\", \"needingAttributes\": {\"attributes\": [{\"name\": \"清理进度\", \"value\": -1, \"sortWay\": 1, \"description\": \"垃圾清理完成百分比\"}, {\"name\": \"防护措施\", \"value\": -1, \"sortWay\": 1, \"description\": \"采取的防护措施数量\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"堆积体积(m³)\", \"value\": -1, \"sortWay\": 2, \"description\": \"目测垃圾总体积\"}, {\"name\": \"虫鼠密度(个/m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"每平方米可见虫鼠数\"}]}','icon_solidrubbish.png'),('草地退化','植被破坏','{\"steps\": [{\"tip\": \"网格员测量退化区域\", \"needingAttributes\": {\"attributes\": [{\"name\": \"退化面积\", \"value\": -1, \"sortWay\": 2, \"description\": \"草地退化面积（公顷）\"}, {\"name\": \"退化程度\", \"value\": -1, \"sortWay\": 2, \"description\": \"退化程度评级（1-5级）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保专家分析原因\", \"needingAttributes\": {\"attributes\": [{\"name\": \"主要成因\", \"value\": -1, \"sortWay\": 1, \"description\": \"退化主要原因代码（1-10）\"}, {\"name\": \"恢复可行性\", \"value\": -1, \"sortWay\": 1, \"description\": \"恢复可行性评分（1-10）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督恢复措施\", \"needingAttributes\": {\"attributes\": [{\"name\": \"恢复进度\", \"value\": -1, \"sortWay\": 1, \"description\": \"恢复工作完成百分比\"}, {\"name\": \"植被覆盖率\", \"value\": -1, \"sortWay\": 1, \"description\": \"恢复后植被覆盖率\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"沙化面积(m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"植被消失的沙化区域\"}, {\"name\": \"侵蚀沟深度(cm)\", \"value\": -1, \"sortWay\": 2, \"description\": \"地表侵蚀沟最大深度\"}]}','荒漠.png'),('非法砍伐','植被破坏','{\"steps\": [{\"tip\": \"网格员现场核查植被破坏情况\", \"needingAttributes\": {\"attributes\": [{\"name\": \"破坏面积\", \"value\": -1, \"sortWay\": 2, \"description\": \"植被破坏的面积（单位：平方米）\"}, {\"name\": \"树木数量\", \"value\": -1, \"sortWay\": 2, \"description\": \"被砍伐的树木数量\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门评估生态影响\", \"needingAttributes\": {\"attributes\": [{\"name\": \"生态影响等级\", \"value\": -1, \"sortWay\": 2, \"description\": \"砍伐对生态的影响等级（1-5级）\"}, {\"name\": \"珍稀物种影响\", \"value\": -1, \"sortWay\": 2, \"description\": \"受影响珍稀物种数量\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督补种工作\", \"needingAttributes\": {\"attributes\": [{\"name\": \"补种数量\", \"value\": -1, \"sortWay\": 1, \"description\": \"补种树木数量\"}, {\"name\": \"成活率\", \"value\": -1, \"sortWay\": 1, \"description\": \"补种植被成活率（百分比）\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"裸土面积(m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"树木移除后裸露面积\"}, {\"name\": \"树桩密度(个/100m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"每百平方米树桩数量\"}]}','禁止伐木.png'),('餐饮油烟污染','空气污染','{\"steps\": [{\"tip\": \"网格员观察油烟排放\", \"needingAttributes\": {\"attributes\": [{\"name\": \"可见油烟\", \"value\": -1, \"sortWay\": 2, \"description\": \"油烟可见度等级（1-5级）\"}, {\"name\": \"影响范围\", \"value\": -1, \"sortWay\": 2, \"description\": \"受影响的居民户数\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门检测排放\", \"needingAttributes\": {\"attributes\": [{\"name\": \"颗粒物浓度\", \"value\": -1, \"sortWay\": 2, \"description\": \"油烟中颗粒物浓度（mg/m³）\"}, {\"name\": \"VOCs含量\", \"value\": -1, \"sortWay\": 2, \"description\": \"挥发性有机物浓度（mg/m³）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督整改\", \"needingAttributes\": {\"attributes\": [{\"name\": \"净化设备\", \"value\": -1, \"sortWay\": 1, \"description\": \"安装净化设备数量\"}, {\"name\": \"投诉减少\", \"value\": -1, \"sortWay\": 1, \"description\": \"整改后投诉减少百分比\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"PM2.5估算值(μg/m³)\", \"value\": -1, \"sortWay\": 2, \"description\": \"参考：可见油烟≈150+，浓烟≈300+\"}, {\"name\": \"影响半径(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"油烟明显可闻的范围直径\"}]}','油烟机.png'),('黑臭水体','水体污染','{\"steps\": [{\"tip\": \"网格员初步评估\", \"needingAttributes\": {\"attributes\": [{\"name\": \"水体长度\", \"value\": -1, \"sortWay\": 2, \"description\": \"黑臭水体长度（米）\"}, {\"name\": \"黑臭程度\", \"value\": -1, \"sortWay\": 2, \"description\": \"黑臭程度等级（1-5级）\"}]}, \"needingGridOperator\": true}, {\"tip\": \"环保部门检测\", \"needingAttributes\": {\"attributes\": [{\"name\": \"溶解氧\", \"value\": -1, \"sortWay\": 1, \"description\": \"溶解氧浓度（mg/L）\"}, {\"name\": \"氨氮含量\", \"value\": -1, \"sortWay\": 2, \"description\": \"氨氮浓度（mg/L）\"}]}, \"needingGridOperator\": false}, {\"tip\": \"网格员监督治理\", \"needingAttributes\": {\"attributes\": [{\"name\": \"治理进度\", \"value\": -1, \"sortWay\": 1, \"description\": \"治理工程完成百分比\"}, {\"name\": \"水质改善\", \"value\": -1, \"sortWay\": 1, \"description\": \"水质改善指标数量\"}]}, \"needingGridOperator\": true}]}','{\"attributes\": [{\"name\": \"黑臭长度(m)\", \"value\": -1, \"sortWay\": 2, \"description\": \"水体发黑发臭的河段长度\"}, {\"name\": \"气泡密度(个/m²)\", \"value\": -1, \"sortWay\": 2, \"description\": \"水面每平方米气泡数量\"}]}','水源.png');
/*!40000 ALTER TABLE `complainttype` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:30
-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: localhost Database: nep_env_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `division`
--
LOCK TABLES `division` WRITE;
/*!40000 ALTER TABLE `division` DISABLE KEYS */;
INSERT INTO `division` VALUES (1,'辽宁省',0,1),(2,'沈阳市',1,2),(3,'大连市',1,2),(4,'鞍山市',1,2),(5,'抚顺市',1,2),(6,'本溪市',1,2),(7,'丹东市',1,2),(8,'锦州市',1,2),(9,'营口市',1,2),(10,'阜新市',1,2),(11,'辽阳市',1,2),(12,'盘锦市',1,2),(13,'铁岭市',1,2),(14,'朝阳市',1,2),(15,'葫芦岛市',1,2),(16,'和平区',2,3),(17,'沈河区',2,3),(18,'大东区',2,3),(19,'皇姑区',2,3),(20,'铁西区',2,3),(21,'苏家屯区',2,3),(22,'浑南区',2,3),(23,'沈北新区',2,3),(24,'于洪区',2,3),(25,'辽中区',2,3),(26,'中山区',3,3),(27,'西岗区',3,3),(28,'沙河口区',3,3),(29,'甘井子区',3,3),(30,'旅顺口区',3,3),(31,'金州区',3,3),(32,'普兰店区',3,3),(33,'铁东区',4,3),(34,'铁西区',4,3),(35,'立山区',4,3),(36,'千山区',4,3),(37,'新抚区',5,3),(38,'东洲区',5,3),(39,'望花区',5,3),(40,'顺城区',5,3),(41,'平山区',6,3),(42,'溪湖区',6,3),(43,'明山区',6,3),(44,'南芬区',6,3),(45,'元宝区',7,3),(46,'振兴区',7,3),(47,'振安区',7,3),(48,'古塔区',8,3),(49,'凌河区',8,3),(50,'太和区',8,3),(51,'站前区',9,3),(52,'西市区',9,3),(53,'鲅鱼圈区',9,3),(54,'老边区',9,3),(55,'海州区',10,3),(56,'新邱区',10,3),(57,'太平区',10,3),(58,'清河门区',10,3),(59,'细河区',10,3),(60,'白塔区',11,3),(61,'文圣区',11,3),(62,'宏伟区',11,3),(63,'弓长岭区',11,3),(64,'太子河区',11,3),(65,'双台子区',12,3),(66,'兴隆台区',12,3),(67,'大洼区',12,3),(68,'银州区',13,3),(69,'清河区',13,3),(70,'双塔区',14,3),(71,'龙城区',14,3),(72,'连山区',15,3),(73,'龙港区',15,3),(74,'南票区',15,3),(75,'新民市',2,3),(76,'康平县',2,3),(77,'法库县',2,3),(78,'瓦房店市',3,3),(79,'庄河市',3,3),(80,'长海县',3,3),(81,'海城市',4,3),(82,'台安县',4,3),(83,'岫岩满族自治县',4,3),(84,'抚顺县',5,3),(85,'新宾满族自治县',5,3),(86,'清原满族自治县',5,3),(87,'本溪满族自治县',6,3),(88,'桓仁满族自治县',6,3),(89,'东港市',7,3),(90,'凤城市',7,3),(91,'宽甸满族自治县',7,3),(92,'凌海市',8,3),(93,'北镇市',8,3),(94,'黑山县',8,3),(95,'义县',8,3),(96,'盖州市',9,3),(97,'大石桥市',9,3),(98,'彰武县',10,3),(99,'灯塔市',11,3),(100,'辽阳县',11,3),(101,'盘山县',12,3),(102,'调兵山市',13,3),(103,'开原市',13,3),(104,'铁岭县',13,3),(105,'西丰县',13,3),(106,'昌图县',13,3),(107,'北票市',14,3),(108,'凌源市',14,3),(109,'朝阳县',14,3),(110,'建平县',14,3),(111,'喀喇沁左翼蒙古族自治县',14,3),(112,'兴城市',15,3),(113,'绥中县',15,3),(114,'建昌县',15,3);
/*!40000 ALTER TABLE `division` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2025-06-28 15:17:28