Name: Mechanical

Display Field: AssetName

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Asset_ID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_ID )
• Location_Desc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location_Desc )
• Install_Date ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Model )
• Serial_Number ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Serial_Number )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Manufacturer )
• Size ( type: esriFieldTypeDouble, alias: Size, editable: true, nullable: true, defaultValue: null, modelName: Size )
• Warranty_Date ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Warranty_Date )
• Condition ( type: esriFieldTypeInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition )
• Condition_Date ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Condition_Date )
• Image_File ( type: esriFieldTypeString, alias: Image, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Image_File )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• AssetType ( type: esriFieldTypeString, alias: AssetType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetType , Coded Values: [AC: A/C Unit] , [AHU: AHU] , [AQ: Air Quality] , ...59 more... )
• ParentID ( type: esriFieldTypeString, alias: ParentID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ParentID , Coded Values: [CES: Carrboro Elementary School] , [CCB: Century Center Building] , [FS1: Fire Station 1] , ...35 more... )
• AssetName ( type: esriFieldTypeString, alias: AssetName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AssetName )
• AssetStatus ( type: esriFieldTypeString, alias: AssetStatus, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetStatus , Coded Values: [ACT: Active] , [ABD: Abandoned] , [DIS: Disposed] , ...1 more... )
• SizeUnit ( type: esriFieldTypeString, alias: SizeUnit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SizeUnit , Coded Values: [in: Inches] , [ft: Feet] , [yd: Yards] , ...20 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Location ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location )

Templates:

• Name: Mechanical
  Description:
  Prototype:
  Location: null
  SizeUnit: null
  Asset_ID: null
  Location_Desc: null
  Install_Date: null
  Model: null
  Serial_Number: null
  Manufacturer: null
  Size: null
  Warranty_Date: null
  Condition: null
  Condition_Date: null
  Image_File: null
  Comments: null
  AssetType: null
  ParentID: null
  AssetName: null
  AssetStatus: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Buildings (7) -- Related To: Buildings (22)
• Parks (21) -- Related To: Parks (20)
• ParkingLots (13) -- Related To: Parking Lots (21)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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