Name: LL_EXPIRED

Display Field: BUSINESSNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Pima County's active, pending, inactive, terminated and seasonal liquor licenses from the Arizona Department of Liquor Licenses and Control. Known Errors/Qualifications: Locations outside City of Tucson are approximate. Lineage: Sep 21, 2010 - published to MARS folder (B. Enright) Feb 24, 2010 - publised to vectorsde (B. Enright) Spatial Domain: Eastern Pima County Rectified: orthophoto2005 Maintenance Organization: n Maintenance Description: Data is downloaded daily from http://www.azliquor.gov/query/query.html and filtered for Pima County addresses with specific license statuses. The feature class is created by geocoding the downloaded table with ADPARCEL and unmatched addresses are captured for review. The unmatched addresses are assigned "best-fit" addresses and added to the PLACENAMESTABLE for future use. Maintenance Format: Shape Primary Source Organization: City of Tucson Primary Source Contact: Bryn Enright Primary Source Document: liquorlc.shp Primary Source Date: 20080109 Primary Source Scale: 24000 Primary Source Format: Shape GIS Contact: Jeff McConnell

Copyright Text: Pima County Information Technology Department - Geographic Information Systems 201 N Stone Ave., 9th Floor Tucson, AZ 85701

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3000000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 404700.94324146956
YMin: 180184.91830708832
XMax: 1079976.7457349077
YMax: 689078.8218503967
Spatial Reference: 2868  (2868)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LICENSESTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Terminated/Other
UniqueValueInfos:
• Value: Expired
  Label: Expired
  Description: N/A
  Symbol:
  
• Value: Inactive
  Label: Inactive
  Description: N/A
  Symbol:
  
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LICENSENO ( type: esriFieldTypeString, alias: LICENSENO, length: 25 )
• LICENSESTATUS ( type: esriFieldTypeString, alias: LICENSESTATUS, length: 25 )
• BUSINESSNAME ( type: esriFieldTypeString, alias: BUSINESSNAME, length: 100 )
• BUSINESSADDRESS ( type: esriFieldTypeString, alias: BUSINESSADDRESS, length: 100 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 50 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 2 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 10 )
• LICENSEELASTNAME ( type: esriFieldTypeString, alias: LICENSEELASTNAME, length: 100 )
• LICENSEEFIRSTNAME ( type: esriFieldTypeString, alias: LICENSEEFIRSTNAME, length: 100 )
• BUSINESSPHONE ( type: esriFieldTypeString, alias: BUSINESSPHONE, length: 25 )
• OWNERNAME ( type: esriFieldTypeString, alias: OWNERNAME, length: 100 )
• EXPIRATIONDATE ( type: esriFieldTypeDate, alias: EXPIRATIONDATE, length: 8 )
• ISSUEDDATE ( type: esriFieldTypeDate, alias: ISSUEDDATE, length: 8 )
• STATUSDATE ( type: esriFieldTypeDate, alias: STATUSDATE, length: 8 )
• IPEXPIRATIONDATE ( type: esriFieldTypeDate, alias: IPEXPIRATIONDATE, length: 8 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 25 )
• LICENSETYPE ( type: esriFieldTypeString, alias: LICENSETYPE, length: 25 )
• MATCHEDADDRESS ( type: esriFieldTypeString, alias: MATCHEDADDRESS, length: 100 )
• DATASOURCE ( type: esriFieldTypeString, alias: DATASOURCE, length: 50 )
• ADDRESSMATCHED ( type: esriFieldTypeString, alias: ADDRESSMATCHED, length: 100 )
• ADDRESSFULL ( type: esriFieldTypeString, alias: ADDRESSFULL, length: 100 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• license ( type: esriFieldTypeString, alias: license, length: 255 )
• status ( type: esriFieldTypeString, alias: status, length: 255 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata