Project

General

Profile

bug #9124

Altitude feature should have [m] as measurement unit by default

Added by Andreas Müller 5 months ago. Updated 2 months ago.

Status:
Resolved
Priority:
Highest
Category:
cdm
Target version:
Start date:
07/04/2020
Due date:
% Done:

50%

Severity:
normal
Found in Version:

Description

This requires that measurement units are loaded before.

Update script needed


Related issues

Related to Edit - feature request #9043: Add feature "Altitude" Closed 05/28/2020

Associated revisions

Revision 5b34cfd9 (diff)
Added by Andreas Müller 3 months ago

ref #9121 and ref #9124 add abbreviations to feature and add measurement unit to feature altitude

Revision d7bb67dd (diff)
Added by Andreas Müller 3 months ago

fix #9124 add meter to altitude (update script)

Revision cc651bea (diff)
Added by Andreas Müller 3 months ago

ref #9124 skip altitude adder if altitude feature does not yet exist

Revision 8878e1fa (diff)
Added by Andreas Müller 2 months ago

ref #9124 fix incorrect Altituded recommended measurement unit update script

Revision 724595b1 (diff)
Added by Andreas Müller 2 months ago

ref #9124 fix taxeditor test H2

Revision fef9465d (diff)
Added by Andreas Müller 2 months ago

ref #9124 fix altitude recommended measurement units issue in vaadin

History

#1 Updated by Andreas Müller 5 months ago

#2 Updated by Andreas Müller 3 months ago

  • Priority changed from New to Highest

#3 Updated by Andreas Müller 3 months ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 50

#4 Updated by Andreas Müller 2 months ago

The first implementatin of the update script had a serious bug as it filled the table DefinedTermBase_StatisticalMeasure instead of DefinedTermBase_MeasurementUnit.

This is fixed and an update script for the wrong update is committed. The result can be checked by:

SELECT MN.feature_id, MN.recommendedstatisticalmeasures_id
FROM DefinedTermBase_StatisticalMeasure MN 
INNER JOIN DefinedTermBase alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase sm ON sm.id = MN.recommendedstatisticalmeasures_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671'  AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6';

SELECT MN.REV, MN.feature_id, MN.recommendedstatisticalmeasures_id
FROM DefinedTermBase_StatisticalMeasure_AUD MN 
INNER JOIN DefinedTermBase_AUD alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase_AUD sm ON sm.id = MN.recommendedstatisticalmeasures_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671'  AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6';

SELECT MN.feature_id, MN.recommendedmeasurementunits_id
FROM DefinedTermBase_MeasurementUnit MN 
INNER JOIN DefinedTermBase alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase sm ON sm.id = MN.recommendedmeasurementunits_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671'  AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6';

SELECT MN.REV, MN.feature_id, MN.recommendedmeasurementunits_id
FROM DefinedTermBase_MeasurementUnit_AUD MN 
INNER JOIN DefinedTermBase_AUD alt ON alt.id = MN.feature_id
INNER JOIN DefinedTermBase_AUD sm ON sm.id = MN.recommendedmeasurementunits_id
WHERE alt.uuid = '1a28ed59-e15f-4001-b5c2-ea89f0012671'  AND sm.uuid = '8bef5055-789c-41e5-bea2-8dc2ea8ecdf6'

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)