View In:   ArcGIS Online Map Viewer

Name: Prime Farmland

Display Field: muname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Displays the Farmland Classification field of the oki.sde.Soils feature class. Farmland classification identifies map units as prime farmland, farmland of statewide importance, farmland of local importance, or unique farmland. It identifies the location and extent of the soils that are best suited to food, feed, fiber, forage, and oilseed crops. NRCS policy and procedures on prime and unique farmlands are published in the "Federal Register," Vol. 43, No. 21, January 31, 1978.This dataset contains soil data for the eight county OKI region from the NRCS SSURGO database, updated in October 2014 and compiled for OKI in December 2014 using the NRCS Soil Data Viewer 6.1. Attribute data includes soils taxonomy classifications, farmland classification, drainage/runoff characteristics, septic tank absorption class, and other soil property data. See OKISoils_DataDictionary.xlsx  for a complete listing of attribute data and descriptions.

Service Item Id: ebb833e2e63c4f1182e81700387f3e50

Copyright Text: NRCS: (Soil Survey Staff, Natural Resources Conservation Service, United States Department of Agriculture. Web Soil Survey. Available online at http://websoilsurvey.nrcs.usda.gov/. Accessed [12/20/2014].), OKI Regional Council of Governments

Default Visibility: false

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

Extent:

XMin: 1219853.690193817
YMin: 284978.61462032795
XMax: 1552200.642624572
YMax: 585054.3497695029
Spatial Reference: 102723  (3735)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: farmlandclass
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: All areas are prime farmland
  Label: All areas are prime farmland
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [171, 205, 101, 255]
  Outline:
  N/A
• Value: Prime farmland if drained
  Label: Prime farmland if drained
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Prime farmland if drained and either protected from flooding or not frequently flooded during the growing season
  Label: Prime farmland if drained
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Prime farmland if protected from flooding or not frequently flooded during the growing season
  Label: Prime farmland if drained
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Farmland of local importance
  Label: Farmland of local or statewide importance
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 76, 0, 255]
  Outline:
  N/A
• Value: Farmland of statewide importance
  Label: Farmland of local or statewide importance
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [115, 76, 0, 255]
  Outline:
  N/A
Transparency: 40
Labeling Info:

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: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: farmlandclass

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: objectid )
• areasymbol ( modelName: areasymbol, nullable: true, editable: true, defaultValue: null, length: 20, alias: areasymbol, type: esriFieldTypeString )
• spatialver ( modelName: spatialver, nullable: true, editable: true, defaultValue: null, alias: spatialver, type: esriFieldTypeDouble )
• musym ( modelName: musym, nullable: true, editable: true, defaultValue: null, length: 6, alias: musym, type: esriFieldTypeString )
• mukey ( modelName: mukey, nullable: true, editable: true, defaultValue: null, length: 30, alias: mukey, type: esriFieldTypeString )
• muname ( modelName: muname, nullable: true, editable: true, defaultValue: null, length: 175, alias: muname, type: esriFieldTypeString )
• component ( modelName: component, nullable: true, editable: true, defaultValue: null, length: 254, alias: component, type: esriFieldTypeString )
• farmlandclass ( modelName: FarmlandClass, nullable: true, editable: true, defaultValue: null, length: 50, alias: farmlandclass, type: esriFieldTypeString )
• parentmaterial ( modelName: ParentMaterial, nullable: true, editable: true, defaultValue: null, length: 100, alias: parentmaterial, type: esriFieldTypeString )
• depthfragipan ( modelName: DepthFragipan, nullable: true, editable: true, defaultValue: null, alias: depthfragipan, type: esriFieldTypeSmallInteger )
• depthlithicrock ( modelName: DepthLithicRock, nullable: true, editable: true, defaultValue: null, alias: depthlithicrock, type: esriFieldTypeSmallInteger )
• depthparalithicrock ( modelName: DepthParalithicRock, nullable: true, editable: true, defaultValue: null, alias: depthparalithicrock, type: esriFieldTypeSmallInteger )
• depthwatertable ( modelName: DepthWaterTable, nullable: true, editable: true, defaultValue: null, alias: depthwatertable, type: esriFieldTypeSmallInteger )
• floodfrequency ( modelName: FloodFrequency, nullable: true, editable: true, defaultValue: null, length: 15, alias: floodfrequency, type: esriFieldTypeString )
• pondingfrequency ( modelName: PondingFrequency, nullable: true, editable: true, defaultValue: null, length: 10, alias: pondingfrequency, type: esriFieldTypeString )
• taxonomyclass ( modelName: TaxonomyClass, nullable: true, editable: true, defaultValue: null, length: 100, alias: taxonomyclass, type: esriFieldTypeString )
• greatgroup ( modelName: GreatGroup, nullable: true, editable: true, defaultValue: null, length: 20, alias: greatgroup, type: esriFieldTypeString )
• drainageclass ( modelName: DrainageClass, nullable: true, editable: true, defaultValue: null, length: 35, alias: drainageclass, type: esriFieldTypeString )
• hydrologicgroupclass ( modelName: HydrologicGroupClass, nullable: true, editable: true, defaultValue: null, length: 5, alias: hydrologicgroupclass, type: esriFieldTypeString )
• taxorder ( modelName: TaxOrder, nullable: true, editable: true, defaultValue: null, length: 15, alias: taxorder, type: esriFieldTypeString )
• taxsuborder ( modelName: TaxSuborder, nullable: true, editable: true, defaultValue: null, length: 25, alias: taxsuborder, type: esriFieldTypeString )
• subgroup ( modelName: SubGroup, nullable: true, editable: true, defaultValue: null, length: 30, alias: subgroup, type: esriFieldTypeString )
• tempregime ( modelName: TempRegime, nullable: true, editable: true, defaultValue: null, length: 15, alias: tempregime, type: esriFieldTypeString )
• particlesize ( modelName: ParticleSize, nullable: true, editable: true, defaultValue: null, length: 50, alias: particlesize, type: esriFieldTypeString )
• landform ( modelName: Landform, nullable: true, editable: true, defaultValue: null, length: 50, alias: landform, type: esriFieldTypeString )
• percentslope ( modelName: PercentSlope, nullable: true, editable: true, defaultValue: null, alias: percentslope, type: esriFieldTypeDouble )
• runoff ( modelName: Runoff, nullable: true, editable: true, defaultValue: null, length: 15, alias: runoff, type: esriFieldTypeString )
• septictankabsorptionclass ( modelName: SepticTankAbsorptionClass, nullable: true, editable: true, defaultValue: null, length: 30, alias: septictankabsorptionclass, type: esriFieldTypeString )
• frostfreedays ( modelName: FrostFreeDays, nullable: true, editable: true, defaultValue: null, alias: frostfreedays, type: esriFieldTypeSmallInteger )
• frostaction ( modelName: FrostAction, nullable: true, editable: true, defaultValue: null, length: 30, alias: frostaction, type: esriFieldTypeString )
• availablewatersupply100cm ( modelName: AvailableWaterSupply100cm, nullable: true, editable: true, defaultValue: null, alias: availablewatersupply100cm, type: esriFieldTypeDouble )
• landcapabilityclass ( modelName: LandCapabilityClass, nullable: true, editable: true, defaultValue: null, alias: landcapabilityclass, type: esriFieldTypeSmallInteger )
• watertabledepthannmin ( modelName: WaterTableDepthAnnMin, nullable: true, editable: true, defaultValue: null, alias: watertabledepthannmin, type: esriFieldTypeSmallInteger )
• k_factor ( modelName: K_Factor, nullable: true, editable: true, defaultValue: null, alias: k_factor, type: esriFieldTypeDouble )
• t_factor ( modelName: T_Factor, nullable: true, editable: true, defaultValue: null, alias: t_factor, type: esriFieldTypeSmallInteger )
• perimeter ( modelName: Perimeter, nullable: true, editable: true, defaultValue: null, alias: perimeter, type: esriFieldTypeDouble )
• ls_factor ( modelName: LS_Factor, nullable: true, editable: true, defaultValue: null, alias: ls_factor, type: esriFieldTypeDouble )
• rusle ( modelName: RUSLE, nullable: true, editable: true, defaultValue: null, alias: rusle, type: esriFieldTypeDouble )
• nlcd2011_majority ( modelName: NLCD2011_majority, nullable: true, editable: true, defaultValue: null, alias: nlcd2011_majority, type: esriFieldTypeSmallInteger )
• c_factor ( modelName: C_Factor, nullable: true, editable: true, defaultValue: null, alias: c_factor, type: esriFieldTypeDouble )
• nlcd2011_text ( modelName: NLCD2011_text, nullable: true, editable: true, defaultValue: null, length: 50, alias: nlcd2011_text, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Types:

ID: All areas are prime farmland
Name: All areas are prime farmland
Domains:
Templates:
• Name: All areas are prime farmland
  Description:
  Prototype:
  mukey: null
  depthfragipan: null
  k_factor: null
  subgroup: null
  floodfrequency: null
  frostfreedays: null
  hydrologicgroupclass: null
  taxsuborder: null
  particlesize: null
  landform: null
  ls_factor: null
  depthlithicrock: null
  frostaction: null
  spatialver: null
  muname: null
  taxorder: null
  areasymbol: null
  percentslope: null
  depthparalithicrock: null
  pondingfrequency: null
  depthwatertable: null
  nlcd2011_majority: null
  tempregime: null
  runoff: null
  musym: null
  landcapabilityclass: null
  taxonomyclass: null
  availablewatersupply100cm: null
  component: null
  c_factor: null
  rusle: null
  watertabledepthannmin: null
  t_factor: null
  perimeter: null
  parentmaterial: null
  nlcd2011_text: null
  drainageclass: null
  farmlandclass: All areas are prime farmland
  greatgroup: null
  septictankabsorptionclass: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Prime farmland if drained
Name: Prime farmland if drained
Domains:
Templates:
• Name: Prime farmland if drained
  Description:
  Prototype:
  mukey: null
  depthfragipan: null
  k_factor: null
  subgroup: null
  floodfrequency: null
  frostfreedays: null
  hydrologicgroupclass: null
  taxsuborder: null
  particlesize: null
  landform: null
  ls_factor: null
  depthlithicrock: null
  frostaction: null
  spatialver: null
  muname: null
  taxorder: null
  areasymbol: null
  percentslope: null
  depthparalithicrock: null
  pondingfrequency: null
  depthwatertable: null
  nlcd2011_majority: null
  tempregime: null
  runoff: null
  musym: null
  landcapabilityclass: null
  taxonomyclass: null
  availablewatersupply100cm: null
  component: null
  c_factor: null
  rusle: null
  watertabledepthannmin: null
  t_factor: null
  perimeter: null
  parentmaterial: null
  nlcd2011_text: null
  drainageclass: null
  farmlandclass: Prime farmland if drained
  greatgroup: null
  septictankabsorptionclass: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Prime farmland if drained and either protected from flooding or not frequently flooded during the growing season
Name: Prime farmland if drained
Domains:
Templates:
• Name: Prime farmland if drained and either protected from flooding or not frequently flooded during the growing season
  Description:
  Prototype:
  mukey: null
  depthfragipan: null
  k_factor: null
  subgroup: null
  floodfrequency: null
  frostfreedays: null
  hydrologicgroupclass: null
  taxsuborder: null
  particlesize: null
  landform: null
  ls_factor: null
  depthlithicrock: null
  frostaction: null
  spatialver: null
  muname: null
  taxorder: null
  areasymbol: null
  percentslope: null
  depthparalithicrock: null
  pondingfrequency: null
  depthwatertable: null
  nlcd2011_majority: null
  tempregime: null
  runoff: null
  musym: null
  landcapabilityclass: null
  taxonomyclass: null
  availablewatersupply100cm: null
  component: null
  c_factor: null
  rusle: null
  watertabledepthannmin: null
  t_factor: null
  perimeter: null
  parentmaterial: null
  nlcd2011_text: null
  drainageclass: null
  farmlandclass: Prime farmland if drained and either protected from flooding or not frequently flooded during the growing season
  greatgroup: null
  septictankabsorptionclass: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Prime farmland if protected from flooding or not frequently flooded during the growing season
Name: Prime farmland if drained
Domains:
Templates:
• Name: Prime farmland if protected from flooding or not frequently flooded during the growing season
  Description:
  Prototype:
  mukey: null
  depthfragipan: null
  k_factor: null
  subgroup: null
  floodfrequency: null
  frostfreedays: null
  hydrologicgroupclass: null
  taxsuborder: null
  particlesize: null
  landform: null
  ls_factor: null
  depthlithicrock: null
  frostaction: null
  spatialver: null
  muname: null
  taxorder: null
  areasymbol: null
  percentslope: null
  depthparalithicrock: null
  pondingfrequency: null
  depthwatertable: null
  nlcd2011_majority: null
  tempregime: null
  runoff: null
  musym: null
  landcapabilityclass: null
  taxonomyclass: null
  availablewatersupply100cm: null
  component: null
  c_factor: null
  rusle: null
  watertabledepthannmin: null
  t_factor: null
  perimeter: null
  parentmaterial: null
  nlcd2011_text: null
  drainageclass: null
  farmlandclass: Prime farmland if protected from flooding or not frequently flooded during the growing season
  greatgroup: null
  septictankabsorptionclass: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Farmland of local importance
Name: Farmland of local or statewide importance
Domains:
Templates:
• Name: Farmland of local or statewide importance
  Description:
  Prototype:
  mukey: null
  depthfragipan: null
  k_factor: null
  subgroup: null
  floodfrequency: null
  frostfreedays: null
  hydrologicgroupclass: null
  taxsuborder: null
  particlesize: null
  landform: null
  ls_factor: null
  depthlithicrock: null
  frostaction: null
  spatialver: null
  muname: null
  taxorder: null
  areasymbol: null
  percentslope: null
  depthparalithicrock: null
  pondingfrequency: null
  depthwatertable: null
  nlcd2011_majority: null
  tempregime: null
  runoff: null
  musym: null
  landcapabilityclass: null
  taxonomyclass: null
  availablewatersupply100cm: null
  component: null
  c_factor: null
  rusle: null
  watertabledepthannmin: null
  t_factor: null
  perimeter: null
  parentmaterial: null
  nlcd2011_text: null
  drainageclass: null
  farmlandclass: Farmland of local importance
  greatgroup: null
  septictankabsorptionclass: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Farmland of statewide importance
Name: Farmland of local or statewide importance
Domains:
Templates:
• Name: Farmland of local or statewide importance
  Description:
  Prototype:
  mukey: null
  depthfragipan: null
  k_factor: null
  subgroup: null
  floodfrequency: null
  frostfreedays: null
  hydrologicgroupclass: null
  taxsuborder: null
  particlesize: null
  landform: null
  ls_factor: null
  depthlithicrock: null
  frostaction: null
  spatialver: null
  muname: null
  taxorder: null
  areasymbol: null
  percentslope: null
  depthparalithicrock: null
  pondingfrequency: null
  depthwatertable: null
  nlcd2011_majority: null
  tempregime: null
  runoff: null
  musym: null
  landcapabilityclass: null
  taxonomyclass: null
  availablewatersupply100cm: null
  component: null
  c_factor: null
  rusle: null
  watertabledepthannmin: null
  t_factor: null
  perimeter: null
  parentmaterial: null
  nlcd2011_text: null
  drainageclass: null
  farmlandclass: Farmland of statewide importance
  greatgroup: null
  septictankabsorptionclass: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Extract

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

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

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