Girona Wiki

Diese Seite ist nicht editierbar. Sie können den Quelltext sehen, jedoch nicht verändern. Kontaktieren Sie den Administrator, wenn Sie glauben, dass hier ein Fehler vorliegt.

<h1>GIS Client für Tombejo:</h1>
<div class="level1">

<p>
Neben einer handelsüblichen Tombejo-Installation braucht der funktionierende GIS Client folgendes:
</p>

</div>

<h2>Benötigt wird:</h2>
<div class="level2">

<p>
Einen Geoserver (z.b. 2.6.2), am besten Standalone
</p>

<p>
Tombejo und Geoserver (<a href="http://geoserver.org/" class="urlextern" title="http://geoserver.org/" rel="nofollow">http://geoserver.org/</a>)  für unix und windows.
</p>

<p>
Eine Datenbasis, bevorzugt POSTGRES, bevorzugt 9.4.0.1. mit POSTGIS plugin. Es gibt eine Zip Datei die die Installationsfiles für Windows enthält, und zwar unter ocw2.de:/home/frauch/to_install.zip
</p>

</div>

<h2>Installation:</h2>
<div class="level2">

<p>
Beim einrichten des Geoservers muss darauf geachtet werden, dass das JDK Version 7 oder größer ist
</p>

<p>
Beim einrichten von POSTGRES wird im Installationsprozess das POSTGIS Plugin optional hinzugefügt. Hier muss darauf geachtet werden, dass die Bitrate mit der von Postgres übereinstimmt (normalerweise sollten es 64 bit sein).
</p>

</div>

<h2>Einrichtung der Datenbank:</h2>
<div class="level2">

<p>
Postgres Admin wird mit Pgadmin3 gestartet. Zuerst muss eine Datenbank angelegt werden (Name: Ahaus_neu), bei der unter extensions POSTGIS ausgewählt wird. Klappt das nicht hat das vermutlich was mit 32/64 bit zu tun.
</p>

<p>
Werden die Daten aus Shapefiles im importiert, so müssen jetzt alle shapefiles mit dem Plugin "Postgis Shapefiles and DBF Loader" geladen werden. Wichtig ist (momentan noch), dass die Option "Preserve case of column names" gesetzt wird, sonst kommt der gisclient damit nicht  zurecht, da diese vom Geoserver incl. case übernommen werden.
</p>

</div>

<h2>Einrichtung des Geoservers</h2>
<div class="level2">

<p>
Erstelle Arbeitsbereich:  <br/>
   <br/>
 Name: Ahaus_neu  <br/>
 Namensraum URI: Ahaus_neu  <br/>
   <br/>
 Neue Datenquelle:  <br/>
   <br/>
 Name der Datenquelle: Ahaus_neu  <br/>
 Beschreibung: Ahaus neu  <br/>
   <br/>
 Database: Ahaus_neu  <br/>
 user: postgres(ql)  <br/>
 passwd: postgres(ql)  <br/>
   <br/>
 Nun alle layer publizieren mit Koordinatensysem EPSG:31466. Die Namen der Layer müssen mit Großbuchstaben beginnen, Titel auch.  <br/>
   <br/>
 Gruppenlayer hinzufügen: Ahaus_neu_gesamt  <br/>
   <br/>
 Dabei die Stile: Rasen-grass Gebäude-rot Weg_wassergebunden-blau Offentl_gruen-green, alles andere-polygon.
</p>

<p>
Die Stile müssen im Moment noch aus ocw2.de geladen werden.
</p>

</div>

<h2>Apache Proxy einrichten</h2>
<div class="level2">

<p>
Damit es nicht zu Cross-Domain-Konflikten kommt, muss der Apache direkt auf den Geoserver weiterleiten. Dafür muss in die apache2.conf folgendes eingetragen werden:
</p>

<p>
# AJP13 Proxy   <br/>
 &lt;IfModule mod_proxy.c>   <br/>
 &lt;IfModule mod_proxy_ajp.c>   <br/>
 Include „conf/extra/httpd-ajp.conf“   <br/>
 &lt;/IfModule>   <br/>
 &lt;/IfModule>   <br/>
   <br/>
 ProxyPass /geoserver <a href="http://localhost:8080/geoserver" class="urlextern" title="http://localhost:8080/geoserver" rel="nofollow">http://localhost:8080/geoserver</a>   <br/>
 ProxyPassReverse /geoserver <a href="http://localhost:8080/geoserver" class="urlextern" title="http://localhost:8080/geoserver" rel="nofollow">http://localhost:8080/geoserver</a>
</p>

<p>
Außerdem  müssen folgende Zeilen auskommentiert werden:
</p>

<p>
<sub>LoadModule proxy_module modules/mod_proxy.so  <br/>
 </sub>
</p>

<p>
<sub>LoadModule proxy_connect_module modules/mod_proxy_connect.so  <br/>
 </sub>
</p>

<p>
<sub>LoadModule proxy_http_module modules/mod_proxy_http.so</sub>
</p>

</div>

<h2>Aufbereitung der Daten</h2>
<div class="level2">
<pre class="code sql"><span class="kw1">UPDATE</span> "Graeber" <span class="kw1">SET</span> "Geo_ID" <span class="sy0">=</span> <span class="kw1">NULL</span> <span class="kw1">WHERE</span> "Geo_ID" <span class="sy0">=</span> <span class="nu0">0</span>
<span class="kw1">UPDATE</span> "Graeber" <span class="kw1">SET</span> "fzeig" <span class="sy0">=</span> <span class="kw1">NULL</span> <span class="kw1">WHERE</span> "fzeig" <span class="sy0">=</span> <span class="nu0">0</span>



</pre><p> </p>
<pre class="code">\\  So lange das hier ausführen, bis es nichts mehr gibt:

</pre><p> </p>
<pre class="code sql"><span class="kw1">DELETE</span> <span class="kw1">FROM</span> "Graeber" <span class="kw1">WHERE</span> "gid" <span class="kw1">IN</span> <span class="br0">(</span>
<span class="kw1">SELECT</span>
<span class="kw1">MAX</span><span class="br0">(</span>"Graeber"<span class="sy0">.</span>"gid"<span class="br0">)</span>
<span class="kw1">FROM</span>
public<span class="sy0">.</span>"Graeber"
<span class="kw1">WHERE</span> "Graeber"<span class="sy0">.</span>"Geo_ID" <span class="kw1">IS</span> <span class="kw1">NOT</span> <span class="kw1">NULL</span>
<span class="kw1">GROUP</span> <span class="kw1">BY</span> "Graeber"<span class="sy0">.</span>"Geo_ID"<span class="sy0">,</span>fzeig <span class="kw1">HAVING</span> <span class="kw1">COUNT</span><span class="br0">(</span><span class="sy0">*</span><span class="br0">)</span><span class="sy0">></span><span class="nu0">1</span>
<span class="br0">)</span>



</pre><p> </p>
<pre class="code">\\  Anschließend das hier

</pre><p> </p>
<pre class="code sql"><span class="kw1">CREATE</span> <span class="kw1">UNIQUE</span> <span class="kw1">INDEX</span> "Graeber_Geo_ID" <span class="kw1">ON</span> "Graeber" <span class="kw1">USING</span> btree<span class="br0">(</span>"Geo_ID"<span class="sy0">,</span>"fzeig"<span class="br0">)</span>



</pre><p> </p>

<p>
<b>Konvertierung von Map-Info Daten nach Shapefile:</b>
</p>

<p>
Im Terminal:
</p>
<pre class="code sql">ogr2ogr <span class="sy0">-</span>f <span class="st0">'ESRI Shapefile'</span> <span class="sy0">*</span>Zieldatei<span class="sy0">*</span> <span class="sy0">*</span>Quelldatei<span class="sy0">*</span>



</pre><p> </p>

</div>

<h2>Linux</h2>
<div class="level2">

<p>
Um den Geoserver mit sh bin/startup.sh  oder sudo -b sh /usr/share/geoserver-2.8.3/bin/startup.sh zu starten muss vorher das eingegeben werden
</p>
<pre class="code sql">sudo bash <span class="sy0">-</span>c "echo JAVA_HOME<span class="sy0">=*</span>java<span class="sy0">-</span>pfad<span class="sy0">*</span>>> <span class="sy0">/</span>etc<span class="sy0">/</span>environment"
 sudo bash <span class="sy0">-</span>c "echo GEOSERVER_HOME<span class="sy0">=</span><span class="coMULTI">/*geoserver-pfad*>> /etc/environment"

</span>

</pre><p> </p>

</div>

<h1>Postgis</h1>
<div class="level1">

<p>
CREATE EXTENSION postgis;
</p>

<p>
kindex unique machen in layer graeber.
</p>

<p>
ALTER TABLE graeber ADD CONSTRAINT unique_kindex UNIQUE (kindex);
</p>

<p>
Graeber layer:
</p>

<span class='np_break'> </span>
<div class="table sectionedit1"><table class="inline">
	<tr class="row0">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=id&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=id&" rel="nofollow">id</a> </td><td class="col1">integer </td>
	</tr>
</table>
<span class='np_break'> </span>
</div>
<p>
NOT NULL
</p>

<span class='np_break'> </span>
<div class="table sectionedit2"><table class="inline">
	<tr class="row0">
		<td class="col0">nextval('graeber_id_seq'::regclass) </td><td class="col1"><a href="http://localhost/phppgadmin/constraints.php?server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&schema=public" class="media" title="http://localhost/phppgadmin/constraints.php?server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&schema=public" rel="nofollow"><img src="/lib/exe/fetch.php?tok=3ddc70&media=http%3A%2F%2Flocalhost%2Fphppgadmin%2Fimages%2Fthemes%2Fdefault%2FPrimaryKey.png" class="media" alt="" /></a> </td><td class="col2"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=id&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=id&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col3"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=id&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=id&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col4"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=id&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=id&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col5"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=id&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=id&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td>
	</tr>
	<tr class="row1">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=geom&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=geom&" rel="nofollow">geom</a> </td><td class="col1">geometry(MultiPolygon,900915) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=geom&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=geom&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=geom&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=geom&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=geom&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=geom&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=geom&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=geom&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row2">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=gname&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=gname&" rel="nofollow">gname</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=gname&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=gname&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=gname&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=gname&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=gname&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=gname&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=gname&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=gname&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row3">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=grabart&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=grabart&" rel="nofollow">grabart</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=grabart&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=grabart&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=grabart&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=grabart&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=grabart&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=grabart&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=grabart&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=grabart&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row4">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=nutzende&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=nutzende&" rel="nofollow">nutzende</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=nutzende&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=nutzende&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=nutzende&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=nutzende&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=nutzende&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=nutzende&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=nutzende&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=nutzende&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row5">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=gmzustand&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=gmzustand&" rel="nofollow">gmzustand</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=gmzustand&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=gmzustand&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=gmzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=gmzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=gmzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=gmzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=gmzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=gmzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row6">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=pfzustand&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=pfzustand&" rel="nofollow">pfzustand</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=pfzustand&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=pfzustand&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=pfzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=pfzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=pfzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=pfzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=pfzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=pfzustand&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row7">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=abtl&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=abtl&" rel="nofollow">abtl</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=abtl&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=abtl&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=abtl&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=abtl&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=abtl&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=abtl&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=abtl&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=abtl&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row8">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=reihe&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=reihe&" rel="nofollow">reihe</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=reihe&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=reihe&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=reihe&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=reihe&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=reihe&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=reihe&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=reihe&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=reihe&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row9">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=stelle&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=stelle&" rel="nofollow">stelle</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=stelle&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=stelle&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=stelle&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=stelle&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=stelle&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=stelle&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=stelle&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=stelle&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row10">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=stellebis&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=stellebis&" rel="nofollow">stellebis</a> </td><td class="col1">character varying(80) </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="leftalign">  </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=stellebis&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=stellebis&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=stellebis&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=stellebis&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=stellebis&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=stellebis&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=stellebis&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=stellebis&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
	<tr class="row11">
		<td class="col0"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=kindex&" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&column=kindex&" rel="nofollow">kindex</a> </td><td class="col1">numeric(10,0) </td><td class="leftalign">  </td><td class="col3">NULL::numeric </td><td class="col4"><a href="http://localhost/phppgadmin/constraints.php?server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&schema=public" class="media" title="http://localhost/phppgadmin/constraints.php?server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public&table=graeber&schema=public" rel="nofollow"><img src="/lib/exe/fetch.php?tok=031854&media=http%3A%2F%2Flocalhost%2Fphppgadmin%2Fimages%2Fthemes%2Fdefault%2FUniqueConstraint.png" class="media" alt="" /></a> </td><td class="col5"><a href="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=kindex&query=SELECT+" class="urlextern" title="http://localhost/phppgadmin/display.php?table=graeber&subject=column&return=table&column=kindex&query=SELECT+" rel="nofollow">Browse</a> </td><td class="col6"><a href="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=kindex&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/colproperties.php?subject=column&action=properties&table=graeber&column=kindex&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Alter</a> </td><td class="col7"><a href="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=kindex&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/privileges.php?subject=column&table=graeber&column=kindex&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Privileges</a> </td><td class="col8"><a href="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=kindex&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" class="urlextern" title="http://localhost/phppgadmin/tblproperties.php?subject=column&action=confirm_drop&table=graeber&column=kindex&server=postgresql.cqubs0xna6kf.eu-west-1.rds.amazonaws.com:5432:allow&database=darmstadt&schema=public" rel="nofollow">Drop</a> </td><td class="leftalign">  </td>
	</tr>
</table>
<span class='np_break'> </span>
</div>
<p>
Shapefiles in Postgis umwandeln
</p>

<p>
shapefile2postgis.php:
</p>

<p>
<a href="/doku.php?id=tombejo_gis_client:shapefile2postgis" class="wikilink2" title="tombejo_gis_client:shapefile2postgis" rel="nofollow">: :tombejo_gis_client:shapefile2postgis </a>
</p>

<p>
<b>Erzeuge gis spalte:</b>
</p>

<p>
SELECT AddGeometryColumn ('public','my_spatial_table','geom',4326,'POINT',2);
</p>

<p>
<a href="http://postgis.net/docs/AddGeometryColumn.html" class="urlextern" title="http://postgis.net/docs/AddGeometryColumn.html" rel="nofollow">http://postgis.net/docs/AddGeometryColumn.html</a>
</p>

<p>
und gleich der ganze table:
</p>
<pre class="code">CREATE TABLE items (
    id integer NOT NULL,
    geom geometry(Point,4326),
    clazz character varying(10)
);



</pre><p> </p>

<p>
<code>ALTER TABLE items OWNER TO postgresql; ALTER TABLE ONLY items     ADD CONSTRAINT items_pkey PRIMARY KEY (id);</code>
</p>

</div>

<h2>Tombejo</h2>
<div class="level2">

<p>
<code>Damit GIS in Tombejo läuft:<br/>

<br/>

1. Geoserver muss in Settings eingetragen sein: <br/>

2. GIS muss in Einwerten eingestellt sein (gisws)<br/>

2. Geoserver Authentifizierungsdaten muss in Mandant eingetragen sein (standard: admin/passwd)<br/>

3. GIS Workspace muss in jeweiligem Friedhof eingestellt sein (momentan laufen: Buckow und Darmstadt)</code>
</p>

</div>
<!-- EDIT2 TABLE [5084-] --><!-- EDIT1 TABLE [4865-] -->
Girona Wiki

Benutzer-Werkzeuge

Webseiten-Werkzeuge

Seiten-Werkzeuge
