The database should hold population data in order to estimate the catchment area of a stop and of a route.
Initially this can be done with the UK Output Area population stats. But the data should be held in such a way that it would allow any population data to be loaded that would be usable. Suggest that simply holding polygons of population stats would allow for a geospatial query to be run that returned population for each stop.
Acceptance Criteria
- View to bring back population data against each stop
- View to bring back population data against each route (no double counting)
- View to bring back population data against each mobile
- View to bring back population data against each organisation
- UK Output area data loaded into the database
The database should hold population data in order to estimate the catchment area of a stop and of a route.
Initially this can be done with the UK Output Area population stats. But the data should be held in such a way that it would allow any population data to be loaded that would be usable. Suggest that simply holding polygons of population stats would allow for a geospatial query to be run that returned population for each stop.
Acceptance Criteria