Name: Code Enforcement

Display Field: NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 0ee3b3255c0c423a87c5dfaf302f6c22

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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 Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADDRESS )
• SBL ( type: esriFieldTypeString, alias: SBL, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SBL )
• USE_CODE ( type: esriFieldTypeString, alias: Use Code, editable: true, nullable: true, length: 3, defaultValue: null, modelName: USE_CODE )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OWNER )
• OPEN_CASE ( type: esriFieldTypeString, alias: Open Case, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OPEN_CASE )
• OPEN_CASES ( type: esriFieldTypeSmallInteger, alias: Open Cases, editable: true, nullable: true, defaultValue: null, modelName: OPEN_CASES )
• CASE_TYPE ( type: esriFieldTypeString, alias: Case Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CASE_TYPE )
• CASE_SOURCE ( type: esriFieldTypeString, alias: Case Source, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CASE_SOURCE )
• VACANT ( type: esriFieldTypeString, alias: Vacant, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VACANT )
• OUTSTANDING_VIOLATIONS ( type: esriFieldTypeSmallInteger, alias: Outstanding Violations, editable: true, nullable: true, defaultValue: null, modelName: OUTSTANDING_VIOLATIONS )
• CODE_ENFORCEMENT ( type: esriFieldTypeString, alias: Code Enforcement, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CODE_ENFORCEMENT )
• TOTAL_TICKETS ( type: esriFieldTypeSmallInteger, alias: Total Tickets, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_TICKETS )
• PENDING_FINES ( type: esriFieldTypeString, alias: Pending Fines, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PENDING_FINES )
• FINE_BALANCE ( type: esriFieldTypeSmallInteger, alias: Fine Balance, editable: true, nullable: true, defaultValue: null, modelName: FINE_BALANCE )
• TAX_FORECLOSURE ( type: esriFieldTypeString, alias: Tax Foreclosure, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TAX_FORECLOSURE )
• INSPECTOR_ID ( type: esriFieldTypeString, alias: Inpsector ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: INSPECTOR_ID )
• CASE_NUMBER ( type: esriFieldTypeString, alias: Case Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CASE_NUMBER )
• DEMO_CASE ( type: esriFieldTypeString, alias: Demo Case, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DEMO_CASE )
• PERMIT_CASE ( type: esriFieldTypeString, alias: PERMIT_CASE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PERMIT_CASE )
• CASE_OPEN_DATE ( type: esriFieldTypeString, alias: Case Open Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CASE_OPEN_DATE )
• LAST_TICKET_DATE ( type: esriFieldTypeString, alias: Last Ticket Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LAST_TICKET_DATE )
• VACANT_DATE ( type: esriFieldTypeString, alias: Vacant Date, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VACANT_DATE )
• RUNDATE ( type: esriFieldTypeString, alias: RUNDATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RUNDATE )
• RUNTIME ( type: esriFieldTypeString, alias: RUNTIME, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RUNTIME )
• INSPECTORAREA ( type: esriFieldTypeString, alias: Inpsector Area, editable: true, nullable: true, length: 5, defaultValue: null, modelName: INSPECTORAREA )
• NAME ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NAME )
• PHONE ( type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PHONE )
• EMAIL ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EMAIL )
• NSC ( type: esriFieldTypeString, alias: NSC, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NSC )
• OFFICEADDR ( type: esriFieldTypeString, alias: Office Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: OFFICEADDR )
• CONTSITUA ( type: esriFieldTypeString, alias: CONTSITUA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTSITUA )
• NEWCOMPL ( type: esriFieldTypeString, alias: NEWCOMPL, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NEWCOMPL )

Templates:

• Name: Code Enforcement
  Description:
  Prototype:
  CONTSITUA: null
  NEWCOMPL: null
  ADDRESS: null
  SBL: null
  USE_CODE: null
  OWNER: null
  OPEN_CASE: null
  OPEN_CASES: null
  CASE_TYPE: null
  CASE_SOURCE: null
  VACANT: null
  OUTSTANDING_VIOLATIONS: null
  CODE_ENFORCEMENT: null
  TOTAL_TICKETS: null
  PENDING_FINES: null
  FINE_BALANCE: null
  TAX_FORECLOSURE: null
  INSPECTOR_ID: null
  CASE_NUMBER: null
  DEMO_CASE: null
  PERMIT_CASE: null
  CASE_OPEN_DATE: null
  LAST_TICKET_DATE: null
  VACANT_DATE: null
  RUNDATE: null
  RUNTIME: null
  INSPECTORAREA: null
  NAME: null
  PHONE: null
  EMAIL: null
  NSC: null
  OFFICEADDR: 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:   Field Groups   Contingent Values

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