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

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

Subject Item

n11:this

foaf:made

n2:VirtSparqlCxmlPivotViewer

Subject Item

n26:this

sioc:creator_of

n2:VirtSparqlCxmlPivotViewer

Subject Item

n19:item

n18:services_of

n2:VirtSparqlCxmlPivotViewer

Subject Item

n16:this

sioc:creator_of

n2:VirtSparqlCxmlPivotViewer

Subject Item

n15:VOS

sioc:container_of

n2:VirtSparqlCxmlPivotViewer

atom:entry

n2:VirtSparqlCxmlPivotViewer

atom:contains

n2:VirtSparqlCxmlPivotViewer

Subject Item

n2:VirtSparqlCxmlPivotViewer

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:47:08.841147

dcterms:modified

2017-06-29T07:41:02.961807

rdfs:label

VirtSparqlCxmlPivotViewer

foaf:maker

n11:this n31:this

dc:title

VirtSparqlCxmlPivotViewer

opl:isDescribedUsing

n24:rdf

sioc:has_creator

n16:this n26:this

sioc:attachment

n5:jpg n7:jpg n8:jpg n9:jpg n12:jpg n13:jpg n14:jpg n28:jpg n29:jpg n30:jpg

sioc:content

---+Pivot Collections (Part 4) ---++Contents Part 1: [[VirtSparqlCxml][Introduction]] Part 2: [[VirtSparqlCxml][SparqlCxml]] Part 3: [[VirtSparqlCxmlDzcs][SparqlCxml Deep Zoom Collections]] Part 4: <nowiki>PivotViewer</nowiki> * [[#AncSparqlCxmlPivotViewer][<nowiki>PivotViewer</nowiki>]] * [[#AncPivotViewerUsage][Usage]] * [[#AncTableView][Table View]] * [[#AncMapView][Map View]] * [[#AncBingMaps][Bing Maps]] * [[#AncCrossDomainBrowsing][Cross-domain Collection Browsing]] Part 5: [[VirtSparqlCxmlImport][Importing CXML]] Part 6: [[VirtSparqlCxmlFacetPivotBridge][Facet Pivot Bridge]] Part 7: [[VirtSparqlCxmlDETs][DETs : Persisting SPARQL Query Results to DAV]] Part 8: [[VirtSparqlCxmlFAQs][Frequently Asked Questions (FAQs)]] Part 9: [[VirtSparqlCxmlGlossary][Glossary]] --- #AncSparqlCxmlPivotViewer ---++<nowiki>PivotViewer</nowiki> The Silverlight <nowiki>PivotViewer</nowiki> control makes it easy to view and interact with massive amounts of data on the web. The Virtuoso <nowiki>PivotViewer</nowiki> provides a container for a customized (subclassed) version of the control offering map and grid views of the data in addition to the standard tile view. The viewer can display both Virtuoso-generated and third-party collections, hosted locally on the viewer host or remotely. Other enhancements include the facility to bookmark static or dynamic collection URIs on popular social networking sites, in-place editing of SPARQL queries used for dynamic collection generation and collection permalink creation with automatic URL shortening. #AncPivotViewerUsage ---+++Usage After installing VAD pivot_dav.vad, <nowiki>PivotViewer</nowiki> is exposed as http://{cname}/PivotViewer/. Any browser with the Silverlight plugin installed can launch the Virtuoso <nowiki>PivotViewer</nowiki> application. Supported browsers currently include Internet Explorer, Firefox, Chrome, Opera and Safari on Windows and OS X. If the viewer is launched without specifying a collection URI, you will be prompted to supply one in the "Collection URL" textbox. Alternatively, the viewer will immediately load any collection specified in a query string, for example: <verbatim> http://kingsley.idehen.net/PivotViewer/?url=http%3A%2F%2Fkingsley.idehen.net%2Fc%2FLLPCJ%23%2524facet0%2524%3DSort%2520Label%26%2524view%2524%3D1%26%24tab%24%3D0%26%24zoom%24%3D2 </verbatim> In this instance the url parameter is a link to a dynamic "Solo Music Artist" collection, created through <nowiki>PivotViewer's</nowiki> permalink option. The query to generate the collection is: <verbatim> DEFINE sql:describe-mode "CBD" DESCRIBE ?s FROM <http://www.bbc.co.uk/music/> WHERE { ?s a mo:SoloMusicArtist; mo:image ?image; mo:musicbrainz ?musicbrainz; foaf:page ?href; foaf:name ?name; rdfs:comment ?comments. optional {?s mo:wikipedia ?wikipedia}. optional {?s mo:biography ?bio}. optional {?s mo:myspace ?myspace}. optional {?s mo:imdb ?imdb}. } LIMIT 100 </verbatim> executed against SPARQL endpoint http://lod.openlinksw.com/sparql. You can re-create this collection from scratch by pasting the query into Virtuoso's SPARQL query UI hosted at /sparql and setting "Format Results As" to "CXML (Pivot Collection)" <div style="margin: 10px 10px;"> <img src="%ATTACHURLPATH%/pv_solo_music_artist_qry_800w.jpg" style="wikiautogen"/> </div> After executing the query, the browser address bar contains the full URL-encoded SPARQL query <div style="margin: 10px 10px;"> <img src="%ATTACHURLPATH%/pv_solo_music_artist_qry_rslt_800w.jpg" style="wikiautogen"/><br/> <a href="%ATTACHURLPATH%/pv_solo_music_artist_qry_rslt.jpg" target="_blank">Click to enlarge</a> </div> Paste this into the URL text box displayed by /<nowiki>PivotViewer</nowiki> to view the collection: <div> <img src="%ATTACHURLPATH%/pv_solo_music_artist_800w.jpg" style="wikiautogen"/><br/> <a href="%ATTACHURLPATH%/pv_solo_music_artist.jpg" target="_blank">Click to enlarge</a> </div> Should you want to modify the source query to create a variant of the collection, it can be edited via <nowiki>PivotViewer</nowiki>'s "Edit" link: <div style="margin: 10px 10px;"> <img src="%ATTACHURLPATH%/pv_solo_music_artist_edit.jpg" style="wikiautogen"/> </div> <nowiki>PivotViewer</nowiki> offers three view styles - the standard tile view above, table and, if geolocation data is available, map. #AncTableView ---+++Table View The table view of the Solo Music Artist collection is shown below: <div style="margin: 10px 10px;"> <img src="%ATTACHURLPATH%/pv_solo_music_artist_grid_800w.jpg" style="wikiautogen"/><br/> <a href="%ATTACHURLPATH%/pv_solo_music_artist_grid.jpg" target="_blank">Click to enlarge</a> </div> The data in the table view can be manipulated by clicking on the cells in the table. Clicking on the name of an item in the Item column will select that item. The table will then only show rows that contain information about that particular item. The info pane for that item will also be displayed on the right hand side. Once a single item has been selected, clicking on any cell in the Item column will clear the selection and rows will be displayed for all items in the collection. Similarly, clicking on a facet in the Facet column will restrict the table to only showing that facet. Again, once a facet has been selected, clicking on any row in the Facet column will clear the selection. The values in the Value column can be used to set a collection filter in the same way that clicking on a value in the info pane sets a filter. Filters are cleared using the filter pane on the left hand side. In addition, clicking on values in the Value column that are URLs will open that URL. The table can be sorted on each column by clicking on the column headers. #AncMapView ---+++Map View An example map view, generated by a different query, is shown below: <div> <img src="%ATTACHURLPATH%/pv_map_1000w.jpg" style="wikiautogen"/><br/> <a href="%ATTACHURLPATH%/pv_map.jpg" target="_blank">Click to enlarge</a> </div> The SPARQL-FED query providing the collection is: <verbatim> ## Example using OpenEI (US Govt - Energy Dept) data PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX swivt: <http://semantic-mediawiki.org/swivt/1.0#> PREFIX resource: <http://openei.org/resources/> PREFIX category: <http://openei.org/resources/Category-3A> PREFIX property: <http://openei.org/resources/Property-3A> SELECT * WHERE { SERVICE <http://en.openei.org/sparql> {{ SELECT * WHERE { ?organization swivt:page ?page . ?organization property:Region resource:Bay_Area . ?organization rdfs:label ?name . OPTIONAL { ?organization foaf:depiction ?image . } OPTIONAL { ?organization property:Address ?address . } OPTIONAL { ?organization property:Zip ?zip . } OPTIONAL { ?organization property:Coordinates ?location . } OPTIONAL { ?organization property:Place ?place . ?place rdfs:label ?placename . } OPTIONAL { ?organization property:Sector ?sector . ?sector rdfs:label ?sectorname . } OPTIONAL { ?organization rdf:type ?category . ?category rdfs:label ?categoryname . } } LIMIT 100 }} } </verbatim> Notice the use of the reserved query variable ?location to indicate to <nowiki>SparqlCxml</nowiki> which property provides the map's geo-data. For more information, see VirtSparqlCxml section "Reserved Query Variable for Geodata" #AncBingMaps ---++++Bing Maps If possible, <nowiki>PivotViewer</nowiki> will use Bing Maps to create the map view. In order for Bing Maps to work, you must first add a Bing maps key to the Virtuoso registry. To do so: * Get a key from http://www.bingmapsportal.com/ * Register it in Virtuoso using the command: * <nowiki><code> registry_set ('_pivot_BingMapsKey','XXX'); </code></nowiki> where 'XXX' is replaced with your key. If a valid Bing key is not found, <nowiki>PivotViewer</nowiki> defaults to using a static Google map. #AncCrossDomainBrowsing ---+++Cross-domain Collection Browsing As well as displaying collections from the same site as itself, <nowiki>PivotViewer</nowiki> can display remote collections, provided the collection publisher has granted the necessary access. The Silverlight security model only allows a Silverlight application to make HTTP web requests to the domain that originally served the application. Cross-domain access to collections on another server requires either a clientaccesspolicy.xml or crossdomain.xml file allowing access from the site serving the Silverlight application. To view a collection served from a different site to that serving <nowiki>PivotViewer</nowiki>, one of these XML files must be present on the server hosting the collection. You may need to contact the system administrator for the server to ensure this is the case. If the collection is being generated by another Virtuoso server, the file must reside in the Virtuoso HTTP root directory identified by the <nowiki>ServerRoot</nowiki> entry in the HTTPServer section of the virtuoso.ini configuration file. Normally this is set to {virtuoso-root-directory}/vsp. Example clientaccesspolicy.xml and crossdomain.xml files are shown below. (The same content works for both.) The <nowiki>PivotViewer</nowiki> VAD includes an 'open' crossdomain.xml file which grants access from any domain. Your system administrator may prefer to restrict access through a more fine-grained policy. Either file can be used to grant cross-domain access. clientaccesspolicy.xml is specifically for Silverlight. crossdomain.xml serves the same purpose but for Flash. If a resource has been enabled for Flash, it then becomes available for Silverlight. If clientaccesspolicy.xml is not present, Silverlight will look for crossdomain.xml and use this instead. ---++++clientaccesspolicy.xml <verbatim> <cross-domain-policy> <allow-access-from domain="*"/> </cross-domain-policy> </verbatim> ---++++crossdomain.xml <verbatim> <cross-domain-policy> <allow-access-from domain="*"/> </cross-domain-policy> </verbatim> For more information on configuring access permissions in Silverlight, refer to MSDN article [[http://msdn.microsoft.com/en-us/library/cc645032%28VS.95%29.aspx][Network Security Access Restrictions in Silverlight]]. ---

sioc:id

66fd926ba81b4071123bb24917a743a4

sioc:link

n2:VirtSparqlCxmlPivotViewer

sioc:has_container

n15:VOS

n18:has_services

n19:item

atom:title

VirtSparqlCxmlPivotViewer

sioc:links_to

n2:VirtSparqlCxmlGlossary n4:aspx n2:VirtSparqlCxmlFacetPivotBridge n6: n2:VirtSparqlCxmlImport n2:VirtSparqlCxmlDETs n25: n2:VirtSparqlCxmlDzcs n2:VirtSparqlCxml

atom:source

n15:VOS

atom:author

n11:this

atom:published

2017-06-13T05:47:08Z

atom:updated

2017-06-29T07:41:02Z

sioc:topic

n15:VOS

Subject Item

n2:VirtVisualizeWithHtmlPivotViewer

sioc:links_to

n2:VirtSparqlCxmlPivotViewer