| | |
| | | |
| | | |
| | | |
| | | ##Oracle to postgresql |
| | | \##Oracle to postgresql
|
| | | copy basedb.sxfmr from oracle to postgresql |
| | | |
| | | |
| | | ~~~ |
| | | //於postgresql 建立這個view |
| | | |
| | | CREATE OR REPLACE VIEW public."fsc-115-c-0-tcount" AS |
| | |
| | | JOIN sxfmr ON "fsc-115-c-0".oid = sxfmr.ufid; |
| | | |
| | | |
| | | ~~~ |
| | | |
| | | \##Geoserver
|
| | | \###Style
|
| | | \#####buf115-5m
|
| | | |
| | | ##Geoserver |
| | | ###Style |
| | | #####buf115-5m |
| | | |
| | | ~~~ |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <sld:StyledLayerDescriptor xmlns="http://www.opengis.net/sld" xmlns:sld="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc" xmlns:gml="http://www.opengis.net/gml" version="1.0.0"> |
| | | <sld:UserLayer> |
| | |
| | | </sld:UserLayer> |
| | | </sld:StyledLayerDescriptor> |
| | | |
| | | ~~~ |
| | | |
| | | #####buf115-25m |
| | | \#####buf115-25m
|
| | | |
| | | ~~~ |
| | | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <sld:StyledLayerDescriptor xmlns="http://www.opengis.net/sld" xmlns:sld="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc" xmlns:gml="http://www.opengis.net/gml" version="1.0.0"> |
| | |
| | | </sld:UserLayer> |
| | | </sld:StyledLayerDescriptor> |
| | | |
| | | ~~~ |
| | | |
| | | #####symbol115 |
| | | \#####symbol115
|
| | | |
| | | ~~~ |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <sld:StyledLayerDescriptor xmlns="http://www.opengis.net/sld" xmlns:sld="http://www.opengis.net/sld" |
| | | xmlns:ogc="http://www.opengis.net/ogc" xmlns:gml="http://www.opengis.net/gml" |
| | |
| | | </sld:UserLayer> |
| | | </sld:StyledLayerDescriptor> |
| | | |
| | | ~~~ |
| | | |
| | | |
| | | ###Layer |
| | | \###Layer
|
| | | 以public."fsc-115-c-0-tcount"建立兩個圖層 |
| | | |
| | | ~~~ |
| | | xtpc:fsc-115-c-0-tcount5m |
| | | style=buf115-5m |
| | | xtpc:fsc-115-c-0-tcount25m |
| | | style=buf115-25m |
| | | ~~~ |
| | | |
| | | 以public."fsc-115-c-0-tcount"建立一個圖層 |
| | | 以public."fsc-115-c-0"建立一個圖層
|
| | | |
| | | ~~~ |
| | | xtpc:fsc-115-c0-tcount-symbol |
| | | style=symbol115 |
| | | ~~~ |
| | | |
| | | ##建立兩個圖層群組 |
| | | \##建立兩個圖層群組
|
| | | |
| | | ~~~ |
| | | pgTcount |
| | | (xtpc:fsc-115-c-0-tcount5m+xtpc:fsc-115-c0-tcount-symbol) |
| | | pgTcount25m |
| | | (xtpc:fsc-115-c-0-tcount25m+xtpc:fsc-115-c0-tcount-symbol) |
| | | ~~~ |
| | | |
| | | |
| | | #程式相關設定 |
| | | \#程式相關設定
|
| | | 請設定tpcSetting.js |
| | | |
| | | ~~~ |
| | | wmsUrl="http://www.ximple.com.tw:80/geosns/xtpc/wms"; |
| | | |
| | | var layerList=[ |
| | |
| | | {name:"變壓器範圍圖5m",id:"變壓器範圍圖5m",featureinfo:false,showdef:true,layerinfo:{baselayer:false,layerType:"wms", layerid:"xtpc:pgTcount",projection:"EPSG:3826"}}, |
| | | {name:"變壓器範圍圖25m",id:"變壓器範圍圖25m",featureinfo:false,showdef:false,layerinfo:{baselayer:false,layerType:"wms", layerid:"xtpc:pgTcount25m",projection:"EPSG:3826"}} |
| | | ]; |
| | | |
| | | ~~~ |