{"data":{"id":"9f7075df431e4a8eb5218b43aee40f18_0","type":"dataset","attributes":{"errors":[],"access":"public","additionalResources":[],"advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsQueryBins":true,"supportsFullTextStopWords":true,"supportsApproxPercentileStatistics":true,"supportsFullTextAccentSensitivity":true,"supportsTimeRelation":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"collection":["Dataset"],"categories":["Metro Government"],"commentsEnabled":true,"composeStatus":{"retries":0,"pass":true,"lastRetriedAt":1789748721581,"lastSuccessAt":1789748721581},"composedAt":1789748721580,"content":"Feature Service","contentSecurityPolicy":null,"created":1677016295000,"currentVersion":12,"description":"<span style='color:rgba(0, 0, 0, 0.87); font-family:Roboto, sans-serif;'><font size='3'>Details of credit card transactions made by Metro Nashville general government departments and agencies.  This dataset is updated annually.</font></span><div><span style='color:rgba(0, 0, 0, 0.87); font-family:Roboto, sans-serif;'><font size='3'><br /></font></span></div><div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif;'><font size='3'>Source Link: <a href='https://www.nashville.gov/departments/finance' style='font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;' target='_blank' rel='nofollow ugc noopener noreferrer'>https://www.nashville.gov/departments/finance</a></font></div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif;'><font size='3'>Metadata Document: <a href='https://nashville.maps.arcgis.com/sharing/rest/content/items/34d201dbfcca4f809a13e14a2322a27c/data' style='font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;' target='_blank' rel='nofollow ugc noopener noreferrer'>Metro Credit Card Transactions Metadata.pdf</a></font></div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif;'><font size='3'>Contact Data Owner: </font><a href='mailto:opendata@nashville.gov?subject=Metro Credit Card Transactions' style='font-family:&quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif;' target='_blank' rel='nofollow ugc noopener noreferrer'>opendata@nashville.gov</a></div></div>","displayField":"","downloadable":true,"enrichCoverage":"unknown","enrichQuality":79,"extent":null,"fieldNames":["OBJECTID","Fiscal_Year_Ending","Fiscal Year Ending","Department___Agency","Department / Agency","Merchant_Name","Merchant Name","Transaction_Date","Transaction Date","Transaction_Amount","Transaction Amount"],"fields":[{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","description":"{\"value\":\"System-generated unique record identifier for each transaction row.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fiscal_Year_Ending","alias":"Fiscal Year Ending","description":"{\"value\":\"Fiscal year ending date or year associated with the transaction record.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department___Agency","length":8000,"alias":"Department / Agency","description":"{\"value\":\"Metro Nashville department or agency associated with the credit card transaction.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Merchant_Name","length":8000,"alias":"Merchant Name","description":"{\"value\":\"Name of the merchant where the credit card transaction occurred.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"precision":1,"name":"Transaction_Date","length":8,"alias":"Transaction Date","description":"{\"value\":\"Date the credit card transaction was made.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Transaction_Amount","alias":"Transaction Amount","description":"{\"value\":\"Monetary amount of the credit card transaction.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"}],"groupIds":["8c9c6d0ef3434041b84116fdff861259"],"hasApi":true,"hubType":"Table","id":"9f7075df431e4a8eb5218b43aee40f18_0","itemId":"9f7075df431e4a8eb5218b43aee40f18","itemModified":1697577594000,"itemExtent":[],"layer":{"supportedContingentValuesFormats":"JSON, PBF","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":true,"editingInfo":{"lastEditDate":1789491776579,"schemaLastEditDate":1789491776579,"dataLastEditDate":1787674835723},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsAttachmentsResizing":true,"id":0,"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":32000,"isDataVersioned":false,"templates":[],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsReturnEditResults":true,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF","supportsTranslation":false,"supportsMaxTranslations":10},"supportsQuantizationEditMode":true,"objectIdField":"OBJECTID","hasContingentValuesDefinition":false,"viewSourceHasAttachments":false,"name":"Metro_Credit_Card_Transactions_tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","description":"{\"value\":\"System-generated unique record identifier for each transaction row.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fiscal_Year_Ending","alias":"Fiscal Year Ending","description":"{\"value\":\"Fiscal year ending date or year associated with the transaction record.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department___Agency","length":8000,"alias":"Department / Agency","description":"{\"value\":\"Metro Nashville department or agency associated with the credit card transaction.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Merchant_Name","length":8000,"alias":"Merchant Name","description":"{\"value\":\"Name of the merchant where the credit card transaction occurred.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"precision":1,"name":"Transaction_Date","length":8,"alias":"Transaction Date","description":"{\"value\":\"Date the credit card transaction was made.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Transaction_Amount","alias":"Transaction Amount","description":"{\"value\":\"Monetary amount of the credit card transaction.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"respectsDaylightSaving":false,"timeZone":"UTC","timeZoneIANA":"Etc/UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","description":"","isUpdatableView":true,"supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__METRO_CR__F4B70D85E70D87EE","isUnique":true,"description":"clustered, unique, primary key","fields":"OBJECTID","isAscending":true}],"htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsQueryBins":true,"supportsFullTextStopWords":true,"supportsApproxPercentileStatistics":true,"supportsFullTextAccentSensitivity":true,"supportsTimeRelation":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"serviceItemId":"9f7075df431e4a8eb5218b43aee40f18","supportsValidateSql":true,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsPercentileAnalytic":true,"supportsTrendlineRegression":true},"hasMetadata":true,"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"OBJECTID"},"tileMaxRecordCount":8000,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsLayerOverrides":true,"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","queryBinsCapabilities":{"supportsAsync":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsFixedIntervalBin":true,"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true,"supportsDateBin":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsStackBy":true,"supportsSplitBy":true,"supportsReturnFullIntervalBin":true,"supportsFirstDayOfWeek":true,"supportsReturnStackValueRange":true,"supportsClassificationBin":true},"cacheMaxAge":30,"supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","supportedConvertFileFormats":"JSON,PBF,Parquet","collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsColumnStoreIndex":true,"guidFormat":"","supportedOperationsWithCollation":"query,addField,updateField","supportsContingentValues":true,"supportsFieldGroups":true,"supportsEditingContingentValues":true,"maxIdsCount":1000000},"layers":[{"supportedContingentValuesFormats":"JSON, PBF","guidFormat":"","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":true,"editingInfo":{"lastEditDate":1789491776579,"schemaLastEditDate":1789491776579,"dataLastEditDate":1787674835723},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsEditingContingentValues":true,"supportsAttachmentsResizing":true,"id":0,"collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":32000,"isDataVersioned":false,"templates":[],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsTranslation":false,"supportsReturnEditResults":true,"supportsMaxTranslations":10,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportsQuantizationEditMode":true,"objectIdField":"OBJECTID","hasContingentValuesDefinition":false,"maxIdsCount":1000000,"viewSourceHasAttachments":false,"name":"Metro_Credit_Card_Transactions_tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","description":"{\"value\":\"System-generated unique record identifier for each transaction row.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fiscal_Year_Ending","alias":"Fiscal Year Ending","description":"{\"value\":\"Fiscal year ending date or year associated with the transaction record.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department___Agency","length":8000,"alias":"Department / Agency","description":"{\"value\":\"Metro Nashville department or agency associated with the credit card transaction.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Merchant_Name","length":8000,"alias":"Merchant Name","description":"{\"value\":\"Name of the merchant where the credit card transaction occurred.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"precision":1,"name":"Transaction_Date","length":8,"alias":"Transaction Date","description":"{\"value\":\"Date the credit card transaction was made.\",\"fieldValueType\":\"dateAndTime\"}","type":"esriFieldTypeDate"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Transaction_Amount","alias":"Transaction Amount","description":"{\"value\":\"Monetary amount of the credit card transaction.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"timeZoneIANA":"Etc/UTC","respectsDaylightSaving":false,"timeZone":"UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","isUpdatableView":true,"supportedOperationsWithCollation":"query,addField,updateField","supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__METRO_CR__F4B70D85E70D87EE","isUnique":true,"description":"clustered, unique, primary key","fields":"OBJECTID","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"queryBinsCapabilities":{"supportsReturnStackValueRange":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsFixedIntervalBin":true,"supportsStackBy":true,"supportsDateBin":true,"supportsSplitBy":true,"supportsClassificationBin":true,"supportsReturnFullIntervalBin":true,"supportsAsync":true,"supportsFirstDayOfWeek":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsTranslations":false,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsAggIds":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsApproxPercentileStatistics":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsReturningQueryExtent":false,"supportsISODOW":true,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsISOWeek":true,"supportsHavingClause":true},"serviceItemId":"9f7075df431e4a8eb5218b43aee40f18","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"supportsContingentValues":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsTrendlineRegression":true,"supportsPercentileAnalytic":true},"hasMetadata":true,"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"OBJECTID"},"tileMaxRecordCount":8000,"supportsFieldGroups":true,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsColumnStoreIndex":true,"supportsLayerOverrides":true}],"licenseInfo":null,"maxRecordCount":1000,"metadata":null,"modified":1789491776579,"modifiedProvenance":"layer.editingInfo.lastEditDate","name":"Metro Credit Card Transactions","objectIdField":"OBJECTID","openData":false,"orgId":"HdTo6HJqh92wn4D8","orgName":"Nashville GIS","organization":"Nashville GIS","orgExtent":{"ymin":4295228.852216443,"xmin":-9698309.88519694,"ymax":4357295.044720508,"xmax":-9623402.999842146,"spatialReference":{"wkid":102100}},"orgContactEmail":"mailto: gisdatateam@nashville.gov","owner":"NashvilleOpenData","recordCount":99450,"region":"US","searchDescription":"Details of credit card transactions made by Metro Nashville general government departments and agencies.  This dataset is updated annually.  Source Link: https://www.nashville.gov/departments/financeMetadata Document: Metro Credit Card Transactions Metadata.pdfContact Data Owner: opendata@nashville.gov","sector":"Local and State Government","server":{"supportedContingentValuesFormats":"JSON, PBF","allowGeometryUpdates":true,"supportsQueryContingentValues":true,"isView":true,"supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"description":"","units":"esriMeters","isUpdatableView":true,"supportsSharedDomains":true,"hasStaticData":true,"syncEnabled":false,"tables":[{"subLayerIds":null,"maxScale":0,"name":"Metro_Credit_Card_Transactions_tbl","defaultVisibility":true,"id":0,"minScale":0,"parentLayerId":-1}],"hasVersionedData":false,"layerOverridesEnabled":true,"layers":[],"serviceItemId":"9f7075df431e4a8eb5218b43aee40f18","fullExtent":null,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel","capabilities":"Query,Extract","supportsAppend":true,"xssPreventionInfo":{"xssInputRule":"rejectInvalid","xssPreventionRule":"InputOnly","xssPreventionEnabled":true},"supportsDisconnectedEditing":false,"sourceSchemaChangesAllowed":true,"supportsContingentValuesJson":2,"supportsTilesAndBasicQueriesMode":true,"preserveLayerIds":true,"supportsReturnDeleteResults":true,"currentVersion":12,"hasSharedDomains":false,"supportsWebHooks":true,"supportsVCSProjection":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsSplit":false,"supportsReturnEditResults":true,"supportsReturnServiceEditsInSourceSR":false,"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportedQueryFormats":"JSON","initialExtent":null,"supportsTemporalLayers":true,"serviceDescription":"","copyrightText":"","supportsLayerOverrides":true,"supportedConvertContentFormats":"LayerEditCollection","onlyAllowTrueCurveUpdatesByTrueCurveClients":false,"supportedConvertFileFormats":"JSON,PBF","supportsTrueCurve":true,"supportedCurveTypes":["esriGeometryCircularArc"],"allowTrueCurvesUpdates":true,"supportedFullTextLocales":["neutral","ar-SA","bg-BG","bn-IN","ca-ES","cs-CZ","da-DK","de-DE","el-GR","en-GB","en-US","es-ES","fr-FR","gu-IN","he-IL","hi-IN","hr-HR","id-ID","is-IS","it-IT","ja-JP","kn-IN","ko-KR","lt-LT","lv-LV","ml-IN","mr-IN","ms-MY","nb-NO","nl-NL","pa-IN","pl-PL","pt-BR","pt-PT","ro-RO","ru-RU","sk-SK","sl-SI","sr-Cyrl-CS","sr-Latn-CS","sv-SE","ta-IN","te-IN","th-TH","tr-TR","uk-UA","ur-PK","vi-VN","zh-CN","zh-HK","zh-MO","zh-SG","zh-TW"],"supportsSharedTemplates":true,"hasSharedTemplates":true,"supportedAppendCapabilities":"Features","supportedTrueCurvePbfFeatureEncodings":["esriCompressedShapeBuffer","esriDefault"],"trueCurveSupportMode":"OGC","maxIdsCount":1000000},"serverCapabilities":"Query,Extract","size":0,"slug":"Nashville::metro-credit-card-transactions","source":"Nashville GIS","sourceProvenance":"org.name","statistics":{"objectid":{"objectid":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":289.9727700003423,"values":{"avg":58087.67624937154,"min":1,"max":122084,"count":99450,"sum":5776819403}}}},"numeric":{"transaction_amount":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":203.40885199978948,"values":{"avg":310.4099361488278,"min":-5910,"max":13860,"var":263506.826062107,"count":99450,"sum":30870268.150000926,"stddev":513.3291595673355}}},"fiscal_year_ending":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":203.40885199978948,"values":{"avg":2021.4385017596783,"min":2016,"max":2026,"var":11.527520405132476,"count":99450,"sum":201032059,"stddev":3.395220229253542}}}},"string":{"merchant_name":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1799.9003490000032,"values":[{"count":6282,"value":"SOUTHWEST AIRLINES"},{"count":1135,"value":"THE HOME DEPOT #0732"},{"count":1097,"value":"MARRIOTT"},{"count":794,"value":"AMERICAN AIRLINES"},{"count":780,"value":"AMAZON MKTPLACE PMTS"},{"count":751,"value":"HILTON"},{"count":728,"value":"THE HOME DEPOT #0778"},{"count":722,"value":"DELTA"},{"count":632,"value":"KROGER #502"},{"count":562,"value":"SHERATON"},{"count":524,"value":"HOVER"},{"count":438,"value":"IBT IIS FINGERPRINT CO"},{"count":429,"value":"HYATT HOTELS"},{"count":385,"value":"ENTERPRISE RENT-A-CAR"},{"count":377,"value":"SUPER 8 MOTELS"},{"count":365,"value":"UNITED AIRLINES"},{"count":360,"value":"SAMSCLUB.COM"},{"count":352,"value":"AMAZON.COM"},{"count":352,"value":"MISTER CAR WASH #84QPS"},{"count":346,"value":"HOLIDAY INNS"},{"count":344,"value":"SAMS CLUB #8294"},{"count":330,"value":"THE HOME DEPOT #0733"},{"count":327,"value":"APCO INTERNATIONAL INC"},{"count":313,"value":"SAMSCLUB #8294"},{"count":303,"value":"MNAA PARKING 2023"},{"count":287,"value":"LOWES #00413"},{"count":284,"value":"DOUBLETREE"},{"count":278,"value":"SOUTHWEST"},{"count":257,"value":"HAMPTON INN HOTELS"},{"count":256,"value":"EMPIRE INDUSTRIES"},{"count":254,"value":"HOMEDEPOT.COM"},{"count":250,"value":"WESTIN"},{"count":247,"value":"OMNI HOTELS"},{"count":244,"value":"LOWES #00629"},{"count":242,"value":"PUBLIX #1426"},{"count":231,"value":"WALMART.COM"},{"count":230,"value":"COMCAST"},{"count":219,"value":"URBAN LAND INSTITUTE"},{"count":215,"value":"EXTENDED STAY"},{"count":214,"value":"GOVERNMENT FINANCE OFF"},{"count":210,"value":"GAN TENNNEWSPAPERSCIRC"},{"count":206,"value":"UT IPS ONLINE"},{"count":194,"value":"ETS HISET REGISTRATION"},{"count":191,"value":"COURTYARD BY MARRIOTT"},{"count":188,"value":"SOCIETYFORHUMANRESOURC"},{"count":186,"value":"WAL-MART #0695"},{"count":185,"value":"LOWES #02851"},{"count":184,"value":"ZOOM.US 888-799-9666"},{"count":177,"value":"NATIONAL ASSOCIATION O"},{"count":176,"value":"MICHAELANGELO'S PIZZA"}],"count":68765,"uniqueCount":2000}},"department___agency":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":438.8645339999348,"values":[{"count":17322,"value":"Police"},{"count":7604,"value":"Sheriff"},{"count":6788,"value":"Water Services"},{"count":6640,"value":"Parks and Recreation"},{"count":5533,"value":"Health"},{"count":4390,"value":"Library"},{"count":3992,"value":"Metro Action Commission"},{"count":3658,"value":"State Trial Courts"},{"count":3094,"value":"Social Services"},{"count":2472,"value":"Finance"},{"count":2438,"value":"Emergency Communications Center"},{"count":2289,"value":"Information Technology Services"},{"count":2122,"value":"District Attorney"},{"count":2111,"value":"Office of Family Safety"},{"count":2091,"value":"Planning"},{"count":1759,"value":"Nashville Fairgrounds"},{"count":1747,"value":"General Sessions Court"},{"count":1740,"value":"Tennessee State Fair"},{"count":1594,"value":"Nashville Department of Transportation"},{"count":1388,"value":"Fire Department"},{"count":1293,"value":"Human Resources"},{"count":1217,"value":"Arts Commission"},{"count":1192,"value":"Farmers Market"},{"count":1118,"value":"Office of Emergency Management"},{"count":1097,"value":"Juvenile Court Judge"},{"count":1066,"value":"Public Defender"},{"count":969,"value":"Mayor's Office"},{"count":877,"value":"Office of Homeless Services"},{"count":815,"value":"Public Works"},{"count":750,"value":"Criminal Court Clerk"},{"count":683,"value":"NDOT"},{"count":653,"value":"Community Review Board"},{"count":594,"value":"Nashville Career Advancement Center"},{"count":519,"value":"Assessor of Property"},{"count":485,"value":"Waste Services"},{"count":451,"value":"Internal Audit"},{"count":442,"value":"Community Education"},{"count":442,"value":"Trustee"},{"count":441,"value":"General Services"},{"count":361,"value":"Human Relations Commission"},{"count":361,"value":"Metro Council Staff"},{"count":290,"value":"Community Oversight Board"},{"count":289,"value":"Beer Permit Board"},{"count":281,"value":"Legal"},{"count":237,"value":"Historical Commission"},{"count":220,"value":"Codes"},{"count":211,"value":"JIS"},{"count":198,"value":"ITS"},{"count":178,"value":"Justice Integration Systems"},{"count":164,"value":"Justice Integration Services"}],"count":99450,"uniqueCount":60}}},"date":{"transaction_date":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":176.0305689999368,"values":{"min":1435708800000,"max":1782777600000,"count":99450}}}}},"structuredLicense":{"type":"none"},"license":"none","supportedQueryFormats":"JSON, geoJSON, PBF","supportsAdvancedQueries":true,"tags":["credit","card","expenditure","expense","cost","merchant","supplier","amount","budget","finance","fiscal","money"],"thumbnail":"thumbnail/thumbnail1677016362854.png","thumbnailUrl":"thumbnail/thumbnail1677016362854.png","type":"Table","typeCategories":["Dataset"],"typeKeywords":["ArcGIS Server","Data","Feature Access","Feature Service","Service","Singlelayer","Table","Hosted Service","View Service"],"url":"https://services2.arcgis.com/HdTo6HJqh92wn4D8/arcgis/rest/services/Metro_Credit_Card_Transactions_view/FeatureServer/0","useStandardizedQueries":true,"validExtent":true,"xFrameOptions":null,"boundary":null,"snippet":"Metro Credit Card Transactions","culture":""},"links":{"self":"https://hub.arcgis.com/api/v3/datasets/9f7075df431e4a8eb5218b43aee40f18_0","rawEs":"https://hub.arcgis.com/api/es/datasets/9f7075df431e4a8eb5218b43aee40f18_0","itemPage":"https://www.arcgis.com/home/item.html?id=9f7075df431e4a8eb5218b43aee40f18","esriRest":"https://www.arcgis.com/sharing/content/items/9f7075df431e4a8eb5218b43aee40f18?f=json"},"meta":{"highlights":{},"matchedFields":[]}},"meta":{"apiRoot":"https://hub.arcgis.com/api/v3/","resourceRoot":"https://hub.arcgis.com/api/v3/datasets","request":"https://hub.arcgis.com/api/v3/datasets/9f7075df431e4a8eb5218b43aee40f18_0"}}