search

oaregithub / oare_sql

1 stars 0 forks source link

Tablets with duplicate side values in text_epigraphy #9

Closed edstratford closed 1 year ago

edstratford commented 1 year ago

Gertrudius opened this issue on oare_mono:

There are a significant number of tablets that have a repeated side of the tablet. At least some of them seem to retain these values from OCHRE, so these will probably need to be examined on an individual basis to see what's going on. See the below query for a list of examples:

SELECT sub.text_uuid, count(sub.text_uuid) FROM (SELECT text_uuid, side, count(side) FROM oarebyue_0.3.text_epigraphy WHERE type = "section" GROUP BY text_uuid, side HAVING count(side) > 1) AS sub GROUP BY text_uuid;

edstratford commented 1 year ago

Stratford on 25 Sep 2022:

Eliminated all but 47 of these, reviewing remainder on case-by-case basis.

AND

At least 4 texts are cases of a last line that has wrapped around again to obverse after going all the way around. ee6d8573-61eb-4b22-ad08-ebc49742be16 eaf139da-935e-40eb-b5c9-f87eba6f4abf da4615d3-7dd4-4363-bb9c-104e8673b917 d4142f7c-9798-359f-df45-e15113bb7d7a

Roughly 17 more to review

edstratford commented 1 year ago

Stratford on 26 Sep 2022:

7 thorny texts remain

edstratford commented 1 year ago

As of 6 June 2023 the query no longer returns any results - we did renumber cases where a line comes over onto the obverse earlier which probably eliminated all examples of this.