Transcript Document 7121987

First Workshop on European Reference
Grids (EuroGrid 2003):
Ispra, Italy 27th-29th October 2003
Aggregation and disaggregation of
statistics
Statistics Denmark
Erik Sommer
Presentation - Content
•
•
•
•
•
•
•
Building a national square grid
Disclosure of statistical data
Supply and demand
Selling statistical data
Partnerships
Integration with other countries
Future work
2
Ispra, Italy October 27-29, 2003.
GRIDdata - CLUSTERdata
3
Ispra, Italy October 27-29, 2003.
København, Danmark
Danish National Grid – 5 grid sizes
Size
4
Name/Net
Grid ID
100 km
Overview
KN100kmDK
| Grey
10 km
Place name
KN10kmDK
| Green
1 km
Basic
KN1kmDK
| Red
250 m
250 meter
KN250mDK
| Orange
100 m
Hectare
KN100mDK
| Blue
Ispra, Italy October 27-29, 2003.
Colour
1 km- og 100 m-grid
Aarhus Kongreshus,
Amaliegade 23, 8000 C.
100m_62237_5749
5
Ispra, Italy October 27-29, 2003.
Grid ID
Northing: 6.223.600 m
Easting:
574.900 m
100m_62236_5749
Formel:
Prefix+’_’+Str(Div(N/f))+’_’+Str(Div(E/f))
6
Ispra, Italy October 27-29, 2003.
Specification – National Square Grid
• UTM projection, zone 32
• Datum used is EUREF 89
• All cell names must refer to the original
UTM32\EUREF89 projection to ensure
standardized names.
7
Ispra, Italy October 27-29, 2003.
Building adresse/street entrance
8
Ispra, Italy October 27-29, 2003.
The key to griddata – building address/street entrance
Address ID
1810012001_
1810012001A
1810012003_
1810012010_
1810012011_
1810012015_
1810032003_
9
Municipality- Street- Housecode
code
number Zipcode
181
0012 001_
181
0012 001A
181
0012 003_
Kn100Dk
2840 100m_61907_7175
2840 100m_61907_7175
2840 100m_61907_7175
181
0012 010_
2840
181
0012 011_
100m_61907_7176
2840 100m_61908_7175
181
0012 015_
2840
181
0032 003_
Ispra, Italy October 27-29, 2003.
100m_61908_7175
2840 100m_61909_7175
Kn1kmDk
1km_6190_717
1km_6190_717
1km_6190_717
1km_6190_717
1km_6190_717
1km_6190_717
1km_6190_717
Placement of addresses – calculated addresses
Northing: 6.223.600 m
Easting:
574.900 m
100m_62236_5749
Formel:
Prefix+’_’+Str(Div(N/f))+’_’+Str(Div(E/f))
10
Ispra, Italy October 27-29, 2003.
Person – Home – Dwelling - Workplace
11
Ispra, Italy October 27-29, 2003.
Placement of addresses – corrected addresses
12
Ispra, Italy October 27-29, 2003.
STATISTICAL INFORMATIONSYSTEM
CPR
Person
Taxes
Person
Education Labourmarket
id:
Person number
Interview
Questionaire
Social
Health
Home
Dwelling
(night-time)
Address
Parcel
13
Ispra, Italy October 27-29, 2003.
Workplace
or education
(daytime)
BBR
Building
CVR
Busines
etc
Guidelines for discloure of data
Number of
households
(clusters)
Data from
Statistics
Denmark
1-19 households
20-49 households
50-99 households
100-149 households
150+ households
No data
Key Figures
Few intervals
More intervals
Statistical
datasystem
14
Ispra, Italy October 27-29, 2003.
Distribution of Households 100 x 100 meter
– 1. January 2003, Denmark
Group
0
1
2
3
4
5
6
Householdsintervals
0
1-19
20-49
50-99
100-149
150-399
400+
Total cells households
Not placed in grid cells
Grid cells
Denmark 1.1.2003
100x100 meter
KMS BAK version1.5
15
Ispra, Italy October 27-29, 2003.
No. Cells % celler No. Households % Households
107581
0
385544 95,64%
1328931
54,55%
10625
2,64%
319342
13,11%
4126
1,02%
289163
11,87%
1451
0,36%
175537
7,21%
1287
0,32%
273017
11,21%
89
0,02%
50051
2,05%
403122 100,00%
2436041
100,00%
510703
30652
2436041
2466693
1,24%
98,76%
100,00%
Distribution of Households 1x1 km
– 1. January 2003
Group
0
1
2
3
4
5
6
Householdsinterval No. Cells % cells
No. Households % Households
0
2753
0
1-19
32576
78,24%
189537
7,73%
20-49
3664
8,80%
111817
4,56%
50-99
1691
4,06%
120421
4,91%
100-149
810
1,95%
98931
4,03%
150-399
1490
3,58%
370208
15,10%
400+
1407
3,38%
1561396
63,67%
Total cells households 41638 100,00%
2452310
100,00%
Not placed in grid cells
Grid cells
Denmark 1.1.2003
1x1 km
KMS BAK version1.5
16
Ispra, Italy October 27-29, 2003.
44391
14383
2452310
2466693
0,58%
99,42%
100,00%
Building Block: Number of households
GRID id
Municipality
61901_7126
61902_7126
61903_7126
61904_7126
61905_7126
61909_7126
61910_7126
61911_7126
61912_7126
61915_7126
61916_7126
61917_7126
61901_7127
61902_7127
17
Ispra, Italy October 27-29, 2003.
Households Population
207
207
207
207
207
207
207
207
207
207
207
207
207
207
1
3
1
3
3
5
3
2
2
5
2
19
9
7
6
8
6
7
8
10
6
5
7
13
8
38
30
19
Options when clustering gridcells
• Proximity – districts, tradearea
required to be a neighbour
• Optimizing – finding gridcells with
equal value without necessarily
being a neighbour
18
Ispra, Italy October 27-29, 2003.
 Optimizing:
Finding gridcells with equal value without
necessarily being a neighbour.
19
Ispra, Italy October 27-29, 2003.
Input clustering cells
CelleID
7201_61721
7201_61722
7201_61723
7201_61724
7201_61725
7201_61726
7201_61728
7201_61729
7201_61730
7201_61731
7201_61732
20
Antal_
Antal_
husstande personer cl20id cl50id
142
262 384157 384157
9
31 379388 394127
7
24 381037 394127
73
138 384160 384160
32
59 384161 384161
41
41 384162 384162
3
7 379180 394127
14
41 384164 394127
12
25 382726 394127
12
40 380092 394127
13
34 383481 394127
Ispra, Italy October 27-29, 2003.
cl100id
384157
379158
379629
384160
383468
384162
377836
379632
378492
378265
382453
cl150id
384157
378945
378693
384160
382973
383716
377836
378697
378492
378265
378922
OUTPUT: Dataset for Clusters
Kom. Clusterid I alt 0-149999 kr150-249999 kr 250-349999 kr 350-499999 kr 500-699999 kr over 700000 kr
101
0 436
111
77
85
77
53
33
101
1 193
15
18
21
39
61
39
101
2 183
54
59
27
25
13
5
101
3 244
12
31
24
45
83
49
101
4 115
7
11
13
26
34
24
101
5 166
23
64
40
21
15
3
101
6 107
40
31
20
11
4
1
101
7 226
59
55
43
39
23
7
101
8 137
12
25
24
24
28
24
101
9 171
29
30
33
32
30
17
101
10 408
198
94
51
40
21
4
101
11 202
11
19
24
34
70
44
101
12 196
28
29
32
42
40
25
101
13 161
15
31
16
30
48
21
101
14 192
32
33
24
33
54
16
101
15 174
11
17
20
46
42
38
101
16 189
35
26
35
39
40
14
101
17 118
47
25
24
9
9
4
21
Ispra, Italy October 27-29, 2003.
Selling statistical data
•
•
•
•
•
22
National level
Consumermarket
Public sector
Reserarch
Selling directly or through partners
Ispra, Italy October 27-29, 2003.
 Segmentation New customers
23
Ispra, Italy October 27-29, 2003.
 Ownership
dwelling > 95%
24
Ispra, Italy October 27-29, 2003.
 Householdincome 450.000+ > 65%
25
Ispra, Italy October 27-29, 2003.
 Households with children > 60%
26
Ispra, Italy October 27-29, 2003.
 Ownership > 95%
 Householdincome 450.000+ > 65%
 Households with children > 60%
27
Ispra, Italy October 27-29, 2003.
Calculated addresses www.kms.dk
28
Ispra, Italy October 27-29, 2003.
Calculated addresses www.kms.dk
29
Ispra, Italy October 27-29, 2003.
Access to addresses in Denmark
Calculated address coordinates
www.kms.dk
Improved access to public data
From 1. January 2003 a number of public
data can be used freely. State, counties and
municiapalities have made an agreement
giving access to different registers including
Building Register Data (BBR) and X,Yaddress coordinates
www.ebst.dk/ejendom or www.ois.dk
30
Ispra, Italy October 27-29, 2003.
Conzoom online – www.conzoom.net
31
Ispra, Italy October 27-29, 2003.
Nordic maps and griddata (Conzoom online)
32
Ispra, Italy October 27-29, 2003.
Nordic griddata online (Conzoom)
33
Ispra, Italy October 27-29, 2003.
Householdstype – singles with no children
34
Ispra, Italy October 27-29, 2003.
Future work
•
•
•
•
•
35
Access to addresses
Access to statistical data
Disclosure policy
Dissemination
Integration (grid, data, pricing and
promotion)
Ispra, Italy October 27-29, 2003.
Access Statistical data
Thank you for your attention
For further information please contact:
Erik Sommer:
www.dst.dk/kvadratnet
[email protected]
phone +45 3917 3582
36
Ispra, Italy October 27-29, 2003.