Dobong-gu(Seoul) Safety-info Map
Where is Dobong-gu? Dobong-gu Seoul Cityhall Seoul K-hotel http://www.openstreetmap.org/ Imagine Spatially
Citizen Participation + BigData Analysis Imagine Spatially
Project Process Step 3 Step 1 Step 2 Step 4 Data Analysis (Text-mining) Map-based Dataset Spot Survey Consturction Inspection Data Analysis (Hotspot) Imagine Spatially
Map-based Survey Imagine Spatially
Map-based survey Process Production the questionnaire Carrying out the survey Gathering completed papers Imagine Spatially
Map-based survey form 1. Please draw your main walkway to school using red marker 2. Please mark a location where your child may feel danger using blue marker and describe the reason *Please refer to attached example map Teenagers smoke Dark road, Need more lights Busy street(too many vehichles) Need CCTV Traffic signal violation Drive too fast Adult stuff Imagine Spatially
Raw data example “Dangerous spot” Illegal parking Streetlamp doesn’t work Imagine Spatially
Raw data example No traffic light Bus & bicycle Collision No answer… Imagine Spatially
Dataset Consturction Imagine Spatially
Convert from RAW DATA in A3 PAPER to VECTOR SHAPE FILE Imagine Spatially
Example: “Way to school” Imagine Spatially
Example: students and their parents compliant Imagine Spatially
Results 2,932 Children 3,247 Children danger consciousness School walkway area = 1,766 km = 14.3 km 2 = 1,097 mile = 3,533 ac Imagine Spatially
Survey Data = BigData ? 1,766 km > 1,707 km Seoul Osaka Shanghai http://map.meurisse.org/ Imagine Spatially
Data Analysis (Text-mining) Imagine Spatially
Text-mining analysis method Top Keyword (using R library – Word Cloud) Sorting & Adding Subtract Change Visualizing Extract Related keywords (using R library – Assosication rule) Association Extract & Visualizing Subtract Transaction Rule Imagine Spatially
Top Keyword Analysis (using R library – Word Cloud) 312 Keywords, 12,914 frequencies Top 15 Keywords form 59% (other 297 keywords form 41%) Rank Keyword Freq. ratio 1 Many cars 1,731 13.4% 2 Drive too fast 664 5.1% 3 Dark 653 5.1% 4 Traffic light 638 4.9% 5 Signal violation 619 4.8% 6 CCTV 531 4.1% 7 Night 462 3.6% 8 Unfrequented 419 3.2% 58.9% 9 Teenager 368 2.8% 10 sidewalk 359 2.8% 11 Illegal parking 276 2.1% 12 Alley 268 2.1% 13 Entry and exit 240 1.9% 14 Crossroad 208 1.6% 15 Crosswalk 185 1.4% 16~312 And many others 4,918 41.1% Total 12,914 100% Imagine Spatially
Differences between each primary school Ga-in Nuwon Dobong Baekwoon Sungmi Shinbanghak shinchang shinhak Shinwha Ssangmun Imagine Spatially
Differences between each primary school Obong Wolchon Jaun Changkyung Changdo Changdong Changrim Changwon Changil Chodang Imagine Spatially
Related keywords (using R library - Assosication rule) Why they think ‘supermarket’ dangerous ? “Understanding the keywords in the context” ‘Taxi driver’ Raw sentence Smoking “because taxi drivers who heavily smoke always gather together teenager here” Raw sentence “sometimes full -size-car or trucks are reversing when children go to school” Full-size-car supermarket Imagine Spatially
Typology of the dangerous situation for children based on text analysis 9 types of situations and keywords View, Too many cars Bad drivers interrupted Apartment, supermarket, Illegal U-turn, drive too trees, reflector, banner, shopping arcade, driving fast, lane violation standing signboard, school, church illegal parking Want to avoid Harmful Mixed traffic situation points flow Smoking, drinking, sex Night spot, bar, adult Narrow sidewalk, double offender, trenchcoat, stuff, illegal flyer park, underpass, side middle school student streets Transport Worry about Hard to notice injury infrasturcture Narrow alley, need alarm, Under the construction, Traffic light, complex unfrequented, small warehouse, wild pig, traffic sign, flashing park, dark landslip, noise, exhaust signal, left turn signal, crosswalk Imagine Spatially
Compare responses using 9 types View, Too many cars Bad drivers interrupted 23% 16% 11% Want to avoid Harmful Mixed traffic situation points flow 4% 1% 9% Worry about Transport Hard to notice injury infrasturcture 16% 15% 3% Imagine Spatially
Differences between each primary school (examples) Too View, Legend TA A Bad many Interrup 23.0 16.0 11.4 drivers 24.6 10.6 10.0 cars ted sch. Mixed Want to Harmful traffic Mixed traffic flow 4.4 1.3 9.0 Avoid Points flow Worry 5.6 0.6 14.4 Hard to Transp. About 3.5 16.0 15.3 notice infra injury Hard to notice 3.8 22.6 7.9 Bad drivers B C 18.0 18.4 5.2 12.6 30.4 9.3 sch. sch. Harmful points 8.0 10.4 2.4 4.5 0.4 8.1 Hard to notice 4.4 23.2 10.0 2.4 18.8 13.6 Imagine Spatially
GIS Analysis – Hotspot extract process Step 1 Step 2 Step 3 Step 4 Insert 9 column Recheck keywords and (dangerous situation type) sentence in hotspot of and write binary value each 9 type Summarized Safety Relative evaluation Information map! each grid cell (Safety-info map) Imagine Spatially
Labeling all complaints using QGIS… Imagine Spatially
Step 1. insert 9 column(dangerous situation type) and write binary value type1 type2 type3 type4 type5 type6 type7 type8 type9 Imagine Spatially
Step 1. insert 9 column(dangerous situation type) and write binary value All type ‘Want to avoid situation’ ‘bad drivers’ … ‘hard to notice’ ‘too many cars’ Imagine Spatially
Step 2. Relative evaluation each grid cell Divide each school area into GRID (10 x 10 meter) Spatial Join (GRID + Responses, find sum of binary value) Imagine Spatially
Step 2. Relative evaluation each grid cell Result of evalutation each grid cell Imagine Spatially
Step 2. Relative evaluation each grid cell ‘Too many cars’ ‘Hard to notice’ ‘Want to avoid situation’ Imagine Spatially
Step 3. Recheck keywords and full sentence in hotspot of each 9 type “Hard to notice” Hotspot Recheck keywords in hotspot Imagine Spatially
Step 3. Recheck keywords and sentence in hotspot of each 9 type “Transport Infrastructure” Hotspot Recheck keywords in hotspot Cherry-pick top keyword in hotspot Imagine Spatially
+ evaluate main school walkway also use spatial join (GRID + walkway polyline shape file ) … Ga-in Primary School – main school walkway Imagine Spatially
Step 4. Summarized Safety Information map! (Safety-info map) (We designed map manually like tour map…) Type 1~5 Type 6~9 Worry injury Bad drivers Hard to notice Want avoid Tranp. Infra Many cars Mixed flow Harmful juvenile delinquent View, interrupted Illegal parking dark, unfrequent LED lingts, CCTV needed Under construction No traffic signal Taxi firm Imagine Spatially
Spot Inspection Imagine Spatially
Officers carried out spot inspection (1) CCTV Narrow road Streetlamp Reflector Imagine Spatially
Officers carried out spot inspection (2) After inspection, recheck safety-info map Result of inspection Imagine Spatially
Thank You for Listening GIS United Inc. http://gisutd.com Imagine Spatially
Recommend
More recommend
