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

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 =

• [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])

• [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]

• 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". } }

• 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

• {{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)

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

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

• {{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]

• {{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]