User:DutchTreat/projects

Lists

• Wikidata:List of properties/New York City

Tools

• Mix-N-Match on toolforge.org , more info at m:Mix'n'match

OpenRefine

• m:OpenRefine and Wikidata:Tools/OpenRefine

• Tutorials: Wikidata:Tools/OpenRefine/Editing/Tutorials/Inverse_Listeria

• Docs: [new entities]

- "It is often useful (but not mandatory) to treat new items in isolation and use a dedicated schema for them." - "Retrieving the Qids of the newly-created items"

Art Exhibition

• Example: On Love & Data (Q113509290)

- name: On Love & Data - description: 2022 Stephanie Dinkins exhibition at the Queens Museum

Properties

• instance of: art exhibition
• location: Queens Museum
• main subject: (P921) "algorithmic bias"; "artificial intelligence"
• curator:
• start time:
• end time:
• exhibited creator: artist(s) (see examples at exhibited creator (P10661)

MET

w:Exhibitions of artifacts from the tomb of Tutankhamun

• Treasures of Tutankhamun (Q115038822) created 2011-11-03 by User:TemboUngwe, open discussion on if this should be for a single museum (at the MET) or for traveling across many museums and use qualifiers for date ranges (11 November 2022)
• Created Treasures of Tutankhamun (Q115521572) as the USA traveling exhibit with each museum stop "part of"

Other American museums

• National Gallery of Art (Q214867) in Washington, D. C.

Company

Croatia (HR)

Improve the parent/child relationships for subsidiaries:

Banks

• w:Privredna banka Zagreb, two items merged: Privredna banka Zagreb (Q7246343) (preferred) and Privredna banka Zagreb (Q115513056) (18 March); owned by w:Intesa Sanpaolo group of Italy.

Food and Beverage

• Dukat (Croatia) (Q43894915) has parent Lactalis (Q1799825) w:Lactalis French dairy products corporation
• Zagrebačka pivovara (Q4183744) brewery owned by CVC Capital Partners (Q1024566)

Pharmaceuticals

• Pliva (Q904388) owned by Teva- Pharmaceutical Industries Ltd. (Q898750) of Israel

Education

Wikidata:WikiProject NYC Open Education Data

Looking to expand representation of Women for Women's History Month 2023. Found a school in Staten Island that is not in WD yet: The Young Women s Leadership School of Staten Island (P085)

Inspired by this query [1] from User:Pharos on 2023-03-12.

Geocode

• [2] fixed: The Christa McAuliffe School\I.S. 187 (Q104129614) , The SEEALL Academy (Q104129611), P.S. 192 - The Magnet School for Math and Science Inquiry (Q104129615), J.H.S. 201 The Dyker Heights (Q104129617) on 2023-06-04

Events

Strikes

Finding images via FIST:

Run query
SELECT ?strike ?strikeLabel WHERE {   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }      ?strike wdt:P31 wd:Q49776. } LIMIT 100

Changes made:

1. Asbestos Strike (Q3118367) image of police reaction in 1949
2. Knysna fiasco (Q1410411) no image yet as of 2024-03-23
3. Canton-Hong Kong strike (Q1634875) no image yet as of 2024-03-23, improve metadata
4. Gurindji strike (Q246080) image of cattle station

• 
  Q3118367 (1949)
• 
  Q246080 (1962)

Places

• OSM linking tool: OSM-Wikidata Link

City Hall

Update instance of (P31) to town hall (Q25550691) from misleading rathaus (Q543654). See discussion from April 2022.

SELECT DISTINCT ?item WHERE { ?item p:P31 ?statement0. ?statement0 (ps:P31/(wdt:P279*)) wd:Q543654. ?item p:P17 ?statement1. ?statement1 (ps:P17/(wdt:P279*)) wd:Q30. } LIMIT 100 run

• US-Mass: Boston City Hall (Q250773) (2023-11-28)
• US-New Jersey: Camden City Hall (Q5025737), Ocean City City Hall (Q7075956), Paterson City Hall (Q7144585), Trenton City Hall (Q14705889) (2023-11-28)
• US-Utah: Salt Lake City Council Hall (Q2215312) (2023-11-29)

Heritage

• Projects: Wikidata:WikiProject Heritage institutions; Wikidata:WikiProject Built heritage (Talk)
• Category: Category:Property proposal place
• Property proposal: Urban Archive Wikidata:Property proposal/Urban Archive ID

• Add External Link for RIBA from w:Royal Institute of British Architects. See RIBA Ref No RIBA46271

• Pleiades ID (P1584) for archaeological places Pleiades

By Country

• Australia: Australian National Heritage List Australian National Heritage List (Q781601); Prop proposal - AHD ID
• Czech: Prop proposal - Czech Monument Catalogue Number
• Serbia: Prop proposal - cultural heritage monument in Serbia
• Slovenia registered immobile cultural heritage of Slovenia (Q18519893); w:List of World Heritage Sites in Slovenia

Croatia

My sandbox: /Croatia

• geoportal from kulturnadobra.hr
• Croatian Cultural Heritage is w:Register of Cultural Goods of Croatia for w:Natural and Cultural Heritage of Croatia maintained by Croatian Ministry of Culture and Media
• See previous proposals for Croatian language identifies: A. Wikidata:Property proposal/Hrvatska enciklopedije ID and B. Wikidata:Property proposal/Hrvatska tehnička enciklopedija ID. Note, neither one is heritage related.

About the database, Grgas, Jelena (23 May 2021). "Register of Cultural Heritage and Geoportal of Cultural Heritage". CroatianHub.;

• query [3] - has Cultural Good of Croatia ID (P11296) OR heritage designation = {Register of Cultural Goods of Croatia |Cultural Heritage in Croatia }

• count run - [4] SELECT (COUNT(*) AS ?count) WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". } { SELECT DISTINCT ?item WHERE { ?item p:P11296 ?statement0. ?statement0 (ps:P11296) _:anyValueP11296. } LIMIT 250 } }
• Progress: 250 items using property as of 2024-02-27

• Map sites with any of three designations: SELECT DISTINCT ?item ?itemLabel ?coord WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". } { SELECT DISTINCT ?item ?coord WHERE { { ?item p:P11296 ?statement0. ?statement0 (ps:P11296) _:anyValueP11296. OPTIONAL{?item wdt:P625 ?coord.} } UNION { ?item p:P1435 ?statement1. ?statement1 (ps:P1435/(wdt:P279*)) wd:Q7309359. OPTIONAL{?item wdt:P625 ?coord.} } UNION { ?item p:P1435 ?statement2. ?statement2 (ps:P1435/(wdt:P279*)) wd:Q106432727. OPTIONAL{?item wdt:P625 ?coord.} } } LIMIT 500 } }
• Query existing inventory codes SELECT ?heritage ?heritageLabel ?inventory WHERE { wd:Q10753710 p:1435 [ps:p1435 ?heritage; pq:P217 ?inventory]. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } } ORDER BY ?inventory

• commons:Category:Cultural heritage monuments in Croatia and on WD Category:Cultural heritage monuments in Croatia (Q28659288), plus commons:Category:Cultural heritage monuments in Croatia with known IDs

• Wiki Loves Monuments: Wikidata:WikiProject WLM/Status rows for HR country code

Landfill

SELECT DISTINCT ?item ?itemLabel ?coordinate_location ?countryLabel ?located_in_the_administrative_territorial_entityLabel WHERE { SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". } { SELECT DISTINCT ?item WHERE { ?item p:P31 ?statement0. ?statement0 (ps:P31/(wdt:P279*)) wd:Q152810. } LIMIT 100 } OPTIONAL { ?item wdt:P625 ?coordinate_location. } OPTIONAL { ?item wdt:P17 ?country. } OPTIONAL { ?item wdt:P131 ?located_in_the_administrative_territorial_entity. } }

Phrases

• /phrases

Navbox

• Wikidata:Country property navboxes - long list by country of existing navboxes