{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "Sanitary Mains", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 100000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 168, 112, 0, 255 ], "width": 8 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpression": "[sde.DBO.SanMain.Diameter] CONCAT \" in\"", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "straight", "deconflictionStrategy": "dynamic", "allowOverrun": false, "repeatLabel": false, "removeDuplicates": "all", "removeDuplicatesDistance": 0, "lineConnection": "minimizeLabels", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 6000, "name": "Default", "priority": 1, "symbol": { "type": "esriTS", "color": [ 168, 112, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 225, 225, 225, 255 ], "haloSize": 1, "font": { "family": "Arial", "size": 8, "style": "normal", "weight": "bold", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 999187.9866798297, "ymin": 1786450.4579672366, "xmax": 1030281.4349914938, "ymax": 1824804.0817191526, "spatialReference": { "wkid": 102671, "latestWkid": 3435, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -17463800, "falseY": -46132600, "xyUnits": 1.3724482207846552E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "sde.DBO.SanMain.EditorName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "sde.DBO.SanMain.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "sde.DBO.SanMain.Diameter", "type": "esriFieldTypeSmallInteger", "alias": "Diameter", "domain": null }, { "name": "sde.DBO.SanMain.Length", "type": "esriFieldTypeDouble", "alias": "Length", "domain": null }, { "name": "sde.DBO.SanMain.EditorName", "type": "esriFieldTypeString", "alias": "EditorName", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Editor", "description": "Editor", "codedValues": [ { "name": "CCURRY", "code": "CCURRY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanMain.LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "length": 8, "domain": null }, { "name": "sde.DBO.SanMain.Placement", "type": "esriFieldTypeString", "alias": "Placement", "length": 50, "domain": null }, { "name": "sde.DBO.SanMain.StrctFrom", "type": "esriFieldTypeString", "alias": "StrctFrom", "length": 50, "domain": null }, { "name": "sde.DBO.SanMain.StrctTo", "type": "esriFieldTypeString", "alias": "StrctTo", "length": 50, "domain": null }, { "name": "sde.DBO.SanMain.FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 50, "domain": null }, { "name": "sde.DBO.SanMain.ToFromALT", "type": "esriFieldTypeString", "alias": "ToFromALT", "length": 50, "domain": null }, { "name": "sde.DBO.SanMain.GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "sde.DBO.SanMain.Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Owner", "description": "", "codedValues": [ { "name": "Plainfield", "code": "Plainfield" }, { "name": "Private", "code": "Private" }, { "name": "State", "code": "State" }, { "name": "County", "code": "County" }, { "name": "Township", "code": "Township" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanMain.Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "WS2_MaterialSanitary", "description": "Sanitary Sewer Materials", "codedValues": [ { "name": "Clay", "code": "Clay" }, { "name": "Concrete", "code": "Concrete" }, { "name": "PVC", "code": "PVC" }, { "name": "PVC Lined", "code": "PVC Lined" }, { "name": "Steel", "code": "Steel" }, { "name": "Cast Iron", "code": "Cast Iron" }, { "name": "Reinforced Plastic", "code": "Reinforced Plastic" }, { "name": "Ductile Iron", "code": "Ductile Iron" }, { "name": "HDPE", "code": "HDPE" }, { "name": "Clay Lined", "code": "Clay Lined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.Problems", "type": "esriFieldTypeString", "alias": "Problem", "length": 50, "domain": { "type": "codedValue", "name": "WS1_SanitaryPipeProblem", "description": "Issues for Sanitary Pipes", "codedValues": [ { "name": "Cast Iron Section", "code": "Cast Iron Section" }, { "name": "Heavy Concrete", "code": "Heavy Concrete" }, { "name": "Infiltration Gusher", "code": "Infiltration Gusher" }, { "name": "Infiltration Runner", "code": "Infiltration Runner" }, { "name": "Intruding Tap", "code": "Intruding Tap" }, { "name": "Joint Offset", "code": "Joint Offset" }, { "name": "Buried Manhole", "code": "Buried Manhole" }, { "name": "Material Change", "code": "Material Change" }, { "name": "Fracture", "code": "Fracture" }, { "name": "Joint Separated", "code": "Joint Separated" }, { "name": "Pipe Broken", "code": "Pipe Broken" }, { "name": "Water Level Sag", "code": "Water Level Sag" }, { "name": "Intruding Material", "code": "Intruding Material" }, { "name": "Hole in Pipe", "code": "Hole in Pipe" }, { "name": "Other", "code": "Other" }, { "name": "Intruding Sealing Material", "code": "Intruding Sealing Material" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanitaryMainIssue.Locations", "type": "esriFieldTypeString", "alias": "Location", "length": 50, "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.DatesRecorded", "type": "esriFieldTypeDate", "alias": "Date Recorded", "length": 8, "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.ProblemsNotes", "type": "esriFieldTypeString", "alias": "Problem Notes", "length": 150, "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.PerformedBy", "type": "esriFieldTypeString", "alias": "Perform By", "length": 50, "domain": { "type": "codedValue", "name": "WS1_WorkDoneBy", "description": "Plainfield, Contractor", "codedValues": [ { "name": "Plainfield", "code": "Plainfield" }, { "name": "Contractor", "code": "Contractor" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanitaryMainIssue.Resolutions", "type": "esriFieldTypeString", "alias": "Resolution", "length": 50, "domain": { "type": "codedValue", "name": "WS1_SanitaryPipeRepair", "description": "Repair work done for Sanitary Pipes", "codedValues": [ { "name": "Pipe Replacement", "code": "Pipe Replacement" }, { "name": "Pipe Repair", "code": "Pipe Repair" }, { "name": "Manhole Lining", "code": "Manhole Lining" }, { "name": "Root Removal", "code": "Root Removal" }, { "name": "Debris Removal", "code": "Debris Removal" }, { "name": "Pipe Lining", "code": "Pipe Lining" }, { "name": "Other", "code": "Other" }, { "name": "Jetting", "code": "Jetting" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanitaryMainIssue.DatesResolved", "type": "esriFieldTypeDate", "alias": "Date Resolved", "length": 8, "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.ResolvedNote", "type": "esriFieldTypeString", "alias": "Resolved Notes", "length": 50, "domain": null }, { "name": "sde.DBO.SanitaryMainIssue.Priority1", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": { "type": "codedValue", "name": "WS1_Severity", "description": "High Medum Low", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium", "code": "Medium" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanitaryMainIssue.Status1", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "WS1_Status", "description": "Open or Resolved", "codedValues": [ { "name": "New", "code": "New" }, { "name": "Complete", "code": "Complete" }, { "name": "In Progress", "code": "In Progress" }, { "name": "On Hold", "code": "On Hold" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanitaryMainIssue.ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null }, { "name": "sde.DBO.SanMain.JettingYear", "type": "esriFieldTypeSmallInteger", "alias": "JettingYear", "domain": null }, { "name": "sde.DBO.SanMain.Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": { "type": "codedValue", "name": "WS2_SanMainType", "description": "Force or Gravity Main", "codedValues": [ { "name": "Force", "code": "Force" }, { "name": "Gravity", "code": "Gravity" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanMain.InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "sde.DBO.SanMain.inLucity", "type": "esriFieldTypeSmallInteger", "alias": "In EAM Lucity", "domain": { "type": "codedValue", "name": "WS2_BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "sde.DBO.SanMain.LucityAutoID", "type": "esriFieldTypeSmallInteger", "alias": "EAM AutoID", "domain": null }, { "name": "sde.DBO.SanMain.lastModBy", "type": "esriFieldTypeString", "alias": "lastModBy", "length": 255, "domain": null }, { "name": "sde.DBO.SanMain.lastSyncDate", "type": "esriFieldTypeDate", "alias": "EAM Sync Date", "length": 8, "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "sde.DBO.SanMain.SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R241_pk", "fields": "sde.DBO.SanMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_241", "fields": "sde.DBO.SanMain.GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_241", "fields": "sde.DBO.SanMain.GlobalID,sde.DBO.SanMain.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S210_idx", "fields": "sde.DBO.SanMain.SHAPE", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R236_SDE_ROWID_UK", "fields": "sde.DBO.SanitaryMainIssue.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1698_ParentG", "fields": "sde.DBO.SanitaryMainIssue.ParentGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SanMainIssue", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7FF36ABC-263E-48F9-8911-4BCA0DDE0F9F}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "maxSelectionCount": 2000, "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "dd59ffffae684ec5beabafb1f7b8f7f3" }