{
 "currentVersion": 10.91,
 "id": 25,
 "name": "valtakunnallinen_kairasydanarkisto",
 "type": "Feature Layer",
 "description": "The centralised data storage facilities of the Geological Survey of Finland (GTK) contain altogether 28857 deep drill holes and boreholes to the bedrock. The drillings began in the 1920's and they still continue. The drilling data has been collected to databases since in 1989. The information of drillings which are older than this has been digitised when necessary. \nThe deep drill holes of the bedrock are a spatial data in which the rock sample has been taken from a certain location by drilling. The data contains the information which is related to this sample site and to the core sample. The azimuth, dip and length of the drill hole vary according to the geological environment of the area. The drilling is performed based on the drilling plan drawn up by a geologist. The geologist supervises the drilling site and the realization of the plan and observes and records the information to the database. \nThe following information is saved to the database: the information related to the positioning and location of the drilling, the information about the drilling organization, the information of the storage place of the core sample, the dip of the drill hole, the lithological information of the sample, cutting angle of the structures, the ore minerals and their appearance in the sample, mineral alteration, structure and texture, stratigraphy, core loss, analysed sample intervals and the geochemical analysis results, physical and petrophysical laboratory measurements, drill hole soundings and thin sections. \nIn the deep drill holes the azimuth is determinated in degrees. In the full circle there are 360°. The cardinal azimuth is set to be North (000° or 360°). The hole azimuth is decided by the geologist assisted by geophysical background information and geophysicist. The objective is to get a representative sample of the bedrock units. \nHole dip refers to the angle between a horizontal direction and a drilling. The hole dip in the databases of GTK is represented in degrees (°). The dip of the vertical hole is 90°. In horizontal hole the dip is 0°. In that case the drilling has been performed either in a mine or in a quarry or the sample is continuous gouge sample sawed from the bedrock. With respect to the horizontal surface the dip of the drill hole is negative upwards. For example, when a dip is -45° the hole has been drilled in underground mine in the angle of 45 degrees to upwards. The dip of the hole to be drilled is decided by the geologist assisted by geophysical background information and geophysicist. The dip can be presented also as grads. This unit has been used mainly by mining companies. \nThe length of the drilled hole in the databases of the GTK is represented in metres (m). In addition to the drilling plan, the capacity of the drilling machine and the quality of the bedrock affect the length of the drill hole. In the shattered bedrock the hole can be jammed before the objective length. The lengths of the drilled holes vary from 1 metre to 2,5 kilometres. \nPetrophysical laboratory measurements have been made from the drill core since about the year 1965. Since the year 1963 petrological and ore analyses have been made from the selected core samples. The use of analyses was established and increased at the end of the 1980's with the development of analysis methods. During the present the geochemical analyses are an essential part of the drilling project and are done from all the bore holes, with few exceptions. The type samples representing the lithological units of the area and the sample intervals significant to exploration are selected for analyses. \nThe deep drill holes have been made by the following programmes of the GTK: ore exploration, rock and mineral aggregate studies, natural stone investigations, bedrock mapping and urban mapping. In addition to these, the deep drill holes have been made among others by Outokumpu, Rautaruukki and Lapin Malmi and by the cooperation projects drawn by the universities. The data sets from different sources are not commensurable and information on the quality of the data is partly lacking. The data have been digitised when necessary and a part of the drilling information is still in the paper based archives.",
 "geometryType": "esriGeometryPoint",
 "sourceSpatialReference": {
  "wkid": 102139,
  "latestWkid": 3067
 },
 "copyrightText": "CreditCd, CreditCd, CreditCd, CreditCd, CreditCd, CreditCd",
 "parentLayer": null,
 "subLayers": [],
 "minScale": 0,
 "maxScale": 0,
 "drawingInfo": {
  "renderer": {
   "type": "simple",
   "symbol": {
    "type": "esriSMS",
    "style": "esriSMSCircle",
    "color": [
     0,
     148,
     86,
     255
    ],
    "size": 4,
    "angle": 0,
    "xoffset": 0,
    "yoffset": 0,
    "outline": {
     "color": [
      0,
      0,
      0,
      255
     ],
     "width": 1
    }
   },
   "label": "",
   "description": ""
  },
  "transparency": 0,
  "labelingInfo": null
 },
 "defaultVisibility": false,
 "extent": {
  "xmin": 202315.6901,
  "ymin": 6654756.4561,
  "xmax": 729992,
  "ymax": 7752771.7812,
  "spatialReference": {
   "wkid": 102139,
   "latestWkid": 3067
  }
 },
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
 "displayField": "HOLE_ID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ARCHIVE_NUMBER",
   "type": "esriFieldTypeDouble",
   "alias": "ARCHIVE_NUMBER",
   "domain": null
  },
  {
   "name": "HOLE_ID",
   "type": "esriFieldTypeString",
   "alias": "HOLE_ID",
   "length": 30,
   "domain": null
  },
  {
   "name": "HOLE_ID2",
   "type": "esriFieldTypeString",
   "alias": "HOLE_ID2",
   "length": 30,
   "domain": null
  },
  {
   "name": "NORTHING",
   "type": "esriFieldTypeDouble",
   "alias": "NORTHING",
   "domain": null
  },
  {
   "name": "EASTING",
   "type": "esriFieldTypeDouble",
   "alias": "EASTING",
   "domain": null
  },
  {
   "name": "NORTHING_YKJ",
   "type": "esriFieldTypeDouble",
   "alias": "NORTHING_YKJ",
   "domain": null
  },
  {
   "name": "EASTING_YKJ",
   "type": "esriFieldTypeDouble",
   "alias": "EASTING_YKJ",
   "domain": null
  },
  {
   "name": "KKJ_100K_SHEET",
   "type": "esriFieldTypeString",
   "alias": "KKJ_100K_SHEET",
   "length": 8,
   "domain": null
  },
  {
   "name": "UTM_50K_SHEET",
   "type": "esriFieldTypeString",
   "alias": "UTM_50K_SHEET",
   "length": 8,
   "domain": null
  },
  {
   "name": "DRILLING_YEAR",
   "type": "esriFieldTypeString",
   "alias": "DRILLING_YEAR",
   "length": 4,
   "domain": null
  },
  {
   "name": "HOLE_LENGTH",
   "type": "esriFieldTypeDouble",
   "alias": "HOLE_LENGTH",
   "domain": null
  },
  {
   "name": "HOLE_AZIMUTH",
   "type": "esriFieldTypeDouble",
   "alias": "HOLE_AZIMUTH",
   "domain": null
  },
  {
   "name": "HOLE_DIP",
   "type": "esriFieldTypeDouble",
   "alias": "HOLE_DIP",
   "domain": null
  },
  {
   "name": "SOIL_DRILLING",
   "type": "esriFieldTypeDouble",
   "alias": "SOIL_DRILLING",
   "domain": null
  },
  {
   "name": "ORGANIZATION",
   "type": "esriFieldTypeString",
   "alias": "ORGANIZATION",
   "length": 50,
   "domain": null
  },
  {
   "name": "DRILLING_CONTRACTOR",
   "type": "esriFieldTypeString",
   "alias": "DRILLING_CONTRACTOR",
   "length": 50,
   "domain": null
  },
  {
   "name": "SENDER_COMPANY",
   "type": "esriFieldTypeString",
   "alias": "SENDER_COMPANY",
   "length": 50,
   "domain": null
  },
  {
   "name": "RECEIVING_DATE",
   "type": "esriFieldTypeDate",
   "alias": "RECEIVING_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "BOXES",
   "type": "esriFieldTypeDouble",
   "alias": "BOXES",
   "domain": null
  },
  {
   "name": "STORAGE_PLACE",
   "type": "esriFieldTypeString",
   "alias": "STORAGE_PLACE",
   "length": 10,
   "domain": null
  },
  {
   "name": "ARCHIVE_PLACE",
   "type": "esriFieldTypeString",
   "alias": "ARCHIVE_PLACE",
   "length": 20,
   "domain": null
  },
  {
   "name": "STATUS",
   "type": "esriFieldTypeString",
   "alias": "STATUS",
   "length": 20,
   "domain": null
  },
  {
   "name": "SHAPE",
   "type": "esriFieldTypeGeometry",
   "alias": "SHAPE",
   "domain": null
  }
 ],
 "geometryField": {
  "name": "SHAPE",
  "type": "esriFieldTypeGeometry",
  "alias": "SHAPE"
 },
 "indexes": [
  {
   "name": "R271_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "A256_IX1",
   "fields": "SHAPE",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "canModifyLayer": true,
 "canScaleSymbols": false,
 "hasLabels": false,
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, geoJSON",
 "isDataVersioned": false,
 "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "supportsDatumTransformation": true,
 "dateFieldsTimeReference": null,
 "supportsCoordinatesQuantization": true
}