HTML Form

Link

http://fdnw.dyndns.org/datawise/dataAPISQL/howto.php

Query method Parameters

Choose format type

Date Range - Number of days back (integer) or timeframe (yyyy-mm-dd hh:mm:ss) to gather data
Select Category Type or Sensor ID
Click Submit to get data

Direct URL

Link

/dataAPI/catdata.php?format=___&bytype___&cid=___&days=___

Examples

/dataAPI/retrievedata.php?format=cvs&bytype=category&cid=1&bydate=back&days=31
/dataAPI/retrievedata.php?format=xml&bytype=sensor&sid=100&bydate=back&days=3
/dataAPI/retrievedata.php?format=json&bytype=sensor&sid=100&bydate=range&tstart=2016-01-28 20:01:00&tend=2016-05-30 20:01:00

Description

parameter	type	default	description
`format`	string	tsv	Specify the output format. `format=tsv` `format=csv` `format=xml` `format=html` `format=json`
`bydate`	string	back	Choose a way to limit the data by date `bydate=back` Number of days back to gather data. Need to set accompanying 'days=' param `bydate=range` Limit data between two dates. Need to set the start/end dates with 'tstart=' & 'tend=' params
`days`	integer	1	Limit number of days to include before the current time. Needed with param bydate=back
`tstart` `tend`	date-time	null	Limit to data on or after the specified start time and on or before the specified end time. Needed with parpm bydate=range. `tstart=yyyy-mm-dd hh:mm:ss&tend=yyyy-mm-dd hh:mm:ss`
`bytype`	string	null	Select the how to identify records. The allowed values are: `bytype=category` Use the category ID to get data over multiple sensors. Set with 'cid=' param. `bytype=sensor` Use to select a single sensor. Set with 'sid=' param.
`cid`	integer	null	Select the specific category ID. Needs 'bytype=category' param
`sid`	integer	null	Select the specific sensor ID to collect data. Needs 'bytype=sensor'.

List of Categories

Types

Tide
Air Temperature
Precip
Wind Speed
Wind Direction
Humidity
Pressure
Solar Radiation
Battery
Wind Chill

Tide
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1005	North Wildwood Tide	39.007468	-74.79874	1

Air Temperature
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1004	North Wildwood Air Temp	39.0055	-74.795	9

Precip
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1001	North Wildwood Precip	39.01	-74.798455	2

Wind Speed
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1002	North Wildwood Wind Speed	39.01	-74.795	7

Wind Direction
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1003	North Wildwood Wind Direction	39.007351	-74.795	8

Humidity
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1006	North Wildwood Humidity	39.0055	-74.8025	5

Pressure
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1007	North Wildwood Barometer	39.007351	-74.8025	6

Solar Radiation
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1008	North Wildwood Solar	39.01	-74.8025	14

Battery
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1009	North Wildwood Batttery	39.0135	-74.798455	12

Wind Chill
Sensor ID	Sensor Name	Latitude	Longitude	SensorType
1010	North Wildwood Wind Chill	39.0055	-74.798455	18
11010	North Wildwood Computed Wind Chill	39.0055	-74.798455	18