Name: Upland_Bird_Hunter_Diary_Table

Display Field: firstname

Type: Table

Geometry Type: N/A

Description: Protected view of the Wild Upland Game Bird Hunter Diary records collected by the Section of Wildlife, Division of Fish and Wildlife, MNDNR. <font face="Avenir Next W01, Avenir Next W00, Avenir Next, Avenir, Helvetica Neue, sans-serif"><span style="font-size:16px;">Wild bird hunter diary</span></font> survey is used to collect location and hunt information for upland game birds in Minnesota. <span style="font-family:"Avenir Next W01", "Avenir Next W00", "Avenir Next", Avenir, "Helvetica Neue", sans-serif; font-size:16px;">Users submit the county location, report the public land information, and counts of hunted game birds. Contact information is collected for follow up purposes.</span>

Service Item Id: 805986f1e988469ab7361c74c24a38c8

Copyright Text: Section of Wildlife, Division of Fish and Wildlife, MNDNR, MNIT Business Services

Default Visibility: false

MaxRecordCount: 1000

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

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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• firstname ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: firstname, alias: First Name: )
• lastname ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: lastname, alias: Last Name: )
• email ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: email, alias: Email Address: )
• warn ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: warn, alias: Tennesseen Warning )
• mapq ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: mapq, alias: How would you like to report the location of the hunt? (Your hunt location will not be made public regardless) , Coded Values: [Map: Use Map] , [Describe: Enter County and City] )
• county ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: county, alias: County: , Coded Values: [aitkin: Aitkin] , [anoka: Anoka] , [becker: Becker] , ...84 more... )
• near_city ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: near_city, alias: Nearest City: )
• city_dist ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: city_dist, alias: Distance (miles) from nearest city: )
• card_dir ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: card_dir, alias: Cardinal direction from nearest city: , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• public_land ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: public_land, alias: Were you hunting on Public Land? , Coded Values: [yes: Yes] , [no: No] )
• wma ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: wma, alias: Did you hunt on a Wildlife Management Area? , Coded Values: [yes: Yes] , [no: No] )
• hwt ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: hwt, alias: Did you hunting on a Hunter Walking Trail? , Coded Values: [yes: Yes] , [no: No] )
• species ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: species, alias: Species )
• dog_hunt ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: dog_hunt, alias: Hunted with a Dog? , Coded Values: [yes: Yes] , [no: No] )
• hours_hunt ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: hours_hunt, alias: Total Hours Hunted? )
• total_ruffed_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_ruffed_flushed, alias: Total Ruffed Grouse Flushed: )
• total_ruffed_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_ruffed_shot, alias: Total Ruffed Grouse Bagged: )
• total_woodcock_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_woodcock_flushed, alias: Total American Woodcock Flushed: )
• total_woodcock_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_woodcock_shot, alias: Total American Woodcock Bagged: )
• total_spruce_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_spruce_flushed, alias: Total Spruce Grouse Flushed: )
• total_spruce_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_spruce_shot, alias: Total Spruce Grouse Bagged: )
• total_sharpie_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_sharpie_flushed, alias: Total Sharp-tailed Grouse Flushed: )
• total_sharpie_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_sharpie_shot, alias: Total Sharp-tailed Grouse Bagged: )
• total_chicken_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_chicken_flushed, alias: Total Greater Prairie Chicken Flushed: )
• total_chicken_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_chicken_shot, alias: Total Greater Prairie Chicken Bagged: )
• total_hun_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_hun_flushed, alias: Total Hungarian Partridge Flushed: )
• total_hun_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_hun_shot, alias: Total Hungarian Partridge Bagged: )
• total_malephez_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_malephez_flushed, alias: Total Male Pheasants Flushed )
• total_femalephez_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_femalephez_flushed, alias: Total Female Pheasants Flushed: )
• total_phez_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_phez_shot, alias: Total Wild Pheasant Bagged: )
• created_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• created_user ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• last_edited_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• last_edited_user ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• huntdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: huntdate, alias: Date of hunt: )
• wia ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: wia, alias: Did you hunt on a DNR walk-in-access site? )
• total_snipe_flushed ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_snipe_flushed, alias: Total Snipe Flushed: )
• total_snipe_shot ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: total_snipe_shot, alias: Total Snipe Bagged: )
• hunter_zipcode ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: hunter_zipcode, alias: Hunter Zip Code )
• phez_agesex1 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: phez_agesex1, alias: Pheasant Bagged 1 )
• phez_agesex2 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: phez_agesex2, alias: Pheasant Bagged 2 )
• phez_agesex3 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: phez_agesex3, alias: Pheasant Bagged 3 )
• ruffed_agesex1 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: ruffed_agesex1, alias: Ruffed Grouse Bagged 1 )
• ruffed_agesex2 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: ruffed_agesex2, alias: Ruffed Grouse Bagged 2 )
• ruffed_agesex3 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: ruffed_agesex3, alias: Ruffed Grouse Bagged 3 )
• ruffed_agesex4 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: ruffed_agesex4, alias: Ruffed Grouse Bagged 4 )
• ruffed_agesex5 ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: ruffed_agesex5, alias: Ruffed Grouse Bagged 5 )
• wia_site_number ( nullable: true, editable: true, defaultValue: null, length: 256, type: esriFieldTypeString, modelName: wia_site_number, alias: WIA Site Number )
• x ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: x, alias: x )
• y ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: y, alias: y )
• format_date ( nullable: true, editable: true, defaultValue: null, length: 256, alias: format date, type: esriFieldTypeString )

Templates:

• Name: Upland_Bird_Hunter_Diary_Table
  Description:
  Prototype:
  county: null
  total_hun_flushed: null
  public_land: null
  created_user: null
  mapq: null
  total_chicken_shot: null
  total_spruce_shot: null
  lastname: null
  warn: null
  huntdate: null
  total_hun_shot: null
  total_woodcock_shot: null
  firstname: null
  total_ruffed_flushed: null
  total_sharpie_shot: null
  hwt: null
  total_snipe_shot: null
  total_chicken_flushed: null
  total_woodcock_flushed: null
  wma: null
  near_city: null
  dog_hunt: null
  wia: null
  total_ruffed_shot: null
  wia_site_number: null
  hours_hunt: null
  card_dir: null
  last_edited_date: null
  total_spruce_flushed: null
  email: null
  total_snipe_flushed: null
  total_malephez_flushed: null
  ruffed_agesex4: null
  total_femalephez_flushed: null
  ruffed_agesex5: null
  total_phez_shot: null
  last_edited_user: null
  phez_agesex3: null
  phez_agesex2: null
  city_dist: null
  phez_agesex1: null
  species: null
  x: null
  total_sharpie_flushed: null
  ruffed_agesex2: null
  y: null
  ruffed_agesex3: null
  created_date: null
  ruffed_agesex1: null
  hunter_zipcode: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Create,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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