CityofToronto / bdit_flashcrow

Working repository for MOVE, a project to modernize transportation data systems at the City of Toronto.
MIT License
9 stars 2 forks source link

MOVE-209: Use ST_AsMVT directly in DynamicTileDAO #1279

Closed imadsyed333 closed 4 months ago

imadsyed333 commented 4 months ago

Issue Addressed

This PR closes MOVE-209.

Description

Edited queries in DynamicTileDAO.js to take advantage of the ST_AsMVT function in Postgis. This allows the database to serve vector tiles to the app, easing the load on the backend.

Tests

Tested in MOVE local v1.13 using Firefox

spencermountain commented 4 months ago

this is awesome, and is well-above my expertise and my ability to review. Gonna pass this one on!