Dobong-gu(Seoul) Safety-info Map Where is Dobong-gu? Dobong-gu - PowerPoint PPT Presentation

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