{ "currentVersion" : 12, "id" : 1, "name" : "SSGravityMainToDoSS7604", "type" : "Feature Layer", "serviceItemId" : "93d793e827e54219b202863d90a973b5", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1692630049776, "schemaLastEditDate" : 1692629449255, "dataLastEditDate" : 1692630049776 }, "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" : true, "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" : 144448, "maxScale" : 0, "extent" : { "xmin" : -9023361.9434, "ymin" : 4021774.1385999992, "xmax" : -9015374.6155, "ymax" : 4039140.1908999979, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : true, "allowUpdateWithoutMValues" : true, "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 }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "Facility Identifier", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LEGACYID", "type" : "esriFieldTypeString", "alias" : "Legacy ID", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MATERIAL", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeMaterial", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "ABS Plastic", "code" : "ABS" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Asphalt", "code" : "ASP" }, { "name" : "Brick", "code" : "BR" }, { "name" : "Cast Iron", "code" : "CAS" }, { "name" : "Clay Tile", "code" : "CT" }, { "name" : "Concrete (Non-Reinforced)", "code" : "CP" }, { "name" : "Concrete Segments (Bolted)", "code" : "CSB" }, { "name" : "Concrete Segments (Unbolted)", "code" : "CSU" }, { "name" : "Corrugated Metal", "code" : "CMP" }, { "name" : "Copper", "code" : "COP" }, { "name" : "Cured In Place", "code" : "CIPP" }, { "name" : "Ductile Iron", "code" : "DIP" }, { "name" : "Fiberglass Reinforced", "code" : "FRP" }, { "name" : "Earth & Geotextile", "code" : "EARGEO" }, { "name" : "Earthen", "code" : "EAR" }, { "name" : "Geotextile", "code" : "GEO" }, { "name" : "Galvanized Pipe", "code" : "GP" }, { "name" : "Glass Reinforced Cement", "code" : "GRC" }, { "name" : "Pitch Fiber (Orangeburg)", "code" : "OB" }, { "name" : "Plastic/Steel Composite", "code" : "PSC" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyvinyl Chloride", "code" : "PVC" }, { "name" : "Pre-Stressed Concrete Cylinder", "code" : "PCCP" }, { "name" : "Reinforced Concrete", "code" : "RCP" }, { "name" : "Reinforced Plastic (Truss)", "code" : "RPM" }, { "name" : "Segmented Block", "code" : "SB" }, { "name" : "Steel", "code" : "SP" }, { "name" : "Transite", "code" : "TTE" }, { "name" : "Vitrified Clay", "code" : "VCP" }, { "name" : "Wood", "code" : "WD" }, { "name" : "Other", "code" : "ZZZ" }, { "name" : "Unknown", "code" : "XXX" }, { "name" : "Brick Masonry", "code" : "BMP" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "ESVCP", "code" : "ESVCP" }, { "name" : "HOBAS", "code" : "HOBAS" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Truss", "code" : "TT" } ] }, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeDouble", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "3/4\"", "code" : 0.75 }, { "name" : "1\"", "code" : 1 }, { "name" : "1 1/4\"", "code" : 1.25 }, { "name" : "1 1/2\"", "code" : 1.5 }, { "name" : "2\"", "code" : 2 }, { "name" : "2 1/2\"", "code" : 2.5 }, { "name" : "3\"", "code" : 3 }, { "name" : "4\"", "code" : 4 }, { "name" : "6\"", "code" : 6 }, { "name" : "8\"", "code" : 8 }, { "name" : "10\"", "code" : 10 }, { "name" : "12\"", "code" : 12 }, { "name" : "14\"", "code" : 14 }, { "name" : "15\"", "code" : 15 }, { "name" : "16\"", "code" : 16 }, { "name" : "18\"", "code" : 18 }, { "name" : "20\"", "code" : 20 }, { "name" : "24\"", "code" : 24 }, { "name" : "30\"", "code" : 30 }, { "name" : "36\"", "code" : 36 }, { "name" : "40\"", "code" : 40 }, { "name" : "42\"", "code" : 42 }, { "name" : "48\"", "code" : 48 }, { "name" : "54\"", "code" : 54 }, { "name" : "60\"", "code" : 60 }, { "name" : "66\"", "code" : 66 }, { "name" : "72\"", "code" : 72 }, { "name" : "75\"", "code" : 75 }, { "name" : "Unknown", "code" : 0 }, { "name" : "Other", "code" : -1 }, { "name" : "21\"", "code" : 21 }, { "name" : "22\"", "code" : 22 }, { "name" : "28\"", "code" : 28 }, { "name" : "27\"", "code" : 27 }, { "name" : "1/2\"", "code" : 0.5 }, { "name" : "1 3/4\"", "code" : 1.75 }, { "name" : "32\"", "code" : 32 } ] }, "defaultValue" : null }, { "name" : "MAINSHAPE", "type" : "esriFieldTypeString", "alias" : "Main Shape", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piPipeShape", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Arched", "code" : "A" }, { "name" : "Barrel", "code" : "B" }, { "name" : "Circular", "code" : "C" }, { "name" : "Egg Shaped", "code" : "E" }, { "name" : "Horseshoe", "code" : "H" }, { "name" : "Oval", "code" : "O" }, { "name" : "Rectangular", "code" : "R" }, { "name" : "Square", "code" : "S" }, { "name" : "Trapezoidal", "code" : "T" }, { "name" : "U-shaped", "code" : "U" }, { "name" : "Other", "code" : "Z" } ] }, "defaultValue" : null }, { "name" : "WIDTH", "type" : "esriFieldTypeDouble", "alias" : "Width", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HEIGHT", "type" : "esriFieldTypeDouble", "alias" : "Height", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINEDYEAR", "type" : "esriFieldTypeString", "alias" : "Year Lined", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINERMAT", "type" : "esriFieldTypeString", "alias" : "Liner Material", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LINERTYPE", "type" : "esriFieldTypeString", "alias" : "Liner Type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piLiningMethod", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Cured in Place", "code" : "CP" }, { "name" : "Fold and Form or Deform/Reform", "code" : "FF" }, { "name" : "Segmented Panel", "code" : "SN" }, { "name" : "Segmented Pipe", "code" : "SP" }, { "name" : "Spiral Wound", "code" : "SW" }, { "name" : "None", "code" : "N" } ] }, "defaultValue" : null }, { "name" : "FROMMH", "type" : "esriFieldTypeString", "alias" : "From Manhole", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOMH", "type" : "esriFieldTypeString", "alias" : "To Manhole", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUMFLOW", "type" : "esriFieldTypeDouble", "alias" : "Flow Summary", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DSDEPTHFROMRIM", "type" : "esriFieldTypeDouble", "alias" : "DS Depth From Rim", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOWNELEV", "type" : "esriFieldTypeDouble", "alias" : "Downstream Elevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USDEPTHFROMRIM", "type" : "esriFieldTypeDouble", "alias" : "US Depth From Rim", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UPELEV", "type" : "esriFieldTypeDouble", "alias" : "Upstream Elevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SLOPE", "type" : "esriFieldTypeDouble", "alias" : "Slope", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITION", "type" : "esriFieldTypeSmallInteger", "alias" : "PACP Condition", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PACPCondition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Minor defect grade", "code" : 1 }, { "name" : "Minor to Moderate", "code" : 2 }, { "name" : "Moderate defect grade", "code" : 3 }, { "name" : "Significant", "code" : 4 }, { "name" : "Most significant defect grade", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "Lifecycle Status", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "LifeCycleStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Active", "code" : "Active" }, { "name" : "Inactive", "code" : "Inactive" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Abandoned", "code" : "Abandoned" }, { "name" : "Removed", "code" : "Removed" }, { "name" : "Deleted/DNE", "code" : "Deleted/DNE" } ] }, "defaultValue" : null }, { "name" : "ACTIVEFLAG", "type" : "esriFieldTypeSmallInteger", "alias" : "Active Flag", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BooleanDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "OWNEDBY", "type" : "esriFieldTypeSmallInteger", "alias" : "Owned By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "City of Columbia", "code" : 1 }, { "name" : "Alpine Utilites", "code" : 2 }, { "name" : "Town of Batesburg-Leesville", "code" : 3 }, { "name" : "Bush River Utilites", "code" : 4 }, { "name" : "Carolina Water Service", "code" : 5 }, { "name" : "City of Cayce", "code" : 6 }, { "name" : "Town of Chapin", "code" : 7 }, { "name" : "E. Richland County PSD", "code" : 8 }, { "name" : "Town of Eastover", "code" : 9 }, { "name" : "Fairfield County", "code" : 10 }, { "name" : "Fort Jackson", "code" : 11 }, { "name" : "Town of Lexington", "code" : 12 }, { "name" : "Lexington County JMWSC", "code" : 13 }, { "name" : "Midlands Utility", "code" : 14 }, { "name" : "Mitford Rural WD", "code" : 15 }, { "name" : "City of Newberry", "code" : 16 }, { "name" : "Newberry County WSA", "code" : 17 }, { "name" : "Palmetto of Richland County", "code" : 18 }, { "name" : "Palmetto Utilities", "code" : 19 }, { "name" : "Richland County", "code" : 20 }, { "name" : "Town of Ridgeway", "code" : 21 }, { "name" : "Town of Springdale", "code" : 22 }, { "name" : "Town of Swansea", "code" : 23 }, { "name" : "City of West Columbia", "code" : 24 }, { "name" : "Town of Whitmire", "code" : 25 }, { "name" : "Town of Winnsboro", "code" : 26 }, { "name" : "Univ. of SC", "code" : 27 }, { "name" : "South Carolina", "code" : 28 }, { "name" : "Federal", "code" : 29 }, { "name" : "Private", "code" : -1 }, { "name" : "Unknown", "code" : -2 } ] }, "defaultValue" : 1 }, { "name" : "MAINTBY", "type" : "esriFieldTypeSmallInteger", "alias" : "Managed By", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "AssetManager", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "City of Columbia", "code" : 1 }, { "name" : "Alpine Utilites", "code" : 2 }, { "name" : "Town of Batesburg-Leesville", "code" : 3 }, { "name" : "Bush River Utilites", "code" : 4 }, { "name" : "Carolina Water Service", "code" : 5 }, { "name" : "City of Cayce", "code" : 6 }, { "name" : "Town of Chapin", "code" : 7 }, { "name" : "E. Richland County PSD", "code" : 8 }, { "name" : "Town of Eastover", "code" : 9 }, { "name" : "Fairfield County", "code" : 10 }, { "name" : "Fort Jackson", "code" : 11 }, { "name" : "Town of Lexington", "code" : 12 }, { "name" : "Lexington County JMWSC", "code" : 13 }, { "name" : "Midlands Utility", "code" : 14 }, { "name" : "Mitford Rural WD", "code" : 15 }, { "name" : "City of Newberry", "code" : 16 }, { "name" : "Newberry County WSA", "code" : 17 }, { "name" : "Palmetto of Richland County", "code" : 18 }, { "name" : "Palmetto Utilities", "code" : 19 }, { "name" : "Richland County", "code" : 20 }, { "name" : "Town of Ridgeway", "code" : 21 }, { "name" : "Town of Springdale", "code" : 22 }, { "name" : "Town of Swansea", "code" : 23 }, { "name" : "City of West Columbia", "code" : 24 }, { "name" : "Town of Whitmire", "code" : 25 }, { "name" : "Town of Winnsboro", "code" : 26 }, { "name" : "Univ. of SC", "code" : 27 }, { "name" : "South Carolina", "code" : 28 }, { "name" : "Federal", "code" : 29 }, { "name" : "Private", "code" : -1 }, { "name" : "Unknown", "code" : -2 } ] }, "defaultValue" : 1 }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBBASIN", "type" : "esriFieldTypeString", "alias" : "Subbasin", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATASOURCE", "type" : "esriFieldTypeString", "alias" : "Data Source", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DataSource", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Asbuilt/Record Drawing", "code" : "ASB" }, { "name" : "Design Drawing", "code" : "DES" }, { "name" : "Imagery", "code" : "IMG" }, { "name" : "Mapping Grade GPS", "code" : "MAPGPS" }, { "name" : "Survey Grade GPS", "code" : "SURVGPS" }, { "name" : "Field Survey", "code" : "FLD" }, { "name" : "Service Card", "code" : "SC" }, { "name" : "Tap Card", "code" : "TC" }, { "name" : "Plat", "code" : "PLAT" }, { "name" : "Deed", "code" : "DEED" }, { "name" : "Auto-Generated", "code" : "AUTO" }, { "name" : "Unknown", "code" : "UNK" }, { "name" : "Other", "code" : "OTH" }, { "name" : "Intersection Card", "code" : "CARD" }, { "name" : "CityWorks", "code" : "CityWorks" } ] }, "defaultValue" : null }, { "name" : "DESIGNLENGTH", "type" : "esriFieldTypeDouble", "alias" : "Design Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LASTUPDATE", "type" : "esriFieldTypeDate", "alias" : "Last Update Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTEDITOR", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATOR", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATIONDATE", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LEGACYPIPEASSETID", "type" : "esriFieldTypeString", "alias" : "Legacy Pipe Asset ID", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRECLEANINGTYPE", "type" : "esriFieldTypeString", "alias" : "Pre-Cleaning Type", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "piCleaningType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Jetting", "code" : "J" }, { "name" : "Heavy cleaning", "code" : "H" }, { "name" : "No pre-cleaning", "code" : "N" }, { "name" : "Not known", "code" : "Z" } ] }, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "Enabled", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "CCTVDATE", "type" : "esriFieldTypeDate", "alias" : "CCTV Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CCTV_ID", "type" : "esriFieldTypeString", "alias" : "CCTV Inspection ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INTEGRATIONSTATUS", "type" : "esriFieldTypeString", "alias" : "Integration Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Y" }, { "name" : "No", "code" : "N" } ] }, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "DateInsp", "type" : "esriFieldTypeDate", "alias" : "Date Inspected", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Inspected", "type" : "esriFieldTypeString", "alias" : "Inspected", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ssGravityMain_Inspected_50d3707a-f1e5-4118-85ac-5109b9cf60db", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "TVOP", "type" : "esriFieldTypeString", "alias" : "TV Operator", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CommentsWP", "type" : "esriFieldTypeString", "alias" : "Comments WP", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PipeCleaningLevel", "type" : "esriFieldTypeString", "alias" : "Pipe Cleaning Level", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ssGravityMain_PipeCleaningLevel_2d56c98a-de1d-462f-8ca1-2f5f36cd3b68", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No Pre-Cleaning", "code" : "N" }, { "name" : "Jetting", "code" : "J" }, { "name" : "Heavy Cleaning", "code" : "H" } ] }, "defaultValue" : null }, { "name" : "Cleaning_Comments", "type" : "esriFieldTypeString", "alias" : "Cleaning Comments", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DateCleaned", "type" : "esriFieldTypeDate", "alias" : "Date Cleaned", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ReCleaning_Needed", "type" : "esriFieldTypeString", "alias" : "Re-Cleaning Needed", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ssGravityMain_ReCleaning_Needed_92122467-5b05-470d-8452-483a8d5fc404", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "Pipe_ReCleaning_Level", "type" : "esriFieldTypeString", "alias" : "Pipe Re-Cleaning Level", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ssGravityMain_Pipe_ReCleaning_Level_828e822a-1b1c-4094-8c51-ac4b299c331d", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No Pre-Cleaning", "code" : "N" }, { "name" : "Jetting", "code" : "J" }, { "name" : "Heavy Cleaning", "code" : "H" } ] }, "defaultValue" : null }, { "name" : "ReCleaned_Date", "type" : "esriFieldTypeDate", "alias" : "Re-Cleaned Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CCTV_Revisit_Complete", "type" : "esriFieldTypeString", "alias" : "CCTV Revisit Complete", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ssGravityMain_CCTV_Revisit_Complete_117e99d5-7c9b-40c8-884a-eeebe0c97708", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "Full_Asset_Name", "type" : "esriFieldTypeString", "alias" : "Full Asset Name", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Diameter_1", "type" : "esriFieldTypeInteger", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pipe_Length", "type" : "esriFieldTypeInteger", "alias" : "Pipe Length", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Subbasin_1", "type" : "esriFieldTypeString", "alias" : "Subbasin", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Inspection_Type", "type" : "esriFieldTypeString", "alias" : "Inspection Type", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CCTVComplete", "type" : "esriFieldTypeString", "alias" : "CCTV Complete?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "CompletionStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not yet attempted", "code" : "Not yet attempted" }, { "name" : "Reverse setup required", "code" : "Reverse setup required " }, { "name" : "Complete", "code" : "Complete" }, { "name" : "Complete (MSA)", "code" : "Complete (MSA) " }, { "name" : "Other (Client Action Needed)", "code" : "Other (Client Action Needed) " } ] }, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__CSAP_SS___F4B70D85D09D4A12", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_35767.CSAP_SS_TODO_SSGRAVITYMAINTODOSS7604_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "CCTVComplete_Index", "fields" : "CCTVComplete", "isAscending" : true, "isUnique" : false, "description" : "CCTVComplete_Index", "indexType" : "Attribute" }, { "name" : "CCTVDATE_Index", "fields" : "CCTVDATE", "isAscending" : true, "isUnique" : false, "description" : "CCTVDATE_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "FACILITYID" : null, "LEGACYID" : null, "INSTALLDATE" : null, "MATERIAL" : null, "DIAMETER" : null, "MAINSHAPE" : null, "WIDTH" : null, "HEIGHT" : null, "LINEDYEAR" : null, "LINERMAT" : null, "LINERTYPE" : null, "FROMMH" : null, "TOMH" : null, "SUMFLOW" : null, "DSDEPTHFROMRIM" : null, "DOWNELEV" : null, "USDEPTHFROMRIM" : null, "UPELEV" : null, "SLOPE" : null, "CONDITION" : null, "LIFECYCLESTATUS" : null, "ACTIVEFLAG" : 1, "OWNEDBY" : 1, "MAINTBY" : 1, "LOCATION" : null, "SUBBASIN" : null, "COMMENTS" : null, "DATASOURCE" : null, "DESIGNLENGTH" : null, "LASTUPDATE" : null, "LASTEDITOR" : null, "CREATOR" : null, "CREATIONDATE" : null, "LEGACYPIPEASSETID" : null, "PRECLEANINGTYPE" : null, "ENABLED" : 1, "CCTVDATE" : null, "CCTV_ID" : null, "INTEGRATIONSTATUS" : null, "DateInsp" : null, "Inspected" : null, "TVOP" : null, "CommentsWP" : null, "PipeCleaningLevel" : null, "Cleaning_Comments" : null, "DateCleaned" : null, "ReCleaning_Needed" : null, "Pipe_ReCleaning_Level" : null, "ReCleaned_Date" : null, "CCTV_Revisit_Complete" : null, "Full_Asset_Name" : null, "Diameter_1" : null, "Pipe_Length" : null, "Subbasin_1" : null, "Inspection_Type" : null, "CCTVComplete" : 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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }