# Bot Notebook Urban Gaz
Google Drive: https://drive.google.com/drive/folders/1fRCLgv0fbg3ZcPFS-tWzqilJR1SlWRRz

## Overview of Data

1. Dura-Europos-individual buildings.csv
* 57 rows
* some columns need to be further subdivided
* mix of new items and existing items
* will require sequence of runs (some statments reference items that will be created in a first bot run)
3. Dura-Europos-urbangazetteer-walls-and-towers.xlsx
* 30 rows
5. Synagoge rooms-urbangaz.csv
* 17 rows
* Additional guidance on references question
7. Temple_of_Bel-urban-gaz.csv
* 36 rows
* Additional guidance on references question
8. update3.24-Dura-organizational units-blocks-streets.xlsx
* 201 rows
* GEOJSON
* Aditional guidance on references question

## References as formatted by Pleiades
line 146 in:
https://github.com/isawnyu/pleiades_dura_converter/blob/main/scripts/convert.py
13 publications -> Kat add by hand?

### populate_buildings.py Dura-Europos Individual Buildings

1. I added 6 Qids in Column A for temples that already have WD items
2. I'm not yet sure how to handle Column H due to multiple values (also strip out words and parenthetical notes)
3. Column I did not have a Property id, I am suggesting P8733
4. Column J requires units
5. Column N makes use of items that will be created by this script- address in 2nd phase?
6. Column O makes use of items that will be created by this script- address in 2nd phase?
7. Column P makes use of items that will be created by this script- address in 2nd phase?
8. How to handle column Q?
9. Column T do these refer to geoshapes? I see polygon?
10. Column U we will need Qids for the directions
11. Column V we will need to add multiple statement qualifier pairs from this column, will need to strip out text
12. Column W has multiple values per cell, will need to strip out text
13. Column X- are any of these references already in Wikidata? Will these be used as references in any of the statements the bot will write?