Transcript Nordic Forum for Geo-statistics

Nordic Forum for Geo-statistics
Kongsvinger, Norway, September 12-14 2006
Market report on grid
data in Denmark
Erik Sommer & Karen Skjelbo
Statistics Denmark
Agenda – Market report on grid data in Denmark
• Research Services
• Social Statistics (Consumer statistic)
• Business Statistics
2
Market report grid data Denmark
Research Services – general approach
•
•
•
•
Authorized research institute
Approved reasearch project
Handled by research services
Annonymized data
3
Market report grid data Denmark
”Human densities” on 2x2 km grid – Denmark – around
the National motorways Aalborg Universitet, Thomas Nielsen – september 2004
4
Market report grid data Denmark
Griddata – Motorway around Randers – Day & Night
population data
Aalborg Universitet, Thomas Nielsen – september 2004
5
Market report grid data Denmark
Police – Crimedata www.statistik.politi.dk
6
Market report grid data Denmark
Business to Consumer (BtC)
• Griddata distribution dataset with
households and persons.
• Clusters with demographic background
variables social statistics
• Distribution channels – direct or indirect
throught resellers
7
Market report grid data Denmark
Grid ID 100 meter cell – lower left corner ID
Northing: 6.175.308 m
Easting:
723.724 m
100m_61753_7237
Formel:
Prefix+’_’+Str(Div(N/f))+’_’+Str(Div(E/f))
8
Market report grid data Denmark
Distribution of households and person - Denmark
cellId
Persons Households Cells
1.1.2006
Distribution 100x100 meter 5410472 2513627 416813 Denmark
Total Denmark
5427459 2516682
Not placed
16987
3055
% cells not placed
% cells placed
0,31%
99,69%
0,12%
99,88%
1-19 households
% share of total
3547570
65,57%
1441089
57,33%
9
Market report grid data Denmark
394896
94,74%
GRIDdata – CLUSTERdata – Denmark –
household average bruttoincome
10
Market report grid data Denmark
København, Danmark
www.conzoom.net – online presentation –
Reseller Geomatic
11
Market report grid data Denmark
Geobroadcast – Informi GIS –
online presentation joint partnership www.geobroadcast.dk/website/dst/viewer.htm
12
Market report grid data Denmark
Business Statistics Projects
• Grid based
Business
Statistics
13
Market report grid data Denmark
• Check of physical
moving of LKAU,
Local Kind of
Activity Units
Grid based Business Statistics
• user interest in grid based business
statistics
• introductory examinations
• Geocoding the LKAU
• Basic data set
• Discretion rules
14
Market report grid data Denmark
Geocoding of LKAU
• Matching LKAU addresses with
address database
– Result: 98 % match
– 17 % of no match are fictitious
LKAU
– Need to improve the quality of the
addresses
15
Market report grid data Denmark
Basic data set
Grid ID
Number
of Lkau
9. stdEmployees grp. 1
9. stdgrp. 2
100m_61765_7251
3
27
2
100m_61766_7252
1
8
1
Grid ID
Business Id nr.
100m_61765_7251
10-10-10-10
100m_61765_7251
10-10-10-11
100m_61765_7251
10-10-10-12
100m_61766_7252
10-10-10-13
16
Market report grid data Denmark
9. stdgrp. 3
…
1
Business
Statistics
data
LKAU: Examples of moving
• Bakery is moving
around the corner
• Bakery is moving
to another
municipality
• New unit or the
same unit?
• New unit or the
same unit?
17
Market report grid data Denmark
LKAU psychical move
• Creating a new LKAU depends on
• Activity code
• Distance
–Using the bee line improve the
quality of the distance and make
the distance rules more detailed
Need to improve the quality of the
addresses
18
Market report grid data Denmark
Market report on grid data in Denmark
End….
19
Market report grid data Denmark