ERDDAP > tabledap > Data Access Form

Dataset Title:	INSTAC - Collection of Phosphate (PO4-P) (PHOW) Profiles - IN SITU MultiPointProfilesObservation
Institution:	INSTAC   (Dataset ID: PR_PHOW_INSTAC)
Information:	Summary | License | FGDC | ISO 19115 | Metadata | Background | Subset | Files | Make a graph

 

Variable	Optional Constraint #1		Optional Constraint #2		Minimum    or a List of Values	Maximum
PLATFORMCODE (EMODnet Platform Code)	!= =~ <= >= = < >		!= =~ <= >= = < >		"FNFP" "TFEA"
SOURCE	!= =~ <= >= = < >		!= =~ <= >= = < >		"instac"
SENSOR (Platform Sensor)	!= =~ <= >= = < >		!= =~ <= >= = < >		""	""
time (Valid Time GMT, UTC)	!= =~ <= >= = < >		!= =~ <= >= = < >		2018-06-16T19:30:00Z	2021-02-16T04:31:00Z
TIME_QC (TIME quality flag, 1)	!= =~ <= >= = < >		!= =~ <= >= = < >		1	1
depth (m)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.0	5337.2998046875
DEPTH_QC (DEPTH quality flag, 1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-127	1
latitude (degrees_north)	!= =~ <= >= = < >		!= =~ <= >= = < >		40.33182907104492	64.33480072021484
longitude (degrees_east)	!= =~ <= >= = < >		!= =~ <= >= = < >		-43.07316970825195	-9.460169792175293
POSITION_QC (POSITION quality flag, 1)	!= =~ <= >= = < >		!= =~ <= >= = < >		1	1
PHOW (Phosphate (PO4-P), mmole/kg)	!= =~ <= >= = < >		!= =~ <= >= = < >		0.009999999776482582	1.5099999904632568
PHOW_QC (PHOW quality flag, 1)	!= =~ <= >= = < >		!= =~ <= >= = < >		-127	4
PHOW_DM	!= =~ <= >= = < >		!= =~ <= >= = < >
url_metadata (Metadata Link)	!= =~ <= >= = < >		!= =~ <= >= = < >		"https://er2webapps..."	"https://er2webapps..."
qc_entity	!= =~ <= >= = < >		!= =~ <= >= = < >		14	14

 

Server-side Functions

distinct()

orderBy orderByDescending orderByClosest orderByCount orderByLimit orderByMax orderByMin orderByMinMax orderByMean orderBySum (" PLATFORMCODE SOURCE SENSOR time TIME_QC depth DEPTH_QC latitude longitude POSITION_QC PHOW PHOW_QC PHOW_DM url_metadata qc_entity PLATFORMCODE SOURCE SENSOR time TIME_QC depth DEPTH_QC latitude longitude POSITION_QC PHOW PHOW_QC PHOW_DM url_metadata qc_entity PLATFORMCODE SOURCE SENSOR time TIME_QC depth DEPTH_QC latitude longitude POSITION_QC PHOW PHOW_QC PHOW_DM url_metadata qc_entity PLATFORMCODE SOURCE SENSOR time TIME_QC depth DEPTH_QC latitude longitude POSITION_QC PHOW PHOW_QC PHOW_DM url_metadata qc_entity PLATFORMCODE SOURCE SENSOR time TIME_QC depth DEPTH_QC latitude longitude POSITION_QC PHOW PHOW_QC PHOW_DM url_metadata qc_entity ")

File type: (more information) .asc - View OPeNDAP-style ISO-8859-1 comma-separated text. .csv - Download a ISO-8859-1 comma-separated text table (line 1: names; line 2: units; ISO 8601 times). .csvp - Download a ISO-8859-1 .csv file with line 1: name (units). Times are ISO 8601 strings. .csv0 - Download a ISO-8859-1 .csv file without column names or units. Times are ISO 8601 strings. .dataTable - A JSON file formatted for use with the Google Visualization client library (Google Charts). .das - View the dataset's metadata via an ISO-8859-1 OPeNDAP Dataset Attribute Structure (DAS). .dds - View the dataset's structure via an ISO-8859-1 OPeNDAP Dataset Descriptor Structure (DDS). .dods - OPeNDAP clients use this to download the data in the DODS binary format. .esriCsv - Download a ISO_8859_1 .csv file for ESRI's ArcGIS 9.x and below (separate date and time columns). .fgdc - View the dataset's UTF-8 FGDC .xml metadata. .geoJson - Download longitude,latitude,otherColumns data as a UTF-8 GeoJSON .json file. .graph - View a Make A Graph web page. .help - View a web page with a description of tabledap. .html - View an OPeNDAP-style HTML Data Access Form. .htmlTable - View a UTF-8 .html web page with the data in a table. Times are ISO 8601 strings. .iso19115 - View the dataset's ISO 19115-2/19139 UTF-8 .xml metadata. .itx - Download an ISO-8859-1 Igor Text File. Each response column becomes a wave. .json - View a table-like UTF-8 JSON file (missing value = 'null'; times are ISO 8601 strings). .jsonlCSV1 - View a UTF-8 JSON Lines CSV file with column names on line 1 (mv = 'null'; times are ISO 8601 strings). .jsonlCSV - View a UTF-8 JSON Lines CSV file without column names (mv = 'null'; times are ISO 8601 strings). .jsonlKVP - View a UTF-8 JSON Lines file with Key:Value pairs (missing value = 'null'; times are ISO 8601 strings). .mat - Download a MATLAB binary file. .nc - Download a flat, table-like, NetCDF-3 binary file with COARDS/CF/ACDD metadata. .ncHeader - View the UTF-8 header (the metadata) for the NetCDF-3 .nc file. .ncCF - Download a NetCDF-3 CF Discrete Sampling Geometries file (Contiguous Ragged Array). .ncCFHeader - View the UTF-8 header (the metadata) for the .ncCF file. .ncCFMA - Download a NetCDF-3 CF Discrete Sampling Geometries file (Multidimensional Array). .ncCFMAHeader - View the UTF-8 header (the metadata) for the .ncCFMA file. .nccsv - Download a NetCDF-3-like 7-bit ASCII NCCSV .csv file with COARDS/CF/ACDD metadata. .nccsvMetadata - View the dataset's metadata as the top half of a 7-bit ASCII NCCSV .csv file. .ncoJson - Download a UTF-8 NCO lvl=2 JSON file with COARDS/CF/ACDD metadata. .odvTxt - Download longitude,latitude,time,otherColumns as an ISO-8859-1 ODV Generic Spreadsheet File (.txt). .parquet - Download as a parquet file. Metadata contains column names ("column_names") and units ("column_units"). .parquetWMeta - Download as a parquet file with detailed metadata. .subset - View an HTML form which uses faceted search to simplify picking subsets of the data. .tsv - Download a ISO-8859-1 tab-separated text table (line 1: names; line 2: units; ISO 8601 times). .tsvp - Download a ISO-8859-1 .tsv file with line 1: name (units). Times are ISO 8601 strings. .tsv0 - Download a ISO-8859-1 .tsv file without column names or units. Times are ISO 8601 strings. .wav - Download a .wav audio file. All columns must be numeric and of the same type. .xhtml - View a UTF-8 XHTML (XML) file with the data in a table. Times are ISO 8601 strings. .kml - View a .kml file, suitable for Google Earth. .smallPdf - View a small .pdf image file with a graph or map. .pdf - View a standard, medium-sized .pdf image file with a graph or map. .largePdf - View a large .pdf image file with a graph or map. .smallPng - View a small .png image file with a graph or map. .png - View a standard, medium-sized .png image file with a graph or map. .largePng - View a large .png image file with a graph or map. .transparentPng - View a .png image file (just the data, without axes, landmask, or legend).

(Documentation / Bypass this form )
 
Submit (Please be patient. It may take a while to get the data.)

 

---

The Dataset Attribute Structure (.das) for this Dataset

Attributes {
 s {
  PLATFORMCODE {
    String cf_role "profile_id";
    String long_name "EMODnet Platform Code";
  }
  SOURCE {
    String actual_range 
"instac
instac";
    String long_name "source";
  }
  SENSOR {
    String long_name "Platform Sensor";
  }
  time {
    String _CoordinateAxisType "Time";
    Float64 actual_range 1.5291774e+9, 1.61344986e+9;
    String axis "T";
    String calendar "Gregorian";
    String ioos_category "Time";
    String long_name "Valid Time GMT";
    String standard_name "time";
    String time_origin "01-JAN-1970 00:00:00";
    String units "seconds since 1970-01-01T00:00:00Z";
  }
  TIME_QC {
    Int16 _FillValue -32767;
    Int16 actual_range 1, 1;
    String flag_meanings "no_qc_performed good_data probably_good_data bad_data_that_are_potentially_correctable bad_data value_changed not_used nominal_value interpolated_value missing_value";
    String long_name "TIME quality flag";
    String standard_name "time";
    String units "1";
    Int16 valid_range 0, 9;
  }
  depth {
    String _CoordinateAxisType "Height";
    String _CoordinateZisPositive "down";
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range 0.0, 5337.2998046875;
    String axis "Z";
    String ioos_category "Location";
    String long_name "Depth";
    String positive "down";
    String standard_name "depth";
    String units "m";
  }
  DEPTH_QC {
    Int16 _FillValue -32767;
    Int16 actual_range -127, 1;
    String flag_meanings "no_qc_performed good_data probably_good_data bad_data_that_are_potentially_correctable bad_data value_changed not_used nominal_value interpolated_value missing_value";
    String long_name "DEPTH quality flag";
    String standard_name "depth";
    String units "1";
    Int16 valid_range 0, 9;
  }
  latitude {
    String _CoordinateAxisType "Lat";
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range 40.33182907104492, 64.33480072021484;
    String axis "Y";
    String ioos_category "Location";
    String latitude_reference_datum "geographical coordinates, WGS84 projection";
    String long_name "Latitude";
    String standard_name "latitude";
    String units "degrees_north";
    Float64 valid_max 90.0;
    Float64 valid_min -90.0;
  }
  longitude {
    String _CoordinateAxisType "Lon";
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range -43.07316970825195, -9.460169792175293;
    String axis "X";
    String ioos_category "Location";
    String latitude_reference_datum "geographical coordinates, WGS84 projection";
    String long_name "Longitude";
    String standard_name "longitude";
    String units "degrees_east";
    Float64 valid_max 180.0;
    Float64 valid_min -180.0;
  }
  POSITION_QC {
    Int16 _FillValue -32767;
    Int16 actual_range 1, 1;
    String flag_meanings "no_qc_performed good_data probably_good_data bad_data_that_are_potentially_correctable bad_data value_changed not_used nominal_value interpolated_value missing_value";
    String long_name "POSITION quality flag";
    String standard_name "latitude";
    String units "1";
    Int16 valid_range 0, 9;
  }
  PHOW {
    Float64 _FillValue 9.969209968386869e+36;
    Float64 actual_range 0.009999999776482582, 1.5099999904632568;
    String ep_parameter_group "Water conductivity/ BioGeoChemical";
    String long_name "Phosphate (PO4-P)";
    String sample_rate_comment "Hourly: 3600, Daily: 8.64e4, Monthly: 2.628e6, Yearly: 3.154e7";
    String sample_rate_units "seconds";
    String sdn "SDN:P01::MDMAP007";
    String source_variable_name "PHOW";
    String standard_name "moles_of_phosphate_per_unit_mass_in_sea_water";
    String units "mmole/kg";
  }
  PHOW_QC {
    Int16 _FillValue -32767;
    Int16 actual_range -127, 4;
    String flag_meanings "no_qc_performed good_data probably_good_data bad_data_that_are_potentially_correctable bad_data value_changed not_used nominal_value interpolated_value missing_value";
    String long_name "PHOW quality flag";
    String standard_name "phow";
    String units "1";
    Int16 valid_range 0, 9;
  }
  PHOW_DM {
    String actual_range 
"\u0000
\u0000";
    String flag_meanings "real-time provisional delayed-mode mixed";
    String flag_values "R, P, D, M";
    String long_name "PHOW method of data processing";
  }
  url_metadata {
    String long_name "Metadata Link";
  }
  qc_entity {
    Int32 actual_range 14, 14;
    String qc_reference_table "https://er2webapps.emodnet-physics.eu/erddap/tabledap/qc_reference_table.htmlTable";
  }
 }
  NC_GLOBAL {
    String cdm_data_type "Profile";
    String cdm_profile_variables "time,PLATFORMCODE";
    String citation "Data are the property of the producer/owner distributed through EMODnet Physics. EMODnet Physics and the partners are not responsible for improper use";
    String contact "contacts@emodnet-physics.eu";
    String Conventions "CF-1.6 OceanSITES-Manual-1.2 Copernicus-InSituTAC-SRD-1.3 Copernicus-InSituTAC-ParametersList-3.0.0, COARDS, ACDD-1.3";
    String creator_type "institution";
    Float64 Easternmost_Easting -9.460169792175293;
    String ep_parameter_group "Water conductivity/ BioGeoChemical";
    String featureType "Profile";
    String geometryType "Point";
    Float64 geospatial_lat_max 64.33480072021484;
    Float64 geospatial_lat_min 40.33182907104492;
    String geospatial_lat_units "degrees_north";
    Float64 geospatial_lon_max -9.460169792175293;
    Float64 geospatial_lon_min -43.07316970825195;
    String geospatial_lon_units "degrees_east";
    Float64 geospatial_vertical_max 5337.2998046875;
    Float64 geospatial_vertical_min 0.0;
    String geospatial_vertical_positive "down";
    String geospatial_vertical_units "m";
    String history 
"2025-04-30T10:25:50Z (local files)
2025-04-30T10:25:50Z http://er1webapps.emodnet-physics.eu/erddap/tabledap/PR_PHOW_INSTAC.html";
    String infoUrl "http://www.emodnet-physics.eu";
    String institution "INSTAC";
    String keywords "above, data, datum, depth, DEPTH_QC, earth, Earth Science > Oceans > Sea Surface Topography > Sea Surface Height, flag, height, latitude, local, longitude, method, ocean, oceans, PHOW, PHOW_DM, PHOW_QC, position, POSITION_QC, processing, quality, reference, science, sea, seawater, source, specific, surface, time, TIME_QC, topography, water, water_surface_height_above_reference_datum";
    String keywords_vocabulary "GCMD Science Keywords";
    String license "Creative Commons Attribution Share-Alike http://www.opendefinition.org/licenses/cc-by-sa";
    Float64 manual 1;
    String metadata_dataset "https://ercompwebapps.emodnet-physics.eu/erddap/tabledap/EP_PLATFORMS_METADATA.html";
    String metadata_document "https://ercompwebapps.emodnet-physics.eu/erddap/tabledap/EP_PLATFORMS_METADATA.csv?&parameters=~\".*'PHOW'.\"&integrator_id=\"instac\"";
    Float64 Northernmost_Northing 64.33480072021484;
    String platformType_dataFeatureType "profile";
    String platformType_description "Botte Samples";
    String platformType_trajectory "False";
    String publisher_type "institution";
    String qc_reference_table "https://er2webapps.emodnet-physics.eu/erddap/tabledap/qc_reference_table.html";
    String SDN "SDN:P01::MDMAP007";
    String sourceUrl "(local files)";
    Float64 Southernmost_Northing 40.33182907104492;
    String standard_name_vocabulary "CF Standard Name Table v70";
    String stato "A";
    String subsetVariables "PLATFORMCODE,SOURCE";
    String summary "INSTAC - Collection of Phosphate (PO4-P) (PHOW) Profiles - IN SITU MultiPointProfilesObservation";
    String testOutOfDate "now-7days";
    String time_coverage_end "2021-02-16T04:31:00Z";
    String time_coverage_start "2018-06-16T19:30:00Z";
    String title "INSTAC - Collection of Phosphate (PO4-P) (PHOW) Profiles - IN SITU MultiPointProfilesObservation";
    Float64 Westernmost_Easting -43.07316970825195;
  }
}

 

---

Using tabledap to Request Data and Graphs from Tabular Datasets

tabledap lets you request a data subset, a graph, or a map from a tabular dataset (for example, buoy data), via a specially formed URL. tabledap uses the OPeNDAP Data Access Protocol (DAP) and its selection constraints.

The URL specifies what you want: the dataset, a description of the graph or the subset of the data, and the file type for the response.

• (easy) You can get data by using the dataset's Data Access Form or Subset form. They make the URL for you.
• (easy) You can make a graph or map by using the dataset's Make A Graph form. It makes the URL for you.
• (not hard) You can bypass the forms and get the data or make a graph or map by generating the URL by hand or with a computer program or script.

Tabledap request URLs must be in the form
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/datasetID.fileType{?query}
For example,
https://coastwatch.pfeg.noaa.gov/erddap/tabledap/pmelTaoDySst.htmlTable?longitude,latitude,time,station,wmo_platform_code,T_25&time>=2015-05-23T12:00:00Z&time<=2015-05-31T12:00:00Z
Thus, the query is often a comma-separated list of desired variable names, followed by a collection of constraints (e.g., variable<value), each preceded by '&' (which is interpreted as "AND").

For details, see the tabledap Documentation.

 

---

ERDDAP, Version 2.25_1
Disclaimers | Privacy Policy | Contact