Page MenuHomePhabricator
Create Task
Maniphest T174426

Add Uganda in English to monuments database
Closed, ResolvedPublic
Actions

Description

Lists are at https://en.wikipedia.org/wiki/National_Cultural_Sites_of_Uganda

  • project - wikipedia
  • lang - en
  • headerTemplate - National Cultural Site of Uganda header
  • rowTemplate - National Cultural Site of Uganda row
  • commonsTemplate -National Cultural Site Uganda
  • commonsTrackerCategory - National Cultural Sites in Uganda with known IDs
  • commonsCategoryBase - National Cultural Sites in Uganda
  • autoGeocode - ?? To automagicly geocode the images at Commons (be careful)
  • unusedImagesPage - ?? Please create
  • imagesWithoutIdPage - ?? Please create -- Page to put the list of images without an id.
  • registrantUrlBase -
  • namespaces - 0
  • table - monuments_ug_(en) - The name of the table, convention monuments_<country>_(<lang>)
  • truncate - ?? False if you don't have a real primkey
  • primkey - number

For archive happyness: the lists originated from a pdf obtained from the National Museum.

Proposed config (inclomplete)

P5935 uganda for monuments DB
1{
2 "country": "uh",
3 "lang": "en",
4 "description": "Monuments in Uganda in English",
5 "project": "wikipedia",
6 "namespaces": [
7 0
8 ],
9 "table": "monuments_ug_(en)",
10 "truncate": false,
11 "primkey": "number",
12 "headerTemplate": "National Cultural Site of Uganda header",
13 "rowTemplate": "National Cultural Site of Uganda row",
14 "commonsTemplate": "National Cultural Site Uganda",
15 "commonsTrackerCategory": "National Cultural Sites in Uganda with known IDs",
16 "commonsCategoryBase": "National Cultural Sites in Uganda",
17 "unusedImagesPage": "",
18 "imagesWithoutIdPage": "",
19 "fields": [
20 {
21 "dest": "number",
22 "source": "number",
23 "type": "varchar(11)"
24 },
25 {
26 "dest": "region_iso",
27 "source": "region_iso"
28 },
29 {
30 "dest": "site",
31 "source": "site"
32 },
33 {
34 "dest": "description",
35 "source": "description"
36 },
37 {
38 "dest": "district",
39 "source": "district"
40 },
41 {
42 "dest": "location",
43 "source": "location"
44 },
45 {
46 "dest": "original_function",
47 "source": "original_function"
48 },
49 {
50 "dest": "image",
51 "source": "image"
52 },
53 {
54 "dest": "commonscat",
55 "source": "commonscat"
56 },
57 {
58 "dest": "lat",
59 "source": "lat",
60 "check": "checkLat"
61 },
62 {
63 "dest": "lon",
64 "source": "lon",
65 "check": "checkLon"
66 },
67 {
68 "dest": "monument_article",
69 "source": "site",
70 "conv": "extractWikilink"
71 }
72 ],
73 "sql_lang": "English",
74 "sql_country": "Uganda",
75 "sql_data": {
76 "country": {
77 "value": "ug",
78 "type": "Text"
79 },
80 "lang": {
81 "value": "en",
82 "type": "Text"
83 },
84 "id": {
85 "value": "number",
86 "type": "Field"
87 },
88 "adm0": {
89 "value": "ug",
90 "type": "Text"
91 },
92 "adm1": {
93 "value": "LOWER(`region_iso`)",
94 "type": "Raw"
95 },
96 "adm3": {
97 "value": "district",
98 "type": "Field"
99 },
100 "name": {
101 "value": "site",
102 "type": "Field"
103 },
104 "address": {
105 "value": "location",
106 "type": "Field"
107 },
108 "municipality": {
109 "value": "district",
110 "type": "Field"
111 },
112 "lat": {
113 "value": "lat",
114 "type": "Field"
115 },
116 "lon": {
117 "value": "lon",
118 "type": "Field"
119 },
120 "image": {
121 "value": "image",
122 "type": "Field"
123 },
124 "commonscat": {
125 "value": "commonscat",
126 "type": "Field"
127 },
128 "source": {
129 "value": "source",
130 "type": "Field"
131 },
132 "changed": {
133 "value": "changed",
134 "type": "Field"
135 },
136 "monument_article": {
137 "value": "monument_article",
138 "type": "Field"
139 }
140 }
141}

Details

SubjectRepoBranchLines +/-
Add Uganda in English (ug_en)labs/tools/heritagemaster+141 -0
Customize query in gerrit

Related Objects

Event Timeline

Effeietsanders created this task.Aug 29 2017, 10:17 AM
Effeietsanders added a project: Wiki-Loves-Monuments (2017).
Effeietsanders updated the task description. (Show Details)Aug 29 2017, 10:22 AM
Lokal_Profil added a comment.Aug 29 2017, 10:24 AM

Quick question. Are the id's official or invented for the sake of WLM?

Effeietsanders added a comment.Aug 29 2017, 10:25 AM

The ID's are not in the document as such, but are based on the ISO code for the region combined with the order. `They are probably not persistent.

Lokal_Profil added a comment.EditedAug 29 2017, 10:41 AM

I assume site is the name and that that is the field which would be wikilinked if there is an article about the monument?

For unusedImagesPage I would suggest Wikipedia:WikiProject Historic sites/Unused images of National Cultural Sites in Uganda
For imagesWithoutIdPage I would suggest Wikipedia:WikiProject Historic sites/Images of National Cultural Sites in Uganda without an ID

(both per Nepal mappings)

I would suggest removing the "?" values and instead have the template default to that or "no known name"

Lokal_Profil added a comment.Aug 29 2017, 10:44 AM

Updated the template and the one list with ???s

Effeietsanders added a comment.Aug 29 2017, 10:45 AM

Site should be the 'name' of the site, or a few word description. Ideally linked yes.

Feel free to improve the data btw, I only copied the existing data from another table. The official value of the site name seems to actually be "?" but I doubt they're very attached to it :)

Lokal_Profil updated the task description. (Show Details)Aug 29 2017, 10:46 AM
Lokal_Profil added a comment.Aug 29 2017, 10:48 AM

If the unusedImagesPage/imagesWithoutIdPage are ok with the local organisers then I think we are good to go.

Effeietsanders added a comment.Aug 29 2017, 10:54 AM

I don't have the impression they have a specific preference. I'll poke them to let us know in the next 24h if objecting.

Alicia_Fagerving_WMSE added a subscriber: Alicia_Fagerving_WMSE.Aug 31 2017, 7:23 AM
gerritbot added a subscriber: gerritbot.Sep 23 2017, 5:23 PM

Change 379992 had a related patch set uploaded (by Jean-Frédéric; owner: Jean-Frédéric):
[labs/tools/heritage@master] Add Uganda in English (ug_en)

https://gerrit.wikimedia.org/r/379992

gerritbot added a project: Patch-For-Review.Sep 23 2017, 5:23 PM
JeanFred moved this task from Backlog to Ready to merge on the Wiki-Loves-Monuments-Sources board.Sep 23 2017, 5:24 PM
JeanFred moved this task from Backlog to In-progress on the Wiki-Loves-Monuments (2017) board.Sep 23 2017, 6:30 PM
Lokal_Profil added a comment.Sep 24 2017, 8:24 PM

@Effeietsanders It looks like one of the id's went wrong. See https://en.wikipedia.org/wiki/Talk:List_of_National_Cultural_Sites_in_Western_Region,_Uganda#Wrong_id

gerritbot added a comment.Sep 24 2017, 8:30 PM

Change 379992 merged by jenkins-bot:
[labs/tools/heritage@master] Add Uganda in English (ug_en)

https://gerrit.wikimedia.org/r/379992

Stashbot added a subscriber: Stashbot.Sep 24 2017, 8:46 PM

Mentioned in SAL (#wikimedia-cloud) [2017-09-24T20:46:50Z] <JeanFred> Deploy latest from Git master: 96feb02 (T174426), dafe240

JeanFred moved this task from Ready to merge to Ready for harvesting on the Wiki-Loves-Monuments-Sources board.Sep 24 2017, 8:48 PM
JeanFred added a comment.Sep 25 2017, 2:05 PM

Harvesting done: 553 monuments (List)

JeanFred moved this task from Ready for harvesting to Harvested on the Wiki-Loves-Monuments-Sources board.Sep 25 2017, 2:06 PM
Lokal_Profil closed this task as Resolved.Sep 25 2017, 9:45 PM
Lokal_Profil assigned this task to JeanFred.
In T174426#3630421, @Lokal_Profil wrote:

@Effeietsanders It looks like one of the id's went wrong. See https://en.wikipedia.org/wiki/Talk:List_of_National_Cultural_Sites_in_Western_Region,_Uganda#Wrong_id

I found the original document and fixed the issue.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL