View In:   ArcGIS Online Map Viewer

Name: SDG Civic Address (911)

Display Field: Name_Twp

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 455ac0cf51324b88b1f4445c8ba1d23d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: -8414972.991
YMin: 5590337.366999999
XMax: -8275903.380000001
YMax: 5700198.324600004
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: EmilyProj
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [204, 204, 204, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: No
  Label: No
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 0, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 92, 230, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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

Type ID Field: EmilyProj

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Unique_ID ( type: esriFieldTypeString, alias: Unique_ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Unique_ID )
• SDGCivicID ( type: esriFieldTypeInteger, alias: SDGCivicID, editable: true, nullable: true, defaultValue: null, modelName: SDGCivicID )
• Address_Nu ( type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Address_Nu )
• Civic_Num ( type: esriFieldTypeInteger, alias: Civic Number, editable: true, nullable: true, defaultValue: null, modelName: Civic_Num )
• UnitNum ( type: esriFieldTypeString, alias: Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UnitNum )
• Unit_Type ( type: esriFieldTypeString, alias: Unit Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Unit_Type , Coded Values: [apartment: apartment] , [condo: condo] , [duplex: duplex] , ...5 more... )
• Street_Nam ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 80, defaultValue: null, modelName: Street_Nam )
• StrNamAlia ( type: esriFieldTypeString, alias: Street Name Alias, editable: true, nullable: true, length: 60, defaultValue: null, modelName: StrNamAlia )
• Settlement ( type: esriFieldTypeString, alias: Settlement, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Settlement , Coded Values: [Alexandria: Alexandria] , [Apple Hill: Apple Hill] , [Ault Island: Ault Island] , ...69 more... )
• Municipali ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 80, defaultValue: null, modelName: Municipali , Coded Values: [North Dundas: North Dundas] , [North Glengarry: North Glengarry] , [North Stormont: North Stormont] , ...3 more... )
• Label ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Label )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Comments )
• MPACCorrec ( type: esriFieldTypeString, alias: MPAC Correction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MPACCorrec )
• SDG_Verif ( type: esriFieldTypeString, alias: SDG Verified, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SDG_Verif )
• VerifDate ( type: esriFieldTypeDate, alias: Verif Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: VerifDate )
• Parcel_Com ( type: esriFieldTypeString, alias: Parcel Comment, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Parcel_Com )
• AddDate ( type: esriFieldTypeDate, alias: Add Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AddDate )
• EditDesc ( type: esriFieldTypeString, alias: Edit Description, editable: true, nullable: true, length: 254, defaultValue: null, modelName: EditDesc )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• ToBeGPS ( type: esriFieldTypeString, alias: To Be GPSed, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ToBeGPS , Coded Values: [check - Google: check - Google] , [yes: yes] , [yes - hp: yes - hp] , ...1 more... )
• GPSCompl ( type: esriFieldTypeString, alias: GPS Completed, editable: true, nullable: true, length: 30, defaultValue: null, modelName: GPSCompl )
• JOINID ( type: esriFieldTypeInteger, alias: JOINID, editable: true, nullable: true, defaultValue: null, modelName: JOINID )
• StrNmFul ( type: esriFieldTypeString, alias: Street Name Full, editable: true, nullable: true, length: 80, defaultValue: null, modelName: StrNmFul )
• StrAlsFul ( type: esriFieldTypeString, alias: Street Alias Full, editable: true, nullable: true, length: 60, defaultValue: null, modelName: StrAlsFul )
• CrysMain ( type: esriFieldTypeString, alias: Crisys Main, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CrysMain )
• CrysAlias ( type: esriFieldTypeString, alias: Crisys Alias, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CrysAlias )
• CrysMainF ( type: esriFieldTypeString, alias: Crisys Main Full, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CrysMainF )
• CrysAlia_F ( type: esriFieldTypeString, alias: Crisys Alias Full, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CrysAlia_F )
• LabelFull ( type: esriFieldTypeString, alias: Label Full, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LabelFull )
• OPPBellPri ( type: esriFieldTypeString, alias: OPP Bell PRIMARY NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPPBellPri )
• OPPBellAli ( type: esriFieldTypeString, alias: OPP Bell ALIAS NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPPBellAli )
• Name_Twp ( type: esriFieldTypeString, alias: Name Twp, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Name_Twp )
• AddressTmp ( type: esriFieldTypeString, alias: Address Temp, editable: true, nullable: true, length: 150, defaultValue: null, modelName: AddressTmp )
• EditFlagTm ( type: esriFieldTypeString, alias: Edit Flag Temp, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EditFlagTm )
• OPPBell_ST ( type: esriFieldTypeString, alias: OPP Bell STREET NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPPBell_ST )
• OPPBell__1 ( type: esriFieldTypeString, alias: OPP Bell STREET TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: OPPBell__1 )
• OPPBell__2 ( type: esriFieldTypeString, alias: OPP Bell STREET DIRECTION, editable: true, nullable: true, length: 1, defaultValue: null, modelName: OPPBell__2 )
• OPPBell_Al ( type: esriFieldTypeString, alias: OPP Bell Alias STREET NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPPBell_Al )
• OPPBell__3 ( type: esriFieldTypeString, alias: OPP Bell STREET TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: OPPBell__3 )
• OPPBell__4 ( type: esriFieldTypeString, alias: OPP Bell STREET DIRECTION, editable: true, nullable: true, length: 1, defaultValue: null, modelName: OPPBell__4 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• GoogleLabe ( type: esriFieldTypeString, alias: Google Label, editable: true, nullable: true, length: 254, defaultValue: null, modelName: GoogleLabe )
• GlobalID_3 ( type: esriFieldTypeGlobalID, alias: GlobalID_3, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_3 )
• EmilyProj ( type: esriFieldTypeString, alias: Emily Project, editable: true, nullable: true, length: 3, defaultValue: null, modelName: EmilyProj , Coded Values: [Yes: Yes] , [No: No] )
• DiscrpAgID ( type: esriFieldTypeString, alias: Discrepancy Agency ID, editable: true, nullable: true, length: 75, defaultValue: null, modelName: DiscrpAgID )
• DateUpdate ( type: esriFieldTypeDate, alias: Date Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateUpdate )
• Effective ( type: esriFieldTypeDate, alias: Effective Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Effective )
• Expire ( type: esriFieldTypeDate, alias: Expiration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Expire )
• Site_NGUID ( type: esriFieldTypeString, alias: Site NENA Globally Unique ID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Site_NGUID )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Country , Coded Values: [CA: CA] )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: null, modelName: State )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 40, defaultValue: null, modelName: County )
• AddCode ( type: esriFieldTypeString, alias: Additional Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: AddCode )
• Inc_Muni ( type: esriFieldTypeString, alias: Incorporated Municipality, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Inc_Muni )
• Uninc_Comm ( type: esriFieldTypeString, alias: Unincorporated Community, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Uninc_Comm )
• Nbrhd_Comm ( type: esriFieldTypeString, alias: Neighborhood Community, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Nbrhd_Comm )
• AddNum_Pre ( type: esriFieldTypeString, alias: Address Number Prefix, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AddNum_Pre )
• Add_Number ( type: esriFieldTypeInteger, alias: Address Number, editable: true, nullable: true, defaultValue: null, modelName: Add_Number )
• AddNum_Suf ( type: esriFieldTypeString, alias: Address Number Suffix, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AddNum_Suf )
• St_PreMod ( type: esriFieldTypeString, alias: Street name Pre Modifier, editable: true, nullable: true, length: 15, defaultValue: null, modelName: St_PreMod )
• St_PreDir ( type: esriFieldTypeString, alias: Street Name Pre Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PreDir )
• St_PreTyp ( type: esriFieldTypeString, alias: Street Name Pre Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PreTyp )
• St_PreSep ( type: esriFieldTypeString, alias: Street Name Pre Type Separator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: St_PreSep )
• St_Name ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 60, defaultValue: null, modelName: St_Name )
• St_PosTyp ( type: esriFieldTypeString, alias: Street Name Post Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: St_PosTyp )
• St_PosDir ( type: esriFieldTypeString, alias: Street Name Post Directional, editable: true, nullable: true, length: 9, defaultValue: null, modelName: St_PosDir )
• St_PosMod ( type: esriFieldTypeString, alias: Street Name Post Modifier, editable: true, nullable: true, length: 25, defaultValue: null, modelName: St_PosMod )
• LSt_PreDir ( type: esriFieldTypeString, alias: Legacy Street Name Pre Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LSt_PreDir )
• LSt_Name ( type: esriFieldTypeString, alias: Legacy Street Name, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LSt_Name )
• LSt_Type ( type: esriFieldTypeString, alias: Legacy Street Name Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LSt_Type )
• LSt_PosDir ( type: esriFieldTypeString, alias: Legacy Street Name Post Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LSt_PosDir , Coded Values: [N: North] , [NE: Northeast] , [NW: Northwest] , ...4 more... )
• ESN ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )
• MSAGComm ( type: esriFieldTypeString, alias: MSAG Community Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MSAGComm )
• Post_Comm ( type: esriFieldTypeString, alias: Postal Community Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Post_Comm )
• Post_Code ( type: esriFieldTypeString, alias: Postal Code, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Post_Code )
• Building ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Building )
• Floor ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Floor )
• Unit ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Unit )
• Room ( type: esriFieldTypeString, alias: Room, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Room )
• Seat ( type: esriFieldTypeString, alias: Seat, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Seat )
• Addtl_Loc ( type: esriFieldTypeString, alias: Additional Location Information, editable: true, nullable: true, length: 225, defaultValue: null, modelName: Addtl_Loc )
• LandmkName ( type: esriFieldTypeString, alias: Complete Landmark Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LandmkName )
• Mile_Post ( type: esriFieldTypeString, alias: Milepost, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Mile_Post , Coded Values: [P: Posted] , [L: Logical / Calculated] )
• Place_Type ( type: esriFieldTypeString, alias: Place Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Place_Type )
• Placement ( type: esriFieldTypeString, alias: Placement Method, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Placement , Coded Values: [Geocoding: Geocoding] , [Parcel: Parcel] , [Property Access: Property Access] , ...3 more... )
• Long ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Long )
• Lat ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Lat )
• Elev ( type: esriFieldTypeSmallInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elev )
• Post_Comm1 ( type: esriFieldTypeString, alias: Postal Community Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Post_Comm1 )
• VerifCheck ( type: esriFieldTypeString, alias: Verification Check, editable: true, nullable: true, length: 100, defaultValue: null, modelName: VerifCheck )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: No
Name: No
Domains:
• Unit_Type:
  Inherited
• Settlement:
  Inherited
• Municipali:
  Inherited
• ToBeGPS:
  Inherited
• EmilyProj:
  Inherited
• Country:
  Inherited
• LSt_PosDir:
  Inherited
• Mile_Post:
  Inherited
• Placement:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  Post_Comm1: null
  VerifCheck: null
  Unique_ID: null
  SDGCivicID: null
  Address_Nu: null
  Civic_Num: null
  UnitNum: null
  Unit_Type: null
  Street_Nam: null
  StrNamAlia: null
  Settlement: null
  Municipali: null
  Label: null
  Comments: null
  MPACCorrec: null
  SDG_Verif: null
  VerifDate: null
  Parcel_Com: null
  AddDate: null
  EditDesc: null
  EditDate: null
  ToBeGPS: null
  GPSCompl: null
  JOINID: null
  StrNmFul: null
  StrAlsFul: null
  CrysMain: null
  CrysAlias: null
  CrysMainF: null
  CrysAlia_F: null
  LabelFull: null
  OPPBellPri: null
  OPPBellAli: null
  Name_Twp: null
  AddressTmp: null
  EditFlagTm: null
  OPPBell_ST: null
  OPPBell__1: null
  OPPBell__2: null
  OPPBell_Al: null
  OPPBell__3: null
  OPPBell__4: null
  Latitude: null
  Longitude: null
  GoogleLabe: null
  EmilyProj: No
  DiscrpAgID: null
  DateUpdate: null
  Effective: null
  Expire: null
  Site_NGUID: null
  Country: null
  State: null
  County: null
  AddCode: null
  Inc_Muni: null
  Uninc_Comm: null
  Nbrhd_Comm: null
  AddNum_Pre: null
  Add_Number: null
  AddNum_Suf: null
  St_PreMod: null
  St_PreDir: null
  St_PreTyp: null
  St_PreSep: null
  St_Name: null
  St_PosTyp: null
  St_PosDir: null
  St_PosMod: null
  LSt_PreDir: null
  LSt_Name: null
  LSt_Type: null
  LSt_PosDir: null
  ESN: null
  MSAGComm: null
  Post_Comm: null
  Post_Code: null
  Building: null
  Floor: null
  Unit: null
  Room: null
  Seat: null
  Addtl_Loc: null
  LandmkName: null
  Mile_Post: null
  Place_Type: null
  Placement: null
  Long: null
  Lat: null
  Elev: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Yes
Name: Yes
Domains:
• Unit_Type:
  Inherited
• Settlement:
  Inherited
• Municipali:
  Inherited
• ToBeGPS:
  Inherited
• EmilyProj:
  Inherited
• Country:
  Inherited
• LSt_PosDir:
  Inherited
• Mile_Post:
  Inherited
• Placement:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  Post_Comm1: null
  VerifCheck: null
  Unique_ID: null
  SDGCivicID: null
  Address_Nu: null
  Civic_Num: null
  UnitNum: null
  Unit_Type: null
  Street_Nam: null
  StrNamAlia: null
  Settlement: null
  Municipali: null
  Label: null
  Comments: null
  MPACCorrec: null
  SDG_Verif: null
  VerifDate: null
  Parcel_Com: null
  AddDate: null
  EditDesc: null
  EditDate: null
  ToBeGPS: null
  GPSCompl: null
  JOINID: null
  StrNmFul: null
  StrAlsFul: null
  CrysMain: null
  CrysAlias: null
  CrysMainF: null
  CrysAlia_F: null
  LabelFull: null
  OPPBellPri: null
  OPPBellAli: null
  Name_Twp: null
  AddressTmp: null
  EditFlagTm: null
  OPPBell_ST: null
  OPPBell__1: null
  OPPBell__2: null
  OPPBell_Al: null
  OPPBell__3: null
  OPPBell__4: null
  Latitude: null
  Longitude: null
  GoogleLabe: null
  EmilyProj: Yes
  DiscrpAgID: null
  DateUpdate: null
  Effective: null
  Expire: null
  Site_NGUID: null
  Country: null
  State: null
  County: null
  AddCode: null
  Inc_Muni: null
  Uninc_Comm: null
  Nbrhd_Comm: null
  AddNum_Pre: null
  Add_Number: null
  AddNum_Suf: null
  St_PreMod: null
  St_PreDir: null
  St_PreTyp: null
  St_PreSep: null
  St_Name: null
  St_PosTyp: null
  St_PosDir: null
  St_PosMod: null
  LSt_PreDir: null
  LSt_Name: null
  LSt_Type: null
  LSt_PosDir: null
  ESN: null
  MSAGComm: null
  Post_Comm: null
  Post_Code: null
  Building: null
  Floor: null
  Unit: null
  Room: null
  Seat: null
  Addtl_Loc: null
  LandmkName: null
  Mile_Post: null
  Place_Type: null
  Placement: null
  Long: null
  Lat: null
  Elev: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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