Name: Business License Types

Display Field: business_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 034d4ff6ba71455da42b5f6c4493a67c

Copyright Text:

Default Visibility: false

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

Templates:

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