Name: AllData20260220_csv

Display Field: resultvaluetypename

Type: Table

Geometry Type: N/A

Description: Associated water quality results for walls and surface water sources sampled as part of the State Water Board's Oil and Gas Regional Monitoring Program. All results are also available throught the United States Geological Survey Water Quality Data Portal. 

Service Item Id: 22934fafe7b04c32a8b5b3237e2efa64

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• field1 ( modelName: field1, nullable: true, editable: true, defaultValue: null, alias: Field1, type: esriFieldTypeInteger )
• locationid ( modelName: locationid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: LocationID, type: esriFieldTypeString )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Longitude, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Latitude, type: esriFieldTypeString )
• medium ( modelName: medium, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Medium, type: esriFieldTypeString )
• observationid ( modelName: observationid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ObservationID, type: esriFieldTypeString )
• observationdate ( modelName: observationdate, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ObservationDate, type: esriFieldTypeString )
• observationtime ( modelName: observationtime, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ObservationTime, type: esriFieldTypeString )
• agencycd ( modelName: agencycd, nullable: true, editable: true, defaultValue: null, length: 8000, alias: AgencyCd, type: esriFieldTypeString )
• observedpropertycasnumber ( modelName: observedpropertycasnumber, nullable: true, editable: true, defaultValue: null, length: 8000, alias: observedPropertyCasNumber, type: esriFieldTypeString )
• observedpropertyid ( modelName: observedpropertyid, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ObservedPropertyId, type: esriFieldTypeString )
• nwisparmcd ( modelName: nwisparmcd, nullable: true, editable: true, defaultValue: null, length: 8000, alias: NWISParmCd, type: esriFieldTypeString )
• resultdetectioncondition ( modelName: resultdetectioncondition, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultDetectionCondition, type: esriFieldTypeString )
• resultvaluetypename ( modelName: resultvaluetypename, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultValueTypeName, type: esriFieldTypeString )
• resultvalue ( modelName: resultvalue, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultValue, type: esriFieldTypeString )
• resultunit ( modelName: resultunit, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultUnit, type: esriFieldTypeString )
• resultqualifiercode ( modelName: resultqualifiercode, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultQualifierCode, type: esriFieldTypeString )
• resultprecisionvalue ( modelName: resultprecisionvalue, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultPrecisionValue, type: esriFieldTypeString )
• resultdetectionlimit ( modelName: resultdetectionlimit, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ResultDetectionLimit, type: esriFieldTypeString )
• detectionlimittype ( modelName: detectionlimittype, nullable: true, editable: true, defaultValue: null, length: 8000, alias: DetectionLimitType, type: esriFieldTypeString )
• laboratoryname ( modelName: laboratoryname, nullable: true, editable: true, defaultValue: null, length: 8000, alias: LaboratoryName, type: esriFieldTypeString )
• analysismethod ( modelName: analysismethod, nullable: true, editable: true, defaultValue: null, length: 8000, alias: analysisMethod, type: esriFieldTypeString )
• analysismethodreference ( modelName: analysismethodreference, nullable: true, editable: true, defaultValue: null, length: 8000, alias: analysisMethodReference, type: esriFieldTypeString )
• labcomment ( modelName: labcomment, nullable: true, editable: true, defaultValue: null, length: 8000, alias: LabComment, type: esriFieldTypeString )
• oilfieldname ( modelName: oilfieldname, nullable: true, editable: true, defaultValue: null, length: 8000, alias: OilFIeldName, type: esriFieldTypeString )
• sampletype ( modelName: sampletype, nullable: true, editable: true, defaultValue: null, length: 8000, alias: SampleType, type: esriFieldTypeString )
• cogg_id ( modelName: cogg_id, nullable: true, editable: true, defaultValue: null, length: 8000, alias: COGG_ID, type: esriFieldTypeString )

Templates:

• Name: AllData20260220_csv
  Description:
  Prototype:
  observedpropertycasnumber: null
  analysismethodreference: null
  latitude: null
  resultvaluetypename: null
  medium: null
  resultvalue: null
  nwisparmcd: null
  resultprecisionvalue: null
  resultdetectioncondition: null
  resultunit: null
  resultdetectionlimit: null
  analysismethod: null
  longitude: null
  cogg_id: null
  observationdate: null
  agencycd: null
  labcomment: null
  field1: null
  observationid: null
  sampletype: null
  locationid: null
  oilfieldname: null
  observationtime: null
  observedpropertyid: null
  detectionlimittype: null
  laboratoryname: null
  resultqualifiercode: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• AllSites (0) -- Related To: AllSites20260220 (32)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata