Wikidata:WikiProject Commons/Links and sitelinks/queries

From Wikidata
Jump to navigation Jump to search

Statistics[edit]

Commons categories
(4,566,749) 		Commons galleries
(112,000) 		total linked
Wikidata articles tinyurl.com/yawsej44 + (P373) tinyurl.com/ybykbj3e + (P935) tinyurl.com/y8lzezt3 + (props)
sitelinks:
tinyurl.com/y7moy7nr 		P373:
tinyurl.com/yb5jjnzg 		sitelinks:
tinyurl.com/y7tszd5b 		P935:
tinyurl.com/hc5x6on 		sitelinks:
tinyurl.com/jkbtnhw 		props:
(P373) + tinyurl.com/y94hrcax
Wikidata categories tinyurl.com/ybxc84ft + (P373) tinyurl.com/y7ulserg + (P935) tinyurl.com/jonq7mu + (props)
sitelinks:
tinyurl.com/y7d58wa4 		P373:
tinyurl.com/zz2roak 		sitelinks:
tinyurl.com/yaz4xp9d 		P935:
tinyurl.com/j39acx2 		sitelinks:
tinyurl.com/h2tur59 		props:
(P373) + tinyurl.com/ycwrcj27
total linked B tinyurl.com/jf8ortt + (P373)
 B tinyurl.com/yd5nkln6 + (P935)
 (arts) + (cats) items / (galls) + (cats) pages
sitelinks:
tinyurl.com/yc8mwr28 arts + cats 		P373:
tinyurl.com/zuypbzg 		sitelinks:
tinyurl.com/y8vgnqrc arts + cats 		P935:
tinyurl.com/ntdtgtq 		sitelinks:
tinyurl.com/hwu5z89
arts + cats 		props:
(arts) + (cats) items / (galls) + (cats) pages
Approximation for Articles P373 : Calculate Total P373, subtract Categories P373, add tinyurl.com/y7sy4wc3
  • cats with 373 and 301: tinyurl.com/h7d7urx
  • non-cats with 373 and 910: tinyurl.com/z5xn3pr
  • non-cats with sitelinks and 910: tinyurl.com/gpxwvtz


details[edit]

  • Commons non-cat sitelinks that do not have P935: tinyurl.com/y8ecch6z
Most are dab pages, or templates/project pages/css pages/etc. A few Creator: pages, that shouldn't be there.
Compare: dab pages with sitelinks and P935s: tinyurl.com/y9aal2x3
  • Category items with sitelink but no P373: tinyurl.com/yaxe94rn QS form: tinyurl.com/yawwpud9

Analysis (2015)[edit]

  • Breakdown of P373 by class: tinyurl.com/jjy3un6 (categories:353,172; people: 221,930; taxons: 88,022; church: 31,548; railway station 15,012 ...)
    • Administrative territorial entities: tinyurl.com/zwno3q7 : 191,212; breakdown: tinyurl.com/jgrpq3h
    • Items with heritage status: tinyurl.com/z2kgtwg : 74,168; breakdown: tinyurl.com/jfbgq4a


Suggestions (2015)[edit]

  • P373 from Sitelinks
    Autolist + grep -- (WD non-cat items)
    Autolist + grep -- (WD category items)
    Count: tinyurl.com/jqpkdb5 / Autolist + grep -- (both)
  • category's main topic (P301) / topic's main category (P910) pairs from shared P373
    ...problem: Commons cat often corresponds to a class; but P373 often used from an item of that class
    tinyurl.com/o972sal (times out)
    Potentially about 15,000 to find tinyurl.com/haoaeus
    tinyurl.com/ht3dbyr -- right on the limit of what will run (first 1000 only)
    tinyurl.com/hz9gmh2 -- first 3000 (in article order)
    Experiments with trying to insist on sitelinks: tinyurl.com/n9fcq6a, tinyurl.com/qzok2qh (Query engine bug?)
    This one works tinyurl.com/o8xllgb (up to a point); whereas this times out tinyurl.com/nsrvl6t
  • Autolist for categories with P373 but no P301 : query tinyurl.com/ovpm2r2 (needs to be run as batch)
  • Autolist for non-categories with P373 but no P910
  • Query: 301 but no 910: tinyurl.com/pjlbpck / P910 but not P301 tinyurl.com/jybovvg


  • Currently, out of 1027043 that have a image (P18), 548931 do not have a P373. tinyurl.com/oatyofu
Breakdown: tinyurl.com/nj6qchu
(human 254,807; taxon 56,587; painting 24,498; railway station 10,205; building 10,047; church 9,486; ... street 3,319; ... city 2,148 ... )
heritage status 62,250 -- breakdown: tinyurl.com/ntbmk7l
  • compare: non-cats with a P373 but no P18 tinyurl.com/z4tuh8r times out.
Retrieved from "https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Commons/Links_and_sitelinks/queries&oldid=656444456"