Comments (4)
Looking at adding jam direction. Suggestions for other fields welcome.
from wazeccpprocessor.
Add ew_direction and ns_direction fields to the jams table.
SQL to update existing rows with direction data:
update waze.jams set
ew_direction =
case when (line -> 0 ->> 'x')::NUMERIC - (line -> jsonb_array_length(line)-1 ->> 'x')::numeric > 0 then
'W' else 'E' end
where uuid in (select uuid from waze.jams where
ew_direction is null limit 100);
update waze.jams set
ns_direction =
case when (line -> 0 ->> 'y')::NUMERIC - (line -> jsonb_array_length(line)-1 ->> 'y')::numeric > 0 then
'S' else 'N' end
where uuid in (select uuid from waze.jams where
ns_direction is null limit 100);
Remove where clause to update all of them, though this will take a long time.
from wazeccpprocessor.
Add a "dayofweek" field to Jams and Alerts.
See this commit: 8a47f61
Integer, 1-7. Corresponds to Monday - Sunday.
from wazeccpprocessor.
This is done in latest code.
from wazeccpprocessor.
Related Issues (20)
- Create PowerBI templates around good use cases and save files to repo HOT 1
- Create Tableau integration
- Optimize Data Store for performance HOT 3
- Work to reduce database costs HOT 8
- Optimize how files are stored or processed HOT 1
- Getting ready for Terraform release v2.0 HOT 8
- Create a read-only database user HOT 1
- Support Microsoft Azure within Terraform HOT 4
- Support Google Cloud within Terraform HOT 1
- Your Use Cases HOT 2
- Add type_id to the Alerts table HOT 5
- Create instructions on how to change settings to change an env-dev deployment to an env-prod HOT 1
- Useful SQL Query Collection HOT 2
- Create geometry fields with line/point data for GIS applications HOT 8
- Release Versioning - Upgrade docs and new install integration
- Replace link on Project page HOT 1
- Create an import script
- Add local timezone field HOT 1
- Upgrade Node Version for Lambdas HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from wazeccpprocessor.