Setup Endpoints for Geospatial Data

[mzagaja]

Overview

In order to do geospatial data analysis we need the PostGIS extension setup for Postgres + the RGeo gem.

Action Items

• Setup PostGIS locally.
• Setup RGeo in the backend repo.
• Create a geospatial data column that matches what is available in the City of Boston dataset shapefile.
• Append geospatial data to the imported CSV data using a script.

Resources/Instructions

• Introduction to PostGIS by Paul Ramsay
• Introduction to PostGIS
• RGeo Gem

[mzagaja]

Dat explained they just need the latitude and longitude as imported from the Data team. It should be provided in two parts. First we need to add the lat/long to the homes. Secondarily we need to add a "start point" to the Assignment.

[mikelynch]

The assignment has a centroid location rather than “start point”. To get the start point, just find the lowest visit_order home with the appropriate assignment_id.