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