weird behavior with Plataea (priority: hestia critical)

[atomrab]

Looking at a reference to Plataea, I saw that a) on its place page it appeared as having no references in Herodotus (which would be odd) and b) its Pleiades link is http://pleiades.stoa.org/places/#Plataea, which just takes you to the generic ancient places page. Is this an import issue, a database issue, or a Geoparser issue? I noted the error but haven't fixed it, in case it's useful to look at the problem.

[katefbyrne]

I can't find a problem for Plataea in the source data or the database (but I may be missing something of course).

There are 33 "Plataea" tokens, mostly in book 9, and they all have 541063 as their PleiadesID, which is correct.

Looking at it the other way, there are 45 tokens linked to http://pleiades.stoa.org/places/541063/. The extra 12 comprise 11 "Cithaeron" tokens and one "Plataeae".

Kate

[For reference, the SQL used to check was: a) SELECT pageid, gap_gazrefs.tokenid, token, uri FROM gap_gazuris, gap_tokens, gap_gazrefs where gap_gazrefs.uriID=gap_gazuris.id and gap_gazrefs.tokenID=gap_tokens.id and token="Plataea"; b) SELECT pageid, gap_gazrefs.tokenid, token, uri FROM gap_gazuris, gap_tokens, gap_gazrefs where gap_gazrefs.uriID=gap_gazuris.id and gap_gazrefs.tokenID=gap_tokens.id and sourceref="541063";]

On 10/22/13 22:13, atomrab wrote:

Looking at a reference to Plataea, I saw that a) on its place page it appeared as having no references in Herodotus (which would be odd) and b) its Pleiades link is http://pleiades.stoa.org/places/#Plataea, which just takes you to the generic ancient places page. Is this an import issue, a database issue, or a Geoparser issue? I noted the error but haven't fixed it, in case it's useful to look at the problem.

— Reply to this email directly or view it on GitHub https://github.com/ekansa/gap2/issues/9.

Kate Byrne School of Informatics, University of Edinburgh http://homepages.inf.ed.ac.uk/kbyrne3/ location: http://geohash.org/gcvwr2rkb5hd twitter: @katefbyrne

The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.

[ekansa]

I have to trace this, but I'm going to guess what's wrong. This may have been the result of me updating coordinates from the Pleiades data dump because the GeoParser coordinates where based on old Pleiades Plus data.

For some reason, some places didn't have lat / lon coordinates. For those, I made a fake URI to http://pleiades.stoa.org/places/#Plataea to make it easy to globally. This relates to the issue Adam had in wanting to edit all tokens for a place that were wrong.

I'm going to hold off on this issue until I get a chance to load up the data from Kate again. There are several records with no lat/lon coordinates to worry about. -E

On Tue, Oct 22, 2013 at 3:46 PM, Kate Byrne notifications@github.comwrote:

I can't find a problem for Plataea in the source data or the database (but I may be missing something of course).

There are 33 "Plataea" tokens, mostly in book 9, and they all have 541063 as their PleiadesID, which is correct.

Looking at it the other way, there are 45 tokens linked to http://pleiades.stoa.org/places/541063/. The extra 12 comprise 11 "Cithaeron" tokens and one "Plataeae".

Kate

[For reference, the SQL used to check was: a) SELECT pageid, gap_gazrefs.tokenid, token, uri FROM gap_gazuris, gap_tokens, gap_gazrefs where gap_gazrefs.uriID=gap_gazuris.id and gap_gazrefs.tokenID=gap_tokens.id and token="Plataea"; b) SELECT pageid, gap_gazrefs.tokenid, token, uri FROM gap_gazuris, gap_tokens, gap_gazrefs where gap_gazrefs.uriID=gap_gazuris.id and gap_gazrefs.tokenID=gap_tokens.id and sourceref="541063";]

On 10/22/13 22:13, atomrab wrote:

Looking at a reference to Plataea, I saw that a) on its place page it appeared as having no references in Herodotus (which would be odd) and b) its Pleiades link is http://pleiades.stoa.org/places/#Plataea, which just takes you to the generic ancient places page. Is this an import issue, a database issue, or a Geoparser issue? I noted the error but haven't fixed it, in case it's useful to look at the problem.

— Reply to this email directly or view it on GitHub https://github.com/ekansa/gap2/issues/9.

Kate Byrne School of Informatics, University of Edinburgh http://homepages.inf.ed.ac.uk/kbyrne3/ location: http://geohash.org/gcvwr2rkb5hd twitter: @katefbyrne

The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.

— Reply to this email directly or view it on GitHubhttps://github.com/ekansa/gap2/issues/9#issuecomment-26861117 .