{ "currentVersion": 11.3, "cimVersion": "3.3.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": "dc35a6e325835c36a55ac9b1d0668b7f", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABXklEQVRIieXUv2rCQBwH8G+i8YKDZtNkyeAflAqdnMS+iC/QR+krdO6TdM0QQhfNEhVDELMkgnCiuZQ76GBJtKZ2aPuFI/ALfO7Hcb8r4wdT/hu453kvlNIHANK1kCRJSbVafTZN8ykTj+N4slqtroY/0u/3HwFk44yxwjAPY0zGV8682Wyi0WjgUpbLJaIoyvyXi4dhiG63i3q9ngsHQZALn8WTJIFlWRiPx1BVVdQOhwN2ux00TROo4zi58Fmch1IqNhiNRiiVSlgsFpjP52JDXucNfOuex3EM27YxHA7RarWg67qA9/v9bYZovV5jNpuh1+thOp1iu93edkI3m43A+fefvS2fU6lU0Ol0+LsBQoioDQYDPok4Ho9wXRdpmqIQLssyFEUROAd93xdXki9e46swTim9OCjncoLzTm6ZE7xWq70ZhnFX5D0HkBJCXnPxdrt9X7TLrPzee/4OBaqDrRcrXUwAAAAASUVORK5CYII=", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "defaultLabel": "Terminated/Other", "uniqueValueGroups": [ { "heading": "", "classes": [ { "label": "Expired", "description": "Expired", "symbol": { "type": "esriPMS", "url": "a4b76b7d6b18f368308b907eca8458ea", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABnUlEQVRIiWNhoCFgGR6Gnz+ycfGn96/t/jMwMJJqECMT019BYcmZehaeHVgNf/boZvSVU7tINhgGbL2TMhgYGLAb/u/vX7INBoF/f/8wMRAT5qq61gzKWuYMhMDF49sYnj+6gVUOp+EPbp5hsHKLZhCXUcVp8M0LhxieP76JUx6n4b9//WRYO6eOIa5wCgMPvzBY7Me3zwzv3zxjkJRTZ3j+6CbD1mVdDAz//5NuOAh8+fiGYe2cWoao3H4GVjZ2hvNHNzOcO7yBIa5oKsO6OXUMf37/ZKAonb98cpthy5J2hsDEegYzx1AGNX1bhrWzaxi+fn5HnUx0+/JRhsPbFzDYeiUyHNo8h+HVs3vUzaH3b5wGG37vxumRVragAy4efgYLl0gGJiYWBi5eAbCYc2AWKCcz/Pr5DRwP///9YyDLcCZmVgZ2Th6w4X///GG4emYvAysbJ1iOkYmJgZGRieE/wz/y0/n25T0M5AIUwxkpKrYYwD7BabiIpOIlDQMH7f8M/0m2homJ+T83n8BBnIZbOEfok+xcPGDopnMAxwKFz0z/m9UAAAAASUVORK5CYII=", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Expired" ] ] }, { "label": "Inactive", "description": "Inactive", "symbol": { "type": "esriPMS", "url": "ae46d26ba6719d307b6ac788356983b7", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABb0lEQVRIieXUz0oCQRwH8O/M7sqWGeUmBaYuQZcMLQ8dO3QMfIJeoEfpFTr3Gl6SjuEhyMwIFEzL/7Wpq+7uxA6ewrXWDPrzncPCzPIZmPn9RsQ3RvwbeLOcPRv2u/uEMeJaItT0zC2eLq1tnozFda1x9Px05x4eJRBJHAMYjzNmTQ3bYbAoPnPmPiUCr38dH6X9mIeu1cauOeKd1gOUcBzyguIIa/WCIzwRtywDpesU1N0kRM88nzONPoY9DbJvBbpWR/k27QhPxO0Ygy7fIBw/BKUi2pUcWuUbRHaSKGVTYJaJL9W5/tpAJZdGcOsA/uA2fIrKNzQGvdk0kdYoolbIIKAmUC1cot9pzrZDO60Sx+2L/mdvy/sIkgwlFAMhFKIk87nVjT0wxmCZQ9SKGbutMRVOCIUgeviXMQsv1XtQQRqtEdiDgU1f55X8BX7EmRNQZ1z2Ll8hoEb5f65lygRJPnfElVAs7hqdkN9b52+qHoLhLttwjQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Inactive" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "a4b76b7d6b18f368308b907eca8458ea", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABnUlEQVRIiWNhoCFgGR6Gnz+ycfGn96/t/jMwMJJqECMT019BYcmZehaeHVgNf/boZvSVU7tINhgGbL2TMhgYGLAb/u/vX7INBoF/f/8wMRAT5qq61gzKWuYMhMDF49sYnj+6gVUOp+EPbp5hsHKLZhCXUcVp8M0LhxieP76JUx6n4b9//WRYO6eOIa5wCgMPvzBY7Me3zwzv3zxjkJRTZ3j+6CbD1mVdDAz//5NuOAh8+fiGYe2cWoao3H4GVjZ2hvNHNzOcO7yBIa5oKsO6OXUMf37/ZKAonb98cpthy5J2hsDEegYzx1AGNX1bhrWzaxi+fn5HnUx0+/JRhsPbFzDYeiUyHNo8h+HVs3vUzaH3b5wGG37vxumRVragAy4efgYLl0gGJiYWBi5eAbCYc2AWKCcz/Pr5DRwP///9YyDLcCZmVgZ2Th6w4X///GG4emYvAysbJ1iOkYmJgZGRieE/wz/y0/n25T0M5AIUwxkpKrYYwD7BabiIpOIlDQMH7f8M/0m2homJ+T83n8BBnIZbOEfok+xcPGDopnMAxwKFz0z/m9UAAAAASUVORK5CYII=", "contentType": "image/png", "width": 17, "height": 17, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Expired", "label": "Expired" }, { "symbol": { "type": "esriPMS", "url": "ae46d26ba6719d307b6ac788356983b7", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABb0lEQVRIieXUz0oCQRwH8O/M7sqWGeUmBaYuQZcMLQ8dO3QMfIJeoEfpFTr3Gl6SjuEhyMwIFEzL/7Wpq+7uxA6ewrXWDPrzncPCzPIZmPn9RsQ3RvwbeLOcPRv2u/uEMeJaItT0zC2eLq1tnozFda1x9Px05x4eJRBJHAMYjzNmTQ3bYbAoPnPmPiUCr38dH6X9mIeu1cauOeKd1gOUcBzyguIIa/WCIzwRtywDpesU1N0kRM88nzONPoY9DbJvBbpWR/k27QhPxO0Ygy7fIBw/BKUi2pUcWuUbRHaSKGVTYJaJL9W5/tpAJZdGcOsA/uA2fIrKNzQGvdk0kdYoolbIIKAmUC1cot9pzrZDO60Sx+2L/mdvy/sIkgwlFAMhFKIk87nVjT0wxmCZQ9SKGbutMRVOCIUgeviXMQsv1XtQQRqtEdiDgU1f55X8BX7EmRNQZ1z2Ll8hoEb5f65lygRJPnfElVAs7hqdkN9b52+qHoLhLttwjQAAAABJRU5ErkJggg==", "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, 210, 228, 255 ], "toColor": [ 252, 210, 228, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 194, 252, 179, 255 ], "toColor": [ 194, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 252, 255 ], "toColor": [ 179, 252, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 182, 252, 255 ], "toColor": [ 182, 182, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 229, 179, 255 ], "toColor": [ 252, 229, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 248, 255 ], "toColor": [ 252, 184, 248, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 210, 217, 252, 255 ], "toColor": [ 210, 217, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 189, 179, 255 ], "toColor": [ 252, 189, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 252, 216, 255 ], "toColor": [ 182, 252, 216, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 234, 252, 212, 255 ], "toColor": [ 234, 252, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 226, 215, 255 ], "toColor": [ 252, 226, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 218, 184, 252, 255 ], "toColor": [ 218, 184, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 184, 215, 255 ], "toColor": [ 252, 184, 215, 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.3503778686156464E8, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": 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 }