{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 32, "name": "ArcSDE.SDE.T_Hangar_Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "t_hangar_no", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "inspection_date_time", "type": "esriFieldTypeDate", "alias": "INSPECTION DATE", "length": 8, "domain": null }, { "name": "t_hangar_no", "type": "esriFieldTypeString", "alias": "T-HANGAR No", "length": 255, "domain": null }, { "name": "authority_lock", "type": "esriFieldTypeString", "alias": "AUTHORITY LOCK", "length": 3, "domain": { "type": "codedValue", "name": "cvd_authority_lock", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aircraft_no_on_lease", "type": "esriFieldTypeString", "alias": "AIRCRAFT No ON LEASE", "length": 255, "domain": null }, { "name": "aircraft_no_in_hangar", "type": "esriFieldTypeString", "alias": "AIRCRAFT No IN HANGAR", "length": 255, "domain": null }, { "name": "current_lease", "type": "esriFieldTypeString", "alias": "CURRENT LEASE ON FILE", "length": 3, "domain": { "type": "codedValue", "name": "cvd_current_lease", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ext_physical_damage", "type": "esriFieldTypeString", "alias": "PHYSICAL DAMAGE", "length": 255, "domain": null }, { "name": "ext_debris", "type": "esriFieldTypeString", "alias": "DEBRIS", "length": 255, "domain": null }, { "name": "ext_storage", "type": "esriFieldTypeString", "alias": "STORAGE OF CARS, TRAILERS, BOATS, ETC", "length": 255, "domain": null }, { "name": "ext_alt_add_improv", "type": "esriFieldTypeString", "alias": "ALTERATIONS, ADDITIONS, IMPROVEMENTS", "length": 255, "domain": null }, { "name": "int_physical_damage", "type": "esriFieldTypeString", "alias": "PHYSICAL DAMAGE", "length": 255, "domain": null }, { "name": "int_debris", "type": "esriFieldTypeString", "alias": "DEBRIS (Boxes, crates, rubbish, paper, rags, waste, etc.):", "length": 255, "domain": null }, { "name": "floors_conditions", "type": "esriFieldTypeString", "alias": "FLOORS CLEAN OF OIL, GREASE & TOXIC CHEMICALS", "length": 255, "domain": null }, { "name": "storage_materials", "type": "esriFieldTypeString", "alias": "STORAGE OF HAZARDOUS OR FLAMMABLE MATERIALS", "length": 255, "domain": null }, { "name": "storage_batteries", "type": "esriFieldTypeString", "alias": "STORAGE OF BATTERIES", "length": 255, "domain": null }, { "name": "fire_extinguisher", "type": "esriFieldTypeString", "alias": "20 lb. DRY CHEMICAL FIRE EXTINGUISHER", "length": 255, "domain": null }, { "name": "signs_spraying", "type": "esriFieldTypeString", "alias": "SIGNS OF PAINTING/PAINT SPRAYING", "length": 255, "domain": null }, { "name": "signs_smoking", "type": "esriFieldTypeString", "alias": "SIGNS OF SMOKING", "length": 255, "domain": null }, { "name": "signs_automobile", "type": "esriFieldTypeString", "alias": "SIGNS OF AUTOMOBILE SERVICING", "length": 255, "domain": null }, { "name": "sign_activity", "type": "esriFieldTypeString", "alias": "SIGNS OF COMMERCIAL ACTIVITY", "length": 255, "domain": null }, { "name": "alt_add_improv", "type": "esriFieldTypeString", "alias": "ALTERATIONS, ADDITIONS, IMPROVEMENTS", "length": 255, "domain": null }, { "name": "wiring_lighting", "type": "esriFieldTypeString", "alias": "ADDITIONAL WIRING/LIGHTING", "length": 255, "domain": null }, { "name": "lost", "type": "esriFieldTypeString", "alias": "LOST OF ANY KIND", "length": 255, "domain": null }, { "name": "signage", "type": "esriFieldTypeString", "alias": "SIGNAGE (Erected, painted, or otherwise displayed)", "length": 255, "domain": null }, { "name": "components", "type": "esriFieldTypeString", "alias": "AIRCRAFT/AIRCRAFT COMPONENTS SUSPENDED OR LIFTED", "length": 255, "domain": null }, { "name": "misc", "type": "esriFieldTypeString", "alias": "MISC", "length": 255, "domain": null }, { "name": "overall_condition", "type": "esriFieldTypeString", "alias": "OVERALL T-HANGAR CONDITION", "length": 255, "domain": null }, { "name": "reinspection_yn", "type": "esriFieldTypeString", "alias": "REINSPECTION REQUIRED", "length": 3, "domain": { "type": "codedValue", "name": "cvd_reinspection_yn", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "reinspection_date_time", "type": "esriFieldTypeDate", "alias": "REINSPECTION DATE", "length": 8, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "inspector_signature", "type": "esriFieldTypeString", "alias": "INSPECTOR'S SIGNATURE", "length": 255, "domain": null }, { "name": "tenant_signature", "type": "esriFieldTypeString", "alias": "TENANT'S SIGNATURE", "length": 255, "domain": null }, { "name": "THangarGUID", "type": "esriFieldTypeGUID", "alias": "THangarGUID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "CREATED USER", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "CREATED DATE", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "LAST EDITOR", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "LAST EDITED DATE", "length": 8, "domain": null } ], "indexes": [ { "name": "R2850_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2850", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a6b51cf8deb34562b26f2e906517b03a" }