Property talk:P7422

Documentation

minimum temperature record
lowest temperature reached at this location
[create Create a translatable help page (preferably in English) for this property to be included here]
Units: “degree Celsius (Q25267), kelvin (Q11579), degree Fahrenheit (Q42289): value unit must be one of listed. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7422#Units
Scope is as main value (Q54828448): the property must be used by specified way only (Help)
List of violations of this constraint: Database reports/Constraint violations/P7422#Scope, hourly updated report, SPARQL
Type “geographic location (Q2221906): item must contain property “instance of (P31)” with classes “geographic location (Q2221906)” or their subclasses (defined using subclass of (P279)). (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Earth (Q2)
List of violations of this constraint: Database reports/Constraint violations/P7422#Type Q2221906, SPARQL
Required qualifier “point in time (P585): this property should be used with the listed qualifier. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7422#mandatory qualifier, SPARQL
Item “coordinate location (P625): Items with this property should also have “coordinate location (P625)”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Earth (Q2), Mad Planet (Q84596793)
List of violations of this constraint: Database reports/Constraint violations/P7422#Item P625, SPARQL
Range from “-459.67” to “593.67”: values should be in the range from “-459.67” to “593.67”. (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7422#Range
Citation needed: the property must have at least one reference (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7422#citation needed
Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)
Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P7422#Entity types

Queries edit

Query with °F/°C conversion edit

#defaultView:Map
# minimum temperatures on Earth 
# from https://www.wikidata.org/wiki/Property_talk:P7422
SELECT ?degrees_Celsius ?degrees_Fahrenheit ?item ?itemLabel ?location ?locationLabel ?date ?coor ?layer
WHERE
{
	?item p:P7422 ?st . 
    {
        ?st psv:P7422  [ wikibase:quantityAmount ?degrees_Celsius ;  wikibase:quantityUnit wd:Q25267 ] 
        BIND ( ROUND ( ?degrees_Celsius * 1.8 + 32 ) as ?degrees_Fahrenheit )
    }
    UNION
	{ 
        ?st psv:P7422  [ wikibase:quantityAmount ?degrees_Fahrenheit ;  wikibase:quantityUnit wd:Q42289 ]
        BIND( ROUND( ( ?degrees_Fahrenheit - 32 ) / 1.8 * 10)/10 as ?degrees_Celsius )
    }
    OPTIONAL { ?st pq:P276 ?location OPTIONAL { ?location wdt:P625 ?coor0 } } 
    OPTIONAL { ?st pq:P585 ?date } 
    OPTIONAL { ?item wdt:P625 ?coor1 }
    BIND( COALESCE(?coor0, ?coor1) as ?coor)
    BIND( CONCAT(str(Floor(?degrees_Celsius / 10)),"0s °C") as ?layer)
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en"  }    
}
ORDER BY ASC(?degrees_Celsius)
LIMIT 1000

Try it!

Difference max-min temperature edit

#defaultView:Map
# difference between minimum and maximum temperature in area 
# from https://www.wikidata.org/wiki/Property_talk:P7422
SELECT DISTINCT ?hdegrees_Celsius ?ldegrees_Celsius ?diff_Celsius ?diff_Fahrenheit ?item ?itemLabel ?coor ?layer
WHERE
{
	?item p:P7422 ?st . 
    {
        ?st psv:P7422  [ wikibase:quantityAmount ?ldegrees_Celsius ;  wikibase:quantityUnit wd:Q25267 ] 
        BIND ( ROUND ( ?ldegrees_Celsius * 1.8 + 32 ) as ?ldegrees_Fahrenheit )
    }
    UNION
	{ 
        ?st psv:P7422  [ wikibase:quantityAmount ?ldegrees_Fahrenheit ;  wikibase:quantityUnit wd:Q42289 ]
        BIND( ROUND( ( ?ldegrees_Fahrenheit - 32 ) / 1.8 * 10)/10 as ?ldegrees_Celsius )
    }
  
    ?item p:P6591 ?st2 .
    {
        ?st2 psv:P6591  [ wikibase:quantityAmount ?hdegrees_Celsius ;  wikibase:quantityUnit wd:Q25267 ] 
        BIND ( ROUND ( ?hdegrees_Celsius * 1.8 + 32 ) as ?hdegrees_Fahrenheit )
    }
    UNION
	{ 
        ?st2 psv:P6591  [ wikibase:quantityAmount ?hdegrees_Fahrenheit ;  wikibase:quantityUnit wd:Q42289 ]
        BIND( ROUND( ( ?hdegrees_Fahrenheit - 32 ) / 1.8 * 10)/10 as ?hdegrees_Celsius )
    }
  
    OPTIONAL { ?item wdt:P625 ?coor }
    BIND( ROUND(?hdegrees_Celsius - ?ldegrees_Celsius) as ?diff_Celsius) 
    BIND( ROUND(?hdegrees_Fahrenheit - ?ldegrees_Fahrenheit) as ?diff_Fahrenheit) 
    BIND( CONCAT(str(Floor(?diff_Celsius / 10)),"0s °C") as ?layer)
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en"  }    
}
ORDER BY ASC(?degrees_Celsius)
LIMIT 1000

Try it!

Units used edit

#defaultView:Map
# minimum temperatures on Earth: units used
# from https://www.wikidata.org/wiki/Property_talk:P7422
SELECT ?item ?itemLabel ?location ?locationLabel ?coor ?layerLabel
WHERE
{
	?item p:P7422 ?st . 
    {
        ?st psv:P7422  [ wikibase:quantityUnit ?layer ] 
    }
    OPTIONAL { ?st pq:P276 ?location OPTIONAL { ?location wdt:P625 ?coor0 } } 
    OPTIONAL { ?st pq:P585 ?date } 
    OPTIONAL { ?item wdt:P625 ?coor1 }
    BIND( COALESCE(?coor0, ?coor1) as ?coor)
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en"  }    
}
LIMIT 1000

Try it!

Discussion edit

Return to "P7422" page.