[OSGeo-UK] VectorMap District to PostGIS

[Matt Walker]

Hi Jonathan,

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:
http://astuntechnology.com/labs/. 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.

Good luck,

Matt.

-- 
Matt Walker
@_walkermatt


On 18 September 2011 08:29, Jonathan Moriarty <prof_moriarty at veryfast.biz>wrote:

> Hi Folks,
>   I've got my hands on the OS OpenData VMD dataset for the entirety of
>   England and was wondering how I'd go about getting it into a PostGIS
>   database with minimum effort using Open-Source tools (this is a
>   do-at-home project so I'd rather not have to spend hours scripting
>   something up). I have experience with the spatial aspects of MySQL
>   and even a little Oracle Locator, but no PostGreSQL/PostGIS so I'm
>   finding the whole "schema/template" thing new.
>
>  I know QGIS can upload shapefiles to Post, but that appears to be a
>  one-at-a-time affair. The PostGIS built-in shp2pgsql similarly only
>  does one at a time. Does anyone have a nice handy script that'd do
>  this? There's one here -
>
> http://nerdytoad.blogspot.com/2010/10/more-rendering-of-vectormapdistrict.html
>  - albeit with no documentation and I can't get it to work). I'd have
>  thought uploading collections of related shapefiles would be a common
>  task so there'd be plenty of tools for it, but I can't seem to find
>  any.
>
> Note - I'm using Windows and this is all happening on my local machine.
> Thanks,
> Jonathan
>
> --
> http://www.fastmail.fm - The professional email service
>
> _______________________________________________
> UK mailing list
> UK at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/uk/attachments/20110918/4c54e30f/attachment.html