On-the-fly Projection for Geodatabase Replication

07-19-2011 01:38 PM
Status: Open
Labels (1)
New Contributor III
We have production databases that are in NAD83 UTM and a publication database that's in Web Mercator in order to match the ArcGIS base map standard projection for our web maps and applications.  We need to update data in the Web Mercator database on a nightly, sometimes quarter hourly, basis and it would be great if we could set up replication so that it would project the data on-the-fly from our UTM database to our Web Mercator database.
See also...

 HowTo:  Create a replica where the child replica data is in a different coordinate system than the parent replica data

Simplify the Create Replica to other Coordinate Systems Process
by Anonymous User

Should be an option button in the Replication set up. Default to 3857.


If things were that simple what would they need GIS people like you for?  Just saying...

by Anonymous User

Well, actually it turned out not to be that bad. The workflow did indeed work perfectly, for a viewer and two SDEs and their child GDBs. However, I imagine this is a common workflow - where GIS departments would want file GDBs in web mercator for web viewers. But they keep SDE in state plane. It would be an area for streamlining the interface. 


I have been using this workflow for years now and as you said it in not a big deal.