{ "currentVersion" : 12, "id" : 5, "name" : "Rockford_Pipe", "type" : "Feature Layer", "serviceItemId" : "0296280492aa40e38e24ccc71b8c25ed", "cacheMaxAge" : 30, "displayField" : "LifeCycleStatus", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1620685591113, "schemaLastEditDate" : 1620685591113, "dataLastEditDate" : 1620685591113 }, "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" : "esriFeet" }, "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" : 2582212.7968228385, "ymin" : 2051550.3625249269, "xmax" : 2586040.7819490023, "ymax" : 2053211.3323000968, "spatialReference" : { "wkid" : 102672, "latestWkid" : 3436 } }, "spatialReference" : { "wkid" : 102672, "latestWkid" : 3436 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Subtype","field2":null,"field3":null,"defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[16,0,156,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[34,0,171,255],"width":1},"value":"1","label":"At Grade","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,158,8,255],"width":1},"value":"2","label":"Below Grade","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,161,118,255],"width":1},"value":"3","label":"Connector","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "Subtype", "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" : "LifeCycleStatus", "type" : "esriFieldTypeString", "alias" : "LifeCycleStatus", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dLifecycleStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Active", "code" : "Active" }, { "name" : "Abandoned", "code" : "Abandoned" }, { "name" : "Killed", "code" : "Killed" }, { "name" : "Removed", "code" : "Removed" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Completed", "code" : "Completed" }, { "name" : "Under Construction", "code" : "Construct" } ] }, "defaultValue" : null }, { "name" : "Material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dSwRefMat", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Asbestos Cement Pipe (ACP)", "code" : "ACP" }, { "name" : "Brick (BR)", "code" : "BR" }, { "name" : "Ductile Iron (DIP)", "code" : "DIP" }, { "name" : "Polyvinylchloride (PVC)", "code" : "PVC" }, { "name" : "Lined", "code" : "Lined" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Reinforced Concrete (RCP)", "code" : "RCP" }, { "name" : "Corrugated Metal (CMP)", "code" : "CMP" }, { "name" : "High Density Polyethylene (HDPE)", "code" : "HDPE" }, { "name" : "Steel", "code" : "Steel" }, { "name" : "Corrugated Plastic Pipe (CPP)", "code" : "CPP" }, { "name" : "Clay", "code" : "Clay" }, { "name" : "Prestressed Concrete Cylinder Pipe (PCCP)", "code" : "PCCP" }, { "name" : "Portland Concrete Cement (PCC)", "code" : "PCC" }, { "name" : "Vitrified Clay Pipe (VCP)", "code" : "VCP" } ] }, "defaultValue" : null }, { "name" : "GroundType", "type" : "esriFieldTypeString", "alias" : "Ground Type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dGroundType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Unknown", "code" : "Unk" }, { "name" : "Dirt", "code" : "Dirt" }, { "name" : "Asphalt", "code" : "Asphalt" }, { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Asphalt/Street", "code" : "AS" }, { "name" : "Concrete/Sidewalk", "code" : "CS" }, { "name" : "Grass", "code" : "Grass" }, { "name" : "Gravel", "code" : "Gravel" }, { "name" : "Grass/Parkway", "code" : "GRSSPKWY" } ] }, "defaultValue" : null }, { "name" : "PipeShape", "type" : "esriFieldTypeString", "alias" : "Pipe Shape", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dSwShape", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Arch", "code" : "Arch" }, { "name" : "Box", "code" : "Box" }, { "name" : "Circular", "code" : "Circular" }, { "name" : "Elliptical", "code" : "Elliptical" }, { "name" : "Other", "code" : "Other" }, { "name" : "Rectangle", "code" : "Rectangle" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Parabolic", "code" : "Parabolic" }, { "name" : "Trapezoid", "code" : "Trapezoid" } ] }, "defaultValue" : null }, { "name" : "Slope", "type" : "esriFieldTypeDouble", "alias" : "Slope", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FromCondition", "type" : "esriFieldTypeString", "alias" : "From Condition", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dSwPCondition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "defaultValue" : null }, { "name" : "ToCondition", "type" : "esriFieldTypeString", "alias" : "To Condition", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dSwPCondition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "defaultValue" : null }, { "name" : "ConstNum", "type" : "esriFieldTypeString", "alias" : "ConstNum", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "InspectedBy", "type" : "esriFieldTypeString", "alias" : "Inspected By", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "InspectedDate", "type" : "esriFieldTypeDate", "alias" : "Inspected Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ModifiedBy", "type" : "esriFieldTypeString", "alias" : "Modified By", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ModifiedDate", "type" : "esriFieldTypeDate", "alias" : "Modified Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ownership", "type" : "esriFieldTypeString", "alias" : "Ownership", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dOwnership", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Private", "code" : "Private" }, { "name" : "Rockford", "code" : "Rockford" }, { "name" : "Loves Park", "code" : "LP" }, { "name" : "Cherry Valley", "code" : "CV" }, { "name" : "Township", "code" : "Township" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "County", "code" : "County" }, { "name" : "ComEd", "code" : "ComEd" }, { "name" : "State", "code" : "State" }, { "name" : "Railroad", "code" : "Railroad" }, { "name" : "IDOT", "code" : "IDOT" }, { "name" : "Rockford Park District", "code" : "RPD" } ] }, "defaultValue" : null }, { "name" : "SharePointLink", "type" : "esriFieldTypeString", "alias" : "SharePointLink", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DataSource", "type" : "esriFieldTypeString", "alias" : "DataSource", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dDataSource", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "As-Built Drawing", "code" : "Asbuilt" }, { "name" : "Engineering Drawing", "code" : "EngDrawing" }, { "name" : "Auto Generated", "code" : "Auto" }, { "name" : "GPS", "code" : "GPS" }, { "name" : "Field Verified", "code" : "Field" }, { "name" : "Field Services", "code" : "FS" }, { "name" : "Distribution", "code" : "Dist" }, { "name" : "Service Card", "code" : "SC" }, { "name" : "Legal Agreement", "code" : "Legal" }, { "name" : "Plumbing Permits", "code" : "PM" } ] }, "defaultValue" : null }, { "name" : "Location", "type" : "esriFieldTypeString", "alias" : "Location", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Watershed", "type" : "esriFieldTypeString", "alias" : "Watershed", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dWatershed", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Airport East", "code" : "AE" }, { "name" : "Blackhawk", "code" : "BH" }, { "name" : "Forest Hills", "code" : "FH" }, { "name" : "Fuller Creek", "code" : "FC" }, { "name" : "Keith Creek", "code" : "Keith" }, { "name" : "Kishwaukee North", "code" : "KN" }, { "name" : "Madigan Creek", "code" : "MAC" }, { "name" : "Manning Creek", "code" : "MC" }, { "name" : "North Main", "code" : "NM" }, { "name" : "Riverside", "code" : "R" }, { "name" : "Sinnissippi", "code" : "S" }, { "name" : "South Main", "code" : "SM" }, { "name" : "Spring Creek", "code" : "SC" }, { "name" : "Kent Creek", "code" : "KC" }, { "name" : "Klehm", "code" : "K" }, { "name" : "Buckbee", "code" : "B" }, { "name" : "Kishwaukee South", "code" : "KS" }, { "name" : "Killbuck Creek", "code" : "KBC" } ] }, "defaultValue" : null }, { "name" : "YearLined", "type" : "esriFieldTypeString", "alias" : "Year Lined", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YearTelevised", "type" : "esriFieldTypeString", "alias" : "Year Televised", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Subtype", "type" : "esriFieldTypeSmallInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dSwPSubtype", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "At Grade", "code" : 1 }, { "name" : "Below Grade", "code" : 2 }, { "name" : "Connector", "code" : 3 } ] }, "defaultValue" : null }, { "name" : "Perforated", "type" : "esriFieldTypeSmallInteger", "alias" : "Perforated", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dBooleanSymbolValue", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 0 } ] }, "defaultValue" : null }, { "name" : "UnitID", "type" : "esriFieldTypeString", "alias" : "UpStructureID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UnitID2", "type" : "esriFieldTypeString", "alias" : "DownStructureID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MainComp1", "type" : "esriFieldTypeSmallInteger", "alias" : "MainComp1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MainComp2", "type" : "esriFieldTypeSmallInteger", "alias" : "MainComp2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CompType", "type" : "esriFieldTypeSmallInteger", "alias" : "CompType", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CompKey", "type" : "esriFieldTypeInteger", "alias" : "CompKey", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "InstDate", "type" : "esriFieldTypeDate", "alias" : "InstDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "InstYear", "type" : "esriFieldTypeString", "alias" : "InstYear", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PipeID", "type" : "esriFieldTypeString", "alias" : "PipeID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cues_Total_Pipe_Score", "type" : "esriFieldTypeDouble", "alias" : "Cues Total Pipe Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cues_Maximum_Score", "type" : "esriFieldTypeDouble", "alias" : "Cues Maximum Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cues_Mean_Score", "type" : "esriFieldTypeDouble", "alias" : "Cues Mean Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UpInvertElev", "type" : "esriFieldTypeDouble", "alias" : "UpInvertElev", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DwnInvertElev", "type" : "esriFieldTypeDouble", "alias" : "DwnInvertElev", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RecordedLen", "type" : "esriFieldTypeDouble", "alias" : "RecordedLen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PipeLen", "type" : "esriFieldTypeDouble", "alias" : "PipeLen", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PipeHt", "type" : "esriFieldTypeDouble", "alias" : "PipeHt", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PipeWidth", "type" : "esriFieldTypeDouble", "alias" : "PipeWidth", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PipeDiam", "type" : "esriFieldTypeDouble", "alias" : "PipeDiam", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "dSwPDiam", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "4 in.", "code" : 4 }, { "name" : "5 in.", "code" : 5 }, { "name" : "6 in.", "code" : 6 }, { "name" : "7 in.", "code" : 7 }, { "name" : "8 in.", "code" : 8 }, { "name" : "9 in.", "code" : 9 }, { "name" : "10 in.", "code" : 10 }, { "name" : "12 in.", "code" : 12 }, { "name" : "14 in.", "code" : 14 }, { "name" : "15 in.", "code" : 15 }, { "name" : "16 in.", "code" : 16 }, { "name" : "17 in.", "code" : 17 }, { "name" : "18 in.", "code" : 18 }, { "name" : "20 in.", "code" : 20 }, { "name" : "21 in.", "code" : 21 }, { "name" : "22 in.", "code" : 22 }, { "name" : "24 in.", "code" : 24 }, { "name" : "26 in.", "code" : 26 }, { "name" : "27 in.", "code" : 27 }, { "name" : "28 in.", "code" : 28 }, { "name" : "30 in.", "code" : 30 }, { "name" : "32 in.", "code" : 32 }, { "name" : "33 in.", "code" : 33 }, { "name" : "35 in.", "code" : 35 }, { "name" : "36 in.", "code" : 36 }, { "name" : "38 in.", "code" : 38 }, { "name" : "39 in.", "code" : 39 }, { "name" : "40 in.", "code" : 40 }, { "name" : "42 in.", "code" : 42 }, { "name" : "45 in.", "code" : 45 }, { "name" : "46 in.", "code" : 46 }, { "name" : "48 in.", "code" : 48 }, { "name" : "54 in.", "code" : 54 }, { "name" : "60 in.", "code" : 60 }, { "name" : "66 in.", "code" : 66 }, { "name" : "72 in.", "code" : 72 }, { "name" : "78 in.", "code" : 78 } ] }, "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" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "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__KILBURNA__F4B70D852C50BC54", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_22116.KILBURNAVESTORNMAP_ROCKFORD_PIPE_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "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" : "PipeID_Index", "fields" : "PipeID", "isAscending" : true, "isUnique" : false, "description" : "PipeID_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 1, "name" : "At Grade", "domains" : { "LifeCycleStatus" : {"type" : "inherited"}, "Material" : {"type" : "inherited"}, "GroundType" : {"type" : "inherited"}, "PipeShape" : {"type" : "inherited"}, "FromCondition" : {"type" : "inherited"}, "ToCondition" : {"type" : "inherited"}, "Ownership" : {"type" : "inherited"}, "DataSource" : {"type" : "inherited"}, "Watershed" : {"type" : "inherited"}, "Perforated" : {"type" : "inherited"}, "PipeDiam" : {"type" : "inherited"}, "Enabled" : {"type" : "inherited"} }, "templates" : [ { "name" : "At Grade", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "YearTelevised" : null, "PipeDiam" : null, "Enabled" : 1, "LifeCycleStatus" : null, "Material" : null, "GroundType" : null, "PipeShape" : null, "Slope" : null, "FromCondition" : null, "ToCondition" : null, "ConstNum" : null, "InspectedBy" : null, "InspectedDate" : null, "ModifiedBy" : null, "ModifiedDate" : null, "Comments" : null, "Ownership" : null, "SharePointLink" : null, "DataSource" : null, "Location" : null, "Watershed" : null, "YearLined" : null, "Subtype" : 1, "Perforated" : null, "UnitID" : null, "UnitID2" : null, "MainComp1" : null, "MainComp2" : null, "CompType" : null, "CompKey" : null, "InstDate" : null, "InstYear" : null, "PipeID" : null, "Cues_Total_Pipe_Score" : null, "Cues_Maximum_Score" : null, "Cues_Mean_Score" : null, "UpInvertElev" : null, "DwnInvertElev" : null, "RecordedLen" : null, "PipeLen" : null, "PipeHt" : null, "PipeWidth" : null } } } ] }, { "id" : 2, "name" : "Below Grade", "domains" : { "LifeCycleStatus" : {"type" : "inherited"}, "Material" : {"type" : "inherited"}, "GroundType" : {"type" : "inherited"}, "PipeShape" : {"type" : "inherited"}, "FromCondition" : {"type" : "inherited"}, "ToCondition" : {"type" : "inherited"}, "Ownership" : {"type" : "inherited"}, "DataSource" : {"type" : "inherited"}, "Watershed" : {"type" : "inherited"}, "Perforated" : {"type" : "inherited"}, "PipeDiam" : {"type" : "inherited"}, "Enabled" : {"type" : "inherited"} }, "templates" : [ { "name" : "Below Grade", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "YearTelevised" : null, "PipeDiam" : null, "Enabled" : 1, "LifeCycleStatus" : null, "Material" : null, "GroundType" : null, "PipeShape" : null, "Slope" : null, "FromCondition" : null, "ToCondition" : null, "ConstNum" : null, "InspectedBy" : null, "InspectedDate" : null, "ModifiedBy" : null, "ModifiedDate" : null, "Comments" : null, "Ownership" : null, "SharePointLink" : null, "DataSource" : null, "Location" : null, "Watershed" : null, "YearLined" : null, "Subtype" : 2, "Perforated" : null, "UnitID" : null, "UnitID2" : null, "MainComp1" : null, "MainComp2" : null, "CompType" : null, "CompKey" : null, "InstDate" : null, "InstYear" : null, "PipeID" : null, "Cues_Total_Pipe_Score" : null, "Cues_Maximum_Score" : null, "Cues_Mean_Score" : null, "UpInvertElev" : null, "DwnInvertElev" : null, "RecordedLen" : null, "PipeLen" : null, "PipeHt" : null, "PipeWidth" : null } } } ] }, { "id" : 3, "name" : "Connector", "domains" : { "LifeCycleStatus" : {"type" : "inherited"}, "Material" : {"type" : "inherited"}, "GroundType" : {"type" : "inherited"}, "PipeShape" : {"type" : "inherited"}, "FromCondition" : {"type" : "inherited"}, "ToCondition" : {"type" : "inherited"}, "Ownership" : {"type" : "inherited"}, "DataSource" : {"type" : "inherited"}, "Watershed" : {"type" : "inherited"}, "Perforated" : {"type" : "inherited"}, "PipeDiam" : {"type" : "inherited"}, "Enabled" : {"type" : "inherited"} }, "templates" : [ { "name" : "Connector", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "YearTelevised" : null, "PipeDiam" : null, "Enabled" : 1, "LifeCycleStatus" : null, "Material" : null, "GroundType" : null, "PipeShape" : null, "Slope" : null, "FromCondition" : null, "ToCondition" : null, "ConstNum" : null, "InspectedBy" : null, "InspectedDate" : null, "ModifiedBy" : null, "ModifiedDate" : null, "Comments" : null, "Ownership" : null, "SharePointLink" : null, "DataSource" : null, "Location" : null, "Watershed" : null, "YearLined" : null, "Subtype" : 3, "Perforated" : null, "UnitID" : null, "UnitID2" : null, "MainComp1" : null, "MainComp2" : null, "CompType" : null, "CompKey" : null, "InstDate" : null, "InstYear" : null, "PipeID" : null, "Cues_Total_Pipe_Score" : null, "Cues_Maximum_Score" : null, "Cues_Mean_Score" : null, "UpInvertElev" : null, "DwnInvertElev" : null, "RecordedLen" : null, "PipeLen" : null, "PipeHt" : null, "PipeWidth" : null } } } ] } ], "templates" : [], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "Subtype", "defaultSubtypeCode" : 2, "subtypes" : [ { "code" : 1, "name" : "At Grade", "defaultValues" : { "LifeCycleStatus" : null, "Material" : null, "GroundType" : null, "PipeShape" : null, "Slope" : null, "FromCondition" : null, "ToCondition" : null, "ConstNum" : null, "InspectedBy" : null, "InspectedDate" : null, "ModifiedBy" : null, "ModifiedDate" : null, "Comments" : null, "Ownership" : null, "SharePointLink" : null, "DataSource" : null, "Location" : null, "Watershed" : null, "YearLined" : null, "YearTelevised" : null, "Subtype" : 1, "Perforated" : null, "UnitID" : null, "UnitID2" : null, "MainComp1" : null, "MainComp2" : null, "CompType" : null, "CompKey" : null, "InstDate" : null, "InstYear" : null, "PipeID" : null, "Cues_Total_Pipe_Score" : null, "Cues_Maximum_Score" : null, "Cues_Mean_Score" : null, "UpInvertElev" : null, "DwnInvertElev" : null, "RecordedLen" : null, "PipeLen" : null, "PipeHt" : null, "PipeWidth" : null, "PipeDiam" : null, "Enabled" : 1 }, "domains" : { "LifeCycleStatus" : { "type" : "codedValue", "name" : "dLifecycleStatus", "codedValues" : [ { "name" : "Active", "code" : "Active" }, { "name" : "Abandoned", "code" : "Abandoned" }, { "name" : "Killed", "code" : "Killed" }, { "name" : "Removed", "code" : "Removed" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Completed", "code" : "Completed" }, { "name" : "Under Construction", "code" : "Construct" } ] }, "Material" : { "type" : "codedValue", "name" : "dSwRefMat", "codedValues" : [ { "name" : "Asbestos Cement Pipe (ACP)", "code" : "ACP" }, { "name" : "Brick (BR)", "code" : "BR" }, { "name" : "Ductile Iron (DIP)", "code" : "DIP" }, { "name" : "Polyvinylchloride (PVC)", "code" : "PVC" }, { "name" : "Lined", "code" : "Lined" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Reinforced Concrete (RCP)", "code" : "RCP" }, { "name" : "Corrugated Metal (CMP)", "code" : "CMP" }, { "name" : "High Density Polyethylene (HDPE)", "code" : "HDPE" }, { "name" : "Steel", "code" : "Steel" }, { "name" : "Corrugated Plastic Pipe (CPP)", "code" : "CPP" }, { "name" : "Clay", "code" : "Clay" }, { "name" : "Prestressed Concrete Cylinder Pipe (PCCP)", "code" : "PCCP" }, { "name" : "Portland Concrete Cement (PCC)", "code" : "PCC" }, { "name" : "Vitrified Clay Pipe (VCP)", "code" : "VCP" } ] }, "GroundType" : { "type" : "codedValue", "name" : "dGroundType", "codedValues" : [ { "name" : "Unknown", "code" : "Unk" }, { "name" : "Dirt", "code" : "Dirt" }, { "name" : "Asphalt", "code" : "Asphalt" }, { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Asphalt/Street", "code" : "AS" }, { "name" : "Concrete/Sidewalk", "code" : "CS" }, { "name" : "Grass", "code" : "Grass" }, { "name" : "Gravel", "code" : "Gravel" }, { "name" : "Grass/Parkway", "code" : "GRSSPKWY" } ] }, "PipeShape" : { "type" : "codedValue", "name" : "dSwShape", "codedValues" : [ { "name" : "Arch", "code" : "Arch" }, { "name" : "Box", "code" : "Box" }, { "name" : "Circular", "code" : "Circular" }, { "name" : "Elliptical", "code" : "Elliptical" }, { "name" : "Other", "code" : "Other" }, { "name" : "Rectangle", "code" : "Rectangle" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Parabolic", "code" : "Parabolic" }, { "name" : "Trapezoid", "code" : "Trapezoid" } ] }, "FromCondition" : { "type" : "codedValue", "name" : "dSwPCondition", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "ToCondition" : { "type" : "codedValue", "name" : "dSwPCondition", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "Ownership" : { "type" : "codedValue", "name" : "dOwnership", "codedValues" : [ { "name" : "Private", "code" : "Private" }, { "name" : "Rockford", "code" : "Rockford" }, { "name" : "Loves Park", "code" : "LP" }, { "name" : "Cherry Valley", "code" : "CV" }, { "name" : "Township", "code" : "Township" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "County", "code" : "County" }, { "name" : "ComEd", "code" : "ComEd" }, { "name" : "State", "code" : "State" }, { "name" : "Railroad", "code" : "Railroad" }, { "name" : "IDOT", "code" : "IDOT" }, { "name" : "Rockford Park District", "code" : "RPD" } ] }, "DataSource" : { "type" : "codedValue", "name" : "dDataSource", "codedValues" : [ { "name" : "As-Built Drawing", "code" : "Asbuilt" }, { "name" : "Engineering Drawing", "code" : "EngDrawing" }, { "name" : "Auto Generated", "code" : "Auto" }, { "name" : "GPS", "code" : "GPS" }, { "name" : "Field Verified", "code" : "Field" }, { "name" : "Field Services", "code" : "FS" }, { "name" : "Distribution", "code" : "Dist" }, { "name" : "Service Card", "code" : "SC" }, { "name" : "Legal Agreement", "code" : "Legal" }, { "name" : "Plumbing Permits", "code" : "PM" } ] }, "Watershed" : { "type" : "codedValue", "name" : "dWatershed", "codedValues" : [ { "name" : "Airport East", "code" : "AE" }, { "name" : "Blackhawk", "code" : "BH" }, { "name" : "Forest Hills", "code" : "FH" }, { "name" : "Fuller Creek", "code" : "FC" }, { "name" : "Keith Creek", "code" : "Keith" }, { "name" : "Kishwaukee North", "code" : "KN" }, { "name" : "Madigan Creek", "code" : "MAC" }, { "name" : "Manning Creek", "code" : "MC" }, { "name" : "North Main", "code" : "NM" }, { "name" : "Riverside", "code" : "R" }, { "name" : "Sinnissippi", "code" : "S" }, { "name" : "South Main", "code" : "SM" }, { "name" : "Spring Creek", "code" : "SC" }, { "name" : "Kent Creek", "code" : "KC" }, { "name" : "Klehm", "code" : "K" }, { "name" : "Buckbee", "code" : "B" }, { "name" : "Kishwaukee South", "code" : "KS" }, { "name" : "Killbuck Creek", "code" : "KBC" } ] }, "Perforated" : { "type" : "codedValue", "name" : "dBooleanSymbolValue", "codedValues" : [ { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 0 } ] }, "PipeDiam" : { "type" : "codedValue", "name" : "dSwPDiam", "codedValues" : [ { "name" : "4 in.", "code" : 4 }, { "name" : "5 in.", "code" : 5 }, { "name" : "6 in.", "code" : 6 }, { "name" : "7 in.", "code" : 7 }, { "name" : "8 in.", "code" : 8 }, { "name" : "9 in.", "code" : 9 }, { "name" : "10 in.", "code" : 10 }, { "name" : "12 in.", "code" : 12 }, { "name" : "14 in.", "code" : 14 }, { "name" : "15 in.", "code" : 15 }, { "name" : "16 in.", "code" : 16 }, { "name" : "17 in.", "code" : 17 }, { "name" : "18 in.", "code" : 18 }, { "name" : "20 in.", "code" : 20 }, { "name" : "21 in.", "code" : 21 }, { "name" : "22 in.", "code" : 22 }, { "name" : "24 in.", "code" : 24 }, { "name" : "26 in.", "code" : 26 }, { "name" : "27 in.", "code" : 27 }, { "name" : "28 in.", "code" : 28 }, { "name" : "30 in.", "code" : 30 }, { "name" : "32 in.", "code" : 32 }, { "name" : "33 in.", "code" : 33 }, { "name" : "35 in.", "code" : 35 }, { "name" : "36 in.", "code" : 36 }, { "name" : "38 in.", "code" : 38 }, { "name" : "39 in.", "code" : 39 }, { "name" : "40 in.", "code" : 40 }, { "name" : "42 in.", "code" : 42 }, { "name" : "45 in.", "code" : 45 }, { "name" : "46 in.", "code" : 46 }, { "name" : "48 in.", "code" : 48 }, { "name" : "54 in.", "code" : 54 }, { "name" : "60 in.", "code" : 60 }, { "name" : "66 in.", "code" : 66 }, { "name" : "72 in.", "code" : 72 }, { "name" : "78 in.", "code" : 78 } ] }, "Enabled" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] } } }, { "code" : 2, "name" : "Below Grade", "defaultValues" : { "LifeCycleStatus" : null, "Material" : null, "GroundType" : null, "PipeShape" : null, "Slope" : null, "FromCondition" : null, "ToCondition" : null, "ConstNum" : null, "InspectedBy" : null, "InspectedDate" : null, "ModifiedBy" : null, "ModifiedDate" : null, "Comments" : null, "Ownership" : null, "SharePointLink" : null, "DataSource" : null, "Location" : null, "Watershed" : null, "YearLined" : null, "YearTelevised" : null, "Subtype" : 2, "Perforated" : null, "UnitID" : null, "UnitID2" : null, "MainComp1" : null, "MainComp2" : null, "CompType" : null, "CompKey" : null, "InstDate" : null, "InstYear" : null, "PipeID" : null, "Cues_Total_Pipe_Score" : null, "Cues_Maximum_Score" : null, "Cues_Mean_Score" : null, "UpInvertElev" : null, "DwnInvertElev" : null, "RecordedLen" : null, "PipeLen" : null, "PipeHt" : null, "PipeWidth" : null, "PipeDiam" : null, "Enabled" : 1 }, "domains" : { "LifeCycleStatus" : { "type" : "codedValue", "name" : "dLifecycleStatus", "codedValues" : [ { "name" : "Active", "code" : "Active" }, { "name" : "Abandoned", "code" : "Abandoned" }, { "name" : "Killed", "code" : "Killed" }, { "name" : "Removed", "code" : "Removed" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Completed", "code" : "Completed" }, { "name" : "Under Construction", "code" : "Construct" } ] }, "Material" : { "type" : "codedValue", "name" : "dSwRefMat", "codedValues" : [ { "name" : "Asbestos Cement Pipe (ACP)", "code" : "ACP" }, { "name" : "Brick (BR)", "code" : "BR" }, { "name" : "Ductile Iron (DIP)", "code" : "DIP" }, { "name" : "Polyvinylchloride (PVC)", "code" : "PVC" }, { "name" : "Lined", "code" : "Lined" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Reinforced Concrete (RCP)", "code" : "RCP" }, { "name" : "Corrugated Metal (CMP)", "code" : "CMP" }, { "name" : "High Density Polyethylene (HDPE)", "code" : "HDPE" }, { "name" : "Steel", "code" : "Steel" }, { "name" : "Corrugated Plastic Pipe (CPP)", "code" : "CPP" }, { "name" : "Clay", "code" : "Clay" }, { "name" : "Prestressed Concrete Cylinder Pipe (PCCP)", "code" : "PCCP" }, { "name" : "Portland Concrete Cement (PCC)", "code" : "PCC" }, { "name" : "Vitrified Clay Pipe (VCP)", "code" : "VCP" } ] }, "GroundType" : { "type" : "codedValue", "name" : "dGroundType", "codedValues" : [ { "name" : "Unknown", "code" : "Unk" }, { "name" : "Dirt", "code" : "Dirt" }, { "name" : "Asphalt", "code" : "Asphalt" }, { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Asphalt/Street", "code" : "AS" }, { "name" : "Concrete/Sidewalk", "code" : "CS" }, { "name" : "Grass", "code" : "Grass" }, { "name" : "Gravel", "code" : "Gravel" }, { "name" : "Grass/Parkway", "code" : "GRSSPKWY" } ] }, "PipeShape" : { "type" : "codedValue", "name" : "dSwShape", "codedValues" : [ { "name" : "Arch", "code" : "Arch" }, { "name" : "Box", "code" : "Box" }, { "name" : "Circular", "code" : "Circular" }, { "name" : "Elliptical", "code" : "Elliptical" }, { "name" : "Other", "code" : "Other" }, { "name" : "Rectangle", "code" : "Rectangle" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Parabolic", "code" : "Parabolic" }, { "name" : "Trapezoid", "code" : "Trapezoid" } ] }, "FromCondition" : { "type" : "codedValue", "name" : "dSwPCondition", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "ToCondition" : { "type" : "codedValue", "name" : "dSwPCondition", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "Ownership" : { "type" : "codedValue", "name" : "dOwnership", "codedValues" : [ { "name" : "Private", "code" : "Private" }, { "name" : "Rockford", "code" : "Rockford" }, { "name" : "Loves Park", "code" : "LP" }, { "name" : "Cherry Valley", "code" : "CV" }, { "name" : "Township", "code" : "Township" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "County", "code" : "County" }, { "name" : "ComEd", "code" : "ComEd" }, { "name" : "State", "code" : "State" }, { "name" : "Railroad", "code" : "Railroad" }, { "name" : "IDOT", "code" : "IDOT" }, { "name" : "Rockford Park District", "code" : "RPD" } ] }, "DataSource" : { "type" : "codedValue", "name" : "dDataSource", "codedValues" : [ { "name" : "As-Built Drawing", "code" : "Asbuilt" }, { "name" : "Engineering Drawing", "code" : "EngDrawing" }, { "name" : "Auto Generated", "code" : "Auto" }, { "name" : "GPS", "code" : "GPS" }, { "name" : "Field Verified", "code" : "Field" }, { "name" : "Field Services", "code" : "FS" }, { "name" : "Distribution", "code" : "Dist" }, { "name" : "Service Card", "code" : "SC" }, { "name" : "Legal Agreement", "code" : "Legal" }, { "name" : "Plumbing Permits", "code" : "PM" } ] }, "Watershed" : { "type" : "codedValue", "name" : "dWatershed", "codedValues" : [ { "name" : "Airport East", "code" : "AE" }, { "name" : "Blackhawk", "code" : "BH" }, { "name" : "Forest Hills", "code" : "FH" }, { "name" : "Fuller Creek", "code" : "FC" }, { "name" : "Keith Creek", "code" : "Keith" }, { "name" : "Kishwaukee North", "code" : "KN" }, { "name" : "Madigan Creek", "code" : "MAC" }, { "name" : "Manning Creek", "code" : "MC" }, { "name" : "North Main", "code" : "NM" }, { "name" : "Riverside", "code" : "R" }, { "name" : "Sinnissippi", "code" : "S" }, { "name" : "South Main", "code" : "SM" }, { "name" : "Spring Creek", "code" : "SC" }, { "name" : "Kent Creek", "code" : "KC" }, { "name" : "Klehm", "code" : "K" }, { "name" : "Buckbee", "code" : "B" }, { "name" : "Kishwaukee South", "code" : "KS" }, { "name" : "Killbuck Creek", "code" : "KBC" } ] }, "Perforated" : { "type" : "codedValue", "name" : "dBooleanSymbolValue", "codedValues" : [ { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 0 } ] }, "PipeDiam" : { "type" : "codedValue", "name" : "dSwPDiam", "codedValues" : [ { "name" : "4 in.", "code" : 4 }, { "name" : "5 in.", "code" : 5 }, { "name" : "6 in.", "code" : 6 }, { "name" : "7 in.", "code" : 7 }, { "name" : "8 in.", "code" : 8 }, { "name" : "9 in.", "code" : 9 }, { "name" : "10 in.", "code" : 10 }, { "name" : "12 in.", "code" : 12 }, { "name" : "14 in.", "code" : 14 }, { "name" : "15 in.", "code" : 15 }, { "name" : "16 in.", "code" : 16 }, { "name" : "17 in.", "code" : 17 }, { "name" : "18 in.", "code" : 18 }, { "name" : "20 in.", "code" : 20 }, { "name" : "21 in.", "code" : 21 }, { "name" : "22 in.", "code" : 22 }, { "name" : "24 in.", "code" : 24 }, { "name" : "26 in.", "code" : 26 }, { "name" : "27 in.", "code" : 27 }, { "name" : "28 in.", "code" : 28 }, { "name" : "30 in.", "code" : 30 }, { "name" : "32 in.", "code" : 32 }, { "name" : "33 in.", "code" : 33 }, { "name" : "35 in.", "code" : 35 }, { "name" : "36 in.", "code" : 36 }, { "name" : "38 in.", "code" : 38 }, { "name" : "39 in.", "code" : 39 }, { "name" : "40 in.", "code" : 40 }, { "name" : "42 in.", "code" : 42 }, { "name" : "45 in.", "code" : 45 }, { "name" : "46 in.", "code" : 46 }, { "name" : "48 in.", "code" : 48 }, { "name" : "54 in.", "code" : 54 }, { "name" : "60 in.", "code" : 60 }, { "name" : "66 in.", "code" : 66 }, { "name" : "72 in.", "code" : 72 }, { "name" : "78 in.", "code" : 78 } ] }, "Enabled" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] } } }, { "code" : 3, "name" : "Connector", "defaultValues" : { "LifeCycleStatus" : null, "Material" : null, "GroundType" : null, "PipeShape" : null, "Slope" : null, "FromCondition" : null, "ToCondition" : null, "ConstNum" : null, "InspectedBy" : null, "InspectedDate" : null, "ModifiedBy" : null, "ModifiedDate" : null, "Comments" : null, "Ownership" : null, "SharePointLink" : null, "DataSource" : null, "Location" : null, "Watershed" : null, "YearLined" : null, "YearTelevised" : null, "Subtype" : 3, "Perforated" : null, "UnitID" : null, "UnitID2" : null, "MainComp1" : null, "MainComp2" : null, "CompType" : null, "CompKey" : null, "InstDate" : null, "InstYear" : null, "PipeID" : null, "Cues_Total_Pipe_Score" : null, "Cues_Maximum_Score" : null, "Cues_Mean_Score" : null, "UpInvertElev" : null, "DwnInvertElev" : null, "RecordedLen" : null, "PipeLen" : null, "PipeHt" : null, "PipeWidth" : null, "PipeDiam" : null, "Enabled" : 1 }, "domains" : { "LifeCycleStatus" : { "type" : "codedValue", "name" : "dLifecycleStatus", "codedValues" : [ { "name" : "Active", "code" : "Active" }, { "name" : "Abandoned", "code" : "Abandoned" }, { "name" : "Killed", "code" : "Killed" }, { "name" : "Removed", "code" : "Removed" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Completed", "code" : "Completed" }, { "name" : "Under Construction", "code" : "Construct" } ] }, "Material" : { "type" : "codedValue", "name" : "dSwRefMat", "codedValues" : [ { "name" : "Asbestos Cement Pipe (ACP)", "code" : "ACP" }, { "name" : "Brick (BR)", "code" : "BR" }, { "name" : "Ductile Iron (DIP)", "code" : "DIP" }, { "name" : "Polyvinylchloride (PVC)", "code" : "PVC" }, { "name" : "Lined", "code" : "Lined" }, { "name" : "Unknown", "code" : "Unk" }, { "name" : "Reinforced Concrete (RCP)", "code" : "RCP" }, { "name" : "Corrugated Metal (CMP)", "code" : "CMP" }, { "name" : "High Density Polyethylene (HDPE)", "code" : "HDPE" }, { "name" : "Steel", "code" : "Steel" }, { "name" : "Corrugated Plastic Pipe (CPP)", "code" : "CPP" }, { "name" : "Clay", "code" : "Clay" }, { "name" : "Prestressed Concrete Cylinder Pipe (PCCP)", "code" : "PCCP" }, { "name" : "Portland Concrete Cement (PCC)", "code" : "PCC" }, { "name" : "Vitrified Clay Pipe (VCP)", "code" : "VCP" } ] }, "GroundType" : { "type" : "codedValue", "name" : "dGroundType", "codedValues" : [ { "name" : "Unknown", "code" : "Unk" }, { "name" : "Dirt", "code" : "Dirt" }, { "name" : "Asphalt", "code" : "Asphalt" }, { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Asphalt/Street", "code" : "AS" }, { "name" : "Concrete/Sidewalk", "code" : "CS" }, { "name" : "Grass", "code" : "Grass" }, { "name" : "Gravel", "code" : "Gravel" }, { "name" : "Grass/Parkway", "code" : "GRSSPKWY" } ] }, "PipeShape" : { "type" : "codedValue", "name" : "dSwShape", "codedValues" : [ { "name" : "Arch", "code" : "Arch" }, { "name" : "Box", "code" : "Box" }, { "name" : "Circular", "code" : "Circular" }, { "name" : "Elliptical", "code" : "Elliptical" }, { "name" : "Other", "code" : "Other" }, { "name" : "Rectangle", "code" : "Rectangle" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "Parabolic", "code" : "Parabolic" }, { "name" : "Trapezoid", "code" : "Trapezoid" } ] }, "FromCondition" : { "type" : "codedValue", "name" : "dSwPCondition", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "ToCondition" : { "type" : "codedValue", "name" : "dSwPCondition", "codedValues" : [ { "name" : "Good", "code" : "Good" }, { "name" : "Fair", "code" : "Fair" }, { "name" : "Poor", "code" : "Poor" }, { "name" : "Capped", "code" : "Capped" }, { "name" : "Blind", "code" : "Blind" }, { "name" : "Unknown", "code" : "Unk" } ] }, "Ownership" : { "type" : "codedValue", "name" : "dOwnership", "codedValues" : [ { "name" : "Private", "code" : "Private" }, { "name" : "Rockford", "code" : "Rockford" }, { "name" : "Loves Park", "code" : "LP" }, { "name" : "Cherry Valley", "code" : "CV" }, { "name" : "Township", "code" : "Township" }, { "name" : "Unknown", "code" : "Unknown" }, { "name" : "County", "code" : "County" }, { "name" : "ComEd", "code" : "ComEd" }, { "name" : "State", "code" : "State" }, { "name" : "Railroad", "code" : "Railroad" }, { "name" : "IDOT", "code" : "IDOT" }, { "name" : "Rockford Park District", "code" : "RPD" } ] }, "DataSource" : { "type" : "codedValue", "name" : "dDataSource", "codedValues" : [ { "name" : "As-Built Drawing", "code" : "Asbuilt" }, { "name" : "Engineering Drawing", "code" : "EngDrawing" }, { "name" : "Auto Generated", "code" : "Auto" }, { "name" : "GPS", "code" : "GPS" }, { "name" : "Field Verified", "code" : "Field" }, { "name" : "Field Services", "code" : "FS" }, { "name" : "Distribution", "code" : "Dist" }, { "name" : "Service Card", "code" : "SC" }, { "name" : "Legal Agreement", "code" : "Legal" }, { "name" : "Plumbing Permits", "code" : "PM" } ] }, "Watershed" : { "type" : "codedValue", "name" : "dWatershed", "codedValues" : [ { "name" : "Airport East", "code" : "AE" }, { "name" : "Blackhawk", "code" : "BH" }, { "name" : "Forest Hills", "code" : "FH" }, { "name" : "Fuller Creek", "code" : "FC" }, { "name" : "Keith Creek", "code" : "Keith" }, { "name" : "Kishwaukee North", "code" : "KN" }, { "name" : "Madigan Creek", "code" : "MAC" }, { "name" : "Manning Creek", "code" : "MC" }, { "name" : "North Main", "code" : "NM" }, { "name" : "Riverside", "code" : "R" }, { "name" : "Sinnissippi", "code" : "S" }, { "name" : "South Main", "code" : "SM" }, { "name" : "Spring Creek", "code" : "SC" }, { "name" : "Kent Creek", "code" : "KC" }, { "name" : "Klehm", "code" : "K" }, { "name" : "Buckbee", "code" : "B" }, { "name" : "Kishwaukee South", "code" : "KS" }, { "name" : "Killbuck Creek", "code" : "KBC" } ] }, "Perforated" : { "type" : "codedValue", "name" : "dBooleanSymbolValue", "codedValues" : [ { "name" : "Yes", "code" : 1 }, { "name" : "No", "code" : 0 } ] }, "PipeDiam" : { "type" : "codedValue", "name" : "dSwPDiam", "codedValues" : [ { "name" : "4 in.", "code" : 4 }, { "name" : "5 in.", "code" : 5 }, { "name" : "6 in.", "code" : 6 }, { "name" : "7 in.", "code" : 7 }, { "name" : "8 in.", "code" : 8 }, { "name" : "9 in.", "code" : 9 }, { "name" : "10 in.", "code" : 10 }, { "name" : "12 in.", "code" : 12 }, { "name" : "14 in.", "code" : 14 }, { "name" : "15 in.", "code" : 15 }, { "name" : "16 in.", "code" : 16 }, { "name" : "17 in.", "code" : 17 }, { "name" : "18 in.", "code" : 18 }, { "name" : "20 in.", "code" : 20 }, { "name" : "21 in.", "code" : 21 }, { "name" : "22 in.", "code" : 22 }, { "name" : "24 in.", "code" : 24 }, { "name" : "26 in.", "code" : 26 }, { "name" : "27 in.", "code" : 27 }, { "name" : "28 in.", "code" : 28 }, { "name" : "30 in.", "code" : 30 }, { "name" : "32 in.", "code" : 32 }, { "name" : "33 in.", "code" : 33 }, { "name" : "35 in.", "code" : 35 }, { "name" : "36 in.", "code" : 36 }, { "name" : "38 in.", "code" : 38 }, { "name" : "39 in.", "code" : 39 }, { "name" : "40 in.", "code" : 40 }, { "name" : "42 in.", "code" : 42 }, { "name" : "45 in.", "code" : 45 }, { "name" : "46 in.", "code" : 46 }, { "name" : "48 in.", "code" : 48 }, { "name" : "54 in.", "code" : 54 }, { "name" : "60 in.", "code" : 60 }, { "name" : "66 in.", "code" : 66 }, { "name" : "72 in.", "code" : 72 }, { "name" : "78 in.", "code" : 78 } ] }, "Enabled" : { "type" : "codedValue", "name" : "EnabledDomain", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] } } } ] }