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.
_______________________________________________
Talk-GB mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/talk-gb
