User:R Focke

interesting props

an example valuenode: wdv:9b9ced144cb72b13a406a94bdce98bd8 wdv = <http://www.wikidata.org/value/>

Kältemittelvorschrift

EN378 für bau und betrieb für Kälteanlagen ISO817 für Kältemittel

Query for refrigerant with wikipedia entry

Collapse to show the query

SELECT ?itemLabel ?article ?Rnumber ?globalwarmthpotential ?boilingpoint ?meltingpoint ?sicherheitsgruppeLabel ?item
WHERE
{
  ?item wdt:P4842 ?Rnumber.
  OPTIONAL{
    ?article schema:about ?item;
    schema:isPartOf <https://de.wikipedia.org/>.
  }
  OPTIONAL{
    SELECT ?item (MIN(?allgwp) as ?globalwarmthpotential)
    WHERE {
      ?item wdt:P2565 ?allgwp.
    } GROUP BY ?item
  }
  OPTIONAL{
    ?item p:P2102 ?statement_boilingpoint.
    ?statement_boilingpoint psv:P2102 ?valuenode_boilingpoint.
    ?valuenode_boilingpoint wikibase:quantityAmount ?boilingpoint;
      wikibase:quantityUnit ?unit_boilingpoint.
    FILTER(?unit_boilingpoint = wd:Q25267)
  }
  OPTIONAL{
    ?item p:P2101 ?statement_meltingpoint.
    ?statement_meltingpoint psv:P2101 ?valuenode_meltingpoint.
    ?valuenode_meltingpoint wikibase:quantityAmount ?meltingpoint;
      wikibase:quantityUnit ?unit_meltingpoint.
    FILTER(?unit_meltingpoint = wd:Q25267)
  }
  Optional{
    ?item wdt:P5009 ?sicherheitsgruppe.
    ?sicherheitsgruppe wdt:P31 wd:Q117757747.
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  #Only use main number to sort
  BIND(xsd:integer(REPLACE(?Rnumber, 
                           "[a-zA-Z]?([0-9]{2,4})[a-zA-Z]?[0-9a-z]?(?:[(][a-zA-Z][)])?", 
                           "$1")) as ?sortnumber)
} ORDER BY ASC(?sortnumber)

Try it!

When multiple boilingpoints or meltingpoints are given, single items are returned multiple times.

Missing toxicity and flammability (iso817) Described here [in deutsch]

Items without refrigerant class

additional information used in some tabular:

• Q900522 ozone depletion rate
• Zusammensetzung, bei gemisch
• Kältemitteltyp
• gesetzliche Regelungen

Verschiedene Kältemitteltypen:

• FCKW Fluorchlorkohlenwasserstoff
• H-FCKW teilhalogenierter Fluorchlorkohlenwasserstoff
• FKW perfluorierter Kohlenwasserstoff
• H-FKW teilfluorierter Kohlenwasserstoff
• KW Kohlenwasserstoff
• H-FCKW-Gemisch Kältemittelgemisch, welches H-FCKW enthält
• H-FKW-Gemisch Kältemittelgemisch, welches H-FKW enthält
• FCKW-Gemisch Kältemittelgemisch, welches FCKW enthält
• HFO Hydrofluorolefin

() Additional a query to find all things that have a boilingpoint in grad celsius but not in Fahrenheit and vice versa(not yet finished):

SELECT ?item ?statement1 ?valuenode1 ?value1 ?statement2
WHERE
{
  ?item wdt:P4842 ?Rnumber.
  ?item p:P2102 ?statement1.
  ?statement1 psv:P2102 ?valuenode1.
  ?valuenode1 wikibase:quantityAmount ?value1;
    wikibase:quantityUnit wd:Q25267.
  FILTER NOT EXISTS{
    ?item p:P2102 ?statement2.
    ?statement2 psv:P2102 ?valuenode2.
    ?valuenode2 wikibase:quantityAmount ?value2;
      wikibase:quantityUnit wd:Q42289.
  }
} LIMIT 20

Try it!