Name: RALEIGH.PRAQ_SAFE

Display Field: ASSET_TYPE

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
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSET_TYPE_SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type Subtype, editable: true, nullable: true, defaultValue: 0, modelName: Asset_Type_Subtype )
• ASSET_TYPE ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Asset_Type )
• ASSET_TAG ( type: esriFieldTypeString, alias: Asset Tag, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Asset_Tag )
• SITE ( type: esriFieldTypeString, alias: Site, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Site , Coded Values: [301 Building: 301 Building] , [310 W. Martin: 310 W. Martin] , [Alexander: Alexander] , ...261 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Location )
• LEGACYID ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• FLOOR ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Floor , Coded Values: [Basement: Basement] , [1st Floor: 1st Floor] , [2nd Floor: 2nd Floor] , ...12 more... )
• ROOM_TYPE ( type: esriFieldTypeString, alias: Room Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Room_Type , Coded Values: [Attic: Attic] , [Break Room: Break Room] , [Classroom: Classroom] , ...43 more... )
• ROOM_ID ( type: esriFieldTypeString, alias: Room ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Room_ID )
• MAKE ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Make )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• CERTIFICATION_DATE ( type: esriFieldTypeDate, alias: Certification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Certification_Date )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• INSTALL_CONTRACTOR ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Install_Contractor )
• LIFECYCLE_YRS ( type: esriFieldTypeString, alias: Lifecycle Yrs, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lifecycle_Yrs )
• SIZE_ ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Size_ )
• WEIGHT ( type: esriFieldTypeString, alias: Weight, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Weight )
• FACILITYID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: FacilityID )
• EXISTING ( type: esriFieldTypeString, alias: Existing, editable: true, nullable: false, length: 20, defaultValue: Yes, modelName: Existing , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• 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_EDITED_USER, 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 )
• FO_ASSET_ID ( type: esriFieldTypeString, alias: FO_ASSET_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FO_ASSET_ID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: RALEIGH.PRAQ_SAFE
  Description:
  Prototype:
  FO_ASSET_ID: null
  LAST_EDITED_DATE: null
  ASSET_TYPE_SUBTYPE: 0
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  NOTES: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Update,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   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata