Updated report templates

[fedjo]

1. Irrigation report:

https://docs.google.com/document/d/1L7jnMiJcS-wRM6GtZ0-UBxm7HB4S3JzfHvFKTRHQC40/edit?tab=t.0#heading=h.lxj6acaxdttn

2. Pesticides report:

https://docs.google.com/document/d/1Qeoklny78JYplwYWkfHyZXBkMeiFk9QumG5PpOqkCtg/edit?tab=t.0#heading=h.lxj6acaxdttn

Details will be added soon

[JoleVLF]

@fedjo
One of the first changeless here will be drawing a satelite parcel photo (also with should use open API examples).
One of the examples I have found:
https://github.com/andolg/satellite-imagery-downloader/blob/main/src/image_downloading.py
But in general OpenStreetMap is something to consider (drawing picture itself is something else when we have image).
Another useful example:
https://www.theurbanist.com.au/2021/03/plotting-openstreetmap-images-with-cartopy/

[fedjo]

As a general rule, I would say that we should not go too technical in implementing the satellite image download. I say that because the second link seems a very technical implementation. Also I agree with we should go with Open Source APIs. OSM can do our work I think.

Here is the license https://www.openstreetmap.org/copyright

[JoleVLF]

@fedjo First limitation for OSM is that it does not have layer for satellite images.
Couldn't we use depiction url maybe and draw the image received in that field in Parcel (if provided) like ui does I think?

[JoleVLF]

@fedjo I will start with pesticides ant fertilization and then leave satelite image for end

[JoleVLF]

@fedjo @arruda
Current Pesticides payload from Farm Calendar API (From swagger https://editor-next.swagger.io/?url=https://raw.githubusercontent.com/agstack/OpenAgri-FarmCalendar/refs/heads/main/schema.yml)
[
{
"id": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"hasCommercialName": "string",
"description": "string",
"hasCost": "-5611348",
"isPricePer": "string",
"hasActiveSubstance": "string",
"isTargetedTowards": "string",
"hasPreharvestInterval": 0,
"status": 0,
"dateCreated": "2025-10-22T07:45:53.579Z",
"dateModified": "2025-10-22T07:45:53.579Z",
"invalidatedAtTime": "2025-10-22T07:45:53.579Z"
}
]

Here we do not have, parcel, farm or any other related info needed for reporting described above

[fedjo]

I think you should get the information from /Farm and /FarmParcel API. What is the case in irrigation report? How do you get these info?

[JoleVLF]

@fedjo It is possible when I have parcel connected to the object, like you can see there is no parcel_id or info about parcel in the object payload.
Irrigation has parcel object holding ID.

[arruda]

Pesticides endpoint is for managing the "mateiral" of pesticides, not its application on a given date/time. What you are looking for is probably the /api/v1/CropProtectionOperations/ endpoint.

But this raises the question if there should be a operations field in the pesticides material endpoint that is currently missing? Could be usefull, and I believe that the OCSM already contemplates this field. (I think it is hasOperations? But we can open an issue for this and I can check it)

[JoleVLF]

@arruda
CropProtectionOperations also does not have parcel (it has agri machine when exist and then I would need to fetch percel from agri machine, which is not good, we would need to have hasParcel like other operations).
Also do we need here to have from and to date filters, along with parcel filter, because it is not present on the swager for this operation type.

{
"activityType": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"title": "string",
"details": "string",
"hasStartDatetime": "2025-10-22T18:55:13.535Z",
"hasEndDatetime": "2025-10-22T18:55:13.535Z",
"responsibleAgent": "string",
"usesAgriculturalMachinery": [
"3fa85f64-5717-4562-b3fc-2c963f66afa6"
],
"hasAppliedAmount": {
"unit": "string",
"numericValue": "-4694"
},
"usesPesticide": "3fa85f64-5717-4562-b3fc-2c963f66afa6",
"operatedOn": "3fa85f64-5717-4562-b3fc-2c963f66afa6"
}

[arruda]

Hello @JoleVLF , the field that references the parcel in this class (from the OCSM) is the "operatedOn".
PS: One thing that I the swagger auto docs is still not ok is on the example os input... for some reason they ignore the default serialization and do not provide the actual JSON-ld structure. Otherwise it would be easier to see that the operated on is a reference to a farm parcel
Example with actual values:

        {
            "@type": "CropProtectionOperation",
            "@id": "urn:farmcalendar:CropProtectionOperation:bddea06c-ba65-48f5-b181-6e8eff43f008",
            "activityType": {
                "@type": "FarmCalendarActivityType",
                "@id": "urn:farmcalendar:FarmCalendarActivityType:00000000-0000-0000-0000-000000000003"
            },
            "title": "Pesticides",
            "details": "",
            "hasStartDatetime": "2025-10-23T00:00:00Z",
            "hasEndDatetime": null,
            "responsibleAgent": null,
            "usesAgriculturalMachinery": [],
            "hasAppliedAmount": {
                "@id": "urn:farmcalendar:QuantityValue:819bd038-5ddc-5ae5-a75b-f4c2769ff5fa",
                "@type": "QuantityValue",
                "unit": "321",
                "numericValue": 123.0
            },
            "usesPesticide": {
                "@type": "Pesticide",
                "@id": "urn:farmcalendar:Pesticide:00000000-0000-0000-0000-000000000001"
            },
            "operatedOn": {
                "@type": "Parcel",
                "@id": "urn:farmcalendar:Parcel:00000000-0000-0000-0000-000000000003"
            }
        }

[JoleVLF]

@arruda Nice, also what about query params, should we add them to Farm Calendar API for this operation?
Date/Parcel query.

[arruda]

@JoleVLF what you mean by that? do you mean the filters in this CropProtection endpoint?
if so, then yes, all activities endpoints have the same filters for date (start and end) and the parcel. (you can check the specific fields for the query parameter in the swagger docs, but it should be the same for all activities in any case)

[JoleVLF]

@arruda Yeap, okay okay, we can proceed with operatedOn field than.
Seems like I have than everything to work with, thanks :D