#gis

2021-01-06
chewei 哲瑋 01:17:50
這是一個釋出 行業廢棄物 的媒合社團，有朋友有興趣爬社團貼文嗎？例如進行物品種類貼文統計，每則貼文也都有地理位置描述
https://www.facebook.com/groups/1806727836019362/permalink/2200486746643467/
Facebook Groups
MengHui Lin
:star:請依格式發文:star: :warning:發文格式不全『直接刪』 . 團名"我們一直在丟東西" 是一個警示， 反映『每個行業、每個人、每天都在做這件事。』 沒有完善處理機制，我們丟出問題、丟出汙染、丟出更多環境成本。 廢棄已經開始侵蝕我們的土地。 因為東西可不是丟(送)出去，就眼不見為淨、回收，就可以一直製造。 如何實踐【循環經濟】，使得資源、環境與經濟能多贏， 是大家都正在學習的課題。 ....
  • ❤️1
2021-01-10
jhaoyuyo 16:25:37
@jhaoyuyo has joined the channel
2021-01-11
chewei 哲瑋 22:06:42
這是一款地號 app，還有現地 AR 看位置!
https://play.google.com/store/apps/details?id=org.gesrt.drawing
play.google.com
地籍查詢—地號定位、AR街景 - Apps on Google Play
1.點線面繪製功能 2.透過AR街景功能查看地號輪廓 3.套圖功能，整合國內開放之WMTS圖層，如中研院百年歷史地圖、國土測繪中心、魯地圖、Google圖層等等 4.地籍定位，查看地號之土地公告地價與公告現值，並導航與街景 5.座標定位、TWD97 119/121、經緯度 6.門牌地址定位
  • 2
2021-01-20
Kay 13:58:08
@kay682 has joined the channel
2021-01-22
餅乾 22:10:18
@dh10050160 has joined the channel
2021-01-25
chewei 哲瑋 19:33:21
Replied to a thread: 2020-12-29 23:33:13
@ronnywang 有看到村里內單一年齡的人口資料，針對「18-20 投票人口分佈地圖」這個 gis 教案操作，可以來確認一下步驟與工具~

(1) 下載資料，接著使用 excel 或 spreadsheet 整理好「村里 18~20 歲人口」csv
(2) 查找並下載「村里 polygon」
(3) 將 polygon 與 人口 csv 兩者對起來，得到 gis 檔案 ← 這步驟有建議的工具嗎 ?
(4) 選擇 Carto 呈現 (Google My Map 可以用於美食地圖的點資料操作過程)，Carto 應該會有一些資料視覺化選項可以操作，待確認

(3) & (4) 會不會可以直接用 Plotdb https://plotdb.com/
Image 276.png
plotdb.com
PlotDB: Share Visualizations with Everyone
PlotDB is a place for you to create, share and ask for visualizations online.
肥貓 20:20:13
第3個步驟，可以試試看我這個影片（使用QGIS+LibreOffice Calc）
肥貓 20:23:28
這是個簡單的Live Demo，因為麥克風壞了所以就沒錄聲音。但是可大致簡單分為「欄位字串合併」（如"新北市"+:板橋區"="新北市板橋區"）、資料串聯（Join）功能，以及失敗的分層設色圖製作，最後則是把所有欄位的東西存成CSV匯出
肥貓 20:31:24
若該檔案無法正常播放，請到我的備援連結去下載
chewei 哲瑋 20:39:18
嗯嗯~ 目前設想教學當天應該是沒有充分時間安裝 QGIS，不過可以在過程中提到 操作 QGIS 的步驟，可以參考你分享的影片連結讓參加者參考
chewei 哲瑋 20:46:12
待測試 人口與村里 polygon 能否用以下網頁 merge
https://funkeinteraktiv.github.io/geo-data-merger/
肥貓 20:49:43
如果是國高中環境，或許可請當地資訊人員事前預先派發
chewei 哲瑋 21:54:26
Replied to a thread: 2020-12-07 22:48:09
#詢問 有推薦可提供單筆地理資料獨立網址的線上地圖嗎? (檢查過無：googlemymap, carto, umap, geojson.io)

欄位預計放在 Airtable 裡面方便協作管理
大概內容長這樣：
．舊名: 長短樹線
．踏查類型: 環景影片
．素材網址: https://youtu.be/XN99HRIAgTc
Image 278.png
chewei 哲瑋 22:32:12
突然想起來有整理過這東西
https://g0v.hackpad.tw/-Mapfessional-EJfaf9C5gaT
ronnywang 22:55:02
第三步驟開源並廣為人知的工具我現在只知道 QGIS
ronnywang 22:55:20
我之前做的 github helper 就是想要解決這問題，或許也可以我在近日把他修好讓他變成一個這樣的工具
ronnywang 22:55:38
再來非開源的話就是看看 cartodb 能不能解決這需求了？
ronnywang 22:55:58
不過我們這次課程要用到 QGIS 好像有點難，畢竟有安裝的問題…
ronnywang 22:56:12
或許我這幾日把 github helper 修好是比較好作法 XD
ronnywang 23:19:47
geojson.io 嗎？如果要做到村里等級的資料會很肥喔
ronnywang 23:20:41
不過 geojson,io 有支援 polygon 顏色，所以確實可以產生人口密度地圖含有背景色階顏色
ronnywang 23:20:55
你有現成可以產生 polygon 背景色階的工具嗎？
2021-01-26
ronnywang 00:48:52
目前覺得單筆資料如果不大的話，放在 github 上用 geojson 存好像是最簡單的方式，像是 https://github.com/ronnywang/sandbox/blob/master/20130805/%E7%A2%A7%E6%BD%AD%E5%8F%A4%E8%B9%9F.geojson
20130805/碧潭古蹟.geojson
``` {"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53703101072,24.956423022659],[121.53703443294,24.956387648962],[121.53705665439,24.956385372044],[121.53705879262,24.956448221098],[121.53702863247,24.956448188112],[121.53703101072,24.956423022659]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":110000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53699160769,24.956424652873],[121.53703101072,24.956423022659],[121.53702863247,24.956448188112],[121.53699170944,24.956448108638],[121.53699160769,24.956424652873]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":120000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53695111674,24.956426357861],[121.53699160769,24.956424652873],[121.53699170944,24.956448108638],[121.53695245479,24.956448108424],[121.53695111674,24.956426357861]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":130000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53694862929,24.956390509419],[121.53703443294,24.956387648962],[121.53703101072,24.956423022659],[121.53699160769,24.956424652873],[121.53695111674,24.956426357861],[121.53694862929,24.956390509419]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":140000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53694529692,24.956339073842],[121.53703926471,24.956336750868],[121.53703443294,24.956387648962],[121.53694862929,24.956390509419],[121.53694529692,24.956339073842]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":150000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53703926471,24.956336750868],[121.53705504342,24.956336552248],[121.53705665439,24.956385372044],[121.53703443294,24.956387648962],[121.53703926471,24.956336750868]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":160000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53705665439,24.956385372044],[121.53705504342,24.956336552248],[121.53705335165,24.956287024099],[121.53705175636,24.956241818334],[121.53704997088,24.956188605571],[121.53704846101,24.956145171108],[121.53704711183,24.956102940761],[121.53704567908,24.95605936429],[121.53704398763,24.956009907002],[121.53704221998,24.955960804311],[121.53704068737,24.95591212596],[121.53707029989,24.95591138141],[121.53708856442,24.956448326343],[121.53705879262,24.956448221098],[121.53705665439,24.956385372044]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1110000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53708981283,24.956485242217],[121.53708856442,24.956448326343],[121.53707029989,24.95591138141],[121.53706744761,24.955827275591],[121.53712185671,24.955826583351],[121.5371279101,24.956003510055],[121.53712959421,24.956051266621],[121.53713744085,24.956283177664],[121.53713895474,24.956327533348],[121.53714742425,24.956577583433],[121.53715482174,24.956795535783],[121.53715642323,24.956842158809],[121.53710033786,24.956797007818],[121.53708981283,24.956485242217]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1140000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53713895474,24.956327533348],[121.5371735409,24.956326487383],[121.53717514177,24.956372968687],[121.53717710337,24.956430928729],[121.53717879182,24.956479677378],[121.53718048149,24.95652870948],[121.53718208575,24.956575970278],[121.53714742425,24.956577583433],[121.53713895474,24.956327533348]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1270000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53736585502,24.956470994947],[121.53746486587,24.956466456712],[121.53746313027,24.956514296474],[121.53746313704,24.956515855467],[121.53737135389,24.956520084168],[121.53736585502,24.956470994947]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1480000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53746224761,24.956364704819],[121.5374660887,24.956318416477],[121.5374668094,24.95630537482],[121.53757371952,24.956312004592],[121.53758638242,24.956381902095],[121.53746777182,24.956383818286],[121.53746062091,24.956383914953],[121.53746224761,24.956364704819]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1560000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53746562091,24.956443423044],[121.53746777182,24.956383818286],[121.53758638242,24.956381902095],[121.53758757915,24.95638898422],[121.53773998076,24.95638191457],[121.53774125876,24.956407704613],[121.53760033217,24.956425929431],[121.53746562091,24.956443423044]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1570000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53736028305,24.956422968956],[121.53735398043,24.956367788292],[121.53742463374,24.956384540853],[121.53746062091,24.956383914953],[121.53746777182,24.956383818286],[121.53746562091,24.956443423044],[121.53746486587,24.956466456712],[121.53736585502,24.956470994947],[121.53736028305,24.956422968956]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1580000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53717710337,24.956430928729],[121.53736028305,24.956422968956],[121.53736585502,24.956470994947],[121.53717879182,24.956479677378],[121.53717710337,24.956430928729]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1590000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53717514177,24.956372968687],[121.53735398043,24.956367788292],[121.53736028305,24.956422968956],[121.53717710337,24.956430928729],[121.53717514177,24.956372968687]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1600000}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.53745377588,24.956364947981],[121.53746224761,24.956364704819],[121.53746062091,24.956383914953],[121.53742463374,24.956384540853],[121.53735398043,24.956367788292],[121.53745377588,24.956364947981]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u865f":1610001}},{"type":"Feature","geometry":{"type":"MultiPolygon","coordinates":[[[[121.5371735409,24.956326487383],[121.53734969737,24.956330174723],[121.53734864812,24.956321249589],[121.53745489364,24.956318031686],[121.53745377588,24.956364947981],[121.53735398043,24.956367788292],[121.53717514177,24.956372968687],[121.5371735409,24.956326487383]]]]},"properties":{"\u7e23\u5e02":"\u65b0\u5317\u5e02","\u9109\u93ae":"\u65b0\u5e97\u5340","\u8def\u6bb5":"\u78a7\u6f6d\u6bb5","\u6bb5\u86…
  • 👍2
SweetCow 10:54:26
我怎麼記得第三步在Carto裡面可以直接做? 分別上傳 CSV 和 Polygon 之後在carto裡面可以利用欄位串起來
ronnywang 10:54:59
不過 cartodb 會不會塞一份村里 polygon 資料就用完免費的 quota 了？
ronnywang 10:56:12
喔喔，現在方案跟以前不一樣了，現在免費不是像以前一樣 10MB
helenhan25 20:07:32
@helenhan25 has joined the channel