{ "currentVersion": 10.81, "id": 1, "name": "sw.DBO.Inlets_Cleaning_Form", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreationDate_1", "creatorField": "Creator_1", "editDateField": "EditDate_1", "editorField": "Editor_1" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "sw.DBO.Inlet_Contractor_Cleaning", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Inlet_ID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Accessible", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CleaningStatus", "type": "esriFieldTypeString", "alias": "Did you clean the inlet?", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "CleaningStatus" }, { "name": "NotCleanedReason", "type": "esriFieldTypeString", "alias": "Why was inlet not cleaned?", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "NotCleanedReason" }, { "name": "Accessible", "type": "esriFieldTypeString", "alias": "Is inlet accessible?", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Accessible" }, { "name": "Reason_Inaccessible", "type": "esriFieldTypeString", "alias": "Reason for inaccessibility", "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" }, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "Reason_Inaccessible" }, { "name": "Stru_Condit", "type": "esriFieldTypeString", "alias": "Structural condition of inlet", "domain": { "type": "codedValue", "name": "dInlet_StructuralCondition", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Poor", "code": "Poor" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Stru_Condit" }, { "name": "Outfall_Condit", "type": "esriFieldTypeString", "alias": "Condition of outfall pipe", "domain": { "type": "codedValue", "name": "dInlet_OutfallCondition", "description": "", "codedValues": [ { "name": "Obstructed", "code": "Obstructed" }, { "name": "Clear", "code": "Clear" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Outfall_Condit" }, { "name": "Outfall_Release", "type": "esriFieldTypeString", "alias": "Did you release outfall pipe?", "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" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Outfall_Release" }, { "name": "Inlet_ID", "type": "esriFieldTypeString", "alias": "Inlet_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Inlet_ID" }, { "name": "Neighborhood", "type": "esriFieldTypeString", "alias": "Neighborhood", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "Neighborhood" }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "Street" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "Location" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "QC", "type": "esriFieldTypeString", "alias": "QC", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "QC" }, { "name": "QC_Comments", "type": "esriFieldTypeString", "alias": "QC_Comments", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "QC_Comments" }, { "name": "CreationDate_1", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreationDate_1" }, { "name": "Creator_1", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Creator_1" }, { "name": "EditDate_1", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate_1" }, { "name": "Editor_1", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Editor_1" }, { "name": "FY_PO", "type": "esriFieldTypeString", "alias": "FY_PO", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FY_PO" }, { "name": "Crew", "type": "esriFieldTypeString", "alias": "Crew", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Crew" }, { "name": "Comment_Contractor", "type": "esriFieldTypeString", "alias": "Comment_Contractor", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "Comment_Contractor" }, { "name": "DateCleaned", "type": "esriFieldTypeDate", "alias": "Date Inlet was cleaned or visited by Contractor", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateCleaned" }, { "name": "Orig_GBID", "type": "esriFieldTypeString", "alias": "Orig_GBID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Orig_GBID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "sw.DBO.Inlets_Cleaning_Form", "description": "", "prototype": { "attributes": { "Orig_GBID": null, "DateCleaned": null, "CleaningStatus": null, "NotCleanedReason": null, "Accessible": null, "Reason_Inaccessible": null, "Stru_Condit": null, "Outfall_Condit": null, "Outfall_Release": null, "Inlet_ID": null, "Neighborhood": null, "Street": null, "Location": null, "InspectionDate": null, "QC": null, "QC_Comments": null, "Comment_Contractor": null, "Crew": null, "FY_PO": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }