Layer: Investment_Tracker (ID:0)

View In: Map Viewer

Name: Investment_Tracker

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Investment Ledger","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Intro_duction (type: esriFieldTypeString, alias: This template will be used to track investments by partners., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name_org (type: esriFieldTypeString, alias: Name of organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name_contact (type: esriFieldTypeString, alias: Name of contact person within organization, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
state_o (type: esriFieldTypeString, alias: State of operation:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ben: Benue], [crs: Cross River], [del: Delta], ... 4 more ...)
sex (type: esriFieldTypeString, alias: Sex of owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [male: Male], [fem: Female], [mix_s: Mixed])
age (type: esriFieldTypeString, alias: Age of owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [15-29: 15 - 29 years], [30+: 30 years and above], [Mixed: Mixed])
business (type: esriFieldTypeString, alias: Type of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Hatchery: Hatchery], [Sale of Improved seeds: Sale of Improved seeds], [Tractor services: Tractor services], ... 3 more ...)
commodity (type: esriFieldTypeString, alias: Focus commodity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Catfish: Catfish], [Cowpea: Cowpea], [Maize: Maize], ... 2 more ...)
rear (type: esriFieldTypeDouble, alias: On average, how long is your rearing cycle (in Months)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
start_last (type: esriFieldTypeDate, alias: When did you start your LAST REARING CYCLE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
end_last (type: esriFieldTypeDate, alias: When did you end your LAST REARING CYCLE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
since (type: esriFieldTypeInteger, alias: How many rearing cycles do you complete in a year?, SQL Type: sqlTypeOther, nullable: true, editable: true)
feed (type: esriFieldTypeDouble, alias: How many bags of FEED did you buy in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
feed_prc (type: esriFieldTypeDouble, alias: What is the average price (in NGN) of a bagof FEED in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
cost_feed (type: esriFieldTypeDouble, alias: Total cost of feed, SQL Type: sqlTypeOther, nullable: true, editable: true)
petrol (type: esriFieldTypeDouble, alias: How many litres of PETROL did you buy in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
petrol_prc (type: esriFieldTypeDouble, alias: What is the average price (in NGN) of a litreof PETROL in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
cost_petrol (type: esriFieldTypeDouble, alias: Total cost of petrol, SQL Type: sqlTypeOther, nullable: true, editable: true)
hormone (type: esriFieldTypeDouble, alias: How many bottles of HORMONE did you buy in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
hormone_prc (type: esriFieldTypeDouble, alias: What is the average price (in NGN) of a BOTTLEof HORMONE in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
cost_hormone (type: esriFieldTypeDouble, alias: Total cost of hormone, SQL Type: sqlTypeOther, nullable: true, editable: true)
syringe (type: esriFieldTypeInteger, alias: How many SYRINGES did you buy in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
syringe_prc (type: esriFieldTypeDouble, alias: What is the average price (in NGN) of a SYRINGE in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
cost_syringes (type: esriFieldTypeDouble, alias: Total cost of syringes, SQL Type: sqlTypeOther, nullable: true, editable: true)
drugs (type: esriFieldTypeDouble, alias: What is the total cost (in NGN) of DRUGS/MEDICATION in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
market (type: esriFieldTypeDouble, alias: What is the total MARKETING fees (in NGN) paid in the last rearing cycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
security_c (type: esriFieldTypeDouble, alias: What is the total SECURITY fees (in NGN) paid in the last rearing cycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
legal (type: esriFieldTypeDouble, alias: What is the total LEGAL fees (in NGN) paid in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
staff (type: esriFieldTypeInteger, alias: How many employees did you use in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
staff_wom (type: esriFieldTypeInteger, alias: How many of your employees are women?, SQL Type: sqlTypeOther, nullable: true, editable: true)
labour_cost (type: esriFieldTypeDouble, alias: What is the total cost of labour in the last rearing cycle?, SQL Type: sqlTypeOther, nullable: true, editable: true)
assets (type: esriFieldTypeString, alias: What assets or equipment have you acquired for your operations since June 2021, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pond (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new pond(s) acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_pond (type: esriFieldTypeDate, alias: Date pond was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
land (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new land(s) acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_land (type: esriFieldTypeDate, alias: Date land was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fence (type: esriFieldTypeDouble, alias: What is the cost (in NGN)of new security fence acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_fence (type: esriFieldTypeDate, alias: Date security fence was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
borehole (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new borehole acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_borehole (type: esriFieldTypeDate, alias: Date borehole was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pump (type: esriFieldTypeDouble, alias: What is the cost (in NGN)of new pump acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_pump (type: esriFieldTypeDate, alias: Date pump was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tank (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new water storage tank acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_storage (type: esriFieldTypeDate, alias: Date storage was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
aerator (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new aerator acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_aerator (type: esriFieldTypeDate, alias: Date aerator was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
outlet (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new distribution outlet(s) acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_distribution (type: esriFieldTypeDate, alias: Date new distribution outlet was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
bds (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new business development service acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_bds (type: esriFieldTypeDate, alias: Date Business Development Service was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
broodstock (type: esriFieldTypeDouble, alias: What is the cost (in NGN) of new broodstock acquired?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_broodstock (type: esriFieldTypeDate, alias: Date broodstock was acquired, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
rent (type: esriFieldTypeString, alias: Do you pay rent?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
pay_rent (type: esriFieldTypeDouble, alias: How much do you pay as rent annually (in NGN)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
tax (type: esriFieldTypeString, alias: Do you pay tax?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
pay_tax (type: esriFieldTypeDouble, alias: How much do you pay as tax annually (in NGN)?, SQL Type: sqlTypeOther, nullable: true, editable: true)
date_entry (type: esriFieldTypeDate, alias: Date of data entry, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
data_by (type: esriFieldTypeString, alias: Data entered by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/2/2021 7:26:42 AM

Schema Last Edit Date: 10/2/2021 7:26:42 AM

Data Last Edit Date: 10/2/2021 7:26:42 AM

Supported Operations: Add Features Apply Edits Generate Renderer Validate SQL Get Estimates ConvertFormat