This HTML5 document contains 66 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

PrefixNamespace IRI
n28http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/fct2.
n33http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/isprql2.
n25http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/isparql.
n10http://rdfs.org/sioc/services#
n6https://shop.openlinksw.com/license_generator/vad/?submitBtn=MakeLinkPage&vadPackage=http%3A%2F%2Fvirtuoso.openlinksw.com%2Fdata%2Fturtle%2Fapplications%2Fapplications.ttl%23
n38http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotViewer.
dchttp://purl.org/dc/elements/1.1/
n37http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotEdit.
n14http://vos.openlinksw.com/dataspace/owiki#
n27https://virtuoso.openlinksw.com/download/
n24http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/fctpiv.
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dctermshttp://purl.org/dc/terms/
n43http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotViewer9.
n9http://vos.openlinksw.com/dataspace/services/wiki/
rdfshttp://www.w3.org/2000/01/rdf-schema#
n21http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/both.
n44http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotViewer4.
n40http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotEdit3.
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
atomhttp://atomowl.org/ontologies/atomrdf#
n42http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotViewer8.
n26http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/fct1.
n11http://vos.openlinksw.com/dataspace/dav#
xsdhhttp://www.w3.org/2001/XMLSchema#
siochttp://rdfs.org/sioc/ns#
n15http://www.delicious.com/kidehen/
n17http://vos.openlinksw.com/dataspace/person/owiki#
n19http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/describe.
n36http://download3.openlinksw.com/HTML5/PivotViewer/html5pivotviewer-1.0.
n23http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/campsites.
oplhttp://www.openlinksw.com/schema/attribution#
n8http://vos.openlinksw.com/dataspace/person/dav#
n34http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/title2a.
n39http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotViewer3.
n30http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/title1.
n41http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotEdit4.
n20http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/describe2.
n45http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/PivotViewer7.
n35http://download3.openlinksw.com/HTML5/PivotViewer/html5pivotviewer-1.0.tar.
n13http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtVisualizeWithHtmlPivotViewer/sioc.
foafhttp://xmlns.com/foaf/0.1/
n31http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/isparql1.
siocthttp://rdfs.org/sioc/types#
n5http://vos.openlinksw.com/dataspace/owiki/wiki/
n29http://vos.openlinksw.com:80/wiki/main/VOS/VirtVisualizeWithHtmlPivotViewer/sparql.
Subject Item
n8:this
foaf:made
n2:VirtVisualizeWithHtmlPivotViewer
Subject Item
n11:this
sioc:creator_of
n2:VirtVisualizeWithHtmlPivotViewer
Subject Item
n9:item
n10:services_of
n2:VirtVisualizeWithHtmlPivotViewer
Subject Item
n14:this
sioc:creator_of
n2:VirtVisualizeWithHtmlPivotViewer
Subject Item
n5:VOS
sioc:container_of
n2:VirtVisualizeWithHtmlPivotViewer
atom:entry
n2:VirtVisualizeWithHtmlPivotViewer
atom:contains
n2:VirtVisualizeWithHtmlPivotViewer
Subject Item
n2:VOSIndex
sioc:links_to
n2:VirtVisualizeWithHtmlPivotViewer
Subject Item
n2:VirtVisualizeWithHtmlPivotViewer
rdf:type
atom:Entry sioct:Comment
dcterms:created
2018-04-19T06:29:34.146728
dcterms:modified
2019-05-30T18:31:15.198818
rdfs:label
VirtVisualizeWithHtmlPivotViewer
foaf:maker
n8:this n17:this
dc:title
VirtVisualizeWithHtmlPivotViewer
opl:isDescribedUsing
n13:rdf
sioc:has_creator
n11:this n14:this
sioc:attachment
n19:png n20:png n21:png n23:png n24:png n25:png n26:png n28:png n29:png n30:png n31:png n33:png n34:png n37:png n38:png n39:png n40:png n41:png n42:png n43:png n44:png n45:png
sioc:content
%META:TOPICPARENT{name="VOSIndex"}% ---+ Visualizing Your Data With <nowiki>HtmlPivotViewer</nowiki> The <nowiki>HtmlPivotViewer</nowiki> jQuery control is a great way to explore datasets in a web browser. The Virtuoso <nowiki>HtmlPivotViewer</nowiki> application extends this control to add a SPARQL query editor, sharing with social media, and Google translation. This guide shows you how to install and configure the Virtuoso <nowiki>HtmlPivotViewer</nowiki> application to view existing data sets and how to configure Virtuoso so that you can generate collections from your own data. * [[#ViewColl][Part 1. Viewing Collections]] * [[#GenColl][Part 2. Generating your own Collections]] * [[#GenPivotViewer][2.1 Using HtmlPivotViewer]] * [[#GenSPARQL][2.2 Using SPARQL]] * [[#GenFCT][2.3 Using The Facet Browser]] * [[#GeniSPARQL][2.4 Using iSPARQL]] * [[#SeeAlso][Related]] #ViewColl ---++ Part 1. Viewing Collections ---+++ Prerequisites * A Virtuoso Server with the following VAD packages installed: * The [[https://shop.openlinksw.com/license_generator/vad/?submitBtn=MakeLinkPage&vadPackage=http%3A%2F%2Fvirtuoso.openlinksw.com%2Fdata%2Fturtle%2Fapplications%2Fapplications.ttl%23CUriVad][c_uri_dav.vad]] VAD. This package contains a URL shortener that the <nowiki>HtmlPivotViewer</nowiki> application relies on to shorten the very long URIs that can result from generating a collection from a query. * The [[https://shop.openlinksw.com/license_generator/vad/?submitBtn=MakeLinkPage&vadPackage=http%3A%2F%2Fvirtuoso.openlinksw.com%2Fdata%2Fturtle%2Fapplications%2Fapplications.ttl%23Html5PivotViewerVad][html5pivotviewer_dav.vad]] VAD<nowiki>HtmlPivotViewer</nowiki> VAD. This VAD is included in the <nowiki>HtmlPivotViewer</nowiki> project that can be downloaded as either a [[http://download3.openlinksw.com/HTML5/PivotViewer/html5pivotviewer-1.0.zip][zip file]] or [[http://download3.openlinksw.com/HTML5/PivotViewer/html5pivotviewer-1.0.tar.gz][compressed tar archive]]. The VAD package contains the <nowiki>HtmlPivotViewer</nowiki> application. Once these VAD packages are installed, viewing an existing collection is as simple as pointing your browser to the <nowiki>HtmlPivotViewer</nowiki> application on your server, i.e. -- <verbatim> http://your server address:your server port/HtmlPivotViewer </verbatim> -- and typing the collection address in the box on the page. %BR%%BR%<img src="%ATTACHURLPATH%/PivotViewer.png" style="wikiautogen"/>%BR%%BR% Alternatively, you can specify the address of the collection as a parameter to the URL, e.g. -- <verbatim> http://{your server address}[:{your server port}]/HtmlPivotViewer?url=http%3A%2F%2Ftweetpivot.com%2Fcollections%2Ffriends_kidehen.cxml </verbatim> <strong>Note:</strong> The collection address must be URL Encoded if given as part of the URL. You can now start exploring existing pivot collections. #GenColl ---++Part 2. Generating your own Collections Once you have the <nowiki>HtmlPivotViewer</nowiki> installed, you will want to start generating pivot collections from your own data. There are a number of ways ways you can do this. One method is to generate a collection from the results of a SPARQL query. The <nowiki>HtmlPivotViewer</nowiki> includes its own SPARQL query editor, or you can use the SPARQL endpoint on any Virtuoso server. Alternatively, you can generate a collection from a result set created in the facet browser. You will need to install some additional packages, whichever method you use. ---+++Prerequisites * The [[https://shop.openlinksw.com/license_generator/vad/?submitBtn=MakeLinkPage&vadPackage=http%3A%2F%2Fvirtuoso.openlinksw.com%2Fdata%2Fturtle%2Fapplications%2Fapplications.ttl%23SparqlCxmlVad][SPARQL-CXML VAD]] (<code><nowiki>sparql_cxml_dav.vad</nowiki></code>). This package supports generating a collection from a SPARQL endpoint, and it is also required to use the SPARQL editor in the Virtuoso <nowiki>HtmlPivotViewer</nowiki>. It also installs some example data that will be used in the rest of this guide. * The Virtuoso <nowiki>ImageMagick</nowiki> and QR Code plugins needs to be enabled. In your <code>virtuoso.ini</code>, in the <code>[Plugins]</code> section, make sure you have lines for "<code>plain, im</code>" and "<code>plain, qrcode</code>", like this -- <verbatim> [Plugins] LoadPath=../hosting ... Load6=plain, im Load7=plain, qrcode </verbatim> Remember to restart Virtuoso if you make any changes to your <code>virtuoso.ini</code>. <strong>Note:</strong> The SPARQL-CXML package extends the SPARQL endpoint on the Virtuoso server where the package is installed. This extension is required to be able to generate a pivot collection from the query results. It is however possible to generate a pivot collection from a query against a third-party SPARQL endpoint or from a Virtuoso SPARQL endpoint that does not have the package installed, by using a SPARQL-FED query from the Virtuoso instance that <strong>does</strong> have the SPARQL-CXML package installed. #GenPivotViewer ---+++2.1 Generating a Collection from a SPARQL Query In <nowiki>HtmlPivotViewer</nowiki> The <nowiki>HtmlPivotViewer</nowiki> application contains its own SPARQL editor. In this example, you will see how to generate a collection from a simple <code>DESCRIBE</code> query; and also how to generate a collection from a SPARQL <code>SELECT</code> query, and then modify the query to meet your specific requirements. ---++++2.1.1 Generating the Collection - Using a SPARQL <code>DESCRIBE</code> Point your browser at the <nowiki>HtmlPivotViewer</nowiki> application on your server, i.e. -- <verbatim> http://your server address:your server port/HtmlPivotViewer </verbatim> -- and then select the <strong>Edit</strong> link in the top-right-corner. You can type your query directly into the <strong>Query Text</strong> box in the form. The simplest way to get an overview of the data in a particular graph is to use a SPARQL <code>DESCRIBE</code> query. For example: <verbatim> DESCRIBE ?s FROM <http://pivot_test_data/ski_resorts> WHERE {?s ?p ?o} </verbatim> creates a collection where each item is a ski resort with various facets giving further information about each resort. %BR%%BR%<img src="%ATTACHURLPATH%/describe.png" style="wikiautogen"/>%BR%%BR% Click on the <strong>View</strong> button at the foot of the page to view the collection in <nowiki>HtmlPivotViewer</nowiki>. %BR%%BR%<img src="%ATTACHURLPATH%/describe2.png" style="wikiautogen"/>%BR%%BR% <strong>Note: </strong>If at this point you see the <nowiki>HtmlPivotViewer</nowiki> but it is completely empty, then it is likely that the SPARQL-CXML VAD has not been correctly installed. However, if you see the <nowiki>HtmlPivotViewer</nowiki> with the filter pane correctly loaded but no item images showing and if the position of the images can be highlighted, then it is likely that you have not enabled the <nowiki>ImageMagick</nowiki> plugin for Virtuoso. ---++++2.1.2 Generating the Collection - Using a SPARQL <code>SELECT</code> If you want more control over the way the collection is generated from your data you can use a <code>SELECT</code> query. This simple <code>SELECT</code> query will return all of the items in the <code><nowiki>http://pivot_test_data/ski_resorts</nowiki></code> graph, part of the example dataset. In the following sections you will see how this simple query can be modified to change the way that collection is generated. <verbatim> SELECT * FROM <http://pivot_test_data/ski_resorts> WHERE {?s ?p ?o} </verbatim> Execute the query and display the results in <nowiki>HtmlPivotViewer </nowiki> by clicking the <strong>View</strong> button at the foot of the edit form. %BR%%BR%<img src="%ATTACHURLPATH%/PivotEdit.png" style="wikiautogen"/>%BR%%BR% You should see the collection like this: %BR%%BR%<img src="%ATTACHURLPATH%/PivotViewer4.png" style="wikiautogen"/>%BR%%BR% If you want to save or share the query, you can do so using the <strong>permalink</strong> at the top-right-corner of the page. If you need to fine tune your query, you can return to the editor by clicking on the <strong>Edit</strong> link. For example, the query that we used to generated this first collection gives us all the items in the ski resorts graph. We can easily change it to get the items in the campsite graph by changing the from clause in the query: <verbatim> SELECT * FROM <http://pivot_test_data/campsites> WHERE {?s ?p ?o} </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/PivotEdit3.png" style="wikiautogen"/>%BR%%BR% Then click on <strong>View</strong> to see the new collection. %BR%%BR%<img src="%ATTACHURLPATH%/campsites.png" style="wikiautogen"/>%BR%%BR% Alternatively, we can see both campsites and ski resorts using the following query: <verbatim> PREFIX ski: <http://www.openlinksw.com/ski_resorts/schema#> PREFIX camp: <http://www.openlinksw.com/campsites/schema#> SELECT * WHERE { { ?s a ski:SkiResort . ?s ?p ?o } UNION { ?s a camp:Campsite . ?s ?p ?o } } </verbatim> %BR%%BR% <img src="%ATTACHURLPATH%/PivotEdit4.png" style="wikiautogen"/>%BR%%BR% %BR%%BR% <img src="%ATTACHURLPATH%/both.png" style="wikiautogen"/>%BR%%BR% ---++++2.1.3 Item Images In the examples so far, all items are represented by the same icon. It would be helpful if different items had different images. We have reserved some special variables in the SPARQL query to help control collection generation, and one of those variables is <strong><code>?image</code></strong>. If we can find an image of the item in the collection and call it <code>?image</code>, then when the collection is generated that item will be represented by its image. So, for example, we can use the following query to find images of some of the ski resorts in the example dataset -- <verbatim> PREFIX ski: <http://www.openlinksw.com/ski_resorts/schema#> PREFIX camp: <http://www.openlinksw.com/campsites/schema#> SELECT * WHERE { { ?s a ski:SkiResort . ?s ?p ?o . OPTIONAL { ?s foaf:depiction ?image } } UNION { ?s a camp:Campsite . ?s ?p ?o . OPTIONAL { ?s foaf:depiction ?image } } } </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/PivotViewer8.png" style="wikiautogen"/>%BR%%BR% It would also be helpful to distinguish between the different types of items; in this case, the ski resorts (without images) and the campsites. Even if an item does not have its own image, we can change the default image depending on the type of the item. To do this we use another reserved variable, <strong><code>?itemtype</code></strong>. Our example query then becomes -- <verbatim> PREFIX ski: <http://www.openlinksw.com/ski_resorts/schema#> PREFIX camp: <http://www.openlinksw.com/campsites/schema#> SELECT * WHERE { { ?s a ski:SkiResort . ?s ?p ?o ; a ?itemtype . OPTIONAL { ?s foaf:depiction ?image } } UNION { ?s a camp:Campsite . ?s ?p ?o ; a ?itemtype . OPTIONAL { ?s foaf:depiction ?image } } } </verbatim> -- and we can clearly see which items are campsites. %BR%%BR%<img src="%ATTACHURLPATH%/PivotVIewer9.png" style="wikiautogen"/>%BR%%BR% ---++++2.1. Item Names If one of the campsite or ski resort items is selected in <nowiki>HtmlPivotViewer</nowiki>, the info box opens on the right hand side of the page. It is headed with the name of the item, but in our example that name is in fact a URI for the item. %BR%%BR%<img src="%ATTACHURLPATH%/title1.png" style="wikiautogen"/>%BR%%BR% In our example, just the name of the item would be sufficient, and it would be more readable. In the case of the campsites, we can use the <code>rdfs:label</code> as the name, while in the case of the ski resorts, we need to use the <code>ski:resort_name</code>. The pattern is optional in case some of the items do not have the necessary attribute defined -- <verbatim> PREFIX ski: <http://www.openlinksw.com/ski_resorts/schema#> PREFIX camp: <http://www.openlinksw.com/campsites/schema#> SELECT * WHERE { { ?s a ski:SkiResort . ?s ?p ?o ; a ?itemtype . OPTIONAL { ?s ski:resort_name ?name } . OPTIONAL { ?s foaf:depiction ?image } } UNION { ?s a camp:Campsite . ?s ?p ?o ; a ?itemtype . OPTIONAL { ?s rdfs:label ?name } . OPTIONAL { ?s foaf:depiction ?image } } } </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/title2a.png" style="wikiautogen"/>%BR%%BR% ---++++2.1.5 Facets The collection we are have generated has two facets, called <code><nowiki>virtcxml:FacetP</nowiki></code> and <code><nowiki>virtcxml:FacetO</nowiki></code>, that map to the predicate (<code>?p</code>) and object (<code>?o</code>) as returned by the simple, generic <code>?s ?p ?o</code> pattern that we have in the <code>WHERE</code> clause of the SPARQL <code>SELECT</code> that we are using. We can control which facets the items in the collection have by having a separate pattern for each facet that we are interested in, and by giving them meaningful names. Some facets will be available on all items, while some will only be relevant to one type of item. For example, all items in our collection have a country code, but only the ski resorts have altitude facets. <verbatim> PREFIX ski: <http://www.openlinksw.com/ski_resorts/schema#> PREFIX camp: <http://www.openlinksw.com/campsites/schema#> SELECT * WHERE { { ?s a ski:SkiResort . ?s a ?itemtype ; geonames:countryCode ?country ; ski:resort_name ?name ; ski:beginner_slopes ?beginner_slopes ; ski:intermediate_slopes ?intermediate_slopes ; ski:advanced_slopes ?advanced_slopes ; ski:expert_slopes ?expert_slopes ; ski:altitude_m ?altitude . OPTIONAL { ?s foaf:depiction ?image } } UNION { ?s a camp:Campsite . ?s a ?itemtype ; geonames:countryCode ?country ; rdfs:label ?name ; campsite:resort_type ?resort_type ; campsite:resort ?resort ; campsite:region ?region ; campsite:category ?category . OPTIONAL { ?s foaf:depiction ?image } } } </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/PivotViewer7.png" style="wikiautogen"/>%BR%%BR% #GenSPARQL ---+++2.2 Generating a Collection from a SPARQL Endpoint The SPARQL-CXML VAD package extends the Virtuoso SPARQL endpoint to add "CXML collection" as an alternative output format for query results. This example uses the same basic query that was used in the previous section, but executes it in the Virtuoso SPARQL endpoint. ---++++2.2.1 Generating the Collection The first step in generating the collection is the SPARQL query that returns the results that you are interested in. Point your browser at the Virtuoso SPARQL endpoint. It will be here: <verbatim> http://your server address:your server port/sparql </verbatim> The following query will return all items in the <code><nowiki>http://pivot_test_data/ski_resorts</nowiki></code> graph, part of the example dataset -- <verbatim> SELECT * FROM <http://pivot_test_data/ski_resorts> WHERE {?s ?p ?o} </verbatim> By default, the results will be shown as a table in your browser. We need the results as a <nowiki>HtmlPivotViewer</nowiki> collection. Alternate result formats can be selected in a drop-down box below the query form. Choose <i>CXML (Pivot collection)</i> -- %BR%%BR% <img src="%ATTACHURLPATH%/sparql.png" style="wikiautogen"/>%BR%%BR% Run the query and, depending on your browser, the result set may now be displayed as XML. If you are using Safari, you will just see a blank page, but if you view the source of the page you will see the XML. To use this collection in <nowiki>HtmlPivotViewer</nowiki>, you simply copy the contents of the browser's address bar, and use that as the collection address in <nowiki>HtmlPivotViewer</nowiki>. So, open <nowiki>HtmlPivotViewer</nowiki>, paste the address from the SPARQL query results in the collection URL box, and click submit. %BR%%BR%<img src="%ATTACHURLPATH%/PivotViewer3.png" style="wikiautogen"/>%BR%%BR% You should see the collection like this: %BR%%BR%<img src="%ATTACHURLPATH%/PivotViewer4.png" style="wikiautogen"/>%BR%%BR% Once you have opened the collection in <nowiki>HtmlPivotViewer</nowiki>, any additional editing of the query can be done using the <nowiki>HtmlPivotViewer</nowiki> editor by simply clicking on the <strong>Edit</strong> link at the top right hand corner. <strong>Tip:</strong> If a query in the <nowiki>HtmlPivotViewer</nowiki> editor is failing, pasting it into the Virtuoso SPARQL endpoint and attempting to run it there may reveal some additional error information which may help you resolve the problem. #GenFCT ---+++2.3 Generating a Collection Using The Facet Browser Using the Facet browser to create collections requires some extra packages. Once these packages are installed, generating the collection is very straightforward. You use the Facet browser to create a result set; then click on the <strong>Make Pivot Collection link</strong>. ---++++Prerequisites * The [[https://virtuoso.openlinksw.com/download/][Cartridges VAD]] (<code><nowiki>cartridges_dav.vad</nowiki></code>). This package provides base RDF functionality and the Sponger framework for converting non-RDF data to RDF. * The [[https://virtuoso.openlinksw.com/download/][Virtuoso Facets web service]] (<code><nowiki>fct_dav.vad</nowiki></code>) A general purpose RDF query facility for facet based browsing. * The [[https://virtuoso.openlinksw.com/download/][Facet Pivot Bridge]] (<code><nowiki>fct_pivot_bridge.vad</nowiki></code>). This package extends the Facets web service so a collection can be generated from the faceted query result sets. ---++++2.3.1 Generating the Collection The Facet browser service will be found at <verbatim> http://your server address:your server port/fct </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/fct1.png" style="wikiautogen"/>%BR%%BR% Type the word "resort" in the search box. This should find both the campsites and the ski resorts. The result set can be manipulated to only include the items that you are interested in. For example, by selecting <strong>Types</strong> in the <strong>Entity Relations Navigation</strong> pane, you can limit the result set to just items of the type <code><nowiki>ski:SkiResort</nowiki></code>. %BR%%BR%<img src="%ATTACHURLPATH%/fct2.png" style="wikiautogen"/>%BR%%BR% Once you have the result set that you want, click on the <strong>Make Pivot Collection</strong> link at the top of the page. This creates the collection, and opens it in <nowiki>HtmlPivotViewer</nowiki>. %BR%%BR%<img src="%ATTACHURLPATH%/fctpiv.png" style="wikiautogen"/>%BR%%BR% #GeniSPARQL ---+++2.4 Generating a Collection from iSPARQL To generate a collection from the iSPARQL interface, you will need to install an extra package. ---++++Prerequisites * The [[https://virtuoso.openlinksw.com/download/][iSPARQL VAD]] (<code><nowiki>isparql_dav.vad</nowiki></code>). This package installs iSPARQL, a graphical utility for building and executing SPARQL queries. ---++++2.4.1 Generating the Collection Point your browser at the iSPARQL interface on your server. It can be found at <verbatim> http://your server address:your server port/isparql </verbatim> It will open to a page like this: %BR%%BR%<img src="%ATTACHURLPATH%/isparql.png" style="wikiautogen"/>%BR%%BR% From the three tabs in the top center, choose the <strong>Advanced</strong> tab. This will open a page where you can type in a query. Use the following <code>DESCRIBE</code> query: <verbatim> DESCRIBE ?s FROM <http://pivot_test_data/ski_resorts> WHERE {?s ?p ?o} </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/isparql1.png" style="wikiautogen"/>%BR%%BR% Click on the arrow-in-a-blue-circle to run the query. The results page will be opened, showing the ski resorts that have been found. %BR%%BR%<img src="%ATTACHURLPATH%/isprql2.png" style="wikiautogen"/>%BR%%BR% To make a pivot collection from these results, simply click on the <strong>Make Pivot</strong> link in the top left corner of the results pane. This will open the link in the <nowiki>HtmlPivotViewer</nowiki>. %BR%%BR%<img src="%ATTACHURLPATH%/isparql3.png" style="wikiautogen"/>%BR%%BR% #SeeAlso ---++ Related * [[VirtSparqlCxmlPivotViewer][Additional PivotViewer Guide]] * <nowiki>PivotViewer</nowiki> Demo Collections * [[http://www.delicious.com/kidehen/logd_demo][Linked Open Government-Oriented Demos]] * [[http://www.delicious.com/kidehen/pivot_collection_app][General PivotViewer + Linked Data Demos]] * [[http://www.delicious.com/kidehen/sparql_fed_demo][SPARQL-FED (Distributed or Federated SPARQL)-based Dynamic CXML and PivotViewer Demos]] * [[http://www.delicious.com/kidehen/qrcode_use_demo][Demos where the SPARQL-based CXML generation includes QR Code generation]] * [[http://www.delicious.com/kidehen/bbc_linkeddata][BBC-specific Demos]] * [[http://www.delicious.com/kidehen/meshup][Various Meshups]] (not "Mashups," since these are driven by Linked Data, rather than by code) * [[http://www.delicious.com/kidehen/goodrelations][Linked Data-Driven eCommerce-Oriented PivotViewer Demos]]
sioc:id
e76fb29ca534470dacc4da015cfc2163
sioc:link
n2:VirtVisualizeWithHtmlPivotViewer
sioc:has_container
n5:VOS
n10:has_services
n9:item
atom:title
VirtVisualizeWithHtmlPivotViewer
sioc:links_to
n2:VirtSparqlCxmlPivotViewer n6:SparqlCxmlVad n15:goodrelations n15:bbc_linkeddata n15:meshup n15:sparql_fed_demo n15:qrcode_use_demo n15:logd_demo n15:pivot_collection_app n27: n35:gz n36:zip n6:CUriVad n6:Html5PivotViewerVad
atom:source
n5:VOS
atom:author
n8:this
atom:published
2018-04-19T06:29:34Z
atom:updated
2019-05-30T18:31:15Z
sioc:topic
n5:VOS