Hi François,
Firstly can other people on the list, particularly folk at SciGRID and
osmTGmod, please double-check we're not missing any important aspects?
This is incredibly important if it sets the standard for the open data
we use for power grids across the globe.
@François: You're right, we need to specify the segmentation more
explicitly.
T-junctions etc are also a problem for the tabular format.
I'd suggest to keep as much information as possible, so that people can
decide themselves how to handle it. How about a double-indexed format,
with the first index being circuit, and the second being segment?
For example just with the wires as an example for a T-junction:
| circuit_name | segment_name | from | to | wires |
|--------------+--------------+--------------+--------------+-------|
| circuit_23 | segment_1 | substation_4 | node_5 | 3 |
| circuit_23 | segment_2 | node_5 | node_6 | 2 |
| circuit_23 | segment_3 | node_6 | substation_6 | 2 |
| circuit_23 | segment_3 | node_6 | substation_7 | 3 |
By the way that relation is a good example of the challenges here:
https://www.openstreetmap.org/relation/5459752
The cables / wires / circuits attributes are jumbled along the line so
you get
| way | cables | wires | circuits |
|-----------+--------+--------+----------|
| 100500807 | 3 | double | |
| 100497456 | 6 | double | 2 |
| 479158213 | 6 | triple | 2 |
| 214450522 | 3 | triple | |
| 100494414 | 6 | triple | 2 |
| 100494422 | 3 | triple | |
I guess it's a double circuit, but some of the segments look like single
circuits.
François, many thanks for all your efforts on this! It's really very
much appreciated in our community.
Best wishes,
Tom
On 02/02/2019 18:57, François Lacombe wrote:
> Hi Tom,
>
> Thank you for your input.
> It's ok to produce a table, even a csv file with some wkt geometries
>
> My views under each attribute you propose below :
>
> Le sam. 2 févr. 2019 à 10:42, Tom Brown <
tom....@kit.edu
> <mailto:
tom....@kit.edu>> a écrit :
>
https://groups.google.com/d/msgid/openmod-initiative/CAG0ygLftsgDEcauQx4KxLNJ3HFBiR8eU4xnxywVtxhvfxsieTA%40mail.gmail.com
> <
https://groups.google.com/d/msgid/openmod-initiative/CAG0ygLftsgDEcauQx4KxLNJ3HFBiR8eU4xnxywVtxhvfxsieTA%40mail.gmail.com?utm_medium=email&utm_source=footer>.