View In:   ArcGIS Online Map Viewer

Name: LIQUOR_LICENSES

Display Field: LICENSE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4b1a23083b8144349ba3d73e558cddbc

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

Supports Datum Transformation: true

Extent:

XMin: 1567652.3800553307
YMin: 14000.714764155447
XMax: 1703803.8725155778
YMax: 142050.59350640327
Spatial Reference: 102664  (102664)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [31, 130, 102, 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: 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

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• LICENSE ( type: esriFieldTypeString, alias: LICENSE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LICENSE )
• DBA ( type: esriFieldTypeString, alias: DBA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DBA )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CATEGORY , Coded Values: [Standard Bar: Standard Bar] , [Live Entertainment: Live Entertainment] , [Live Entertainment w/ Dancing: Live Entertainment w/ Dancing] , ...3 more... )
• KIND ( type: esriFieldTypeString, alias: KIND, editable: true, nullable: true, length: 254, defaultValue: null, modelName: KIND , Coded Values: [Beer: Beer] , [Wine: Wine] , [Beer and Wine: Beer and Wine] , ...7 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION )
• TOWN ( type: esriFieldTypeString, alias: TOWN, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TOWN )
• CONDITIONS ( type: esriFieldTypeString, alias: CONDITIONS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CONDITIONS )
• LICENSEE ( type: esriFieldTypeString, alias: LICENSEE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LICENSEE )
• MAILING ( type: esriFieldTypeString, alias: MAILING, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MAILING )
• FEE ( type: esriFieldTypeInteger, alias: FEE, editable: true, nullable: true, defaultValue: null, modelName: FEE )
• HI_GE ( type: esriFieldTypeString, alias: HI_GE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: HI_GE )
• CLASS ( type: esriFieldTypeString, alias: License Classification, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CLASS , Coded Values: [Manufacturer: Manufacturer] , [Restaurant: Restaurant] , [Wholesale Dealer: Wholesale Dealer] , ...13 more... )
• LicRecID ( type: esriFieldTypeInteger, alias: Record ID, editable: true, nullable: true, defaultValue: null, modelName: LicRecID )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Inactive: Inactive] )
• IssueDate ( type: esriFieldTypeDate, alias: Issue Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IssueDate )
• ExpirationDate ( type: esriFieldTypeDate, alias: Expiration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ExpirationDate )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 50, defaultValue: null, modelName: District , Coded Values: [Hanalei: Hanalei] , [Lihue: Lihue] , [Kawaihau: Kawaihau] , ...2 more... )
• PremiseAddress1 ( type: esriFieldTypeString, alias: Location Address 1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PremiseAddress1 )
• PremiseAddress2 ( type: esriFieldTypeString, alias: Location Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PremiseAddress2 )
• PremiseCity ( type: esriFieldTypeString, alias: Location City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PremiseCity )
• PremiseState ( type: esriFieldTypeString, alias: Location State, editable: true, nullable: true, length: 2, defaultValue: HI, modelName: PremiseState )
• PremiseZip ( type: esriFieldTypeString, alias: Location Zip, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PremiseZip )
• MailingAddress1 ( type: esriFieldTypeString, alias: Mailing Address 1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MailingAddress1 )
• MailingAddress2 ( type: esriFieldTypeString, alias: Mailing Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MailingAddress2 )
• MailingCity ( type: esriFieldTypeString, alias: Mailing City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MailingCity )
• MailingState ( type: esriFieldTypeString, alias: Mailing State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MailingState )
• MailingZip ( type: esriFieldTypeString, alias: Mailing Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MailingZip )
• MailingCountry ( type: esriFieldTypeString, alias: Mailing Country, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MailingCountry )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: FID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LicenseeRiskPriority ( type: esriFieldTypeString, alias: Risk Priority, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LicenseeRiskPriority , Coded Values: [Priority 1: Priority 1] , [Priority 2: Priority 2] , [Priority 3: Priority 3] )
• LicenseeRiskPriorityDate ( type: esriFieldTypeDate, alias: Risk Last Updated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LicenseeRiskPriorityDate )
• LicenseeEmail ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LicenseeEmail )
• LicenseePhone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LicenseePhone )

Templates:

• Name: LIQUOR_LICENSES
  Description:
  Prototype:
  PremiseCity: null
  LicenseeEmail: null
  LICENSE: null
  DBA: null
  CATEGORY: null
  KIND: null
  LOCATION: null
  TOWN: null
  CONDITIONS: null
  LICENSEE: null
  MAILING: null
  FEE: null
  HI_GE: null
  CLASS: null
  LicRecID: null
  Status: null
  IssueDate: null
  ExpirationDate: null
  District: null
  PremiseAddress1: null
  PremiseAddress2: null
  PremiseState: HI
  PremiseZip: null
  MailingAddress1: null
  MailingAddress2: null
  MailingCity: null
  MailingState: null
  MailingZip: null
  MailingCountry: null
  LicenseeRiskPriorityDate: null
  LicenseeRiskPriority: null
  LicenseePhone: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: 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: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata