[OSM-dev] A new way to split the planet

Paul Johnson baloo at ursamundi.org
Sun Aug 16 03:15:46 BST 2009


On Fri, 2009-08-14 at 20:07 +0200, Nic Roets wrote:

> 3. Use an OO spreadsheet to choose the rectangles (density4.ods). OO
> will makes it quite easy: As you drag to highlight a rectangle, it
> will display the sum (of nodes) in the status bar. This way you can
> see how much data will be in the rectangle. I stayed below 14,000,000
> which works out at .osm.gz of less than 300MB and gosmore files of
> less than 400MB. It also works well if you compose expressions like
> MAX(SUM(A1:K12);SUM(D9:M21)), because you can hit F2 to see how the
> rectangles overlap and even change them. I ended up with 58
> rectangles, which will increase as the planet gets larger.

For the sake of simplicity for someone who isn't a spreadsheet nerd,
would it be possible to get the relevant cell ranges named?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20090815/b7137ad6/attachment.pgp>


More information about the dev mailing list