User:Einebillion

en-N	This user has a native understanding of English.

This user loves Wikidata.

This user uses QuickStatements.

This user uses Mix'n'match.

This user loves OpenRefine.

Introduction

I am Victoria Leachman and I live in Wellington, New Zealand. I am a GLAM (Galleries, Libraries, Archives & Museums) professional having worked in museums for my entire career, initially as a museum collection manager, then as a manager of copyright processes within a museum, and now as an executive and people manager making collections more accessible and reuseable for the public. I manage teams responsible for a research library, corporate archives and records, copyright clearances and processes, collections information management and data and digital preservation workflows, imaging, publishing, and lending collection items.

Main contributions (as at October 2025)

Note: I have recently completed a six month break from my Wikimedia duties as I travelled Europe. I returned to my duties at the start of October.

I contribute to the Wikiverse in my role as President of Wikimedia Aotearoa New Zealand incorporated society (WANZ) - the Aotearoa New Zealand chapter affiliated with Wikimedia Foundation. In this role I do on average 3 hours of organising a week including

a weekly meeting with the Executive Advisor planning workload for her and the part time Marketing / Comms person,
confirming the agenda of the monthly board meeting,
chairing board meetings
meeting separately with individual board members
recruiting new board members
chairing the AGM
writing board papers and reports
planning strategy, budgets, and funding applications
reporting
connecting with Wikimedia Foundation staff and staff and board members of other affiliates
attending WANZ events and WANZ funded events in my area
advocating within the GLAM and education sectors for more engagement with the Aotearoa New Zealand chapter and the Wikimedia projects in general

I also co-organise and facilitate two regular user meetups, the Aotearoa New Zealand Online monthly meetup and the Wellington monthly meetup. This involves working with Ambrosia10 to set up new meta pages for each event, take attendence, facilitate, and tidy up the notes from the meeting. These meetings allow us to share information that is happening in the community and the chapter with other editors, to hear feedback, and to share editing skills with each other.

I am a member of the Museum of New Zealand Te Papa Tongarewa staff wikipedia editing group and, as a manager, I encourage the Librarians and other knowledge professionals I manage to participate in professional development sessions about Wikimedia projects and to attend events organised by the Digital Outreach Manager e.g. edit-a-thons and #1Lib1Ref events. I regularly support the Digital Outreach Manager with her initiatives to share Te Papa's content by attending public events and being an experienced editor on hand to assist newbies.

My ORCID is https://orcid.org/0000-0002-2008-1827

Work currently being undertaken (October 2025)

I am involved in three separate projects establishing high quality linked data:

New Zealand historic photographers from 1850s - 1950
Participants of the New Zealand Wars (1845-1872)
Provenance research associated with the British collectors and dealers in ethnographic material - William Ockleford Oldman and William Downing Webster.

The majority of the people I am interested in are not part of a large dataset. I am gathering information on them and entering data into Wikidata manually with references. Where I can I use mix'n'match to connect individuals with other datasets and identifyers. I spend a lot of time cleaning up mix'n'match. I also contribute to New Zealand Theses Project where possible.

New Zealand Historic Photographers 1850s - 1950

The reason I picked this as one of my areas of interest is because when I was researching photographer copyright at my work I found it difficult to trace individual photographers' dates of death. As a consequence it was difficult to establish when their work assended from copyright and into the public domain. Particularly in the United Kingdom the information on Victorian photographers is behind a paywall so this is my attempt to free information to have a solid base from which to judge copyright duration.

I've worked with User:DrThneed and gathered publicly accessible datasets from the Museum of New Zealand Te Papa Tongarewa collections online and the New Zealand Women Photographers dataset. This included establishing the New Zealand Women Photographers Wikidata Project.

I'm still working through manually checking the Women photographers dataset. I've also received the dataset from Auckland Libraries of historic New Zealand photographers but have yet to import this using Open Refine.

Participants of the New Zealand Wars (1845-1872)

I am using a combination of Wikidata for notable participants and Wikitree for those that have yet to reach Wikidata notability. The reason I'm working on assembling this data is to assist researchers with provenance research. It was common for those serving in the New Zealand Wars to gather Maori treasures. It was also common through time for these items to be traded and to be acquired by collecting institutions such as museums and galleries. By identifying those that collected these items and their service record, it gives a greater likelihood of reconnecting these treasures with their provenance and with their source communities.

Provenance Research

I've recently set up a project called: Provenance Research: The clients of W. O. Oldman and W. D. Webster.

There is a worldwide movement in galleries and museums to decolonise the language describing public collection items and to link collection items back to the source communities. Similar to the previous topic, this project works to document a significant time period in collections provenance research and identifies those individuals trading with two of the foremost ethnographic traders of the Victorian and Edwardian period. Ensuring this data is entered into Wikidata will assist museums with the provenance research of their collection.

I am using the publicly available images of letter books and stock books of both of these traders and attempting to identify as many of their clients as possible. A large number of their clients were significant individuals already existing in Wikidata or significant enough to feature in Wikidata.

Other bits and pieces

Working through the digitized catalogues of World Fairs and ensuring that the New Zealand photographers that participated in these exhibitions are reflected as having participated. see progress on Google sheet https://docs.google.com/spreadsheets/d/1JrVXLf5JbzAZ-QFk0IQKTsDvxznA_FsO-zwsQUCn94s/edit#gid=1418688886
Working through the biographical data from book Nineteenth Century New Zealand Artists: A Guide and Handbook. https://www.wikidata.org/wiki/Q80587764
Working through Soldiers of the Empire New Zealand medal recipient lists. Datasets and information I haven't requested yet include:

Conflict of Interest

I work for the Museum of New Zealand Te Papa Tongarewa. My full conflict of interest statement is available on my Wikipedia User page.

Organising and Resource Development Work

For information on my facilitation of meetup groups see my Wikipedia User Profile.
Subpage for my manual on how I set up my Wikidata projects, documented workflows, including my own how-tos with OpenRefine User:Einebillion/Manual
My notes when teaching people about wikidata User:Einebillion/Teaching notes

File:Https://meta.wikimedia.org/wiki/File:Wikidata-in-brief-1.0.pdf

Wikidata in Brief

My Wikidata Information Set for Bulk Processes for GLAM collections User:Einebillion/GLAM notes

Work Done

COMPLETED Working through dataset of New Zealand photographers from Te Papa and reconciling with wikidata Q numbers.
COMPLETED Working through the biographical data from manuscript The Pioneer Land Surveyors of New Zealand. https://www.wikidata.org/wiki/Q104113251d
COMPLETED Adding Tuhinga articles metadata to wikidata

Ideas

Taxonomy work. See video for taxonomic names and concepts and differences in protocols across botany and zoology. https://www.youtube.com/watch?v=vPVm5S0qIcs

My scatch pad for Wikidata Queries

NOTE FOR SELF Control space whilst hovering in the wdt: or wd: area gives you a search function!!!

Provenance Research Project list sorted by family name https://w.wiki/Fy6b

New Zealand Photographers sorted by family name https://w.wiki/6Rvb

SELECT ?item ?itemLabel ?familyname ?familynameLabel WHERE {

 ?item wdt:P106 wd:Q33231 . # Occupation is photographer
 {?item wdt:P27 wd:Q664 } # Country of citizenship is New Zealand
 UNION {?item wdt:P27 wd:Q2594990 } # or Country of citizenship is Dominion of New Zealand
 UNION {?item wdt:P27 wd:Q5148518 } # or Country of citizenship is Colony of New Zealand
 ?item wdt:P734 ?familyname . # item also includes the value family name so it can be picked up in the dataset and for ordering purposes

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ASC(?familynameLabel) #order alphabetically by family name label

New Zealand Photographic Studios https://w.wiki/8dcM

SELECT ?item ?itemLabel WHERE {

 ?item wdt:P31 wd:Q672070 . # instance of photographic studio
 {?item wdt:P17 wd:Q664 } # Country is New Zealand
 UNION {?item wdt:P17 wd:Q2594990 } # or Country is Dominion of New Zealand
 UNION {?item wdt:P17 wd:Q5148518 } # or Country is Colony of New Zealand

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ASC(?itemLabel) #order alphabetically by item name

Photographers with Te Papa ID SELECT ?item ?itemLabel ?TePapaID WHERE {

?item wdt:P106 wd:Q33231 . # Occupation is photographer
?item wdt:P3544 ?TePapaID . # item also includes the value Te Papa Artist ID so it can be picked up in the dataset and for ordering purposes

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC (?TePapaIDLabel) #order numerically

Photographic Studios with Te Papa ID

SELECT ?item ?itemLabel ?TePapaID WHERE {

?item wdt:P31 wd:Q672070 . # instance of photographic studio
?item wdt:P3544 ?TePapaID . # item also includes the value Te Papa Artist ID so it can be picked up in the dataset and for ordering purposes

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC (?TePapaIDLabel) #order numerically

All Wikidata Q numbers with a Te Papa Agent ID

This query can be actioned by going to the Te Papa Agent ID property P3544 and clicking on the Talk/Discussion tab. In the Documentation section and along the Te Papa agent ID row there are a number of links to Wikidata Query Service which include common queries. Current Uses returns Q item number, itemLabel and Te Papa agent ID value. Remember to remove the item limit before running the report otherwise it will be limited to 1000 items.

All botanists with Te Papa ID

SELECT ?item ?itemLabel ?TePapaID WHERE {

?item wdt:P106 wd:Q2374149 . # occupation of Botanist
?item wdt:P3544 ?TePapaID . # item also includes the value Te Papa Artist ID so it can be picked up in the dataset and for ordering purposes

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC (?TePapaIDLabel) #order numerically

https://w.wiki/3dJD

Tuhinga Scholarly Articles

SELECT ?item ?itemLabel WHERE {

 ?item wdt:P1433 wd:Q15757882 . # published in Tuhinga

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ASC(?itemLabel) #order alphabetically by item name

Nineteenth century New Zealand artists: a guide and handbook listing

SELECT ?item ?itemLabel ?familyname ?familynameLabel WHERE {

 ?item wdt:P1343 wd:Q80587764 . # described by source is Nineteenth century New Zealand artists: a guide and handbook
 ?item wdt:P734 ?familyname . # item also includes the value family name so it can be picked up in the dataset and for ordering purposes

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY ASC(?familynameLabel) #order alphabetically by family name label

New Zealand Wars participant https://w.wiki/552e

Properties to use in Tabernacle or OpenRefine

https://tools.wmflabs.org/tabernacle/#/

OpenRefine howtos User:Einebillion/Manual

New Zealand Photographers

Property	Property title	Value Q number	Q title
P31	Instance of	Q5	Human
P18	Image	Example	Example
P21	Sex	Example	Example
P27	Country of citizenship	Q664	New Zealand
P735	Given name	Example	Example
P734	Family name	Example	Example
P1317	active ( value needs to be year)	Example	Example
P569	date of birth	Example	Example
P19	place of birth	Example	Example
P570	date of death	Example	Example
P20	place of death	Example	Example
P119	place of burial	Example	Example
P106	Occupation	Q33231	Photographer
P937	work location	Example	Example
P1830	Owner of	Example	Example
P6379	has works in the collection(s)	Example	Example
P31184	sibling	Example	Example
P463	member of	Example	Example
P1066	student of	Example	Example

New Zealand Photographic Studios

Property	Property title	Value Q number	Q title
P31	Instance of	Q672070	Photographic studio
P31	Instance of	Q43229	Organization
P17	Country	Q664	New Zealand
P18	Image	Example	Example
P159	Headquarters Location (City)	Example	Example
P669	Located on street	Example	Example
P276	Location (City)	Example	Example
P571	Inception	Example	Example
P576	Dissolved, abolished or demolished	Example	Example
P127	Owned by	Example	Example
P1037	Director / manager of	Example	Example
P155	Follows	Example	Example
P156	Followed by	Example	Example
P6379	Has works in the collection(s)	Example	Example
P463	member of	Example	Example

Spreadsheet tips for me

User:Einebillion/Google Sheets Tips How to find duplicate values in excel spreadsheet columns http://spreadsheetpro.net/comparing-two-columns-unique-values/

Column A = list of IRNs for people extracted from GLAM collection API
Column B = List of organisation names
Column C - List of people names
Column D - blank column
Column E - Qnumber extracted using Wikidata query service script
Column F - Name extracted from wikidata Q entry using Wikidata query service script
Column G - GLAM collection IRN extracted from wikidata Q entry using Wikidata query service script

To compare these two columns to extract out from the API set those that already have Q numbers use the following excel formula in cell A2 and then drag it down to repeat as many rows as required.

=IF(ISERROR(MATCH(A2,$G$2:$G$771,0)),"",A2)

The formula in cell F3 looks like this: =IF(ISERROR(MATCH(D3,B$3:B$8,0)),"No","Yes (" & MATCH(D3,B$3:B$8,0) & ")"). It's a little longer and more complicated but if we break it down you'll see what is happening. The IF function has 3 parts: (1) What you want to check (2) What to do if it's True (3) What to do if it's False. In this case we're checking if ISERROR(MATCH(A2,$G$2:$G$771,0)) is True or False. We already know what the MATCH function does, and the ISERROR function just checks to see if the MATCH function returns an error (i.e. no match) or a number. If MATCH returns a #N/A then ISERROR will be True, otherwise it will be False.

Now, if ISERROR is True (i.e. we didn't find a match) then the IF function will return a blank value. If ISERROR is False (i.e. we found a match) then the IF function will return the value of whatever is in A2.

Notes to self

Draft property proposal

Property Proposal location for person

Description has natural environment specimens in collection(s)
Represents the institution holding the natural environment specimens collected by the subject
Data type Item
Domain qualifier for ?
Allowed values human (Q5)

Example 1 Joseph Dalton Hooker (Q157501) -> Museum of New Zealand Te Papa Tongarewa (Q915603)
Example 2 Joseph Dalton Hooker (Q157501) -> National Museum of Natural History (Q148554)
Example 3 James Hector (Q675726) -> Natural History Museum (Q309388)
Example 4
Motivation: Adds the identity of organisations that hold the specimens collected by the subject. I anticipate that the majority of organisations would be universities or GLAM organisations. Demonstrates reach and impact of work of scientist / collector. May assist with providing provenance information for specimens.
Discussion: There are wikidata properties for Archives at (P485): the institution holding the subject's archives, and has works in the collection(s) (P6379): the institution or collection holding the artworks created by the subject. This additional property enables another GLAM data element to be included into Wikidata.