Struggles with ArcGIS Online data management is common.  When managing data between your local geodatabase and ArcGIS Online hosted data, the number one question that we hear from customers is, “How do I sync my online data with the data on my desktop?”  Well… you don’t; not if you don’t have ArcGIS for Server to host your services, or if you prefer to host your data in ArcGIS Online.  Currently, there is no “sync” functionality between your ArcGIS Online feature service and the geodatabase you used to publish it.  So, what are your options?  There are a few choices, and many of them will be addressed in upcoming blog posts and Tech Talks.  However, there is one standout.

Safe’s FME Software

The FME software created by Safe Software Inc. is provided to GIS users in the form of Esri’s Data Interoperability Extension, and the software now supports transformations from ArcGIS Online feature classes to any supported writer.  This functionality opens a world of possibilities to us and can solve several workflow struggles.

In this example, I have a geodatabase for Signs that has extensive subtypes.  When editing data in Esri’s Collector app, these subtypes allow me to automatically populate things like sign size, MUTCD codes, and stock numbers.  If I don’t have access to FME or the Data Interop extension, then my workflow would be to export the feature service as a file geodatabase in ArcGIS Online, download the geodatabase, use the Delete Features tool to remove all the existing data from the original database, and finally Load Data into the existing geodatabase so that I don’t lose my subtypes.  Moving data around in this way is not recommended.  It is time-consuming and creates a lot of opportunity for mistakes.

But have no fear.  A Spatial ETL tool or FME Workspace can automatically check my feature service for added, updated and deleted features and make those changes in my local file geodatabase.

The 2017 version of the FME software has some amazing new functionality like the DateTimeCalculator, which can do things like modify attributes based on a relative date.  For example, maybe I have sign inspections that need to happen every couple years.  I could have the Workspace highlight features that have an inspection due date in the next 3 months.  The possibilities are endless.

Automating Workflows

Why not take this automation even further?  What if I want to use the Z-value tools for Collector to add mean sea level values to the data collected?  Well, I could just drag this new tool into the model that Esri has provided.

Once I have a model created, I can export that to a Python script and set it up to run on a schedule.  Maybe I would set this up to run every night at midnight.  When I come in every morning, all new data collected the previous day would be in my geodatabase, have vertical values entered in the attribute table, and I can see which sign inspection dates are coming due.

Check out our upcoming webinar on March 29th to see the setup and the full workflow in action.  And as always, if you need assistance, be sure to keep us in mind for training and professional services.

If you’re interested in taking a stab at this yourself, check out this blog post from Laura at Safe Software that contains an FME workspace to use as an example.  I love working with this software and think you will too.

And a special shout out to the Safe Software support department who has never let me down and continues to be full of heroes who always save the day.

Solutions

Frontier Precision has a 30-year plus track record of helping you provide a measure of excellence. It all ladders back to our core philosophy of How You Measure Matters. It’s why each day, we seamlessly connect the physical and digital worlds through technology to improve how we all better interact with the earth in meaningful ways. Our tools and solutions make you more efficient, productive, and most importantly, profitable.

Products

Frontier Precision knows that every measurement its customers take is important. It’s why Frontier Precision not only offers the latest, cutting-edge measurement tools, but also understand the continuing need for service and support — because How You Measure Matters encompasses the total customer experience.

Professional Services

From Geospatial Services to GIS Professional Services to Water Resources Data Acquisition Services, Frontier Precision delivers leading-edge measurement technology. We’ve been there, every centimeter of the way, as geospatial technology has evolved. No matter what your need for accurate measurement, we have the experience and expertise to create a customized solution for you.

 

Training & Events

We give you the proper training on the solutions we sell. Sign up for Professional Certified Training to get up and running quickly — all backed by the most experience in the industry. Whether onsite, online or in the classroom, we are helping make our customers efficient, productive, and profitable with today’ s and tomorrow’s technology.

Support

Frontier Precision provides world-class support from centers across a wide section of the western United States. Need support for any geospacial products, software or services?

Contact Frontier Precision at 800-359-3703.

About Frontier Precision

Frontier Precision’s measure of excellence can be traced back to 1988. Four years later, in 1991, Frontier Precision partnered with Trimble — a United States-based GPS equipment manufacturer at the time, and the rest is history. Since then, Frontier Precision has grown with Trimble to be one their largest and best geospatial distributors in the world.

We’ve been at the frontier of technology for three decades, continually offering customers new tools and solutions, all with our end goal in mind to help make our customers efficient, productive, and profitable with today’s and tomorrow’s technology. Frontier Precision is an employee-owned company — each of our team members is committed to your success.

Contact Frontier Precision

WHEREVER YOU ARE, WE ARE.

From our original office in Bismarck, North Dakota, we’ve grown our footprint thousands of miles in every direction.Today, you’ll also find us in South Dakota, Minnesota, Colorado, Alaska, Montana, Idaho, Hawaii, Wyoming, Oregon and Washington — delivering the Frontier Precision difference to more people each day.