{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 17, "name": "LL_EXPIRED", "type": "Feature Layer", "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", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2868, "latestWkid": 2868, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17746700, "falseY": -44067300, "xyUnits": 3048, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "Pima County Information Technology Department - Geographic Information Systems\n201 N Stone Ave., 9th Floor\nTucson, AZ 85701", "parentLayer": null, "subLayers": [], "minScale": 3000000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "LICENSESTATUS", "defaultSymbol": { "type": "esriPMS", "url": "cb707240c7434d33e501e8a3a6807753", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABbUlEQVRIid3Uu4oiQRTG8f+xRlsM1MxLYuCFlhE2MpLeF5kX2EeZV9h4n2TSCkQmURMvKCJt0i0IJdrlJrswM9jq9DDBzJcVxfcLijrnjk/M3ffAJ5PJH2PMT0DeC4lIlMvlftdqtcezeBiGD4vF4t3w/7Tb7V/Aedxamxj+10+9PMe+eblcplQqXQXn8zlBEJy9i8U3mw2tVotCoRALr1arWPgiHkURWms8zyObzQJwOBzY7XYUi0WCIGAwGMTCF3EAYwxaa3q9HkopZrMZ0+kUz/PQWhNFUXIcIAxD+v0+3W6Xer1OpVJBa81+v79WvW2I1us1o9EI13UZDodst9tbardPqO/7uK6L7/u3Vr7LbnmbTCZDs9lERHAcB4BOp4O1luPxyHg85nQ6JcNTqRTpdBoRwVrLcrlEKYVSChFBRJLjxpirg3Ipr3CRD+2ty3g+n3+uVqv3JNjnwMlxnKdYvNFo/EiAxubr/vO/BaqDrfSVZYMAAAAASUVORK5CYII=", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "Terminated/Other", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "0056557dc26214bf43f010ba44ab8700", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABvUlEQVRIid3UXUhTYRzH8e953Bza8gUDGUIQaYnh9MqGuTAUIrvyQsgMYV6J0IVe+3KpSOBNXYQKglJXiyJ1IHSRS4IsLV9gB2HKlI1qJHMqvuzsdCFBk51tZ+FF/u4envP7PHB4nr+BM4zhfOCLH96M72z/vK2CpBeShFDyCyzPrbZ7A3Fxv09uWfk0oxv+E/v9tnYgPh5VlLThk35E/L3W/Ocl5be4WnYzKfjt4zQBnyfunia+IX+h+u4jCouKNWH56yyBTVlzXxM/PjrAOdxDa+dTzLkFABzsh9kO+rFcvk7AJzP1YhBUVT8OsBsK4hzp4eHjIYyZJhbn3rLgfk1r1zNejfQSOT5MVE9+z79vrTE50U+jo4+qO01cs9bgHO5mL/wrWTW1R7S2PIfbNYa9wcHs5Cg//N5Uaqm/0HXPPPYGB17PfKqV8zJbTifbnIutvhkhDGRfzAOgrrGDqKJwdLiP2zWGGo2mh4sMI6YsM0IYUCIRVj+/w5iZBYAkBJIkUEkT3w0Fcb18kuiThInBpX8aWyBJMXMrFr9kubJUWll7Q0XVfYwQGeqFnLz3mrit7kGFXjRR/t97/hu8BIXNfoxTkgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Expired", "label": "Expired" }, { "symbol": { "type": "esriPMS", "url": "6e6c5ff33f5c918144abec79afadb855", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABfklEQVRIid3Uu04CQRTG8f8sC1kvGHUlmqBCTGzUiFJYWlia+AS+gI/iK1j7GjQaWy1MwFtMIFlB5aoryGV3x4ZCDbvCRgv5usnM+RUnc47KH0YdDrySzxx3Wo1tIaUYWBKKHRqZOJqcWz7siTfN8v7L093gcDeRWPIA6I1L6fiGASSO8vns2vOwHmNsev5HsPZ4S9Ms9rxzxeu1B/TFBNq47gqbpawr7Ik7toWRThHf3EMNjQJgWy067yZaeIamWSJ/c+oKe+IAVruBkU6xmNhFUVRqhWuq+StiG3sYmRTSsf3jAM23MoXrU6IrO0xH1wjrMYx0Cqv9/lNpf0NklnMUsxdE4kmes+e06pV+yvqf0HrVIBJPUq8+9FsyLLvlewJBDX1hHSEU1KAGwOzSFlJKHLtDMXcBUvrDhVAIqCGEUJDS4fX5HiUQ7N4JBAKJT9xqNyjcnnk98cyv9lzwZW99xbWxqUsi8VXAzz6XgaB24orrC+uJgVGP/N9//gGqHoLhL23FEQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Inactive", "label": "Inactive" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 239, 197, 255 ], "toColor": [ 252, 239, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 212, 179, 252, 255 ], "toColor": [ 212, 179, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 249, 252, 255 ], "toColor": [ 184, 249, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 187, 202, 255 ], "toColor": [ 252, 187, 202, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 183, 255 ], "toColor": [ 179, 252, 183, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 207, 252, 255 ], "toColor": [ 179, 207, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 207, 252, 218, 255 ], "toColor": [ 207, 252, 218, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 210, 252, 255 ], "toColor": [ 235, 210, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 244, 255 ], "toColor": [ 252, 184, 244, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 217, 207, 255 ], "toColor": [ 252, 217, 207, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 237, 252, 187, 255 ], "toColor": [ 237, 252, 187, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 234, 252, 255 ], "toColor": [ 210, 234, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 189, 227, 255 ], "toColor": [ 252, 189, 227, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 404700.94324146956, "ymin": 180184.91830708832, "xmax": 1079976.7457349077, "ymax": 689078.8218503967, "spatialReference": { "wkid": 2868, "latestWkid": 2868, "xyTolerance": 0.0032808398950131233, "zTolerance": 2, "mTolerance": 0.001, "falseX": -17746700, "falseY": -44067300, "xyUnits": 1.3725486072514725E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "BUSINESSNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LICENSENO", "type": "esriFieldTypeString", "alias": "LICENSENO", "length": 25, "domain": null }, { "name": "LICENSESTATUS", "type": "esriFieldTypeString", "alias": "LICENSESTATUS", "length": 25, "domain": null }, { "name": "BUSINESSNAME", "type": "esriFieldTypeString", "alias": "BUSINESSNAME", "length": 100, "domain": null }, { "name": "BUSINESSADDRESS", "type": "esriFieldTypeString", "alias": "BUSINESSADDRESS", "length": 100, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 50, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 2, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 10, "domain": null }, { "name": "LICENSEELASTNAME", "type": "esriFieldTypeString", "alias": "LICENSEELASTNAME", "length": 100, "domain": null }, { "name": "LICENSEEFIRSTNAME", "type": "esriFieldTypeString", "alias": "LICENSEEFIRSTNAME", "length": 100, "domain": null }, { "name": "BUSINESSPHONE", "type": "esriFieldTypeString", "alias": "BUSINESSPHONE", "length": 25, "domain": null }, { "name": "OWNERNAME", "type": "esriFieldTypeString", "alias": "OWNERNAME", "length": 100, "domain": null }, { "name": "EXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "EXPIRATIONDATE", "length": 8, "domain": null }, { "name": "ISSUEDDATE", "type": "esriFieldTypeDate", "alias": "ISSUEDDATE", "length": 8, "domain": null }, { "name": "STATUSDATE", "type": "esriFieldTypeDate", "alias": "STATUSDATE", "length": 8, "domain": null }, { "name": "IPEXPIRATIONDATE", "type": "esriFieldTypeDate", "alias": "IPEXPIRATIONDATE", "length": 8, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "length": 25, "domain": null }, { "name": "LICENSETYPE", "type": "esriFieldTypeString", "alias": "LICENSETYPE", "length": 25, "domain": null }, { "name": "MATCHEDADDRESS", "type": "esriFieldTypeString", "alias": "MATCHEDADDRESS", "length": 100, "domain": null }, { "name": "DATASOURCE", "type": "esriFieldTypeString", "alias": "DATASOURCE", "length": 50, "domain": null }, { "name": "ADDRESSMATCHED", "type": "esriFieldTypeString", "alias": "ADDRESSMATCHED", "length": 100, "domain": null }, { "name": "ADDRESSFULL", "type": "esriFieldTypeString", "alias": "ADDRESSFULL", "length": 100, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "license", "type": "esriFieldTypeString", "alias": "license", "length": 255, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R3046_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2820_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }