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

Display button

This page helps you to understand the various possibilities to display results on SPARQL query service.

Die Abfragebeispielseite enthält viele gute Beispiele, die du ausprobieren kannst!

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.

Tabelle (Standard)

Zeigt die Ergebnisse als Tabelle an. Das ist die Standardansicht für Ergebnisse und kann jeden Datentyp anzeigen.

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

• 
  Ergebnistabelle
• 
  Ergebnistabelle auf kleinen Bildschirmen, mit vertauschten Spalten

Image Grid

Image Grid Ausprobieren

Zeigt die Ergebnisdaten als Gitter mit Bildern an.

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

Contents an item is the formatted row data.

Variable	Datentyp	Mapping	Beschreibung
*	Commons Media	Grid Item	Image columns will create a grid item.

Rows containing no image will be ignored.

It’s nonetheless possible to include no image rows in the result by modifying the sparql by including a default image in case the image variable is not bound:

  optional {
    ?item wdt:P18 ?img_ .
  }
  bind (if(bound(?img_), 
           ?img_, 
           <http://commons.wikimedia.org/wiki/Special:FilePath/File:Profile_avatar_placeholder_large.png>) as ?image) # [[:commons:File:Profile_avatar_placeholder_large.png]] as a placeholder

Here the file commons:File:Profile avatar placeholder large.png is used as a placeholder, you can use your own

See a complete query example using this technique.

Optionen

Optionsname	Typ	Beschreibung
hide	One or more variable names (strings, starting with ?), single value or array	Zeige nicht diese Variablen als Ergebnis.

Karte

Zeigt die Ergebnisdaten als Karte mit OpenStreetMap-Daten an.

Variable	Datentyp	Mapping	Beschreibung
*	Koordinate	Kartenmarker	Spalten erstellen einen Marker auf der Karte Der Inhalt des Markers sind die #Formatting Rohdaten.
?layer		Kartenmarkerlayer	Erstellen eines gefärbten Kartenlayers mit Filterfunktion
?rgb	Farbe	Kartenmarken färben	Example 000000 for black color.

• 
  Karten mit Layers Ausprobieren
• 
  Karte von Flughäfen in Belgien Ausprobieren

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.

Optionen

specify using e.g. #defaultView:Map{"hide":["?foo", "?bar"],"layer":"?bar"}, using an array when there are multiple variables.

Optionsname	Typ	Beschreibung
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

Zeigt einen dieser Diagrammtypen.

Variable	Datentyp	Mapping	Beschreibung
*	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

• 
• File:Line Chart
• 
• File:Area Chart
• File:Bar Chart (Animated)
• 
• File:Scatter Chart (animated)

Bubble Chart

Bubble Chart

Ausprobieren

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.

Variable	Datentyp	Mapping
*	Label	Bubble Label
*	Number	Bubble Size
*	Item	Bubble Link (optional)
?rgb	Color	Bubble Color (optional)

Tree Map

Tree Map

Ausprobieren

Shows a zoomable tree map.

Variable	Datentyp	Mapping	Beschreibung
*	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

Shows an expandable tree.

Tree Try Out

Variable	Datentyp	Mapping	Beschreibung
*	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

Timeline

Ausprobieren

Shows a explorable timeline.

Variable	Datentyp	Mapping	Beschreibung
*	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

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

Dimensions

Dimensions

Ausprobieren

Shows dimension and their links.

It also allows filtering them by selecting an axis fraction.

This type of graph is also known as parallel coordinates.

Variable	Datentyp	Mapping	Beschreibung
*	Label	Dimension	Every column in the result row is mapped to a dimension
*	Number
*	DateTime

Graph

Graph browsing Abraham Lincoln

Ausprobieren

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

Variable	Datentyp	Mapping	Beschreibung
*	Item	Node ID	First item in a row of output variables 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)	Color of the item just before the rgb variable. Example 000000 for black color.
*	Number	Node Size (optional)
?edgeLabel	Label	Edge Label (optional)

Graph

Ausprobieren

Weitere Informationen

RDF-Datentypen-Mapping

RDF Type	RDF Data Type	Constraint	Data 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	http://www.w3.org/2001/XMLSchema#dateTime		DateTime
Literal	http://www.opengis.net/ont/geosparql#wktLiteral		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

Formatierung

Für die folgenden Datentypen gibt es spezielle Formatierungen:

Datentyp	Format
Entity	Link zu Wikidata.org Label is shortened to wd:Qxx Explore an item (magnify icon)
DateTime	MM DD, YYYY Der Tooltip zeigt die den rohen ISO-Timestamp
Commons Media	Link zu Commons.Wikimedia.org Displaying Gallery ( image icon )

Mobile / Responsive

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

Embed Mode

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">

Ergebnisse herunterladen

Download results buttons

Es gibt verschiedene Möglichkeiten, die Ergebnisse einer Abfrage zu exportieren.

JSON, TSV und CSV sind drei unterschiedliche, offene Standardformate um die Daten herunterzuladen. Sie finden diese optionen unter Download. Um die Daten im XML-Format zu erhalten, klicken sie auf 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

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

#defaultView:[NAME]

Zum Beispiel:

#defaultView:ImageGrid

Result view options

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

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

Title

Result views can show a title. The title can be set via a title comment.

#title:A title of your choice

Auto language

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 displayed in the users language.

Example:

#<span lang="en" dir="ltr" class="mw-content-ltr">Use language of the user for display labels and fallback to english as default</span>
SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}

Auto coordinates

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.
  }