Supergeo GIS Applications Feature – Statistical GIS

GIS Center at Academia Sinica is in charge of planning and advancing GIS related basic researches and integration of resources, building cross-domain integration based on time and spatiality, and creating application environment for analysis and map metaphor. Moreover, this GIS center also has diverse groups of researchers who are responsible for further research aiming to topics like Health Care and Environment Change, Taiwan Socio-economic conditions data GIS, and Historical Population, etc.

USer Interface of Statistical GIS
Taiwan Population statistical data contains all the census statistics from Japanese colonial period to R.O.C. period. However, historical statistical data are in the forms of text description and tables mostly so that it is difficult to let those who are interested in Taiwan Population to comprehend data with its spatial distribution and even the meaning of data displayed in geographic districts. Therefore, statistical data integrating with GIS will be able to make population statistical data meaningful by computing data with spatial calculation and displaying the results on the map, and to find the clues hidden in spatial distribution.
 
Goals

To integrate data and functions in Taiwan Socio-economic indicator database and display statistical data on the map, GIS Center at Academia Sinica needs a system which is capable of integrating statistical data, map display function and management function to quickly integrate and display statistical data on the map.

The system is supposed to contain the following functions
1. Spatial data integration:
  To integrate “Statistical data of historical population in Taiwan” in former Taiwan Socio-economic indicator GIS database with “Taiwan Socio-economic indicator data” to build Statistical GIS.
2. System for displaying spatial data and management:
  Statistical GIS has to combine the integrated data in database with GIS technologies and display the results on the map website. Besides, it has to provide management interface designed for administrating data and user authority.
3. Portal Website:
  The portal website of the system should display diverse data or research results in order for users to query the required data easily, and provide URL of map websites in Statistical GIS to open and utilize website functions quickly.
 
Solutions

Statistical GIS needs to integrate statistical data in database and supports to display these data on map website. Therefore, Statistical GIS adopts Microsoft Windows Server 2008 R2 as server platform and SuperGIS Server as GIS server of the system. SuperGIS Server is capable of publishing commonly-used Taiwan map as map service, integrating statistical data and displaying the result on map website with layering rendering. In addition to the function of map display and basic navigation, the map website provides functions like statistics querying, positioning and so forth to enable users to browse data they required.

The System integrates statistical tables and forms.
For integration of statistical data, the database software employs MS SQL 2008 Server R2. MS Excel is adopted for users to build statistical data table and fill metadata into the database. Therefore, people who want to build data just need to fill in data according to the rules instead of adapting to a new system. Besides, to preserve all the data in database, not only former statistics table, but also integrated statistics tables and metadata of statistics tables are recorded in one Excel.

Results
Statistical GIS, a GIS platform integrating database and map websites, aims to integrate “Statistical data of historical population in Taiwan” in former Taiwan Socio-economic indicator GIS database with “Taiwan Socio-economic indicator data”, and provides management interface to assist administrators in administrating layer data, statistical data, and user authority, etc.
Key functions of the system include portal website, integration of former database and new data, and map website of Statistical GIS.
 
1. Portal Website
Employing “Content Management System”, the portal website is capable of assisting system administrators in effectively managing layer content, statistical data, user authority and so forth. Additionally, connecting with JavaScript API, the map website is able to display map services of Statistical GIS.
 
2. Integration of the former database and new data
To integrate new data with the former data, Statistical GIS stores the Taiwan maps and statistical data separately and adopts MS Excel for users to create statistical data table and fill metadata in. Thus, people who build data are able to add new data rapidly. Besides, statistical data can be input to the created table by data uploading so that users can upload diverse statistical data to web system quickly and conveniently.
 
3. Map Website of Statistical GIS
The map website is mainly composed of “Map Display”, “Platform Navigation Toolbar” and “Main Menu.” “Main Menu” including functions of statistics query, layer overlay, positioning, map tools, enable users to display the required statistical data on map speedily.
(a) Statistics Query:
After setting query conditions, the tables matching the input query conditions will be listed automatically on the section of “Query List.” Including choropleth map, bar chart, pie chart, broken line graph, scatter plot and so forth, diverse types of statistical charts for statistical variables are drawn on the display. Besides, with interactive functions, the statistical map can show different colors while the mouse is moved overt the map.
 
(b) Layer Overlay:
After clicking this function, users are allowed to select district layer of the specified year by checking on menu in the window. Users can set the label visibility of each layer and the layer transparency.
 
(c) Positioning:
Positioning contains the methods of “Administrative Division Positioning” and “Coordinate Positioning.” With “Administrative Division Positioning”, users can select administrative division on the drop-down menu to position to the center of the city, town or county. “Coordinates Positioning” supports users to enter WGS84 geographic coordinates to locate the coordinate point.
 
(d) Map tools:
To use draw toolbar, please click on the tool icon. After that, users can use these tools to add symbols like point, polyline, polygon or text on map. Those symbols can be output together with the printing of map.

Users are allowed to select data from different tables

 
diverse types of statistical charts
 
Coordinate positioning
 
Attribute querying
System Benefit:  
Statistical GIS is used as a powerful gateway of querying Taiwan population researches in domains of academic researches and mass education. With the time passing and requirements increasing, the GIS also adds interactive functions facilitate and enhance system operation. Integrating statistical data of every period, Statistical GIS combines data with map through GIS technologies as well to enable users to deeply comprehend the relation between statistics data and spatial distribution

 

image_pdfimage_print
Share SHARE
Editor (18230 Posts)

Glenn is a geographer and a GIS professional with over 20 years experience in the industry. He's the co-founder of GISuser and several other technology web publications.


Editor’s Picks

opengov group

2014 Open Data for Development Research Grants – Call for Proposals

The Open Government Partnership Open Data Working Group is interested in receiving research proposals for work exploring the technical and practical implications of Open Data. These grants are administered by the Web Foundation and supported by the International Development Research Centre (IDRC), and will initially support research projects to take place between November 2014 and […]

autocad for mac

AutoCAD for Mac 2015 and AutoCAD LT for Mac 2015 Now Available

New Functionality Helps Mac and Windows Users Work Together More Efficiently SAN FRANCISCO–(BUSINESS WIRE)–Autodesk, Inc. (NASDAQ: ADSK) today announced the 2015 releases of AutoCAD for Mac and AutoCAD LT for Mac software, two of the leading computer-aided design (CAD) tools for Mac users. The new software makes it easier than ever for businesses and students to […]

ESRIUC Notes – Top 10 new features in ArcGIS 10.2

I’m a big fan of Top 10 lists, and I’m also a fan of the annual ESRIUC, so when there happens to be a Top 10 list featured on stage at the event I tend to take note! This year the list focused on the top new features in ArcGIS at R 10.2. ArcGIS product […]

More Posts from this Category

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>