View In:   ArcGIS Online Map Viewer

Name: Assault

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7f85b629a4dc472196b37305221ebf30

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: -8235452.323715891
YMin: 5276548.718321045
XMax: -8225732.275066061
YMax: 5287154.882120774
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• ObjectID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: ObjectID )
• Loc_name ( type: esriFieldTypeString, alias: Loc_name, editable: true, nullable: true, length: 14, defaultValue: null, modelName: Loc_name )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Status, required: true )
• Score ( type: esriFieldTypeDouble, alias: Score, editable: true, nullable: true, defaultValue: null, modelName: Score, required: true )
• Match_type ( type: esriFieldTypeString, alias: Match_type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Match_type )
• Match_addr ( type: esriFieldTypeString, alias: Match_addr, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Match_addr, required: true )
• LongLabel ( type: esriFieldTypeString, alias: LongLabel, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LongLabel )
• ShortLabel ( type: esriFieldTypeString, alias: ShortLabel, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ShortLabel )
• Addr_type ( type: esriFieldTypeString, alias: Addr_type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Addr_type )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• PlaceName ( type: esriFieldTypeString, alias: PlaceName, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PlaceName )
• Place_addr ( type: esriFieldTypeString, alias: Place_addr, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Place_addr )
• Phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Phone )
• URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 250, defaultValue: null, modelName: URL )
• Rank ( type: esriFieldTypeDouble, alias: Rank, editable: true, nullable: true, defaultValue: null, modelName: Rank )
• AddBldg ( type: esriFieldTypeString, alias: BuildingName, editable: true, nullable: true, length: 125, defaultValue: null, modelName: AddBldg )
• AddNum ( type: esriFieldTypeString, alias: AddressNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddNum )
• AddNumFrom ( type: esriFieldTypeString, alias: AddNumFrom, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddNumFrom )
• AddNumTo ( type: esriFieldTypeString, alias: AddNumTo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AddNumTo )
• AddRange ( type: esriFieldTypeString, alias: AddressRange, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AddRange )
• Side ( type: esriFieldTypeString, alias: Side, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Side )
• StPreDir ( type: esriFieldTypeString, alias: StPreDir, editable: true, nullable: true, length: 5, defaultValue: null, modelName: StPreDir )
• StPreType ( type: esriFieldTypeString, alias: StPreType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StPreType )
• StName ( type: esriFieldTypeString, alias: StName, editable: true, nullable: true, length: 125, defaultValue: null, modelName: StName )
• StType ( type: esriFieldTypeString, alias: StType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: StType )
• StDir ( type: esriFieldTypeString, alias: StDir, editable: true, nullable: true, length: 20, defaultValue: null, modelName: StDir )
• BldgType ( type: esriFieldTypeString, alias: BldgType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BldgType )
• BldgName ( type: esriFieldTypeString, alias: BldgName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BldgName )
• LevelType ( type: esriFieldTypeString, alias: LevelType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LevelType )
• LevelName ( type: esriFieldTypeString, alias: LevelName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LevelName )
• UnitType ( type: esriFieldTypeString, alias: UnitType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UnitType )
• UnitName ( type: esriFieldTypeString, alias: UnitName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UnitName )
• SubAddr ( type: esriFieldTypeString, alias: SubAddress, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SubAddr )
• StAddr ( type: esriFieldTypeString, alias: StAddr, editable: true, nullable: true, length: 300, defaultValue: null, modelName: StAddr )
• Block ( type: esriFieldTypeString, alias: Block, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Block )
• Sector ( type: esriFieldTypeString, alias: Sector, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Sector )
• Nbrhd ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Nbrhd )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 120, defaultValue: null, modelName: District )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 120, defaultValue: null, modelName: City )
• MetroArea ( type: esriFieldTypeString, alias: MetroArea, editable: true, nullable: true, length: 120, defaultValue: null, modelName: MetroArea )
• Subregion ( type: esriFieldTypeString, alias: Subregion, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Subregion )
• Region ( type: esriFieldTypeString, alias: Region, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Region )
• RegionAbbr ( type: esriFieldTypeString, alias: RegionAbbr, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RegionAbbr )
• Territory ( type: esriFieldTypeString, alias: Territory, editable: true, nullable: true, length: 120, defaultValue: null, modelName: Territory )
• Zone ( type: esriFieldTypeString, alias: Zone, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Zone )
• Postal ( type: esriFieldTypeString, alias: Postal, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Postal )
• PostalExt ( type: esriFieldTypeString, alias: PostalExt, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PostalExt )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Country )
• CntryName ( type: esriFieldTypeString, alias: CountryName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CntryName )
• LangCode ( type: esriFieldTypeString, alias: LangCode, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LangCode )
• Distance ( type: esriFieldTypeDouble, alias: Distance, editable: true, nullable: true, defaultValue: null, modelName: Distance )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• DisplayX ( type: esriFieldTypeDouble, alias: DisplayX, editable: true, nullable: true, defaultValue: null, modelName: DisplayX )
• DisplayY ( type: esriFieldTypeDouble, alias: DisplayY, editable: true, nullable: true, defaultValue: null, modelName: DisplayY )
• Xmin ( type: esriFieldTypeDouble, alias: Xmin, editable: true, nullable: true, defaultValue: null, modelName: Xmin )
• Xmax ( type: esriFieldTypeDouble, alias: Xmax, editable: true, nullable: true, defaultValue: null, modelName: Xmax )
• Ymin ( type: esriFieldTypeDouble, alias: Ymin, editable: true, nullable: true, defaultValue: null, modelName: Ymin )
• Ymax ( type: esriFieldTypeDouble, alias: Ymax, editable: true, nullable: true, defaultValue: null, modelName: Ymax )
• ExInfo ( type: esriFieldTypeString, alias: ExtraInfo, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ExInfo )
• IN_SingleLine ( type: esriFieldTypeString, alias: Single Line Input, editable: true, nullable: true, length: 100, defaultValue: , modelName: IN_SingleLine )
• USER_agency ( type: esriFieldTypeString, alias: agency, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_agency )
• USER_ocbeg_dt ( type: esriFieldTypeDate, alias: ocbeg_dt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_ocbeg_dt )
• USER_ocen_dt ( type: esriFieldTypeDate, alias: ocen_dt, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_ocen_dt )
• USER_occbegti ( type: esriFieldTypeString, alias: occbegti, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_occbegti )
• USER_timeofc ( type: esriFieldTypeInteger, alias: timeofc, editable: true, nullable: true, defaultValue: null, modelName: USER_timeofc )
• USER_occenti ( type: esriFieldTypeString, alias: occenti, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_occenti )
• USER_rep_stam ( type: esriFieldTypeDate, alias: rep_stam, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_rep_stam )
• USER_rep_tm ( type: esriFieldTypeString, alias: rep_tm, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_rep_tm )
• USER_calltype ( type: esriFieldTypeInteger, alias: calltype, editable: true, nullable: true, defaultValue: null, modelName: USER_calltype )
• USER_type_de ( type: esriFieldTypeString, alias: type_de, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_type_de )
• USER_crime_de ( type: esriFieldTypeString, alias: crime_de, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_crime_de )
• USER_chargety ( type: esriFieldTypeString, alias: chargety, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_chargety )
• USER_crcldesc ( type: esriFieldTypeString, alias: crcldesc, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_crcldesc )
• USER_nibrs ( type: esriFieldTypeString, alias: nibrs, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_nibrs )
• USER_nibrsdes ( type: esriFieldTypeString, alias: nibrsdes, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_nibrsdes )
• USER_hier ( type: esriFieldTypeDouble, alias: hier, editable: true, nullable: true, defaultValue: null, modelName: USER_hier )
• USER_crcount ( type: esriFieldTypeString, alias: crcount, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_crcount )
• USER_dir ( type: esriFieldTypeString, alias: dir, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_dir )
• USER_zone ( type: esriFieldTypeInteger, alias: zone, editable: true, nullable: true, defaultValue: null, modelName: USER_zone )
• USER_block ( type: esriFieldTypeString, alias: block, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_block )
• USER_cross_st ( type: esriFieldTypeString, alias: cross_st, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_cross_st )
• USER_location ( type: esriFieldTypeString, alias: location, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_location )
• USER_esri ( type: esriFieldTypeString, alias: esri, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_esri )
• USER_loccode ( type: esriFieldTypeInteger, alias: loccode, editable: true, nullable: true, defaultValue: null, modelName: USER_loccode )
• USER_locdesc ( type: esriFieldTypeString, alias: locdesc, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_locdesc )
• USER_statdesc ( type: esriFieldTypeString, alias: statdesc, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_statdesc )
• USER_thisweek ( type: esriFieldTypeInteger, alias: thisweek, editable: true, nullable: true, defaultValue: null, modelName: USER_thisweek )
• USER_lastweek ( type: esriFieldTypeInteger, alias: lastweek, editable: true, nullable: true, defaultValue: null, modelName: USER_lastweek )
• USER_thismonth ( type: esriFieldTypeInteger, alias: thismonth, editable: true, nullable: true, defaultValue: null, modelName: USER_thismonth )
• USER_lastmonth ( type: esriFieldTypeInteger, alias: lastmonth, editable: true, nullable: true, defaultValue: null, modelName: USER_lastmonth )
• USER_thisyear ( type: esriFieldTypeInteger, alias: thisyear, editable: true, nullable: true, defaultValue: null, modelName: USER_thisyear )
• USER_lastyear ( type: esriFieldTypeInteger, alias: lastyear, editable: true, nullable: true, defaultValue: null, modelName: USER_lastyear )
• USER_lastyear_month ( type: esriFieldTypeInteger, alias: lastyear_month, editable: true, nullable: true, defaultValue: null, modelName: USER_lastyear_month )
• USER_end_date ( type: esriFieldTypeDate, alias: end_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_end_date )
• USER_thisweek_beg ( type: esriFieldTypeDate, alias: thisweek_beg, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_thisweek_beg )
• USER_lastweek_end ( type: esriFieldTypeDate, alias: lastweek_end, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_lastweek_end )
• USER_lastweek_beg ( type: esriFieldTypeDate, alias: lastweek_beg, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_lastweek_beg )
• USER_thismonth_beg ( type: esriFieldTypeDate, alias: thismonth_beg, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_thismonth_beg )
• USER_lastmonth_beg ( type: esriFieldTypeDate, alias: lastmonth_beg, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_lastmonth_beg )
• USER_lastmonth_end ( type: esriFieldTypeDate, alias: lastmonth_end, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_lastmonth_end )
• USER_lyear_end ( type: esriFieldTypeDate, alias: lyear_end, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_lyear_end )
• USER_lyear_monthbegin ( type: esriFieldTypeDate, alias: lyear_monthbegin, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_lyear_monthbegin )
• USER_Beg2016 ( type: esriFieldTypeDate, alias: Beg2016, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_Beg2016 )
• USER_End2016 ( type: esriFieldTypeDate, alias: End2016, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_End2016 )
• USER_Beg2017 ( type: esriFieldTypeDate, alias: Beg2017, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_Beg2017 )
• USER_End2017 ( type: esriFieldTypeDate, alias: End2017, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_End2017 )
• USER_Beg2018 ( type: esriFieldTypeDate, alias: Beg2018, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_Beg2018 )
• USER_End2018 ( type: esriFieldTypeDate, alias: End2018, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_End2018 )
• USER_Beg2019 ( type: esriFieldTypeDate, alias: Beg2019, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_Beg2019 )
• USER_End2019 ( type: esriFieldTypeDate, alias: End2019, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_End2019 )
• USER_Beg2022 ( type: esriFieldTypeDate, alias: Beg2022, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_Beg2022 )
• USER_End2022 ( type: esriFieldTypeDate, alias: End2022, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USER_End2022 )
• USER_murder ( type: esriFieldTypeInteger, alias: murder, editable: true, nullable: true, defaultValue: null, modelName: USER_murder )
• USER_negmurd ( type: esriFieldTypeInteger, alias: negmurd, editable: true, nullable: true, defaultValue: null, modelName: USER_negmurd )
• USER_assault ( type: esriFieldTypeInteger, alias: assault, editable: true, nullable: true, defaultValue: null, modelName: USER_assault )
• USER_rape ( type: esriFieldTypeInteger, alias: rape, editable: true, nullable: true, defaultValue: null, modelName: USER_rape )
• USER_robbery ( type: esriFieldTypeInteger, alias: robbery, editable: true, nullable: true, defaultValue: null, modelName: USER_robbery )
• USER_burglary ( type: esriFieldTypeInteger, alias: burglary, editable: true, nullable: true, defaultValue: null, modelName: USER_burglary )
• USER_larceny ( type: esriFieldTypeInteger, alias: larceny, editable: true, nullable: true, defaultValue: null, modelName: USER_larceny )
• USER_mvtheft ( type: esriFieldTypeInteger, alias: mvtheft, editable: true, nullable: true, defaultValue: null, modelName: USER_mvtheft )
• USER_arson ( type: esriFieldTypeInteger, alias: arson, editable: true, nullable: true, defaultValue: null, modelName: USER_arson )
• USER_type ( type: esriFieldTypeString, alias: type, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_type )
• USER_platoon ( type: esriFieldTypeInteger, alias: platoon, editable: true, nullable: true, defaultValue: null, modelName: USER_platoon )
• USER_new_type ( type: esriFieldTypeString, alias: new_type, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_new_type )
• USER_nmonth ( type: esriFieldTypeInteger, alias: nmonth, editable: true, nullable: true, defaultValue: null, modelName: USER_nmonth )
• USER_nyear ( type: esriFieldTypeInteger, alias: nyear, editable: true, nullable: true, defaultValue: null, modelName: USER_nyear )
• USER_neighborhood ( type: esriFieldTypeString, alias: neighborhood, editable: true, nullable: true, length: 8000, defaultValue: , modelName: USER_neighborhood )

Templates:

• Name: Assault
  Description:
  Prototype:
  USER_nyear: null
  Loc_name: null
  Status: null
  Score: null
  Match_type: null
  Match_addr: null
  LongLabel: null
  ShortLabel: null
  Addr_type: null
  Type: null
  PlaceName: null
  Place_addr: null
  Phone: null
  URL: null
  Rank: null
  AddBldg: null
  AddNum: null
  AddNumFrom: null
  AddNumTo: null
  AddRange: null
  Side: null
  StPreDir: null
  StPreType: null
  StName: null
  StType: null
  StDir: null
  BldgType: null
  BldgName: null
  LevelType: null
  LevelName: null
  UnitType: null
  UnitName: null
  SubAddr: null
  StAddr: null
  Block: null
  Sector: null
  Nbrhd: null
  District: null
  City: null
  MetroArea: null
  Subregion: null
  Region: null
  RegionAbbr: null
  Territory: null
  Zone: null
  Postal: null
  PostalExt: null
  Country: null
  CntryName: null
  LangCode: null
  Distance: null
  X: null
  Y: null
  DisplayX: null
  DisplayY: null
  Xmin: null
  Xmax: null
  Ymin: null
  Ymax: null
  ExInfo: null
  IN_SingleLine:
  USER_agency:
  USER_ocbeg_dt: null
  USER_ocen_dt: null
  USER_occbegti:
  USER_timeofc: null
  USER_occenti:
  USER_rep_stam: null
  USER_rep_tm:
  USER_calltype: null
  USER_type_de:
  USER_crime_de:
  USER_chargety:
  USER_crcldesc:
  USER_nibrs:
  USER_nibrsdes:
  USER_hier: null
  USER_crcount:
  USER_dir:
  USER_zone: null
  USER_block:
  USER_cross_st:
  USER_location:
  USER_esri:
  USER_loccode: null
  USER_locdesc:
  USER_statdesc:
  USER_thisweek: null
  USER_lastweek: null
  USER_thismonth: null
  USER_lastmonth: null
  USER_thisyear: null
  USER_lastyear: null
  USER_lastyear_month: null
  USER_end_date: null
  USER_thisweek_beg: null
  USER_lastweek_end: null
  USER_lastweek_beg: null
  USER_thismonth_beg: null
  USER_lastmonth_beg: null
  USER_lastmonth_end: null
  USER_lyear_end: null
  USER_lyear_monthbegin: null
  USER_Beg2016: null
  USER_End2016: null
  USER_Beg2017: null
  USER_End2017: null
  USER_Beg2018: null
  USER_End2018: null
  USER_Beg2019: null
  USER_End2019: null
  USER_Beg2022: null
  USER_End2022: null
  USER_murder: null
  USER_negmurd: null
  USER_assault: null
  USER_rape: null
  USER_robbery: null
  USER_burglary: null
  USER_larceny: null
  USER_mvtheft: null
  USER_arson: null
  USER_type:
  USER_platoon: null
  USER_new_type:
  USER_nmonth: null
  USER_neighborhood:
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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

Child Resources:

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