Fixed a bug on trim of name to have the various truely distinct names of ships or captain.
Added new comments on tables of the API.

added list of ship_id or captain_id to captain or ship description, with min and max date and the number of documents where they are mentioned.

Detailled the process to build travels with net_route_marker well checked.

Few changes for ports to export all ports, including homeports that are not in pointcalls and to send back a geojson file that can be used directly for web mapping in EPSG 4326.

Départ au long cours/Clearances (to America and Indian ocean)
qui correspond à la source Expéditions coloniales Marseille (1789)
(119 entrées en 1789)

when a port is totally missing, or has CR filled only for one source, but has no data input_done (thus no pointcalls), a line will be returned describing its position and nomenclature anyway, but filled with null for missing attributes.
Corresponding SQL documentation si version 3
Changed also wsgi script to match the new structure of porticapi folder.
Tested on prod. OK.

New path /api/test/ qui permet de vérifier la version de PANDAS et PYTHON exécutée par Apache (il faut recompiler WSGI avec la version de python 3.7 et dans cette version de python 3.7 il faut installer les packages requis)
- voir : https://github.com/GrahamDumpleton/mod_wsgi/releases
wget https://github.com/GrahamDumpleton/mod_wsgi/archive/4.7.1.tar.gz
tar xvfz 4.7.1
cd mod_wsgi-4.7.1
./configure --with-python=/usr/bin/python3.7
make
sudo make install

Installer les package python pour apache2 dans python3.7
	/usr/bin/python3.7 –version
	/usr/bin/python3.7 -m pip install pandas==1.3.4
	sudo –H /usr/bin/python3.7 -m pip install -r path2/porticapi/requirements.txt

Sinon, l'API marche en prod : pour tester, http://data.portic.fr/api/sources/?srid=4326&date=1789

Cette version prépare le tag v1.1 qui va suivre et qui permettra de récupérer les points où aucun CR ni inputdone n'existe (et source vaut alors null) + les flags.

new api rawflows to get all flows. Will be deployed on 19/07/2021 afternoon. New comments for columns are set in the git in static/data

new attributes : ferme_direction_uncertainity, cargo_item_action, and documentation of outdate_fixed, indate_fixed

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