View In:   ArcGIS Online Map Viewer

Name: DAPSTOM ICES format (Integrated database and portal for fish stomach records)

Display Field: tblHaulID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 7eee9138316c4571b3d9d68813b02196

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -56.59999847399996
YMin: 43.65299987800006
XMax: 49.90000152600004
YMax: 80.08300018300008
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [175, 51, 121, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• tblHaulID ( type: esriFieldTypeString, alias: tblHaulID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tblHaulID )
• StationNumber ( type: esriFieldTypeString, alias: StationNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StationNumber )
• tblPredatorInformationID ( type: esriFieldTypeString, alias: tblPredatorInformationID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tblPredatorInformationID )
• tblUploadID ( type: esriFieldTypeString, alias: tblUploadID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: tblUploadID )
• HaulNo ( type: esriFieldTypeString, alias: HaulNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HaulNo )
• ICESDatabase ( type: esriFieldTypeString, alias: ICESDatabase, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ICESDatabase )
• haul_id ( type: esriFieldTypeString, alias: haul_id, editable: true, nullable: true, length: 40, defaultValue: null, modelName: haul_id )
• Year ( type: esriFieldTypeInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• Month ( type: esriFieldTypeInteger, alias: Month, editable: true, nullable: true, defaultValue: null, modelName: Month )
• Day ( type: esriFieldTypeInteger, alias: Day, editable: true, nullable: true, defaultValue: null, modelName: Day )
• station ( type: esriFieldTypeString, alias: station, editable: true, nullable: true, length: 10, defaultValue: null, modelName: station )
• quarter ( type: esriFieldTypeInteger, alias: quarter, editable: true, nullable: true, defaultValue: null, modelName: quarter )
• sea ( type: esriFieldTypeString, alias: sea, editable: true, nullable: true, length: 30, defaultValue: null, modelName: sea )
• ices_division ( type: esriFieldTypeString, alias: ices_division, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ices_division )
• ICESrectangle ( type: esriFieldTypeString, alias: ICESrectangle, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ICESrectangle )
• HaulLat ( type: esriFieldTypeSingle, alias: HaulLat, editable: true, nullable: true, defaultValue: null, modelName: HaulLat )
• HaulLong ( type: esriFieldTypeSingle, alias: HaulLong, editable: true, nullable: true, defaultValue: null, modelName: HaulLong )
• ShootLat ( type: esriFieldTypeSingle, alias: ShootLat, editable: true, nullable: true, defaultValue: null, modelName: ShootLat )
• ShootLong ( type: esriFieldTypeSingle, alias: ShootLong, editable: true, nullable: true, defaultValue: null, modelName: ShootLong )
• Depth ( type: esriFieldTypeSingle, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• Survey ( type: esriFieldTypeString, alias: Survey, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Survey )
• Time ( type: esriFieldTypeDate, alias: Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Time )
• GravMethod ( type: esriFieldTypeString, alias: GravMethod, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: GravMethod )
• UnitWgt ( type: esriFieldTypeString, alias: UnitWgt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UnitWgt )
• UnitLngt ( type: esriFieldTypeString, alias: UnitLngt, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UnitLngt )
• ship_code ( type: esriFieldTypeString, alias: ship_code, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ship_code )
• Ship ( type: esriFieldTypeString, alias: Ship, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Ship )
• Gear ( type: esriFieldTypeString, alias: Gear, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Gear )
• data_derived_from ( type: esriFieldTypeString, alias: data_derived_from, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: data_derived_from )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 600, defaultValue: null, modelName: Notes )
• pred_id ( type: esriFieldTypeString, alias: pred_id, editable: true, nullable: true, length: 40, defaultValue: null, modelName: pred_id )
• Number ( type: esriFieldTypeInteger, alias: Number, editable: true, nullable: true, defaultValue: null, modelName: Number )
• pred_length_cm ( type: esriFieldTypeSingle, alias: pred_length_cm, editable: true, nullable: true, defaultValue: null, modelName: pred_length_cm )
• IndWgt ( type: esriFieldTypeSingle, alias: IndWgt, editable: true, nullable: true, defaultValue: null, modelName: IndWgt )
• Age ( type: esriFieldTypeString, alias: Age, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Age )
• pred_tsn ( type: esriFieldTypeInteger, alias: pred_tsn, editable: true, nullable: true, defaultValue: null, modelName: pred_tsn )
• AphiaIDPredator ( type: esriFieldTypeInteger, alias: AphiaIDPredator, editable: true, nullable: true, defaultValue: null, modelName: AphiaIDPredator )
• tblPreyInformationID ( type: esriFieldTypeInteger, alias: tblPreyInformationID, editable: true, nullable: true, defaultValue: null, modelName: tblPreyInformationID )
• Count ( type: esriFieldTypeInteger, alias: Count, editable: true, nullable: true, defaultValue: null, modelName: Count )
• calc_ind_prey_wgt_g ( type: esriFieldTypeSingle, alias: calc_ind_prey_wgt_g, editable: true, nullable: true, defaultValue: null, modelName: calc_ind_prey_wgt_g )
• ind_prey_wgt_g ( type: esriFieldTypeSingle, alias: ind_prey_wgt_g, editable: true, nullable: true, defaultValue: null, modelName: ind_prey_wgt_g )
• prey_length_cm ( type: esriFieldTypeSingle, alias: prey_length_cm, editable: true, nullable: true, defaultValue: null, modelName: prey_length_cm )
• DigestionStage ( type: esriFieldTypeString, alias: DigestionStage, editable: true, nullable: true, length: 6, defaultValue: null, modelName: DigestionStage )
• prey_tsn ( type: esriFieldTypeInteger, alias: prey_tsn, editable: true, nullable: true, defaultValue: null, modelName: prey_tsn )
• AphiaIDPrey ( type: esriFieldTypeInteger, alias: AphiaIDPrey, editable: true, nullable: true, defaultValue: null, modelName: AphiaIDPrey )
• Weight ( type: esriFieldTypeDouble, alias: Weight, editable: true, nullable: true, defaultValue: null, modelName: Weight )
• Code ( type: esriFieldTypeString, alias: Code, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Code )
• Sex ( type: esriFieldTypeString, alias: Sex, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sex )
• MaturityScale ( type: esriFieldTypeString, alias: MaturityScale, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaturityScale )
• MaturityStage ( type: esriFieldTypeString, alias: MaturityStage, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaturityStage )
• PreservationMethod ( type: esriFieldTypeString, alias: PreservationMethod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreservationMethod )
• Regurgitated ( type: esriFieldTypeString, alias: Regurgitated, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Regurgitated )
• StomachFullness ( type: esriFieldTypeString, alias: StomachFullness, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StomachFullness )
• FullStomWgt ( type: esriFieldTypeString, alias: FullStomWgt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FullStomWgt )
• EmptyStomWgt ( type: esriFieldTypeString, alias: EmptyStomWgt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EmptyStomWgt )
• StomachEmpty ( type: esriFieldTypeString, alias: StomachEmpty, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StomachEmpty )
• GenSamp ( type: esriFieldTypeString, alias: GenSamp, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GenSamp )
• FishID ( type: esriFieldTypeString, alias: FishID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FishID )
• AnalysingOrg ( type: esriFieldTypeString, alias: AnalysingOrg, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AnalysingOrg )
• IdentMet ( type: esriFieldTypeString, alias: IdentMet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IdentMet )
• SubFactor ( type: esriFieldTypeString, alias: SubFactor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SubFactor )
• PreySequence ( type: esriFieldTypeString, alias: PreySequence, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreySequence )
• OtherItems ( type: esriFieldTypeString, alias: OtherItems, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OtherItems )
• OtherCount ( type: esriFieldTypeString, alias: OtherCount, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OtherCount )
• OtherWgt ( type: esriFieldTypeString, alias: OtherWgt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OtherWgt )

Templates:

• Name: DAPSTOM ICES format (Integrated database and portal for fish stomach records)
  Description:
  Prototype:
  OtherCount: null
  OtherWgt: null
  tblHaulID: null
  StationNumber: null
  tblPredatorInformationID: null
  tblUploadID: null
  HaulNo: null
  ICESDatabase: null
  haul_id: null
  Year: null
  Month: null
  Day: null
  station: null
  quarter: null
  sea: null
  ices_division: null
  ICESrectangle: null
  HaulLat: null
  HaulLong: null
  ShootLat: null
  ShootLong: null
  Depth: null
  Survey: null
  Time: null
  GravMethod: null
  UnitWgt: null
  UnitLngt: null
  ship_code: null
  Ship: null
  Gear: null
  data_derived_from: null
  Notes: null
  pred_id: null
  Number: null
  pred_length_cm: null
  IndWgt: null
  Age: null
  pred_tsn: null
  AphiaIDPredator: null
  tblPreyInformationID: null
  Count: null
  calc_ind_prey_wgt_g: null
  ind_prey_wgt_g: null
  prey_length_cm: null
  DigestionStage: null
  prey_tsn: null
  AphiaIDPrey: null
  Weight: null
  Code: null
  Sex: null
  MaturityScale: null
  MaturityStage: null
  PreservationMethod: null
  Regurgitated: null
  StomachFullness: null
  FullStomWgt: null
  EmptyStomWgt: null
  StomachEmpty: null
  GenSamp: null
  FishID: null
  AnalysingOrg: null
  IdentMet: null
  SubFactor: null
  PreySequence: null
  OtherItems: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata