Import of GML into PostgreSQL 8.4

From: "Oisin" <oisink(at)btinternet(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Import of GML into PostgreSQL 8.4
Date: 2009-10-25 17:52:52
Message-ID: B528912549E542F3B9315B386EABFAF2@dell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-10-25 21:51:55 Re: Import of GML into PostgreSQL 8.4
Previous Message Casey Allen Shobe 2009-10-25 16:07:23 Re: creating view - conditional testing in construct