Name: GEONAV.COVID_REPORTED_VIOLATION

Display Field: BUSINESS_NAME

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• CE_COMPLAINT_SEQ ( type: esriFieldTypeInteger , alias: CE_COMPLAINT_SEQ )
• CASE_NUMBER ( type: esriFieldTypeString , alias: CASE_NUMBER , length: 53 )
• COMPLAINT_DATE ( type: esriFieldTypeDate , alias: COMPLAINT_DATE , length: 8 )
• CE_SOURCE_SEQ ( type: esriFieldTypeSmallInteger , alias: CE_SOURCE_SEQ )
• SOURCE_DESC ( type: esriFieldTypeString , alias: SOURCE_DESC , length: 40 )
• STATUS_CODE ( type: esriFieldTypeString , alias: STATUS_CODE , length: 1 )
• STATUS_DESC ( type: esriFieldTypeString , alias: STATUS_DESC , length: 20 )
• COMPLAINT ( type: esriFieldTypeString , alias: COMPLAINT , length: 40 )
• COMPLAINT_COMMENT ( type: esriFieldTypeString , alias: COMPLAINT_COMMENT , length: 500 )
• ADDRESS1 ( type: esriFieldTypeString , alias: ADDRESS1 , length: 4000 )
• CITY ( type: esriFieldTypeString , alias: CITY , length: 30 )
• ZIP_CODE ( type: esriFieldTypeString , alias: ZIP_CODE , length: 5 )
• GENERAL_LOCATION ( type: esriFieldTypeString , alias: GENERAL_LOCATION , length: 4000 )
• SITUS_SEQ ( type: esriFieldTypeDouble , alias: SITUS_SEQ )
• COMPLAINT_TYPE ( type: esriFieldTypeString , alias: COMPLAINT_TYPE , length: 1 )
• BUSINESS_NAME ( type: esriFieldTypeString , alias: BUSINESS_NAME , length: 150 )
• PENDING_INSPECTION ( type: esriFieldTypeString , alias: PENDING_INSPECTION , length: 3 )
• CITATION_ISSUED ( type: esriFieldTypeString , alias: CITATION_ISSUED , length: 3 )
• NOV_ISSUED ( type: esriFieldTypeString , alias: NOV_ISSUED , length: 3 )
• WARNING_ISSUED ( type: esriFieldTypeString , alias: WARNING_ISSUED , length: 3 )
• BUSINESS_SHUTDOWN_ISSUED ( type: esriFieldTypeString , alias: BUSINESS_SHUTDOWN_ISSUED , length: 3 )
• EDUCATION_ISSUED ( type: esriFieldTypeString , alias: EDUCATION_ISSUED , length: 3 )
• FULLY_COMPLIANT_ISSUED ( type: esriFieldTypeString , alias: FULLY_COMPLIANT_ISSUED , length: 3 )
• REFERRAL_ISSUED ( type: esriFieldTypeString , alias: REFERRAL_ISSUED , length: 3 )
• LATEST_STATUS_IMAGE ( type: esriFieldTypeString , alias: LATEST_STATUS_IMAGE , length: 4000 )
• CITATION_COUNT ( type: esriFieldTypeDouble , alias: CITATION_COUNT )
• NOV_COUNT ( type: esriFieldTypeDouble , alias: NOV_COUNT )
• WARNING_COUNT ( type: esriFieldTypeDouble , alias: WARNING_COUNT )
• BUSINESS_SHUTDOWN_COUNT ( type: esriFieldTypeDouble , alias: BUSINESS_SHUTDOWN_COUNT )
• EDUCATION_COUNT ( type: esriFieldTypeDouble , alias: EDUCATION_COUNT )
• FULLY_COMPLIANT_COUNT ( type: esriFieldTypeDouble , alias: FULLY_COMPLIANT_COUNT )
• REFERRAL_COUNT ( type: esriFieldTypeDouble , alias: REFERRAL_COUNT )
• VIOLATION_TYPE_HOURS ( type: esriFieldTypeString , alias: VIOLATION_TYPE_HOURS , length: 40 )
• VIOLATION_TYPE_NO_OPEN ( type: esriFieldTypeString , alias: VIOLATION_TYPE_NO_OPEN , length: 40 )
• VIOLATION_TYPE_50PCT ( type: esriFieldTypeString , alias: VIOLATION_TYPE_50PCT , length: 40 )
• VIOLATION_TYPE_SOCIAL ( type: esriFieldTypeString , alias: VIOLATION_TYPE_SOCIAL , length: 40 )
• VIOLATION_TYPE_OTHERS ( type: esriFieldTypeString , alias: VIOLATION_TYPE_OTHERS , length: 40 )
• RESOLVED ( type: esriFieldTypeString , alias: RESOLVED , length: 3 )
• STREET_NO ( type: esriFieldTypeString , alias: STREET_NO , length: 10 )
• STREET_PRE_DIR ( type: esriFieldTypeString , alias: STREET_PRE_DIR , length: 2 )
• STREET_NAME ( type: esriFieldTypeString , alias: STREET_NAME , length: 30 )
• STREET_SUFFIX ( type: esriFieldTypeString , alias: STREET_SUFFIX , length: 4 )
• STREET_POST_DIR ( type: esriFieldTypeString , alias: STREET_POST_DIR , length: 2 )
• APT_BLDG_UNIT ( type: esriFieldTypeString , alias: APT_BLDG_UNIT , length: 6 )
• STREET_ADDR_UNIT ( type: esriFieldTypeString , alias: STREET_ADDR_UNIT , length: 6 )
• STREET_BLDG_FIRM_SECOND_NAME ( type: esriFieldTypeString , alias: STREET_BLDG_FIRM_SECOND_NAME , length: 30 )
• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )

Supported Operations:   Query   Generate Renderer   Return Updates