{
 "tables": [{
  "preferredTimeReference": null,
  "useStandardizedQueries": true,
  "maxRecordCount": 2000,
  "description": null,
  "datesInUnknownTimezone": false,
  "type": "Table",
  "subtypes": [],
  "relationships": [],
  "indexes": [{
   "name": "R60_SDE_ROWID_UK",
   "isUnique": true,
   "description": "",
   "fields": "OBJECTID",
   "isAscending": true
  }],
  "htmlPopupType": "esriServerHTMLPopupTypeNone",
  "cimVersion": "3.7.0",
  "isDataArchived": false,
  "id": 2,
  "archivingInfo": {
   "startArchivingMoment": -1,
   "supportsQueryWithHistoricMoment": false
  },
  "hasAttachments": false,
  "advancedQueryCapabilities": {
   "supportsStatistics": true,
   "supportsSqlExpression": true,
   "supportsQueryWithResultType": true,
   "supportsTrueCurve": false,
   "supportsOrderBy": true,
   "supportsQueryRelatedPagination": true,
   "supportsSqlFormat": false,
   "useStandardizedQueries": true,
   "supportsResultPaginationToken": false,
   "supportsQueryWithDistance": true,
   "supportsQueryWithCacheHint": false,
   "supportsCountDistinct": true,
   "supportsCurrentUserQueries": true,
   "supportsAdvancedQueryRelated": true,
   "supportsReturningQueryExtent": true,
   "supportsPagination": true,
   "supportsMaxRecordCountFactor": false,
   "supportsDistinct": true,
   "supportsTimeRelation": true,
   "supportsQueryAnalytic": true,
   "supportsPercentileStatistics": true,
   "supportsHavingClause": true
  },
  "subtypeField": null,
  "subtypeFieldName": null,
  "supportsStatistics": true,
  "serviceItemId": "6f66d369a87842fb82f51888f0e42377",
  "capabilities": "Query,Map,Data",
  "hasLastEditTime": false,
  "supportsExceedsLimitStatistics": true,
  "standardMaxRecordCount": 32000,
  "isDataVersioned": false,
  "supportsAdvancedQueries": true,
  "advancedQueryAnalyticCapabilities": {
   "supportsAsync": false,
   "supportsLinearRegression": true,
   "supportsPercentileAnalytic": true
  },
  "hasMetadata": true,
  "tileMaxRecordCount": 2000,
  "currentVersion": 12.1,
  "typeIdField": null,
  "defaultSubtypeCode": null,
  "timeInfo": {"timeReference": {
   "timeZoneIANA": "America/Chicago",
   "respectsDaylightSaving": true,
   "timeZone": "Central Standard Time"
  }},
  "supportedQueryFormats": "JSON, PBF",
  "name": "USACOE Grapevine Levels - History",
  "displayField": "lake_name",
  "copyrightText": null,
  "fields": [
   {
    "nullable": false,
    "domain": null,
    "name": "OBJECTID",
    "alias": "OBJECTID",
    "type": "esriFieldTypeOID"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "location",
    "length": 20,
    "alias": "Location Station Code",
    "type": "esriFieldTypeString"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "lake_name",
    "length": 50,
    "alias": "Lake Name",
    "type": "esriFieldTypeString"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "retrieved_utc",
    "length": 8,
    "alias": "UTC Automation Run",
    "type": "esriFieldTypeDate"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "reading_time",
    "length": 8,
    "alias": "Sensor Reading Time",
    "type": "esriFieldTypeDate"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "source",
    "length": 20,
    "alias": "Data Source (Legacy vs Modern)",
    "type": "esriFieldTypeString"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "elevation_ft",
    "alias": "Water Surface Elevation (ft)",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "elevation_units",
    "length": 10,
    "alias": "Elevation Unit",
    "type": "esriFieldTypeString"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "precipitation_in",
    "alias": "Hourly Incremental Precipitation (in)",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "precipitation_units",
    "length": 10,
    "alias": "Precipitation Unit",
    "type": "esriFieldTypeString"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "wind_dir_deg",
    "alias": "Wind Direction (Degrees from North)",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "wind_dir_units",
    "length": 10,
    "alias": "Wind Direction Unit",
    "type": "esriFieldTypeString"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "wind_speed_mph",
    "alias": "Wind Speed (mph)",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "wind_speed_units",
    "length": 10,
    "alias": "Wind Speed Unit",
    "type": "esriFieldTypeString"
   }
  ],
  "maxRecordCountFactor": 1,
  "dateFieldsTimeReference": {
   "timeZoneIANA": "America/Chicago",
   "respectsDaylightSaving": true,
   "timeZone": "Central Standard Time"
  }
 }],
 "layers": [{
  "extent": {
   "ymin": 3888440.422654225,
   "xmin": -10822134.853180978,
   "ymax": 3901718.6973430342,
   "xmax": -10804009.772787288,
   "spatialReference": {
    "falseM": -100000,
    "xyTolerance": 0.001,
    "mUnits": 10000,
    "zUnits": 10000,
    "latestWkid": 3857,
    "zTolerance": 0.001,
    "wkid": 102100,
    "xyUnits": 10000,
    "mTolerance": 0.001,
    "falseX": -20037700,
    "falseY": -30241100,
    "falseZ": -100000
   }
  },
  "maxRecordCount": 2000,
  "datesInUnknownTimezone": false,
  "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
  "type": "Feature Layer",
  "maxSelectionCount": 2000,
  "subtypes": [],
  "relationships": [],
  "cimVersion": "3.7.0",
  "isDataArchived": false,
  "id": 0,
  "archivingInfo": {
   "startArchivingMoment": -1,
   "supportsQueryWithHistoricMoment": false
  },
  "spatialReference": {
   "falseM": -100000,
   "xyTolerance": 0.001,
   "mUnits": 10000,
   "zUnits": 10000,
   "latestWkid": 3857,
   "zTolerance": 0.001,
   "wkid": 102100,
   "xyUnits": 10000,
   "mTolerance": 0.001,
   "falseX": -20037700,
   "falseY": -30241100,
   "falseZ": -100000
  },
  "subtypeFieldName": null,
  "supportsStatistics": true,
  "hasLastEditTime": false,
  "uniqueIdInfo": {
   "type": "simple",
   "fields": ["polygon_objectid"],
   "OIDFieldContainsHashValue": false
  },
  "standardMaxRecordCount": 4000,
  "isDataVersioned": false,
  "supportsAdvancedQueries": true,
  "parentLayer": null,
  "subLayers": [],
  "currentVersion": 12.1,
  "referenceScale": 0,
  "canScaleSymbols": false,
  "timeInfo": {"timeReference": {
   "timeZoneIANA": "America/Chicago",
   "respectsDaylightSaving": true,
   "timeZone": "Central Standard Time"
  }},
  "name": "Current Lake Elevation",
  "displayField": "LakeStage",
  "fields": [
   {
    "nullable": false,
    "domain": null,
    "name": "polygon_objectid",
    "alias": "polygon_objectid",
    "type": "esriFieldTypeOID"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "polygon_elevation",
    "alias": "polygon_elevation",
    "type": "esriFieldTypeSmallInteger"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "Shape",
    "alias": "Shape",
    "type": "esriFieldTypeGeometry"
   },
   {
    "nullable": false,
    "domain": null,
    "name": "reading_objectid",
    "alias": "reading_objectid",
    "type": "esriFieldTypeInteger"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "reading_time",
    "length": 8,
    "alias": "reading_time",
    "type": "esriFieldTypeDate"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "elevation_ft",
    "alias": "elevation_ft",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "elevation_floor",
    "alias": "elevation_floor",
    "type": "esriFieldTypeInteger"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "elevation_rounded",
    "alias": "elevation_rounded",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "precipitation_in",
    "alias": "precipitation_in",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "wind_dir_deg",
    "alias": "wind_dir_deg",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "wind_speed_mph",
    "alias": "wind_speed_mph",
    "type": "esriFieldTypeDouble"
   },
   {
    "nullable": true,
    "domain": null,
    "name": "effective_elevation",
    "alias": "effective_elevation",
    "type": "esriFieldTypeInteger"
   },
   {
    "nullable": false,
    "domain": null,
    "name": "LakeStage",
    "length": 17,
    "alias": "LakeStage",
    "type": "esriFieldTypeString"
   }
  ],
  "maxRecordCountFactor": 1,
  "dateFieldsTimeReference": {
   "timeZoneIANA": "America/Chicago",
   "respectsDaylightSaving": true,
   "timeZone": "Central Standard Time"
  },
  "preferredTimeReference": null,
  "useStandardizedQueries": true,
  "sourceSpatialReference": {
   "falseM": -100000,
   "xyTolerance": 0.0032808333333333331,
   "mUnits": 10000,
   "zUnits": 10000,
   "latestWkid": 2276,
   "zTolerance": 0.001,
   "wkid": 102738,
   "xyUnits": 3048.00609601219276,
   "mTolerance": 0.001,
   "falseX": -123407700,
   "falseY": -86123500,
   "falseZ": -100000
  },
  "description": "",
  "maxUniqueIDCount": 100000,
  "canModifyLayer": true,
  "supportedSpatialRelationships": [
   "esriSpatialRelIntersects",
   "esriSpatialRelContains",
   "esriSpatialRelCrosses",
   "esriSpatialRelEnvelopeIntersects",
   "esriSpatialRelIndexIntersects",
   "esriSpatialRelOverlaps",
   "esriSpatialRelTouches",
   "esriSpatialRelWithin",
   "esriSpatialRelRelation"
  ],
  "standardMaxRecordCountNoGeometry": 32000,
  "indexes": [{
   "name": "FDO_polygon_objectid",
   "isUnique": true,
   "description": "",
   "fields": "polygon_objectid",
   "isAscending": true
  }],
  "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
  "supportsDatumTransformation": true,
  "minScale": 0,
  "supportsDynamicLegends": true,
  "hasAttachments": false,
  "advancedQueryCapabilities": {
   "supportsSqlExpression": true,
   "supportsQueryWithResultType": true,
   "supportsQueryRelatedPagination": true,
   "supportsSqlFormat": false,
   "useStandardizedQueries": true,
   "supportsResultPaginationToken": false,
   "supportsQueryWithCacheHint": false,
   "supportsQueryWithDatumTransformation": true,
   "supportsCurrentUserQueries": true,
   "supportsQueryWithLodSR": false,
   "supportsPagination": true,
   "supportsMaxRecordCountFactor": false,
   "supportsStatistics": true,
   "supportsTrueCurve": true,
   "supportsOrderBy": true,
   "supportsLod": false,
   "supportsQueryWithDistance": true,
   "supportsCountDistinct": true,
   "supportsAdvancedQueryRelated": true,
   "supportsReturningQueryExtent": true,
   "supportsDistinct": true,
   "supportsTimeRelation": true,
   "supportsQueryAnalytic": true,
   "supportsPercentileStatistics": true,
   "supportsHavingClause": true
  },
  "subtypeField": null,
  "serviceItemId": "6f66d369a87842fb82f51888f0e42377",
  "supportsCoordinatesQuantization": true,
  "capabilities": "Query,Map,Data",
  "maxScale": 0,
  "supportsExceedsLimitStatistics": true,
  "defaultVisibility": true,
  "advancedQueryAnalyticCapabilities": {
   "supportsAsync": false,
   "supportsLinearRegression": true,
   "supportsPercentileAnalytic": true
  },
  "hasMetadata": true,
  "tileMaxRecordCount": 4000,
  "typeIdField": null,
  "defaultSubtypeCode": null,
  "supportedQueryFormats": "JSON, geoJSON, PBF",
  "hasLabels": true,
  "drawingInfo": {
   "renderer": {
    "uniqueValueGroups": [{
     "heading": "Lake Stage",
     "classes": [
      {
       "symbol": {
        "outline": {
         "color": [
          0,
          38,
          115,
          229
         ],
         "width": 2,
         "style": "esriSLSSolid",
         "type": "esriSLS"
        },
        "color": [
         0,
         197,
         255,
         102
        ],
        "style": "esriSFSSolid",
        "type": "esriSFS"
       },
       "values": [["Conservation Pool"]],
       "description": "Conservation Pool",
       "label": "Conservation Pool"
      },
      {
       "symbol": {
        "outline": {
         "color": [
          0,
          38,
          115,
          255
         ],
         "width": 2,
         "style": "esriSLSSolid",
         "type": "esriSLS"
        },
        "color": [
         0,
         197,
         255,
         153
        ],
        "style": "esriSFSSolid",
        "type": "esriSFS"
       },
       "values": [["Normal Pool"]],
       "description": "Normal Pool",
       "label": "Normal Pool"
      },
      {
       "symbol": {
        "outline": {
         "color": [
          0,
          38,
          115,
          255
         ],
         "width": 2,
         "style": "esriSLSSolid",
         "type": "esriSLS"
        },
        "color": [
         255,
         98,
         43,
         153
        ],
        "style": "esriSFSSolid",
        "type": "esriSFS"
       },
       "values": [["Flood Pool"]],
       "description": "Flood Pool",
       "label": "Flood Pool"
      },
      {
       "symbol": {
        "outline": {
         "color": [
          0,
          38,
          115,
          255
         ],
         "width": 2,
         "style": "esriSLSSolid",
         "type": "esriSLS"
        },
        "color": [
         103,
         7,
         24,
         165
        ],
        "style": "esriSFSSolid",
        "type": "esriSFS"
       },
       "values": [["Extreme Flood"]],
       "description": "Extreme Flood",
       "label": "Extreme Flood"
      }
     ]
    }],
    "field1": "LakeStage",
    "authoringInfo": {"colorRamp": {
     "colorRamps": [
      {
       "toColor": [
        252,
        220,
        187,
        255
       ],
       "fromColor": [
        252,
        220,
        187,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        182,
        179,
        252,
        255
       ],
       "fromColor": [
        182,
        179,
        252,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        184,
        248,
        252,
        255
       ],
       "fromColor": [
        184,
        248,
        252,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        185,
        252,
        182,
        255
       ],
       "fromColor": [
        185,
        252,
        182,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        252,
        182,
        212,
        255
       ],
       "fromColor": [
        252,
        182,
        212,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        194,
        218,
        252,
        255
       ],
       "fromColor": [
        194,
        218,
        252,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        250,
        252,
        179,
        255
       ],
       "fromColor": [
        250,
        252,
        179,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        241,
        179,
        252,
        255
       ],
       "fromColor": [
        241,
        179,
        252,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        179,
        252,
        222,
        255
       ],
       "fromColor": [
        179,
        252,
        222,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        252,
        215,
        225,
        255
       ],
       "fromColor": [
        252,
        215,
        225,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        227,
        252,
        207,
        255
       ],
       "fromColor": [
        227,
        252,
        207,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        236,
        212,
        252,
        255
       ],
       "fromColor": [
        236,
        212,
        252,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      },
      {
       "toColor": [
        252,
        184,
        184,
        255
       ],
       "fromColor": [
        252,
        184,
        184,
        255
       ],
       "type": "algorithmic",
       "algorithm": "esriCIELabAlgorithm"
      }
     ],
     "type": "multipart"
    }},
    "uniqueValueInfos": [
     {
      "symbol": {
       "outline": {
        "color": [
         0,
         38,
         115,
         229
        ],
        "width": 2,
        "style": "esriSLSSolid",
        "type": "esriSLS"
       },
       "color": [
        0,
        197,
        255,
        102
       ],
       "style": "esriSFSSolid",
       "type": "esriSFS"
      },
      "label": "Conservation Pool",
      "value": "Conservation Pool"
     },
     {
      "symbol": {
       "outline": {
        "color": [
         0,
         38,
         115,
         255
        ],
        "width": 2,
        "style": "esriSLSSolid",
        "type": "esriSLS"
       },
       "color": [
        0,
        197,
        255,
        153
       ],
       "style": "esriSFSSolid",
       "type": "esriSFS"
      },
      "label": "Normal Pool",
      "value": "Normal Pool"
     },
     {
      "symbol": {
       "outline": {
        "color": [
         0,
         38,
         115,
         255
        ],
        "width": 2,
        "style": "esriSLSSolid",
        "type": "esriSLS"
       },
       "color": [
        255,
        98,
        43,
        153
       ],
       "style": "esriSFSSolid",
       "type": "esriSFS"
      },
      "label": "Flood Pool",
      "value": "Flood Pool"
     },
     {
      "symbol": {
       "outline": {
        "color": [
         0,
         38,
         115,
         255
        ],
        "width": 2,
        "style": "esriSLSSolid",
        "type": "esriSLS"
       },
       "color": [
        103,
        7,
        24,
        165
       ],
       "style": "esriSFSSolid",
       "type": "esriSFS"
      },
      "label": "Extreme Flood",
      "value": "Extreme Flood"
     }
    ],
    "type": "uniqueValue",
    "fieldDelimiter": ","
   },
   "scaleSymbols": true,
   "transparency": 0,
   "labelingInfo": [{
    "multiPart": "labelLargest",
    "symbol": {
     "backgroundColor": null,
     "kerning": true,
     "color": [
      0,
      0,
      0,
      255
     ],
     "yoffset": 0,
     "xoffset": 0,
     "haloColor": null,
     "type": "esriTS",
     "borderLineColor": null,
     "borderLineSize": null,
     "horizontalAlignment": "left",
     "haloSize": null,
     "angle": 0,
     "rightToLeft": false,
     "verticalAlignment": "bottom",
     "font": {
      "size": 10,
      "weight": "normal",
      "style": "normal",
      "family": "Times New Roman",
      "decoration": "none"
     }
    },
    "stackLabel": true,
    "stackRowLength": 24,
    "maxScale": 0,
    "allowOverrun": true,
    "useClippedGeometry": true,
    "labelExpressionInfo": {
     "expression": "/*\nDetermine if a UTC date falls within US Central Daylight Time\nDST starts: 2nd Sunday of March at 2:00 AM local\nDST ends:   1st Sunday of November at 2:00 AM local\n*/\n\n// --- Input fields from new schema ---\nvar utcTime = $feature.reading_time;\nvar elevation = $feature.elevation_ft;\n\n// Year for DST calculations\nvar yr = Year(utcTime);\n\n// --- Calculate 2nd Sunday in March ---\n// Weekday(): 0=Sun, 1=Mon, ... 6=Sat\nvar marchFirst = Date(yr, 2, 1);\nvar marchDow = Weekday(marchFirst);\nvar dstStartDay = IIF(marchDow == 0, 8, 15 - marchDow);\nvar dstStart = Date(yr, 2, dstStartDay, 8, 0, 0); // 2AM CST = 8AM UTC\n\n// --- Calculate 1st Sunday in November ---\nvar novFirst = Date(yr, 10, 1);\nvar novDow = Weekday(novFirst);\nvar dstEndDay = IIF(novDow == 0, 1, 8 - novDow);\nvar dstEnd = Date(yr, 10, dstEndDay, 7, 0, 0); // 2AM CDT = 7AM UTC\n\n// --- Determine correct offset: CDT (-5) or CST (-6) ---\nvar offset = IIF(utcTime >= dstStart && utcTime < dstEnd, -5, -6);\nvar localTime = DateAdd(utcTime, offset, 'hours');\nvar tzLabel = IIF(offset == -5, \"CDT\", \"CST\");\n\n// --- Final label text ---\n\"Lake Level: \" + Round(elevation, 2) + \" ft\" +\nTextFormatting.NewLine +\n\"As of: \" + Text(localTime, \"MM/DD/Y hh:mm A\") + \" \" + tzLabel  ",
     "title": "Current Lake Level"
    },
    "deconflictionStrategy": "dynamic",
    "priority": -1,
    "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal",
    "removeDuplicates": "none",
    "name": "Class 1",
    "repeatLabel": false,
    "minScale": 0,
    "stackAlignment": "dynamic",
    "useCodedValues": true
   }]
  },
  "geometryField": {
   "name": "Shape",
   "alias": "Shape",
   "type": "esriFieldTypeGeometry"
  },
  "copyrightText": "",
  "geometryType": "esriGeometryPolygon"
 }]
}