Table | Name | Field Alias | Data Type | Description |
WATER.GW_NETWORKS | UNIT_NO | | Long Integer | A unique identifier for a drillhole |
WATER.GW_NETWORKS | DHNO | | Long Integer | Drillhole Number unique internally generated number |
WATER.GW_NETWORKS | NAME | | text | Name of the drillhole. |
WATER.GW_NETWORKS | EASTING | | Double | Easting |
WATER.GW_NETWORKS | NORTHING | | Double | Northing |
WATER.GW_NETWORKS | ZONE | | short integer | MGA Zone (GDA94) in which the drillhole is located. |
WATER.GW_NETWORKS | LAT | | Double | Decimal latitude degrees south ,of the drillhole, (denormalised from lat_degrees, minutes, seconds) (GDA94). |
WATER.GW_NETWORKS | LON | | Double | Decimal longitude degrees (denormalised from long degrees, minutes, seconds) (GDA94). |
WATER.GW_NETWORKS | REF_ELEV | | Double | The AHD(Australian Height Datum) elevation of an elevation point |
WATER.GW_NETWORKS | GRND_ELEV | | Double | Elevation point at drillhole location, derived from DEM |
WATER.GW_NETWORKS | HUND | | text | Name of the hundred in which the drillhole is located. |
WATER.GW_NETWORKS | PARCEL | | text | Parcel type and number in which the drillhole is located |
WATER.GW_NETWORKS | PARCELNO | | text | The unique No. for the Parcel, where the drillhole is located |
WATER.GW_NETWORKS | PARCELID | | text | A concatenation of the Plan Type, plan number, Parcel Type and Parcel Number to form a unique ID, where the drillhole is located |
WATER.GW_NETWORKS | STATE | | text | State code where the drillhole is located eg SA |
WATER.GW_NETWORKS | PRESCRIBED_WELL_AREA | | text | Prescribed Well Area point is located in. |
WATER.GW_NETWORKS | PRESC_WATER_RES_AREA | | text | Prescribed Water Resource Area point is located in. |
WATER.GW_NETWORKS | NRM_REGION_CODE | | text | NRM Region point is located in. |
WATER.GW_NETWORKS | MAP | | short integer | 1:100 000 map sheet number |
WATER.GW_NETWORKS | NUM | | Long Integer | Sequential number for the drillhole |
WATER.GW_NETWORKS | STATUS | | text | Status code e.g. (BKF) |
WATER.GW_NETWORKS | DESC_ | | text | Status description e.g. (Backfilled) |
WATER.GW_NETWORKS | PURPOSE | | text | Purpose code e.g. (DOM) |
WATER.GW_NETWORKS | PURP_DESC | | text | Purpose description e.g. (Domestic) |
WATER.GW_NETWORKS | PURPOSE2 | | text | Secondary purpose code e.g. (DOM) |
WATER.GW_NETWORKS | PURP2_DESC | | text | Secondary purpose description e.g. (Domestic) |
WATER.GW_NETWORKS | PURPOSE3 | | text | Tertiary purpose code e.g. (DOM) |
WATER.GW_NETWORKS | PURP3_DESC | | text | Tertiary purpose description e.g. (Domestic) |
WATER.GW_NETWORKS | ANALFULL | | text | Flag field indicating whether a full chemical analysis, for the drillhole has been taken (Y or N). |
WATER.GW_NETWORKS | PH | | Double | pH level (if known) |
WATER.GW_NETWORKS | TDS | | Long Integer | Total Dissolved Salts |
WATER.GW_NETWORKS | TDSDATE | | Date | Date of TDS test |
WATER.GW_NETWORKS | YIELD | | Double | The rate, in L/sec, at which water is extracted or is flowing from the drillhole. |
WATER.GW_NETWORKS | YIELD_DATE | | Date | Observation date for well yield measurement |
WATER.GW_NETWORKS | WATER_CUT | | Double | Distance from drillhole to where water began flowing |
WATER.GW_NETWORKS | DTW | | Double | The measured distance, in metres, from a reference point to the water surface in the drillhole |
WATER.GW_NETWORKS | SWL | | Double | The latest standing water level (time series) value, in metres, recorded for the drillhole |
WATER.GW_NETWORKS | SWLDATE | | Double | Latest observation date of SWL |
WATER.GW_NETWORKS | DRILL_DATE | | Date | Date well was drilled (if known) |
WATER.GW_NETWORKS | LAT_DEPTH | | Double | Latest known depth, in metres, for the drillhole. |
WATER.GW_NETWORKS | ORIG_DEPTH | | Double | Maximum depth, in metres, of the drillhole when it was originally drilled |
WATER.GW_NETWORKS | MAX_DEPTH | | Double | The maximum depth, in metres, to which the drillhole has been drilled |
WATER.GW_NETWORKS | PERMIT_NO | | Long Integer | Latest well construction permit number relating to a drillhole |
WATER.GW_NETWORKS | PERMIT_EX | | text | Permit extension code |
WATER.GW_NETWORKS | LOGGEOPHYS | | text | Flag field indicating that a geophysical log, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | LOGDRILL | | text | Flag field indicating that a driller's log, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | LOGGEOL | | text | Flag field indicating that a geological log, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | LOGSTRAT | | text | Flag field indicating that a stratigraphical log, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | LOGHYDROSTRAT | | text | Flag field indicating that a hydro-stratigraphical log, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | LOGGER_DATA | | text | Flag field indicating that a logger data, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | TELEMETRY_DATA | | text | Flag field indicating that a Telemetry data, for the drillhole, exists in the data base (Y or N). |
WATER.GW_NETWORKS | OBSHUND | | text | Hundred in which the well is located (3 characters) |
WATER.GW_NETWORKS | OBSSEQ | | short integer | Number which uniquely identifies that well in the hundred (3 digits) |
WATER.GW_NETWORKS | OBSNUMBER | | text | Combination of the hundred in which the well is located (OBSHUND) and a number which uniquely identifies that well in the hundred (OBSSEQ) |
WATER.GW_NETWORKS | CLASS | | text | Identifies the purpose or type of the drillhole |
WATER.GW_NETWORKS | WW_CLASS | | text | Flag field indicating if drillhole is a water well (Y or N) |
WATER.GW_NETWORKS | PRIVATE | | text | Flag field indicating if it is a private well |
WATER.GW_NETWORKS | EC | | Long Integer | A measure of the electrical conductivity, in uS/cm, of the water sample. |
WATER.GW_NETWORKS | RSWL | | Double | Reduced Standing Water Level - the elevation of the water level, typically measured in mAHD. It is calculated by subtracting the Depth to Water (DTW) from the reference elevation. A negative value indicates that the water level is below mean sea level. |
WATER.GW_NETWORKS | AQ_MON | | text | Aquifer monitoring code |
WATER.GW_NETWORKS | AQ_MONDESC | | text | Aquifer ¿ full description |
WATER.GW_NETWORKS | PHOTO | | text | Flag field indicating if drillhole has a photo in the database (Y or N) |
WATER.GW_NETWORKS | SWL_STATUS | | text | A unique code indicating the water level monitoring status of a drillhole - current (C), historical (H) or not monitored for water levels (N) |
WATER.GW_NETWORKS | SWL_FREQ | | text | A number or code indicating the frequency (monthly) at which the water level is measured in the monitoring point. Typically 1,2,3,4,6,12 monthly or R (random). |
WATER.GW_NETWORKS | TDS_STATUS | | text | A unique code indicating the salinity monitoring status of a drillhole - current (C), historical (H) or not monitored for salinity (N) |
WATER.GW_NETWORKS | TDS_FREQ | | text | A number or code indicating the frequency (monthly) at which the salinity is measured in the monitoring point. Typically 1,2,3,4,6,12 monthly or R (random). |
WATER.GW_NETWORKS | GROUP_CODE | | text | A unique code identifying a group or collection of wells. This is the network name for observation bore monitoring networks. |
WATER.GW_NETWORKS | GROUP_DESC | | text | Description of Group or Monitoring Network |
WATER.GW_NETWORKS | GROUP_TYPE | | text | A unique code used to identify what the grouping of wells (GROUP_CODE) represents. Commonly used groundwater codes are OMN (observation monitoring network) or PR (project). |
WATER.GW_NETWORKS | STATE_ASSET | | text | Flag field indicating if drillhole is State owned (Y, N or U) |
WATER.GW_NETWORKS | OWNER_CODE | | text | Agency owner code e.g. PIRSA |
WATER.GW_NETWORKS | STATE_ASSET_RETAINED | | text | Flag field indicating if drillhole is state retained asset (Y or N) |
WATER.GW_NETWORKS | STATE_ASSET_STATUS | | text | Drillholes current status in the Network |