<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1027" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Hi List<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>I notice on the OGR formats page for ESRI Shapefile the following is mentioned:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>================<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Size Issues<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Geometry: The Shapefile format explicitly uses 32bit offsets and so cannot go over 8GB (it actually uses 32bit offsets to 16bit words). Hence, it is is not recommended to use a file size over 4GB.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Attributes: The dbf format does not have any offsets in it, so it can be arbitrarily large.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>================<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Yet on the ESRI website:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>================<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Geometry limitations<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>There is a 2 GB size limit for any shapefile component file, which translates to a maximum of roughly 70 million point features. The actual number of line or polygon features you can store in a shapefile depends on the number of vertices in each line or polygon (a vertex is equivalent to a point).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>================<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>I assume the OGR web page is wrong, or has a different meaning outside of ESRI S/W use.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>I notice that the PostGIS utility pgsql2shp stops processing with an error once the dbf file goes over 2GB. Is there any way to get ogr2ogr to do this?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Ideally, something I can’t find a lot of information about online, is there a way to get ogr2ogr to start writing to a new shapefile at a certain processing point (number of objects or file size)?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Alternatively, assuming the OGR website text is correct for files it creates, is there any utility that could be used to split the created shapefile files into ones with a size less than 2GB?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Thanks in advance<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'>Darren<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></p><p class=MsoNormal><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Line_x0020_2" o:spid="_x0000_s1026" type="#_x0000_t75" style='position:absolute;margin-left:-16.15pt;margin-top:13.2pt;width:7.5pt;height:179.25pt;z-index:251659264;visibility:visible;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;mso-position-horizontal:absolute;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:text;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page'>
<v:imagedata src="cid:image001.png@01CEE9CB.06164A00" o:title="" />
<o:lock v:ext="edit" aspectratio="f" />
</v:shape><![endif]--><![if !vml]><span style='mso-ignore:vglayout;position:absolute;z-index:251659264;margin-left:-22px;margin-top:18px;width:10px;height:239px'><img width=10 height=239 src="cid:image001.png@01CEE9CB.06164A00" v:shapes="Line_x0020_2"></span><![endif]><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-GB'>Darren Carman</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#5F5F5F;mso-fareast-language:EN-GB'><br>Senior Software Engineer<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#5F5F5F;mso-fareast-language:EN-GB'>GEO-Information Services<o:p></o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#5F5F5F;mso-fareast-language:EN-GB'><o:p> </o:p></span></b></p><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-GB'>Astrium Services</span></b><b><span lang=DE style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D;mso-fareast-language:EN-GB'><o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#5F5F5F;mso-fareast-language:EN-GB'>Tel +44 (0)1252 362138<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#5F5F5F;mso-fareast-language:EN-GB'><a href="http://www.infoterra.co.uk"><span style='color:blue'>http://www.astrium-geo.com</span></a><o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p></div><!--qsdbegin-->
<p> </p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Infoterra Ltd. </span><span style='font-size:7.5pt;font-family:
"Arial","sans-serif";color:black'>Is part of the Astrium GEO-Information Services Division and a wholly owned subsidiary of Astrium, Europe's leading space systems and services specialist.<br>
<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>Disclaimer. </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif";
color:#666666'>The information contained in this e-mail and its attachments are
confidential and intended only for the use of the named addressee(s). If you
are not the intended addressee, please do not read, copy, use or disclose this
message or its attachments. If you have received this message in error, please
notify the sender immediately and delete or destroy all copies of this message
and attachments in all media. Any views or opinions expressed are solely those
of the author and do not necessarily represent those of Infoterra Ltd and shall
not form part of any binding agreement.<br>
<br>
Infoterra Limited a company registered in <st1:country-region w:st="on"><st1:place
w:st="on">England</st1:place></st1:country-region> under number 2359955 and
having its registered office at Europa House, <st1:address w:st="on"><st1:Street
w:st="on">Southwood Crescent</st1:Street>, <st1:City w:st="on">Farnborough</st1:City>,
<st1:PostalCode w:st="on">GU14 0NL</st1:PostalCode></st1:address>. VAT number
GB 476 0468 27. <br>
<br>
</span><span style='font-size:10.0pt;font-family:Webdings;color:#009900'>P </span><span
style='font-size:7.5pt;font-family:"Tahoma","sans-serif";color:#009900'>Before
printing, think about the environment </span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<!--qsdend--><br></body></html>