{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "EMD_PFAS_SAMPLE_RESULTS", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "dbo.EMD_PFAS_SAMPLE_POINTS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "STANO", "composite": false, "catalogID": "{9DC213BE-1608-4B2E-AABA-B380C45A52E9}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ACTIVITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "STANO", "type": "esriFieldTypeDouble", "alias": "STANO", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "STANO" }, { "name": "ACTIVITYID", "type": "esriFieldTypeString", "alias": "ACTIVITYID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACTIVITYID" }, { "name": "SAMPLEDATE", "type": "esriFieldTypeDate", "alias": "SAMPLEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SAMPLEDATE" }, { "name": "LABID", "type": "esriFieldTypeString", "alias": "LABID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LABID" }, { "name": "PROJNO", "type": "esriFieldTypeDouble", "alias": "PROJNO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PROJNO" }, { "name": "TOTAL_PFAS", "type": "esriFieldTypeDouble", "alias": "TOTAL_PFAS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_PFAS" }, { "name": "RESULTS_COUNT", "type": "esriFieldTypeDouble", "alias": "RESULTS_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RESULTS_COUNT" }, { "name": "PFOA_PFOS", "type": "esriFieldTypeDouble", "alias": "PFOA_PFOS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFOA_PFOS" }, { "name": "E_AGQS", "type": "esriFieldTypeString", "alias": "E_AGQS", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "E_AGQS" }, { "name": "ACTNO", "type": "esriFieldTypeDouble", "alias": "ACTNO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACTNO" }, { "name": "E_MCL", "type": "esriFieldTypeString", "alias": "E_MCL", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "E_MCL" }, { "name": "LABQVAL", "type": "esriFieldTypeString", "alias": "LABQVAL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LABQVAL" }, { "name": "PFODA", "type": "esriFieldTypeDouble", "alias": "PFODA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFODA" }, { "name": "PFHXDA", "type": "esriFieldTypeDouble", "alias": "PFHXDA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFHXDA" }, { "name": "PFTEA", "type": "esriFieldTypeDouble", "alias": "PFTEA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFTEA" }, { "name": "PFTRA", "type": "esriFieldTypeDouble", "alias": "PFTRA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFTRA" }, { "name": "PFDOA", "type": "esriFieldTypeDouble", "alias": "PFDOA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFDOA" }, { "name": "PFUNA", "type": "esriFieldTypeDouble", "alias": "PFUNA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFUNA" }, { "name": "PFDA", "type": "esriFieldTypeDouble", "alias": "PFDA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFDA" }, { "name": "PFNA", "type": "esriFieldTypeDouble", "alias": "PFNA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFNA" }, { "name": "PFOA", "type": "esriFieldTypeDouble", "alias": "PFOA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFOA" }, { "name": "PFHPA", "type": "esriFieldTypeDouble", "alias": "PFHPA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFHPA" }, { "name": "PFHXA", "type": "esriFieldTypeDouble", "alias": "PFHXA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFHXA" }, { "name": "PFPEA", "type": "esriFieldTypeDouble", "alias": "PFPEA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFPEA" }, { "name": "PFBA", "type": "esriFieldTypeDouble", "alias": "PFBA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFBA" }, { "name": "PFDODS", "type": "esriFieldTypeDouble", "alias": "PFDODS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFDODS" }, { "name": "PFDS", "type": "esriFieldTypeDouble", "alias": "PFDS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFDS" }, { "name": "PFNS", "type": "esriFieldTypeDouble", "alias": "PFNS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFNS" }, { "name": "PFOS", "type": "esriFieldTypeDouble", "alias": "PFOS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFOS" }, { "name": "PFHPS", "type": "esriFieldTypeDouble", "alias": "PFHPS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFHPS" }, { "name": "PFHXS", "type": "esriFieldTypeDouble", "alias": "PFHXS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFHXS" }, { "name": "PFPES", "type": "esriFieldTypeDouble", "alias": "PFPES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFPES" }, { "name": "PFBS", "type": "esriFieldTypeDouble", "alias": "PFBS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFBS" }, { "name": "FTS82", "type": "esriFieldTypeDouble", "alias": "FTS82", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTS82" }, { "name": "FTS62", "type": "esriFieldTypeDouble", "alias": "FTS62", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTS62" }, { "name": "FTS42", "type": "esriFieldTypeDouble", "alias": "FTS42", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTS42" }, { "name": "FTSA102", "type": "esriFieldTypeDouble", "alias": "FTSA102", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTSA102" }, { "name": "FTSA82", "type": "esriFieldTypeDouble", "alias": "FTSA82", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTSA82" }, { "name": "FTSA62", "type": "esriFieldTypeDouble", "alias": "FTSA62", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTSA62" }, { "name": "FTSA42", "type": "esriFieldTypeDouble", "alias": "FTSA42", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTSA42" }, { "name": "FOSA", "type": "esriFieldTypeDouble", "alias": "FOSA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FOSA" }, { "name": "NETFOSA", "type": "esriFieldTypeDouble", "alias": "NETFOSA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NETFOSA" }, { "name": "NMEFOSA", "type": "esriFieldTypeDouble", "alias": "NMEFOSA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NMEFOSA" }, { "name": "NETFOSE", "type": "esriFieldTypeDouble", "alias": "NETFOSE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NETFOSE" }, { "name": "NMEFOSE", "type": "esriFieldTypeDouble", "alias": "NMEFOSE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NMEFOSE" }, { "name": "NETFOSAA", "type": "esriFieldTypeDouble", "alias": "NETFOSAA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NETFOSAA" }, { "name": "NMEFOSAA", "type": "esriFieldTypeDouble", "alias": "NMEFOSAA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NMEFOSAA" }, { "name": "GENXACID", "type": "esriFieldTypeDouble", "alias": "GENXACID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GENXACID" }, { "name": "DONA", "type": "esriFieldTypeDouble", "alias": "DONA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DONA" }, { "name": "ADONA", "type": "esriFieldTypeDouble", "alias": "ADONA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADONA" }, { "name": "F53B_MAJOR", "type": "esriFieldTypeDouble", "alias": "F53B_MAJOR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F53B_MAJOR" }, { "name": "F53B_MINOR", "type": "esriFieldTypeDouble", "alias": "F53B_MINOR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "F53B_MINOR" }, { "name": "NFDHA", "type": "esriFieldTypeDouble", "alias": "NFDHA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NFDHA" }, { "name": "PFEESA", "type": "esriFieldTypeDouble", "alias": "PFEESA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFEESA" }, { "name": "PFMBA", "type": "esriFieldTypeDouble", "alias": "PFMBA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFMBA" }, { "name": "PFMPA", "type": "esriFieldTypeDouble", "alias": "PFMPA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFMPA" }, { "name": "FTCA33", "type": "esriFieldTypeDouble", "alias": "FTCA33", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTCA33" }, { "name": "FTCA53", "type": "esriFieldTypeDouble", "alias": "FTCA53", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTCA53" }, { "name": "FTCA73", "type": "esriFieldTypeDouble", "alias": "FTCA73", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTCA73" }, { "name": "PFPRA", "type": "esriFieldTypeDouble", "alias": "PFPRA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFPRA" }, { "name": "PFECHS", "type": "esriFieldTypeDouble", "alias": "PFECHS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFECHS" }, { "name": "PEPA", "type": "esriFieldTypeDouble", "alias": "PEPA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PEPA" }, { "name": "PFPRS", "type": "esriFieldTypeDouble", "alias": "PFPRS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFPRS" }, { "name": "PMPA", "type": "esriFieldTypeDouble", "alias": "PMPA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PMPA" }, { "name": "REVE", "type": "esriFieldTypeDouble", "alias": "REVE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REVE" }, { "name": "FTCA62", "type": "esriFieldTypeDouble", "alias": "FTCA62", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTCA62" }, { "name": "FTUCA62", "type": "esriFieldTypeDouble", "alias": "FTUCA62", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTUCA62" }, { "name": "FTCA82", "type": "esriFieldTypeDouble", "alias": "FTCA82", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTCA82" }, { "name": "FTUCA82", "type": "esriFieldTypeDouble", "alias": "FTUCA82", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTUCA82" }, { "name": "PFO2HXA", "type": "esriFieldTypeDouble", "alias": "PFO2HXA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFO2HXA" }, { "name": "PFO5DODA_TAF", "type": "esriFieldTypeDouble", "alias": "PFO5DODA_TAF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFO5DODA_TAF" }, { "name": "RPSDA", "type": "esriFieldTypeDouble", "alias": "RPSDA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RPSDA" }, { "name": "FTCA102", "type": "esriFieldTypeDouble", "alias": "FTCA102", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTCA102" }, { "name": "FTUCA102", "type": "esriFieldTypeDouble", "alias": "FTUCA102", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FTUCA102" }, { "name": "PFECA_G", "type": "esriFieldTypeDouble", "alias": "PFECA_G", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFECA_G" }, { "name": "PFMOAA", "type": "esriFieldTypeDouble", "alias": "PFMOAA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFMOAA" }, { "name": "PFO3OA", "type": "esriFieldTypeDouble", "alias": "PFO3OA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFO3OA" }, { "name": "PFO4DA", "type": "esriFieldTypeDouble", "alias": "PFO4DA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PFO4DA" }, { "name": "EVE_ACID", "type": "esriFieldTypeDouble", "alias": "EVE_ACID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EVE_ACID" }, { "name": "HYDRO_EVE_A", "type": "esriFieldTypeDouble", "alias": "HYDRO_EVE_A", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDRO_EVE_A" }, { "name": "MTP", "type": "esriFieldTypeDouble", "alias": "MTP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MTP" }, { "name": "NVHOS", "type": "esriFieldTypeDouble", "alias": "NVHOS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NVHOS" }, { "name": "PS_ACID", "type": "esriFieldTypeDouble", "alias": "PS_ACID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PS_ACID" }, { "name": "HYDRO_PS_A", "type": "esriFieldTypeDouble", "alias": "HYDRO_PS_A", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDRO_PS_A" }, { "name": "HYDRO_PSDA", "type": "esriFieldTypeDouble", "alias": "HYDRO_PSDA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDRO_PSDA" }, { "name": "R_PSDCA", "type": "esriFieldTypeDouble", "alias": "R_PSDCA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "R_PSDCA" }, { "name": "PROPOSED_MCL", "type": "esriFieldTypeString", "alias": "PROPOSED_MCL", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PROPOSED_MCL" } ], "indexes": [ { "name": "R3463_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "EMD_PFAS_SAMPLE_RESULTS", "description": "", "prototype": { "attributes": { "R_PSDCA": null, "PROPOSED_MCL": null, "STANO": 0, "ACTIVITYID": null, "SAMPLEDATE": null, "LABID": null, "PROJNO": null, "TOTAL_PFAS": null, "RESULTS_COUNT": null, "PFOA_PFOS": null, "E_AGQS": null, "ACTNO": null, "E_MCL": null, "LABQVAL": null, "PFODA": null, "PFHXDA": null, "PFTEA": null, "PFTRA": null, "PFDOA": null, "PFUNA": null, "PFDA": null, "PFNA": null, "PFOA": null, "PFHPA": null, "PFHXA": null, "PFPEA": null, "PFBA": null, "PFDODS": null, "PFDS": null, "PFNS": null, "PFOS": null, "PFHPS": null, "PFHXS": null, "PFPES": null, "PFBS": null, "FTS82": null, "FTS62": null, "FTS42": null, "FTSA102": null, "FTSA82": null, "FTSA62": null, "FTSA42": null, "FOSA": null, "NETFOSA": null, "NMEFOSA": null, "NETFOSE": null, "NMEFOSE": null, "NETFOSAA": null, "NMEFOSAA": null, "GENXACID": null, "DONA": null, "ADONA": null, "F53B_MAJOR": null, "F53B_MINOR": null, "NFDHA": null, "PFEESA": null, "PFMBA": null, "PFMPA": null, "FTCA33": null, "FTCA53": null, "FTCA73": null, "PFPRA": null, "PFECHS": null, "PEPA": null, "PFPRS": null, "PMPA": null, "REVE": null, "FTCA62": null, "FTUCA62": null, "FTCA82": null, "FTUCA82": null, "PFO2HXA": null, "PFO5DODA_TAF": null, "RPSDA": null, "FTCA102": null, "FTUCA102": null, "PFECA_G": null, "PFMOAA": null, "PFO3OA": null, "PFO4DA": null, "EVE_ACID": null, "HYDRO_EVE_A": null, "MTP": null, "NVHOS": null, "PS_ACID": null, "HYDRO_PS_A": null, "HYDRO_PSDA": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1, "serviceItemId": "e2613ba86b224f028936a1809fec55c7" }