{
  "currentVersion" : 12, 
  "id" : 24, 
  "name" : "Range and coded domain examples", 
  "type" : "Feature Layer", 
  "serviceItemId" : "c8047d1e8ea0486b962fc8c629fc2f62", 
  "cacheMaxAge" : 30, 
  "displayField" : "OBJECTID", 
  "description" : "", 
  "copyrightText" : "", 
  "defaultVisibility" : true, 
  "editingInfo" : {
    "lastEditDate" : 1706882576577, 
    "schemaLastEditDate" : 1706114751228, 
    "dataLastEditDate" : 1706882576577
  }, 
  "relationships" : [], 
  "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" : false, 
  "supportsMultiScaleGeometry" : true, 
  "supportsReturningQueryGeometry" : true, 
  "enableNullGeometry" : false, 
  "hasGeometryProperties" : true, 
  "geometryProperties" : 
  {
    "shapeAreaFieldName" : "Shape__Area", 
    "shapeLengthFieldName" : "Shape__Length", 
    "units" : "esriMeters"
  }, 
  "advancedQueryCapabilities" : {
    "supportsPagination" : true, 
    "supportsPaginationOnAggregatedQueries" : true, 
    "supportsQueryRelatedPagination" : true, 
    "supportsQueryWithDistance" : true, 
    "supportsOutDistance" : true, 
    "supportsReturningQueryExtent" : true, 
    "supportsStatistics" : true, 
    "supportsOrderBy" : true, 
    "supportsDistinct" : true, 
    "supportsQueryWithResultType" : true, 
    "supportsSqlExpression" : true, 
    "supportsTimeRelation" : true, 
    "supportsAdvancedQueryRelated" : true, 
    "supportsCountDistinct" : true, 
    "supportsPercentileStatistics" : true, 
    "supportsApproxPercentileStatistics" : true, 
    "supportsSpatialAggregationStatistics" : true, 
    "supportsTrueCurve" : true, 
    "supportedSpatialAggregationStatistics" : [
      "EnvelopeAggregate", 
      "CentroidAggregate", 
      "ConvexHullAggregate"
    ], 
    "supportsLod" : true, 
    "supportsQueryWithLodSR" : false, 
    "supportedLodTypes" : [
      "geohash"
    ], 
    "supportsReturningGeometryCentroid" : true, 
    "supportsReturningGeometryEnvelope" : true, 
    "supportsReturningGeometryProperties" : true, 
    "supportsQueryWithDatumTransformation" : true, 
    "supportsCurrentUserQueries" : true, 
    "supportsHavingClause" : true, 
    "supportsOutFieldSQLExpression" : true, 
    "supportsMaxRecordCountFactor" : true, 
    "supportsTopFeaturesQuery" : true, 
    "supportsDisjointSpatialRel" : 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" : [
    "extent", 
    "count"
  ], 
  "useStandardizedQueries" : true, 
  "geometryType" : "esriGeometryPolygon", 
  "minScale" : 0, 
  "maxScale" : 0, 
  "extent" : {
    "xmin" : -8410993.9733472057, 
    "ymin" : 5930225.3686999977, 
    "xmax" : -7943073.5881995484, 
    "ymax" : 6077177.0025653159, 
    "spatialReference" : {
      "wkid" : 102100, 
      "latestWkid" : 3857
    }
  }, 
  "spatialReference" : {
    "wkid" : 102100, 
    "latestWkid" : 3857
  }, 
  "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[204,206,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, 
  "allowGeometryUpdates" : true, 
  "trueCurveSupportMode" : "OGC", 
  "supportedCurveTypes" : [
    "esriGeometryCircularArc"
  ], 
  "supportedTrueCurvePbfFeatureEncodings" : [
    "esriCompressedShapeBuffer", 
    "esriDefault"
  ], 
  "allowTrueCurvesUpdates" : true, 
  "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, 
  "hasAttachments" : false, 
  "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", 
  "hasMetadata" : true, 
  "hasM" : false, 
  "hasZ" : true, 
  "enableZDefaults" : true, 
  "zDefault" : 0, 
  "objectIdField" : "OBJECTID", 
  "uniqueIdField" : 
  {
    "name" : "OBJECTID", 
    "isSystemMaintained" : true
  }, 
  "globalIdField" : "", 
  "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
    }, 
    {
      "name" : "dateonly_coded", 
      "type" : "esriFieldTypeDateOnly", 
      "alias" : "dateonly_coded", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "dateonly_coded", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "three holidays in 2024", 
        "codedValues" : [
          {
            "name" : "Valentine's Day 2024", 
            "code" : "2024-02-14"
          }, 
          {
            "name" : "Canada Day 2024", 
            "code" : "2024-07-01"
          }, 
          {
            "name" : "4th of July 2024", 
            "code" : "2024-07-04"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "dateonly_range", 
      "type" : "esriFieldTypeDateOnly", 
      "alias" : "dateonly_range", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "range", 
        "name" : "dateonly_range", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "just Feb 2024", 
        "range" : [
          "2024-02-01", 
          "2024-02-29"
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "timeonly_coded", 
      "type" : "esriFieldTypeTimeOnly", 
      "alias" : "timeonly_coded", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "timeonly_coded", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "meal times", 
        "codedValues" : [
          {
            "name" : "Breakfast", 
            "code" : "08:00:00"
          }, 
          {
            "name" : "Noon", 
            "code" : "12:00:00"
          }, 
          {
            "name" : "Dinner", 
            "code" : "17:00:00"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "timeonly_range", 
      "type" : "esriFieldTypeTimeOnly", 
      "alias" : "timeonly_range", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "range", 
        "name" : "timeonly_range", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "business hours (9-5) only", 
        "range" : [
          "09:00:00", 
          "17:00:00"
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "datetime_coded", 
      "type" : "esriFieldTypeDate", 
      "alias" : "datetime_coded", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "date_coded", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "first week of Feb 2024", 
        "codedValues" : [
          {
            "name" : "Monday Feb 5", 
            "code" : 1707091200000
          }, 
          {
            "name" : "Tuesday Feb 6", 
            "code" : 1707177600000
          }, 
          {
            "name" : "Wednesday Feb 7", 
            "code" : 1707264000000
          }, 
          {
            "name" : "Thursday Feb 8", 
            "code" : 1707350400000
          }, 
          {
            "name" : "Friday Feb 9", 
            "code" : 1707436800000
          }
        ]
      }, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "datetime_range", 
      "type" : "esriFieldTypeDate", 
      "alias" : "datetime_range", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "range", 
        "name" : "date_range", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "only june 2024", 
        "range" : [
          1706745600000, 
          1719705600000
        ]
      }, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "integer_coded", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "integer_coded", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "int_coded", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "numbers as text values", 
        "codedValues" : [
          {
            "name" : "one", 
            "code" : 1
          }, 
          {
            "name" : "two", 
            "code" : 2
          }, 
          {
            "name" : "three", 
            "code" : 3
          }, 
          {
            "name" : "six", 
            "code" : 6
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "integer_range", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "integer_range", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "range", 
        "name" : "int_range", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "1 to 10", 
        "range" : [
          1, 
          10
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "string_coded", 
      "type" : "esriFieldTypeString", 
      "alias" : "string_coded", 
      "sqlType" : "sqlTypeOther", 
      "length" : 255, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "string_coded", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "sizes", 
        "codedValues" : [
          {
            "name" : "xs", 
            "code" : "extra-small"
          }, 
          {
            "name" : "s", 
            "code" : "small"
          }, 
          {
            "name" : "m", 
            "code" : "medium"
          }, 
          {
            "name" : "l", 
            "code" : "large"
          }, 
          {
            "name" : "xl", 
            "code" : "extra-large"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "double_coded", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "double_coded", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "double_coded", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "numbers as text values", 
        "codedValues" : [
          {
            "name" : "two point one", 
            "code" : 2.1
          }, 
          {
            "name" : "three point one", 
            "code" : 3.1
          }, 
          {
            "name" : "four point one", 
            "code" : 4.1
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "double_range", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "double_range", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "range", 
        "name" : "double_range", 
        "mergePolicy" : "esriMPTDefaultValue", 
        "splitPolicy" : "esriSPTDefaultValue", 
        "description" : "decimals less than 1 only", 
        "range" : [
          0, 
          1
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Shape__Area", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "Shape__Area", 
      "sqlType" : "sqlTypeDouble", 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Shape__Length", 
      "type" : "esriFieldTypeDouble", 
      "alias" : "Shape__Length", 
      "sqlType" : "sqlTypeDouble", 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "stringf2", 
      "type" : "esriFieldTypeString", 
      "alias" : "stringf2", 
      "sqlType" : "sqlTypeOther", 
      "length" : 256, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : "default value!"
    }, 
    {
      "name" : "stringtest3", 
      "type" : "esriFieldTypeString", 
      "alias" : "stringtest3", 
      "sqlType" : "sqlTypeOther", 
      "length" : 256, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }
  ], 
  "indexes" : [
    {
      "name" : "PK__RANGE_AN__F4B70D85F30BAC0E", 
      "fields" : "OBJECTID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "user_79414.RANGE_AND_CODED_DOMAIN_EXAMPLES_RANGE_AND_CODED_DOMAIN_EXAMPLES_Shape_sidx", 
      "fields" : "Shape", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Spatial"
    }, 
    {
      "name" : "Shape__Area_Index", 
      "fields" : "Shape__Area", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "Shape__Length_Index", 
      "fields" : "Shape__Length", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Attribute"
    }
  ], 
  "dateFieldsTimeReference" : {
    "timeZone" : "UTC", 
    "timeZoneIANA" : "Etc/UTC", 
    "respectsDaylightSaving" : false
  }, 
  "preferredTimeReference" : null, 
  "types" : [], 
  "templates" : [
    {
      "name" : "Range and coded domain examples", 
      "description" : "", 
      "drawingTool" : "esriFeatureEditToolPolygon", 
      "prototype" : {
        "attributes" : {
          "double_coded" : null, 
          "string_coded" : null, 
          "double_range" : null, 
          "dateonly_coded" : null, 
          "dateonly_range" : null, 
          "timeonly_coded" : null, 
          "timeonly_range" : null, 
          "datetime_coded" : null, 
          "datetime_range" : null, 
          "integer_coded" : null, 
          "integer_range" : null, 
          "stringf2" : "default value!", 
          "stringtest3" : null
        }
      }
    }
  ], 
  "supportedQueryFormats" : "JSON, geoJSON, PBF, GeoParquet", 
  "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,geoparquet", 
  "supportedConvertFileFormats" : "JSON,PBF,Geoparquet", 
  "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", 
  "supportedSpatialRelationships" : [
    "esriSpatialRelIntersects", 
    "esriSpatialRelContains", 
    "esriSpatialRelCrosses", 
    "esriSpatialRelEnvelopeIntersects", 
    "esriSpatialRelIndexIntersects", 
    "esriSpatialRelOverlaps", 
    "esriSpatialRelTouches", 
    "esriSpatialRelWithin", 
    "esriSpatialRelDisjoint", 
    "esriSpatialRelRelation"
  ], 
  "guidFormat" : "", 
  "supportsContingentValues" : true, 
  "supportedContingentValuesFormats" : "JSON, PBF", 
  "supportsFieldGroups" : true, 
  "supportedSyncDataOptions" : 260, 
  "hasStaticData" : false, 
  "maxRecordCount" : 2000, 
  "standardMaxRecordCount" : 2000, 
  "maxIdsCount" : 100000, 
  "standardMaxRecordCountNoGeometry" : 32000, 
  "tileMaxRecordCount" : 4000, 
  "maxRecordCountFactor" : 1, 
  "capabilities" : "Query"
}