[Talk-GB] LandForm Panorama + VectorMap District + OSM Footpaths : Method

[Keith Sharp]

On 18-Mar-2011, at 6:14 PM, Keith Sharp wrote:

> On 17-Mar-2011, at 11:02 PM, Nick Whitelegg wrote:
> 
>> Have put up a wiki page detailing how the 'pseudo-Landranger' map at 
>> 
>> http://www.free-map.org.uk/expts/vmdlfp200/
>> 
>> was created...
>> 
>> http://wiki.openstreetmap.org/wiki/VMD_plus_LFP_plus_OSM
> 
> Could you add the SQL statement used to create the contours table to the Wiki page?

Answering myself, the following seems to work:

CREATE TABLE "contours" (gid serial PRIMARY KEY, height double precision);
SELECT AddGeometryColumn('', 'contours', 'way', '27700', 'LINESTRING', 2);

One query on this: does the height column need to be "double precise"?  I only chose this as you're using a C++ double to store the value in your lfp2pg program.

Keith.