For a number of uses of IATI data you might want to put IATI data into a relational database. The diagram attached shows one possible structure for normalising the data - separating out all the elements that could have a one-to-many relationship with a core activity (or transaction etc.) into their own tables.
You can see what is mandatory (1..), optional (0..) and only allowed to have a single value (..1) in the documentation for the IATI Standard: http://iatistandard.org/standard/activities
A question from the <A href="http://groups.drupal.org/node/161214#comment-542089">Drupal forum</a>: is there a normalisation diagram for the organisation standard?
I noticed that the fact that location~gazetteer entry is a 0-* in the Standard. This allows you to refer to multiple sources (like your own map + Openstreetmap).
That is not reflected in the (awesome) image.
Do you have the sources for this file in an open format (i use dia)? That would be useful for a iati > drupal mapping diagram. am at reinier dot battenberg at mountbatten doot net
3 Comments