![Page 1: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/1.jpg)
Automatic GIS Feature Generation using SDE Java API
Chuck Carufel - Indianapolis/ Marion County GIS
Joe LaCombe – Woolpert
![Page 2: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/2.jpg)
What Are They?
Applications to automatically create GIS features based upon occurrences in non-GIS databases.
![Page 3: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/3.jpg)
TAGG – Tidemark Automated Geography Generator.
Tidemark / Accela Permitting System
1) All Permits
2) Building Permits
![Page 4: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/4.jpg)
SAGA – Siebel Automated Geography Application.
Siebel CRM system. Citizen requests for service.
1) All non-info requests.
![Page 5: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/5.jpg)
Beginnings
Desire to see new structure locations quicker.
2 year planimetric update cycle.
So why not?........
![Page 6: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/6.jpg)
So why not?........
Include all permits, not just buildings.
Ok, well citizen requests are just locations too. And even more folks would like to easily see them.
Chuck’s annual wish list…..
![Page 7: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/7.jpg)
Self-maintaining Data.
![Page 8: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/8.jpg)
So how did we do it?
Master Address Database
(MAD)
![Page 9: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/9.jpg)
![Page 10: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/10.jpg)
![Page 11: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/11.jpg)
Address Table
TableADDRESS
Data typeField namePrec-ision Scale Length
Allow nulls
Main address table containing all non-linear address occurances such as buildings, parcels, and units
ADDR_TAG Long integer No 9 Unique tag among all non-linear address records
ADDR_SOURCE String Yes 5 Place a succinct description of the field in this text
CENTERLINE_TAG Long integer Yes 9 STREET_NAME_ID Long integer Yes 10 Provides a link to the STREET_NAME table
STNUM Long integer Yes 10 Street Number component of address
UNIT_TYPE String Yes 5 Describes the type of unit address
UNIT String Yes 10 Unit component of the address
CITY String Yes 20 City name
STATE String Yes 2 State name
ZIPCODE String Yes 10 Zipcode
Unique tag. Provides a link to the centerline geography
![Page 12: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/12.jpg)
702 – 798 ELM ST
5551
– 5
599
OA
K S
T 726
55555554 A5554 B5554 C5554 D
5556 A5556 B5556 C5556 D
Conseco Fieldhouse
![Page 13: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/13.jpg)
What does MAD do for us?
All Records Will Match
Known Geographic Location
City/County Standard Compliant
![Page 14: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/14.jpg)
Options Considered
Oracle PL/Sql Procedures
ArcGIS Web Service
ArcSDE Java API
![Page 15: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/15.jpg)
SDE Java API
What is it? Java programming interface Process and analyze SDE data
![Page 16: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/16.jpg)
Why SDE Java API
Database Solution Geometry Creation Follows SDE and geodatabase rules
![Page 17: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/17.jpg)
Why SDE Java API
Database Solution Automated, hidden application Needed to run within Oracle System architecture – two servers
Java Stored Procedures
![Page 18: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/18.jpg)
Java Stored Procedures
What are they? Java classes Stored within Oracle Operated via Oracle’s Java Virtual
Machine
![Page 19: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/19.jpg)
Why Java Stored Procedures
Oracle Integration Class files stored in database schema Efficient integration with PL/SQL Oracle developed with Java in mind
![Page 20: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/20.jpg)
Why Java Stored Procedures
System Architecture Database solution: Two-server
architecture Stability Secure
![Page 21: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/21.jpg)
TAGG Solution Workflow
TidemarkDatabase
AFTER_INSERTTRIGGER
Tidemark users
Saved PermitCase
TidemarkServer
![Page 22: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/22.jpg)
TAGG Solution Workflow cont…
AFTER_INSERTTRIGGER
STORED PROCEDUREPROCESS
Database Link
SDE Server
DBMS_Job
Staging Table
![Page 23: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/23.jpg)
TAGG Solution Workflow cont…
SDE Server
Java Source
MasterAddress
CCGIS.fcAllPermits
CCGIS.IndyParcels
CCGIS.fcParcels
CCGIS.fcBuildingPermits
CCGIS.IndyPermits
SDE
![Page 24: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/24.jpg)
SAGA Solution Workflow
Siebel Database
AFTER_INSERTTRIGGER
Siebel CRM users
Saved servicerequest
SiebelServer
AFTER_UPDATETRIGGER
![Page 25: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/25.jpg)
SAGA Solution Workflow cont…
AFTER_INSERTTRIGGER
SDE Server
Address Locators
IndyStreets
IndyParcels
Java SourceCCGIS.Requests
CCGIS.RequestForService
SDE
AFTER_UPDATETRIGGER
Staging Table
![Page 26: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/26.jpg)
Problems Encountered / Lessons Learned
Performance SDE connection Save transaction Calling via DBMS Job
Learning Curve system/database integration
![Page 27: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/27.jpg)
Problems Encountered / Lessons Learned
Technology ArcSDE 9 Java API Oracle 9i
Java Runtime version 1.3 Oracle 10g
Java Runtime version 1.4
![Page 28: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/28.jpg)
Benefits
“Invisible” Feature Creation
Managed By Oracle Efficient, Secure
Existing Environment
Simple 2 Server Architecture
![Page 29: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/29.jpg)
Benefits cont…
Java Based Easy Install & Configuration
Simple ArcSDE Interaction
Cool Ability To Add Historical Records
![Page 30: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/30.jpg)
How Will TAGG Be Used?
Directed Planimetric Updates
Solid Waste Billing Process
Permit Type Trends
![Page 31: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/31.jpg)
How Will SAGA Be Used?
Simple Mapping Of Complaints Daily Trends
Linked To Work Management (IMS)
Automated Mapping Engine Subscription
Siebel Call Center Integration
![Page 32: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/32.jpg)
Status
TAGG Goes Live Next Monday
SAGA App Completed, Siebel Triggers About To Be Integrated
![Page 33: Automatic GIS Feature Generation using SDE Java API](https://reader035.vdocuments.us/reader035/viewer/2022062721/56813785550346895d9f1f05/html5/thumbnails/33.jpg)
Questions ?
Thank You!