Name: dbo.MAFACpopulations

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 ( modelName: popid, nullable: true, editable: true, defaultValue: null, alias: PopID, type: esriFieldTypeInteger )
• 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 )
• meannosa10recent ( modelName: meannosa10recent, nullable: true, editable: true, defaultValue: null, alias: MeanNOSA10Recent, type: esriFieldTypeInteger )
• meantsa10recent ( modelName: meantsa10recent, nullable: true, editable: true, defaultValue: null, alias: MeanTSA10Recent, type: esriFieldTypeInteger )
• meannobroodstockremoved10recent ( modelName: meannobroodstockremoved10recent, nullable: true, editable: true, defaultValue: null, alias: MeanNOBroodStockRemoved10Recent, type: esriFieldTypeInteger )
• geomeannosa10recent ( modelName: geomeannosa10recent, nullable: true, editable: true, defaultValue: null, alias: GeomeanNOSA10Recent, type: esriFieldTypeInteger )
• geomeantsa10recent ( modelName: geomeantsa10recent, nullable: true, editable: true, defaultValue: null, alias: GeomeanTSA10Recent, type: esriFieldTypeInteger )
• geomeanbroodstockremoved10recen ( modelName: geomeanbroodstockremoved10recen, nullable: true, editable: true, defaultValue: null, alias: GeomeanBroodstockRemoved10Recent, type: esriFieldTypeInteger )
• minyear10recent ( modelName: minyear10recent, nullable: true, editable: true, defaultValue: null, alias: MinYear10Recent, type: esriFieldTypeSmallInteger )
• maxyear10recent ( modelName: maxyear10recent, nullable: true, editable: true, defaultValue: null, alias: MaxYear10Recent, type: esriFieldTypeSmallInteger )
• maxyear10recentnosaij ( modelName: maxyear10recentnosaij, nullable: true, editable: true, defaultValue: null, alias: MaxYear10RecentNOSAIJ, type: esriFieldTypeInteger )
• maxyear10recentnosaej ( modelName: maxyear10recentnosaej, nullable: true, editable: true, defaultValue: null, alias: MaxYear10RecentNOSAEJ, type: esriFieldTypeInteger )
• numrecords10recent ( modelName: numrecords10recent, nullable: true, editable: true, defaultValue: null, alias: NumRecords10Recent, type: esriFieldTypeDouble )
• meannosa2008_2017 ( modelName: meannosa2008_2017, nullable: true, editable: true, defaultValue: null, alias: MeanNOSA2008_2017, type: esriFieldTypeInteger )
• meantsa2008_2017 ( modelName: meantsa2008_2017, nullable: true, editable: true, defaultValue: null, alias: MeanTSA2008_2017, type: esriFieldTypeInteger )
• meannobroodstockremoved2008_201 ( modelName: meannobroodstockremoved2008_201, nullable: true, editable: true, defaultValue: null, alias: MeanNOBroodStockRemoved2008_2017, type: esriFieldTypeInteger )
• geomeannosa2008_2017 ( modelName: geomeannosa2008_2017, nullable: true, editable: true, defaultValue: null, alias: GeomeanNOSA2008_2017, type: esriFieldTypeInteger )
• geomeantsa2008_2017 ( modelName: geomeantsa2008_2017, nullable: true, editable: true, defaultValue: null, alias: GeomeanTSA2008_2017, type: esriFieldTypeInteger )
• geomeanbroodstockremoved2008_20 ( modelName: geomeanbroodstockremoved2008_20, nullable: true, editable: true, defaultValue: null, alias: GeomeanBroodstockRemoved2008_2017, type: esriFieldTypeInteger )
• minyear2008_2017 ( modelName: minyear2008_2017, nullable: true, editable: true, defaultValue: null, alias: MinYear2008_2017, type: esriFieldTypeSmallInteger )
• maxyear2008_2017 ( modelName: maxyear2008_2017, nullable: true, editable: true, defaultValue: null, alias: MaxYear2008_2017, type: esriFieldTypeSmallInteger )
• numrecords2008_2017 ( modelName: numrecords2008_2017, nullable: true, editable: true, defaultValue: null, alias: NumRecords2008_2017, 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 )
• esri_oid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: esri_oid, alias: ESRI_OID )

Templates:

• Name: dbo.MAFACpopulations
  Description:
  Prototype:
  snloaddate: null
  maxyear2008_2017: null
  upddate: null
  geomeantsa10recent: null
  numrecords10recent: null
  superpopid: null
  geomeannosa2008_2017: null
  superpopulation: null
  id: null
  meannobroodstockremoved10recent: null
  numrecords2008_2017: null
  apikey: null
  meannobroodstockremoved2008_201: null
  geomeannosa10recent: null
  geomeantsa2008_2017: null
  minyear2008_2017: null
  meantsa10recent: null
  maxyear10recentnosaij: null
  maxyear10recentnosaej: null
  geomeanbroodstockremoved10recen: null
  maxyear10recent: null
  hli_lastupdated: null
  popid: null
  minyear10recent: null
  meantsa2008_2017: null
  publish: null
  populationname: null
  meannosa10recent: null
  lastupdated: null
  validationdate: null
  geomeanbroodstockremoved2008_20: null
  compilerrecordid: null
  meannosa2008_2017: 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