User:DutchTreat/projects
Lists edit
Tools edit
- Mix-N-Match on toolforge.org , more info at m:Mix'n'match
OpenRefine edit
- 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 edit
- Example: On Love & Data (Q113509290)
- name: On Love & Data - description: 2022 Stephanie Dinkins exhibition at the Queens Museum
Properties edit
- 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 edit
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 edit
- National Gallery of Art (Q214867) in Washington, D. C.
Company edit
Croatia (HR) edit
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 edit
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 edit
Events edit
Strikes edit
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:
- Asbestos Strike (Q3118367) image of police reaction in 1949
- Knysna fiasco (Q1410411) no image yet as of 2024-03-23
- Canton-Hong Kong strike (Q1634875) no image yet as of 2024-03-23, improve metadata
- Gurindji strike (Q246080) image of cattle station
-
Q3118367 (1949) -
Q246080 (1962)
Places edit
- OSM linking tool: OSM-Wikidata Link
City Hall edit
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
- 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 edit
- 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 edit
- 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 edit
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 edit
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 edit
edit
- Wikidata:Country property navboxes - long list by country of existing navboxes
