{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "EMD_PFAS_SAMPLE_RESULTS", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACTIVITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "STANO", "type": "esriFieldTypeDouble", "alias": "STANO", "domain": null }, { "name": "ACTIVITYID", "type": "esriFieldTypeString", "alias": "ACTIVITYID", "length": 50, "domain": null }, { "name": "SAMPLEDATE", "type": "esriFieldTypeDate", "alias": "SAMPLEDATE", "length": 8, "domain": null }, { "name": "LABID", "type": "esriFieldTypeString", "alias": "LABID", "length": 255, "domain": null }, { "name": "PROJNO", "type": "esriFieldTypeDouble", "alias": "PROJNO", "domain": null }, { "name": "TOTAL_PFAS", "type": "esriFieldTypeDouble", "alias": "TOTAL_PFAS", "domain": null }, { "name": "RESULTS_COUNT", "type": "esriFieldTypeDouble", "alias": "RESULTS_COUNT", "domain": null }, { "name": "PFOA_PFOS", "type": "esriFieldTypeDouble", "alias": "PFOA_PFOS", "domain": null }, { "name": "E_AGQS", "type": "esriFieldTypeString", "alias": "E_AGQS", "length": 1, "domain": null }, { "name": "ACTNO", "type": "esriFieldTypeDouble", "alias": "ACTNO", "domain": null }, { "name": "E_MCL", "type": "esriFieldTypeString", "alias": "E_MCL", "length": 1, "domain": null }, { "name": "LABQVAL", "type": "esriFieldTypeString", "alias": "LABQVAL", "length": 255, "domain": null }, { "name": "PFODA", "type": "esriFieldTypeDouble", "alias": "PFODA", "domain": null }, { "name": "PFHXDA", "type": "esriFieldTypeDouble", "alias": "PFHXDA", "domain": null }, { "name": "PFTEA", "type": "esriFieldTypeDouble", "alias": "PFTEA", "domain": null }, { "name": "PFTRA", "type": "esriFieldTypeDouble", "alias": "PFTRA", "domain": null }, { "name": "PFDOA", "type": "esriFieldTypeDouble", "alias": "PFDOA", "domain": null }, { "name": "PFUNA", "type": "esriFieldTypeDouble", "alias": "PFUNA", "domain": null }, { "name": "PFDA", "type": "esriFieldTypeDouble", "alias": "PFDA", "domain": null }, { "name": "PFNA", "type": "esriFieldTypeDouble", "alias": "PFNA", "domain": null }, { "name": "PFOA", "type": "esriFieldTypeDouble", "alias": "PFOA", "domain": null }, { "name": "PFHPA", "type": "esriFieldTypeDouble", "alias": "PFHPA", "domain": null }, { "name": "PFHXA", "type": "esriFieldTypeDouble", "alias": "PFHXA", "domain": null }, { "name": "PFPEA", "type": "esriFieldTypeDouble", "alias": "PFPEA", "domain": null }, { "name": "PFBA", "type": "esriFieldTypeDouble", "alias": "PFBA", "domain": null }, { "name": "PFDODS", "type": "esriFieldTypeDouble", "alias": "PFDODS", "domain": null }, { "name": "PFDS", "type": "esriFieldTypeDouble", "alias": "PFDS", "domain": null }, { "name": "PFNS", "type": "esriFieldTypeDouble", "alias": "PFNS", "domain": null }, { "name": "PFOS", "type": "esriFieldTypeDouble", "alias": "PFOS", "domain": null }, { "name": "PFHPS", "type": "esriFieldTypeDouble", "alias": "PFHPS", "domain": null }, { "name": "PFHXS", "type": "esriFieldTypeDouble", "alias": "PFHXS", "domain": null }, { "name": "PFPES", "type": "esriFieldTypeDouble", "alias": "PFPES", "domain": null }, { "name": "PFBS", "type": "esriFieldTypeDouble", "alias": "PFBS", "domain": null }, { "name": "FTS82", "type": "esriFieldTypeDouble", "alias": "FTS82", "domain": null }, { "name": "FTS62", "type": "esriFieldTypeDouble", "alias": "FTS62", "domain": null }, { "name": "FTS42", "type": "esriFieldTypeDouble", "alias": "FTS42", "domain": null }, { "name": "FTSA102", "type": "esriFieldTypeDouble", "alias": "FTSA102", "domain": null }, { "name": "FTSA82", "type": "esriFieldTypeDouble", "alias": "FTSA82", "domain": null }, { "name": "FTSA62", "type": "esriFieldTypeDouble", "alias": "FTSA62", "domain": null }, { "name": "FTSA42", "type": "esriFieldTypeDouble", "alias": "FTSA42", "domain": null }, { "name": "FOSA", "type": "esriFieldTypeDouble", "alias": "FOSA", "domain": null }, { "name": "NETFOSA", "type": "esriFieldTypeDouble", "alias": "NETFOSA", "domain": null }, { "name": "NMEFOSA", "type": "esriFieldTypeDouble", "alias": "NMEFOSA", "domain": null }, { "name": "NETFOSE", "type": "esriFieldTypeDouble", "alias": "NETFOSE", "domain": null }, { "name": "NMEFOSE", "type": "esriFieldTypeDouble", "alias": "NMEFOSE", "domain": null }, { "name": "NETFOSAA", "type": "esriFieldTypeDouble", "alias": "NETFOSAA", "domain": null }, { "name": "NMEFOSAA", "type": "esriFieldTypeDouble", "alias": "NMEFOSAA", "domain": null }, { "name": "GENXACID", "type": "esriFieldTypeDouble", "alias": "GENXACID", "domain": null }, { "name": "DONA", "type": "esriFieldTypeDouble", "alias": "DONA", "domain": null }, { "name": "ADONA", "type": "esriFieldTypeDouble", "alias": "ADONA", "domain": null }, { "name": "F53B_MAJOR", "type": "esriFieldTypeDouble", "alias": "F53B_MAJOR", "domain": null }, { "name": "F53B_MINOR", "type": "esriFieldTypeDouble", "alias": "F53B_MINOR", "domain": null }, { "name": "NFDHA", "type": "esriFieldTypeDouble", "alias": "NFDHA", "domain": null }, { "name": "PFEESA", "type": "esriFieldTypeDouble", "alias": "PFEESA", "domain": null }, { "name": "PFMBA", "type": "esriFieldTypeDouble", "alias": "PFMBA", "domain": null }, { "name": "PFMPA", "type": "esriFieldTypeDouble", "alias": "PFMPA", "domain": null }, { "name": "FTCA33", "type": "esriFieldTypeDouble", "alias": "FTCA33", "domain": null }, { "name": "FTCA53", "type": "esriFieldTypeDouble", "alias": "FTCA53", "domain": null }, { "name": "FTCA73", "type": "esriFieldTypeDouble", "alias": "FTCA73", "domain": null }, { "name": "PFPRA", "type": "esriFieldTypeDouble", "alias": "PFPRA", "domain": null }, { "name": "PFECHS", "type": "esriFieldTypeDouble", "alias": "PFECHS", "domain": null }, { "name": "PEPA", "type": "esriFieldTypeDouble", "alias": "PEPA", "domain": null }, { "name": "PFPRS", "type": "esriFieldTypeDouble", "alias": "PFPRS", "domain": null }, { "name": "PMPA", "type": "esriFieldTypeDouble", "alias": "PMPA", "domain": null }, { "name": "REVE", "type": "esriFieldTypeDouble", "alias": "REVE", "domain": null }, { "name": "FTCA62", "type": "esriFieldTypeDouble", "alias": "FTCA62", "domain": null }, { "name": "FTUCA62", "type": "esriFieldTypeDouble", "alias": "FTUCA62", "domain": null }, { "name": "FTCA82", "type": "esriFieldTypeDouble", "alias": "FTCA82", "domain": null }, { "name": "FTUCA82", "type": "esriFieldTypeDouble", "alias": "FTUCA82", "domain": null }, { "name": "PFO2HXA", "type": "esriFieldTypeDouble", "alias": "PFO2HXA", "domain": null }, { "name": "PFO5DODA_TAF", "type": "esriFieldTypeDouble", "alias": "PFO5DODA_TAF", "domain": null }, { "name": "RPSDA", "type": "esriFieldTypeDouble", "alias": "RPSDA", "domain": null }, { "name": "FTCA102", "type": "esriFieldTypeDouble", "alias": "FTCA102", "domain": null }, { "name": "FTUCA102", "type": "esriFieldTypeDouble", "alias": "FTUCA102", "domain": null }, { "name": "PFECA_G", "type": "esriFieldTypeDouble", "alias": "PFECA_G", "domain": null }, { "name": "PFMOAA", "type": "esriFieldTypeDouble", "alias": "PFMOAA", "domain": null }, { "name": "PFO3OA", "type": "esriFieldTypeDouble", "alias": "PFO3OA", "domain": null }, { "name": "PFO4DA", "type": "esriFieldTypeDouble", "alias": "PFO4DA", "domain": null }, { "name": "EVE_ACID", "type": "esriFieldTypeDouble", "alias": "EVE_ACID", "domain": null }, { "name": "HYDRO_EVE_A", "type": "esriFieldTypeDouble", "alias": "HYDRO_EVE_A", "domain": null }, { "name": "MTP", "type": "esriFieldTypeDouble", "alias": "MTP", "domain": null }, { "name": "NVHOS", "type": "esriFieldTypeDouble", "alias": "NVHOS", "domain": null }, { "name": "PS_ACID", "type": "esriFieldTypeDouble", "alias": "PS_ACID", "domain": null }, { "name": "HYDRO_PS_A", "type": "esriFieldTypeDouble", "alias": "HYDRO_PS_A", "domain": null }, { "name": "HYDRO_PSDA", "type": "esriFieldTypeDouble", "alias": "HYDRO_PSDA", "domain": null }, { "name": "R_PSDCA", "type": "esriFieldTypeDouble", "alias": "R_PSDCA", "domain": null }, { "name": "PROPOSED_MCL", "type": "esriFieldTypeString", "alias": "PROPOSED_MCL", "length": 1, "domain": null } ], "indexes": [ { "name": "R3463_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "dbo.EMD_PFAS_SAMPLE_POINTS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "STANO", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9DC213BE-1608-4B2E-AABA-B380C45A52E9}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 100000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "a6c0303c679047ed97401c2eba5a4d30" }