...
- Note that the TextEntry blob is being concatenated with the existing Description and placed in dimensionNote. (There are a few cases where this note contains
a dimension at variance with the other dimension data - The value for measuredPart is being set on the basis of the Description field, with the exception of cases where this field begins with "wi". This heuristic allows values beginning with "with" or "width" to stay (appropriately) as description (there are about 300 cases) while the rest of the values become (also mostly correctly) part descriptions. Yes, it is a bit of a hack.
- The units and dimension values are converted to lowercase, as seems to be the CSpace convention.
- I can't for the life of me get the dimensionNote to not be (null).
...
A few example rows
dimensionID | Objectid | measuredPart | dimension | valueQualifier | value | measurementUnit | dimensionNote | dimensionSummary |
|---|---|---|---|---|---|---|---|---|
3 | 11403 |
| height |
| 4.0000000000000 | inches | (null) | 4 x 5 in |
4 | 11403 |
| width |
| 5.0000000000000 | inches | (null) | 4 x 5 in |
5 | 11404 |
| height |
| 4.0000000000000 | inches | Measured numbers: 204, 206 | 4 x 5 in |
256 | 81692 |
| height |
| 78.0000000000000 | inches | Measured numbers: 204, 206 | 78 in |
257 | 81693 |
| height |
| 37.0000000000000 | inches | (null) | 37 in |
258 | 81694 |
| height |
| 333.0000000000000 | centimeters | (null) | 333 cm |
5842 | 449454 |
| recording speed |
| 110.0000000000000 | recording speed | (null) | 110 speed, 204 secs |
5843 | 449454 |
| duration |
| 204.0000000000000 | seconds | (null) | 110 speed, 204 secs |
5844 | 449455 |
| recording speed |
| 110.0000000000000 | recording speed | (null) | 110 speed, 199 secs |
21734 | 38533 |
| height |
| 3.6000000000000 | centimeters | (null) | 3.6 cm (1 7/16 in) |
21737 | 486208 | c | height |
| 18.2000000000000 | centimeters | (null) | 18.2 x 1.2 cm (7 3/16 x 1/2 in) |
21740 | 486208 | c | diameter |
| 1.2000000000000 | centimeters | (null) | 18.2 x 1.2 cm (7 3/16 x 1/2 in) |
21741 | 486208 | b | height |
| 16.8000000000000 | centimeters | (null) | 16.8 x 1.2 cm (6 5/8 x 1/2 in) |
21744 | 486208 | b | diameter |
| 1.2000000000000 | centimeters | (null) | 16.8 x 1.2 cm (6 5/8 x 1/2 in) |
21745 | 486208 | a | height |
| 10.1000000000000 | centimeters | (null) | 10.1 x 1.2 cm (4 x 1/2 in) |
21748 | 486208 | a | diameter |
| 1.2000000000000 | centimeters | (null) | 10.1 x 1.2 cm (4 x 1/2 in) |
21749 | 38534 |
| height |
| 3.3000000000000 | centimeters | (null) | 3.3 cm (1 5/16 in) |