<p>Hello, <br>
I had some issue with rendering my data with mapnik and it appears to be related to the way data are stored in the database after import with osm2pgsql. <br>
I use a very simple example data of 2 nodes and 1 way linking them. <br>
When importating this to my database with osm2pgsql, it creates 10 rows in the planet_osm_line table, which in turn creates some problem with mapnik rendering for correctly spacing the text labels on the road. </p>
<p>Is this split normal, and/or is there a way to avoid it? </p>
<p>Thanks a lot. </p>
<p>P.S. the osm file I used to test: </p>
<div class="highlight highlight-text-xml"><pre><?<span class="pl-ent">xml</span><span class="pl-e"> version</span>=<span class="pl-s"><span class="pl-pds">"</span>1.0<span class="pl-pds">"</span></span><span class="pl-e"> encoding</span>=<span class="pl-s"><span class="pl-pds">"</span>UTF-8<span class="pl-pds">"</span></span>?>
<<span class="pl-ent">osm</span> <span class="pl-e">version</span>=<span class="pl-s"><span class="pl-pds">"</span>0.6<span class="pl-pds">"</span></span> <span class="pl-e">generator</span>=<span class="pl-s"><span class="pl-pds">"</span><span class="pl-pds">"</span></span> <span class="pl-e">copyright</span>=<span class="pl-s"><span class="pl-pds">"</span>OpenStreetMap<span class="pl-pds">"</span></span> <span class="pl-e">attribution</span>=<span class="pl-s"><span class="pl-pds">"</span>http://www.openstreetmap.org/copyright<span class="pl-pds">"</span></span> <span class="pl-e">license</span>=<span class="pl-s"><span class="pl-pds">"</span>http://opendatacommons.org/licenses/odbl/1-0/<span class="pl-pds">"</span></span>>
<<span class="pl-ent">bounds</span> <span class="pl-e">minlat</span>=<span class="pl-s"><span class="pl-pds">"</span>-90<span class="pl-pds">"</span></span> <span class="pl-e">minlon</span>=<span class="pl-s"><span class="pl-pds">"</span>-180<span class="pl-pds">"</span></span> <span class="pl-e">maxlat</span>=<span class="pl-s"><span class="pl-pds">"</span>90<span class="pl-pds">"</span></span> <span class="pl-e">maxlon</span>=<span class="pl-s"><span class="pl-pds">"</span>180<span class="pl-pds">"</span></span>/>
<<span class="pl-ent">node</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>623<span class="pl-pds">"</span></span> <span class="pl-e">visible</span>=<span class="pl-s"><span class="pl-pds">"</span>true<span class="pl-pds">"</span></span> <span class="pl-e">lat</span>=<span class="pl-s"><span class="pl-pds">"</span>-0.339746<span class="pl-pds">"</span></span> <span class="pl-e">lon</span>=<span class="pl-s"><span class="pl-pds">"</span>6.000000<span class="pl-pds">"</span></span>>
</<span class="pl-ent">node</span>>
<<span class="pl-ent">node</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>626<span class="pl-pds">"</span></span> <span class="pl-e">visible</span>=<span class="pl-s"><span class="pl-pds">"</span>true<span class="pl-pds">"</span></span> <span class="pl-e">lat</span>=<span class="pl-s"><span class="pl-pds">"</span>7.789438<span class="pl-pds">"</span></span> <span class="pl-e">lon</span>=<span class="pl-s"><span class="pl-pds">"</span>2.715955<span class="pl-pds">"</span></span>>
</<span class="pl-ent">node</span>>
<<span class="pl-ent">way</span> <span class="pl-e">id</span>=<span class="pl-s"><span class="pl-pds">"</span>963<span class="pl-pds">"</span></span> <span class="pl-e">visible</span>=<span class="pl-s"><span class="pl-pds">"</span>true<span class="pl-pds">"</span></span>>
<<span class="pl-ent">nd</span> <span class="pl-e">ref</span>=<span class="pl-s"><span class="pl-pds">"</span>626<span class="pl-pds">"</span></span>/>
<<span class="pl-ent">nd</span> <span class="pl-e">ref</span>=<span class="pl-s"><span class="pl-pds">"</span>623<span class="pl-pds">"</span></span>/>
<<span class="pl-ent">tag</span> <span class="pl-e">k</span>=<span class="pl-s"><span class="pl-pds">"</span>name<span class="pl-pds">"</span></span> <span class="pl-e">v</span>=<span class="pl-s"><span class="pl-pds">"</span>aaaaaaaaaaaaa<span class="pl-pds">"</span></span> />
</<span class="pl-ent">way</span>>
</<span class="pl-ent">osm</span>></pre></div>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/openstreetmap/osm2pgsql/issues/507">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AD2-7mciAqoz2KFL6tlGjrTEzK-I267Hks5pHx7SgaJpZM4GmYrG.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/openstreetmap/osm2pgsql/issues/507"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>