居民地数据质量检查脚本

### **一、居民地**
#### **居民地面总数**

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

![](/api/file/getImage?fileId=63e0e2239a54ae022200009e)

#### **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、管线面属性核对**

#### **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、植被面属性核对**

#### **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、地貌面属性核对**

#### **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、交通面属性核对**

#### **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、植被面属性核对**

An's Blog

Navigation

Recent Posts

Friend Links