Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var tabulatorCardHeader = document.getElementById('headingTable');
- tabulatorCardHeader.onclick = function() {
- app.statisticsTable.redraw(true);
- }
- //define attribute table
- app.statisticsTable = new Tabulator("#synterra-stats-table", { // UPDATE WHEN DEPLOYING
- data: tabledata,
- height: 450,
- layout: "fitDataFill",
- selectable: 1,
- placeholder: "No Features Available In Specified Area",
- pagination: "local",
- paginationSize: 20,
- groupBy: '',
- groupClosedShowCalcs: true,
- columnCalcs: 'both',
- downloadConfig: {
- columnGroups: true,
- rowGroups: true, //include row groups in download
- columnCalcs: true, //include column calculation rows in download
- },
- paginationSizeSelector: [10, 20, 30, 40, 50, 60, 70, 80, 90, 100],
- rowClick: function(e, row) {
- // WHEN ROW IS CLICKED, ZOOM TO SELECTED FEATURE
- app.activeView.whenLayerView(app.layerToBeQueried).then(function(layerView) {
- var query = app.layerToBeQueried.createQuery();
- query.where = "StationShortName = " + "'" + row._row.data.StationShortName + "'";
- query.outSpatialReference = app.activeView.spatialReference;
- query.returnGeometry = true;
- app.layerToBeQueried.queryFeatures(query).then(function(results) {
- var selectedFeature = results.features[0];
- app.activeView.goTo({
- target: selectedFeature.geometry,
- zoom: 20
- });
- });
- });
- },
- rowMouseOver: function(e, row) {
- // highlight selected feature when row is hovered
- app.activeView.whenLayerView(app.layerToBeQueried).then(function(layerView) {
- var query = app.layerToBeQueried.createQuery();
- query.where = "StationShortName = " + "'" + row._row.data.StationShortName + "'";
- query.outSpatialReference = app.activeView.spatialReference;
- query.returnGeometry = true;
- layerView.queryFeatures(query).then(function(results) {
- var graphic = results.features[0];
- app.activeView.graphics.removeAll();
- app.selectedTableFeature.geometry = graphic.geometry;
- app.activeView.graphics.add(app.selectedTableFeature);
- });
- });
- },
- rowMouseLeave: function(e, row) {
- // remove highlight box graphic when user stops hovering over table row
- app.activeView.graphics.removeAll();
- },
- initialSort: [{
- column: "StationShortName",
- dir: "asc"
- }, //sort by this first
- // { column: "SAMPLETYPE", dir: "asc" }, //then sort by this second
- ],
- columns: [
- {
- // row of zoom icons to allow user to zoom to selected feature. does not download to exported spreadsheet
- title: 'Zoom',
- align: "center",
- formatter: zoomIcon,
- headerSort: false,
- download: false,
- frozen: true
- },
- {
- title: "Station Short Name",
- field: "StationShortName",
- sorter: "string",
- frozen: true,
- download: false,
- topCalc: "count",
- // editor: "input",
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: '',
- columns: [
- {
- title: 'Station Information',
- columns: [
- {
- title: "Station Name",
- field: "StationName",
- sorter: "string",
- frozen: false,
- topCalc: "count",
- // editor: "input",
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: "Station Short Name",
- field: "StationShortName",
- sorter: "string",
- frozen: false,
- topCalc: "count",
- // editor: "input",
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: "Program",
- field: "SampleType",
- sorter: "string",
- frozen: false,
- // editor: "input",
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: "Flow Zone",
- field: "StaGeologicUnit",
- sorter: "string",
- editor: "input",
- headerFilter: true,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: "Station Type",
- field: "StationType",
- sorter: "string",
- editor: "input",
- headerFilter: true,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: "Location",
- field: "Location",
- sorter: "string",
- editor: "input",
- headerFilter: true,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column'
- }
- ]
- }
- ]
- },
- {
- title: 'Q1 2018 SAMPLING EVENT',
- columns: [
- {
- title: "Sample Date",
- field: "SampleDate_Converted",
- formatter: "datetime",
- formatterParams:{
- inputFormat: "MM/DD/YYYY",
- outputFormat:"M/D/YYYY",
- invalidPlaceholder:"Not Sampled In Q1",
- },
- sorter: 'date',
- sorterParams:{format:"MM/DD/YYYY"},
- frozen: false,
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: 'Field Parameters',
- columns: [
- {
- title: "pH (S.U.)",
- field: "pH",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Water Level (ft)",
- field: "WaterLevel",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Temperature (C)",
- field: "Temperature",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Specific Conductance (umhos/cm)",
- field: "SpecificConductance",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Dissolved Oxygen (mg/L)",
- field: "DissolvedOxygen",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Oxidation Reduction Potential (mV)",
- field: "OxidationReductionPotential",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Eh (mV)",
- field: "Eh",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Turbidity (NTUs)",
- field: "Turbidity",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- },
- {
- title: 'Constituents of Interest',
- columns: [
- {
- title: "Boron (μg/L)",
- field: "Boron",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Chloride (mg/L)",
- field: "Chloride",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Cobalt (μg/L)",
- field: "Cobalt",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Selenium (μg/L)",
- field: "Selenium",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Sulfate (μg/L)",
- field: "Sulfate",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- }
- ]
- },
- {
- title: 'Q2 2018 SAMPLING EVENT',
- columns: [
- {
- title: "Sample Date",
- field: "SampleDate_1_Converted",
- formatter: "datetime",
- formatterParams:{
- inputFormat: "MM/DD/YYYY",
- outputFormat:"M/D/YYYY",
- invalidPlaceholder:"Not Sampled In Q2",
- },
- sorter: 'date',
- sorterParams:{format:"MM/DD/YYYY"},
- frozen: false,
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: 'Field Parameters',
- columns: [
- {
- title: "pH (S.U.)",
- field: "pH_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Water Level (ft)",
- field: "WaterLevel_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Temperature (C)",
- field: "Temperature_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Specific Conductance (umhos/cm)",
- field: "SpecificConductance_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Dissolved Oxygen (mg/L)",
- field: "DissolvedOxygen_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Oxidation Reduction Potential (mV)",
- field: "OxidationReductionPotential_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Eh (mV)",
- field: "Eh_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Turbidity (NTUs)",
- field: "Turbidity_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- },
- {
- title: 'Constituents of Interest',
- columns: [
- {
- title: "Boron (μg/L)",
- field: "Boron_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Chloride (mg/L)",
- field: "Chloride_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Cobalt (μg/L)",
- field: "Cobalt_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Selenium (μg/L)",
- field: "Selenium_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Sulfate (mg/L)",
- field: "Sulfate_1",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- }
- ]
- },
- {
- title: 'Q3 2018 SAMPLING EVENT',
- columns: [
- {
- title: "Sample Date",
- field: "SampleDate_12_Converted",
- formatter: "datetime",
- formatterParams:{
- inputFormat: "MM/DD/YYYY",
- outputFormat:"M/D/YYYY",
- invalidPlaceholder:"Not Sampled In Q3",
- },
- sorter: 'date',
- sorterParams:{format:"MM/DD/YYYY"},
- frozen: false,
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: 'Field Parameters',
- columns: [
- {
- title: "pH (S.U.)",
- field: "pH_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Water Level (ft)",
- field: "WaterLevel_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Temperature (C)",
- field: "Temperature_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Specific Conductance (umhos/cm)",
- field: "SpecificConductance_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Dissolved Oxygen (mg/L)",
- field: "DissolvedOxygen_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Oxidation Reduction Potential (mV)",
- field: "OxidationReductionPotential_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Eh (mV)",
- field: "Eh_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Turbidity (NTUs)",
- field: "Turbidity_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- },
- {title: 'Constituents of Interest',
- columns: [
- {
- title: "Boron (μg/L)",
- field: "Boron_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Chloride (mg/L)",
- field: "Chloride_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Cobalt (μg/L)",
- field: "Cobalt_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Selenium (μg/L)",
- field: "Selenium_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Sulfate (mg/L)",
- field: "Sulfate_12",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- }
- ]
- },
- {
- title: 'Q4 2018 SAMPLING EVENT',
- columns: [
- {
- title: "Sample Date",
- field: "SampleDate_12_13_Converted",
- formatter: "datetime",
- formatterParams:{
- inputFormat: "MM/DD/YYYY",
- outputFormat:"M/D/YYYY",
- invalidPlaceholder:"Not Sampled In Q4",
- },
- sorter: 'date',
- sorterParams:{format:"MM/DD/YYYY"},
- frozen: false,
- headerFilter: true,
- headerFilterPlaceholder: 'Filter Column'
- },
- {
- title: 'Field Parameters',
- columns: [
- {
- title: "pH (S.U.)",
- field: "pH_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Water Level (ft)",
- field: "WaterLevel_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Temperature (C)",
- field: "Temperature_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Specific Conductance (umhos/cm)",
- field: "SpecificConductance_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Dissolved Oxygen (mg/L)",
- field: "DissolvedOxygen_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Oxidation Reduction Potential (mV)",
- field: "OxidationReductionPotential_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Eh (mV)",
- field: "Eh_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Turbidity (NTUs)",
- field: "Turbidity_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- },
- {
- title: 'Constituents of Interest',
- columns: [
- {
- title: "Boron (μg/L)",
- field: "Boron_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Chloride (μg/L)",
- field: "Chloride_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Cobalt (μg/L)",
- field: "Cobalt_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Selenium (μg/L)",
- field: "Selenium_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- },
- {
- title: "Sulfate (mg/L)",
- field: "Sulfate_12_13",
- sorter: "number",
- editor: "input",
- headerFilter: false,
- frozen: false,
- headerFilterPlaceholder: 'Filter Column',
- topCalc: customAverageCalc // custom function to exlude null values
- }
- ]
- }
- ]
- },
- {
- title: '',
- columns: [
- {
- title: 'Location Information',
- columns: [
- {
- title: "Ground Elevation",
- field: "GroundElevation",
- sorter: "number",
- headerFilter: false,
- frozen: false,
- },
- {
- title: "Datum Elevation",
- field: "DatumElevation",
- sorter: "number",
- headerFilter: false,
- frozen: false,
- },
- {
- title: "ScreenTop",
- field: "ScreenTop",
- sorter: "number",
- headerFilter: false,
- frozen: false,
- },
- {
- title: "ScreenBase",
- field: "ScreenBase",
- sorter: "number",
- headerFilter: false,
- frozen: false,
- },
- {
- title: "X Coordinate",
- field: "Location_CX",
- sorter: "number",
- headerFilter: false,
- frozen: false,
- },
- {
- title: "Y Coordinate",
- field: "Location_CY",
- sorter: "number",
- headerFilter: false,
- frozen: false,
- }
- ]
- }
- ]
- }
- ]
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement