Wikipedia:Meetup/NYC/Queens Name Explorer/Wikidata

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 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) Create a Wikidata username if you do not yet have one
 * 2) Start with beginner tasks
 * 3) Login to Mix'n'Match and Tabernacle with your Wikidata username
 * 4) (optional) Work through Wiki Edu Wikidata Training Modules if you're interested to learn more about Wikidata:
 * 5) Wiki Edu's Introduction to Wikidata
 * 6) Evaluating Data on Wikidata
 * 7) Adding to Wikidata

= Tasks =

Mix'n'Match

 * Match people names (people dashboard)
 * Match place names (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 matched places (recent changes)
 * Enhance Wikidata items for matched people (recent changes)
 * Use Item Quality Evaluator with the following code entered into the SPARQL tab:

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 places

 * : (required for queries)
 * (required for queries)
 * (required for queries)
 * Add reference using and   URL as the value (example)
 * One of the following OpenStreetMap properties:
 * (Alternately, if the place doesn't yet exist in OpenStreetMap, add : no value)
 * (Alternately, if the place doesn't yet exist in OpenStreetMap, add : no value)
 * (Alternately, if the place doesn't yet exist in OpenStreetMap, add : no value)
 * (Alternately, if the place doesn't yet exist in OpenStreetMap, add : no value)
 * (Alternately, if the place doesn't yet exist in OpenStreetMap, add : no value)

For co-named streets

 * : Wikidata item for street that has been co-named
 * : Wikidata item for street that has been co-named

For schools
See Wikidata:WikiProject NYC Open Education Data for public schools

For individual person

 * : (required for queries)

See Wikidata:WikiProject Biographical Identifiers and Wikidata:Living people

For group of people

 * : or more specific item, i.e. or  (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]
 * Most common occupations of people who have a place named after them in Queens
 * People by number of places named after them in Queens