Leveraging ArcGIS Online for Public Utility Information
Leveraging ArcGIS Online for Public Utility Information David Speight True North Geographic Technologies, LLC
www.tngeo.com www.facebook.com/tngeo www.twitter.com/tngeo
• User Story • Business Problem • Technical Challenges • Solution in Action • Why is this relevant?
Business Problem
We Need a Map!
Business Problem • Outage Data
• Telvent OMS • SQL Server
• ArcGIS for Server Standard • SQL Server
• ArcGIS for Desktop
Initial Idea We use the Flex Viewer internally….
…let’s use it for the public.
Technical Problems / Concerns • Opening the firewall • Server capacity • Server performance ….do we need to buy more licensing?
Usability Problems / Concerns • Keep users on the corporate website • Mobile device compatibility • Needs to work like the rest of the web • What information / level of detail do we expose?
Alternative Approach ArcGIS Online
CEMC OMS
Desktop GP • Feature services • Web maps • Templates / apps / embed code
Online Outage Map
Data Prep
• Geoprocessing • • • •
Convert tabular data to feature class Limit attribute output Aggregate data by grid Publish to Server or AGOL (new at 10.1)
• Ready to publish?
Wait….….we’re still at 10.0 (I don’t have a Server Publishing toolbox)
Workaround
for field in fieldnames: element = str(field) value = str(row.getValue(field)) attributeDict[element] = value # Create the geometry object 'feat' feat = row.getValue(shapefieldname) poly = feat.getPart() for allRings in poly: for coordPair in allRings: xyPair = [coordPair.X,coordPair.Y] allPairs.append(xyPair) replaceRingsList = allPairs geometrySyntax['geometry']['rings'][0] = copy.deepcopy(replaceRingsList) # place the geometrySyntax dictionary that was created above into the cumulative inputGeometries list geometrySyntax['attributes'] = attributeDict geometrySyntaxDeepCopy = copy.deepcopy(geometrySyntax)
Final Solution • Python GP scripts
• ETL script exported from Model Builder • Load data to AGOL via feature services • Executed as scheduled task • 24 x 7 every 10 minutes
• Web Map
• Symbology • Generalized data • Popups
• Embedded to corporate website
Final Solution • Feature Service Updates vs. Republishing
• FS approach was faster (< 5s) • Lose the overhead of republishing service definition, resharing, etc.
• ArcGIS Online Organizational Account • • • •
Level 1 (5 users / 2500 credits) In production since November 2012 Almost no credit consumption Free to use AGO for other uses
Solution in Action
Summary • Publishing data to ArcGIS Online
• Eliminated security concerns • Eliminated server capacity concerns • Purchase AGOL Organizational subscription instead of more hardware/software
• Kept users on the corporate website • Maintained compatibility with mobile devices • Easy to modify & add content
Thank you… David Speight True North Geographic Technologies, LLC [email protected] 615-890-7728 www.tngeo.com
www.tngeo.com www.facebook.com/tngeo www.twitter.com/tngeo
• User Story • Business Problem • Technical Challenges • Solution in Action • Why is this relevant?
Business Problem
We Need a Map!
Business Problem • Outage Data
• Telvent OMS • SQL Server
• ArcGIS for Server Standard • SQL Server
• ArcGIS for Desktop
Initial Idea We use the Flex Viewer internally….
…let’s use it for the public.
Technical Problems / Concerns • Opening the firewall • Server capacity • Server performance ….do we need to buy more licensing?
Usability Problems / Concerns • Keep users on the corporate website • Mobile device compatibility • Needs to work like the rest of the web • What information / level of detail do we expose?
Alternative Approach ArcGIS Online
CEMC OMS
Desktop GP • Feature services • Web maps • Templates / apps / embed code
Online Outage Map
Data Prep
• Geoprocessing • • • •
Convert tabular data to feature class Limit attribute output Aggregate data by grid Publish to Server or AGOL (new at 10.1)
• Ready to publish?
Wait….….we’re still at 10.0 (I don’t have a Server Publishing toolbox)
Workaround
for field in fieldnames: element = str(field) value = str(row.getValue(field)) attributeDict[element] = value # Create the geometry object 'feat' feat = row.getValue(shapefieldname) poly = feat.getPart() for allRings in poly: for coordPair in allRings: xyPair = [coordPair.X,coordPair.Y] allPairs.append(xyPair) replaceRingsList = allPairs geometrySyntax['geometry']['rings'][0] = copy.deepcopy(replaceRingsList) # place the geometrySyntax dictionary that was created above into the cumulative inputGeometries list geometrySyntax['attributes'] = attributeDict geometrySyntaxDeepCopy = copy.deepcopy(geometrySyntax)
Final Solution • Python GP scripts
• ETL script exported from Model Builder • Load data to AGOL via feature services • Executed as scheduled task • 24 x 7 every 10 minutes
• Web Map
• Symbology • Generalized data • Popups
• Embedded to corporate website
Final Solution • Feature Service Updates vs. Republishing
• FS approach was faster (< 5s) • Lose the overhead of republishing service definition, resharing, etc.
• ArcGIS Online Organizational Account • • • •
Level 1 (5 users / 2500 credits) In production since November 2012 Almost no credit consumption Free to use AGO for other uses
Solution in Action
Summary • Publishing data to ArcGIS Online
• Eliminated security concerns • Eliminated server capacity concerns • Purchase AGOL Organizational subscription instead of more hardware/software
• Kept users on the corporate website • Maintained compatibility with mobile devices • Easy to modify & add content
Thank you… David Speight True North Geographic Technologies, LLC [email protected] 615-890-7728 www.tngeo.com
