{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 32, "name": "Raw Water System Valve", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": -1.0886282785057947E7, "ymin": 4536147.35234397, "xmax": -1.083684168065151E7, "ymax": 4588108.534834014, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102678, "latestWkid": 3420, "xyTolerance": 0.006561666658081819, "zTolerance": 2, "mTolerance": 2, "falseX": -1.2102569999929017E8, "falseY": -9.367489999940652E7, "xyUnits": 2438.40488, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 163, 0, 98, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 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": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Valve Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "RVG_NUMBER" }, { "name": "VALVETYPE", "type": "esriFieldTypeInteger", "alias": "Type", "domain": { "type": "codedValue", "name": "WTRSVLV_RV_TYPE_CD", "description": "Type", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Gate", "code": 1 }, { "name": "Butterfly", "code": 2 }, { "name": "Side Gate", "code": 3 }, { "name": "Ball", "code": 4 }, { "name": "Curb Stop", "code": 5 }, { "name": "Check", "code": 6 }, { "name": "Gear", "code": 7 }, { "name": "Pressure Sustaining", "code": 8 }, { "name": "Plug", "code": 9 }, { "name": "Air Release", "code": 10 }, { "name": "Other", "code": 11 }, { "name": "Corporation Stop", "code": 12 }, { "name": "Air/Vac Release", "code": 13 }, { "name": "Sleeve Valve", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_TYPE_CD" }, { "name": "CLASSIFICATION", "type": "esriFieldTypeInteger", "alias": "Classification", "domain": { "type": "codedValue", "name": "WTRSVLV_RV_CLSS_CD", "description": "Classification", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Line", "code": 1 }, { "name": "Hydrant", "code": 2 }, { "name": "Fire Service", "code": 3 }, { "name": "Domestic Service", "code": 4 }, { "name": "Lawn Service", "code": 5 }, { "name": "Air Release", "code": 6 }, { "name": "Air/Vac Release", "code": 7 }, { "name": "Blow Off", "code": 8 }, { "name": "Outlet", "code": 9 }, { "name": "X-Conn", "code": 10 }, { "name": "Drain", "code": 11 }, { "name": "By-Pass", "code": 12 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_CLSS_CD" }, { "name": "VALVESIZE", "type": "esriFieldTypeDouble", "alias": "Size (in)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_SIZE" }, { "name": "PRESSUREZONE", "type": "esriFieldTypeInteger", "alias": "Pressure Zone", "domain": { "type": "codedValue", "name": "WTRSVLV_RV_ZONE_CD", "description": "Pressure Zone", "codedValues": [ { "name": "West Hills", "code": 1 }, { "name": "N/A", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_ZONE_CD" }, { "name": "ISOLATIONVALVE", "type": "esriFieldTypeSmallInteger", "alias": "Isolation Valve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_ISO_VL" }, { "name": "GPSFLAG", "type": "esriFieldTypeSmallInteger", "alias": "GPS Located", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_GPS_FLG" }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_ELEV" }, { "name": "LucityAutoID", "type": "esriFieldTypeInteger", "alias": "Link to Lucity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LucityAutoID" }, { "name": "INLUCITY", "type": "esriFieldTypeSmallInteger", "alias": "In Lucity Database?", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RVG_DB" }, { "name": "LastModBy", "type": "esriFieldTypeString", "alias": "Last Modified By", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LastModBy" }, { "name": "LastModDate", "type": "esriFieldTypeDate", "alias": "Last Modified date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastModDate" }, { "name": "LastSynDate", "type": "esriFieldTypeDate", "alias": "Last Synchronized Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastSynDate" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "OPSTATUS", "type": "esriFieldTypeSmallInteger", "alias": "Operating Status", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.StatusCode", "description": "StatusCode", "codedValues": [ { "name": "Open", "code": 1 }, { "name": "Closed", "code": 2 }, { "name": "Abandoned", "code": 3 }, { "name": "Buried In Place-Open", "code": 4 }, { "name": "Broken/Not Working", "code": 5 }, { "name": "Buried In Place-Closed", "code": 6 }, { "name": "UNDER CONSTRUCTION", "code": 7 }, { "name": "Pressure Zone Closed", "code": 8 }, { "name": "UNKNOWN", "code": 9 }, { "name": "Rmvd,no longer in service", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPSTATUS" }, { "name": "TURNS", "type": "esriFieldTypeDouble", "alias": "Turns to Open", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TURNS" }, { "name": "GENLOC", "type": "esriFieldTypeString", "alias": "General Location", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "GENLOC" }, { "name": "BUILDNO", "type": "esriFieldTypeInteger", "alias": "Building Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BUILDNO" }, { "name": "STRTNAME", "type": "esriFieldTypeString", "alias": "Street Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STRTNAME" }, { "name": "MAPNO", "type": "esriFieldTypeString", "alias": "Map Number", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MAPNO" }, { "name": "PROJNO", "type": "esriFieldTypeString", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PROJNO" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Installation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "TAPPING", "type": "esriFieldTypeSmallInteger", "alias": "Tapping", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.TappingCode", "description": "TappingCode", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Yes", "code": 1 }, { "name": "No", "code": 2 }, { "name": "Anchor Valve Special", "code": 3 }, { "name": "All Thread Anchored", "code": 4 }, { "name": "Chain & Boom Anchored", "code": 5 }, { "name": "MJ Anchor Ring", "code": 6 }, { "name": "Tapping Sleeve", "code": 7 }, { "name": "Anchored Outlet or Tee", "code": 8 }, { "name": "Anchor Nipple", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TAPPING" }, { "name": "ACCESS", "type": "esriFieldTypeSmallInteger", "alias": "Access", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.AccessCode", "description": "AccessCode", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "6\" Valve Box", "code": 1 }, { "name": "2\" Valve Box", "code": 2 }, { "name": "Vault", "code": 3 }, { "name": "Manhole", "code": 4 }, { "name": "Meter Box", "code": 5 }, { "name": "Building", "code": 6 }, { "name": "Valve Box in Paving", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCESS" }, { "name": "OPERATORTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Operator Type", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.OperatorTypeCode", "description": "OperatorTypeCode", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Air", "code": 1 }, { "name": "Hydraulic", "code": 2 }, { "name": "Electrical", "code": 3 }, { "name": "Manual", "code": 4 }, { "name": "Remote Air", "code": 5 }, { "name": "Remote Hydraulic", "code": 6 }, { "name": "Remote Electric", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OPERATORTYPE" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "General Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMENT" }, { "name": "SCADAID", "type": "esriFieldTypeString", "alias": "SCADA ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SCADAID" }, { "name": "MANUFACT", "type": "esriFieldTypeSmallInteger", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.ManufacturerCode", "description": "ManufacturerCode", "codedValues": [ { "name": "Unknown", "code": 0 }, { "name": "Allis Chalmers", "code": 1 }, { "name": "Blair", "code": 2 }, { "name": "Clow", "code": 3 }, { "name": "Darling", "code": 4 }, { "name": "Dresser", "code": 5 }, { "name": "Eddy", "code": 6 }, { "name": "Ford", "code": 7 }, { "name": "Hays", "code": 8 }, { "name": "Jones", "code": 9 }, { "name": "Kennedy", "code": 10 }, { "name": "Ludlow", "code": 11 }, { "name": "Mcdonald", "code": 12 }, { "name": "Metropolitan", "code": 13 }, { "name": "Mueller", "code": 14 }, { "name": "Pratt", "code": 15 }, { "name": "Smith", "code": 16 }, { "name": "Stockham", "code": 17 }, { "name": "Us Pipe", "code": 18 }, { "name": "Waterous", "code": 19 }, { "name": "AFC", "code": 20 }, { "name": "Traverse", "code": 21 }, { "name": "M & H", "code": 22 }, { "name": "AVK", "code": 23 }, { "name": "Valv-Matic", "code": 24 }, { "name": "American", "code": 25 }, { "name": "Columbia", "code": 26 }, { "name": "Sentinel", "code": 27 }, { "name": "ARI", "code": 28 }, { "name": "Sigma", "code": 29 }, { "name": "Bailey", "code": 30 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MANUFACT" }, { "name": "MODELNO", "type": "esriFieldTypeString", "alias": "Model Number", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MODELNO" }, { "name": "SERLNO", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SERLNO" }, { "name": "ENDTYPE", "type": "esriFieldTypeSmallInteger", "alias": "End Type", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.EndTypeCode", "description": "EndTypeCode", "codedValues": [ { "name": "N/A", "code": 0 }, { "name": "Flanged", "code": 1 }, { "name": "MJ", "code": 2 }, { "name": "Leaded", "code": 4 }, { "name": "MJ X Flange", "code": 5 }, { "name": "Smith Tap", "code": 6 }, { "name": "IPT", "code": 7 }, { "name": "MJ- Cut In", "code": 9 }, { "name": "Flange X Hub End", "code": 11 }, { "name": "PE X MJ", "code": 13 }, { "name": "PE X Lead", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ENDTYPE" }, { "name": "INSTALLEDBY", "type": "esriFieldTypeString", "alias": "Installed By", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "INSTALLEDBY" }, { "name": "WOCOMM", "type": "esriFieldTypeString", "alias": "Work Order Comment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WOCOMM" }, { "name": "STATUS", "type": "esriFieldTypeSmallInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "RawWaterSystemValves.User1Code", "description": "User1Code", "codedValues": [ { "name": "Active", "code": 1 }, { "name": "Abandoned", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STATUS" }, { "name": "ABNDON", "type": "esriFieldTypeDate", "alias": "Abandoned On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ABNDON" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R102_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_102", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "UUID_OID_102", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID" }, { "name": "S91_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "SHAPE" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Raw Water System Valve", "description": "", "prototype": { "attributes": { "STATUS": null, "FACILITYID": null, "VALVETYPE": null, "CLASSIFICATION": null, "VALVESIZE": null, "PRESSUREZONE": null, "ISOLATIONVALVE": null, "GPSFLAG": null, "ELEVATION": null, "LucityAutoID": null, "INLUCITY": null, "LastModBy": null, "LastModDate": null, "LastSynDate": null, "ABNDON": null, "INSTALL_DATE": null, "OPSTATUS": null, "TURNS": null, "GENLOC": null, "BUILDNO": null, "STRTNAME": null, "MAPNO": null, "PROJNO": null, "INSTALLDATE": null, "TAPPING": null, "ACCESS": null, "OPERATORTYPE": null, "COMMENT": null, "SCADAID": null, "MANUFACT": null, "MODELNO": null, "SERLNO": null, "ENDTYPE": null, "INSTALLEDBY": null, "WOCOMM": 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" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "6f5e4d7a784d45d89bd169988977fdd3" }