Semantic search

This page or action requires JavaScript to work. Please enable JavaScript in your browser or use a browser where it is supported, so that functionality can be provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

Condition

Printout selection

Options

Parameters [+]

limit:

The maximum number of results to return

offset:

The offset of the first result

link:

Show values as links

headers:

Display the headers/property names

mainlabel:

The label to give to the main page name

intro:

The text to display before the query results, if there are any

outro:

The text to display after the query results, if there are any

searchlabel:

Text for continuing the search

default:

The text to display if there are no query results

class:

An additional CSS class to set for the table

transpose:

Display table headers vertically and results horizontally

sep:

The separator between results

Sort options

Delete

Add sorting condition

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Category:OSGeo Member]]
 |?Name
 |?Address
 |?Country
 |?State
 |?City
 |?Coordinate
 |?LocalChapter
 |?Email
 |?Website
 |format=broadtable
 |limit=20
 |offset=50
 |sort=
 |order=asc
 |mainlabel=
 |searchlabel=Click here for a tabular overview
}}

Results 51 – 70 previous 20 20 50 100 250 500 next 20

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Category:OSGeo Member]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0445",
    "from_cache": false
}

Debug output SQLStore

ASK Query

[[Category:OSGeo Member]]

SQL Query

SELECT DISTINCT
t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`osgeo_smw_object_ids` AS t0
INNER JOIN
(`osgeo_smw_fpt_inst` AS t1
INNER JOIN
`osgeo_t2` AS t2 ON t1.o_id=t2.id) ON t0.smw_id=t1.s_id
WHERE
t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t2	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	osgeo_wiki.t2.id	10	Using index
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	osgeo_wiki.t1.s_id	1	Using where

Auxilliary Tables

Temporary table t2
Recursively computed hierarchy for element(s) (21765).
SELECT s_id FROM `osgeo_smw_fpt_subc` WHERE o_id=21765 LIMIT 1

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

	Name	Address	Country	State	City	Coordinate	LocalChapter	EmailThis property is a special property in this wiki.	Website
Alexneto	Alexandre Neto	Cascais, Portugal				38° 41' 50.17" N, 9° 25' 18.32" W
Algci2017	A. L.					35° 12' 3.60" N, 91° 49' 54.48" W
Alina Gerlée	Alina Gerlée		Poland		Warsaw	52° 14' 24.04" N, 21° 1' 2.21" E	Poland		http://www.alinagerlee.pl
Alireza Kashian
All Members
Alrocar	Alberto Romeu	Valencia, Spain				39° 28' 25.32" N, 0° 22' 50.16" W
Altjira	Greg R Perry	Towanda, United States				41° 50' 24.00" N, 76° 24' 0.00" W
Alukach
Alvaro Huarte
Alvaro Huarte
AlvinMN2015
Aman	aman		India	jammu and kashmir	jammu	33° 55' 12.00" N, 74° 14' 24.00" E	India
Amercader	Adrià Mercader	Newcastle upon Tyne				55° 0' 0.00" N, 1° 37' 12.00" W
Ameyad22	Ameya Deshmukh	Opp. Chanakyapuri, Shahnoormiya Dargah	India	Maharashtra	Aurangabad	19° 51' 21.94" N, 75° 20' 33.63" E	India
Amidacoder	Mimche Njikam Amida	Foumban, Cameroon	Cameroon	West	Foumban	5° 43' 13.05" N, 10° 54' 3.37" E	Africa Local Chapter	amida.njikam@gmail.com
Amyonthemap	Feng Amy Gao		USA	Maryland	Potomac	39° 1' 4.57" N, 77° 12' 34.04" W	North America
AnaLeticiaGIS	Ana Leticia Ma		United States	California	Los Angeles	34° 3' 7.92" N, 118° 14' 37.32" W	North America
AndersHjalmarson	Anders Hjalmarson		Sweden		LINKÖPING	58° 26' 14.60" N, 15° 21' 14.18" E	None
Andres Herrera	AndresHerrera	Cali, Colombia				3° 25' 17.68" N, 76° 30' 26.70" W
AndresHerrera	Andres Herrera	Cali, Colombia				76° 30' 26.70" S, 3° 25' 17.68" E

Semantic search

Query log

Navigation menu

Search