[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Geomedia Dataserver for PostGIS
From: Budschedl Harald <Harald.Budschedl () ikt ! linz ! at>
Date: 2009-12-29 10:16:32
Message-ID: 755D7A8C698CE141BF7791E841710C7D7C94D00E1C () UGLCL01-MXS ! ugl ! linz ! at
[Download RAW message or body]
Hi PostGIS ppl!
This is my first posting in this mailinglist.
I just got out of a PostgreSQL-seminar last week, learning a lot about that=
DB. Definitely a cool thing!
We are currently using ORACLE incl. Spatial in an Intergraph/Geomedia/Respu=
blica environment, so I thought: "let's see what PostGIS will do for me".
Setting up PostgreSQL 8.4 and PostGIS 1.4 was easy enough. I even created m=
y own cadastre-database, as I wanted to test the PG-DB with that data.
But how to get the data to PG?
First I tried using Geomedia, but there is no PostGIS dataserver. *hint, hi=
nt* But thank god, there is FME to save the day. Shame though, the FME-Data=
server for Geomedia is just supporting read access. To write data into a PG=
-DB you'll have to use the Workbench.
And so I did.
Works fine so far. Then there were only 2 "quirks" to sort out. One is alre=
ady solved, but I guess I have to take some time to figure out what is wron=
g with the second one.
First problem:
Even though I used the same (and correct) projection (AUT-GK31-5 in FME) in=
all my products, the data is off to the west about 30km, when I load it in=
Geomedia via FME-Dataserver. The Geoworkspace-Coordsys is ok, I checked th=
at. When I load the data into FME-Viewer, the coordinates are ok.
Solution: PostGIS saved the Data in EPSG:31258, which FME didn't understand=
correctly. "Save" and their austrian vendor "Axmann" were able to solve th=
is problem very quickly.
Second problem:
Not all the attributes are shown in Geomedia, neither when I doubleclick an=
object to review the properties, nor when I check the featuredefinition it=
self. I have yet to check which attributefields are missing, but my first g=
uess after a short check is, that there seems to be a problem with VARCHAR =
attributes. It's not just the data, but the whole fielddefinition is missin=
g.
Again, when I load the data in FME-Viewer, the attributes are all there.
To find out more about the problem, I am currently trying to establish a WF=
S webservice on my testserver, using the UMN Mapserver on Apache. Quite a c=
hallenge for me, but I am learning ;)
Geomedia will be able to access WFS with their own dataserver and I am curi=
ous to see, if the attribute-problem prevails or is gone.
So here goes my call to all the "explorers who go boldly, where no Geomedia=
n has gone before", and therefore have some experience with PostGIS and Geo=
media:
Any hints are greatly appreciated!
Oh, yes, and if someone feels compelled to create a native PostGIS-Dataserv=
er for Geomedia: that would be a hit!
I am not a programmer (not anymore - stopped coding in the mid-90s), but fr=
om what I heared, this should not be much of a trouble for people with C# a=
nd/or .NET experience. A developmet environment incl. documentation comes w=
ith every Geomedia licence. But as I said, I'm no expert anymore.
If there are any new developments, I'll try to keep you posted, if you are =
interested and my time allows it.
Cya.
Harry
Freundliche Gr=FC=DFe
Harald Budschedl
Geodaten Management (Geo)
IKT Linz GmbH
Ein Unternehmen der Stadt Linz
4040 Linz, Hauptstra=DFe 1-5
AUSTRIA
Tel. +43 732 7070 3436
Fax +43 732 7070 54 3436
visit www.linz.at/ikt<http://www.linz.at/ikt>
mailto: harald.budschedl@ikt.linz.at<mailto:gerhard.schoeller@ikt.linz.at>
________________________________
Diese Nachricht inklusive aller Anh=E4nge kann vertrauliche Informationen e=
nthalten. Sie ist ausschlie=DFlich f=FCr die adressierten Personen bestimmt=
. Das unerlaubte Kopieren sowie die unbefugte Weitergabe sind nicht gestatt=
et. Sollten Sie nicht die richtige Adressatin/der richtige Adressat sein, v=
ernichten Sie den gesamten Inhalt (=A7 93 Abs. 4 Telekommunikationsgesetz 2=
003) und informieren Sie bitte sofort den/die Absender/in. N=E4here Regelun=
gen zur elektronischen Kommunikation mit der Stadt Linz finden Sie in den "=
Allgemeinen Hinweisen und Nutzungsbestimmungen betreffend das E-Government =
der Stadt Linz (e-linz)" ( http://www.linz.at/images/AGB_egov_2008.pdf )
IKT Linz GmbH, Firmenbuch des Landesgerichtes Linz ++ Firmenbuch-Nummer: 32=
1197z ++ UID-Nummer: ATU64636344
IKT Linz Infrastruktur GmbH, Firmenbuch des Landesgerichtes Linz ++ Firmenb=
uch-Nummer: 321990s ++ UID-Nummer: ATU64664303
A-4020 Linz, Gruberstra=DFe 42, Tel. +43 732 7070 0, Fax: +43 732 7070 54 1=
555, office@ikt.linz.at, www.linz.at/ikt
Linz ist 2009 Kulturhauptstadt Europas
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 \
2px solid; } --></style> </head>
<body>
<font face="Arial, sans-serif" size="2">
<div>Hi PostGIS ppl!</div>
<div> </div>
<div>This is my first posting in this mailinglist.</div>
<div> </div>
<div><font face="Arial, sans-serif">I just got out of a PostgreSQL-seminar last week, \
learning a lot about that DB. Definitely a cool thing!</font></div> <div><font \
face="Arial, sans-serif"> </font></div> <div><font face="Arial, sans-serif">We \
are currently using ORACLE incl. Spatial in an Intergraph/Geomedia/Respublica \
environment, so I thought: "let's see what PostGIS will do for \
me".</font></div> <div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">Setting up PostgreSQL 8.4 and PostGIS 1.4 was \
easy enough. I even created my own cadastre-database, as I wanted to test the PG-DB \
with that data.</font></div> <div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">But how to get the data to PG?</font></div>
<div><font face="Arial, sans-serif">First I tried using Geomedia, but there is no \
PostGIS dataserver. *hint, hint* But thank god, there is FME to save the day. Shame \
though, the FME-Dataserver for Geomedia is just supporting read access. To write data \
into a PG-DB you'll have to use the Workbench.</font></div>
<div><font face="Arial, sans-serif">And so I did.</font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">Works fine so far. Then there were only 2 \
"quirks" to sort out. One is already solved, but I guess I have to take \
some time to figure out what is wrong with the second one.</font></div> <div><font \
face="Arial, sans-serif"> </font></div> <div><font face="Arial, \
sans-serif">First problem:</font></div> <div><font face="Arial, sans-serif">Even \
though I used the same (and correct) projection (AUT-GK31-5 in FME) in all my \
products, the data is off to the west about 30km, when I load it in Geomedia via \
FME-Dataserver. The Geoworkspace-Coordsys is ok, I checked that. When I load the data \
into FME-Viewer, the coordinates are ok.</font></div> <div><font face="Arial, \
sans-serif">Solution: PostGIS saved the Data in EPSG:31258, which FME didn't \
understand correctly. "Save" and their austrian vendor "Axmann" \
were able to solve this problem very quickly.</font></div> <div><font face="Arial, \
sans-serif"> </font></div> <div><font face="Arial, sans-serif">Second \
problem:</font></div> <div><font face="Arial, sans-serif">Not all the attributes are \
shown in Geomedia, neither when I doubleclick an object to review the properties, nor \
when I check the featuredefinition itself. I have yet to check which attributefields \
are missing, but my first guess after a short check is, that there seems to be a \
problem with VARCHAR attributes. It's not just the data, but the whole \
fielddefinition is missing.</font></div> <div><font face="Arial, sans-serif">Again, \
when I load the data in FME-Viewer, the attributes are all there.</font></div> \
<div><font face="Arial, sans-serif"> </font></div> <div><font face="Arial, \
sans-serif">To find out more about the problem, I am currently trying to establish a \
WFS webservice on my testserver, using the UMN Mapserver on Apache. Quite a challenge \
for me, but I am learning ;)</font></div> <div><font face="Arial, \
sans-serif">Geomedia will be able to access WFS with their own dataserver and I am \
curious to see, if the attribute-problem prevails or is gone.</font></div> <div><font \
face="Arial, sans-serif"> </font></div> <div><font face="Arial, sans-serif">So \
here goes my call to all the "explorers who go boldly, where no Geomedian has \
gone before", and therefore have some experience with PostGIS and \
Geomedia:</font></div> <div><font face="Arial, sans-serif">Any hints are greatly \
appreciated!</font></div> <div><font face="Arial, sans-serif">Oh, yes, and if someone \
feels compelled to create a native PostGIS-Dataserver for Geomedia: that would be a \
hit!</font></div> <div><font face="Arial, sans-serif">I am not a programmer (not \
anymore - stopped coding in the mid-90s), but from what I heared, this should not be \
much of a trouble for people with C# and/or .NET experience. A developmet environment \
incl. documentation comes with every Geomedia licence. But as I said, I'm no expert \
anymore.</font></div> <div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">If there are any new developments, I'll try to \
keep you posted, if you are interested and my time allows it.</font></div> <div><font \
face="Arial, sans-serif"> </font></div> <div><font face="Arial, \
sans-serif">Cya.</font></div> <div><font face="Arial, sans-serif">Harry</font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">Freundliche Grüße</font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif" size="2"><b>Harald Budschedl</b></font></div>
<div><font face="Arial, sans-serif">Geodaten Management (Geo) </font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">IKT Linz GmbH </font></div>
<div><font face="Arial, sans-serif">Ein Unternehmen der Stadt Linz</font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">4040 Linz, Hauptstraße 1-5</font></div>
<div><font face="Arial, sans-serif">AUSTRIA</font></div>
<div><font face="Arial, sans-serif"> </font></div>
<div><font face="Arial, sans-serif">Tel. +43 732 7070 \
3436</font></div> <div><font face="Arial, \
sans-serif">Fax +43 732 7070 54 3436</font></div> \
<div><font face="Arial, \
sans-serif">visit \
<a href="http://www.linz.at/ikt"><font \
color="#0000FF"><u>www.linz.at/ikt</u></font></a> </font></div> <div><font \
face="Arial, sans-serif"><a href="mailto:gerhard.schoeller@ikt.linz.at"><font \
color="#0000FF"><u>mailto: harald.budschedl@ikt.linz.at</u></font></a></font></div> \
<div><font face="Arial, sans-serif"> </font></div> <div><font face="Arial, \
sans-serif"> </font></div> <div><font face="Arial, \
sans-serif"> </font></div> <div><font size="3"><br>
</font></div>
<div><font size="3" color="#0000FF"><u> ________________________________ \
</u></font></div> <div><font face="Arial, sans-serif" size="1" \
color="#808080">Diese Nachricht inklusive aller Anhänge kann vertrauliche \
Informationen enthalten. Sie ist ausschließlich für die adressierten Personen \
bestimmt. Das unerlaubte Kopieren sowie die unbefugte Weitergabe sind nicht \
gestattet. Sollten Sie nicht die richtige Adressatin/der richtige Adressat sein, \
vernichten Sie den gesamten Inhalt (§ 93 Abs. 4 Telekommunikationsgesetz 2003) und \
informieren Sie bitte sofort den/die Absender/in. Nähere Regelungen zur \
elektronischen Kommunikation mit der Stadt Linz finden Sie in den "Allgemeinen \
Hinweisen und Nutzungsbestimmungen betreffend das E-Government der Stadt Linz \
(e-linz)" ( <a href="http://www.linz.at/images/AGB_egov_2008.pdf">http://www.linz.at/images/AGB_egov_2008.pdf</a> \
)<br>
<br>
IKT Linz GmbH, Firmenbuch des Landesgerichtes Linz ++ Firmenbuch-Nummer: \
321197z ++ UID-Nummer: ATU64636344<br>
IKT Linz Infrastruktur GmbH, Firmenbuch des Landesgerichtes Linz ++ \
Firmenbuch-Nummer: 321990s ++ UID-Nummer: ATU64664303<br>
A-4020 Linz, Gruberstraße 42, Tel. +43 732 7070 0, Fax: +43 732 7070 54 1555, \
office@ikt.linz.at, <a href="http://www.linz.at/ikt">www.linz.at/ikt</a><br>
<br>
Linz ist 2009 Kulturhauptstadt Europas<br>
</font></div>
</font>
</body>
</html>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
--===============2273087126255660854==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic