Name: Case_Main
Display Field: CASE_NAME
Type: Table
Geometry Type: N/A
Description: N/A
Service Item Id: 6c3db0d094bc4f2fb7fbe977b6cb5ca4
Copyright Text: N/A
Default Visibility: false
Max Result Window: N/A
Max Record Count: 2000
Standard Max Record Count No Geometry: N/A
Max Record Count Factor: 1
Standard MaxRecord Count: 32000
Tile Max Record Count: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Feature Draw Order:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true
HasZ: false
HasM: false
Has Attachments: false
Has Last Edit Time: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: N/A
Fields:
-
PREFIX
(
nullable: true, length: 6, alias: PREFIX, type: esriFieldTypeString
)
-
YRMO
(
nullable: true, alias: YRMO, type: esriFieldTypeDouble
)
-
SEQ_NO
(
nullable: true, alias: SEQ_NO, type: esriFieldTypeDouble
)
-
CASE_NO
(
nullable: false, length: 30, alias: CASE_NO, type: esriFieldTypeString
)
-
CASE_NAME
(
nullable: true, length: 60, alias: CASE_NAME, type: esriFieldTypeString
)
-
STARTED
(
nullable: true, length: 8, alias: STARTED, type: esriFieldTypeDate
)
-
STARTED_BY
(
nullable: true, length: 6, alias: STARTED_BY, type: esriFieldTypeString
)
-
CLOSED
(
nullable: true, length: 8, alias: CLOSED, type: esriFieldTypeDate
)
-
CLOSED_BY
(
nullable: true, length: 6, alias: CLOSED_BY, type: esriFieldTypeString
)
-
LASTACTION
(
nullable: true, length: 8, alias: LASTACTION, type: esriFieldTypeDate
)
-
LASTACTION_BY
(
nullable: true, length: 6, alias: LASTACTION_BY, type: esriFieldTypeString
)
-
FOLLOWUP
(
nullable: true, length: 8, alias: FOLLOWUP, type: esriFieldTypeDate
)
-
FOLLOWUP_BY
(
nullable: true, length: 6, alias: FOLLOWUP_BY, type: esriFieldTypeString
)
-
RECEIVED_BY
(
nullable: true, length: 30, alias: RECEIVED_BY, type: esriFieldTypeString
)
-
HOW_RECEIVED
(
nullable: true, length: 30, alias: HOW_RECEIVED, type: esriFieldTypeString
)
-
CaseType
(
nullable: true, length: 60, alias: CaseType, type: esriFieldTypeString
)
-
CaseSubType
(
nullable: true, length: 60, alias: CaseSubType, type: esriFieldTypeString
)
-
CASE_LOCATION
(
nullable: true, length: 100, alias: CASE_LOCATION, type: esriFieldTypeString
)
-
SITE_APN
(
nullable: true, length: 50, alias: SITE_APN, type: esriFieldTypeString
)
-
SITE_STREETID
(
nullable: true, alias: SITE_STREETID, type: esriFieldTypeInteger
)
-
SITE_NUMBER
(
nullable: true, length: 12, alias: SITE_NUMBER, type: esriFieldTypeString
)
-
SITE_STREETNAME
(
nullable: true, length: 60, alias: SITE_STREETNAME, type: esriFieldTypeString
)
-
SITE_UNIT_NO
(
nullable: true, length: 10, alias: SITE_UNIT_NO, type: esriFieldTypeString
)
-
SITE_CITY
(
nullable: true, length: 30, alias: SITE_CITY, type: esriFieldTypeString
)
-
SITE_STATE
(
nullable: true, length: 2, alias: SITE_STATE, type: esriFieldTypeString
)
-
SITE_ZIP
(
nullable: true, length: 10, alias: SITE_ZIP, type: esriFieldTypeString
)
-
SITE_LOT_NO
(
nullable: true, length: 20, alias: SITE_LOT_NO, type: esriFieldTypeString
)
-
SITE_BLOCK
(
nullable: true, length: 10, alias: SITE_BLOCK, type: esriFieldTypeString
)
-
SITE_TRACT
(
nullable: true, length: 50, alias: SITE_TRACT, type: esriFieldTypeString
)
-
SITE_SUBDIVISION
(
nullable: true, length: 100, alias: SITE_SUBDIVISION, type: esriFieldTypeString
)
-
SITE_DESCRIPTION
(
nullable: true, length: 2000, alias: SITE_DESCRIPTION, type: esriFieldTypeString
)
-
SITE_ADDR
(
nullable: true, length: 85, alias: SITE_ADDR, type: esriFieldTypeString
)
-
CODE_SECTION
(
nullable: true, length: 30, alias: CODE_SECTION, type: esriFieldTypeString
)
-
DESCRIPTION
(
nullable: true, length: 5000, alias: DESCRIPTION, type: esriFieldTypeString
)
-
ASSIGNED_TO
(
nullable: true, length: 30, alias: ASSIGNED_TO, type: esriFieldTypeString
)
-
REFERRED_TO
(
nullable: true, length: 30, alias: REFERRED_TO, type: esriFieldTypeString
)
-
STATUS
(
nullable: true, length: 60, alias: STATUS, type: esriFieldTypeString
)
-
FEES_CHARGED
(
nullable: true, alias: FEES_CHARGED, type: esriFieldTypeDouble
)
-
FEES_PAID
(
nullable: true, alias: FEES_PAID, type: esriFieldTypeDouble
)
-
BALANCE_DUE
(
nullable: true, alias: BALANCE_DUE, type: esriFieldTypeDouble
)
-
PARENT_PROJECT_NO
(
nullable: true, length: 30, alias: PARENT_PROJECT_NO, type: esriFieldTypeString
)
-
OTHER_DATE1
(
nullable: true, length: 8, alias: OTHER_DATE1, type: esriFieldTypeDate
)
-
OTHER_BY1
(
nullable: true, length: 6, alias: OTHER_BY1, type: esriFieldTypeString
)
-
OWNER_NAME
(
nullable: true, length: 60, alias: OWNER_NAME, type: esriFieldTypeString
)
-
RESIDENT_NAME
(
nullable: true, length: 60, alias: RESIDENT_NAME, type: esriFieldTypeString
)
-
COMPLAINANT_NAME
(
nullable: true, length: 60, alias: COMPLAINANT_NAME, type: esriFieldTypeString
)
-
RECORDID
(
nullable: true, length: 30, alias: RECORDID, type: esriFieldTypeString
)
-
LOCKID
(
nullable: true, length: 30, alias: LOCKID, type: esriFieldTypeString
)
-
LOC_RECORDID
(
nullable: true, length: 30, alias: LOC_RECORDID, type: esriFieldTypeString
)
-
DEPOSITTYPE
(
nullable: true, length: 60, alias: DEPOSITTYPE, type: esriFieldTypeString
)
-
HISTORICAL_APN
(
nullable: true, length: 50, alias: HISTORICAL_APN, type: esriFieldTypeString
)
-
PARENT_PERMIT_NO
(
nullable: true, length: 30, alias: PARENT_PERMIT_NO, type: esriFieldTypeString
)
-
PARENT_BUS_LIC_NO
(
nullable: true, length: 20, alias: PARENT_BUS_LIC_NO, type: esriFieldTypeString
)
-
REFERENCE_NO
(
nullable: true, length: 30, alias: REFERENCE_NO, type: esriFieldTypeString
)
-
SITE_ALTERNATE_ID
(
nullable: true, length: 40, alias: SITE_ALTERNATE_ID, type: esriFieldTypeString
)
-
SITE_GEOTYPE
(
nullable: true, length: 60, alias: SITE_GEOTYPE, type: esriFieldTypeString
)
-
Parent_Generic1_ActivityNo
(
nullable: true, length: 15, alias: Parent_Generic1_ActivityNo, type: esriFieldTypeString
)
-
Parent_Generic2_ActivityNo
(
nullable: true, length: 15, alias: Parent_Generic2_ActivityNo, type: esriFieldTypeString
)
-
Parent_Generic3_ActivityNo
(
nullable: true, length: 15, alias: Parent_Generic3_ActivityNo, type: esriFieldTypeString
)
-
Parent_Generic4_ActivityNo
(
nullable: true, length: 15, alias: Parent_Generic4_ActivityNo, type: esriFieldTypeString
)
-
Parent_Generic5_ActivityNo
(
nullable: true, length: 15, alias: Parent_Generic5_ActivityNo, type: esriFieldTypeString
)
-
TSstatus
(
nullable: true, alias: TSstatus, type: esriFieldTypeInteger
)
-
ActivityTypeID
(
nullable: false, alias: ActivityTypeID, type: esriFieldTypeInteger
)
-
Unique_Key
(
nullable: true, length: 38, alias: Unique_Key, type: esriFieldTypeGUID
)
-
RowNum
(
nullable: false, alias: RowNum, type: esriFieldTypeOID
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata