Name: tbl_seapscore

Display Field: SurveyID

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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SurveyID (type: esriFieldTypeInteger, alias: SurveyID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SEAPScore_ID (type: esriFieldTypeInteger, alias: SEAPScore_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ0 (type: esriFieldTypeString, alias: AFWQ0, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• AFWQ0Risk (type: esriFieldTypeInteger, alias: AFWQ0Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ1 (type: esriFieldTypeString, alias: AFWQ1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AFWQ1Risk (type: esriFieldTypeInteger, alias: AFWQ1Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ2 (type: esriFieldTypeString, alias: AFWQ2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AFWQ2Risk (type: esriFieldTypeInteger, alias: AFWQ2Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ3 (type: esriFieldTypeString, alias: AFWQ3, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AFWQ3Risk (type: esriFieldTypeInteger, alias: AFWQ3Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ4 (type: esriFieldTypeString, alias: AFWQ4, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AFWQ4Risk (type: esriFieldTypeInteger, alias: AFWQ4Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ5 (type: esriFieldTypeString, alias: AFWQ5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AFWQ5Risk (type: esriFieldTypeInteger, alias: AFWQ5Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQ6 (type: esriFieldTypeString, alias: AFWQ6, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AFWQ6Risk (type: esriFieldTypeInteger, alias: AFWQ6Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AFWQScore (type: esriFieldTypeString, alias: AFWQScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• AFWQRiskScore (type: esriFieldTypeString, alias: AFWQRiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GEO0 (type: esriFieldTypeString, alias: GEO0, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• GEO1 (type: esriFieldTypeString, alias: GEO1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GEO1Risk (type: esriFieldTypeInteger, alias: GEO1Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEO2 (type: esriFieldTypeString, alias: GEO2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GEO2Risk (type: esriFieldTypeInteger, alias: GEO2Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEO3 (type: esriFieldTypeString, alias: GEO3, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GEO3Risk (type: esriFieldTypeInteger, alias: GEO3Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEO4 (type: esriFieldTypeString, alias: GEO4, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GEO4Risk (type: esriFieldTypeInteger, alias: GEO4Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEO5 (type: esriFieldTypeString, alias: GEO5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GEO5Risk (type: esriFieldTypeInteger, alias: GEO5Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEOScore (type: esriFieldTypeString, alias: GEOScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GEORiskScore (type: esriFieldTypeString, alias: GEORiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• HAB1 (type: esriFieldTypeString, alias: HAB1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• HAB1Risk (type: esriFieldTypeInteger, alias: HAB1Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAB2 (type: esriFieldTypeString, alias: HAB2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• HAB2Risk (type: esriFieldTypeInteger, alias: HAB2Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAB3 (type: esriFieldTypeString, alias: HAB3, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• HAB3Risk (type: esriFieldTypeInteger, alias: HAB3Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAB4 (type: esriFieldTypeString, alias: HAB4, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• HAB4Risk (type: esriFieldTypeInteger, alias: HAB4Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAB5 (type: esriFieldTypeString, alias: HAB5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• HAB5Risk (type: esriFieldTypeInteger, alias: HAB5Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HABScore (type: esriFieldTypeString, alias: HABScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• HABRiskScore (type: esriFieldTypeString, alias: HABRiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• BIO1a (type: esriFieldTypeString, alias: BIO1a, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO1aRisk (type: esriFieldTypeInteger, alias: BIO1aRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO1b (type: esriFieldTypeString, alias: BIO1b, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO1bRisk (type: esriFieldTypeInteger, alias: BIO1bRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO2a (type: esriFieldTypeString, alias: BIO2a, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO2aRisk (type: esriFieldTypeInteger, alias: BIO2aRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO2b (type: esriFieldTypeString, alias: BIO2b, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO2bRisk (type: esriFieldTypeInteger, alias: BIO2bRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO3a (type: esriFieldTypeString, alias: BIO3a, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO3aRisk (type: esriFieldTypeInteger, alias: BIO3aRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO3b (type: esriFieldTypeString, alias: BIO3b, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO3bRisk (type: esriFieldTypeInteger, alias: BIO3bRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO4a (type: esriFieldTypeString, alias: BIO4a, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO4aRisk (type: esriFieldTypeInteger, alias: BIO4aRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIO4b (type: esriFieldTypeString, alias: BIO4b, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• BIO4bRisk (type: esriFieldTypeInteger, alias: BIO4bRisk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIOScore (type: esriFieldTypeString, alias: BIOScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• BIORiskScore (type: esriFieldTypeString, alias: BIORiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FHI1 (type: esriFieldTypeString, alias: FHI1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI1Risk (type: esriFieldTypeInteger, alias: FHI1Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI2 (type: esriFieldTypeString, alias: FHI2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI2Risk (type: esriFieldTypeInteger, alias: FHI2Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI3 (type: esriFieldTypeString, alias: FHI3, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI3Risk (type: esriFieldTypeInteger, alias: FHI3Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI4 (type: esriFieldTypeString, alias: FHI4, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI4Risk (type: esriFieldTypeInteger, alias: FHI4Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI5 (type: esriFieldTypeString, alias: FHI5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI5Risk (type: esriFieldTypeInteger, alias: FHI5Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI6 (type: esriFieldTypeString, alias: FHI6, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI6Risk (type: esriFieldTypeInteger, alias: FHI6Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI7 (type: esriFieldTypeString, alias: FHI7, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI7Risk (type: esriFieldTypeInteger, alias: FHI7Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI8 (type: esriFieldTypeString, alias: FHI8, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI8Risk (type: esriFieldTypeInteger, alias: FHI8Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHI9 (type: esriFieldTypeString, alias: FHI9, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FHI9Risk (type: esriFieldTypeInteger, alias: FHI9Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHIScore (type: esriFieldTypeString, alias: FHIScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• FHIRiskScore (type: esriFieldTypeString, alias: FHIRiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• AC1 (type: esriFieldTypeString, alias: AC1, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC1Risk (type: esriFieldTypeInteger, alias: AC1Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC1Comments (type: esriFieldTypeString, alias: CastAC1Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC2 (type: esriFieldTypeString, alias: AC2, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC2Risk (type: esriFieldTypeInteger, alias: AC2Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC2Comments (type: esriFieldTypeString, alias: CastAC2Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC3 (type: esriFieldTypeString, alias: AC3, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC3Risk (type: esriFieldTypeInteger, alias: AC3Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC3Comments (type: esriFieldTypeString, alias: CastAC3Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC4 (type: esriFieldTypeString, alias: AC4, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC4Risk (type: esriFieldTypeInteger, alias: AC4Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC4Comments (type: esriFieldTypeString, alias: CastAC4Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC5 (type: esriFieldTypeString, alias: AC5, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC5Risk (type: esriFieldTypeInteger, alias: AC5Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC5Comments (type: esriFieldTypeString, alias: CastAC5Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC6 (type: esriFieldTypeString, alias: AC6, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC6Risk (type: esriFieldTypeInteger, alias: AC6Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC6Comments (type: esriFieldTypeString, alias: CastAC6Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC7 (type: esriFieldTypeString, alias: AC7, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC7Risk (type: esriFieldTypeInteger, alias: AC7Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC7Comments (type: esriFieldTypeString, alias: CastAC7Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC8 (type: esriFieldTypeString, alias: AC8, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC8Risk (type: esriFieldTypeInteger, alias: AC8Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC8Comments (type: esriFieldTypeString, alias: CastAC8Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• AC9 (type: esriFieldTypeString, alias: AC9, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AC9Risk (type: esriFieldTypeInteger, alias: AC9Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastAC9Comments (type: esriFieldTypeString, alias: CastAC9Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ACScore (type: esriFieldTypeString, alias: ACScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ACRiskScore (type: esriFieldTypeString, alias: ACRiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• TA (type: esriFieldTypeString, alias: TA, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• TotalScore (type: esriFieldTypeString, alias: TotalScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• TotalRiskScore (type: esriFieldTypeString, alias: TotalRiskScore, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• NullScores (type: esriFieldTypeInteger, alias: NullScores, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NullRiskScores (type: esriFieldTypeInteger, alias: NullRiskScores, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CastManagementRecommendations (type: esriFieldTypeString, alias: CastManagementRecommendations, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• initialtimestamp (type: esriFieldTypeDate, alias: initialtimestamp, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: tbl_seapscore
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• tbl_Surveys (96) -- Related To: tbl_Surveys (46)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/2/2023 1:46:40 AM

Schema Last Edit Date: 3/2/2023 1:46:40 AM

Data Last Edit Date: 3/2/2023 1:46:40 AM

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