GIS Portfolio

Subtitle

 GIS Data Modelling

 

A GIS Transportation Infrastructure and Emergency Management Network Data Model for Stark County, Ohio

  • Stark County is situated in Northeast region part of state of Ohio and it is one of two counties which is part of Canton-Massillon Metropolitan Statistical Area (MSA) as defined by United States Census Bureau.
  • The main purpose of this geodatabase is to create a storing and editing document platform for the Stark County for various departments such as regional planning,transportation and traffic, and engineering.
 
 
Purpose
  •  The main use of this geodatabase is to create a storing and editing document platform for the Stark County various departments such as regional planning, transportation and traffic, and engineering etc. Various departments can use the information for their individual needs and also various projects can be implemented working on this platform with two or more department functioning at the same time.
  • This platform will not only provide editing and validation options but also has relationship classes and topological behaviors amongst the data. So, this will enforce referential integrity, facilitate editing and will also support cardinality correspondence. Basically the data in the geodatabase will be systematically and practically layered together and will provide a platform to perform various tasks efficiently.  
 
Scope
  • This geodatabase project focuses on Stark County which is located in the state of Ohio. In order to build this geodatabase, first step is acquiring data pertaining to county’s demographic, transportation infrastructure, and land use information. County’s population growth in last decade was approximately 3 % and some visible economic development. Analyzing transportation infrastructure dataset and land use information for the county will solve problem such as traffic congestion, pollution, etc. With good prospective growth predicted in future, the county will use this geodatabase for setting up future goals in land use and transportation using comprehensive planning as platform.  
 
 

A) Conceptual Data Model:

  • The basic objective of this geodatabase is to establish transportation infrastructure and emergency management network platform for various departments in Stark County to work independently and as well as mutually on variety of projects. To achieve this objective variety of datasets such as Census Boundaries, transportation infrastructure, and emergency services such as fire stations, hospitals and law enforcement agencies are used. Also, relationship among various data like census blocks to block demographics, census tracts to tract demographics is created in order to analyze demographic information for any particular census block or tract.


B) Logical Data Model:

  • Logical data model is fundamentally a refinement of conceptual model. This phase includes identifying subtypes, domains, and relationship, defining tables, attributes and feature classes, group feature classesFor practical implication all the datasets are divided systematically in the geodatabase. There are 4 feature datasets, 24 feature classes, 4 raster dataset, and 4 standalone tables (Shown below).


  • One powerful feature of this geodatabase is an artificial behavior which comprises of 3 subtypes, 3 domains, 2 relationship classes, and 2 topology rules.


C) Physical Data Model:

  • In this phase the spatial reference, tolerance, and resolution is defined to improve the quality of the dataset.
  • A file based geodatabase is selected to construct because of its overall storage capacity and also its raster dataset compatibility. A screenshot of the geodatabase from the ArcCatalog is displayed below.


D) Summary of Geodatabase Build Process:
  • Arc Toolbox is used to build a geodatabase and import all the required feature classes, rater dataset, and tables. A snapshot of "modelbuilder" model is shown below.





E) Deployment:
  • Deciding a location of a command centre for emergency services can be a complicated task. This analysis is possible using Spatial Statistics tool in ArcGIS. The final output is shown below in map.