CercaTrova

Design Lab project

CercaTrova, meaning Seek and ye Shall Find, was developed as part of our Designn Lab coursework and is a real-time Emergency Redressal System with Android Apps as frontend and a Django PostgreSQL powered backend.

Important Links

Setup Instructions

Please follow the following Setup Instructions carefully to create the main Server

Download and install PostgreSQL EnterpriseDB v9.6.2 (.exe for Windows/ .run for Linux)

$ cd <folder_location>/
$ chmod 755 <file_name>.run
$ sudo ./<file_name>.run

Install PostGIS v2.3.2 using stackbuilder bundled with above installer.Select spatial extension and run the rest of the wizard.
(Windows Only) Download and install OSgeo4W.
(Linux Only) Install GDAL

sudo apt-get install libgdal-dev

Start psql command prompt. Create a new database named cerca_trova and a new user named admin with password 'admin' and grant all rights to database cerca_trova.

create user admin with password ‘admin’;
create database cerca_trova;
grant all privileges on database cerca_trova to admin;

Login to new database with new user credentials and enable PostGIS extension. Be careful not to enable PostGIS in postgres database. Some of the extensions might fail dont worry.

-- Enable PostGIS (includes raster)
CREATE EXTENSION postgis;
-- Enable Topology
CREATE EXTENSION postgis_topology;
-- Enable PostGIS Advanced 3D
-- and other geoprocessing algorithms
CREATE EXTENSION postgis_sfcgal;
-- fuzzy matching needed for Tiger
CREATE EXTENSION fuzzystrmatch;
-- rule based standardizer
CREATE EXTENSION address_standardizer;
-- example rule data set
CREATE EXTENSION address_standardizer_data_us;
-- Enable US Tiger Geocoder
CREATE EXTENSION postgis_tiger_geocoder;
-- routing functionality
CREATE EXTENSION pgrouting;
-- spatial foreign data wrappers
CREATE EXTENSION ogr_fdw;

-- LIDAR support
CREATE EXTENSION pointcloud;
-- LIDAR Point cloud patches to geometry type cases
CREATE EXTENSION pointcloud_postgis;

Install virtualenv

$ pip install virtualenv

create project folder

$ cd <location>
$ mkdir <folder_name>

cd to folder and create and enable python virtualenv

$ virtualenv <folder_name> 
$ source /bin/activate

Pull the project repository from remote server

$ git pull https://github.com/NilanjanDaw/CercaTrova-Server.git

Install dependencies

$ pip install -r requirements.txt

cd to cerca_trova folder within repository. Add host URL to allowed in "settings.py"

ALLOWED_HOSTS = [
  ...,
  <HOST_URL>,
]

cd to repository root folder. Migrate databases and start Server

$ python manage.py migrate
$ python manage.py runserver 0.0.0.0:8000