Welcome

• Sample 1: Retrieve all entities (of any type) in the "Bay Area" region
  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 property:Region resource:Bay_Area. ?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. }. }
  
• Sample 2: Retrieve all companies (regardless of region, sector, etc.)
  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: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. }. }
  
• Sample 3: Retrieve all networking organizations (regardless of region, sector, etc.)
  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. }. }
  
• Sample 4: Retrieve all research institutions (regardless of region, sector, etc.)
  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:Research_Institutions. ?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. }. }
  
• Sample 5: Retrieve all energy generation facilities (regardless of region, sector, etc.)
  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 ?capacity ?coordinates ?place_name ?developer_name ?owner_name FROM <http://openei.org> WHERE { ?facility swivt:page ?page. ?facility rdf:type category:Energy_Generation_Facilities. ?facility rdfs:label ?name. OPTIONAL { ?facility property:GeneratingCapacity ?capacity. }. OPTIONAL { ?facility property:Coordinates ?coordinates. }. OPTIONAL { ?facility property:Place ?place. ?place rdfs:label ?place_name. }. OPTIONAL { ?facility property:Developer ?developer. ?developer rdfs:label ?developer_name. }. OPTIONAL { ?facility property:Owner ?owner. ?owner rdfs:label ?owner_name. }. }
  
• Sample 6: Retrieve all ARRA Smart Grid projects (regardless of region, sector, etc.)
  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 ?awardee ?hq_city ?hq_state ?recovery_funding ?total_value FROM <http://openei.org> WHERE { ?project swivt:page ?page. ?project rdf:type category:Smart_Grid_Projects. ?project rdfs:label ?name. ?project property:Awardee ?awardee. ?project property:HeadquartersCity ?hq_city. ?project property:HeadquartersState ?hq_state. ?project property:RecoveryFunding ?recovery_funding. ?project property:TotalValue ?total_value. }
  
• Sample 7: Retrieve all policy organizations (regardless of region, sector, etc.)
  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:Policy_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. }. }
  
• Sample 8: Retrieve all financial organizations (regardless of region, sector, etc.)
  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:Financial_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. }. }