<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif;" dir="ltr">
<p>.. one caveat though is that it doesn't do relations: only nodes and ways (linear and polygon).</p>
<p><br>
</p>
<p>It was really written for the Freemap site so doesn't cover all use cases, but may be interesting.</p>
<p><br>
</p>
<p>Nick<br>
</p>
<p><br>
</p>
<p><br>
<strong><font size="1"><font face="Trebuchet MS,sans-serif"></font></font></strong></p>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Nick Whitelegg<br>
<b>Sent:</b> 16 May 2017 09:07:57<br>
<b>To:</b> dev@openstreetmap.org<br>
<b>Subject:</b> Re: [OSM-dev] Planet file with preprocessed lines/polygons</font>
<div> </div>
</div>
<div>
<meta content="text/html; charset=UTF-8">
<style type="text/css" style="">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p><br>
</p>
<p>Hello Christoph,</p>
<p><br>
</p>
<p>I do have some code which gives GeoJSON from a standard OSM PostGIS database as a web service, if you're interested.</p>
<p><br>
</p>
<p>This code is available as part of the Freemap repository:</p>
<p><br>
</p>
<p><a href="https://github.com.nickw1/Freemap/" class="x_OWAAutoLink" id="LPlnk85365">https://github.com.nickw1/Freemap/</a></p>
<p><br>
</p>
<p>Not sure if you understand PHP but the files you're interested in are in the "ws" directory, tsvr.php (which takes in tile x,y,z parameters) and bsvr.php (which takes in a bounding box of arbitrary projection, plus input and output SRIDs (projection identifiers).</p>
<p><br>
</p>
<p>Let me know if you're interested in this and would like to install it on your server.<br>
</p>
<p><br>
</p>
<p>Nick<br>
</p>
<p><br>
</p>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); font-family:Calibri,Arial,Helvetica,sans-serif,"EmojiFont","Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols; font-size:12pt">
<p></p>
<div style="margin:0px"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt"><font face="Trebuchet MS,sans-serif" size="1"><span style="font-size:8pt"><strong>Nick Whitelegg</strong></span>
</font></span></font></div>
<div style="margin:0px"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt"><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><strong><font color="#000000">Senior Lecturer in Computing (Internet)</font></strong> </span>
</font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><b>|</b></span>
</font><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">School of Media Arts and Technology</span></font></span>
</font></div>
<div style="margin:0px"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt"><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">Southampton Solent University<font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"> </span>
</font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><b>|</b></span>
</font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"></span></font>RM424</span>
</font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"></span></font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><b>|</b></span>
</font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"></span></font><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">East Park Terrace</span>
</font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"></span></font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><b>|</b></span>
</font><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">Southampton SO14 0YN</span></font>
</span></font></div>
<div style="margin:0px"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt"><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">T: 023 8201 3075
</span></font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><b>|</b></span></font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt">
</span></font><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">E:
<a href="mailto:nick.whitelegg@solent.ac.uk" target="_blank" id="LPNoLP">nick.whitelegg@solent.ac.uk</a></span></font><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">
</span></font><font face="Trebuchet MS,sans-serif" color="red" size="1"><span style="font-size:8pt"><b>|</b></span></font><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt"> W:
</span></font><a href="http://www.solent.ac.uk/" target="_blank" id="LPNoLP"><font face="Trebuchet MS,sans-serif" size="1"><span style="font-size:8pt">solent.ac.uk</span></font></a><font face="Trebuchet MS,sans-serif" color="black" size="1"><span style="font-size:8pt">
</span></font></span></font></div>
<div style="margin:0px"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt"><br>
</span></font></div>
<div style="margin:0px"><font face="Calibri,sans-serif" size="2"><span style="font-size:11pt"><a href="http://www.solent.ac.uk/disclaimer/disclaimer.aspx" target="_blank" id="LPNoLP"><font face="Trebuchet MS,sans-serif" size="1"><span style="font-size:8pt">Disclaimer</span></font></a></span></font><br>
</div>
</div>
</div>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Christoph Lingg <christoph@lingg.eu><br>
<b>Sent:</b> 15 May 2017 18:11:59<br>
<b>To:</b> jukka.rahkonen@latuviitta.fi<br>
<b>Cc:</b> dev@openstreetmap.org<br>
<b>Subject:</b> Re: [OSM-dev] Planet file with preprocessed lines/polygons</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText"><br>
>> A huge file containing all osm items as geojson would be my dreamcase.<br>
>> Does this exist?<br>
> <br>
> It could rather be a nightmare. GeoJSON can't be indexed spatially nor by attributes so if you would like to work only on small area of interest or to find just certain features you would still need to parse the whole huge GeoJOSN file.<br>
<br>
I agree that GeoJSON is not the format you would like to query your data. I wanted to refer to the way the data is available for download. To put it into other words: instead of raw xml (like now) a precomputed GeoJSON. Packing all OSM objects into a feature
collection would be again a night mare as you need a huge amount of RAM. But having one GeoJSON object per line could work much better and would allow the creation of an OSM object stream easily. Without downloading the entire dataset on disk first.<br>
<br>
Christoph<br>
_______________________________________________<br>
dev mailing list<br>
dev@openstreetmap.org<br>
<a href="https://lists.openstreetmap.org/listinfo/dev">https://lists.openstreetmap.org/listinfo/dev</a><br>
</div>
</span></font></div>
</body>
</html>