{ "currentVersion" : 12, "id" : 5, "name" : "Sewer Manhole Stub", "type" : "Feature Layer", "serviceItemId" : "0e2e93a319b14d76986f1e79e8ab5d79", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "UNIQUEID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1665640841661, "schemaLastEditDate" : 1665640841661, "dataLastEditDate" : 1665640841661 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : { "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" : false, "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, "supportsDefaultSR" : true, "supportsTranslations" : false, "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" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 428061.40099999873, "ymin" : 6902744.15329976, "xmax" : 517206.56510000041, "ymax" : 6981677.104399736, "spatialReference" : { "wkid" : 28356, "latestWkid" : 28356 } }, "spatialReference" : { "wkid" : 28356, "latestWkid" : 28356 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[115,38,0,255],"width":0.8},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "viewSourceHasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "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" : "STATUS", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cStatus", "codedValues" : [ { "name" : "AS DESIGNED", "code" : "ASDES" }, { "name" : "AS CONSTRUCTED", "code" : "ASCON" }, { "name" : "DE-COMMISSIONED", "code" : "DEC" }, { "name" : "NOT IN USE", "code" : "NIU" }, { "name" : "REMOVED", "code" : "REM" }, { "name" : "CAPTURE ERROR", "code" : "ERR" }, { "name" : "ASCON - OFFLINE", "code" : "OFF" }, { "name" : "PROPOSED", "code" : "PROP" }, { "name" : "REHABILITATED", "code" : "REH" } ] }, "defaultValue" : null }, { "name" : "SUBTYPECD", "type" : "esriFieldTypeInteger", "alias" : "SubtypeCD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeInteger", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "sPipe Diameter", "codedValues" : [ { "name" : "40 MM", "code" : 40 }, { "name" : "50 MM", "code" : 50 }, { "name" : "60 MM", "code" : 60 }, { "name" : "62 MM", "code" : 62 }, { "name" : "63 MM", "code" : 63 }, { "name" : "65 MM", "code" : 65 }, { "name" : "75 MM", "code" : 75 }, { "name" : "76 MM", "code" : 76 }, { "name" : "80 MM", "code" : 80 }, { "name" : "90 MM", "code" : 90 }, { "name" : "100 MM", "code" : 100 }, { "name" : "110 MM", "code" : 110 }, { "name" : "125 MM", "code" : 125 }, { "name" : "140 MM", "code" : 140 }, { "name" : "150 MM", "code" : 150 }, { "name" : "160 MM", "code" : 160 }, { "name" : "180 MM", "code" : 180 }, { "name" : "200 MM", "code" : 200 }, { "name" : "225 MM", "code" : 225 }, { "name" : "230 MM", "code" : 230 }, { "name" : "250 MM", "code" : 250 }, { "name" : "256 MM", "code" : 256 }, { "name" : "260 MM", "code" : 260 }, { "name" : "275 MM", "code" : 275 }, { "name" : "280 MM", "code" : 280 }, { "name" : "300 MM", "code" : 300 }, { "name" : "315 MM", "code" : 315 }, { "name" : "316 MM", "code" : 316 }, { "name" : "350 MM", "code" : 350 }, { "name" : "355 MM", "code" : 355 }, { "name" : "356 MM", "code" : 356 }, { "name" : "361 MM", "code" : 361 }, { "name" : "375 MM", "code" : 375 }, { "name" : "385 MM", "code" : 385 }, { "name" : "400 MM", "code" : 400 }, { "name" : "410 MM", "code" : 410 }, { "name" : "450 MM", "code" : 450 }, { "name" : "457 MM", "code" : 457 }, { "name" : "460 MM", "code" : 460 }, { "name" : "470 MM", "code" : 470 }, { "name" : "475 MM", "code" : 475 }, { "name" : "500 MM", "code" : 500 }, { "name" : "510 MM", "code" : 510 }, { "name" : "525 MM", "code" : 525 }, { "name" : "534 MM", "code" : 534 }, { "name" : "540 MM", "code" : 540 }, { "name" : "550 MM", "code" : 550 }, { "name" : "554 MM", "code" : 554 }, { "name" : "560 MM", "code" : 560 }, { "name" : "600 MM", "code" : 600 }, { "name" : "610 MM", "code" : 610 }, { "name" : "616 MM", "code" : 616 }, { "name" : "630 MM", "code" : 630 }, { "name" : "635 MM", "code" : 635 }, { "name" : "660 MM", "code" : 660 }, { "name" : "675 MM", "code" : 675 }, { "name" : "700 MM", "code" : 700 }, { "name" : "750 MM", "code" : 750 }, { "name" : "755 MM", "code" : 755 }, { "name" : "760 MM", "code" : 760 }, { "name" : "800 MM", "code" : 800 }, { "name" : "813 MM", "code" : 813 }, { "name" : "825 MM", "code" : 825 }, { "name" : "830 MM", "code" : 830 }, { "name" : "840 MM", "code" : 840 }, { "name" : "850 MM", "code" : 850 }, { "name" : "870 MM", "code" : 870 }, { "name" : "900 MM", "code" : 900 }, { "name" : "910 MM", "code" : 910 }, { "name" : "960 MM", "code" : 960 }, { "name" : "1000 MM", "code" : 1000 }, { "name" : "1050 MM", "code" : 1050 }, { "name" : "1060 MM", "code" : 1060 }, { "name" : "1086 MM", "code" : 1086 }, { "name" : "1140 MM", "code" : 1140 }, { "name" : "1200 MM", "code" : 1200 }, { "name" : "1240 MM", "code" : 1240 }, { "name" : "1275 MM", "code" : 1275 }, { "name" : "1350 MM", "code" : 1350 }, { "name" : "1370 MM", "code" : 1370 }, { "name" : "1400 MM", "code" : 1400 }, { "name" : "1451 MM", "code" : 1451 }, { "name" : "1500 MM", "code" : 1500 }, { "name" : "1575 MM", "code" : 1575 }, { "name" : "1650 MM", "code" : 1650 }, { "name" : "1800 MM", "code" : 1800 }, { "name" : "1840 MM", "code" : 1840 }, { "name" : "2400 MM", "code" : 2400 }, { "name" : "3060 MM", "code" : 3060 }, { "name" : "UNKNOWN", "code" : 0 } ] }, "defaultValue" : null }, { "name" : "CREATEDATE", "type" : "esriFieldTypeDate", "alias" : "Create Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CREATEUSER", "type" : "esriFieldTypeString", "alias" : "Create User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOWNSTREAMIL", "type" : "esriFieldTypeDouble", "alias" : "DownStream IL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STUBLENGTH", "type" : "esriFieldTypeDouble", "alias" : "Stub Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UNIQUEID", "type" : "esriFieldTypeString", "alias" : "Unique ID", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UPDATEDATE", "type" : "esriFieldTypeDate", "alias" : "Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "UPDATEUSER", "type" : "esriFieldTypeString", "alias" : "Update User", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__UU_SEWER__F4B70D85EDB2A162", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_49851.UU_SEWER_SQL_SEWER_MANHOLE_STUB_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "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" : "Sewer Manhole Stub", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "UPDATEDATE" : null, "UPDATEUSER" : null, "STATUS" : null, "SUBTYPECD" : 22601, "DIAMETER" : null, "CREATEDATE" : null, "CREATEUSER" : null, "DOWNSTREAMIL" : null, "STUBLENGTH" : null, "UNIQUEID" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "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", "supportedConvertFileFormats" : "JSON,PBF", "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" : 1000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "SUBTYPECD", "defaultSubtypeCode" : 22601, "subtypes" : [ { "code" : 22601, "name" : "MANHOLE STUB", "defaultValues" : { "STATUS" : null, "SUBTYPECD" : 22601, "DIAMETER" : 150, "CREATEDATE" : null, "CREATEUSER" : null, "DOWNSTREAMIL" : null, "STUBLENGTH" : null, "UNIQUEID" : null, "UPDATEDATE" : null, "UPDATEUSER" : null }, "domains" : { "STATUS" : { "type" : "codedValue", "name" : "cStatus", "codedValues" : [ { "name" : "AS DESIGNED", "code" : "ASDES" }, { "name" : "AS CONSTRUCTED", "code" : "ASCON" }, { "name" : "DE-COMMISSIONED", "code" : "DEC" }, { "name" : "NOT IN USE", "code" : "NIU" }, { "name" : "REMOVED", "code" : "REM" }, { "name" : "CAPTURE ERROR", "code" : "ERR" }, { "name" : "ASCON - OFFLINE", "code" : "OFF" }, { "name" : "PROPOSED", "code" : "PROP" }, { "name" : "REHABILITATED", "code" : "REH" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "sPipe Diameter", "codedValues" : [ { "name" : "40 MM", "code" : 40 }, { "name" : "50 MM", "code" : 50 }, { "name" : "60 MM", "code" : 60 }, { "name" : "62 MM", "code" : 62 }, { "name" : "63 MM", "code" : 63 }, { "name" : "65 MM", "code" : 65 }, { "name" : "75 MM", "code" : 75 }, { "name" : "76 MM", "code" : 76 }, { "name" : "80 MM", "code" : 80 }, { "name" : "90 MM", "code" : 90 }, { "name" : "100 MM", "code" : 100 }, { "name" : "110 MM", "code" : 110 }, { "name" : "125 MM", "code" : 125 }, { "name" : "140 MM", "code" : 140 }, { "name" : "150 MM", "code" : 150 }, { "name" : "160 MM", "code" : 160 }, { "name" : "180 MM", "code" : 180 }, { "name" : "200 MM", "code" : 200 }, { "name" : "225 MM", "code" : 225 }, { "name" : "230 MM", "code" : 230 }, { "name" : "250 MM", "code" : 250 }, { "name" : "256 MM", "code" : 256 }, { "name" : "260 MM", "code" : 260 }, { "name" : "275 MM", "code" : 275 }, { "name" : "280 MM", "code" : 280 }, { "name" : "300 MM", "code" : 300 }, { "name" : "315 MM", "code" : 315 }, { "name" : "316 MM", "code" : 316 }, { "name" : "350 MM", "code" : 350 }, { "name" : "355 MM", "code" : 355 }, { "name" : "356 MM", "code" : 356 }, { "name" : "361 MM", "code" : 361 }, { "name" : "375 MM", "code" : 375 }, { "name" : "385 MM", "code" : 385 }, { "name" : "400 MM", "code" : 400 }, { "name" : "410 MM", "code" : 410 }, { "name" : "450 MM", "code" : 450 }, { "name" : "457 MM", "code" : 457 }, { "name" : "460 MM", "code" : 460 }, { "name" : "470 MM", "code" : 470 }, { "name" : "475 MM", "code" : 475 }, { "name" : "500 MM", "code" : 500 }, { "name" : "510 MM", "code" : 510 }, { "name" : "525 MM", "code" : 525 }, { "name" : "534 MM", "code" : 534 }, { "name" : "540 MM", "code" : 540 }, { "name" : "550 MM", "code" : 550 }, { "name" : "554 MM", "code" : 554 }, { "name" : "560 MM", "code" : 560 }, { "name" : "600 MM", "code" : 600 }, { "name" : "610 MM", "code" : 610 }, { "name" : "616 MM", "code" : 616 }, { "name" : "630 MM", "code" : 630 }, { "name" : "635 MM", "code" : 635 }, { "name" : "660 MM", "code" : 660 }, { "name" : "675 MM", "code" : 675 }, { "name" : "700 MM", "code" : 700 }, { "name" : "750 MM", "code" : 750 }, { "name" : "755 MM", "code" : 755 }, { "name" : "760 MM", "code" : 760 }, { "name" : "800 MM", "code" : 800 }, { "name" : "813 MM", "code" : 813 }, { "name" : "825 MM", "code" : 825 }, { "name" : "830 MM", "code" : 830 }, { "name" : "840 MM", "code" : 840 }, { "name" : "850 MM", "code" : 850 }, { "name" : "870 MM", "code" : 870 }, { "name" : "900 MM", "code" : 900 }, { "name" : "910 MM", "code" : 910 }, { "name" : "960 MM", "code" : 960 }, { "name" : "1000 MM", "code" : 1000 }, { "name" : "1050 MM", "code" : 1050 }, { "name" : "1060 MM", "code" : 1060 }, { "name" : "1086 MM", "code" : 1086 }, { "name" : "1140 MM", "code" : 1140 }, { "name" : "1200 MM", "code" : 1200 }, { "name" : "1240 MM", "code" : 1240 }, { "name" : "1275 MM", "code" : 1275 }, { "name" : "1350 MM", "code" : 1350 }, { "name" : "1370 MM", "code" : 1370 }, { "name" : "1400 MM", "code" : 1400 }, { "name" : "1451 MM", "code" : 1451 }, { "name" : "1500 MM", "code" : 1500 }, { "name" : "1575 MM", "code" : 1575 }, { "name" : "1650 MM", "code" : 1650 }, { "name" : "1800 MM", "code" : 1800 }, { "name" : "1840 MM", "code" : 1840 }, { "name" : "2400 MM", "code" : 2400 }, { "name" : "3060 MM", "code" : 3060 }, { "name" : "UNKNOWN", "code" : 0 } ] } } } ] }