{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "FishContaminantMonitoringEdibleSamplingData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "EgleSde.EGLESDEADMIN.FishContaminantMonitoringSamplingSites", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SiteGlobalID", "composite": false, "catalogID": "{9AF4516E-C700-497F-9989-C793DD744E33}" } ], "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, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "CountyName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Usgshuc", "type": "esriFieldTypeString", "alias": "USGS HUC 8", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Usgshuc" }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "County Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CountyName" }, { "name": "StationId", "type": "esriFieldTypeInteger", "alias": "StationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StationId" }, { "name": "WaterBody", "type": "esriFieldTypeString", "alias": "WaterBody", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WaterBody" }, { "name": "SamplingLocation", "type": "esriFieldTypeString", "alias": "Sampling Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SamplingLocation" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Lat", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Long", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "CollectionDate", "type": "esriFieldTypeDate", "alias": "Collection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CollectionDate" }, { "name": "Species", "type": "esriFieldTypeString", "alias": "Species", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Species" }, { "name": "Sex", "type": "esriFieldTypeString", "alias": "Sex", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Sex" }, { "name": "Age", "type": "esriFieldTypeInteger", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Age" }, { "name": "Lengthcm", "type": "esriFieldTypeDouble", "alias": "Length (cm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Lengthcm" }, { "name": "Weightg", "type": "esriFieldTypeDouble", "alias": "Weight (g)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Weightg" }, { "name": "SampleType", "type": "esriFieldTypeString", "alias": "Sample Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SampleType" }, { "name": "VisitId", "type": "esriFieldTypeDouble", "alias": "VisitID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VisitId" }, { "name": "SampleId", "type": "esriFieldTypeString", "alias": "SampleID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SampleId" }, { "name": "FishId", "type": "esriFieldTypeString", "alias": "FishID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FishId" }, { "name": "Mercuryppm", "type": "esriFieldTypeDouble", "alias": "Mercury (ppm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mercuryppm" }, { "name": "MercuryCode", "type": "esriFieldTypeString", "alias": "Mercury Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MercuryCode" }, { "name": "PerfluorooctaneSulfonateppb", "type": "esriFieldTypeDouble", "alias": "Perfluorooctane Sulfonate (ppb)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PerfluorooctaneSulfonateppb" }, { "name": "PFOSCode", "type": "esriFieldTypeString", "alias": "PFOS Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PFOSCode" }, { "name": "TotalChlordaneppm", "type": "esriFieldTypeDouble", "alias": "Total Chlordane (ppm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalChlordaneppm" }, { "name": "ChlordaneCode", "type": "esriFieldTypeString", "alias": "Chlordane Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ChlordaneCode" }, { "name": "TotalDDTppm", "type": "esriFieldTypeDouble", "alias": "Total DDT (ppm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalDDTppm" }, { "name": "DDTCode", "type": "esriFieldTypeString", "alias": "DDT Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DDTCode" }, { "name": "TotalPCBAroclorppm", "type": "esriFieldTypeDouble", "alias": "Total PCB Aroclor (ppm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalPCBAroclorppm" }, { "name": "PCBAroclorCode", "type": "esriFieldTypeString", "alias": "PCB Aroclor Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PCBAroclorCode" }, { "name": "TotalPCBCongenersppm", "type": "esriFieldTypeDouble", "alias": "Total PCB Congeners (ppm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalPCBCongenersppm" }, { "name": "PCBCongenerCode", "type": "esriFieldTypeString", "alias": "PCB Congener Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PCBCongenerCode" }, { "name": "Toxapheneppm", "type": "esriFieldTypeDouble", "alias": "Toxaphene (ppm)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Toxapheneppm" }, { "name": "ToxapheneCode", "type": "esriFieldTypeString", "alias": "Toxaphene Code", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ToxapheneCode" }, { "name": "TEQppt", "type": "esriFieldTypeDouble", "alias": "TEQ (ppt)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TEQppt" }, { "name": "SiteGlobalID", "type": "esriFieldTypeGUID", "alias": "SiteGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SiteGlobalID" } ], "indexes": [ { "name": "R452_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_7997_SiteGlo", "fields": "SiteGlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "FishContaminantMonitoringEdibleSamplingData", "description": "", "prototype": { "attributes": { "TEQppt": null, "SiteGlobalID": null, "Usgshuc": null, "CountyName": null, "StationId": null, "WaterBody": null, "SamplingLocation": null, "Latitude": null, "Longitude": null, "CollectionDate": null, "Species": null, "Sex": null, "Age": null, "Lengthcm": null, "Weightg": null, "SampleType": null, "VisitId": null, "SampleId": null, "FishId": null, "Mercuryppm": null, "MercuryCode": null, "PerfluorooctaneSulfonateppb": null, "PFOSCode": null, "TotalChlordaneppm": null, "ChlordaneCode": null, "TotalDDTppm": null, "DDTCode": null, "TotalPCBAroclorppm": null, "PCBAroclorCode": null, "TotalPCBCongenersppm": null, "PCBCongenerCode": null, "Toxapheneppm": null, "ToxapheneCode": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }