This dataset includes geotechnical reports available throughout Auckland Council systems. Geotechnical reports are written by suitably qualified and experienced geotechnical engineers or engineering geologists and include information on ground quality and subsurface geology. They are generally undertaken for infrastructure and building development or land use planningGeotechnical reports are received by council as part of consent applications, and are stored on the related property file. For each legacy council these records were located with the help of the document management team. Although spatial data was generated by property, the final database is not tagged to property parcels. Where feasible, detailed location polygons were generated using site maps available in the individual reports. In addition, some geotechnical reports are received by council for our own projects. These are also provided where available.This database was August 2020. All reports are available either on the Geotechnical Sharepoint or on ACCORD. Editing of this dataset can be done with the approval of Ross Roberts. geotechnical reports (i.e. tag them as Geotech and edit the GIS geometr, or a secondary process mayautomatically created property based geometry). Report data will be stored in OpenText/Accord, and will be flagged in SAPLineage: Data was extracted from legacy council databases sourced from:ACC/FDC Filenet ReportsNSCC Dataworks ReportsWCC Pathway ReportsRDC Pathway ReportsMCC Alchemy ReportsSAP Reports (2015-2019)ACGD Partner Reports (Watercare)These were evaluated to remove duplicate records, and associated with property records. Using property records a process was created for a one off load of the data (Geospatial team) using the property boundaries to create a base geometry. As one area may have several reports a separate related table was created to hold summary details of the reports. (Geotechnical Report Details)As some reports were not property based areas were manually digitised to indicate the extent of the report area.Future updates:As at this date the data is not yet updated - though it is intended that:The database will be updated whenever a new report is received. When a geotechnical report comes into council as part of a resource or building consent, the SAP team will need to follow the SAP protocol for In addition, new consent applications with geotechnical reports will be added, as will geotechnical reports undertaken for Auckland Council projects. Reports from other sources (e.g. CCOs, other crown entities) may be added where appropriate.