The "tablevalues" web service provides both the meta data and values of a tabular dataset.
A typical URL is: http://myserver.mycompany.com:8080/INTGeoServer/json/tablevalues?file=DEVT_table.csv
The following parameter is available:
file: the relative path of the specified dataset. This is a required parameter. If a path encoder is used, this path is encoded.
Here is an example response. This response has been formatted to improve readability
{
"name":"DEVT_table",
"columnNames":[
"COUNTRY",
"YEAR COMPLETED",
"OPERATORSHIP",
"REGION",
"WELL NAME",
"PROJECT NAME OR FIELD",
"LATITUDE",
"LONGITUDE",
"LATITUDE",
"LONGITUDE",
"WELL TOTAL DEPTH",
"WELL TYPE",
"BENCHMARK DDPTF",
"BENCHMARK WCPF",
"ACTUAL DDPTF",
"ACTUAL WCPF",
"ACTUAL DCPF",
"ACTUAL NPT% (WITH WOW)",
"DDPTF\nRATIO",
"WCPF\nRATIO",
"DDPTF RANK",
"WCPF RANK",
"PLAN TOTAL WELL DAYS",
"ACTUAL TOTAL WELL DAYS",
"SCHEDULE VARIANCE",
"SCHEDULE VARIANCE",
"PLAN WELL COST\n(USD)",
"SUPPLEMENTARY COST",
"ESTIMATED TOTAL WELL COST",
"COST VARIANCE",
"COST VARIANCE",
"SCHEDULE INDEX",
"COST\nINDEX",
"SCHEDULERANK",
"COST RANK",
"POSITION"
],
"columnUnits":[
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"m",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"Days",
"",
"%",
"",
"",
"USD",
"",
"%",
"",
"",
"",
"",
""
],
"rowCount":3,
"values":[
[
"XXXXX",
"2014",
"XXX",
"XX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XX",
"XX",
"XXXX",
"XXXX",
"XXXX",
"XXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XX",
"XX",
"X"
],
[
"XXXXX",
"2014",
"XXX",
"XX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XX",
"XX",
"XXXX",
"XXXX",
"XXXX",
"XXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XX",
"XX",
"X"
],
[
"XXXXX",
"2014",
"XXX",
"XX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XX",
"XX",
"XXXX",
"XXXX",
"XXXX",
"XXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XXXXXXX",
"XX",
"XX",
"X"
]
]
}
The name entry is the name of of the specified file without the extension.
The columnNames entry contains all of the column names contained in the dataset.
The columnUnits entry contains all of the units for each column. The order of these units matches the order of the column names.
The rowCount entry is the total number of records. This entry matches the number of arrays contained in the values entry.
The values entry contains all of the values in the dataset. It contains an array of arrays. Each of the sub array contains all of the values for a column. The order of the arrays matches the order of the column names.