{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 12, "name": "Case_Main", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CASE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "PREFIX", "length": 6, "domain": null }, { "name": "YRMO", "type": "esriFieldTypeDouble", "alias": "YRMO", "domain": null }, { "name": "SEQ_NO", "type": "esriFieldTypeDouble", "alias": "SEQ_NO", "domain": null }, { "name": "CASE_NO", "type": "esriFieldTypeString", "alias": "CASE_NO", "length": 30, "domain": null }, { "name": "CASE_NAME", "type": "esriFieldTypeString", "alias": "CASE_NAME", "length": 60, "domain": null }, { "name": "STARTED", "type": "esriFieldTypeDate", "alias": "STARTED", "length": 8, "domain": null }, { "name": "STARTED_BY", "type": "esriFieldTypeString", "alias": "STARTED_BY", "length": 6, "domain": null }, { "name": "CLOSED", "type": "esriFieldTypeDate", "alias": "CLOSED", "length": 8, "domain": null }, { "name": "CLOSED_BY", "type": "esriFieldTypeString", "alias": "CLOSED_BY", "length": 6, "domain": null }, { "name": "LASTACTION", "type": "esriFieldTypeDate", "alias": "LASTACTION", "length": 8, "domain": null }, { "name": "LASTACTION_BY", "type": "esriFieldTypeString", "alias": "LASTACTION_BY", "length": 6, "domain": null }, { "name": "FOLLOWUP", "type": "esriFieldTypeDate", "alias": "FOLLOWUP", "length": 8, "domain": null }, { "name": "FOLLOWUP_BY", "type": "esriFieldTypeString", "alias": "FOLLOWUP_BY", "length": 6, "domain": null }, { "name": "RECEIVED_BY", "type": "esriFieldTypeString", "alias": "RECEIVED_BY", "length": 30, "domain": null }, { "name": "HOW_RECEIVED", "type": "esriFieldTypeString", "alias": "HOW_RECEIVED", "length": 30, "domain": null }, { "name": "CaseType", "type": "esriFieldTypeString", "alias": "CaseType", "length": 60, "domain": null }, { "name": "CaseSubType", "type": "esriFieldTypeString", "alias": "CaseSubType", "length": 60, "domain": null }, { "name": "CASE_LOCATION", "type": "esriFieldTypeString", "alias": "CASE_LOCATION", "length": 100, "domain": null }, { "name": "SITE_APN", "type": "esriFieldTypeString", "alias": "SITE_APN", "length": 50, "domain": null }, { "name": "SITE_STREETID", "type": "esriFieldTypeInteger", "alias": "SITE_STREETID", "domain": null }, { "name": "SITE_NUMBER", "type": "esriFieldTypeString", "alias": "SITE_NUMBER", "length": 12, "domain": null }, { "name": "SITE_STREETNAME", "type": "esriFieldTypeString", "alias": "SITE_STREETNAME", "length": 60, "domain": null }, { "name": "SITE_UNIT_NO", "type": "esriFieldTypeString", "alias": "SITE_UNIT_NO", "length": 10, "domain": null }, { "name": "SITE_CITY", "type": "esriFieldTypeString", "alias": "SITE_CITY", "length": 30, "domain": null }, { "name": "SITE_STATE", "type": "esriFieldTypeString", "alias": "SITE_STATE", "length": 2, "domain": null }, { "name": "SITE_ZIP", "type": "esriFieldTypeString", "alias": "SITE_ZIP", "length": 10, "domain": null }, { "name": "SITE_LOT_NO", "type": "esriFieldTypeString", "alias": "SITE_LOT_NO", "length": 20, "domain": null }, { "name": "SITE_BLOCK", "type": "esriFieldTypeString", "alias": "SITE_BLOCK", "length": 10, "domain": null }, { "name": "SITE_TRACT", "type": "esriFieldTypeString", "alias": "SITE_TRACT", "length": 50, "domain": null }, { "name": "SITE_SUBDIVISION", "type": "esriFieldTypeString", "alias": "SITE_SUBDIVISION", "length": 100, "domain": null }, { "name": "SITE_DESCRIPTION", "type": "esriFieldTypeString", "alias": "SITE_DESCRIPTION", "length": 2000, "domain": null }, { "name": "SITE_ADDR", "type": "esriFieldTypeString", "alias": "SITE_ADDR", "length": 85, "domain": null }, { "name": "CODE_SECTION", "type": "esriFieldTypeString", "alias": "CODE_SECTION", "length": 30, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 5000, "domain": null }, { "name": "ASSIGNED_TO", "type": "esriFieldTypeString", "alias": "ASSIGNED_TO", "length": 30, "domain": null }, { "name": "REFERRED_TO", "type": "esriFieldTypeString", "alias": "REFERRED_TO", "length": 30, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 60, "domain": null }, { "name": "FEES_CHARGED", "type": "esriFieldTypeDouble", "alias": "FEES_CHARGED", "domain": null }, { "name": "FEES_PAID", "type": "esriFieldTypeDouble", "alias": "FEES_PAID", "domain": null }, { "name": "BALANCE_DUE", "type": "esriFieldTypeDouble", "alias": "BALANCE_DUE", "domain": null }, { "name": "PARENT_PROJECT_NO", "type": "esriFieldTypeString", "alias": "PARENT_PROJECT_NO", "length": 30, "domain": null }, { "name": "OTHER_DATE1", "type": "esriFieldTypeDate", "alias": "OTHER_DATE1", "length": 8, "domain": null }, { "name": "OTHER_BY1", "type": "esriFieldTypeString", "alias": "OTHER_BY1", "length": 6, "domain": null }, { "name": "OWNER_NAME", "type": "esriFieldTypeString", "alias": "OWNER_NAME", "length": 60, "domain": null }, { "name": "RESIDENT_NAME", "type": "esriFieldTypeString", "alias": "RESIDENT_NAME", "length": 60, "domain": null }, { "name": "COMPLAINANT_NAME", "type": "esriFieldTypeString", "alias": "COMPLAINANT_NAME", "length": 60, "domain": null }, { "name": "RECORDID", "type": "esriFieldTypeString", "alias": "RECORDID", "length": 30, "domain": null }, { "name": "LOCKID", "type": "esriFieldTypeString", "alias": "LOCKID", "length": 30, "domain": null }, { "name": "LOC_RECORDID", "type": "esriFieldTypeString", "alias": "LOC_RECORDID", "length": 30, "domain": null }, { "name": "DEPOSITTYPE", "type": "esriFieldTypeString", "alias": "DEPOSITTYPE", "length": 60, "domain": null }, { "name": "HISTORICAL_APN", "type": "esriFieldTypeString", "alias": "HISTORICAL_APN", "length": 50, "domain": null }, { "name": "PARENT_PERMIT_NO", "type": "esriFieldTypeString", "alias": "PARENT_PERMIT_NO", "length": 30, "domain": null }, { "name": "PARENT_BUS_LIC_NO", "type": "esriFieldTypeString", "alias": "PARENT_BUS_LIC_NO", "length": 20, "domain": null }, { "name": "REFERENCE_NO", "type": "esriFieldTypeString", "alias": "REFERENCE_NO", "length": 30, "domain": null }, { "name": "SITE_ALTERNATE_ID", "type": "esriFieldTypeString", "alias": "SITE_ALTERNATE_ID", "length": 40, "domain": null }, { "name": "SITE_GEOTYPE", "type": "esriFieldTypeString", "alias": "SITE_GEOTYPE", "length": 60, "domain": null }, { "name": "Parent_Generic1_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic1_ActivityNo", "length": 15, "domain": null }, { "name": "Parent_Generic2_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic2_ActivityNo", "length": 15, "domain": null }, { "name": "Parent_Generic3_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic3_ActivityNo", "length": 15, "domain": null }, { "name": "Parent_Generic4_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic4_ActivityNo", "length": 15, "domain": null }, { "name": "Parent_Generic5_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic5_ActivityNo", "length": 15, "domain": null }, { "name": "TSstatus", "type": "esriFieldTypeInteger", "alias": "TSstatus", "domain": null }, { "name": "ActivityTypeID", "type": "esriFieldTypeInteger", "alias": "ActivityTypeID", "domain": null }, { "name": "Unique_Key", "type": "esriFieldTypeGUID", "alias": "Unique_Key", "length": 38, "domain": null }, { "name": "RowNum", "type": "esriFieldTypeOID", "alias": "RowNum", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "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, "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": "6c3db0d094bc4f2fb7fbe977b6cb5ca4" }