[foss4g 2015] gis policy map for local government in korea story of dobong-gu, seoul

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 & bicycleCollision

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

AssociationRule

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 shinhakshinchang 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 offender, 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)

TA23.0 16.0 11.4

4.4 1.3 9.0

3.5 16.0 15.3

Legend Too manycars

Baddrivers

View,Interrup

ted

Want toAvoid

HarmfulPoints

Mixed traffic flow

WorryAboutinjury

Hard tonotice

Transp.infra

Bsch.

18.0 18.4 5.2

8.0 10.4 2.4

4.4 23.2 10.0

Asch.

24.6 10.6 10.0

5.6 0.6 14.4

3.8 22.6 7.9

Csch.

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, unfrequentLED 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