{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Sites", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "MaintenanceArea", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{0C6B25FA-057A-42D8-B7D9-243A7261E61E}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriIntFeet" }, "hasMetadata": true, "extent": { "xmin": 1.328630772284685E7, "ymin": 290663.7914340794, "xmax": 1.3287248080042526E7, "ymax": 291188.0726663619, "spatialReference": { "wkid": 2253, "latestWkid": 2253, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 2253, "latestWkid": 2253, "xyTolerance": 0.0032808464567060333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -107138600, "falseY": -97193800, "xyUnits": 3047.993904000002, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 194, 251, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R43_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_43", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S11_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Sites", "description": "", "prototype": { "attributes": { "LOCATION": null, "NAME": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "MaintenanceArea", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{CBC9B6A1-80F9-4381-8DC1-CD73ABB49FCE}" }, { "id": 0, "name": "Sites", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{0C6B25FA-057A-42D8-B7D9-243A7261E61E}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" } ], "indexes": [ { "name": "R44_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_44", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2038_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MaintenanceArea", "description": "", "prototype": { "attributes": { "Parent_GUID": null, "LOCATION": null, "NAME": null, "SITE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Process", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 14, "name": "Valve", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{7699CCB7-039B-4F0C-822E-08A439CE832C}" }, { "id": 10, "name": "Instrumentation", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{D951F9C7-1BA5-41F9-8BDE-13DD6E2614F2}" }, { "id": 24, "name": "Slaker", "relatedTableId": 26, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{B2EC096E-935C-4ED8-82EF-1BDC91F2CD36}" }, { "id": 13, "name": "HVAC", "relatedTableId": 19, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{24642E58-547C-4FB1-A489-2DFDF8DA7434}" }, { "id": 16, "name": "Filter", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{3D727640-05E1-46FC-8458-2E9A4DB7D0C5}" }, { "id": 3, "name": "Thickener", "relatedTableId": 28, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{F0F854F0-03C2-4B35-B0D1-4E05BBC07396}" }, { "id": 7, "name": "Bin", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{F2CCA72B-A91F-4DE1-99DE-4E2B7C28AAB2}" }, { "id": 22, "name": "Tank", "relatedTableId": 27, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{DD8A5151-80F5-46A5-9A1E-576037251D76}" }, { "id": 23, "name": "Electrical", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{82520A6C-5E17-49BC-83F2-5E9600334516}" }, { "id": 25, "name": "Mixer", "relatedTableId": 22, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{7071A838-F68E-43D9-BBD1-5FA9088B4C11}" }, { "id": 18, "name": "Regulator", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{066C5AFC-AA00-4877-8EAA-62713D52B717}" }, { "id": 11, "name": "GearReducer", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{EA5323D5-6B5C-4300-B345-6DAB45BF185A}" }, { "id": 9, "name": "Header", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{D4EDA87D-65CB-4090-997B-71CE773DF81E}" }, { "id": 26, "name": "Feeder", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{2C49E2BD-533C-426A-8A10-74EF8B41F13D}" }, { "id": 8, "name": "Meter", "relatedTableId": 21, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{E5C017A8-9F78-413B-B64D-88A4A8117844}" }, { "id": 21, "name": "Vaporizer", "relatedTableId": 29, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{B867FE97-FAA1-4295-A489-970D380F35DF}" }, { "id": 15, "name": "Compressor", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{47F00D64-0F03-4E87-88CC-970DBAB3959B}" }, { "id": 17, "name": "Flocculator", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{63DFFD81-E95F-488C-A546-999178D1D527}" }, { "id": 5, "name": "Generator", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{3344B153-17DD-46F0-BC00-AF9E9500072C}" }, { "id": 20, "name": "Backflow", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{60966A05-307A-453B-9F0D-B1DDEF024144}" }, { "id": 2, "name": "Clarifier", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{240C31D1-C9E8-434C-8884-B7BBD8FC5402}" }, { "id": 4, "name": "Pump", "relatedTableId": 24, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{A40BDA60-64B7-4F87-9FE5-D4ADEE9206CC}" }, { "id": 28, "name": "Contactor", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{68CB42A6-8040-4BF0-B515-D562C634CCF1}" }, { "id": 19, "name": "FilterPress", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{2DFB6A4F-A66D-47CA-99F4-E365F73DFAD7}" }, { "id": 6, "name": "Boiler", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{A4EA1828-88CA-416B-82EF-F53036FEC896}" }, { "id": 12, "name": "Motor", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{4747F518-0788-46E8-85FD-FF05221E58FB}" }, { "id": 27, "name": "Crane", "relatedTableId": 10, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false, "catalogID": "{8A19361C-F2B3-43C2-80C5-FFC509AB9182}" }, { "id": 1, "name": "MaintenanceArea", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{CBC9B6A1-80F9-4381-8DC1-CD73ABB49FCE}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ProcessName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ProcessName", "type": "esriFieldTypeString", "alias": "ProcessName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ProcessName" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "MaintArea", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R45_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_45", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2439_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Process", "description": "", "prototype": { "attributes": { "Parent_GUID": null, "MaintArea": null, "ProcessName": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Valve", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 14, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{7699CCB7-039B-4F0C-822E-08A439CE832C}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" } ], "indexes": [ { "name": "R30_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_30", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_419_Parent_G", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Valve", "description": "", "prototype": { "attributes": { "INSP_DATE": null, "NAME": null, "Parent_GUID": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Backflow", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 20, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{60966A05-307A-453B-9F0D-B1DDEF024144}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R48_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_48", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2846_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Backflow", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Bin", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 7, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{F2CCA72B-A91F-4DE1-99DE-4E2B7C28AAB2}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R49_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_49", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2847_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Bin", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "BoilerWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{A4EA1828-88CA-416B-82EF-F53036FEC896}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R50_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_50", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2848_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "BoilerWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "ClarifierWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{240C31D1-C9E8-434C-8884-B7BBD8FC5402}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R51_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_51", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2849_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ClarifierWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "CompressorWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 15, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{47F00D64-0F03-4E87-88CC-970DBAB3959B}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R52_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_52", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2850_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "CompressorWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "FACILITYID": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null, "created_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Contactor", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 28, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{68CB42A6-8040-4BF0-B515-D562C634CCF1}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R53_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_53", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2851_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Contactor", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Crane", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 27, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{8A19361C-F2B3-43C2-80C5-FFC509AB9182}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R56_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_56", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2854_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Crane", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "ElectricalWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 23, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{82520A6C-5E17-49BC-83F2-5E9600334516}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R57_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_57", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2855_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ElectricalWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "FeederWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 26, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{2C49E2BD-533C-426A-8A10-74EF8B41F13D}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R58_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_58", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2856_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FeederWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "FilterWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 16, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{3D727640-05E1-46FC-8458-2E9A4DB7D0C5}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R59_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_59", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2857_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FilterWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 14, "name": "FilterPress", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 19, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{2DFB6A4F-A66D-47CA-99F4-E365F73DFAD7}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R60_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_60", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2858_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FilterPress", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 15, "name": "FlocculatorWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 17, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{63DFFD81-E95F-488C-A546-999178D1D527}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R61_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_61", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2859_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FlocculatorWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 16, "name": "GearReducerWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 11, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{EA5323D5-6B5C-4300-B345-6DAB45BF185A}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R62_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_62", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2860_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GearReducerWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 17, "name": "GeneratorWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 5, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{3344B153-17DD-46F0-BC00-AF9E9500072C}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R64_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_64", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2862_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GeneratorWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 18, "name": "HeaderWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 9, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{D4EDA87D-65CB-4090-997B-71CE773DF81E}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R65_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_65", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2863_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "HeaderWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 19, "name": "HVACwtp", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 13, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{24642E58-547C-4FB1-A489-2DFDF8DA7434}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "BUILDING", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BUILDING" }, { "name": "ROOM", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ROOM" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" } ], "indexes": [ { "name": "R29_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_29", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_418_Parent_G", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "HVACwtp", "description": "", "prototype": { "attributes": { "INSP_DATE": null, "NAME": null, "Parent_GUID": null, "OLD_ASSETNO": null, "BUILDING": null, "ROOM": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 20, "name": "InstrumentationWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 10, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{D951F9C7-1BA5-41F9-8BDE-13DD6E2614F2}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R66_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_66", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2864_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "InstrumentationWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 21, "name": "MeterWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 8, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{E5C017A8-9F78-413B-B64D-88A4A8117844}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R67_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_67", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2865_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MeterWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 22, "name": "MixerWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 25, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{7071A838-F68E-43D9-BBD1-5FA9088B4C11}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R68_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_68", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2866_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MixerWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 23, "name": "MotorWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 12, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{4747F518-0788-46E8-85FD-FF05221E58FB}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "BUILDING", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BUILDING" }, { "name": "ROOM", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ROOM" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" } ], "indexes": [ { "name": "R31_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_31", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_420_Parent_G", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MotorWTP", "description": "", "prototype": { "attributes": { "INSP_DATE": null, "NAME": null, "Parent_GUID": null, "OLD_ASSETNO": null, "BUILDING": null, "ROOM": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 24, "name": "PumpWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{A40BDA60-64B7-4F87-9FE5-D4ADEE9206CC}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Field", "type": "esriFieldTypeString", "alias": "Field", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Field" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "BUILDING", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BUILDING" }, { "name": "ROOM", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ROOM" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" } ], "indexes": [ { "name": "R28_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_28", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_417_Parent_G", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PumpWTP", "description": "", "prototype": { "attributes": { "INSP_DATE": null, "NAME": null, "Field": null, "Parent_GUID": null, "OLD_ASSETNO": null, "BUILDING": null, "ROOM": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 25, "name": "RegulatorWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 18, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{066C5AFC-AA00-4877-8EAA-62713D52B717}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R69_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_69", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2867_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "RegulatorWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 26, "name": "SlakerWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 24, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{B2EC096E-935C-4ED8-82EF-1BDC91F2CD36}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R70_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_70", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2868_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SlakerWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 27, "name": "TankWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 22, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{DD8A5151-80F5-46A5-9A1E-576037251D76}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "PROCESS", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PROCESS" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" } ], "indexes": [ { "name": "R46_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_46", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3239_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "TankWTP", "description": "", "prototype": { "attributes": { "INSP_DATE": null, "NAME": null, "Parent_GUID": null, "OLD_ASSETNO": null, "PROCESS": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 28, "name": "ThickenerWTP", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{F0F854F0-03C2-4B35-B0D1-4E05BBC07396}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R71_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_71", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2869_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ThickenerWTP", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 29, "name": "WTPVaporizer", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 21, "name": "Process", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Parent_GUID", "composite": false, "catalogID": "{B867FE97-FAA1-4295-A489-970D380F35DF}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "NAME" }, { "name": "OLD_ASSETNO", "type": "esriFieldTypeString", "alias": "OLD_ASSETNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OLD_ASSETNO" }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "BUILDING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SITE" }, { "name": "MaintArea", "type": "esriFieldTypeString", "alias": "ROOM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaintArea" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATUS" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "MANUFACTURER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "MODEL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MODEL" }, { "name": "SUPPLIER", "type": "esriFieldTypeString", "alias": "SUPPLIER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SUPPLIER" }, { "name": "SERIALNO", "type": "esriFieldTypeString", "alias": "SERIALNO", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SERIALNO" }, { "name": "PURCHASE_DATE", "type": "esriFieldTypeDate", "alias": "PURCHASE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PURCHASE_DATE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "WARRANTY_DATE", "type": "esriFieldTypeDate", "alias": "WARRANTY_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WARRANTY_DATE" }, { "name": "CoF", "type": "esriFieldTypeString", "alias": "CoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoF" }, { "name": "PoF", "type": "esriFieldTypeString", "alias": "PoF", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoF" }, { "name": "BRE", "type": "esriFieldTypeString", "alias": "BRE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "BRE" }, { "name": "INSP_DATE", "type": "esriFieldTypeDate", "alias": "INSP_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_DATE" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Parent_GUID", "type": "esriFieldTypeGUID", "alias": "Parent_GUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Parent_GUID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R72_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_72", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_2870_Parent_", "fields": "Parent_GUID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WTPVaporizer", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "created_user": null, "NAME": null, "OLD_ASSETNO": null, "SITE": null, "MaintArea": null, "LOCATION": null, "STATUS": null, "MANUFACTURER": null, "MODEL": null, "SUPPLIER": null, "SERIALNO": null, "PURCHASE_DATE": null, "INSTALL_DATE": null, "WARRANTY_DATE": null, "CoF": null, "PoF": null, "BRE": null, "INSP_DATE": null, "last_edited_date": null, "Parent_GUID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }