Openei

From solab
Revision as of 16:47, 27 April 2024 by Gio (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Name Value
Name Openei
Cat Solar
Product Web,
Homepage http://en.openei.org
has_location_city Web
Property:has_location_country Web
Property:has_coordinates
Photo File:Openei2.png
Photo Openei2.png



27 April 2024 16:47:27

Nrel

solab


http://en.openei.org/sparql

test

{{#gu_gen: pg |solab| postgres | select distinct subject, name from mysparqlopenei('Openei') |notrace=yes |WIKITABLE | | |llg }}

json

{{#gu_gen: pg |solab| postgres | select distinct r->>'name' as name from mysparqlopeneij('a') |notrace=yes |WIKITABLE | | |llg }}

sparql

  1. giosparql: 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 ?page ?name ?address ?place_name ?zip ?coordinates ?sector_name ?category_name
FROM <http://openei.org>
WHERE {
 ?organization swivt:page ?page.
 ?organization rdf:type category:Networking_Organizations.
 ?organization rdfs:label ?name.
 OPTIONAL { ?organization property:Address ?address. }.
 OPTIONAL { ?organization property:Zip ?zip. }.
 OPTIONAL { ?organization property:Coordinates ?coordinates. }.
 OPTIONAL {
   ?organization property:Place ?place.
   ?place rdfs:label ?place_name.
 }.
 OPTIONAL {
   ?organization property:Sector ?sector. 
   ?sector rdfs:label ?sector_name.
 }.
 OPTIONAL {
   ?organization rdf:type ?category.
   ?category rdfs:label ?category_name.
 }.
}
limit 100  |http://en.openei.org/sparql}}

sparql 1

http://en.openei.org/sparql

  1. giosparql: 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 ?page ?name ?address ?place_name ?zip ?coordinates ?sector_name ?category_name
FROM <http://openei.org>
WHERE {
?organization swivt:page ?page.
?organization rdf:type category:Networking_Organizations.
?organization rdfs:label ?name.
OPTIONAL { ?organization property:Address ?address. }.
OPTIONAL { ?organization property:Zip ?zip. }.
OPTIONAL { ?organization property:Coordinates ?coordinates. }.
OPTIONAL {
  ?organization property:Place ?place.
  ?place rdfs:label ?place_name.
}.
OPTIONAL {
  ?organization property:Sector ?sector. 
  ?sector rdfs:label ?sector_name.
}.
OPTIONAL {
  ?organization rdf:type ?category.
  ?category rdfs:label ?category_name.
}.

} |http://en.openei.org/sparql}}

  1. giosparql: 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 ?page ?name ?address ?place_name ?zip ?coordinates ?sector_name ?category_name
WHERE {
 ?organization swivt:page ?page.
 ?organization rdf:type category:Companies.
 ?organization rdfs:label ?name.
 OPTIONAL { ?organization property:Address ?address. }.
 OPTIONAL { ?organization property:Zip ?zip. }.
 OPTIONAL { ?organization property:Coordinates ?coordinates. }.
 OPTIONAL {
   ?organization property:Place ?place.
   ?place rdfs:label ?place_name.
 }.
 OPTIONAL {
   ?organization property:Sector ?sector. 
   ?sector rdfs:label ?sector_name.
 }.
 OPTIONAL {
   ?organization rdf:type ?category.
   ?category rdfs:label ?category_name.
 }.
}

limit 100 |http://en.openei.org/sparql}}