Question about visualising geometry points in pipeline builder

[Emperorkuusko]

I am trying to extract some information from a media set which in this case is a simple pdf I made using parcel information. the pdf has a simple table (or text i guess??) with the basic information and geometrie points. my pipeline looks like this:

my output should be a dataset containing a latitude and longitude so i can use it as a geopoint for visualisation in workspace.

i get schema error on the last one and im stuck:

Is this approach right or am i doing it completely wrong?

My goal is that the mediaset provided gives out the information on a map.

[helenq]

What does the very first error say? On the first “Cast to integer” board

[Emperorkuusko]

Thanks for your reply. I am sorry I was messing with it and the transform is gone now.

The LLM gives back a JSON.

this is (part of) the prompt in the LLM.

Extract all rows and return JSON with this schema:

[
{
“Gemeente”: “”,
“Ligging”: “”,
“Sectie”: “”,
“Nummer”: “”,
“ha”: “”,
“are”: “”,
“ca”: “”,
“latitude”: “”,
“longitude”: “”
}
]

I simply want all of them in columns so i can have a dataset that can be presented geographically. At one point I got the columns but it didnt give the rows with the information from the mediaset.