Spatial Database Integration of spatial database and statistical

Spatial Database Integration of spatial database and statistical data Nordic Forum for Geo-statistics Kongsvinger, Norway 12 -14. 9. 2006 Maija Leppänen Statistics Finland

Contents About Production Model and a new data base structure n GIS in the new environment n Modelling GIS and statistical attribute data n Examples n Benefits and summary n 17. 9. 2020 2

Production model of ‘Census’ statistics Downsizing of processes in IBM mainframe n modernising production of statistics n integrating digital map data, locations of statistical entities and attribute data together in the same environment n statistics are produced in the old and new environment and results are compared n 17. 9. 2020 3

Data Base Architecture of ‘Census’ data Register Data Others GIS Data Base Meta Data Electronically collected data Production Data base User Interface, SAS SQL Data Ware House Superstar User Interface, SAS, SQL 17. 9. 2020 4

Spatial database is a data base containing digital map data and location data, Also called: geodatabase or GIS database Spatial database is a logical concept, physically data is in more than one SQL Server-database. Geometry is administrated by Arc. SDE-product 17. 9. 2020 5

Spatial data production and use Micro- and macro-data Map data, locations of statistical data as spatial data types 17. 9. 2020 6

Spatial Modelling of database n n GMF : General Feature Model (Application Schema ISO 19109) GML : Geographic Markup Language (ISO 19136, OGC) l GMF: n XML-implementation Finnish recommendations, work ongoing ESRI’s Geodatabase 17. 9. 2020 7

An example of ESRI geodatabase schema 17. 9. 2020 8

Current Contents of the Geodatabase n In production: Maintenance of buildings (as points) l Use of Municipal boundaries in different scales l Updating Sub-areas of municipalities l Using Grid nets of 1*1 km and 250*250 km together with aggregated grid data l n Testing Postal code areas l Localities l. . . l 17. 9. 2020 9

Common use of statistical entities and map data Building_id Co-ordinates Sub-area code Locality code Municipality code Geometry: Point Digital map data Point in polygonmethod 17. 9. 2020 10

Producing grid data 17. 9. 2020 11

Benefits of using spatial database Commonly used database l Statistical attribute data in the same environment l Maintenance in one place l Processed will be simplified l Quality will be better l More possibilities l Administration of large data is better l 17. 9. 2020 12

Summary Central spatial database is a part of spatial infrastructure and is one of the most important clue in GIS-strategy of Statistic Finland => Harmonised data sets to common use 17. 9. 2020 13