Wikipedia:Meetup/NYC/Queens Name Explorer/Wikidata#Mix'n'Match

{{Wikipedia:Meetup/NYC/Queens_Name_Explorer/Tab_Header}}

[https://wikidata.org Wikidata] is a free, collaborative, multilingual, secondary knowledge base, collecting structured data to provide support for Wikipedia, Wikimedia Commons, the other wikis of the Wikimedia movement, and to anyone in the world.

Our goal is to match people and places from [https://nameexplorer.urbanarchive.org/ Queens Name Explorer] to their corresponding Wikidata items, creating new Wikidata items when they do not yet exist.

As we match, edit, and create Wikidata items for people and places, it will power a [https://query.wikidata.org/embed.html#%23title%3A%20Places%20located%20in%20Queens%20named%20after%20people%0A%0ASELECT%20%3Fplace%20%3FplaceLabel%20%3FplaceArticle%20%28COALESCE%28%3FosmRelationLink%2C%20%3FosmWayLink%2C%20%3FosmNodeLink%29%20AS%20%3FosmLink%29%20%3Fnamesake%20%3FnamesakeLabel%20%3FnamesakeArticle%20%3FnameExplorerLink%20WHERE%20%7B%0A%20%20%0A%20%20%23%20get%20places%20located%20in%20the%20administrative%20territory%20of%20Queens%20with%20a%20named%20after%20statement%20and%20their%20namesakes%20that%20are%20people%20%28%22human%22%29%20or%20group%20of%20people%20%28%22group%20of%20humans%22%29%0A%20%20%3Fplace%20wdt%3AP131%20wd%3AQ18424%3B%20%0A%20%20%20%20p%3AP138%20%3Fstatement.%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP576%20%3FdemolishedDate.%20%7D%20%23%20omit%20demolished%20places%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP31%20wd%3AQ123705.%20%7D%20%23%20omit%20neighborhoods%0A%20%20MINUS%20%7B%20%3Fplace%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ16970.%20%7D%20%23%20omit%20churches%0A%20%20%3Fstatement%20ps%3AP138%20%3Fnamesake.%20%0A%20%20%7B%20%3Fnamesake%20wdt%3AP31%20wd%3AQ5.%20%7D%20UNION%20%7B%20%3Fnamesake%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ16334295.%20%7D%20%0A%20%20MINUS%20%7B%20%3Fnamesake%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ486972.%20%7D%20%23%20omit%20namesakes%20that%20are%20human%20settlements%0A%20%20%0A%20%20%23%20get%20Wikipedia%20article%20for%20the%20place%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FplaceArticle%20schema%3Aabout%20%3Fplace%20.%0A%20%20%20%20%3FplaceArticle%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20FILTER%20%28SUBSTR%28str%28%3FplaceArticle%29%2C%201%2C%2025%29%20%3D%20%22https%3A%2F%2Fen.wikipedia.org%2F%22%29%0A%20%20%7D%0A%20%20%0A%20%20%23%20get%20OSM%20relation%2C%20way%2C%20or%20node%20link%20for%20place%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20wdt%3AP402%20%3FosmRelationID.%0A%20%20%20%20wd%3AP402%20wdt%3AP1630%20%3FosmRelationFormatter%20.%0A%20%20%20%20BIND%28IRI%28REPLACE%28%3FosmRelationID%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FosmRelationFormatter%29%29%20AS%20%3FosmRelationLink%29%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20wdt%3AP10689%20%3FosmWayID.%0A%20%20%20%20wd%3AP10689%20wdt%3AP1630%20%3FosmWayFormatter%20.%0A%20%20%20%20BIND%28IRI%28REPLACE%28%3FosmWayID%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FosmWayFormatter%29%29%20AS%20%3FosmWayLink%29%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20wdt%3AP11693%20%3FosmNodeID.%0A%20%20%20%20wd%3AP11693%20wdt%3AP1630%20%3FosmNodeFormatter%20.%0A%20%20%20%20BIND%28IRI%28REPLACE%28%3FosmNodeID%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FosmNodeFormatter%29%29%20AS%20%3FosmNodeLink%29%0A%20%20%7D%0A%20%0A%20%20%23%20get%20reference%20URLs%20that%20match%20nameexplorer.urbanarchive.org%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fstatement%20prov%3AwasDerivedFrom%20%3Freference.%0A%20%20%20%20%3Freference%20pr%3AP854%20%3FnameExplorerLink.%0A%20%20%20%20FILTER%28CONTAINS%28STR%28%3FnameExplorerLink%29%2C%20%22nameexplorer.urbanarchive%22%29%29%0A%20%20%7D%0A%20%20%0A%20%20%23%20get%20Wikipedia%20article%20for%20the%20namesake%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamesakeArticle%20schema%3Aabout%20%3Fnamesake%20.%0A%20%20%20%20%3FnamesakeArticle%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20FILTER%20%28SUBSTR%28str%28%3FnamesakeArticle%29%2C%201%2C%2025%29%20%3D%20%22https%3A%2F%2Fen.wikipedia.org%2F%22%29%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%0A%7D%0A%0AORDER%20BY%20%28%3FplaceLabel%29 dynamic list] that includes links to corresponding Wikipedia articles and OpenStreetMap features.

= Getting started =

New to Wikidata?

  1. [https://www.wikidata.org/w/index.php?title=Special:CreateAccount Create a Wikidata username] if you do not yet have one
  2. Start with beginner tasks
  3. Login to [https://mix-n-match.toolforge.org/api.php?query=widar&action=authorize Mix'n'Match] and [https://tabernacle.toolforge.org/api.php?action=authorize Tabernacle] with your Wikidata username
  4. (optional) Work through [https://dashboard.wikiedu.org/training/wikidata-professional/ Wiki Edu Wikidata Training Modules] if you're interested to learn more about Wikidata:
  5. [https://dashboard.wikiedu.org/training/wikidata-professional/introduction-wikidata-professional Wiki Edu's Introduction to Wikidata]
  6. [https://dashboard.wikiedu.org/training/wikidata-professional/evaluating-wikidata Evaluating Data on Wikidata]
  7. [https://dashboard.wikiedu.org/training/wikidata-professional/adding-to-wikidata Adding to Wikidata]

= Tasks =

Beginner tasks

= Mix'n'Match =

  • [https://mix-n-match.toolforge.org/#/random/6234 Match people names] ([https://mix-n-match.toolforge.org/#/catalog/6234 people dashboard])
  • [https://mix-n-match.toolforge.org/#/random/6235 Match place names] ([https://mix-n-match.toolforge.org/#/catalog/6235 places dashboard])

= Tabernacle =

  • [https://tabernacle.toolforge.org/?#/tab/sparql/SELECT%20DISTINCT%20%3Fplace%20WHERE%20%7B%0A%20%20%0A%20%20%23%20get%20places%20located%20in%20the%20administrative%20territory%20of%20Queens%20with%20a%20named%20after%20statement%20and%20their%20namesakes%20that%20are%20people%20(%22human%22)%20or%20group%20of%20people%20(%22group%20of%20humans%22)%0A%20%20%3Fplace%20wdt%3AP131%20wd%3AQ18424%3B%20%0A%20%20%20%20p%3AP138%20%3Fstatement.%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP576%20%3FdemolishedDate.%20%7D%20%23%20omit%20demolished%20places%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP31%20wd%3AQ123705.%20%7D%20%23%20omit%20neighborhoods%0A%20%20MINUS%20%7B%20%3Fplace%20(wdt%3AP31%2F(wdt%3AP279*))%20wd%3AQ16970.%20%7D%20%23%20omit%20churches%0A%20%20%3Fstatement%20ps%3AP138%20%3Fnamesake.%20%0A%20%20%7B%20%3Fnamesake%20wdt%3AP31%20wd%3AQ5.%20%7D%20UNION%20%7B%20%3Fnamesake%20(wdt%3AP31%2F(wdt%3AP279*))%20wd%3AQ16334295.%20%7D%20%0A%20%20MINUS%20%7B%20%3Fnamesake%20(wdt%3AP31%2F(wdt%3AP279*))%20wd%3AQ486972.%20%7D%20%23%20omit%20namesakes%20that%20are%20human%20settlements%0A%20%20%0A%20%20%23%20omit%20places%20with%20OpenStreetMap%20identifiers%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP402%20%3FosmRelationID.%20%7D%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP10689%20%3FosmWayID.%20%7D%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP11693%20%3FosmNodeID.%20%7D%0A%0A%20%20%23%20omit%20places%20in%20Queens%20with%20%22no%20value%22%20for%20P10689%0A%20%20MINUS%20%7B%20%3Fplace%20rdf%3Atype%20wdno%3AP10689.%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%0A%7D%0A%0AORDER%20BY%20(%3FplaceLabel)/P402%3BP10689%3BP11693 Add OpenStreetMap identifiers]

Intermediate tasks

  • Add required statements to [https://mix-n-match.toolforge.org/#/list/6235/manual matched places] ([https://mix-n-match.toolforge.org/#/rc/6235 recent changes])
  • Enhance Wikidata items for [https://mix-n-match.toolforge.org/#/list/6234/manual matched people] ([https://mix-n-match.toolforge.org/#/rc/6234 recent changes])
  • Use [https://item-quality-evaluator.toolforge.org/ Item Quality Evaluator] with the following code entered into the SPARQL tab:

:: SELECT DISTINCT ?namesake WHERE { ?place wdt:P131 wd:Q18424; p:P138 ?statement. MINUS { ?place wdt:P576 ?demolishedDate. } MINUS { ?place wdt:P31 wd:Q123705. } MINUS { ?place (wdt:P31/(wdt:P279*)) wd:Q16970. } ?statement ps:P138 ?namesake. ?namesake wdt:P31 wd:Q5. MINUS { ?namesake (wdt:P31/(wdt:P279*)) wd:Q486972. } SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } }

Advanced tasks

  • Develop additional SPARQL queries to help visualize Queens Name Explorer data

= Wikidata statements to add to items =

Statements required for queries are indicated, other statements listed are recommended if known

For [https://mix-n-match.toolforge.org/#/list/6235/manual places]

  • {{wdp|17}}: {{wdq|Q30}}
  • {{highlight|{{wdp|131}}: {{wdq|18424}} (required for queries)}}
  • {{highlight|{{wdp|625}} (required for queries)}}
  • {{highlight|{{wdp|138}} (required for queries)}}
  • Add reference using {{wdp|854}} and nameexplorer.urbanarchive.me URL as the value ([https://www.wikidata.org/wiki/Q124461361#P138 example])
  • One of the following OpenStreetMap properties:
  • {{wdp|402}}
  • {{wdp|10689}}
  • {{wdp|11693}}

: (Alternately, if the place doesn't yet exist in OpenStreetMap, add {{wdp|10689}}: no value)

= For [https://w.wiki/9Tmg co-named streets] =

  • {{wdp|31}}: {{wdq|124461364}}
  • {{wdp|669}}: Wikidata item for street that has been co-named

= For [https://w.wiki/9Tmm schools] =

See [https://www.wikidata.org/wiki/Wikidata:WikiProject_NYC_Open_Education_Data#Properties Wikidata:WikiProject NYC Open Education Data] for public schools

For [https://mix-n-match.toolforge.org/#/list/6234/manual people]

= For individual person =

  • {{highlight|{{wdp|31}}: {{wdq|5}} (required for queries)}}
  • {{wdp|106}}
  • {{wdp|569}}
  • {{wdp|570}}

See [https://www.wikidata.org/wiki/Wikidata:WikiProject_Biographical_Identifiers Wikidata:WikiProject Biographical Identifiers] and [https://www.wikidata.org/wiki/Wikidata:Living_people Wikidata:Living people]

= For group of people =

  • {{highlight|{{wdp|31}}: {{wdq|16334295}} or more specific item, i.e. {{wdq|215380}} or {{wdq|8436}} (required for queries)}}

= Queries =

  • [https://query.wikidata.org/embed.html#%23title%3A%20Places%20located%20in%20Queens%20named%20after%20people%0A%0ASELECT%20%3Fplace%20%3FplaceLabel%20%3FplaceArticle%20%28COALESCE%28%3FosmRelationLink%2C%20%3FosmWayLink%2C%20%3FosmNodeLink%29%20AS%20%3FosmLink%29%20%3Fnamesake%20%3FnamesakeLabel%20%3FnamesakeArticle%20%3FnameExplorerLink%20WHERE%20%7B%0A%20%20%0A%20%20%23%20get%20places%20located%20in%20the%20administrative%20territory%20of%20Queens%20with%20a%20named%20after%20statement%20and%20their%20namesakes%20that%20are%20people%20%28%22human%22%29%20or%20group%20of%20people%20%28%22group%20of%20humans%22%29%0A%20%20%3Fplace%20wdt%3AP131%20wd%3AQ18424%3B%20%0A%20%20%20%20p%3AP138%20%3Fstatement.%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP576%20%3FdemolishedDate.%20%7D%20%23%20omit%20demolished%20places%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP31%20wd%3AQ123705.%20%7D%20%23%20omit%20neighborhoods%0A%20%20MINUS%20%7B%20%3Fplace%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ16970.%20%7D%20%23%20omit%20churches%0A%20%20%3Fstatement%20ps%3AP138%20%3Fnamesake.%20%0A%20%20%7B%20%3Fnamesake%20wdt%3AP31%20wd%3AQ5.%20%7D%20UNION%20%7B%20%3Fnamesake%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ16334295.%20%7D%20%0A%20%20MINUS%20%7B%20%3Fnamesake%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ486972.%20%7D%20%23%20omit%20namesakes%20that%20are%20human%20settlements%0A%20%20%0A%20%20%23%20get%20Wikipedia%20article%20for%20the%20place%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FplaceArticle%20schema%3Aabout%20%3Fplace%20.%0A%20%20%20%20%3FplaceArticle%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20FILTER%20%28SUBSTR%28str%28%3FplaceArticle%29%2C%201%2C%2025%29%20%3D%20%22https%3A%2F%2Fen.wikipedia.org%2F%22%29%0A%20%20%7D%0A%20%20%0A%20%20%23%20get%20OSM%20relation%2C%20way%2C%20or%20node%20link%20for%20place%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20wdt%3AP402%20%3FosmRelationID.%0A%20%20%20%20wd%3AP402%20wdt%3AP1630%20%3FosmRelationFormatter%20.%0A%20%20%20%20BIND%28IRI%28REPLACE%28%3FosmRelationID%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FosmRelationFormatter%29%29%20AS%20%3FosmRelationLink%29%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20wdt%3AP10689%20%3FosmWayID.%0A%20%20%20%20wd%3AP10689%20wdt%3AP1630%20%3FosmWayFormatter%20.%0A%20%20%20%20BIND%28IRI%28REPLACE%28%3FosmWayID%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FosmWayFormatter%29%29%20AS%20%3FosmWayLink%29%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20wdt%3AP11693%20%3FosmNodeID.%0A%20%20%20%20wd%3AP11693%20wdt%3AP1630%20%3FosmNodeFormatter%20.%0A%20%20%20%20BIND%28IRI%28REPLACE%28%3FosmNodeID%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FosmNodeFormatter%29%29%20AS%20%3FosmNodeLink%29%0A%20%20%7D%0A%20%0A%20%20%23%20get%20reference%20URLs%20that%20match%20nameexplorer.urbanarchive.org%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fstatement%20prov%3AwasDerivedFrom%20%3Freference.%0A%20%20%20%20%3Freference%20pr%3AP854%20%3FnameExplorerLink.%0A%20%20%20%20FILTER%28CONTAINS%28STR%28%3FnameExplorerLink%29%2C%20%22nameexplorer.urbanarchive%22%29%29%0A%20%20%7D%0A%20%20%0A%20%20%23%20get%20Wikipedia%20article%20for%20the%20namesake%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamesakeArticle%20schema%3Aabout%20%3Fnamesake%20.%0A%20%20%20%20%3FnamesakeArticle%20schema%3AinLanguage%20%22en%22%20.%0A%20%20%20%20FILTER%20%28SUBSTR%28str%28%3FnamesakeArticle%29%2C%201%2C%2025%29%20%3D%20%22https%3A%2F%2Fen.wikipedia.org%2F%22%29%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%0A%7D%0A%0AORDER%20BY%20%28%3FplaceLabel%29 List of places and namesakes]: dynamic list of Wikidata items located in the administrative territorial entity Queens with a named after statement (excludes neighborhoods, churches, and places named after human settlements)
  • [https://query.wikidata.org/embed.html#SELECT%20%3Fitem%20%3FitemLabel%20%28COALESCE%28%3FcommonsCatLink%2C%20%3FcommonsPage%29%20as%20%3FcommonsLink%29%20WHERE%20%7B%0A%20%20%0A%20%20%3Fplace%20wdt%3AP131%20wd%3AQ18424%3B%20%0A%20%20%20%20p%3AP138%20%3Fstatement.%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP576%20%3FdemolishedDate.%20%7D%20%23%20omit%20demolished%20places%0A%20%20MINUS%20%7B%20%3Fplace%20wdt%3AP31%20wd%3AQ123705.%20%7D%20%23%20omit%20neighborhoods%0A%20%20MINUS%20%7B%20%3Fplace%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ16970.%20%7D%20%23%20omit%20churches%0A%20%20%3Fstatement%20ps%3AP138%20%3Fnamesake.%20%0A%20%20%7B%20%3Fnamesake%20wdt%3AP31%20wd%3AQ5.%20%7D%20UNION%20%7B%20%3Fnamesake%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ16334295.%20%7D%20%0A%20%20MINUS%20%7B%20%3Fnamesake%20%28wdt%3AP31%2F%28wdt%3AP279%2a%29%29%20wd%3AQ486972.%20%7D%20%23%20omit%20namesakes%20that%20are%20human%20settlements%0A%20%20%0A%20%20BIND%28%3Fplace%20as%20%3Fitem%29%0A%20%20%0A%20%20MINUS%7B%3Fitem%20wdt%3AP18%20%3Fimage.%7D%0A%20%20%3Fitem%20wdt%3AP373%20%3FcommonsCat.%0A%20%20%0A%20%20%3FcommonsPage%20schema%3Aabout%20%3Fitem.%0A%20%20FILTER%20%28SUBSTR%28str%28%3FcommonsPage%29%2C%201%2C%2030%29%20%3D%20%22https%3A%2F%2Fcommons.wikimedia.org%2F%22%29%0A%20%20%0A%20%20wd%3AP373%20wdt%3AP1630%20%3FcommonsCatFormatter%0A%20%20BIND%28IRI%28REPLACE%28%3FcommonsCat%2C%20%27%5E%28.%2B%29%24%27%2C%20%3FcommonsCatFormatter%29%29%20AS%20%3FcommonsCatLink%29%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Places with Wikimedia Commons Category but no image (P18) on Wikidata]
  • [https://w.wiki/9SeK Most common occupations of people who have a place named after them in Queens]
  • [https://w.wiki/9Y9Q People by number of places named after them in Queens]