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

Dobong-gu(Seoul) Safety-info Map

Imagine Spatially

Where is Dobong-gu?

http://www.openstreetmap.org/

Seoul Cityhall

Dobong-gu

K-hotel Seoul

Imagine Spatially

Citizen Participation + BigData Analysis

Imagine Spatially

Project Process Map-based Survey Dataset Consturction Data Analysis (Text-mining) Spot Inspection

Step 1 Step 2 Step 3 Step 4

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

Drive too fast Adult stuff Dark road, Need more lights Teenagers smoke Busy street(too many vehichles) Traffic signal violation Need CCTV

Imagine Spatially

Raw data example

Illegal parking “Dangerous spot” Streetlamp doesn’t work

Imagine Spatially

Raw data example

No answer… No traffic light Bus & bicycle Collision

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

3,247 Children School walkway = 1,766 km = 1,097 mile 2,932 Children danger consciousness area = 14.3 km2 = 3,533 ac

Imagine Spatially

Survey Data = BigData ?

http://map.meurisse.org/

Shanghai Seoul Osaka

1,766 km > 1,707 km

Imagine Spatially

Data Analysis (Text-mining)

Imagine Spatially

Text-mining analysis method Adding

Sorting & Extract

Subtract Change Visualizing

Subtract Extract & Transaction

Association Rule Visualizing

Related keywords (using R library – Assosication rule) Top Keyword (using R library – Word Cloud)

Imagine Spatially

Top Keyword Analysis (using R library – Word Cloud)

Rank Keyword Freq. ratio 1 Many cars 1,731 13.4% 58.9% 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% 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%

312 Keywords, 12,914 frequencies Top 15 Keywords form 59% (other 297 keywords form 41%)

Imagine Spatially

Differences between each primary school

Ga-in Nuwon Dobong Baekwoon Sungmi Shinbanghak shinhak shinchang 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)

“because taxi drivers who heavily smoke always gather together here” “sometimes full-size-car or trucks are reversing when children go to school”

Why they think ‘supermarket’ dangerous?

“Understanding the keywords in the context”

‘Taxi driver’ Smoking teenager Full-size-car supermarket Raw sentence Raw sentence

Imagine Spatially

Typology of the dangerous situation for children based on text analysis Too many cars

Apartment, supermarket, shopping arcade, driving school, church

Bad drivers

Illegal U-turn, drive too fast, lane violation

Want to avoid situation

Smoking, drinking, sex

• ffender, trenchcoat,

middle school student

Worry about injury

Under the construction, warehouse, wild pig, landslip, noise, exhaust

Harmful points

Night spot, bar, adult stuff, illegal flyer

View, interrupted

trees, reflector, banner, standing signboard, illegal parking

Mixed traffic flow

Narrow sidewalk, double park, underpass, side streets

Transport infrasturcture

Traffic light, complex traffic sign, flashing signal, left turn signal, crosswalk

Hard to notice

Narrow alley, need alarm, unfrequented, small park, dark

9 types of situations and keywords

Imagine Spatially

Compare responses using 9 types Too many cars

23%

Bad drivers

16%

Want to avoid situation

4%

Worry about injury

3%

Harmful points

1%

View, interrupted

11%

Mixed traffic flow

9%

Transport infrasturcture

15%

Hard to notice

16%

Imagine Spatially

Differences between each primary school (examples)

TA 23.0 16.0 11.4 4.4 1.3 9.0 3.5 16.0 15.3 Legend Too many cars Bad drivers View, Interrup ted Want to Avoid Harmful Points Mixed traffic flow Worry About injury Hard to notice Transp. infra

B sch.

18.0 18.4 5.2 8.0 10.4 2.4 4.4 23.2 10.0

A sch.

24.6 10.6 10.0 5.6 0.6 14.4 3.8 22.6 7.9

C sch.

12.6 30.4 9.3 4.5 0.4 8.1 2.4 18.8 13.6

Harmful points Hard to notice Mixed traffic flow Hard to notice Bad drivers

Imagine Spatially

GIS Analysis – Hotspot extract process

Step 1 Step 2 Step 3 Step 4

Insert 9 column (dangerous situation type) and write binary value Relative evaluation each grid cell Recheck keywords and sentence in hotspot of each 9 type Summarized Safety Information map! (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

Ga-in Primary School – main school walkway

also use spatial join (GRID + walkway polyline shape file) …

Imagine Spatially

Step 4. Summarized Safety Information map! (Safety-info map)

Type 1~5 Type 6~9

(We designed map manually like tour map…)

Worry injury Bad drivers Want avoid Many cars Harmful Hard to notice

• Tranp. Infra

Mixed flow View, interrupted Under construction Taxi firm juvenile delinquent dark, unfrequent LED lingts, CCTV needed Illegal parking No traffic signal

Imagine Spatially

Spot Inspection

Imagine Spatially

Officers carried out spot inspection (1)

CCTV Streetlamp Reflector Narrow road

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