Skip to content

A simple citizen-driven web mapping app for quick reporting of visible damage to a building after a storm or other disaster.

License

Notifications You must be signed in to change notification settings

respec/mf_connect

 
 

Repository files navigation

mapFeeder Connect

A simple user-driven web mapping application for the quick reporting of public generated feedback to an .sql database.

Instructions for adding new communities/instances:

  1. Add entry in the form.html #issue_city select options list that matches up with the URL param for the city= or map=<instance_or_city_name>

  2. Add entry in the config.json

  3. Copy database: CREATE DATABASE mfc_new_city_name WITH TEMPLATE mfc_ak_kodiak;

  4. Update the /etc/postgresql/9.3/main/pg_hba.conf for host and localhost to access the new db. And reload the conf with SELECT pg_reload_conf();

  5. Optional: for instances with several or changed URL param instance names, you can re-route users by adding entries in the .htaccess file

Instructions for exporting comments

  1. Open a connection to the database and populate the geom column with this command UPDATE workorder.mfc_data SET the_geom = ST_SetSRID(ST_MakePoint(lng, lat), 4326); This could be automated via trigger or explicitly in the serverside code

Via QGIS into geojson format

  1. open workorder.mfc_data table in QGIS
  2. Right click on the layer in the layer menu > click export > select format as .shp make sure the projection is set to the desired one

Via QGIS into .csv / .excel format (includes lat lng columns)

  1. Right click on the layer in the layer menu > click export > select format as .csv
  2. Under the geometry dropdown select no geom.
  3. Open the .csv in Excel
  4. Save As > .xlsx format

Database Backup

  1. Run this command on the server /usr/bin/pg_dump <name of database> -f <filename you want for the backup file>.backup -Fc -U postgres --no-owner

About

A simple citizen-driven web mapping app for quick reporting of visible damage to a building after a storm or other disaster.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 83.5%
  • JavaScript 8.0%
  • HTML 6.6%
  • CSS 1.9%