search

McMasterAI / TrafficTracker

A street traffic counter that provides efficient and ethical modelling of how people engage and interact within a given public space.
MIT License
7 stars 2 forks source link

Create SQL structure #57

Closed cczarnuch closed 3 years ago

cczarnuch commented 3 years ago

Create these table using MSSQL syntax.

Heatmap table: auto-incrementing 🔑 Time Position (x, y, w, h) Class Object_id location_id

Old data: auto-incrementing 🔑 Time Position (x, y, w, h) Class Object_id location_id

Locations table: location_id 🔑 latitude longitude location_name