This web app takes a list of barangay, municipality, city, and province names and looks up their closest matches in the Philippine Standard Geographic Code (PSGC). It's useful if you're trying to standardize location names for merging location datasets from diverse sources.
How it works
- Upload a single CSV file that contains separate barangay, province, and city or municipality columns.
- Identify the columns that correspond to the correct administrative levels in the PSG code.
- For places with exact matches in the PSGC, LinkSight returns the precise PSG code. For places with more than one possible matching PSG code, use the app's graphical user interface to select the correct match.
- Export the results as a CSV.
This app is in active development! Your feedback will help us improve it. If you have any suggestions for features, enhancements, or find any bugs, or just want to contribute, please send us an email at email@example.com.
npm install -g pm2
Set configuration values
Config name Description APPROVED_EMAILS_ROW_KEY The row key for approved emails APPROVED_EMAILS_SHEET_ID Google Sheets ID of th list of approved emails APPROVED_EMAILS_SHEET_RANGE The sheet range for approved emails DATABASE_URL See DJ-Database-URL DEBUG Toggles running the server in debug mode EMAIL_HOST_PASSWORD Password for above EMAIL_HOST_USER User for sending email EMAIL_PORT Port to use when sending email FLOWER_OAUTH2_REDIRECT_URI Redirect url for Flower auth GOOGLE_APPLICATION_CREDENTIALS Path to the Google Cloud Service Account key file used to retrieve the list of approved emails GOOGLE_OAUTH2_KEY Key for Google OAuth2 GOOGLE_OAUTH2_SECRET Secret for Google OAuth2 SECRET_KEY String used to provide cryptographic signing of sessions, etc.
If you are a member of the official LinkSight development team, you can ask for access to the template with secrets filled in.
Install postgresql and run the following:
Make sure that you can connect using the
DATABASE_URLyou used in
venv/bin/python manage.py migrate
Go to http://localhost:3000/
venv/bin/python manage.py test
You can run specific subsets of tests like so.
NOTE: Commands below must be executed within the
Create instances with terraform:
Note the IP shown in the output.
Configure instances from the inventory file:
cd deploy && ENV=staging HOST=linksight-stg.thinkingmachin.es make deploy
cd deploy && ENV=production HOST=linksight.thinkingmachin.es make deploy
The PSGC reference file is maintained in a separate repo and has been added to this repo as a git subtree. To pull latest changes, run:
git subtree pull --prefix data/psgc \ https://github.com/thinkingmachines/psgc.git \ master --squash