substation quest suggests to add reference as a name, creating osmose issues

[Jibec]

I applied this kind of substation quests:

but I notice it triggers a new issue:

what is this number? a reference?
if my understanding is correct, related source code is https://github.com/osm-fr/osmose-backend/blob/master/analysers/analyser_merge_power_substation_minor_FR.py#L64 is it correct?
If so, maybe simply check with fields["Nom poste"].isdigit() is False?

[frodrigo]

This data source compile other sources. Look like at some point a reference is put into the name field for Stransbourg. There is also alpha-num ref for Stransbourg.

[Jibec]

When I look at the data, I see:

2023-03-14 21:15:20,484 - In the source, there 27370 unique values
2023-03-14 21:15:20,514 - ..including 27370 strings
2023-03-14 21:15:20,515 - ...including 6121 digits

used code:

df_es = pd.read_csv(SOURCE, sep=";", usecols=[NOM_COL], low_memory=False)
df_es.fillna("", inplace=True)
s = df_es[NOM_COL]
s_strings = s[s.apply(lambda x: isinstance(x, str))]
s_digits = s[s.apply(lambda x: str.isdigit(x))]
s_non_digits = s[~s.apply(lambda x: str.isdigit(x))]

[frodrigo]

@flacombe what do you think of this ?

[flacombe]

Hello

Look like at some point a reference is put into the name field for Stransbourg.

I think you are right.
From the very beginning of this agregation, I recommended separating name and ref, like on OSM.
Currently, only names are part of the file so when you don't have name, you put ref instead and here the fun begins.

The analyzer could be modified by operator lookup: when Strasbourg Electricite Réseau, it's ref and name instead.
I could done it next week.

[frodrigo]

Done in #1981.

[Jibec]

Thank you team

[flacombe]

So quick!
Thank you

[frodrigo]

We just got it in 5 months.