PostGIS Terminal
SQL Composer (
Help
):
» SELECT Basics:
-- pick --
SELECT ST_AsText(_geom)
FROM _table
WHERE (name ILIKE '_string%')
AND ST_Contains(mapextent(), _geom)
GROUP BY 1 HAVING
ORDER BY 1
LIMIT 100
OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
» Outputs / Measurements:
-- pick --
ST_AsText(_geom)
Count(*)
ST_Area(_geom)
ST_Length(_geom)
ST_Distance(_geom, geom2)
» Relationships (->bool):
-- pick --
ST_Contains(_geom, geom2)
ST_Intersects(_geom, geom2)
ST_Within(_geom, geom2)
ST_DWithin(_geom, distance_double)
ST_Relate(_geom, geom2, '0********')
» Relate exemplified (bool):
pt
li
po
pt
li
po
» Processors (->geom):
-- pick --
ST_Buffer(_geom, distance_double)
ST_Union(_geom, geom2)
ST_Centroid(_geom)
» Examples:
-- pick --
Search inside mapextent
Search for string in _table
Search for ATM in osm_point
Search for county/village name in osm_polygon
Feature Info with mouse click (_mouse_x,_mouse_y)
Query:
-- default --
green
blue
yellow
orange
grey
black
white
with limit 100
Fill Color:
-- default --
red
green
blue
yellow
brown
black
white
Navigation:
Log:
Clear log before query
Service temporarily unavailable
OSM
·
OpenPOIMap
·
About...
·
Feedback
·
Terms of Use
·
Geometa Lab HSR
· Data 08.10.2022 07:00 ODbL by
OpenStreetMap