Topic on User talk:ChristianKl/Structured Discussions Archive 1

Jump to navigation Jump to search

Request to remove constraint violating charge (P1595) claims (2022-12-08)

14
Trade (talkcontribs)

Hi. I know this is unrelated but while you are at it could you please make a request to remove unsourced claims of convicted of (P1399) medical condition (P1050) from items of humans=

You are better than me at getting consensus for this kind of changes so i'll appreciate if you could do this for me.

ChristianKl (talkcontribs)

Do you have a query that lists the current unsourced claims for those so that we have an idea of how much claims we are talking about?

Trade (talkcontribs)
SELECT distinct ?item ?itemLabel ?property ?value ?valueLabel ?statement
WHERE 
{
  {?item p:P1399 ?stat .
# imported from Wikimedia project (P143) and/or Wikimedia import URL (P4656)
  {?stat prov:wasDerivedFrom/pr:P143 [] .  } UNION
  {?stat prov:wasDerivedFrom/pr:P4656 [] . }
  bind(?stat as ?statement)
  bind(wdt:P1399 as ?property)
  ?stat ps:P1399 ?value .
  }
  UNION
 {?item p:P1050 ?stat2 .  
# imported from Wikimedia project (P143) and/or Wikimedia import URL (P4656)
  {?stat2 prov:wasDerivedFrom/pr:P143 [] .  } UNION
  {?stat2 prov:wasDerivedFrom/pr:P4656 [] . }
  bind(?stat2 as ?statement)
  bind(wdt:P1050 as ?property)
  ?stat2 ps:P1050 ?value .
  }    
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
}
Run it!
SELECT distinct ?item ?itemLabel ?property ?value ?valueLabel ?statement
WHERE 
{
  ?item p:P1399 ?stat .
  # No reference
  filter not exists {?stat prov:wasDerivedFrom [] .}
  bind(?stat as ?statement)
  bind(wdt:P1399 as ?property)
  ?stat ps:P1399 ?value .
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
}
Run it!
SELECT ?item ?itemLabel  ?value ?valueLabel ?statement
WHERE 
{ 
  SERVICE bd:slice {
    ?item p:P1050 ?stat2 .
    bd:serviceParam bd:slice.offset 0 . # Start at item number (not to be confused with QID)
    bd:serviceParam bd:slice.limit 100000 . # List this many items
  }
  filter not exists {?stat2 prov:wasDerivedFrom [] .}
  bind(?stat2 as ?statement)
  ?stat2 ps:P1050 ?value .  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
}
Run it!
Trade (talkcontribs)

Thoughts?

ChristianKl (talkcontribs)

The amount of results suggests that we clearly need a bot to do the job. As you can see nobody seems to have acted on the "Request to remove constraint violating charge (P1595) claims (2022-12-08)" request. Would you want to do the bot work and what you need is mainly the consensus or do you have an idea for who will do the bot work?

Trade (talkcontribs)

My plan was to get consensus first and then we could ask BrokenSegue to do the bot work

Trade (talkcontribs)

So will you help me get consensus?

ChristianKl (talkcontribs)

Yes, I will write a post.

Trade (talkcontribs)

Can i get a link to the post?

ChristianKl (talkcontribs)
ChristianKl (talkcontribs)

@Trade if you are interested in it it makes sense to speak up in the discussion.

Trade (talkcontribs)

Done

Trade (talkcontribs)

Alright, what now?

Trade (talkcontribs)

?

Reply to "Request to remove constraint violating charge (P1595) claims (2022-12-08)"