[OSM-dev] Sql Server Parser

Milo van der Linden mlinden at zeelandnet.nl
Sun Sep 16 16:14:30 BST 2007


Hello Ray,

I am a .net developer and allready made my own little parser, but it 
stranded when I got busy with more important matters.

I would love to help you and I agree that placing it in a separate 
branch of the OSM repository would be best.

You say that it imports into SQL databases, do you mean SQL server or 
any SQL?

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!

You can use my eyes!

Kind regards,

Milo van der Linden
Ray Booysen schreef:
> 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
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>
>   


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.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. 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070916/9585f065/attachment.html>


More information about the dev mailing list