mfrasca / ghini-inception Goto Github PK

when I open Ghini, I land directly in the map, while I would like to select the garden I'm going to explore. and once I'm connected to a garden, I would like the option "explore a different area".

currently, the botanische tuinen have a database which they happily use.
(btuu : botanische tuinen universiteit utrecht)
I think it is necessary to map their scheme into sqlalchemy before doing anything else.
a following step will probably be criticise the scheme, but first let's map (and understand) it

when a user adds stuff to the pg database in whatever way external to Ghini, like using Bauble, the database should have some triggering configured so the Ghini server can broadcast the event to the connected clients.

If one inserts a new genus and species and a day later you want to add information that you have forgotten or extra notes you cannot save the new information with ok.
The ok button is not active
The same for inserting local names in Spanish or English or other language

Llamar a Sra. Ochoa

• Cita con Memo pero hasta ahora no he llegado (la tiera, la casa>>>>)

looks nicer and we're very well on time to do so.
https://www.npmjs.com/package/pg-promise
https://promisesaplus.com/
https://github.com/vitaly-t/pg-promise/wiki

write a description of the current form of the database as used at the botanische tuin of the Utrecht university.

the description should explicitly include foreign keys and reference to the ITFv2 document.

just transposing notes from paper to digital.
need review!

entry points: search by taxon, accession, location

Phone Alberto Gomez Mejia from red de Jardin Botancio en Colombia and find out if BG recorder data base system is still used. Maybe new update?
Maybe he can give also some advise on fundraising possibilities for Cuchubo garden.

57 3102127510 or 57 16608136

just transposing notes from paper to digital.
need review!

the ITF.xml file contains some data that could be put into the database.

If you type in a living plant location like FHK44-A1 you cannot see this fully written on the screen.
You miss a few letters or numbers.
Create more space.

currently all users can add and move plants around.
this is not desirable.
we need some user management, and lacking that we better NOT let anybody alter anything, just browse.

I've just registered ghini on http://travis-ci.org/mfrasca/ghini.
travisci obviously complains about "no test specified"!

npm test
> [email protected] test /home/travis/build/mfrasca/ghini
> echo "Error: no test specified" && exit 1
Error: no test specified
npm ERR! Test failed. See above for more details.
npm ERR! not ok code 0
The command "npm test" exited with 1.

user has a plant under their arm and wants to insert it in the database, associating it to a location in the garden.

1. verify that the taxon in there in the database (otherwise look it up from tpl)
2. describe the accession associating it to the taxon
3. create as many living localized accessions (still need decide the name of these objects) as the garden locations where they put the accession.

Inform him of date of arrival
Availability house
Land surface, location

the kew.org site offers some data, we could import from there into taxon.
maybe.

Please Mario rápido,
I want to put pictures of plants, as link, in the database. How can I do this?

Hablar sobre proyecto de manglar (2002) CARSURCRE y Fusabana

Objetivo del Projecto, Manera de motivar personas,actividades, resultados, estan todavia trabajando recuperar el mangle

Luis Eduardo Julio y Honorio Guerra

on your code like this:

db.query("UPDATE plant SET position_lat={0}, position_lon={1}, zoom={4} WHERE code='{3}' AND accession_id=(SELECT id FROM accession WHERE code='{2}')".formatU([data.lat, data.lng, data.accession, data.plant_short, data.zoom]))

You should not format queries like that. There are too many cases where such formatting will become broken. For example, if any of the text strings has quote ' in it. Only pg-propmise knows how to correctly inject all JavaScript types into a query,and that's the query formatting you should be using.