{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Pedestrian Malls", "type" : "Feature Layer", "serviceItemId" : "84066636d4a446f99de8dcf382db2ca2", "cacheMaxAge" : 30, "displayField" : "Loc_name", "description" : "", "copyrightText" : "", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1607735259880, "schemaLastEditDate" : 1607735259880, "dataLastEditDate" : 1607735259880 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -17572658.819305681, "ymin" : 2428275.5953182988, "xmax" : -7820937.8424259629, "ymax" : 6041154.594416582, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"USER_Status","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[76,230,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Existing","label":"Existing"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Removed","label":"Removed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[228,252,182,255],"toColor":[228,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[235,179,252,255],"toColor":[235,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,235,252,255],"toColor":[192,235,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,189,255],"toColor":[252,202,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,223,255],"toColor":[184,252,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[238,215,252,255],"toColor":[238,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,237,199,255],"toColor":[252,237,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,222,255],"toColor":[252,179,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,193,252,255],"toColor":[187,193,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,252,248,255],"toColor":[189,252,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,212,252,255],"toColor":[187,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,252,210,255],"toColor":[222,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,189,255],"toColor":[187,252,189,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "ObjectID", "uniqueIdField" : { "name" : "ObjectID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "USER_Status", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "ObjectID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Loc_name", "type" : "esriFieldTypeString", "alias" : "Loc_name", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Score", "type" : "esriFieldTypeDouble", "alias" : "Score", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Match_type", "type" : "esriFieldTypeString", "alias" : "Match_type", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Match_addr", "type" : "esriFieldTypeString", "alias" : "Match_addr", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LongLabel", "type" : "esriFieldTypeString", "alias" : "LongLabel", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ShortLabel", "type" : "esriFieldTypeString", "alias" : "ShortLabel", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Addr_type", "type" : "esriFieldTypeString", "alias" : "Addr_type", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type", "type" : "esriFieldTypeString", "alias" : "Type", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PlaceName", "type" : "esriFieldTypeString", "alias" : "PlaceName", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Place_addr", "type" : "esriFieldTypeString", "alias" : "Place_addr", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Phone", "type" : "esriFieldTypeString", "alias" : "Phone", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "URL", "type" : "esriFieldTypeString", "alias" : "URL", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rank", "type" : "esriFieldTypeDouble", "alias" : "Rank", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AddBldg", "type" : "esriFieldTypeString", "alias" : "BuildingName", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AddNum", "type" : "esriFieldTypeString", "alias" : "AddressNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AddNumFrom", "type" : "esriFieldTypeString", "alias" : "AddNumFrom", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AddNumTo", "type" : "esriFieldTypeString", "alias" : "AddNumTo", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AddRange", "type" : "esriFieldTypeString", "alias" : "AddressRange", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Side", "type" : "esriFieldTypeString", "alias" : "Side", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StPreDir", "type" : "esriFieldTypeString", "alias" : "StPreDir", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StPreType", "type" : "esriFieldTypeString", "alias" : "StPreType", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StName", "type" : "esriFieldTypeString", "alias" : "StName", "sqlType" : "sqlTypeOther", "length" : 125, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StType", "type" : "esriFieldTypeString", "alias" : "StType", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StDir", "type" : "esriFieldTypeString", "alias" : "StDir", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BldgType", "type" : "esriFieldTypeString", "alias" : "BldgType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BldgName", "type" : "esriFieldTypeString", "alias" : "BldgName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LevelType", "type" : "esriFieldTypeString", "alias" : "LevelType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LevelName", "type" : "esriFieldTypeString", "alias" : "LevelName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UnitType", "type" : "esriFieldTypeString", "alias" : "UnitType", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UnitName", "type" : "esriFieldTypeString", "alias" : "UnitName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SubAddr", "type" : "esriFieldTypeString", "alias" : "SubAddress", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StAddr", "type" : "esriFieldTypeString", "alias" : "StAddr", "sqlType" : "sqlTypeOther", "length" : 300, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Block", "type" : "esriFieldTypeString", "alias" : "Block", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sector", "type" : "esriFieldTypeString", "alias" : "Sector", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Nbrhd", "type" : "esriFieldTypeString", "alias" : "Neighborhood", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "District", "type" : "esriFieldTypeString", "alias" : "District", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MetroArea", "type" : "esriFieldTypeString", "alias" : "MetroArea", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Subregion", "type" : "esriFieldTypeString", "alias" : "Subregion", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Region", "type" : "esriFieldTypeString", "alias" : "Region", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RegionAbbr", "type" : "esriFieldTypeString", "alias" : "RegionAbbr", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Territory", "type" : "esriFieldTypeString", "alias" : "Territory", "sqlType" : "sqlTypeOther", "length" : 120, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zone", "type" : "esriFieldTypeString", "alias" : "Zone", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Postal", "type" : "esriFieldTypeString", "alias" : "Postal", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PostalExt", "type" : "esriFieldTypeString", "alias" : "PostalExt", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Country", "type" : "esriFieldTypeString", "alias" : "Country", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LangCode", "type" : "esriFieldTypeString", "alias" : "LangCode", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distance", "type" : "esriFieldTypeDouble", "alias" : "Distance", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DisplayX", "type" : "esriFieldTypeDouble", "alias" : "DisplayX", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DisplayY", "type" : "esriFieldTypeDouble", "alias" : "DisplayY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Xmin", "type" : "esriFieldTypeDouble", "alias" : "Xmin", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Xmax", "type" : "esriFieldTypeDouble", "alias" : "Xmax", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ymin", "type" : "esriFieldTypeDouble", "alias" : "Ymin", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Ymax", "type" : "esriFieldTypeDouble", "alias" : "Ymax", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ExInfo", "type" : "esriFieldTypeString", "alias" : "ExtraInfo", "sqlType" : "sqlTypeOther", "length" : 500, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ResultID", "type" : "esriFieldTypeInteger", "alias" : "ResultID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IN_SingleLine", "type" : "esriFieldTypeString", "alias" : "Single Line Input", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_Name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USER_City__State", "type" : "esriFieldTypeString", "alias" : "City, State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DISTILLE__9A6192B1F18B67CB", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3177.DISTILLERY_OPTIONS_WFL1_PEDESTRIAN_MALLS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Existing", "name" : "Existing", "domains" : { }, "templates" : [ { "name" : "Existing", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "USER_Status" : "Existing", "USER_City__State" : "", "Loc_name" : null, "Status" : null, "Score" : null, "Match_type" : null, "Match_addr" : null, "LongLabel" : null, "ShortLabel" : null, "Addr_type" : null, "Type" : null, "PlaceName" : null, "Place_addr" : null, "Phone" : null, "URL" : null, "Rank" : null, "AddBldg" : null, "AddNum" : null, "AddNumFrom" : null, "AddNumTo" : null, "AddRange" : null, "Side" : null, "StPreDir" : null, "StPreType" : null, "StName" : null, "StType" : null, "StDir" : null, "BldgType" : null, "BldgName" : null, "LevelType" : null, "LevelName" : null, "UnitType" : null, "UnitName" : null, "SubAddr" : null, "StAddr" : null, "Block" : null, "Sector" : null, "Nbrhd" : null, "District" : null, "City" : null, "MetroArea" : null, "Subregion" : null, "Region" : null, "RegionAbbr" : null, "Territory" : null, "Zone" : null, "Postal" : null, "PostalExt" : null, "Country" : null, "LangCode" : null, "Distance" : null, "X" : null, "Y" : null, "DisplayX" : null, "DisplayY" : null, "Xmin" : null, "Xmax" : null, "Ymin" : null, "Ymax" : null, "ExInfo" : null, "ResultID" : null, "IN_SingleLine" : "", "USER_Name" : "" } } } ] }, { "id" : "Removed", "name" : "Removed", "domains" : { }, "templates" : [ { "name" : "Removed", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "USER_Status" : "Removed", "USER_City__State" : "", "Loc_name" : null, "Status" : null, "Score" : null, "Match_type" : null, "Match_addr" : null, "LongLabel" : null, "ShortLabel" : null, "Addr_type" : null, "Type" : null, "PlaceName" : null, "Place_addr" : null, "Phone" : null, "URL" : null, "Rank" : null, "AddBldg" : null, "AddNum" : null, "AddNumFrom" : null, "AddNumTo" : null, "AddRange" : null, "Side" : null, "StPreDir" : null, "StPreType" : null, "StName" : null, "StType" : null, "StDir" : null, "BldgType" : null, "BldgName" : null, "LevelType" : null, "LevelName" : null, "UnitType" : null, "UnitName" : null, "SubAddr" : null, "StAddr" : null, "Block" : null, "Sector" : null, "Nbrhd" : null, "District" : null, "City" : null, "MetroArea" : null, "Subregion" : null, "Region" : null, "RegionAbbr" : null, "Territory" : null, "Zone" : null, "Postal" : null, "PostalExt" : null, "Country" : null, "LangCode" : null, "Distance" : null, "X" : null, "Y" : null, "DisplayX" : null, "DisplayY" : null, "Xmin" : null, "Xmax" : null, "Ymin" : null, "Ymax" : null, "ExInfo" : null, "ResultID" : null, "IN_SingleLine" : "", "USER_Name" : "" } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "cities", "type" : "Feature Layer", "serviceItemId" : "84066636d4a446f99de8dcf382db2ca2", "cacheMaxAge" : 30, "displayField" : "NAME", "description" : "\u003cDIV STYLE=\"text-align:Left;\"\u003e\u003cDIV\u003e\u003cDIV\u003e\u003cP\u003e\u003cSPAN\u003e\u003cSPAN\u003eU.S. Cities represents locations for cities within the United States with populations greater than 10,000, all state capitals, and the national capital.\u003c/SPAN\u003e\u003c/SPAN\u003e\u003c/P\u003e\u003c/DIV\u003e\u003c/DIV\u003e\u003c/DIV\u003e", "copyrightText" : "", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1607735259880, "schemaLastEditDate" : 1607735259880, "dataLastEditDate" : 1607735259880 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -20037507.067179192, "ymin" : 1029029.4240642968, "xmax" : 20037507.0671792, "ymax" : 11502186.943989132, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[154,72,160,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "NAME", "type" : "esriFieldTypeString", "alias" : "NAME", "sqlType" : "sqlTypeOther", "length" : 57, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLASS", "type" : "esriFieldTypeString", "alias" : "CLASS", "sqlType" : "sqlTypeOther", "length" : 36, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ST", "type" : "esriFieldTypeString", "alias" : "ST", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STFIPS", "type" : "esriFieldTypeString", "alias" : "STFIPS", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PLACEFIPS", "type" : "esriFieldTypeString", "alias" : "PLACEFIPS", "sqlType" : "sqlTypeOther", "length" : 7, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CAPITAL", "type" : "esriFieldTypeString", "alias" : "CAPITAL", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP_CLASS", "type" : "esriFieldTypeSmallInteger", "alias" : "POP_CLASS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POPULATION", "type" : "esriFieldTypeInteger", "alias" : "POP2014", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POP2010", "type" : "esriFieldTypeInteger", "alias" : "POP2010", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WHITE", "type" : "esriFieldTypeInteger", "alias" : "WHITE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BLACK", "type" : "esriFieldTypeInteger", "alias" : "BLACK", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AMERI_ES", "type" : "esriFieldTypeInteger", "alias" : "AMERI_ES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASIAN", "type" : "esriFieldTypeInteger", "alias" : "ASIAN", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HAWN_PI", "type" : "esriFieldTypeInteger", "alias" : "HAWN_PI", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HISPANIC", "type" : "esriFieldTypeInteger", "alias" : "HISPANIC", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OTHER", "type" : "esriFieldTypeInteger", "alias" : "OTHER", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MULT_RACE", "type" : "esriFieldTypeInteger", "alias" : "MULT_RACE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MALES", "type" : "esriFieldTypeInteger", "alias" : "MALES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FEMALES", "type" : "esriFieldTypeInteger", "alias" : "FEMALES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_UNDER5", "type" : "esriFieldTypeInteger", "alias" : "AGE_UNDER5", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_5_9", "type" : "esriFieldTypeInteger", "alias" : "AGE_5_9", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_10_14", "type" : "esriFieldTypeInteger", "alias" : "AGE_10_14", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_15_19", "type" : "esriFieldTypeInteger", "alias" : "AGE_15_19", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_20_24", "type" : "esriFieldTypeInteger", "alias" : "AGE_20_24", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_25_34", "type" : "esriFieldTypeInteger", "alias" : "AGE_25_34", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_35_44", "type" : "esriFieldTypeInteger", "alias" : "AGE_35_44", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_45_54", "type" : "esriFieldTypeInteger", "alias" : "AGE_45_54", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_55_64", "type" : "esriFieldTypeInteger", "alias" : "AGE_55_64", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_65_74", "type" : "esriFieldTypeInteger", "alias" : "AGE_65_74", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_75_84", "type" : "esriFieldTypeInteger", "alias" : "AGE_75_84", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AGE_85_UP", "type" : "esriFieldTypeInteger", "alias" : "AGE_85_UP", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MED_AGE", "type" : "esriFieldTypeDouble", "alias" : "MED_AGE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MED_AGE_M", "type" : "esriFieldTypeDouble", "alias" : "MED_AGE_M", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MED_AGE_F", "type" : "esriFieldTypeDouble", "alias" : "MED_AGE_F", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HOUSEHOLDS", "type" : "esriFieldTypeInteger", "alias" : "HOUSEHOLDS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AVE_HH_SZ", "type" : "esriFieldTypeDouble", "alias" : "AVE_HH_SZ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HSEHLD_1_M", "type" : "esriFieldTypeInteger", "alias" : "HSEHLD_1_M", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HSEHLD_1_F", "type" : "esriFieldTypeInteger", "alias" : "HSEHLD_1_F", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MARHH_CHD", "type" : "esriFieldTypeInteger", "alias" : "MARHH_CHD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MARHH_NO_C", "type" : "esriFieldTypeInteger", "alias" : "MARHH_NO_C", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MHH_CHILD", "type" : "esriFieldTypeInteger", "alias" : "MHH_CHILD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FHH_CHILD", "type" : "esriFieldTypeInteger", "alias" : "FHH_CHILD", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FAMILIES", "type" : "esriFieldTypeInteger", "alias" : "FAMILIES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AVE_FAM_SZ", "type" : "esriFieldTypeDouble", "alias" : "AVE_FAM_SZ", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HSE_UNITS", "type" : "esriFieldTypeInteger", "alias" : "HSE_UNITS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VACANT", "type" : "esriFieldTypeInteger", "alias" : "VACANT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OWNER_OCC", "type" : "esriFieldTypeInteger", "alias" : "OWNER_OCC", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RENTER_OCC", "type" : "esriFieldTypeInteger", "alias" : "RENTER_OCC", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DISTILLE__F4B70D85911EB875", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_3177.DISTILLERY_OPTIONS_WFL1_CITIES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "cities", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "OWNER_OCC" : null, "RENTER_OCC" : null, "NAME" : null, "CLASS" : null, "ST" : null, "STFIPS" : null, "PLACEFIPS" : null, "CAPITAL" : null, "POP_CLASS" : null, "POPULATION" : null, "POP2010" : null, "WHITE" : null, "BLACK" : null, "AMERI_ES" : null, "ASIAN" : null, "HAWN_PI" : null, "HISPANIC" : null, "OTHER" : null, "MULT_RACE" : null, "MALES" : null, "FEMALES" : null, "AGE_UNDER5" : null, "AGE_5_9" : null, "AGE_10_14" : null, "AGE_15_19" : null, "AGE_20_24" : null, "AGE_25_34" : null, "AGE_35_44" : null, "AGE_45_54" : null, "AGE_55_64" : null, "AGE_65_74" : null, "AGE_75_84" : null, "AGE_85_UP" : null, "MED_AGE" : null, "MED_AGE_M" : null, "MED_AGE_F" : null, "HOUSEHOLDS" : null, "AVE_HH_SZ" : null, "HSEHLD_1_M" : null, "HSEHLD_1_F" : null, "MARHH_CHD" : null, "MARHH_NO_C" : null, "MHH_CHILD" : null, "FHH_CHILD" : null, "FAMILIES" : null, "AVE_FAM_SZ" : null, "HSE_UNITS" : null, "VACANT" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 2, "name" : "Liquor_Laws$", "type" : "Table", "serviceItemId" : "84066636d4a446f99de8dcf382db2ca2", "cacheMaxAge" : 30, "displayField" : "State", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1607735259880, "schemaLastEditDate" : 1607735259880, "dataLastEditDate" : 1607735259880 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "ObjectID", "uniqueIdField" : { "name" : "ObjectID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "State", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Postal", "type" : "esriFieldTypeString", "alias" : "Postal", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State_Guild", "type" : "esriFieldTypeString", "alias" : "State_Guild", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tier_Control", "type" : "esriFieldTypeString", "alias" : "Tier_Control", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Production_Limit", "type" : "esriFieldTypeString", "alias" : "Production_Limit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tasting_Room", "type" : "esriFieldTypeString", "alias" : "Tasting_Room", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Satellite_Tasting", "type" : "esriFieldTypeString", "alias" : "Satellite_Tasting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Paid_Tasting", "type" : "esriFieldTypeString", "alias" : "Paid_Tasting", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Bottle_Sales", "type" : "esriFieldTypeString", "alias" : "Bottle_Sales", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Glass_Sales", "type" : "esriFieldTypeString", "alias" : "Glass_Sales", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cocktails", "type" : "esriFieldTypeString", "alias" : "Cocktails", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Self_Distribution", "type" : "esriFieldTypeString", "alias" : "Self_Distribution", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Swag", "type" : "esriFieldTypeString", "alias" : "Swag", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ObjectID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DISTILLE__9A6192B115FD3DCC", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Liquor_Laws$", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Swag" : null, "State" : null, "Postal" : null, "State_Guild" : null, "Tier_Control" : null, "Production_Limit" : null, "Tasting_Room" : null, "Satellite_Tasting" : null, "Paid_Tasting" : null, "Bottle_Sales" : null, "Glass_Sales" : null, "Cocktails" : null, "Self_Distribution" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "'Exported Data$'", "type" : "Table", "serviceItemId" : "84066636d4a446f99de8dcf382db2ca2", "cacheMaxAge" : 30, "displayField" : "City", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1607735259880, "schemaLastEditDate" : 1607735259880, "dataLastEditDate" : 1607735259880 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "ObjectID", "uniqueIdField" : { "name" : "ObjectID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Distilleries", "type" : "esriFieldTypeDouble", "alias" : "Distilleries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Breweries", "type" : "esriFieldTypeDouble", "alias" : "Breweries", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rent_Min", "type" : "esriFieldTypeDouble", "alias" : "Rent_Min", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sites", "type" : "esriFieldTypeDouble", "alias" : "Sites", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pop_2020", "type" : "esriFieldTypeDouble", "alias" : "Pop_2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pop_2025", "type" : "esriFieldTypeDouble", "alias" : "Pop_2025", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Alc_Bev_2020", "type" : "esriFieldTypeDouble", "alias" : "Alc_Bev_2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Whiskey_2020", "type" : "esriFieldTypeDouble", "alias" : "Whiskey_2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Alc_Rest_2020", "type" : "esriFieldTypeDouble", "alias" : "Alc_Rest_2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rest_Food_2020", "type" : "esriFieldTypeDouble", "alias" : "Rest_Food_2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Alc_Trip_2020", "type" : "esriFieldTypeDouble", "alias" : "Alc_Trip_2020", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ObjectID", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__DISTILLE__9A6192B1A93F0D6E", "fields" : "ObjectID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "'Exported Data$'", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Alc_Trip_2020" : null, "City" : null, "State" : null, "Distilleries" : null, "Breweries" : null, "Rent_Min" : null, "Sites" : null, "Pop_2020" : null, "Pop_2025" : null, "Alc_Bev_2020" : null, "Whiskey_2020" : null, "Alc_Rest_2020" : null, "Rest_Food_2020" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }