Is there a way to detect overlapping geofences?

[SteveDonie]

I'm using teslamate a lot and adding lots of geofences for my handyman clients. Sometimes I accidentally create two similar geofences - very similar lat/long/radius, similar or same name.

Is there a way to detect if there are overlapping geofences? Even if that way is a direct postgresql query?

[eliluong]

Yes, you can access the geofences table in the Postgres database. It has a longitude/latitude for each geofence, along with the radius that is stored in meters. Then you can do some math to see if there is anything overlapping. I think it is easiest to pull data from the database and then operate on it.

[SteveDonie]

OK. I think I can get pretty much the same thing from the UI as well. Just copy and paste the text on the geofences UI table into a spreadsheet and then "do some math" If I figure out the math I'll let you know. It can probably be simplified by considering the geofence as a square at first, and then only go circle vs circle if needed. I think big O complexity is O(n log n) - You have to check geofence 1 against 2..n, then 2 against 3..n, etc.

…

On Sun, Jan 26, 2025 at 3:11 PM eliluong ***@***.***> wrote: Yes, you can access the geofences table in the Postgres database. It has a longitude/latitude for each geofence, along with the radius that is stored in meters. Then you can do some math to see if there is anything overlapping. I think it is easiest to pull data from the database and then operate on it. — Reply to this email directly, view it on GitHub <#4506 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAETZ2QLWPWCL7GLD7P6OTD2MVFO3AVCNFSM6AAAAABV4ZNOEGVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCOJWGE4TCNY> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>