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)
» 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

About... ·  Feedback ·  Terms of Use ·  GISpunkt HSR · Data 22.02.2012 CC-By-SA by OpenStreetMap