{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "CIP Point Assets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "81eaa850baff394e16f8e326c12f4a8d", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAw0lEQVQokaXRsUpCYRiA4Uc7QnQF7Q3OoYsERkgi0ZCjo04iYYNgVODg0hLegRcQQrfQEk01BhaeMVocA9sMgyQ5x+HQC9/y8z3wwR9IWPBfsKWnI2/fhoyxJ9duTH3EgYyhWw3Hy5cjRbuKmk68eV8FF87U/yz/diCv7cqp1irIKUitOTxrL3pSau06c+koePXgS9VmDJh4jIJLA9sqag6XaI47L+51o2BRQ9mnnh0laYHQs9C5kVk8WNTW52diS/zT34q2JCByOET8AAAAAElFTkSuQmCC", "contentType": "image/png", "width": 9, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 6472983.067939173, "ymin": 1863872.5222829282, "xmax": 6486134.651216004, "ymax": 1872862.9373729303, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "STRATEGY", "type": "esriFieldTypeString", "alias": "Strategy", "length": 50, "domain": null }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "Action", "length": 50, "domain": null }, { "name": "COST", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "MULTI", "type": "esriFieldTypeDouble", "alias": "Multiplier Value", "domain": null }, { "name": "ADDCOST", "type": "esriFieldTypeDouble", "alias": "Additional Cost", "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "EXTFILT1", "type": "esriFieldTypeString", "alias": "Existing Value - 1st", "length": 50, "domain": null }, { "name": "EXTFILT2", "type": "esriFieldTypeString", "alias": "Existing Value - 2nd", "length": 50, "domain": null }, { "name": "PROFILT1", "type": "esriFieldTypeString", "alias": "Replacement Value - 1st", "length": 50, "domain": null }, { "name": "PROFILT2", "type": "esriFieldTypeString", "alias": "Replacement Value - 2nd", "length": 50, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "ASSETTYP", "type": "esriFieldTypeString", "alias": "Source Asset", "length": 255, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 120, "domain": null }, { "name": "SOURCOID", "type": "esriFieldTypeString", "alias": "Source OID", "length": 50, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R148_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G442PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_148", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_148", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S70_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{C3B88271-A65E-45EC-820F-2D0955293292}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "CIP Project Locations", "type": "Feature Layer", "description": "This is a point feature that represents the location of CIP projects and is used in multi-scale maps.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "56fda9e70d9e3ac406341f60b0cb3e1b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA0UlEQVQokWNhIBGwUKqBiyGkqJhBSc+egYmFleHZnTMMa6b0MHx78xybBlaGjN6VDI6RPnARQyc7BgVtO4Z51QEMT249RdUQmJPP4BCBUAwD2tYmDO4J1Qxzq7JQNSjoWzIwMmJ3uISSNaaTGBlwqGYAASZMDU/vHWH4/TOQgZUdU/nL+8cwNaxs72MQFPFgsAlyhWv6/5+B4dS2qwznz5VhagCBGcVuDN+/1zFIyjszMDGyMLx4dJbh8+tyhrOrv2PXAAILa5oYGBhAGCsgOaYBPOs14dBfYBAAAAAASUVORK5CYII=", "contentType": "image/png", "width": 9, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214588.95977716148, "ymin": -214715.70504674315, "xmax": 6496793.750304587, "ymax": 1938909.2022617608, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CIPSTAT", "type": "esriFieldTypeString", "alias": "CIP Status", "length": 50, "domain": { "type": "codedValue", "name": "CIPStatus", "description": "The status of the CIP", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Completed", "code": "Completed" }, { "name": "Approved", "code": "Approved" }, { "name": "Funded", "code": "Funded" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Canceled", "code": "Canceled" }, { "name": "In Design", "code": "In Design" }, { "name": "Pavement Moratorium", "code": "Pavement Moratorium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": { "type": "codedValue", "name": "CIPProjManager", "description": "A domain used to identify the name of the project manager", "codedValues": [ { "name": "A LeBlanc", "code": "A LeBlanc" }, { "name": "C Jones", "code": "C Jones" }, { "name": "Public Works", "code": "Public Works" }, { "name": "S Lemmon", "code": "S Lemmon" }, { "name": "Utilities", "code": "Utilities" }, { "name": "V Gonzalez", "code": "V Gonzalez" }, { "name": "Water Treatment", "code": "Water Treatment" }, { "name": "D DeMaster", "code": "D DeMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "length": 175, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjectType", "description": "The type of CIP", "codedValues": [ { "name": "Streets", "code": "Streets" }, { "name": "Other", "code": "Other" }, { "name": "Water", "code": "Water" }, { "name": "Sanitary Sewer", "code": "Sanitary Sewer" }, { "name": "Stormwater", "code": "Stormwater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "length": 80, "domain": null }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 80, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 20, "domain": null }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CIP INTERAGENCY MAP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeInteger", "alias": "CIPFISCALYEAR", "domain": null }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 80, "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "System Revenues", "code": "System Revenues" }, { "name": "Other", "code": "Other" }, { "name": "Water Enterprise Fund", "code": "Water Enterprise Fund" }, { "name": "Other Agencies", "code": "Other Agencies" }, { "name": "Solid Waste and Recycling Enterprise Fund", "code": "Solid Waste and Recycling Enterprise Fund" }, { "name": "FEMA", "code": "FEMA" }, { "name": "General Fund", "code": "General Fund" }, { "name": "Measure T", "code": "Measure T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIP_IMPROVEMENTTYPE", "type": "esriFieldTypeString", "alias": "CIP Improvement Type", "length": 30, "domain": null }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION CREW", "length": 50, "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIP COMPONENT", "length": 20, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R130_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G424PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_424_CIPPRIOR", "fields": "CIPComponent", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_130", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_130", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S52_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "WaterCIP_Table", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "CIPComponent", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{20A69A1B-CBFC-4602-AAFB-8114B8AE8275}" }, { "id": 2, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{659954DE-D14C-4C4C-8A12-9FC178028CC9}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "CIP Polyline Assets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 17, 0, 166, 255 ], "width": 1.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214748.36464207992, "ymin": -214748.36475832015, "xmax": 6732128.306537423, "ymax": 1903217.6680019274, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "STRATEGY", "type": "esriFieldTypeString", "alias": "Strategy", "length": 50, "domain": null }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "Action", "length": 50, "domain": null }, { "name": "COST", "type": "esriFieldTypeDouble", "alias": "Cost per Unit", "domain": null }, { "name": "MULTI", "type": "esriFieldTypeDouble", "alias": "Multiplier Value", "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "Length", "length": 50, "domain": null }, { "name": "ADDCOST", "type": "esriFieldTypeDouble", "alias": "Additional Cost", "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "EXTFILT1", "type": "esriFieldTypeString", "alias": "Existing Value - 1st", "length": 50, "domain": null }, { "name": "EXTFILT2", "type": "esriFieldTypeString", "alias": "Existing Value - 2nd", "length": 50, "domain": null }, { "name": "PROFILT1", "type": "esriFieldTypeString", "alias": "Replacement Value - 1st", "length": 50, "domain": null }, { "name": "PROFILT2", "type": "esriFieldTypeString", "alias": "Replacement Value - 2nd", "length": 50, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "ASSETTYP", "type": "esriFieldTypeString", "alias": "Source Asset", "length": 255, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 120, "domain": null }, { "name": "SOURCOID", "type": "esriFieldTypeString", "alias": "Source OID", "length": 50, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R146_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G440PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_146", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_146", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S68_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{4D6C998D-2ADC-4FCD-AF13-AC8FB4E98406}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Breaks Per Mile of Water Main", "type": "Feature Layer", "description": "The number of breaks per mile of water main.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 99999.99999999999 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Relative Score", "domain": { "type": "codedValue", "name": "CIPCritScore", "description": "The relative score assigned to asset by the model", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Excellent", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Immediate Attention", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DEFPRDIS", "type": "esriFieldTypeDouble", "alias": "Breaks or Leaks per Mile", "domain": null }, { "name": "DEFCOUNT", "type": "esriFieldTypeInteger", "alias": "Breaks or Leaks Count", "domain": null }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R139_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_139", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_139", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S61_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Water Mains Life Expectancy", "type": "Feature Layer", "description": "The life expectancy of the water mains.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 99999.99999999999 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 35, 163, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "LIFEEXPT", "type": "esriFieldTypeDouble", "alias": "Life Expectancy", "domain": null }, { "name": "REMLIF", "type": "esriFieldTypeDouble", "alias": "Remaing Life Expectancy", "domain": null }, { "name": "SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Relative Score", "domain": { "type": "codedValue", "name": "CIPCritScore", "description": "The relative score assigned to asset by the model", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Excellent", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Immediate Attention", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "length": 8, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "AC", "code": "AC" }, { "name": "C900", "code": "C900" }, { "name": "C900 F", "code": "C900 F" }, { "name": "C905", "code": "C905" }, { "name": "C909", "code": "C909" }, { "name": "CI", "code": "CI" }, { "name": "CMP", "code": "CMP" }, { "name": "COP", "code": "COP" }, { "name": "CPVC", "code": "CPVC" }, { "name": "DIP", "code": "DIP" }, { "name": "GALVANIZED", "code": "GALVANIZED" }, { "name": "NON LEAD", "code": "NON LEAD" }, { "name": "PCCP", "code": "PCCP" }, { "name": "PLASTIC", "code": "PLASTIC" }, { "name": "POLYETHYLENE", "code": "POLYETHYLENE" }, { "name": "PVC", "code": "PVC" }, { "name": "RCCP", "code": "RCCP" }, { "name": "STEEL", "code": "STL" }, { "name": "NA", "code": "NA" }, { "name": "Unknown", "code": "Unknown" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R136_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_136", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_136", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S58_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Water Mains With Overlapping Projects", "type": "Feature Layer", "description": "Water mains that overlap other projects.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 99999.99999999999 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 0, 83, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "OTHPRJ", "type": "esriFieldTypeSmallInteger", "alias": "Asset Overlaps Another Project", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R137_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_137", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_137", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S59_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Water Mains With Trace Summary", "type": "Feature Layer", "description": "Water mains with trace summary.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 148, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "VALVECOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Valve Count", "domain": null }, { "name": "METERCOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Meter Count", "domain": null }, { "name": "NUMCRITMETER", "type": "esriFieldTypeSmallInteger", "alias": "Number of Critical Customers", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 125, "domain": null }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R135_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_135", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_135", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S57_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Water Mains With Dirty Water Complaints", "type": "Feature Layer", "description": "Water mains that have dirty water complaints.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 99999.99999999999 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 97, 171, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "HASCOMPL", "type": "esriFieldTypeSmallInteger", "alias": "Has Dirty Water Complaint", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R138_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_138", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_138", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S60_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Water Main Criticality Score", "type": "Feature Layer", "description": "The water main criticality score.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 99999.99999999999 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 168, 42, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "RAILROAD", "type": "esriFieldTypeSmallInteger", "alias": "Intersects a Railroad?", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAJROAD", "type": "esriFieldTypeSmallInteger", "alias": "Under or Touches a Major Road?", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CRITMET", "type": "esriFieldTypeSmallInteger", "alias": "Supports a Critical Customer?", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SCORE", "type": "esriFieldTypeSmallInteger", "alias": "Relative Score", "domain": { "type": "codedValue", "name": "CIPCritScore", "description": "The relative score assigned to asset by the model", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Excellent", "code": 1 }, { "name": "Good", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Poor", "code": 4 }, { "name": "Immediate Attention", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "METERCOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Meter Count", "domain": null }, { "name": "VALVECOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Valve Count", "domain": null }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R134_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_134", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_134", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S56_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasM": 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, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "CIP Polygon Assets", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 207, 217, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "STRATEGY", "type": "esriFieldTypeString", "alias": "Strategy", "length": 50, "domain": null }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "Action", "length": 50, "domain": null }, { "name": "COST", "type": "esriFieldTypeDouble", "alias": "Cost per Unit", "domain": null }, { "name": "MULTI", "type": "esriFieldTypeDouble", "alias": "Multiplier Value", "domain": null }, { "name": "ADDCOST", "type": "esriFieldTypeDouble", "alias": "Additional Cost", "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "EXTFILT1", "type": "esriFieldTypeString", "alias": "Existing Value - 1st", "length": 50, "domain": null }, { "name": "EXTFILT2", "type": "esriFieldTypeString", "alias": "Existing Value - 2nd", "length": 50, "domain": null }, { "name": "PROFILT1", "type": "esriFieldTypeString", "alias": "Replacement Value - 1st", "length": 50, "domain": null }, { "name": "PROFILT2", "type": "esriFieldTypeString", "alias": "Replacement Value - 2nd", "length": 50, "domain": null }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Asset Notes", "length": 255, "domain": null }, { "name": "ASSETTYP", "type": "esriFieldTypeString", "alias": "Source Asset", "length": 255, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 120, "domain": null }, { "name": "SOURCOID", "type": "esriFieldTypeString", "alias": "Source OID", "length": 50, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "TotalCost", "type": "esriFieldTypeInteger", "alias": "TotalCost", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R147_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G441PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_147", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_147", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S69_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{DA0E083E-CCAB-4867-8837-F52BE35AA17B}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "CIP Project Outlines", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 190, 190, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214758.36495016143, "ymin": -214758.3647383228, "xmax": 6732138.306517422, "ymax": 1941265.3855415136, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CIPSTATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "length": 50, "domain": { "type": "codedValue", "name": "CIPStatus", "description": "The status of the CIP", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Completed", "code": "Completed" }, { "name": "Approved", "code": "Approved" }, { "name": "Funded", "code": "Funded" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Canceled", "code": "Canceled" }, { "name": "In Design", "code": "In Design" }, { "name": "Pavement Moratorium", "code": "Pavement Moratorium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": { "type": "codedValue", "name": "CIPProjManager", "description": "A domain used to identify the name of the project manager", "codedValues": [ { "name": "A LeBlanc", "code": "A LeBlanc" }, { "name": "C Jones", "code": "C Jones" }, { "name": "Public Works", "code": "Public Works" }, { "name": "S Lemmon", "code": "S Lemmon" }, { "name": "Utilities", "code": "Utilities" }, { "name": "V Gonzalez", "code": "V Gonzalez" }, { "name": "Water Treatment", "code": "Water Treatment" }, { "name": "D DeMaster", "code": "D DeMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "length": 175, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjectType", "description": "The type of CIP", "codedValues": [ { "name": "Streets", "code": "Streets" }, { "name": "Other", "code": "Other" }, { "name": "Water", "code": "Water" }, { "name": "Sanitary Sewer", "code": "Sanitary Sewer" }, { "name": "Stormwater", "code": "Stormwater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 80, "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "System Revenues", "code": "System Revenues" }, { "name": "Other", "code": "Other" }, { "name": "Water Enterprise Fund", "code": "Water Enterprise Fund" }, { "name": "Other Agencies", "code": "Other Agencies" }, { "name": "Solid Waste and Recycling Enterprise Fund", "code": "Solid Waste and Recycling Enterprise Fund" }, { "name": "FEMA", "code": "FEMA" }, { "name": "General Fund", "code": "General Fund" }, { "name": "Measure T", "code": "Measure T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "length": 80, "domain": null }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjManEMAIL", "description": "Email address choices for CIP Projects", "codedValues": [ { "name": "aleblanc@cityofnapa.org", "code": "aleblanc@cityofnapa.org" }, { "name": "chrisjones@cityofnapa.org", "code": "chrisjones@cityofnapa.org" }, { "name": "slemmon@cityofnapa.org", "code": "slemmon@cityofnapa.org" }, { "name": "vgonzalez@cityofnapa.org", "code": "vgonzalez@cityofnapa.org" }, { "name": "ddemaster@cityofnapa.org", "code": "ddemaster@cityofnapa.org" }, { "name": "water@cityofnapa.org", "code": "water@cityofnapa.org" }, { "name": "engineering@cityofnapa.org", "code": "engineering@cityofnapa.org" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 20, "domain": null }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeSmallInteger", "alias": "CIP FYEAR", "domain": null }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CIP INTERAGENCY MAP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIP_IMPROVEMENT_TYPE", "type": "esriFieldTypeString", "alias": "CIP IMPROVE TYPE", "length": 30, "domain": { "type": "codedValue", "name": "CIP_ImprovementType ", "description": "Type of CIP Improvement", "codedValues": [ { "name": "Abandon", "code": "Abandon" }, { "name": "New", "code": "New" }, { "name": "Reduce", "code": "Reduce" }, { "name": "Rehab", "code": "Rehab" }, { "name": "Replace", "code": "Replace" }, { "name": "Upgrade", "code": "Upgrade" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "Plan_Year", "type": "esriFieldTypeString", "alias": "Plan Year", "length": 50, "domain": { "type": "codedValue", "name": "CIPPlannedFiscalYear", "description": "Capital Improvement planned fiscal year", "codedValues": [ { "name": "FY 12-13", "code": "FY 12-13" }, { "name": "FY 13-14", "code": "FY 13-14" }, { "name": "FY 14-15", "code": "FY 14-15" }, { "name": "FY 15-16", "code": "FY 15-16" }, { "name": "FY 16-17", "code": "FY 16-17" }, { "name": "FY 17-18", "code": "FY 17-18" }, { "name": "FY 18-19", "code": "FY 18-19" }, { "name": "FY 19-20", "code": "FY 19-20" }, { "name": "FY 20-21", "code": "FY 20-21" }, { "name": "FY 21-22", "code": "FY 21-22" }, { "name": "FY 22-23", "code": "FY 22-23" }, { "name": "FY 23-24", "code": "FY 23-24" }, { "name": "FY 24-25", "code": "FY 24-25" }, { "name": "FY 25-26", "code": "FY 25-26" }, { "name": "FY 26-27", "code": "FY 26-27" }, { "name": "FY 27-28", "code": "FY 27-28" }, { "name": "FY 28-29", "code": "FY 28-29" }, { "name": "FY 29-30", "code": "FY 29-30" }, { "name": "FY 30-31", "code": "FY 30-31" }, { "name": "FY 31-32", "code": "FY 31-32" }, { "name": "FY 32-33", "code": "FY 32-33" }, { "name": "FY 33-34", "code": "FY 33-34" }, { "name": "FY 34-35", "code": "FY 34-35" }, { "name": "FY 35-40", "code": "FY 35-40" }, { "name": "FY 40-45", "code": "FY 40-45" }, { "name": "FY 45-50", "code": "FY 45-50" }, { "name": "FY 50-55", "code": "FY 50-55" }, { "name": "FY 55-60", "code": "FY 55-60" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION_CREW", "length": 50, "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIPComponent", "length": 20, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 1000, "domain": null }, { "name": "BudgetFund", "type": "esriFieldTypeString", "alias": "Budget Fund", "length": 50, "domain": { "type": "codedValue", "name": "CIPBudgetFund", "description": "Budget Fund for CIP Projects", "codedValues": [ { "name": "Water Distribution", "code": "WD" }, { "name": "Water Transmission", "code": "WT" }, { "name": "Water Quality", "code": "WQ" }, { "name": "Water Supply", "code": "WS" }, { "name": "Water Administration", "code": "WA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "PipeMaterial", "type": "esriFieldTypeString", "alias": "Pipe Material", "length": 32, "domain": null }, { "name": "CIPMethod", "type": "esriFieldTypeString", "alias": "CIP Method", "length": 50, "domain": { "type": "codedValue", "name": "piCIPMethod", "description": "Denotes the CIP Method", "codedValues": [ { "name": "Open Cut", "code": "OC" }, { "name": "Horizontal Directional Drilling", "code": "HDD" }, { "name": "Pipe Burst", "code": "PB" }, { "name": "Abandon", "code": "AB" }, { "name": "Slip-Line", "code": "SL" }, { "name": "CIPP", "code": "CIPP" }, { "name": "Above Ground", "code": "AG" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CostLinear", "type": "esriFieldTypeInteger", "alias": "Cost Linear", "domain": null }, { "name": "CostOther", "type": "esriFieldTypeInteger", "alias": "Cost Other", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R145_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G439PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_439_CIPPRIOR", "fields": "CIPComponent", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_145", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_145", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S67_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CIPPoints", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{C3B88271-A65E-45EC-820F-2D0955293292}" }, { "id": 2, "name": "CIPProjectsLocations", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{659954DE-D14C-4C4C-8A12-9FC178028CC9}" }, { "id": 5, "name": "WaterCIP_Table", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "CIPComponent", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A6C2B198-A733-4007-BCD8-AB7CFB1CBDD4}" }, { "id": 3, "name": "CIPPolylines", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{4D6C998D-2ADC-4FCD-AF13-AC8FB4E98406}" }, { "id": 4, "name": "CIPPolygons", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{DA0E083E-CCAB-4867-8837-F52BE35AA17B}" }, { "id": 6, "name": "CIPProjectsOverview", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{D3D0F591-A151-4933-9ADF-4C47E67C2141}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "CIP Project Overviews", "type": "Feature Layer", "description": "A polygon that represents an overview of the CIP project.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 215, 192, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -214818.36483016238, "ymin": -214818.36461832374, "xmax": 6732198.306069337, "ymax": 1903287.6675338447, "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PROJNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "length": 8, "domain": null }, { "name": "CIPSTATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "length": 50, "domain": { "type": "codedValue", "name": "CIPStatus", "description": "The status of the CIP", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Completed", "code": "Completed" }, { "name": "Approved", "code": "Approved" }, { "name": "Funded", "code": "Funded" }, { "name": "Under Construction", "code": "Under Construction" }, { "name": "Canceled", "code": "Canceled" }, { "name": "In Design", "code": "In Design" }, { "name": "Pavement Moratorium", "code": "Pavement Moratorium" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 200, "domain": null }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "length": 50, "domain": { "type": "codedValue", "name": "CIPProjManager", "description": "A domain used to identify the name of the project manager", "codedValues": [ { "name": "A LeBlanc", "code": "A LeBlanc" }, { "name": "C Jones", "code": "C Jones" }, { "name": "Public Works", "code": "Public Works" }, { "name": "S Lemmon", "code": "S Lemmon" }, { "name": "Utilities", "code": "Utilities" }, { "name": "V Gonzalez", "code": "V Gonzalez" }, { "name": "Water Treatment", "code": "Water Treatment" }, { "name": "D DeMaster", "code": "D DeMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "length": 50, "domain": null }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "length": 175, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 50, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "domain": null }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "length": 80, "domain": { "type": "codedValue", "name": "CIPProjectType", "description": "The type of CIP", "codedValues": [ { "name": "Streets", "code": "Streets" }, { "name": "Other", "code": "Other" }, { "name": "Water", "code": "Water" }, { "name": "Sanitary Sewer", "code": "Sanitary Sewer" }, { "name": "Stormwater", "code": "Stormwater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FUNDSOUR", "type": "esriFieldTypeString", "alias": "Funding Source", "length": 80, "domain": { "type": "codedValue", "name": "CIPFundingSource", "description": "The funding source for the CIP", "codedValues": [ { "name": "System Revenues", "code": "System Revenues" }, { "name": "Other", "code": "Other" }, { "name": "Water Enterprise Fund", "code": "Water Enterprise Fund" }, { "name": "Other Agencies", "code": "Other Agencies" }, { "name": "Solid Waste and Recycling Enterprise Fund", "code": "Solid Waste and Recycling Enterprise Fund" }, { "name": "FEMA", "code": "FEMA" }, { "name": "General Fund", "code": "General Fund" }, { "name": "Measure T", "code": "Measure T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "length": 80, "domain": null }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 80, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "length": 20, "domain": null }, { "name": "CIPPRIORITY", "type": "esriFieldTypeString", "alias": "CIPPRIORITY", "length": 20, "domain": null }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CICIP INTERAGENCY MAP", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeInteger", "alias": "CIPFISCALYEAR", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "PLAN_YEAR", "type": "esriFieldTypeString", "alias": "PLAN_YEAR", "length": 50, "domain": null }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION CREW", "length": 50, "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R144_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G438PROJNAME", "fields": "PROJNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_144", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_144", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S66_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{D3D0F591-A151-4933-9ADF-4C47E67C2141}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Number Of Main Breaks Per Area", "type": "Feature Layer", "description": "The number of main breaks per area.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 203, 235, 242, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 125, "domain": null }, { "name": "DEFCNT", "type": "esriFieldTypeSmallInteger", "alias": "Defect Count", "domain": null }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length of Main", "domain": null }, { "name": "DEFPRLEN", "type": "esriFieldTypeDouble", "alias": "Number of Defects per Length", "domain": null }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R133_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_133", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_133", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S55_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Operations Area Report", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 224, 204, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "METERCNT", "type": "esriFieldTypeInteger", "alias": "Number of Meters", "domain": null }, { "name": "HYDCNT", "type": "esriFieldTypeInteger", "alias": "Number of Hydrants", "domain": null }, { "name": "VALVECNT", "type": "esriFieldTypeInteger", "alias": "Number of Valves", "domain": null }, { "name": "MAINLEN", "type": "esriFieldTypeDouble", "alias": "Total Main Length", "domain": null }, { "name": "LEAKCNT", "type": "esriFieldTypeInteger", "alias": "Number of Leaks", "domain": null }, { "name": "GALLOST", "type": "esriFieldTypeDouble", "alias": "Number of Gallons Lost", "domain": null }, { "name": "LEAKSMEAS", "type": "esriFieldTypeDouble", "alias": "Leaks per Mile", "domain": null }, { "name": "MODELDATE", "type": "esriFieldTypeDate", "alias": "Run Date for Feature", "length": 8, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Area Name", "length": 50, "domain": null }, { "name": "ENGINEER", "type": "esriFieldTypeString", "alias": "Engineer", "length": 50, "domain": null }, { "name": "METERCONS1", "type": "esriFieldTypeDouble", "alias": "Current Total Water Usage", "domain": null }, { "name": "METERCONS2", "type": "esriFieldTypeDouble", "alias": "Last Total Water Usage", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R132_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_132", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_132", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S54_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "Service Area Report", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.0032808333333333335, "zTolerance": 2.0E-5, "mTolerance": 2.0E-5, "falseX": -17463800, "falseY": -46132600, "xyUnits": 3048.0060960121914, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 195, 247, 234, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": "NaN", "ymin": "NaN", "xmax": "NaN", "ymax": "NaN", "spatialReference": { "wkid": 102642, "latestWkid": 2226, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -115211800, "falseY": -93821500, "xyUnits": 3.5908650709057175E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "METERCNT", "type": "esriFieldTypeInteger", "alias": "Number of Meters", "domain": null }, { "name": "HYDCNT", "type": "esriFieldTypeInteger", "alias": "Number of Hydrants", "domain": null }, { "name": "VALVECNT", "type": "esriFieldTypeInteger", "alias": "Number of Valves", "domain": null }, { "name": "MAINLEN", "type": "esriFieldTypeDouble", "alias": "Total Main Length", "domain": null }, { "name": "LEAKCNT", "type": "esriFieldTypeInteger", "alias": "Number of Leaks", "domain": null }, { "name": "GALLOST", "type": "esriFieldTypeDouble", "alias": "Number of Gallons Lost", "domain": null }, { "name": "LEAKSMEAS", "type": "esriFieldTypeDouble", "alias": "Leaks per Mile", "domain": null }, { "name": "MODELDATE", "type": "esriFieldTypeDate", "alias": "Run Date for Feature", "length": 8, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Area Name", "length": 50, "domain": null }, { "name": "ENGINEER", "type": "esriFieldTypeString", "alias": "Engineer", "length": 50, "domain": null }, { "name": "METERCONS1", "type": "esriFieldTypeDouble", "alias": "Current Total Water Usage", "domain": null }, { "name": "METERCONS2", "type": "esriFieldTypeDouble", "alias": "Last Total Water Usage", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R131_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_131", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_131", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S53_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 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": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "05b8db5751804915b405795587b57857" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "Water CIP Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIPID", "length": 255, "domain": null }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project_Name", "length": 255, "domain": null }, { "name": "Segment_ID", "type": "esriFieldTypeInteger", "alias": "Segment_ID", "domain": null }, { "name": "GIS_FacilityIDs", "type": "esriFieldTypeString", "alias": "GIS_FacilityIDs", "length": 255, "domain": null }, { "name": "CIPID_Priority", "type": "esriFieldTypeString", "alias": "CIPID_Priority", "length": 255, "domain": null }, { "name": "Year_Priority", "type": "esriFieldTypeString", "alias": "Year_Priority", "length": 255, "domain": null }, { "name": "Proposed_Fyear", "type": "esriFieldTypeInteger", "alias": "Proposed_Fyear", "domain": null }, { "name": "Completion_Date", "type": "esriFieldTypeString", "alias": "Completion_Date", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": null }, { "name": "Priority_In_Year", "type": "esriFieldTypeString", "alias": "Priority_In_Year", "length": 255, "domain": null }, { "name": "Priority_In_Project", "type": "esriFieldTypeString", "alias": "Priority_In_Project", "length": 255, "domain": null }, { "name": "Road_Name", "type": "esriFieldTypeString", "alias": "Road_Name", "length": 255, "domain": null }, { "name": "Project_Limits_1", "type": "esriFieldTypeString", "alias": "Project_Limits_1", "length": 255, "domain": null }, { "name": "Project_Limits_2", "type": "esriFieldTypeString", "alias": "Project_Limits_2", "length": 255, "domain": null }, { "name": "Pipe_Age", "type": "esriFieldTypeString", "alias": "Pipe_Age", "length": 255, "domain": null }, { "name": "Pipe_Material", "type": "esriFieldTypeString", "alias": "Pipe_Material", "length": 255, "domain": null }, { "name": "Project_Length_ft", "type": "esriFieldTypeInteger", "alias": "Project_Length_ft", "domain": null }, { "name": "Improvement_Type", "type": "esriFieldTypeString", "alias": "Improvement_Type", "length": 255, "domain": null }, { "name": "Major_Minor", "type": "esriFieldTypeString", "alias": "Major_Minor", "length": 255, "domain": null }, { "name": "Construction__Crew", "type": "esriFieldTypeString", "alias": "Construction__Crew", "length": 255, "domain": null }, { "name": "Existing", "type": "esriFieldTypeInteger", "alias": "Existing", "domain": null }, { "name": "Future", "type": "esriFieldTypeInteger", "alias": "Future", "domain": null }, { "name": "No_of_Hydrants", "type": "esriFieldTypeInteger", "alias": "No_of_Hydrants", "domain": null }, { "name": "No_of_ResidentServices", "type": "esriFieldTypeInteger", "alias": "No_of_ResidentServices", "domain": null }, { "name": "No_of_Large_Services", "type": "esriFieldTypeInteger", "alias": "No_of_Large_Services", "domain": null }, { "name": "No_of_Tie_ins", "type": "esriFieldTypeInteger", "alias": "No_of_Tie_ins", "domain": null }, { "name": "Work_Description", "type": "esriFieldTypeString", "alias": "Work_Description", "length": 255, "domain": null }, { "name": "Project_Costs_Hydrants_Services", "type": "esriFieldTypeInteger", "alias": "Project_Costs_Hydrants_Services_TieIns", "domain": null }, { "name": "Project_Costs_Water_Main", "type": "esriFieldTypeInteger", "alias": "Project_Costs_Water_Main", "domain": null }, { "name": "Project_Costs_True_Water_Main_l", "type": "esriFieldTypeDouble", "alias": "Project_Costs_True_Water_Main_length_modifier", "domain": null }, { "name": "Project_Extras_Permits_Traffic_", "type": "esriFieldTypeInteger", "alias": "Project_Extras_Permits_Traffic_Control_Other_Work", "domain": null }, { "name": "Total_Project_Cost", "type": "esriFieldTypeInteger", "alias": "Total_Project_Cost", "domain": null }, { "name": "Map_primary", "type": "esriFieldTypeString", "alias": "Map_primary", "length": 255, "domain": null }, { "name": "Map_secondary", "type": "esriFieldTypeString", "alias": "Map_secondary", "length": 255, "domain": null }, { "name": "Map_tertiary", "type": "esriFieldTypeString", "alias": "Map_tertiary", "length": 255, "domain": null }, { "name": "Driving_Work1", "type": "esriFieldTypeString", "alias": "Driving_Work1", "length": 255, "domain": null }, { "name": "Driving_Work2", "type": "esriFieldTypeString", "alias": "Driving_Work2", "length": 255, "domain": null }, { "name": "Driving_Work3", "type": "esriFieldTypeString", "alias": "Driving_Work3", "length": 255, "domain": null }, { "name": "Funding_Source", "type": "esriFieldTypeString", "alias": "Funding_Source", "length": 255, "domain": null }, { "name": "Leak_Count", "type": "esriFieldTypeInteger", "alias": "Leak_Count", "domain": null }, { "name": "Year_Done", "type": "esriFieldTypeString", "alias": "Year_Done", "length": 255, "domain": null }, { "name": "Scheduled_Paving_Year", "type": "esriFieldTypeString", "alias": "Scheduled_Paving_Year", "length": 255, "domain": null }, { "name": "Paving_Area", "type": "esriFieldTypeString", "alias": "Paving_Area", "length": 255, "domain": null }, { "name": "Report", "type": "esriFieldTypeString", "alias": "Report", "length": 255, "domain": null }, { "name": "GIS", "type": "esriFieldTypeString", "alias": "GIS", "length": 255, "domain": null }, { "name": "Water_Priority", "type": "esriFieldTypeInteger", "alias": "Water_Priority", "domain": null }, { "name": "MainCostAlt", "type": "esriFieldTypeInteger", "alias": "MainCostAlt", "domain": null }, { "name": "TotalCostAlt", "type": "esriFieldTypeInteger", "alias": "TotalCostAlt", "domain": null }, { "name": "countCIPID", "type": "esriFieldTypeInteger", "alias": "countCIPID", "domain": null }, { "name": "COUNT_CIPIDSegment", "type": "esriFieldTypeInteger", "alias": "COUNT_CIPIDSegment", "domain": null }, { "name": "CIPID_Year_Priority", "type": "esriFieldTypeString", "alias": "CIPID_Year_Priority", "length": 255, "domain": null }, { "name": "Project_Description", "type": "esriFieldTypeString", "alias": "Project_Description", "length": 255, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 261, "domain": null }, { "name": "WTR_Project", "type": "esriFieldTypeString", "alias": "WTR_Project", "length": 255, "domain": null }, { "name": "Interagency_Map", "type": "esriFieldTypeString", "alias": "Interagency_Map", "length": 255, "domain": null }, { "name": "Water_CIP_Map", "type": "esriFieldTypeString", "alias": "Water_CIP_Map", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIPComponent", "length": 255, "domain": null } ], "indexes": [ { "name": "R1242_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12115_CIPID_", "fields": "CIPComponent", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "CIPProjectsLocations", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "CIPComponent", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{20A69A1B-CBFC-4602-AAFB-8114B8AE8275}" }, { "id": 5, "name": "CIPProjects", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "CIPComponent", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A6C2B198-A733-4007-BCD8-AB7CFB1CBDD4}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "05b8db5751804915b405795587b57857" } ] }