single quotes in groupname field

[yakra]

In the ConnectedRoute constructor:

DataProcessing/siteupdate/python-teresco/siteupdate.py

Line 881 in 5db8dfa

self.groupname = fields[3].replace("'","''")

This appears to be there to play nice with inserting the field into the SQL file. I presume ' is an escape character.

However, there are unintended side effects in highwaydatastats.log:
TunEnv (Tunel d''Envarlira): 2.55 mi (AND TunEnv only), rather than
TunEnv (Tunel d'Envarlira): 2.55 mi (AND TunEnv only)

Probably better to perform this replacement when groupname is written to the SQL file, rather than before.

[jteresco]

I'm OK with changing it to do so only when writing the SQL, but I'm also not bothered much by the extraneous ' in the log file.

[yakra]

Also, when calling the HighwaySystem constructor:

DataProcessing/siteupdate/python-teresco/siteupdate.py

Lines 2024 to 2025 in bc6eacd

	hs = HighwaySystem(fields[0], fields[1],
	fields[2].replace("'","''"),

From a housekeeping perspective it seems sensible to do this replacement when writing to the SQL file too.
This doesn't matter very much; I don't believe this field is used in any of the .log files.
But if we ever wanted to enhance the user list logs, say, from
System canon (active) overall: 4554.78 of 6285.55 mi (72.5%) to
System canon, Ontario King's Highways (active) overall: 4554.78 of 6285.55 mi (72.5%)
this would be something to watch out for.

Just making note of this; I don't consider it important enough to open a new issue or reopen this one.