<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Ray,<br>
<br>
I am a .net developer and allready made my own little parser, but it
stranded when I got busy with more important matters. <br>
<br>
I would love to help you and I agree that placing it in a separate
branch of the OSM repository would be best.<br>
<br>
You say that it imports into SQL databases, do you mean SQL server or
any SQL?<br>
<br>
Are you aware of msSQLSpatial, a spatial extension that is available
for SQL Server 2005 (Express and others)? It is OGC compliant and has
almost the same structure as postGIS!<br>
<br>
You can use my eyes!<br>
<br>
Kind regards,<br>
<br>
Milo van der Linden<br>
Ray Booysen schreef:
<blockquote cite="mid:46EAAF61.6070303@rjb.za.net" type="cite">
<pre wrap="">Hi all
In the hope that there are some .Net developers out there, I've decided
to let loose my project to parse the planet.osm file. In a nutshell it
will parse all nodes, segments and ways with tags into an sql database.
I've used an XmlTextReader which is an extremely fast forward only xml
reader which keeps memory usage down to a minimum. Running it on the
latest planet, I don't get RAM usage above 8MB throughout the import.
I've created a schema close but not the same as the schema that OSM
uses. I've moved tags out of the segments and node tables into their
own table for better analysis. If you're interested in developing this
further or want the code, I can either send it to you although I would
prefer to stick it in the OSM repository. If anyone here has the
ability, I would love to be able to commit.
It is a POC at the moment but works really well and could use another
pair of eyes on it.
Cheers
Ray
_______________________________________________
dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev">http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="NL">De informatie in dit bericht
reflecteert mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bij het betreffende medium
behorende voorwaarden.</span>
<span lang="EN">The information in this message reflects my
personal opinion and not that of a company or public body. All rights
reserved.If this message is contained in a mailing-list or community,
the rights on the medium are automatically adapted.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>