Automatic GIS Feature Generation using SDE Java API

Automatic GIS Feature Generation using SDE Java API Chuck Carufel - Indianapolis/ Marion County GIS Joe La. Combe – Woolpert

What Are They? Applications to automatically create GIS features based upon occurrences in non-GIS databases.

TAGG – Tidemark Automated Geography Generator. Tidemark / Accela Permitting System 1) All Permits 2) Building Permits

SAGA – Siebel Automated Geography Application. Siebel CRM system. Citizen requests for service. 1) All non-info requests.

Beginnings Desire to see new structure locations quicker. 2 year planimetric update cycle. So why not? . . . .

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…. .

Self-maintaining Data.

So how did we do it? Master Address Database (MAD)

Address Table

5554 A 5554 B 5554 C 5554 D 5551 – 5599 OAK ST 5556 A 5556 B 5556 C 5556 D 726 5555 702 – 798 ELM ST Conseco Fieldhouse

What does MAD do for us? All Records Will Match Known Geographic Location City/County Standard Compliant

Options Considered Oracle PL/Sql Procedures Arc. GIS Web Service Arc. SDE Java API

SDE Java API What is it? l Java programming interface l Process and analyze SDE data

Why SDE Java API l l l Database Solution Geometry Creation Follows SDE and geodatabase rules

Why SDE Java API Database Solution l Automated, hidden application l Needed to run within Oracle l System architecture – two servers Java Stored Procedures

Java Stored Procedures What are they? l Java classes l Stored within Oracle l Operated via Oracle’s Java Virtual Machine

Why Java Stored Procedures Oracle Integration l Class files stored in database schema l Efficient integration with PL/SQL l Oracle developed with Java in mind

Why Java Stored Procedures System Architecture l Database solution: Two-server architecture l Stability l Secure

TAGG Solution Workflow

TAGG Solution Workflow cont…

TAGG Solution Workflow cont…

SAGA Solution Workflow

SAGA Solution Workflow cont…

Problems Encountered / Lessons Learned Performance l SDE connection l Save transaction l Calling via DBMS Job Learning Curve l system/database integration

Problems Encountered / Lessons Learned Technology l Arc. SDE 9 Java API l Oracle 9 i l Java Runtime version 1. 3 l Oracle 10 g l Java Runtime version 1. 4

Benefits “Invisible” Feature Creation Managed By Oracle l Efficient, Secure l Existing Environment Simple 2 Server Architecture

Benefits cont… Java Based l Easy Install & Configuration l Simple Arc. SDE Interaction Cool Ability To Add Historical Records

How Will TAGG Be Used? Directed Planimetric Updates Solid Waste Billing Process Permit Type Trends

How Will SAGA Be Used? Simple Mapping Of Complaints l Daily Trends l Linked To Work Management (IMS) Automated Mapping Engine l Subscription Siebel Call Center Integration

Status TAGG Goes Live Next Monday SAGA App Completed, Siebel Triggers About To Be Integrated

Questions ? Thank You!