<div dir="ltr">Thanks George - I will check this out. I think that your method of detailing the various tables to include WILL be useful for me. What I am less sure about is whether or not this will export "links" from tables... but then again, I do not even know if personal geoDB will support that... <div><br></div><div>In other words, my goal is to give my users something with a structure that holds features in one table, then associates those features with various properties tables. </div><div><br></div><div>As an aside, this is a pretty typical use case, I have inherited stewardship of a ShapeFile with 58,000 rows in it, and 135 columns. I pulled it into a nicely atomized and structured PostgreSQL db, but my users really want me to give them a daily dump of the old 58,000x135 shape file -- I want to lure them away from such abominations...</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 2, 2014 at 2:23 PM, George Silva <span dir="ltr"><<a href="mailto:georger.silva@gmail.com" target="_blank">georger.silva@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div>Hello Robert,<br><br></div>If your slave copy is read-only, you can setup a export job using ogr2ogr to generate the File Geodatabase daily.<br><br></div>Personal Geodatabase are not supported, but File Geodatabase are. You'll need to compile GDAL with FGDB support, that must be installed separately.<br><br>Some Geodatabase features are not supported via export directly, such as the creation of Feature Datasets.<br><br>Check this gist:<br><br><a href="https://gist.github.com/george-silva/787861408555572ad100" target="_blank">https://gist.github.com/george-silva/787861408555572ad100</a><br><br></div>The main export.sh script takes up a few parameters, so you can pass them along. This uses a table inside postgresql to know in advance about the layers I have and those that need to be exported.<br><br></div>This is bit more sophisticated, but you can hardcode your script and it will work the same.<br><br></div>Let me know how that works out for you.<br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Tue, Dec 2, 2014 at 4:37 PM, Robert Burgholzer <span dir="ltr"><<a href="mailto:rburghol@vt.edu" target="_blank">rburghol@vt.edu</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Wondering if anyone has any experience running from PG to ESRI mdb. Basically, we want to use PostGIS as our master, and then replicate in GeoDB format for field personel to reference when they are unable to connect to the Web due to remote location (which happens very frequently in our line of work).<div><br></div><div>Any thoughts, experiences would be welcome.<span><font color="#888888"><br clear="all"><div><br></div>-- <br><div><div dir="ltr">--<br>Robert W. Burgholzer<br> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus<div>Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank">http://athleticalgorithm.wordpress.com/</a> <br></div><div>Science: <a href="http://robertwb.wordpress.com/" target="_blank">http://robertwb.wordpress.com/</a></div><div>Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank">http://reesvineyard.wordpress.com/</a></div></div></div>
</font></span></div></div>
<br></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><span class="HOEnZb"><font color="#888888"><br></font></span></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><br>-- <br><div><div dir="ltr">George R. C. Silva<br>SIGMA Consultoria<div>----------------------------<br><div><a href="http://www.consultoriasigma.com.br/" target="_blank">http://www.consultoriasigma.com.br/</a><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div></div></div></div></div>
</font></span></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr">--<br>Robert W. Burgholzer<br> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.' - Charles Mingus<div>Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank">http://athleticalgorithm.wordpress.com/</a> <br></div><div>Science: <a href="http://robertwb.wordpress.com/" target="_blank">http://robertwb.wordpress.com/</a></div><div>Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank">http://reesvineyard.wordpress.com/</a></div></div></div>
</div>