Timeline for How to count number of attributes and then link back to road network - pgrouting
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 9, 2021 at 3:14 | history | tweeted | twitter.com/StackGIS/status/1435803683745411073 | ||
| Aug 13, 2021 at 17:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 14, 2021 at 9:11 | answer | added | geozelot | timeline score: 2 | |
| S Jul 6, 2021 at 14:46 | history | suggested | menes | CC BY-SA 4.0 |
minor improvements
|
| Jul 6, 2021 at 14:42 | review | Suggested edits | |||
| S Jul 6, 2021 at 14:46 | |||||
| Jul 6, 2021 at 14:16 | comment | added | Kathryn Adams | Yes, that is correct. | |
| Jul 6, 2021 at 13:39 | comment | added | geozelot | Oh wait, you just want the same behavior as with Excel here? Note that, if I'm not mistaken, both counts should always be equal. | |
| Jul 6, 2021 at 13:31 | comment | added | Kathryn Adams | Yes, so I am looking at traffic counts which is equivalent to count(edges)/ count(gid). These need to be joined back onto the road network in one query | |
| Jul 6, 2021 at 13:11 | comment | added | geozelot |
You can only ever meaningfully aggregate gids per name1 (into an array, or concatenated string), as you are effectively counting them into groups (per name1); is that the desired output?
|
|
| Jul 6, 2021 at 13:08 | history | edited | geozelot | CC BY-SA 4.0 |
added 37 characters in body; edited tags
|
| Jul 6, 2021 at 12:37 | history | edited | Kathryn Adams | CC BY-SA 4.0 |
added 300 characters in body
|
| Jul 6, 2021 at 10:50 | history | asked | Kathryn Adams | CC BY-SA 4.0 |