CCS

67

DB4401

4401/T

138—2021河（湖）長制管理信息系統(tǒng)數(shù)據(jù)規(guī)范Data

specification

of

the

management

system

for

the

river

system 廣州市市場(chǎng)監(jiān)督管理局 發(fā)

布DB4401/T

II

4.1

4.2

4.3

5.1

5.2

5.3

6.1

6.2

6.3

106.4

17

24 32DB4401/T

136—2021DB4401/T

IIDB4401/T

廣州市水系及其附屬設(shè)施編碼規(guī)范第1部分：河流（涌）、水庫、湖泊編碼規(guī)

3.13.2

section

4.1

a)b) c)d)4.2

a)b)c)d)DB4401/T

138—2021e)

4.3

a) b)c)

5.1

河流（涌）、湖泊、水庫編碼遵循DB4401/T

a)

15

BT

FF

SS

圖1

b)

12

BT

FF

SS

圖2

c)

12

BT

FF

SS

DB4401/T

圖3

5.2

a)b) c) d)

e) f)

CC

DDD

EEE

圖4

011203130414051506171118DB4401/T

138—2021a)

ABTFFSSUUVVWWXX

15

b)

CC

表1

e)

DDD

表1

f)

EEE

——

位字符，表示村級(jí)編碼，行政村編碼詳見《廣東省統(tǒng)計(jì)用區(qū)劃代碼》，不在行政g)

h)

——

段）、L（左岸）、R（右岸）。

1：沙河涌達(dá)道南社區(qū)段，沙河涌河流（涌）編碼為

AHD030212000000；達(dá)道南社區(qū)屬于越秀區(qū)東山街道，其區(qū)級(jí)編號(hào)

2：南亭西街涌廣東工業(yè)大學(xué)段，南亭西街涌河流（涌）編碼為

AHD030338000000；廣東工業(yè)大學(xué)（大學(xué)城校區(qū)）屬于番禺區(qū)小谷圍街道，其區(qū)段編號(hào)為

13，鎮(zhèn)級(jí)編號(hào)為

011，村級(jí)臨時(shí)編碼為

T01(村級(jí)平行管理單位)；河段順序號(hào)編

2；左右岸代碼，全段為

5.3

6.1

數(shù)據(jù)表字段類型說明見表2。表2

表2

數(shù)據(jù)表分類匯總見表3。FOU_LAKEFOU_AREAFOU_USERFOU_RIVER_INFO_DOCFOU_RIVER_LAKE_DOCFOU_RIVER_POLIDYN_PATROLDYN_PROBLEM_ASSIGNEDDYN_PROBLEM_SUPERVISIONTDYN_ASS_STANDARDDYN_RIVER_DYNA_DOCSPA_RIVER_BSINSPA_RESERVIOR_BSINSPA_BANKSPA_BULLETIN_BOARDSPA_PS_DRAINSECTION_ID26

SECTION_NAME50RIVER_SYSTEM50RIVER_SIDEL.左岸，R.右岸，A.START_ADDR50END_ADDR5026DB4401/T

表3

表3

表4

表4

河流（涌）信息表（FOU_RIVER）PARENT_IDS10ADDVCD1211D，EA.省管，B.市管，C.12IMP_HC1314INTRODUCTION15PIC_PATH20001636173618ADMIN_AGENCY19203621

YYYY-MM-DDhh:mm:ss，下同22362324DEL_FLAG

26

50RIVER_SYSTEM50LAKE_IS_SALT0.

0.A.省管，B.市管，C.ADDVCD12INTRODUCTIONPIC_PATH200036103611ADMIN_AGENCY12LC13BASIN_CODEDB4401/T

138—2021表4

(續(xù))表4

(續(xù))表5

表5

RSR_ID26

RSR_NAME50RIVER_SYSTEM5015ADDVCD12MATERIAL50

YYYY-MM-DD，INTRODUCTIONPIC_PATH2000“;”隔開10A.，B.，C.111.Ⅰ類，2.Ⅱ類，3.1236133614ADMIN_AGENCY1516361718361920DEL_FLAG

1415361617361819DEL_FLAG

CODE1212DB4401/T

表5

表5

表6

表6

表7

表7

ID3636LODIN_NAMENAME166413MOBILE13GENDERM，F(xiàn)WECHAT_LOGINNAME36105011201236131.，2.總河長，10.鎮(zhèn)（街）河長，11.村（居）河1415361617361819DEL_FLAG

PARENT_IDS40NAME1.省份、直轄市，2.36361011DEL_FLAG

DB4401/T

138—2021表7

表7

表8

表8

SECTION_ID26SECTION_NAME505026RIVER_SYSTEM50START_LGTD10

START_LTTD10

END_LGTD10

END_LTTD10

1010

km11RIVER_DISTL.左岸，R.右岸，T.12AREA10

km1315

14LOWFLOW_VOLUME10

/s151617RIGHT_BRANCH2650RIVER_SYSTEM5010

10

10

km10

DB4401/T

表9

表9

10

10

“一河（湖）一檔”湖泊自然屬性表（FOU_LAKE_INFO_DOC）ID36SN36河段/湖泊編碼SECTION_ID26ATTACHMENTS_PATHSTA_DATEEND_DATE3610361112DEL_FLAG

26SN36SECTION_ID26SECTION_NAME50CRO_LGTD10

CRO_LTTD10

AVG_VOLUME10

36河段/湖泊編碼SECTION_ID2636DB4401/T

138—2021

11

11

“一河（湖）一策”表用于存儲(chǔ)治河（湖）策略信息，見表12。

12

12

巡河記錄表用于存儲(chǔ)河長巡河信息，見表13。

13

巡河記錄表（DYN_PATROL）PROBLEM_ID36PROBLEM_TYPE301.工業(yè)廢水排放，2.施，4.違法建設(shè)，5.物，7.堆場(chǎng)碼頭，8.圾，10.其他。PROBLEM_SOURCE

訴，2.微信相關(guān)，3.理，5.媒體曝光，6.TIMEDISTANCE10

kmDURATION10

START_LGTD10

START_LTTD10

10END_LGTD10

11END_LTTD10

ID3636TIME

json

DB4401/T

13

13

14

14

巡河軌跡表（DYN_PATROLTRACK）

15

LOCATIONDESCRIBE20001，2，3，4LGTD10

LTTD10

10

ID3611123613PIC_PATH2000“;”隔開14ADDVCD1215361617END_DATE1832191320PROBLEM_CODE36ID36PROBLEM_ID3636NEXT_USER_ID362000PIC_PATH2000“;”隔開TIME10ADDVCD1210DB4401/T

138—2021

15

15

16

16

督辦表用于存儲(chǔ)問題督辦基本信息，見表17。12ID36河段/湖泊編碼SECTION_ID26DETECTION_DATEADDVCD120，1，2，3臭，2.輕度黑臭，3.1.Ⅰ類，2.Ⅱ類，3.20TEST36TEST_VALUE15103611監(jiān)測(cè)內(nèi)容、測(cè)量值、計(jì)量單位見GB

3838及城市黑臭水體整治工作指南，并以監(jiān)測(cè)點(diǎn)實(shí)際上報(bào)項(xiàng)目為準(zhǔn)；黑臭水體類別ID36PROBLEM_ID363636END_DATEPAPER_ID36PAPER_DATEID36PROBLEM_ID36TOPIC_TYPE36SUP_DATE20001，2DB4401/T

17

17

18

18

19

19

ID3630所，3.涉嫌違建，4.LOCATIONSECTION_ID2636CHECK_DATE0，1，2，3ID36SUBJECT_ID36ITEMSTANDARD_SCOREGRADING_STANDARD20003610361112DEL_FLAG

ID36DB4401/T

138—2021

20

20

21

21

22

SECTION_ID26TOTAL_SUPPLY10

ACTRUAL_SUPPLY10

MOUNT_WS10

WS_QUALITY10

10111213

度占比（%）14

比（%）15

比（%）16

17COMPLIANCE_PERCENT1819LEN_CUTOFF10

km202122MOUNT_SA2310

km36MODEL_ID36363610DEL_FLAG

DB4401/T

22

22

(續(xù))

23

1524LEFT_LEN10

km2510

km26CENTER_LEN10

km27B_PROT_LEN10

km2810

km29B_CU_LEN10

km30B_DU_LEN10

km31DU_LEN10

km32DU_PERCENT33NAVI_LEN10

km34AQUA_LEN10

km35MOUNT_SAND3610

37MOUNT_ZP38MOUNT_RD39MOUNT_NAVIBUID4041CAPA_RSR10

42BS_L_LEN10

km43BS_R_LEN10

km44MOUNT_PORT45LEN_PORT10

4626MOUNT_WSTOTAL_SUPPLY10

10

ACTRUAL_SUPPLY10

WS_QUALITY10

/年1010

1112135014POLLUTANTS15HI_LEVEL10

DB4401/T

138—2021

23

23

(續(xù))

24

1610

17RECLAME_AREA10

km1810

km1910

km2021B_DU_LEN10

km22B_DU_PRECENT2310

km24TOTAL_SAND1025B_PROT_LEN10

km2610

km27B_CU_LEN10

km28B_DU_LEN10

km29AQUA_LEN10

km30EMBANK_LEN10

km3132MOUNT_PUMP33MOUNT_PORT34SECTION_ID26

START_LGTD10

START_LTTD10

END_LGTD10

END_LTTD10

502050ESTUARY_PS501010

km11BASIN_AREA10

12BASIN_CODEDB4401/T

24

24

25

1713BASIN_NAME50141516TARGAT_QUALITY1710

18AREA10

19

20RIVER_OV21PLAN_REMARKS5022

23

24MOUNT_CD2526362728362930DEL_FLAG

26

10

10

10

10

SOUTH_LGTD10

SOUTH_LTTD10

10

10

DB4401/T

138—2021

25

25

湖泊分布表用于存儲(chǔ)湖泊分布空間信息，見表26。

26

10NORTH_LGTD10

11NORTH_LTTD10

1210

1310

1410

151617TARGAT_QUALITY1819LAKE_SCALE2021362223362425DEL_FLAG

0.已刪ID26

10

10

CAPACITY10

AREA12

DAM_LGTD10

DAM_LTTD10

RSR_TYPE50RSR_FUNC50101112TARGET_QUALITY131436DB4401/T

26

26

27

WATERSOURCE_ID36河流/湖泊代碼SECTION_ID265050LGTD10

LTTD10

10

10OBJECTID36BASIN_CODEBASIN_NAME50RIVER_CODE26SECTION_NAME5036361011DEL_FLAG

1516361718DEL_FLAG

DB4401/T

138—2021

27

27

流域邊界分布表用于存儲(chǔ)流域邊界分布基本信息，見表28。

28

28

飲用水水源地表用于存儲(chǔ)飲用水水源地基本信息，見表29。

29

河段/湖泊編碼SECTION_ID263610

kmLEFT_LEN10

km10

kmCENTER_LEN10

km10

km10

km10KEEP_LEN10

km1110

km1210

km1314361516361718DEL_FLAG

11DRINKW_POS10

1213361415361617DEL_FLAG

BOARD_ID36DB4401/T

29

29

30

30

31

21STATION_ID36STATION_NAME50STATION_TYPELGTD10

LTTD10

SECTION_ID26ADDVCD12361011361213DEL_FLAG

LGTD10

LTTD10

河涌/湖泊編碼SECTION_ID26200020002000VILLAGE_DUTY2000200010131112361314361516DEL_FLAG

DB4401/T

138—2021

31

31

水質(zhì)監(jiān)測(cè)站點(diǎn)信息表用于存儲(chǔ)水質(zhì)監(jiān)測(cè)站點(diǎn)基本信息，見表32。

32

32

排水口信息表用于存儲(chǔ)排水口基本信息，見表33。22DRAIN_ID36DRAIN_NAME5050WAT_TYPE

LGTD10

LTTD10

20SECTION_ID261210PIC_PATH2000“;”隔開1112361314361516DEL_FLAG

DB4401/T

33

DYNA_RIVER_WATERSOURCEDYNA_RIVER_DRAINDYNA_RIVER_RESERVIORDYNA_RIVER_ETCDYNA_LAKE_INTAKEDYNA_LAKE_ZONEDYNA_LAKE_BANKDYNA_LAKE_SLUICEDYNA_LAKE_PUMPDYNA_LAKE_PORTSECTION_ID26SN10NAME50LGTD10

LTTD10

TOTAL_WITHDRAWAL10

ACTRUAL_SUPPLY10

1.工業(yè)，2.農(nóng)業(yè)，3.10DB4401/T

138—2021

“一河（湖）一檔”分類動(dòng)態(tài)信息表

A.1

A.1 “一河（湖）一檔”分類動(dòng)態(tài)信息表分類匯總

A.2

SECTION_ID26SN10NAME50LGTD10

LTTD10

10

DIPOSAL_AGENCY3610SECTION_ID26SN10LV1_NAME50LV2_NAME50START_LGTD10

START_LTTD10

END_LGTD10

END_LTTD10

SECTION_ID26SN10NAME50LGTD10

LTTD10

10

WS_QUALITYDB4401/T

A.3

A.3

A.4

A.5SECTION_ID26SN10NAME50LGTD10

LTTD10

ADMIN_AGENCYSECTION_ID26SN10NAME50LGTD10

LTTD10

SECTION_ID26SN10NAME50LGTD10

10FREQ20111213DB4401/T

138—2021

A.5

A.5

A.7

A.7 河流（段）攔河閘、泵站、橡膠壩、滾水壩、通航建筑物動(dòng)態(tài)信息（DYNA_RIVER_BUILDING）

A.8

SECTION_ID26SN10NAME50START_LGTD10

START_LTTD10

END_LGTD10

END_LTTD10

LENT10

kmLEFT_RIGHT10TYPE501112SECTION_ID26SN10NAME50LGTD10

LTTD10

10

LTTD10

CAPACITY10

ADMIN_AGENCYDB4401/T

A.8

A.8

(續(xù))

A.9

A.10DYNA_LAKE_ID26SN10NAME50LGTD10

LTTD10

TOTAL_WITHDRAWAL10萬mACTRUAL_SUPPLY10萬m1，2，3