Name: ControlVisit

Display Field: RecordedByName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7d3c55e7b1604566b99ba537334f3b4f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: Notes )
• Organisation ( type: esriFieldTypeInteger, alias: Organisation, editable: true, nullable: true, defaultValue: null, modelName: Organisation , Coded Values: [0: Auckland Council] , [1: Bay of Plenty Regional Council] , [2: Treescape] , ...851 more... )
• Project ( type: esriFieldTypeInteger, alias: Project, editable: true, nullable: true, defaultValue: null, modelName: Project , Coded Values: [0: Not Assigned] , [9: Regional Deer Control] , [10: Regional Goat Control] , ...48 more... )
• FinancialYear ( type: esriFieldTypeInteger, alias: Financial Year, editable: true, nullable: true, defaultValue: null, modelName: FinancialYear , Coded Values: [1901: 1901-1902] , [1902: 1902-1903] , [1903: 1903-1904] , ...127 more... )
• ShortID ( type: esriFieldTypeString, alias: Short ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: ShortID )
• RecordedByName ( type: esriFieldTypeString, alias: Recorded By Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RecordedByName )
• RecordedByOrganisation ( type: esriFieldTypeInteger, alias: Recorded By Organisation, editable: true, nullable: true, defaultValue: null, modelName: RecordedByOrganisation , Coded Values: [0: Auckland Council] , [1: Bay of Plenty Regional Council] , [2: Treescape] , ...851 more... )
• ValidationState ( type: esriFieldTypeInteger, alias: Validation State, editable: true, nullable: true, defaultValue: null, modelName: ValidationState , Coded Values: [0: Not Valid] , [1: Not Valid and Public] , [2: Valid and Private] , ...1 more... )
• RecordStatus ( type: esriFieldTypeInteger, alias: Record Status, editable: true, nullable: true, defaultValue: 1, modelName: RecordStatus , Coded Values: [1: Active/Current] , [2: Complete/Historic] , [3: Planned/Proposed] , ...3 more... )
• PestAnimalControlAreaID ( type: esriFieldTypeGUID, alias: Pest Animal Control Area ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PestAnimalControlAreaID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• EditedBy ( type: esriFieldTypeString, alias: EditedBy, editable: false, nullable: true, length: 255, defaultValue: null, modelName: EditedBy )
• EditedDate ( type: esriFieldTypeDate, alias: EditedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditedDate )
• ManualControlMethod ( type: esriFieldTypeInteger, alias: Manual Control Method, editable: true, nullable: true, defaultValue: null, modelName: ManualControlMethod , Coded Values: [1: Day ground hunting] , [2: Aerial hunting] , [3: Trapping] , ...1 more... )
• PesticideControlMethod ( type: esriFieldTypeInteger, alias: Pesticide Control Method, editable: true, nullable: true, defaultValue: null, modelName: PesticideControlMethod , Coded Values: [1: Bait stations/bait bags] , [2: Burrow fumigation] , [3: Aerial application] , ...4 more... )
• PesticideType ( type: esriFieldTypeInteger, alias: Pesticide Type, editable: true, nullable: true, defaultValue: null, modelName: PesticideType , Coded Values: [129: Key Industries Biff Ant] , [130: Xstinguish] , [131: Connovation Feratox Bio Bag 12g] , ...27 more... )
• PestAnimalControlArea ( type: esriFieldTypeString, alias: Control Area Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PestAnimalControlArea )
• Weather ( type: esriFieldTypeInteger, alias: Weather, editable: true, nullable: true, defaultValue: null, modelName: Weather , Coded Values: [1: Sunny] , [2: Partly Cloudy] , [3: Overcast] , ...1 more... )
• Species ( type: esriFieldTypeInteger, alias: Species, editable: true, nullable: true, defaultValue: null, modelName: Species , Coded Values: [11: Streaked goby, Striped sandgoby, Asian goby, Acentrogobius pflaumii] , [15: Common myna, Myna, Indian myna, Maina, Acridotheres tristis] , [33: Eurasian skylark, Skylark, Kaireka, Alauda arvensis] , ...255 more... )
• PesticideAmount ( type: esriFieldTypeDouble, alias: Pesticide Amount, editable: true, nullable: true, defaultValue: null, modelName: PesticideAmount )
• CouncilBusinessUnit ( type: esriFieldTypeInteger, alias: Council Business Unit, editable: false, nullable: true, defaultValue: null, modelName: CouncilBusinessUnit , Coded Values: [1: Environmental Services] , [2: Community Facilities] , [3: Parks, Sports and Recreation] , ...3 more... )
• InfestationAreaShortID ( type: esriFieldTypeString, alias: Infestation Area Short ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: InfestationAreaShortID )
• PesticideUnit ( type: esriFieldTypeInteger, alias: Pesticide Unit, editable: true, nullable: true, defaultValue: null, modelName: PesticideUnit , Coded Values: [1: ml] , [2: grams] , [3: litres] , ...1 more... )
• StartDate ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• EndDate ( type: esriFieldTypeDate, alias: End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EndDate )
• StartQuarter ( type: esriFieldTypeInteger, alias: Start Quarter, editable: false, nullable: true, defaultValue: null, modelName: StartQuarter , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• EndQuarter ( type: esriFieldTypeInteger, alias: End Quarter, editable: false, nullable: true, defaultValue: null, modelName: EndQuarter , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• PestAnimalControlAreaM2 ( type: esriFieldTypeDouble, alias: Pest Animal Control Area (m2), editable: false, nullable: true, defaultValue: null, modelName: PestAnimalControlAreaM2 )
• AssetsInstalled ( type: esriFieldTypeDouble, alias: Assets Installed, editable: true, nullable: true, defaultValue: null, modelName: AssetsInstalled )
• AssetsChecked ( type: esriFieldTypeDouble, alias: Assets Taken, editable: true, nullable: true, defaultValue: null, modelName: AssetsChecked )
• AssetsRemoved ( type: esriFieldTypeDouble, alias: Assets Removed, editable: true, nullable: true, defaultValue: null, modelName: AssetsRemoved )
• DataSource ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataSource )
• DataSourceID ( type: esriFieldTypeString, alias: Data Source ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataSourceID )
• DataSourceDate ( type: esriFieldTypeDate, alias: Data Source Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DataSourceDate )
• DataSourceType ( type: esriFieldTypeInteger, alias: Data Source Type, editable: true, nullable: true, defaultValue: null, modelName: DataSourceType , Coded Values: [0: Internal] , [1: External] )
• TotalHoursWorked ( type: esriFieldTypeDouble, alias: Total Hours Worked, editable: true, nullable: true, defaultValue: null, modelName: TotalHoursWorked )
• KillCount ( type: esriFieldTypeInteger, alias: Kill Count, editable: true, nullable: true, defaultValue: null, modelName: KillCount )
• ObservedCount ( type: esriFieldTypeInteger, alias: Observed Count, editable: true, nullable: true, defaultValue: null, modelName: ObservedCount )
• VisitType ( type: esriFieldTypeInteger, alias: Visit Type, editable: true, nullable: true, defaultValue: null, modelName: VisitType , Coded Values: [0: Manual Control] , [1: Pesticide Control] )
• Season ( type: esriFieldTypeInteger, alias: Season, editable: false, nullable: true, defaultValue: null, modelName: Season , Coded Values: [1: Summer] , [2: Autumn] , [3: Winter] , ...1 more... )
• SubProject ( type: esriFieldTypeInteger, alias: Sub project, editable: false, nullable: true, defaultValue: null, modelName: SubProject , Coded Values: [0: Te Paparahi lizard and frog survey] , [1: Pipit survey] , [2: Reef heron survey] , ...30 more... )
• OtherObservedCount ( type: esriFieldTypeInteger, alias: Other Observed Count, editable: true, nullable: true, defaultValue: null, modelName: OtherObservedCount )
• OtherKillCount ( type: esriFieldTypeInteger, alias: Other Kill Count, editable: true, nullable: true, defaultValue: null, modelName: OtherKillCount )
• AreaID ( type: esriFieldTypeString, alias: Area ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: AreaID )
• PreMacleanScale ( type: esriFieldTypeInteger, alias: Pre Maclean Scale, editable: true, nullable: true, defaultValue: null, modelName: PreMacleanScale , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• PostMacleanScale ( type: esriFieldTypeInteger, alias: Post Maclean Scale, editable: true, nullable: true, defaultValue: null, modelName: PostMacleanScale , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...5 more... )
• Firearms ( type: esriFieldTypeInteger, alias: Firearms Used, editable: true, nullable: true, defaultValue: null, modelName: Firearms , Coded Values: [1: Yes] , [2: No] , [3: N/A] )
• Dogs ( type: esriFieldTypeInteger, alias: Dogs Used, editable: true, nullable: true, defaultValue: null, modelName: Dogs , Coded Values: [1: Yes] , [2: No] , [3: N/A] )

Templates:

• Name: ControlVisit
  Description:
  Prototype:
  Firearms: null
  Notes: null
  Organisation: null
  Project: null
  FinancialYear: null
  PreMacleanScale: null
  RecordedByName: null
  RecordedByOrganisation: null
  ValidationState: null
  RecordStatus: 1
  PestAnimalControlAreaID: null
  Dogs: null
  PostMacleanScale: null
  DataSourceID: null
  OtherKillCount: null
  OtherObservedCount: null
  DataSourceDate: null
  ManualControlMethod: null
  PesticideControlMethod: null
  PesticideType: null
  PestAnimalControlArea: null
  Weather: null
  Species: null
  PesticideAmount: null
  DataSourceType: null
  VisitType: null
  PesticideUnit: null
  StartDate: null
  EndDate: null
  ObservedCount: null
  KillCount: null
  TotalHoursWorked: null
  AssetsInstalled: null
  AssetsChecked: null
  AssetsRemoved: null
  DataSource: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PestAnimalControl_Area (0) -- Related To: PestAnimalControlArea (3)

Capabilities: Query,Create,Update,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditedDate
• Editor Field: EditedBy

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata