Organisation dataset

[sjib]

• Create sql script to add the necessary organisations for use with Morges / Nyon - see email from @jpdupuy

[sjib]

currently as sql script with the following INSERT Statement structure as there is no INTERLIS Import available

INSERT INTO tdh_od.organisation(
	obj_id, identifier, identifier_short, municipality_number, organisation_type, remark, status, uid, last_modification, fk_dataowner, fk_provider)
	VALUES ('ch20p3q4000000xy', 'Nyon', NULL, 5724, 8604, 'no official obj_id yet', 9047, NULL, now() ,NULL ,NULL );

@jpdupuy It would be nice if you could register "Morges" and "Nyon" as communities via the VSA Organisation application Form

In addition I suggest then to manually create an obj_id for these two organisations at the moment (or are there any more you need right away?):

• Morges Energies SA
• ThermorésÔ Nyon SA

What are the INTERLIS prefixes used in Morges and Nyon?

The SIA 405 Comission is launching a project to have all organisation beeing registered during this year (also from water, district heating, gaz etc.). Communities that are already registered with the VSA will not have to re-apply.

[jpdupuy]

@sjib

Commune de Morges is registered by the INTERLIS prefix is ch24ztmg for the district_heating product.
But it is not registered as Morges Energies SA
• ThermorésÔ Nyon SA did not register yet (I shall let them register)

I shall check with the Data Owner if Morges already registered in the VSA Organisation application form.

[sjib]

I shall check with the Data Owner if Morges already registered in the VSA Organisation application form.

They are not yet in the VSA Organisation Dataset see https://www.vsa.ch/models/?dir=organisation

[sjib]

@jpdupuy Here a preliminary version of the organisations for testing : 20250124create_tdh_organisations.zip

[sjib]

[jpdupuy]

@sjib I fixed your ids (it was a mix between Morges and Nyon)
INSERT INTO tdh_od.organisation(
obj_id, identifier, identifier_short, municipality_number, organisation_type, remark, status, uid, last_modification, fk_dataowner, fk_provider)
VALUES ('ch24ztmgOG000001', 'Morges Energies SA', NULL, NULL, 8606, 'no official obj_id yet', 9047, 'CHE407479717', now() ,NULL ,NULL );

INSERT INTO tdh_od.organisation(
obj_id, identifier, identifier_short, municipality_number, organisation_type, remark, status, uid, last_modification, fk_dataowner, fk_provider)
VALUES ('ch20p3q4000000xx', 'ThermorésÔ Nyon SA', NULL, NULL, 8606, 'no official obj_id yet', 9047, 'CHE465878702', now() ,NULL ,NULL );

INSERT INTO tdh_od.organisation(
obj_id, identifier, identifier_short, municipality_number, organisation_type, remark, status, uid, last_modification, fk_dataowner, fk_provider)
VALUES ('ch20p3q4000000xy', 'ThermorésÔ SA', NULL, NULL, 8606, 'no official obj_id yet', 9047, 'CHE383608577', now() ,NULL ,NULL );

INSERT INTO tdh_od.organisation(
obj_id, identifier, identifier_short, municipality_number, organisation_type, remark, status, uid, last_modification, fk_dataowner, fk_provider)
VALUES ('ch24ztmgOG000002', 'Morges', NULL, 5642, 8604, 'no official obj_id yet', 9047, NULL, now() ,NULL ,NULL );

INSERT INTO tdh_od.organisation(
obj_id, identifier, identifier_short, municipality_number, organisation_type, remark, status, uid, last_modification, fk_dataowner, fk_provider)
VALUES ('ch20p3q4000000xz', 'Nyon', NULL, 5724, 8604, 'no official obj_id yet', 9047, NULL, now() ,NULL ,NULL );

[sjib]

• Application pour VSA organisation Nyon / Morges @jpdupuy
• Définir obj_id 'ThermorésÔ Nyon SA * avec prefix du projet Nyon Chauffage à distance @jpdupuy

[jpdupuy]

@sjib Commune de Nyon OID = ch25eaht

[sjib]

20250308create_tdh_organisations.zip

[sjib]

• Integrate Morges / Nyon from VSA Organisations when available

[sjib]

• Integrate create script into repository @sjib

[jpdupuy]

Salut, la ville de Morges et de Nyon font bien membre de l'organisation VSA https://vsa.ch/fr/le-vsa/membres-vsa/

par contre le fichier xtf n'est pas à jour dans http://www.vsa.ch/models

car je ne les trouve pas