In addition to the tables from relational databases (ORACLE and Access), the Irrigation Module is linking to GIS files. The used file format is ArcView shapefile (*.shp). Each shapefile is linked through an index file (*.shx) to an attribute table in dBase format (*.dbf).
Neither the geometry of the spatial data nor their attribute tables are modified, as they are only used for spatial selection. The location of the files is either offline (on a local drive) or online (on a network drive). At both locations, the same directory structure is assumed, i.e. the files are residing in the three subdirectories base data, thematic data and balancing.
The names and relevant fields of the GIS files are contained in table TShapefiles within the database application. Name and table structure are taken from the DVS (Digital Visualisation System)
| SFCode | AVSFName | AVSubDir | SFName | CodeField | NameField | SelOutputField | IntersectCode | LabelThreshold | LabelSize | Color |
|---|---|---|---|---|---|---|---|---|---|---|
| 01 | nation | base data | Nation | NAME | NAME | NAT | 2 | 0.04 | dvsOcher | |
| 02 | govern | base data | Governorate | CODE | GOVERNORAT | GOV | GOV | 2 | 0.025 | dvsOcher |
| 03 | districts | base data | District | ADMIN_ID | DIST_NAME | DIST | DIS | 0.4 | 0.025 | dvsOcher |
| 04 | mainswbasins | base data | Surfacewater basin | IDEN | BASIN_NAME | MSWB | MSW | 2 | 0.022 | dvsLightGreen |
| 06 | agro_zones | base data | Agro-climatic zone | ZONE | NAME | AGZ | AGZ | 2 | 0.021 | dvsLightGreen |
| 07 | gw_basins | base data | Groundwater basin | GW_CODE | NAME | GWB | GW | 2 | 0.025 | dvsKhaki |
| 21 | settlements | base data | Settlements | SETT_ID | SETT_NAME | SETT_ID | 0.07 | 0.02 | dvsRed | |
| 23 | irri_cen | thematic data | Irrigation centers | SETT_ID | SETT_NAME | ZONE | 0.1 | 0.02 | dvsDarkGreen |