Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Without having actual data, I'd guess you could use a windows function (+ interesting blog post on the topic). Something like select row_number() over (partition by ST_LineMerge(ST_Collect(way))) as overlap_count could work.
Without having actual data, I'd guess you could use a window function (+ interesting blog post on the topic). Something like select row_number() over (partition by ST_LineMerge(ST_Collect(way))) as overlap_count could work.
Without having actual data, I'd guess you could use a windows function (+ interesting blog post on the topic). Something like select row_number() over (partition by ST_LineMerge(ST_Collect(way))) as overlap_count could work.