1 / 33

Automatic GIS Feature Generation using SDE Java API

Automatic GIS Feature Generation using SDE Java API. Chuck Carufel - Indianapolis/ Marion County GIS Joe LaCombe – Woolpert. What Are They?. Applications to automatically create GIS features based upon occurrences in non-GIS databases. TAGG – Tidemark Automated Geography Generator.

valentino-dawson
Download Presentation

Automatic GIS Feature Generation using SDE Java API

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

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

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

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

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

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

  7. Self-maintaining Data.

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

  9. Address Table

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

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

  12. Options Considered Oracle PL/Sql Procedures ArcGIS Web Service ArcSDE Java API

  13. SDE Java API • What is it? • Java programming interface • Process and analyze SDE data

  14. Why SDE Java API • Database Solution • Geometry Creation • Follows SDE and geodatabase rules

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

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

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

  18. Why Java Stored Procedures • System Architecture • Database solution: Two-server architecture • Stability • Secure

  19. TAGG Solution Workflow

  20. TAGG Solution Workflow cont…

  21. TAGG Solution Workflow cont…

  22. SAGA Solution Workflow

  23. SAGA Solution Workflow cont…

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

  25. Problems Encountered / Lessons Learned Technology • ArcSDE 9 Java API • Oracle 9i • Java Runtime version 1.3 • Oracle 10g • Java Runtime version 1.4

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

  27. Benefits cont… • Java Based • Easy Install & Configuration • Simple ArcSDE Interaction Cool Ability To Add Historical Records

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

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

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

  31. Questions ? Thank You!

More Related