Wikidata

Wikidata:WikiProject Ecology

ecology (Q7150) is about interactions between species, including this Yellow-headed Caracara (Q28484) on a Hydrochoerus hydrochaeris (Q131538) in the Pantanal (Q157603)

Welcome to WikiProject Ecology, a community initiative to collaborate on the curation of ecological knowledge across disciplinary, taxonomic, geographic, linguistic, jurisdictional and other boundaries. Feel free to change anything here if you think this would be an improvement. If you are not sure or if you have other ideas or comments, you can leave a note on the discussion page.

About edit

This page, its subpages and the associated discussion pages are intended to assist WikiProject Ecology with the structuring of ecological knowledge available through Wikidata.

Properties edit

Existing edit

Proposed edit

To be proposed edit

  • ...

Items edit

Main items edit

Other items edit

Queries edit

Main queries edit

Habitats and habitat types edit

Habitats and habitat types by number of species, with examples edit

The following query uses these:

  • Properties: habitat (P2974)     , taxon rank (P105)     , instance of (P31)     , subclass of (P279)     
    #title: Habitats and habitat types by number of species, with examples
SELECT 
  DISTINCT 
  ?type ?typeLabel 
  ?count ?sample ?sampleLabel
WITH {
  SELECT DISTINCT ?type (COUNT(?item_) AS ?count) (SAMPLE(?item_) AS ?sample)  
  WHERE {
    ?item_ wdt:P2974 ?habitat .
    ?item_ wdt:P105 wd:Q7432 .
    ?habitat wdt:P31|wdt:P279 ?type .
  }
  GROUP BY ?type ?count ?sample
} AS %items
WHERE {
  INCLUDE %items 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }  
}
GROUP BY ?type ?typeLabel ?count ?sample ?sampleLabel 
ORDER BY DESC(?count)
LIMIT 200
Habitats and habitat types by number of species, with examples
Habitat types edit

The following query uses these:

  • Properties: instance of (P31)     
    #title: Habitat types
SELECT ?item ?itemLabel WHERE {
  ?item wdt:P31 wd:Q111535406 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Habitat types

Publications edit

Habitat-related publications about species with no habitat statements edit

The following query uses these:

  • Properties: title (P1476)     , main subject (P921)     , taxon name (P225)     , habitat (P2974)     
    #title: Habitat-related publications about species with no habitat statements
SELECT 
  DISTINCT
    ?item ?title ?topic ?taxonname

WHERE {
  hint:Query hint:optimizer "None".
  
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "habitat and haswbstatement:P31=Q13442814 -haswbstatement:P921=Q52105".
      ?page_title wikibase:apiOutput mwapi:title.
  }
 }
UNION
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "habitat -and haswbstatement:P31=Q13442814 -haswbstatement:P921=Q52105".
      ?page_title wikibase:apiOutput mwapi:title.
  }
 }
  BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
  
  ?item wdt:P1476 ?title.
  FILTER REGEX(LCASE(?title), "habitat").

  ?item wdt:P921 ?topic.
  ?topic wdt:P225 ?taxonname .
  FILTER NOT EXISTS { ?topic wdt:P2974 [] } .
  
}
Habitat-related publications about species with no habitat statements

Taxa edit

Genera of species with at least one habitat statement edit

The following query uses these:

Genera of species with at least one habitat statement


Genera of species with no habitat statements edit

The following query uses these:

  • Properties: title (P1476)     , main subject (P921)     , parent taxon (P171)     , taxon rank (P105)     , taxon name (P225)     , habitat (P2974)     
    #title: Genera of species with no habitat statements
SELECT 
  DISTINCT
    ?topicparent ?taxonname (COUNT(DISTINCT ?item) AS ?count)

WHERE {
  hint:Query hint:optimizer "None".
  
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "habitat and haswbstatement:P31=Q13442814 -haswbstatement:P921=Q52105".
      ?page_title wikibase:apiOutput mwapi:title.
  }
 }
UNION
{  SERVICE wikibase:mwapi {
    bd:serviceParam wikibase:api "Search";
                    wikibase:endpoint "www.wikidata.org";
                    mwapi:srsearch "habitat -and haswbstatement:P31=Q13442814 -haswbstatement:P921=Q52105".
      ?page_title wikibase:apiOutput mwapi:title.
  }
 }
  BIND(IRI(CONCAT(STR(wd:), ?page_title)) AS ?item)
  
  ?item wdt:P1476 ?title.
  FILTER REGEX(LCASE(?title), "habitat").

  ?item wdt:P921 ?topic.
  ?topic wdt:P171 ?topicparent .
  ?topicparent wdt:P105 wd:Q34740 .
  ?topicparent wdt:P225 ?taxonname .
  FILTER NOT EXISTS { ?topic wdt:P2974 [] } .
  
}
GROUP BY ?topicparent ?taxonname
ORDER BY DESC(?count)
Genera of species with no habitat statements

Other queries edit

  • ...

Literature edit

Scholia edit

Tools edit

  •   Info You can use the AutoEdit tool to quickly add label and description in many languages to items within the scope of WikiProject Ecology.


Subpages edit

This WikiProject has the following subpages:

Participants edit

The participants listed below can be notified using the following template in discussions:
{{Ping project|Ecology}}

See also edit

Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Ecology&oldid=1800005191"