{ "currentVersion": 10.41, "id": 3, "name": "GEONAV.COVID_REPORTED_VIOLATION", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BUSINESS_NAME", "typeIdField": null, "fields": [ { "name": "CE_COMPLAINT_SEQ", "type": "esriFieldTypeInteger", "alias": "CE_COMPLAINT_SEQ", "domain": null }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "CASE_NUMBER", "length": 53, "domain": null }, { "name": "COMPLAINT_DATE", "type": "esriFieldTypeDate", "alias": "COMPLAINT_DATE", "length": 8, "domain": null }, { "name": "CE_SOURCE_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "CE_SOURCE_SEQ", "domain": null }, { "name": "SOURCE_DESC", "type": "esriFieldTypeString", "alias": "SOURCE_DESC", "length": 40, "domain": null }, { "name": "STATUS_CODE", "type": "esriFieldTypeString", "alias": "STATUS_CODE", "length": 1, "domain": null }, { "name": "STATUS_DESC", "type": "esriFieldTypeString", "alias": "STATUS_DESC", "length": 20, "domain": null }, { "name": "COMPLAINT", "type": "esriFieldTypeString", "alias": "COMPLAINT", "length": 40, "domain": null }, { "name": "COMPLAINT_COMMENT", "type": "esriFieldTypeString", "alias": "COMPLAINT_COMMENT", "length": 500, "domain": null }, { "name": "ADDRESS1", "type": "esriFieldTypeString", "alias": "ADDRESS1", "length": 4000, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 30, "domain": null }, { "name": "ZIP_CODE", "type": "esriFieldTypeString", "alias": "ZIP_CODE", "length": 5, "domain": null }, { "name": "GENERAL_LOCATION", "type": "esriFieldTypeString", "alias": "GENERAL_LOCATION", "length": 4000, "domain": null }, { "name": "SITUS_SEQ", "type": "esriFieldTypeDouble", "alias": "SITUS_SEQ", "domain": null }, { "name": "COMPLAINT_TYPE", "type": "esriFieldTypeString", "alias": "COMPLAINT_TYPE", "length": 1, "domain": null }, { "name": "BUSINESS_NAME", "type": "esriFieldTypeString", "alias": "BUSINESS_NAME", "length": 150, "domain": null }, { "name": "PENDING_INSPECTION", "type": "esriFieldTypeString", "alias": "PENDING_INSPECTION", "length": 3, "domain": null }, { "name": "CITATION_ISSUED", "type": "esriFieldTypeString", "alias": "CITATION_ISSUED", "length": 3, "domain": null }, { "name": "NOV_ISSUED", "type": "esriFieldTypeString", "alias": "NOV_ISSUED", "length": 3, "domain": null }, { "name": "WARNING_ISSUED", "type": "esriFieldTypeString", "alias": "WARNING_ISSUED", "length": 3, "domain": null }, { "name": "BUSINESS_SHUTDOWN_ISSUED", "type": "esriFieldTypeString", "alias": "BUSINESS_SHUTDOWN_ISSUED", "length": 3, "domain": null }, { "name": "EDUCATION_ISSUED", "type": "esriFieldTypeString", "alias": "EDUCATION_ISSUED", "length": 3, "domain": null }, { "name": "FULLY_COMPLIANT_ISSUED", "type": "esriFieldTypeString", "alias": "FULLY_COMPLIANT_ISSUED", "length": 3, "domain": null }, { "name": "REFERRAL_ISSUED", "type": "esriFieldTypeString", "alias": "REFERRAL_ISSUED", "length": 3, "domain": null }, { "name": "LATEST_STATUS_IMAGE", "type": "esriFieldTypeString", "alias": "LATEST_STATUS_IMAGE", "length": 4000, "domain": null }, { "name": "CITATION_COUNT", "type": "esriFieldTypeDouble", "alias": "CITATION_COUNT", "domain": null }, { "name": "NOV_COUNT", "type": "esriFieldTypeDouble", "alias": "NOV_COUNT", "domain": null }, { "name": "WARNING_COUNT", "type": "esriFieldTypeDouble", "alias": "WARNING_COUNT", "domain": null }, { "name": "BUSINESS_SHUTDOWN_COUNT", "type": "esriFieldTypeDouble", "alias": "BUSINESS_SHUTDOWN_COUNT", "domain": null }, { "name": "EDUCATION_COUNT", "type": "esriFieldTypeDouble", "alias": "EDUCATION_COUNT", "domain": null }, { "name": "FULLY_COMPLIANT_COUNT", "type": "esriFieldTypeDouble", "alias": "FULLY_COMPLIANT_COUNT", "domain": null }, { "name": "REFERRAL_COUNT", "type": "esriFieldTypeDouble", "alias": "REFERRAL_COUNT", "domain": null }, { "name": "VIOLATION_TYPE_HOURS", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_HOURS", "length": 40, "domain": null }, { "name": "VIOLATION_TYPE_NO_OPEN", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_NO_OPEN", "length": 40, "domain": null }, { "name": "VIOLATION_TYPE_50PCT", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_50PCT", "length": 40, "domain": null }, { "name": "VIOLATION_TYPE_SOCIAL", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_SOCIAL", "length": 40, "domain": null }, { "name": "VIOLATION_TYPE_OTHERS", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_OTHERS", "length": 40, "domain": null }, { "name": "RESOLVED", "type": "esriFieldTypeString", "alias": "RESOLVED", "length": 3, "domain": null }, { "name": "STREET_NO", "type": "esriFieldTypeString", "alias": "STREET_NO", "length": 10, "domain": null }, { "name": "STREET_PRE_DIR", "type": "esriFieldTypeString", "alias": "STREET_PRE_DIR", "length": 2, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "length": 30, "domain": null }, { "name": "STREET_SUFFIX", "type": "esriFieldTypeString", "alias": "STREET_SUFFIX", "length": 4, "domain": null }, { "name": "STREET_POST_DIR", "type": "esriFieldTypeString", "alias": "STREET_POST_DIR", "length": 2, "domain": null }, { "name": "APT_BLDG_UNIT", "type": "esriFieldTypeString", "alias": "APT_BLDG_UNIT", "length": 6, "domain": null }, { "name": "STREET_ADDR_UNIT", "type": "esriFieldTypeString", "alias": "STREET_ADDR_UNIT", "length": 6, "domain": null }, { "name": "STREET_BLDG_FIRM_SECOND_NAME", "type": "esriFieldTypeString", "alias": "STREET_BLDG_FIRM_SECOND_NAME", "length": 30, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "R1034577_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true } }