Name: Plan2Farm.DBO.DraftingQs

Display Field: IndDiscussGroupName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: c9de7dfeb5ce4804849b855bb063092d

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• LandholderID ( type: esriFieldTypeGUID, alias: LandholderID, length: 38 )
• CompletedBy ( type: esriFieldTypeString, alias: Assessment Completed By, length: 50 , Coded Values: [Bryony Fitzgerald: Bryony Fitzgerald] , [Carl Walters: Carl Walters] , [Charles Thompson: Charles Thompson] , ...42 more... )
• ResponseDate ( type: esriFieldTypeDate, alias: Response Date, length: 8 )
• PrimeFarmType ( type: esriFieldTypeString, alias: Primary Farm Type, length: 50 , Coded Values: [Annual Horticulture: Annual Horticulture] , [Cattle Beef: Cattle (Beef)] , [Dairy: Dairy] , ...9 more... )
• SecondFarmType ( type: esriFieldTypeString, alias: Secondary Farm Type, length: 50 , Coded Values: [Annual Horticulture: Annual Horticulture] , [Cattle Beef: Cattle (Beef)] , [Dairy: Dairy] , ...9 more... )
• TertFarmType ( type: esriFieldTypeString, alias: Tertiary Farm Type, length: 50 , Coded Values: [Annual Horticulture: Annual Horticulture] , [Cattle Beef: Cattle (Beef)] , [Dairy: Dairy] , ...9 more... )
• WaterUsage ( type: esriFieldTypeString, alias: Current Water Usage, length: 10 , Coded Values: [0_10: 0-10] , [10_50: 10-50] , [50_200: 50-200] , ...2 more... )
• FarmSizeHA ( type: esriFieldTypeString, alias: Farm Size in HA, length: 10 , Coded Values: [0_20: 0-20] , [20_150: 20-150] , [150_400: 150-400] , ...1 more... )
• Employees ( type: esriFieldTypeString, alias: Number Of Employees, length: 3 )
• ConnectionStat ( type: esriFieldTypeString, alias: Connection Status, length: 15 , Coded Values: [Completed: Completed] , [Not Applicable: Not Applicable] , [Not Completed: Not Completed] )
• FutureIrrigInt ( type: esriFieldTypeString, alias: FutureI rrigigation Intentions, length: 15 , Coded Values: [Cease: Cease] , [Decrease: Decrease] , [Increase: Increase] , ...3 more... )
• HaveFarmVision ( type: esriFieldTypeString, alias: Do you have future farm vision?, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• WhatToAchieveVision ( type: esriFieldTypeString, alias: Do you know what it will take to achieve your vision?, length: 15 , Coded Values: [Yes: Yes] , [No: No] , [NA: Not Applicable] )
• FarmingFuture ( type: esriFieldTypeString, alias: Do you intend to keep farming?, length: 6 , Coded Values: [Yes: Yes] , [No: No] , [Unsure: Unsure] )
• FutureReasons ( type: esriFieldTypeString, alias: Whye are you unsure/intend to cease farming?, length: 600 )
• OnFarmEfficency ( type: esriFieldTypeString, alias: Participated in on farm efficency program, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• OFEType ( type: esriFieldTypeString, alias: Which On Farm Efficiency Program, length: 125 )
• SuccessionPlan ( type: esriFieldTypeString, alias: Current Succession Plan, length: 50 , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• BusinessPlan ( type: esriFieldTypeString, alias: Current Business Plan, length: 50 , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• FinancialPlanBudget ( type: esriFieldTypeString, alias: Current Financial Plan/Budget, length: 50 , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• WaterBudget ( type: esriFieldTypeString, alias: Current Water Budget, length: 50 , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• WFP ( type: esriFieldTypeString, alias: Current Whole Farm Plan, length: 50 , Coded Values: [Yes: Yes] , [Yes Need Updating: Yes- Needs Updating] , [No: No] )
• TrackBusAnnualPerf ( type: esriFieldTypeString, alias: Do you track you business annual performance, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• TrachBusBench ( type: esriFieldTypeString, alias: Do you track your business benchamarking, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• TrackCashflow ( type: esriFieldTypeString, alias: Do you track cash flow, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• IndDiscussGroup ( type: esriFieldTypeString, alias: Industry Discussion Group, length: 10 , Coded Values: [Currently: Currently] , [Never: Never] , [Previously: Previously] )
• IndDiscussGroupName ( type: esriFieldTypeString, alias: Industry Discussion Group Name, length: 125 )
• TakingStock ( type: esriFieldTypeString, alias: Participated in taking stock, length: 10 , Coded Values: [Currently: Currently] , [Never: Never] , [Previously: Previously] )
• Landcare ( type: esriFieldTypeString, alias: Involved in Landcare, length: 10 , Coded Values: [Currently: Currently] , [Never: Never] , [Previously: Previously] )
• OtherGroup ( type: esriFieldTypeString, alias: Any Other Groups/Programs, length: 125 )
• UseAnimalNut ( type: esriFieldTypeString, alias: Do you currently pay an Animal Nutritionist, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• UseAgron ( type: esriFieldTypeString, alias: Do you currently pay an Agronomist, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• UseFarmBus ( type: esriFieldTypeString, alias: Do you currnetly pay a Financial Advisor, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• UseAccount ( type: esriFieldTypeString, alias: Do you currently pay an Accountant, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• UseOtherConsult ( type: esriFieldTypeString, alias: Do you currently pay any other consultants, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• ListOtherConsult ( type: esriFieldTypeString, alias: List Other Consultants used, length: 254 )
• OtherHelp ( type: esriFieldTypeString, alias: Other help required or multiple issues, length: 254 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DraftComplete ( type: esriFieldTypeString, alias: Drafting Questions Complete?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• Landholder Details (0) -- Related To: Farm - All (0)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata