{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 6, "name": "ATTAINS Assessments by Catchment Table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "submissionid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "submissionid", "type": "esriFieldTypeString", "alias": "Submission ID", "length": 40, "domain": null }, { "name": "nhdplusid", "type": "esriFieldTypeDouble", "alias": "NHDPlusID", "domain": null }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "region", "type": "esriFieldTypeString", "alias": "Region", "length": 2, "domain": null }, { "name": "organizationid", "type": "esriFieldTypeString", "alias": "Organization ID", "length": 30, "domain": null }, { "name": "orgtype", "type": "esriFieldTypeString", "alias": "Organization Type", "length": 30, "domain": null }, { "name": "tas303d", "type": "esriFieldTypeString", "alias": "TAS 303(d)", "length": 1, "domain": null }, { "name": "reportingcycle", "type": "esriFieldTypeInteger", "alias": "Reporting Cycle", "domain": null }, { "name": "assessmentunitidentifier", "type": "esriFieldTypeString", "alias": "Assessment Unit Identifier", "length": 50, "domain": null }, { "name": "waterbodyreportlink", "type": "esriFieldTypeString", "alias": "Waterbody Report Link", "length": 4000, "domain": null }, { "name": "assmnt_joinkey", "type": "esriFieldTypeString", "alias": "Assessment JoinKey", "length": 40, "domain": null }, { "name": "permid_joinkey", "type": "esriFieldTypeString", "alias": "PermID Joinkey", "length": 40, "domain": null }, { "name": "ircategory", "type": "esriFieldTypeString", "alias": "IR Category", "length": 5, "domain": null }, { "name": "overallstatus", "type": "esriFieldTypeString", "alias": "Overall Status", "length": 50, "domain": null }, { "name": "isassessed", "type": "esriFieldTypeString", "alias": "Is Assessed", "length": 1, "domain": null }, { "name": "isimpaired", "type": "esriFieldTypeString", "alias": "Is Impaired", "length": 1, "domain": null }, { "name": "isthreatened", "type": "esriFieldTypeString", "alias": "Is Threatened", "length": 1, "domain": null }, { "name": "on303dlist", "type": "esriFieldTypeString", "alias": "On 303d List", "length": 1, "domain": null }, { "name": "hastmdl", "type": "esriFieldTypeString", "alias": "Has TMDL", "length": 1, "domain": null }, { "name": "has4bplan", "type": "esriFieldTypeString", "alias": "Has 4B Plan", "length": 1, "domain": null }, { "name": "hasalternativeplan", "type": "esriFieldTypeString", "alias": "Has Alternative Plan", "length": 1, "domain": null }, { "name": "hasprotectionplan", "type": "esriFieldTypeString", "alias": "Has Protection Plan", "length": 1, "domain": null }, { "name": "visionpriority303d", "type": "esriFieldTypeString", "alias": "Vision Priority 303d", "length": 1, "domain": null }, { "name": "areasqkm", "type": "esriFieldTypeDouble", "alias": "Area (SqKm)", "domain": null }, { "name": "huc12", "type": "esriFieldTypeString", "alias": "HUC12", "length": 12, "domain": null }, { "name": "catchmentareasqkm", "type": "esriFieldTypeDouble", "alias": "Catchment Area (SqKm)", "domain": null }, { "name": "catchmentstatecode", "type": "esriFieldTypeString", "alias": "Catchment State Code", "length": 2, "domain": null }, { "name": "catchmentistribal", "type": "esriFieldTypeString", "alias": "Catchment Tribal Flag", "length": 1, "domain": null }, { "name": "catchmentresolution", "type": "esriFieldTypeString", "alias": "Catchment Resolution", "length": 2, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GLOBALID", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9catchmentresol", "fields": "catchmentresolution", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9catchmentstate", "fields": "catchmentstatecode", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9visionpriority", "fields": "visionpriority303d", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9hasprotectionp", "fields": "hasprotectionplan", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9hasalternative", "fields": "hasalternativeplan", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9has4bplan", "fields": "has4bplan", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9hastmdl", "fields": "hastmdl", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9on303dlist", "fields": "on303dlist", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9isthreatened", "fields": "isthreatened", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9isimpaired", "fields": "isimpaired", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9isassessed", "fields": "isassessed", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9overallstatus", "fields": "overallstatus", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9ircategory", "fields": "ircategory", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9assmnt_joinkey", "fields": "assmnt_joinkey", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9assessmentunit", "fields": "assessmentunitidentifier", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9reportingcycle", "fields": "reportingcycle", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9tas303d", "fields": "tas303d", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9orgtype", "fields": "orgtype", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9organizationid", "fields": "organizationid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9submissionid", "fields": "submissionid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9huc12", "fields": "huc12", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9region", "fields": "region", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9state", "fields": "state", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I9nhdplusid", "fields": "nhdplusid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }