{ "layers": [ { "currentVersion": 10.81, "id": 133, "name": "PumpStation", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "1fa732b65d922448565062caaeb702b5", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAASCAYAAABFGc6jAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAR5JREFUOI3N0s0r5XEUB+DH9WNIXha3bvLWeInCSNF0S5JGWbC3s7FhYWep5g+Y/8B+0uwUK8qkSZHU0C3KAkVq3Fw2LEYsbG5y66e+4bM6p07nqdOJvFGivHoZhqbUhVh8e+Nu65f0S1CE0ekFDyGgxXnZ/D4qNBg6Hws62iZ3QaqFhk6O/3J5Ss8IJWUBoet/tH1lb51kPVdntKc53KRrOCBU+onqFE2d3GRJRFQm+dwbD4kN5S7J/OZkj9EZzg9Y/M74bGCorJxkI6393P/nyzc6Bshs0DcWEqog1fxU5865ztLUTXEiHhIbyv+smlp2V9lZYXAiMNQxkNcUMTwZH3gVFCLvAvVhbelHmMX7f1QVgpLwcy4M9DxvdrpHRtM64FtYotYAAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 908076.7671821639, "ymin": 559078.8654797375, "xmax": 942013.2252277471, "ymax": 578933.4081196561, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PumpStation", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "PS_ID", "type": "esriFieldTypeString", "alias": "PS_ID", "length": 50, "domain": null }, { "name": "Legacy_ID", "type": "esriFieldTypeString", "alias": "Legacy_ID", "length": 50, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "PumpStationType", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R76_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G86PS_ID", "fields": "PS_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I86PumpStation", "fields": "PumpStation", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "System", "relatedTableId": 165, "role": "esriRelRoleOrigin", "keyField": "PS_ID", "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 125, "name": "SewerMeter", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "d45f40c84e00016932a2e4c45a8bcf77", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAdxJREFUOI211D9oE2EYx/Hve3mTu15bsen1lEppCVS0/qFiHBTBQYOIFQoiou7Gxa24iKVOgg6Co4uouDrolooIKjhEREQHUagI/WcMYkxzV+L7OtSElCbeJY2/6eV57/m8z/DeK/lPkZXF7Vnm2wFqWEz3s1vWFDaBeUPjf2gVFXBQwBjUTPw3GYN4DpFPtjDqc7WC14VRIj+WnDavGiruhTVziTlrZpg0mnKltgYG6MsOic2Xpu0waHlxDvHunD8z/GlVvS6sbaljWwYEwO/CTyJd3SBEdV8tL4NSGJbV8MC6cG2+XTzGxsk7WImt1Vrh4QOMXpfu1PHWYWH1UHryCOv8xMq0pSW8zD3sMxP/7AuE5dAO1K8C5e85ZK9D6W0W8/DZoLZgGMBOjbP08ikbTpzCe5HBPnqS8vzs+mFrZBeF+zeJbduJTGyHaLQ9E4uIpCN1mh/XLtAzdRdVKrYHBug8cIhIn0tsYBDvY/BfHwh3HBkHwOjswh7dB0DUcTHMxnc4FGwn969tclyk4zYPRz+/N75cDvcOiaKH2vs1FggbmM8e3/KvwOtQcLVPx7OQH20A+3u0Nt8IzFdNqYCm6AjMEfDrTny9srGOLKyC0/2Ixt82n9D3uNn8AZGFetN1mwkuAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 16, "height": 16, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": [ { "labelPlacement": "esriServerPointLabelPlacementAboveRight", "where": null, "labelExpression": "[Meter_No]", "useCodedValues": true, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "baseline", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 8, "style": "normal", "weight": "normal", "decoration": "none" } }, "minScale": 0, "maxScale": 0 } ] }, "defaultVisibility": true, "extent": { "xmin": 912807.9401344955, "ymin": 568853.8833312392, "xmax": 933823.2849147469, "ymax": 577722.2048334032, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "Meter_No", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "Meter_No", "type": "esriFieldTypeString", "alias": "Meter_No", "length": 5, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 30, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R146_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S113_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "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, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 126, "name": "Cleanouts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "c9c1c5be4d44a048d4816498a1d71484", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAkJJREFUOI1jYSAOMDIwMPzHp4AFn6S3tzdPkNr3FX8ZGLj3XWONWbFz51OSDeov9LSX5fw000fnqjor81cGaT7j/foKnnWVM7evINYgxmk5rt1m0q8SjWXPCsEEvbSOqSoLa0/nznF3y5uyM52BgeE3ToPyE3zF9YW+rvfVuWIuwv2cCd0GdfGrApIC7xK4i5z0b3/kDO+Yu/UOhkGTs5wi5YU/dHponZJlZfqJy8cMfOzPGRPM3xntvmF8SCLbqbVg6r6pcIPml7hPN5V9EqMtcZUHpwlIgInhJ4O7xjFJRUH1Hp58V/uUibvDWBgYGBi4WX+qa4jfwTDkzVdJhvUXdRgYGBgYggyuMAhzPUeRVxW/yXH+uaQy3EWcbExzHr5TcFQSvomicM4JA4YTL9kYGBgYGN79MGAod0I16PlHeQYWZqZ1cIN8G/ct291kNVlJmEEIWeHbn4jwfvMDI+wZbr2W/vbuE+dEuEEMDAwMH3+wXfnHwGCHrDze8ClD60FZBiYmBoYkowcYBr35ynYrbdLWLygGsbP8XfL0g4qdrAA8Rhl0JC8wLA67zsDAwMDAghaTH75LMvz+zbQHxocb5Nt0eO6BNqsuWYE7Asga0A2Ae+ul1Pd3v7h7MAxiYGD49+4r27X/DAxWjFi1ooLnX3hv50zc/BKbQQzMzAwrX3yWt5LkfYjXkO9/hBg+/WQ9juJyZM6JpgPTv1U6tcsLSHDgM+jZR7Y/z7+w9OE0qJ2B4TdD+z5uvM7BAfCWR6QAAIJFtML6YQ2fAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 910256.9540947452, "ymin": 559427.1206887364, "xmax": 939611.4757661633, "ymax": 579581.2936349064, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "ACCESSMAT", "type": "esriFieldTypeString", "alias": "Access Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACCESSTYPE", "type": "esriFieldTypeString", "alias": "Access Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piAccessType", "description": "List of infrastructure access types", "codedValues": [ { "name": "Door", "code": "Door" }, { "name": "Grate", "code": "Grate" }, { "name": "Cover", "code": "Cover" }, { "name": "Hand", "code": "Hand" }, { "name": "Lid", "code": "Lid" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "INTDEPTH", "type": "esriFieldTypeDouble", "alias": "Interior Depth", "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "DEVICETYPE", "type": "esriFieldTypeString", "alias": "Cleanout Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_piCleanoutTypes", "description": "List of infrastructure cleanout types", "codedValues": [ { "name": "Cleanout", "code": "Cleanout" }, { "name": "Flushing Structure", "code": "Flushing Structure" }, { "name": "Lamp Hole", "code": "Lamp Hole" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACCESSDIAM", "type": "esriFieldTypeDouble", "alias": "Access Diameter", "domain": { "type": "range", "name": "WS2_piAccessDiameter", "description": "Valid range of infrastructure access diameters", "range": [ 0, 72 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TOP_ELEV", "type": "esriFieldTypeDouble", "alias": "TOP_ELEV", "domain": null }, { "name": "Invert", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "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": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R136_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S103_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 127, "name": "Manhole", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "OWNEDBY", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "d84580ddfa548901e8c04fcdc8cca81a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAmtJREFUKJFtk09I03EYxj9tv23MP23NWaQZiCu9WDoPqSATLNJLlzq0gswYoQYpeNCBMcESUxFUUtlBvHQr6KJWRiSTaObGL2SY+Weti3+yr4Gu+dNiHSam5gPv4X14nsPD874ShyAaRT08zMWNDdPppaXwXE2N8h5QDuqkvcv8PKaJCZ7Z7dgMBlSyLCgshKIi/uTm8qa7m9vA0n/miQnODA4ip6QQ19cHRiNUVkJzM2g0qMfGuDw7y7TXayoRQvh3zaOjqEZG8K6uEldSEjPuhVYL2dmQkYFxY0O89Hg4DyxKAMvLusd6vXKspwd6e0GjAYvlKisr8wSDpSQnu3n0SOBygd+Pxm6nWQgcEkAgoNxwOECthqoqqKu7QGnpLbq6cgmFQjQ0fGBgYAazeZHiYoyJiVwTgnsSwOQkx+vrIRyGSATy829SVnYFgLS0NJzOhwjxjvj4RgCsVtbW101ZEkAwiKoxxhOJQEXF2X2ZU1NTcTpfYTbHdr+fk+Fw+KgEkJnJr7Y2EvR62NoCt/s1BQWXUKlUAPh8H+nvP4fB4AFgfJyvoZCyLAGYTHhmZijLyYG1NZieHqSnR0VWlo2Fhc8sLIyQnv4WqxWE4JMskwR8kQCGhkwPtrdFYXs7htZWaGoSJCV14HB00NkJ8fHQ2QlqNb9bWvgOPN3tWQjhm5rSPbFYFOfcHEeSk//1q9HEpraWsM3GpteLFujad2GBgNKo0+m2y8uVuy4XP/LyOBWNYtjc5FsggFxdzQmfj5/AdWDr4G1HFUVpkmXTC5tN3AcSAK3bjW5H1wE839vCvsfYiSADdw7yh+EveSjm7bhGPHcAAAAASUVORK5CYII=", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "1", "label": "North Miami", "description": "" }, { "symbol": { "type": "esriPMS", "url": "e17c5e4df41316f7d4328fee02d4ec87", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAArdJREFUKJFtk3tIUwEYxX/ee7c5X1uzh8ssSiMLeymUST5gghkEFUHaH/aS6AEZPTBLMzSjhwlmZUhEBkVERSJaUJCmRbOUlS6bmTah1rLuGjXdnYb9UUSa57/v4xz4Dud8EuNgpMoq1te2pP4QPNM/uZ3dOQ3FTwFlLE/6d3iX0Wxocbfeyjx1MFknBguW/pckGJeQaIj7udgY8/CstXoT8Ok/cUvGndlX3tywTDWEBVSmHUOv1bG99hDFpgOoREls7DOnvZXtnWbllUmW5ba/4gc8EO711pu/DLkCTKHL0Wt1o85Ti2rmT44m0jBD/8Px/X4T8kLAIQE40ztOat3+EyrSirjQdhWVn0TU3Cg+6930zuhnUk8gJY/PUZiUQ9vHDlVmTVaxDNkSgNXRtSE7LhNRENkRm8W+9uOsiFtL+dZK7HY7B+sKuJxSwkStgZRZ8fpgjXGdrDh2SQAvnB2Tc/31eHwDDA57iV+TRPqqlQBERESQV3QYud1LYOcAALGGGNd3RYmWAHrlPiG/4QwAg8ODbF69a5Tn8PBw8o7sZ6IzCIA2ucPowRMiAcwxRA6cMuUFadX++H76qHpUwzLTcgRBAKD1+QsuripB98EfgOaKZ+/tisMpARgCdU02V0/6oinzcHnddD56RYVfKdEJC+ixddPT8JqZIVpijTHIHtdLi2ILBbokgDq5sWDosS/hdFq+7sSTCxxN3kOodwLZ+3IpSy0gMCqdMvMlRITh480V/cC1vznLstza7rGdj6pKyeve1ug3KSD0d76oUIkSKlFiz9ItnuTqNV6zbFUD5aMaZlW68zUazdDG2pxthYl7v8aFzZ82AjrvkLfP+qXLsvN27pRWxfYNyAB8Y7s9oijKUYvy9m7yzfW7gSBAXWW7rvnDKwVu/5vCqMf4Y8ECbBm7Hw+/AHxsDOMnBEaMAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "5", "label": "Private", "description": "" }, { "symbol": { "type": "esriPMS", "url": "e17c5e4df41316f7d4328fee02d4ec87", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAArdJREFUKJFtk3tIUwEYxX/ee7c5X1uzh8ssSiMLeymUST5gghkEFUHaH/aS6AEZPTBLMzSjhwlmZUhEBkVERSJaUJCmRbOUlS6bmTah1rLuGjXdnYb9UUSa57/v4xz4Dud8EuNgpMoq1te2pP4QPNM/uZ3dOQ3FTwFlLE/6d3iX0Wxocbfeyjx1MFknBguW/pckGJeQaIj7udgY8/CstXoT8Ok/cUvGndlX3tywTDWEBVSmHUOv1bG99hDFpgOoREls7DOnvZXtnWbllUmW5ba/4gc8EO711pu/DLkCTKHL0Wt1o85Ti2rmT44m0jBD/8Px/X4T8kLAIQE40ztOat3+EyrSirjQdhWVn0TU3Cg+6930zuhnUk8gJY/PUZiUQ9vHDlVmTVaxDNkSgNXRtSE7LhNRENkRm8W+9uOsiFtL+dZK7HY7B+sKuJxSwkStgZRZ8fpgjXGdrDh2SQAvnB2Tc/31eHwDDA57iV+TRPqqlQBERESQV3QYud1LYOcAALGGGNd3RYmWAHrlPiG/4QwAg8ODbF69a5Tn8PBw8o7sZ6IzCIA2ucPowRMiAcwxRA6cMuUFadX++H76qHpUwzLTcgRBAKD1+QsuripB98EfgOaKZ+/tisMpARgCdU02V0/6oinzcHnddD56RYVfKdEJC+ixddPT8JqZIVpijTHIHtdLi2ILBbokgDq5sWDosS/hdFq+7sSTCxxN3kOodwLZ+3IpSy0gMCqdMvMlRITh480V/cC1vznLstza7rGdj6pKyeve1ug3KSD0d76oUIkSKlFiz9ItnuTqNV6zbFUD5aMaZlW68zUazdDG2pxthYl7v8aFzZ82AjrvkLfP+qXLsvN27pRWxfYNyAB8Y7s9oijKUYvy9m7yzfW7gSBAXWW7rvnDKwVu/5vCqMf4Y8ECbBm7Hw+/AHxsDOMnBEaMAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "3", "label": "Others", "description": "" }, { "symbol": { "type": "esriPMS", "url": "6d947cb9ca9edc015efb5874ea94ea6b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAArZJREFUKJFtk3tIUwEYxX/ee/dSa3NmtcyiMrKwl4MeUiksMAOhIkj7w8pEekBKFmZpRWb0hrIXElFBEZFRiBYUpGnRTGU+ls1Mm1BzWXeNmu5Ow/4oKq3z3/dxDpzD+T6J/6B0yC6WV9YtF775Jnl73B1V2UXPAWUkT/p7SH1ba/TWNdw5nrYnQdSPEnptTZjiF2Bcav5umh/72H722kag5x9xat3d6a+v3rIZJ4wPTrp4GJ1BT/mWvViKdiOqJLG72pokv3G2KdZmiyzLjX/Ejx4JXQ8qrQOfPMHhliXoDPph9kS1mrGzYzBOm2xwffv6kBp5LuCSAJLdrce8Om1YUskhGi9cJ0glMTM6GsNHL5O7eumMCOFp8TmWHcjmQ2Or6n5aehEymRKAy96+3pyZhiCKxG1NpyX3COYVa9h85iJOp5OKPYUkXilGN8bI1MRFBs0o01pFdm2XANz1rWO1eQYCvj4G+/2sXrSMlOSVAERFRXEofx8tsp+2kD4AjHGxHuWrEiMByF3dQlXBKQAG+/tZtWn7sMyRkZHsz9+Fe0woAHJjqwmfb7QEYJwxrc9yPD9UrdPyPRDgSel9LIuXIAgCAC8b6km5VMx7vRaAktoX7xSnyy0BhBj1NR5HZ/K4ebPwe7w8aWsmqOQk8TFzcHR2UNX5itFTdJjiYvHJnibF5ggH2n/arqgufDoQiE86UaB/dvQCCQdz8IeHkZuZx/LThUSHJGM9fRlEYbD2SEkvcON3z7IsN/haHOdLoxPzszqqg4Ijwn+GVasQVRKiSmJhTobvWsJqv2y1q4Ezwy5MsXcUaDSagfIN2VlLD+z8PN48eyJD6Af8/u5P9nZb2ba8cUqD4wuQCgRG3vaQoigHFdube7cT1u0AQgG1o/Sm5hfvJFD2dwvDHuNXBBuQMXL/P/wAeb4M4/CJ+BEAAAAASUVORK5CYII=", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "6", "label": "WASD", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 906716.1918193288, "ymin": 558996.3476001546, "xmax": 942285.199093245, "ymax": 580479.984094739, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "HIGHELEV", "type": "esriFieldTypeDouble", "alias": "High Pipe Elevation", "domain": null }, { "name": "INVERT", "type": "esriFieldTypeDouble", "alias": "Invert", "domain": null }, { "name": "INVERTELEV", "type": "esriFieldTypeDouble", "alias": "Invert Elevation", "domain": null }, { "name": "CVTYPE", "type": "esriFieldTypeString", "alias": "Cover Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piManholeCoverType", "description": "List of infrastructure Manhole Cover Types", "codedValues": [ { "name": "Standard W/ Lock", "code": "Standard W/ Lock" }, { "name": "Standard W/ Ears", "code": "Standard W/ Ears" }, { "name": "Non-District", "code": "Non-District" }, { "name": "Water Tight", "code": "Water Tight" }, { "name": "27\" Diameter", "code": "27\" Diameter" }, { "name": "42\" Diameter", "code": "42\" Diameter" }, { "name": "Large - Water Tight", "code": "Large - Water Tight" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WALLMAT", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 25, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MHTYPE", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 15, "domain": { "type": "codedValue", "name": "WS2_piManholeType", "description": "List of infrastructure Manhole Types", "codedValues": [ { "name": "Standard", "code": "STD" }, { "name": "Drop", "code": "DRP" }, { "name": "Split", "code": "SPL" }, { "name": "Diversion", "code": "DIV" }, { "name": "Sedimentation", "code": "SED" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CUTDEPTH", "type": "esriFieldTypeDouble", "alias": "Pavement Cut Depth", "domain": null }, { "name": "FLOWDIR", "type": "esriFieldTypeString", "alias": "Flow Direction", "length": 25, "domain": { "type": "codedValue", "name": "WS2_Direction", "description": "A general description of cardinal direction", "codedValues": [ { "name": "East", "code": "East" }, { "name": "North", "code": "North" }, { "name": "South", "code": "South" }, { "name": "West", "code": "West" }, { "name": "Northeast", "code": "Northeast" }, { "name": "Northwest", "code": "Northwest" }, { "name": "Southeast", "code": "Southeast" }, { "name": "Southwest", "code": "Southwest" }, { "name": "North/South", "code": "North/South" }, { "name": "East/West", "code": "East/West" }, { "name": "Northeast/Northwest", "code": "Northeast/Northwest" }, { "name": "Southeast/Southwest", "code": "Southeast/Southwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "Lined", "length": 3, "domain": { "type": "codedValue", "name": "WS2_YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "BASIN", "type": "esriFieldTypeDouble", "alias": "BASIN", "domain": null }, { "name": "RIM_ELEV", "type": "esriFieldTypeDouble", "alias": "RIM_ELEV", "domain": null }, { "name": "INV_N", "type": "esriFieldTypeDouble", "alias": "INV_N", "domain": null }, { "name": "INV_S", "type": "esriFieldTypeDouble", "alias": "INV_S", "domain": null }, { "name": "INV_W", "type": "esriFieldTypeDouble", "alias": "INV_W", "domain": null }, { "name": "INV_E", "type": "esriFieldTypeDouble", "alias": "INV_E", "domain": null }, { "name": "INV_NW", "type": "esriFieldTypeDouble", "alias": "INV_NW", "domain": null }, { "name": "INV_NE", "type": "esriFieldTypeDouble", "alias": "INV_NE", "domain": null }, { "name": "INV_SW", "type": "esriFieldTypeDouble", "alias": "INV_SW", "domain": null }, { "name": "INV_SE", "type": "esriFieldTypeDouble", "alias": "INV_SE", "domain": null }, { "name": "Status", "type": "esriFieldTypeSmallInteger", "alias": "In use or abandoned", "domain": { "type": "codedValue", "name": "WS2_AssetStatus", "description": "In use or abandoned", "codedValues": [ { "name": "Abandoned", "code": 0 }, { "name": "In use", "code": 1 }, { "name": "Unknown", "code": 2 }, { "name": "By-Pass", "code": 3 }, { "name": "Removed", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "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": "ValidatedBy", "type": "esriFieldTypeInteger", "alias": "ValidatedBy", "domain": { "type": "codedValue", "name": "WS2_Validation", "description": "Feature Location Validation", "codedValues": [ { "name": "Aerial Imagery", "code": 1 }, { "name": "Street View", "code": 2 }, { "name": "Field Verified", "code": 3 }, { "name": "GPS", "code": 4 }, { "name": "Needs Field Validation", "code": 5 }, { "name": "As_built", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Question", "type": "esriFieldTypeString", "alias": "Question", "length": 150, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 150, "domain": null }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "Manhole_Survey", "type": "esriFieldTypeString", "alias": "Manhole_Survey", "length": 12, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R139_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I162FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S106_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 128, "name": "Laterals", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 56, 168, 0, 255 ], "width": 1 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 906682.6078969948, "ymin": 559026.3232619911, "xmax": 939611.4757661633, "ymax": 579646.9821518213, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINETYPE", "type": "esriFieldTypeString", "alias": "Line Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Cured in Place", "code": "CP" }, { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "Spiral Wound", "code": "SW" }, { "name": "Other", "code": "OTH" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 50, "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "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": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "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": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DISTANCE", "type": "esriFieldTypeInteger", "alias": "Distance", "domain": null }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "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": "esriFieldTypeSmallInteger", "alias": "In use or abandoned", "domain": { "type": "codedValue", "name": "WS2_AssetStatus", "description": "In use or abandoned", "codedValues": [ { "name": "Abandoned", "code": 0 }, { "name": "In use", "code": 1 }, { "name": "Unknown", "code": 2 }, { "name": "By-Pass", "code": 3 }, { "name": "Removed", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R138_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S105_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 129, "name": "Pressurized Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "Status", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 230, 0, 0, 255 ], "width": 7.950000762939453 }, "value": "1", "label": "In use", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 250, 52, 17, 255 ], "width": 0.75 }, "value": "3", "label": "By-Pass", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 255, 85, 0, 255 ], "width": 0.5 }, "value": "0", "label": "Abandoned", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 905057.3162000775, "ymin": 555190.5208942369, "xmax": 942425.1863460802, "ymax": 580501.7849041596, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "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": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "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": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Status", "type": "esriFieldTypeSmallInteger", "alias": "In use or abandoned", "domain": { "type": "codedValue", "name": "WS2_AssetStatus", "description": "In use or abandoned", "codedValues": [ { "name": "Abandoned", "code": 0 }, { "name": "In use", "code": 1 }, { "name": "Unknown", "code": 2 }, { "name": "By-Pass", "code": 3 }, { "name": "Removed", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Description", "length": 50, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "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": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "H_Link", "type": "esriFieldTypeString", "alias": "H_Link", "length": 150, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R140_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S107_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 130, "name": "Gravity Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "AssetStatus", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 38, 115, 0, 255 ], "width": 7.950000762939453 }, "value": "1", "label": "In use", "description": "" }, { "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 56, 168, 0, 255 ], "width": 0.5 }, "value": "0", "label": "Abandoned", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 906541.3407910801, "ymin": 558996.3476001546, "xmax": 942285.199093245, "ymax": 580480.6957074925, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "Polyvinyl Chloride Class C-900", "code": "PVC_C-900" }, { "name": "Polyvinyl Chloride Class C-905", "code": "PVC_C-905" }, { "name": "PVC Schedule 40", "code": "PVC_SCH40" }, { "name": "PVC Schedule 80", "code": "PVC_SCH80" }, { "name": "Corrugated Iron Pipe", "code": "CIP" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Asbestos", "code": "Asbestos" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "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": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "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": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINSHAPE", "type": "esriFieldTypeString", "alias": "Main Shape", "length": 50, "domain": { "type": "codedValue", "name": "WS2_piPipeShape", "description": "Sanitary and stormwater pipe shapes", "codedValues": [ { "name": "Circular", "code": "Circular" }, { "name": "Horseshoe", "code": "Horseshoe" }, { "name": "Oblong", "code": "Oblong" }, { "name": "Rectangular", "code": "Rectangular" }, { "name": "Trapezoidal", "code": "Trapezoidal" }, { "name": "Triangular", "code": "Triangular" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINERTYPE", "type": "esriFieldTypeString", "alias": "Liner Type", "length": 20, "domain": { "type": "codedValue", "name": "WS2_piLiningMethod", "description": "The pipe lining method based on LACP and PACP standards", "codedValues": [ { "name": "Cured in Place", "code": "CP" }, { "name": "Fold and Form or Deform/Reform", "code": "FF" }, { "name": "Segmented Panel", "code": "SN" }, { "name": "Segmented Pipe", "code": "SP" }, { "name": "Spiral Wound", "code": "SW" }, { "name": "Other", "code": "OTH" }, { "name": "None", "code": "NONE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FROMMH", "type": "esriFieldTypeString", "alias": "From Manhole", "length": 11, "domain": null }, { "name": "TOMH", "type": "esriFieldTypeString", "alias": "To Manhole", "length": 11, "domain": null }, { "name": "WATERTYPE", "type": "esriFieldTypeString", "alias": "Water Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_ssWaterType", "description": "Sanitary sewer water type", "codedValues": [ { "name": "Treated Water", "code": "Treated" }, { "name": "Combined Waste Water", "code": "Combined" }, { "name": "Potable Water", "code": "Potable" }, { "name": "Raw Water", "code": "Raw" }, { "name": "Reclaimed Water", "code": "Reclaimed" }, { "name": "Salt Water", "code": "Salt" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Storm Runoff", "code": "Storm" }, { "name": "Waste Water Effluent", "code": "Effluent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUMFLOW", "type": "esriFieldTypeDouble", "alias": "Flow Summary", "domain": null }, { "name": "DOWNELEV", "type": "esriFieldTypeDouble", "alias": "Downstream Elevation", "domain": null }, { "name": "UPELEV", "type": "esriFieldTypeDouble", "alias": "Upstream Elevation", "domain": null }, { "name": "SLOPE", "type": "esriFieldTypeDouble", "alias": "Slope", "domain": null }, { "name": "BASIN", "type": "esriFieldTypeString", "alias": "BASIN", "length": 50, "domain": null }, { "name": "BASIN_2", "type": "esriFieldTypeSmallInteger", "alias": "BASIN_2", "domain": null }, { "name": "LINED", "type": "esriFieldTypeString", "alias": "LINED", "length": 3, "domain": null }, { "name": "Lined_Date", "type": "esriFieldTypeDate", "alias": "Lined_Date", "length": 8, "domain": null }, { "name": "AssetStatus", "type": "esriFieldTypeSmallInteger", "alias": "In use or abandoned", "domain": { "type": "codedValue", "name": "WS2_AssetStatus", "description": "In use or abandoned", "codedValues": [ { "name": "Abandoned", "code": 0 }, { "name": "In use", "code": 1 }, { "name": "Unknown", "code": 2 }, { "name": "By-Pass", "code": 3 }, { "name": "Removed", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "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": "DIAM1", "type": "esriFieldTypeDouble", "alias": "DIAM1", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null }, { "name": "H_Link", "type": "esriFieldTypeString", "alias": "H_Link", "length": 150, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R137_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S104_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 131, "name": "SystemValve", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "c2df70da126d15bd845fe3aa05796bdd", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAfBJREFUKJGd0j+oUnEUB/DvjydXFK7/EFyuooXSIL4nvARpFhQd7iYIDvE0nCoa5Hp1E664SDikqOEobhdRdBJ0CQx55aAt0eL1gXAhuGAYig2h9UgoOuPhfDjncI4K/xmqc8nBYPBwt9tdEkK+hMPh279CURRT0+m0MJvNDFarFbIsg+O4b16vtxaNRl+eha1Wqz4ajW54nidms/lUsNlsNLVa7UW1Wn2SSqUe34PdbpedTCY3RqORyLKM36GiKJAkCTab7brdbr8+dlYBwGKxKCWTSWI2m1EsFhGLxeB0OnF3d4dSqQSe56FWq5HP558B+AXX6zXDMAwAIJ1Oo1AoIBAIoNPpIJvNwmAwAAAYhtH0+/2rUCj0QQUAFEWddtVoNIjH43C5XJhOpycEACaTCfv9/gGAn3C73X4/HA5qQggkSUKj0cBqtUKlUoHJZILdbgcALJdLeDyej6dR7Xb7p/l8fqnX61Eul5HL5aDT6cBxHARBQCKRAE3TUBTlazAY/HyCDofjab1ef09R1MURAYBWq0Umk4EgCABw8Pl8mXvnCIfDt6IoPh+Px2VJki5omgYhBAAgyzIIIQe32/2WZdnqHw/AsuybXq/3bjgcNpvN5iOKoqjtdruzWCxLv9//KhKJiGc/59gZwBX+IX4Awna03jR2fXIAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 905514.7214532457, "ymin": 555794.5528226569, "xmax": 942425.1863460802, "ymax": 579610.7433791533, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "LOCDESC", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "length": 200, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "Rotation", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": { "type": "codedValue", "name": "WS2_piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "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": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "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": "Unknown", "code": 0 }, { "name": "Other", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 30, "domain": { "type": "codedValue", "name": "WS2_piSystemValveType", "description": "List of system valves types", "codedValues": [ { "name": "Air Release", "code": "Air Release" }, { "name": "Ball", "code": "Ball" }, { "name": "Butterfly", "code": "Butterfly" }, { "name": "Check", "code": "Check" }, { "name": "Cone", "code": "Cone" }, { "name": "Gate", "code": "Gate" }, { "name": "Gate and Plug", "code": "Gate and Plug" }, { "name": "Gate Tapping", "code": "Gate Tapping" }, { "name": "Other", "code": "Other" }, { "name": "Post Indicator Valve", "code": "PIV" }, { "name": "Plug", "code": "Plug" }, { "name": "Post Indicator Valve", "code": "PostInd" }, { "name": "Roundway", "code": "Roundway" }, { "name": "Shut Off", "code": "Shut Off" }, { "name": "Tapping", "code": "Tapping" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Backflow Control", "code": "Backflow Control" }, { "name": "Double Check", "code": "Double Check" }, { "name": "Pressure Reducer", "code": "Pressure Reducer" }, { "name": "Double Detector Check Valve", "code": "DDVC" }, { "name": "Flushing Valve", "code": "Flushing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BYPASSVALVE", "type": "esriFieldTypeSmallInteger", "alias": "Bypass Valve", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CLOCKTOCLOSE", "type": "esriFieldTypeSmallInteger", "alias": "Clockwise To Close", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NORMALLYOPEN", "type": "esriFieldTypeSmallInteger", "alias": "Normally Open", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TURNSTOCLOSE", "type": "esriFieldTypeInteger", "alias": "Turns To Close", "domain": null }, { "name": "OPERABLE", "type": "esriFieldTypeSmallInteger", "alias": "Operable", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CURROPEN", "type": "esriFieldTypeSmallInteger", "alias": "Currently Open", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "WS2_EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "WS2_BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "WS2_AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Miami-Dade", "code": 2 }, { "name": "Others", "code": 3 }, { "name": "Biscayne Park", "code": 4 }, { "name": "Private", "code": 5 }, { "name": "WASD", "code": 6 }, { "name": "Water Service Area", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "Managed By", "domain": { "type": "codedValue", "name": "WS2_AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "North Miami", "code": 1 }, { "name": "Others", "code": 3 }, { "name": "Miami-Dade", "code": 2 }, { "name": "WASD", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "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": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 30, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 10, "domain": { "type": "codedValue", "name": "WS2_Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R135_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S102_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 173, "name": "SewerServiceLocation", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103022, "latestWkid": 6438 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 171, 0, 108, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 904743.5809351611, "ymin": 555105.0624037375, "xmax": 939345.8316124142, "ymax": 580887.687675654, "spatialReference": { "wkid": 102658, "latestWkid": 2236 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ST_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LPROP_ID", "type": "esriFieldTypeDouble", "alias": "LPROP_ID", "domain": null }, { "name": "ADDRESSID", "type": "esriFieldTypeDouble", "alias": "ADDRESSID", "domain": null }, { "name": "FOLIO", "type": "esriFieldTypeString", "alias": "FOLIO", "length": 13, "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null }, { "name": "HSE_NUM", "type": "esriFieldTypeInteger", "alias": "HSE_NUM", "domain": null }, { "name": "PRE_DIR", "type": "esriFieldTypeString", "alias": "PRE_DIR", "length": 2, "domain": null }, { "name": "ST_NAME", "type": "esriFieldTypeString", "alias": "ST_NAME", "length": 20, "domain": null }, { "name": "ST_TYPE", "type": "esriFieldTypeString", "alias": "ST_TYPE", "length": 4, "domain": null }, { "name": "SUF_DIR", "type": "esriFieldTypeString", "alias": "SUF_DIR", "length": 2, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeInteger", "alias": "ZIP", "domain": null }, { "name": "PLUS4", "type": "esriFieldTypeSmallInteger", "alias": "PLUS4", "domain": null }, { "name": "MUNIC", "type": "esriFieldTypeSmallInteger", "alias": "MUNIC", "domain": null }, { "name": "MAILING_MU", "type": "esriFieldTypeString", "alias": "MAILING_MU", "length": 25, "domain": null }, { "name": "SNAME", "type": "esriFieldTypeString", "alias": "SNAME", "length": 42, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "UID", "type": "esriFieldTypeString", "alias": "UID", "length": 50, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R106_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S6_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.81, "id": 134, "name": "PSWaterCW.DBO.psBattery", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VoltsOut", "type": "esriFieldTypeDouble", "alias": "VoltsOut", "domain": null }, { "name": "AMPOut", "type": "esriFieldTypeDouble", "alias": "AMPOut", "domain": null } ], "indexes": [ { "name": "R50_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G60Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SCADA", "relatedTableId": 162, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 135, "name": "PSWaterCW.DBO.psBCCBioCube", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 50, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date\n", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Unit", "type": "esriFieldTypeSmallInteger", "alias": "Unit", "domain": null } ], "indexes": [ { "name": "R51_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G61Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "BioCubeControl", "relatedTableId": 139, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 136, "name": "PSWaterCW.DBO.psBCCBreaker", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 50, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date\n", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R52_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G62Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "BioCubeControl", "relatedTableId": 139, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 137, "name": "PSWaterCW.DBO.psBCCMotor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 50, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date\n", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MotorType", "type": "esriFieldTypeString", "alias": "MotorType", "length": 20, "domain": null }, { "name": "Watts", "type": "esriFieldTypeSmallInteger", "alias": "Watts", "domain": null }, { "name": "Horsepower", "type": "esriFieldTypeDouble", "alias": "Horsepower", "domain": null }, { "name": "Volts", "type": "esriFieldTypeSmallInteger", "alias": "Volts", "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "AMP", "type": "esriFieldTypeDouble", "alias": "AMP", "domain": null } ], "indexes": [ { "name": "R53_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G63Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "BioCubeControl", "relatedTableId": 139, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 138, "name": "PSWaterCW.DBO.psBCCOdorControl", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 50, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date\n", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R54_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G64Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "BioCubeControl", "relatedTableId": 139, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 139, "name": "PSWaterCW.DBO.psBioCubeControl", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R55_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G65Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G65System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G65Asset", "fields": "Asset", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "BCCBioCube", "relatedTableId": 135, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "BCCBreaker", "relatedTableId": 136, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "BCCMotor", "relatedTableId": 137, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "BCCOdorControl", "relatedTableId": 138, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 140, "name": "PSWaterCW.DBO.psBuilding", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Model Number", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R56_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G66Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G66System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Door", "relatedTableId": 142, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "Ground", "relatedTableId": 151, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "Roofling", "relatedTableId": 161, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 141, "name": "PSWaterCW.DBO.psControlPanel", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R57_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G67Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G67System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67PumpStation", "fields": "PumpStation", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "GearSwitch", "relatedTableId": 149, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "Postion", "relatedTableId": 154, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 142, "name": "PSWaterCW.DBO.psDoor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Model Number", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R58_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G68Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Building", "relatedTableId": 140, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 143, "name": "PSWaterCW.DBO.psEngine", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "EngineType", "type": "esriFieldTypeString", "alias": "EngineType", "length": 50, "domain": null }, { "name": "Frame", "type": "esriFieldTypeString", "alias": "Frame", "length": 10, "domain": null }, { "name": "HorsePower", "type": "esriFieldTypeDouble", "alias": "HorsePower", "domain": null }, { "name": "Volts", "type": "esriFieldTypeSmallInteger", "alias": "Volts", "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "AMP", "type": "esriFieldTypeDouble", "alias": "AMP", "domain": null }, { "name": "OilType", "type": "esriFieldTypeString", "alias": "Oil Type", "length": 50, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R59_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G69Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "Generator", "relatedTableId": 150, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 144, "name": "PSWaterCW.DBO.psFencing", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R60_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 145, "name": "PSWaterCW.DBO.psFireExtinguisher", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Model Number", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeSmallInteger", "alias": "SerialNumber", "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R61_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G71System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 16, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 146, "name": "PSWaterCW.DBO.psFPLConnection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "PowerRating", "type": "esriFieldTypeDouble", "alias": "PowerRating", "domain": null }, { "name": "VoltRating", "type": "esriFieldTypeDouble", "alias": "VoltRating", "domain": null }, { "name": "VoltIn", "type": "esriFieldTypeDouble", "alias": "VoltsIn", "domain": null }, { "name": "AMPIn", "type": "esriFieldTypeDouble", "alias": "AMPIn", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R62_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G72Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I72PumpStation", "fields": "PumpStation", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G72System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "FPLMeter", "relatedTableId": 147, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 18, "name": "FPLSwitch", "relatedTableId": 148, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 19, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 147, "name": "PSWaterCW.DBO.psFPLMeter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R63_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G73Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 17, "name": "FPLConnection", "relatedTableId": 146, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 148, "name": "PSWaterCW.DBO.psFPLSwitch", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R64_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G74Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 18, "name": "FPLConnection", "relatedTableId": 146, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 149, "name": "PSWaterCW.DBO.psGearSwitch", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R65_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G75Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "ControlPanel", "relatedTableId": 141, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 150, "name": "PSWaterCW.DBO.psGenerator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "OutputPower", "type": "esriFieldTypeDouble", "alias": "OutputPower", "domain": null }, { "name": "Voltage", "type": "esriFieldTypeSmallInteger", "alias": "Voltage", "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R66_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G76Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G76System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "Engine", "relatedTableId": 143, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 151, "name": "PSWaterCW.DBO.psGround", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Model Number", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R67_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G77Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Building", "relatedTableId": 140, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 152, "name": "PSWaterCW.DBO.psLightingSystem", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 250, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "Serial", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R68_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G78Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "Position", "relatedTableId": 154, "role": "esriRelRoleDestination", "keyField": "Position_ID", "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 }, { "currentVersion": 10.81, "id": 153, "name": "PSWaterCW.DBO.psMainBoard", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R69_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G79Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 22, "name": "SCADA", "relatedTableId": 162, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 154, "name": "PSWaterCW.DBO.psPosition", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Position", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 20, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "PostionStatus", "type": "esriFieldTypeString", "alias": "PostionStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_PositionStatus", "description": "PositionStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Out of Service", "code": "Out of Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R70_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G80Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "LightingSystem", "relatedTableId": 152, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 23, "name": "Pump", "relatedTableId": 157, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 24, "name": "PumpMeter", "relatedTableId": 159, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 25, "name": "PumpSwitchGear", "relatedTableId": 160, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 26, "name": "Valve", "relatedTableId": 167, "role": "esriRelRoleOrigin", "keyField": "Position_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "ControlPanel", "relatedTableId": 141, "role": "esriRelRoleDestination", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 27, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 155, "name": "PSWaterCW.DBO.psProcessMeasurement", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_PositionStatus", "description": "PositionStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "Out of Service", "code": "Out of Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R71_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G81Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 28, "name": "SCADA", "relatedTableId": 162, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 156, "name": "PSWaterCW.DBO.psProtectionCover", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R72_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G82System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 29, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 157, "name": "PSWaterCW.DBO.psPump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 250, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "Serial", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "domain": null }, { "name": "RPM", "type": "esriFieldTypeSmallInteger", "alias": "RPM", "domain": null }, { "name": "GPM", "type": "esriFieldTypeSmallInteger", "alias": "Capacity(GPM)", "domain": null }, { "name": "MGD", "type": "esriFieldTypeSmallInteger", "alias": "Capacity(MGD)", "domain": null }, { "name": "HorsePower", "type": "esriFieldTypeDouble", "alias": "HorsePower", "domain": null }, { "name": "Volts", "type": "esriFieldTypeSmallInteger", "alias": "Voltage", "domain": null }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": null }, { "name": "AMP", "type": "esriFieldTypeDouble", "alias": "AMP", "domain": null }, { "name": "CYCLE", "type": "esriFieldTypeSmallInteger", "alias": "CYCLE", "domain": null } ], "indexes": [ { "name": "R73_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G83Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 23, "name": "Postion", "relatedTableId": 154, "role": "esriRelRoleDestination", "keyField": "Position_ID", "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 }, { "currentVersion": 10.81, "id": 158, "name": "PSWaterCW.DBO.psPumpBoard", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R74_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G84Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 30, "name": "SCADA", "relatedTableId": 162, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 159, "name": "PSWaterCW.DBO.psPumpMeter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 250, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "Serial", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Reading", "type": "esriFieldTypeString", "alias": "Reading", "length": 50, "domain": null } ], "indexes": [ { "name": "R75_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G85Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 24, "name": "Position", "relatedTableId": 154, "role": "esriRelRoleDestination", "keyField": "Position_ID", "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 }, { "currentVersion": 10.81, "id": 160, "name": "PSWaterCW.DBO.psPumpSwitchGear", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 250, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "Serial", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R77_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G87Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 25, "name": "Position", "relatedTableId": 154, "role": "esriRelRoleDestination", "keyField": "Position_ID", "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 }, { "currentVersion": 10.81, "id": 161, "name": "PSWaterCW.DBO.psRoofling", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Model Number", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R78_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G88Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "Building", "relatedTableId": 140, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 162, "name": "PSWaterCW.DBO.psSCADA", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R79_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G89Asset_ID", "fields": "Asset_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G89System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Battery", "relatedTableId": 134, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 22, "name": "MainBoard", "relatedTableId": 153, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 28, "name": "ProcessMeasurement", "relatedTableId": 155, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 30, "name": "PumpBoard", "relatedTableId": 158, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 31, "name": "SCADATransformer", "relatedTableId": 163, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 32, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 163, "name": "PSWaterCW.DBO.psSCADATransformer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 30, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Parent_ID", "type": "esriFieldTypeString", "alias": "Parent_ID", "length": 20, "domain": null }, { "name": "Parent", "type": "esriFieldTypeString", "alias": "Parent", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "PowerRating", "type": "esriFieldTypeDouble", "alias": "PowerRating", "domain": null }, { "name": "VoltRating", "type": "esriFieldTypeDouble", "alias": "VoltRating", "domain": null }, { "name": "VoltIn", "type": "esriFieldTypeDouble", "alias": "VoltsIn", "domain": null }, { "name": "VoltOut", "type": "esriFieldTypeDouble", "alias": "VoltsOut", "domain": null }, { "name": "AMPIn", "type": "esriFieldTypeDouble", "alias": "AMPIn", "domain": null }, { "name": "AMPOut", "type": "esriFieldTypeDouble", "alias": "AMPOut", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R80_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G90Parent_ID", "fields": "Parent_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 31, "name": "SCADA", "relatedTableId": 162, "role": "esriRelRoleDestination", "keyField": "Parent_ID", "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 }, { "currentVersion": 10.81, "id": 164, "name": "PSWaterCW.DBO.psStationAlarm", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeSmallInteger", "alias": "SerialNumber", "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R81_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G91System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 33, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 165, "name": "PSWaterCW.DBO.psSystem", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "System", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "PS_ID", "type": "esriFieldTypeString", "alias": "PS_ID", "length": 20, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R82_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G92System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G92PS_ID", "fields": "PS_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "BioCubeControl", "relatedTableId": 139, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "Building", "relatedTableId": 140, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "ControlPanel", "relatedTableId": 141, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "Fencing", "relatedTableId": 144, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 16, "name": "FireExtinguisher", "relatedTableId": 145, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 19, "name": "FPLConnection", "relatedTableId": 146, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 20, "name": "Generator", "relatedTableId": 150, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 27, "name": "Postion", "relatedTableId": 154, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 29, "name": "ProtectionCover", "relatedTableId": 156, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 32, "name": "SCADA", "relatedTableId": 162, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 33, "name": "StationAlarm", "relatedTableId": 164, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 34, "name": "Transformer", "relatedTableId": 166, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 35, "name": "ValvePit", "relatedTableId": 168, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 36, "name": "Ventilation", "relatedTableId": 169, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 37, "name": "WetWell", "relatedTableId": 170, "role": "esriRelRoleOrigin", "keyField": "System_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "PumpStation", "relatedTableId": 133, "role": "esriRelRoleDestination", "keyField": "PS_ID", "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 }, { "currentVersion": 10.81, "id": 166, "name": "PSWaterCW.DBO.psTransformer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "PowerRating", "type": "esriFieldTypeDouble", "alias": "PowerRating", "domain": null }, { "name": "VoltRating", "type": "esriFieldTypeDouble", "alias": "VoltRating", "domain": null }, { "name": "VoltIn", "type": "esriFieldTypeDouble", "alias": "VoltsIn", "domain": null }, { "name": "VoltOut", "type": "esriFieldTypeDouble", "alias": "VoltsOut", "domain": null }, { "name": "AMPIn", "type": "esriFieldTypeDouble", "alias": "AMPIn", "domain": null }, { "name": "AMPOut", "type": "esriFieldTypeDouble", "alias": "AMPOut", "domain": null }, { "name": "LifeCycleStatus", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R83_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G93System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 34, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 167, "name": "PSWaterCW.DBO.psValve", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 250, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "Position_ID", "type": "esriFieldTypeString", "alias": "Position_ID", "length": 50, "domain": null }, { "name": "Position", "type": "esriFieldTypeString", "alias": "Position", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "MFRDate", "length": 8, "domain": null }, { "name": "Serial", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 20, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "domain": null }, { "name": "Function_", "type": "esriFieldTypeString", "alias": "Function", "length": 20, "domain": null }, { "name": "Size", "type": "esriFieldTypeDouble", "alias": "Size", "domain": null } ], "indexes": [ { "name": "R84_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G94Position_ID", "fields": "Position_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 26, "name": "Postion", "relatedTableId": 154, "role": "esriRelRoleDestination", "keyField": "Position_ID", "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 }, { "currentVersion": 10.81, "id": 168, "name": "PSWaterCW.DBO.psValvePit", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R85_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G95System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 35, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 169, "name": "PSWaterCW.DBO.psVentilation", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R86_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G96System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 36, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 }, { "currentVersion": 10.81, "id": 170, "name": "PSWaterCW.DBO.psWetWell", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PumpStation", "type": "esriFieldTypeString", "alias": "PumpStation", "length": 50, "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 20, "domain": null }, { "name": "Asset", "type": "esriFieldTypeString", "alias": "Asset", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "System_ID", "type": "esriFieldTypeString", "alias": "System_ID", "length": 20, "domain": null }, { "name": "System", "type": "esriFieldTypeString", "alias": "System", "length": 50, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 50, "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "ModifiedBy", "type": "esriFieldTypeString", "alias": "ModifiedBy", "length": 50, "domain": null }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "ModifiedDate", "length": 8, "domain": null }, { "name": "InstalledDate", "type": "esriFieldTypeDate", "alias": "InstalledDate", "length": 8, "domain": null }, { "name": "MFR", "type": "esriFieldTypeString", "alias": "Manufacurer", "length": 50, "domain": null }, { "name": "MFRModel", "type": "esriFieldTypeString", "alias": "Model Number", "length": 50, "domain": null }, { "name": "MFRDate", "type": "esriFieldTypeDate", "alias": "Manufacture Date", "length": 8, "domain": null }, { "name": "LifeCycelStatus", "type": "esriFieldTypeString", "alias": "LifeCycelStatus", "length": 50, "domain": { "type": "codedValue", "name": "WS1_LifeCycleStatus", "description": "LifeCycleStatus", "codedValues": [ { "name": "In Service", "code": "In Service" }, { "name": "New On Shelf", "code": "New On Shelf" }, { "name": "Used On Shelf", "code": "Used On Shelf" }, { "name": "Discarded", "code": "Discarded" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CondtionDate", "type": "esriFieldTypeDate", "alias": "CondtionDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R87_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G97System_ID", "fields": "System_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 37, "name": "System", "relatedTableId": 165, "role": "esriRelRoleDestination", "keyField": "System_ID", "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 } ] }