2e:null 2f:["$","title",null,{"children":"Map of All the Wind Farms / Solar Power Plants in the United States Using the OpenEI Knowledge Graph / RDF / SPARQL Query Service | Damien LIEBER | Observable"}] 34:T734,{ // Landmass for the U.S. const landmass = vl .markGeoshape() // Get the shape for the U.S. from the us-atlas npm module. .data( vl .topojson("https://unpkg.com/us-atlas@3/states-10m.json") .feature("states") ) .encode(vl.stroke().value("lightgray"), vl.color().value(null)); // Add points for each place const points = vl .markCircle({ size: 20 }) .data(query_results_extract) .encode( vl.longitude().fieldQ("longitude"), vl.latitude().fieldQ("latitude"), vl.tooltip([ { field: "facility_label", type: "nominal", title: "Facility Name" }, { field: "place_name", type: "nominal", title: "Location" }, { field: "FacilityType", type: "nominal", title: "Facility Type" }, { field: "FacilityStatus", type: "nominal", title: "Facility Status" }, { field: "GeneratingCapacity", type: "quantitative", title: "Generating Capacity [MW]" }, { field: "NumberOfUnits", type: "quantitative", title: "Number Of Units [-]" }, { field: "page", type: "nominal", title: "Link to OpenEI Wiki" } ]), vl .size() .fieldQ(valueKeyName) .scale({ domain: [dotSizeRange[0], dotSizeRange[1]] }) .legend(true), vl .color() .fieldN(colorKeyName) .legend(true), vl .order() .fieldQ(valueKeyName) .sort('descending') // place smaller circles on top ); // Return a combined view return vl .layer(landmass, points) // Layer the views together. .project(vl.projection("albersUSA")) .width(900) .height(500) .autosize({ type: "fit-x", contains: "padding" }) .config({ view: { stroke: null } }) .render(); }35:T5e7,SPARQL_query = `#Map all wind turbines in the US as on https://openei.org/wiki/Map_of_Wind_Farms #defaultView: Geo PREFIX xsd: PREFIX ref: PREFIX rdf: PREFIX rdfs: PREFIX swivt: PREFIX resource: PREFIX category: PREFIX property: SELECT ?facility ?facility_label ?FacilityType ?NumberOfUnits ?FacilityStatus ?GeneratingCapacity ?place_name ?latitude ?longitude ?page FROM WHERE { ?facility rdf:type category:Energy_Generation_Facilities; property:Sector resource:${energy_source}; swivt:page ?page. OPTIONAL{?facility rdfs:label ?facility_label} OPTIONAL{?facility property:FacilityType ?FacilityType} OPTIONAL{?facility property:FacilityStatus ?FacilityStatus} OPTIONAL{?facility property:GeneratingCapacity ?GeneratingCapacity} OPTIONAL{?facility property:Coordinates-23aux ?Coordinates. BIND(STRBEFORE(?Coordinates,',') as ?latitude) BIND(STRAFTER(?Coordinates,',') as ?longitude) BIND(STRDT(CONCAT('Point(',str(?longitude),' ',str(?latitude),')'), xsd:string) as ?geo_point)} OPTIONAL{?facility property:Place ?place_name} OPTIONAL{?facility property:NumberOfUnits ?NumberOfUnits} } ORDER BY desc(?GeneratingCapacity)`36:[] 32:{"id":"f1768b738995c31d","slug":"map-of-all-the-wind-farms-in-the-united-states-using-the-opene","title":"Map of All the Wind Farms / Solar Power Plants in the United States Using the OpenEI Knowledge Graph / RDF / SPARQL Query Service","thumbnail":"0992e8bbe0f8e735a1eb405afcd18e64c4802164f349f23c0420e56ad8a7626f","access_level":"public","create_time":"$D2020-07-21T22:44:21.700Z","update_time":"$D2020-07-29T22:30:39.128Z","view_time":null,"first_public_time":"$D2020-07-22T15:55:47.319Z","has_unpublished_edits":null,"fork":{"id":"b8395bdbc9e78a31","slug":"openei-sparql-tool-find-predicate-object-pairs-for-a-given-v","title":"OpenEI SPARQL tool: explore predicate/object pairs for a given value based on the Wiki page URL and visualize as a hierarchy / tidy tree","owner":{"id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER"}},"stars":1,"starred":false,"owner":{"type":"team","id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":"starter_2024"},"version":552,"publish_version":552,"role":null,"authored":false,"authors":[{"type":"individual","id":"c095b1fa4a790aee","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":null}],"members":[{"type":"individual","id":"c095b1fa4a790aee","login":"damienlieber","name":"Damien LIEBER","avatar_url":"https://avatars-next.observableusercontent.com/0e1f2b0778dcdd3cb2dd2365e32c6c023e6371c8c102eab5dcf2b22b76cb3064","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"25e626badc333ea1","slug":"energy","title":"Energy","owner":{"id":"f1833863e1ef8994","login":"damienlieber","name":"Damien LIEBER"}},"type":"notebook","body":{"title":"Map of All the Wind Farms / Solar Power Plants in the United States Using the OpenEI Knowledge Graph / RDF / SPARQL Query Service","cells":[{"id":0,"value":"md`# Map of All the Wind Farms / Solar Power Plants in the United States Using the OpenEI Knowledge Graph / RDF / SPARQL Query Service`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":347,"value":"md`*Note: may need to wait a few seconds for notebook to fetch data using the query*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"md`## Map visualization`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"md`## User input:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"viewof energy_source = radio({\n title: 'Select type of energy:',\n options: [{ label: 'Wind Energy', value: 'Wind_energy' }, 'Solar'],\n value: \"Wind_energy\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"viewof valueKeyName = radio({\n title: 'Select numerical attribute to visualize as dot size:',\n options: [\n { label: 'Generating Capacity', value: 'GeneratingCapacity' },\n { label: 'Number Of Units', value: 'NumberOfUnits' }\n ],\n value: \"GeneratingCapacity\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"viewof colorKeyName = radio({\n title: 'Select string attribute to visualize as dot color:',\n options: [\n { label: 'Facility Type', value: 'FacilityType' },\n { label: 'Facility Status', value: 'FacilityStatus' }\n ],\n value: \"FacilityType\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":400,"value":"viewof dotSizeRange = rangeSlider({\n format: ',.2r',\n title: 'Dot Size Range',\n description: 'Note: dots < left slider will not be displayed because < 1 px.',\n min: query_results_extract.reduce(\n (min, seq) => (seq[valueKeyName] < min ? seq[valueKeyName] : min),\n query_results_extract[0][valueKeyName]\n ),\n max: query_results_extract.reduce(\n (max, seq) => (seq[valueKeyName] > max ? seq[valueKeyName] : max),\n query_results_extract[0][valueKeyName]\n ),\n value: [\n query_results_extract.reduce(\n (min, seq) => (seq[valueKeyName] < min ? seq[valueKeyName] : min),\n query_results_extract[0][valueKeyName]\n ),\n 1500\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":513,"value":"md`## Notes:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"md`**Total installed generating capacity found in OpenEI:** ${total_value.toFixed(\n 1\n)} MW`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"md`Goal is to replicate https://openei.org/wiki/Map_of_Wind_Farms`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"md`**_ Note: Total installed wind generating capacity found in OpenEI as of 7/29/2020:_** *118,922.8 MW vs reference datum of 107,319 MW in Q1 2020 ([Source](https://windexchange.energy.gov/maps-data/321)), giving confidence in comprehensiveness of dataset*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"md`___\n# Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"md`## Work-In-Progress`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":274,"value":"maximum_value = query_results_extract.reduce(\n (max, seq) => (seq[valueKeyName] > max ? seq[valueKeyName] : max),\n query_results_extract[0][valueKeyName]\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"total_value = query_results_extract.reduce(\n (total, num) =>\n num[valueKeyName] !== undefined && num[valueKeyName] !== \"NAN\"\n ? (total += num[valueKeyName])\n : (total += 0),\n 0\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"md`## Write query and retrieve results as JSON`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"md`*Note: you can access this query in a SPARQL editor here:* https://api.triplydb.com/s/1_KIH3Vtg`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"md`1- Define SPARQL endpoint`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"SPARQL_endpoint = 'https://openei.org/sparql'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":530,"value":"md`2- Define query and update from user inputs above`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"md`3- Send above query and fetch result (see import from other notebooks below`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"md`## Transform response`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"md`Uses a SPARQL parser to format the query result into a convenient JSON. The function in *.map* formats some of the returned URIs to be used as strings in the map above.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":364,"value":"query_results_extract = parseSPARQL(json_query_results, prefixes).map(row => {\n return Object.assign({}, row, {\n place_name: formatOpenEIResource(row.place_name),\n FacilityType: formatOpenEIResource(row.FacilityType)\n });\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":471,"value":"function formatOpenEIResource(resource) {\n if (resource !== undefined && resource) {\n return titleCase(\n resource\n .replace('resource:', '')\n .replace(/_/g, ' ')\n .replace(/-2D/g, '-')\n .replace('Definition-3A', '')\n );\n } else {\n return resource;\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"md`## Misc. functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":543,"value":"md`Format a string in title-case:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"function titleCase(str) {\n return str\n .toLowerCase()\n .split(' ')\n .map(function(word) {\n return word.replace(word[0], word[0].toUpperCase());\n })\n .join(' ');\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"md`## Import notebooks`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"import { json_query_results, prefixes } with {\n SPARQL_endpoint,\n SPARQL_query\n} from '@damienlieber/sparql-select-query-tool-for-any-rdf-knowledge-graphs'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":361,"value":"import { parseSPARQL } from '@damienlieber/sparql-parsing-function'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"import { text, radio } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"import { vl } from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"import { rangeSlider } from \"@mootari/range-slider\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 33:"$32:body"