{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "Region45_SampleTable", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Depth", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PointID", "type": "esriFieldTypeString", "alias": "PointID", "length": 255, "domain": null }, { "name": "Depth", "type": "esriFieldTypeString", "alias": "Depth", "length": 8, "domain": null }, { "name": "Bottom", "type": "esriFieldTypeString", "alias": "Bottom", "length": 8, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": null }, { "name": "Number", "type": "esriFieldTypeString", "alias": "Number", "length": 8, "domain": null }, { "name": "Recovery", "type": "esriFieldTypeString", "alias": "Recovery", "length": 255, "domain": null }, { "name": "Driving_Resist", "type": "esriFieldTypeString", "alias": "Driving_Resist", "length": 255, "domain": null }, { "name": "N_Value", "type": "esriFieldTypeString", "alias": "N Value", "length": 255, "domain": null }, { "name": "Discontinuities", "type": "esriFieldTypeString", "alias": "Discontinuities", "length": 255, "domain": null }, { "name": "Percent_Moist", "type": "esriFieldTypeString", "alias": "Percent_Moist", "length": 255, "domain": null }, { "name": "RQD", "type": "esriFieldTypeString", "alias": "RQD", "length": 255, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 755, "domain": null }, { "name": "Soil_Name", "type": "esriFieldTypeString", "alias": "Soil_Name", "length": 255, "domain": null }, { "name": "USCS", "type": "esriFieldTypeString", "alias": "USCS", "length": 255, "domain": null }, { "name": "Soil_Color", "type": "esriFieldTypeString", "alias": "Soil_Color", "length": 255, "domain": null }, { "name": "Plasticity", "type": "esriFieldTypeString", "alias": "Plasticity", "length": 255, "domain": null }, { "name": "Moisture", "type": "esriFieldTypeString", "alias": "Moisture", "length": 255, "domain": null }, { "name": "Consistency", "type": "esriFieldTypeString", "alias": "Consistency", "length": 255, "domain": null }, { "name": "Soil_Texture", "type": "esriFieldTypeString", "alias": "Soil_Texture", "length": 255, "domain": null }, { "name": "Soil_Structure", "type": "esriFieldTypeString", "alias": "Soil_Structure", "length": 255, "domain": null }, { "name": "Soil_Other", "type": "esriFieldTypeString", "alias": "Soil_Other", "length": 255, "domain": null }, { "name": "Soil_Origin", "type": "esriFieldTypeString", "alias": "Soil_Origin", "length": 255, "domain": null }, { "name": "Rock_Name", "type": "esriFieldTypeString", "alias": "Rock_Name", "length": 255, "domain": null }, { "name": "Rock_Color", "type": "esriFieldTypeString", "alias": "Rock_Color", "length": 255, "domain": null }, { "name": "Weathering", "type": "esriFieldTypeString", "alias": "Weathering", "length": 255, "domain": null }, { "name": "Hardness", "type": "esriFieldTypeString", "alias": "Hardness", "length": 255, "domain": null }, { "name": "Rock_Structure", "type": "esriFieldTypeString", "alias": "Rock_Structure", "length": 255, "domain": null }, { "name": "Rock_Other", "type": "esriFieldTypeString", "alias": "Rock_Other", "length": 255, "domain": null }, { "name": "Formation", "type": "esriFieldTypeString", "alias": "Formation", "length": 255, "domain": null }, { "name": "NE", "type": "esriFieldTypeString", "alias": "NE", "length": 255, "domain": null }, { "name": "Recovery_Length", "type": "esriFieldTypeString", "alias": "Recovery Length", "length": 255, "domain": null }, { "name": "Driving_Resistance", "type": "esriFieldTypeString", "alias": "Driving Resistance", "length": 255, "domain": null }, { "name": "RQD_Length", "type": "esriFieldTypeString", "alias": "RQD Length", "length": 255, "domain": null }, { "name": "Blows_1st", "type": "esriFieldTypeDouble", "alias": "Blows 1st", "domain": null }, { "name": "Blows_2nd", "type": "esriFieldTypeDouble", "alias": "Blows 2nd", "domain": null }, { "name": "Blows_3rd", "type": "esriFieldTypeDouble", "alias": "Blows 3rd", "domain": null }, { "name": "Recovery_1", "type": "esriFieldTypeString", "alias": "Recovery", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4PointID", "fields": "PointID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Region45_attach", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PointID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3E5CBF5C-565C-476B-9F2A-1E13A489A923}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }