How to creat a point from existing lat long data

Bzarbo

I have a table of "hydrants" within my xano database with about 8000 records and among the other hydrant properties there's a lat field and a long field for each hydrant. I have created a field called "hydrant locations".

What I am trying to do is to build a function stack that pulls in the already existing "hydrant" lat and long and then updates applies it as a "geo_point" in the "hydrant locations" field for that same hydrant.

I have been able to successfully do this with a single "get record" by using the "hydrants_id" as an input. But I am trying to not have to change the input manually every time I debug and run for 8000 records.

Louis Machado - CSA

Hi @Bzarbo,

Here's a step-by-step guide on how you can go about that. Let me know if you have additional questions.

https://www.loom.com/share/6429ba92603e4fa980afb92aafd07ef9?sid=6710fd9e-9dd3-4a72-8b93-6cb34554ad12

A sample of the JSON that is stored in the geopoint field type.

{
"type": "point",
"data": {
"lng": 111,
"lat": 111
}
}