Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
COSCUP 17 Lightning Talk
Search
Hsiao-Ting Yu
August 05, 2017
0
190
COSCUP 17 Lightning Talk
Hsiao-Ting Yu
August 05, 2017
Tweet
Share
More Decks by Hsiao-Ting Yu
See All by Hsiao-Ting Yu
有人用了更頭大: OpenStreetMap 的社群營運挑戰
littlebtc
0
75
[COSCUP 2014] Take Back the Map to People: When OpenStreetMap Meets Taiwan Social Issues
littlebtc
0
230
[SOTM.TW 2013] The mapping status of bus lines in Taiwan
littlebtc
0
220
(Mobile) App and Open Source: Kamigami Client on Various Platforms
littlebtc
0
460
Mobile Web Issues: Limitation and Experience
littlebtc
1
280
From Rails to Node.js + Backbone: The Rewrite of TouchLimit
littlebtc
2
200
Featured
See All Featured
GraphQLの誤解/rethinking-graphql
sonatard
71
11k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
32
1.5k
Fantastic passwords and where to find them - at NoRuKo
philnash
52
3.4k
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
11
1.1k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.5k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
26
3k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
A designer walks into a library…
pauljervisheath
207
24k
Reflections from 52 weeks, 52 projects
jeffersonlam
351
21k
The Cult of Friendly URLs
andyhume
79
6.6k
Transcript
當資料來來了了 誰來來把它放上去 —以 OSM + 台中市⾨門牌資料為例例 Littlebtc ⼩小B Text: CC-BY-SA
Map data: © OpenStreetMap Contributors © Taichung City Government
Me • 第⼀一次 COSCUP: 2009 • 從⼩小是地圖迷 + 程式天才 •
本業寫程式,突然愛上畫地圖 • 近年年專職是議程中睡著
提供 台中市政府
None
有都市計畫圖 重劃區就IMBA啦!
1,100,788 個地址
None
街道哪裡來來?
29,573 個街道叢集 熬夜*1
None
嘗試各種 PostGIS ⿊黑魔法
熬夜*2
經過了了熬夜*3
⿊黑魔法的 Python CSV -> PostGIS • tl;dr: PostGIS + PgRouting
+ ⼀一整天嘗試當掉或卡死之後得到的魔法 • TWD97 轉 4326 • 街道作群組 unnest(ST_ClusterWithin(location, 0.001)) • pgr_PointsAsPolygon ⼤大數量量比較快 • ST_SimplifyPreserveTopology(ST_SmartConcaveHull()) 處理理其他的
後置作業 • 加上圖磚 • 放上 Google Cloud Engine • 後續改良
None
Finally • 圖磚跟 Task Manager 貼社團 • 祈禱有⼈人來來畫 3 months
ago
http://osmtm.exc.moe/ Facebook: OpenStreetMap台灣 有粉絲⾴頁、也有社團喔 來來幫忙畫 或著看看戲 https://github.com/OsmHackTW/taichung-street-tile/ ⾒見見證⿊黑魔法