{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "sw.DBO.Inlets_Cleaning_Form", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Accessible", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CleaningStatus", "type": "esriFieldTypeString", "alias": "Did you clean the inlet?", "length": 5, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NotCleanedReason", "type": "esriFieldTypeString", "alias": "Why was inlet not cleaned?", "length": 256, "domain": null }, { "name": "Accessible", "type": "esriFieldTypeString", "alias": "Is inlet accessible?", "length": 5, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Reason_Inaccessible", "type": "esriFieldTypeString", "alias": "Reason for inaccessibility", "length": 256, "domain": { "type": "codedValue", "name": "dInlet_Accessiblility", "description": "", "codedValues": [ { "name": "Construction", "code": "CON" }, { "name": "Parked Vehicles", "code": "VEH" }, { "name": "Other", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Stru_Condit", "type": "esriFieldTypeString", "alias": "Structural condition of inlet", "length": 5, "domain": { "type": "codedValue", "name": "dInlet_StructuralCondition", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Poor", "code": "Poor" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Condit", "type": "esriFieldTypeString", "alias": "Condition of outfall pipe", "length": 10, "domain": { "type": "codedValue", "name": "dInlet_OutfallCondition", "description": "", "codedValues": [ { "name": "Obstructed", "code": "Obstructed" }, { "name": "Clear", "code": "Clear" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Outfall_Release", "type": "esriFieldTypeString", "alias": "Did you release outfall pipe?", "length": 5, "domain": { "type": "codedValue", "name": "dYes_No_NA", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inlet_ID", "type": "esriFieldTypeString", "alias": "Inlet_ID", "length": 15, "domain": null }, { "name": "Neighborhood", "type": "esriFieldTypeString", "alias": "Neighborhood", "length": 40, "domain": null }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "length": 254, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 254, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "length": 8, "domain": null }, { "name": "QC", "type": "esriFieldTypeString", "alias": "QC", "length": 20, "domain": null }, { "name": "QC_Comments", "type": "esriFieldTypeString", "alias": "QC_Comments", "length": 256, "domain": null }, { "name": "CreationDate_1", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator_1", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate_1", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor_1", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "FY_PO", "type": "esriFieldTypeString", "alias": "FY_PO", "length": 10, "domain": null }, { "name": "Crew", "type": "esriFieldTypeString", "alias": "Crew", "length": 25, "domain": null }, { "name": "Comment_Contractor", "type": "esriFieldTypeString", "alias": "Comment_Contractor", "length": 256, "domain": null }, { "name": "DateCleaned", "type": "esriFieldTypeDate", "alias": "Date Inlet was cleaned or visited by Contractor", "length": 8, "domain": null }, { "name": "Orig_GBID", "type": "esriFieldTypeString", "alias": "Orig_GBID", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R510_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I6103Orig_GBID", "fields": "Orig_GBID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_510", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_6103_Inlet_I", "fields": "Inlet_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "sw.DBO.Inlet_Contractor_Cleaning", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Inlet_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B1F193D0-64B2-4AD1-883D-D1285E2C441F}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }