'[postgis-users] Import of GML into PostgreSQL 8.4'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: postgis-users
Subject: [postgis-users] Import of GML into PostgreSQL 8.4
From: "OisinJK" <oisin.kelly () landscapeplanning ! co ! uk>
Date: 2009-10-26 21:47:23
Message-ID: B7C9076DA2096E4BAB98EC256764D44DABA64D () colchester01 ! LPGL ! local
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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

[Attachment #5 (text/html)]

<HTML dir=ltr><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18828"></HEAD>
<BODY>
<DIV>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 </DIV> <DIV>Oisin </DIV></BODY></HTML>

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread] 