Name: LitterWatchDB.DBO.ItemLookup

Display Field: generalname

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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 )
• pk_itemcode ( type: esriFieldTypeInteger, alias: pk_itemcode, editable: true, nullable: false, defaultValue: null, modelName: pk_itemcode )
• fk_category_id ( type: esriFieldTypeInteger, alias: fk_category_id, editable: true, nullable: true, defaultValue: null, modelName: fk_category_id )
• generalcode ( type: esriFieldTypeString, alias: generalcode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: generalcode )
• level1_materials ( type: esriFieldTypeString, alias: level1_materials, editable: true, nullable: true, length: 255, defaultValue: null, modelName: level1_materials )
• level2_generaluse ( type: esriFieldTypeString, alias: level2_generaluse, editable: true, nullable: true, length: 255, defaultValue: null, modelName: level2_generaluse )
• level3 ( type: esriFieldTypeString, alias: level3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: level3 )
• generalname ( type: esriFieldTypeString, alias: generalname, editable: true, nullable: true, length: 255, defaultValue: null, modelName: generalname )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: description )
• material ( type: esriFieldTypeString, alias: material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: material )
• purpose ( type: esriFieldTypeString, alias: purpose, editable: true, nullable: true, length: 255, defaultValue: null, modelName: purpose )
• usage ( type: esriFieldTypeString, alias: usage, editable: true, nullable: true, length: 255, defaultValue: null, modelName: usage )
• source ( type: esriFieldTypeString, alias: source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: source )
• problem1 ( type: esriFieldTypeString, alias: problem1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: problem1 )
• problem2 ( type: esriFieldTypeString, alias: problem2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: problem2 )
• core ( type: esriFieldTypeInteger, alias: core, editable: true, nullable: true, defaultValue: null, modelName: core )
• beach ( type: esriFieldTypeInteger, alias: beach, editable: true, nullable: true, defaultValue: null, modelName: beach )
• seafloor ( type: esriFieldTypeInteger, alias: seafloor, editable: true, nullable: true, defaultValue: null, modelName: seafloor )
• floating ( type: esriFieldTypeInteger, alias: floating, editable: true, nullable: true, defaultValue: null, modelName: floating )
• biota ( type: esriFieldTypeInteger, alias: biota, editable: true, nullable: true, defaultValue: null, modelName: biota )
• micro ( type: esriFieldTypeInteger, alias: micro, editable: true, nullable: true, defaultValue: null, modelName: micro )
• regional ( type: esriFieldTypeString, alias: regional, editable: true, nullable: true, length: 255, defaultValue: null, modelName: regional )
• update_date ( type: esriFieldTypeDate, alias: update_date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: update_date )
• update_process ( type: esriFieldTypeString, alias: update_process, editable: true, nullable: true, length: 255, defaultValue: null, modelName: update_process )
• IsToplist ( type: esriFieldTypeSmallInteger, alias: IsToplist, editable: true, nullable: true, defaultValue: null, modelName: IsToplist )

Templates:

• Name: LitterWatchDB.DBO.ItemLookup
  Description:
  Prototype:
  update_process: null
  IsToplist: null
  pk_itemcode: 0
  fk_category_id: null
  generalcode: null
  level1_materials: null
  level2_generaluse: null
  level3: null
  generalname: null
  description: null
  material: null
  purpose: null
  usage: null
  source: null
  problem1: null
  problem2: null
  core: null
  beach: null
  seafloor: null
  floating: null
  biota: null
  micro: null
  regional: null
  update_date: null
  
  Drawing Tool: esriFeatureEditToolNone

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

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

Child Resources:   Field Groups   Contingent Values

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