PostGIS Terminal - Versionsgeschichte

Stefan am 14. November 2023 um 11:43 Uhr

2023-11-14T11:43:24Z

← Nächstältere Version		Version vom 14. November 2023, 11:43 Uhr
Zeile 1:		Zeile 1:
	[[Bild:PostGIS_Terminal.jpg\|thumb\|300px\|right\|Printscreen of PostGIS Terminal (Prototype).]]		[[Bild:PostGIS_Terminal.jpg\|thumb\|300px\|right\|Printscreen of PostGIS Terminal (Prototype).]]

	The OSM SQL Terminal (formerly known as '''PostGIS Terminal''') is an online browser shell to query a geospatial database called [[EOSMDBOne]] ("Extended OSM DB One") using spatial [[SQL]]. The result is visualized in raw graphics in a map window directly in the browser (map view). The background map and the geodata come from [[OpenStreetMap]]. The data is syncronized every night (area of Switzerland) from the OpenStreetMap database to EOSMDBOne.		The '''OSM SQL Terminal''' (formerly known as '''PostGIS Terminal''') is an online browser shell to query a geospatial database called [[EOSMDBOne]] ("Extended OSM DB One") using spatial [[SQL]]. The result is visualized in raw graphics in a map window directly in the browser (map view). The background map and the geodata come from [[OpenStreetMap]]. The data is syncronized every night (area of Switzerland) from the OpenStreetMap database to EOSMDBOne.

	See also [[PostGIS Terminal Examples]], [[PostGIS]].		See also [[PostGIS Terminal Examples]], [[PostGIS]].
Zeile 11:		Zeile 11:
	The OSM SQL Terminal was developed based on the original idea and implementation of Marc Jansen and Till Adams. They are the authors of the german [[OpenLayers]] book (see [http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html] and [http://2010.foss4g.org/presentations_show.php?id=3630]). The idea was also realized independently in [http://www.postgisonline.org/ postgisonline.org].		The OSM SQL Terminal was developed based on the original idea and implementation of Marc Jansen and Till Adams. They are the authors of the german [[OpenLayers]] book (see [http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html] and [http://2010.foss4g.org/presentations_show.php?id=3630]). The idea was also realized independently in [http://www.postgisonline.org/ postgisonline.org].

	~~PostGIS Terminal~~ is mainly a rich client written in JavaScript with some server code currently in PHP. Specifically it runs on Apache (with PHP support), PostgreSQL/[[PostGIS]] (see [[EOSMDBOne]]) plus [[OpenLayers]]. There are no other SW dependencies.		The terminal is mainly a rich client written in JavaScript with some server code currently in PHP. Specifically it runs on Apache (with PHP support), PostgreSQL/[[PostGIS]] (see [[EOSMDBOne]]) plus [[OpenLayers]]. There are no other SW dependencies.

	== Über... ==		== Über... ==
Zeile 94:		Zeile 94:
	\| ####### \| Footer \|		\| ####### \| Footer \|
	.--------------------------.		.--------------------------.
	Figure: GUI Layout of ~~PostGIS~~ Terminal.		Figure: GUI Layout of OSM SQL Terminal.

	Reserved field and function names are:		Reserved field and function names are:

Stefan: Replaced PostGIS Terminal with OSM SQL Terminal

2023-11-14T11:42:17Z

Replaced PostGIS Terminal with OSM SQL Terminal

← Nächstältere Version		Version vom 14. November 2023, 11:42 Uhr
Zeile 1:		Zeile 1:
	[[Bild:PostGIS_Terminal.jpg\|thumb\|300px\|right\|Printscreen of PostGIS Terminal (Prototype).]]		[[Bild:PostGIS_Terminal.jpg\|thumb\|300px\|right\|Printscreen of PostGIS Terminal (Prototype).]]

	'''PostGIS Terminal''' is an online browser shell to query a geospatial database called [[EOSMDBOne]] ("Extended OSM DB One") using spatial [[SQL]]. The result is visualized in raw graphics in a map window directly in the browser (map view). The background map and the geodata come from [[OpenStreetMap]]. The data is syncronized every night (area of Switzerland) from the OpenStreetMap database to EOSMDBOne.		The OSM SQL Terminal (formerly known as '''PostGIS Terminal''') is an online browser shell to query a geospatial database called [[EOSMDBOne]] ("Extended OSM DB One") using spatial [[SQL]]. The result is visualized in raw graphics in a map window directly in the browser (map view). The background map and the geodata come from [[OpenStreetMap]]. The data is syncronized every night (area of Switzerland) from the OpenStreetMap database to EOSMDBOne.

	See also [[PostGIS Terminal Examples]], [[PostGIS]].		See also [[PostGIS Terminal Examples]], [[PostGIS]].

	~~'''~~>> Go to ~~[http://labs.geometa.info/postgisterminal/?xapi=node%5Bname%3DParkhaus%20See\|Kinderzoo%5D PostGIS Terminal]...~~ <<~~''' - ''NOTE: Use with care! There is no warrranty about availability!''~~		>> Ask Prof. Stefan Keller about access to it <<

	== About ==		== About ==

	The ~~PostGIS~~ Terminal was developed based on the original idea and implementation of Marc Jansen and Till Adams. They are the authors of the german [[OpenLayers]] book (see [http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html] and [http://2010.foss4g.org/presentations_show.php?id=3630]). The idea was also realized independently in [http://www.postgisonline.org/ postgisonline.org].		The OSM SQL Terminal was developed based on the original idea and implementation of Marc Jansen and Till Adams. They are the authors of the german [[OpenLayers]] book (see [http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html] and [http://2010.foss4g.org/presentations_show.php?id=3630]). The idea was also realized independently in [http://www.postgisonline.org/ postgisonline.org].

	PostGIS Terminal is mainly a rich client written in JavaScript with some server code currently in PHP. Specifically it runs on Apache (with PHP support), PostgreSQL/[[PostGIS]] (see [[EOSMDBOne]]) plus [[OpenLayers]]. There are no other SW dependencies.		PostGIS Terminal is mainly a rich client written in JavaScript with some server code currently in PHP. Specifically it runs on Apache (with PHP support), PostgreSQL/[[PostGIS]] (see [[EOSMDBOne]]) plus [[OpenLayers]]. There are no other SW dependencies.
Zeile 15:		Zeile 15:
	== Über... ==		== Über... ==

	Notes (in german): Das ~~PostGIS~~ Terminal ist eine Art Webadmin-Tool zur Visualisierung von Spatial SQL Queries und kann für Ausbildungzwecke aber auch für GIS-Administratoren nützlich sein. Installieren siehe _README.txt. Es gibt ev. mal eine Homepage auf http://labs.geometa.info/ (analog http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html ). Setzt Apache/PHP und PostgresSQL/PostGIS voraus. Passende Daten dazu stammen beispielsweise von OpenStreetMap (http://download.geofabrik.de/osm/ ). Testen mit den Beispielen in _EXAMPLE_QUERIES.txt und [http://openlayers-buch.de/beispiele/chapter-09/nice-queries-for-postgis-console.sql nice-queries-for-postgis-console.sql]. Könnte theoretisch auch weitere Geo-Datenbanksysteme unterstützen (müsste dann aber umbenannt werden).		Notes (in german): Das OSM SQL Terminal ist eine Art Webadmin-Tool zur Visualisierung von Spatial SQL Queries und kann für Ausbildungzwecke aber auch für GIS-Administratoren nützlich sein. Installieren siehe _README.txt. Es gibt ev. mal eine Homepage auf http://labs.geometa.info/ (analog http://openlayers-buch.de/beispiele/chapter-09/postgis-terminal.html ). Setzt Apache/PHP und PostgresSQL/PostGIS voraus. Passende Daten dazu stammen beispielsweise von OpenStreetMap (http://download.geofabrik.de/osm/ ). Testen mit den Beispielen in _EXAMPLE_QUERIES.txt und [http://openlayers-buch.de/beispiele/chapter-09/nice-queries-for-postgis-console.sql nice-queries-for-postgis-console.sql]. Könnte theoretisch auch weitere Geo-Datenbanksysteme unterstützen (müsste dann aber umbenannt werden).

	== How to use it ==		== How to use it ==
Zeile 29:		Zeile 29:
	== Credits / License ==		== Credits / License ==
	Credits to...		Credits to...
			* Joël Schwab und Felix Reiniger, IFS OST
	* Marc Jansen/Till Adams (code, OpenLayers book)		* Marc Jansen/Till Adams (code, OpenLayers book)
	* and Hartmut Holzgräfe (code)		* and Hartmut Holzgräfe (code)
Zeile 68:		Zeile 69:
	To be defined. The use of selectors which "generate" SQL into query input console is experimental from an eLearning view.		To be defined. The use of selectors which "generate" SQL into query input console is experimental from an eLearning view.

	=== Help using ~~PostGIS~~ Terminal ===		=== Help using OSM SQL Terminal ===

	~~PostGIS Terminal~~ analyses your SQL query (from your input into the Query editor), beautifies it and looks for placeholders.		The terminal analyses your SQL query (from your input into the Query editor), beautifies it and looks for placeholders.
	Output (text or map) can be controlled with field names (or function names) if they exist		Output (text or map) can be controlled with field names (or function names) if they exist
	in the SQL console input or in the query result.		in the SQL console input or in the query result.
Zeile 81:		Zeile 82:

	.--------------------------.		.--------------------------.
	\| ~~PostGIS~~ Terminal... \|		\| OSM SQL Terminal... \|
	\|--------------------------\|		\|--------------------------\|
	\| xxx \| \|		\| xxx \| \|
Zeile 134:		Zeile 135:
	=== XAPI-to-Map ===		=== XAPI-to-Map ===

	''NOTE: If ~~PostGIS~~ Terminal shows an error, try to Copy&Paste the examples below into the browser of your choice!''		''NOTE: If the OSM SQL Terminal shows an error, try to Copy&Paste the examples below into the browser of your choice!''

	You can query the ~~PostGIS-~~Terminal by using the [[XAPI]] syntax from [[OSM]], like this:		You can query the OSM SQL Terminal by using the [[XAPI]] syntax from [[OSM]], like this:

	* Alle Zoos der Schweiz: <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D]		* Alle Zoos der Schweiz: <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D]

Stefan: /* Syntax */

2013-02-09T00:46:05Z

Syntax

← Nächstältere Version		Version vom 9. Februar 2013, 00:46 Uhr
Zeile 130:		Zeile 130:
	WHERE tags @> hstore('tourism','zoo') </nowiki>		WHERE tags @> hstore('tourism','zoo') </nowiki>

	Shortcut using XAPI-to-Map: http://labs.geometa.info/postgisterminal/?xapi=%5Btourism~~=zoo%5D http://labs.geometa.info/postgisterminal/?xapi=[tourism~~=zoo%5D		Shortcut using XAPI-to-Map: http://labs.geometa.info/postgisterminal/?xapi=*%5Btourism=zoo%5D

	=== XAPI-to-Map ===		=== XAPI-to-Map ===

Stefan: /* Syntax */

2013-02-09T00:45:39Z

Syntax

← Nächstältere Version		Version vom 9. Februar 2013, 00:45 Uhr
Zeile 130:		Zeile 130:
	WHERE tags @> hstore('tourism','zoo') </nowiki>		WHERE tags @> hstore('tourism','zoo') </nowiki>

	Shortcut using XAPI-to-Map: [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo%5D]		Shortcut using XAPI-to-Map: http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo%5D

	=== XAPI-to-Map ===		=== XAPI-to-Map ===

Stefan: /* Syntax */

2013-02-09T00:45:11Z

Syntax

← Nächstältere Version		Version vom 9. Februar 2013, 00:45 Uhr
Zeile 130:		Zeile 130:
	WHERE tags @> hstore('tourism','zoo') </nowiki>		WHERE tags @> hstore('tourism','zoo') </nowiki>

	Shortcut using XAPI-to-Map: [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo]]		Shortcut using XAPI-to-Map: [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo%5D]

	=== XAPI-to-Map ===		=== XAPI-to-Map ===

Stefan: /* XAPI-to-Map */

2013-01-08T18:18:13Z

XAPI-to-Map

← Nächstältere Version		Version vom 8. Januar 2013, 18:18 Uhr
Zeile 138:		Zeile 138:
	You can query the PostGIS-Terminal by using the [[XAPI]] syntax from [[OSM]], like this:		You can query the PostGIS-Terminal by using the [[XAPI]] syntax from [[OSM]], like this:

	* Zoos: <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D]		* Alle Zoos der Schweiz: <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D]
	* Museum: <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[tourism=museum]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=museum%5D]		* Museum: <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[tourism=museum]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=museum%5D]
	* Castles (Burgen): <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[historic=castle]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Bhistoric=castle%5D]		* Castles (Burgen): <tt><nowiki>http://labs.geometa.info/postgisterminal/?xapi=[historic=castle]</nowiki></tt> [http://labs.geometa.info/postgisterminal/?xapi=%5Bhistoric=castle%5D]

Stefan: /* Syntax */

2012-11-04T21:37:40Z

Syntax

← Nächstältere Version		Version vom 4. November 2012, 21:37 Uhr
Zeile 130:		Zeile 130:
	WHERE tags @> hstore('tourism','zoo') </nowiki>		WHERE tags @> hstore('tourism','zoo') </nowiki>

	Shortcut using XAPI-to-Map: ~~<tt><nowiki>~~http://labs.geometa.info/postgisterminal/?xapi=~~[tourism~~=zoo~~]</nowiki></tt> [~~http://labs.geometa.info/postgisterminal/?xapi=~~%5Btourism~~=zoo~~%5D~~]		Shortcut using XAPI-to-Map: [http://labs.geometa.info/postgisterminal/?xapi=%5Btourism=zoo%5D http://labs.geometa.info/postgisterminal/?xapi=[tourism=zoo]]

	=== XAPI-to-Map ===		=== XAPI-to-Map ===

Stefan am 4. November 2012 um 21:36 Uhr

2012-11-04T21:36:49Z

Änderungen zeigen

Stefan am 4. November 2012 um 21:29 Uhr

2012-11-04T21:29:44Z

← Nächstältere Version		Version vom 4. November 2012, 21:29 Uhr
Zeile 3:		Zeile 3:
	'''PostGIS Terminal''' is an online browser shell to query a geospatial database called [[EOSMDBOne]] ("Extended OSM DB One") using spatial [[SQL]]. The result is visualized in raw graphics in a map window directly in the browser (map view). The background map and the geodata come from [[OpenStreetMap]]. The data is syncronized every night (area of Switzerland) from the OpenStreetMap database to EOSMDBOne.		'''PostGIS Terminal''' is an online browser shell to query a geospatial database called [[EOSMDBOne]] ("Extended OSM DB One") using spatial [[SQL]]. The result is visualized in raw graphics in a map window directly in the browser (map view). The background map and the geodata come from [[OpenStreetMap]]. The data is syncronized every night (area of Switzerland) from the OpenStreetMap database to EOSMDBOne.

	[[PostGIS]]		See also [[PostGIS Terminal Examples]], [[PostGIS]].

	'''>> Go to [http://labs.geometa.info/postgisterminal/?xapi=node%5Bname%3DParkhaus%20See\|Kinderzoo%5D PostGIS Terminal]... <<''' - ''NOTE: Use with care! There is no warrranty about availability!''		'''>> Go to [http://labs.geometa.info/postgisterminal/?xapi=node%5Bname%3DParkhaus%20See\|Kinderzoo%5D PostGIS Terminal]... <<''' - ''NOTE: Use with care! There is no warrranty about availability!''

Stefan: /* Examples */

2012-07-15T15:22:02Z

Examples

@@ Zeile 216: / Zeile 216: @@
    ORDER BY osm_poi.way <-> mylocation.way
    LIMIT 100  </nowiki>
 === XAPI-to-Map ===