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