Name: IYS_trawl_catch_specimen_join

Display Field: common_name

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_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• station_event_id (type: esriFieldTypeString, alias: station_event_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• original_event_id (type: esriFieldTypeString, alias: original_event_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• catch_id (type: esriFieldTypeString, alias: catch_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• original_catch_id (type: esriFieldTypeString, alias: original_catch_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• specimen_id (type: esriFieldTypeString, alias: specimen_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• original_specimen_id (type: esriFieldTypeString, alias: original_specimen_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• verbatim_identification (type: esriFieldTypeString, alias: verbatim_identification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• species_recorded (type: esriFieldTypeString, alias: species_recorded, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• common_name (type: esriFieldTypeString, alias: common_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• scientific_name (type: esriFieldTypeString, alias: scientific_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• scientific_name_id (type: esriFieldTypeString, alias: scientific_name_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lifestage (type: esriFieldTypeString, alias: lifestage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sex (type: esriFieldTypeString, alias: sex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• taxonomic_rank (type: esriFieldTypeString, alias: taxonomic_rank, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• size_class_mm (type: esriFieldTypeInteger, alias: size_class_mm, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_measured (type: esriFieldTypeInteger, alias: number_measured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• specimen_length (type: esriFieldTypeInteger, alias: specimen_length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• specimen_length_units (type: esriFieldTypeString, alias: specimen_length_units, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• length_type (type: esriFieldTypeString, alias: length_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• specimen_length2 (type: esriFieldTypeInteger, alias: specimen_length2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• specimen_length2_units (type: esriFieldTypeString, alias: specimen_length2_units, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• length_type2 (type: esriFieldTypeString, alias: length_type2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• specimen_weight (type: esriFieldTypeInteger, alias: specimen_weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• specimen_weight2 (type: esriFieldTypeInteger, alias: specimen_weight2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• weight_units (type: esriFieldTypeString, alias: weight_units, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• weight_type (type: esriFieldTypeString, alias: weight_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• marks_scars (type: esriFieldTypeString, alias: marks_scars, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• visceral_adhesion (type: esriFieldTypeString, alias: visceral_adhesion, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• station_event_id_1 (type: esriFieldTypeString, alias: station_event_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• original_event_id_1 (type: esriFieldTypeString, alias: original_event_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• catch_id_1 (type: esriFieldTypeString, alias: catch_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• original_catch_id_1 (type: esriFieldTypeString, alias: original_catch_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• verbatim_identification_1 (type: esriFieldTypeString, alias: verbatim_identification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• species_recorded_1 (type: esriFieldTypeString, alias: species_recorded, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• common_name_1 (type: esriFieldTypeString, alias: common_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• scientific_name_1 (type: esriFieldTypeString, alias: scientific_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• scientific_name_id_1 (type: esriFieldTypeString, alias: scientific_name_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• taxonomic_rank_1 (type: esriFieldTypeString, alias: taxonomic_rank, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• identified_by (type: esriFieldTypeString, alias: identified_by, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• date_identified (type: esriFieldTypeDate, alias: date_identified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifestage_1 (type: esriFieldTypeString, alias: lifestage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• catch_count (type: esriFieldTypeInteger, alias: catch_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• count_method (type: esriFieldTypeString, alias: count_method, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• catch_weight (type: esriFieldTypeDouble, alias: catch_weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• catch_weight_units (type: esriFieldTypeString, alias: catch_weight_units, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• weight_method (type: esriFieldTypeString, alias: weight_method, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• comments_1 (type: esriFieldTypeString, alias: comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: IYS_trawl_catch_specimen_join
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/13/2023 12:28:47 AM

Schema Last Edit Date: 10/12/2023 10:39:03 PM

Data Last Edit Date: 10/13/2023 12:28:47 AM

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