Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
COSCUP 17 Lightning Talk
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
Hsiao-Ting Yu
August 05, 2017
220
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
COSCUP 17 Lightning Talk
Hsiao-Ting Yu
August 05, 2017
Transcript
18 slides
當資料來來了了 誰來來把它放上去 —以 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/ ⾒見見證⿊黑魔法
More Decks by Hsiao-Ting Yu
See All by Hsiao-Ting Yu
有人用了更頭大: OpenStreetMap 的社群營運挑戰
littlebtc
0
140
[COSCUP 2014] Take Back the Map to People: When OpenStreetMap Meets Taiwan Social Issues
littlebtc
0
250
[SOTM.TW 2013] The mapping status of bus lines in Taiwan
littlebtc
0
270
(Mobile) App and Open Source: Kamigami Client on Various Platforms
littlebtc
0
600
Mobile Web Issues: Limitation and Experience
littlebtc
1
350
From Rails to Node.js + Backbone: The Rewrite of TouchLimit
littlebtc
2
240
Featured
See All Featured
Bash Introduction
62gerente
615
220k
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership regardless of position
madoxten
70
69k
Ecommerce SEO: The Keys for Success Now & Beyond - #SERPConf2024
aleyda
1
2.3k
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
helenjbeal
2
400
State of Search Keynote: SEO is Dead Long Live SEO
ryanjones
0
350
Marketing to machines
jonoalderson
1
6k
Balancing Empowerment & Direction
lara
6
1.4k
Mobile First: as difficult as doing things right
swwweet
225
10k
The agentic SEO stack - context over prompts
schlessera
0
1k
The Pragmatic Product Professional
lauravandoore
37
7.5k
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
33
5.8k
We Analyzed 250 Million AI Search Results: Here's What I Found
joshbly
2
2.1k