The "tabledata" web service provides meta data about a tabular dataset.
A typical URL is: http://myserver.mycompany.com:8080/INTGeoServer/json/tabledata?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":146
}
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