MIRCS Institute is a nonprofit devoted to the renewal of civil society. It is currently engaging a number of projects in public history, research, and education. The project is to have a publicly accessible web application - basically “Facebook for dead people”, which would serve as a prototype for future development of a robust, scalable, online platform. The developed project will allow a user to browse through the map, populated with historic data with the ability to click on the historic profiles to view more information as well as log in to add more information to the data.
#Dependencies ##System The system based dependencies needed to run the program are:
- PostgreSQL
- PostGIS
- Python
The Python libraries used in the program are:
- django
- pandas
- Jinja2
- sqlalchemy
- Aldjemy
- geoalchemy2
- psycopg2
- xlrd
#Starting the Server
- Navigate to mircsgeo/manage.py
- Run the command
python manage.py runserver 0.0.0.0:8000
#Current Functionality ##1. Upload a file (CSV or Excel)
- Click "Upload File"
- On the new page, click "Choose file"
- Select the Excel or CSV to upload
- Wait for the page to load a preview of the data
- Click "Add GeoSpatial Columns"
- Select the Longitude and Latitude columns
- Scroll to the bottom of the page
- Click "Submit"
##2. Append data to a dataset
- On the home page Click "Edit" for the dataset to which you want to append data
- Click on the "Append Data" button
- On the new page, click "Choose file"
- Select the Excel or CSV to upload
- Wait for the page to load a preview of the data
- Scroll to the bottom of the page
- Click "Submit"
##3. Pick a key
- On the home page Click "Edit" for the dataset to which you want to append data
- Click on the "Add Data Key For Join" button
-
- On the new page, select all columns for the key using the dropdown
- Click "Submit"
##4. Create a Join
- On the home page Click "Edit" for the dataset to which you want to append data
- Click on the "Join Data" button
- Select the joining dataset
- Select the mmain dataset key
- Select the joining dataset key
- Click "Submit"
##5. View the datatset
- On the home page Click "View" for the dataset to view a map and the table of data
#Database ##ERD ![Alt text] (https://github.com/alexetnunes/mircs-geogenealogy/blob/master/db-erd.png)