Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe

Commits:

21 changed files:

Changes:

  • doc/images/error.png deleted
    No preview for this file type
  • doc/images/info.png deleted
    No preview for this file type
  • doc/images/ok.png deleted
    No preview for this file type
  • doc/images/question.png deleted
    No preview for this file type
  • doc/images/warning.png deleted
    No preview for this file type
  • persistence/pom.xml
    ... ... @@ -57,6 +57,11 @@
    57 57 
           <groupId>org.nuiton</groupId>
    58 58 
           <artifactId>nuiton-version</artifactId>
    59 59 
         </dependency>
    60 
    +    <dependency>
    61 
    +      <groupId>org.nuiton</groupId>
    62 
    +      <artifactId>nuiton-csv</artifactId>
    63 
    +      <scope>test</scope>
    64 
    +    </dependency>
    60 65
    61 66 
         <!-- commons -->
    62 67 
         <dependency>

  • persistence/src/main/java/fr/ird/observe/persistence/migration/DataSourceMigrationForVersion_7_0.java
    ... ... @@ -65,6 +65,7 @@ public class DataSourceMigrationForVersion_7_0 extends AbstractObserveMigrationC
    65 65 
             addScript("06", "add_non_target_catch_release", queries);
    66 66 
             addScript("07", "drop_table_sizemeasuretype", queries);
    67 67 
             addScript("08", "add_floating_object_fields", queries);
    68 
    +        addScript("09", "fill_object_material", queries);
    68 69 
         }
    69 70
    70 71 
         public static class H2DataSourceMigrationForVersion extends DataSourceMigrationForVersion_7_0 {

  • persistence/src/main/models/Observe.model
    ... ... @@ -654,7 +654,7 @@ nonEntangling + {*:1} boolean | notNull
    654 654 
     childrenMultiSelectable + {*:1} boolean | notNull
    655 655 
     childSelectionMandatory + {*:1} boolean | notNull
    656 656 
     parent {*:0..1} referentiel.seine.ObjectMaterial
    657 
    -objectMaterialType {*:1} referentiel.seine.ObjectMaterialType | notNull lazy=false
    657 
    +objectMaterialType {*:1} referentiel.seine.ObjectMaterialType | lazy=false
    658 658 
     validation + {*:1} String
    659 659
    660 660 
     referentiel.seine.ObjectMaterialType > referentiel.I18nReferentialEntity | entity

  • persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql
    ... ... @@ -35,48 +35,3 @@ ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT PK_OBJECT_MATERIAL PRIMA
    35 35 
     ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT FK_OBJECT_MATERIAL_PARENT FOREIGN KEY (parent) REFERENCES observe_seine.objectMaterial(topiaid);
    36 36 
     ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT FK_OBJECT_MATERIAL_OBJECT_MATERIAL_TYPE FOREIGN KEY (objectMaterialType) REFERENCES observe_seine.objectMaterialType(topiaid);
    37 37 
     INSERT INTO observe_common.LASTUPDATEDATE (topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#901', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial', CURRENT_TIMESTAMP);
    38 
    -
    39 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1', NULL,'Raft', 'Radeau', true, true, true, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    40 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 'Frame', ' Chassis', FALSE, FALSE, TRUE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    41 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#2', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 'Vegetal (including bamboo)', 'Végétal (dont bambou)', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    42 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#3', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 'Metal', 'Métal', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    43 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#4', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-1-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1','PVC', 'PVC', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    44 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 'Coverage type', 'Type de couverture', false, true, true, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    45 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Net', 'Filet', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    46 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 'Net with mesh <=3cm', 'Filet avec maille <=3cm', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    47 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#8', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 'Net with mesh <=3cm above', 'Filet avec maille <=3cm dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    48 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 'Net with mesh <=3cm behind', 'Filet avec maille <=3cm dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    49 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 'Net with mesh >3cm', 'Filet avec maille >3cm', FALSE, FALSE, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    50 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 'Net with mesh >3cm above', 'Filet avec maille >3cm dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    51 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-1-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 'Net with mesh >3cm behind', 'Filet avec maille >3cm dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    52 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Coverage without mesh', 'Couverture sans maille', FALSE, FALSE, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    53 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 'Coverage without mesh above', 'Couverture sans maille dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    54 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 'Coverage without mesh behind', 'Couverture sans maille dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    55 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Not covered', 'Non couvert', FALSE, FALSE, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    56 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-3-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 'Not covered above', 'Non couvert dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    57 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-3-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 'Not covered behind', 'Non couvert dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    58 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-4', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 'Not visible', 'Non visible', false, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    59 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-4-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 'Not visible above', 'Non visible dessus', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    60 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '1-2-4-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 'Not visible behind', 'Non visible dessous', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    61 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2', NULL, 'Underwater part', 'Partie immergée', false, true, true, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    62 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Net in sausage', 'Filet saucisse', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    63 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-1-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 'Net in sausage <=3cm', 'Filet saucisse <=3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    64 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-1-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 'Net in sausage >3cm', 'Filet saucisse >3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    65 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Open net', 'Filet ouvert', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    66 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#27', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-2-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 'Open net <= 3cm', 'Filet ouvert <=3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    67 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#28', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-2-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 'Open net >3cm', 'Filet ouvert >3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    68 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Single net pieces', 'Pièces de filets accolées', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    69 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#30', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-3-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 'Single net pieces <=3cm', 'Pièces de filets accolées <=3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    70 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#31', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-3-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 'Single net pieces >3cm', 'Pièces de filets accolées >3cm', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    71 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#32', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-4', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Rope/no mesh', 'Bout/sans maille', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    72 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#33', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-5', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'Not visible', 'Pas visible', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    73 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#34', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '2-6', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 'No sub structure', 'Pas de mouillage', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    74 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3', NULL, 'Other elements', 'Autres éléments', FALSE, TRUE, FALSE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    75 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#36', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-1', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Platic containers', 'Bidons plastique', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    76 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#37', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-2', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Corks', 'Flotteurs', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    77 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#38', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-3', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Bags', 'Sacs', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    78 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#39', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-4', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Palms, canes', 'Palmes, tiges', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', false, false);
    79 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#40', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-5', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Color belts', 'Rubans colorés', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1', false, false);
    80 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#41', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-6', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Weights', 'Poids', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', false, false);
    81 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#42', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '', '', '3-7', 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 'Entangled animal', 'Animal maillé', true, false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3', false, false);
    82 
    -UPDATE observe_seine.objectMaterial set label3 = label2 || ' TODO';

  • persistence/src/main/resources/db/migration/6.901/09_fill_object_material-common.sql
    1 
    +---
    2 
    +-- #%L
    3 
    +-- ObServe :: Persistence
    4 
    +-- %%
    5 
    +-- Copyright (C) 2008 - 2017 IRD, Code Lutin, Ultreia.io
    6 
    +-- %%
    7 
    +-- This program is free software: you can redistribute it and/or modify
    8 
    +-- it under the terms of the GNU General Public License as
    9 
    +-- published by the Free Software Foundation, either version 3 of the
    10 
    +-- License, or (at your option) any later version.
    11 
    +--
    12 
    +-- This program is distributed in the hope that it will be useful,
    13 
    +-- but WITHOUT ANY WARRANTY; without even the implied warranty of
    14 
    +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    15 
    +-- GNU General Public License for more details.
    16 
    +--
    17 
    +-- You should have received a copy of the GNU General Public
    18 
    +-- License along with this program.  If not, see
    19 
    +-- <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 
    +-- #L%
    21 
    +---
    22 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.1' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'FAD'     , '1'            , NULL                                                             , 'FAD'                                             , 'FAD'                                             , 'FAD'                                             , false, false, false, NULL                                                              , NULL                          , false, false);
    23 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '16'           , 'DFAD'    , '1-1'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.1' , 'DFAD (drifting FAD)'                             , 'DFAD (FAD dérivant)'                             , 'DFAD (FAD a la deriva)'                          , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    24 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '19'           , NULL      , '1-1-1'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Experimental FAD'                                , 'Objet expérimental'                              , 'Objeto experimental'                             , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    25 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '18'           , NULL      , '1-1-2'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Artificial FAD'                                  , 'Objet artificiel'                                , 'Objeto artificial'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    26 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '27'           , NULL      , '1-1-3'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Several FAD entangled'                           , 'Plusieurs FAD'                                   , 'Objectos enredados'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    27 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-1'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Frame'                                           , 'Chassis'                                         , 'Estructura'                                      , false, false, true , NULL                                                              , NULL                          , false, false);
    28 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.7' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '6, 15, 25'    , NULL      , '1-1-1-1-1'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Vegetal, canes,bamboo'                           , 'Végétal, tiges,bambou'                           , 'Bambú, cañas'                                    , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    29 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.8' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '20, 21*,26'   , NULL      , '1-1-1-1-2'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Metallic or PVC'                                 , 'Métal ou PVC'                                    , 'Metállica ó PVC'                                 , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    30 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Superior coverage'                               , 'Revêtement supérieur'                            , 'Recubrimiento superior'                          , false, true , true , NULL                                                              , NULL                          , false, false);
    31 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2-1'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Net'                                             , 'Filet'                                           , 'Red'                                             , false, true , false, NULL                                                              , NULL                          , false, false);
    32 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2-1-1'  , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.10', 'Net with mesh ≤7cm'                              , 'Filet avec maillage ≤7cm'                        , 'Red con malla ≤7cm'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    33 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2-1-2'  , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.10', 'Net with mesh >7cm'                              , 'Filet avec maillage >7cm'                        , 'Red con malla >7cm'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    34 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2-2'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Coverage without mesh'                           , 'Revêtement sans maillage'                        , 'Recubrimiento sin malla'                         , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    35 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2-3'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Not covered'                                     , 'Non couvert'                                     , 'Sin recubrimiento'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    36 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-2-4'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.9' , 'Not visible'                                     , 'Non visible'                                     , 'No se ve'                                        , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    37 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Inferior coverage'                               , 'Revêtement inférieur'                            , 'Recubrimiento inferior'                          , false, true , true , NULL                                                              , NULL                          , false, false);
    38 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3-1'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Net'                                             , 'Filet'                                           , 'Red'                                             , false, true , false, NULL                                                              , NULL                          , false, false);
    39 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3-1-1'  , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.17', 'Net with mesh ≤7cm'                              , 'Filet avec maillage ≤7cm'                        , 'Red con malla ≤7cm'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    40 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3-1-2'  , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.17', 'Net with mesh >7cm'                              , 'Filet avec maillage >7cm'                        , 'Red con malla >7cm'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    41 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3-2'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Coverage without mesh'                           , 'Revêtement sans maillage'                        , 'Recubrimiento sin malla'                         , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    42 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3-3'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Not covered'                                     , 'Non couvert'                                     , 'Sin recubrimiento'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    43 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-3-4'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.16', 'Not visible'                                     , 'Non visible'                                     , 'No se ve'                                        , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    44 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-4'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Modified'                                        , 'Modifié'                                         , 'Se modifica'                                     , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    45 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-1-5'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.3' , 'Replaced'                                        , 'Remplacé'                                        , 'Se reemplaza'                                    , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    46 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-1'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Net in sausage'                                  , 'Filet saucisse'                                  , 'Red en chorizo'                                  , false, true , false, NULL                                                              , NULL                          , false, false);
    47 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, NULL           , NULL      , '1-1-2-1-1'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.25', 'Net in sausage with mesh ≤7cm'                   , 'Filet saucisse avec maillage ≤7cm'               , 'Red en chorizo con malla ≤7cm'                   , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    48 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.27', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, NULL           , NULL      , '1-1-2-1-2'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.25', 'Net in sausage with mesh >7cm'                   , 'Filet saucisse avec maillage >7cm'               , 'Red en chorizo con malla >7cm'                   , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    49 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.28', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-2'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Open net'                                        , 'Filet ouvert'                                    , 'Red abierta'                                     , false, true , false, NULL                                                              , NULL                          , false, false);
    50 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.29', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-2-1'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.28', 'Open net with mesh ≤7cm'                         , 'Filet ouvert avec maillage ≤7cm'                 , 'Red abierta con malla ≤7cm'                      , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    51 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.30', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-2-2'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.28', 'Open net with mesh >7cm'                         , 'Filet ouvert avec maillage >7cm'                 , 'Red abierta con malla >7cm'                      , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    52 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.31', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-3'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Single net pieces'                               , 'Pièces de filets accolées'                       , 'Paños de red sueltos'                            , false, true , false, NULL                                                              , NULL                          , false, false);
    53 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.32', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-3-1'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.31', 'Single net pieces with mesh ≤7cm'                , 'Pièces de filets accolées avec maillage ≤7cm'    , 'Paños de red sueltos con malla ≤7cm'             , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    54 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.33', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-3-2'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.31', 'Single net pieces with mesh >7cm'                , 'Pièces de filets accolées avec maillage >7cm'    , 'Paños de red sueltos con malla >7cm'             , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    55 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.34', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-4'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Rope/no mesh'                                    , 'Bout/sans maillage'                              , 'Cabo/sin red'                                    , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    56 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.35', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-5'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Not visible'                                     , 'Pas visible'                                     , 'No se ve'                                        , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    57 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.36', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-6'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'No subsurface structure'                         , 'Pas de mouillage'                                , 'Sin rabo'                                        , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    58 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.37', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-7'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Modified'                                        , 'Modifié'                                         , 'Se modifica'                                     , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    59 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.38', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-2-8'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.4' , 'Replaced'                                        , 'Remplacé'                                        , 'Se reemplaza'                                    , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    60 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.39', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-1'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Containers'                                      , 'Bidons plastique'                                , 'Garrafas plástico'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    61 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.40', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-2'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Corks'                                           , 'Flotteurs'                                       , 'Corchos'                                         , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    62 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.41', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-3'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Bags'                                            , 'Sacs'                                            , 'Sacos'                                           , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    63 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.42', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-4'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Palms, canes'                                    , 'Palmes, tiges'                                   , 'Palmeras, cañas'                                 , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    64 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.43', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-5'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Color belts'                                     , 'Rubans colorés'                                  , 'Cintas de colores'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    65 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.44', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-6'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Weights'                                         , 'Poids'                                           , 'Peso'                                            , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    66 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.45', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-1-3-7'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.5' , 'Entangled animal'                                , 'Animal maillé'                                   , 'Animal enmallado'                                , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    67 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '7'            , 'AFAD'    , '1-2'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.1' , 'AFAD (anchored FAD)'                             , 'AFAD (FAD ancré)'                                , 'AFAD (FAD arraigado)'                            , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    68 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.47', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-2-1'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 'Radar reflectors'                                , 'Réflecteurs radar'                               , 'Reflectores de radar'                            , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    69 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.48', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-2-2'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 'Lighting'                                        , 'Eclairage'                                       , 'iluminación'                                     , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    70 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.49', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '1-2-3'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.46', 'Visual range (in nautical miles)'                , 'Rayon de visibilité (en miles nautiques)'        , 'Rango de visibilidad'                            , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1', 'x >= 0.1 && x <= 50'         , false, false);
    71 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.50', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'LOG'     , '2'            , NULL                                                             , 'LOG'                                             , 'LOG'                                             , 'LOG'                                             , true , true , false, NULL                                                              , NULL                          , false, false);
    72 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.51', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'NLOG'    , '2-1'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.50', 'NLOG (natural LOG)'                              , 'NLOG (LOG naturel)'                              , 'NLOG (LOG natural)'                              , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    73 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'VNLOG'   , '2-1-1'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.51', 'VNLOG (vegetal NLOG)'                            , 'VNLOG (NLOG vegetal)'                            , 'VNLOG (NLOG vegetal)'                            , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    74 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.53', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1'            , NULL      , '2-1-1-1'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 'Straw heap'                                      , 'Tas de paille'                                   , 'Monton the hierba'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    75 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.54', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2'            , NULL      , '2-1-1-2'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 'Palm tree, palm'                                 , 'Palmier, palme'                                  , 'Palma, hoja de palmera'                          , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    76 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.55', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3'            , NULL      , '2-1-1-3'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.52', 'Tree, branche'                                   , 'Arbre, branche'                                  , 'Árbol, rama'                                     , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    77 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.56', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'ANLOG'   , '2-1-2'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.51', 'ANLOG (animal NLOG)'                             , 'ANLOG (NLOG animal)'                             , 'ANLOG (NLOG animal)'                             , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    78 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.57', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '4, 5*, 24'    , NULL      , '2-1-2-1'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.56', 'Carrion'                                         , 'Charogne'                                        , 'Carroña'                                         , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    79 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.58', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '2-1-2-2'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.56', 'Whale shark'                                     , 'Requin-baleine'                                  , 'Tiburón ballena'                                 , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    80 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'ALOG'    , '2-2'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.50', 'ALOG (artificial LOG)'                           , 'ALOG (LOG artificiel)'                           , 'ALOG (LOG artificial)'                           , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    81 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.60', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '10'           , NULL      , '2-2-1'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'Case, big board'                                 , 'Caisse, grosse planche'                          , 'Caja, gran tablero'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    82 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.61', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '13'           , NULL      , '2-2-2'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'Plastic object'                                  , 'Objet plastique'                                 , 'Objeto de plastico'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    83 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.62', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '17'           , NULL      , '2-2-3'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'Metallic object'                                 , 'Objet métallique'                                , 'Objeto de metal'                                 , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    84 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'FALOG'   , '2-2-4'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'FALOG (fishing ALOG)'                            , 'FALOG (ALOG pêche)'                              , 'FALOG (ALOG pesca)'                              , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    85 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.64', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '11'           , NULL      , '2-2-4-1'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 'Rope, cable'                                     , 'Cordage, câble'                                  , 'Cuerda, cable'                                   , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    86 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.65', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '12'           , NULL      , '2-2-4-2'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 'Net, piece of net'                               , 'Filet, morceau de filet'                         , 'Red, pedazo de red'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    87 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.66', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '2-2-4-3'      , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63', 'Inert plastic buoy'                              , 'Bouée plastique inerte'                          , 'Boya de plástico inerte'                         , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    88 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.67', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , 'HALOG'   , '2-2-5'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59', 'HALOG (not fishing ALOG)'                        , 'HALOG (ALOG non pêche)'                          , 'HALOG (HALOG no pesca)'                          , true , true , false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    89 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4'            , NULL                                                             , 'Other properties'                                , 'Autres propriétés'                               , 'Otras propiedades'                               , false, true , false, NULL                                                              , NULL                          , false, false);
    90 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.69', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4-1'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Biodegradable'                                   , 'Matériaux'                                       , 'Materiales'                                      , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    91 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.70', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '22'           , NULL      , '4-2'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Non entangling'                                  , 'Non maillant'                                    , NULL                                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    92 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.71', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '23'           , NULL      , '4-3'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Entangling'                                      , 'Maillant'                                        , 'Enmallante'                                      , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    93 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.72', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4-4'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Depth (in m)'                                    , 'Profondeur (en m)'                               , 'Profundidad (en m)'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', 'x >= 0 && x <= 100'          , false, false);
    94 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.73', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4-5'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Area (in m2)'                                    , 'Surface (en m2)'                                 , 'Superficie (en m2)'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1', 'x >= 0.5  && x <= 50'        , false, false);
    95 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.74', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4-6'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Size of largest mesh'                            , 'Taille de la maille la plus grande (en mm)'      , 'Talla de la malla más grandes (en mm)'           , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', 'x >= 5 && x <= 200'          , false, false);
    96 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.75', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4-7'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'FOB identifier'                                  , 'Identifiant du FOB'                              , 'Identificador del FOB'                           , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3', 'len(x) >= 3 && len(x) <= 64' , false, false);
    97 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.76', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '4-8'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68', 'Number of FOB of this'                           , 'Nombre de FOB de ce type emmêlés'                , NULL                                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2', 'x >= 2 && x <= 100'          , false, false);
    98 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, NULL           , NULL      , '6'            , NULL                                                             , 'Legacy codes'                                    , 'Anciens codes'                                   , 'Códigos antiguos'                                , false, true , false, NULL                                                              , NULL                          , false, false);
    99 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.78', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '99'           , NULL      , '6-1'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Other, unknown'                                  , 'Autre, inconnu'                                  , 'Otro, desconocido'                               , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    100 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.79', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '14'           , 'ALOG'    , '6-2'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'One of the previous (10, 11, 12, 13) tagged'     , 'Un des antérieurs (10, 11, 12, 13) balisé'       , 'Una de los anterior (10, 11, 12, 13) con Baliza' , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    101 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.80', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '8'            , NULL      , '6-3'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Tuna seiner (or skiff)'                          , 'Thonier (ou skiff)'                              , 'Atunero (oó panga)'                              , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    102 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.81', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '9'            , NULL      , '6-4'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Supply'                                          , 'Bateau d’appui'                                  , 'Macicero'                                        , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    103 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.82', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, '5*, 6*, 21*'  , NULL      , '6-5'          , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77', 'Tagged'                                          , 'Balisé'                                          , 'Marcado'                                         , true , false, false, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    104 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.83', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '7-1-1'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Raft'                                            , 'Radeau'                                          , 'Parrilla'                                        , true , true , true , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0', NULL                          , false, false);
    105 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.84', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  0, NULL           , NULL      , '7-1-1-1-3'    , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Mixed vegetal and metallic or PVC'               , NULL                                              , 'Mixta (metálica o PVC y cañas)'                  , false, false, false, NULL                                                              , NULL                          , false, false);
    106 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.85', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '7-1-2'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.6' , 'Subsurface structure'                            , 'Structure immergée'                              , 'Rabo'                                            , false, true , true , NULL                                                              , NULL                          , false, false);
    107 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.86', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, NULL           , NULL      , '7-1-3'        , 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.2' , 'Other components'                                , 'Autres éléments'                                 , 'Otros componentes'                               , false, true , false, NULL                                                              , NULL                          , false, false);

  • persistence/src/main/resources/db/migration/6.901/referential-ObjectMaterial.csv
    1 
    +code,parent,legacyCode,standardCode,label1,label2,label3,dataType,validation,selectable,childrenMultiSelectable,childSelectionMandatory,status,biodegradable,nonEntangling
    2 
    +1,,,FAD,FAD,FAD,FAD,,,FALSE,FALSE,FALSE,TRUE,,
    3 
    +1-1,1,16,DFAD,DFAD (drifting FAD),DFAD (FAD dérivant),DFAD (FAD a la deriva),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    4 
    +1-1-1,1-1,19,,Experimental FAD,Objet expérimental,Objeto experimental,Boolean,,TRUE,,,FALSE,,
    5 
    +1-1-2,1-1,18,,Artificial FAD,Objet artificiel,Objeto artificial,Boolean,,TRUE,,,FALSE,,
    6 
    +1-1-3,1-1,27,,Several FAD entangled,Plusieurs FAD,Objectos enredados,Boolean,,TRUE,,,TRUE,,
    7 
    +1-1-1-1,1-1-1,,,Frame,Chassis,Estructura,,,FALSE,FALSE,TRUE,TRUE,,
    8 
    +1-1-1-1-1,1-1-1-1,"6, 15, 25",,"Vegetal, canes,bamboo","Végétal, tiges,bambou","Bambú, cañas",Boolean,,TRUE,,,TRUE,,
    9 
    +1-1-1-1-2,1-1-1-1,"20, 21*,26",,Metallic or PVC,Métal ou PVC,Metállica ó PVC,Boolean,,TRUE,,,TRUE,,
    10 
    +1-1-1-2,1-1-1,,,Superior coverage,Revêtement supérieur,Recubrimiento superior,,,FALSE,TRUE,TRUE,TRUE,,
    11 
    +1-1-1-2-1,1-1-1-2,,,Net,Filet,Red,,,FALSE,TRUE,FALSE,TRUE,,
    12 
    +1-1-1-2-1-1,1-1-1-2-1,,,Net with mesh ≤7cm,Filet avec maillage ≤7cm,Red con malla ≤7cm,Boolean,,TRUE,,FALSE,TRUE,,
    13 
    +1-1-1-2-1-2,1-1-1-2-1,,,Net with mesh >7cm,Filet avec maillage >7cm,Red con malla >7cm,Boolean,,TRUE,,FALSE,TRUE,,
    14 
    +1-1-1-2-2,1-1-1-2,,,Coverage without mesh,Revêtement sans maillage,Recubrimiento sin malla,Boolean,,TRUE,,FALSE,TRUE,,
    15 
    +1-1-1-2-3,1-1-1-2,,,Not covered,Non couvert,Sin recubrimiento,Boolean,,TRUE,,FALSE,TRUE,,
    16 
    +1-1-1-2-4,1-1-1-2,,,Not visible,Non visible,No se ve,Boolean,,TRUE,,,TRUE,,
    17 
    +1-1-1-3,1-1-1,,,Inferior coverage,Revêtement inférieur,Recubrimiento inferior,,,FALSE,TRUE,TRUE,TRUE,,
    18 
    +1-1-1-3-1,1-1-1-3,,,Net,Filet,Red,,,FALSE,TRUE,FALSE,TRUE,,
    19 
    +1-1-1-3-1-1,1-1-1-3-1,,,Net with mesh ≤7cm,Filet avec maillage ≤7cm,Red con malla ≤7cm,Boolean,,TRUE,,FALSE,TRUE,,
    20 
    +1-1-1-3-1-2,1-1-1-3-1,,,Net with mesh >7cm,Filet avec maillage >7cm,Red con malla >7cm,Boolean,,TRUE,,FALSE,TRUE,,
    21 
    +1-1-1-3-2,1-1-1-3,,,Coverage without mesh,Revêtement sans maillage,Recubrimiento sin malla,Boolean,,TRUE,,FALSE,TRUE,,
    22 
    +1-1-1-3-3,1-1-1-3,,,Not covered,Non couvert,Sin recubrimiento,Boolean,,TRUE,,FALSE,TRUE,,
    23 
    +1-1-1-3-4,1-1-1-3,,,Not visible,Non visible,No se ve,Boolean,,TRUE,,,TRUE,,
    24 
    +1-1-1-4,1-1-1,,,Modified,Modifié,Se modifica,Boolean,,TRUE,,,TRUE,,
    25 
    +1-1-1-5,1-1-1,,,Replaced,Remplacé,Se reemplaza,Boolean,,TRUE,,,TRUE,,
    26 
    +1-1-2-1,1-1-2,,,Net in sausage,Filet saucisse,Red en chorizo,,,FALSE,TRUE,FALSE,TRUE,,
    27 
    +1-1-2-1-1,1-1-2-1,,,Net in sausage with mesh ≤7cm,Filet saucisse avec maillage ≤7cm,Red en chorizo con malla ≤7cm,Boolean,,TRUE,,,FALSE,,
    28 
    +1-1-2-1-2,1-1-2-1,,,Net in sausage with mesh >7cm,Filet saucisse avec maillage >7cm,Red en chorizo con malla >7cm,Boolean,,TRUE,,,FALSE,,
    29 
    +1-1-2-2,1-1-2,,,Open net,Filet ouvert,Red abierta,,,FALSE,TRUE,FALSE,TRUE,,
    30 
    +1-1-2-2-1,1-1-2-2,,,Open net with mesh ≤7cm,Filet ouvert avec maillage ≤7cm,Red abierta con malla ≤7cm,Boolean,,TRUE,,,TRUE,,
    31 
    +1-1-2-2-2,1-1-2-2,,,Open net with mesh >7cm,Filet ouvert avec maillage >7cm,Red abierta con malla >7cm,Boolean,,TRUE,,,TRUE,,
    32 
    +1-1-2-3,1-1-2,,,Single net pieces,Pièces de filets accolées,Paños de red sueltos,,,FALSE,TRUE,FALSE,TRUE,,
    33 
    +1-1-2-3-1,1-1-2-3,,,Single net pieces with mesh ≤7cm,Pièces de filets accolées avec maillage ≤7cm,Paños de red sueltos con malla ≤7cm,Boolean,,TRUE,,,TRUE,,
    34 
    +1-1-2-3-2,1-1-2-3,,,Single net pieces with mesh >7cm,Pièces de filets accolées avec maillage >7cm,Paños de red sueltos con malla >7cm,Boolean,,TRUE,,,TRUE,,
    35 
    +1-1-2-4,1-1-2,,,Rope/no mesh,Bout/sans maillage,Cabo/sin red,Boolean,,TRUE,,,TRUE,,
    36 
    +1-1-2-5,1-1-2,,,Not visible,Pas visible,No se ve,Boolean,,TRUE,,,TRUE,,
    37 
    +1-1-2-6,1-1-2,,,No subsurface structure,Pas de mouillage,Sin rabo,Boolean,,TRUE,,,TRUE,,
    38 
    +1-1-2-7,1-1-2,,,Modified,Modifié,Se modifica,Boolean,,TRUE,,,TRUE,,
    39 
    +1-1-2-8,1-1-2,,,Replaced,Remplacé,Se reemplaza,Boolean,,TRUE,,,TRUE,,
    40 
    +1-1-3-1,1-1-3,,,Containers,Bidons plastique,Garrafas plástico,Boolean,,TRUE,,,TRUE,,
    41 
    +1-1-3-2,1-1-3,,,Corks,Flotteurs,Corchos,Boolean,,TRUE,,,TRUE,,
    42 
    +1-1-3-3,1-1-3,,,Bags,Sacs,Sacos,Boolean,,TRUE,,,TRUE,,
    43 
    +1-1-3-4,1-1-3,,,"Palms, canes","Palmes, tiges","Palmeras, cañas",Boolean,,TRUE,,,TRUE,,
    44 
    +1-1-3-5,1-1-3,,,Color belts,Rubans colorés,Cintas de colores,Boolean,,TRUE,,,TRUE,,
    45 
    +1-1-3-6,1-1-3,,,Weights,Poids,Peso,Boolean,,TRUE,,,TRUE,,
    46 
    +1-1-3-7,1-1-3,,,Entangled animal,Animal maillé,Animal enmallado,Boolean,,TRUE,,,TRUE,,
    47 
    +1-2,1,7,AFAD,AFAD (anchored FAD),AFAD (FAD ancré),AFAD (FAD arraigado),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    48 
    +1-2-1,1-2,,,Radar reflectors,Réflecteurs radar,Reflectores de radar,Boolean,,TRUE,,FALSE,TRUE,,
    49 
    +1-2-2,1-2,,,Lighting,Eclairage,iluminación,Boolean,,TRUE,,FALSE,TRUE,,
    50 
    +1-2-3,1-2,,,Visual range (in nautical miles),Rayon de visibilité (en miles nautiques),Rango de visibilidad,float1,x >= 0.1 && x <= 50,TRUE,,FALSE,TRUE,,
    51 
    +2,,,LOG,LOG,LOG,LOG,,,TRUE,TRUE,FALSE,TRUE,,
    52 
    +2-1,2,,NLOG,NLOG (natural LOG),NLOG (LOG naturel),NLOG (LOG natural),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    53 
    +2-1-1,2-1,,VNLOG,VNLOG (vegetal NLOG),VNLOG (NLOG vegetal),VNLOG (NLOG vegetal),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    54 
    +2-1-1-1,2-1-1,1,,Straw heap,Tas de paille,Monton the hierba,Boolean,,TRUE,,,TRUE,,
    55 
    +2-1-1-2,2-1-1,2,,"Palm tree, palm","Palmier, palme","Palma, hoja de palmera",Boolean,,TRUE,,,TRUE,,
    56 
    +2-1-1-3,2-1-1,3,,"Tree, branche","Arbre, branche","Árbol, rama",Boolean,,TRUE,,,TRUE,,
    57 
    +2-1-2,2-1,,ANLOG,ANLOG (animal NLOG),ANLOG (NLOG animal),ANLOG (NLOG animal),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    58 
    +2-1-2-1,2-1-2,"4, 5*, 24",,Carrion,Charogne,Carroña,Boolean,,TRUE,,,TRUE,,
    59 
    +2-1-2-2,2-1-2,,,Whale shark,Requin-baleine,Tiburón ballena,Boolean,,TRUE,,,TRUE,,
    60 
    +2-2,2,,ALOG,ALOG (artificial LOG),ALOG (LOG artificiel),ALOG (LOG artificial),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    61 
    +2-2-1,2-2,10,,"Case, big board","Caisse, grosse planche","Caja, gran tablero",Boolean,,TRUE,,,TRUE,,
    62 
    +2-2-2,2-2,13,,Plastic object,Objet plastique,Objeto de plastico,Boolean,,TRUE,,,TRUE,,
    63 
    +2-2-3,2-2,17,,Metallic object,Objet métallique,Objeto de metal,Boolean,,TRUE,,,TRUE,,
    64 
    +2-2-4,2-2,,FALOG,FALOG (fishing ALOG),FALOG (ALOG pêche),FALOG (ALOG pesca),Boolean,,TRUE,TRUE,,TRUE,,
    65 
    +2-2-4-1,2-2-4,11,,"Rope, cable","Cordage, câble","Cuerda, cable",Boolean,,TRUE,,,TRUE,,
    66 
    +2-2-4-2,2-2-4,12,,"Net, piece of net","Filet, morceau de filet","Red, pedazo de red",Boolean,,TRUE,,,TRUE,,
    67 
    +2-2-4-3,2-2-4,,,Inert plastic buoy,Bouée plastique inerte,Boya de plástico inerte,Boolean,,TRUE,,,TRUE,,
    68 
    +2-2-5,2-2,,HALOG,HALOG (not fishing ALOG),HALOG (ALOG non pêche),HALOG (HALOG no pesca),Boolean,,TRUE,TRUE,FALSE,TRUE,,
    69 
    +4,,,,Other properties,Autres propriétés,Otras propiedades,,,FALSE,TRUE,FALSE,TRUE,,
    70 
    +4-1,4,,,Biodegradable,Matériaux,Materiales,Boolean,,TRUE,,,TRUE,,
    71 
    +4-2,4,22,,Non entangling,Non maillant,,Boolean,,TRUE,,,TRUE,,
    72 
    +4-3,4,23,,Entangling,Maillant,Enmallante,Boolean,,TRUE,,,TRUE,,
    73 
    +4-4,4,,,Depth (in m),Profondeur (en m),Profundidad (en m),Integer,x >= 0 && x <= 100,TRUE,,,TRUE,,
    74 
    +4-5,4,,,Area (in m2),Surface (en m2),Superficie (en m2),float1,x >= 0.5  && x <= 50,TRUE,,,TRUE,,
    75 
    +4-6,4,,,Size of largest mesh,Taille de la maille la plus grande (en mm),Talla de la malla más grandes (en mm),Integer,x >= 5 && x <= 200,TRUE,,,TRUE,,
    76 
    +4-7,4,,,FOB identifier,Identifiant du FOB,Identificador del FOB,String,len(x) >= 3 && len(x) <= 64,TRUE,,,TRUE,,
    77 
    +4-8,4,,,Number of FOB of this,Nombre de FOB de ce type emmêlés,,Integer,x >= 2 && x <= 100,TRUE,,,TRUE,,
    78 
    +6,,,,Legacy codes,Anciens codes,Códigos antiguos,,,FALSE,TRUE,FALSE,FALSE,,
    79 
    +6-1,6,99,,"Other, unknown","Autre, inconnu","Otro, desconocido",Boolean,,TRUE,,,,,
    80 
    +6-2,6,14,ALOG,"One of the previous (10, 11, 12, 13) tagged","Un des antérieurs (10, 11, 12, 13) balisé","Una de los anterior (10, 11, 12, 13) con Baliza",Boolean,,TRUE,,,,,
    81 
    +6-3,6,8,,Tuna seiner (or skiff),Thonier (ou skiff),Atunero (oó panga),Boolean,,TRUE,,,,,
    82 
    +6-4,6,9,,Supply,Bateau d’appui,Macicero,Boolean,,TRUE,,,,,
    83 
    +6-5,6,"5*, 6*, 21*",,Tagged,Balisé,Marcado,Boolean,,TRUE,,,FALSE,,
    84 
    +7-1-1,1-1,,,Raft,Radeau,Parrilla,Boolean,,TRUE,TRUE,TRUE,TRUE,,
    85 
    +7-1-1-1-3,1-1-1-1,,,Mixed vegetal and metallic or PVC,,Mixta (metálica o PVC y cañas),,,,,,,,
    86 
    +7-1-2,1-1-1-1,,,Subsurface structure,Structure immergée,Rabo,,,FALSE,TRUE,TRUE,TRUE,,
    87 
    +7-1-3,1-1,,,Other components,Autres éléments,Otros componentes,,,FALSE,TRUE,FALSE,TRUE,,
    \ No newline at end of file

  • persistence/src/test/java/fr/ird/observe/persistence/migration/GenerateReferentialObjectMaterial.java
    1 
    +package fr.ird.observe.persistence.migration;
    2 
    +
    3 
    +/*-
    4 
    + * #%L
    5 
    + * ObServe :: Persistence
    6 
    + * %%
    7 
    + * Copyright (C) 2008 - 2017 IRD, Code Lutin, Ultreia.io
    8 
    + * %%
    9 
    + * This program is free software: you can redistribute it and/or modify
    10 
    + * it under the terms of the GNU General Public License as
    11 
    + * published by the Free Software Foundation, either version 3 of the
    12 
    + * License, or (at your option) any later version.
    13 
    + *
    14 
    + * This program is distributed in the hope that it will be useful,
    15 
    + * but WITHOUT ANY WARRANTY; without even the implied warranty of
    16 
    + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    17 
    + * GNU General Public License for more details.
    18 
    + *
    19 
    + * You should have received a copy of the GNU General Public
    20 
    + * License along with this program.  If not, see
    21 
    + * <http://www.gnu.org/licenses/gpl-3.0.html>.
    22 
    + * #L%
    23 
    + */
    24 
    +
    25 
    +import com.google.common.collect.ImmutableMap;
    26 
    +import fr.ird.observe.common.constants.ReferenceStatus;
    27 
    +import fr.ird.observe.entities.referentiel.seine.ObjectMaterial;
    28 
    +import fr.ird.observe.entities.referentiel.seine.ObjectMaterialImpl;
    29 
    +import java.io.BufferedReader;
    30 
    +import java.io.BufferedWriter;
    31 
    +import java.io.File;
    32 
    +import java.io.IOException;
    33 
    +import java.nio.file.Files;
    34 
    +import java.nio.file.Path;
    35 
    +import java.util.Collection;
    36 
    +import org.apache.commons.lang3.mutable.MutableInt;
    37 
    +import org.apache.commons.logging.Log;
    38 
    +import org.apache.commons.logging.LogFactory;
    39 
    +import org.junit.Test;
    40 
    +import org.nuiton.csv.Common;
    41 
    +import org.nuiton.csv.Import;
    42 
    +import org.nuiton.csv.ext.AbstractImportModel;
    43 
    +
    44 
    +/**
    45 
    + * Created by tchemit on 31/07/17.
    46 
    + *
    47 
    + * @author Tony Chemit - dev@tchemit.fr
    48 
    + */
    49 
    +public class GenerateReferentialObjectMaterial {
    50 
    +
    51 
    +    // Lines to fxi and readd to file
    52 
    +
    53 
    +
    54 
    +    /** Logger. */
    55 
    +    private static final Log log = LogFactory.getLog(GenerateReferentialObjectMaterial.class);
    56 
    +
    57 
    +    private static final String INSERT = "INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, legacyCode, standardCode, code, parent, label1, label2, label3, selectable, childrenMultiSelectable, childSelectionMandatory, objectMaterialType, validation, biodegradable, nonEntangling) values (%-65s, 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  %s, %-15s, %-10s, %-15s, %-65s, %-50s, %-50s, %-50s, %-5s, %-5s, %-5s, %-66s, %-30s, %-5s, %-5s);";
    58 
    +
    59 
    +    @Test
    60 
    +    public void generate() throws IOException {
    61 
    +
    62 
    +
    63 
    +        Path dir = new File("").getAbsoluteFile().toPath()
    64 
    +                .resolve("src")
    65 
    +                .resolve("main")
    66 
    +                .resolve("resources")
    67 
    +                .resolve("db")
    68 
    +                .resolve("migration")
    69 
    +                .resolve("6.901");
    70 
    +
    71 
    +        Path sourcePath = dir.resolve("referential-ObjectMaterial.csv");
    72 
    +        Path targetPath = dir.resolve("09_fill_object_material-common.sql");
    73 
    +
    74 
    +        Collection<ObjectMaterial> data = loadData(sourcePath);
    75 
    +
    76 
    +        try (BufferedWriter writer = Files.newBufferedWriter(targetPath)) {
    77 
    +
    78 
    +            for (ObjectMaterial datum : data) {
    79 
    +
    80 
    +                String row = String.format(INSERT
    81 
    +                        , getValue(datum.getTopiaId())
    82 
    +                        , datum.getStatus().ordinal()
    83 
    +                        , getValue(datum.getLegacyCode())
    84 
    +                        , getValue(datum.getStandardCode())
    85 
    +                        , getValue(datum.getCode())
    86 
    +                        , getValue(datum.getParent() == null ? "" : datum.getParent().getTopiaId())
    87 
    +                        , getValue(datum.getLabel1())
    88 
    +                        , getValue(datum.getLabel2())
    89 
    +                        , getValue(datum.getLabel3())
    90 
    +                        , datum.isSelectable()
    91 
    +                        , datum.isChildrenMultiSelectable()
    92 
    +                        , datum.isChildSelectionMandatory()
    93 
    +                        , getValue(datum.getLabel5()==null?"":datum.getLabel5())
    94 
    +                        , getValue(datum.getValidation())
    95 
    +                        , datum.isBiodegradable()
    96 
    +                        , datum.isNonEntangling()
    97 
    +                );
    98 
    +                writer.append(row);
    99 
    +                writer.newLine();
    100 
    +
    101 
    +            }
    102 
    +        }
    103 
    +
    104 
    +    }
    105 
    +
    106 
    +    private String getValue(String value) {
    107 
    +        return value.isEmpty() ? "NULL" : ("'" + value + "'");
    108 
    +    }
    109 
    +
    110 
    +    private Collection<ObjectMaterial> loadData(Path sourcePath) throws IOException {
    111 
    +
    112 
    +        ImmutableMap.Builder<String, ObjectMaterial> result = ImmutableMap.builder();
    113 
    +        MutableInt idIndex = new MutableInt(0);
    114 
    +        try (BufferedReader reader = Files.newBufferedReader(sourcePath)) {
    115 
    +            Import.newImport(new ImportModel(), reader).forEach(objectMaterial -> {
    116 
    +
    117 
    +                objectMaterial.setTopiaId("fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0." + idIndex.incrementAndGet());
    118 
    +
    119 
    +                log.info(String.format("Loading %s (%s)", objectMaterial.getCode(), objectMaterial.getTopiaId()));
    120 
    +                String dataType = objectMaterial.getLabel5();
    121 
    +                objectMaterial.setLabel5(null);
    122 
    +                if (dataType != null) {
    123 
    +                    switch (dataType.trim().toLowerCase()) {
    124 
    +                        case "boolean":
    125 
    +                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0");
    126 
    +                            break;
    127 
    +                        case "integer":
    128 
    +                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2");
    129 
    +                            break;
    130 
    +                        case "string":
    131 
    +                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3");
    132 
    +                            break;
    133 
    +                        case "float1":
    134 
    +                            objectMaterial.setLabel5("fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1");
    135 
    +                            break;
    136 
    +
    137 
    +                    }
    138 
    +                }
    139 
    +                String status = objectMaterial.getLabel6();
    140 
    +                objectMaterial.setLabel6(null);
    141 
    +                Boolean statusB = status == null ? null : Boolean.valueOf(status);
    142 
    +                objectMaterial.setStatus(statusB != null && statusB ? ReferenceStatus.enabled : ReferenceStatus.disabled);
    143 
    +                result.put(objectMaterial.getCode(), objectMaterial);
    144 
    +            });
    145 
    +        }
    146 
    +        ImmutableMap<String, ObjectMaterial> map = result.build();
    147 
    +        for (ObjectMaterial objectMaterial : map.values()) {
    148 
    +            String parentCode = objectMaterial.getLabel4();
    149 
    +            objectMaterial.setLabel4(null);
    150 
    +            if (parentCode != null) {
    151 
    +                ObjectMaterial parent = map.get(parentCode);
    152 
    +                objectMaterial.setParent(parent);
    153 
    +            }
    154 
    +        }
    155 
    +        return map.values();
    156 
    +    }
    157 
    +
    158 
    +    private static class ImportModel extends AbstractImportModel<ObjectMaterial> {
    159 
    +
    160 
    +        ImportModel() {
    161 
    +            super(',');
    162 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_CODE);
    163 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_LEGACY_CODE);
    164 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_STANDARD_CODE);
    165 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_BIODEGRADABLE, Common.PRIMITIVE_BOOLEAN);
    166 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_NON_ENTANGLING, Common.PRIMITIVE_BOOLEAN);
    167 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_SELECTABLE, Common.PRIMITIVE_BOOLEAN);
    168 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_CHILD_SELECTION_MANDATORY, Common.PRIMITIVE_BOOLEAN);
    169 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_CHILDREN_MULTI_SELECTABLE, Common.PRIMITIVE_BOOLEAN);
    170 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_LABEL1);
    171 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_LABEL2);
    172 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_LABEL3);
    173 
    +            newMandatoryColumn(ObjectMaterial.PROPERTY_VALIDATION);
    174 
    +            newMandatoryColumn("parent", ObjectMaterial.PROPERTY_LABEL4);
    175 
    +            newMandatoryColumn("dataType", ObjectMaterial.PROPERTY_LABEL5);
    176 
    +            newMandatoryColumn("status", ObjectMaterial.PROPERTY_LABEL6);
    177 
    +        }
    178 
    +
    179 
    +        @Override
    180 
    +        public ObjectMaterial newEmptyInstance() {
    181 
    +            return new ObjectMaterialImpl();
    182 
    +        }
    183 
    +    }
    184 
    +}

  • services-topia/src/main/java/fr/ird/observe/services/binder/referential/seine/ObjectMaterialBinder.java
    ... ... @@ -22,6 +22,7 @@ package fr.ird.observe.services.binder.referential.seine;
    22 22 
      * #L%
    23 23 
      */
    24 24
    25 
    +import fr.ird.observe.entities.referentiel.I18nReferentialEntity;
    25 26 
     import fr.ird.observe.entities.referentiel.seine.ObjectMaterial;
    26 27 
     import fr.ird.observe.entities.referentiel.seine.ObjectMaterialType;
    27 28 
     import fr.ird.observe.services.binder.referential.ReferentialBinderSupport;
    ... ... @@ -80,7 +81,7 @@ public class ObjectMaterialBinder extends ReferentialBinderSupport<ObjectMateria
    80 81 
             return toReferentialReference(entity,
    81 82 
                                           entity.getCode(), getLabel(referentialLocale, entity),
    82 83 
                                           Optional.ofNullable(entity.getParent()).map(ObjectMaterial::getTopiaId).orElse(null),
    83 
    -                                      entity.getObjectMaterialType().getTopiaId(),
    84 
    +                                      Optional.ofNullable(entity.getObjectMaterialType()).map(I18nReferentialEntity::getTopiaId).orElse(null),
    84 85 
                                           entity.getValidation());
    85 86
    86 87 
         }

  • services-topia/src/test/java/fr/ird/observe/services/topia/service/actions/validate/ValidateServiceTopiaTest.java
    ... ... @@ -199,7 +199,7 @@ public class ValidateServiceTopiaTest extends AbstractServiceTopiaTest {
    199 199 
             assertValidateResultForReferentialDtoType(resultByType, ObjectOperationDto.class, 10);
    200 200 
             assertValidateResultForReferentialDtoType(resultByType, ObjectTypeDto.class, 23);
    201 201 
             assertValidateResultForReferentialDtoType(resultByType, ObjectMaterialTypeDto.class, 4);
    202 
    -        assertValidateResultForReferentialDtoType(resultByType, ObjectMaterialDto.class, 43);
    202 
    +        assertValidateResultForReferentialDtoType(resultByType, ObjectMaterialDto.class, 86);
    203 203 
             assertValidateResultForReferentialDtoType(resultByType, ObservedSystemDto.class, 21);
    204 204 
             assertValidateResultForReferentialDtoType(resultByType, ReasonForDiscardDto.class, 5);
    205 205 
             assertValidateResultForReferentialDtoType(resultByType, ReasonForNoFishingDto.class, 13);

  • services-topia/src/test/java/fr/ird/observe/services/topia/service/data/seine/FloatingObjectServiceTopiaTest.java
    ... ... @@ -52,7 +52,7 @@ public class FloatingObjectServiceTopiaTest extends AbstractServiceTopiaTest {
    52 52
    53 53 
             List<ObjectMaterialHierarchyDto> form = service.getObjectMaterialHierarchy();
    54 54 
             Assert.assertNotNull(form);
    55 
    -        Assert.assertEquals(3, form.size());
    55 
    +        Assert.assertEquals(4, form.size());
    56 56
    57 57 
         }
    58 58

  • test/src/main/java/fr/ird/observe/test/ObserveFixtures.java
    ... ... @@ -101,7 +101,7 @@ public class ObserveFixtures {
    101 101 
                 .<String, Long>builder()
    102 102 
                 .put("observe_seine.detectionmode", 11L)
    103 103 
                 .put("observe_seine.objectoperation", 10L)
    104 
    -            .put("observe_seine.objectmaterial", 43L)
    104 
    +            .put("observe_seine.objectmaterial", 86L)
    105 105 
                 .put("observe_seine.objectmaterialtype", 4L)
    106 106 
                 .put("observe_seine.objecttype", 27L)
    107 107 
                 .put("observe_seine.observedsystem", 21L)

  • test/src/main/resources/db/6.901/dataForTestLongline.sql.gz
    No preview for this file type
  • test/src/main/resources/db/6.901/dataForTestSeine.sql.gz
    No preview for this file type
  • test/src/main/resources/db/6.901/empty_h2.sql.gz
    No preview for this file type
  • test/src/main/resources/db/6.901/empty_pg.sql.gz
    No preview for this file type
  • test/src/main/resources/db/6.901/referentiel.sql.gz
    No preview for this file type

    • —
    View it on GitLab.
    You're receiving this email because of your account on gitlab.com. If you'd like to receive fewer emails, you can adjust your notification settings.