FB and GIS data types?

[Andrea Raimondi]

Hello!

Anyone's got good tips on using FB with GIS data types such as Lat/Long and the relevant operations? I mean I can probably find a way around it with a mix of SPs and code but I'd rather not.

Suggestions?

Thanks!

[AlexPeshkoff]

The main problem is missing spatial index, and unfotunately I see no solution for it except adding it to engine's codebase.

пятница, 23 июля 2021 г. в 04:33:56 UTC+3, andrea....@gmail.com:

[liviuslivius]

GIS is not supported by FB in the way all think about GIS term.

But all depend of the data and operation and calculations you need. We use e.g. triangles. We have procedure which divide any area into triangles. Triangles math is simple and well known as it is used in all game engine.

You can create top area table and detsil with triangle description with rect area conture and create some helper indexes.

But as i say all depend of the needs.

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Andrea Raimondi <andrea....@gmail.com>

Data: 23.07.2021 03:33 (GMT+01:00)

Do: firebird...@googlegroups.com

Temat: [firebird-support] FB and GIS data types?

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CACr216WgVVeiuBtPCZj%3Dpfs7c4w0V4A0uepe5OSXyWCMsi0uuw%40mail.gmail.com.

[Andrea Raimondi]

Hi!

I mean, I could create all the stored procedures etc. but it's tedious and error prone. 

Do you know of anyone who's done something for this as an open source and/or paid for package?

Thanks!

A

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4GWZ1f5fhKzlkTtW%40smtp.poczta.onet.pl.

--

Mr. Andrea Raimondi
I shatter fantasies to deliver solutions.

LinkedIn https://www.linkedin.com/in/andrearaimondi/

[Andrea Raimondi]

So... it turns out that there is something for Delphi to help with GIS: https://bitbucket.org/mathias_burbach/geolocation/src/master/

Please take a look to see if it fits your needs. At a skim it appears to fit mine. 

[Norbert Saint Georges]

Andrea Raimondi a écrit :

> So... it turns out that there is something for Delphi to help with GIS:
> https://bitbucket.org/mathias_burbach/geolocation/src/master/
>
> Please take a look to see if it fits your needs. At a skim it appears to
> fit mine.

Interesting.
The source code uses the WGS84 standard but not too difficult to port
to UDR.

--
Norbert Saint Georges
http://tetrasys.fi