get PostGIS working, added lat/long coords to `sc.langauges` and update wiki with instructions on using PostGIS locally

CordField / cordtables

Data sovereignty, transfer, and security solution for organizations in the Bible Translation movement.

MIT License

3 stars 1 forks source link

get PostGIS working, added lat/long coords to `sc.langauges` and update wiki with instructions on using PostGIS locally #122

Closed michaelmarshall closed 3 years ago

questionreality commented 3 years ago

resources: https://www.youtube.com/watch?v=hMn74o11wdk https://postgis.net/

questionreality commented 3 years ago

all we need is to store the data as geospatial data can later do visualizations

questionreality commented 3 years ago

https://stackoverflow.com/a/65293118/13888168 steps to install postgis on docker container. && apt-get install postgresql-12-postgis-3 -y \ -> this line needs to be && apt-get install postgresql-14-postgis-3 -y \ as we are using postgres v14

questionreality commented 3 years ago

[x] need to remove the query abstraction in order to return geography datatype in a human readable format
[x] dockerfile with commands to set up packages reqd (also pull postgres 13.3 - same version as aurora)
[x] need to figure out a way to conveniently update/create the value