View Issue Details

IDProjectCategoryView StatusLast Update
000892710000-008: Data AccessSpecpublic2023-06-06 15:39
ReporterMarkus Horstmann Assigned ToJim Luth  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Product Version1.05.01 
Summary0008927: UNECE to OPCUA mapping has duplicate and incorrect entries
Description

These units have the same description:

A49 4273209 den (g/9 km) denier
M83 5060659 den denier

Multiple units have the same display name:
77,14135,mil,milli-inch
MAM,5062989,Mm,megametre
MLT,5065812,ml,millilitre
MTZ,5067866,mHz,millihertz
RPM,5394509,r/min,revolutions per minute
2U,12885,Mg,megagram
STI,5461065,st,stone (UK)
B72,4339506,Mg/m³,megagram per cubic metre
B47,4338743,kN,kilonewton
C20,4403760,mN,millinewton
D83,4470835,mN·m,millinewton metre
MPA,5066817,MPa,megapascal
89,14393,P,poise
91,14641,St,stokes
C15,4403509,mJ,millijoule
C31,4404017,mW,milliwatt
N12,5124402,PS,Pferdestaerke
AMP,4279632,A,ampere
4K,13387,mA,milliampere
C70,4405040,pA,picoampere
D86,4470838,mC,millicoulomb
C71,4405041,pC,picocoulomb
D88,4470840,mC/m³,millicoulomb per cubic metre
D89,4470841,mC/m²,millicoulomb per square metre
C30,4404016,mV/m,millivolt per metre
2Z,12890,mV,millivolt
D33,4469555,T,tesla
P13,5255475,kT,kilotesla
81,14385,H,henry
E45,4535349,mΩ,milliohm
SIE,5458245,S,siemens
B53,4338995,kS,kilosiemens
C27,4403767,mS,millisiemens
B99,4340025,µS,microsiemens
N92,5126450,pS,picosiemens
C23,4403763,mΩ·m,milliohm metre
F54,4601140,mΩ/m,milliohm per metre
M35,5059381,mV·A,millivolt - ampere
KVR,4937298,kvar,kilovar
MAR,5062994,kvar,megavar
JM,19021,MJ/m³,megajoule per cubic metre
P40,5256240,Ly,langley
P30,5255984,Lb,lambert
P26,5255734,ph,phot
Q30,5321520,pH,pH (potential of Hydrogen)
A14,4272436,b,barn
C80,4405296,rad,rad
D6,17462,R/s,roentgen per second
2G,12871,V,volt AC
2H,12872,V,volt DC
E16,4534582,BtuIT/h,million Btu(IT) per hour
E44,4535348,kgf·m/cm²,kilogram-force metre per square centimetre
GRO,4674127,gr,gross
H77,4732727,MW,module width
HMQ,4738385,Mm³,million cubic metre
Q26,5321270,1/1,one per one
Q27,5321271,N·m/m²,newton metre per metre
WCD,5718852,cord,cord

This unit should be just called %:
P1 20529 % or pct percent

Steps To Reproduce

Open http://www.opcfoundation.org/UA/EngineeringUnits/UNECE/UNECE_to_OPCUA.csv in Excel.

Turn on filtering and select Remove Duplicates for the display name column: 1 duplicate.
Repeat for description column: 57 duplicates.

TagsNo tags attached.
Attached Files
image.png (2,055 bytes)   
image.png (2,055 bytes)   
image-2.png (3,160 bytes)   
image-2.png (3,160 bytes)   
image-3.png (2,516 bytes)   
image-3.png (2,516 bytes)   
image-4.png (2,660 bytes)   
image-4.png (2,660 bytes)   
Commit Version
Fix Due Date

Activities

Jim Luth

2023-06-06 15:39

administrator   ~0019471

The records claimed to be duplicate have differences in other fields making them unique in UNCE.

Issue History

Date Modified Username Field Change
2023-05-02 20:36 Markus Horstmann New Issue
2023-05-02 20:36 Markus Horstmann File Added: image.png
2023-05-02 20:36 Markus Horstmann File Added: image-2.png
2023-05-02 20:36 Markus Horstmann File Added: image-3.png
2023-05-02 20:36 Markus Horstmann File Added: image-4.png
2023-06-06 15:39 Jim Luth Assigned To => Jim Luth
2023-06-06 15:39 Jim Luth Status new => closed
2023-06-06 15:39 Jim Luth Resolution open => no change required
2023-06-06 15:39 Jim Luth Note Added: 0019471