This website does readability filtering of other pages. All styles, scripts, forms and ads are stripped. If you want your website excluded or have other feedback, use this form.

Wikidata:SPARQL query service/Wikidata Query Help/Result Views - Wikidata

Wikidata:SPARQL query service/Wikidata Query Help/Result Views

From Wikidata < Wikidata:SPARQL query service‎ | Wikidata Query Help Jump to navigation Jump to search Translate this page; Other languages: Bahasa Indonesia • ‎Deutsch • ‎English • ‎Esperanto • ‎Türkçe • ‎català • ‎dansk • ‎español • ‎français • ‎italiano • ‎polski • ‎svenska • ‎Ελληνικά • ‎русский • ‎српски / srpski • ‎українська • ‎עברית • ‎العربية • ‎日本語

This page contains changes. Please contact a translation admin to mark them for translation.

Other languages: Bahasa Indonesia • ‎Deutsch • ‎English • ‎Esperanto • ‎Türkçe • ‎català • ‎dansk • ‎español • ‎français • ‎italiano • ‎polski • ‎svenska • ‎Ελληνικά • ‎русский • ‎српски / srpski • ‎українська • ‎עברית • ‎العربية • ‎日本語 Display button

This page helps you to understand the various possibilities to display results on SPARQL query service. The query example page contains many good examples you can try!

After running a query, you can choose with the "Display" button which result view you want to display. Depending on your query and the data type, some of the views will be available.

Contents

Table (default)[edit]

Shows the result data as a table. It is the default view for results and can display every data type.

Will map every variable from the SPARQL select clause to a formatted table column.

  • Table Result

  • Table Result on small screens with flipped columns

Image Grid[edit]

Image Grid Try Out

Shows the result data as a grid with images.

Every grid item has a big picture and opens the gallery when clicking on it.

Contents an item is the formatted row data.

VariableData TypeMappingDescription * Commons Media Grid Item Image columns will create a grid item.

Rows containing no image will be ignored.

Options[edit]

Option nameTypeDescription hide One or more variable names (strings, starting with ?), single value or array Don’t show these variables in the result.

Map[edit]

Shows the result data as map with Open Street Map data.

VariableData TypeMappingDescription * Coordinate or Geographic shape Map Marker Columns will create a marker on the map.

Content of that marker is the formatted row data.

?layer Map Marker Layer Creates a colored map layer that allows filtering. ?rgb Color Color Map Marker Example 000000 for black color.


Technically, any well-known text literal can be displayed, not just a point coordinate. Non-point geometry values are never stored on Wikidata, but they can be constructed in SPARQL using functions like CONCAT() and STRDT() – see this map of Czech railway lines for an example of LINESTRING() geometry.

Options[edit]

Option nameTypeDescription hide One or more variable names (strings, starting with ?), single value or array Don’t show these variables in the result. layer One or more variable names (strings, starting with ?), single value or array Use these variables for the map layer, instead of the default ?layerLabel, ?layer. markercluster boolean or object
  • If the value is an object, pass these options to Leaflet.markercluster, a map plugin for clustering nearby map markers. (If the value is the empty object {}, Leaflet.markercluster is enabled with its default options.)
  • If the value is true (default for queries without map layers), Leaflet.markercluster is enabled with a special set of options that doesn’t cluster any nearby map markers (it only “spiderfies” markers with exactly identical coordinates) and attempts to replicate the default map look as much as possible.
  • If the value is false (default for queries with map layers), Leaflet.markercluster is not enabled.

Line, Bar, Scatter and Area Chart[edit]

Shows one of these chart types.

VariableData TypeMappingDescription * Number

Label

DateTime

X-Axis

Y-Axis

First will be X-axis, second Y-axis * Label Category / Legend Item (optional) Will only be used after the above are mapped * Label Storyboard / Animation (optional) Will only be used after the above are mapped


Bubble Chart[edit]

Bubble Chart Try Out

Shows a bubble chart where the size and the color of the bubble can configured.

When an item is provided a bubble is linked to Wikidata.org.

VariableData TypeMapping * Label Bubble Label * Number Bubble Size * Item Bubble Link (optional) ?rgb Color Bubble Color (optional)

Tree Map[edit]

Tree Map Try Out

Shows a zoomable tree map.

VariableData TypeMappingDescription * Label Label 1st label in a row will be 1st level in tree map.

2nd label will be 2nd level.

3rd label will be 3rd level etc..

* Item Link (optional) * Quantity Size

Tree[edit]

Shows an expandable tree.

Tree Try Out VariableData TypeMappingDescription * Item Node ID First item will be a root node the following items in the same row will be nested. * Label Node Label (optional) Labels will be appended to current node. * Number Node Label (optional) * Commons Media Item image

Timeline[edit]

Timeline Try Out

Shows a explorable timeline.

VariableData TypeMappingDescription * DateTime Item Point in Time

Item End Point in Time

First date in a row sets the item position in the timeline.

If a second date is present a start and end date will be set.

* Commons Media Item image

Options[edit]

Option nameTypeDescription hide One or more variable names (strings, starting with ?), single value or array Don’t show these variables in the result.

Dimensions[edit]

Dimensions Try Out

Shows dimension and their links.

It also allows filtering them by selecting an axis fraction.

VariableData TypeMappingDescription * Label Dimension Every column in the result row is mapped to a dimension * Number * DateTime

Graph[edit]

Play media Graph browsing Abraham Lincoln Try Out

Shows an interactive graph that allow hierarchically ordering and exploring items.

VariableData TypeMappingDescription * Item Node ID First item in a row will have an arrow pointing to the items in the same row * Label Node Label (optional) * Commons Media Node Image (optional) ?rgb Color Node Color (optional) Example 000000 for black color. * Number Node Size (optional) ?edgeLabel Label Edge Label (optional) Graph Try Out

Additional Information[edit]

RDF Data Type Mapping[edit]

RDF TypeRDF Data TypeConstraintData Type URI String starts with
http://www.wikidata.org/entity/Q
Entity URI String starts with
http://commons.wikimedia.org/wiki/Special:FilePath
Commons Media Literal [www.w3.org] DateTime Literal [www.opengis.net] Coordinate Literal http://www.w3.org/2001/XMLSchema#double

http://www.w3.org/2001/XMLSchema#float

http://www.w3.org/2001/XMLSchema#decimal

http://www.w3.org/2001/XMLSchema#integer

http://www.w3.org/2001/XMLSchema#long

http://www.w3.org/2001/XMLSchema#int

http://www.w3.org/2001/XMLSchema#short

http://www.w3.org/2001/XMLSchema#nonNegativeInteger

http://www.w3.org/2001/XMLSchema#positiveInteger

http://www.w3.org/2001/XMLSchema#unsignedLong

http://www.w3.org/2001/XMLSchema#unsignedInt

http://www.w3.org/2001/XMLSchema#unsignedShort

http://www.w3.org/2001/XMLSchema#nonPositiveInteger

http://www.w3.org/2001/XMLSchema#negativeInteger

Number Literal Has no RDF Data Type Label Literal Has property
xml:lang
Label Literal String matches
/^[0-9A-F]{6}$/
Color

Formatting[edit]

There is special formatting for the following data types:

Data TypeFormat Entity Link to Wikidata.org

Label is shortened to wd:Qxx

Explore an item (magnify icon)

DateTime MM DD, YYYY

Tooltip shows raw ISO timestamp

Commons Media Link to Commons.Wikimedia.org

Displaying Gallery ( image icon )

Mobile / Responsive[edit]

Result views are made to work on different devices and resolutions. Their appearance may change depending on the space they can use.

Embed Mode[edit]

Result views can be linked or embedded via iframes. You can get the regarding link or code by clicking Link in the above menu. See the difference: link to a query and link to a result or the embed code:

<iframe style="width:80vw; height:50vh;" scrolling="yes" frameborder="0" src="http://tinyurl.com/zwf4k2w">

Download results[edit]

Download results buttons

There are several ways to export the results of a query.

JSON, TSV and CSV are three different open-standard formats to download the data, offered under the Download tab. To get results in XML format, click on Link > SPARQL endpoint.

You can also download some of the graphic views as a SVG file: this feature works with all the views except table, image grid, timeline, graph builder, map, and graph.

Default View[edit]

The default view can be change for each SPARQL query by using a comment:

#defaultView:[NAME]

For example:

#defaultView:ImageGrid

Result view options[edit]

Result views can be configured with various options, which are specified in JavaScript Object Notation (Q2063) format, either following the defaultView comment (see previous section) or following a separate view comment.

#defaultView:Map{"layer": "?typeLabel"}
#view:ImageGrid{"hide": "?coords"}

Auto language[edit]

When using the magic keyword [AUTO_LANGUAGE] it is replaced by the users language when submitting the query. This allows writing a query with where the result is display in the users language.

Example:

#Use language of the user for display labels and fallback to english as default
SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}

Auto coordinates[edit]

When using the magic keyword [AUTO_COORDINATES] it is replaced by the users location when submitting the query. This allows writing a query with the users' location.

Example:

  SERVICE wikibase:around {
    ?place wdt:P625 ?coordinate_location.
    bd:serviceParam wikibase:center "[AUTO_COORDINATES]".
    bd:serviceParam wikibase:radius "1".
    bd:serviceParam wikibase:distance ?dist.
  }
Retrieved from "[www.wikidata.org]" Categories: Hidden category:

Navigation menu

Personal tools

Namespaces

Variants

    Views

    More

      Navigation

      Print/export

      Tools

      In Wikipedia

        Add links