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

OSM ·  OpenPOIMap ·  About... ·  Feedback ·  Terms of Use ·  Geometa Lab HSR · Data 28.05.2020 14:00 ODbL by OpenStreetMap