{ "currentVersion": 10.81, "id": 3, "name": "GEONAV.COVID_REPORTED_VIOLATION", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "BUSINESS_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "CE_COMPLAINT_SEQ", "type": "esriFieldTypeInteger", "alias": "CE_COMPLAINT_SEQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CE_COMPLAINT_SEQ" }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "CASE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 53, "defaultValue": null, "modelName": "CASE_NUMBER" }, { "name": "COMPLAINT_DATE", "type": "esriFieldTypeDate", "alias": "COMPLAINT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMPLAINT_DATE" }, { "name": "CE_SOURCE_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "CE_SOURCE_SEQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CE_SOURCE_SEQ" }, { "name": "SOURCE_DESC", "type": "esriFieldTypeString", "alias": "SOURCE_DESC", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SOURCE_DESC" }, { "name": "STATUS_CODE", "type": "esriFieldTypeString", "alias": "STATUS_CODE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "STATUS_CODE" }, { "name": "STATUS_DESC", "type": "esriFieldTypeString", "alias": "STATUS_DESC", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "STATUS_DESC" }, { "name": "COMPLAINT", "type": "esriFieldTypeString", "alias": "COMPLAINT", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "COMPLAINT" }, { "name": "COMPLAINT_COMMENT", "type": "esriFieldTypeString", "alias": "COMPLAINT_COMMENT", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "COMPLAINT_COMMENT" }, { "name": "ADDRESS1", "type": "esriFieldTypeString", "alias": "ADDRESS1", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "ADDRESS1" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CITY" }, { "name": "ZIP_CODE", "type": "esriFieldTypeString", "alias": "ZIP_CODE", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ZIP_CODE" }, { "name": "GENERAL_LOCATION", "type": "esriFieldTypeString", "alias": "GENERAL_LOCATION", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "GENERAL_LOCATION" }, { "name": "SITUS_SEQ", "type": "esriFieldTypeDouble", "alias": "SITUS_SEQ", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SITUS_SEQ" }, { "name": "COMPLAINT_TYPE", "type": "esriFieldTypeString", "alias": "COMPLAINT_TYPE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "COMPLAINT_TYPE" }, { "name": "BUSINESS_NAME", "type": "esriFieldTypeString", "alias": "BUSINESS_NAME", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "BUSINESS_NAME" }, { "name": "PENDING_INSPECTION", "type": "esriFieldTypeString", "alias": "PENDING_INSPECTION", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PENDING_INSPECTION" }, { "name": "CITATION_ISSUED", "type": "esriFieldTypeString", "alias": "CITATION_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CITATION_ISSUED" }, { "name": "NOV_ISSUED", "type": "esriFieldTypeString", "alias": "NOV_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "NOV_ISSUED" }, { "name": "WARNING_ISSUED", "type": "esriFieldTypeString", "alias": "WARNING_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "WARNING_ISSUED" }, { "name": "BUSINESS_SHUTDOWN_ISSUED", "type": "esriFieldTypeString", "alias": "BUSINESS_SHUTDOWN_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "BUSINESS_SHUTDOWN_ISSUED" }, { "name": "EDUCATION_ISSUED", "type": "esriFieldTypeString", "alias": "EDUCATION_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "EDUCATION_ISSUED" }, { "name": "FULLY_COMPLIANT_ISSUED", "type": "esriFieldTypeString", "alias": "FULLY_COMPLIANT_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FULLY_COMPLIANT_ISSUED" }, { "name": "REFERRAL_ISSUED", "type": "esriFieldTypeString", "alias": "REFERRAL_ISSUED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "REFERRAL_ISSUED" }, { "name": "LATEST_STATUS_IMAGE", "type": "esriFieldTypeString", "alias": "LATEST_STATUS_IMAGE", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "LATEST_STATUS_IMAGE" }, { "name": "CITATION_COUNT", "type": "esriFieldTypeDouble", "alias": "CITATION_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CITATION_COUNT" }, { "name": "NOV_COUNT", "type": "esriFieldTypeDouble", "alias": "NOV_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOV_COUNT" }, { "name": "WARNING_COUNT", "type": "esriFieldTypeDouble", "alias": "WARNING_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WARNING_COUNT" }, { "name": "BUSINESS_SHUTDOWN_COUNT", "type": "esriFieldTypeDouble", "alias": "BUSINESS_SHUTDOWN_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BUSINESS_SHUTDOWN_COUNT" }, { "name": "EDUCATION_COUNT", "type": "esriFieldTypeDouble", "alias": "EDUCATION_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EDUCATION_COUNT" }, { "name": "FULLY_COMPLIANT_COUNT", "type": "esriFieldTypeDouble", "alias": "FULLY_COMPLIANT_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FULLY_COMPLIANT_COUNT" }, { "name": "REFERRAL_COUNT", "type": "esriFieldTypeDouble", "alias": "REFERRAL_COUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REFERRAL_COUNT" }, { "name": "VIOLATION_TYPE_HOURS", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_HOURS", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "VIOLATION_TYPE_HOURS" }, { "name": "VIOLATION_TYPE_NO_OPEN", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_NO_OPEN", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "VIOLATION_TYPE_NO_OPEN" }, { "name": "VIOLATION_TYPE_50PCT", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_50PCT", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "VIOLATION_TYPE_50PCT" }, { "name": "VIOLATION_TYPE_SOCIAL", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_SOCIAL", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "VIOLATION_TYPE_SOCIAL" }, { "name": "VIOLATION_TYPE_OTHERS", "type": "esriFieldTypeString", "alias": "VIOLATION_TYPE_OTHERS", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "VIOLATION_TYPE_OTHERS" }, { "name": "RESOLVED", "type": "esriFieldTypeString", "alias": "RESOLVED", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "RESOLVED" }, { "name": "STREET_NO", "type": "esriFieldTypeString", "alias": "STREET_NO", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "STREET_NO" }, { "name": "STREET_PRE_DIR", "type": "esriFieldTypeString", "alias": "STREET_PRE_DIR", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "STREET_PRE_DIR" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STREET_NAME" }, { "name": "STREET_SUFFIX", "type": "esriFieldTypeString", "alias": "STREET_SUFFIX", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "STREET_SUFFIX" }, { "name": "STREET_POST_DIR", "type": "esriFieldTypeString", "alias": "STREET_POST_DIR", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "STREET_POST_DIR" }, { "name": "APT_BLDG_UNIT", "type": "esriFieldTypeString", "alias": "APT_BLDG_UNIT", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "APT_BLDG_UNIT" }, { "name": "STREET_ADDR_UNIT", "type": "esriFieldTypeString", "alias": "STREET_ADDR_UNIT", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "STREET_ADDR_UNIT" }, { "name": "STREET_BLDG_FIRM_SECOND_NAME", "type": "esriFieldTypeString", "alias": "STREET_BLDG_FIRM_SECOND_NAME", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STREET_BLDG_FIRM_SECOND_NAME" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "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, geoJSON", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }