Yannis Lolos and the GGRS87

I was fortunate to receive Yannis Lolos’ Land of Sikyon a few days ago.  This is an investigation of the territory formerly dominated by Sicyon in the western Corinthia.  Not only is the book a valuable reference but it’s a joy just as a physical object – a beautifully made book.

One of its features is a gazetteer of all the find spots in the territory of Sicyon from the Neolithic to the Early Modern.  Each place is described and precisely located.  Only one problem.  Dr. Lolos’ does not give the coordinates in ordinary lat/lon form (technically the WGS84 projection) but in the Greek Grid system (GGRS87/EGSA87) which will be incomprehensible to most readers.  

What to do?

I found an easy-to-use site that will allow you to convert coordinate pairs from the GGRS87 projection to the WGS84 (what humans use).  It is here: 

http://www.themos-sa.gr/proj/index.php

To use this site you enter the GGRS coordinates in the upper right-hand box separated by commas.  You press the convert button and the lat/lon pair shows up in the upper left-hand box.  

So let's use a little Mycenaean settlement called 'Klimenti, Mastrogianni'  (Lolos [2011], p. 425, 'HS-11', 'Klimenti, Mastrogianni') as an example.  This is a small area (about 0.7 ha.) for which Dr. Lolos gives us the four corner points in GGRS 87 easting/northing pairs.  The first coordinate is 376799, 4203582.  You enter it into the conversion interface like this:

The conversion screen.  Enter the GGRS pair in the  right upper window (center),
press the 'Convert' button, and read the lat/lon (WGS84) pair in the upper left window.

The illustration shows you the conversion process for that point.  It maps to point 1 in this Google Earth image:

Four corner points for the site of Klimenti, Mastrogianni (HS-11).
Coordinates are numbered in the order in which Lolos presents them on p. 425.

Our first coordinate is the white arrow numbered '1' in the image above.   The set of four coordinates is this:

Easting	Northing	Lat	Lon
376799	4203582	37.97412198	22.59898503
376648	4203590	37.97417358	22.59726491
376653	4203631	37.97454367	22.59731479
376800	4203636	37.97460867	22.59898716

The 'file' button on this interface allows you to save a set of converted lat/lon pairs that have been converted to GGRS87 but I don't see that there's a way to create a file of GGRS87 points and have them converted all at once to WGS84.

I find an algorithm for converting from WGS84 to the Greek system at this web page:

http://studentguru.gr/b/kokyri/archive/2012/02/21/convert-coordinates-from-greek-grid-ggrs87-87-espg-2100-to-latitude-longitude-wsg84

This would have to be coded if I wanted, for example, to add the GGRS87 coordinate pairs to the 2000+ points in the Mycenaean Atlas Project, for example.  

I'll think about it.

Status of the Mycenaean Atlas Project:  www.helladic.info

I uploaded a new DB to helladic.info.  The specifications are: 

Database Update: Rev. 36. (MAP_Rev_0.036__09_13_17_Test)

Of the 1500 points in Dr. Murray's DB that I have targetted for initial integration I have completed about 1200.  There are currently 2055 separate sites in the Mycenaean Atlas Project DB.

Anyone who would like to have a copy of the MAP database can send an e-mail to bobconsoli 'at' gmail.com or leave a comment on any of my posts.  To run the MAP database requires a SQL server running on your desktop computer.   MySQL is such a server and it is powerful, industry-standard, and free.   Anyone who has a version of the DB from more than a month ago should request a new one.

I can and will make .kml or .kmz files, which can be opened directly in Google Earth, available to those who would like them.

  

I can also create .csv files for people who would like to import Mycenaean Atlas Project data into Google Earth but would like it in tabular form.  I do recommend that you use the website at www.helladic.info      Most of your needs can probably be met on that site and you can generate .kmz files for maps that you create.

If you like these posts then please follow me on Twitter (Squinchpix) or on Google+   (Robert Consoli)

Friends don't let friends use Facebook.

Bibliography

Lolos [2011]:      Lolos, Yannis A.   Land of Sikyon: Archaeology and History of a Greek City-State. Hesperia supplements, 39.   Princeton:  American School of Classical Studies at Athens, 2011.

A Trove of Precise Locations in Bronze Age Cyprus

You are welcome, Sir, to Cyprus.  Goats and Monkeys!
Othello, iv, 1


Recently I’ve been adding locations in Cyprus to the Mycenaean Atlas Project.  From van Wijngaarden[1] I’ve derived a list of some 90 places where Mycenaean ceramics have been found.  I learn, somewhat to my surprise, that there is no definite evidence of Mycenaean settlement or colonization on Cyprus.  There is, of course, no shortage of papers that claim as much.[2]

Bronze Age sites in Andreou [2014]

The purpose of this post is to share with my readers a resource that turned up unexpectedly while reading about this island.  In Andreou’s study of Bronze Age Cyprus there is an appendix of more than 180 BA archaeological sites on Cyprus with their exact positions.[3]  This is a veritable treasure trove and although she presents her position data in a not-very-friendly form of UTM (Universal Transverse Mercator)[4]  in about twenty minutes I was able to take her entire list, establish a file, and convert it with a UTM to DMS converter.  I used this conversion site. 

The result was a glorious .kml file, suitable for opening in Google Earth, that you can safely pick up from my Google Drive account here. 

Kalavasos Valley according to Andreou [2014].

If you prefer this information in a comma separated file (.csv) you can download it from Google Drive here.

How good is her data?  Every measurement contains error.  So I did a bit of checking.  I do know where Kalavasos-Tenda is so I looked at her answer for that location:

Kalavasos-Tenda.

Kalavasos-Tenda is a Neolithic site in the Kalavasos valley in southern Cyprus.  The orange dot in the above photo is from my Features table.  Its position is 34.752469° N, 33.303370° E.  Dr. Andreou's location is the purple push pin.  That pin is about 10 meters from the closest edge of the 'tent'.  That distance of 10 meters is, as far as I'm concerned, more than acceptable in work of this kind.

Dr. Andreou’s data was very helpful for confirming my location for Erimi-Kafkalla.  

First let’s look at a sketch map.[5]

Erimi-Kafkalla is a large early BA settlement and necropolis in southern Cyprus.[6]  I make its position to be here: 34.688212° N, 32.916350° E. 

Now let’s look at it in Google Earth here.

The water tank is in the right position although there are two rather than Swiny's one.  The altitudes match; I have marked one of the places where Google Earth makes it to be 120 m. altitude.  The informal road to the west of the tank is now paved and what appears to be a large freeway at the bottom is new.  You can even make out the scatter of tombs which is so visible in Swiny's sketch map.

In this picture taken from Google Earth the blue dot is my position and the purple push pin is Dr. Andreou’s position.  She has placed Erimi-Kafkalla at 34.688086° N, 32.916886° E which is spot on and confirms my initial placement.

Her position for the Bronze Age Cypriot site at Erimi Laonin tou Porakou is less happy.  She has put it at 34.728969° N, 32.925616° E which is 1600 m. distant from the closest part of that site.

In the picture above we can see the situation.  Erimi-Laonin is positioned on a cliff to the left side (east) of the Kouris river.[7]  It is actually located on the same Kouris river and just to the north of Erimi-Kafkalla which was discussed above.  I have marked the position ( 34.711862° N, 32.923202° E) of Laonin as 'F2892'.  Her position would place it just to the east of the Kouris Dam which is not a helpful location for finding it.

Perhaps the biggest difference in Dr. Andreou's measurements is in respect to Maa Palaeokastro.  Let's look at the peninsula on which it sits.

In the 12 C BC the whole peninsula is thought to have been the site of a settlement.  The digs that have taken place there are best seen in the site that I've marked.  In the picture above we also see the hilariously named 'Museum of the Mycenaean Colonisation of Cyprus' which is shaped like an arrow in order to indicate the direction from which the first (Mycenaean) colonizers came.(!)[8]

Dr. Andreou's instincts have failed her just this once because she places the location of Maa at Paphos, as we see in the next photograph. Her location for Maa is 10+ km. from its real location which is at  34.853992° E, 32.363368° N.

Nevertheless, Dr. Andreou's points are still very valuable, particularly for the Kalavasos Valley on southern Cyprus which is an area that she seems to know best.  She has performed a very great service for anyone interested in prehistoric Cyprus.

~~~~~~~~~~~~~~~~

I'll be going on vacation to Hawaii until April 5, 2017.  I'll be silent until then.  Perhaps, for a change of pace, I'll put up some pictures of Hawaii.

Anyone who would like to have a copy of the MAP database can send an e-mail to bobconsoli 'at' gmail.com or leave a comment on any of my posts.  To run the MAP database requires a SQL server running on your desktop computer.   MySQL is such a server and it is powerful, industry-standard, and free.  

I can and will make .kml or .kmz files, which can be opened directly in Google Earth, available to those who would like them.  

I can also create .csv files for people who would like to import Mycenaean Atlas Project data into Google Earth but would like it in tabular form.

Those who do not have a SQL server but would like the full database in .pdf form can have that for the asking.

If you like these posts then please follow me on Twitter (Squinchpix) or on Google+   (Robert Consoli)

Facebook?  Sorry.I.just.can't.

Footnotes

[1] van Wijngaarden [2002], 323 ff.

[2] The authoritative discussion of this topic is in Knapp [2013], 451 ff.  For the role that Cyprus plays in the Greek historical imagination see Michael [2005] passim.  Specifically see her remarks on Maa Palaeokastro beginning on p. 127.

[3] Andreou [2014], Appendix 2, pp. 428-437

[4]  For once Wikipedia is good for something.  See their description of UTM here. 

[5] Swiny [1979b], fig. 72.

[6] Swiny [1979a] 251 ff.

[7] For a useful discussion of the Italian effort there see this.

[8] Discussed in Michael [2005], 127 ff.

Bibliography

Andreou [2014]:  Andreou, Georgia-Marina, Traversing Space: Landscape and Identity in Bronze Age Cyprus, Ph.D. dissertation submitted to School of History, Classics and Archaeology, The University of Edinburgh, 2014.  Online here.

Knapp [2013]:  Knapp, A. Bernard.  The Archaeology of Cyprus; From Earliest Prehistory throught the Bronze Age.  Cambridge University Press.  2013.  ISBN: 978-0521723473

Michael [2005]: Michael, Angela Stella.  Making Histories: Nationalism, Colonialism and the Uses of the Past on Cyprus.  Thesis submitted for Ph.D., University of Glasgow.  June 2005.  Online here. 

Swiny [1979a]:  Swiny, Stuart. Southern Cyprus, 2000-1500 B.C.; Vol  I, Text.  Ph.D. thesis.  Institute of Archaeology,  University of London. 1979.

Swiny [1979b]: Swiny, Stuart. Southern Cyprus, 2000-1500 B.C.; Vol II, Figures. Ph.D. thesis. Institute of Archaeology, University of London. 1979.

van Wijngaarden [2002]: van Wijngaarden, G.,  Use and Appreciation of Mycenaean Pottery in the Levant, Cyprus and Italy (ca. 1600 - 1200 BC).  Netherlands Organisation for Scientific Research and Amsterdam University Press. 2002.  Online (more or less) here.