Utility Billing Integration and Flex Based Application Development Scott F. Snider, GISP GIS Coordinator City of Lancaster IT/Telecom 2012 Ohio GIS Conference September 19 - 21, 2012 | Hyatt Regency Hotel | Columbus, Ohio
Outline • • • GIS System UB System Linking Servers for Integration Modelbuilder Python Task Scheduler Data Services Flex API Projects Live Demonstration?
GIS System • ELA Customer with ESRI • Arc. GIS 10. 0 – Upgrade to 10. 1 Pending • SQL Server 2005 – Upgrade to 2008 R 2 required for 10. 1 • Desktop Installations at 8+ sites across Lancaster – Connected back to IT via City Owned Fiber Optic Network
Utility Billing System • in. HANCE Utility Solution by Harris • SQL Server
How do severs communicate? • By linking them • And setting up an ODC db connection
Modelbuilder Points for Reverse Integration Convert Parcels for Customers of Each Utility Create Data Points for Meters
Modelbuilder *CAUTION* That may not be the best method. . . - Delete Tables It is simply MY method! - Recopy Tables - Delete Customer Parcels - Repeat *CAUTION* with Storm Water - Repeat with Water - Clean up parcels for next step - Create No Gas Service Parcels - Copies Parcels Joins Gas Table Repeat with Sanitation Delete No Service Parcels Create Parcels with no Utility Services - Repeat for Sanitation, Storm Water & Water
Modelbuilder • Be sure to back copy/paste models while working!!!! • The RED X of DOOM will strike at the worst possible time!!! • Or you can crash the program.
Python • Export model to python script • Pyscripter – free application if you need to make edits. – I use it for find replace. • Task scheduler will not function with a mapped drive from the same machine. • Use python to test your script on your server before moving on to set up batch file and automated task.
Python
. bat (Batch) file • Notepad document calling for python script • Change extension to. bat from. txt
Task Scheduler • Set. bat file to run overnight when server traffic is low
Data Services • Set up an. mxd to display the data how you want it to appear in your applications • Save it as an. msd • Use server manager to publish the. msd as the data service
Data Services ***Nugget of Knowledge #1*** • I use a dummy user account on my server for data connections for my services • Necessary? ? ? – Helps me track who’s connected in SQL
Data Services ***Nugget of Knowledge #2*** • If you have problems with your service locking you out of editing in your databases in SDE (assuming direct access to database) • C: Program Files (x 86)Arc. GISServer 10. 0serverusercfg • Add this line to your service config file: <Schema. Locking. Enabled>False<Schema. Locking. Enabled>
Flex Applications
Flex Applications
LIVE DEMO? (I am crossing my fingers)
Questions? • • • Scott F. Snider, GISP GIS Coordinator City of Lancaster IT/Telecom ssnider@ci. lancaster. oh. us 740. 652. 2687
Скачать презентацию Utility Billing Integration and Flex Based Application Development
c32e9c632b4bc1a6cb4b9c2125d2646f.ppt