{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 40, "name": "SewerMains", "type": "Feature Layer", "description": "This data contains the Sewer mains for the City of McKinney, Texas", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 2.560000002384187E-4, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -1.2340769999992177E8, "falseY": -8.612349999990822E7, "xyUnits": 31249.999970896155, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 2.560000002384187E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.2971053801711988E8, "falseY": -9.078990711872776E7, "xyUnits": 3.503993664638381E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "McKinney GIS and Water department", "parentLayer": { "id": 21, "name": "Sewer" }, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "RuleID", "uniqueValueGroups": [ { "heading": "", "classes": [ { "label": "MCKINNEY", "description": "MCKINNEY", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 0.4 }, "values": [ [ "1" ] ] }, { "label": "MELISSA", "description": "MELISSA", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 92, 230, 255 ], "width": 0.4 }, "values": [ [ "2" ] ] }, { "label": "NTMWD", "description": "NTMWD", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 137, 90, 68, 255 ], "width": 0.4 }, "values": [ [ "3" ] ] }, { "label": "PRIVATE", "description": "PRIVATE", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 255, 223, 255 ], "width": 0.4 }, "values": [ [ "4" ] ] }, { "label": "FRISCO", "description": "FRISCO", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 38, 115, 0, 255 ], "width": 0.4 }, "values": [ [ "5" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 0.4 }, "value": "1", "label": "MCKINNEY" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 92, 230, 255 ], "width": 0.4 }, "value": "2", "label": "MELISSA" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 137, 90, 68, 255 ], "width": 0.4 }, "value": "3", "label": "NTMWD" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 115, 255, 223, 255 ], "width": 0.4 }, "value": "4", "label": "PRIVATE" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 38, 115, 0, 255 ], "width": 0.4 }, "value": "5", "label": "FRISCO" } ], "fieldDelimiter": "," }, "scaleSymbols": false, "transparency": 0, "labelingInfo": [ { "labelExpression": "[AssetID] CONCAT NEWLINE CONCAT [Size] CONCAT \"'\" CONCAT \"'\" CONCAT \" \" CONCAT \" \" CONCAT [SHAPE.STLength()] CONCAT \"'\"", "labelPlacement": "esriServerLinePlacementCenterAlong", "textLayout": "straight", "deconflictionStrategy": "dynamic", "allowOverrun": false, "repeatLabel": false, "removeDuplicates": "all", "removeDuplicatesDistance": 0, "lineConnection": "minimizeLabels", "stackLabel": false, "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Default", "priority": 1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "center", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": false, "extent": { "xmin": 2498331.772697419, "ymin": 7096061.500029296, "xmax": 2569459.1499156654, "ymax": 7169125.409857348, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 2.560000002384187E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -1.2971053801711988E8, "falseY": -9.078990711872776E7, "xyUnits": 3.503993664638381E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "AssetID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 35, "domain": null }, { "name": "Street", "type": "esriFieldTypeString", "alias": "STREET", "length": 35, "domain": null }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "SIZE", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 35, "domain": { "type": "codedValue", "name": "SewerMainsMaterial", "description": "SewerMains Material Types", "codedValues": [ { "name": "PVC", "code": "PVC" }, { "name": "CI", "code": "CI" }, { "name": "CP", "code": "CP" }, { "name": "DI", "code": "DI" }, { "name": "FRP", "code": "FRP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "LINER", "code": "LINER" }, { "name": "VCP", "code": "VCP" }, { "name": "Polypropylene", "code": "Polypropylene" }, { "name": "PVC90", "code": "PVC90" }, { "name": "Liner & Plastic", "code": "LinerPlastic " }, { "name": "Spirolite CL100", "code": "SpiroliteCL100" }, { "name": "Spirolite CL250", "code": " SpiroliteCL250" }, { "name": "Pro-21 PVC", "code": " Pro-21PVC" }, { "name": "RCP", "code": "RCP" }, { "name": "RPM", "code": "RPM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VID", "type": "esriFieldTypeString", "alias": "VID", "length": 35, "domain": null }, { "name": "CRC", "type": "esriFieldTypeDouble", "alias": "CRC", "domain": null }, { "name": "OID", "type": "esriFieldTypeInteger", "alias": "OID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "TYPE", "length": 50, "domain": { "type": "codedValue", "name": "SewerMainsType", "description": "SewerMains Type", "codedValues": [ { "name": "Gravity", "code": "Gravity" }, { "name": "Force", "code": "Force" }, { "name": "Lateral", "code": "Lateral" }, { "name": "Main", "code": "Main" }, { "name": "Outfall", "code": "Outfall" }, { "name": "SIPHON", "code": "SIPHON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 25, "domain": null }, { "name": "Reversal", "type": "esriFieldTypeString", "alias": "Reversal", "length": 10, "domain": { "type": "codedValue", "name": "YesNaNeeded", "description": "Yes/No/Needed", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "NA", "code": "NA" }, { "name": "Needed", "code": "Needed" }, { "name": "Unable", "code": "Unable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Reason", "type": "esriFieldTypeString", "alias": "Reason", "length": 50, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 100, "domain": null }, { "name": "QSR", "type": "esriFieldTypeString", "alias": "QSR", "length": 4, "domain": null }, { "name": "QMR", "type": "esriFieldTypeString", "alias": "QMR", "length": 4, "domain": null }, { "name": "SPR", "type": "esriFieldTypeString", "alias": "SPR", "length": 3, "domain": null }, { "name": "MPR", "type": "esriFieldTypeString", "alias": "MPR", "length": 3, "domain": null }, { "name": "SPRI", "type": "esriFieldTypeString", "alias": "SPRI", "length": 3, "domain": null }, { "name": "MPRI", "type": "esriFieldTypeString", "alias": "MPRI", "length": 3, "domain": null }, { "name": "OPRI", "type": "esriFieldTypeString", "alias": "OPRI", "length": 3, "domain": null }, { "name": "AcousticDate", "type": "esriFieldTypeDate", "alias": "AcousticDate", "length": 8, "domain": null }, { "name": "CleanSchedule", "type": "esriFieldTypeDate", "alias": "CleanSchedule", "length": 8, "domain": null }, { "name": "CleanComplete", "type": "esriFieldTypeDate", "alias": "CleanComplete", "length": 8, "domain": null }, { "name": "TVSchedule", "type": "esriFieldTypeDate", "alias": "TV_Schedule", "length": 8, "domain": null }, { "name": "TVInspected", "type": "esriFieldTypeDate", "alias": "TV_Inspected", "length": 8, "domain": null }, { "name": "RootControl", "type": "esriFieldTypeDate", "alias": "RootControl", "length": 8, "domain": null }, { "name": "AcousticGrade", "type": "esriFieldTypeString", "alias": "AcousticGrade", "length": 3, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "SewerReps_Rules", "description": "Representation rules", "codedValues": [ { "name": "MCKINNEY", "code": 1 }, { "name": "MELISSA", "code": 2 }, { "name": "NTMWD", "code": 3 }, { "name": "PRIVATE", "code": 4 }, { "name": "FRISCO", "code": 5 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Override", "type": "esriFieldTypeBlob", "alias": "Override", "domain": null }, { "name": "USMH", "type": "esriFieldTypeString", "alias": "USMH", "length": 10, "domain": null }, { "name": "DSMH", "type": "esriFieldTypeString", "alias": "DSMH", "length": 10, "domain": null }, { "name": "SCVConn", "type": "esriFieldTypeInteger", "alias": "SCVConn", "domain": null }, { "name": "HotSpot", "type": "esriFieldTypeString", "alias": "HotSpot", "length": 255, "domain": { "type": "codedValue", "name": "YesNoNA", "description": "for mobile data collection", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "CapacityIssue", "type": "esriFieldTypeString", "alias": "CapacityIssue", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "InstallYear", "type": "esriFieldTypeSmallInteger", "alias": "InstallYear", "domain": null }, { "name": "SurveyedLength", "type": "esriFieldTypeDouble", "alias": "Surveyed Length", "domain": null }, { "name": "Project", "type": "esriFieldTypeString", "alias": "Project", "length": 255, "domain": null }, { "name": "OwnedBy", "type": "esriFieldTypeString", "alias": "OwnedBy", "length": 35, "domain": { "type": "codedValue", "name": "SewerMainsOwnership", "description": "Sewer Mains Ownership Types", "codedValues": [ { "name": "FRISCO", "code": "FRISCO" }, { "name": "MELISSA", "code": "MELISSA" }, { "name": "NTMWD", "code": "NTMWD" }, { "name": "PARKS", "code": "PARKS" }, { "name": "PRIVATE", "code": "PRIVATE" }, { "name": "COLLIN COUNTY", "code": "COLLIN COUNTY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Rehab", "type": "esriFieldTypeString", "alias": "Rehab", "length": 200, "domain": { "type": "codedValue", "name": "Rehab", "description": "Rehab value list", "codedValues": [ { "name": "Completed", "code": "Completed" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Scheduled", "code": "Scheduled" }, { "name": "Needed", "code": "Needed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LifeCycle", "type": "esriFieldTypeString", "alias": "LifeCycle", "length": 50, "domain": { "type": "codedValue", "name": "LifeCycle", "description": "Life Cycle", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CWAssetID", "type": "esriFieldTypeString", "alias": "CWAssetID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Notes2", "type": "esriFieldTypeString", "alias": "Notes2", "length": 250, "domain": null }, { "name": "RehabDate", "type": "esriFieldTypeDate", "alias": "RehabDate", "length": 8, "domain": null }, { "name": "OffsiteEasements", "type": "esriFieldTypeString", "alias": "OffsiteEasements", "length": 3, "domain": { "type": "codedValue", "name": "SewerOffsiteEasement", "description": "Sewer Offsite Easement", "codedValues": [ { "name": "Sewer Mains within ROW", "code": "1" }, { "name": "Offsite Sewer Mains (w/ Easements)", "code": "2" }, { "name": "Offsite Sewer Mains (w/o Easements)", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AerialCrossing", "type": "esriFieldTypeString", "alias": "AerialCrossing", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Encasement", "type": "esriFieldTypeString", "alias": "Encasement", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EncasementType", "type": "esriFieldTypeString", "alias": "EncasementType", "length": 255, "domain": null }, { "name": "LF", "type": "esriFieldTypeDouble", "alias": "LF", "domain": null }, { "name": "OpMaintRating", "type": "esriFieldTypeSmallInteger", "alias": "OpMaintRating", "domain": { "type": "codedValue", "name": "OpMaintRating", "description": "OpMaintRating", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MilesOfPipe", "type": "esriFieldTypeDouble", "alias": "MilesOfPipe", "domain": null }, { "name": "Basin", "type": "esriFieldTypeString", "alias": "Basin", "length": 10, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "length": 10, "domain": null }, { "name": "StructuralRating", "type": "esriFieldTypeSmallInteger", "alias": "StructuralRating", "domain": null }, { "name": "RepairMethod", "type": "esriFieldTypeString", "alias": "RepairMethod", "length": 20, "domain": { "type": "codedValue", "name": "RepairMethod", "description": "Sewer Mains Repair Method", "codedValues": [ { "name": "CIP", "code": "CIP" }, { "name": "Open Cut", "code": "OpenCut" }, { "name": "Lining", "code": "Lining" }, { "name": "Pipe Burst", "code": "PipeBurst" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "YearsLastTelevised", "type": "esriFieldTypeString", "alias": "YearsLastTelevised", "length": 10, "domain": null }, { "name": "PreviousTVInspected", "type": "esriFieldTypeDate", "alias": "PreviousTVInspected", "length": 8, "domain": null }, { "name": "LinerType", "type": "esriFieldTypeString", "alias": "LinerType", "length": 50, "domain": { "type": "codedValue", "name": "LinerType", "description": "Sewer Mains Liner Type", "codedValues": [ { "name": "CIPP", "code": "CIPP" }, { "name": "Felt", "code": "Felt" }, { "name": "Old Liner", "code": "Old Liner" }, { "name": "Poly", "code": "Poly" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RepairReason", "type": "esriFieldTypeString", "alias": "RepairReason", "length": 255, "domain": null }, { "name": "RepairProject", "type": "esriFieldTypeString", "alias": "RepairProject", "length": 255, "domain": null }, { "name": "WarrantyAccepted", "type": "esriFieldTypeString", "alias": "WarrantyAccepted", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PreviousCleaningDate", "type": "esriFieldTypeDate", "alias": "PreviousCleaningDate", "length": 8, "domain": null }, { "name": "RehabContractor", "type": "esriFieldTypeString", "alias": "RehabContractor ", "length": 150, "domain": { "type": "codedValue", "name": "SewerManholeRehabContractor", "description": "Sewer Manhole Rehab Contractor", "codedValues": [ { "name": "Fuquay", "code": "Fuquay" }, { "name": "Insituform", "code": "Insituform" }, { "name": "Warren Epoxy", "code": "WarrenEpoxy" }, { "name": "Infrastructure Rehab USA", "code": "InfStrRehabUSA" }, { "name": "Unknown", "code": " Unknown" }, { "name": "TriPlex", "code": " TriPlex" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SubBasin", "type": "esriFieldTypeString", "alias": "SubBasin", "length": 20, "domain": null }, { "name": "HotSpotFrequency", "type": "esriFieldTypeDouble", "alias": "HotSpotFrequency", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R1735_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1735", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_1735", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1401_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "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": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }