[Talk-us] Bulk upload from sql server 2008 (via shapefile?)

[Kate Chapman]

I would think there is probably an easier route from SQL Server 2008 to OSM,
but it would be more initial work. It is relatively easy to get XML out of
SQL Server it would just be a matter of massaging it into the OSM format.
Does anyone think this would be particularly useful though since there is a
lot more experience going from SHP to OSM?

-Kate Chapman

On Fri, Sep 4, 2009 at 11:10 AM, Ian Dees <ian.dees at gmail.com> wrote:
>
> I would start with this: export the various themes to shapefiles and then
> we can work from there. I don't think anyone has any experience converting
> SQL Server 2008 to OSM, but there's tons of experience converting SHP to
> OSM.
>
> As for reconciliation after you get it into OSM format, it really depends
> on the areas that the data covers. If it's in a highly active area, then
> there's a greater chance that there will be more conflicts (but also
> possibly more people to help you). Once we get the OSM files, we can work on
> getting some help to merge old OSM with new OSM (perhaps from the Germans
> (who have already mapped everything in their own country ;-) )).
>
> _______________________________________________
> Talk-us mailing list
> Talk-us at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-us
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-us/attachments/20090904/0410a5d8/attachment.html>