View In:   ArcGIS Online Map Viewer

Name: Trade_License

Display Field: business_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Trade_License

Service Item Id: b6b95e7e879e4d6baa0648cf7acda447

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.401060153655966E7
YMin: 7.450580596923828E-9
XMax: 1.0744880077890076E7
YMax: 5713820.738372497
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [58, 49, 132, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Query With LOD Spatial Reference: true
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• contractor_data ( modelName: contractor_data, nullable: true, editable: true, defaultValue: null, length: 255, alias: contractor_data, type: esriFieldTypeString )
• logos ( modelName: logos, nullable: true, editable: true, defaultValue: null, length: 255, alias: logos, type: esriFieldTypeString )
• cdv_info ( modelName: cdv_info, nullable: true, editable: true, defaultValue: null, length: 255, alias: 121 S Gordy St Ste 202El Dorado, KS 67042316-322-4325, type: esriFieldTypeString )
• license_info ( modelName: license_info, nullable: true, editable: true, defaultValue: null, length: 255, alias: License Information, type: esriFieldTypeString )
• spacer ( modelName: spacer, nullable: true, editable: true, defaultValue: null, length: 255, alias: spacer, type: esriFieldTypeString )
• renewal ( modelName: renewal, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Is this a License Renewal or a New License Application?, type: esriFieldTypeString , Coded Values: [renewal: Renewal] , [new: New Application] )
• business_list ( modelName: business_list, nullable: true, editable: true, defaultValue: null, length: 255, alias: Select your business from the current list of licensed businesses., type: esriFieldTypeString )
• business_point ( modelName: business_point, nullable: true, editable: true, defaultValue: null, length: 255, alias: business_point, type: esriFieldTypeString )
• renewal_year ( modelName: renewal_year, nullable: true, editable: true, defaultValue: null, length: 255, alias: renewal_year, type: esriFieldTypeString )
• license_year ( modelName: license_year, nullable: true, editable: true, defaultValue: null, length: 255, alias: License Year, type: esriFieldTypeString , Coded Values: [2024: 2024] , [2025: 2025] , [2026: 2026] , ...74 more... )
• address_info ( modelName: address_info, nullable: true, editable: true, defaultValue: null, length: 255, alias: Please fill out below address information for mailing and contact purposes., type: esriFieldTypeString )
• business_name ( modelName: business_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Business Name:, type: esriFieldTypeString )
• business_address ( modelName: business_address, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Mailing Address:, type: esriFieldTypeString )
• business_city ( modelName: business_city, nullable: true, editable: true, defaultValue: null, length: 8000, alias: City:, type: esriFieldTypeString )
• business_state ( modelName: business_state, nullable: true, editable: true, defaultValue: null, length: 8000, alias: State:, type: esriFieldTypeString )
• business_zip ( modelName: business_zip, nullable: true, editable: true, defaultValue: null, alias: Zip:, type: esriFieldTypeInteger )
• business_owner ( modelName: business_owner, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Owner's Name:, type: esriFieldTypeString )
• phone ( modelName: phone, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Phone Number:, type: esriFieldTypeString )
• cell_phone ( modelName: cell_phone, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Cell Phone Number:, type: esriFieldTypeString )
• email ( modelName: email, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Email Address:, type: esriFieldTypeString )
• second_email ( modelName: second_email, nullable: true, editable: true, defaultValue: null, length: 255, alias: Secondary Email Address:, type: esriFieldTypeString )
• trade_info ( modelName: trade_info, nullable: true, editable: true, defaultValue: null, length: 255, alias: Please select all of the trades that apply to you., type: esriFieldTypeString )
• plumbing ( modelName: plumbing, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Plumbing - $50, type: esriFieldTypeString , Coded Values: [yes: Plumbing] )
• plumbing_fee ( modelName: plumbing_fee, nullable: true, editable: true, defaultValue: null, length: 255, alias: plumbing_fee, type: esriFieldTypeString )
• electrical ( modelName: electrical, nullable: true, editable: true, defaultValue: null, length: 255, alias: Electrical - $50, type: esriFieldTypeString , Coded Values: [yes: Electrical] )
• electrical_fee ( modelName: electrical_fee, nullable: true, editable: true, defaultValue: null, length: 255, alias: electrical_fee, type: esriFieldTypeString )
• hvac ( modelName: hvac, nullable: true, editable: true, defaultValue: null, length: 255, alias: HVAC - $50, type: esriFieldTypeString , Coded Values: [yes: HVAC] )
• hvac_fee ( modelName: hvac_fee, nullable: true, editable: true, defaultValue: null, length: 255, alias: hvac_fee, type: esriFieldTypeString )
• environmental_installer ( modelName: environmental_installer, nullable: true, editable: true, defaultValue: null, length: 255, alias: Environmental Installer - $50, type: esriFieldTypeString , Coded Values: [yes: Environmental Installer] )
• environmental_fee ( modelName: environmental_fee, nullable: true, editable: true, defaultValue: null, length: 255, alias: environmental_fee, type: esriFieldTypeString )
• general_contractor ( modelName: general_contractor, nullable: true, editable: true, defaultValue: null, length: 255, alias: General Contractor/Any Other Trade - $50, type: esriFieldTypeString , Coded Values: [yes: General Contractor/Any Other Trade] )
• general_contractor_type ( modelName: general_contractor_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Please select all trades that apply, type: esriFieldTypeString )
• general_fee ( modelName: general_fee, nullable: true, editable: true, defaultValue: null, length: 255, alias: general_fee, type: esriFieldTypeString )
• additional_documents ( modelName: additional_documents, nullable: true, editable: true, defaultValue: null, length: 255, alias: Attach any additional documents, type: esriFieldTypeString , Coded Values: [yes: Yes] )
• license_number ( modelName: license_number, nullable: true, editable: true, defaultValue: null, length: 8000, alias: License Number, type: esriFieldTypeString )
• total_fee ( modelName: total_fee, nullable: true, editable: true, defaultValue: null, length: 255, alias: Total Fees, type: esriFieldTypeString )
• insurance ( modelName: insurance, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Insurance, type: esriFieldTypeString )
• insurance_exp ( modelName: insurance_exp, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Insurance Expiration Date:, type: esriFieldTypeDate )
• total_fee_continued ( modelName: total_fee_continued, nullable: true, editable: true, defaultValue: null, length: 255, alias: Total Fees, type: esriFieldTypeString )
• reviewed ( modelName: reviewed, nullable: true, editable: true, defaultValue: null, length: 255, alias: reviewed, type: esriFieldTypeString )
• payment ( modelName: payment, nullable: true, editable: true, defaultValue: null, length: 255, alias: payment, type: esriFieldTypeString )
• delete_record ( modelName: delete_record, nullable: true, editable: true, defaultValue: null, length: 255, alias: delete_record, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )

Templates:

• Name: Trade_License
  Description:
  Prototype:
  additional_documents: null
  insurance: null
  hvac: null
  business_owner: null
  business_address: null
  hvac_fee: null
  general_fee: null
  business_zip: null
  business_city: null
  logos: null
  plumbing_fee: null
  general_contractor: null
  business_point: null
  electrical_fee: null
  total_fee: null
  reviewed: null
  payment: null
  license_year: null
  email: null
  business_name: null
  environmental_installer: null
  address_info: null
  renewal: null
  total_fee_continued: null
  electrical: null
  environmental_fee: null
  delete_record: null
  plumbing: null
  trade_info: null
  general_contractor_type: null
  renewal_year: null
  cell_phone: null
  license_number: null
  cdv_info: null
  contractor_data: null
  license_info: null
  phone: null
  business_list: null
  second_email: null
  spacer: null
  insurance_exp: null
  business_state: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata