1. 21 Jan, 2022 1 commit
  2. 09 Dec, 2021 1 commit
  3. 20 Jul, 2021 2 commits
  4. 19 Jul, 2021 2 commits
    • Christine Plumejeaud's avatar
      fixed the computing of pointcall_rankfull (take now into account the... · ed8065d5
      Christine Plumejeaud authored
      fixed the computing of pointcall_rankfull (take now into account the source_doc_id to sort pointcall by dates)
      fixed the computing of built_travels accordingly
      fixed raw_flows to integrate the sort
      ORDER by coalesce(d.ship_id, d.source_doc_id), d.pointcall_rankfull
      fixed debug_travels to build travels (no more checks on different source_doc_id)
      
      update navigoviz.pointcall p set pointcall_rankfull = k.pointcall_rankfull, date_fixed= k.date_dates
                  from (
                      select ROW_NUMBER () OVER (PARTITION BY ship_id  ORDER by source_doc_id, COALESCE(pointcall_out_date, pointcall_in_date )) as pointcall_rankfull, p.pkid,
                      p.source_doc_id,  p.ship_id, pointcall_out_date, pointcall_in_date, coalesce(p.outdate_fixed, p.indate_fixed) as date_dates
                      from navigoviz.pointcall p
                      order by p.ship_id
                  ) as k where p.pkid = k.pkid
      ed8065d5
    • Christine Plumejeaud's avatar
      add new attributes ferme_direction_uncertainty and cargo_item_action Add the... · d73f8929
      Christine Plumejeaud authored
      add new attributes ferme_direction_uncertainty and cargo_item_action Add the raw_flows table for api rawflows. Changed al lot the way of computing of indate_fixed and outdate_fixed
      d73f8929
  5. 06 Apr, 2021 3 commits
    • Christine Plumejeaud's avatar
      bonne url à utiliser pour le fichier CSV qui autodocumente les tables et les... · 91b1373d
      Christine Plumejeaud authored
      bonne url à utiliser pour le fichier CSV qui autodocumente les tables et les attributs de la base de données en ligne (API), et aide à générer l'application apidemo.portic.fr
      91b1373d
    • Christine Plumejeaud's avatar
      version of database. The full file is not the server side. In... · 966ad2bd
      Christine Plumejeaud authored
      version of database. The full file is not the server side. In /home/plumegeo/navigo/ETL/data_05avril2021
      /home/plumegeo/navigo/ETL/data_25janvier2021
      966ad2bd
    • Christine Plumejeaud's avatar
      Add new attributes to API : · 223a89bc
      Christine Plumejeaud authored
      for ports, pointcalls and travels, we filled data about congés that were in database or available according to historical sources.
      conges_1787_inputdone
      conges_1789_inputdone
      incertitude_status
      nb_conges_1787_inputdone
      Nb_conges_1787_CR
      Nb_sante_1787
      Nb_petitcabotage_1787
      nb_conges_1789_inputdone
      Nb_conges_1789_CR
      Nb_sante_1789
      Nb_petitcabotage_1789
      for pointcalls and travels we added some attributes used for determination of ship's flags, and their uncertainity level, and the uncertainity level for the shipclass.
      birthplace_uhgs_id
      birthplace_uncertainity
      birthplace_uhgs_id_uncertainity
      citizenship_uncertainity
      shipclass_uncertainity
      for pointcalls and travels , we added information about 5 taxes per document (at max) :
      taxe_concept was renamed taxe_concept1
      q01, q02, q03 were renamed q01_1, q02_1, q03_1
      Added the total paid with taxe_amount[01, 02, 03, 04, 05]
      taxe_amount01
      tax_concept2
      q01_2
      q02_2
      q03_2
      taxe_amount02
      tax_concept3
      q01_3
      q02_3
      q03_3
      taxe_amount03
      tax_concept4
      q01_4
      q02_4
      q03_4
      taxe_amount04
      tax_concept2
      q01_2
      q02_2
      q03_2
      taxe_amount02
      
      et removed 2 :
      source_1787_available
      source_1789_available
      that were confusing.
      
      Silvia has checked manually inputs made 2 years ago by Christian about the status of the ports, and many has_a_clerk, obliques, and pointcall_status were changed accordingly. Also, pointcall_status_uncertainity exists, to inform about doubts about the status (oblique, siège amirauté, or nothing) BUT it is not fully filled for the moment.
      223a89bc
  6. 08 Mar, 2021 2 commits
  7. 05 Mar, 2021 3 commits
  8. 04 Mar, 2021 2 commits
  9. 16 Feb, 2021 2 commits
  10. 15 Feb, 2021 2 commits
  11. 02 Nov, 2020 1 commit
  12. 07 Aug, 2020 1 commit
  13. 31 Jul, 2020 1 commit
  14. 16 Jul, 2020 3 commits
  15. 06 Jun, 2020 7 commits
  16. 25 May, 2020 1 commit
  17. 21 May, 2020 1 commit
  18. 20 May, 2020 3 commits
  19. 19 May, 2020 2 commits