View In:   ArcGIS Online Map Viewer

Name: COLEGEODEV.DBO.NetworkStructure

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 6208836.169146463
YMin: 2170632.6744658947
XMax: 6266960.683802724
YMax: 2205437.4916671515
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assettype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 4
  Label: Collar
  Description: N/A
  Symbol:
  
• Value: 1
  Label: DiversionStructure
  Description: N/A
  Symbol:
  
• Value: 3
  Label: EnergyDissipator
  Description: N/A
  Symbol:
  
• Value: 6
  Label: GradeBreak
  Description: N/A
  Symbol:
  
• Value: 5
  Label: JunctionStructure
  Description: N/A
  Symbol:
  
• Value: 7
  Label: JunctionStructureWManhole
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Outlet
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Plug
  Description: N/A
  Symbol:
  
• Value: 19
  Label: Rip-Rap
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Riser
  Description: N/A
  Symbol:
  
• Value: 17
  Label: RiserWCatchBasin
  Description: N/A
  Symbol:
  
• Value: 18
  Label: Stormcepter
  Description: N/A
  Symbol:
  
• Value: 16
  Label: TransitionStructure
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

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

Type ID Field: assettype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: true, defaultValue: null, modelName: assettype , Coded Values: [0: Unknown] , [3: EnergyDissipator] , [5: JunctionStructure] , ...10 more... )
• globalid ( type: esriFieldTypeGUID, alias: Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: globalid )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: ownedby , Coded Values: [1: Our Agency] , [100: Other] , [2: Private] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: maintby , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation , Range: [0, 359] )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Life Cycle Status, editable: true, nullable: true, defaultValue: null, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Proposed - Approved] , ...4 more... )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• NAME ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NAME )
• OPDATE ( type: esriFieldTypeDate, alias: Operational Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OPDATE )
• STRUCTTYPE ( type: esriFieldTypeString, alias: Structure Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STRUCTTYPE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: ENABLED )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: null, modelName: AncillaryRole )
• FeatureType ( type: esriFieldTypeString, alias: FeatureType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FeatureType )
• FeatureID ( type: esriFieldTypeString, alias: FeatureID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeatureID )
• Asbuilt ( type: esriFieldTypeSmallInteger, alias: Asbuilt, editable: true, nullable: true, defaultValue: null, modelName: Asbuilt )
• Barcode ( type: esriFieldTypeString, alias: Barcode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Barcode )
• SheetNo ( type: esriFieldTypeString, alias: SheetNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SheetNo )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Owner )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Source )
• GridNo ( type: esriFieldTypeString, alias: GridNo, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GridNo )
• LaserFiche_Scan_No ( type: esriFieldTypeString, alias: LaserFiche_Scan_No, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LaserFiche_Scan_No )
• DigitizedMethod ( type: esriFieldTypeSmallInteger, alias: DigitizedMethod, editable: true, nullable: true, defaultValue: null, modelName: DigitizedMethod )
• Outflow_Invert ( type: esriFieldTypeDouble, alias: Outflow_Invert, editable: true, nullable: true, defaultValue: null, modelName: Outflow_Invert )
• DwgNo ( type: esriFieldTypeString, alias: DwgNo, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DwgNo )
• DesignFlowRate ( type: esriFieldTypeDouble, alias: DesignFlowRate, editable: true, nullable: true, defaultValue: null, modelName: DesignFlowRate )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Remarks )
• NetworkStructureType ( type: esriFieldTypeInteger, alias: NetworkStructureType, editable: true, nullable: true, defaultValue: null, modelName: NetworkStructureType )

Types:

ID: 4
Name: Collar
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Collar
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 4
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: DiversionStructure
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: DiversionStructure
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 1
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: EnergyDissipator
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  Remarks: null
  NetworkStructureType: null
  assettype: 3
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: GradeBreak
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: GradeBreak
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 6
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: JunctionStructure
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: JunctionStructure
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 5
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: JunctionStructureWManhole
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: JunctionStructureWManhole
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 7
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Outlet
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Outlet
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 2
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Plug
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Plug
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 8
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 19
Name: Rip-Rap
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Rip-Rap
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 19
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 12
Name: Riser
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Riser
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 12
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 17
Name: RiserWCatchBasin
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: RiserWCatchBasin
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 17
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 18
Name: Stormcepter
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: Stormcepter
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 18
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 16
Name: TransitionStructure
Domains:
• assettype:
  Inherited
• ownedby:
  Inherited
• maintby:
  Inherited
• symbolrotation:
  Inherited
• lifecyclestatus:
  Inherited
Templates:
• Name: TransitionStructure
  Description:
  Prototype:
  NetworkStructureType: null
  assettype: 16
  globalid: null
  installdate: null
  ownedby: null
  maintby: null
  symbolrotation: null
  assetid: null
  lifecyclestatus: null
  created_date: null
  created_user: null
  last_edited_date: null
  last_edited_user: null
  FACILITYID: null
  LOCDESC: null
  ROTATION: null
  NAME: null
  OPDATE: null
  STRUCTTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  AncillaryRole: null
  FeatureType: null
  FeatureID: null
  Asbuilt: null
  Barcode: null
  SheetNo: null
  Owner: null
  Status: null
  Source: null
  GridNo: null
  LaserFiche_Scan_No: null
  DigitizedMethod: null
  Outflow_Invert: null
  DwgNo: null
  DesignFlowRate: null
  Remarks: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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