P13 Spatial database

PirroNord_wiki|PirroNord wiki

The most important thing of all is to document the way you have organised your database and entered information into it! It is essential that source-specific information is recorded as and when data is generated, as this task becomes increasingly difficult retrospectively. Where did the source data originate from, what was the scale at which it was prepared, if based on others' work where can this be found, and what are the copyright restrictions involved in its use by a third party? What levels of accuracy were accepted and what errors were recorded during digitization etc? What data standards were adhered to (dated if possible, as revisions will occur) and what naming conventions have been adopted. GIS Guide to Good Practice

PostgreSQL + PostGIS

 * Refer to PostgreSQL for database creation and management.

SQL

 * Database graphical schema


 * Database SQL code

Please note that the database structure has been recently updated since the 2012 version. Have a look at the history of page for diff.