GitLab

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

and 2 were DELETED :
source_1787_available
source_1789_available
because they 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.

# Conflicts:
#	porticapi/static/data/api_portic.csv

UTF-8

'Filled with ''A'' when the pointcall line (not all entries of the same documentary_unit_id) in FileMaker has been manually checked against the content of the source (source_doc_id). A programm must be called after to propagate corrections from lines with A to other of the same documentary_unit_id. Not yet done in FileMaker. The main cause of inconsistencies in FileMaker database are due to this missing program for propagation of fixes to other entries of the same documentary_unit_id (source_doc_id).'

Fixed shornames of columns. May happen very often. This file is used by demonstrator.portic.fr to provide examples and fields description

ports api is filled

Fixed a bug in the API : only previous or next pointcalls in a route of a ship were fetch in flow requests. This was a mistake in the code. Fixed.

/api/ports/
Add also substates for ports in the response.

Deleted alphaportic/public/assets/fonts/datta/fonts/pct.eot, alphaportic/public/assets/fonts/datta/fonts/pct.svg, alphaportic/public/assets/fonts/datta/fonts/pct.ttf, alphaportic/public/assets/fonts/datta/fonts/pct.woff, alphaportic/public/assets/fonts/datta/datta-icons.css, alphaportic/public/assets/fonts/feather/fonts/feather.eot, alphaportic/public/assets/fonts/feather/fonts/feather.svg, alphaportic/public/assets/fonts/feather/fonts/feather.ttf, alphaportic/public/assets/fonts/feather/fonts/feather.woff, alphaportic/public/assets/fonts/feather/icon-font.css, alphaportic/public/favicon.ico, alphaportic/public/index.html, alphaportic/public/manifest.json, alphaportic/src/App/colors/dict_colors.js, alphaportic/src/App/components/MainCard.js, alphaportic/src/App/components/UcFirst.js, alphaportic/src/App/layout/AdminLayout/Breadcrumb/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavLeft/NavSearch/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavLeft/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/Friends/Chat/Messages/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/Friends/Chat/chat.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/Friends/Chat/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/Friends/Friend/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/Friends/friends.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/Friends/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/ChatList/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/NavRight/index.js, alphaportic/src/App/layout/AdminLayout/NavBar/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/NavBadge/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/NavCollapse/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/NavGroup/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/NavIcon/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/NavItem/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/NavSearch/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavContent/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/NavLogo/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/OutsideClick/index.js, alphaportic/src/App/layout/AdminLayout/Navigation/OneDrive - Raccourci.lnk, alphaportic/src/App/layout/AdminLayout/Navigation/index.js, alphaportic/src/App/layout/AdminLayout/app.scss, alphaportic/src/App/layout/AdminLayout/index.js, alphaportic/src/App/layout/Loader/index.js, alphaportic/src/App/layout/ScrollToTop/index.js, alphaportic/src/App/translations/labels_i18n_en.json, alphaportic/src/App/translations/labels_i18n_fr.json, alphaportic/src/App/i18n.js, alphaportic/src/App/index.js, alphaportic/src/Components/Graphic/BarChart.js, alphaportic/src/Components/Graphic/BoxPlotChart-flow.js, alphaportic/src/Components/Graphic/BoxPlotChart.js, alphaportic/src/Components/Graphic/LightenDarkenColor.js, alphaportic/src/Components/Graphic/MultiBarChart-flow.js, alphaportic/src/Components/Graphic/MultiBarChart.js, alphaportic/src/Components/Graphic/RadarPlot.js, alphaportic/src/Components/Graphic/RadarPlot2.js, alphaportic/src/Components/Graphic/Tab.js, alphaportic/src/Components/Graphic/Tabs.js, alphaportic/src/Components/Graphic/VPlot.js, alphaportic/src/Components/Graphic/ViolinPlot-old.js, alphaportic/src/Components/Graphic/ViolinPlot.js, alphaportic/src/Components/Graphic/distroChart.css, alphaportic/src/Components/Graphic/distroPlot.js, alphaportic/src/Components/Graphic/distroPlotChart.js, alphaportic/src/Components/Graphic/distrochart.js, alphaportic/src/Components/Graphic/donneesnavigo.csv, alphaportic/src/Components/Graphic/enattendant.js, alphaportic/src/Components/Graphic/nv.d3.css, alphaportic/src/Components/Graphic/pointcall_20200427.txt, alphaportic/src/Components/Graphic/pointcalls_API_11mai2020.csv, alphaportic/src/Components/Graphic/pointcalls_API_11mai2020.txt, alphaportic/src/Components/Graphic/radarCharts.js, alphaportic/src/Components/Graphic/tabstyle.css, alphaportic/src/Components/Graphic/travels_API_11mai2020.txt, alphaportic/src/Components/OL/data/monde.geojson, alphaportic/src/Components/OL/data/new_for_portic_31mars2020.geojson, alphaportic/src/Components/OL/data/port_points_06avril2020.geojson, alphaportic/src/Components/OL/data/ports26mars2020.geojson, alphaportic/src/Components/OL/data/ports26mars2020.json, alphaportic/src/Components/OL/data/trait_cote.geojson, alphaportic/src/Components/OL/Collapsible.scss, alphaportic/src/Components/OL/layerswitcher-flows.js, alphaportic/src/Components/OL/layerswitcher.css, alphaportic/src/Components/OL/layerswitcher.js, alphaportic/src/Components/OL/ol-layerswitcher.css, alphaportic/src/Components/OL/updateTravelSet.js, alphaportic/src/Components/Page/Docs.js, alphaportic/src/Components/Page/FlowGraph.js, alphaportic/src/Components/Page/PointGraph.js, alphaportic/src/Components/Page/distrochart.css, alphaportic/src/Components/Page/tabstyle.css, alphaportic/src/assets/images/user/avatar-1.jpg, alphaportic/src/assets/images/user/avatar-2.jpg, alphaportic/src/assets/images/user/avatar-3.jpg, alphaportic/src/assets/images/user/avatar-4.jpg, alphaportic/src/assets/images/user/avatar-5.jpg, alphaportic/src/assets/images/user/lock.png, alphaportic/src/assets/images/user/user-1.png, alphaportic/src/assets/images/user/user-2.png, alphaportic/src/assets/images/user/user.png, alphaportic/src/assets/images/widget/dashborad-1.jpg, alphaportic/src/assets/images/widget/dashborad-2.jpg, alphaportic/src/assets/images/widget/dashborad-3.jpg, alphaportic/src/assets/images/widget/dashborad-4.jpg, alphaportic/src/assets/images/widget/dashborad-5.jpg, alphaportic/src/assets/images/widget/emoticon.jpg, alphaportic/src/assets/images/widget/master-background.png, alphaportic/src/assets/images/widget/master-logo.png, alphaportic/src/assets/images/widget/rupay-background.png, alphaportic/src/assets/images/widget/rupay-logo.png, alphaportic/src/assets/images/widget/shape1.png, alphaportic/src/assets/images/widget/shape2.png, alphaportic/src/assets/images/widget/shape3.png, alphaportic/src/assets/images/widget/shape4.png, alphaportic/src/assets/images/widget/shape5.png, alphaportic/src/assets/images/widget/shape6.png, alphaportic/src/assets/images/widget/visa-background.png, alphaportic/src/assets/images/widget/visa-logo.png, alphaportic/src/assets/images/complete.png, alphaportic/src/assets/images/favicon.ico, alphaportic/src/assets/images/logo-dark.png, alphaportic/src/assets/images/logo.png, alphaportic/src/assets/scss/partials/menu/_menu-lite.scss, alphaportic/src/assets/scss/partials/mixins/_alert.scss, alphaportic/src/assets/scss/partials/mixins/_buttons.scss, alphaportic/src/assets/scss/partials/mixins/_function.scss, alphaportic/src/assets/scss/partials/mixins/_pagination.scss, alphaportic/src/assets/scss/partials/other/_chart.scss, alphaportic/src/assets/scss/partials/other/_chat.scss, alphaportic/src/assets/scss/partials/other/_icon-lauouts.scss, alphaportic/src/assets/scss/partials/other/_prism.scss, alphaportic/src/assets/scss/partials/other/_switches.scss, alphaportic/src/assets/scss/partials/pages/gallery.scss, alphaportic/src/assets/scss/partials/theme-elements/_alert.scss, alphaportic/src/assets/scss/partials/theme-elements/_authentication.scss, alphaportic/src/assets/scss/partials/theme-elements/_breadcrumb-pagination.scss, alphaportic/src/assets/scss/partials/theme-elements/_button.scss, alphaportic/src/assets/scss/partials/theme-elements/_data-tables.scss, alphaportic/src/assets/scss/partials/theme-elements/_form.scss, alphaportic/src/assets/scss/partials/theme-elements/_labels-badges.scss, alphaportic/src/assets/scss/partials/theme-elements/_modal.scss, alphaportic/src/assets/scss/partials/theme-elements/_nav.scss, alphaportic/src/assets/scss/partials/theme-elements/_popover.scss, alphaportic/src/assets/scss/partials/theme-elements/_progress.scss, alphaportic/src/assets/scss/partials/theme-elements/_radiobox-checkbox.scss, alphaportic/src/assets/scss/partials/theme-elements/_tooltip.scss, alphaportic/src/assets/scss/partials/third-party/react-bootstrap/_header.scss, alphaportic/src/assets/scss/partials/third-party/react-bootstrap/react-bootstrap.scss, alphaportic/src/assets/scss/partials/third-party/_css-animator.scss, alphaportic/src/assets/scss/partials/third-party/_google-map.scss, alphaportic/src/assets/scss/partials/third-party/_ngx-perfect-scrollbar.scss, alphaportic/src/assets/scss/partials/third-party/_react-full-screen.scss, alphaportic/src/assets/scss/partials/third-party/_third-party.scss, alphaportic/src/assets/scss/partials/widget/_widget.scss, alphaportic/src/assets/scss/partials/_general.scss, alphaportic/src/assets/scss/partials/_generic.scss, alphaportic/src/assets/scss/partials/_mixins.scss, alphaportic/src/assets/scss/partials/_variables.scss, alphaportic/src/assets/scss/partials/logo_portic_carla.png, alphaportic/src/assets/scss/style.scss, alphaportic/src/hoc/_Aux/index.js, alphaportic/src/store/actions.js, alphaportic/src/store/constant.js, alphaportic/src/store/reducer.js, alphaportic/src/config.js, alphaportic/src/exportdata.js, alphaportic/src/index.js, alphaportic/src/menu-items.js, alphaportic/src/route.js, alphaportic/src/routes.js, alphaportic/src/serviceWorker.js, alphaportic/HOWTO.md, alphaportic/README.md, alphaportic/package-lock.json, alphaportic/package.json, alphaportic/webpack.config.js files

Deleted alphaportic/public/assets/fonts/datta/fonts/pct.eot, alphaportic/public/assets/fonts/datta/fonts/pct.svg, alphaportic/public/assets/fonts/datta/fonts/pct.ttf, alphaportic/public/assets/fonts/datta/fonts/pct.woff, alphaportic/public/assets/fonts/datta/datta-icons.css, alphaportic/public/assets/fonts/feather/fonts/feather.eot, alphaportic/public/assets/fonts/feather/fonts/feather.svg, alphaportic/public/assets/fonts/feather/fonts/feather.ttf, alphaportic/public/assets/fonts/feather/fonts/feather.woff, alphaportic/public/assets/fonts/feather/icon-font.css, alphaportic/public/favicon.ico, alphaportic/public/index.html, alphaportic/public/manifest.json files

Documentation is also inside the readme

Documentation is also inside the readme

Using postgres, portic_v3 with the user api_user, password = 'portic'. READ only user.

Using postgres, portic_v3 with the user api_user, password = 'portic'. READ only user.

fielnames : return the metadata of the API. Removed a bug that occurs when params contains an element not in the attributes of the database.

Still the postgres requests to add (will be done)
Locally tested with various params, reading from CSV file.

First code of api, without the postgres backend for the moment. It will come soon. Many ideas to test to enhance performance.

ETL for building an API publishing navigo data : pointcalls and travels.

ETL for building an API publishing navigo data : pointcalls and travels.