{
  "currentVersion" : 12, 
  "id" : 4, 
  "name" : "InspectionHydrant", 
  "type" : "Table", 
  "serviceItemId" : "8f2fa40f4e6347e88fc739d6a99e58e2", 
  "cacheMaxAge" : 30, 
  "displayField" : "", 
  "description" : "", 
  "copyrightText" : "", 
  "defaultVisibility" : true, 
  "ownershipBasedAccessControlForFeatures" : {
    "allowOthersToQuery" : true, 
    "allowOthersToDelete" : false, 
    "allowOthersToUpdate" : true, 
    "allowAnonymousToQuery" : true, 
    "allowAnonymousToUpdate" : true, 
    "allowAnonymousToDelete" : true
  }, 
  "editFieldsInfo" : {
    "creationDateField" : "DATECREATED", 
    "creatorField" : "CREATIONUSER", 
    "editDateField" : "DATEMODIFIED", 
    "editorField" : "LASTUSER"
  }, 
  "editingInfo" : {
    "lastEditDate" : 1699990329201, 
    "schemaLastEditDate" : 1698434490700, 
    "dataLastEditDate" : 1699990329201
  }, 
  "relationships" : [
    {
      "id" : 0, 
      "name" : "WaterHydrant_InspectionHydrant", 
      "relatedTableId" : 0, 
      "cardinality" : "esriRelCardinalityOneToMany", 
      "role" : "esriRelRoleDestination", 
      "keyField" : "WHYDRANT_GLOBALID", 
      "composite" : false
    }
  ], 
  "isDataVersioned" : false, 
  "hasContingentValuesDefinition" : false, 
  "supportsAppend" : true, 
  "supportsCalculate" : true, 
  "supportsASyncCalculate" : true, 
  "supportsTruncate" : true, 
  "supportsAttachmentsByUploadId" : true, 
  "supportsAttachmentsResizing" : true, 
  "supportsRollbackOnFailureParameter" : true, 
  "supportsStatistics" : true, 
  "supportsExceedsLimitStatistics" : true, 
  "supportsAdvancedQueries" : true, 
  "supportsValidateSql" : true, 
  "supportsCoordinatesQuantization" : true, 
  "supportsLayerOverrides" : true, 
  "supportsTilesAndBasicQueriesMode" : true, 
  "supportsFieldDescriptionProperty" : true, 
  "supportsQuantizationEditMode" : true, 
  "supportsColumnStoreIndex" : true, 
  "supportsApplyEditsWithGlobalIds" : true, 
  "supportsOBACForAnonymousUsers" : true, 
  "advancedQueryCapabilities" : {
    "supportsPagination" : true, 
    "supportsPaginationOnAggregatedQueries" : true, 
    "supportsQueryRelatedPagination" : true, 
    "supportsQueryWithDistance" : true, 
    "supportsReturningQueryExtent" : false, 
    "supportsStatistics" : true, 
    "supportsOrderBy" : true, 
    "supportsDistinct" : true, 
    "supportsQueryWithResultType" : true, 
    "supportsSqlExpression" : true, 
    "supportsTimeRelation" : true, 
    "supportsAdvancedQueryRelated" : true, 
    "supportsCountDistinct" : true, 
    "supportsPercentileStatistics" : true, 
    "supportsApproxPercentileStatistics" : true, 
    "supportsSpatialAggregationStatistics" : true, 
    "supportedSpatialAggregationStatistics" : [
      "EnvelopeAggregate", 
      "CentroidAggregate", 
      "ConvexHullAggregate"
    ], 
    "supportsLod" : true, 
    "supportsQueryWithLodSR" : false, 
    "supportedLodTypes" : [
      "geohash"
    ], 
    "supportsReturningGeometryCentroid" : false, 
    "supportsReturningGeometryEnvelope" : true, 
    "supportsQueryWithDatumTransformation" : true, 
    "supportsCurrentUserQueries" : true, 
    "supportsHavingClause" : true, 
    "supportsOutFieldSQLExpression" : true, 
    "supportsMaxRecordCountFactor" : true, 
    "supportsTopFeaturesQuery" : true, 
    "supportsQueryWithCacheHint" : true, 
    "supportedOperationsWithCacheHint" : [
      "query", 
      "queryTopFilter", 
      "queryAnalytics", 
      "queryAttachments", 
      "queryRelated", 
      "queryBins", 
      "queryPivot"
    ], 
    "supportsQueryAnalytic" : true, 
    "supportsQueryPivot" : true, 
    "supportsQueryBins" : true, 
    "supportsQueryBoxplots" : true, 
    "supportsDefaultSR" : true, 
    "supportsTranslations" : true, 
    "supportsAggIds" : true, 
    "supportsQueryWithCollation" : true, 
    "supportsISODOW" : true, 
    "supportsISOWeek" : true, 
    "supportsFullTextSearch" : true, 
    "fullTextSearchCapabilities" : {
      "supportsAccentSensitivity" : true, 
      "supportsStopWords" : true, 
      "supportsSearchOperator" : true, 
      "supportsOperator" : true
    }
  }, 
  "advancedQueryAnalyticCapabilities" : {
    "supportsLinearRegression" : true, 
    "supportsTrendlineRegression" : true, 
    "supportsAsync" : true, 
    "supportsPercentileAnalytic" : true
  }, 
  "queryBinsCapabilities" : {
    "supportsAsync" : true, 
    "supportsAutoIntervalBin" : true, 
    "supportsFixedIntervalBin" : true, 
    "supportsFixedBoundariesBin" : true, 
    "supportsDateBin" : true, 
    "supportsClassificationBin" : true, 
    "supportsStackBy" : true, 
    "supportsSplitBy" : true, 
    "supportsFirstDayOfWeek" : true, 
    "supportsSnapToData" : true, 
    "supportsReturnFullIntervalBin" : true, 
    "supportsReturnStackValueRange" : true, 
    "supportsNormalization" : true, 
    "supportedStatisticTypes" : [
      "COUNT", 
      "SUM", 
      "AVG", 
      "VAR", 
      "STDDEV", 
      "MIN", 
      "MAX", 
      "PERCENTILE_CONT", 
      "PERCENTILE_DISC", 
      "APPROX_PERCENTILE_CONT", 
      "APPROX_PERCENTILE_DISC", 
      "CentroidAggregate", 
      "EnvelopeAggregate", 
      "ConvexHullAggregate"
    ], 
    "supportedNormalizationTypes" : [
      "boxCox", 
      "field", 
      "inverse", 
      "log", 
      "naturalLog", 
      "percentOfTotal", 
      "squareRoot"
    ]
  }, 
  "queryBoxplotsCapabilities" : {
    "supportsAsync" : true, 
    "standardMaxCategoryCount" : 10000, 
    "standardMaxSeriesCount" : 100
  }, 
  "supportedOperationsWithCollation" : "query,addField,updateField", 
  "advancedEditingCapabilities" : {
    "supportedSqlFormatsInCalculate" : [
      "standard"
    ], 
    "supportsAsyncApplyEdits" : true, 
    "supportsReturnEditResults" : true, 
    "supportsApplyEditsbyUploadID" : true, 
    "supportedApplyEditsUploadIDFormats" : "JSON,PBF", 
    "supportsTranslation" : true, 
    "supportsMaxTranslations" : 10
  }, 
  "infoInEstimates" : [
    "count"
  ], 
  "useStandardizedQueries" : true, 
  "allowGeometryUpdates" : true, 
  "hasAttachments" : false, 
  "htmlPopupType" : "esriServerHTMLPopupTypeNone", 
  "hasMetadata" : true, 
  "hasM" : false, 
  "hasZ" : false, 
  "objectIdField" : "OBJECTID", 
  "uniqueIdField" : 
  {
    "name" : "OBJECTID", 
    "isSystemMaintained" : true
  }, 
  "globalIdField" : "GlobalID", 
  "typeIdField" : "", 
  "collation" : {
    "locale" : "neutral", 
    "caseSensitive" : false, 
    "accentSensitive" : true
  }, 
  "fields" : [
    {
      "name" : "OBJECTID", 
      "type" : "esriFieldTypeOID", 
      "alias" : "OBJECTID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "required" : true
    }, 
    {
      "name" : "CREATIONUSER", 
      "type" : "esriFieldTypeString", 
      "alias" : "Creation User", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "DATECREATED", 
      "type" : "esriFieldTypeDate", 
      "alias" : "Date Created", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "DATEMODIFIED", 
      "type" : "esriFieldTypeDate", 
      "alias" : "Date Modified", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "LASTUSER", 
      "type" : "esriFieldTypeString", 
      "alias" : "Last User", 
      "sqlType" : "sqlTypeOther", 
      "length" : 50, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "HYDRANTOBJECTID", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Hydrant ObjectID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "CHECKEDBY", 
      "type" : "esriFieldTypeString", 
      "alias" : "Checked By", 
      "sqlType" : "sqlTypeOther", 
      "length" : 15, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "GasWaterDistributionCrew", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "codedValues" : [
          {
            "name" : "Andrew Serre", 
            "code" : "ASERRE"
          }, 
          {
            "name" : "Colton Krivinchuk", 
            "code" : "CKRIVINCHUK"
          }, 
          {
            "name" : "Craig Peterson", 
            "code" : "CLPETERSON"
          }, 
          {
            "name" : "Dallas Starkey", 
            "code" : "DSTARKEY"
          }, 
          {
            "name" : "Eric Frostman", 
            "code" : "EFROSTMAN"
          }, 
          {
            "name" : "Grant Miller", 
            "code" : "GMILLER"
          }, 
          {
            "name" : "Jason Macdonald", 
            "code" : "JDMACDONALD"
          }, 
          {
            "name" : "Jim Glonek", 
            "code" : "JGLONEK"
          }, 
          {
            "name" : "Joe Kujawa", 
            "code" : "JKUJAWA"
          }, 
          {
            "name" : "Keith Kellerhuis", 
            "code" : "KKELLERHUIS"
          }, 
          {
            "name" : "Ryan Brennan", 
            "code" : "RBRENNAN"
          }, 
          {
            "name" : "Steve Anderson", 
            "code" : "SANDERSON"
          }, 
          {
            "name" : "Tucker Abernethy", 
            "code" : "TABERNETHY"
          }, 
          {
            "name" : "Tony Burkhart", 
            "code" : "TBURKHART"
          }, 
          {
            "name" : "Matt Tonn", 
            "code" : "MTONN"
          }, 
          {
            "name" : "Brent Anderson", 
            "code" : "BTANDERSON"
          }, 
          {
            "name" : "Mike Hedin", 
            "code" : "MHEDIN"
          }, 
          {
            "name" : "Andy Strand", 
            "code" : "ASTRAND"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "DATECHECKED", 
      "type" : "esriFieldTypeDate", 
      "alias" : "Date Checked", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "MINUTESFLUSHED", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Minutes Flushed", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : 5
    }, 
    {
      "name" : "FLOWRATE", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Flow Rate PSI", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "DEADENDMAIN", 
      "type" : "esriFieldTypeString", 
      "alias" : "Dead End Main", 
      "sqlType" : "sqlTypeOther", 
      "length" : 1, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Yes/No Indicator", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "codedValues" : [
          {
            "name" : "No", 
            "code" : "N"
          }, 
          {
            "name" : "Yes", 
            "code" : "Y"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "BACKFLUSH", 
      "type" : "esriFieldTypeString", 
      "alias" : "Back Flush", 
      "sqlType" : "sqlTypeOther", 
      "length" : 1, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Yes/No Indicator", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "codedValues" : [
          {
            "name" : "No", 
            "code" : "N"
          }, 
          {
            "name" : "Yes", 
            "code" : "Y"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "OILED", 
      "type" : "esriFieldTypeString", 
      "alias" : "Oiled", 
      "sqlType" : "sqlTypeOther", 
      "length" : 1, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Yes/No Indicator", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "codedValues" : [
          {
            "name" : "No", 
            "code" : "N"
          }, 
          {
            "name" : "Yes", 
            "code" : "Y"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "FROZENDATE", 
      "type" : "esriFieldTypeDate", 
      "alias" : "Frozen Date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "COMMENTS", 
      "type" : "esriFieldTypeString", 
      "alias" : "Comments", 
      "sqlType" : "sqlTypeOther", 
      "length" : 140, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "STATICBADGENUM", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Static Badge Number", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "FLOWBADGENUM", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Flow Badge Number", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "STATICSTARTPSI", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Static Start PSI", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "STATICDURINGPSI", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Static During PSI", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "FLOWHYDPSI", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Flow Hydrant PSI", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "THAWEDDATE", 
      "type" : "esriFieldTypeDate", 
      "alias" : "Thawed Date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "HYDRANTSTATUS", 
      "type" : "esriFieldTypeString", 
      "alias" : "Hydrant Status", 
      "sqlType" : "sqlTypeOther", 
      "length" : 5, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "wHydrantStatus", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "Describes status of Hydrant", 
        "codedValues" : [
          {
            "name" : "In Service", 
            "code" : "IS"
          }, 
          {
            "name" : "Out of Service", 
            "code" : "OOS"
          }
        ]
      }, 
      "defaultValue" : "IS"
    }, 
    {
      "name" : "WHYDRANT_GLOBALID", 
      "type" : "esriFieldTypeGUID", 
      "alias" : "WHYDRANT_GLOBALID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 38, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "FLUSHPORT", 
      "type" : "esriFieldTypeString", 
      "alias" : "Flushed out of", 
      "sqlType" : "sqlTypeOther", 
      "length" : 20, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "FlushPort", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "codedValues" : [
          {
            "name" : "Big ear", 
            "code" : "BIGEAR"
          }, 
          {
            "name" : "Small ear", 
            "code" : "SMALLEAR"
          }, 
          {
            "name" : "Two small ears", 
            "code" : "TWOSMALLEARS"
          }, 
          {
            "name" : "All ears", 
            "code" : "ALLEARS"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "DIFFUSED", 
      "type" : "esriFieldTypeString", 
      "alias" : "Diffuser used", 
      "sqlType" : "sqlTypeOther", 
      "length" : 1, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Yes/No Indicator", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDuplicate", 
        "codedValues" : [
          {
            "name" : "No", 
            "code" : "N"
          }, 
          {
            "name" : "Yes", 
            "code" : "Y"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "INSPECTIONTYPE", 
      "type" : "esriFieldTypeString", 
      "alias" : "Inspection Type", 
      "sqlType" : "sqlTypeOther", 
      "length" : 25, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "wHydrantInspectionType", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "codedValues" : [
          {
            "name" : "Routine Flushing", 
            "code" : "ROUTINEFLUSH"
          }, 
          {
            "name" : "Used in Shutdown", 
            "code" : "USEDINSHUTDOWN"
          }, 
          {
            "name" : "Maintenance or Repair", 
            "code" : "MAINTREPAIR"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "CLRESIDUAL", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "Chlorine Residual", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "ServerOID", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "ServerOID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "GlobalID", 
      "type" : "esriFieldTypeGlobalID", 
      "alias" : "GlobalID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 38, 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "required" : true
    }
  ], 
  "indexes" : [
    {
      "name" : "FDO_GlobalID", 
      "fields" : "GlobalID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "I19ServerOID", 
      "fields" : "ServerOID", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "G19WHYDRANT_GLOB", 
      "fields" : "WHYDRANT_GLOBALID", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "PK__DATA_INS__F4B70D859FF1B391", 
      "fields" : "OBJECTID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "clustered, unique, primary key", 
      "indexType" : "Attribute"
    }
  ], 
  "dateFieldsTimeReference" : {
    "timeZone" : "UTC", 
    "timeZoneIANA" : "Etc/UTC", 
    "respectsDaylightSaving" : false
  }, 
  "preferredTimeReference" : null, 
  "types" : [], 
  "templates" : [], 
  "supportedQueryFormats" : "JSON, geoJSON, PBF, Parquet", 
  "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", 
  "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", 
  "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", 
  "supportedConvertFileFormats" : "JSON,PBF,Parquet", 
  "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", 
  "guidFormat" : "", 
  "supportsContingentValues" : true, 
  "supportsEditingContingentValues" : true, 
  "supportedContingentValuesFormats" : "JSON, PBF", 
  "supportsFieldGroups" : true, 
  "supportedSyncDataOptions" : 260, 
  "hasStaticData" : true, 
  "maxRecordCount" : 2000, 
  "standardMaxRecordCount" : 32000, 
  "maxIdsCount" : 100000, 
  "tileMaxRecordCount" : 8000, 
  "maxRecordCountFactor" : 1, 
  "capabilities" : "Query"
}