City-of-Bloomington / inRoads

Digital service to publish road, sidewalk and parking status information including closings, lane reductions and reservations. Generates feeds for Waze Connected Cities program.
https://bloomington.in.gov/inroads
GNU Affero General Public License v3.0
9 stars 4 forks source link

MySQL 8 spatial data types #204

Closed inghamn closed 4 years ago

inghamn commented 4 years ago

MySQL 8 removed the old spatial data types we are using for MySQL 5.7. We need to update the SQL to use the standard OpenGIS data types and SQL.

https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html