Paul, Thanks for this. My bad for not grabbing the latest code, reading the INSTALL file and doing the configure/make/install dance before asking. This is done now, and I have a 1.9.3 instance going now with PostGIS support. I will play with all this and let you know how it goes.
Where can I find more info about this xastir-ng stuff other than the few threads I find when googling? In the process of doing this implementation, I will end setting up a REST API on top of the positions DB using GeoDjango to query the database etc and return GeoRSS, KML, GeoJSON etc. If anyone is interested in this sort of thing, I am happy to share. Also, I will look into the APRSWorld schema if this is the best place for me to make an initial contribution. Jeff On Tue, Jul 8, 2008 at 11:10 AM, Paul J. Morris <[EMAIL PROTECTED]> wrote: > On Tue, 8 Jul 2008 09:04:21 -0700 > "Jeffrey Johnson" <[EMAIL PROTECTED]> wrote: > > What ever became of this? > > > > http://lists.xastir.org/pipermail/xastir-dev/2007-July/002674.html > > > > I am perhaps interested in contributing to this effort if its still > > alive. > > It is at a working proof of concept stage in the current 1.9.3 > development release. I haven't had a chance to work on in for a few > months, but (depending on the shift of effort to xastir-ng [where most > of this layer could be built rapidly with code generation tools]), it > is still quite alive, if rather experimental still. You can store > station positions as they are heard in a table in either MySQL or > PostGIS, and retrieve those positions on restarting xastir. > > Support for MySQL 5 or Postgresql+PostGIS can be enabled by building > xastir using: > > configure --with-mysql --with-postgis > > See section 12 in the INSTALL file. > > Only a minimal set of data is currently being stored (expanding to the > APRSWorld schema might be a nice next step). > > SQL to create the relevant tables can be found in > scripts/db_gis_mysql.sql and scripts/db_gis_postgis.sql > > http://xastir.cvs.sourceforge.net/xastir/xastir/scripts/db_gis_mysql.sql?view=markup > > http://xastir.cvs.sourceforge.net/xastir/xastir/scripts/db_gis_postgis.sql?view=markup > > Most of the code is in src/db_gis.c > http://xastir.cvs.sourceforge.net/xastir/xastir/src/db_gis.c?view=markup > with other blocks in interface.c, interface_gui.c, main.c, and > xa_config.c identifiable with #ifdef HAVE_DB directives. > > -Paul > -- > Paul J. Morris > Biodiversity Informatics Manager > Harvard University Herbaria/Museum of Comparative Zoölogy > [EMAIL PROTECTED] AA3SD PGP public key available > _______________________________________________ Xastir-dev mailing list Xastir-dev@xastir.org http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir-dev
