{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "ArcSDE.SDE.T_Hangar_Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "globalid", "displayField": "t_hangar_no", "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": "inspection_date_time", "type": "esriFieldTypeDate", "alias": "INSPECTION DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inspection_date" }, { "name": "t_hangar_no", "type": "esriFieldTypeString", "alias": "T-HANGAR No", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "t_hangar_no" }, { "name": "authority_lock", "type": "esriFieldTypeString", "alias": "AUTHORITY LOCK", "domain": { "type": "codedValue", "name": "cvd_authority_lock", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "authority_lock" }, { "name": "aircraft_no_on_lease", "type": "esriFieldTypeString", "alias": "AIRCRAFT No ON LEASE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "aircraft_no_on_lease" }, { "name": "aircraft_no_in_hangar", "type": "esriFieldTypeString", "alias": "AIRCRAFT No IN HANGAR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "aircraft_no_in_hangar" }, { "name": "current_lease", "type": "esriFieldTypeString", "alias": "CURRENT LEASE ON FILE", "domain": { "type": "codedValue", "name": "cvd_current_lease", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "current_lease" }, { "name": "ext_physical_damage", "type": "esriFieldTypeString", "alias": "PHYSICAL DAMAGE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ext_physical_damage" }, { "name": "ext_debris", "type": "esriFieldTypeString", "alias": "DEBRIS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ext_debris" }, { "name": "ext_storage", "type": "esriFieldTypeString", "alias": "STORAGE OF CARS, TRAILERS, BOATS, ETC", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ext_storage" }, { "name": "ext_alt_add_improv", "type": "esriFieldTypeString", "alias": "ALTERATIONS, ADDITIONS, IMPROVEMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ext_alt_add_improv" }, { "name": "int_physical_damage", "type": "esriFieldTypeString", "alias": "PHYSICAL DAMAGE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "int_physical_damage" }, { "name": "int_debris", "type": "esriFieldTypeString", "alias": "DEBRIS (Boxes, crates, rubbish, paper, rags, waste, etc.):", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "int_debris" }, { "name": "floors_conditions", "type": "esriFieldTypeString", "alias": "FLOORS CLEAN OF OIL, GREASE & TOXIC CHEMICALS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "floors_conditions" }, { "name": "storage_materials", "type": "esriFieldTypeString", "alias": "STORAGE OF HAZARDOUS OR FLAMMABLE MATERIALS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "storage_materials" }, { "name": "storage_batteries", "type": "esriFieldTypeString", "alias": "STORAGE OF BATTERIES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "storage_batteries" }, { "name": "fire_extinguisher", "type": "esriFieldTypeString", "alias": "20 lb. DRY CHEMICAL FIRE EXTINGUISHER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fire_extinguisher" }, { "name": "signs_spraying", "type": "esriFieldTypeString", "alias": "SIGNS OF PAINTING/PAINT SPRAYING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "signs_spraying" }, { "name": "signs_smoking", "type": "esriFieldTypeString", "alias": "SIGNS OF SMOKING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "signs_smoking" }, { "name": "signs_automobile", "type": "esriFieldTypeString", "alias": "SIGNS OF AUTOMOBILE SERVICING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "signs_automobile" }, { "name": "sign_activity", "type": "esriFieldTypeString", "alias": "SIGNS OF COMMERCIAL ACTIVITY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sign_activity" }, { "name": "alt_add_improv", "type": "esriFieldTypeString", "alias": "ALTERATIONS, ADDITIONS, IMPROVEMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "alt_add_improv" }, { "name": "wiring_lighting", "type": "esriFieldTypeString", "alias": "ADDITIONAL WIRING/LIGHTING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "wiring_lighting" }, { "name": "lost", "type": "esriFieldTypeString", "alias": "LOST OF ANY KIND", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "lofts" }, { "name": "signage", "type": "esriFieldTypeString", "alias": "SIGNAGE (Erected, painted, or otherwise displayed)", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "signage" }, { "name": "components", "type": "esriFieldTypeString", "alias": "AIRCRAFT/AIRCRAFT COMPONENTS SUSPENDED OR LIFTED", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "components" }, { "name": "misc", "type": "esriFieldTypeString", "alias": "MISC", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "misc" }, { "name": "overall_condition", "type": "esriFieldTypeString", "alias": "OVERALL T-HANGAR CONDITION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "overall_condition" }, { "name": "reinspection_yn", "type": "esriFieldTypeString", "alias": "REINSPECTION REQUIRED", "domain": { "type": "codedValue", "name": "cvd_reinspection_yn", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "reinspection_yn" }, { "name": "reinspection_date_time", "type": "esriFieldTypeDate", "alias": "REINSPECTION DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "reinspection_date" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "comments" }, { "name": "inspector_signature", "type": "esriFieldTypeString", "alias": "INSPECTOR'S SIGNATURE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspector_signature" }, { "name": "tenant_signature", "type": "esriFieldTypeString", "alias": "TENANT'S SIGNATURE", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tenant_signature" }, { "name": "THangarGUID", "type": "esriFieldTypeGUID", "alias": "THangarGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "THangarGUID" }, { "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 EDITOR", "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": "R2850_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2850", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "ArcSDE.SDE.T_Hangar_Inspections", "description": "", "prototype": { "attributes": { "last_edited_user": null, "created_date": null, "last_edited_date": null, "inspection_date_time": null, "t_hangar_no": null, "authority_lock": null, "aircraft_no_on_lease": null, "aircraft_no_in_hangar": null, "current_lease": null, "ext_physical_damage": null, "ext_debris": null, "ext_storage": null, "ext_alt_add_improv": null, "int_physical_damage": null, "int_debris": null, "floors_conditions": null, "storage_materials": null, "storage_batteries": null, "fire_extinguisher": null, "signs_spraying": null, "signs_smoking": null, "signs_automobile": null, "sign_activity": null, "alt_add_improv": null, "wiring_lighting": null, "lost": null, "signage": null, "components": null, "misc": null, "overall_condition": null, "reinspection_yn": null, "reinspection_date_time": null, "comments": null, "inspector_signature": null, "tenant_signature": null, "THangarGUID": null, "created_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "f9c4448eb3f9496887df89327e357b3b" }