1 / 12

DATA from the MAP

DATA from the MAP. Presentation at the Nordic Forum for Geostatistics 2007 Helsinki, Finland. Thursday 20 September Johnny Sehli n , Statistics Sweden. Statistics Sweden. D A T A from the M A P. The problem GIS infrastructure, software and maps,

walcott
Télécharger la présentation

DATA from the MAP

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. DATA from the MAP Presentation at the Nordic Forum for Geostatistics 2007 Helsinki, Finland. Thursday 20 September Johnny Sehlin, Statistics Sweden Statistics Sweden

  2. D A T A from the MAP The problem GIS infrastructure, software and maps, is too expensive to most customers interested in small area statistics The solution Find and use cheap software's and maps. At Statistics Sweden we found MapPoint Statistics Sweden

  3. D A T A from the MAP This is MapPoint - Maps down to street level - MS Office compatibility - Programmable in Visual basic - Price 300 Euro Statistics Sweden

  4. D A T A from the MAP MapPoint uses Workspaces (.PTM-files) to open user defined views. In this slide show 1. Apoteket20070531.ptm Statistics Sweden

  5. D A T A from the MAP The .PTM-file opens the map zoomed in at Stockholm and opens a grid map with population centroids for 250x250 m (urban) and 1x1 km (rural) grids Statistics Sweden

  6. D A T A from the MAP By using the Find option in MapPoint it is easy to find the geographical area of interest. The city of Luleå up north in Sweden for instance Statistics Sweden

  7. D A T A from the MAP In this case we are interested in the centre of Luleå and zoom in to see the street level. Statistics Sweden

  8. D A T A from the MAP By using the drawing tools we delimit the area e.g. using the street information Statistics Sweden

  9. D A T A from the MAP By starting the application Statistikanalys from the Tools menu MapPoint performs a point in polygon selection Statistics Sweden

  10. D A T A from the MAP This form is shown giving some information about the selected area. By pressing the ”Skapa rapport” Button a report is genarated. Statistics Sweden

  11. D A T A from the MAP A report like this one will be generated. The report might consist of the map, tables an diagrams and can be altered by the user Statistics Sweden

  12. In short: MapPoint application D A T A from the MAP Draw an area on the map, choose ”Statistikanalys” in the Tools menu and select the ”Skapa rapport”Add-in Selected grids are transfered to SQL Server via a VB macro in Excel SQL Server (Database) Excel report The Database consists of statistics in tables and stored procedures run from Visual Basic macros in the Excelreport. The result is transfered to the report and is presented as a map, in tables and in diagrams. Statistics Sweden

More Related