Subject | Re: [firebird-support] Re: Spatial Data in FB |
---|---|
Author | Daniel Berstein |
Post date | 2004-03-20T02:27:39Z |
Alex, Firebird has no "native" support for spatial-enabled data types.
I guess you're thinking in Oracle Spatial and/or PostGIS (add-on for
Postgresql). I bet something similar *could* be built over Firebird.
Spatial data types are nothing more than a couple of tables defining
vertex relations. You could code stored procedures to populate and
manipulate this geometric entities. The most difficult task would be
to create the RTREE index (quadtree).
Regards,
Daniel Berstein.
El Martes, 09 de Marzo de 2004 escribiste:
a> Hi Alexander,
a> Actually I want to know if FB has native treatment of spatial data,
a> such as spatial index, spatial search through clause (like within,
a> inside, and so on), things like these.
a> Maybe internally FB can implent this using BLOBs, but I wanna know if
a> the user/programmer can interact with this data, implement code to
a> query/update/insert spatial data?
a> Regards,
a> Alex
a> --- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
a> <ded@h...> wrote:
--
Saludos,
Daniel Berstein
dbz@...
I guess you're thinking in Oracle Spatial and/or PostGIS (add-on for
Postgresql). I bet something similar *could* be built over Firebird.
Spatial data types are nothing more than a couple of tables defining
vertex relations. You could code stored procedures to populate and
manipulate this geometric entities. The most difficult task would be
to create the RTREE index (quadtree).
Regards,
Daniel Berstein.
El Martes, 09 de Marzo de 2004 escribiste:
a> Hi Alexander,
a> Actually I want to know if FB has native treatment of spatial data,
a> such as spatial index, spatial search through clause (like within,
a> inside, and so on), things like these.
a> Maybe internally FB can implent this using BLOBs, but I wanna know if
a> the user/programmer can interact with this data, implement code to
a> query/update/insert spatial data?
a> Regards,
a> Alex
a> --- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
a> <ded@h...> wrote:
>> --- In firebird-support@yahoogroups.com, "alex_daher" <aldaher@c...>a> Yahoo! Groups Links
>> wrote:
>> > Hi!
>> >
>> > I'd like to know if FB supports spatial data. Is there any package or
>> > king of a plug-in code that I can use?
>>
>> Alex, can't say I clearly understand question. FB can store any kind
>> of data in BLOBs. Is this what you are searching?
>>
>> Best regards,
>> Alexander.
--
Saludos,
Daniel Berstein
dbz@...