{ "currentVersion": 10.91, "id": 3, "name": "KCsde.DBO.weeds_species_codes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "species_code", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "species_code", "type": "esriFieldTypeString", "alias": "species_code", "length": 3, "domain": { "type": "codedValue", "name": "nwSpeciesCodes", "description": "species codes for the weed_pnts layer for noxious weed", "codedValues": [ { "name": "Annual Bugloss", "code": "AB" }, { "name": "Alfalfa Dodder", "code": "AD" }, { "name": "Absinth Wormwood", "code": "AW" }, { "name": "Bighead Knapweed", "code": "BK" }, { "name": "Babysbreath", "code": "BB" }, { "name": "Buffalobur", "code": "BF" }, { "name": "Bull Thistle", "code": "BT" }, { "name": "Common Bugloss", "code": "CB" }, { "name": "Common Catsear", "code": "CC" }, { "name": "Common Groundsel", "code": "CG" }, { "name": "Canada Thistle", "code": "CT" }, { "name": "Diffuse Knapweed", "code": "DK" }, { "name": "Dalmatian Toadflax", "code": "DT" }, { "name": "Dyers Woad", "code": "DW" }, { "name": "Field Bindweed", "code": "FB" }, { "name": "Giant Knotweed", "code": "GK" }, { "name": "Houndstongue", "code": "HT" }, { "name": "Horseweed (Marestail)", "code": "HW" }, { "name": "Jointed Goatgrass", "code": "JG" }, { "name": "Japanese Knotweed", "code": "JK" }, { "name": "Kochia", "code": "KO" }, { "name": "Leafy Spurge", "code": "LS" }, { "name": "Meadow Knapweed", "code": "MK" }, { "name": "Myrtle Spurge", "code": "MS" }, { "name": "Musk Thistle", "code": "MT" }, { "name": "Orange Hawkweed", "code": "OH" }, { "name": "Poison Hemlock", "code": "PH" }, { "name": "Purple Loosestrife", "code": "PL" }, { "name": "Perennial Pepperweed", "code": "PP" }, { "name": "Puncturevine", "code": "PV" }, { "name": "Wild Carrot", "code": "QL" }, { "name": "Russian Knapweed", "code": "RK" }, { "name": "Russian Thistle", "code": "RT" }, { "name": "Scotch Broom", "code": "SB" }, { "name": "Spotted Knapweed", "code": "SK" }, { "name": "Scentless Mayweed", "code": "SM" }, { "name": "Scotch Thistle", "code": "ST" }, { "name": "St. Johnswort", "code": "SJ" }, { "name": "Tansy Ragwort", "code": "TR" }, { "name": "Velvetleaf", "code": "VL" }, { "name": "White Cockle", "code": "WC" }, { "name": "Whitetop", "code": "WT" }, { "name": "Yellow Starthistle", "code": "YS" }, { "name": "Yellow Toadflax", "code": "YT" }, { "name": "Spikeweed", "code": "SW" }, { "name": "Yellow Flag Iris", "code": "YF" }, { "name": "Herb Robert", "code": "HR" }, { "name": "Perennial Sowthistle", "code": "PS" }, { "name": "Rush Skeletonweed", "code": "RS" }, { "name": "Yellow Hawkweed", "code": "YH" }, { "name": "Oxeye Daisy", "code": "OD" }, { "name": "Hoary Alyssum", "code": "HA" }, { "name": "Common Mullein", "code": "CM" }, { "name": "Bogus Statement", "code": "BS" }, { "name": "Wild Four O\u2019Clock", "code": "WF" }, { "name": "Spiny Cocklebur", "code": "SP" }, { "name": "Longspine Sandbur", "code": "SD" }, { "name": "Common Hawkweed", "code": "CH" }, { "name": "Yellow Archangel", "code": "YA" }, { "name": "Ventenata", "code": "VE" }, { "name": "Medusahead", "code": "MH" }, { "name": "Sulfur Cinquefoil", "code": "SC" }, { "name": "Common Reed (Phragmites)", "code": "CR" }, { "name": "Cornflower (Bachelors Button)", "code": "CF" }, { "name": "Saltcedar (T. Ramosissima)", "code": "TX" }, { "name": "Common Tansy", "code": "TA" }, { "name": "Spanish Broom", "code": "SPB" } ], "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 }, { "name": "weedsID", "type": "esriFieldTypeGUID", "alias": "weedsID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_4395", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_4395", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_254785_weeds", "fields": "weedsID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "weed_caseLog_new", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "weedsID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true } }