From: Franck Martin <F<ranck@so...> - 2000-04-18 00:08:21
Nice to hear from you...
I had a quicklook of Mysql and mSql and I have to review it a little bit as
I now know more Postgres. For me Postgres seems more mature than others due
to the fact that it includes triggers, functions, foreign keys.., which
cause speed loss. I'm not sure that triggers and functions will be used in
the beginning, but it is important in a GIS. Also Postgres allows
customisation of data types. I have to look in that... It also has a good
user security system, to allow multiuser environment.
Also, MySQL and mSQL have got fancy licences, same as between Qt and GTK+.
The only problem so far is that postgres is limited to an 8kB record, and
one should use large objects to store data. There are no such things as
varbinary in PG ! The postgres team thinks to remove this limitation in 7.1
(7.0 has just been released).
For the moment the application is mostly empty, and is only a GUI. I don't
even draw a polygon on the screen... What I want is to start from the GUI
and go into GIS, and not the opposite...
I'm currently working on having the display a real OpenGL display... Then I
will add geographical object types, and work on the datum transformation
May I suggest you get the code from the CVS (read the install, or just read
the code, there is not much). And give me some input... I will try to post a
modified OpenGIS spec, to give some guidelines...
You could give us your experience in storing geographical data, and which
attributes you would like to see...
I'm working in an organisation which does geoscience so boreholes are
familiar to me, but I develop fmaps on my free time. I think plenty people
have plenty GIS software, but not a common API to put it together in a nice
interface.. So if you like to work on fmaps, it is your chance to modify
stuff.. I have been advertising fmaps above it is real value, to bring
people together on a nice team...
Network and Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
E-mail: franck@... <mailto:franck@...>
Web site: http://www.sopac.org.fj <http://www.sopac.org.fj>
From: SJ Geophysics Ltd [mailto:sydv@...]
Sent: Tuesday, April 18, 2000 11:16 AM
Subject: [Fmaps-devel] Interested in the fmap project
I'm interested in what fmaps is doing. I've been involved
with GIS in
geoscience apps for quite a few years and have been hoping a
source group could get started. We have been working on a
home grown GIS,
initially for geophysical applications, but with designs to
support 3D data
including drill-holes, surface data collected on and off
surface and u/g mapping and remotely sensed data. To date
we have focused