{"id":131,"date":"2014-01-02T23:51:06","date_gmt":"2014-01-02T15:51:06","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=131"},"modified":"2014-03-07T11:04:13","modified_gmt":"2014-03-07T03:04:13","slug":"calculating-total-surface-area-of-a-geography-instance","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html","title":{"rendered":"Calculating Total Surface Area of a Geography Instance"},"content":{"rendered":"<p>Seperti diketahui bahwa di SQL Server 2008 telah support untuk spatial. berikut ini saya coba berikan contoh bagaimana untuk menghitung sebuah luas area polygon.<\/p>\n<p>untuk menghitungnya dapat menggunakan OGC Method <strong>STArea()<\/strong>.<\/p>\n<pre class=\"theme:ssms2012 lang:tsql decode:true\" title=\"Menghitung Luas Area\">DECLARE @Pentagon geography\r\nSET @Pentagon = geography::STPolyFromText('POLYGON((\r\n-77.0532238483429  38.870863029297695,\r\n-77.05478297004701  38.87304314667469,\r\n-77.05788016319276  38.872800914712734,\r\n-77.05849170684814  38.870219840133124,\r\n-77.05556273460388  38.8690670969385,\r\n-77.0532238483429  38.870863029297695))',4326)\r\nselect @Pentagon,@Pentagon.STArea() luas_area<\/pre>\n<p>&nbsp;<\/p>\n<p>Berikut ini saya contohkan menghitung sebuah luas PENTAGON.<span style=\"font-size: 13px;\">bila T-SQL diatas dijalankan akan memberikan result berikut :<\/span><\/p>\n<p><a href=\"\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/area1_5F00_11C78A68.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"area1\" alt=\"area1\" src=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/area1_5F00_thumb_5F00_115B5773.png\" width=\"452\" height=\"75\" border=\"0\" \/><\/a><\/p>\n<p>karena SRID yang digunakan adalah 4326, maka satuan luasnya adalah meter persegi. untuk sample diatas luasnya adalah 136,272.39716506 meter persegi.<\/p>\n<p>dan berikut ini adalah bentuk spatial Resultnya :<\/p>\n<p><a href=\"\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/area_5F00_1F359B3D.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border: 0px;\" title=\"area\" alt=\"area\" src=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/area_5F00_thumb_5F00_29F2F292.png\" width=\"382\" height=\"269\" border=\"0\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seperti diketahui bahwa di SQL Server 2008 telah support untuk spatial. berikut ini saya coba berikan contoh bagaimana untuk menghitung sebuah luas area polygon. untuk menghitungnya dapat menggunakan OGC Method STArea(). DECLARE @Pentagon geography SET @Pentagon = geography::STPolyFromText(&#8216;POLYGON(( -77.0532238483429 38.870863029297695, -77.05478297004701 38.87304314667469, -77.05788016319276 38.872800914712734, -77.05849170684814 38.870219840133124, -77.05556273460388 38.8690670969385, -77.0532238483429 38.870863029297695))&#8217;,4326) \u2026<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\">Continue reading<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":132,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[65,39],"class_list":["post-131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spatial","tag-polygon","tag-starea"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculating Total Surface Area of a Geography Instance - Suherman Blog<\/title>\n<meta name=\"description\" content=\"Menghitung Luas Area\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculating Total Surface Area of a Geography Instance - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Menghitung Luas Area\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-02T15:51:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-03-07T03:04:13+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png\" \/>\n\t<meta property=\"og:image:width\" content=\"382\" \/>\n\t<meta property=\"og:image:height\" content=\"269\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Calculating Total Surface Area of a Geography Instance\",\"datePublished\":\"2014-01-02T15:51:06+00:00\",\"dateModified\":\"2014-03-07T03:04:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\"},\"wordCount\":80,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png\",\"keywords\":[\"polygon\",\"STArea\"],\"articleSection\":[\"Spatial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\",\"url\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\",\"name\":\"Calculating Total Surface Area of a Geography Instance - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png\",\"datePublished\":\"2014-01-02T15:51:06+00:00\",\"dateModified\":\"2014-03-07T03:04:13+00:00\",\"description\":\"Menghitung Luas Area\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage\",\"url\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png\",\"contentUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png\",\"width\":382,\"height\":269},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculating Total Surface Area of a Geography Instance\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"http:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculating Total Surface Area of a Geography Instance - Suherman Blog","description":"Menghitung Luas Area","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html","og_locale":"en_US","og_type":"article","og_title":"Calculating Total Surface Area of a Geography Instance - Suherman Blog","og_description":"Menghitung Luas Area","og_url":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-01-02T15:51:06+00:00","article_modified_time":"2014-03-07T03:04:13+00:00","og_image":[{"width":382,"height":269,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png","type":"image\/png"}],"author":"admin","twitter_misc":{"Written by":"admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Calculating Total Surface Area of a Geography Instance","datePublished":"2014-01-02T15:51:06+00:00","dateModified":"2014-03-07T03:04:13+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html"},"wordCount":80,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png","keywords":["polygon","STArea"],"articleSection":["Spatial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html","url":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html","name":"Calculating Total Surface Area of a Geography Instance - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png","datePublished":"2014-01-02T15:51:06+00:00","dateModified":"2014-03-07T03:04:13+00:00","description":"Menghitung Luas Area","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#primaryimage","url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png","contentUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/01\/calc.png","width":382,"height":269},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/calculating-total-surface-area-of-a-geography-instance.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Calculating Total Surface Area of a Geography Instance"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"http:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":4,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":239,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/131\/revisions\/239"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/132"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}