Name: Business License Types

Display Field: business_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 034d4ff6ba71455da42b5f6c4493a67c

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:

• objectid ( modelName: objectid, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• account_id ( modelName: account_id, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Account_ID, type: esriFieldTypeString )
• business_status ( modelName: business_status, nullable: true, editable: true, defaultValue: N/A, length: 1, alias: Business_Status, type: esriFieldTypeString )
• business_name ( modelName: business_name, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: Business_Name, type: esriFieldTypeString )
• startdate ( modelName: startdate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: StartDate, type: esriFieldTypeDate )
• territory ( modelName: territory, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: Territory, type: esriFieldTypeString )
• jurisdiction ( modelName: jurisdiction, nullable: true, editable: true, defaultValue: N/A, length: 13, alias: Jurisdiction, type: esriFieldTypeString )
• gislayers.sde.BUSINESS_LICENSE_TYPES.area ( modelName: gislayers.sde.BUSINESS_LICENSE_TYPES.area, nullable: true, editable: true, defaultValue: N/A, length: 19, alias: gislayers.sde.BUSINESS_LICENSE_TYPES.area, type: esriFieldTypeString )
• hsn ( modelName: hsn, nullable: true, editable: true, defaultValue: N/A, alias: HSN, type: esriFieldTypeInteger )
• hsn_suffix ( modelName: hsn_suffix, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: HSN_Suffix, type: esriFieldTypeString )
• pre_direction ( modelName: pre_direction, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: Pre_Direction, type: esriFieldTypeString )
• street ( modelName: street, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Street, type: esriFieldTypeString )
• street_type ( modelName: street_type, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: Street_Type, type: esriFieldTypeString )
• post_direction ( modelName: post_direction, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: Post_Direction, type: esriFieldTypeString )
• unit_type ( modelName: unit_type, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: Unit_Type, type: esriFieldTypeString )
• unit ( modelName: unit, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: Unit, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: Zip, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: N/A, length: 4, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: N/A, length: 2, alias: State, type: esriFieldTypeString )
• gis_address_id ( modelName: gis_address_id, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: GIS_Address_ID, type: esriFieldTypeString )
• delinquent ( modelName: DELINQUENT, nullable: false, editable: true, defaultValue: N/A, length: 1, alias: DELINQUENT, type: esriFieldTypeString )
• unfiled ( modelName: UNFILED, nullable: false, editable: true, defaultValue: N/A, length: 1, alias: UNFILED, type: esriFieldTypeString )
• addressid ( modelName: addressid, nullable: true, editable: true, defaultValue: N/A, length: 25, alias: ADDRESSID, type: esriFieldTypeString )
• x_location ( modelName: x_location, nullable: true, editable: true, defaultValue: N/A, alias: X_Location, type: esriFieldTypeDouble )
• y_location ( modelName: y_location, nullable: true, editable: true, defaultValue: N/A, alias: Y_location, type: esriFieldTypeDouble )
• datetime_data_pulled ( modelName: DateTime_Data_Pulled, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: DateTime_Data_Pulled, type: esriFieldTypeDate )
• licensetypecode ( modelName: licensetypecode, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: licensetypecode, type: esriFieldTypeString )
• licensestatus ( modelName: licensestatus, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: licensestatus, type: esriFieldTypeString )
• licensedesc1 ( modelName: licensedesc1, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: licensedesc1, type: esriFieldTypeString )
• licensedesc2 ( modelName: licensedesc2, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: licensedesc2, type: esriFieldTypeString )
• naics_code ( modelName: naics_code, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: naics_code, type: esriFieldTypeString )

Templates:

• Name: Business License Types
  Description:
  Prototype:
  naics_code: null
  hsn: null
  licensedesc1: null
  city: null
  jurisdiction: null
  post_direction: null
  startdate: null
  unit_type: null
  y_location: null
  unfiled:
  street: null
  delinquent:
  state: null
  gislayers.sde.BUSINESS_LICENSE_TYPES.area: null
  zip: null
  gis_address_id: null
  business_name: null
  business_status: null
  pre_direction: null
  licensetypecode: null
  datetime_data_pulled: null
  hsn_suffix: null
  addressid: null
  unit: null
  account_id: null
  licensestatus: null
  street_type: null
  licensedesc2: null
  x_location: null
  territory: 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