Name: Geotechnical Report Extent
Display Field: GeotechExtentID
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: <div><div>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 planning</div><div>Geotechnical 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.</div><div>This database was August 2020. </div><div>All reports are available either on the Geotechnical Sharepoint or on ACCORD. </div><div>Editing of this dataset can be done with the approval of Ross Roberts. </div><div>geotechnical reports (i.e. tag them as Geotech and edit the GIS geometr, or a secondary process mayautomatically created property based geometry). </div><div><ul><li>Report data will be stored in OpenText/Accord, and will be flagged in SAP</li></ul></div><div><br /></div><div><b>Lineage: </b></div><div>Data was extracted from legacy council databases sourced from:</div><div><ul><li>ACC/FDC Filenet Reports</li><li>NSCC Dataworks Reports</li><li>WCC Pathway Reports</li><li>RDC Pathway Reports</li><li>MCC Alchemy Reports</li><li>SAP Reports (2015-2019)</li><li>ACGD Partner Reports (Watercare)</li></ul></div><div>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)</div><div>As some reports were not property based areas were manually digitised to indicate the extent of the report area.</div><div><br /></div><div><b>Future updates:</b></div><div>As at this date the data is not yet updated - though it is intended that:</div><div><ul><li>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.</li></ul></div></div><div><br /></div>
Copyright Text: Sarah Sinclair
Chief Engineer
Engineering and Technical Services
Auckland Council
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 1686431.2779
YMin: 5871395.331
XMax: 1825929.894
YMax: 6026808.7678
Spatial Reference: 2193 (2193)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"BoundarySource","uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[151,219,242,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[64,101,235,255],"width":0.4}},"value":"Digitised","label":"Digitised"},{"symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[255,255,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.4}},"value":"Property","label":"Property"},{"symbol":{"type":"esriSFS","style":"esriSFSBackwardDiagonal","color":[255,188,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[188,0,0,255],"width":0.4}},"value":"Soil Data","label":"Soil Data"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,251,179,255],"toColor":[252,251,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,179,252,255],"toColor":[222,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,238,252,255],"toColor":[179,238,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,189,255],"toColor":[252,187,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,210,255],"toColor":[179,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,232,212,255],"toColor":[252,232,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,249,255],"toColor":[252,215,249,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,198,252,255],"toColor":[187,198,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,239,255],"toColor":[215,252,239,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,252,179,255],"toColor":[210,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,233,255],"toColor":[252,179,233,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,225,252,255],"toColor":[212,225,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,252,212,255],"toColor":[240,252,212,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: BoundarySource
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- GeotechExtentID (type: esriFieldTypeString, alias: GeotechExtentID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LocationDescription (type: esriFieldTypeString, alias: LocationDescription, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- Locality (type: esriFieldTypeString, alias: Locality, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Hazard (type: esriFieldTypeString, alias: Hazard, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
- BoundarySource (type: esriFieldTypeString, alias: BoundarySource, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ReportDataCaptureComplete (type: esriFieldTypeString, alias: ReportDataCaptureComplete, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- VALIDATIONSTATE (type: esriFieldTypeSmallInteger, alias: VALIDATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Valid], [1: Not Valid and Public], [2: Valid and Private], ... 1 more ...)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Range: [1/1/1990 12:00:00 AM - 1/1/2050 12:00:00 AM])
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: Digitised
Name: Digitised
Domains:
- Field Name: ReportDataCaptureComplete
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: created_date
Inherited
- Field Name: last_edited_date
Inherited
Templates:
Name: Digitised
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- BoundarySource: Digitised
- VALIDATIONSTATE: 0
ID: Property
Name: Property
Domains:
- Field Name: ReportDataCaptureComplete
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: created_date
Inherited
- Field Name: last_edited_date
Inherited
Templates:
Name: Property
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- BoundarySource: Property
- VALIDATIONSTATE: 0
ID: Soil Data
Name: Soil Data
Domains:
- Field Name: ReportDataCaptureComplete
Inherited
- Field Name: VALIDATIONSTATE
Inherited
- Field Name: created_date
Inherited
- Field Name: last_edited_date
Inherited
Templates:
Name: Soil Data
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- BoundarySource: Soil Data
- VALIDATIONSTATE: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/2/2022 9:45:22 PM
Schema Last Edit Date: 10/2/2022 9:45:22 PM
Data Last Edit Date: 10/2/2022 9:45:22 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat