Name: License2_Main

Display Field: OWNER_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:

• BALANCE_DUE ( modelName: BALANCE_DUE, nullable: true, editable: true, defaultValue: N/A, alias: BALANCE_DUE, type: esriFieldTypeDouble )
• CHECKBOX1 ( modelName: CHECKBOX1, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX1, type: esriFieldTypeString )
• CHECKBOX2 ( modelName: CHECKBOX2, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX2, type: esriFieldTypeString )
• CHECKBOX3 ( modelName: CHECKBOX3, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX3, type: esriFieldTypeString )
• CHECKBOX4 ( modelName: CHECKBOX4, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX4, type: esriFieldTypeString )
• CHECKBOX5 ( modelName: CHECKBOX5, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX5, type: esriFieldTypeString )
• CHECKBOX6 ( modelName: CHECKBOX6, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX6, type: esriFieldTypeString )
• CHECKBOX7 ( modelName: CHECKBOX7, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX7, type: esriFieldTypeString )
• CHECKBOX8 ( modelName: CHECKBOX8, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: CHECKBOX8, type: esriFieldTypeString )
• COMPANY ( modelName: COMPANY, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: COMPANY, type: esriFieldTypeString )
• COMPANY_PRINT_AS ( modelName: COMPANY_PRINT_AS, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: COMPANY_PRINT_AS, type: esriFieldTypeString )
• DEFAULT_INSPECTOR ( modelName: DEFAULT_INSPECTOR, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: DEFAULT_INSPECTOR, type: esriFieldTypeString )
• DEPOSITTYPE ( modelName: DEPOSITTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: DEPOSITTYPE, type: esriFieldTypeString )
• EMAIL ( modelName: EMAIL, nullable: true, editable: true, defaultValue: N/A, length: 80, alias: EMAIL, type: esriFieldTypeString )
• EMERGENCY ( modelName: EMERGENCY, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: EMERGENCY, type: esriFieldTypeString )
• APPLIED ( modelName: APPLIED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: APPLIED, type: esriFieldTypeDate )
• APPLIED_BY ( modelName: APPLIED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: APPLIED_BY, type: esriFieldTypeString )
• EXPIRED ( modelName: EXPIRED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: EXPIRED, type: esriFieldTypeDate )
• EXPIRED_BY ( modelName: EXPIRED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: EXPIRED_BY, type: esriFieldTypeString )
• FAX ( modelName: FAX, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: FAX, 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 )
• HISTORICAL_APN ( modelName: HISTORICAL_APN, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: HISTORICAL_APN, type: esriFieldTypeString )
• ISSUED ( modelName: ISSUED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: ISSUED, type: esriFieldTypeDate )
• ISSUED_BY ( modelName: ISSUED_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: ISSUED_BY, type: esriFieldTypeString )
• LIAB_CARRIER ( modelName: LIAB_CARRIER, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LIAB_CARRIER, type: esriFieldTypeString )
• LIAB_EXP ( modelName: LIAB_EXP, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: LIAB_EXP, type: esriFieldTypeDate )
• LIAB_ISS ( modelName: LIAB_ISS, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: LIAB_ISS, type: esriFieldTypeDate )
• LIAB_NO ( modelName: LIAB_NO, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LIAB_NO, type: esriFieldTypeString )
• LICENSE_NO ( modelName: LICENSE_NO, nullable: false, editable: true, defaultValue: N/A, length: 30, alias: LICENSE_NO, type: esriFieldTypeString )
• LICENSE_SUBTYPE ( modelName: LICENSE_SUBTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: LICENSE_SUBTYPE, type: esriFieldTypeString )
• LICENSE_TYPE ( modelName: LICENSE_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: LICENSE_TYPE, type: esriFieldTypeString )
• LOC_RECORDID ( modelName: LOC_RECORDID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LOC_RECORDID, type: esriFieldTypeString )
• LOCKID ( modelName: LOCKID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: LOCKID, type: esriFieldTypeString )
• MAIL_ADDRESS1 ( modelName: MAIL_ADDRESS1, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: MAIL_ADDRESS1, type: esriFieldTypeString )
• MAIL_ADDRESS2 ( modelName: MAIL_ADDRESS2, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: MAIL_ADDRESS2, type: esriFieldTypeString )
• MAIL_CITY ( modelName: MAIL_CITY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: MAIL_CITY, type: esriFieldTypeString )
• MAIL_STATE ( modelName: MAIL_STATE, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: MAIL_STATE, type: esriFieldTypeString )
• MAIL_ZIP ( modelName: MAIL_ZIP, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: MAIL_ZIP, type: esriFieldTypeString )
• MAINTEXTFIELD1 ( modelName: MAINTEXTFIELD1, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD1, type: esriFieldTypeString )
• MAINTEXTFIELD2 ( modelName: MAINTEXTFIELD2, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD2, type: esriFieldTypeString )
• MAINTEXTFIELD3 ( modelName: MAINTEXTFIELD3, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD3, type: esriFieldTypeString )
• MAINTEXTFIELD4 ( modelName: MAINTEXTFIELD4, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD4, type: esriFieldTypeString )
• MAINTEXTFIELD5 ( modelName: MAINTEXTFIELD5, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD5, type: esriFieldTypeString )
• MAINTEXTFIELD6 ( modelName: MAINTEXTFIELD6, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD6, type: esriFieldTypeString )
• MAINTEXTFIELD7 ( modelName: MAINTEXTFIELD7, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD7, type: esriFieldTypeString )
• MAINTEXTFIELD8 ( modelName: MAINTEXTFIELD8, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MAINTEXTFIELD8, type: esriFieldTypeString )
• NOTES ( modelName: NOTES, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: NOTES, type: esriFieldTypeString )
• OWNER_NAME ( modelName: OWNER_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: OWNER_NAME, type: esriFieldTypeString )
• PARENT_RECORDID ( modelName: PARENT_RECORDID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: PARENT_RECORDID, type: esriFieldTypeString )
• PHONE ( modelName: PHONE, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: PHONE, type: esriFieldTypeString )
• PREFIX ( modelName: PREFIX, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: PREFIX, type: esriFieldTypeString )
• RECORDID ( modelName: RECORDID, nullable: false, editable: true, defaultValue: N/A, length: 30, alias: RECORDID, type: esriFieldTypeString )
• REFERENCE_NO ( modelName: REFERENCE_NO, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: REFERENCE_NO, type: esriFieldTypeString )
• SEQ_NO ( modelName: SEQ_NO, nullable: true, editable: true, defaultValue: N/A, alias: SEQ_NO, type: esriFieldTypeDouble )
• SIC_2 ( modelName: SIC_2, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SIC_2, type: esriFieldTypeString )
• SIC_3 ( modelName: SIC_3, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SIC_3, 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_APN ( modelName: SITE_APN, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SITE_APN, type: esriFieldTypeString )
• SITE_BLOCK ( modelName: SITE_BLOCK, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_BLOCK, type: esriFieldTypeString )
• SITE_CITY ( modelName: SITE_CITY, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: SITE_CITY, type: esriFieldTypeString )
• SITE_DESCRIPTION ( modelName: SITE_DESCRIPTION, nullable: true, editable: true, defaultValue: N/A, length: 2000, alias: SITE_DESCRIPTION, type: esriFieldTypeString )
• SITE_GEOTYPE ( modelName: SITE_GEOTYPE, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: SITE_GEOTYPE, 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_NUMBER ( modelName: SITE_NUMBER, nullable: true, editable: true, defaultValue: N/A, length: 12, alias: SITE_NUMBER, type: esriFieldTypeString )
• SITE_STATE ( modelName: SITE_STATE, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: SITE_STATE, type: esriFieldTypeString )
• SITE_STREETID ( modelName: SITE_STREETID, nullable: true, editable: true, defaultValue: N/A, alias: SITE_STREETID, type: esriFieldTypeInteger )
• SITE_STREETNAME ( modelName: SITE_STREETNAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: SITE_STREETNAME, type: esriFieldTypeString )
• SITE_SUBDIVISION ( modelName: SITE_SUBDIVISION, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: SITE_SUBDIVISION, type: esriFieldTypeString )
• SITE_TRACT ( modelName: SITE_TRACT, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: SITE_TRACT, 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_ZIP ( modelName: SITE_ZIP, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: SITE_ZIP, type: esriFieldTypeString )
• ST_LIC_EXP ( modelName: ST_LIC_EXP, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: ST_LIC_EXP, type: esriFieldTypeDate )
• ST_LIC_ISS ( modelName: ST_LIC_ISS, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: ST_LIC_ISS, type: esriFieldTypeDate )
• STATUS ( modelName: STATUS, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: STATUS, type: esriFieldTypeString )
• STATUS_BY ( modelName: STATUS_BY, nullable: true, editable: true, defaultValue: N/A, length: 6, alias: STATUS_BY, type: esriFieldTypeString )
• TAG ( modelName: TAG, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: TAG, type: esriFieldTypeString )
• TEXTFIELD1 ( modelName: TEXTFIELD1, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD1, type: esriFieldTypeString )
• TEXTFIELD2 ( modelName: TEXTFIELD2, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD2, type: esriFieldTypeString )
• TEXTFIELD3 ( modelName: TEXTFIELD3, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD3, type: esriFieldTypeString )
• TEXTFIELD4 ( modelName: TEXTFIELD4, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD4, type: esriFieldTypeString )
• TEXTFIELD5 ( modelName: TEXTFIELD5, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD5, type: esriFieldTypeString )
• TEXTFIELD6 ( modelName: TEXTFIELD6, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD6, type: esriFieldTypeString )
• TEXTFIELD7 ( modelName: TEXTFIELD7, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD7, type: esriFieldTypeString )
• TEXTFIELD8 ( modelName: TEXTFIELD8, nullable: true, editable: true, defaultValue: N/A, length: 24, alias: TEXTFIELD8, type: esriFieldTypeString )
• W_COMP_EXP ( modelName: W_COMP_EXP, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: W_COMP_EXP, type: esriFieldTypeDate )
• W_COMP_ISS ( modelName: W_COMP_ISS, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: W_COMP_ISS, type: esriFieldTypeDate )
• W_COMP_NO ( modelName: W_COMP_NO, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: W_COMP_NO, type: esriFieldTypeString )
• WRKR_COMP ( modelName: WRKR_COMP, nullable: true, editable: true, defaultValue: N/A, length: 26, alias: WRKR_COMP, type: esriFieldTypeString )
• YRMO ( modelName: YRMO, nullable: true, editable: true, defaultValue: N/A, alias: YRMO, type: esriFieldTypeDouble )
• SITE_ADDR ( modelName: SITE_ADDR, nullable: true, editable: true, defaultValue: N/A, length: 85, alias: SITE_ADDR, type: esriFieldTypeString )
• OWNERSHIP_TYPE ( modelName: OWNERSHIP_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: OWNERSHIP_TYPE, type: esriFieldTypeString )
• RESALE_ID ( modelName: RESALE_ID, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: RESALE_ID, type: esriFieldTypeString )
• SIC_1 ( modelName: SIC_1, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: SIC_1, type: esriFieldTypeString )
• INVOICE_DATE ( modelName: INVOICE_DATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: INVOICE_DATE, type: esriFieldTypeDate )
• PHONE_EXT ( modelName: PHONE_EXT, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: PHONE_EXT, 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 )
• TAX_ID ( modelName: TAX_ID, nullable: true, editable: true, defaultValue: N/A, alias: TAX_ID, type: esriFieldTypeBlob )
• 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: License2_Main
  Description:
  Prototype:
  TEXTFIELD3: null
  TEXTFIELD4: null
  INVOICE_DATE: null
  SITE_STREETNAME: null
  TEXTFIELD1: null
  TEXTFIELD2: null
  MAINTEXTFIELD3: null
  MAINTEXTFIELD2: null
  MAINTEXTFIELD1: null
  SITE_TRACT: null
  TEXTFIELD7: null
  TEXTFIELD8: null
  TEXTFIELD5: null
  TEXTFIELD6: null
  CHECKBOX1: null
  RECORDID:
  CHECKBOX2: null
  COMPANY: null
  CHECKBOX3: null
  CHECKBOX4: null
  LIAB_ISS: null
  CHECKBOX5: null
  MAIL_STATE: null
  CHECKBOX6: null
  CHECKBOX7: null
  CHECKBOX8: null
  EMERGENCY: null
  DEFAULT_INSPECTOR: null
  PHONE_EXT: null
  APPLIED_BY: null
  ISSUED_BY: null
  W_COMP_NO: null
  YRMO: null
  LIAB_CARRIER: null
  SITE_BLOCK: null
  SEQ_NO: null
  OWNER_NAME: null
  SITE_LOT_NO: null
  TAX_ID: null
  BALANCE_DUE: null
  ST_LIC_EXP: null
  SITE_STATE: null
  TSstatus: null
  MAIL_ZIP: null
  FEES_PAID: null
  SITE_CITY: null
  W_COMP_ISS: null
  STATUS_BY: null
  TAG: null
  REFERENCE_NO: null
  OWNERSHIP_TYPE: null
  MAIL_CITY: null
  LICENSE_NO:
  MAIL_ADDRESS2: null
  MAIL_ADDRESS1: null
  EMAIL: null
  SITE_DESCRIPTION: null
  SIC_3: null
  STATUS: null
  SIC_2: null
  SITE_STREETID: null
  SITE_ALTERNATE_ID: null
  LICENSE_TYPE: null
  LOC_RECORDID: null
  COMPANY_PRINT_AS: null
  LIAB_EXP: null
  ActivityTypeID: 0
  ST_LIC_ISS: null
  SIC_1: null
  LOCKID: null
  WRKR_COMP: null
  LICENSE_SUBTYPE: null
  PREFIX: null
  HISTORICAL_APN: null
  SITE_SUBDIVISION: null
  SITE_UNIT_NO: null
  EXPIRED: null
  PHONE: null
  PARENT_RECORDID: null
  DEPOSITTYPE: null
  NOTES: null
  Unique_Key: null
  SITE_NUMBER: null
  LIAB_NO: null
  APPLIED: null
  EXPIRED_BY: null
  ISSUED: null
  SITE_ADDR: null
  MAINTEXTFIELD8: null
  MAINTEXTFIELD7: null
  FEES_CHARGED: null
  MAINTEXTFIELD6: null
  MAINTEXTFIELD5: null
  MAINTEXTFIELD4: null
  SITE_GEOTYPE: null
  SITE_ZIP: null
  W_COMP_EXP: null
  FAX: null
  RESALE_ID: 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