1 / 36

Statistics Denmark Erik Sommer

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

gent
Download Presentation

Statistics Denmark Erik Sommer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. First Workshop on European Reference Grids (EuroGrid 2003): Ispra, Italy 27th-29th October 2003Aggregation and disaggregation of statistics Statistics Denmark Erik Sommer

  2. Presentation - Content • Building a national square grid • Disclosure of statistical data • Supply and demand • Selling statistical data • Partnerships • Integration with other countries • Future work

  3. GRIDdata - CLUSTERdata København, Danmark

  4. Danish National Grid – 5 grid sizes

  5. Aarhus Kongreshus, Amaliegade 23, 8000 C. 100m_62237_5749 1 km- og 100 m-grid

  6. Northing: 6.223.600 m Easting: 574.900 m 100m_62236_5749 Grid ID Formel: Prefix+’_’+Str(Div(N/f))+’_’+Str(Div(E/f))

  7. 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.

  8. Building adresse/street entrance

  9. The key to griddata – building address/street entrance

  10. Northing: 6.223.600 m Easting: 574.900 m 100m_62236_5749 Placement of addresses – calculated addresses Formel: Prefix+’_’+Str(Div(N/f))+’_’+Str(Div(E/f))

  11. Person – Home – Dwelling - Workplace

  12. Placement of addresses – corrected addresses

  13. Education Labourmarket CPR Person Person id: Person number Inter- view Taxes Questionaire Social Health etc Home Dwelling (night-time) Address Workplace or education (daytime) Parcel BBR Building CVR Busines STATISTICAL INFORMATIONSYSTEM

  14. Guidelines for discloure of data

  15. Distribution of Households 100 x 100 meter – 1. January 2003, Denmark

  16. Distribution of Households 1x1 km – 1. January 2003

  17. Building Block: Number of households

  18. Options when clustering gridcells • Proximity – districts, tradearea required to be a neighbour • Optimizing – finding gridcells with equal value without necessarily being a neighbour

  19. Optimizing: Finding gridcells with equal value without necessarily being a neighbour.

  20. Input clustering cells

  21. OUTPUT: Dataset for Clusters

  22. Selling statistical data • National level • Consumermarket • Public sector • Reserarch • Selling directly or through partners

  23. Segmentation New customers

  24. Ownership dwelling > 95%

  25. Householdincome 450.000+ > 65%

  26. Households with children > 60%

  27. Ownership > 95% • Householdincome 450.000+ > 65% • Households with children > 60%

  28. Calculated addresses www.kms.dk

  29. Calculated addresses www.kms.dk

  30. Access to addresses in Denmark Calculated address coordinates www.kms.dk Improved access to public dataFrom 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,Y-address coordinates www.ebst.dk/ejendom or www.ois.dk

  31. Conzoom online – www.conzoom.net

  32. Nordic maps and griddata(Conzoom online)

  33. Nordic griddata online (Conzoom)

  34. Householdstype – singles with no children

  35. Future work • Access to addresses • Access to statistical data • Disclosure policy • Dissemination • Integration (grid, data, pricing and promotion)

  36. Access Statistical data Thank you for your attention For further information please contact: Erik Sommer: www.dst.dk/kvadratnet eso@dst.dk phone +45 3917 3582

More Related