Name: RALEIGH.PRAQ_AQUA

Display Field: ASSET_TYPE

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSET_TYPE_SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type Subtype )
• ASSET_TYPE ( type: esriFieldTypeString, alias: Asset Type, length: 50 )
• ASSET_TAG ( type: esriFieldTypeString, alias: Asset Tag, length: 20 )
• SITE ( type: esriFieldTypeString, alias: Site, length: 50 , Coded Values: [301 Building: 301 Building] , [310 W. Martin: 310 W. Martin] , [Alexander: Alexander] , ...261 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, length: 50 )
• LEGACYID ( type: esriFieldTypeString, alias: Address, length: 50 )
• FLOOR ( type: esriFieldTypeString, alias: Floor, length: 20 , Coded Values: [Basement: Basement] , [1st Floor: 1st Floor] , [2nd Floor: 2nd Floor] , ...12 more... )
• ROOM_TYPE ( type: esriFieldTypeString, alias: Room Type, length: 50 , Coded Values: [Attic: Attic] , [Break Room: Break Room] , [Classroom: Classroom] , ...43 more... )
• ROOM_ID ( type: esriFieldTypeString, alias: Room ID, length: 20 )
• MAKE ( type: esriFieldTypeString, alias: Make, length: 50 )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 50 )
• SN ( type: esriFieldTypeString, alias: Serial Number, length: 50 )
• TYPE ( type: esriFieldTypeString, alias: Type, length: 50 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• FACILITYID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• EXISTING ( type: esriFieldTypeString, alias: Existing, length: 20 , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 250 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• FO_ASSET_ID ( type: esriFieldTypeString, alias: FO_ASSET_ID, length: 20 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Relationships:

• CITYW_BUILDINGS (6) -- Related To: Buildings (3)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata