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