Name: GEONAV.COVID_REPORTED_VIOLATION
Display Field: BUSINESS_NAME
Type: Table
Geometry Type: N/A
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing Info:
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:
Fields:
-
CE_COMPLAINT_SEQ
(
type: esriFieldTypeInteger
,
alias: CE_COMPLAINT_SEQ
,
editable: true
,
nullable: true
)
-
CASE_NUMBER
(
type: esriFieldTypeString
,
alias: CASE_NUMBER
,
editable: true
,
nullable: true
,
length: 53
)
-
COMPLAINT_DATE
(
type: esriFieldTypeDate
,
alias: COMPLAINT_DATE
,
editable: true
,
nullable: true
,
length: 8
)
-
CE_SOURCE_SEQ
(
type: esriFieldTypeSmallInteger
,
alias: CE_SOURCE_SEQ
,
editable: true
,
nullable: true
)
-
SOURCE_DESC
(
type: esriFieldTypeString
,
alias: SOURCE_DESC
,
editable: true
,
nullable: true
,
length: 40
)
-
STATUS_CODE
(
type: esriFieldTypeString
,
alias: STATUS_CODE
,
editable: true
,
nullable: true
,
length: 1
)
-
STATUS_DESC
(
type: esriFieldTypeString
,
alias: STATUS_DESC
,
editable: true
,
nullable: true
,
length: 20
)
-
COMPLAINT
(
type: esriFieldTypeString
,
alias: COMPLAINT
,
editable: true
,
nullable: true
,
length: 40
)
-
COMPLAINT_COMMENT
(
type: esriFieldTypeString
,
alias: COMPLAINT_COMMENT
,
editable: true
,
nullable: true
,
length: 500
)
-
ADDRESS1
(
type: esriFieldTypeString
,
alias: ADDRESS1
,
editable: true
,
nullable: true
,
length: 4000
)
-
CITY
(
type: esriFieldTypeString
,
alias: CITY
,
editable: true
,
nullable: true
,
length: 30
)
-
ZIP_CODE
(
type: esriFieldTypeString
,
alias: ZIP_CODE
,
editable: true
,
nullable: true
,
length: 5
)
-
GENERAL_LOCATION
(
type: esriFieldTypeString
,
alias: GENERAL_LOCATION
,
editable: true
,
nullable: true
,
length: 4000
)
-
SITUS_SEQ
(
type: esriFieldTypeDouble
,
alias: SITUS_SEQ
,
editable: true
,
nullable: true
)
-
COMPLAINT_TYPE
(
type: esriFieldTypeString
,
alias: COMPLAINT_TYPE
,
editable: true
,
nullable: true
,
length: 1
)
-
BUSINESS_NAME
(
type: esriFieldTypeString
,
alias: BUSINESS_NAME
,
editable: true
,
nullable: true
,
length: 150
)
-
PENDING_INSPECTION
(
type: esriFieldTypeString
,
alias: PENDING_INSPECTION
,
editable: true
,
nullable: true
,
length: 3
)
-
CITATION_ISSUED
(
type: esriFieldTypeString
,
alias: CITATION_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
NOV_ISSUED
(
type: esriFieldTypeString
,
alias: NOV_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
WARNING_ISSUED
(
type: esriFieldTypeString
,
alias: WARNING_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
BUSINESS_SHUTDOWN_ISSUED
(
type: esriFieldTypeString
,
alias: BUSINESS_SHUTDOWN_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
EDUCATION_ISSUED
(
type: esriFieldTypeString
,
alias: EDUCATION_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
FULLY_COMPLIANT_ISSUED
(
type: esriFieldTypeString
,
alias: FULLY_COMPLIANT_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
REFERRAL_ISSUED
(
type: esriFieldTypeString
,
alias: REFERRAL_ISSUED
,
editable: true
,
nullable: true
,
length: 3
)
-
LATEST_STATUS_IMAGE
(
type: esriFieldTypeString
,
alias: LATEST_STATUS_IMAGE
,
editable: true
,
nullable: true
,
length: 4000
)
-
CITATION_COUNT
(
type: esriFieldTypeDouble
,
alias: CITATION_COUNT
,
editable: true
,
nullable: true
)
-
NOV_COUNT
(
type: esriFieldTypeDouble
,
alias: NOV_COUNT
,
editable: true
,
nullable: true
)
-
WARNING_COUNT
(
type: esriFieldTypeDouble
,
alias: WARNING_COUNT
,
editable: true
,
nullable: true
)
-
BUSINESS_SHUTDOWN_COUNT
(
type: esriFieldTypeDouble
,
alias: BUSINESS_SHUTDOWN_COUNT
,
editable: true
,
nullable: true
)
-
EDUCATION_COUNT
(
type: esriFieldTypeDouble
,
alias: EDUCATION_COUNT
,
editable: true
,
nullable: true
)
-
FULLY_COMPLIANT_COUNT
(
type: esriFieldTypeDouble
,
alias: FULLY_COMPLIANT_COUNT
,
editable: true
,
nullable: true
)
-
REFERRAL_COUNT
(
type: esriFieldTypeDouble
,
alias: REFERRAL_COUNT
,
editable: true
,
nullable: true
)
-
VIOLATION_TYPE_HOURS
(
type: esriFieldTypeString
,
alias: VIOLATION_TYPE_HOURS
,
editable: true
,
nullable: true
,
length: 40
)
-
VIOLATION_TYPE_NO_OPEN
(
type: esriFieldTypeString
,
alias: VIOLATION_TYPE_NO_OPEN
,
editable: true
,
nullable: true
,
length: 40
)
-
VIOLATION_TYPE_50PCT
(
type: esriFieldTypeString
,
alias: VIOLATION_TYPE_50PCT
,
editable: true
,
nullable: true
,
length: 40
)
-
VIOLATION_TYPE_SOCIAL
(
type: esriFieldTypeString
,
alias: VIOLATION_TYPE_SOCIAL
,
editable: true
,
nullable: true
,
length: 40
)
-
VIOLATION_TYPE_OTHERS
(
type: esriFieldTypeString
,
alias: VIOLATION_TYPE_OTHERS
,
editable: true
,
nullable: true
,
length: 40
)
-
RESOLVED
(
type: esriFieldTypeString
,
alias: RESOLVED
,
editable: true
,
nullable: true
,
length: 3
)
-
STREET_NO
(
type: esriFieldTypeString
,
alias: STREET_NO
,
editable: true
,
nullable: true
,
length: 10
)
-
STREET_PRE_DIR
(
type: esriFieldTypeString
,
alias: STREET_PRE_DIR
,
editable: true
,
nullable: true
,
length: 2
)
-
STREET_NAME
(
type: esriFieldTypeString
,
alias: STREET_NAME
,
editable: true
,
nullable: true
,
length: 30
)
-
STREET_SUFFIX
(
type: esriFieldTypeString
,
alias: STREET_SUFFIX
,
editable: true
,
nullable: true
,
length: 4
)
-
STREET_POST_DIR
(
type: esriFieldTypeString
,
alias: STREET_POST_DIR
,
editable: true
,
nullable: true
,
length: 2
)
-
APT_BLDG_UNIT
(
type: esriFieldTypeString
,
alias: APT_BLDG_UNIT
,
editable: true
,
nullable: true
,
length: 6
)
-
STREET_ADDR_UNIT
(
type: esriFieldTypeString
,
alias: STREET_ADDR_UNIT
,
editable: true
,
nullable: true
,
length: 6
)
-
STREET_BLDG_FIRM_SECOND_NAME
(
type: esriFieldTypeString
,
alias: STREET_BLDG_FIRM_SECOND_NAME
,
editable: true
,
nullable: true
,
length: 30
)
-
OBJECTID
(
type: esriFieldTypeOID
,
alias: OBJECTID
,
editable: false
,
nullable: false
)
Templates:
-
Name: GEONAV.COVID_REPORTED_VIOLATION
Description:
Prototype:
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
Drawing Tool: esriFeatureEditToolNone
Capabilities: Query,Extract
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Supported Operations:
Query
Calculate
Validate SQL
Generate Renderer
Return Updates