<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Century Gothic";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 62.9pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Hallo,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>ich verwende gewöhnlich relationale
Datenbanktabellen zur Darstellung von Punktdaten (POINT-, ANNOTATION-Layer).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Dies geschieht via OGR. Um nicht alle
Datensätze abfragen zu müssen mache ich eine räumliche Abfrage. Dazu<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>habe ich bisher immer die URL ausgelesen
(BBOX-Attribut im WMS-Aufruf) und in mein SQL Query<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>eingebaut:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>LAYER <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'> NAME Schulen<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'> GROUP Oeffentliche_Einrichtungen<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'> </span></font><font size=2
face="Century Gothic"><span lang=EN-GB style='font-size:10.0pt;font-family:
"Century Gothic"'>STATUS ON<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> CONNECTIONTYPE OGR<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> CONNECTION
"<OGRVRTDataSource><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> <OGRVRTLayer
name='objekte'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> <SrcDataSource>ODBC:MapServer/MapServer@ds_nl</SrcDataSource>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> </span></font><font
size=2 face="Century Gothic"><span style='font-size:10.0pt;font-family:"Century Gothic"'><SrcSQL>SELECT
rechtswert, hochwert FROM map_objekte <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'> </span></font><font
size=2 face="Century Gothic"><span lang=EN-GB style='font-size:10.0pt;
font-family:"Century Gothic"'>WHERE layer='Schulen' <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> AND
rechtswert BETWEEN SUBSTRING('%BBOX%', 0 ,11) AND SUBSTRING('%BBOX%', 25 ,11)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> AND
hochwert BETWEEN SUBSTRING('%BBOX%', 13 ,11) AND SUBSTRING('%BBOX%', 37
,11)</SrcSQL><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> <GeometryType>wkbPoint</GeometryType><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> <GeometryField
encoding='PointFromColumns' x='rechtswert' y='hochwert'/> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> </OGRVRTLayer><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> </OGRVRTDataSource>"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> DATA
"OBJEKTE"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'> TYPE POINT<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Bislang habe ich ausschließlich mit
Gauss-Krüger-Daten gearbeitet und daher hatte ich kein Probleme, da mein
WMS-Aufruf<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>auch über Gauss-Krüger erfolgte.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Jetzt habe ich allerdings
lat/lon-Koordinaten in meiner DB-Tabelle und möchte diese aber trotzdem über<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Gauss-Krüger abfragen. Daher entfällt die
räumliche Abfrage wie ich sie bislang gemacht habe. Da die DB-Tabelle sehr groß
ist<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>muss ich allerdings eine räumliche Abfrage
machen, da sonst der GetMap-Request viel zu viel Zeit benötigt (mehrer
Sekunden).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Hat jemand eine Antwort für mich parat ob
sich das mit OGR oder sonst wie machen lässt? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Oder muss ich die Daten doch erst nach
Gauss-Krüger konvertieren (z.B. mit ogr2ogr in ein Shape-File mit
GK-Koordinaten)?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>Mit freundlichen Grüßen,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 color="#333333" face="Century Gothic"><span
style='font-size:10.0pt;font-family:"Century Gothic";color:#333333;font-weight:
bold'>Gunter Becker </span></font></b><font size=2 face="Century Gothic"><span
style='font-size:10.0pt;font-family:"Century Gothic"'><br>
_________________________________________________________________<br>
</span></font><b><font color="#333333" face="Century Gothic"><span
style='font-family:"Century Gothic";color:#333333;font-weight:bold'>CSO GmbH </span></font></b><font
size=2 face="Century Gothic"><span style='font-size:10.0pt;font-family:"Century Gothic"'><br>
Informations-Lösungen <br>
Forsthausstrasse 2 <br>
75180 Pforzheim <br>
Fon +49 (0) 72 31 . 97 35 62 (direkt)<br>
Fon +49 (0) 72 31 . 97 35 10 (Zentrale)<br>
Fax +49 (0) 72 31 . 97 35 90 <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Century Gothic"><span style='font-size:
10.0pt;font-family:"Century Gothic"'>eMail <u><a
href="mailto:gunter.becker@csogis.de">gunter.becker@csogis.de</a></u> <br>
web <a href="www.csogis.de">www.csogis.de</a> <br>
_________________________________________________________________<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 face="Century Gothic"><span style='font-size:
5.0pt;font-family:"Century Gothic"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 color=gray face="Century Gothic"><span
style='font-size:10.0pt;font-family:"Century Gothic";color:gray;font-weight:
bold'>Aufpoliert!</span></font></b><font size=2 color=gray face="Century Gothic"><span
style='font-size:10.0pt;font-family:"Century Gothic";color:gray'><br>
</span></font><font size=1 color=gray face="Century Gothic"><span
style='font-size:9.0pt;font-family:"Century Gothic";color:gray'>Inzwischen war
er in die Jahre gekommen: Der Web-Auftritt von CSO. <br>
Jetzt wurde er konzeptionell neugestaltet. Bitte besuchen Sie uns unter<br>
<a href="http://www.csogis.de/"><font color=gray><span style='color:gray'>www.csogis.de</span></font></a></span></font><font
size=1 color=gray face="Century Gothic"><span style='font-size:5.0pt;
font-family:"Century Gothic";color:gray'><br>
</span></font><font size=2 face="Century Gothic"><span style='font-size:10.0pt;
font-family:"Century Gothic"'>_________________________________________________________________</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>