bdit_data-sources
bdit_data-sources copied to clipboard
CityofToronto
Data sources used by the Big Data Innovation Team
Ideally, we should have tables with the following schemas: - `reader_locations`: this is a table of all locations at which Bliptrack readers have ever been installed - `reader_id`: unique ID...
After matching intersections to Bluetooth detector locations, should be using routing in the centreline network rather than drawing a straight line between the two points as outlined [here](https://github.com/CityofToronto/bdit_data-sources/blob/master/bluetooth/update/README.md#explanation-of-query). - [x]...
Create routes for the following analysis_id ``` select * from bluetooth.all_analyses where route_name like '%DT2%' ``` Steps: - get start and end geom for each analysis_id - create table with...
Road restrictions are available here: `ROAD_DBA.RR_XML_IN` in the Oracle database CARTEDBA (internal Oracle DB located at 703 DM). The timestamps are in some modified UNIX format, where you have to...
@webgisgeek found 4 routes that have data in `bluetooth.observations` but not (ish) in `bluetooth.aggr_5min`. ```sql SELECT device_class_set_name, analysis_id, minimum_point_completed, outcomes, report_id, report_name, route_id, route_name, route_points, pull_data FROM bluetooth.all_analyses WHERE analysis_id...
When a street name is duplicated or triplicated across the city due to amalgamation, there will be a two-character code in the `highway` field to specify which former municipality is...
Some streets have a median. Those can have a centreline for each direction, rather than a bi-directioal singular centreline. An unfortunate consequence of #268 is that we are only assigning...
The error `line_locate_point: 1st arg isn't a line` happens when the `whole_centreline` is not a single line, as shown in the figure below.  I'm thinking we can avoid this...
- [x] Look into failed bylaws and find out how many fail at which stage. - [x] Find out similarity of the failed bylaws. Is there sth that can be...
From [this comment](https://github.com/CityofToronto/bdit_data-sources/issues/271#issuecomment-605333393) on QC speed limit layer after implementing the updated mega function `jchew.text_to_centreline_updated`, I found cases where there's only one intersection (btwn1 = btwn2) but two offsets (metres_btwn1...
Metadata
Owner
Metadata
Data sources used by the Big Data Innovation Team