![Page 1: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/1.jpg)
Developing an Enterprise GIS and Web Developing an Enterprise GIS and Web Application with CAMA IntegrationApplication with CAMA Integration
Matt BryantMatt BryantBruce Harris & Associates, Inc.Bruce Harris & Associates, Inc.
![Page 2: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/2.jpg)
IntroductionIntroduction
Building GIS EnterpriseBuilding GIS Enterprise–– CAD to SDE ConversionCAD to SDE Conversion–– MultiMulti--Editor Versioned EnvironmentEditor Versioned Environment–– GDB ReplicationGDB Replication–– CAMA Data ExtractCAMA Data Extract
Building Public Property Web ApplicationBuilding Public Property Web Application–– Parcel/CAMA Search DesignParcel/CAMA Search Design–– File ManagementFile Management–– Deployment StrategyDeployment Strategy
Osceola County Property AppraiserOsceola County Property Appraiser
![Page 3: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/3.jpg)
Scoping out a projectScoping out a project
What currently exists?What currently exists?–– CAD filesCAD files–– ShapefilesShapefiles–– ArcIMSArcIMS 4.x4.x
![Page 4: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/4.jpg)
Scoping out a projectScoping out a project
What are the goals?What are the goals?–– Migration to ArcSDE SQL Server Migration to ArcSDE SQL Server
geodatabasegeodatabase–– New Web ApplicationNew Web Application
ArcGIS ServerArcGIS Server–– County Standard Tax MapCounty Standard Tax Map
Modern look and feelModern look and feelCleaner backendCleaner backendMore FunctionalityMore Functionality
![Page 5: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/5.jpg)
Scoping out a projectScoping out a project
What are the challenges?What are the challenges?–– GeodatabaseGeodatabase
Topologically accurate boundaries and Topologically accurate boundaries and polylinespolylinesIntelligent feature linked annotationIntelligent feature linked annotationNew condominium modelNew condominium model
–– CAMACAMANew clean data extractNew clean data extract
–– Web ApplicationWeb ApplicationNew DesignNew DesignNew ESRI Technologies (REST, Javascript API)New ESRI Technologies (REST, Javascript API)
![Page 6: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/6.jpg)
Deployment StrategyDeployment Strategy
![Page 7: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/7.jpg)
Development StrategyDevelopment Strategy
Data TierData Tier–– ArcSDE GeodatabaseArcSDE Geodatabase–– CAMA extract databaseCAMA extract database–– FilesFiles
Business TierBusiness Tier–– Server code executing Stored ProceduresServer code executing Stored Procedures–– File Management and PDF GenerationFile Management and PDF Generation–– ArcGIS ServerArcGIS Server
Presentation TierPresentation Tier–– AJAX Tabbed Web ApplicationAJAX Tabbed Web Application–– ESRI JavaScript APIESRI JavaScript API–– Input ValidationInput Validation
![Page 8: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/8.jpg)
Geodatabase ConversionGeodatabase Conversion
Database designDatabase design–– CAD data lookCAD data look–– TopologyTopology–– Feature linked Feature linked
annotationannotation–– Condominium Condominium
supportsupport
![Page 9: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/9.jpg)
GIS DataGIS Data
ArcSDEArcSDE–– ArcSDE Production ArcSDE Production
databasedatabaseVersioned EditingVersioned Editing
–– GDB ReplicationGDB Replication
ArcGIS ServerArcGIS Server–– REST ServiceREST Service
![Page 10: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/10.jpg)
CAMA DataCAMA Data
Identify public domain dataIdentify public domain dataAvoid overwhelming the userAvoid overwhelming the userDesign Web Application specific Design Web Application specific databasedatabaseModify schema for optimal search Modify schema for optimal search performanceperformanceKeep data as live as the mapKeep data as live as the map
![Page 11: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/11.jpg)
CAMA DataCAMA Data
QueriesQueries–– Stored ProceduresStored Procedures
SSIS packageSSIS packageSchedule jobSchedule job
![Page 12: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/12.jpg)
Website DesignWebsite Design
Simple InterfaceSimple InterfaceNew look and feelNew look and feel–– Common CSS with main siteCommon CSS with main site
Tab driven workflowTab driven workflowAJAX driven updatesAJAX driven updatesVertical scroll details pageVertical scroll details pageData or Map search Data or Map search --> same workflow> same workflow
![Page 13: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/13.jpg)
Web ApplicationWeb Application
VB.NET VB.NET -- ASP.NET 3.5ASP.NET 3.5IIS 6+IIS 6+Google Google BlueprintCSSBlueprintCSSJQueryJQueryESRI JavaScript APIESRI JavaScript APIHome brewed controls and AJAX Home brewed controls and AJAX frameworkframework
![Page 14: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/14.jpg)
Property SearchProperty Search
Basic and Advanced Search TabsBasic and Advanced Search Tabs
![Page 15: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/15.jpg)
Property SearchProperty Search
Search ResultsSearch Results–– SortingSorting–– CSVCSV
![Page 16: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/16.jpg)
Property SearchProperty Search
Parcel DetailsParcel Details
![Page 17: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/17.jpg)
Property SearchProperty Search
Links to Photo, Trim, Sketch, and MapLinks to Photo, Trim, Sketch, and Map
![Page 18: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/18.jpg)
Map InteractionMap Interaction
SelectSelect–– Search ResultsSearch Results
![Page 19: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/19.jpg)
Map InteractionMap Interaction
IdentifyIdentify–– Parcel DetailParcel Detail
![Page 20: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/20.jpg)
Additional Additional FuntionalityFuntionality
Generate PDFGenerate PDFBirds Eye ViewBirds Eye View
![Page 21: Developing an Enterprise GIS and Web Application with CAMA ... · – New Web Application ... New clean data extract – Web Application New Design New ESRI Technologies (REST, Javascript](https://reader030.vdocuments.us/reader030/viewer/2022013023/6026f7d5f0acac060d64b063/html5/thumbnails/21.jpg)
ContactsContacts
http://ira.propertyhttp://ira.property--appraiser.orgappraiser.org
Bruce Harris & Associates, Inc.Bruce Harris & Associates, Inc.–– Kevin HardesterKevin Hardester
[email protected]@bruceharris.com(321) 663(321) 663--60456045
–– Matt BryantMatt [email protected]@bruceharris.com(630) 761(630) 761--09510951