An's Blog
收藏、分享 …
Toggle navigation
Home
Cesium
SuperMap
ArcGIS
MapboxGL
CentOS
GeoServer
Favorites
Archives
Tags
居民地数据质量检查脚本
2023-02-07 14:52:15
9
0
0
admin
### **一、居民地** #### **居民地面总数** SELECT CASSCODE,CASSNAME,count(CASSCODE) as Total FROM [dbo].[RESPL] WHERE CASSCODE in ('140001','143111','143112','141800','144301','143130','143131') GROUP BY CASSCODE,CASSNAME ORDER BY CASSCODE ASC  #### **1、居民地点属性核对** SELECT DISTINCT NAME,SLAYER,CASSNAME FROM [dbo].[RESPT] ; SELECT DISTINCT TYPE,SLAYER,CASSNAME FROM [dbo].[RESPT] ORDER BY TYPE ASC; SELECT DISTINCT LTYPE,SLAYER,CASSNAME FROM [dbo].[RESPT] ; SELECT DISTINCT ANGLE,SLAYER,CASSNAME FROM [dbo].[RESPT] ; SELECT DISTINCT SXTYPE,SLAYER,CASSNAME FROM [dbo].[RESPT] ; SELECT DISTINCT ANGLE,SLAYER,CASSNAME FROM [dbo].[RESPT] ; SELECT DISTINCT ANGLE2,SLAYER,CASSNAME FROM [dbo].[RESPT] ; SELECT DISTINCT Height,SLAYER,CASSNAME FROM [dbo].[RESPT] ; #### **2、居民地线属性核对** SELECT DISTINCT ELEV FROM [dbo].[RESLN] ; SELECT DISTINCT TYPE FROM [dbo].[RESLN] ; SELECT DISTINCT BG FROM [dbo].[RESLN] ; SELECT DISTINCT ANGLE FROM [dbo].[RESLN] ; #### **3、居民地面属性核对** SELECT DISTINCT NAME FROM [dbo].[RESPL] ; SELECT DISTINCT TYPE FROM [dbo].[RESPL] ; SELECT DISTINCT LTYPE FROM [dbo].[RESPL] ; SELECT DISTINCT FLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT UNFLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT USE_ FROM [dbo].[RESPL] ; SELECT DISTINCT STRUCT FROM [dbo].[RESPL] ; ### **二、管线** #### **1、管点属性核对** SELECT DISTINCT NAME FROM [dbo].[PIPPT] ; SELECT DISTINCT TYPE FROM [dbo].[PIPPT] ; SELECT DISTINCT ANGLE FROM [dbo].[PIPPT] ; #### **2、管线属性核对** SELECT DISTINCT NAME FROM [dbo].[PIPLN] ; SELECT DISTINCT TYPE FROM [dbo].[PIPLN] ; SELECT DISTINCT KV FROM [dbo].[PIPLN] ; SELECT DISTINCT ELEV FROM [dbo].[PIPLN] ; #### **3、管线面属性核对** SELECT DISTINCT NAME FROM [dbo].[RESPL] ; SELECT DISTINCT TYPE FROM [dbo].[RESPL] ; SELECT DISTINCT LTYPE FROM [dbo].[RESPL] ; SELECT DISTINCT FLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT UNFLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT USE_ FROM [dbo].[RESPL] ; SELECT DISTINCT STRUCT FROM [dbo].[RESPL] ; ### **三、植被** #### **1、植被点属性核对** SELECT DISTINCT NAME FROM [dbo].[VEGPT] ; SELECT DISTINCT TYPE FROM [dbo].[VEGPT] ; SELECT DISTINCT TYPE2 FROM [dbo].[VEGPT] ; SELECT DISTINCT BG FROM [dbo].[VEGPT] ; #### **2、植被地线属性核对** SELECT DISTINCT TYPE FROM [dbo].[VEGLN] ; SELECT DISTINCT FLCODE FROM [dbo].[VEGLN] ; #### **3、植被面属性核对** SELECT DISTINCT NAME FROM [dbo].[RESPL] ; SELECT DISTINCT TYPE FROM [dbo].[RESPL] ; SELECT DISTINCT LTYPE FROM [dbo].[RESPL] ; SELECT DISTINCT FLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT UNFLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT USE_ FROM [dbo].[RESPL] ; SELECT DISTINCT STRUCT FROM [dbo].[RESPL] ; ### **四、地貌** #### **1、地貌点属性核对** SELECT DISTINCT NAME FROM [dbo].[TERPT] ; SELECT DISTINCT ELEV FROM [dbo].[TERPT] ; SELECT DISTINCT BG FROM [dbo].[TERPT] ; SELECT DISTINCT ANGLE FROM [dbo].[TERPT] ; SELECT DISTINCT ANNO FROM [dbo].[TERPT] ; #### **2、地貌地线属性核对** SELECT DISTINCT FLCODE FROM [dbo].[TERLN] ; SELECT DISTINCT ELEV FROM [dbo].[TERLN] ; SELECT DISTINCT BG FROM [dbo].[TERLN] ; #### **3、地貌面属性核对** SELECT DISTINCT NAME FROM [dbo].[RESPL] ; SELECT DISTINCT TYPE FROM [dbo].[RESPL] ; SELECT DISTINCT LTYPE FROM [dbo].[RESPL] ; SELECT DISTINCT FLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT UNFLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT USE_ FROM [dbo].[RESPL] ; SELECT DISTINCT STRUCT FROM [dbo].[RESPL] ; ### **五、交通** #### **1、交通点属性核对** SELECT DISTINCT NAME FROM [dbo].[TFCPT] ; SELECT DISTINCT RN FROM [dbo].[TFCPT] ; SELECT DISTINCT TYPE FROM [dbo].[TFCPT] ; SELECT DISTINCT BG FROM [dbo].[TFCPT] ; SELECT DISTINCT USE_ FROM [dbo].[TFCPT] ; SELECT DISTINCT PN FROM [dbo].[TFCPT] ; SELECT DISTINCT ANGLE FROM [dbo].[TFCPT] ; SELECT DISTINCT KM FROM [dbo].[TFCPT] ; #### **2、交通线属性核对** SELECT DISTINCT NAME FROM [dbo].[ROALN] ; SELECT DISTINCT RN FROM [dbo].[ROALN] ; SELECT DISTINCT RTEG FROM [dbo].[ROALN] ; SELECT DISTINCT MATRL FROM [dbo].[ROALN] ; SELECT DISTINCT LANE FROM [dbo].[ROALN] ; SELECT DISTINCT SDTF FROM [dbo].[ROALN] ; SELECT DISTINCT WIDTH FROM [dbo].[ROALN] ; SELECT DISTINCT TYPE FROM [dbo].[ROALN] ; #### **3、交通面属性核对** SELECT DISTINCT NAME FROM [dbo].[RESPL] ; SELECT DISTINCT TYPE FROM [dbo].[RESPL] ; SELECT DISTINCT LTYPE FROM [dbo].[RESPL] ; SELECT DISTINCT FLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT UNFLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT USE_ FROM [dbo].[RESPL] ; SELECT DISTINCT STRUCT FROM [dbo].[RESPL] ; ### **五、水系** #### **1、交通点属性核对** SELECT DISTINCT NAME FROM [dbo].[HYDPT] ; SELECT DISTINCT ELEV FROM [dbo].[HYDPT] ; SELECT DISTINCT TYPE FROM [dbo].[HYDPT] ; SELECT DISTINCT TYPE2 FROM [dbo].[HYDPT] ; SELECT DISTINCT ANGLE FROM [dbo].[HYDPT] ; SELECT DISTINCT BG FROM [dbo].[HYDPT] ; #### **2、植被地线属性核对** SELECT DISTINCT FLCODE FROM [dbo].[HYDLN] ; SELECT DISTINCT HYDC FROM [dbo].[HYDLN] ; SELECT DISTINCT NAME FROM [dbo].[HYDLN] ; SELECT DISTINCT PERIOD FROM [dbo].[HYDLN] ; SELECT DISTINCT BG FROM [dbo].[HYDLN] ; SELECT DISTINCT WIDTH FROM [dbo].[HYDLN] ; SELECT DISTINCT TYPE FROM [dbo].[HYDLN] ; #### **3、植被面属性核对** SELECT DISTINCT NAME FROM [dbo].[RESPL] ; SELECT DISTINCT TYPE FROM [dbo].[RESPL] ; SELECT DISTINCT LTYPE FROM [dbo].[RESPL] ; SELECT DISTINCT FLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT UNFLOOR FROM [dbo].[RESPL] ; SELECT DISTINCT USE_ FROM [dbo].[RESPL] ; SELECT DISTINCT STRUCT FROM [dbo].[RESPL] ;
Pre:
PostGIS扩展
Next:
ArcGIS GP工具代码收集
0
likes
9
Weibo
Wechat
Tencent Weibo
QQ Zone
RenRen
Table of content