{ "currentVersion" : 12, "id" : 0, "name" : "PGISREF.DBO.WAT_ControlValve", "type" : "Feature Layer", "serviceItemId" : "853794352fed41adb7fccc94bce5df89", "cacheMaxAge" : 30, "displayField" : "DATACAPTUREMETHOD", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1734637232490, "schemaLastEditDate" : 1734637232490, "dataLastEditDate" : 1734637232490 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 598356.62170278258, "ymin" : 4802572.830581991, "xmax" : 611044.27143219789, "ymax" : 4819349.9808832835, "spatialReference" : { "wkid" : 26917, "latestWkid" : 26917 } }, "spatialReference" : { "wkid" : 26917, "latestWkid" : 26917 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"SUBTYPE","classes":[{"label":"System","description":"System","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,199,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["1"]]},{"label":"Zone","description":"Zone","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[192,182,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["2"]]},{"label":"SystemDP","description":"SystemDP","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[179,252,210,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["3"]]},{"label":"ZoneDP","description":"ZoneDP","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[194,236,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["4"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,199,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"1","label":"System"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[192,182,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"2","label":"Zone"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[179,252,210,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"3","label":"SystemDP"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[194,236,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"4","label":"ZoneDP"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,252,252,255],"toColor":[202,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,250,255],"toColor":[252,182,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,206,184,255],"toColor":[252,206,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[180,252,179,255],"toColor":[180,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,203,252,255],"toColor":[187,203,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,244,179,255],"toColor":[252,244,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,240,255],"toColor":[252,215,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[219,252,202,255],"toColor":[219,252,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,190,255],"toColor":[252,179,190,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,182,252,255],"toColor":[199,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,232,252,255],"toColor":[184,232,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,221,255],"toColor":[187,252,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,240,204,255],"toColor":[252,240,204,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GLOBALID", "typeIdField" : "SUBTYPE", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "Objectid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "RMOHID", "type" : "esriFieldTypeInteger", "alias" : "Rmohid", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATACAPTUREMETHOD", "type" : "esriFieldTypeString", "alias" : "Datacapturemethod", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ADMINISTRATIVEAREA", "type" : "esriFieldTypeString", "alias" : "AdministrativeArea", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMOwner", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : "HALTON" }, { "name" : "LIFECYCLESTATUS", "type" : "esriFieldTypeString", "alias" : "LifecycleStatus", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "defaultValue" : "INSRV" }, { "name" : "LOCATIONDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "Locationdescription", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTNUMBER", "type" : "esriFieldTypeString", "alias" : "Projectnumber", "sqlType" : "sqlTypeOther", "length" : 14, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPERATIONALAREA", "type" : "esriFieldTypeString", "alias" : "Operationalarea", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "defaultValue" : null }, { "name" : "ROTATION", "type" : "esriFieldTypeDouble", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER", "type" : "esriFieldTypeSmallInteger", "alias" : "Diameter", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMwValveDiameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "12", "code" : 12 }, { "name" : "15", "code" : 15 }, { "name" : "19", "code" : 19 }, { "name" : "25", "code" : 25 }, { "name" : "32", "code" : 32 }, { "name" : "37", "code" : 37 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "100", "code" : 100 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "350", "code" : 350 }, { "name" : "400", "code" : 400 }, { "name" : "450", "code" : 450 }, { "name" : "500", "code" : 500 }, { "name" : "600", "code" : 600 }, { "name" : "750", "code" : 750 }, { "name" : "900", "code" : 900 }, { "name" : "1050", "code" : 1050 }, { "name" : "1200", "code" : 1200 }, { "name" : "1350", "code" : 1350 }, { "name" : "1500", "code" : 1500 }, { "name" : "1800", "code" : 1800 }, { "name" : "Unknown", "code" : 9999 } ] }, "defaultValue" : null }, { "name" : "MODELNO", "type" : "esriFieldTypeString", "alias" : "Modelno", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEMAND", "type" : "esriFieldTypeDouble", "alias" : "Demand", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GROUNDELEVATION", "type" : "esriFieldTypeDouble", "alias" : "Groundelevation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUBTYPE", "type" : "esriFieldTypeInteger", "alias" : "Subtype", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 1 }, { "name" : "BYPASSVALVE", "type" : "esriFieldTypeString", "alias" : "ByPassValve", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMYesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "defaultValue" : "NO" }, { "name" : "DEPTHTONUT", "type" : "esriFieldTypeDouble", "alias" : "Depthtonut", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NORMALLYOPEN", "type" : "esriFieldTypeString", "alias" : "NormallyOpen", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMYesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDuplicate", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "defaultValue" : "YES" }, { "name" : "OPENS", "type" : "esriFieldTypeString", "alias" : "Opens", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMwValveTurns", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Clockwise", "code" : "CW" }, { "name" : "Counterclockwise", "code" : "CCW" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : "CCW" }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMwStatus", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Closed", "code" : "CLOS" }, { "name" : "Open", "code" : "OPEN" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : "OPEN" }, { "name" : "TURNSNUMBER", "type" : "esriFieldTypeSmallInteger", "alias" : "Turnsnumber", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VALVETYPE", "type" : "esriFieldTypeString", "alias" : "Valvetype", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMwValveType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Ball", "code" : "BAV" }, { "name" : "Butterfly", "code" : "BTV" }, { "name" : "Gate", "code" : "GTV" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "defaultValue" : null }, { "name" : "CHAMBERID", "type" : "esriFieldTypeInteger", "alias" : "Chamberid", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VALVEBOXTYPE", "type" : "esriFieldTypeString", "alias" : "ValveBoxType", "sqlType" : "sqlTypeOther", "length" : 4, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DmnFMwValveBoxType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Valve Box", "code" : "VBOX" }, { "name" : "Buffalo Box", "code" : "BBOX" }, { "name" : "Not Applicable", "code" : "NA" } ] }, "defaultValue" : "VBOX" }, { "name" : "MAINTENANCERESPONSIBILITY", "type" : "esriFieldTypeString", "alias" : "Maintenanceresponsibility", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GPS_XCOORD", "type" : "esriFieldTypeDouble", "alias" : "Gps Xcoord", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GPS_YCOORD", "type" : "esriFieldTypeDouble", "alias" : "Gps Ycoord", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GPS_ZCOORD", "type" : "esriFieldTypeDouble", "alias" : "Gps Zcoord", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONSTRUCTIONSTARTDATE", "type" : "esriFieldTypeDate", "alias" : "Constructionstartdate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DEVELOPMENTNUMBER", "type" : "esriFieldTypeString", "alias" : "Developmentnumber", "sqlType" : "sqlTypeOther", "length" : 14, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONTRACTNUMBER", "type" : "esriFieldTypeString", "alias" : "Contractnumber", "sqlType" : "sqlTypeOther", "length" : 14, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAPTILES2000NUM", "type" : "esriFieldTypeString", "alias" : "Maptiles2000num", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SLKEY", "type" : "esriFieldTypeInteger", "alias" : "Slkey", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UNITTYPE", "type" : "esriFieldTypeString", "alias" : "Unittype", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "URL", "type" : "esriFieldTypeString", "alias" : "Url", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GLOBALID", "type" : "esriFieldTypeGlobalID", "alias" : "GLOBALID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__PGISREF___F4B70D85028B04DE", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_19393.PGISREF_DBO_WAT_CONTROLVALVE_PGISREF_DBO_WAT_CONTROLVALVE_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GLOBALID", "fields" : "GLOBALID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : 1, "name" : "System", "domains" : { "ADMINISTRATIVEAREA" : {"type" : "inherited"}, "LIFECYCLESTATUS" : {"type" : "inherited"}, "OPERATIONALAREA" : {"type" : "inherited"}, "DIAMETER" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPENS" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "VALVEBOXTYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "System", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "URL" : null, "UNITTYPE" : null, "RMOHID" : 0, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 1, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null } } } ] }, { "id" : 2, "name" : "Zone", "domains" : { "ADMINISTRATIVEAREA" : {"type" : "inherited"}, "LIFECYCLESTATUS" : {"type" : "inherited"}, "OPERATIONALAREA" : {"type" : "inherited"}, "DIAMETER" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPENS" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "VALVEBOXTYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "Zone", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "URL" : null, "UNITTYPE" : null, "RMOHID" : 0, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 2, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null } } } ] }, { "id" : 3, "name" : "SystemDP", "domains" : { "ADMINISTRATIVEAREA" : {"type" : "inherited"}, "LIFECYCLESTATUS" : {"type" : "inherited"}, "OPERATIONALAREA" : {"type" : "inherited"}, "DIAMETER" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPENS" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "VALVEBOXTYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "SystemDP", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "URL" : null, "UNITTYPE" : null, "RMOHID" : 0, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 3, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null } } } ] }, { "id" : 4, "name" : "ZoneDP", "domains" : { "ADMINISTRATIVEAREA" : {"type" : "inherited"}, "LIFECYCLESTATUS" : {"type" : "inherited"}, "OPERATIONALAREA" : {"type" : "inherited"}, "DIAMETER" : {"type" : "inherited"}, "BYPASSVALVE" : {"type" : "inherited"}, "NORMALLYOPEN" : {"type" : "inherited"}, "OPENS" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"}, "VALVETYPE" : {"type" : "inherited"}, "VALVEBOXTYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "ZoneDP", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "URL" : null, "UNITTYPE" : null, "RMOHID" : 0, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 4, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query", "subtypeField" : "SUBTYPE", "defaultSubtypeCode" : 1, "subtypes" : [ { "code" : 3, "name" : "SystemDP", "defaultValues" : { "RMOHID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 3, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null, "UNITTYPE" : null, "URL" : null }, "domains" : { "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMwValveDiameter", "codedValues" : [ { "name" : "12", "code" : 12 }, { "name" : "15", "code" : 15 }, { "name" : "19", "code" : 19 }, { "name" : "25", "code" : 25 }, { "name" : "32", "code" : 32 }, { "name" : "37", "code" : 37 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "100", "code" : 100 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "350", "code" : 350 }, { "name" : "400", "code" : 400 }, { "name" : "450", "code" : 450 }, { "name" : "500", "code" : 500 }, { "name" : "600", "code" : 600 }, { "name" : "750", "code" : 750 }, { "name" : "900", "code" : 900 }, { "name" : "1050", "code" : 1050 }, { "name" : "1200", "code" : 1200 }, { "name" : "1350", "code" : 1350 }, { "name" : "1500", "code" : 1500 }, { "name" : "1800", "code" : 1800 }, { "name" : "Unknown", "code" : 9999 } ] }, "BYPASSVALVE" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "NORMALLYOPEN" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "OPENS" : { "type" : "codedValue", "name" : "DmnFMwValveTurns", "codedValues" : [ { "name" : "Clockwise", "code" : "CW" }, { "name" : "Counterclockwise", "code" : "CCW" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "STATUS" : { "type" : "codedValue", "name" : "DmnFMwStatus", "codedValues" : [ { "name" : "Closed", "code" : "CLOS" }, { "name" : "Open", "code" : "OPEN" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVETYPE" : { "type" : "codedValue", "name" : "DmnFMwValveType", "codedValues" : [ { "name" : "Ball", "code" : "BAV" }, { "name" : "Butterfly", "code" : "BTV" }, { "name" : "Gate", "code" : "GTV" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVEBOXTYPE" : { "type" : "codedValue", "name" : "DmnFMwValveBoxType", "codedValues" : [ { "name" : "Valve Box", "code" : "VBOX" }, { "name" : "Buffalo Box", "code" : "BBOX" }, { "name" : "Not Applicable", "code" : "NA" } ] } } }, { "code" : 2, "name" : "Zone", "defaultValues" : { "RMOHID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 2, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null, "UNITTYPE" : null, "URL" : null }, "domains" : { "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMwValveDiameter", "codedValues" : [ { "name" : "12", "code" : 12 }, { "name" : "15", "code" : 15 }, { "name" : "19", "code" : 19 }, { "name" : "25", "code" : 25 }, { "name" : "32", "code" : 32 }, { "name" : "37", "code" : 37 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "100", "code" : 100 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "350", "code" : 350 }, { "name" : "400", "code" : 400 }, { "name" : "450", "code" : 450 }, { "name" : "500", "code" : 500 }, { "name" : "600", "code" : 600 }, { "name" : "750", "code" : 750 }, { "name" : "900", "code" : 900 }, { "name" : "1050", "code" : 1050 }, { "name" : "1200", "code" : 1200 }, { "name" : "1350", "code" : 1350 }, { "name" : "1500", "code" : 1500 }, { "name" : "1800", "code" : 1800 }, { "name" : "Unknown", "code" : 9999 } ] }, "BYPASSVALVE" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "NORMALLYOPEN" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "OPENS" : { "type" : "codedValue", "name" : "DmnFMwValveTurns", "codedValues" : [ { "name" : "Clockwise", "code" : "CW" }, { "name" : "Counterclockwise", "code" : "CCW" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "STATUS" : { "type" : "codedValue", "name" : "DmnFMwStatus", "codedValues" : [ { "name" : "Closed", "code" : "CLOS" }, { "name" : "Open", "code" : "OPEN" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVETYPE" : { "type" : "codedValue", "name" : "DmnFMwValveType", "codedValues" : [ { "name" : "Ball", "code" : "BAV" }, { "name" : "Butterfly", "code" : "BTV" }, { "name" : "Gate", "code" : "GTV" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVEBOXTYPE" : { "type" : "codedValue", "name" : "DmnFMwValveBoxType", "codedValues" : [ { "name" : "Valve Box", "code" : "VBOX" }, { "name" : "Buffalo Box", "code" : "BBOX" }, { "name" : "Not Applicable", "code" : "NA" } ] } } }, { "code" : 4, "name" : "ZoneDP", "defaultValues" : { "RMOHID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 4, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null, "UNITTYPE" : null, "URL" : null }, "domains" : { "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMwValveDiameter", "codedValues" : [ { "name" : "12", "code" : 12 }, { "name" : "15", "code" : 15 }, { "name" : "19", "code" : 19 }, { "name" : "25", "code" : 25 }, { "name" : "32", "code" : 32 }, { "name" : "37", "code" : 37 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "100", "code" : 100 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "350", "code" : 350 }, { "name" : "400", "code" : 400 }, { "name" : "450", "code" : 450 }, { "name" : "500", "code" : 500 }, { "name" : "600", "code" : 600 }, { "name" : "750", "code" : 750 }, { "name" : "900", "code" : 900 }, { "name" : "1050", "code" : 1050 }, { "name" : "1200", "code" : 1200 }, { "name" : "1350", "code" : 1350 }, { "name" : "1500", "code" : 1500 }, { "name" : "1800", "code" : 1800 }, { "name" : "Unknown", "code" : 9999 } ] }, "BYPASSVALVE" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "NORMALLYOPEN" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "OPENS" : { "type" : "codedValue", "name" : "DmnFMwValveTurns", "codedValues" : [ { "name" : "Clockwise", "code" : "CW" }, { "name" : "Counterclockwise", "code" : "CCW" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "STATUS" : { "type" : "codedValue", "name" : "DmnFMwStatus", "codedValues" : [ { "name" : "Closed", "code" : "CLOS" }, { "name" : "Open", "code" : "OPEN" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVETYPE" : { "type" : "codedValue", "name" : "DmnFMwValveType", "codedValues" : [ { "name" : "Ball", "code" : "BAV" }, { "name" : "Butterfly", "code" : "BTV" }, { "name" : "Gate", "code" : "GTV" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVEBOXTYPE" : { "type" : "codedValue", "name" : "DmnFMwValveBoxType", "codedValues" : [ { "name" : "Valve Box", "code" : "VBOX" }, { "name" : "Buffalo Box", "code" : "BBOX" }, { "name" : "Not Applicable", "code" : "NA" } ] } } }, { "code" : 1, "name" : "System", "defaultValues" : { "RMOHID" : null, "DATACAPTUREMETHOD" : null, "ADMINISTRATIVEAREA" : "HALTON", "LIFECYCLESTATUS" : "INSRV", "LOCATIONDESCRIPTION" : null, "PROJECTNUMBER" : null, "OPERATIONALAREA" : null, "ROTATION" : null, "COMMENTS" : null, "DIAMETER" : null, "MODELNO" : null, "DEMAND" : null, "GROUNDELEVATION" : null, "SUBTYPE" : 1, "BYPASSVALVE" : "NO", "DEPTHTONUT" : null, "NORMALLYOPEN" : "YES", "OPENS" : "CCW", "STATUS" : "OPEN", "TURNSNUMBER" : null, "VALVETYPE" : null, "CHAMBERID" : null, "VALVEBOXTYPE" : "VBOX", "MAINTENANCERESPONSIBILITY" : null, "GPS_XCOORD" : null, "GPS_YCOORD" : null, "GPS_ZCOORD" : null, "CONSTRUCTIONSTARTDATE" : null, "DEVELOPMENTNUMBER" : null, "CONTRACTNUMBER" : null, "MAPTILES2000NUM" : null, "SLKEY" : null, "UNITTYPE" : null, "URL" : null }, "domains" : { "ADMINISTRATIVEAREA" : { "type" : "codedValue", "name" : "DmnFMOwner", "codedValues" : [ { "name" : "Regional Municipality of Halton", "code" : "HALTON" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "City of Hamilton", "code" : "HAMILTON" }, { "name" : "Region of Peel", "code" : "PEEL" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Private", "code" : "PRIV" }, { "name" : "Unassumed", "code" : "UNAS" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "LIFECYCLESTATUS" : { "type" : "codedValue", "name" : "DmnFMLifeCycleStatus", "codedValues" : [ { "name" : "In Service", "code" : "INSRV" }, { "name" : "Out Of Service", "code" : "OUTSRV" }, { "name" : "Proposed", "code" : "PROP" }, { "name" : "Temporary", "code" : "TEMP" } ] }, "OPERATIONALAREA" : { "type" : "codedValue", "name" : "DmnFMOperationalArea", "codedValues" : [ { "name" : "Town of Oakville", "code" : "OAKVILLE" }, { "name" : "Town of Milton", "code" : "MILTON" }, { "name" : "Town of Halton Hills", "code" : "HALTON HILLS" }, { "name" : "City of Burlington", "code" : "BURLINGTON" }, { "name" : "Acton", "code" : "ACTON" }, { "name" : "Georgetown", "code" : "GEORGETOWN" }, { "name" : "Campbellville", "code" : "CAMPBELLVILLE" } ] }, "DIAMETER" : { "type" : "codedValue", "name" : "DmnFMwValveDiameter", "codedValues" : [ { "name" : "12", "code" : 12 }, { "name" : "15", "code" : 15 }, { "name" : "19", "code" : 19 }, { "name" : "25", "code" : 25 }, { "name" : "32", "code" : 32 }, { "name" : "37", "code" : 37 }, { "name" : "50", "code" : 50 }, { "name" : "75", "code" : 75 }, { "name" : "100", "code" : 100 }, { "name" : "150", "code" : 150 }, { "name" : "200", "code" : 200 }, { "name" : "250", "code" : 250 }, { "name" : "300", "code" : 300 }, { "name" : "350", "code" : 350 }, { "name" : "400", "code" : 400 }, { "name" : "450", "code" : 450 }, { "name" : "500", "code" : 500 }, { "name" : "600", "code" : 600 }, { "name" : "750", "code" : 750 }, { "name" : "900", "code" : 900 }, { "name" : "1050", "code" : 1050 }, { "name" : "1200", "code" : 1200 }, { "name" : "1350", "code" : 1350 }, { "name" : "1500", "code" : 1500 }, { "name" : "1800", "code" : 1800 }, { "name" : "Unknown", "code" : 9999 } ] }, "BYPASSVALVE" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "NORMALLYOPEN" : { "type" : "codedValue", "name" : "DmnFMYesNo", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "OPENS" : { "type" : "codedValue", "name" : "DmnFMwValveTurns", "codedValues" : [ { "name" : "Clockwise", "code" : "CW" }, { "name" : "Counterclockwise", "code" : "CCW" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "STATUS" : { "type" : "codedValue", "name" : "DmnFMwStatus", "codedValues" : [ { "name" : "Closed", "code" : "CLOS" }, { "name" : "Open", "code" : "OPEN" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVETYPE" : { "type" : "codedValue", "name" : "DmnFMwValveType", "codedValues" : [ { "name" : "Ball", "code" : "BAV" }, { "name" : "Butterfly", "code" : "BTV" }, { "name" : "Gate", "code" : "GTV" }, { "name" : "Unknown", "code" : "UNKN" } ] }, "VALVEBOXTYPE" : { "type" : "codedValue", "name" : "DmnFMwValveBoxType", "codedValues" : [ { "name" : "Valve Box", "code" : "VBOX" }, { "name" : "Buffalo Box", "code" : "BBOX" }, { "name" : "Not Applicable", "code" : "NA" } ] } } } ] }