Begin Red Squirrel database and data move

[Chris-Schnaufer]

Waiting for a reply from Vicky on beginning Red Squirrel database development and data movement

This task is to design and configure the database and plan for data movement

• [x] Design tables and rows
• [x] Create DB schema in database
• [ ] ~Determine what transfers from the old data, and where the old fields go in the new schema~

[Chris-Schnaufer]

• Working on scheduling a kick-off meeting for this work (email sent out)
• Generated preliminary Python code to transfer the data from ESRI to MySQL

[Chris-Schnaufer]

Able to get Public results off Survey123. Have question in to see if it's possible to do this without the results being Public.

https://community.esri.com/t5/python-questions/access-non-public-results-from-survey123-outside/m-p/1305982/thread-id/68094

[Chris-Schnaufer]

Using the ESRI generated JSON to create the database schema

[Chris-Schnaufer]

Able to load the data into the DB after it's been exported from AGOL

See the scripts a https://github.com/Chris-Schnaufer/agol2mysql