{"id":834,"date":"2020-07-18T07:29:00","date_gmt":"2020-07-18T00:29:00","guid":{"rendered":"http:\/\/www.gis2me.com\/geospatial\/?p=834"},"modified":"2025-04-30T09:18:03","modified_gmt":"2025-04-30T02:18:03","slug":"r-studio-ep19-%e0%b8%aa%e0%b8%a3%e0%b9%89%e0%b8%b2%e0%b8%87-map-with-hyperlink-popup-%e0%b8%94%e0%b8%b6%e0%b8%87%e0%b8%a0%e0%b8%b2%e0%b8%9e%e0%b8%ab%e0%b8%a3%e0%b8%b7%e0%b8%ad%e0%b8%a7%e0%b8%b5","status":"publish","type":"post","link":"http:\/\/www.gis2me.com\/geospatial\/?p=834","title":{"rendered":"R-studio : ( EP#19 ) \u0e2a\u0e23\u0e49\u0e32\u0e07 Map with Hyperlink popup \u0e14\u0e36\u0e07\u0e20\u0e32\u0e1e\u0e2b\u0e23\u0e37\u0e2d\u0e27\u0e35\u0e14\u0e35\u0e42\u0e2d\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e1a\u0e19\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48 \u0e14\u0e49\u0e27\u0e22\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 R"},"content":{"rendered":"<p>R-studio : ( EP#19 ) \u0e2a\u0e23\u0e49\u0e32\u0e07 Map with Hyperlink popup \u0e14\u0e36\u0e07\u0e20\u0e32\u0e1e\u0e2b\u0e23\u0e37\u0e2d\u0e27\u0e35\u0e14\u0e35\u0e42\u0e2d\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e1a\u0e19\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48 \u0e14\u0e49\u0e27\u0e22\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 R<br \/><strong data-start=\"23\" data-end=\"73\">EP#19: \u0e2a\u0e23\u0e49\u0e32\u0e07 \u201cMap with Hyperlink Popup\u201d \u0e14\u0e49\u0e27\u0e22 R<\/strong> \u0e19\u0e35\u0e49\u0e16\u0e37\u0e2d\u0e40\u0e1b\u0e47\u0e19\u0e01\u0e32\u0e23\u0e22\u0e01\u0e23\u0e30\u0e14\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e19\u0e33\u0e40\u0e2a\u0e19\u0e2d\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e0a\u0e34\u0e07\u0e1e\u0e37\u0e49\u0e19\u0e17\u0e35\u0e48\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e21\u0e35\u0e1b\u0e0f\u0e34\u0e2a\u0e31\u0e21\u0e1e\u0e31\u0e19\u0e18\u0e4c (interactive mapping) \u0e42\u0e14\u0e22\u0e43\u0e0a\u0e49\u0e20\u0e32\u0e29\u0e32 R \u0e41\u0e25\u0e30\u0e41\u0e1e\u0e47\u0e01\u0e40\u0e01\u0e08 <strong data-start=\"185\" data-end=\"198\"><code data-start=\"187\" data-end=\"196\">leaflet<\/code><\/strong> \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e22\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1e\u0e34\u0e01\u0e31\u0e14\u0e01\u0e31\u0e1a\u0e2a\u0e37\u0e48\u0e2d\u0e20\u0e32\u0e1e\/\u0e27\u0e35\u0e14\u0e35\u0e42\u0e2d\u0e2b\u0e23\u0e37\u0e2d\u0e25\u0e34\u0e07\u0e01\u0e4c\u0e40\u0e2a\u0e23\u0e34\u0e21\u0e43\u0e19 <strong data-start=\"258\" data-end=\"277\">Popup \u0e02\u0e2d\u0e07\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48<\/strong><\/p>\n<p>\u0e40\u0e1b\u0e47\u0e19\u0e1a\u0e17\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e1e\u0e34\u0e01\u0e31\u0e14\u0e08\u0e38\u0e14\u0e41\u0e2b\u0e25\u0e48\u0e07\u0e2a\u0e16\u0e32\u0e19\u0e17\u0e35\u0e48\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e41\u0e19\u0e30\u0e19\u0e33 \u0e08\u0e32\u0e01 Google sheets \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e22\u0e07\u0e44\u0e1b\u0e22\u0e31\u0e07\u0e27\u0e35\u0e14\u0e35\u0e42\u0e2d \u0e41\u0e25\u0e30\u0e19\u0e33\u0e17\u0e32\u0e07\u0e14\u0e49\u0e27\u0e22 google map \u0e43\u0e2b\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e44\u0e27\u0e49\u0e43\u0e0a\u0e49\u0e41\u0e19\u0e30\u0e19\u0e33\u0e41\u0e2b\u0e25\u0e48\u0e07\u0e2a\u0e16\u0e32\u0e19\u0e17\u0e35\u0e48\u0e19\u0e31\u0e49\u0e19 \u0e41\u0e25\u0e30\u0e08\u0e31\u0e14\u0e17\u0e33\u0e40\u0e1b\u0e47\u0e19 Webpage Html file \u0e44\u0e14\u0e49\u0e2a\u0e30\u0e14\u0e27\u0e01<\/p>\n<p>\u0e25\u0e07\u0e17\u0e30\u0e40\u0e1a\u0e35\u0e22\u0e19\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e02\u0e2d\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e44\u0e1f\u0e25\u0e4c R script \u0e44\u0e14\u0e49\u0e17\u0e35\u0e48 <a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSeLf7SRVYVz59P3wNA_WT6UePNLzplQVO2_CAb6ckOqNWsBZQ\/viewform\">https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSeLf7SRVYVz59P3wNA_WT6UePNLzplQVO2_CAb6ckOqNWsBZQ\/viewform<\/a><\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/jT06MYPSubA\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd0e \u0e41\u0e19\u0e27\u0e04\u0e34\u0e14\u0e2b\u0e25\u0e31\u0e01<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e43\u0e0a\u0e49\u0e1e\u0e34\u0e01\u0e31\u0e14\u0e08\u0e38\u0e14 (Latitude\/Longitude) \u0e08\u0e32\u0e01 <strong>Google Sheets<\/strong><\/li>\n\n\n\n<li>\u0e2a\u0e23\u0e49\u0e32\u0e07 popup \u0e17\u0e35\u0e48\u0e21\u0e35 <strong>Hyperlink<\/strong> \u0e2b\u0e23\u0e37\u0e2d <strong>Embed \u0e20\u0e32\u0e1e\/YouTube<\/strong><\/li>\n\n\n\n<li>\u0e41\u0e2a\u0e14\u0e07\u0e1a\u0e19 <strong>Leaflet Map<\/strong><\/li>\n\n\n\n<li>\u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 <strong>HTML Webpage<\/strong> \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19\u0e2d\u0e2d\u0e19\u0e44\u0e25\u0e19\u0e4c<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udccc \u0e02\u0e31\u0e49\u0e19\u0e15\u0e2d\u0e19\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. \u0e40\u0e15\u0e23\u0e35\u0e22\u0e21\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 Google Sheets<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>name<\/th><th>lat<\/th><th>lon<\/th><th>img_url<\/th><th>video_url<\/th><th>gmap_url<\/th><\/tr><\/thead><tbody><tr><td>\u0e27\u0e31\u0e14\u0e1e\u0e23\u0e30\u0e41\u0e01\u0e49\u0e27<\/td><td>13.7515<\/td><td>100.4923<\/td><td><a class=\"\">https:\/\/bit.ly\/temple_img<\/a><\/td><td><a class=\"\" href=\"https:\/\/youtu.be\/example\">https:\/\/youtu.be\/example<\/a><\/td><td><a class=\"\">https:\/\/maps.google.com\/?q=13.7515,100.4923<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u2705 <strong>Tips<\/strong>: \u0e15\u0e31\u0e49\u0e07\u0e04\u0e48\u0e32 Google Sheet \u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e47\u0e19 <code>Share -&gt; Anyone with the link<\/code> \u0e41\u0e25\u0e30\u0e43\u0e0a\u0e49\u0e41\u0e1e\u0e47\u0e01\u0e40\u0e01\u0e08 <code>gsheet<\/code> \u0e2b\u0e23\u0e37\u0e2d <code>googlesheets4<\/code><\/p>\n<\/blockquote>\n\n\n\n<h4 class=\"wp-block-heading\">2. \u0e2d\u0e48\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01 Google Sheets<\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">rCopyEdit<code>library(googlesheets4)\nlibrary(dplyr)\nlibrary(leaflet)\n\n# \u0e25\u0e34\u0e07\u0e01\u0e4c Google Sheets \u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e41\u0e1a\u0e1a public\nsheet_url &lt;- \"https:\/\/docs.google.com\/spreadsheets\/d\/1xxxxxxxxxxxxxxxxxxx\/edit#gid=0\"\ndata &lt;- read_sheet(sheet_url)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">3. \u0e2a\u0e23\u0e49\u0e32\u0e07 popup \u0e1e\u0e23\u0e49\u0e2d\u0e21 Hyperlink \/ \u0e20\u0e32\u0e1e<\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">rCopyEdit<code>data &lt;- data %&gt;%\n  mutate(popup = paste0(\n    \"&lt;b&gt;\", name, \"&lt;\/b&gt;&lt;br&gt;\",\n    \"&lt;a href='\", gmap_url, \"' target='_blank'&gt;\ud83d\udccd Google Map&lt;\/a&gt;&lt;br&gt;\",\n    \"&lt;a href='\", video_url, \"' target='_blank'&gt;\ud83c\udfac YouTube&lt;\/a&gt;&lt;br&gt;\",\n    \"&lt;img src='\", img_url, \"' width='200'&gt;\"\n  ))\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4. \u0e41\u0e2a\u0e14\u0e07\u0e1c\u0e25\u0e1a\u0e19\u0e41\u0e1c\u0e19\u0e17\u0e35\u0e48\u0e14\u0e49\u0e27\u0e22 <code>leaflet<\/code><\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">rCopyEdit<code>leaflet(data) %&gt;%\n  addTiles() %&gt;%\n  addMarkers(~lon, ~lat, popup = ~popup) %&gt;%\n  addMiniMap(toggleDisplay = TRUE)\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">5. \u0e2a\u0e48\u0e07\u0e2d\u0e2d\u0e01 HTML<\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">rCopyEdit<code>library(htmlwidgets)\nsaveWidget(leaflet(data) %&gt;%\n             addTiles() %&gt;%\n             addMarkers(~lon, ~lat, popup = ~popup),\n           file = \"map_with_hyperlink_popup.html\")\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83e\udde0 \u0e1b\u0e23\u0e30\u0e42\u0e22\u0e0a\u0e19\u0e4c<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0e43\u0e0a\u0e49\u0e43\u0e19\u0e01\u0e32\u0e23\u0e41\u0e19\u0e30\u0e19\u0e33 <strong>\u0e41\u0e2b\u0e25\u0e48\u0e07\u0e17\u0e48\u0e2d\u0e07\u0e40\u0e17\u0e35\u0e48\u0e22\u0e27<\/strong> \/ <strong>\u0e2a\u0e16\u0e32\u0e19\u0e17\u0e35\u0e48\u0e2a\u0e33\u0e04\u0e31\u0e0d<\/strong><\/li>\n\n\n\n<li>\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19 <strong>\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e21\u0e37\u0e2d\u0e2a\u0e37\u0e48\u0e2d\u0e2a\u0e32\u0e23\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e2a\u0e38\u0e02\u0e20\u0e32\u0e1e<\/strong> \u0e40\u0e0a\u0e48\u0e19 \u0e08\u0e38\u0e14\u0e1a\u0e23\u0e34\u0e01\u0e32\u0e23\u0e27\u0e31\u0e04\u0e0b\u0e35\u0e19<\/li>\n\n\n\n<li>\u0e43\u0e0a\u0e49\u0e43\u0e19\u0e01\u0e32\u0e23 <strong>\u0e23\u0e32\u0e22\u0e07\u0e32\u0e19\u0e1c\u0e25\u0e2a\u0e33\u0e23\u0e27\u0e08\u0e20\u0e32\u0e04\u0e2a\u0e19\u0e32\u0e21<\/strong> \u0e17\u0e35\u0e48\u0e21\u0e35\u0e20\u0e32\u0e1e\u0e1b\u0e23\u0e30\u0e01\u0e2d\u0e1a<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udce5 \u0e25\u0e07\u0e17\u0e30\u0e40\u0e1a\u0e35\u0e22\u0e19\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e23\u0e31\u0e1a R Script<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udc49 <a class=\"\" href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSeLf7SRVYVz59P3wNA_WT6UePNLzplQVO2_CAb6ckOqNWsBZQ\/viewform\">\u0e41\u0e1a\u0e1a\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e02\u0e2d\u0e23\u0e31\u0e1a R Script \u2013 EP#19<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>R-studio : ( EP#19 ) \u0e2a\u0e23\u0e49\u0e32\u0e07 Map with Hyperlink popup \u0e14\u0e36\u0e07 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[21],"tags":[462,457,463,440,455,456,453,443,454,452,439,459,460,458,461],"class_list":["post-834","post","type-post","status-publish","format-standard","hentry","category--r-studio","tag-data-visualization-r","tag-embedded-map","tag-field-survey-reportj","tag-gis--r","tag-google-sheets-gis","tag-html-map","tag-interactive-map","tag-leaflet","tag-map-with-hyperlink","tag-popup-map","tag-r-studio","tag-r-","tag-460","tag-458","tag-461"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=834"}],"version-history":[{"count":1,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/834\/revisions"}],"predecessor-version":[{"id":835,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=\/wp\/v2\/posts\/834\/revisions\/835"}],"wp:attachment":[{"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gis2me.com\/geospatial\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}