Name: dbo.MAFACpopulationsNOSA10Recent

Display Field: populationname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1d0a76e03996496fbacbca41656e3e98

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• popid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: popid, alias: PopID )
• populationname ( modelName: populationname, nullable: true, editable: true, defaultValue: null, length: 120, alias: PopulationName, type: esriFieldTypeString )
• superpopulation ( modelName: superpopulation, nullable: true, editable: true, defaultValue: null, length: 120, alias: Superpopulation, type: esriFieldTypeString )
• superpopid ( modelName: superpopid, nullable: true, editable: true, defaultValue: null, alias: SuperPopID, type: esriFieldTypeInteger )
• spawningyear ( modelName: spawningyear, nullable: true, editable: true, defaultValue: null, alias: SpawningYear, type: esriFieldTypeSmallInteger )
• nosa ( modelName: nosa, nullable: true, editable: true, defaultValue: null, alias: NOSA, type: esriFieldTypeInteger )
• nosaij ( modelName: nosaij, nullable: true, editable: true, defaultValue: null, alias: NOSAIJ, type: esriFieldTypeInteger )
• nosaej ( modelName: nosaej, nullable: true, editable: true, defaultValue: null, alias: NOSAEJ, type: esriFieldTypeInteger )
• lognosa ( modelName: lognosa, nullable: true, editable: true, defaultValue: null, alias: LogNOSA, type: esriFieldTypeDouble )
• tsa ( modelName: tsa, nullable: true, editable: true, defaultValue: null, alias: TSA, type: esriFieldTypeInteger )
• logtsa ( modelName: logtsa, nullable: true, editable: true, defaultValue: null, alias: LogTSA, type: esriFieldTypeDouble )
• includesjacks ( modelName: includesjacks, nullable: true, editable: true, defaultValue: null, length: 3, alias: IncludesJacks, type: esriFieldTypeString )
• nobroodstockremoved ( modelName: nobroodstockremoved, nullable: true, editable: true, defaultValue: null, alias: NOBroodStockRemoved, type: esriFieldTypeInteger )
• lognobroodstockremoved ( modelName: lognobroodstockremoved, nullable: true, editable: true, defaultValue: null, alias: LogNOBroodStockRemoved, type: esriFieldTypeDouble )
• rownum ( modelName: rownum, nullable: true, editable: true, defaultValue: null, alias: RowNum, type: esriFieldTypeDouble )
• id ( modelName: id, nullable: true, editable: true, defaultValue: null, length: 38, alias: ID, type: esriFieldTypeGUID )
• publish ( modelName: publish, nullable: true, editable: true, defaultValue: null, length: 3, alias: Publish, type: esriFieldTypeString )
• compilerrecordid ( modelName: compilerrecordid, nullable: true, editable: true, defaultValue: null, length: 3, alias: CompilerRecordID, type: esriFieldTypeString )
• upddate ( modelName: upddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: UpdDate, type: esriFieldTypeDate )
• snloaddate ( modelName: snloaddate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: SNLoadDate, type: esriFieldTypeDate )
• validationdate ( modelName: validationdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: ValidationDate, type: esriFieldTypeDate )
• hli_lastupdated ( modelName: hli_lastupdated, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: HLI_LastUpdated, type: esriFieldTypeDate )
• lastupdated ( modelName: lastupdated, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LastUpdated, type: esriFieldTypeDate )
• apikey ( modelName: apikey, nullable: true, editable: true, defaultValue: null, length: 36, alias: apikey, type: esriFieldTypeString )

Templates:

• Name: dbo.MAFACpopulationsNOSA10Recent
  Description:
  Prototype:
  nobroodstockremoved: null
  lognobroodstockremoved: null
  snloaddate: null
  spawningyear: null
  tsa: null
  apikey: null
  logtsa: null
  rownum: null
  upddate: null
  hli_lastupdated: null
  nosaej: null
  superpopid: null
  nosaij: null
  publish: null
  includesjacks: null
  lastupdated: null
  populationname: null
  superpopulation: null
  lognosa: null
  id: null
  nosa: null
  validationdate: null
  compilerrecordid: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata