{ "layers": [ { "currentVersion": 10.91, "id": 0, "name": "Facility Structure Areas", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102671, "latestWkid": 3435 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 215, 202, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 974181.1817017049, "ymin": 1995310.735214129, "xmax": 998883.4012726471, "ymax": 2000114.7843109742, "spatialReference": { "wkid": 102671, "latestWkid": 3435 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "AREANAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "AREANAME", "type": "esriFieldTypeString", "alias": "Area Name", "length": 100, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STArea()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STArea()", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1074_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9742_FACILIT", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S817_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "f_Pump", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "f_Generators", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "f_HVAC", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "f_Valves", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "f_Meters", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "f_Instrumentation", "relatedTableId": 13, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "f_FlowMeters", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE.STArea()", "shapeLengthFieldName": "SHAPE.STLength()", "units": "esriFeet" }, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" } ], "tables": [ { "currentVersion": 10.91, "id": 9, "name": "f_Pump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYNAMES", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "PUMPTYPE", "type": "esriFieldTypeString", "alias": "Pump Type", "length": 50, "domain": { "type": "codedValue", "name": "PumpType", "description": "Type of Pump for facility", "codedValues": [ { "name": "Brine Feed Pump", "code": "Brine Feed Pump" }, { "name": "Centrifugal Pump", "code": "Centrifugal Pump" }, { "name": "Chemical Feed Pump", "code": "Chemical Feed Pump" }, { "name": "Chemical Transfer Pump", "code": "Chemical Transfer Pump" }, { "name": "High Service Pump", "code": "High Service Pump" }, { "name": "Hot Water Feed Pump", "code": "Hot Water Feed Pump" }, { "name": "Hot Water Recirculation Pump", "code": "Hot Water Recirculation Pump" }, { "name": "Primary Filtrate Pump", "code": "Primary Filtrate Pump" }, { "name": "Recirculation Pump", "code": "Recirculation Pump" }, { "name": "Secondary Feed Pump", "code": "Secondary Feed Pump" }, { "name": "Secondary Filtrate Pump", "code": "Secondary Filtrate Pump" }, { "name": "Submersible Pump", "code": "Submersible Pump" }, { "name": "Sump Pump", "code": "Sump Pump" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": { "type": "codedValue", "name": "ProcessType", "description": "Process Type of Facility Pump", "codedValues": [ { "name": "BD-2000", "code": "BD-2000" }, { "name": "Brine Pump", "code": "Brine Pump" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Citric Acid", "code": "Citric Acid" }, { "name": "Flouride", "code": "Flouride" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Hypochlorite", "code": "Hypochlorite" }, { "name": "Non Potable", "code": "Non Potable" }, { "name": "Phosphate ", "code": "Phosphate " }, { "name": "Phosphate", "code": "Phosphate" }, { "name": "Polyphosphate", "code": "Polyphosphate" }, { "name": "Potable Water", "code": "Potable Water" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Sludge", "code": "Sludge" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Wash Water", "code": "Wash Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 25, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "length": 30, "domain": { "type": "codedValue", "name": "PumpMake", "description": "Maker of Facility Pump", "codedValues": [ { "name": "Aurora ", "code": "Aurora " }, { "name": "Hydromatic", "code": "Hydromatic" }, { "name": "Jesco", "code": "Jesco" }, { "name": "Paterson ", "code": "Paterson " }, { "name": "Wallanen & Terrian", "code": "Wallanen & Terrian" }, { "name": "Weinman", "code": "Weinman" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 30, "domain": null }, { "name": "SERIAL", "type": "esriFieldTypeString", "alias": "SERIAL", "length": 30, "domain": null }, { "name": "DATEINSERVE", "type": "esriFieldTypeDate", "alias": "Date in Service", "length": 8, "domain": null }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "Size", "length": 20, "domain": null }, { "name": "GPM", "type": "esriFieldTypeSmallInteger", "alias": "Gallons Per Min", "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "Revolutions Per Min", "domain": null }, { "name": "TDH", "type": "esriFieldTypeSmallInteger", "alias": "Total Dynamic Head", "domain": null }, { "name": "HP", "type": "esriFieldTypeSmallInteger", "alias": "Horse Power", "domain": null }, { "name": "PHASE", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "HERTZ", "type": "esriFieldTypeSmallInteger", "alias": "Hertz", "domain": null }, { "name": "VOLTS", "type": "esriFieldTypeSmallInteger", "alias": "Volts", "domain": null }, { "name": "MOTORSERIAL", "type": "esriFieldTypeString", "alias": "Motor Serial ", "length": 40, "domain": null }, { "name": "FACILITYNAMES", "type": "esriFieldTypeString", "alias": "Facility Names", "length": 35, "domain": { "type": "codedValue", "name": "FacilityName", "description": "Name of the facility", "codedValues": [ { "name": "ALGONQUIN SHORES LIFT STATION", "code": "ALGONQUIN SHORES LIFT STATION" }, { "name": "BRAEWOOD LIFT STATION", "code": "BRAEWOOD LIFT STATION" }, { "name": "BRITTANY HILLS LIFT STATION", "code": "BRITTANY HILLS LIFT STATION" }, { "name": "CARY BOOSTER", "code": "CARY BOOSTER" }, { "name": "CARY STANDPIPE", "code": "CARY STANDPIPE" }, { "name": "COPPER OAKS TOWER", "code": "COPPER OAKS TOWER" }, { "name": "COUNTRYSIDE BOOSTER", "code": "COUNTRYSIDE BOOSTER" }, { "name": "COUNTRYSIDE STANDPIPE", "code": "COUNTRYSIDE STANDPIPE" }, { "name": "GRAND RESERVE LIFT STATION", "code": "GRAND RESERVE LIFT STATION" }, { "name": "HANSON BOOSTER", "code": "HANSON BOOSTER" }, { "name": "HANSON WATER TOWER", "code": "HANSON WATER TOWER" }, { "name": "HILLSIDE BOOSTER", "code": "HILLSIDE BOOSTER" }, { "name": "HUNTINGTON BOOSTER", "code": "HUNTINGTON BOOSTER" }, { "name": "HUNTINGTON STANDPIPE", "code": "HUNTINGTON STANDPIPE" }, { "name": "JACOBS WATER TOWER", "code": "JACOBS WATER TOWER" }, { "name": "LAKEWOOD WATER TOWER", "code": "LAKEWOOD WATER TOWER" }, { "name": "LOWE DR LIFT STATION", "code": "LOWE DR LIFT STATION" }, { "name": "MEYER BOOSTER", "code": "MEYER BOOSTER" }, { "name": "NORTH HARRISON LIFT STATION", "code": "NORTH HARRISON LIFT STATION" }, { "name": "NORTH RIVER RD LIFT STATION", "code": "NORTH RIVER RD LIFT STATION" }, { "name": "POOL PUMP HOUSE", "code": "POOL PUMP HOUSE" }, { "name": "RIVER FRONT LIFT STATION", "code": "RIVER FRONT LIFT STATION" }, { "name": "SQUARE BARN LIFT STATION", "code": "SQUARE BARN LIFT STATION" }, { "name": "WASTE WATER TREATMENT PLANT", "code": "WASTE WATER TREATMENT PLANT" }, { "name": "WATER TREATMENT PLANT 1", "code": "WATER TREATMENT PLANT 1" }, { "name": "WATER TREATMENT PLANT 2", "code": "WATER TREATMENT PLANT 2" }, { "name": "WATER TREATMENT PLANT 3", "code": "WATER TREATMENT PLANT 3" }, { "name": "WELL 10", "code": "WELL 10" }, { "name": "WELL 11", "code": "WELL 11" }, { "name": "WELL 13", "code": "WELL 13" }, { "name": "WELL 15", "code": "WELL 15" }, { "name": "WELL 5", "code": "WELL 5" }, { "name": "WELL 6", "code": "WELL 6" }, { "name": "WELL 7", "code": "WELL 7" }, { "name": "WELL 8", "code": "WELL 8" }, { "name": "WELL 9", "code": "WELL 9" }, { "name": "WOODS CREEK LIFT STATION", "code": "WOODS CREEK LIFT STATION" }, { "name": "ZANGE BOOSTER", "code": "ZANGE BOOSTER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PUMPNAME", "type": "esriFieldTypeString", "alias": "Pump Name", "length": 50, "domain": null }, { "name": "INSTALLYEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 10, "domain": null }, { "name": "USEFULLIFE", "type": "esriFieldTypeSmallInteger", "alias": "Useful Life", "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1075_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9743_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }, { "currentVersion": 10.91, "id": 10, "name": "f_FlowMeters", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "STRUCTURETYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 25, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 50, "domain": null }, { "name": "USEFULLIFE", "type": "esriFieldTypeSmallInteger", "alias": "Useful Life", "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1080_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9750_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }, { "currentVersion": 10.91, "id": 11, "name": "f_Generators", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility_ID", "length": 10, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": { "type": "codedValue", "name": "FacilityProcessType", "description": "Facility Process Types", "codedValues": [ { "name": "Activated Sludge", "code": "Activated Sludge" }, { "name": "BD-2000", "code": "BD-2000" }, { "name": "Brine Pump", "code": "Brine Pump" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Citric Acid", "code": "Citric Acid" }, { "name": "Cooling", "code": "Cooling" }, { "name": "Effluent", "code": "Effluent" }, { "name": "Flouride", "code": "Flouride" }, { "name": "Heating", "code": "Heating" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Hypochlorite", "code": "Hypochlorite" }, { "name": "Non Potable", "code": "Non Potable" }, { "name": "Phosphate", "code": "Phosphate" }, { "name": "Phosphate ", "code": "Phosphate " }, { "name": "Polyphosphate", "code": "Polyphosphate" }, { "name": "Potable Water", "code": "Potable Water" }, { "name": "Primary Sludge", "code": "Primary Sludge" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Return Activated Sludge", "code": "Return Activated Sludge" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Thickened Waste Activated Sludge", "code": "Thickened Waste Activated Sludge" }, { "name": "Wash Water", "code": "Wash Water" }, { "name": "Waste Activated Sludge", "code": "Waste Activated Sludge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 35, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 25, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 15, "domain": null }, { "name": "USEFULLIFE", "type": "esriFieldTypeSmallInteger", "alias": "Useful Life", "domain": null }, { "name": "MODELNUMBER", "type": "esriFieldTypeString", "alias": "Model Number", "length": 30, "domain": null }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 50, "domain": null }, { "name": "KILOWATTS", "type": "esriFieldTypeString", "alias": "Kilowatts", "length": 15, "domain": null }, { "name": "MOTORSERIALNUMBER", "type": "esriFieldTypeString", "alias": "Motor Serial Number", "length": 50, "domain": null }, { "name": "VOLTS", "type": "esriFieldTypeString", "alias": "Volts", "length": 15, "domain": null }, { "name": "PHASE", "type": "esriFieldTypeString", "alias": "Phase", "length": 10, "domain": null }, { "name": "ATSID", "type": "esriFieldTypeString", "alias": "ATS Identifier", "length": 10, "domain": null }, { "name": "FUELTYPE", "type": "esriFieldTypeString", "alias": "Fuel Type", "length": 30, "domain": null }, { "name": "FUELCAPACITY", "type": "esriFieldTypeString", "alias": "Fuel Capacity (Gallon)", "length": 15, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 15, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1081_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9751_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }, { "currentVersion": 10.91, "id": 12, "name": "f_HVAC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "STRUCTURETYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": { "type": "codedValue", "name": "FacilityProcessType", "description": "Facility Process Types", "codedValues": [ { "name": "Activated Sludge", "code": "Activated Sludge" }, { "name": "BD-2000", "code": "BD-2000" }, { "name": "Brine Pump", "code": "Brine Pump" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Citric Acid", "code": "Citric Acid" }, { "name": "Cooling", "code": "Cooling" }, { "name": "Effluent", "code": "Effluent" }, { "name": "Flouride", "code": "Flouride" }, { "name": "Heating", "code": "Heating" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Hypochlorite", "code": "Hypochlorite" }, { "name": "Non Potable", "code": "Non Potable" }, { "name": "Phosphate", "code": "Phosphate" }, { "name": "Phosphate ", "code": "Phosphate " }, { "name": "Polyphosphate", "code": "Polyphosphate" }, { "name": "Potable Water", "code": "Potable Water" }, { "name": "Primary Sludge", "code": "Primary Sludge" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Return Activated Sludge", "code": "Return Activated Sludge" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Thickened Waste Activated Sludge", "code": "Thickened Waste Activated Sludge" }, { "name": "Wash Water", "code": "Wash Water" }, { "name": "Waste Activated Sludge", "code": "Waste Activated Sludge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 25, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null }, { "name": "SERIAL", "type": "esriFieldTypeString", "alias": "Serial", "length": 50, "domain": null }, { "name": "INSTALLYEAR", "type": "esriFieldTypeString", "alias": "Install Year", "length": 10, "domain": null }, { "name": "FACILITYNAMES", "type": "esriFieldTypeString", "alias": "Facility Names", "length": 50, "domain": null }, { "name": "USEFULLIFE", "type": "esriFieldTypeSmallInteger", "alias": "Useful Life", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1082_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9752_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }, { "currentVersion": 10.91, "id": 13, "name": "f_Instrumentation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "STRUCTURETYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": { "type": "codedValue", "name": "FacilityProcessType", "description": "Facility Process Types", "codedValues": [ { "name": "Activated Sludge", "code": "Activated Sludge" }, { "name": "BD-2000", "code": "BD-2000" }, { "name": "Brine Pump", "code": "Brine Pump" }, { "name": "Chlorine", "code": "Chlorine" }, { "name": "Citric Acid", "code": "Citric Acid" }, { "name": "Cooling", "code": "Cooling" }, { "name": "Effluent", "code": "Effluent" }, { "name": "Flouride", "code": "Flouride" }, { "name": "Heating", "code": "Heating" }, { "name": "HVAC", "code": "HVAC" }, { "name": "Hypochlorite", "code": "Hypochlorite" }, { "name": "Non Potable", "code": "Non Potable" }, { "name": "Phosphate", "code": "Phosphate" }, { "name": "Phosphate ", "code": "Phosphate " }, { "name": "Polyphosphate", "code": "Polyphosphate" }, { "name": "Potable Water", "code": "Potable Water" }, { "name": "Primary Sludge", "code": "Primary Sludge" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Raw Water", "code": "Raw Water" }, { "name": "Return Activated Sludge", "code": "Return Activated Sludge" }, { "name": "Sodium Hypochlorite", "code": "Sodium Hypochlorite" }, { "name": "Thickened Waste Activated Sludge", "code": "Thickened Waste Activated Sludge" }, { "name": "Wash Water", "code": "Wash Water" }, { "name": "Waste Activated Sludge", "code": "Waste Activated Sludge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 25, "domain": null }, { "name": "METERTYPE", "type": "esriFieldTypeString", "alias": "Meter Type", "length": 20, "domain": { "type": "codedValue", "name": "MeterType", "description": "Type of instrument Meter", "codedValues": [ { "name": "Doppler", "code": "Doppler" }, { "name": "Magmeter", "code": "Magmeter" }, { "name": "Ultrasonic", "code": "Ultrasonic" }, { "name": "ABB", "code": "ABB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAKE", "type": "esriFieldTypeString", "alias": "Make", "length": 25, "domain": { "type": "codedValue", "name": "InsturmentMake", "description": "Make type of facility instrumentation", "codedValues": [ { "name": "Endress-Hauser", "code": "Endress-Hauser" }, { "name": "ISCO", "code": "ISCO" }, { "name": "Krohne", "code": "Krohne" }, { "name": "Polysonics", "code": "Polysonics" }, { "name": "Rosemount", "code": "Rosemount" }, { "name": "Siemens", "code": "Siemens" }, { "name": "WaterMaster", "code": "WaterMaster" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 25, "domain": { "type": "codedValue", "name": "InstrumentModel", "description": "Type of Model for instruments", "codedValues": [ { "name": "3010", "code": "3010" }, { "name": "8732C", "code": "8732C" }, { "name": "DDF4008", "code": "DDF4008" }, { "name": "Milltronics", "code": "Milltronics" }, { "name": "PROMAG53", "code": "PROMAG53" }, { "name": "PROMAGW", "code": "PROMAGW" }, { "name": "SC100AS/MP", "code": "SC100AS/MP" }, { "name": "SX40", "code": "SX40" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SERIALNUM", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 25, "domain": null }, { "name": "RANGE", "type": "esriFieldTypeString", "alias": "Range", "length": 25, "domain": null }, { "name": "ANUALCALIBREQ", "type": "esriFieldTypeString", "alias": "Annual Calibration Required", "length": 3, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "Size", "length": 5, "domain": { "type": "codedValue", "name": "piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "0.75", "code": 0.75 }, { "name": "1", "code": 1 }, { "name": "1.25", "code": 1.25 }, { "name": "1.5", "code": 1.5 }, { "name": "2", "code": 2 }, { "name": "2.5", "code": 2.5 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "6", "code": 6 }, { "name": "8", "code": 8 }, { "name": "10", "code": 10 }, { "name": "12", "code": 12 }, { "name": "14", "code": 14 }, { "name": "15", "code": 15 }, { "name": "16", "code": 16 }, { "name": "17", "code": 17 }, { "name": "18", "code": 18 }, { "name": "20", "code": 20 }, { "name": "21", "code": 21 }, { "name": "24", "code": 24 }, { "name": "27", "code": 27 }, { "name": "30", "code": 30 }, { "name": "36", "code": 36 }, { "name": "40", "code": 40 }, { "name": "42", "code": 42 }, { "name": "48", "code": 48 }, { "name": "54", "code": 54 }, { "name": "60", "code": 60 }, { "name": "66", "code": 66 }, { "name": "72", "code": 72 }, { "name": "75", "code": 75 }, { "name": "84", "code": 84 }, { "name": "96", "code": 96 }, { "name": "108", "code": 108 }, { "name": "120", "code": 120 }, { "name": "144", "code": 144 }, { "name": "168", "code": 168 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GPM", "type": "esriFieldTypeSmallInteger", "alias": "Gallons Per Min", "domain": null }, { "name": "FACILITYNAMES", "type": "esriFieldTypeString", "alias": "Facility Names", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1083_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9753_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }, { "currentVersion": 10.91, "id": 14, "name": "f_Meters", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "STRUCTURETYPE", "type": "esriFieldTypeString", "alias": "Structure Type", "length": 50, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 25, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 50, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Stauts", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1084_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9754_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" }, { "currentVersion": 10.91, "id": 15, "name": "f_Valves", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "PROCESSTYPE", "type": "esriFieldTypeString", "alias": "Process Type", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 25, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 50, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 30, "domain": { "type": "codedValue", "name": "FVType", "description": "Valve Type for Facilities Valves", "codedValues": [ { "name": "Ball", "code": "Ball" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Gate", "code": "Gate" }, { "name": "Mud", "code": "Mud" }, { "name": "Pinch", "code": "Pinch" }, { "name": "Plug", "code": "Plug" }, { "name": "Slide", "code": "Slide" }, { "name": "Telescopic", "code": "Telescopic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVEMATERIAL", "type": "esriFieldTypeString", "alias": "VALVEMATERIAL", "length": 35, "domain": { "type": "codedValue", "name": "FVMaterial", "description": "Valve Material for Facilities Valves", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Brass", "code": "Brass" }, { "name": "Ductile", "code": "Ductile" }, { "name": "Plastic, PVC", "code": "Plastic, PVC" }, { "name": "SS, 304", "code": "SS, 304" }, { "name": "SS, 316", "code": "SS, 316" }, { "name": "Steel", "code": "Steel" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVESERVICE", "type": "esriFieldTypeString", "alias": "Valve Service", "length": 35, "domain": { "type": "codedValue", "name": "FVService", "description": "Valve Service for Facilities Valves", "codedValues": [ { "name": "Air", "code": "Air" }, { "name": "Chemical", "code": "Chemical" }, { "name": "Effluent", "code": "Effluent" }, { "name": "Mixed Liquor", "code": "Mixed Liquor" }, { "name": "Non-Pot H2O", "code": "Non-Pot H2O" }, { "name": "Raw Sewage", "code": "Raw Sewage" }, { "name": "Sludge", "code": "Sludge" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "JOINTTYPE", "type": "esriFieldTypeString", "alias": "Joint Type", "length": 50, "domain": { "type": "codedValue", "name": "FVJointType", "description": "Joint Type for Facilities Valves", "codedValues": [ { "name": "Bell & Spigot", "code": "Bell & Spigot" }, { "name": "Flange", "code": "Flange" }, { "name": "Groove & Clamp", "code": "Groove & Clamp" }, { "name": "Mech. Joint", "code": "Mech. Joint" }, { "name": "National Pipe Thread", "code": "National Pipe Thread" }, { "name": "Socket Weld", "code": "Socket Weld" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPERATORTYPE", "type": "esriFieldTypeString", "alias": "Operator Type", "length": 50, "domain": { "type": "codedValue", "name": "FVOperatorType", "description": "Operator Type for Facilities Valves", "codedValues": [ { "name": "Extended Nut", "code": "Extended Nut" }, { "name": "Floor Stand", "code": "Floor Stand" }, { "name": "Gear OP W/Ext. Bonnet & HW", "code": "Gear OP W/Ext. Bonnet & HW" }, { "name": "Gear W/Chain", "code": "Gear W/Chain" }, { "name": "Gear W/Hand Crank", "code": "Gear W/Hand Crank" }, { "name": "Gear w/Handwheel", "code": "Gear w/Handwheel" }, { "name": "Quarter Turn Nut", "code": "Quarter Turn Nut" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPERATORSTYLE", "type": "esriFieldTypeString", "alias": "Operator Style", "length": 35, "domain": { "type": "codedValue", "name": "FVOperatorStyle", "description": "Operator Style of Facilities Valves", "codedValues": [ { "name": "Indicating", "code": "Indicating" }, { "name": "Locking Lever", "code": "Locking Lever" }, { "name": "Nmotor", "code": "Nmotor" }, { "name": "Non-Indicating", "code": "Non-Indicating" }, { "name": "Non-Rising Stem", "code": "Non-Rising Stem" }, { "name": "Rising Stem", "code": "Rising Stem" }, { "name": "Spring", "code": "Spring" }, { "name": "Weighted Arm", "code": "Weighted Arm" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 20, "domain": { "type": "codedValue", "name": "Status_Record", "description": "The status of record", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Engineering", "code": "Engineer" }, { "name": "Abandoned", "code": "Abandon" }, { "name": "Permanently Removed", "code": "Removed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STRUCTUREAREA", "type": "esriFieldTypeString", "alias": "Structure Area", "length": 50, "domain": null } ], "indexes": [ { "name": "R1078_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9748_STRUCTU", "fields": "STRUCTUREAREA", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "fStructureAreas", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "STRUCTUREAREA", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "ca40279f1ed74d03b97507e94a432bfa" } ] }