Some (un)useful statistics

For each link below, you can add (or remove) from the url provided, these parameters

Parameters:

?dal=01/01/2005&oceano=5&type=SVP&status=D

• dal: from this date (sql: deployment_time>= DATE)
• al: to this date (sql: deployment_time<=DATE)
• oceano: identifiy the sea from this table:
  • 2 Oceano Atlantico
  • 5 Mar Mediterraneo
  • 18 Mar Nero
  • 19 Zona Antartica
• depth (drogue length) (sql: depth=DOUBLE)
  • 0
  • 15
  • ...
• type (generic)

  • Drifter	Float	Glider
    A106/A111 CARTHE CMOD CODE DWS OTHER SVP WHOI	Apex Arvor-A Arvor-A3 Arvor-C Arvor-D Arvor DO Arvor-I Arvor-I-DO Arvor-I-ICE Arvor-L Arvor-N Dova Nemo Nemo DO Nova Provor Provor Bio Provor DO Provor III Provor Nut	Deep Slocum Seaglider Shallow Slocum

• country_www

  • Drifter	Float	Glider
    AEGEAN 2002-200 ALBOREX ALTIFLOAT BLACK SEA 1999- boa Fabio CALYPSO CINEL COCES COCONET CYPRUS DART 2006-2007 DOLCEVITA 2001- EGITTO 2005-200 EXPLORA IFREMER IMEDEA-SOCIB IONIAN IRENE ITALY LATEX2008 LATEX2009 LATEX2010 LAURA_BASSI LIDEX10 LOGMEC MEDESS MEDITERRANEAN 1 MELMAS MERSEA MIAMI MILONGA MOMA MORSEA MREA07-LASIE07 MREA08 NEMED NOMR12 NORTH ADRIATIC EXP 2015 NURC2011 OTHER PEACETIME PERLE REP11 REP14 RITMARE SEAKEEPERS SOUTHERN OCEAN STRING TEST TOSCA TOSCAno TRANSMED18 TSS (2008-2009) TYRRHENIAN 2001 UNITUS	BULGARIA CHINA EURO FRANCE GERMANY GREECE ITALY LEBANON MFSTEP SPAIN TURKEY USA	ITALY

• status (A or D)

Eg:

URL?dal=01/01/2005&oceano=5&type=SVP&status=D

URL?dal=01/01/2005&al=31/12/2020&oceano=5&depth=15&type=SVP

URL?dal=01/01/2005&oceano=5&type=SVP

URL?dal=01/01/2005&oceano=5&type=CODE

URL?dal=01/01/2005&oceano=5&type=SVP&status=D

URL?dal=01/01/2005&oceano=19&type=SVP&status=D

URL?type=CODE&status=D

URL?type=CARTHE&status=D

Drifter:

How many per year (con redeploy/split)

How many fisical no redeploy count (per year)

How many type per year

Drifter positioning system deployed per year

Pos system per year

https://argo.ogs.it/stat/drifter_stat6.php?dal=01/01/2005&al=31/12/2020&oceano=5
telemetry
SELECT Count(d.id_drifter) AS quanti, t.tipo_det
FROM tbl_drifter as d LEFT JOIN tbl_telemetry as t ON d.id_telemetry = t.id_telemetry
GROUP BY d.daelaborare, t.tipo_det
HAVING d.daelaborare=TRUE;

Drifter telemetry per year

https://argo.ogs.it/stat/float_stat2.php?&oceano=19
quantita' float per anno

Tipi di grafico:
https://www.highcharts.com/demo/column-stacked
https://www.highcharts.com/demo/column-stacked-and-grouped

https://argo.ogs.it/stat/drifter_stat1.php
https://argo.ogs.it/stat/drifter_stat2.php
https://argo.ogs.it/stat/drifter_stat3.php

- positioning systems (Argos, gps....);
- telemetry
- svp drogue depth
- life time after deployment;