| 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: | Whole Thread | Raw Message | 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 |