Abstract
GIS Layer Maintenance in a Complex Environment Track: Database Design, Automation, and Management Author(s): Angela Kneece, Jared Shoultz, Mehdi Khan To conserve time and effort maintaining the dynamic ArcSDE feature class of statewide licensed health facilities, the South Carolina Dept. of Health and Environmental Control has formulated a system of weekly automated nonspatial attribute updates in conjunction with mobile GIS/GPS data collection. A weekly scheduled data transformation service from an Oracle licensing database to a SQL Server SDE database ensures a complete and spatially accurate facilities layer. Complex comparisons are made from the source to the destination table, which drive automated geocoding and archiving. Standard mobile GIS procedures are then used to version and check out portions of the file for GPS data collection, which is followed up with geoprocessing to determine zone information related to flooding, hurricanes, and evacuation planning. Together, this process enables the leveraging of geographically accurate and precise data current to the week for internal desktop use and with Internet-based mapping and routing services in near real time. Angela Kneece South Carolina DHEC Division of Biostatistics and Health GIS 2600 Bull St. Room 1660 Columbia , SC 29201 US Phone: 803-898-3736 E-mail: kneeceam@dhec.sc.gov Jared Shoultz SC DHEC Division of Biostatistics and Health GIS 2600 Bull St., Room 1660 Columbia , SC 29201 US Phone: 803-898-3668 E-mail: shoultjj@dhec.sc.gov Mehdi Khan SC DHEC Division of Biostatistics and Health GIS 2600 Bull St., Room 1660 Columbia , SC 29201 US Phone: 803-898-3664 E-mail: khanmm@dhec.sc.gov |
|||||
