{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "PN_Asset_Maint_Record", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Asset_Name", "typeIdField": "TASK_TYPE_ID", "subtypeFieldName": "TASK_TYPE_ID", "subtypeField": "TASK_TYPE_ID", "defaultSubtypeCode": 20001, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeInteger", "alias": "AssetID", "domain": null }, { "name": "ASSET_TYPE", "type": "esriFieldTypeInteger", "alias": "Asset Type", "domain": { "type": "codedValue", "name": "Parks_Asset_Type_ID", "description": "Parks_Asset_Type_ID", "codedValues": [ { "name": "Art Installation", "code": 10001 }, { "name": "Baseball Back Stop", "code": 10002 }, { "name": "Bench", "code": 10003 }, { "name": "Boundary Fence", "code": 10004 }, { "name": "Culvert", "code": 10005 }, { "name": "Drainage Bulkhead", "code": 10006 }, { "name": "Entrance Gate", "code": 10007 }, { "name": "Entrance Road", "code": 10008 }, { "name": "Exercise Equipment", "code": 10009 }, { "name": "Fenced Trash Receptacle", "code": 10010 }, { "name": "Free-Standing Learning Unit", "code": 10011 }, { "name": "Infant/Toddler Swing Unit", "code": 10012 }, { "name": "Masonry Fence", "code": 10013 }, { "name": "Metal Grill", "code": 10014 }, { "name": "Park Sign", "code": 10015 }, { "name": "Pavilion", "code": 10016 }, { "name": "Permanent Grill", "code": 10017 }, { "name": "Permanent Restroom", "code": 10018 }, { "name": "Picnic Table", "code": 10019 }, { "name": "Play Mat", "code": 10020 }, { "name": "Slide / Climbing Unit", "code": 10021 }, { "name": "Swing Unit", "code": 10022 }, { "name": "Temporary Restroom", "code": 10023 }, { "name": "Trash Can", "code": 10024 }, { "name": "Vehicle Restriction Post", "code": 10025 }, { "name": "Walking Path", "code": 10026 }, { "name": "Water Fountain", "code": 10027 }, { "name": "Greenhouse Bed", "code": 10028 }, { "name": "Tennis Court", "code": 10029 }, { "name": "Basketball Court", "code": 10030 }, { "name": "Undeveloped Park", "code": 10031 }, { "name": "Bridge", "code": 10032 }, { "name": "Chain Link Fence", "code": 10033 }, { "name": "Animal Waste Station", "code": 10034 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Asset_Name", "type": "esriFieldTypeString", "alias": "Asset Name", "length": 50, "domain": null }, { "name": "COMPOUND_NAME", "type": "esriFieldTypeString", "alias": "Compound", "length": 50, "domain": { "type": "codedValue", "name": "Parks_Compounds", "description": "Parks_Compounds", "codedValues": [ { "name": "Armory", "code": "Armory" }, { "name": "Center City Armory", "code": "Center City Armory" }, { "name": "Frayser", "code": "Frayser" }, { "name": "Greenhouse", "code": "Greenhouse" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Mississippi Shelter", "code": "Mississippi Shelter" }, { "name": "MLK Riverside", "code": "MLK Riverside" }, { "name": "Willow Road", "code": "Willow Road" }, { "name": "Tree Crew", "code": "Tree Crew" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Park_ID", "type": "esriFieldTypeInteger", "alias": "ParkID", "domain": null }, { "name": "PARK_NAMEFULL", "type": "esriFieldTypeString", "alias": "Full Park Name", "length": 50, "domain": { "type": "codedValue", "name": "Parks_Area_Names", "description": "Parks_Area_Names", "codedValues": [ { "name": "Alcy-Samuels Park", "code": "Alcy-Samuels Park" }, { "name": "Alcy-Warren Park", "code": "Alcy-Warren Park" }, { "name": "Alonzo Weaver Park (W. Junction)", "code": "Alonzo Weaver Park (W. Junction)" }, { "name": "American Way Park", "code": "American Way Park" }, { "name": "Archery Range at Crockett", "code": "Archery Range at Crockett" }, { "name": "Armory Home Office", "code": "Armory Home Office" }, { "name": "Army Bed 1", "code": "Army Bed 1" }, { "name": "Army Bed 2", "code": "Army Bed 2" }, { "name": "Army Park", "code": "Army Park" }, { "name": "Audubon Park", "code": "Audubon Park" }, { "name": "Avon Park", "code": "Avon Park" }, { "name": "Belvedere Park", "code": "Belvedere Park" }, { "name": "Belz Park", "code": "Belz Park" }, { "name": "Bert Ferguson Community Center", "code": "Bert Ferguson Community Center" }, { "name": "Bert Ferguson Park", "code": "Bert Ferguson Park" }, { "name": "Bethel LaBelle Community Center", "code": "Bethel LaBelle Community Center" }, { "name": "Bickford Community Center", "code": "Bickford Community Center" }, { "name": "Bickford Park", "code": "Bickford Park" }, { "name": "Binghampton Park", "code": "Binghampton Park" }, { "name": "Bison Park", "code": "Bison Park" }, { "name": "Booth Park", "code": "Booth Park" }, { "name": "Boxtown Park", "code": "Boxtown Park" }, { "name": "Brentwood", "code": "Brentwood" }, { "name": "Brinkley Park (Market Square)", "code": "Brinkley Park (Market Square)" }, { "name": "C. P. J. Mooney Park", "code": "C. P. J. Mooney Park" }, { "name": "Cancer Survivor Park", "code": "Cancer Survivor Park" }, { "name": "Carver Heights Park", "code": "Carver Heights Park" }, { "name": "Chandler Park", "code": "Chandler Park" }, { "name": "Charjean Park", "code": "Charjean Park" }, { "name": "Charles Powell - Westwood Community Center", "code": "Charles Powell - Westwood Community Center" }, { "name": "Cherokee Park", "code": "Cherokee Park" }, { "name": "Chickasaw Gardens Park", "code": "Chickasaw Gardens Park" }, { "name": "Child Advocacy Center", "code": "Child Advocacy Center" }, { "name": "City Beautiful", "code": "City Beautiful" }, { "name": "City Hall Crape Myrtle", "code": "City Hall Crape Myrtle" }, { "name": "City Hall Daylilly", "code": "City Hall Daylilly" }, { "name": "City Hall Front Grass Beds", "code": "City Hall Front Grass Beds" }, { "name": "City Hall Front Liriope", "code": "City Hall Front Liriope" }, { "name": "City Hall Ginko Tree Beds", "code": "City Hall Ginko Tree Beds" }, { "name": "City Hall Rear Liriope", "code": "City Hall Rear Liriope" }, { "name": "City Hall Rear Raised Beds", "code": "City Hall Rear Raised Beds" }, { "name": "City Hall Rock Wall Bed", "code": "City Hall Rock Wall Bed" }, { "name": "City Hall Rose Beds", "code": "City Hall Rose Beds" }, { "name": "Colonial Park (Auction Square)", "code": "Colonial Park (Auction Square)" }, { "name": "Columbus Park", "code": "Columbus Park" }, { "name": "Cooper", "code": "Cooper" }, { "name": "Crenshaw Park", "code": "Crenshaw Park" }, { "name": "Cunningham Community Center", "code": "Cunningham Community Center" }, { "name": "Daffodil Bed", "code": "Daffodil Bed" }, { "name": "Dalstrom Park", "code": "Dalstrom Park" }, { "name": "Dave Wells Community Center", "code": "Dave Wells Community Center" }, { "name": "David Carnes Park", "code": "David Carnes Park" }, { "name": "David Wells Park", "code": "David Wells Park" }, { "name": "Davis Community Center", "code": "Davis Community Center" }, { "name": "Davis Park", "code": "Davis Park" }, { "name": "Denver Park", "code": "Denver Park" }, { "name": "Dlugach Park", "code": "Dlugach Park" }, { "name": "Dog Park at Avery", "code": "Dog Park at Avery" }, { "name": "Douglass Community Center", "code": "Douglass Community Center" }, { "name": "Douglass Park", "code": "Douglass Park" }, { "name": "East High Sportsplex", "code": "East High Sportsplex" }, { "name": "East Zone Office", "code": "East Zone Office" }, { "name": "Easthaven Park", "code": "Easthaven Park" }, { "name": "Ed Rice Community Center", "code": "Ed Rice Community Center" }, { "name": "Egypt Central Park", "code": "Egypt Central Park" }, { "name": "Emerald Park", "code": "Emerald Park" }, { "name": "Fairley Park", "code": "Fairley Park" }, { "name": "Fairway Park", "code": "Fairway Park" }, { "name": "Firestone Park", "code": "Firestone Park" }, { "name": "Fletcher Creek Park", "code": "Fletcher Creek Park" }, { "name": "Flowering Peach Park", "code": "Flowering Peach Park" }, { "name": "Ford Park", "code": "Ford Park" }, { "name": "Frayser Park", "code": "Frayser Park" }, { "name": "Frayser School", "code": "Frayser School" }, { "name": "Frayser Shelter Office", "code": "Frayser Shelter Office" }, { "name": "Front Street Containers", "code": "Front Street Containers" }, { "name": "Fulmer Park", "code": "Fulmer Park" }, { "name": "Gaisman Community Center", "code": "Gaisman Community Center" }, { "name": "Gaisman Park", "code": "Gaisman Park" }, { "name": "Galloway & Rose - East", "code": "Galloway & Rose - East" }, { "name": "Galloway & Rose - North", "code": "Galloway & Rose - North" }, { "name": "Galloway Golf", "code": "Galloway Golf" }, { "name": "Gardenview Park", "code": "Gardenview Park" }, { "name": "Gaston Community Center", "code": "Gaston Community Center" }, { "name": "Gaston Park", "code": "Gaston Park" }, { "name": "George Alberson Park", "code": "George Alberson Park" }, { "name": "Georgian Hills Park", "code": "Georgian Hills Park" }, { "name": "Germanshire Park", "code": "Germanshire Park" }, { "name": "Glenview Community Center", "code": "Glenview Community Center" }, { "name": "Glenview Park", "code": "Glenview Park" }, { "name": "Godwin Park", "code": "Godwin Park" }, { "name": "Gooch Park", "code": "Gooch Park" }, { "name": "Gragg Park", "code": "Gragg Park" }, { "name": "Grandview Park", "code": "Grandview Park" }, { "name": "Greenhouse Parkway Office", "code": "Greenhouse Parkway Office" }, { "name": "Greenlaw Park", "code": "Greenlaw Park" }, { "name": "Greenway Harbortown", "code": "Greenway Harbortown" }, { "name": "Halle Park", "code": "Halle Park" }, { "name": "Heroes Park", "code": "Heroes Park" }, { "name": "Hickory Hill Center Center", "code": "Hickory Hill Community Center" }, { "name": "Hickory Hill Park", "code": "Hickory Hill Park" }, { "name": "Highland Park", "code": "Highland Park" }, { "name": "Hollywood Community Center", "code": "Hollywood Community Center" }, { "name": "Hollywood Park", "code": "Hollywood Park" }, { "name": "Humphreys Greenway", "code": "Humphreys Greenway" }, { "name": "J. J. Brennan Park", "code": "J. J. Brennan Park" }, { "name": "J. T. Willingham Park", "code": "J. T. Willingham Park" }, { "name": "Jackson Park", "code": "Jackson Park" }, { "name": "Jesse Turner Park", "code": "Jesse Turner Park" }, { "name": "John C. Shivler Park", "code": "John C. Shivler Park" }, { "name": "John F. Kennedy Park", "code": "John F. Kennedy Park" }, { "name": "Judge Andrew Holmes Park", "code": "Judge Andrew Holmes Park" }, { "name": "Kate Sexton Community Center", "code": "Kate Sexton Community Center" }, { "name": "Kennedy Maintenance Shelter", "code": "Kennedy Maintenance Shelter" }, { "name": "Klondike Park", "code": "Klondike Park" }, { "name": "L. E. Brown Park", "code": "L. E. Brown Park" }, { "name": "LaBelle Park", "code": "LaBelle Park" }, { "name": "Lamar", "code": "Lamar" }, { "name": "Lanier Park", "code": "Lanier Park" }, { "name": "Lazarov Park", "code": "Lazarov Park" }, { "name": "Leftwich Tennis", "code": "Leftwich Tennis" }, { "name": "Lester Community Center", "code": "Lester Community Center" }, { "name": "Levitt Shell", "code": "Levitt Shell" }, { "name": "Lewis-Davis Park", "code": "Lewis-Davis Park" }, { "name": "Lewis Senior Center", "code": "Lewis Senior Center" }, { "name": "Lincoln Park", "code": "Lincoln Park" }, { "name": "Lincoln School Park", "code": "Lincoln School Park" }, { "name": "Linden Park", "code": "Linden Park" }, { "name": "Litty Park", "code": "Litty Park" }, { "name": "Lucille Price Park", "code": "Lucille Price Park" }, { "name": "M. L. King Park (Riverside)", "code": "M. L. King Park (Riverside)" }, { "name": "Madison & Monroe Park", "code": "Madison & Monroe Park" }, { "name": "Magevney House", "code": "Magevney House" }, { "name": "Magevny Park", "code": "Magevny Park" }, { "name": "Magnolia Community Center", "code": "Magnolia Community Center" }, { "name": "Mallory-Neely House", "code": "Mallory-Neely House" }, { "name": "Mallory Park", "code": "Mallory Park" }, { "name": "Marion Hale Community Center", "code": "Marion Hale Community Center" }, { "name": "Martha Byrnes Park", "code": "Martha Byrnes Park" }, { "name": "Mary Elizabeth Malone Park", "code": "Mary Elizabeth Malone Park" }, { "name": "May Park", "code": "May Park" }, { "name": "McFarland Community Center", "code": "McFarland Community Center" }, { "name": "McFarland Park", "code": "McFarland Park" }, { "name": "McNeil Park", "code": "McNeil Park" }, { "name": "McWherter Park", "code": "McWherter Park" }, { "name": "Medal of Honor Park", "code": "Medal of Honor Park" }, { "name": "Memphis City Beautiful 1", "code": "Memphis City Beautiful 1" }, { "name": "Memphis City Beautiful 2", "code": "Memphis City Beautiful 2" }, { "name": "Memphis City Beautiful 3", "code": "Memphis City Beautiful 3" }, { "name": "Minnie Wagner Park", "code": "Minnie Wagner Park" }, { "name": "Mississippi River Greenbelt Park", "code": "Mississippi River Greenbelt Park" }, { "name": "Mississippi Shelter Office", "code": "Mississippi Shelter Office" }, { "name": "Mitchell Community Center", "code": "Mitchell Community Center" }, { "name": "Morris Park", "code": "Morris Park" }, { "name": "Nash Buckingham Park", "code": "Nash Buckingham Park" }, { "name": "Navy Bed 1", "code": "Navy Bed 1" }, { "name": "Navy Bed 2", "code": "Navy Bed 2" }, { "name": "Navy Park", "code": "Navy Park" }, { "name": "Neely Park", "code": "Neely Park" }, { "name": "New Chicago Park", "code": "New Chicago Park" }, { "name": "North Frayser Community Center", "code": "North Frayser Community Center" }, { "name": "O. L. Cash Park", "code": "O. L. Cash Park" }, { "name": "Oakhaven Park", "code": "Oakhaven Park" }, { "name": "Orange Mound Community Center", "code": "Orange Mound Community Center" }, { "name": "Orange Mound Park", "code": "Orange Mound Park" }, { "name": "Orange Mound Service Center", "code": "Orange Mound Service Center" }, { "name": "Parkway", "code": "Parkway" }, { "name": "Patton Park", "code": "Patton Park" }, { "name": "Pauline \"Pep\" Marquette Park", "code": "Pauline \"Pep\" Marquette Park" }, { "name": "Peabody Park", "code": "Peabody Park" }, { "name": "Pershing Park", "code": "Pershing Park" }, { "name": "Pickett Park", "code": "Pickett Park" }, { "name": "Pierotti Park", "code": "Pierotti Park" }, { "name": "Pine Hill Community Center", "code": "Pine Hill Community Center" }, { "name": "Pine Hill Park", "code": "Pine Hill Park" }, { "name": "Pink Palace", "code": "Pink Palace" }, { "name": "Pink Palace Bed 1", "code": "Pink Palace Bed 1" }, { "name": "Pink Palace Bed 2", "code": "Pink Palace Bed 2" }, { "name": "Pink Palace Circle Bed", "code": "Pink Palace Circle Bed" }, { "name": "Pink Palace Entrance Bed", "code": "Pink Palace Entrance Bed" }, { "name": "Polly Williams Park", "code": "Polly Williams Park" }, { "name": "Poplar at Highland Park", "code": "Poplar at Highland Park" }, { "name": "Raines Road Park", "code": "Raines Road Park" }, { "name": "Raleigh Bartlett Meadows Park", "code": "Raleigh Bartlett Meadows Park" }, { "name": "Raleigh Community Center", "code": "Raleigh Community Center" }, { "name": "Redbud", "code": "Redbud" }, { "name": "Redding Park", "code": "Redding Park" }, { "name": "Riverview Community Center", "code": "Riverview Community Center" }, { "name": "Riverview Park", "code": "Riverview Park" }, { "name": "Robert Church Park", "code": "Robert Church Park" }, { "name": "Robert Howze Park", "code": "Robert Howze Park" }, { "name": "Robert O'Brien Park", "code": "Robert O'Brien Park" }, { "name": "Rodney Baber Park", "code": "Rodney Baber Park" }, { "name": "Rozelle (Annesdale) Park", "code": "Rozelle (Annesdale) Park" }, { "name": "Sea Isle Park", "code": "Sea Isle Park" }, { "name": "Skate Park & Avery", "code": "Skate Park & Avery" }, { "name": "South Memphis Senior Center", "code": "South Memphis Senior Center" }, { "name": "Southside Park", "code": "Southside Park" }, { "name": "Spanish War Memorial Park", "code": "Spanish War Memorial Park" }, { "name": "Texas Courts Park", "code": "Texas Courts Park" }, { "name": "The Big M", "code": "The Big M" }, { "name": "Tobey Park", "code": "Tobey Park" }, { "name": "Tom Lee Pool", "code": "Tom Lee Pool" }, { "name": "Tower Park", "code": "Tower Park" }, { "name": "Trigg West Park", "code": "Trigg West Park" }, { "name": "University Park", "code": "University Park" }, { "name": "Victorian Village Park", "code": "Victorian Village Park" }, { "name": "Walker Hall Park", "code": "Walker Hall Park" }, { "name": "Walter Chandler Park", "code": "Walter Chandler Park" }, { "name": "Washington Park", "code": "Washington Park" }, { "name": "Watkins & O'Berle Park", "code": "Watkins & O'Berle Park" }, { "name": "Western Cove Park", "code": "Westen Cove Park" }, { "name": "Western Park", "code": "Western Park" }, { "name": "Western Weaver Park", "code": "Western Weaver Park" }, { "name": "Weston & Ford Park", "code": "Weston & Ford Park" }, { "name": "Westside Park", "code": "Westside Park" }, { "name": "Westwood Park", "code": "Westwood Park" }, { "name": "Whitehaven Community Center", "code": "Whitehaven Community Center" }, { "name": "Whitehaven Park", "code": "Whitehaven Park" }, { "name": "Will Carruthers Park", "code": "Will Carruthers Park" }, { "name": "Williamson Park", "code": "Williamson Park" }, { "name": "Willow Park", "code": "Willow Park" }, { "name": "Willow Road Home Office", "code": "Willow Road Home Office" }, { "name": "Wilson Park", "code": "Wilson Park" }, { "name": "Winchester Park", "code": "Winchester Park" }, { "name": "Winridge Park", "code": "Winridge Park" }, { "name": "Wolbrecht Tennis", "code": "Wolbrecht Tennis" }, { "name": "Wooddale Tennis", "code": "Wooddale Tennis" }, { "name": "Zodiac Park", "code": "Zodiac Park" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PARCELID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 240, "domain": null }, { "name": "TASK_ID", "type": "esriFieldTypeInteger", "alias": "Task Unique ID", "domain": null }, { "name": "TASK_TYPE_ID", "type": "esriFieldTypeInteger", "alias": "Task Type ID", "domain": null }, { "name": "TASK_TYPE", "type": "esriFieldTypeString", "alias": "Maintenance Task", "length": 75, "domain": null }, { "name": "TASK_STATUS", "type": "esriFieldTypeString", "alias": "Task Status", "length": 50, "domain": { "type": "codedValue", "name": "Tasks_AssignStatus", "description": "Tasks_AssignStatus", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Unassigned", "code": "Unassigned" }, { "name": "Assigned", "code": "Assigned" }, { "name": "Accepted", "code": "Accepted" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Declined", "code": "Declined" }, { "name": "Completed", "code": "Completed" }, { "name": "Ready for Review", "code": "Ready for Review" }, { "name": "Invoice \u2013 sent to City", "code": "Invoiced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TASK_PRIORITY", "type": "esriFieldTypeString", "alias": "Task Priority", "length": 25, "domain": { "type": "codedValue", "name": "REQUEST_PRIORITY", "description": "REQUEST_PRIORITY", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium", "code": "Medium" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CREATION_DATE", "type": "esriFieldTypeDate", "alias": "Creation Date", "length": 8, "domain": null }, { "name": "TASK_SUBJECT", "type": "esriFieldTypeString", "alias": "Maintenance Subject", "length": 250, "domain": null }, { "name": "TASK_ASSIGNEE", "type": "esriFieldTypeString", "alias": "Task Assignee", "length": 255, "domain": { "type": "codedValue", "name": "Parks_Users", "description": "Parks_Users", "codedValues": [ { "name": "Anthony Howard", "code": "Anthony Howard" }, { "name": "Connie Shepherd", "code": "Connie Shepherd" }, { "name": "Gettone Smith", "code": "Gettone Smith" }, { "name": "Jeffery Dennis", "code": "Jeffery Dennis" }, { "name": "Jeremy Wright", "code": "Jeremy Wright" }, { "name": "Jonathon Carson", "code": "Jonathon Carson" }, { "name": "Maurice Goode", "code": "Maurice Goode" }, { "name": "Mickey Barker", "code": "Mickey Barker" }, { "name": "Phillip Geater", "code": "Phillip Geater" }, { "name": "Robert Buggs", "code": "Robert Buggs" }, { "name": "Ty Hairr", "code": "Ty Hairr" }, { "name": "Tyrone Wright", "code": "Tyrone Wright" }, { "name": "Willie Taylor", "code": "Willie Taylor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TASK_NOTES", "type": "esriFieldTypeString", "alias": "Maintenance Notes", "length": 250, "domain": null }, { "name": "Park_Assets_Rating", "type": "esriFieldTypeInteger", "alias": "Park Assets Rating", "domain": { "type": "codedValue", "name": "Park_Assets_Rating", "description": "Park Assets Rating", "codedValues": [ { "name": "1 - Cannot be repaired, must be replaced", "code": 1 }, { "name": "2 - Poor condition, needs renovation", "code": 2 }, { "name": "3 - Adequate, but needs a little work", "code": 3 }, { "name": "4 - Good condition", "code": 4 }, { "name": "6 - Not applicable", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SCHEDULED_START_DATE", "type": "esriFieldTypeDate", "alias": "Scheduled Start Date", "length": 8, "domain": null }, { "name": "SCHEDULED_END_DATE", "type": "esriFieldTypeDate", "alias": "Scheduled End Date", "length": 8, "domain": null }, { "name": "ACTUAL_START_DATE", "type": "esriFieldTypeDate", "alias": "Actual Start Date", "length": 8, "domain": null }, { "name": "ACTUAL_END_DATE", "type": "esriFieldTypeDate", "alias": "Actual End Date", "length": 8, "domain": null }, { "name": "ACTUAL_EFFORT", "type": "esriFieldTypeDouble", "alias": "Actual Effort", "domain": null }, { "name": "FOLLOWUP_DATE", "type": "esriFieldTypeDate", "alias": "Follow Up Date", "length": 8, "domain": null }, { "name": "ASSET_GUID", "type": "esriFieldTypeGUID", "alias": "ASSET_GUID", "length": 38, "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "Created By", "length": 255, "domain": { "type": "codedValue", "name": "Parks_Users", "description": "Parks_Users", "codedValues": [ { "name": "Anthony Howard", "code": "Anthony Howard" }, { "name": "Connie Shepherd", "code": "Connie Shepherd" }, { "name": "Gettone Smith", "code": "Gettone Smith" }, { "name": "Jeffery Dennis", "code": "Jeffery Dennis" }, { "name": "Jeremy Wright", "code": "Jeremy Wright" }, { "name": "Jonathon Carson", "code": "Jonathon Carson" }, { "name": "Maurice Goode", "code": "Maurice Goode" }, { "name": "Mickey Barker", "code": "Mickey Barker" }, { "name": "Phillip Geater", "code": "Phillip Geater" }, { "name": "Robert Buggs", "code": "Robert Buggs" }, { "name": "Ty Hairr", "code": "Ty Hairr" }, { "name": "Tyrone Wright", "code": "Tyrone Wright" }, { "name": "Willie Taylor", "code": "Willie Taylor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAST_UPDATED_BY", "type": "esriFieldTypeString", "alias": "Task Updated By", "length": 255, "domain": { "type": "codedValue", "name": "Parks_Users", "description": "Parks_Users", "codedValues": [ { "name": "Anthony Howard", "code": "Anthony Howard" }, { "name": "Connie Shepherd", "code": "Connie Shepherd" }, { "name": "Gettone Smith", "code": "Gettone Smith" }, { "name": "Jeffery Dennis", "code": "Jeffery Dennis" }, { "name": "Jeremy Wright", "code": "Jeremy Wright" }, { "name": "Jonathon Carson", "code": "Jonathon Carson" }, { "name": "Maurice Goode", "code": "Maurice Goode" }, { "name": "Mickey Barker", "code": "Mickey Barker" }, { "name": "Phillip Geater", "code": "Phillip Geater" }, { "name": "Robert Buggs", "code": "Robert Buggs" }, { "name": "Ty Hairr", "code": "Ty Hairr" }, { "name": "Tyrone Wright", "code": "Tyrone Wright" }, { "name": "Willie Taylor", "code": "Willie Taylor" } ], "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": "R23_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_23", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G75ASSET_GUID", "fields": "ASSET_GUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GUID", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "ASSET_TYPE": {"type": "inherited"}, "COMPOUND_NAME": {"type": "inherited"}, "PARK_NAMEFULL": {"type": "inherited"}, "TASK_TYPE": { "type": "codedValue", "name": "Parks_Maintenance_Types", "description": "Parks_Maintenance_Types", "codedValues": [ { "name": "Empty Trash Receptacle", "code": "Empty Trash Receptacle" }, { "name": "Inventory Report", "code": "Inventory Report" }, { "name": "Leaf Mulching", "code": "Leaf Mulching" }, { "name": "Litter Pick Up", "code": "Litter Pick Up" }, { "name": "Mow Edge Trim Blow", "code": "Mow Edge Trim Blow" }, { "name": "Preventative Maint on Equipment", "code": "Preventative Maint on Equipment" }, { "name": "Pruning Hedges", "code": "Pruning Hedges" }, { "name": "Pruning Trees", "code": "Pruning Trees" }, { "name": "Safety Assessment", "code": "Safety Assessment" }, { "name": "Weekly Park Inspection", "code": "Weekly Park Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "TASK_STATUS": {"type": "inherited"}, "TASK_PRIORITY": {"type": "inherited"}, "TASK_ASSIGNEE": {"type": "inherited"}, "Park_Assets_Rating": {"type": "inherited"}, "CREATED_BY": {"type": "inherited"}, "LAST_UPDATED_BY": {"type": "inherited"} }, "id": 20001, "name": "Maintenance Task" }, { "domains": { "ASSET_TYPE": {"type": "inherited"}, "COMPOUND_NAME": {"type": "inherited"}, "PARK_NAMEFULL": {"type": "inherited"}, "TASK_TYPE": { "type": "codedValue", "name": "Parks_Maintenance_Types_MO", "description": "Parks_Maintenance_Types_MO", "codedValues": [ { "name": "Asset Inspection", "code": "Asset Inspection" }, { "name": "Asset Repair", "code": "Asset Repair" }, { "name": "Playground Inspection", "code": "Playground Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "TASK_STATUS": {"type": "inherited"}, "TASK_PRIORITY": {"type": "inherited"}, "TASK_ASSIGNEE": {"type": "inherited"}, "Park_Assets_Rating": {"type": "inherited"}, "CREATED_BY": {"type": "inherited"}, "LAST_UPDATED_BY": {"type": "inherited"} }, "id": 20002, "name": "Maintenance Task M & O" } ], "subtypes": [ { "domains": { "ASSET_TYPE": {"type": "inherited"}, "COMPOUND_NAME": {"type": "inherited"}, "PARK_NAMEFULL": {"type": "inherited"}, "TASK_TYPE": { "type": "codedValue", "name": "Parks_Maintenance_Types", "description": "Parks_Maintenance_Types", "codedValues": [ { "name": "Empty Trash Receptacle", "code": "Empty Trash Receptacle" }, { "name": "Inventory Report", "code": "Inventory Report" }, { "name": "Leaf Mulching", "code": "Leaf Mulching" }, { "name": "Litter Pick Up", "code": "Litter Pick Up" }, { "name": "Mow Edge Trim Blow", "code": "Mow Edge Trim Blow" }, { "name": "Preventative Maint on Equipment", "code": "Preventative Maint on Equipment" }, { "name": "Pruning Hedges", "code": "Pruning Hedges" }, { "name": "Pruning Trees", "code": "Pruning Trees" }, { "name": "Safety Assessment", "code": "Safety Assessment" }, { "name": "Weekly Park Inspection", "code": "Weekly Park Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "TASK_STATUS": {"type": "inherited"}, "TASK_PRIORITY": {"type": "inherited"}, "TASK_ASSIGNEE": {"type": "inherited"}, "Park_Assets_Rating": {"type": "inherited"}, "CREATED_BY": {"type": "inherited"}, "LAST_UPDATED_BY": {"type": "inherited"} }, "defaultValues": { "ASSETID": null, "ASSET_TYPE": null, "Asset_Name": null, "COMPOUND_NAME": null, "Park_ID": null, "PARK_NAMEFULL": null, "PARCELID": null, "TASK_ID": null, "TASK_TYPE_ID": null, "TASK_TYPE": null, "TASK_STATUS": null, "TASK_PRIORITY": null, "CREATION_DATE": null, "TASK_SUBJECT": null, "TASK_ASSIGNEE": null, "TASK_NOTES": null, "Park_Assets_Rating": null, "SCHEDULED_START_DATE": null, "SCHEDULED_END_DATE": null, "ACTUAL_START_DATE": null, "ACTUAL_END_DATE": null, "ACTUAL_EFFORT": null, "FOLLOWUP_DATE": null, "ASSET_GUID": null, "CREATED_BY": null, "LAST_UPDATED_BY": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null }, "code": 20001, "name": "Maintenance Task" }, { "domains": { "ASSET_TYPE": {"type": "inherited"}, "COMPOUND_NAME": {"type": "inherited"}, "PARK_NAMEFULL": {"type": "inherited"}, "TASK_TYPE": { "type": "codedValue", "name": "Parks_Maintenance_Types_MO", "description": "Parks_Maintenance_Types_MO", "codedValues": [ { "name": "Asset Inspection", "code": "Asset Inspection" }, { "name": "Asset Repair", "code": "Asset Repair" }, { "name": "Playground Inspection", "code": "Playground Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "TASK_STATUS": {"type": "inherited"}, "TASK_PRIORITY": {"type": "inherited"}, "TASK_ASSIGNEE": {"type": "inherited"}, "Park_Assets_Rating": {"type": "inherited"}, "CREATED_BY": {"type": "inherited"}, "LAST_UPDATED_BY": {"type": "inherited"} }, "defaultValues": { "ASSETID": null, "ASSET_TYPE": null, "Asset_Name": null, "COMPOUND_NAME": null, "Park_ID": null, "PARK_NAMEFULL": null, "PARCELID": null, "TASK_ID": null, "TASK_TYPE_ID": null, "TASK_TYPE": null, "TASK_STATUS": null, "TASK_PRIORITY": null, "CREATION_DATE": null, "TASK_SUBJECT": null, "TASK_ASSIGNEE": null, "TASK_NOTES": null, "Park_Assets_Rating": null, "SCHEDULED_START_DATE": null, "SCHEDULED_END_DATE": null, "ACTUAL_START_DATE": null, "ACTUAL_END_DATE": null, "ACTUAL_EFFORT": null, "FOLLOWUP_DATE": null, "ASSET_GUID": null, "CREATED_BY": null, "LAST_UPDATED_BY": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null }, "code": 20002, "name": "Maintenance Task M & O" } ], "relationships": [ { "id": 5, "name": "Records to Asset", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "ASSET_GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A4250CE-CBD2-4EAF-BC6F-993ADFF80983}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "e1dd598dad7947b0904fe5f8b0050b71" }