GIS data used by the Irrigation Module

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