Name: GEONAV.COVID_REPORTED_VIOLATION

Display Field: BUSINESS_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: 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   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata