Name: Chemicals

Display Field: CHEM_NAMEGUID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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 )
• CHEM_SUMMARY ( type: esriFieldTypeString, alias: Release Summary for Substance, editable: true, nullable: true, length: 333, defaultValue: null, modelName: CHEM_SUMMARY )
• CHEM_NAMEGUID ( type: esriFieldTypeString, alias: Substance Released, editable: true, nullable: true, length: 200, defaultValue: null, modelName: CHEM_NAMEGUID )
• CHEM_CAS ( type: esriFieldTypeString, alias: CAS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CHEM_CAS )
• CHEM_SUBSTANCE ( type: esriFieldTypeString, alias: Substance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CHEM_SUBSTANCE )
• CHEM_EXTREMELYHAZARDOUS ( type: esriFieldTypeString, alias: Extremely Hazardous, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CHEM_EXTREMELYHAZARDOUS )
• CHEM_ABOVERQ ( type: esriFieldTypeString, alias: Above RQ, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CHEM_ABOVERQ )
• CHEM_ESTQUANTITY ( type: esriFieldTypeDouble, alias: Est Quantity, editable: true, nullable: true, defaultValue: null, modelName: CHEM_ESTQUANTITY )
• CHEM_ESTUNITS ( type: esriFieldTypeString, alias: Est Units, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CHEM_ESTUNITS , Coded Values: [pounds: pounds] , [gallons: gallons] , [other: other] )
• CHEM_ESTOTHERUNITS ( type: esriFieldTypeString, alias: Other Units, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CHEM_ESTOTHERUNITS , Coded Values: [cubic yard: cubic yard] , [cup: cup] , [Liters: Liters] , ...8 more... )
• CHEM_RQ ( type: esriFieldTypeInteger, alias: Reportable Quantity, editable: true, nullable: true, defaultValue: null, modelName: CHEM_RQ )
• CHEM_RQ_UNIT ( type: esriFieldTypeString, alias: Unit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CHEM_RQ_UNIT )
• CHEM_HEALTHRISKS ( type: esriFieldTypeString, alias: HEALTHRISKS, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: CHEM_HEALTHRISKS )
• CHEM_MEDICALATTENTION ( type: esriFieldTypeString, alias: Medical Attention, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: CHEM_MEDICALATTENTION )
• ALL_RELEASES_GLOBALID ( type: esriFieldTypeGUID, alias: All Releases GLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ALL_RELEASES_GLOBALID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Chemicals
  Description:
  Prototype:
  ALL_RELEASES_GLOBALID: null
  CHEM_MEDICALATTENTION: null
  CHEM_SUMMARY: null
  CHEM_NAMEGUID: null
  CHEM_CAS: null
  CHEM_SUBSTANCE: null
  CHEM_EXTREMELYHAZARDOUS: null
  CHEM_ABOVERQ: null
  CHEM_ESTQUANTITY: null
  CHEM_ESTUNITS: null
  CHEM_ESTOTHERUNITS: null
  CHEM_RQ: null
  CHEM_RQ_UNIT: null
  CHEM_HEALTHRISKS: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DNREC_OWNER.ENV_OTS_Releases (0) -- Related To: Releases (2)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata