Tony CHEMIT pushed to branch develop-9.0.x at ultreiaio / ird-observe
Commits:
-
b7a5669d
by Tony Chemit at 2022-12-05T22:07:57+01:00
2 changed files:
Changes:
| ... | ... | @@ -16,43 +16,43 @@ La table est déversée dans plusieurs tables : |
| 16 | 16 | * **FloatingObject**
|
| 17 | 17 | * **TransmittingBuoy**
|
| 18 | 18 | |
| 19 | -|n° | nom | destination |note |
|
|
| 20 | -|:--- | :--- | :--- |:--- |
|
|
| 21 | -| ACTIVITE_01 | C_BAT | Route.topiaId | |
|
|
| 22 | -| ACTIVITE_02 | D_DBQ | Route.topiaId | |
|
|
| 23 | -| ACTIVITE_03 | D_ACT | Route.date | |
|
|
| 24 | -| ACTIVITE_04 | N_ACT | Activity.number | |
|
|
| 25 | -| ACTIVITE_05 | H_ACT | Activity.time | [1](#n_0_1) |
|
|
| 26 | -| ACTIVITE_06 | M_ACT | Activity.time | [1](#n_0_1) |
|
|
| 27 | -| ACTIVITE_07 | C_OCEA | Not used | |
|
|
| 28 | -| ACTIVITE_08 | Q_ACT | Signe de latitude et longitude | [2](#n_0_2) |
|
|
| 29 | -| ACTIVITE_09 | V_LAT | Activity.latitude | [2](#n_0_2) |
|
|
| 30 | -| ACTIVITE_10 | V_LON | Activity.longitude | [2](#n_0_2) |
|
|
| 31 | -| ACTIVITE_11 | V_TMER | Route.timeAtSea | [3](#n_0_3) |
|
|
| 32 | -| ACTIVITE_12 | V_TPEC | Route.fishingTime | [3](#n_0_3) |
|
|
| 33 | -| ACTIVITE_13 | C_OPERA | Activity.vesselActivity | [4](#n_0_4) |
|
|
| 34 | -| ACTIVITE_14 | V_NB_OP | Activity.setCount | |
|
|
| 35 | -| ACTIVITE_15 | C_TBANC | Activity.schoolType | [5](#n_0_5) |
|
|
| 36 | -| ACTIVITE_16 | F_DON_ORG | Activity.originalDataModified | [6](#n_0_6) |
|
|
| 37 | -| ACTIVITE_17 | F_POS_COR | Activity.positionCorrected | [7](#n_0_7) |
|
|
| 38 | -| ACTIVITE_18 | F_POS_VMS_D | Activity.vmsDivergent | [8](#n_0_8) |
|
|
| 39 | -| ACTIVITE_19 | F_CUVE_C | Not used | |
|
|
| 40 | -| ACTIVITE_20 | F_OBS | Not used | |
|
|
| 41 | -| ACTIVITE_21 | F_EXPERT | Not used | |
|
|
| 42 | -| ACTIVITE_22 | V_POIDS_CAP | Activity.totalWeight | |
|
|
| 43 | -| ACTIVITE_23 | V_TEMP_S | Activity.seaSurfaceTemperature | |
|
|
| 44 | -| ACTIVITE_24 | V_COUR_DIR | Activity.currentDirection | |
|
|
| 45 | -| ACTIVITE_25 | V_COUR_VIT | Activity.currentSpeed | |
|
|
| 46 | -| ACTIVITE_26 | V_VENT_DIR | Activity.windDirection | |
|
|
| 47 | -| ACTIVITE_27 | V_VENT_VIT | Activity.wind | [9](#n_0_9) |
|
|
| 48 | -| ACTIVITE_28 | C_TYP_OBJET | | [10](#n_0_10)|
|
|
| 49 | -| ACTIVITE_29 | F_DCP_ECO | ??? | |
|
|
| 50 | -| ACTIVITE_30 | F_PROP_BALISE | ??? | |
|
|
| 51 | -| ACTIVITE_31 | C_TYP_BALISE | | [10](#n_0_10)|
|
|
| 52 | -| ACTIVITE_32 | V_ID_BALISE | TransmittingBuoy.code | |
|
|
| 53 | -| ACTIVITE_33 | V_POIDS_ESTIM_DCP | FloatingObject.comment | [11](#n_0_11)|
|
|
| 54 | -| ACTIVITE_34 | L_COM_A | Activity.comment | |
|
|
| 55 | -| ACTIVITE_35 | C_Z_FPA | Activity.fpaZone | [12](#n_0_12)|
|
|
| 19 | +| n° | nom | destination | note |
|
|
| 20 | +|:------------|:------------------|:-------------------------------------------|:--------------|
|
|
| 21 | +| ACTIVITE_01 | C_BAT | Route.topiaId | |
|
|
| 22 | +| ACTIVITE_02 | D_DBQ | Route.topiaId | |
|
|
| 23 | +| ACTIVITE_03 | D_ACT | Route.date | |
|
|
| 24 | +| ACTIVITE_04 | N_ACT | Activity.number | |
|
|
| 25 | +| ACTIVITE_05 | H_ACT | Activity.time | [1](#n_0_1) |
|
|
| 26 | +| ACTIVITE_06 | M_ACT | Activity.time | [1](#n_0_1) |
|
|
| 27 | +| ACTIVITE_07 | C_OCEA | Not used | |
|
|
| 28 | +| ACTIVITE_08 | Q_ACT | Signe de latitude et longitude | [2](#n_0_2) |
|
|
| 29 | +| ACTIVITE_09 | V_LAT | Activity.latitude | [2](#n_0_2) |
|
|
| 30 | +| ACTIVITE_10 | V_LON | Activity.longitude | [2](#n_0_2) |
|
|
| 31 | +| ACTIVITE_11 | V_TMER | Route.timeAtSea | [3](#n_0_3) |
|
|
| 32 | +| ACTIVITE_12 | V_TPEC | Route.fishingTime | [3](#n_0_3) |
|
|
| 33 | +| ACTIVITE_13 | C_OPERA | Activity.vesselActivity | [4](#n_0_4) |
|
|
| 34 | +| ACTIVITE_14 | V_NB_OP | Activity.setCount | |
|
|
| 35 | +| ACTIVITE_15 | C_TBANC | Activity.schoolType | [5](#n_0_5) |
|
|
| 36 | +| ACTIVITE_16 | F_DON_ORG | Activity.originalDataModified | [6](#n_0_6) |
|
|
| 37 | +| ACTIVITE_17 | F_POS_COR | Activity.positionCorrected | [7](#n_0_7) |
|
|
| 38 | +| ACTIVITE_18 | F_POS_VMS_D | Activity.vmsDivergent | [8](#n_0_8) |
|
|
| 39 | +| ACTIVITE_19 | F_CUVE_C | Not used | |
|
|
| 40 | +| ACTIVITE_20 | F_OBS | Not used | |
|
|
| 41 | +| ACTIVITE_21 | F_EXPERT | Not used | |
|
|
| 42 | +| ACTIVITE_22 | V_POIDS_CAP | Activity.totalWeight | |
|
|
| 43 | +| ACTIVITE_23 | V_TEMP_S | Activity.seaSurfaceTemperature | |
|
|
| 44 | +| ACTIVITE_24 | V_COUR_DIR | Activity.currentDirection | |
|
|
| 45 | +| ACTIVITE_25 | V_COUR_VIT | Activity.currentSpeed | |
|
|
| 46 | +| ACTIVITE_26 | V_VENT_DIR | Activity.windDirection | |
|
|
| 47 | +| ACTIVITE_27 | V_VENT_VIT | Activity.wind | [9](#n_0_9) |
|
|
| 48 | +| ACTIVITE_28 | C_TYP_OBJET | | [10](#n_0_10) |
|
|
| 49 | +| ACTIVITE_29 | F_DCP_ECO | ??? | |
|
|
| 50 | +| ACTIVITE_30 | F_PROP_BALISE | TransmittingBuoy.transmittingBuoyOwnerShip | [10](#n_0_10) |
|
|
| 51 | +| ACTIVITE_31 | C_TYP_BALISE | | [10](#n_0_10) |
|
|
| 52 | +| ACTIVITE_32 | V_ID_BALISE | TransmittingBuoy.code | |
|
|
| 53 | +| ACTIVITE_33 | V_POIDS_ESTIM_DCP | FloatingObject.comment | [11](#n_0_11) |
|
|
| 54 | +| ACTIVITE_34 | L_COM_A | Activity.comment | |
|
|
| 55 | +| ACTIVITE_35 | C_Z_FPA | Activity.fpaZone | [12](#n_0_12) |
|
|
| 56 | 56 | |
| 57 | 57 | |
| 58 | 58 | * Note 1
|
| ... | ... | @@ -111,21 +111,23 @@ On ajoute un DCP uniquement pour une activité avec **vesselActivity.code == 13* |
| 111 | 111 | |
| 112 | 112 | Provient d'une translation de **ACTIVITE.C_OPERA** vers **ps_common.ObjectOperation.code**
|
| 113 | 113 | |
| 114 | -| ACTIVITE.C_OPERA | ps_common.ObjectOperation.code |
|
|
| 115 | -| :--- | :--- |
|
|
| 116 | -|5 | 1 |
|
|
| 117 | -|6 | 4 |
|
|
| 118 | -|22 | 4 |
|
|
| 119 | -|23 | 1 |
|
|
| 120 | -|24 | 4 |
|
|
| 121 | -|25 | 2 |
|
|
| 122 | -|26 | 2 |
|
|
| 123 | -|29 | 2 |
|
|
| 124 | -|30 | 2 |
|
|
| 125 | -|31 | 8 |
|
|
| 126 | -|32 | 8 |
|
|
| 127 | -|33 | 11 |
|
|
| 128 | -|34 | 4 |
|
|
| 114 | +| ACTIVITE.C_OPERA | ps_common.ObjectOperation.code |
|
|
| 115 | +|:-----------------|:-------------------------------|
|
|
| 116 | +| 5 | 1 |
|
|
| 117 | +| 6 | 4 |
|
|
| 118 | +| 22 | 4 |
|
|
| 119 | +| 23 | 1 |
|
|
| 120 | +| 24 | 4 |
|
|
| 121 | +| 25 | 2 |
|
|
| 122 | +| 26 | 2 |
|
|
| 123 | +| 29 | 2 |
|
|
| 124 | +| 30 | 2 |
|
|
| 125 | +| 31 | 8 |
|
|
| 126 | +| 32 | 8 |
|
|
| 127 | +| 33 | 11 |
|
|
| 128 | +| 34 | 4 |
|
|
| 129 | +| 40 | 11 |
|
|
| 130 | +| 41 | 11 |
|
|
| 129 | 131 | |
| 130 | 132 | * ```FloatingObject.floatingObjectPart```
|
| 131 | 133 | |
| ... | ... | @@ -133,21 +135,23 @@ Pour calculer les matériaux du DCP, on doit d'abord définir les deux valeurs |
| 133 | 135 | * ```whenArriving```
|
| 134 | 136 | * ```whenLeaving```
|
| 135 | 137 | |
| 136 | -| ACTIVITE.C_OPERA | whenArriving | whenLeaving |
|
|
| 137 | -| :--- | :--- | :--- |
|
|
| 138 | -|5 | | TRUE |
|
|
| 139 | -|6 | TRUE | |
|
|
| 140 | -|22 | TRUE | |
|
|
| 141 | -|23 | | TRUE |
|
|
| 142 | -|24 | TRUE | |
|
|
| 143 | -|25 | TRUE | |
|
|
| 144 | -|26 | TRUE | |
|
|
| 145 | -|29 | TRUE | |
|
|
| 146 | -|30 | TRUE | |
|
|
| 147 | -|31 | TRUE | TRUE |
|
|
| 148 | -|32 | TRUE | TRUE |
|
|
| 149 | -|33 | TRUE | |
|
|
| 150 | -|34 | TRUE | |
|
|
| 138 | +| ACTIVITE.C_OPERA | whenArriving | whenLeaving |
|
|
| 139 | +|:-----------------|:-------------|:------------|
|
|
| 140 | +| 5 | | TRUE |
|
|
| 141 | +| 6 | TRUE | |
|
|
| 142 | +| 22 | TRUE | |
|
|
| 143 | +| 23 | | TRUE |
|
|
| 144 | +| 24 | TRUE | |
|
|
| 145 | +| 25 | TRUE | |
|
|
| 146 | +| 26 | TRUE | |
|
|
| 147 | +| 29 | TRUE | |
|
|
| 148 | +| 30 | TRUE | |
|
|
| 149 | +| 31 | TRUE | TRUE |
|
|
| 150 | +| 32 | TRUE | TRUE |
|
|
| 151 | +| 33 | TRUE | |
|
|
| 152 | +| 34 | TRUE | |
|
|
| 153 | +| 40 | TRUE | |
|
|
| 154 | +| 41 | TRUE | |
|
|
| 151 | 155 | |
| 152 | 156 | * Calcul des matériaux à utiliser
|
| 153 | 157 | |
| ... | ... | @@ -207,12 +211,12 @@ if ("999".equals(typeObjectCode)) { |
| 207 | 211 | |
| 208 | 212 | Pour le **simple mapping** on utilise la translation :
|
| 209 | 213 | |
| 210 | -| ACTIVITE.C_TYP_OBJET | ps_common.ObjectMaterial.code | note |
|
|
| 211 | -| :--- | :--- | :---|
|
|
| 212 | -|1 | fr.ird.referential.ps.common.ObjectMaterial#0#0.46 | 1-2 AFAD |
|
|
| 213 | -|2 | fr.ird.referential.ps.common.ObjectMaterial#0#0.2 | 1-1 DFAD |
|
|
| 214 | -|3 | fr.ird.referential.ps.common.ObjectMaterial#0#0.50 | 2 LOG |
|
|
| 215 | -|9 | fr.ird.referential.ps.common.ObjectMaterial#0#1.3 | FOB |
|
|
| 214 | +| ACTIVITE.C_TYP_OBJET | ps_common.ObjectMaterial.code | note |
|
|
| 215 | +|:---------------------|:---------------------------------------------------|:---------|
|
|
| 216 | +| 1 | fr.ird.referential.ps.common.ObjectMaterial#0#0.46 | 1-2 AFAD |
|
|
| 217 | +| 2 | fr.ird.referential.ps.common.ObjectMaterial#0#0.2 | 1-1 DFAD |
|
|
| 218 | +| 3 | fr.ird.referential.ps.common.ObjectMaterial#0#0.50 | 2 LOG |
|
|
| 219 | +| 9 | fr.ird.referential.ps.common.ObjectMaterial#0#1.3 | FOB |
|
|
| 216 | 220 | |
| 217 | 221 | |
| 218 | 222 | * ```FloatingObject.transmittingBuoy```
|
| ... | ... | @@ -221,23 +225,29 @@ Soit ```baliseId``` (**ACTIVITE.V_ID_BALISE**) (à placer dans **TransmittingBuo |
| 221 | 225 | |
| 222 | 226 | Soit ```transmittingBuoyOperation``` (translation de **ACTIVITE.C_OPERA**)
|
| 223 | 227 | |
| 224 | -| ACTIVITE.C_OPERA | ps_common.TransmittingBuoyOperation.code |
|
|
| 225 | -| :--- | :--- |
|
|
| 226 | -5 | 3 |
|
|
| 227 | -6 | 2 |
|
|
| 228 | -23 | 3 |
|
|
| 229 | -24 | 2 |
|
|
| 230 | -25 | 3 |
|
|
| 231 | -26 | 2 |
|
|
| 232 | -29 | 1 |
|
|
| 233 | -32 | 3 |
|
|
| 234 | -33 | 4 |
|
|
| 235 | -34 | 2 |
|
|
| 228 | +| ACTIVITE.C_OPERA | ps_common.TransmittingBuoyOperation.code |
|
|
| 229 | +|:-----------------|:-----------------------------------------|
|
|
| 230 | +| 5 | 3 |
|
|
| 231 | +| 6 | 2 |
|
|
| 232 | +| 23 | 3 |
|
|
| 233 | +| 24 | 2 |
|
|
| 234 | +| 25 | 3 |
|
|
| 235 | +| 26 | 2 |
|
|
| 236 | +| 29 | 1 |
|
|
| 237 | +| 32 | 3 |
|
|
| 238 | +| 33 | 4 |
|
|
| 239 | +| 34 | 2 |
|
|
| 240 | +| 40 | 4 |
|
|
| 241 | +| 41 | 5 |
|
|
| 236 | 242 | |
| 237 | 243 | Soit ```transmittingBuoyType``` (translation de **ACTIVITE.C_TYP_BALISE**)
|
| 238 | 244 | |
| 239 | 245 | Voir mapping [REF_TRANSMITTING_BUOY](./referential.html#REF_TRANSMITTING_BUOY)
|
| 240 | 246 | |
| 247 | +Soit ```transmittingBuoyOwnerShip``` (translation de **ACTIVITE.F_PROP_BALISE**)
|
|
| 248 | + |
|
| 249 | +Voir mapping [REF_TRANSMITTING_BUOY_OWNER_SHIP](./referential.html#REF_TRANSMITTING_BUOY_OWNER_SHIP)
|
|
| 250 | + |
|
| 241 | 251 | **Attention: cette règle n'est plus appliquée!**
|
| 242 | 252 | |
| 243 | 253 | ** On remplace par 999 si non trouvé**
|
| ... | ... | @@ -264,7 +274,7 @@ return observedSystem.get(observedSystemCode); |
| 264 | 274 | avec ```OBSERVED_SYSTEM_CODE_MAPPING```
|
| 265 | 275 | |
| 266 | 276 | | ACTIVITE.C_TYP_OBJET | ps_common.ObservedSystem.code |
|
| 267 | -| :--- | :--- |
|
|
| 277 | +|:---------------------|:------------------------------|
|
|
| 268 | 278 | | 1 | 20 |
|
| 269 | 279 | | 2 | 20 |
|
| 270 | 280 | | 3 | 20 |
|
| ... | ... | @@ -277,14 +287,14 @@ avec ```OBSERVED_SYSTEM_CODE_MAPPING``` |
| 277 | 287 | |
| 278 | 288 | ### Table ACT_ASSOC
|
| 279 | 289 | |
| 280 | -|n° | nom | destination |note |
|
|
| 281 | -|:--- | :--- | :--- |:--- |
|
|
| 282 | -| ACT_ASSOC_01 | C_BAT | Activity_ObservedSystem.activity | [1](#n_1_1)|
|
|
| 283 | -| ACT_ASSOC_02 | D_DBQ | Activity_ObservedSystem.activity | [1](#n_1_1)|
|
|
| 284 | -| ACT_ASSOC_03 | D_ACT | Activity_ObservedSystem.activity | [1](#n_1_1)|
|
|
| 285 | -| ACT_ASSOC_04 | N_ACT | Activity_ObservedSystem.activity | [1](#n_1_1)|
|
|
| 286 | -| ACT_ASSOC_05 | N_ASSOC | Not used | |
|
|
| 287 | -| ACT_ASSOC_06 | C_ASSOC | Activity_ObservedSystem.ObservedSystem | [2](#n_1_2)|
|
|
| 290 | +| n° | nom | destination | note |
|
|
| 291 | +|:-------------|:--------|:---------------------------------------|:------------|
|
|
| 292 | +| ACT_ASSOC_01 | C_BAT | Activity_ObservedSystem.activity | [1](#n_1_1) |
|
|
| 293 | +| ACT_ASSOC_02 | D_DBQ | Activity_ObservedSystem.activity | [1](#n_1_1) |
|
|
| 294 | +| ACT_ASSOC_03 | D_ACT | Activity_ObservedSystem.activity | [1](#n_1_1) |
|
|
| 295 | +| ACT_ASSOC_04 | N_ACT | Activity_ObservedSystem.activity | [1](#n_1_1) |
|
|
| 296 | +| ACT_ASSOC_05 | N_ASSOC | Not used | |
|
|
| 297 | +| ACT_ASSOC_06 | C_ASSOC | Activity_ObservedSystem.ObservedSystem | [2](#n_1_2) |
|
|
| 288 | 298 | |
| 289 | 299 | * Note 1
|
| 290 | 300 | ### <a name="n_1_1"></a>
|
| ... | ... | @@ -296,16 +306,16 @@ Voir mapping [REF_OBSERVED_SYSTEM](./referential.html#REF_OBSERVED_SYSTEM) |
| 296 | 306 | |
| 297 | 307 | ### Table CAPT_ELEM
|
| 298 | 308 | |
| 299 | -|n° | nom | destination |note |
|
|
| 300 | -|:--- | :--- | :--- |:--- |
|
|
| 301 | -| CAPT_ELEM_01 | C_BAT | Catch.activity | [1](#n_2_1)|
|
|
| 302 | -| CAPT_ELEM_02 | D_DBQ | Catch.activity | [1](#n_2_1)|
|
|
| 303 | -| CAPT_ELEM_03 | D_ACT | Catch.activity | [1](#n_2_1)|
|
|
| 304 | -| CAPT_ELEM_04 | N_ACT | Catch.activity | [1](#n_2_1)|
|
|
| 305 | -| CAPT_ELEM_05 | N_CAPT | Catch.homeId | |
|
|
| 306 | -| CAPT_ELEM_06 | C_ESP | Catch.species | [2](#n_2_2)|
|
|
| 307 | -| CAPT_ELEM_07 | C_CAT_T | Catch.weightCategory | [3](#n_2_3)|
|
|
| 308 | -| CAPT_ELEM_08 | V_POIDS_CAPT | Catch.weight | |
|
|
| 309 | +| n° | nom | destination | note |
|
|
| 310 | +|:-------------|:-------------|:---------------------|:------------|
|
|
| 311 | +| CAPT_ELEM_01 | C_BAT | Catch.activity | [1](#n_2_1) |
|
|
| 312 | +| CAPT_ELEM_02 | D_DBQ | Catch.activity | [1](#n_2_1) |
|
|
| 313 | +| CAPT_ELEM_03 | D_ACT | Catch.activity | [1](#n_2_1) |
|
|
| 314 | +| CAPT_ELEM_04 | N_ACT | Catch.activity | [1](#n_2_1) |
|
|
| 315 | +| CAPT_ELEM_05 | N_CAPT | Catch.homeId | |
|
|
| 316 | +| CAPT_ELEM_06 | C_ESP | Catch.species | [2](#n_2_2) |
|
|
| 317 | +| CAPT_ELEM_07 | C_CAT_T | Catch.weightCategory | [3](#n_2_3) |
|
|
| 318 | +| CAPT_ELEM_08 | V_POIDS_CAPT | Catch.weight | |
|
|
| 309 | 319 | |
| 310 | 320 | * Note 1
|
| 311 | 321 | ### <a name="n_2_1"></a>
|
| ... | ... | @@ -323,13 +333,13 @@ Voir mapping [REF_CATCH_WEIGHT_CATEGORY](./referential.html#REF_CATCH_WEIGHT_CAT |
| 323 | 333 | |
| 324 | 334 | Cette table représente la définition des cuves sur une marée et est déversée dans la table **WellPlan**.
|
| 325 | 335 | |
| 326 | -|n° | nom | destination |note |
|
|
| 327 | -|:--- | :--- | :--- |:--- |
|
|
| 328 | -| CUVE_01 | C_BAT | WellPlan.trip | [1](#n_3_1)|
|
|
| 329 | -| CUVE_02 | D_DBQ | WellPlan.trip | [1](#n_3_1)|
|
|
| 330 | -| CUVE_03 | N_CUVE | WellPlan.well | [2](#n_3_2)|
|
|
| 331 | -| CUVE_04 | F_POS_CUVE | WellPlan.well | [2](#n_3_2)|
|
|
| 332 | -| CUVE_05 | C_DEST | WellPlan.wellSamplingConformity et wellSamplingStatus | [3](#n_3_3)|
|
|
| 336 | +| n° | nom | destination | note |
|
|
| 337 | +|:--------|:-----------|:------------------------------------------------------|:------------|
|
|
| 338 | +| CUVE_01 | C_BAT | WellPlan.trip | [1](#n_3_1) |
|
|
| 339 | +| CUVE_02 | D_DBQ | WellPlan.trip | [1](#n_3_1) |
|
|
| 340 | +| CUVE_03 | N_CUVE | WellPlan.well | [2](#n_3_2) |
|
|
| 341 | +| CUVE_04 | F_POS_CUVE | WellPlan.well | [2](#n_3_2) |
|
|
| 342 | +| CUVE_05 | C_DEST | WellPlan.wellSamplingConformity et wellSamplingStatus | [3](#n_3_3) |
|
|
| 333 | 343 | |
| 334 | 344 | * Note 1
|
| 335 | 345 | ### <a name="n_3_1"></a>
|
| ... | ... | @@ -353,19 +363,19 @@ Voir mapping [REF_WELL_SAMPLING_CONFORMITY](./referential.html#REF_WELL_SAMPLING |
| 353 | 363 | |
| 354 | 364 | Cette table définit le plan de cuve et est déversée dans la table **WellPlan**.
|
| 355 | 365 | |
| 356 | -|n° | nom | destination |note |
|
|
| 357 | -|:--- | :--- | :--- |:--- |
|
|
| 358 | -| CUVE_CALEE_01 | C_BAT | WellPlan.topiaId | [1](#n_4_1)|
|
|
| 359 | -| CUVE_CALEE_02 | D_DBQ | WellPlan.topiaId | [1](#n_4_1)|
|
|
| 360 | -| CUVE_CALEE_03 | N_CUVE | WellPlan.topiaId | [1](#n_4_1)|
|
|
| 361 | -| CUVE_CALEE_04 | F_POS_CUVE | WellPlan.topiaId | [1](#n_4_1)|
|
|
| 362 | -| CUVE_CALEE_05 | N_CALESP | ??? | |
|
|
| 363 | -| CUVE_CALEE_06 | D_ACT | Activity.topiaId | [2](#n_4_2)|
|
|
| 364 | -| CUVE_CALEE_07 | N_ACT | Activity.topiaId | [2](#n_4_2)|
|
|
| 365 | -| CUVE_CALEE_08 | C_ESP | WellPlan.species | [3](#n_4_3)|
|
|
| 366 | -| CUVE_CALEE_09 | C_CAT_POIDS | WellPlan.weightCategory | [4](#n_4_4)|
|
|
| 367 | -| CUVE_CALEE_10 | V_POIDS | WellPlan.weight | |
|
|
| 368 | -| CUVE_CALEE_11 | V_NB | Not Used | |
|
|
| 366 | +| n° | nom | destination | note |
|
|
| 367 | +|:--------------|:------------|:------------------------|:------------|
|
|
| 368 | +| CUVE_CALEE_01 | C_BAT | WellPlan.topiaId | [1](#n_4_1) |
|
|
| 369 | +| CUVE_CALEE_02 | D_DBQ | WellPlan.topiaId | [1](#n_4_1) |
|
|
| 370 | +| CUVE_CALEE_03 | N_CUVE | WellPlan.topiaId | [1](#n_4_1) |
|
|
| 371 | +| CUVE_CALEE_04 | F_POS_CUVE | WellPlan.topiaId | [1](#n_4_1) |
|
|
| 372 | +| CUVE_CALEE_05 | N_CALESP | ??? | |
|
|
| 373 | +| CUVE_CALEE_06 | D_ACT | Activity.topiaId | [2](#n_4_2) |
|
|
| 374 | +| CUVE_CALEE_07 | N_ACT | Activity.topiaId | [2](#n_4_2) |
|
|
| 375 | +| CUVE_CALEE_08 | C_ESP | WellPlan.species | [3](#n_4_3) |
|
|
| 376 | +| CUVE_CALEE_09 | C_CAT_POIDS | WellPlan.weightCategory | [4](#n_4_4) |
|
|
| 377 | +| CUVE_CALEE_10 | V_POIDS | WellPlan.weight | |
|
|
| 378 | +| CUVE_CALEE_11 | V_NB | Not Used | |
|
|
| 369 | 379 | |
| 370 | 380 | * Note 1
|
| 371 | 381 | ### <a name="n_4_1"></a>
|
| ... | ... | @@ -167,39 +167,51 @@ Mapping TransmittingBuoy |
| 167 | 167 | |
| 168 | 168 | Pour transposer certains codes **TYPE_BALISE.C_TYP_BALISE** en code **ps_common.TransmittingBuoy.code**, les autres codes sont ceux d'ObServe.
|
| 169 | 169 | |
| 170 | -| **TYPE_BALISE.C_TYP_BALISE** | **ps_common.ObservedSystem.code** |
|
|
| 171 | -|:-----------------------------|:----------------------------------|
|
|
| 172 | -| 11 | 90 |
|
|
| 173 | -| 12 | 21 |
|
|
| 174 | -| 13 | 22 |
|
|
| 175 | -| 14 | 23 |
|
|
| 176 | -| 15 | 24 |
|
|
| 177 | -| 16 | 25 |
|
|
| 178 | -| 17 | 26 |
|
|
| 179 | -| 18 | 27 |
|
|
| 180 | -| 19 | 28 |
|
|
| 181 | -| 20 | 41 |
|
|
| 182 | -| 21 | 42 |
|
|
| 183 | -| 22 | 43 |
|
|
| 184 | -| 23 | 44 |
|
|
| 185 | -| 24 | 45 |
|
|
| 186 | -| 25 | 46 |
|
|
| 187 | -| 26 | 47 |
|
|
| 188 | -| 27 | 100 |
|
|
| 189 | -| 28 | 61 |
|
|
| 190 | -| 29 | 62 |
|
|
| 191 | -| 30 | 63 |
|
|
| 192 | -| 31 | 64 |
|
|
| 193 | -| 32 | 65 |
|
|
| 194 | -| 33 | 66 |
|
|
| 195 | -| 34 | 67 |
|
|
| 196 | -| 35 | 68 |
|
|
| 197 | -| 36 | 69 |
|
|
| 198 | -| 37 | 70 |
|
|
| 199 | -| 38 | 71 |
|
|
| 200 | -| 39 | 3 |
|
|
| 201 | -| 40 | 91 |
|
|
| 202 | -| 98 | 99 |
|
|
| 170 | +| **TYPE_BALISE.C_TYP_BALISE** | **ps_common.TransmittingBuoyType.code** |
|
|
| 171 | +|:-----------------------------|:-----------------------------------------|
|
|
| 172 | +| 11 | 90 |
|
|
| 173 | +| 12 | 21 |
|
|
| 174 | +| 13 | 22 |
|
|
| 175 | +| 14 | 23 |
|
|
| 176 | +| 15 | 24 |
|
|
| 177 | +| 16 | 25 |
|
|
| 178 | +| 17 | 26 |
|
|
| 179 | +| 18 | 27 |
|
|
| 180 | +| 19 | 28 |
|
|
| 181 | +| 20 | 41 |
|
|
| 182 | +| 21 | 42 |
|
|
| 183 | +| 22 | 43 |
|
|
| 184 | +| 23 | 44 |
|
|
| 185 | +| 24 | 45 |
|
|
| 186 | +| 25 | 46 |
|
|
| 187 | +| 26 | 47 |
|
|
| 188 | +| 27 | 100 |
|
|
| 189 | +| 28 | 61 |
|
|
| 190 | +| 29 | 62 |
|
|
| 191 | +| 30 | 63 |
|
|
| 192 | +| 31 | 64 |
|
|
| 193 | +| 32 | 65 |
|
|
| 194 | +| 33 | 66 |
|
|
| 195 | +| 34 | 67 |
|
|
| 196 | +| 35 | 68 |
|
|
| 197 | +| 36 | 69 |
|
|
| 198 | +| 37 | 70 |
|
|
| 199 | +| 38 | 71 |
|
|
| 200 | +| 39 | 3 |
|
|
| 201 | +| 40 | 91 |
|
|
| 202 | +| 98 | 99 |
|
|
| 203 | + |
|
| 204 | + |
|
| 205 | +### REF_TRANSMITTING_BUOY_OWNER_SHIP
|
|
| 206 | + |
|
| 207 | +Mapping TransmittingBuoyOwnerShip
|
|
| 208 | + |
|
| 209 | +Pour transposer certains codes **ACTIVITE.F_PROP_BALISE** en code **ps_common.TransmittingBuoyOwnerShip.code**.
|
|
| 210 | + |
|
| 211 | +| **ACTIVITE.F_PROP_BALISE** | **ps_common.TransmittingBuoyOwnerShip.code** |
|
|
| 212 | +|:---------------------------|:---------------------------------------------|
|
|
| 213 | +| 1 | 0 |
|
|
| 214 | +| 2 | 3 |
|
|
| 203 | 215 | |
| 204 | 216 | ### REF_VESSEL_ACTIVITY_TYPE
|
| 205 | 217 | |
| ... | ... | @@ -226,6 +238,8 @@ Mapping type d'activité |
| 226 | 238 | | 32 | 13 (2) |
|
| 227 | 239 | | 33 | 13 (2) |
|
| 228 | 240 | | 34 | 13 (2) |
|
| 241 | +| 40 | 13 (2) |
|
|
| 242 | +| 41 | 13 (2) |
|
|
| 229 | 243 | | 7 | 22 |
|
| 230 | 244 | | 8 | 10 |
|
| 231 | 245 | | 9 | 23 |
|