-
Notifications
You must be signed in to change notification settings - Fork 10
/
README
44 lines (26 loc) · 1.29 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Here we keep the Data base design and code.
So far only a first draft database design done with Power Architect
and some example code to verify it.
Power Architect makes sql code automatically. However, there is (yet) no support for postGIS.
We need to make a small script that will take the automatically generated sql code
from Power Architect and insert the geography specific parameters/tags for postGIS.
So far the automatically generated sql code has been adapted manually to comply with postGIS.
Content:
* README
This file
* pytroll_db.architect
The db-design as done with Power Architect
* pytroll_db_v2.sql
The slightly modified/edited sql file that was generated automatically from pgDesigner
* postgisify_pytroll_db.py*
Creates PostGIS version of pytroll_db create SQL
* pytroll_db.py
SQLAlchemy interface for the pytroll DB
* pytroll_db_insert_pps.sql
Test code to insert some PPS values into the database.
* pps_db_import.py
Scan directory for global metop PPS cloudtype granules and add to DB
* pytroll_cleanup.py
Clean up DB files based on content of dir containing global metop PPS cloudtype granules
Esben & Adam
2011-11-11