Wikidata

User:DutchTreat/projects

< User:DutchTreat

Lists

edit

Tools

edit

OpenRefine

edit

- "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

- 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

Other American museums

edit

Company

edit

Croatia (HR)

edit

Improve the parent/child relationships for subsidiaries:

Banks
Food and Beverage
Pharmaceuticals

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:

  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)

People

edit

Japan

edit

Places

edit

ASCE Landmarks

edit
Query
  • 190 items in Wd using this property, as of 2024-July.
Basic with count of properties

#title:Items with most values of the property P5904 SELECT ?item ?itemLabel ?cnt { { SELECT ?item (COUNT(?value) AS ?cnt) { ?item wdt:P5904 ?value } GROUP BY ?item ORDER BY DESC(?cnt) LIMIT 200 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?cnt)

ID with ASCE ID plus location for mapping

#title:Items with most values of the property P5904 SELECT ?item ?itemLabel ?ASCE_Historical_Civil_Engineering_Landmark_ID ?coordinate_location WHERE { { SELECT ?item WHERE { ?item wdt:P5904 ?value. } LIMIT 300 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } OPTIONAL { ?item wdt:P625 ?coordinate_location. } OPTIONAL { ?item wdt:P5904 ?ASCE_Historical_Civil_Engineering_Landmark_ID. } } RUN

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 run


Heritage

edit

By Country

edit

Croatia

edit

My sandbox: /Croatia

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

  • 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

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

Sports

edit
  • Dragway for w:drag racing
    • Colorado src : add Julesburg Dragstrip , 17454 Hwy 138 Julesburg, CO 80737; Pueblo Motorsports Park 3733 North Pueblo Boulevard Pueblo, CO 81008
edit
Cultural heritage properties
General
International
National
Americas
Asia
Europe
Western Europe
Eastern Europe
Northern Europe
Southern Europe
Subnational
Americas
Canada
United States of America
Australia
Europe
Belgium
Germany
Italy
Spain
United Kingdom
Retrieved from "https://www.wikidata.org/w/index.php?title=User:DutchTreat/projects&oldid=2203088417"