{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "CIP Point Assets", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "CIPProjects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJNAME", "composite": true, "catalogID": "{C3B88271-A65E-45EC-820F-2D0955293292}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJNAME" }, { "name": "STRATEGY", "type": "esriFieldTypeString", "alias": "Strategy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRATEGY" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "Action", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACTION" }, { "name": "COST", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COST" }, { "name": "MULTI", "type": "esriFieldTypeDouble", "alias": "Multiplier Value", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MULTI" }, { "name": "ADDCOST", "type": "esriFieldTypeDouble", "alias": "Additional Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDCOST" }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTCOST" }, { "name": "EXTFILT1", "type": "esriFieldTypeString", "alias": "Existing Value - 1st", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTFILT1" }, { "name": "EXTFILT2", "type": "esriFieldTypeString", "alias": "Existing Value - 2nd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTFILT2" }, { "name": "PROFILT1", "type": "esriFieldTypeString", "alias": "Replacement Value - 1st", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROFILT1" }, { "name": "PROFILT2", "type": "esriFieldTypeString", "alias": "Replacement Value - 2nd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROFILT2" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "ASSETTYP", "type": "esriFieldTypeString", "alias": "Source Asset", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETTYP" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "SOURCOID", "type": "esriFieldTypeString", "alias": "Source OID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SOURCOID" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Point Assets", "description": "", "prototype": { "attributes": { "COST": null, "LASTUPDATE": null, "PROJNAME": null, "STRATEGY": null, "ACTION": null, "MULTI": 1, "ADDCOST": null, "TOTCOST": null, "EXTFILT1": null, "EXTFILT2": null, "PROFILT1": null, "PROFILT2": null, "NOTES": null, "ASSETTYP": null, "FACILITYID": null, "SOURCOID": null, "LASTEDITOR": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "CIP Project Locations", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "This is a point feature that represents the location of CIP projects and is used in multi-scale maps.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 1, "name": "WaterCIP_Table", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "CIPComponent", "composite": false, "catalogID": "{20A69A1B-CBFC-4602-AAFB-8114B8AE8275}" }, { "id": 2, "name": "CIPProjects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "PROJNAME", "composite": true, "catalogID": "{659954DE-D14C-4C4C-8A12-9FC178028CC9}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJNAME" }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTCOST" }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTLEN" }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAREA" }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTPNT" }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATESTART" }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECOMP" }, { "name": "CIPSTAT", "type": "esriFieldTypeString", "alias": "CIP Status", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Proposed", "modelName": "CIPSTAT" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "NOTES" }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PRJMAN" }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATNAM" }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATDAT" }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "domain": null, "editable": true, "nullable": true, "length": 175, "defaultValue": null, "modelName": "LINK" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "PROJTYPE" }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "MANPHONE" }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "MANEMAIL" }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CIPID" }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CIP INTERAGENCY MAP", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CIP_INTERAGENCYMAP" }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeInteger", "alias": "CIPFISCALYEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CIPFISCALYEAR" }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "FUNDSOUR" }, { "name": "CIP_IMPROVEMENTTYPE", "type": "esriFieldTypeString", "alias": "CIP Improvement Type", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CIP_IMPROVEMENTTYPE" }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION CREW", "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONSTRUCTION_CREW" }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIP COMPONENT", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CIPPRIORITY" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Project Locations", "description": "", "prototype": { "attributes": { "DATECOMP": null, "CIPComponent": null, "PROJNAME": null, "TOTCOST": null, "TOTLEN": null, "TOTAREA": null, "TOTPNT": null, "DATESTART": null, "CIPSTAT": "Proposed", "NOTES": null, "PRJMAN": null, "CREATNAME": null, "CREATDATE": null, "LINK": null, "LASTEDITOR": null, "LASTUPDATE": null, "PROJTYPE": null, "MANPHONE": null, "MANEMAIL": null, "CIPID": null, "CIP_INTERAGENCYMAP": null, "CIPFISCALYEAR": null, "FUNDSOURCE": null, "CIP_IMPROVEMENTTYPE": null, "CONSTRUCTION_CREW": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "CIP Polyline Assets", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 3, "name": "CIPProjects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJNAME", "composite": true, "catalogID": "{4D6C998D-2ADC-4FCD-AF13-AC8FB4E98406}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 17, 0, 166, 255 ], "width": 1.5 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJNAME" }, { "name": "STRATEGY", "type": "esriFieldTypeString", "alias": "Strategy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRATEGY" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "Action", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACTION" }, { "name": "COST", "type": "esriFieldTypeDouble", "alias": "Cost per Unit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COST" }, { "name": "MULTI", "type": "esriFieldTypeDouble", "alias": "Multiplier Value", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MULTI" }, { "name": "LENGTH", "type": "esriFieldTypeString", "alias": "Length", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LENGTH" }, { "name": "ADDCOST", "type": "esriFieldTypeDouble", "alias": "Additional Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDCOST" }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTCOST" }, { "name": "EXTFILT1", "type": "esriFieldTypeString", "alias": "Existing Value - 1st", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTFILT1" }, { "name": "EXTFILT2", "type": "esriFieldTypeString", "alias": "Existing Value - 2nd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTFILT2" }, { "name": "PROFILT1", "type": "esriFieldTypeString", "alias": "Replacement Value - 1st", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROFILT1" }, { "name": "PROFILT2", "type": "esriFieldTypeString", "alias": "Replacement Value - 2nd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROFILT2" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "ASSETTYP", "type": "esriFieldTypeString", "alias": "Source Asset", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETTYP" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "SOURCOID", "type": "esriFieldTypeString", "alias": "Source OID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SOURCOID" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Polyline Assets", "description": "", "prototype": { "attributes": { "COST": null, "LASTUPDATE": null, "PROJNAME": null, "STRATEGY": null, "ACTION": null, "MULTI": 1, "LENGTH": null, "ADDCOST": null, "TOTCOST": null, "EXTFILT1": null, "EXTFILT2": null, "PROFILT1": null, "PROFILT2": null, "NOTES": null, "ASSETTYP": null, "FACILITYID": null, "SOURCOID": null, "LASTEDITOR": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Breaks Per Mile of Water Main", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "The number of breaks per mile of water main.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 255, 0, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SCORE" }, { "name": "DEFPRDIS", "type": "esriFieldTypeDouble", "alias": "Breaks or Leaks per Mile", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEFPRDIS" }, { "name": "DEFCOUNT", "type": "esriFieldTypeInteger", "alias": "Breaks or Leaks Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEFCOUNT" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Breaks Per Mile of Water Main", "description": "", "prototype": { "attributes": { "REPORTDT": null, "FACILITYID": null, "SCORE": null, "DEFPRDIS": null, "DEFCOUNT": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Water Mains Life Expectancy", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "The life expectancy of the water mains.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 35, 163, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "LIFEEXPT", "type": "esriFieldTypeDouble", "alias": "Life Expectancy", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LIFEEXPT" }, { "name": "REMLIF", "type": "esriFieldTypeDouble", "alias": "Remaing Life Expectancy", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REMLIF" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SCORE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MATERIAL" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Mains Life Expectancy", "description": "", "prototype": { "attributes": { "REPORTDT": null, "FACILITYID": null, "LIFEEXPT": null, "REMLIF": null, "SCORE": null, "INSTALLDATE": null, "MATERIAL": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Water Mains With Overlapping Projects", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "Water mains that overlap other projects.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 166, 0, 83, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OTHPRJ" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Mains With Overlapping Projects", "description": "", "prototype": { "attributes": { "REPORTDT": null, "FACILITYID": null, "OTHPRJ": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Water Mains With Trace Summary", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "Water mains with trace summary.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 148, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "VALVECOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Valve Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVECOUNT" }, { "name": "METERCOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Meter Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCOUNT" }, { "name": "NUMCRITMETER", "type": "esriFieldTypeSmallInteger", "alias": "Number of Critical Customers", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMCRITMETER" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Mains With Trace Summary", "description": "", "prototype": { "attributes": { "REPORTDT": null, "FACILITYID": null, "VALVECOUNT": null, "METERCOUNT": null, "NUMCRITMETER": null, "COMMENTS": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Water Mains With Dirty Water Complaints", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "Water mains that have dirty water complaints.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 97, 171, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HASCOMPL" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Mains With Dirty Water Complaints", "description": "", "prototype": { "attributes": { "REPORTDT": null, "FACILITYID": null, "HASCOMPL": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Water Main Criticality Score", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "The water main criticality score.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 168, 42, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "RAILROAD" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "MAJROAD" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "CRITMET" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "SCORE" }, { "name": "METERCOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Meter Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCOUNT" }, { "name": "VALVECOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Valve Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVECOUNT" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Main Criticality Score", "description": "", "prototype": { "attributes": { "FACILITYID": null, "RAILROAD": 0, "MAJROAD": 0, "CRITMET": 0, "REPORTDT": null, "SCORE": 0, "METERCOUNT": null, "VALVECOUNT": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "CIP Polygon Assets", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 4, "name": "CIPProjects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PROJNAME", "composite": true, "catalogID": "{DA0E083E-CCAB-4867-8837-F52BE35AA17B}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJNAME" }, { "name": "STRATEGY", "type": "esriFieldTypeString", "alias": "Strategy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRATEGY" }, { "name": "ACTION", "type": "esriFieldTypeString", "alias": "Action", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACTION" }, { "name": "COST", "type": "esriFieldTypeDouble", "alias": "Cost per Unit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COST" }, { "name": "MULTI", "type": "esriFieldTypeDouble", "alias": "Multiplier Value", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "MULTI" }, { "name": "ADDCOST", "type": "esriFieldTypeDouble", "alias": "Additional Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDCOST" }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTCOST" }, { "name": "EXTFILT1", "type": "esriFieldTypeString", "alias": "Existing Value - 1st", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTFILT1" }, { "name": "EXTFILT2", "type": "esriFieldTypeString", "alias": "Existing Value - 2nd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EXTFILT2" }, { "name": "PROFILT1", "type": "esriFieldTypeString", "alias": "Replacement Value - 1st", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROFILT1" }, { "name": "PROFILT2", "type": "esriFieldTypeString", "alias": "Replacement Value - 2nd", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROFILT2" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Asset Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NOTES" }, { "name": "ASSETTYP", "type": "esriFieldTypeString", "alias": "Source Asset", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ASSETTYP" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Asset ID", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "SOURCOID", "type": "esriFieldTypeString", "alias": "Source OID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SOURCOID" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "TotalCost", "type": "esriFieldTypeInteger", "alias": "TotalCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalCost" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Polygon Assets", "description": "", "prototype": { "attributes": { "COST": null, "TotalCost": null, "PROJNAME": null, "STRATEGY": null, "ACTION": null, "MULTI": 1, "ADDCOST": null, "TOTCOST": null, "EXTFILT1": null, "EXTFILT2": null, "PROFILT1": null, "PROFILT2": null, "NOTES": null, "ASSETTYP": null, "FACILITYID": null, "SOURCOID": null, "LASTEDITOR": null, "LASTUPDATE": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "CIP Project Outlines", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "CIPPoints", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "composite": true, "catalogID": "{C3B88271-A65E-45EC-820F-2D0955293292}" }, { "id": 2, "name": "CIPProjectsLocations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "composite": true, "catalogID": "{659954DE-D14C-4C4C-8A12-9FC178028CC9}" }, { "id": 5, "name": "WaterCIP_Table", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "CIPComponent", "composite": false, "catalogID": "{A6C2B198-A733-4007-BCD8-AB7CFB1CBDD4}" }, { "id": 3, "name": "CIPPolylines", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "composite": true, "catalogID": "{4D6C998D-2ADC-4FCD-AF13-AC8FB4E98406}" }, { "id": 4, "name": "CIPPolygons", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "composite": true, "catalogID": "{DA0E083E-CCAB-4867-8837-F52BE35AA17B}" }, { "id": 6, "name": "CIPProjectsOverview", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "PROJNAME", "composite": true, "catalogID": "{D3D0F591-A151-4933-9ADF-4C47E67C2141}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJNAME" }, { "name": "TOTCOST", "type": "esriFieldTypeInteger", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTCOST" }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTLEN" }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAREA" }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTPNT" }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATESTART" }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECOMP" }, { "name": "CIPSTATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Proposed", "modelName": "CIPSTAT" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "NOTES" }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PRJMAN" }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATNAM" }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATDAT" }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "domain": null, "editable": true, "nullable": true, "length": 175, "defaultValue": null, "modelName": "LINK" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "PROJTYPE" }, { "name": "FUNDSOURCE", "type": "esriFieldTypeString", "alias": "Funding Source", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "FUNDSOUR" }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "MANPHONE" }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "MANEMAIL" }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CIPID" }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeSmallInteger", "alias": "CIP FYEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CIPFISCALYEAR" }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CIP INTERAGENCY MAP", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CIP_INTERAGENCYMAP" }, { "name": "CIP_IMPROVEMENT_TYPE", "type": "esriFieldTypeString", "alias": "CIP IMPROVE TYPE", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CIP_IMPROVEMENT_TYPE" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "Plan_Year", "type": "esriFieldTypeString", "alias": "Plan Year", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Plan_Year" }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION_CREW", "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONSTRUCTION_CREW" }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIPComponent", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CIPPRIORITY" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Description" }, { "name": "BudgetFund", "type": "esriFieldTypeString", "alias": "Budget Fund", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BudgetFund" }, { "name": "Diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Diameter" }, { "name": "PipeMaterial", "type": "esriFieldTypeString", "alias": "Pipe Material", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "PipeMaterial" }, { "name": "CIPMethod", "type": "esriFieldTypeString", "alias": "CIP Method", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CIPMethod" }, { "name": "CostLinear", "type": "esriFieldTypeInteger", "alias": "Cost Linear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CostLinear" }, { "name": "CostOther", "type": "esriFieldTypeInteger", "alias": "Cost Other", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CostOther" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Project Outlines", "description": "", "prototype": { "attributes": { "DATECOMP": null, "CostLinear": null, "PROJNAME": null, "TOTCOST": null, "TOTLEN": null, "TOTAREA": null, "TOTPNT": null, "DATESTART": null, "CIPSTATUS": "Proposed", "NOTES": null, "PRJMAN": null, "CREATNAME": null, "CREATDATE": null, "LINK": null, "LASTEDITOR": null, "LASTUPDATE": null, "PROJTYPE": null, "FUNDSOURCE": null, "MANPHONE": null, "MANEMAIL": null, "CIPID": null, "CIPFISCALYEAR": null, "CIP_INTERAGENCYMAP": null, "CIP_IMPROVEMENT_TYPE": null, "CostOther": null, "CIPMethod": null, "Plan_Year": null, "CONSTRUCTION_CREW": null, "CIPComponent": null, "Description": null, "BudgetFund": null, "Diameter": null, "PipeMaterial": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "CIP Project Overviews", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "A polygon that represents an overview of the CIP project.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 6, "name": "CIPProjects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "PROJNAME", "composite": true, "catalogID": "{D3D0F591-A151-4933-9ADF-4C47E67C2141}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "PROJNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "PROJNAME", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJNAME" }, { "name": "TOTCOST", "type": "esriFieldTypeDouble", "alias": "Total Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTCOST" }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTLEN" }, { "name": "TOTAREA", "type": "esriFieldTypeDouble", "alias": "Total Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAREA" }, { "name": "TOTPNT", "type": "esriFieldTypeDouble", "alias": "Point Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTPNT" }, { "name": "DATESTART", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATESTART" }, { "name": "DATECOMP", "type": "esriFieldTypeDate", "alias": "Date Completed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECOMP" }, { "name": "CIPSTATUS", "type": "esriFieldTypeString", "alias": "CIP Status", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Proposed", "modelName": "CIPSTAT" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "NOTES" }, { "name": "PRJMAN", "type": "esriFieldTypeString", "alias": "Project Manager", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PRJMAN" }, { "name": "CREATNAME", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CREATNAM" }, { "name": "CREATDATE", "type": "esriFieldTypeDate", "alias": "Date Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATDAT" }, { "name": "LINK", "type": "esriFieldTypeString", "alias": "Link to Report", "domain": null, "editable": true, "nullable": true, "length": 175, "defaultValue": null, "modelName": "LINK" }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LASTEDITOR" }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Last Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LASTUPDATE" }, { "name": "PROJTYPE", "type": "esriFieldTypeString", "alias": "Project Type", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "PROJTYPE" }, { "name": "FUNDSOUR", "type": "esriFieldTypeString", "alias": "Funding Source", "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" }, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "FUNDSOUR" }, { "name": "MANPHONE", "type": "esriFieldTypeString", "alias": "Contact Phone", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "MANPHONE" }, { "name": "MANEMAIL", "type": "esriFieldTypeString", "alias": "Contact Email", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "MANEMAIL" }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIP ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CIPID" }, { "name": "CIPPRIORITY", "type": "esriFieldTypeString", "alias": "CIPPRIORITY", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CIPPRIORITY" }, { "name": "CIP_INTERAGENCYMAP", "type": "esriFieldTypeString", "alias": "CICIP INTERAGENCY MAP", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CIP_INTERAGENCYMAP" }, { "name": "CIPFISCALYEAR", "type": "esriFieldTypeInteger", "alias": "CIPFISCALYEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CIPFISCALYEAR" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "PLAN_YEAR", "type": "esriFieldTypeString", "alias": "PLAN_YEAR", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PLAN_YEAR" }, { "name": "CONSTRUCTION_CREW", "type": "esriFieldTypeString", "alias": "CONSTRUCTION CREW", "domain": { "type": "codedValue", "name": "ConstructionCrew", "description": "Used in Water CIP", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Contractor", "code": "Contractor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONSTRUCTION_CREW" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CIP Project Overviews", "description": "", "prototype": { "attributes": { "DATECOMP": null, "PLAN_YEAR": null, "PROJNAME": null, "TOTCOST": null, "TOTLEN": null, "TOTAREA": null, "TOTPNT": null, "DATESTART": null, "CIPSTATUS": "Proposed", "NOTES": null, "PRJMAN": null, "CREATNAME": null, "CREATDATE": null, "LINK": null, "LASTEDITOR": null, "LASTUPDATE": null, "PROJTYPE": null, "FUNDSOUR": null, "MANPHONE": null, "MANEMAIL": null, "CIPID": null, "CIPPRIORITY": null, "CIP_INTERAGENCYMAP": null, "CIPFISCALYEAR": null, "CONSTRUCTION_CREW": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Number Of Main Breaks Per Area", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "The number of main breaks per area.", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 125, "defaultValue": null, "modelName": "NAME" }, { "name": "DEFCNT", "type": "esriFieldTypeSmallInteger", "alias": "Defect Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEFCNT" }, { "name": "TOTLEN", "type": "esriFieldTypeDouble", "alias": "Total Length of Main", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTLEN" }, { "name": "DEFPRLEN", "type": "esriFieldTypeDouble", "alias": "Number of Defects per Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEFPRLEN" }, { "name": "REPORTDT", "type": "esriFieldTypeDate", "alias": "Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORTDT" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "System-maintained Geometry for a feature" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Number Of Main Breaks Per Area", "description": "", "prototype": { "attributes": { "REPORTDT": null, "NAME": null, "DEFCNT": null, "TOTLEN": null, "DEFPRLEN": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Operations Area Report", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "METERCNT", "type": "esriFieldTypeInteger", "alias": "Number of Meters", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCNT" }, { "name": "HYDCNT", "type": "esriFieldTypeInteger", "alias": "Number of Hydrants", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDCNT" }, { "name": "VALVECNT", "type": "esriFieldTypeInteger", "alias": "Number of Valves", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVECNT" }, { "name": "MAINLEN", "type": "esriFieldTypeDouble", "alias": "Total Main Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAINLEN" }, { "name": "LEAKCNT", "type": "esriFieldTypeInteger", "alias": "Number of Leaks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LEAKCNT" }, { "name": "GALLOST", "type": "esriFieldTypeDouble", "alias": "Number of Gallons Lost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GALLOST" }, { "name": "LEAKSMEAS", "type": "esriFieldTypeDouble", "alias": "Leaks per Mile", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LEAKSMEAS" }, { "name": "MODELDATE", "type": "esriFieldTypeDate", "alias": "Run Date for Feature", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MODELDATE" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Area Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "ENGINEER", "type": "esriFieldTypeString", "alias": "Engineer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ENGINEER" }, { "name": "METERCONS1", "type": "esriFieldTypeDouble", "alias": "Current Total Water Usage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCONS1" }, { "name": "METERCONS2", "type": "esriFieldTypeDouble", "alias": "Last Total Water Usage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCONS2" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Operations Area Report", "description": "", "prototype": { "attributes": { "METERCONS2": null, "METERCNT": null, "HYDCNT": null, "VALVECNT": null, "MAINLEN": null, "LEAKCNT": null, "GALLOST": null, "LEAKSMEAS": null, "MODELDATE": null, "NAME": null, "ENGINEER": null, "METERCONS1": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "Service Area Report", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": false, "minScale": 150000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "METERCNT", "type": "esriFieldTypeInteger", "alias": "Number of Meters", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCNT" }, { "name": "HYDCNT", "type": "esriFieldTypeInteger", "alias": "Number of Hydrants", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDCNT" }, { "name": "VALVECNT", "type": "esriFieldTypeInteger", "alias": "Number of Valves", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVECNT" }, { "name": "MAINLEN", "type": "esriFieldTypeDouble", "alias": "Total Main Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAINLEN" }, { "name": "LEAKCNT", "type": "esriFieldTypeInteger", "alias": "Number of Leaks", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LEAKCNT" }, { "name": "GALLOST", "type": "esriFieldTypeDouble", "alias": "Number of Gallons Lost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GALLOST" }, { "name": "LEAKSMEAS", "type": "esriFieldTypeDouble", "alias": "Leaks per Mile", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LEAKSMEAS" }, { "name": "MODELDATE", "type": "esriFieldTypeDate", "alias": "Run Date for Feature", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MODELDATE" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Area Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NAME" }, { "name": "ENGINEER", "type": "esriFieldTypeString", "alias": "Engineer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ENGINEER" }, { "name": "METERCONS1", "type": "esriFieldTypeDouble", "alias": "Current Total Water Usage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCONS1" }, { "name": "METERCONS2", "type": "esriFieldTypeDouble", "alias": "Last Total Water Usage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "METERCONS2" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Service Area Report", "description": "", "prototype": { "attributes": { "METERCONS2": null, "METERCNT": null, "HYDCNT": null, "VALVECNT": null, "MAINLEN": null, "LEAKCNT": null, "GALLOST": null, "LEAKSMEAS": null, "MODELDATE": null, "NAME": null, "ENGINEER": null, "METERCONS1": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "Water CIP Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "CIPProjectsLocations", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CIPComponent", "composite": false, "catalogID": "{20A69A1B-CBFC-4602-AAFB-8114B8AE8275}" }, { "id": 5, "name": "CIPProjects", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CIPComponent", "composite": false, "catalogID": "{A6C2B198-A733-4007-BCD8-AB7CFB1CBDD4}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Project_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CIPID", "type": "esriFieldTypeString", "alias": "CIPID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CIPID" }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project_Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Name" }, { "name": "Segment_ID", "type": "esriFieldTypeInteger", "alias": "Segment_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment_ID" }, { "name": "GIS_FacilityIDs", "type": "esriFieldTypeString", "alias": "GIS_FacilityIDs", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GIS_FacilityIDs" }, { "name": "CIPID_Priority", "type": "esriFieldTypeString", "alias": "CIPID_Priority", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CIPID_Priority" }, { "name": "Year_Priority", "type": "esriFieldTypeString", "alias": "Year_Priority", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Year_Priority" }, { "name": "Proposed_Fyear", "type": "esriFieldTypeInteger", "alias": "Proposed_Fyear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Proposed_Fyear" }, { "name": "Completion_Date", "type": "esriFieldTypeString", "alias": "Completion_Date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Completion_Date" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "name": "Priority_In_Year", "type": "esriFieldTypeString", "alias": "Priority_In_Year", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Priority_In_Year" }, { "name": "Priority_In_Project", "type": "esriFieldTypeString", "alias": "Priority_In_Project", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Priority_In_Project" }, { "name": "Road_Name", "type": "esriFieldTypeString", "alias": "Road_Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Road_Name" }, { "name": "Project_Limits_1", "type": "esriFieldTypeString", "alias": "Project_Limits_1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Limits_1" }, { "name": "Project_Limits_2", "type": "esriFieldTypeString", "alias": "Project_Limits_2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Limits_2" }, { "name": "Pipe_Age", "type": "esriFieldTypeString", "alias": "Pipe_Age", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pipe_Age" }, { "name": "Pipe_Material", "type": "esriFieldTypeString", "alias": "Pipe_Material", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pipe_Material" }, { "name": "Project_Length_ft", "type": "esriFieldTypeInteger", "alias": "Project_Length_ft", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Length_ft" }, { "name": "Improvement_Type", "type": "esriFieldTypeString", "alias": "Improvement_Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Improvement_Type" }, { "name": "Major_Minor", "type": "esriFieldTypeString", "alias": "Major_Minor", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Major_Minor" }, { "name": "Construction__Crew", "type": "esriFieldTypeString", "alias": "Construction__Crew", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Construction__Crew" }, { "name": "Existing", "type": "esriFieldTypeInteger", "alias": "Existing", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Existing" }, { "name": "Future", "type": "esriFieldTypeInteger", "alias": "Future", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Future" }, { "name": "No_of_Hydrants", "type": "esriFieldTypeInteger", "alias": "No_of_Hydrants", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "No_of_Hydrants" }, { "name": "No_of_ResidentServices", "type": "esriFieldTypeInteger", "alias": "No_of_ResidentServices", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "No_of_ResidentServices" }, { "name": "No_of_Large_Services", "type": "esriFieldTypeInteger", "alias": "No_of_Large_Services", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "No_of_Large_Services" }, { "name": "No_of_Tie_ins", "type": "esriFieldTypeInteger", "alias": "No_of_Tie_ins", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "No_of_Tie_ins" }, { "name": "Work_Description", "type": "esriFieldTypeString", "alias": "Work_Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Work_Description" }, { "name": "Project_Costs_Hydrants_Services", "type": "esriFieldTypeInteger", "alias": "Project_Costs_Hydrants_Services_TieIns", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Costs_Hydrants_Services_TieIns" }, { "name": "Project_Costs_Water_Main", "type": "esriFieldTypeInteger", "alias": "Project_Costs_Water_Main", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Costs_Water_Main" }, { "name": "Project_Costs_True_Water_Main_l", "type": "esriFieldTypeDouble", "alias": "Project_Costs_True_Water_Main_length_modifier", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Costs_True_Water_Main_length_modifier" }, { "name": "Project_Extras_Permits_Traffic_", "type": "esriFieldTypeInteger", "alias": "Project_Extras_Permits_Traffic_Control_Other_Work", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Extras_Permits_Traffic_Control_Other_Work" }, { "name": "Total_Project_Cost", "type": "esriFieldTypeInteger", "alias": "Total_Project_Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Project_Cost" }, { "name": "Map_primary", "type": "esriFieldTypeString", "alias": "Map_primary", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Map_primary" }, { "name": "Map_secondary", "type": "esriFieldTypeString", "alias": "Map_secondary", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Map_secondary" }, { "name": "Map_tertiary", "type": "esriFieldTypeString", "alias": "Map_tertiary", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Map_tertiary" }, { "name": "Driving_Work1", "type": "esriFieldTypeString", "alias": "Driving_Work1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Driving_Work1" }, { "name": "Driving_Work2", "type": "esriFieldTypeString", "alias": "Driving_Work2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Driving_Work2" }, { "name": "Driving_Work3", "type": "esriFieldTypeString", "alias": "Driving_Work3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Driving_Work3" }, { "name": "Funding_Source", "type": "esriFieldTypeString", "alias": "Funding_Source", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Funding_Source" }, { "name": "Leak_Count", "type": "esriFieldTypeInteger", "alias": "Leak_Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Leak_Count" }, { "name": "Year_Done", "type": "esriFieldTypeString", "alias": "Year_Done", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Year_Done" }, { "name": "Scheduled_Paving_Year", "type": "esriFieldTypeString", "alias": "Scheduled_Paving_Year", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Scheduled_Paving_Year" }, { "name": "Paving_Area", "type": "esriFieldTypeString", "alias": "Paving_Area", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Paving_Area" }, { "name": "Report", "type": "esriFieldTypeString", "alias": "Report", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Report" }, { "name": "GIS", "type": "esriFieldTypeString", "alias": "GIS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GIS" }, { "name": "Water_Priority", "type": "esriFieldTypeInteger", "alias": "Water_Priority", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Water_Priority" }, { "name": "MainCostAlt", "type": "esriFieldTypeInteger", "alias": "MainCostAlt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MainCostAlt" }, { "name": "TotalCostAlt", "type": "esriFieldTypeInteger", "alias": "TotalCostAlt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalCostAlt" }, { "name": "countCIPID", "type": "esriFieldTypeInteger", "alias": "countCIPID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "countCIPID" }, { "name": "COUNT_CIPIDSegment", "type": "esriFieldTypeInteger", "alias": "COUNT_CIPIDSegment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COUNT_CIPIDSegment" }, { "name": "CIPID_Year_Priority", "type": "esriFieldTypeString", "alias": "CIPID_Year_Priority", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CIPID_Year_Priority" }, { "name": "Project_Description", "type": "esriFieldTypeString", "alias": "Project_Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Project_Description" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 261, "defaultValue": null, "modelName": "Notes" }, { "name": "WTR_Project", "type": "esriFieldTypeString", "alias": "WTR_Project", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WTR_Project" }, { "name": "Interagency_Map", "type": "esriFieldTypeString", "alias": "Interagency_Map", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Interagency_Map" }, { "name": "Water_CIP_Map", "type": "esriFieldTypeString", "alias": "Water_CIP_Map", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Water_CIP_Map" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "CIPComponent", "type": "esriFieldTypeString", "alias": "CIPComponent", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CIPID_Segment_formula" } ], "indexes": [ { "name": "R1242_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_12115_CIPID_", "fields": "CIPComponent", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water CIP Table", "description": "", "prototype": { "attributes": { "Water_CIP_Map": null, "CIPComponent": null, "CIPID": null, "Project_Name": null, "Segment_ID": null, "GIS_FacilityIDs": null, "CIPID_Priority": null, "Year_Priority": null, "Proposed_Fyear": null, "Completion_Date": null, "Status": null, "Priority_In_Year": null, "Priority_In_Project": null, "Road_Name": null, "Project_Limits_1": null, "Project_Limits_2": null, "Pipe_Age": null, "Pipe_Material": null, "Project_Length_ft": null, "Improvement_Type": null, "Major_Minor": null, "Construction__Crew": null, "Existing": null, "Future": null, "No_of_Hydrants": null, "No_of_ResidentServices": null, "No_of_Large_Services": null, "No_of_Tie_ins": null, "Work_Description": null, "Project_Costs_Hydrants_Services": null, "Project_Costs_Water_Main": null, "Project_Costs_True_Water_Main_l": null, "Project_Extras_Permits_Traffic_": null, "Total_Project_Cost": null, "Map_primary": null, "Map_secondary": null, "Map_tertiary": null, "Driving_Work1": null, "Driving_Work2": null, "Driving_Work3": null, "Funding_Source": null, "Leak_Count": null, "Year_Done": null, "Scheduled_Paving_Year": null, "Paving_Area": null, "Report": null, "GIS": null, "Water_Priority": null, "MainCostAlt": null, "TotalCostAlt": null, "countCIPID": null, "COUNT_CIPIDSegment": null, "CIPID_Year_Priority": null, "Project_Description": null, "Notes": null, "WTR_Project": null, "Interagency_Map": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "4a0e46113ffe4b7eb8cf8c54499c48cf" } ] }