[OSGeo-UK] VectorMap District to PostGIS

Mike Saunt mikesaunt at astuntechnology.com
Sun Sep 18 10:59:13 EDT 2011


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...

sent from mobile which isn't an iPhone
On Sep 18, 2011 10:03 AM, "Matt Walker" <walkermatt at longwayaround.org.uk>
wrote:
> 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/d7dbb6a5/attachment.html


More information about the UK mailing list