{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Subsurface Layer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LAYER_TYPE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SUBSURF_LAYER_ID", "type": "esriFieldTypeInteger", "alias": "Subsurface layer ID", "domain": null }, { "name": "EXPLOR_ID", "type": "esriFieldTypeInteger", "alias": "Exploration ID", "domain": null }, { "name": "LAYER_NUM", "type": "esriFieldTypeSmallInteger", "alias": "Layer number", "domain": { "type": "range", "name": "LAYER_NUM", "description": "Layer number", "range": [ 0, 999 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAYER_TYPE", "type": "esriFieldTypeString", "alias": "Layer type", "length": 10, "domain": { "type": "codedValue", "name": "LAYER_TYPE", "description": "Subsurface layer type", "codedValues": [ { "name": "Gradational", "code": "Grad" }, { "name": "Interbedded", "code": "Int" }, { "name": "Single Layer", "code": "Lay" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAYER_TOP_DEPTH", "type": "esriFieldTypeSingle", "alias": "Layer top depth", "domain": { "type": "range", "name": "EXPLOR_DEPTH", "description": "Exploration Depth", "range": [ 0, 0 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAYER_BOT_DEPTH", "type": "esriFieldTypeSingle", "alias": "Layer bottom depth", "domain": { "type": "range", "name": "EXPLOR_DEPTH", "description": "Exploration Depth", "range": [ 0, 0 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAYER_DESC", "type": "esriFieldTypeString", "alias": "Layer description", "length": 500, "domain": null }, { "name": "MAT_DENSITY", "type": "esriFieldTypeString", "alias": "Material density", "length": 10, "domain": { "type": "codedValue", "name": "MAT_DENSITY", "description": "Material density", "codedValues": [ { "name": "Dense", "code": "Dense" }, { "name": "Hard", "code": "Hard" }, { "name": "Loose", "code": "Loose" }, { "name": "Medium dense", "code": "MDense" }, { "name": "Medium stiff", "code": "MStiff" }, { "name": "Not applicable", "code": "NA" }, { "name": "Non-standard", "code": "NS" }, { "name": "Soft", "code": "Soft" }, { "name": "Stiff", "code": "Stiff" }, { "name": "Unknown", "code": "U" }, { "name": "Very dense", "code": "VDense" }, { "name": "Very loose", "code": "VLoose" }, { "name": "Very soft", "code": "VSoft" }, { "name": "Very stiff", "code": "VStiff" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_DENSITY_RANGE", "type": "esriFieldTypeSmallInteger", "alias": "Material density is range", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MINOR_GRAVEL", "type": "esriFieldTypeSmallInteger", "alias": "Minor material gravel", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MINOR_SAND", "type": "esriFieldTypeSmallInteger", "alias": "Minor material sand", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MINOR_SILT", "type": "esriFieldTypeSmallInteger", "alias": "Minor material silt", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MINOR_CLAY", "type": "esriFieldTypeSmallInteger", "alias": "Minor material clay", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MAJOR", "type": "esriFieldTypeString", "alias": "Major material", "length": 10, "domain": { "type": "codedValue", "name": "MAT_MAJOR", "description": "Major material type", "codedValues": [ { "name": "Asphalt/Concrete +", "code": "ASPH_CONC" }, { "name": "Clay", "code": "CLAY" }, { "name": "Cobbles +", "code": "COBBLES" }, { "name": "Gravel", "code": "GRAVEL" }, { "name": "No Description", "code": "NO_DESC" }, { "name": "Peat", "code": "PEAT" }, { "name": "Sand", "code": "SAND" }, { "name": "Silt", "code": "SILT" }, { "name": "Topsoil/Vegetation +", "code": "TOP_VEG" }, { "name": "Unknown", "code": "U" }, { "name": "Rock - Plutonic & Metamorphic", "code": "ROCK_PLUT" }, { "name": "Rock - Sedimentary", "code": "ROCK_SED" }, { "name": "Rock - Volcanic", "code": "ROCK_VOLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MINOR_ORG", "type": "esriFieldTypeSmallInteger", "alias": "Minor material organic(s)", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_MINOR_DEB", "type": "esriFieldTypeSmallInteger", "alias": "Minor material debris", "domain": { "type": "codedValue", "name": "BOOLEAN_YN", "description": "Yes/No", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_USCS", "type": "esriFieldTypeString", "alias": "Material USCS", "length": 10, "domain": { "type": "codedValue", "name": "MAT_USCS", "description": "USCS classification on log", "codedValues": [ { "name": "CH", "code": "CH" }, { "name": "CL", "code": "CL" }, { "name": "CL-ML", "code": "CL-ML" }, { "name": "GC", "code": "GC" }, { "name": "GC-GM", "code": "GC-GM" }, { "name": "GM", "code": "GM" }, { "name": "GP", "code": "GP" }, { "name": "GP-GC", "code": "GP-GC" }, { "name": "GP-GM", "code": "GP-GM" }, { "name": "GW", "code": "GW" }, { "name": "GW-GC", "code": "GW-GC" }, { "name": "GW-GM", "code": "GW-GM" }, { "name": "MH", "code": "MH" }, { "name": "ML", "code": "ML" }, { "name": "Not applicable", "code": "NA" }, { "name": "Non-standard", "code": "NS" }, { "name": "OH", "code": "OH" }, { "name": "OL", "code": "OL" }, { "name": "PT", "code": "PT" }, { "name": "SC", "code": "SC" }, { "name": "SC-SM", "code": "SC-SM" }, { "name": "SM", "code": "SM" }, { "name": "SP", "code": "SP" }, { "name": "SP-SC", "code": "SP-SC" }, { "name": "SP-SM", "code": "SP-SM" }, { "name": "SW", "code": "SW" }, { "name": "SW-SC", "code": "SW-SC" }, { "name": "SW-SM", "code": "SW-SM" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAT_LOG_UNIT", "type": "esriFieldTypeString", "alias": "Material log unit", "length": 50, "domain": null }, { "name": "DATE_CREATED", "type": "esriFieldTypeDate", "alias": "Date created", "length": 8, "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "Created by", "length": 10, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G30EXPLOR_ID", "fields": "EXPLOR_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G30SUBSURF_LAYER", "fields": "SUBSURF_LAYER_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "has interpretation", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "SUBSURF_LAYER_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{1F92B822-0FEE-40D4-A2DD-38AAB137E65E}" }, { "id": 1, "name": "is in exploration", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "EXPLOR_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7A9B7D98-066F-4A2D-B368-86974AFA398C}" }, { "id": 6, "name": "is in exploration", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "EXPLOR_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7A9B7D98-066F-4A2D-B368-86974AFA398C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }