EDH Geographic Database

An imaginary layout of the database

To illustrate the fields/tables within the database

EGDH_Nr.HD_Nr.(e.g.)EDH fo_antikPl. ancient loc.EDH fo_modernPl. modern loc.EDH fundstelle_1,_2,_3Pl. findspotEDH lat.EDH long.Geo_id for EDH coord.EDH basis
1HD033127Municipium Salviumplaces/197491GlamočVrba44.0122216.90003259928/vrba.htmlfundstelle_1
2HD056021Municipium Salviumplaces/197491GlamočVrba, frühchristliche Kirchefundstelle_2
3HD023324Salviaeplaces/197490GlamočHalapić44.073616.783063199427/halapic.htmlfundstelle_1
4HD056015Salviaeplaces/197490GlamočHalapić, Glavicefundstelle_2
5HD012593Salviaeplaces/197490GlamočHalapić, Glavice, frühchristliche Kirchefundstelle_3
6HD052288GlamočGlavica44.1105616.766113240394/glavica.htmlfundstelle_1
7HD033954Municipium Salvium, aus?GlamočPodgradina44.0230616.885563193017/podgradina.htmlfundstelle_1
8HD033935GlamočStaro Selo, bei43.971116.93753189928/staro-selo.htmlfundstelle_1
109HD050500Traguriumplaces/197555Trogir43.512516.251673188763/trogir.htmlfo_modern
3010HD058449Tragurium, beiPrgometLabin43.583316.250003196835/labin.htmlfundstelle_1
11HD053719Salonae - Servitium, interGlamoč, bei44.0458316.848613200651/glamoc.htmlfo_modern

Notes on the columns and lines

  • Each line contains a unique combination of geographic data. In the future database context this will be one record (for which we shall have a stable record_id, is what we imagine).
  • Column: EGDH_Nr. (e.g.)
    • NEW This number will operate as the reference number for relating the geographic database to the EDH itself. In the EDH there will be a new field which will contain the EGDH_Nr. The numbers here are only exempli gratia. NEW
  • Column: HD_Nr. (e.g.)
    • This field will be the place, in which all HD_numbers which contain the combination of geographic data in the line in question will be listed.
  • Columns: EDH lat. and EDH long.
    • EDH will (in the first instance) store only those coordinates which are used to identify the modern findspot of the inscription in question.
  • Column: Geo_id for EDH coord.
    • The geonames_id of the EDH modern findspot will be stored
  • Column: EDH basis
    • In this column EDH declares the granularity of the findspot. In other words what geographical data is specified by the coordinates. Values for this table will be a drop down authority list: fo_modern, fundstelle_1, fundstelle_2, fundstelle_3.
      • fo_modern: e.g. line 9
      • fundstelle_1: e.g. lines 1, 3, 6, 7, 8
      • fundstelle_2: e.g. lines 2 and 4
      • fundstelle_3: e.g. line 5
        • unfortunately we do not have the coordinates for the "frühchristliche Kirche" in the Glavice quarter of the town Halapić. However fundstelle_3 refers to the threefold breakdown of the data: town, quarter, specific findspot. This is as granular as the EDH fundstelle can be. At present if we had to specify coordinates we would have to go back to those for Halapić, as in line 3. We have left these columns empty in an attempt to illustrate an example of how differentiated EDH data might be.
        • NEW instead of using the expressions (fo_modern, fundstelle_1, fundstelle_2, fundstelle_3) we might think of using a sort of scale: percentages of accuracy, or simply a scale of numbers (would have to be dependent upon an authority list of possiblities) NEW
  • Columns: Pl. ancient loc, Pl. modern loc., Pl. findspot
    • In the first instance we shall enter whatever relevant placename_ids we can find from the Pleiades site.
  • the use of the extras "bei", "aus" and "?"
    • "bei" in line 8: fundstelle_1 indicates what the coordinates refer to. bei indicates that all we can do is say that the findspot is more approximate than the name of a village, settlement or whatever. We are saying that the environments of the village, settlement or whatever are as accurate as we can be. We imagine that Pleiades can use this information to add some sort of relevance scale.
    • "bei" in line 11: fo_modern indicates what the coordinates refer to. bei indicates that all we can do is say that the modern location is more approximate than the name of a town. We are saying that the environments of the town are as accurate as we can be. We imagine that Pleiades can use this information to add some sort of relevance scale.