查看道路分級(jí)如下：

mapdb=# select distinct pathclass from rbeijing;
 pathclass
-----------
 0
 15
 2
 3
 4
(5 rows)

使用子查詢實(shí)現(xiàn)道路分級(jí)

  CONNECTIONTYPE postgis
  PROCESSING "CLOST_CONNECTION=DEFER"
  CONNECTION "user=map password=postgres dbname=mapdb host=192.168.1.11 port=5432"
  DATA "the_geom from  (select * from rbeijing where pathclass='3') as subquery using unique gid USING SRID=4326"









分級(jí)前的查詢代碼
  CONNECTIONTYPE postgis
  PROCESSING "CLOST_CONNECTION=DEFER"
  CONNECTION "user=zhangyi password=postgres dbname=zydb host=192.168.10.166 port=5432"
  DATA "the_geom from rbeijing using unique gid USING SRID=4326"                                                  
  #DATA "the_geom from  (select * from rbeijing where pathclass='3') as subquery using unique gid USING SRID=4326"

分級(jí)前的效果







|----------------------------------------------------------------------------------------|
                           版權(quán)聲明  版權(quán)所有 @zhyiwww
            引用請(qǐng)注明來(lái)源 http://www.tkk7.com/zhyiwww   
|----------------------------------------------------------------------------------------|