<p>If you have any issues let us at Astun know. We have a new script available soon but also could give you a postgis backup of national vmd, meridian & strategi...</p>
<p>sent from mobile which isn't an iPhone</p>
<div class="gmail_quote">On Sep 18, 2011 10:03 AM, "Matt Walker" <<a href="mailto:walkermatt@longwayaround.org.uk">walkermatt@longwayaround.org.uk</a>> wrote:<br type="attribution">> Hi Jonathan,<br>> <br>
> Jo Cook and I ran a workshop at the OS GIS Conference in Nottingham this<br>> year which covered loading OS OpenData including VMD into<br>> PostgreSQL/PostGIS. It was on Linux but it does include steps for creating a<br>
> new spatial DB from a PostGIS template and scripts for loading the data<br>> which could be fairly easily ported to use dos. Details including a download<br>> with the scripts and a link to the presentation here:<br>
> <a href="http://astuntechnology.com/labs/">http://astuntechnology.com/labs/</a>. I think the VMD Shapefiles are named with<br>> a prefix of their grid square which you may need to trim off in order to get<br>> 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>> On 18 September 2011 08:29, Jonathan Moriarty <<a href="mailto:prof_moriarty@veryfast.biz">prof_moriarty@veryfast.biz</a>>wrote:<br>
> <br>>> 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>>><br>>> <a href="http://nerdytoad.blogspot.com/2010/10/more-rendering-of-vectormapdistrict.html">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>>><br>>> --<br>>> <a href="http://www.fastmail.fm">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">http://lists.osgeo.org/mailman/listinfo/uk</a><br>
>><br></div>