On-the-fly Projection for Geodatabase Replication

395
5
07-19-2011 01:38 PM
Status: Open
Labels (1)
BerneJackson
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.
5 Comments
DanMcCoy
See also...

 HowTo:  Create a replica where the child replica data is in a different coordinate system than the parent replica data
http://support.esri.com/en/knowledgebase/techarticles/detail/34129


Simplify the Create Replica to other Coordinate Systems Process
https://community.esri.com/ideas/1514
KevinMacLeod4

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

RobertScheitlin__GISP

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

KevinMacLeod4

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. 

RobertScheitlin__GISP

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