{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "HRSD.TSD_SampleDetailsStorm", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "TIDALSTAGE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SITEID", "type": "esriFieldTypeInteger", "alias": "SiteID", "domain": null }, { "name": "LAB_SAMP_ID", "type": "esriFieldTypeInteger", "alias": "Lab_Samp_ID", "domain": null }, { "name": "DATEOFCOLLECTION", "type": "esriFieldTypeDate", "alias": "DateOfCollection", "length": 8, "domain": null }, { "name": "AMMONIA", "type": "esriFieldTypeDouble", "alias": "Ammonia", "domain": null }, { "name": "TIDALSTAGE", "type": "esriFieldTypeString", "alias": "TidalStage", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_Tidal", "description": "Tidal Stage during sample collection", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Mid-Ebbing", "code": "Mid-Ebbing" }, { "name": "Mid-Flooding", "code": "Mid-Flooding" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RAINFALL_PRE_72HR", "type": "esriFieldTypeDouble", "alias": "Rainfall_pre_72hr", "domain": null }, { "name": "RAINFALL_PRE_24HR", "type": "esriFieldTypeDouble", "alias": "Rainfall_pre_24hr", "domain": null }, { "name": "WEATHERCONDITION", "type": "esriFieldTypeString", "alias": "WeatherCondition", "length": 10, "domain": { "type": "codedValue", "name": "TSD_Sample_Weather", "description": "Weather during sample collection", "codedValues": [ { "name": "Dry", "code": "Dry" }, { "name": "Wet", "code": "Wet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SALINITY", "type": "esriFieldTypeDouble", "alias": "Salinity", "domain": null }, { "name": "TURBIDITY", "type": "esriFieldTypeDouble", "alias": "Turbidity", "domain": null }, { "name": "AIR_TEMP", "type": "esriFieldTypeInteger", "alias": "Air_Temp", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "DEPOSIT_STAINS", "type": "esriFieldTypeString", "alias": "Deposit_Stains", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_Deposit", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Sediments", "code": "Sediments" }, { "name": "Oily", "code": "Oily" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VEGET_CONDITION", "type": "esriFieldTypeString", "alias": "Veget_Condition", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_VegCondition", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Normal", "code": "Normal" }, { "name": "Excessive Growth", "code": "Excessive Growth" }, { "name": "Inhibited Growth", "code": "Inhibited Growth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCT_CONDITION", "type": "esriFieldTypeString", "alias": "Struct_Condition", "length": 50, "domain": { "type": "codedValue", "name": "TSD_Sample_StructCondition", "description": "", "codedValues": [ { "name": "Normal", "code": "Normal" }, { "name": "Concrete Cracking-Spauling", "code": "Concrete Cracking-Spauling" }, { "name": "Metal Corrosion", "code": "Metal Corrosion" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BIOLOGICAL", "type": "esriFieldTypeString", "alias": "Biological", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_Biological", "description": "", "codedValues": [ { "name": "Mosquito Larvae", "code": "Mosquito Larvae" }, { "name": "Bacteria-Algae", "code": "Bacteria-Algae" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOW", "type": "esriFieldTypeString", "alias": "Flow", "length": 3, "domain": { "type": "codedValue", "name": "Yes_Or_No", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WATERWIDTH", "type": "esriFieldTypeDouble", "alias": "WaterWidth", "domain": null }, { "name": "WATERDEPTH", "type": "esriFieldTypeDouble", "alias": "WaterDepth", "domain": null }, { "name": "FLOWVELOCITY", "type": "esriFieldTypeDouble", "alias": "FlowVelocity", "domain": null }, { "name": "FLOWRATE", "type": "esriFieldTypeDouble", "alias": "FlowRate", "domain": null }, { "name": "ODOR", "type": "esriFieldTypeString", "alias": "Odor", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_Odor", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Musty", "code": "Musty" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Rotten Eggs", "code": "Rotten Eggs" }, { "name": "Other", "code": "Other" }, { "name": "Sour Milk", "code": "Sour Milk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "Color", "length": 20, "domain": { "type": "codedValue", "name": "TSD_Sample_Color", "description": "", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Red", "code": "Red" }, { "name": "Yellow", "code": "Yellow" }, { "name": "Brown", "code": "Brown" }, { "name": "Green", "code": "Green" }, { "name": "Grey", "code": "Grey" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLARITY", "type": "esriFieldTypeString", "alias": "Clarity", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_Clarity", "description": "", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Cloudy", "code": "Cloudy" }, { "name": "Opaque", "code": "Opaque" }, { "name": "Suspended Solids", "code": "Suspended Solids" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FLOATABLES", "type": "esriFieldTypeString", "alias": "Floatables", "length": 25, "domain": { "type": "codedValue", "name": "TSD_Sample_Float", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Oily Sheen", "code": "Oily Sheen" }, { "name": "Garbage-Sewage", "code": "Garbage-Sewage" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "length": 255, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "length": 255, "domain": null }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "length": 8, "domain": null } ], "indexes": [ { "name": "GDB_2588_SITEID", "fields": "SITEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R4236_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "TSD_SampleSiteStorm", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SITEID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D3CAB7F9-D11D-4700-8FE1-1AAA647B2CE6}" } ], "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": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }