GIS to show when, where and how death occured
2000 (English)Independent thesis Basic level (professional degree), 10 credits / 15 HE credits
Student thesis
Abstract [en]
SMC has the database TOPSWING (Total Population of Sweden Individual and Geographical database). TOPSWING contains socio-econmical information on Swedens population during the years 1985-1995. The kind of information that exists is for example a persons habitation, income, education level, migration, civil status, sex, age and so on. If a person dies, there will be information about cause of death, when the person died etc. With these kinds of data from TOPSWING it is possible to study geographical connections over regions, years and/or death causes. This undergraduate project consisted of three steps. The first step was to make new tables in the database to enhance the search process, to make it less time consuming. With the old tables, it could sometimes take several hours to get a result, but with the new tables a result could be reached in a few minutes. The second step was to create a GUI (graphical user interface) that was user-friendly. Instead of writing long SQL-commands it is now possible to get a result just by making a few choices with the mouse. By selecting one or two region(s), a year and a cause of death, the result is displayed as a barchart next to a map over Sweden. The selected region(s) is highlighted. It is also possible to zoom in and out the map, zoom to full extent, zoom to selected region, pan the map and a some other functions. The third step was to connect the new tables in the database with the application. By expanding ArcView with its scripting language Avenue, a connection could be made between the new tables in the database and the application. The result is an application that researches can use to detect geographical connections concerning death in Sweden.
Place, publisher, year, edition, pages
2000.
Keywords [en]
Technology, database, databas, TOPSWING, death cause, dödsorsaker, SMC, applications, applikationer, ArcView, Avenue, SQL, rate, bar, chart, tabelldiagram, script, regions, områden, GIS
Keywords [sv]
Teknik
Identifiers
URN: urn:nbn:se:ltu:diva-44835ISRN: LTU-HIP-EX--00/78--SELocal ID: 2953a845-7015-4ade-a908-33af39d0cefbOAI: oai:DiVA.org:ltu-44835DiVA, id: diva2:1018114
Subject / course
Student thesis, at least 15 credits
Educational program
Geographical IT, bachelor's level
Examiners
Note
Validerat; 20101217 (root)
2016-10-042016-10-04Bibliographically approved