Locations

locations

This table stores detailed information about the geographical locations associated with the origin of materials, including fields for specifying coordinates and site or location names. The link between the locations and materials tables is established using the fields location_name, latitude, longitude, and coordinates_type. The locations table only includes entries with a defined name. If only latitude and longitude coordinates are available without an associated name, these coordinates are stored directly in the materials table.

Location name

location_name

Name of the location, typically an archaeological site, where the source was collected. Example: Catacombs of Marcellinus and Peter

Type	Required	Table
string	yes	locations, materials

Latitude

latitude

Latitude, an angular measurement in degrees north or south from the equator, serves as the geographic coordinate for the location where the material was collected. There are no constraints on the number of digits following the decimal point. Example: 7.316667

Type	Required	Unit/Norm	Table
decimal	yes	WGS84	locations, materials

Longitude

longitude

Longitude, an angular measurement in degrees east or west from the prime meridian, acts as a coordinate for pinpointing the location where the material was collected. There are no constraints on the number of digits following the decimal point. Example: 13.5833333

Type	Required	Unit/Norm	Table
decimal	yes	WGS84	locations, materials

Coordinates type

coordinates_type

Coordinates type indicates the precision of the geographic location where the material was collected, whether exact or approximate.

Type	Required	Validations	Table
string	yes	Lowercase: yes	locations, materials

Allowed Values:

• exact
• approximate

Alternative location name

alternative_location_name

Alternate name for the location where the source was collected. This may include a different known name for the toponym, spelling variations, or the original name in a non-Latin alphabet. Example: تل موزان

Type	Required	Table
string	no	locations