4 ms·
That does look interesting. I could search through it for a lat & long, but it looks like it only gives a name (e.g. "Silicon Oasis") without a corresponding co
by edent 1y ago
That does look interesting. I could search through it for a lat & long, but it looks like it only gives a name (e.g. "Silicon Oasis") without a corresponding country. Food for thought though.
Thanks!
- rovr138 1y agoYeah. It’s not flat. You can use admin fields, and it’s a recursive query to find. I have recursive CTE (thanks to ChatGPT). Could also be done on save, since they shouldn’t change for locations. The recursiveness though, gives you a benefit if you extract type and save the intermediate steps, it allows you to start grouping things together at different levels which is one of the use cases you mentioned.