These files are an augmented digitization of Appendix 27 ("Colonisation and Hellenisation") from Hansen and Nielsen, An Inventory of Archaic and Classical Poleis. They contain both the Pleiades ID (PID) for each colony and metropolis, insofar as one exists, and the Polis Inventory number, again insofar as one exists (since not all the founders or colonies are poleis).

The initial digitization of the appendix into a spreadsheet was done with the aid of Gemini, and then corrected, cleaned, and prepped for data work by hand in Google Sheets; all subsequent work was done in Python without use of AI (the Jupyter notebook is available here, although it can't actually be run without the relevant source files). Locations were programmatically associated with their PIDs where possible, and then further matching, disambiguating, and correcting was done by hand. A caveat: there are likely still some incorrect identifications! Please feel free to submit corrections. The matching of Polis Inventory numbers (here labeled as HNID) was also done programmatically, drawing the IDs from a GeoJSON file provided by the IOS app of the Polis Inventory, in turn derived from the Stanford Polis Project.

• CSV or JSON of Appendix 27, with added data
Click here to show or hide data dictionary
• region: name of geographic region, from Hansen-Nielsen appendix
• colony_name: name of colony, from Hansen-Nielsen appendix
• colony_pid: the Pleiades ID for the colony
• hn_founder: name(s) of metropol(e)is, from Hansen-Nielsen appendix
• initial_foundation: a boolean (true/false) variable indicating whether or not Hansen-Nielsen mark this with 'Re.' or 'occ.' to indicate a re-foundation or occupation
• occupation: a boolean (true/false) variable indicating whether or not Hansen-Nielsen mark this with 'occ.' to indicate an occupation
• hn_foundation_date: approximate or exact date of foundation, from Hansen-Nielsen appendix
• hn_primary_secondary: primary or secondary colony, from Hansen-Nielsen appendix
• hn_polis_type: type of polis, from Hansen-Nielsen appendix (types α, β and γ indicate the degree of Hellenicity; see Hansen-Nielsen p.7)
• founder_pid: the Pleiades ID for the metropolis
• founder_name: the name of an individual metropolis, extracted from hn_founder
• certain: a boolean (true/false) variable indicating whether the association between metropolis and colony is certain (e.g., is there a question mark or an 'or' in Hansen-Nielsen)
• colony_hnid: the Polis Inv. number for the colony
• founder_hnid: the Polis Inv. number for the metropolis
Click here to show or hide corrections to Hansen-Nielsen
• row added: foundation of Sybaris at Traeis by exiled Sybarites (see Hansen-Nielsen pp.297–8)
• data added: Chersonesos in Pontic Skythia founded by colonists from Delion or Delos (see Hansen-Nielsen p.942)
• data corrected: Ainos in Thrace founded by colonists from Alopekonnesos (not Alopeke), Mytilene, and Aiolian Kyme
• File bundle for importing the colonies, metropoleis, and directed edges (connections from founder to colony) into QGIS (also derived as part of the workflow detailed above).
• Instructions (assuming that you have QGIS 3.44+ already installed):
1. Install the Notebook plugin for QGIS
2. Unzip the file
3. Open the Jupyter notebook (colonizing_expeditions.ipynb), using the Notebook plugin, in a new QGIS project
4. Adjust the file paths in the Jupyter notebook for the file locations on your computer: only change source_path and save_path in the first notebook cell (the source path should be the location of your unzipped files; the save path should be where you want the resulting Geopackage file to be saved, which can be the same as or different from the source path)
5. Run the full notebook
• Each place is represented by at least one point, polygon, or linestring; if multiple instances of a given geometry exist in Pleiades, only one was retained, but a place may exist as more than one geometry type
• The zip file contains a CSV for crosswalking PIDs to HNIDs, in case you want to join the locations to additional data that makes use of the polis inventory number
• N.B. The linestrings created between metropoleis and colonies are straight lines, rather than geodesic curves, but they can be densified if desired