1 / 13

Integration of spatial database and statistical data

Explore the integration of spatial databases and statistical data for optimized production and modernization of census statistics. Learn about GIS modeling, benefits, and the role of a central spatial database in GIS strategy. Discover the benefits of using spatial databases and the merging of digital map data with statistical entities.

pamelawalker
Download Presentation

Integration of spatial database and statistical data

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. Integration of spatial database and statistical data Spatial Database Nordic Forum for Geo-statistics Kongsvinger, Norway 12-14.9.2006 Maija Leppänen Statistics Finland

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

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

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

  5. 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 ArcSDE-product

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

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

  8. An example of ESRI geodatabase schema

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

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

  11. Producing grid data

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

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

More Related