cobb county gis: beyond the map - amazon s3 · cobb county gis: beyond the map charles fail tim...
TRANSCRIPT
SERUG 2008 1
Cobb County GIS:Cobb County GIS:Beyond the MapBeyond the Map
Charles FailTim Scharff
Cobb County GIS
SERUG 2008 2
TopicsTopics
Cobb GIS OverviewThe Early YearsEnterprise GIS TransitionPutting It TogetherLooking Ahead
SERUG 2008 3
Cobb GIS OverviewCobb GIS Overview
Mission– create, operate, and maintain an efficient, cost-
effective geographic information system through the use of specialized computer, mapping and digital aerial photography technologies in support of the Board of Commissioners, elected officials, and county departments.
SERUG 2008 4
Cobb GIS OverviewCobb GIS Overview
Enterprise GIS Plan– Serves as the guiding document for the
countywide GIS implementation– Consists of 6 major program elements:
• Databases, Hardware, Software, Applications, Personnel, and Program Mgmt
– Initial 5-Year GIS Implementation Plan approved by the BOCC in 1999
SERUG 2008 5
Cobb GIS OverviewCobb GIS OverviewProvides Provides overall overall
direction for direction for GIS ProgramGIS Program
Develops dept Develops dept GIS plan, GIS plan, ensures ensures database database
standards, standards, coordinates coordinates
trainingtraining
Overall Overall management of management of the Enterprise the Enterprise
GISGIS
Provides Provides technical technical guidance, guidance, formulates formulates
recommended recommended solutionssolutions
Shares knowledge, Shares knowledge, multimulti--departmental departmental
networkingnetworking
SERUG 2008 6
The Early YearsThe Early Years
Database Development– Base Map (2000, 2003)– Tax Assessor Parcels (2003)– Coverages, Shapefiles, and pGDB’s
Application Development– ImagePicker Extension (ArcView 3.x)– Web Mapping Site (hosted externally)
SERUG 2008 7
The Early YearsThe Early Years
Hardware / Software– ArcGIS Desktop 8.x– ArcView 3.x– File Server
Users– Year 4 projection: 100 users– Actual number: 200 users
SERUG 2008 8
Enterprise GIS TransitionEnterprise GIS Transition
TriggersMulti-User Editing NeedsMulti-Department Approach To:– Data Models, Data Maintenance Workflows
Replacement of business applicationsUpdated Vision:– Make GIS a transparent technology that is
used routinely to create, manage, and analyze data
SERUG 2008 9
Enterprise GIS TransitionEnterprise GIS Transition
ResultsEnterprise GDB Development & Migration– CobbETRANS (2004)– Parcel Geodatabase (2005)
Accessibility & Ease of Use– Cobb GIS Data Access Tool– Web Mapping Sites
Infrastructure Changes– Separate Edit & Production Environments– ArcIMS & ArcSDE Implementation
Production Server
ArcSDE 9.1
Edit Server
ArcSDE 9.1
Web Server
(reverse proxy)
RouteMap
Application Server
ArcIMS 9.1GeoCortex 5.1
ArcGIS Server 9.1
Nightly Synch
ArcGIS Desktop 9.1 Users (AI, AE)
Edit Production
ArcGIS Desktop 9.1 Users (AV)
Various Appsaccess
database views
Internal Web Mapping Users
Public
Web Mapping
Sites
External Web
Server
(DMZ)
Cobb County
System at v9.1
Firewall
SERUG 2008 11
Putting It TogetherPutting It Together
We had a lot of the ingredients, now what?– Automate eGDB synchronization– Facilitate use– Look for integration opportunities– “Make the cake”
SERUG 2008 12
GIS Edit ServersGIS Edit Servers
For data editing onlyNot visible to general GIS usersEdit environment consists of:– One centralized server– Two department workgroup servers
SERUG 2008 13
GIS Edit ServersGIS Edit Servers
GISGeneral Data
5151dev_gis
Land MgmtParcels
5152dev_landmgmt
Land UseFuture Land Use
Zoning
5157dev_landuse
Public SafetyFire
Police
5154dev_pubsafety
Com DevAddresses
Cities
5156dev_comdev
Sheriff
5155dev_sheriff
EmergencyMgmt
5160dev_ema
Test
5170dev_test
Database / Service ConfigurationDatabase / Service Configuration
WaterHydrantsCMOM
5158dev_water
TransportationCobb ETRANS
giswg01\sqlexpress
E911E911 Data
5169dev_e911trans
WaterWaterSewer
5171water_sde
StormInventory
Hydro
5172storm_sde
GISSDEDEVGISSDEDEV GISWG01GISWG01
GISWATSDEGISWATSDE
SERUG 2008 14
GIS Production ServerGIS Production Server
Contains read-only dataServes data for all Desktop- and Web-based clientsSome data restricted to internal usersApproximately 2 terabytes of data– 10GB of vector data– 200GB / year for orthophotos
SERUG 2008 15
GIS Production ServerGIS Production Server
Test
5199sde_test
Database / Service ConfigurationDatabase / Service Configuration
GISVector Data
5151sde_gis
GIS2Vector Data
5153sde_gis2
OrthosRaster Data
5152sde_orthos
SERUG 2008 16
eGDBeGDB SynchronizationSynchronization
GIS layer changes moved nightly from “Edit” servers to “Production” serverRelated data from other business systemsSeries of SDE Commands, SQL Sever Packages, VB Scripting
Base Map Data (Contours, Orthos, etc) updated annually
SERUG 2008 17
Why Not Replication?Why Not Replication?
Synchronization scripts developed prior to v9.2Replication can handle some cases:– Update single feature class– Example: Parcels
But not others:– Event creation and SQL post-processing– Example: Roads
SERUG 2008 18
Recent DevelopmentsRecent Developments
Databases– Zoning Geodatabase
Applications– Data maintenance tools– StreetChecker– Expansion of Web mapping sites– Integration with critical business apps
SERUG 2008 19
Zoning Zoning GeodatabaseGeodatabase
SERUG 2008 20
Web Mapping SitesWeb Mapping Sites
Set short-term goal to create 3 new sites per quarter10 sites currently in production– 12 ArcIMS map services– 88 layers being published
Sparked imagination– Can we make …?– Can you add … to the Web map?
SERUG 2008 21
Virtual ToursVirtual Tours
SERUG 2008 22
Traffic CamerasTraffic Cameras
SERUG 2008 23
Web Mapping StatisticsWeb Mapping StatisticsInternal Map Services Internal Map Services -- 20072007
SERUG 2008 24
Web Mapping StatisticsWeb Mapping StatisticsPublic Map Service Public Map Service -- 20072007
SERUG 2008 25
GIS IntegrationGIS Integration
DOT – CarteGraph– Work orders, pavement mgmt, etc.– Maps, link to Cobb ETRANS
Countywide Imaging – OnBase– Search docs by clicking feature on map– When viewing docs, click to show map
SERUG 2008 26
CarteGraphCarteGraph CALLdirectorCALLdirector
Enter work request and determine jurisdiction and maintenance district from map
SERUG 2008 27
Present Day SystemPresent Day System
Databases– 15 databases
Applications– Focus on Web-based applications
Software– ArcGIS Desktop: 62 licenses– 3 ArcSDE, 1 ArcIMS, 2 ArcGIS Server
Users– ArcGIS Desktop: over 160 users– Web Mapping: 150,000 maps / month
GISSDE
ArcSDE 9.2
(AGS Ent/Bas)
GISSDEDEV
ArcSDE 9.2
(AGS Ent/Bas)
GISAPPS
(reverse proxy)
GISAPPDEV
ArcIMS 9.2GeoCortex 5.1
RouteServer
Nightly Synch
GIS Users
Various Appsaccess
database views
Public
Web / Server Based Sites
Cobb County
System at v9.2
Firewall
Work GroupServer
(AGS Wkg/Std) ArcGISServer
(AGS Ent/Adv)
Nightly SynchEdit
Edit / Publish
Production
External Web
Server
(DMZ)
Multiple Work Group
Servers
ArcGISServer
(AGS Ent/Std)
PublishCache
SERUG 2008 29
Looking AheadLooking Ahead
Increased integration with critical business applicationsAdditional eGDB developmentIncreased leverage of ArcGIS Server
SERUG 2008 30
GIS IntegrationGIS Integration
Community Development -- Accela– Suite of applications for:
• Permitting, Business License, etc.– Maps and proximity alerts
Water System -- Maximo– Asset management, work orders
• Water, sewer and storm water– Maps
SERUG 2008 31
eGDBeGDB DevelopmentDevelopment
Countywide Addressing Repository– Single source for county addresses– Based on proposed FGDC standard– Interfaces to business applications
Water System Geodatabase– Migration from MicroStation / Intergraph– Geometric networks– Linear referencing
SERUG 2008 32
Leveraging Leveraging ArcGISArcGIS ServerServer
Migrate current ArcIMS sitesDevelop new applications and Web services– MyCobbCounty website– Dashboards for department managers– Geoprocessing models
SERUG 2008 33
MyCobbCountyMyCobbCounty
Enter address and get information -- such as commissioner district, elected officials and nearest park or library
SERUG 2008 34
Ortho Cache IssueOrtho Cache Issue
SERUG 2008 35
QuestionsQuestions
Charles FailGIS Programmer/Analyst II
Tim ScharffGIS Manager770-528-8703
The application of GIS technology is limited only by the imagination of those who use it.
-- Jack Dangermond