{ "currentVersion": 10.91, "id": 4, "name": "SURF Data 2009-2015", "type": "Table", "description": "Extracted 2009-2015 data for priority urban pesticides from California Department of Pesticide Regulation's SURF dataset. Includes all monitoring events for permethrin, bifenthrin, and fipronil and its degradates.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CHEMICAL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 255, "domain": null }, { "name": "CHEMICAL", "type": "esriFieldTypeString", "alias": "Chemical", "length": 255, "domain": null }, { "name": "SITE", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "CONC_PPB", "type": "esriFieldTypeDouble", "alias": "Concentration, parts per billion", "domain": null }, { "name": "SAMP_DATE", "type": "esriFieldTypeDate", "alias": "Sample Date", "length": 8, "domain": null }, { "name": "MDL_PPB", "type": "esriFieldTypeString", "alias": "Method Detection Limit, parts per billion", "length": 255, "domain": null }, { "name": "LAT_NAD83", "type": "esriFieldTypeDouble", "alias": "Latitude NAD83", "domain": null }, { "name": "LONGI_NAD83", "type": "esriFieldTypeDouble", "alias": "Longitude NAD83", "domain": null }, { "name": "SITE_CODE", "type": "esriFieldTypeString", "alias": "Site Code", "length": 255, "domain": null }, { "name": "STUDY_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Study Description", "length": 255, "domain": null }, { "name": "STUDY_WEBLINK", "type": "esriFieldTypeString", "alias": "Study Weblink", "length": 255, "domain": null }, { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "ExceedanceYN", "type": "esriFieldTypeString", "alias": "EPA Benchmark Exceedance?", "length": 50, "domain": null } ], "indexes": [ { "name": "I3SITE_CODE", "fields": "SITE_CODE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Mon_Sites_Final_t83", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SITE_CODE", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 7000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }