s p a t i a l i n f o r m a t i o n s y s t e m s © geoanalytics, inc. 2002 – all rights...
TRANSCRIPT
![Page 1: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/1.jpg)
s p a t i a l i n f o r m a t i o n s y s t e m s
© GeoAnalytics, Inc. 2002 – All Rights Reserved
Technical Aspects: Wisconsin Historical Society GIS Project
Technical Aspects: Wisconsin Historical Society GIS Project
March 2002March 2002
WLIA 2002 Annual ConferenceWLIA 2002 Annual Conference
Presented by: Anita Temple
Team Members: Puneet Kishor and Jim Cory
![Page 2: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/2.jpg)
Presentation Outline
Project Background and Scope Situation at Project Start Changes to New System Application Details Technical and Non-technical Lessons
![Page 3: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/3.jpg)
Acknowledgements
Wisconsin Department of Transportation Staff members of WHS – especially
Bob Birmingham, John Broihahn, and LTE’s Jim Draeger, Joe DeRose, Brad Schwarzhoff Rick Dexter, Dan Duchow, and Compliance
Reviewers Maggie Buck, GIS Coordinator
WDOA, Office of Land Information Services
![Page 4: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/4.jpg)
Project Background and Scope
WHS founded in 1846. Mandate –collect, maintain, manage and
disseminate archaeological and historical data in Wisconsin.
This project – One division, three sections. Archaeology Survey and Registration Compliance
Project started Fall 2000. Completed December 2001.
![Page 5: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/5.jpg)
Project Background and Scope
Goals of Project – modernize! Migrate data to a new system Create spatial data Create web-based applications for all (data
viewers and editors) Easy access to all data via a web browser Visual display and maps of data via the web
applications Online decision support for Compliance reviews More options for data distribution
![Page 6: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/6.jpg)
In the Beginning
Paradox on PCs DOS or Windows 3.1 versions Four separate databases, few links
AHI (Architectural Historical Inventory) ASI (Archeological Site Inventory) BAR (Bibliography of Archeological Reports) Compliance (a tracking database)
Four applications by different developers, dates, functions, and levels of robustness
No Spatial data Arch sites and survey data drawn on USGS hardcopy quads No digital spatial representation of architectural sites
![Page 7: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/7.jpg)
In the Beginning
Hardcopy data galore! In the basement Upstairs in several file places
Staff – “techno-peasants” What is GIS? How to digitize? What is a web-based application?
![Page 8: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/8.jpg)
But…Change Had to Happen Because
Heavy workload on a few staff due to compliance review mandates
Inefficient or difficult access to data – time! Paradox database crashes No spatial data for visualization, maps,
analysis, etc. Pending budget cuts against all resources
(and now…even worse!)
![Page 9: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/9.jpg)
The Changes
Acquisition of software and hardware. Oracle ESRI product suite: Arc 8, ArcView 3.2, ArcIMS,
ArcSDE MacroMedia Cold Fusion New servers, PCs, monitors, etc.
Spatial data creation. Archaeological, Survey, and Burial sites captured
as heads-up digitizing in ArcView Geocoding Architectural sites with QMS to point
locations
![Page 10: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/10.jpg)
The Changes
Databases migrate to: Oracle 8.2 Four schemas, one for each application + an
additional schema for common data Share lookup tables, location (PLSS) tables Significant data scrubbing Changes in field values and definitions
![Page 11: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/11.jpg)
Application Development
Four applications for business needs including a map component.
Web browser Cold Fusion programming Oracle connect ArcIMS via CF connector
Administrator module for user access permissions.
![Page 12: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/12.jpg)
Admin Module
![Page 13: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/13.jpg)
Entry into System
![Page 14: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/14.jpg)
Entry into System
![Page 15: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/15.jpg)
Search Functions
Each application has simple and advanced search options that are customized to the business needs.
ASI have PLSS, County, Muni, Site#, etc. (BAR is similar).
AHI has Address (e.g. 707 Main) as well as County, municipality, etc.
Compliance has project lead, project number, project name, Street address, County, PLSS.
![Page 16: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/16.jpg)
Search Functions
![Page 17: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/17.jpg)
Search Results
![Page 18: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/18.jpg)
Viewing Records
![Page 19: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/19.jpg)
Viewing Records
![Page 20: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/20.jpg)
Data Updates
![Page 21: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/21.jpg)
Mapping Functions
![Page 22: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/22.jpg)
Specialized Features
Complex queries / searches. Organized information into ‘tab’ screens. Within each tab, information is organized
logically for updates / edits. Map application allows browsing to another
nearby site and when new site is selected, record is refreshed to that information.
![Page 23: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/23.jpg)
Specialized Features - Compliance
Compliance – not like the others – is a tracking application.
Contact list Reviewer list Correspondence list Search related records in ASI and AHI Search proposed project area visually via map tab Status tracking of review process Generates form letters
![Page 24: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/24.jpg)
Specialized Features – Related Records
![Page 25: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/25.jpg)
Related Records Map
![Page 26: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/26.jpg)
Tracking Options
![Page 27: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/27.jpg)
Technical Lessons
Versions of software are important for functions and compatibility issues.
CF 4.5 versus 5.0 ArcIMS 3.0 and 3.1 IE and Netscape
Prescribe minimum technology and user experience requirements for the applications.
![Page 28: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/28.jpg)
Technical Lessons
One application cannot serve all user needs or levels of experience.
Browsers of data versus editors of data Data analysts
Reuse Code! The use of custom tags and functions.
![Page 29: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/29.jpg)
Technical Lessons
Application development should be iterative, not sequential.
Changes / discoveries in the 4th application can cycle back to the 1st application.
Testing of applications should be done by all, even those outside of the business area.
![Page 30: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/30.jpg)
Non-technical Lessons
Process changes can be difficult. From a personal data entry method to another Work flow of data Understanding the new system
User needs change as more becomes possible with technology.
User needs change as staff become educated on the new system
Expectations change over time.
![Page 31: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/31.jpg)
Outcomes
for WHS – State-of-the-art database and work applications. Integrated system. Access to all data to all staff resulting in increased
efficiencies (especially to compliance). Capability for remote staff access to data. Map-making capabilities.
for WDOT & other agencies– web access to generalized data for a first “cut” with compliance reviews.
![Page 32: S p a t i a l i n f o r m a t i o n s y s t e m s © GeoAnalytics, Inc. 2002 – All Rights Reserved Technical Aspects: Wisconsin Historical Society GIS](https://reader036.vdocuments.us/reader036/viewer/2022062803/56649f165503460f94c2bfcc/html5/thumbnails/32.jpg)
s p a t i a l i n f o r m a t i o n s y s t e m s
© GeoAnalytics, Inc. 2002 – All Rights ReservedMarch 2002March 2002
Madison, Wisconsin West Palm Beach, FloridaChicago, Illinois
Anita Temple or Puneet KishorAnita Temple or Puneet Kishor
GeoAnalytics, Inc.GeoAnalytics, Inc.1716 Fordem Avenue1716 Fordem Avenue
Madison, WI 53704-4604Madison, WI 53704-4604Phone: 608-241-7100 Fax: 608-241-7116Phone: 608-241-7100 Fax: 608-241-7116
E-mail: E-mail: [email protected] or or [email protected]
Web: Web: http://www.geoanalytics.com