search

skfarhad / hazard_reporting_system

BSD 3-Clause "New" or "Revised" License
15 stars 16 forks source link

DATA: Need to create geoJson of Admin boundaries for District and Upazila/Thana from external sources #38

Open skfarhad opened 2 months ago

skfarhad commented 2 months ago

We need to store geoJson of Admin boundaries for District and Upazila/Thana from external sources to make incident reporting process smoother. The map window should be focused on Thana/Upazila admin boundary before dropping location pin on Map for incident reporting. These admin boundary will also be used to highlight the map area with Incident/Volunteer status reports.

Here is a public source for geoJson files(need to validate): https://github.com/yasserius/bangladesh_geojson_shapefile Another one(need to validate): https://drmkc.jrc.ec.europa.eu/inform-index/INFORM-Subnational-Risk/Bangladesh

dg1223 commented 2 months ago

@skfarhad Can I work on this? I have experience with data storage/extraction/prep with Postgres. Looking at the links you provided, looks like there are some data visuallization aspect to it as well. I have some experience in these domains.

dg1223 commented 2 months ago

As discussed, I'll start working on this issue. Thanks

dg1223 commented 2 months ago

@skfarhad Do we already have a Postgres DB on the backend that I can populate with the dimension tables you requested? If not, are we planning to host the database somewhere first or do you want me to share the the DDL statements as an SQL or JSON file with the backend engineers so that they can populate the tables after hosting the database?

skfarhad commented 2 months ago

@skfarhad Do we already have a Postgres DB on the backend that I can populate with the dimension tables you requested? If not, are we planning to host the database somewhere first or do you want me to share the the DDL statements as an SQL or JSON file with the backend engineers so that they can populate the tables after hosting the database?

Test your codes in a local database. Then create a new brunch where you will commit. Make a folder called backend/geojson_data/ and put your code there. After you submit the PR, BE devs will review and share feedback.