[postgis-users] Import of GML into PostgreSQL 8.4

[OisinJK]

Hi folks

Newbie to postgres and database admin generally, so be gentle.

I'm trying to set-up a postgres mapserver for Ordnance Survey Mastermap. So
far I have installed postgreSQL 8..4 and PostGIS. I have imported a GML file
into a postgres database, created using postgis_template, using ogr2ogr.

The import was successful, and creates 8 tables. I will not list them all
here. But there seem to be two tables associated with what are the map
labels in OS Mastermap. The tables are named "cartographicsymbol" and
"cartographictext".

I note that the table cartographicsymbol does contain an attribute (or
column) named [orientation] , whch can be used to rotate the label to the
correct orientation. Although the information is contained in the raw GML
file, no such [orientation] attribute is imported for "cartographictext". I
also note that in neither table is the [fid] attribute (unique identifier)
imported.

Does anyone have any clues about how to get over this difficulty?

Many thanks

Oisin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091026/237c7bf4/attachment.html>