diff options
Diffstat (limited to 'test/where/ import mapinfo.html')
| -rw-r--r-- | test/where/ import mapinfo.html | 367 |
1 files changed, 367 insertions, 0 deletions
diff --git a/test/where/ import mapinfo.html b/test/where/ import mapinfo.html new file mode 100644 index 0000000..a165f34 --- /dev/null +++ b/test/where/ import mapinfo.html @@ -0,0 +1,367 @@ + +<!-- saved from url=(0073)http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet --> +<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title> + OGR2OGR Cheatsheet +</title><meta name="description" content="Boston GIS a testbed for GIS mapping services focusing on Boston Massachusetts"><meta name="keywords" content="Boston Consulting, GIS, mapping, UMN mapserver, postgis, postgresql, ESRI shapefiles, MapInfo Tab files, WMS, WFS, Ortho Photos, Web mapping"><meta name="robots" content="index,follow"><meta name="rating" content="General"><meta name="revisit-after" content="1 days"><link rel="alternate" type="application/rss+xml" title="GIS Tutorial and Article Comments (ALL)" href="http://www.bostongis.com/GISCommentsRss.aspx"><link href="./ import mapinfo_files/basic.css" type="text/css" rel="stylesheet"><link href="./ import mapinfo_files/basic070802.css" type="text/css" rel="stylesheet"><link href="./ import mapinfo_files/jeditcode.css" type="text/css" rel="stylesheet"><link href="./ import mapinfo_files/printer.css" type="text/css" rel="stylesheet"></head> +<body marginwidth="0" marginheight="15" topmargin="15"> + <div id="hdr"> + <table border="0" width="100%"> + <tbody><tr valign="middle"> + <td align="left"> + <a href="http://www.postgis.org/" target="_blank" title="PostGIS Spatial Database Engine"><img border="0" alt="PostGIS Spatial Database Engine" src="./ import mapinfo_files/stock_elephant_060_rev.gif" style="border-width:0px;"></a> + </td> + <td align="left"> + <a href="http://mapserver.org/" target="_blank" title="UMN Mapserver Community site"><img border="0" alt="UMN Mapserver" src="./ import mapinfo_files/mapserver_logo.gif" style="border-width:0px;"></a> + </td> + <td align="center"><span class="head">Boston Geographic Information Systems</span></td> + <td align="right"> <a href="http://www.postgis.us/page_buy_book" target="_blank" title="Buy PostGIS in Action"><img src="./ import mapinfo_files/postgisinaction_small.jpg" alt="Checkout our PostGIS in Action book. First chapter is a free download" border="0"></a> <a href="http://www.postgresql.org/" target="_blank" title="PostGreSQL ORDBMS"><img border="0" alt="PostGreSQL Object Relational Database Management System" src="./ import mapinfo_files/postgresql95x51_4.gif" style="border-width:0px;"></a></td> + </tr> + </tbody></table> + <div id="bar"><a href="http://www.bostongis.com/store.aspx">GIS Books</a> <a href="http://www.bostongis.com/" class="home">Home</a> <a href="http://www.paragoncorporation.com/Services.aspx" class="home" target="_blank">Consulting Services</a> <a href="http://www.bostongis.com/About.aspx" class="home">About Boston GIS</a> <a href="http://www.bostongis.com/blog">Boston GIS Blog</a> <a href="http://www.postgresonline.com/">Postgres OnLine Journal</a> + <br></div> + </div> + <span class="screen_only"> + + <table width="100%"><tbody><tr><td width="25%"> + <a href="http://www.postgis.us/page_buy_book" target="_blank" title="PostGIS in Action">PostGIS in Action is out in hard-copy, <br>download the first chapter <br>and SQL Primer for free. + <img src="./ import mapinfo_files/postgisinaction_small.jpg" alt="Tips and Tricks for PostGIS" border="0"></a></td> +<td> + <script type="text/javascript" async="" src="./ import mapinfo_files/ga.js"></script><script type="text/javascript"><!-- +amazon_ad_tag="bostongis-20"; +amazon_ad_width="728"; +amazon_ad_height="90"; +amazon_color_border="C80109"; +amazon_color_logo="FFFFFF"; +amazon_color_link="DC1D25"; +amazon_ad_logo="hide"; +amazon_ad_title="Boston GIS Store"; //--></script> +<script type="text/javascript" src="./ import mapinfo_files/asw.js"></script><script src="./ import mapinfo_files/ads-common.js" type="text/javascript"></script><iframe src="./ import mapinfo_files/cm.html" marginwidth="0" marginheight="0" width="728" height="90" border="0" frameborder="0" style="border:none;" scrolling="no"></iframe> + +</td></tr></tbody></table> +</span> +<table> +<tbody><tr valign="top"><td> + <form name="aspnetForm" method="post" action="./ import mapinfo_files/ import mapinfo.html" id="aspnetForm"> +<div> +<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE5MDEwNjc4NTEPZBYCZg9kFgQCBA9kFgICAQ9kFgQCAQ8PFgIeBFRleHQFyVs8ZGl2IGlkPSdoZHInPjxzcGFuIGNsYXNzPWhlYWRlcnRpdGxlPk9HUjJPR1IgQ2hlYXRzaGVldDwvc3Bhbj48L2Rpdj48aDE+T0dSIFRvb2xzPC9oMT4KPFA+VGhlIE9HUiB0b29sa2l0IGlzIGEgc3Via2l0IG9mIHRoZSBGVyBUb29scyBUb29sa2l0LiAgVGhlIEZXIFRvb2xzIFRvb2xraXQgaXMgYSB0b29sa2l0IGF2YWlsYWJsZSBpbiBib3RoIExpbnV4IGFuZCBXaW5kb3dzIGV4ZWN1dGFibGUgZm9ybSBhcyB3ZWxsIGFzIHNvdXJjZSBjb2RlIGZvcm0uICAKSXQgaGFzIHNldmVyYWwgY29tbWFuZCBsaW5lIHRvb2xzLiAgVGhlIG9uZXMgd2UgZmluZCBtb3N0IHVzZWZ1bCBhcmU6CjxVTD4KPExJPjxiPk9nckluZm88L2I+IC0gaW5zcGVjdHMgYSBHSVMgZGF0YXNvdXJjZSBhbmQgc3BpdHMgb3V0IHN1bW1hcnkgZGF0YSBvciBkZXRhaWxlZCBpbmZvcm1hdGlvbiBhYm91dCB0aGUgbGF5ZXJzLCBraW5kcyBvZiBnZW9tZXRyaWVzIGZvdW5kIGluIHRoZSBmaWxlLjwvTEk+Cgo8TEk+PGI+T2dyMk9ncjwvYj4gLSAgdGhpcyBpcyBhIGNvbW1hbmQgbGluZSB0b29sIHRoYXQgY29udmVydHMgb25lIE9nciBkZWZpbmVkIGRhdGEgc291cmNlIHRvIGFub3RoZXIgT2dyIGRhdGEgc291cmNlLiAgT2dyIHN1cHBvcnRzIG11bHRpcGxlIGRhdGEgZm9ybWF0czogRVNSSSBTaGFwZWZpbGUsIE1hcEluZm8gVGFiIGZpbGUsIFRJR0VSLCBzNTcsIERHTiwgQ1NWLCBEQkYsIEdNTCwgS01MLCBJbnRlcmxpcywgU1FMaXRlLCBPREJDLCBFU1JJIEdlb0RhdGFiYXNlIChNREIgZm9ybWF0KSwgUG9zdEdJUy9Qb3N0Z3JlU1FMLCBNeVNRTCAuIDwvTEk+CjwvVUw+Cgo8UD5UaGVzZSAyIGNvbW1hbmQgbGluZSB0b29scyBjYW4gYmUgZm91bmQgaW4gdGhlIDxiPmJpbjwvYj4gZm9sZGVyIG9mIHlvdXIgRldUb29scyBpbnN0YWxsLiAgVG8gc3RhcnQgdXNpbmcgdGhlc2UgdG9vbHMgCjxPTD48TEk+SW5zdGFsbCB0aGUgPGEgaHJlZj0iaHR0cDovL2Z3dG9vbHMubWFwdG9vbHMub3JnLyIgdGFyZ2V0PV9ibGFuaz5GVyBUb29sczwvYT4gdG9vbCBraXQuPC9MST4KPExJPkxhdW5jaCB0aGUgPGI+RlcgVG9vbHMgU2hlbGw8L2I+IC0gaW4gd2luZG93cyB0aGlzIGlzIGZvdW5kIHVuZGVyIFN0YXJ0LT5Qcm9ncmFtcy0+RlcgVG9vbHMgLi48L0xJPgo8TEk+RnJvbSB0aGUgc2hlbGwgLSAgY2QgaW50byB5b3VyIGRpcmVjdG9yeSB0aGF0IGhhcyB0aGUgZGF0YSB5b3Ugd2FudCB0byBjb252ZXJ0PC9MST4KPC9QPgoKPGgyPkdldHRpbmcgbW9yZSBIZWxwPC9oMj4KPFA+SWYgeW91IHdhbnQgYSBjb21wcmVoZW5zaXZlIGxpc3Rpbmcgb2Ygb3B0aW9ucyBvZmZlcmVkIGJ5IDxiPm9ncjJvZ3I8L2I+IG9yIDxiPm9ncmluZm88L2I+LCBydW4gdGhlIGZvbGxvd2luZyBhdCB0aGUgRlcgVG9vbHMgU2hlbGwuIDwvUD4KPFBSRT48Q09ERT5vZ3Iyb2dyIC0taGVscApvZ3JpbmZvIC0taGVscAo8L0NPREU+CjwvUFJFPgoKPGgyPkNvbnZlcnNpb25zIGZyb20gTWFwSW5mbyB0byBPdGhlciBmb3JtYXRzPC9oMj4KPGgzPkNvbnZlcnNpb24gZnJvbSBNYXBJbmZvIHRvIEVTUkkgU2hhcGU8L2gzPgoKPENPREU+b2dyMm9nciAtZiAiRVNSSSBTaGFwZWZpbGUiIG15ZGF0YS5zaHAgbXlkYXRhLnRhYjwvQ09ERT4KPGgzPkNvbnZlcnNpb24gZnJvbSBNYXBJbmZvIHRvIFBvc3RHSVM8L2gzPgo8Q09ERT5vZ3Iyb2dyIC1mICJQb3N0Z3JlU1FMIiBQRzoiaG9zdD1teWhvc3QgdXNlcj1teWxvZ2lubmFtZSBkYm5hbWU9bXlkYm5hbWUgcGFzc3dvcmQ9bXlwYXNzd29yZCIgbXl0YWJmaWxlLnRhYjwvQ09ERT4KCjxQPk5vdGU6IGZvciB0aGUgYWJvdmUsIHlvdSBjYW4gbGVhdmUgb3V0IHRoZSBob3N0IGlmIGl0cyBsb2NhbGhvc3QgYW5kIHVzZXIgYW5kIHBhc3N3b3JkIGlmIHlvdSBoYXZlIHlvdXIgYXV0aGVudGljYXRpb24gc2V0IHRvIHRydXN0LjwvUD4KCjxiPkltcG9ydGluZyBhcyBhIGRpZmZlcmVudCB0YWJsZSBuYW1lPC9iPgo8UD5JbiB0aGUgYmVsb3cgZXhhbXBsZSwgd2UgZG9uJ3Qgd2FudCBPR1IgdG8gY3JlYXRlIGEgdGFibGUgY2FsbGVkIDxiPm15dGFibGU8L2I+LiAgV2UgaW5zdGVhZCB3YW50IHRvIGNhbGwgdGhlIHRhYmxlIHNvbWV0aGluZyBkaWZmZXJlbnQgbGlrZSA8Yj5uZXd0YWJsZW5hbWU8L2I+LiAgVG8gZG8gc28gd2UgdXNlIHRoZSA8Yj5ubG48L2I+IG9wdGlvbi4KCjxiciAvPjxiciAvPgo8Q09ERT5vZ3Iyb2dyIC1mICJQb3N0Z3JlU1FMIiBQRzoiaG9zdD1teWhvc3QgdXNlcj1teWxvZ2lubmFtZSBkYm5hbWU9bXlkYm5hbWUgcGFzc3dvcmQ9bXlwYXNzd29yZCIgbXl0YWJmaWxlLnRhYiAtbmxuIG5ld3RhYmxlbmFtZTwvQ09ERT4KPC9QPgoKCjxoMz5XaGVuIE9HUiBndWVzc2VzIHdyb25nIG9yIGZhaWxzIHRvIGd1ZXNzPC9oMz4KPFA+U29tZXRpbWVzIE9HUiBkb2VzIG5vdCBvdXRwdXQgdGhlIHJpZ2h0IHByb2plY3Rpb24sIHBhcnRpY3VsYXJseSB3aXRoIFVuaXRzIG9mIEZlZXQgb3IgZGF0YSB0aGF0IGhhcyBubyBwcm9qZWN0aW9uIGluZm8gb3IgdGhlIHByb2plY3Rpb24gaW5mb3JtYXRpb24gY2FuJ3QgYmUgZWFzaWx5IHRyYW5zbGF0ZWQgdG8geW91ciBzeXN0ZW0uICBTb21ldGltZXMgT0dSIGNhbid0IG1hdGNoIHRoZSBwcm9qZWN0aW9uIHRvIG9uZSBpbiB5b3VyIHNwYXRpYWxfcmVmX3N5cyB0YWJsZSBzbyBjcmVhdGVzIGEgbmV3IGVudHJ5IGluIHRoYXQgdGFibGUuICBJbiB0aGVzZSBjYXNlcyB5b3UgaGF2ZSB0byB0ZWxsIE9HUiB3aGF0IHRoZSBvdXRwdXQgcHJvamVjdGlvbiBpcy4gIFlvdSBkbyB0aGlzIHdpdGggdGhlIDxiPi1hX3NyczwvYj4gZmxhZy4KPGJyIC8+PGJyIC8+CjxDT0RFPm9ncjJvZ3IgLWYgIlBvc3RncmVTUUwiIC1hX3NycyAiRVBTRzoyMjQ5IiBQRzoiaG9zdD1teWhvc3QgdXNlcj1teWxvZ2lubmFtZSBkYm5hbWU9bXlkYm5hbWUgcGFzc3dvcmQ9bXlwYXNzd29yZCIgbXl0YWJmaWxlLnRhYjwvQ09ERT4KPC9QPgoKPFA+SW4gdGhlIGFib3ZlIGV4YW1wbGUgSSB0b2xkIE9HUjJPR1IgdG8gYXNzdW1lIHRoZSBzb3VyY2Uvb3V0cHV0IHByb2plY3Rpb24gaXMgaW4gTWFzc2FjaHVzZXR0cyBNYWlubGFuZCBVUyBGdC4gIDxiPk5vdGU6PC9iPiBBbGwgU3BhdGlhbCBSZWYgU3lzdGVtcyBjYW4gYmUgZm91bmQgaW4gdGhlIHNwYXRpYWxfcmVmX3N5cyB0YWJsZSBvZiBQb3N0R0lTIG9yIHRoZSBEYXRhL2djcy5jc3YgZmlsZSBvZiB5b3VyIEZXIFRvb2xzIGluc3RhbGwuPC9QPgoKPGgyPkNvbnZlcnNpb25zIGZyb20gUG9zdEdJUyB0byBPdGhlciBmb3JtYXRzPC9oMj4KPGgzPkNvbnZlcnNpb24gZnJvbSBQb3N0R0lTIHRvIEVTUkkgU2hhcGU8L2gzPgo8UD5UaGUgPGI+cGdzcWwyc2hwPC9iPiBhbmQgPGI+c2hwMnBnc3FsPC9iPiBhcmUgdXN1YWxseSB0aGUgYmVzdCB0b29scyBmb3IgY29udmVydGluZyBiYWNrIGFuZCBmb3J0aCBiZXR3ZWVuIFBvc3RHSVMgYW5kIEVTUkkgZm9yIDIgbWFpbiByZWFzb25zLgoKPFVMPjxMST5JdCBoYXMgZmV3ZXIgaWRpb3N5bmNyYWNpZXMgd2hlbiBjb252ZXJ0aW5nIGRhdGE8L0xJPgo8TEk+SXQgaGFzIGEgbG90IGZld2VyIGRlcGVuZGVuY2llcyBzbyBjYW4gZml0IG9uIHlvdXIgZmxvcHB5LjwvTEk+CjwvVUw+PC9QPgo8YnIgLz48YnIgLz4KPFA+SWYgeW91IHJlYWxseSB3YW50IHRvIHVzZSBPZ3IyT2dyIGZvciB0aGlzIGtpbmQgb2YgY29udmVyc2lvbiwgYmVsb3cgaXMgdGhlIHN0YW5kYXJkIHdheSB0byBkbyBpdDwvUD4KPGJyIC8+CjxDT0RFPm9ncjJvZ3IgLWYgIkVTUkkgU2hhcGVmaWxlIiBteWRhdGEuc2hwIFBHOiJob3N0PW15aG9zdCB1c2VyPW15bG9naW5uYW1lIGRibmFtZT1teWRibmFtZSBwYXNzd29yZD1teXBhc3N3b3JkIiAibXl0YWJsZSI8L0NPREU+CjxCciAvPjxiciAvPgo8aDQ+U2VsZWN0aW5nIHNwZWNpZmljIGZpZWxkcywgc2V0cyBvZiBkYXRhICBhbmQgR2VvbWV0cnk8L2g0Pgo8UD5Tb21ldGltZXMgeW91IGhhdmUgbW9yZSB0aGFuIG9uZSBnZW9tZXRyeSBmaWVsZCBpbiBhIHRhYmxlLCBhbmQgRVNSSSBzaGFwZSBjYW4gb25seSBzdXBwb3J0IG9uZSBnZW9tZXRyeSBmaWVsZCBwZXIgc2hhcGUuIEFsc28geW91IG1heSBvbmx5IHdhbnQgYSBzdWJzZXQgb2YgZGF0YS4gICBJbiB0aGVzZSBjYXNlcywgeW91IHdpbGwgbmVlZCB0byBzZWxlY3QgdGhlIGdlb21ldHJ5IGZpZWxkIHRvIHVzZS4gIFRoZSBtb3N0IGZsZXhpYmxlIHdheSB0byBkbyB0aGlzIGlzIHRvIHVzZSB0aGUgLXNxbCBjb21tYW5kIHdoaWNoIHdpbGwgdGFrZSBhbnkgc3FsIHN0YXRlbWVudC48L1A+CjxiciAvPgoKPENPREU+b2dyMm9nciAtZiAiRVNSSSBTaGFwZWZpbGUiIG15ZGF0YS5zaHAgUEc6Imhvc3Q9bXlob3N0IHVzZXI9bXlsb2dpbm5hbWUgZGJuYW1lPW15ZGJuYW1lIHBhc3N3b3JkPW15cGFzc3dvcmQiIC1zcWwgIlNFTEVDVCBuYW1lLCB0aGVfZ2VvbSBGUk9NIG5laWdoYm9yaG9vZHMiIDwvQ09ERT4KCjxoND5FeGFtcGxlIHNuaXBwZXQgY29udmVydGluZyBmcm9tIFBvc3RHSVMgdG8gS01MPC9oND4KPENPREU+Cm9ncjJvZ3IgLWYgIktNTCIgbmVpZ2hib3Job29kcy5rbWwgUEc6Imhvc3Q9bXlob3N0IHVzZXI9bXlsb2dpbm5hbWUgZGJuYW1lPW15ZGJuYW1lIHBhc3N3b3JkPW15cGFzc3dvcmQiIC1zcWwgInNlbGVjdCBnaWQsIG5hbWUsIHRoZV9nZW9tIGZyb20gbmVpZ2hib3Job29kcyIKPC9DT0RFPgo8YnIgLz5UaGUgYmVsb3cgb3V0cHV0cyB0aGUgbmVpZ2hib3Job29kIHRhYmxlIHRvIEtNTCBhbmQgc2V0cyB0aGUgS01MIGRlc2NyaXB0aW9uIGZpZWxkIHRvIG5hbWUgb2YgbmVpZ2hib3Job29kPGJyIC8+CjxDT0RFPgpvZ3Iyb2dyIC1mICJLTUwiIG5laWdoYm9yaG9vZHMua21sIFBHOiJob3N0PW15aG9zdCB1c2VyPW15bG9naW5uYW1lIGRibmFtZT1teWRibmFtZSBwYXNzd29yZD1teXBhc3N3b3JkIiBuZWlnaGJvcmhvb2RzIC1kc2NvIE5hbWVGaWVsZD1uYW1lCjwvQ09ERT4KCgo8SDQ+RXhwb3J0aW5nIG11bHRpcGxlIHRhYmxlcyBmcm9tIFBvc3RHSVMgdXNpbmcgT2dyMk9ncjwvSDQ+CjxQPk9uZSB3YXkgaW4gd2hpY2ggb2dyMm9nciBleGNlbHMgYWJvdmUgdXNpbmcgdGhlIHBnc3FsMnNocCB0b29sIGlzIHRoYXQgb2dyMm9nciBjYW4gZXhwb3J0IG11bHRpcGxlIHRhYmxlcyBhdCBvbmNlLiAgClRoaXMgaXMgcHJldHR5IGhhbmR5IGZvciBzaGFyaW5nIHlvdXIgcG9zdGdpcyBkYXRhIHdpdGggb3RoZXJzIHdobyBkbyBub3QgaGF2ZSBhIHBvc3RnaXMgZGF0YWJhc2UuCjwvUD4KPFA+VGhlIGNvZGUgYmVsb3cgd2lsbCBleHBvcnQgYWxsIHlvdXIgcG9zdGdpcyB0YWJsZXMgb3V0IGludG8gYSBmb2xkZXIgY2FsbGVkIDxpPm15ZGF0YWR1bXA8L2k+IGluIEVTUkkgc2hhcGUgKHNocCkgZm9ybWF0LjwvUD4KCjxDT0RFPgoJb2dyMm9nciAtZiAiRVNSSSBTaGFwZWZpbGUiIG15ZGF0YWR1bXAgUEc6Imhvc3Q9bXlob3N0IHVzZXI9bXlsb2dpbm5hbWUgZGJuYW1lPW15ZGJuYW1lIHBhc3N3b3JkPW15cGFzc3dvcmQiCjwvQ09ERT4KPFA+VGhlIGNvZGUgYmVsb3cgd2lsbCBleHBvcnQgYWxsIHlvdXIgcG9zdGdpcyB0YWJsZXMgb3V0IGludG8gYSBmb2xkZXIgY2FsbGVkIDxpPm15ZGF0YWR1bXA8L2k+IGluIE1hcEluZm8gLnRhYiBmb3JtYXQuPC9QPgo8Q09ERT4KCW9ncjJvZ3IgLWYgIk1hcEluZm8gRmlsZSIgbXlkYXRhZHVtcCBQRzoiaG9zdD1teWhvc3QgdXNlcj1teWxvZ2lubmFtZSBkYm5hbWU9bXlkYm5hbWUgcGFzc3dvcmQ9bXlwYXNzd29yZCIKPC9DT0RFPgoKPFA+Tm93IG1vc3Qgb2YgdGhlIHRpbWUgeW91IHByb2JhYmx5IG9ubHkgd2FudCB0byBvdXRwdXQgYSBzdWJzZXQgb2YgeW91ciBwb3N0Z2lzIHRhYmxlcyByYXRoZXIgdGhhbiBhbGwgeW91ciB0YWJsZXMuICBUaGlzIGNvZGUgZXhwb3J0cyBvbmx5IHRoZSBuZWlnaGJvcmhvb2RzIGFuZCBwYXJjZWxzIHRhYmxlcyB0byBhIGZvbGRlciBjYWxsZWQgPGk+bXlkYXRhZHVtcDwvaT4gaW4gRVNSSSBzaGFwZWZpbGUgZm9ybWF0Cgo8L1A+CjxDT0RFPgoJb2dyMm9nciAtZiAiRVNSSSBTaGFwZWZpbGUiIG15ZGF0YWR1bXAgUEc6Imhvc3Q9bXlob3N0IHVzZXI9bXlsb2dpbm5hbWUgZGJuYW1lPW15ZGJuYW1lIHBhc3N3b3JkPW15cGFzc3dvcmQiIG5laWdoYm9yaG9vZCBwYXJjZWxzCjwvQ09ERT4KCjxIMj5Db252ZXJzaW9uIGZyb20gVElHRVIgdG8gb3RoZXIgZm9ybWF0czwvSDI+CjxQPlRvcG9sb2dpY2FsbHkgSW50ZWdyYXRlZCBHZW9ncmFwaGljIEVuY29kaW5nIGFuZCBSZWZlcmVuY2luZyBzeXN0ZW0gKFRJR0VSKSBpcyB0aGUgVVMgQ2Vuc3VzIEJ1cmVhdXMgcHJvcHJpZXRhcnkgZm9ybWF0IGZvciBleHBvcnRpbmcgVVMgQ2Vuc3VzIGdlb2dyYXBoaWMgYW5kIHN0YXRpc3RpY2FsIGRhdGEuICAgU3RhcnRpbmcgaW4gMjAwNywgdGhleSB3aWxsIGJlIHVzaW5nIEVTUkkgU2hhcGVmaWxlIChTSFApIGFzIHRoZXJlIG9mZmljaWFsIGV4cG9ydCBmb3JtYXQuICAgU28gdGhpcyBzZWN0aW9uIG1heSBiZSBhIGJpdCBvYnNvbGV0ZSBmb3IgdGhlIHVwY29taW5nIHZlcnNpb25zLgo8L1A+Cgo8UD5UbyBnZXQgdGhlIGZpbGVzIGZvciB5b3VyIGxvY2F0aW9uIC0geW91IGNhbiBicm93c2UgdGhlaXIgYXJjaGl2ZSBhdCAKPGEgaHJlZj0iaHR0cDovL3d3dy5jZW5zdXMuZ292L2dlby93d3cvdGlnZXIvaW5kZXguaHRtbCIgdGFyZ2V0PV9ibGFuaz5odHRwOi8vd3d3LmNlbnN1cy5nb3YvZ2VvL3d3dy90aWdlci9pbmRleC5odG1sPC9hPjwvUD4KCjxIMz5SZWFkaW5nIHRoZSBtZXRhIGRhdGEgdXNpbmcgb2dyaW5mbzwvSDM+PGJyIC8+Cgo8Q09ERT4KICAgb2dyaW5mbyBUR1IyNTAyNS5SVEkKPC9DT0RFPgoKPEgzPkNvbnZlcnNpb24gZnJvbSBUaWdlciB0byBFU1JJIHNoYXBlPC9IMz4KPEg0PkdpdmUgbWUgYWxsIGxheWVycyBpbiBUR1IyNTAyNTwvSDQ+CjxQPlRoZSB0aWdlciBmaWxlcyBjb250YWluIGEgc2V0IG9mIGxheWVycywgc28gdW5saWtlIHRoZSBvdGhlciBvdXRwdXRzIHdlIGhhdmUgZG9uZSwgd2Ugd2lsbCBzcGVjaWZ5IGEgZm9sZGVyIHRvIGR1bXAgYWxsIHRoZSBsYXllcnMgaW50bwo8L1A+CjxDT0RFPm9ncjJvZ3IgLWYgIkVTUkkgU2hhcGVmaWxlIiBtYXN1ZmZvbGsgVEdSMjUwMjUuUlRJPC9DT0RFPgoKPGJyIC8+PGJyIC8+CjxiPk5vdGU6PC9iPiBUaGUgYWJvdmUgb3V0cHV0cyBhbGwgdGhlIHRpZ2VyIGxheWVycyBpbiB0aGUgVEdSMjUwMjUgc2V0IGludG8gYSBmb2xkZXIgY2FsbGVkIG1hc3VmZm9sayB0aGF0IHJlc2lkZXMgd2l0aGluIG91ciBkYXRhIGZvbGRlciB0aGF0IHdlIGhhdmUgY2RlZCB0by4KCgo8SDQ+SnVzdCBPbmUgTGF5ZXI8L0g0Pgo8Q09ERT5vZ3Iyb2dyIC1mICJFU1JJIFNoYXBlZmlsZSIgc3VmY29tcC5zaHAgVEdSMjUwMjUuUlQxIGxheWVyIENvbXBsZXRlQ2hhaW48L0NPREU+Cgo8UD5JbiB0aGUgYWJvdmUsIHdlIGFyZSBhc2tpbmcgZm9yIGp1c3QgdGhlIENvbXBsZXRlQ2hhaW4gbGF5ZXIgYW5kIHRvIG91dHB1dCB0byBhIG5ldyBmaWxlIGNhbGxlZCBzdWZjb21wLnNocC4gIE5vdGUgaXQgd2lsbCBvdXRwdXQgc2hwIGFuZCB0aGUgY29ycmVzcG9uZGluZyBzaHgsIGFuZCBwcmogZmlsZXMuCjwvUD4KCjxIMz5Db252ZXJzaW9uIGZyb20gVElHRVIgdG8gTWFwSW5mbzwvSDM+CjxQPlRoZSBjb252ZXJzaW9uIGZvbGxvd3MgYSBzaW1pbGFyIHBhdGggdG8gRVNSSSBTaGFwZTwvUD4KPEg0PkFsbCBMYXllcnMgLSBFYWNoIExheWVyIGFzIGEgc2luZ2xlIGZpbGU8L0g0Pgo8UD5UaGUgYmVsb3cgd2lsbCBjcmVhdGUgYSBmb2xkZXIgbWFzdWYgYW5kIG91dHB1dCBhbGwgdGhlIGxheWVycyBpbnRvIHRoYXQgZm9sZGVyIGFuZCBnaXZlIGVhY2ggYSB0YWIgZmlsZSBleHRlbnNpb248L1A+CjxiciAvPgoKPENPREU+b2dyMm9nciAtZiAiTWFwSW5mbyBGaWxlIiBtYXN1ZiBUR1IyNTAyNS5SVDE8L0NPREU+Cgo8SDQ+U2luZ2xlIExheWVyIC0gU2luZ2xlIEZpbGU8L0g0Pgo8Q09ERT5vZ3Iyb2dyIC1mICJNYXBJbmZvIEZpbGUiIHN1ZmNvbXAudGFiIFRHUjI1MDI1LlJUMSBsYXllciBDb21wbGV0ZUNoYWluPC9DT0RFPgoKPEgzPkNvbnZlcnNpb24gZnJvbSBUaWdlciB0byBQb3N0R0lTPC9IMz4KPENPREU+b2dyMm9nciAtdXBkYXRlIC1hcHBlbmQgLWYgIlBvc3RHcmVTUUwiIFBHOiJob3N0PW15c2VydmVyIHVzZXI9bXl1c2VybmFtZSBkYm5hbWU9bXlkYm5hbWUgcGFzc3dvcmQ9bXlwYXNzd29yZCIgVEdSMjUwMjUuUlQxIGxheWVyIENvbXBsZXRlQ2hhaW4gLW5sbiBtYXN1ZiAgLWFfc3JzICJFUFNHOjQyNjkiCjwvQ09ERT4KCjxQPk5vdGUgaW4gdGhlIGFib3ZlIHdlIG5lZWRlZCB0byBwdXQgdGhlIC11cGRhdGUgLWFwcGVuZCBvcHRpb24gYmVjYXVzZSBPR1IyT0dSIHdpbGwgdHJ5IHRvIGNyZWF0ZSBhIGZvbGRlciBpZiBnaXZlbiBhIGZpbGUgd2l0aCBubyBleHRlbnNpb24sIHdoaWNoIHRyYW5zbGF0ZXMgdG8gY3JlYXRpbmcgYSBuZXcgZGF0YWJhc2UuICA8L1A+Cgo8UD5XZSBhbHNvIHB1dCBpbiB0aGUgPGI+LW5sbiBtYXN1ZjwvYj4gdG8gcHJldmVudCBPR1IyT0dSIGZyb20gY3JlYXRpbmcgdGhlIHRhYmxlIG5hbWUgYXMgQ29tcGxldGVDaGFpbjwvUD4KCjxQPkxhc3RseSB3ZSBwdXQgaW4gRVBTRzo0MjY5IHRvIHRlbGwgT0dSIHRvIGp1c3QgYXNzdW1lIFRpZ2VyIGlzIGluIE5BRCA4MyBsb25nIGxhdC4gIFdpdGhvdXQgdGhpcyBpdCBjcmVhdGVzIGFuIGVudHJ5IGluIHRoZSBzcGF0aWFsX3JlZl9zeXMgdGFibGUgd2hpY2ggaXMgZXF1aXZhbGVudCB0byB0aGUgYWxyZWFkeSBleGlzdGluZyB3ZWxsIGtub3duIDQyNjkuCjwvUD4KCjxoMj5FU1JJIEdlb0RhdGFiYXNlIChNREIgZm9ybWF0KTwvaDM+CjxQPkZXVG9vbHMgYXQgbGVhc3QgZm9yIHdpbmRvd3MsIGhhcyB0aGUgRVNSSSBHZW9kYXRhYmFzZSBkcml2ZXIgKHJlZmVycmVkIHRvIGFzIFBHZW8gZm9yIFBlcnNvbmFsIEdlb2RhdGFiYXNlKSBiYWtlZCBpbnRvIHRoZSBiaW5hcnkuICBUaGlzIG1ha2VzIGl0IHJlbGF0aXZlbHkgc2ltcGxlIHRvIGV4cG9ydCBkYXRhIG91dCBvZiB0aGUgUGVyc29uYWwgR2VvZGF0YWJhc2UKZm9ybWF0IGludG8gb3RoZXIgZm9ybWF0cyBzdWNoIGFzIFBvc3RncmVTUUwgb3IgRVNSSSBTaGFwZTwvUD4KCjxwPklmIHlvdSB3YW50IGEgc2FtcGxlIGdlbyBkYXRhYmFzZSB0byBwbGF5IHdpdGgsIHRyeSB0aGUgPGEgaHJlZj0iaHR0cDovL3d3dy5tYXNzLmdvdi9tZ2lzL2Z0cGdubS5odG0iIHRhcmdldD0iX2JsYW5rIj5NYXNzR0lTIGFubm90YXRpb24gcGVyc29uYWwgZ2VvIGRhdGFiYXNlIGh0dHA6Ly93d3cubWFzcy5nb3YvbWdpcy9mdHBnbm0uaHRtPC9hPiAKCjxoMz5TZWUgbGlzdCBvZiBGZWF0dXJlIENsYXNzZXM8L2gzPgo8Q09ERT4Kb2dyaW5mbyBDOlxHSVNEYXRhXEdlb25hbWVzLm1kYgo8L0NPREU+CjxwcmU+CklORk86IE9wZW4gb2YgYGM6XEdJU0RhdGFcR2VvbmFtZXMubWRiJwogICAgICB1c2luZyBkcml2ZXIgYFBHZW8nIHN1Y2Nlc3NmdWwuCjE6IEdFT05BTUVTX0FOTk9fUExBQ0VTCjI6IEdFT05BTUVTX0FOTk9fSFlEUk8KMzogR0VPTkFNRVNfQU5OT19IWVBTTwo8L3ByZT4KCjxoMz5JbXBvcnQgUGVyc29uYWwgR2VvZGF0YWJhc2UgdG8gUG9zdEdJUzwvaDM+CjxwPlRvIGltcG9ydCBhbGwgZmVhdHVyZSBjbGFzc2VzIGFuZCBhc3NpZ24gYSBwYXJ0aWN1bGFyIHNwYXRpYWwgcmVmPC9wPgo8Q09ERT4Kb2dyMm9nciAtZiAiUG9zdGdyZVNRTCIgUEc6Imhvc3Q9bG9jYWxob3N0IHVzZXI9c29tZXVzZXIgZGJuYW1lPXNvbWVkYiBwYXNzd29yZD1zb21lcGFzc3dvcmQgcG9ydD01NDMyIiBDOlxHSVNEYXRhXEdlb25hbWVzLm1kYiAtYV9zcnMgRVBTRzoyNjk4Ngo8L0NPREU+Cgo8cD5JbXBvcnQgMSBmZWF0dXJlIGNsYXNzIGFuZCByZXByb2plY3QgYW5kIHJlbmFtZSBnZW9tZXRyeSBjb2x1bW4uICBUaGlzIGV4YW1wbGUgYnJpbmdzIGluIGEgZmVhdHVyZSBjbGFzcyB0aGF0IGlzIG9mIHByb2plY3Rpb24gTkFEIDgzIE1BIG1ldGVycyBhbmQgdHJhbnNmb3JtcyB0byBOQUQgODMgbG9uZ2xhdCBhbmQgYWxzbyByZW5hbWVzIHRoZSBmZWF0dXJlCmNsYXNzIG1hX2h5ZHJvPC9wPgo8Q09ERT4Kb2dyMm9nciAtZiAiUG9zdGdyZVNRTCIgUEc6Imhvc3Q9bG9jYWxob3N0IHVzZXI9c29tZXVzZXIgZGJuYW1lPXNvbWVkYiIgQzpcRGF0YVxHZW9uYW1lcy5tZGIgR0VPTkFNRVNfQU5OT19IWURSTyAtYV9zcnMgRVBTRzoKMjY5ODYgLXRfc3JzIEVQU0c6NDI2OSAtbmxuIG1hX2h5ZHJvIC1sY28gR0VPTUVUUllfTkFNRT10aGVfZ2VvbV80MjY5CjwvQ09ERT4KCgo8aDI+SW1wb3J0aW5nIGZyb20gRVNSSSBTaGFwZSB0byBNeVNRTDwvaDM+CjxQPk15U1FMIDQgYW5kIDUgc3VwcG9ydCBzcGF0aWFsIG9iamVjdHMgdG8gYSBsaW1pdGVkIGV4dGVudC4gIFRoZSBmdW5jdGlvbmFsaXR5IGlzIG5vdCBhcyByaWNoIGFzIFBvc3RHSVMsIGJ1dCBmb3IgYmFzaWMgbWFwcGluZyB3b3JrIGFuZCBsaW1pdGVkIHNwYXRpYWwgYW5hbHlzaXMsIGFuZCBpZiB5b3UgYWxyZWFkeSBoYXZlIE15U1FMIGluc3RhbGxlZCwgaXQgbWF5IHN1aXQgeW91ciBuZWVkcyBqdXN0IGZpbmUuICBCZWxvdyBpcyBhIHNuaXBwZXQgb2YgY29kZSB0aGF0IHdpbGwgaW1wb3J0IGEgc2hhcGUgZmlsZSBjYWxsZWQgPGVtPndvcmxkX2FkbTAuc2hwPC9lbT4gaW50byBhIE15U1FMIGRhdGFiYXNlIGFuZCB3aWxsIHJlbmFtZSBpdCA8ZW0+d29ybGQ8L2VtPi4gIE5PVEU6IHRoYXQgaWYgeW91IGhhdmUgYSB2aXJnaW4gTXlTUUwgIGRhdGFiYXNlIHdpdGggbm8gZ2VvbWV0cnlfY29sdW1ucyBvciBzcGF0aWFsX3JlZl9zeXMgdGFibGUsIHRoZW4gdGhvc2Ugd2lsbCBhdXRvbWF0aWNhbGx5IGJlIGNyZWF0ZWQuCjwvUD4KCjxDT0RFPgpvZ3Iyb2dyIC1mICJNeVNRTCIgIE1ZU1FMOiJteWRiLGhvc3Q9bXlob3N0LHVzZXI9bXlsb2dpbixwYXNzd29yZD1teXBhc3N3b3JkLHBvcnQ9MzMwNiIgLW5sbiAid29ybGQiIC1hX3NycyAiRVBTRzo0MzI2IiBwYXRoL3RvL3dvcmxkX2FkbTAuc2hwCjwvQ09ERT4KCjxoMj5Vc2luZyBPR1IgdG8gSW1wb3J0IE5vbi1zcGF0aWFsIERhdGE8L2gyPgo8UD5XaGlsZSBPR1Igd2FzIGRlc2lnbmVkIHByaW1hcmlseSB0byB0cmFuc2Zvcm0gZGF0YSBiZXR3ZWVuIGRpZmZlcmVudCBzcGF0aWFsIGRhdGFzb3VyY2VzLCBpdCBpcyBhIGxpdHRsZSBrbm93biBmYWN0IHRoYXQgaXQKY2FuIGJlIHVzZWQgYXMgd2VsbCBmb3IgaW1wb3J0aW5nIG5vbi1zcGF0aWFsIGRhdGFzb3VyY2VzIHN1Y2ggYXMgRGJhc2UgZmlsZXMgYW5kIENTViBmaWxlcy4gPC9QPgoKPGgzPkltcG9ydGluZyBEYmFzZSBmaWxlIGludG8gUG9zdGdyZVNRTCB1c2luZyBPZ3IyT2dyPC9oMz4KPFA+SW4gdGhlIGJlbG93IGV4YW1wbGUsIHdlIHdpbGwgZGVtb25zdHJhdGUgaW1wb3J0aW5nIGEgRGJhc2UgZmlsZSBpbnRvIFBvc3RncmVTUUwgdXNpbmcgT0dSMk9HUjwvUD4KPENPREU+b2dyMm9nciAtZiAiUG9zdGdyZVNRTCIgUEc6Imhvc3Q9bXlzZXJ2ZXIgdXNlcj1teXVzZXJuYW1lIGRibmFtZT1teWRibmFtZSBwYXNzd29yZD1teXBhc3N3b3JkIiBzb21ldGFibGUuZGJmIC1ubG4gInNvbWV0YWJsZSI8L0NPREU+PGJyIC8+PGJyIC8+PGEgaHJlZj0iRmVlZEJhY2suYXNweD9jb250ZW50X2lkPTQxIj5Qb3N0IENvbW1lbnRzIEFib3V0IE9HUjJPR1IgQ2hlYXRzaGVldDwvYT5kZAICDxYCHwAFOmh0dHA6Ly93d3cuYm9zdG9uZ2lzLmNvbS9HSVNDb21tZW50c1Jzcy5hc3B4P2NvbnRlbnRfaWQ9NDFkAgUPFgIfAAUIZ2RhbCBnaXNkGAIFIWN0bDAwJGNwaE1haW4kZGdyZWxhdGVkX3Jlc291cmNlcw88KwAKAQgCAWQFGGN0bDAwJGNwaE1haW4kZGdDb21tZW50cw88KwAKAQgCAWSa2w/cG/wDoQyX0xfHjBFQu1gA6Q=="> +</div> + + + <div id="outer"> + <table align="center" width="100%"> + <tbody><tr valign="top"> + <td width="10%" valign="center"> </td> + <td width="90%" align="left"> + + <img src="./ import mapinfo_files/rss.png" alt="GIS Article comments" border="0"> Comments Rss <br> + <span id="ctl00_cphMain_BodyContent"><div id="hdr"><span class="headertitle">OGR2OGR Cheatsheet</span></div><h1>OGR Tools</h1> +<p>The OGR toolkit is a subkit of the FW Tools Toolkit. The FW Tools Toolkit is a toolkit available in both Linux and Windows executable form as well as source code form. +It has several command line tools. The ones we find most useful are: +</p><ul> +<li><b>OgrInfo</b> - inspects a GIS datasource and spits out summary data or detailed information about the layers, kinds of geometries found in the file.</li> + +<li><b>Ogr2Ogr</b> - this is a command line tool that converts one Ogr defined data source to another Ogr data source. Ogr supports multiple data formats: ESRI Shapefile, MapInfo Tab file, TIGER, s57, DGN, CSV, DBF, GML, KML, Interlis, SQLite, ODBC, ESRI GeoDatabase (MDB format), PostGIS/PostgreSQL, MySQL . </li> +</ul> + +<p>These 2 command line tools can be found in the <b>bin</b> folder of your FWTools install. To start using these tools +</p><ol><li>Install the <a href="http://fwtools.maptools.org/" target="_blank">FW Tools</a> tool kit.</li> +<li>Launch the <b>FW Tools Shell</b> - in windows this is found under Start->Programs->FW Tools ..</li> +<li>From the shell - cd into your directory that has the data you want to convert</li> +<p></p> + +<h2>Getting more Help</h2> +<p>If you want a comprehensive listing of options offered by <b>ogr2ogr</b> or <b>ogrinfo</b>, run the following at the FW Tools Shell. </p> +<pre><code>ogr2ogr --help +ogrinfo --help +</code> +</pre> + +<h2>Conversions from MapInfo to Other formats</h2> +<h3>Conversion from MapInfo to ESRI Shape</h3> + +<code>ogr2ogr -f "ESRI Shapefile" mydata.shp mydata.tab</code> +<h3>Conversion from MapInfo to PostGIS</h3> +<code>ogr2ogr -f "PostgreSQL" PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" mytabfile.tab</code> + +<p>Note: for the above, you can leave out the host if its localhost and user and password if you have your authentication set to trust.</p> + +<b>Importing as a different table name</b> +<p>In the below example, we don't want OGR to create a table called <b>mytable</b>. We instead want to call the table something different like <b>newtablename</b>. To do so we use the <b>nln</b> option. + +<br><br> +<code>ogr2ogr -f "PostgreSQL" PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" mytabfile.tab -nln newtablename</code> +</p> + + +<h3>When OGR guesses wrong or fails to guess</h3> +<p>Sometimes OGR does not output the right projection, particularly with Units of Feet or data that has no projection info or the projection information can't be easily translated to your system. Sometimes OGR can't match the projection to one in your spatial_ref_sys table so creates a new entry in that table. In these cases you have to tell OGR what the output projection is. You do this with the <b>-a_srs</b> flag. +<br><br> +<code>ogr2ogr -f "PostgreSQL" -a_srs "EPSG:2249" PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" mytabfile.tab</code> +</p> + +<p>In the above example I told OGR2OGR to assume the source/output projection is in Massachusetts Mainland US Ft. <b>Note:</b> All Spatial Ref Systems can be found in the spatial_ref_sys table of PostGIS or the Data/gcs.csv file of your FW Tools install.</p> + +<h2>Conversions from PostGIS to Other formats</h2> +<h3>Conversion from PostGIS to ESRI Shape</h3> +<p>The <b>pgsql2shp</b> and <b>shp2pgsql</b> are usually the best tools for converting back and forth between PostGIS and ESRI for 2 main reasons. + +</p><ul><li>It has fewer idiosyncracies when converting data</li> +<li>It has a lot fewer dependencies so can fit on your floppy.</li> +</ul><p></p> +<br><br> +<p>If you really want to use Ogr2Ogr for this kind of conversion, below is the standard way to do it</p> +<br> +<code>ogr2ogr -f "ESRI Shapefile" mydata.shp PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" "mytable"</code> +<br><br> +<h4>Selecting specific fields, sets of data and Geometry</h4> +<p>Sometimes you have more than one geometry field in a table, and ESRI shape can only support one geometry field per shape. Also you may only want a subset of data. In these cases, you will need to select the geometry field to use. The most flexible way to do this is to use the -sql command which will take any sql statement.</p> +<br> + +<code>ogr2ogr -f "ESRI Shapefile" mydata.shp PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" -sql "SELECT name, the_geom FROM neighborhoods" </code> + +<h4>Example snippet converting from PostGIS to KML</h4> +<code> +ogr2ogr -f "KML" neighborhoods.kml PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" -sql "select gid, name, the_geom from neighborhoods" +</code> +<br>The below outputs the neighborhood table to KML and sets the KML description field to name of neighborhood<br> +<code> +ogr2ogr -f "KML" neighborhoods.kml PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" neighborhoods -dsco NameField=name +</code> + + +<h4>Exporting multiple tables from PostGIS using Ogr2Ogr</h4> +<p>One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once. +This is pretty handy for sharing your postgis data with others who do not have a postgis database. +</p> +<p>The code below will export all your postgis tables out into a folder called <i>mydatadump</i> in ESRI shape (shp) format.</p> + +<code> + ogr2ogr -f "ESRI Shapefile" mydatadump PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" +</code> +<p>The code below will export all your postgis tables out into a folder called <i>mydatadump</i> in MapInfo .tab format.</p> +<code> + ogr2ogr -f "MapInfo File" mydatadump PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" +</code> + +<p>Now most of the time you probably only want to output a subset of your postgis tables rather than all your tables. This code exports only the neighborhoods and parcels tables to a folder called <i>mydatadump</i> in ESRI shapefile format + +</p> +<code> + ogr2ogr -f "ESRI Shapefile" mydatadump PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" neighborhood parcels +</code> + +<h2>Conversion from TIGER to other formats</h2> +<p>Topologically Integrated Geographic Encoding and Referencing system (TIGER) is the US Census Bureaus proprietary format for exporting US Census geographic and statistical data. Starting in 2007, they will be using ESRI Shapefile (SHP) as there official export format. So this section may be a bit obsolete for the upcoming versions. +</p> + +<p>To get the files for your location - you can browse their archive at +<a href="http://www.census.gov/geo/www/tiger/index.html" target="_blank">http://www.census.gov/geo/www/tiger/index.html</a></p> + +<h3>Reading the meta data using ogrinfo</h3><br> + +<code> + ogrinfo TGR25025.RTI +</code> + +<h3>Conversion from Tiger to ESRI shape</h3> +<h4>Give me all layers in TGR25025</h4> +<p>The tiger files contain a set of layers, so unlike the other outputs we have done, we will specify a folder to dump all the layers into +</p> +<code>ogr2ogr -f "ESRI Shapefile" masuffolk TGR25025.RTI</code> + +<br><br> +<b>Note:</b> The above outputs all the tiger layers in the TGR25025 set into a folder called masuffolk that resides within our data folder that we have cded to. + + +<h4>Just One Layer</h4> +<code>ogr2ogr -f "ESRI Shapefile" sufcomp.shp TGR25025.RT1 layer CompleteChain</code> + +<p>In the above, we are asking for just the CompleteChain layer and to output to a new file called sufcomp.shp. Note it will output shp and the corresponding shx, and prj files. +</p> + +<h3>Conversion from TIGER to MapInfo</h3> +<p>The conversion follows a similar path to ESRI Shape</p> +<h4>All Layers - Each Layer as a single file</h4> +<p>The below will create a folder masuf and output all the layers into that folder and give each a tab file extension</p> +<br> + +<code>ogr2ogr -f "MapInfo File" masuf TGR25025.RT1</code> + +<h4>Single Layer - Single File</h4> +<code>ogr2ogr -f "MapInfo File" sufcomp.tab TGR25025.RT1 layer CompleteChain</code> + +<h3>Conversion from Tiger to PostGIS</h3> +<code>ogr2ogr -update -append -f "PostGreSQL" PG:"host=myserver user=myusername dbname=mydbname password=mypassword" TGR25025.RT1 layer CompleteChain -nln masuf -a_srs "EPSG:4269" +</code> + +<p>Note in the above we needed to put the -update -append option because OGR2OGR will try to create a folder if given a file with no extension, which translates to creating a new database. </p> + +<p>We also put in the <b>-nln masuf</b> to prevent OGR2OGR from creating the table name as CompleteChain</p> + +<p>Lastly we put in EPSG:4269 to tell OGR to just assume Tiger is in NAD 83 long lat. Without this it creates an entry in the spatial_ref_sys table which is equivalent to the already existing well known 4269. +</p> + +<h2>ESRI GeoDatabase (MDB format)</h2> +<p>FWTools at least for windows, has the ESRI Geodatabase driver (referred to as PGeo for Personal Geodatabase) baked into the binary. This makes it relatively simple to export data out of the Personal Geodatabase +format into other formats such as PostgreSQL or ESRI Shape</p> + +<p>If you want a sample geo database to play with, try the <a href="http://www.mass.gov/mgis/ftpgnm.htm" target="_blank">MassGIS annotation personal geo database http://www.mass.gov/mgis/ftpgnm.htm</a> + +</p><h3>See list of Feature Classes</h3> +<code> +ogrinfo C:\GISData\Geonames.mdb +</code> +<pre>INFO: Open of `c:\GISData\Geonames.mdb' + using driver `PGeo' successful. +1: GEONAMES_ANNO_PLACES +2: GEONAMES_ANNO_HYDRO +3: GEONAMES_ANNO_HYPSO +</pre> + +<h3>Import Personal Geodatabase to PostGIS</h3> +<p>To import all feature classes and assign a particular spatial ref</p> +<code> +ogr2ogr -f "PostgreSQL" PG:"host=localhost user=someuser dbname=somedb password=somepassword port=5432" C:\GISData\Geonames.mdb -a_srs EPSG:26986 +</code> + +<p>Import 1 feature class and reproject and rename geometry column. This example brings in a feature class that is of projection NAD 83 MA meters and transforms to NAD 83 longlat and also renames the feature +class ma_hydro</p> +<code> +ogr2ogr -f "PostgreSQL" PG:"host=localhost user=someuser dbname=somedb" C:\Data\Geonames.mdb GEONAMES_ANNO_HYDRO -a_srs EPSG: +26986 -t_srs EPSG:4269 -nln ma_hydro -lco GEOMETRY_NAME=the_geom_4269 +</code> + + +<h2>Importing from ESRI Shape to MySQL</h2> +<p>MySQL 4 and 5 support spatial objects to a limited extent. The functionality is not as rich as PostGIS, but for basic mapping work and limited spatial analysis, and if you already have MySQL installed, it may suit your needs just fine. Below is a snippet of code that will import a shape file called <em>world_adm0.shp</em> into a MySQL database and will rename it <em>world</em>. NOTE: that if you have a virgin MySQL database with no geometry_columns or spatial_ref_sys table, then those will automatically be created. +</p> + +<code> +ogr2ogr -f "MySQL" MYSQL:"mydb,host=myhost,user=mylogin,password=mypassword,port=3306" -nln "world" -a_srs "EPSG:4326" path/to/world_adm0.shp +</code> + +<h2>Using OGR to Import Non-spatial Data</h2> +<p>While OGR was designed primarily to transform data between different spatial datasources, it is a little known fact that it +can be used as well for importing non-spatial datasources such as Dbase files and CSV files. </p> + +<h3>Importing Dbase file into PostgreSQL using Ogr2Ogr</h3> +<p>In the below example, we will demonstrate importing a Dbase file into PostgreSQL using OGR2OGR</p> +<code>ogr2ogr -f "PostgreSQL" PG:"host=myserver user=myusername dbname=mydbname password=mypassword" sometable.dbf -nln "sometable"</code><br><br><a href="http://www.bostongis.com/FeedBack.aspx?content_id=41">Post Comments About OGR2OGR Cheatsheet</a><br> <br> + + +<br> + + <a href="http://www.bostongis.com/GISCommentsRss.aspx?content_id=41"> + <br> + <div> + <table cellspacing="0" rules="all" border="1" id="ctl00_cphMain_dgComments" style="background-color:White;width:100%;border-collapse:collapse;"> + <tbody><tr> + <th scope="col"> </th><th scope="col">Commenter</th><th scope="col">Comment</th> + </tr><tr> + <td>11/16/2011 6:14:14 PM</td><td>Heidi Ochis</td><td><a name="comment_406"></a>Any ideas on when or if the ESRI GeoDatabase(gdb)format will be included in the OGR2OGR conversion list?</td> + </tr><tr style="background-color:#EFEFEF;"> + <td>7/6/2011 4:55:58 AM</td><td>Rob</td><td><a name="comment_362"></a>Hello,<br>I am trying to convert a .shp file to a .tab file whilst also only selecting records that have a date field that equals within the last 30 days.<br><br>However I am struggling to filter the data at all on the date field. I have tried using "-where" & "-sql" and I cannot filter the data even on a particular date. I think I must be using the wrong format for dates, but I've tried every combination I can think of.<br><br>Does anyone have any examples of working "-where" or "-sql" clauses on date fields?<br><br>Thanks</td> + </tr><tr> + <td>5/18/2011 12:29:32 PM</td><td>bespin</td><td><a name="comment_349"></a>I'm running 2008 SP1, not R2. I did find that if you include the table name as part of the conn string it works. It won't let me use -sql though so it's a bit less flexible.<br><br>This works : http://pastebin.com/kTDuYg1a</td> + </tr><tr style="background-color:#EFEFEF;"> + <td>5/18/2011 3:24:46 AM</td><td>Regina</td><td><a name="comment_348"></a>Sorry -- no haven't tried. Are you running MSSQL 2008 plain or MSSQL 2008 R2. I recall people having issues with another loader I forget which when using against R2. So I presume there must have been changes between the 2 releases.</td> + </tr><tr> + <td>5/16/2011 2:55:07 PM</td><td>bespin</td><td><a name="comment_347"></a>Have you tried using the latest ogr2ogr (I'm running it from OSGeo4W) with MSSQL 2008 geometery? I'm having problems doing a simple dump to shp. The syntax is similar to what you have for PG.<br><br>Every row returns the error "ERROR 1: GetNextRawFeature(): Corrupt data" The shp comes out with attributes and no geometry.</td> + </tr><tr style="background-color:#EFEFEF;"> + <td>4/28/2011 8:07:54 AM</td><td>Regina</td><td><a name="comment_339"></a>Garret,<br><br>I think you have your arguments confused. a_srs is the assumed projection and t_srs is what you want to transform it to.<br><br>If it still doesn't work make sure OGR2OGR can find you epsg file. As I recall I think the environment variable is GDAL_DATA though install should have put that in.</td> + </tr><tr> + <td>4/27/2011 3:31:48 PM</td><td>garret</td><td><a name="comment_338"></a>hi, great software. However, I cannot get -a_srs to work properly. I've specifed EPSG:29902 but when I add the PostGIS layer in QGIS, the projection is always geographic WGS84... so I have to manually specify the projection.</td> + </tr><tr style="background-color:#EFEFEF;"> + <td>4/25/2011 11:11:12 AM</td><td>Regina</td><td><a name="comment_336"></a>Eriovaldo,<br><br>You need to set the encoding.<br><br>Try setting the environment variable<br>something like this. <br><br>export PGCLIENTENCODING=latin1 <br><br>On windows 7 set it in system -> Control Panel -> System -> Advanced System Settings -> Environment variables </td> + </tr><tr> + <td>4/21/2011 3:03:57 PM</td><td>Eriovaldo</td><td><a name="comment_335"></a>I am using ogr2ogr and I got in trouble with the tool running on DOS - Windows 7.<br>The command does not work fine when using special characters.<br><br>For example:<br><br>Command: INSERT INTO "spatial_treina"."table" ("id", "name")<br>VALUES (5470, '231260', 'SÒo LuÝs do Curu')<br> RETURNING ogc_fid<br>ERROR 1: INSERT command for new feature failed.<br>ERRO: sequ+¬ncia de bytes +® inv+ílida para codifica+º+úo "UTF8": 0xe36f20<br><br>the correct should be: São Luís do Curu.<br><br>How can I configure the DOS in order do not generate this kind of character.<br></td> + </tr><tr style="background-color:#EFEFEF;"> + <td>1/21/2010 10:07:18 PM</td><td>Chris McCarthy</td><td><a name="comment_174"></a>The code suggestion for converting MapInfo to PostGIS didn't work for me because a quotation mark was in the wrong place. It should read: <br><br>ogr2ogr -f "PostgreSQL" "PG:host=myhost user=myloginname dbname=mydbname password=mypassword" mytabfile.tab<br><br>Note the double quote after PG: should be before PG:.<br><br>This dogged me for a whole day.</td> + </tr><tr> + <td>7/17/2009 5:32:28 PM</td><td>Regina</td><td><a name="comment_108"></a>I'm not sure its possible with plain OGR2OGR. I know its doable in UMN Mapserver using the OGR2OGR driver so I assume it must be possible. I'll experiment with this and see what I come up with.<br><br>Is output the folder where your shape and dbf files reside? I suspect for this to work, you need to specifiy the folder name not the shapefile name as you would normally.<br><br>Here is an example of how its done in UMN Mapserver<br><br>http://www.mail-archive.com/mapserver-users@lists.umn.edu/msg13477.html</td> + </tr><tr style="background-color:#EFEFEF;"> + <td>7/10/2009 7:32:07 PM</td><td>KRD</td><td><a name="comment_106"></a>I would like to see the syntax for an OGR2OGR join involving a shapefile and a dbf lookup table. The following syntax should work, but does not:<br><br>SELECT * FROM table1, table2 WHERE table1.field1=table2.fieldA<br><br>Neither JOIN nor LEFT JOIN syntax works either.<br><br>An example of what I really want to do is:<br><br>ogr2ogr -sql "SELECT * FROM soils LEFT JOIN master ON soils.MUKEY = master.MUKEY" output soils.shp<br><br>If I can get the join working, then I can move on to enhance the operation to select only certain field and records (shapes)<br><br>Thanks,</td> + </tr> + </tbody></table> +</div> + <div> + <table cellspacing="0" rules="all" border="1" id="ctl00_cphMain_dgrelated_resources" style="background-color:White;width:100%;border-collapse:collapse;"> + <tbody><tr> + <th scope="col"> </th> + </tr><tr> + <td> + <a href="http://casoilresource.lawr.ucdavis.edu/drupal/node/98" target="_blank">GDAL and OGR: geodata conversion and re-projection tools</a> + <br>Demonstrates using Ogr and GDAL to reproject vector and raster data. This is a tutorial provided by California Soil Resource Lab.</td> + </tr><tr style="background-color:#EFEFEF;"> + <td> + <a href="http://fwtools.maptools.org/" target="_blank">FW Tools - GIS Tool Kit</a> + </td> + </tr><tr> + <td> + <a href="http://www.postgresonline.com/journal/index.php?/archives/31-GDALOGR2OGR-for-Data-Loading.html" target="_blank">GDAL OGR2OGR for Data Loading</a> + <br>Article detailing how to use ogr2ogr for loading non-spatial data into PostgreSQL.</td> + </tr><tr style="background-color:#EFEFEF;"> + <td> + <a href="http://docs.codehaus.org/display/GEOSDOC/Loading+TIGER+basedata" target="_blank">Loading TIGER basedata: GeoServer and PostGIS</a> + <br></td> + </tr> + </tbody></table> +</div> + </a></ol></span></td> + </tr> + <tr class="screen_only"><td> </td> + <td> + + <p class="footerlink"> <a href="http://del.icio.us/post?url=http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet&title=OGR2OGR%20Cheatsheet" target="_blank"><img src="./ import mapinfo_files/delicioussm.gif" alt="Del.icio.us" border="0"> Del.icio.us</a> | <a href="http://reddit.com/submit?url=http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet&title=OGR2OGR%20Cheatsheet" title="Reddit" target="_blank"><img src="./ import mapinfo_files/redditsm.gif" border="0"> Reddit</a> | <a href="http://www.digg.com/submit?phase=2&url=http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet&title=OGR2OGR%20Cheatsheet" title="Submit to Digg" target="_blank"><img src="./ import mapinfo_files/diggsm.gif" alt="Digg" border="0"> Digg</a> | <a href="http://blinklist.com/index.php?Action=Blink/addblink.php&OGR2OGR%20Cheatsheet&Url=http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet" title="BlinkList Submit" target="_blank"><img src="./ import mapinfo_files/blinklistsm.gif" alt="Blinklist" border="0"> BlinkList</a> | <a href="http://furl.net/storeIt.jsp?t=OGR2OGR%20Cheatsheet&u=http://www.bostongis.com/PrinterFriendly.aspx?content_name=ogr_cheatsheet" title="Furl" target="_blank"><img src="./ import mapinfo_files/furlsm.gif" alt="Furl" border="0"> Furl</a> +</p> + </td> + </tr> + </tbody></table> + </div> + + </form> + + <p> + This Document is available under the GNU Free Documentation License 1.2 + <a href="http://www.gnu.org/copyleft/fdl.html">http://www.gnu.org/copyleft/fdl.html</a> & for download at the BostonGIS site http://www.bostongis.com + </p> + <div align="left" id="ftr"> + Boston GIS Copyright 2012 <a href="http://www.paragoncorporation.com/" target="_blank">Paragon Corporation</a> + </div> + </td> +<!-- <td class="screen_only"><script type='text/javascript'> +var amzn_wdgt={widget:'Search'}; +amzn_wdgt.tag='bostongis-20'; +amzn_wdgt.columns='1'; +amzn_wdgt.rows='4'; +amzn_wdgt.width='200'; +amzn_wdgt.showImage='True'; +amzn_wdgt.showPrice='True'; +amzn_wdgt.showRating='True'; +amzn_wdgt.defaultSearchTerm='gdal gis'; + +amzn_wdgt.design='2'; +amzn_wdgt.colorTheme='Default'; +amzn_wdgt.headerTextColor='#FFFFFF'; +amzn_wdgt.outerBackgroundColor='#000000'; +</script> +<script type='text/javascript' src='http://wms.assoc-amazon.com/20070822/US/js/AmazonWidgets.js'></td>--> +</tr> +</tbody></table> + <script type="text/javascript"> + + var _gaq = _gaq || []; + _gaq.push(['_setAccount', 'UA-404903-1']); + _gaq.push(['_trackPageview']); + + (function() { + var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; + ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; + var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); + })(); + +</script> + + + +</body></html>
\ No newline at end of file |