Name: ATTAINS Assessments by Catchment Table

Display Field: submissionid

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• submissionid (type: esriFieldTypeString, alias: Submission ID, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true)
• nhdplusid (type: esriFieldTypeDouble, alias: NHDPlusID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• organizationid (type: esriFieldTypeString, alias: Organization ID, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• orgtype (type: esriFieldTypeString, alias: Organization Type, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• tas303d (type: esriFieldTypeString, alias: TAS 303(d), SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• reportingcycle (type: esriFieldTypeInteger, alias: Reporting Cycle, SQL Type: sqlTypeOther, nullable: false, editable: true)
• assessmentunitidentifier (type: esriFieldTypeString, alias: Assessment Unit Identifier, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• waterbodyreportlink (type: esriFieldTypeString, alias: Waterbody Report Link, SQL Type: sqlTypeOther, length: 4000, nullable: false, editable: true)
• assmnt_joinkey (type: esriFieldTypeString, alias: Assessment JoinKey, SQL Type: sqlTypeOther, length: 40, nullable: false, editable: true)
• permid_joinkey (type: esriFieldTypeString, alias: PermID Joinkey, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ircategory (type: esriFieldTypeString, alias: IR Category, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• overallstatus (type: esriFieldTypeString, alias: Overall Status, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• isassessed (type: esriFieldTypeString, alias: Is Assessed, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• isimpaired (type: esriFieldTypeString, alias: Is Impaired, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• isthreatened (type: esriFieldTypeString, alias: Is Threatened, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• on303dlist (type: esriFieldTypeString, alias: On 303d List, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• hastmdl (type: esriFieldTypeString, alias: Has TMDL, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• has4bplan (type: esriFieldTypeString, alias: Has 4B Plan, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• hasalternativeplan (type: esriFieldTypeString, alias: Has Alternative Plan, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• hasprotectionplan (type: esriFieldTypeString, alias: Has Protection Plan, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• visionpriority303d (type: esriFieldTypeString, alias: Vision Priority 303d, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• areasqkm (type: esriFieldTypeDouble, alias: Area (SqKm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• huc12 (type: esriFieldTypeString, alias: XWalk HUC12, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• xwalk_method (type: esriFieldTypeString, alias: XWalk Method, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• xwalk_huc12_version (type: esriFieldTypeString, alias: XWalk HUC12 Version, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• catchmentareasqkm (type: esriFieldTypeDouble, alias: Catchment Area (SqKm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• catchmentstatecode (type: esriFieldTypeString, alias: Catchment State Code, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• catchmentistribal (type: esriFieldTypeString, alias: Catchment Tribal Flag, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• catchmentresolution (type: esriFieldTypeString, alias: Catchment Resolution, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: ATTAINS Assessments by Catchment Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• catchmentresolution:
• catchmentistribal:
• submissionid:
• nhdplusid: 0
• state:
• region:
• organizationid:
• orgtype:
• tas303d:
• reportingcycle: 0
• assessmentunitidentifier:
• waterbodyreportlink:
• assmnt_joinkey:
• overallstatus:
• isassessed:
• isimpaired:
• isthreatened:
• hastmdl:
• has4bplan:
• hasalternativeplan:
• hasprotectionplan:
• catchmentstatecode:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/2/2024 11:18:54 AM

Schema Last Edit Date: 10/2/2024 11:18:54 AM

Data Last Edit Date: 10/1/2024 3:49:54 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat