Name: Case_Main

Display Field: CASE_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 576da40e77a843c7a093f7b549286cad

Copyright Text:

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, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

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: false
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:

Fields:

• PREFIX ( modelName: PREFIX, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: PREFIX, type: esriFieldTypeString )
• YRMO ( modelName: YRMO, nullable: true, editable: true, defaultValue: N/A, alias: YRMO, type: esriFieldTypeDouble )
• SEQ_NO ( modelName: SEQ_NO, nullable: true, editable: true, defaultValue: N/A, alias: SEQ_NO, type: esriFieldTypeDouble )
• CASE_NO ( modelName: CASE_NO, nullable: false, editable: true, defaultValue: N/A, length: 30, alias: CASE_NO, type: esriFieldTypeString )
• CASE_NAME ( modelName: CASE_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: CASE_NAME, type: esriFieldTypeString )
• STARTED ( modelName: STARTED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: STARTED, type: esriFieldTypeDate )
• STARTED_BY ( modelName: STARTED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: STARTED_BY, type: esriFieldTypeString )
• CLOSED ( modelName: CLOSED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: CLOSED, type: esriFieldTypeDate )
• CLOSED_BY ( modelName: CLOSED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: CLOSED_BY, type: esriFieldTypeString )
• LASTACTION ( modelName: LASTACTION, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: LASTACTION, type: esriFieldTypeDate )
• LASTACTION_BY ( modelName: LASTACTION_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: LASTACTION_BY, type: esriFieldTypeString )
• FOLLOWUP ( modelName: FOLLOWUP, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: FOLLOWUP, type: esriFieldTypeDate )
• FOLLOWUP_BY ( modelName: FOLLOWUP_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: FOLLOWUP_BY, type: esriFieldTypeString )
• RECEIVED_BY ( modelName: RECEIVED_BY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: RECEIVED_BY, type: esriFieldTypeString )
• HOW_RECEIVED ( modelName: HOW_RECEIVED, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: HOW_RECEIVED, type: esriFieldTypeString )
• CaseType ( modelName: CaseType, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: CaseType, type: esriFieldTypeString )
• CaseSubType ( modelName: CaseSubType, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: CaseSubType, type: esriFieldTypeString )
• CASE_LOCATION ( modelName: CASE_LOCATION, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: CASE_LOCATION, type: esriFieldTypeString )
• SITE_APN ( modelName: SITE_APN, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SITE_APN, type: esriFieldTypeString )
• SITE_STREETID ( modelName: SITE_STREETID, nullable: true, editable: true, defaultValue: N/A, alias: SITE_STREETID, type: esriFieldTypeInteger )
• SITE_NUMBER ( modelName: SITE_NUMBER, nullable: true, editable: true, defaultValue: N/A, length: 12, alias: SITE_NUMBER, type: esriFieldTypeString )
• SITE_STREETNAME ( modelName: SITE_STREETNAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: SITE_STREETNAME, type: esriFieldTypeString )
• SITE_UNIT_NO ( modelName: SITE_UNIT_NO, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_UNIT_NO, type: esriFieldTypeString )
• SITE_CITY ( modelName: SITE_CITY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: SITE_CITY, type: esriFieldTypeString )
• SITE_STATE ( modelName: SITE_STATE, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: SITE_STATE, type: esriFieldTypeString )
• SITE_ZIP ( modelName: SITE_ZIP, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_ZIP, type: esriFieldTypeString )
• SITE_LOT_NO ( modelName: SITE_LOT_NO, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: SITE_LOT_NO, type: esriFieldTypeString )
• SITE_BLOCK ( modelName: SITE_BLOCK, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_BLOCK, type: esriFieldTypeString )
• SITE_TRACT ( modelName: SITE_TRACT, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SITE_TRACT, type: esriFieldTypeString )
• SITE_SUBDIVISION ( modelName: SITE_SUBDIVISION, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: SITE_SUBDIVISION, type: esriFieldTypeString )
• SITE_DESCRIPTION ( modelName: SITE_DESCRIPTION, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: SITE_DESCRIPTION, type: esriFieldTypeString )
• SITE_ADDR ( modelName: SITE_ADDR, nullable: true, editable: true, defaultValue: N/A, length: 85, alias: SITE_ADDR, type: esriFieldTypeString )
• CODE_SECTION ( modelName: CODE_SECTION, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: CODE_SECTION, type: esriFieldTypeString )
• DESCRIPTION ( modelName: DESCRIPTION, nullable: true, editable: true, defaultValue: N/A, length: 5000, alias: DESCRIPTION, type: esriFieldTypeString )
• ASSIGNED_TO ( modelName: ASSIGNED_TO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: ASSIGNED_TO, type: esriFieldTypeString )
• REFERRED_TO ( modelName: REFERRED_TO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: REFERRED_TO, type: esriFieldTypeString )
• STATUS ( modelName: STATUS, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: STATUS, type: esriFieldTypeString )
• FEES_CHARGED ( modelName: FEES_CHARGED, nullable: true, editable: true, defaultValue: N/A, alias: FEES_CHARGED, type: esriFieldTypeDouble )
• FEES_PAID ( modelName: FEES_PAID, nullable: true, editable: true, defaultValue: N/A, alias: FEES_PAID, type: esriFieldTypeDouble )
• BALANCE_DUE ( modelName: BALANCE_DUE, nullable: true, editable: true, defaultValue: N/A, alias: BALANCE_DUE, type: esriFieldTypeDouble )
• PARENT_PROJECT_NO ( modelName: PARENT_PROJECT_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: PARENT_PROJECT_NO, type: esriFieldTypeString )
• OTHER_DATE1 ( modelName: OTHER_DATE1, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: OTHER_DATE1, type: esriFieldTypeDate )
• OTHER_BY1 ( modelName: OTHER_BY1, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: OTHER_BY1, type: esriFieldTypeString )
• OWNER_NAME ( modelName: OWNER_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: OWNER_NAME, type: esriFieldTypeString )
• RESIDENT_NAME ( modelName: RESIDENT_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: RESIDENT_NAME, type: esriFieldTypeString )
• COMPLAINANT_NAME ( modelName: COMPLAINANT_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: COMPLAINANT_NAME, type: esriFieldTypeString )
• RECORDID ( modelName: RECORDID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: RECORDID, type: esriFieldTypeString )
• LOCKID ( modelName: LOCKID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LOCKID, type: esriFieldTypeString )
• LOC_RECORDID ( modelName: LOC_RECORDID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LOC_RECORDID, type: esriFieldTypeString )
• DEPOSITTYPE ( modelName: DEPOSITTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: DEPOSITTYPE, type: esriFieldTypeString )
• HISTORICAL_APN ( modelName: HISTORICAL_APN, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: HISTORICAL_APN, type: esriFieldTypeString )
• PARENT_PERMIT_NO ( modelName: PARENT_PERMIT_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: PARENT_PERMIT_NO, type: esriFieldTypeString )
• PARENT_BUS_LIC_NO ( modelName: PARENT_BUS_LIC_NO, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: PARENT_BUS_LIC_NO, type: esriFieldTypeString )
• REFERENCE_NO ( modelName: REFERENCE_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: REFERENCE_NO, type: esriFieldTypeString )
• SITE_ALTERNATE_ID ( modelName: SITE_ALTERNATE_ID, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: SITE_ALTERNATE_ID, type: esriFieldTypeString )
• SITE_GEOTYPE ( modelName: SITE_GEOTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: SITE_GEOTYPE, type: esriFieldTypeString )
• Parent_Generic1_ActivityNo ( modelName: Parent_Generic1_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic1_ActivityNo, type: esriFieldTypeString )
• Parent_Generic2_ActivityNo ( modelName: Parent_Generic2_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic2_ActivityNo, type: esriFieldTypeString )
• Parent_Generic3_ActivityNo ( modelName: Parent_Generic3_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic3_ActivityNo, type: esriFieldTypeString )
• Parent_Generic4_ActivityNo ( modelName: Parent_Generic4_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic4_ActivityNo, type: esriFieldTypeString )
• Parent_Generic5_ActivityNo ( modelName: Parent_Generic5_ActivityNo, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: Parent_Generic5_ActivityNo, type: esriFieldTypeString )
• TSstatus ( modelName: TSstatus, nullable: true, editable: true, defaultValue: N/A, alias: TSstatus, type: esriFieldTypeInteger )
• ActivityTypeID ( modelName: ActivityTypeID, nullable: false, editable: true, defaultValue: N/A, alias: ActivityTypeID, type: esriFieldTypeInteger )
• Unique_Key ( modelName: Unique_Key, nullable: true, editable: true, defaultValue: N/A, length: 38, alias: Unique_Key, type: esriFieldTypeGUID )
• RowNum ( modelName: RowNum, nullable: false, editable: false, defaultValue: N/A, alias: RowNum, type: esriFieldTypeOID )

Templates:

• Name: Case_Main
  Description:
  Prototype:
  LASTACTION_BY: null
  STARTED_BY: null
  SITE_DESCRIPTION: null
  RECEIVED_BY: null
  SITE_STREETNAME: null
  STATUS: null
  SITE_STREETID: null
  SITE_ALTERNATE_ID: null
  SITE_TRACT: null
  LOC_RECORDID: null
  Parent_Generic4_ActivityNo: null
  PARENT_BUS_LIC_NO: null
  CODE_SECTION: null
  ActivityTypeID: 0
  ASSIGNED_TO: null
  Parent_Generic1_ActivityNo: null
  RECORDID: null
  FOLLOWUP: null
  LOCKID: null
  LASTACTION: null
  RESIDENT_NAME: null
  Parent_Generic3_ActivityNo: null
  PREFIX: null
  CaseType: null
  CaseSubType: null
  HISTORICAL_APN: null
  SITE_SUBDIVISION: null
  PARENT_PROJECT_NO: null
  COMPLAINANT_NAME: null
  Parent_Generic2_ActivityNo: null
  CLOSED: null
  OTHER_BY1: null
  HOW_RECEIVED: null
  SITE_UNIT_NO: null
  Parent_Generic5_ActivityNo: null
  DEPOSITTYPE: null
  YRMO: null
  SITE_BLOCK: null
  SEQ_NO: null
  CASE_LOCATION: null
  DESCRIPTION: null
  OWNER_NAME: null
  STARTED: null
  CLOSED_BY: null
  FOLLOWUP_BY: null
  Unique_Key: null
  SITE_NUMBER: null
  SITE_LOT_NO: null
  BALANCE_DUE: null
  SITE_STATE: null
  SITE_ADDR: null
  OTHER_DATE1: null
  CASE_NAME: null
  REFERRED_TO: null
  TSstatus: null
  FEES_CHARGED: null
  PARENT_PERMIT_NO: null
  FEES_PAID: null
  SITE_CITY: null
  CASE_NO:
  SITE_GEOTYPE: null
  SITE_ZIP: null
  REFERENCE_NO: null
  SITE_APN: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata