id

Integer

Autogenerated, incremental. Not visible to user

createdBy

String

Email of user who created the entity

createdById

Int

Id of the user who created the entity

observations

String

Notes provided by the user

refNumber

String

Autogenerated identification number visible to user.

lat

Decimal

Latitude where this entity was created

lon

Decimal

Longitud where this entity was created

society

Int

Id of society

name

String

Farmer name

lastname

String

Farmer lastname

name

String

Establishment name

farmer

Int

Farmer ID

name

String

Plot name

number

Int

Plot number (deprecado)

geometry

String

GeoJson representing the plot boundaries

establishment

Int

Establishment ID

active

boolean

Flag this plot active or inactive

masterCampaign

Int

Master campaign ID

daysFromPlanting

Int

Number of days since planting

schedulePlantingDate

Date

Schedule date of planting

plantingDate

Date

Date of the actual planting

plantingDistance

Int

Distance between grooves in Cm

plantingObjectiveDensitySeedsMeter

Int

The objective (planned) density of seeds per meter.

plantingObjectiveDensityPlantsHa

Int

The objective (planned) density of plants per hectare.

plantingObjetiveGerminativePower

Int

plantingObjectiveAchievementCoefficient

Int

The objective (planned) density in Kg/Ha.

plantingObjectiveAreaHa

Int

The objective (planned) planting area

plantingObjectiveDensityKgHa

Int

objectiveYieldKgHa

Int

The objective (planned) yield in Kg/Ha

plantedArea

Int

The actual planted area

harvestFinished

Boolean

Flag indicating if harvest is complete

harvestFinalYield

Int

The actual yield obtained

plantingFinished

Boolean

Flag indicating if planting is complete

plot

Int

Plot ID

plantingSystem

Int

The planting system

formulated

Int

The variety or hybrid planted

active

Boolean

Flag this campaign active or inactive

name

String

Name of the master campaign

cultivation

Int

Cultivation ID

plantingTime

Int

Planting time ID

cycle

Int

Cycle ID

name

String

Name of cycle

dateFrom

Date

Beginning of season

dateTo

Date

End of season

name

String

Name of crop

name

String

Name of planting time

l1

String

Name line 1

l2

String

Name line 2

l3

String

Name line 3

unit_id

Int

Unit ID

ai_id

Int

Active Ingredient ID

cnt

String

Concentration

apt

String

Aptitude

use_id

Int

Formulated use ID. Used to clasify formulateds in, for example, herbicides or insesticed

tc

String

Toxicological class

campaign

Int

Campaign ID

a0 (semaphore)

Int

Semaphore representing the state of this scouting. 1 = Green, 2 = Yellow, 3 = Red

a1 (samplesTaken)

Int

Number of samples taken in this scouting

a2 (knots)

Int

Number of knots

a3 (clothSize)

Decimal

Deprected

a4 (phenological state)

Int

Phenological state ID

a5 (HydricState)

Int

Hydric state ID

a6 (plot state)

Int

Plot state ID

a7 (estimatedYield)

Decimal

Estimated yield in Kg/Ha

a8 (plant height)

int

Height of the plant

spr

Collection

Collection of ScoutingProtocolResult.

ssa

Collection

Collection of ScoutingSampleAlert.

a0 (adversity)

Int

Adversity ID

a1 (scouting protocol)

Int

Scouting protocol ID

a2 (scouting measure)

Int

Scouting measure ID

a3 (value)

Decimal

The decimal value of the measure

a4 (semaphore)

Int

Semaphore representing the state of this result. 1 = Green, 2 = Yellow, 3 = Red

a0 (sample)

Int

Sample number

a1 (semaphore weeds)

Int

Semaphore for weeds

a2 (semaphore insects)

Int

Semaphore for insects

a3 (semaphore diseases)

Int

Semaphore for diseases

a4 (semaphore summary)

Int

Summary semaphore

a5 (lat)

Decimal

Latitude of sample station

a6 (lon)

Decimal

Longitude of sample station

a0 (sample)

Int

Sample number

a1 (value)

Decimal

Value

a2 (semaphore)

Int

Semaphore

a3 (protocol_id)

Int

Scouting protocol ID

a4 (adversity_id)

Int

Adversity ID

a5 (measure_id)

Int

Scouting measure ID

a0 (name)

String

Name of adversity

a1 (scientificName)

Int

Scientific name

a2 (description)

String

Description

a3 (isResistant)

Boolean

Flag indicating if the adversity is resistant.

a4 (symptoms)

String

Description of symptoms

a5 (predisposingConditions)

String

Describes the situations and conditions where this adversity may emerge.

a6 (handling)

String

Describes the procedure of how this adversity should be treated.

a8 (defaultPhotoId)

Int

Photo ID. Only available for SIMA mobile application.

a7 (category)

Int

Category ID

a9 (kind)

Int

Kind ID

a0 (unit)

String

Unit of measure

a1 (controlType)

String

The type of UI control presented to the user.

• counter: button

• slider: seekbar or progress bar

• checkbox: checkbox

• decimalValue: a decimal value inputed by keyboard

a2 (kind)

Int

Kind ID

a3

deprecated

a4

deprecated

a0 (name)

String

Name of protocol

a1 (procedure)

String

The procedure or description of the protocol

a2

deprectated

a3 (kind)

Int

Kind ID

a0 (name)

String

Name of category

a1 (description)

String

Description of category

a2 (kind)

Int

Kind ID

a0 (name)

String

Name of kind

a0 (min)

Decimal

a1 (max)

Decimal

a2 (step)

String

a3 (scale_values)

Text

a4 (scale_legends)

Text

a5 (measure_id)

Int

a6 (protocol_id)

Int

a7 (scale_images)

Text

a8 (keep_sample_value)

Boolean

a9 (default_value)

Decimal

a10 (self_calculation_expression)

Text

a0 (adversity_id)

Int

a1 (cultivation_id)

Int

a2 (protocol_id)

Int

a3 (society_id)

Int

a4 (show_protocol_name)

Boolean

a5 (exclude_equivalent)

Boolean

name

String

Name of phenological state

description

String

Description

cultivation

Int

Cultivation ID

a1 (cultivation)

Int

Cultivation ID

a2 (protocol)

Int

Protocol ID

a3 (measure)

Int

Measure ID

a4 (phenWeightFrom)

Int

Phenology weight (from)

a5 (phenWeightTo)

Int

Phenology weight (to)

a6 (active)

Int

Flag this threshold active or inactive

a7 (adversity)

Int

Adversity ID

g (green)

y (yellow)

r (red)

Decimal

If userValue is between green and yellow, then the semaphore es green.

If userValue is between yellow and red, then the semaphore es yellow.

If userValue is bigger than red, then the semaphore es red.

applicationName

String

Name defined by user

nozzles

Int

Nozzle ID

dateIssued

Date

The date this order was issued

dateConfirmed

Date

The date this order was executed (completed)

plantingDistance

Int

The recommended distances between grooves for this order.

objectiveDensitySeedM

Int

The objective (planned) seed density in meters

orderType

Int

Orders can be:

• Application Order = orderType = 7

• Planting Order = orderType = 17

• Fertilization Order = orderType = 18

• Harvest Order = orderType = 19

creation_system_id

Int

system where it was created: Ej 4 (android)

application_campaigns

Collection

Collection of application_campaign

application_formulated

Collection

Collection of application_formulated

application_confirmations

Collection

Collection of application_campaign

applicationOrder

Int

Application Order ID

campaign

Int

Campaign ID

areaToApply

Decimal

Recommended area to apply

applicationOrder

Int

Application Order ID

formulated

Int

Formulated ID

unit

Int

Unit ID

doseToApply

Decimal

Recommended dose to apply

totalToApply

Decimal

Recommended total to apply

applicationOrder

Int

Application Order ID

campaign

Int

Campaign ID

formulated

Int

Formulated ID

unit

Int

Unit ID

areaApplied

Decimal

Actual area applied

doseApplied

Decimal

Actual dose applied

date

date

Date of creation

createdBy

String

Email of the user who created the entity

createdById

Int

Id of the user who created the entity

status

syncCheck

refNumber

String

Autogenerated identification number visible to user.

tableCode

tag

id

entityId

fullName

String

tableCode

createdBy

Int

Email of the user who created the entity

createdById

Int

Id of the user who created the entity

sync_check

status

id

Int

name

String