search

oaregithub / oare_mono

1 stars 0 forks source link

Tablets with duplicate `side` values in `text_epigraphy` #1290

Closed Gertrudius closed 1 year ago

Gertrudius commented 2 years ago

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

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

edstratford commented 1 year ago

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

7 thorny texts remain

edstratford commented 1 year ago

This issue has been moved to the oare_sql repo.