Name: ArcSDE.SDE.T_Hangar_Inspections

Display Field: t_hangar_no

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f9c4448eb3f9496887df89327e357b3b

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• inspection_date_time ( type: esriFieldTypeDate, alias: INSPECTION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inspection_date )
• t_hangar_no ( type: esriFieldTypeString, alias: T-HANGAR No, editable: true, nullable: true, length: 255, defaultValue: null, modelName: t_hangar_no )
• authority_lock ( type: esriFieldTypeString, alias: AUTHORITY LOCK, editable: true, nullable: true, length: 3, defaultValue: null, modelName: authority_lock , Coded Values: [yes: Yes] , [no: No] )
• aircraft_no_on_lease ( type: esriFieldTypeString, alias: AIRCRAFT No ON LEASE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: aircraft_no_on_lease )
• aircraft_no_in_hangar ( type: esriFieldTypeString, alias: AIRCRAFT No IN HANGAR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: aircraft_no_in_hangar )
• current_lease ( type: esriFieldTypeString, alias: CURRENT LEASE ON FILE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: current_lease , Coded Values: [yes: Yes] , [no: No] )
• ext_physical_damage ( type: esriFieldTypeString, alias: PHYSICAL DAMAGE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ext_physical_damage )
• ext_debris ( type: esriFieldTypeString, alias: DEBRIS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ext_debris )
• ext_storage ( type: esriFieldTypeString, alias: STORAGE OF CARS, TRAILERS, BOATS, ETC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ext_storage )
• ext_alt_add_improv ( type: esriFieldTypeString, alias: ALTERATIONS, ADDITIONS, IMPROVEMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ext_alt_add_improv )
• int_physical_damage ( type: esriFieldTypeString, alias: PHYSICAL DAMAGE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: int_physical_damage )
• int_debris ( type: esriFieldTypeString, alias: DEBRIS (Boxes, crates, rubbish, paper, rags, waste, etc.):, editable: true, nullable: true, length: 255, defaultValue: null, modelName: int_debris )
• floors_conditions ( type: esriFieldTypeString, alias: FLOORS CLEAN OF OIL, GREASE & TOXIC CHEMICALS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: floors_conditions )
• storage_materials ( type: esriFieldTypeString, alias: STORAGE OF HAZARDOUS OR FLAMMABLE MATERIALS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: storage_materials )
• storage_batteries ( type: esriFieldTypeString, alias: STORAGE OF BATTERIES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: storage_batteries )
• fire_extinguisher ( type: esriFieldTypeString, alias: 20 lb. DRY CHEMICAL FIRE EXTINGUISHER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: fire_extinguisher )
• signs_spraying ( type: esriFieldTypeString, alias: SIGNS OF PAINTING/PAINT SPRAYING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signs_spraying )
• signs_smoking ( type: esriFieldTypeString, alias: SIGNS OF SMOKING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signs_smoking )
• signs_automobile ( type: esriFieldTypeString, alias: SIGNS OF AUTOMOBILE SERVICING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: signs_automobile )
• sign_activity ( type: esriFieldTypeString, alias: SIGNS OF COMMERCIAL ACTIVITY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sign_activity )
• alt_add_improv ( type: esriFieldTypeString, alias: ALTERATIONS, ADDITIONS, IMPROVEMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: alt_add_improv )
• wiring_lighting ( type: esriFieldTypeString, alias: ADDITIONAL WIRING/LIGHTING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: wiring_lighting )
• lost ( type: esriFieldTypeString, alias: LOST OF ANY KIND, editable: true, nullable: true, length: 255, defaultValue: null, modelName: lofts )
• signage ( type: esriFieldTypeString, alias: SIGNAGE (Erected, painted, or otherwise displayed), editable: true, nullable: true, length: 255, defaultValue: null, modelName: signage )
• components ( type: esriFieldTypeString, alias: AIRCRAFT/AIRCRAFT COMPONENTS SUSPENDED OR LIFTED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: components )
• misc ( type: esriFieldTypeString, alias: MISC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: misc )
• overall_condition ( type: esriFieldTypeString, alias: OVERALL T-HANGAR CONDITION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: overall_condition )
• reinspection_yn ( type: esriFieldTypeString, alias: REINSPECTION REQUIRED, editable: true, nullable: true, length: 3, defaultValue: null, modelName: reinspection_yn , Coded Values: [yes: Yes] , [no: No] )
• reinspection_date_time ( type: esriFieldTypeDate, alias: REINSPECTION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: reinspection_date )
• comments ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: comments )
• inspector_signature ( type: esriFieldTypeString, alias: INSPECTOR'S SIGNATURE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspector_signature )
• tenant_signature ( type: esriFieldTypeString, alias: TENANT'S SIGNATURE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tenant_signature )
• THangarGUID ( type: esriFieldTypeGUID, alias: THangarGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: THangarGUID )
• created_user ( type: esriFieldTypeString, alias: CREATED USER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: CREATED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: LAST EDITOR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: LAST EDITED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: ArcSDE.SDE.T_Hangar_Inspections
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata