datarttu sujuikoDB issues

datarttu / sujuikoDB

Database backend for transit network & observation data.

MIT License

1 stars 1 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Feature: section result views

#120 datarttu closed 2 years ago
0
Add views for section reporting

#119 datarttu opened 2 years ago
0
Collect journeys into linestrings in a view

#118 datarttu closed 3 years ago
0
Fix exclusion constraint in `nw.route_version`

#117 datarttu closed 3 years ago
0
Set signed distance_from_link

#116 datarttu closed 3 years ago
0
Feat/fkey deps

#115 datarttu closed 3 years ago
0
Dynamically updated nodes

#114 datarttu closed 3 years ago
1
On `nw.link` delete, set possible `nw.stop` link refs to `NULL`

#113 datarttu closed 3 years ago
0
Maintain nodes and node references dynamically

#112 datarttu closed 3 years ago
0
Add fkey `obs.link_on_journey(jrnid)` -> `obs.journey(jrnid)`

#111 datarttu closed 3 years ago
0
Use negative `distance_from_link` if point is on the left side of the directed link

#110 datarttu closed 3 years ago
0
Add per-link stats from halt events to a view

#109 datarttu opened 3 years ago
0
Create `link_on_journey` model and interpolation algorithm

#108 datarttu closed 3 years ago
0
Add `COMMENT`s to db objects and columns

#107 datarttu closed 3 years ago
0
Define a common policy for conflicts in insertion procedures

#106 datarttu opened 3 years ago
0
Add view(s) for validations

#105 datarttu opened 3 years ago
0
Add rest of the network validations

#104 datarttu opened 3 years ago
0
Fix `route_version` validity time exclusion constraint

#103 datarttu closed 3 years ago
0
Overlapping stop coverage distances may result in duplicated `view_halt_on_journey_extended` entries

#102 datarttu opened 3 years ago
0
Minor improvements

#101 datarttu closed 3 years ago
0
Consider creating tsdb hypertables as a separate layer

#100 datarttu opened 3 years ago
0
Create db object documentation with `COMMENT ON`

#99 datarttu closed 3 years ago
0
Show numbers about journey data coverage

#98 datarttu opened 3 years ago
0
Add `halt_on_link` feature

#97 datarttu closed 3 years ago
0
Section improvements

#96 datarttu closed 3 years ago
0
Add support for basic link-based aggregate values

#95 datarttu closed 3 years ago
0
Create interpolated `link_on_journey` data from `point_on_link`

#94 datarttu closed 3 years ago
0
Consider `link_on_route` and HFP point orders in `obs.get_point_on_link_candidates()`

#93 datarttu opened 3 years ago
0
Add CI

#92 datarttu closed 3 years ago
0
Add a view and triggers for interactive modifications of sections

#91 datarttu closed 3 years ago
0
Suppress redundant updates with trigger

#90 datarttu opened 3 years ago
0
Single stop ref update

#89 datarttu closed 3 years ago
0
Add procedure to update stop-link reference of one stop

#88 datarttu closed 3 years ago
0
HFP observations model

#87 datarttu closed 3 years ago
1
`link_on_route` records are incorrectly ordered within route version

#86 datarttu closed 3 years ago
0
First parts missing from link_on_route via nodes and routes

#85 datarttu closed 3 years ago
0
Change smallint link_dir to boolean link_reversed

#84 datarttu closed 3 years ago
2
Add a license

#83 haphut closed 3 years ago
0
`nw.upsert_link_on_route` fails when adjacent via nodes are the same node

#82 datarttu closed 3 years ago
0
Replace enum arrays with a solution that works with QGIS

#81 datarttu opened 3 years ago
2
Start validation rules implementation

#80 datarttu closed 3 years ago
1
Sketch validation feature and usage in `db/README.md`

#79 datarttu closed 3 years ago
0
Create a generic validation labeling function

#78 datarttu closed 3 years ago
0
Start writing data validation rules and descriptions

#77 datarttu closed 3 years ago
0
Add fkeys `nw.link(i_node)` and `nw.link(j_node)` to `nw.node(node_id)`

#76 datarttu closed 3 years ago
0
Add ability to create `link_on_route` paths from stop and manual via nodes

#75 datarttu closed 3 years ago
1
Add routing feature to create `link_on_sth`-type records

#74 datarttu closed 3 years ago
1
Create a function that routes with `pgr_dijkstra` and via nodes using `nw.view_link_directed`, and returns set of `link_seq, link_id, link_dir`

#73 datarttu closed 3 years ago
0
Add a function for adding / updating an analysis section

#72 datarttu closed 3 years ago
0
Automatically find link references for stops

#71 datarttu closed 3 years ago
1