Issue Details (XML | Word | Printable)

Key: CORE-659
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: kohan_gg
Votes: 25
Watchers: 18
Operations

If you were logged in you would be able to see more operations.
Firebird Core

gis implementation (opengis)

Created: 21/Jul/04 12:00 AM   Updated: 01/Mar/14 10:12 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Duplicate
 

SF_ID: 995200


 Description  « Hide
SFID: 995200#
Submitted By: kohan_gg

Implementation of spatial operator (cf. opengis
consortium) will be very very useful
For example Postgres and Mysql had already yet implemented.
Do you think that it's possible in near future ?

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:41 AM
Date: 2006-01-17 14:55
Sender: dimitr
Logged In: YES
user_id=61270

I doubt anyone would be interested even in not so near
future. Those needing proper GIS support are always with
PostgreSQL.

Eron Lloyd added a comment - 17/Aug/06 05:04 PM
I think FB having this would be awesome. Could it be developed as an add-on, like PostGIS?

Sean Palmer added a comment - 25/Jan/07 10:30 AM
If Firebird where "spatially enabled", which would allow it to be used as a backend spatial database for geographic information systems (GIS), it could potentially blow other products like ESRI's SDE or Oracle's Spatial extension or PostGIS out of the water.

Please see OpenGIS "Simple Features Specification For SQL" (http://www.opengis.org/docs/99-049.pdf) for details.

Godofredo Contreras Nava added a comment - 03/Jul/07 12:38 PM
I have been a firebird user for more than 5 years, also I have been working with spatial databases since then and one feature I have ever wished is spatial extension for firebird. I have developed a small udf to transform wkt to wkb and store them in a blob field, also I have been contributing to some opensource gis and there are libraries that could help to implement the extension in an easy way, libraries to manage spatial indexes, libraries to transform between wkt and wkb, and also spatial analisys libraries.

It will be really nice to have a small and fast relational database server as firebird with a spatial extension.



Dehorter Olivier added a comment - 27/Jun/08 07:59 AM
more and more often, data needs to integrate information from GPS. thus inclusion of GIS module into the firebird project could be a major progress

Simon Greener added a comment - 26/Nov/09 05:17 AM
It is interesting to note, for those who know or have heard of ESRI's ArcSDE, that the very first version - 1.0 - was originally released on Interbase. The coordinates were stored in an array of integers. I enjoyed using it and achieved some amazing things with it. The original version was developed by Geomatic Technologies Incorporates (GTI), Bellingham, WA. It was sold to ESRI Inc (Redlands, Ca) who then ported it to Oracle etc and dropped the Interbase version.

It would be rather just for Firebird to have spatial. Even SQLite has it!

vander clock stephane added a comment - 13/Dec/10 06:03 PM
what the status of this ? for exemple even Sqlite3 (http://www.sqlite.org/rtree.html) support it :(
it's could be very usefull

Dmitry Yemanov added a comment - 13/Dec/10 06:15 PM
Are you willing to sponsor the development? ;-)

Christian Waldmann added a comment - 16/Dec/10 08:28 AM
Hello Dmitry

Do you have an estimate for complexity and work to do (days, weeks,...) of adding the new index kind RTREE, keeping in mind the others may follow (HASH, GIST,...)?

vander clock stephane added a comment - 16/Dec/10 04:26 PM
Hello Dmitry

same as Christan, Do you have an estimate for complexity and work to do (days, weeks,...) of adding the new index kind RTREE ?

the code can be freely study from sqlite3 (it's a very ligh SQL engine that support RTREE pretty wheel) for exemple...

Thanks
stéphane

Dmitry Yemanov added a comment - 16/Dec/10 04:31 PM
No, I don't (at the moment). I could try to research the requirements during the Christmas holidays though.

vander clock stephane added a comment - 16/Dec/10 07:51 PM
could be good to do a blog about the project to know how many people are ready to sponsor it ?
with me it's already 1, but i hope i will be not alone ?

stephane

Simon Greener added a comment - 17/Dec/10 12:17 AM
I don't know much about the inner workings of Firebird. Here are some things I see that need examining.

1. How easily the indexing system can be extended to support RTrees?
   The RTree, in and of itself, is not difficult to implement.
   There are a number of open source implementations around that can provide code/examples.

2. The maturity of the type system of the host database. Most implementations around at the
   moment are all single inherited so only offer a single type "geometry" (and/or "geography"
   for geodetic). Few offer the full type system of the OGC/SQLMM standard such that one can
   declare a table to have a column of type "point" that therefore doesn't have a method area.
   Depending on the type system an implementation that uses "dot" notation referencing is
   possible (polygon.Area()) with some, cf PostGIS, only supporting functional approaches
   eg Area(polygon).

3. Functions. The SQL/MM standard provides the required list of functions across a range of separate areas.
   Implementation of what is known as Simple Features is the basic minimum for vector data. PostGIS provides
   a large range of additional, non standard, operations that are there because the standard should have them
   but don't!

4. Operators and query optimisation. How extensible is the database's query optimiser for efficient plan generation?

5. Aggregate operators.

6. Metadata integration (fairly straightforwards).

I am happy to be involved on some sort of guidance/testing role. I am a database person and not really a full on professional
developer. My only development experience is with Java as the lead for GeoRaptor.

I am a single person consulting business so while I can affor some time to work on this for free I cannot do much more unless
some sort of financial incentive was available.

regards
Simon
www.spatialdbadvisor.com

Juergen Seelmann added a comment - 06/Mar/12 07:17 AM
Quite a while since the last entry. I am working with TatukGIS storing data in FB: So slow compared to the use of SHP Files. This is an issue which gets more and more urgent: Any news?

Juergen Seelmann added a comment - 07/Mar/12 02:32 AM
Sorry, I send a bit fast yesterday: Can we take up this BLOG proposal: To gather all those who would support/sponsor the issue?
I wouldn't like to use a 'slow' database such as PostGre/PostGIS just for 'fast' GIS...




Peter Borissow added a comment - 16/Sep/13 12:05 PM - edited
I know its been several years since this ticket was opened but I too would love to see this feature implemented in Firebird. Why? Because there are very few options out there for an embedded database with spatial support. Sure, there's SQLite and Spatialite but SQLite has some significant concurrency issues that drives me nuts.

From a user perspective, I see 4 basic requirements for a spatial extension for Firebird:

(1) Support for spatial data types (point, lines, polygons, etc)

(2) Support for spatial operators (intersects, within, touches, etc)

(3) Support for projected and geodetic coordinates

(4) Spatial indexing (e.g. RTree)

Open source projects like GEOS and PROJ4 provide many of the building blocks for this. And of course, there is the Spatialite extension for SQLite. In fact, if it were up to me, I would see if there's some way to bootstrap Spatialite into Firebird.

I'm not a C/C++ developer so I can't really contribute much to this endeavor. I would be willing to make a small financial contribution to this task if that's what it would take to get this going. I don't have much to donate but maybe enough to buy a couple cases of beer or coffee or whatever :-) Perhaps others would be willing to contribute as well?

Juergen Seelmann added a comment - 28/Feb/14 07:49 AM
End of February 2014. Firebird 3.0 is upcoming with strong support for Python... Python is commonly used in the GIS environment. Still nobody supporting the spatial extension in a way as outlined by Peter Borissow/Simon Greener.

Vlad Khorsun added a comment - 01/Mar/14 10:12 AM
I think, tracker is not a good place to discuss such thing as sponsorship of developing of a new feature.
Better start discussion in fb-general or contact with Firebird Foundation.