In addition to the tables from relational databases (ORACLE and Access), the Pre-Processing 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). Even the table contents are just slightly changed; thus, the table contains several records which are only relevant for the DVS and not for the pre-processing module.
The way where and how GIS files are used is shown is described in a system of 3 related tables.
TShapefiles
| SFCode | AVSFName | AVSubDir | SFName | CodeField | NameField | SelOutputField | IntersectCode | LabelThreshold | LabelSize | Color |
|---|---|---|---|---|---|---|---|---|---|---|
| 01 | nation | base data | Nation | NAME | NAME | NAT | 2 | 0.05 | dvsOcher | |
| 02 | govern | base data | Governorate | CODE | GOVERNORAT | GOV | GOV | 2 | 0.03 | dvsOcher |
| 03 | districts | base data | District | ADMIN_ID | DIST_NAME | DIST | DIS | 0.4 | 0.026 | dvsOcher |
| 04 | mainswbasins | base data | Surfacewater basin | MAINSWBASI | BASIN_NAME | MSWB | MSW | 2 | 0.026 | dvsLightGreen |
| 05 | service_zones | thematic data | Service zone | SERVZ_ID | DESCR | SZ | SPZ | 0.15 | 0.03 | dvsLightGreen |
| 06 | agro_zones | base data | Agro-climatic zone | ZONE | NAME | AGZ | AGZ | 2 | 0.025 | dvsLightGreen |
| 07 | supply_zones | thematic data | Supply zone | CODE | DESCRIPTIO | SZ_ID | SUZ | 0.15 | 0.03 | dvsLightGreen |
| 21 | settle | base data | Settlements | SETT_ID | SETT_NAME | SETT_ID | 0.07 | 0.02 | dvsRed | |
| 22 | treatment_plants | thematic data | WWT Plants | FAC_ID | NAME_ | FAC_ID | 0.4 | 0.02 | dvsMagenta | |
| 23 | irri_cen | thematic data | Irrigation centers | SETT_ID | SETT_NAME | SETT_ID | 0.2 | 0.02 | dvsDarkGreen | |
| 24 | transfer_stations | balancing | Transfer stations | STATION_ID | DESCRIPTIO | STATION_ID | 0.4 | 0.02 | dvsMagenta | |
| 25 | transfer_tp | balancing | Transfer points | TP_ID | TP_ID | TP_ID | 0.4 | 0.02 | dvsBlue | |
| 26 | wadi_endpoints | balancing | Wadi endpoint | WEP_ID | WEP_ID | WEP_ID | 0.4 | 0.02 | dvsBlue | |
| 27 | industries | thematic data | Industries | FACILITY_I | NAME | FAC_ID | 0.3 | 0.02 | dvsMagenta | |
| 28 | rainstations | thematic data | Rainfall stations | CODE | NAME | STAT_ID | 0.3 | 0.02 | dvsBlue | |
| 29 | wells | thematic data | Wells | PALC | PALC | STAT_ID | 0.1 | 0.02 | dvsBlue | |
| 30 | Gaugingstations | thematic data | Gauging stations | IDEN | STATION_NA | STAT_ID | 0.4 | 0.02 | dvsBlue | |
| 41 | transfersystems | balancing | Transfer system | TS_ID | TS_ID | TS_ID | 0.4 | 0.02 | dvsBlue | |
| 42 | baseflowsystems | balancing | Baseflow system | BS_ID | NAME | BS_ID | 0.4 | 0.02 | dvsBlue |