{"id":2409,"date":"2024-10-31T17:04:39","date_gmt":"2024-10-31T08:04:39","guid":{"rendered":"http:\/\/blog.moramcnt.com\/?p=2409"},"modified":"2024-10-31T17:05:26","modified_gmt":"2024-10-31T08:05:26","slug":"geoserver-sql-view-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/blog.moramcnt.com\/?p=2409","title":{"rendered":"GeoServer SQL View \ud30c\ub77c\ubbf8\ud130 \uc124\uc815"},"content":{"rendered":"

I. \ubaa9\ud45c<\/strong><\/p>\n

WMS\/WFS\uc5d0\uc11c \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \uac70\ub798\ucc98ID\uc5d0 \ud574\ub2f9\ud558\ub294 \uac70\uc810\ub4f1\uc744 \uac00\uc838\uc62c \uc218 \uc788\ub294\uc9c0 \uc5f0\uad6c\ud55c\ub2e4.<\/p>\n

II. \uc5f0\uad6c \ubc0f \uac1c\ubc1c\ub0b4\uc6a9<\/strong><\/p>\n

WMS\/WFS\uc5d0\uc11c \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \uac70\ub798\ucc98ID\uc5d0 \ud574\ub2f9\ud558\ub294 \uac70\uc810\ub4f1\uc744 \uac00\uc838\uc624\uae30 \uc704\ud574\uc11c\ub294<\/p>\n

\ud30c\ub77c\ubbf8\ud130\ub85c \ubc1b\uc544 SQL View \uc5d0\uc11c \uc694\uccad\ud55c \uac70\ub798\ucc98\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\ub9cc \ub9ac\ud134\ud574\uc57c \ud55c\ub2e4.<\/p>\n

 <\/p>\n

1. SQL \ubb38\uc7a5\uc5d0 \ud30c\ub77c\ubbf8\ud130 \ucd94\uac00<\/p>\n

-%\ud30c\ub77c\ubbf8\ud130\uba85% \ud615\uc2dd\uc73c\ub85c \uc791\uc131<\/p>\n\n\n\n
SELECT<\/b>corp_id, branch_seq, branch_name,<\/p>\n

inout_radius,<\/p>\n

(inout_radius* 2) AS<\/b>distance,<\/p>\n

geom,<\/p>\n

‘.’|| icon_path|| icon_nameas<\/b>icon<\/p>\n

FROM<\/b>branch_info<\/p>\n

where<\/b>CORP_ID=’%corpId%’<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

2. \ud30c\ub77c\ubbf8\ud130 \uc124\uc815<\/p>\n

\uc720\ud615\uc131 \uac80\uc0ac \uc815\uaddc\ud45c\ud604\uc2dd\uc5d0\uc11c ^[\\w\\d\\s]+$ \ub97c \uc81c\uac70<\/p>\n

\"\"<\/p>\n

3.WMS \ud638\ucd9c<\/p>\n

JavaScript\uc5d0\uc11c \ud638\ucd9c\uc2dc \uc544\ub798\uc640 \uac19\uc774 \ud638\ucd9c\ud558\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n
varstrViewParams =”corpId:”+strCorpId +”;userId:”+strUserId;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ \uc138\ubbf8\ucf5c\ub860\uc73c\ub85c \uad6c\ubd84<\/p>\n

 <\/p>\n

varclsBranchSource =newol.source.ImageWMS({<\/p>\n

ratio\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: 1,<\/p>\n

url\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: this.mStrTileServerUrl,<\/p>\n

params: {<\/p>\n

“FORMAT”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: “image\/png”,<\/p>\n

“VERSION”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: “1.1.1”,<\/p>\n

“LAYERS”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: “lbsok:branch”,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ workspace:layer<\/p>\n

“VIEWPARAMS”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: strViewParams,<\/p>\n

“exceptions”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: “application\/vnd.ogc.se_inimage”<\/p>\n

}<\/p>\n

});<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

III. \uacb0\ub860<\/strong><\/p>\n

SQLView\ub85c \ud30c\ub77c\ubbf8\ud130 \uc124\uc815\uc744 \ud558\uc5ec \uc6d0\ud558\ub294 \ud56d\ubaa9\ub9cc\u00a0 \uac00\uc838\uc62c\uc218 \uc788\uc5c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

I. \ubaa9\ud45c WMS\/WFS\uc5d0\uc11c \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \uac70\ub798\ucc98ID\uc5d0 \ud574\ub2f9\ud558\ub294 \uac70\uc810\ub4f1\uc744 \uac00\uc838\uc62c \uc218 \uc788\ub294\uc9c0 \uc5f0\uad6c\ud55c\ub2e4. II. \uc5f0\uad6c \ubc0f \uac1c\ubc1c\ub0b4\uc6a9 WMS\/WFS\uc5d0\uc11c \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \uac70\ub798\ucc98ID\uc5d0 \ud574\ub2f9\ud558\ub294 \uac70\uc810\ub4f1\uc744 \uac00\uc838\uc624\uae30 \uc704\ud574\uc11c\ub294 \ud30c\ub77c\ubbf8\ud130\ub85c \ubc1b\uc544 SQL View \uc5d0\uc11c \uc694\uccad\ud55c \uac70\ub798\ucc98\uc5d0 \ud574\ub2f9\ud558\ub294 \ub370\uc774\ud130\ub9cc \ub9ac\ud134\ud574\uc57c \ud55c\ub2e4.   1. SQL \ubb38\uc7a5\uc5d0 \ud30c\ub77c\ubbf8\ud130 \ucd94\uac00 -%\ud30c\ub77c\ubbf8\ud130\uba85% \ud615\uc2dd\uc73c\ub85c \uc791\uc131 SELECTcorp_id, branch_seq, branch_name, inout_radius, (inout_radius* 2) ASdistance, geom, ‘.’|| icon_path|| icon_nameasicon […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5,2],"tags":[290,296,297],"class_list":["post-2409","post","type-post","status-publish","format-standard","hentry","category-gis","category-2","tag-geoserver","tag-sql-view","tag-297"],"_links":{"self":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/2409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2409"}],"version-history":[{"count":2,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/2409\/revisions"}],"predecessor-version":[{"id":2412,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=\/wp\/v2\/posts\/2409\/revisions\/2412"}],"wp:attachment":[{"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2409"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.moramcnt.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}