{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 16, "name": "EE Court Cases", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CivilWarrant", "type": "esriFieldTypeInteger", "alias": "Civil Warrant", "domain": null }, { "name": "NextSetting", "type": "esriFieldTypeDate", "alias": "Next Setting", "length": 8, "domain": null }, { "name": "Status_1", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "Code_MemphisFightsBlightStatus", "description": "Memphis Fights Blight Status", "codedValues": [ { "name": "Demo", "code": "Demo" }, { "name": "Dev Plan", "code": "Dev Plan" }, { "name": "Dismissed", "code": "Dismissed" }, { "name": "Hearing", "code": "Hearing" }, { "name": "Initial Setting", "code": "Initial Setting" }, { "name": "Initial Setting 2", "code": "Initial Setting 2" }, { "name": "Initial Setting 3", "code": "Initial Setting 3" }, { "name": "Initial Setting 4", "code": "Initial Setting 4" }, { "name": "Non-Compliance", "code": "Non-Compliance" }, { "name": "Nuisance", "code": "Nuisance" }, { "name": "Payment", "code": "Payment" }, { "name": "Receiver", "code": "Receiver" }, { "name": "Status", "code": "Status" }, { "name": "Stay", "code": "Stay" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 100, "domain": null }, { "name": "CityFileNo", "type": "esriFieldTypeString", "alias": "City File No", "length": 50, "domain": null }, { "name": "CouncilDistrict", "type": "esriFieldTypeInteger", "alias": "Council District", "domain": null }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "Assigned To", "length": 50, "domain": { "type": "codedValue", "name": "Code_MemphisFightsBlightAssignedTo", "description": "Memphis Fights Blight Assigned To", "codedValues": [ { "name": "Alexandra Francis", "code": "Alexandra Francis" }, { "name": "Brittany Williams", "code": "Brittany Williams" }, { "name": "City Prosecutor", "code": "City Prosecutor" }, { "name": "Corbin Kennedy", "code": "Corbin Kennedy" }, { "name": "Courtney Boykin", "code": "Courtney Boykin" }, { "name": "Danny Schaffzin", "code": "Danny Schaffzin" }, { "name": "Hayden Cherry", "code": "Hayden Cherry" }, { "name": "Jared Davenport", "code": "Jared Davenport" }, { "name": "Kaitlyn Cornett", "code": "Kaitlyn Cornett" }, { "name": "Kenya Hooks", "code": "Kenya Hooks" }, { "name": "Rachel Goodwin", "code": "Rachel Goodwin" }, { "name": "Steve Barlow", "code": "Steve Barlow" }, { "name": "Will Gibbons", "code": "Will Gibbons" }, { "name": "Will Hultman", "code": "Will Hultman" }, { "name": "Brigid Welsh", "code": "Brigid Welsh" }, { "name": "Cory Chitwood", "code": "Cory Chitwood" }, { "name": "Dillan McQueen", "code": "Dillan McQueen" }, { "name": "Kenneth Piper", "code": "Kenneth Piper" }, { "name": "Mark Zenker", "code": "Mark Zenker" }, { "name": "Evan Thiele", "code": "Evan Thiele" }, { "name": "Faith Merriweather", "code": "Faith Merriweather" }, { "name": "Hayden Phillips", "code": "Hayden Phillips" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StreetNumber", "type": "esriFieldTypeInteger", "alias": "Street Number", "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "AZAddress", "type": "esriFieldTypeString", "alias": "AZAddress", "length": 100, "domain": null }, { "name": "OwnerFirstName", "type": "esriFieldTypeString", "alias": "Owner First Name", "length": 100, "domain": null }, { "name": "OwnerLastName", "type": "esriFieldTypeString", "alias": "Owner Last Name", "length": 100, "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 50, "domain": null }, { "name": "OwnerMailingAddress", "type": "esriFieldTypeString", "alias": "Owner Mailing Address", "length": 100, "domain": null }, { "name": "OwnerCity", "type": "esriFieldTypeString", "alias": "Owner City", "length": 100, "domain": null }, { "name": "OwnerState", "type": "esriFieldTypeString", "alias": "Owner State", "length": 100, "domain": null }, { "name": "OwnerZip", "type": "esriFieldTypeString", "alias": "Owner Zip", "length": 100, "domain": null }, { "name": "OwnerContactNumber", "type": "esriFieldTypeString", "alias": "Owner Contact Number", "length": 100, "domain": null }, { "name": "NotesInitialFiling", "type": "esriFieldTypeString", "alias": "Notes Initial Filing", "length": 1073741822, "domain": null }, { "name": "CourtNotes", "type": "esriFieldTypeString", "alias": "Court Notes", "length": 1073741822, "domain": null }, { "name": "NotesOnService", "type": "esriFieldTypeString", "alias": "Notes On Service", "length": 1073741822, "domain": null }, { "name": "ContactName", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 500, "domain": null }, { "name": "NotesFromCorrespondence", "type": "esriFieldTypeString", "alias": "Notes From Correspondence", "length": 1073741822, "domain": null }, { "name": "BestWayToContact", "type": "esriFieldTypeString", "alias": "Best Way To Contact", "length": 500, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "DateEdited", "type": "esriFieldTypeDate", "alias": "Date Edited", "length": 8, "domain": null }, { "name": "PhotoBefore", "type": "esriFieldTypeString", "alias": "Photo Before", "length": 255, "domain": null }, { "name": "PhotoAfter", "type": "esriFieldTypeString", "alias": "Photo After", "length": 255, "domain": null }, { "name": "DismissStatus", "type": "esriFieldTypeString", "alias": "Dismiss Status", "length": 100, "domain": null }, { "name": "lat", "type": "esriFieldTypeDouble", "alias": "lat", "domain": null }, { "name": "lng", "type": "esriFieldTypeDouble", "alias": "lng", "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "type", "length": 50, "domain": null }, { "name": "pic", "type": "esriFieldTypeString", "alias": "pic", "length": 255, "domain": null }, { "name": "Referral", "type": "esriFieldTypeString", "alias": "Referral", "length": 500, "domain": null }, { "name": "DismissedCondition", "type": "esriFieldTypeString", "alias": "Dismissed Condition", "length": 500, "domain": { "type": "codedValue", "name": "Code_MemphisFightsBlightDismissedReason", "description": "Memphis Fights Blight Dismissed Reason", "codedValues": [ { "name": "Dismissed Rehab by Property Owner", "code": "Dismissed Rehab by Property Owner" }, { "name": "Dismissed Rehab by Property Receiver", "code": "Dismissed Rehab by Property Receiver" }, { "name": "Dismissed Demolished by City", "code": "Dismissed Demolished by City" }, { "name": "Dismissed Demolished by Property Owner", "code": "Dismissed Demolished by Property Owner" }, { "name": "Dismissed Property Transferred", "code": "Dismissed Property Transferred" }, { "name": "Dismissed Property Owned by County Through Tax Sale", "code": "Dismissed Property Owned by County Through Tax Sale" }, { "name": "Dismissed Refer to Condemnation", "code": "Dismissed Refer to Condemnation" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Other", "type": "esriFieldTypeString", "alias": "Other", "length": 500, "domain": null }, { "name": "Assign", "type": "esriFieldTypeString", "alias": "Assign", "length": 500, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 50, "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": 50, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Incident_Number", "type": "esriFieldTypeString", "alias": "SR Number", "length": 64, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null }, { "name": "SR_Summary", "type": "esriFieldTypeString", "alias": "SR_Summary", "length": 500, "domain": null } ], "indexes": [ { "name": "R90_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_90", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S123_Index", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3014_ParentG", "fields": "ParentGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 21, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" }, { "id": 31, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" }, { "id": 41, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" }, { "id": 50, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" }, { "id": 53, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" }, { "id": 65, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" }, { "id": 70, "name": "PW_Code_EnvEnf_ServiceRequests", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{62340668-3D27-4755-8CEF-2C04482A0662}" } ], "capabilities": "Map,Query,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": "1e8ab59911a64c4f847ab1fef2796ce6" }