Hi Jonathan,<br><br>Jo Cook and I ran a workshop at the OS GIS Conference in Nottingham this year which covered loading OS OpenData including VMD into PostgreSQL/PostGIS. It was on Linux but it does include steps for creating a new spatial DB from a PostGIS template and scripts for loading the data which could be fairly easily ported to use dos. Details including a download with the scripts and a link to the presentation here: <a href="http://astuntechnology.com/labs/">http://astuntechnology.com/labs/</a>. I think the VMD Shapefiles are named with a prefix of their grid square which you may need to trim off in order to get all features from all tables loaded into the relevant tables.<br>
<br>Good luck,<br><br>Matt.<br><br>-- <br>Matt Walker<br>@_walkermatt<br><br><br><div class="gmail_quote">On 18 September 2011 08:29, Jonathan Moriarty <span dir="ltr"><<a href="mailto:prof_moriarty@veryfast.biz">prof_moriarty@veryfast.biz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Folks,<br>
I've got my hands on the OS OpenData VMD dataset for the entirety of<br>
England and was wondering how I'd go about getting it into a PostGIS<br>
database with minimum effort using Open-Source tools (this is a<br>
do-at-home project so I'd rather not have to spend hours scripting<br>
something up). I have experience with the spatial aspects of MySQL<br>
and even a little Oracle Locator, but no PostGreSQL/PostGIS so I'm<br>
finding the whole "schema/template" thing new.<br>
<br>
I know QGIS can upload shapefiles to Post, but that appears to be a<br>
one-at-a-time affair. The PostGIS built-in shp2pgsql similarly only<br>
does one at a time. Does anyone have a nice handy script that'd do<br>
this? There's one here -<br>
<a href="http://nerdytoad.blogspot.com/2010/10/more-rendering-of-vectormapdistrict.html" target="_blank">http://nerdytoad.blogspot.com/2010/10/more-rendering-of-vectormapdistrict.html</a><br>
- albeit with no documentation and I can't get it to work). I'd have<br>
thought uploading collections of related shapefiles would be a common<br>
task so there'd be plenty of tools for it, but I can't seem to find<br>
any.<br>
<br>
Note - I'm using Windows and this is all happening on my local machine.<br>
Thanks,<br>
Jonathan<br>
<font color="#888888"><br>
--<br>
<a href="http://www.fastmail.fm" target="_blank">http://www.fastmail.fm</a> - The professional email service<br>
<br>
_______________________________________________<br>
UK mailing list<br>
<a href="mailto:UK@lists.osgeo.org">UK@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/uk" target="_blank">http://lists.osgeo.org/mailman/listinfo/uk</a><br>
</font></blockquote></div><br><br>