{ "currentVersion": 10.61, "id": 1, "name": "lisleedit.GIS.WorkOrder_History_10_27_16", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SPECIES", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TREE_ID", "type": "esriFieldTypeInteger", "alias": "TREE_ID", "domain": null }, { "name": "SPECIES", "type": "esriFieldTypeString", "alias": "SPECIES", "length": 75, "domain": { "type": "codedValue", "name": "SPP_COMMON", "description": "SPP_COMMON", "codedValues": [ { "name": "AILANTHUS", "code": "AILANTHUS" }, { "name": "ALDER-SPP", "code": "ALDER-SPP" }, { "name": "AMERICAN HORNBEAM", "code": "AMERICAN HORNBEAM" }, { "name": "AMERICAN REDBUD", "code": "AMERICAN REDBUD" }, { "name": "AMUR CORKTREE", "code": "AMUR CORKTREE" }, { "name": "AMUR MAACKIA", "code": "AMUR MAACKIA" }, { "name": "APPLE-CRAB SPP", "code": "APPLE-CRAB SPP" }, { "name": "APPLE-EDIBLE", "code": "APPLE-EDIBLE" }, { "name": "APRICOT", "code": "APRICOT" }, { "name": "ARBOR VITAE", "code": "ARBOR VITAE" }, { "name": "ASH-BLACK", "code": "ASH-BLACK" }, { "name": "ASH-BLUE", "code": "ASH-BLUE" }, { "name": "ASH-EUROPEAN", "code": "ASH-EUROPEAN" }, { "name": "ASH-GREEN", "code": "ASH-GREEN" }, { "name": "ASH-WHITE", "code": "ASH-WHITE" }, { "name": "ASPEN", "code": "ASPEN" }, { "name": "BALDCYPRESS", "code": "BALDCYPRESS" }, { "name": "BARBERRY SPP", "code": "BARBERRY SPP" }, { "name": "BEECH-AMERICAN", "code": "BEECH-AMERICAN" }, { "name": "BEECH-SPP", "code": "BEECH-SPP" }, { "name": "BIRCH-RIVER", "code": "BIRCH-RIVER" }, { "name": "BIRCH-SPP", "code": "BIRCH-SPP" }, { "name": "BIRCH-WHITE", "code": "BIRCH-WHITE" }, { "name": "BLACK LOCUST", "code": "BLACK LOCUST" }, { "name": "BLACK TUPELO", "code": "BLACK TUPELO" }, { "name": "BLACKGUM", "code": "BLACKGUM" }, { "name": "BOXELDER", "code": "BOXELDER" }, { "name": "BUCKEYE-OHIO", "code": "BUCKEYE-OHIO" }, { "name": "BUCKEYE-RED", "code": "BUCKEYE-RED" }, { "name": "BUCKEYE-YELLOW", "code": "BUCKEYE-YELLOW" }, { "name": "BUCKTHORN", "code": "BUCKTHORN" }, { "name": "BURNING BUSH", "code": "BURNING BUSH" }, { "name": "CATALPA", "code": "CATALPA" }, { "name": "CATALPA-PURPLE", "code": "CATALPA-PURPLE" }, { "name": "CHERRY-BLACK", "code": "CHERRY-BLACK" }, { "name": "CHERRY-PURPLE LEAF", "code": "CHERRY-PURPLE LEAF" }, { "name": "CHERRY-SPP", "code": "CHERRY-SPP" }, { "name": "CHESTNUT-CHINESE", "code": "CHESTNUT-CHINESE" }, { "name": "CHOKECHERRY", "code": "CHOKECHERRY" }, { "name": "COTTONWOOD", "code": "COTTONWOOD" }, { "name": "DAWN REDWOOD", "code": "DAWN REDWOOD" }, { "name": "DOGWOOD-SPP", "code": "DOGWOOD-SPP" }, { "name": "DOUGLAS FIR", "code": "DOUGLAS FIR" }, { "name": "EASTERN REDCEDAR", "code": "EASTERN REDCEDAR" }, { "name": "ELDERBERRY", "code": "ELDERBERRY" }, { "name": "ELM-AMERICAN", "code": "ELM-AMERICAN" }, { "name": "ELM-CHINESE", "code": "ELM-CHINESE" }, { "name": "ELM-ENGLISH", "code": "ELM-ENGLISH" }, { "name": "ELM-HYBRID", "code": "ELM-HYBRID" }, { "name": "ELM-RED", "code": "ELM-RED" }, { "name": "ELM-SIBERIAN", "code": "ELM-SIBERIAN" }, { "name": "ELM-SPP", "code": "ELM-SPP" }, { "name": "EUROPEAN HORNBEAM", "code": "EUROPEAN HORNBEAM" }, { "name": "FIR-CONCOLOR", "code": "FIR-CONCOLOR" }, { "name": "FIR-SPP", "code": "FIR-SPP" }, { "name": "GINKGO", "code": "GINKGO" }, { "name": "GOLDEN RAINTREE", "code": "GOLDEN RAINTREE" }, { "name": "HACKBERRY", "code": "HACKBERRY" }, { "name": "HARDY RUBBERTREE", "code": "HARDY RUBBERTREE" }, { "name": "HAWTHORN-COCKSPUR", "code": "HAWTHORN-COCKSPUR" }, { "name": "HAWTHORN-SPP", "code": "HAWTHORN-SPP" }, { "name": "HAZELNUT-TREE", "code": "HAZELNUT-TREE" }, { "name": "HEMLOCK-EASTERN", "code": "HEMLOCK-EASTERN" }, { "name": "HICKORY-BITTERNUT", "code": "HICKORY-BITTERNUT" }, { "name": "HICKORY-SHAGBARK", "code": "HICKORY-SHAGBARK" }, { "name": "HONEYLOCUST", "code": "HONEYLOCUST" }, { "name": "HONEYSUCKLE", "code": "HONEYSUCKLE" }, { "name": "HORSECHESTNUT", "code": "HORSECHESTNUT" }, { "name": "IRONWOOD", "code": "IRONWOOD" }, { "name": "JUNIPER-COMMON", "code": "JUNIPER-COMMON" }, { "name": "KATSURA", "code": "KATSURA" }, { "name": "KENTUCKY COFFEETREE", "code": "KENTUCKY COFFEETREE" }, { "name": "LARCH", "code": "LARCH" }, { "name": "LILAC-SHRUB", "code": "LILAC-SHRUB" }, { "name": "LILAC-TREE", "code": "LILAC-TREE" }, { "name": "LINDEN-AMERICAN", "code": "LINDEN-AMERICAN" }, { "name": "LINDEN-LITTLELEAF", "code": "LINDEN-LITTLELEAF" }, { "name": "LINDEN-SPP", "code": "LINDEN-SPP" }, { "name": "LONDON PLANETREE", "code": "LONDON PLANETREE" }, { "name": "MAGNOLIA-SHRUB", "code": "MAGNOLIA-SHRUB" }, { "name": "MAGNOLIA-TREE", "code": "MAGNOLIA-TREE" }, { "name": "MAPLE-AMUR", "code": "MAPLE-AMUR" }, { "name": "MAPLE-AUTUMN BLAZE", "code": "MAPLE-AUTUMN BLAZE" }, { "name": "MAPLE-BLACK", "code": "MAPLE-BLACK" }, { "name": "MAPLE-CELEBRATION", "code": "MAPLE-CELEBRATION" }, { "name": "MAPLE-HEDGE", "code": "MAPLE-HEDGE" }, { "name": "MAPLE-JAPANESE", "code": "MAPLE-JAPANESE" }, { "name": "MAPLE-MARMO", "code": "MAPLE-MARMO" }, { "name": "MAPLE-MIYABEI", "code": "MAPLE-MIYABEI" }, { "name": "MAPLE-NORWAY", "code": "MAPLE-NORWAY" }, { "name": "MAPLE-PAPERBARK", "code": "MAPLE-PAPERBARK" }, { "name": "MAPLE-RED", "code": "MAPLE-RED" }, { "name": "MAPLE-RED SUNSET", "code": "MAPLE-RED SUNSET" }, { "name": "MAPLE-REDPOINTE", "code": "MAPLE-REDPOINTE" }, { "name": "MAPLE-SILVER", "code": "MAPLE-SILVER" }, { "name": "MAPLE-SPP", "code": "MAPLE-SPP" }, { "name": "MAPLE-STRIPED", "code": "MAPLE-STRIPED" }, { "name": "MAPLE-SUGAR", "code": "MAPLE-SUGAR" }, { "name": "MAPLE-TRIDENT", "code": "MAPLE-TRIDENT" }, { "name": "MAPLE-TRIFLORUM", "code": "MAPLE-TRIFLORUM" }, { "name": "MOUNTAIN ASH", "code": "MOUNTAIN ASH" }, { "name": "MULBERRY-SPP", "code": "MULBERRY-SPP" }, { "name": "OAK-BEBB", "code": "OAK-BEBB" }, { "name": "OAK-BLACK", "code": "OAK-BLACK" }, { "name": "OAK-BURR", "code": "OAK-BURR" }, { "name": "OAK-CHESTNUT", "code": "OAK-CHESTNUT" }, { "name": "OAK-CHINKAPIN", "code": "OAK-CHINKAPIN" }, { "name": "OAK-ENGLISH", "code": "OAK-ENGLISH" }, { "name": "OAK-PIN", "code": "OAK-PIN" }, { "name": "OAK-RED", "code": "OAK-RED" }, { "name": "OAK-REGAL PRINCE", "code": "OAK-REGAL PRINCE" }, { "name": "OAK-SHINGLE", "code": "OAK-SHINGLE" }, { "name": "OAK-SPP", "code": "OAK-SPP" }, { "name": "OAK-SWAMP WHITE", "code": "OAK-SWAMP WHITE" }, { "name": "OAK-WHITE", "code": "OAK-WHITE" }, { "name": "OAK-WILLOW", "code": "OAK-WILLOW" }, { "name": "OSAGE ORANGE", "code": "OSAGE ORANGE" }, { "name": "OTHER", "code": "OTHER" }, { "name": "PAGODA TREE", "code": "PAGODA TREE" }, { "name": "PALM-SPP", "code": "PALM-SPP" }, { "name": "PEACH", "code": "PEACH" }, { "name": "PEAR-CALLERY", "code": "PEAR-CALLERY" }, { "name": "PEAR-EDIBLE", "code": "PEAR-EDIBLE" }, { "name": "PINE-AUSTRIAN", "code": "PINE-AUSTRIAN" }, { "name": "PINE-LIMBER", "code": "PINE-LIMBER" }, { "name": "PINE-MUGO", "code": "PINE-MUGO" }, { "name": "PINE-RED", "code": "PINE-RED" }, { "name": "PINE-SCOTCH", "code": "PINE-SCOTCH" }, { "name": "PINE-WHITE", "code": "PINE-WHITE" }, { "name": "PLANTING SPACE", "code": "PLANTING SPACE" }, { "name": "PLUM-SPP", "code": "PLUM-SPP" }, { "name": "POPLAR-SPP", "code": "POPLAR-SPP" }, { "name": "POPLAR-WHITE", "code": "POPLAR-WHITE" }, { "name": "PRINCESS TREE", "code": "PRINCESS TREE" }, { "name": "PUSSYWILLOW", "code": "PUSSYWILLOW" }, { "name": "ROSE OF SHARON", "code": "ROSE OF SHARON" }, { "name": "RUSSIAN OLIVE", "code": "RUSSIAN OLIVE" }, { "name": "SERVICEBERRY-SPP", "code": "SERVICEBERRY-SPP" }, { "name": "SEVENTH SON FLOWER", "code": "SEVENTH SON FLOWER" }, { "name": "SMOKETREE", "code": "SMOKETREE" }, { "name": "SPRUCE-BLUE", "code": "SPRUCE-BLUE" }, { "name": "SPRUCE-NORWAY", "code": "SPRUCE-NORWAY" }, { "name": "SPRUCE-SPP", "code": "SPRUCE-SPP" }, { "name": "STUMP", "code": "STUMP" }, { "name": "SUGARBERRY", "code": "SUGARBERRY" }, { "name": "SUMAC", "code": "SUMAC" }, { "name": "SWEETGUM", "code": "SWEETGUM" }, { "name": "SYCAMORE", "code": "SYCAMORE" }, { "name": "TAMARISK", "code": "TAMARISK" }, { "name": "TULIPTREE", "code": "TULIPTREE" }, { "name": "TURKISH FILBERT", "code": "TURKISH FILBERT" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "VIBURNUM", "code": "VIBURNUM" }, { "name": "VIBURNUM-BLACKHAW", "code": "VIBURNUM-BLACKHAW" }, { "name": "WALNUT-BLACK", "code": "WALNUT-BLACK" }, { "name": "WILLOW-SPP", "code": "WILLOW-SPP" }, { "name": "YELLOWWOOD", "code": "YELLOWWOOD" }, { "name": "YEW", "code": "YEW" }, { "name": "ZELKOVA", "code": "ZELKOVA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DBH", "type": "esriFieldTypeInteger", "alias": "DBH", "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeInteger", "alias": "CONDITION", "domain": { "type": "codedValue", "name": "CONDITION_1", "description": "Condition of tree", "codedValues": [ { "name": "0", "code": 0 }, { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "INV_DATE", "type": "esriFieldTypeDate", "alias": "INV_DATE", "length": 8, "domain": null }, { "name": "PLANT_DATE", "type": "esriFieldTypeDate", "alias": "PLANT_DATE", "length": 8, "domain": null }, { "name": "REMOVE_DATE", "type": "esriFieldTypeDate", "alias": "REMOVE_DATE", "length": 8, "domain": null }, { "name": "WORK_ORDER", "type": "esriFieldTypeString", "alias": "WORK_ORDER", "length": 50, "domain": { "type": "codedValue", "name": "MAINT_REQ", "description": "Maintenance required", "codedValues": [ { "name": "INSPECT", "code": "INSPECT" }, { "name": "REMOVE", "code": "REMOVE" }, { "name": "PRUNE", "code": "PRUNE" }, { "name": "PLANT", "code": "PLANT" }, { "name": "RISK ASSESS", "code": "RISK ASSESS" }, { "name": "GRIND STUMP", "code": "GRIND STUMP" }, { "name": "APPLY MULCH", "code": "APPLY MULCH" }, { "name": "STAKE", "code": "STAKE" }, { "name": "REMOVE STAKE", "code": "REMOVE STAKE" }, { "name": "CHEM APPLICATION", "code": "CHEM APPLICATION" }, { "name": "BASIC UPDATE", "code": "BASIC UPDATE" }, { "name": "COMPLETE", "code": "COMPLETE" }, { "name": "UNCHANGED", "code": "UNCHANGED" }, { "name": "MONITOR", "code": "MONITOR" }, { "name": "REINVENTORY", "code": "REINVENTORY" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WORK_REASON", "type": "esriFieldTypeString", "alias": "WORK_REASON", "length": 50, "domain": { "type": "codedValue", "name": "MAINT_REASON", "description": "Reason for maintenance", "codedValues": [ { "name": "STUMP ON PARKWAY", "code": "STUMP ON PARKWAY" }, { "name": "RESIDENT REQUEST", "code": "RESIDENT REQUEST" }, { "name": "ADDISON REQUEST", "code": "ADDISON REQUEST" }, { "name": "STORM DAMAGE", "code": "STORM DAMAGE" }, { "name": "HIGH RISK LIMB", "code": "HIGH RISK LIMB" }, { "name": "OTHER", "code": "OTHER" }, { "name": "PEST/PATHOGEN", "code": "PEST/PATHOGEN" }, { "name": "EAB", "code": "EAB" }, { "name": "DED", "code": "DED" }, { "name": "HIGH RISK TREE", "code": "HIGH RISK TREE" }, { "name": "ROT/DECAY", "code": "ROT/DECAY" }, { "name": "SPRING PLANTING", "code": "SPRING PLANTING" }, { "name": "FALL PLANTING", "code": "FALL PLANTING" }, { "name": "OTHER PLANTING", "code": "OTHER PLANTING" }, { "name": "NO MULCH", "code": "NO MULCH" }, { "name": "LEANING/HEAVING", "code": "LEANING/HEAVING" }, { "name": "CYCLE PRUNE", "code": "CYCLE PRUNE" }, { "name": "BASIC UPDATE", "code": "BASIC UPDATE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 100, "domain": null }, { "name": "OPENED_BY", "type": "esriFieldTypeString", "alias": "OPENED_BY", "length": 50, "domain": { "type": "codedValue", "name": "OPENED BY", "description": "Who opened maintenance request", "codedValues": [ { "name": "STEVE LANE", "code": "STEVE LANE" }, { "name": "JEREMY LAKE", "code": "JEREMY LAKE" }, { "name": "CRYSTALYN DELACRUZ", "code": "CRYSTALYN DELACRUZ" }, { "name": "GRAF TREE CARE", "code": "GRAF TREE CARE" }, { "name": "OTHER PW", "code": "OTHER PW" }, { "name": "OTHER GIS", "code": "OTHER GIS" }, { "name": "OTHER VENDOR", "code": "OTHER VENDOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPENED_ON", "type": "esriFieldTypeDate", "alias": "OPENED_ON", "length": 8, "domain": null }, { "name": "CLOSED_BY", "type": "esriFieldTypeString", "alias": "CLOSED_BY", "length": 50, "domain": { "type": "codedValue", "name": "OPENED BY", "description": "Who opened maintenance request", "codedValues": [ { "name": "STEVE LANE", "code": "STEVE LANE" }, { "name": "JEREMY LAKE", "code": "JEREMY LAKE" }, { "name": "CRYSTALYN DELACRUZ", "code": "CRYSTALYN DELACRUZ" }, { "name": "GRAF TREE CARE", "code": "GRAF TREE CARE" }, { "name": "OTHER PW", "code": "OTHER PW" }, { "name": "OTHER GIS", "code": "OTHER GIS" }, { "name": "OTHER VENDOR", "code": "OTHER VENDOR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLOSED_ON", "type": "esriFieldTypeDate", "alias": "CLOSED_ON", "length": 8, "domain": null }, { "name": "CONTRACTOR", "type": "esriFieldTypeString", "alias": "CONTRACTOR", "length": 50, "domain": null }, { "name": "WORK_NOTES", "type": "esriFieldTypeString", "alias": "WORK_NOTES", "length": 100, "domain": null }, { "name": "FOLLOWUP", "type": "esriFieldTypeString", "alias": "FOLLOWUP", "length": 50, "domain": { "type": "codedValue", "name": "MAINT_REQ", "description": "Maintenance required", "codedValues": [ { "name": "INSPECT", "code": "INSPECT" }, { "name": "REMOVE", "code": "REMOVE" }, { "name": "PRUNE", "code": "PRUNE" }, { "name": "PLANT", "code": "PLANT" }, { "name": "RISK ASSESS", "code": "RISK ASSESS" }, { "name": "GRIND STUMP", "code": "GRIND STUMP" }, { "name": "APPLY MULCH", "code": "APPLY MULCH" }, { "name": "STAKE", "code": "STAKE" }, { "name": "REMOVE STAKE", "code": "REMOVE STAKE" }, { "name": "CHEM APPLICATION", "code": "CHEM APPLICATION" }, { "name": "BASIC UPDATE", "code": "BASIC UPDATE" }, { "name": "COMPLETE", "code": "COMPLETE" }, { "name": "UNCHANGED", "code": "UNCHANGED" }, { "name": "MONITOR", "code": "MONITOR" }, { "name": "REINVENTORY", "code": "REINVENTORY" }, { "name": "OTHER", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "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": "R914_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_914", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3261TREE_ID", "fields": "TREE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_914", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Lisle_Tree_Inventory_10_27_16", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "TREE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "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": null }