{"data":{"id":"eed2428238124a05afd72bfa047fdcfa_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,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":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,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":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":1789535887336,"lastSuccessAt":1789535887336},"composedAt":1789535887336,"content":"Feature Service","contentSecurityPolicy":null,"created":1677015296000,"currentVersion":12,"description":"Budgeted and actual expenses divided by fun, department, business unit, and account with details for each fiscal year.  This dataset is updated annually.

Source Link: https://www.nashville.gov/departments/finance/management-and-budget/citizens-guide-budget
Metadata Document: Metro Budget to Actual Expenses (FY2010 - Present) Metadata.pdf
Contact Data Owner: opendata@nashville.gov
","displayField":"","downloadable":true,"enrichCoverage":"unknown","enrichQuality":79,"extent":null,"fieldNames":["OBJECTID","Fund","Fund_Description","Fund Description","Department","Department_Description","Department Description","Business_Unit","Business Unit","Business_Unit_Description","Business Unit Description","Object_Account","Object Account","Object_Account_Description","Object Account Description","FY2010_Budgeted_Expenses","FY2010 Budgeted Expenses","FY2010_Actual_Expenses","FY2010 Actual Expenses","FY2011_Budgeted_Expenses","FY2011 Budgeted Expenses","FY2011_Actual_Expenses","FY2011 Actual Expenses","FY2012_Budgeted_Expenses","FY2012 Budgeted Expenses","FY2012_Actual_Expenses","FY2012 Actual Expenses","FY2013_Budgeted_Expenses","FY2013 Budgeted Expenses","FY2013_Actual_Expenses","FY2013 Actual Expenses","FY2014_Budgeted_Expenses","FY2014 Budgeted Expenses","FY2014_Actual_Expenses","FY2014 Actual Expenses","FY2015_Budgeted_Expenses","FY2015 Budgeted Expenses","FY2015_Actual_Expenses","FY2015 Actual Expenses","FY2016_Budgeted_Expenses","FY2016 Budgeted Expenses","FY2016_Actual_Expenses","FY2016 Actual Expenses","FY2017_Budgeted_Expenses","FY2017 Budgeted Expenses","FY2017_Actual_Expenses","FY2017 Actual Expenses","FY2018_Budgeted_Expenses","FY2018 Budgeted Expenses","FY2018_Actual_Expenses","FY2018 Actual Expenses","FY2019_Budgeted_Expenses","FY2019 Budgeted Expenses","FY2019_Actual_Expenses","FY2019 Actual Expenses","FY2020_Budgeted_Expenses","FY2020 Budgeted Expenses","FY2020_Actual_Expenses","FY2020 Actual Expenses","FY2021_Budgeted_Expenses","FY2021 Budgeted Expenses","FY2021_Actual_Expenses","FY2021 Actual Expenses","FY2022_Budgeted_Expenses","FY2022 Budgeted Expenses","FY2022_Actual_Expenses","FY2022 Actual Expenses","FY2023_Budgeted_Expenses","FY2023 Budgeted Expenses","FY2023_Actual_Expenses","FY2023 Actual Expenses","FY2024_Budgeted_Expenses","FY2024 Budgeted Expenses","FY2024_Actual_Expenses","FY2024 Actual Expenses","FY2025_Budgeted_Expenses","FY2025 Budgeted Expenses","FY2025_Actual_Expenses","FY2025 Actual Expenses"],"fields":[{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","description":"{\"value\":\"Unique system-generated identifier for each record.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fund","alias":"Fund","description":"{\"value\":\"Numeric code identifying the fund associated with the budget or expense record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fund_Description","length":8000,"alias":"Fund Description","description":"{\"value\":\"Name or description of the fund associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department","alias":"Department","description":"{\"value\":\"Numeric code identifying the department associated with the budget or expense record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Description","length":8000,"alias":"Department Description","description":"{\"value\":\"Name or description of the department associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Business_Unit","alias":"Business Unit","description":"{\"value\":\"Numeric code identifying the business unit associated with the record.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Business_Unit_Description","length":8000,"alias":"Business Unit Description","description":"{\"value\":\"Name or description of the business unit associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Object_Account","alias":"Object Account","description":"{\"value\":\"Numeric code identifying the object account for the budget or expense line item.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Object_Account_Description","length":8000,"alias":"Object Account Description","description":"{\"value\":\"Name or description of the object account category for the line item.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2010_Budgeted_Expenses","alias":"FY2010 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2010, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2010_Actual_Expenses","alias":"FY2010 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2010, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2011_Budgeted_Expenses","alias":"FY2011 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2011, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2011_Actual_Expenses","alias":"FY2011 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2011, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2012_Budgeted_Expenses","alias":"FY2012 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2012, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2012_Actual_Expenses","alias":"FY2012 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2012, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2013_Budgeted_Expenses","alias":"FY2013 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2013, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2013_Actual_Expenses","alias":"FY2013 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2013, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2014_Budgeted_Expenses","alias":"FY2014 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2014, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2014_Actual_Expenses","alias":"FY2014 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2014, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2015_Budgeted_Expenses","alias":"FY2015 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2015, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2015_Actual_Expenses","alias":"FY2015 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2015, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2016_Budgeted_Expenses","alias":"FY2016 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2016, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2016_Actual_Expenses","alias":"FY2016 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2016, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2017_Budgeted_Expenses","alias":"FY2017 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2017, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2017_Actual_Expenses","alias":"FY2017 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2017, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2018_Budgeted_Expenses","alias":"FY2018 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2018, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2018_Actual_Expenses","alias":"FY2018 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2018, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2019_Budgeted_Expenses","alias":"FY2019 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2019, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2019_Actual_Expenses","alias":"FY2019 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2019, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2020_Budgeted_Expenses","alias":"FY2020 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2020, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2020_Actual_Expenses","alias":"FY2020 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2020, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2021_Budgeted_Expenses","alias":"FY2021 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2021, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2021_Actual_Expenses","alias":"FY2021 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2021, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2022_Budgeted_Expenses","alias":"FY2022 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2022, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2022_Actual_Expenses","alias":"FY2022 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2022, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2023_Budgeted_Expenses","alias":"FY2023 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2023, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2023_Actual_Expenses","alias":"FY2023 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2023, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2024_Budgeted_Expenses","alias":"FY2024 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2024, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2024_Actual_Expenses","alias":"FY2024 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2024, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2025_Budgeted_Expenses","alias":"FY2025 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2025, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2025_Actual_Expenses","alias":"FY2025 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2025, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"}],"groupIds":["8c9c6d0ef3434041b84116fdff861259"],"hasApi":true,"hubType":"Table","id":"eed2428238124a05afd72bfa047fdcfa_0","itemId":"eed2428238124a05afd72bfa047fdcfa","itemModified":1697576242000,"itemExtent":[],"layer":{"supportedContingentValuesFormats":"JSON, PBF","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":false,"editingInfo":{"lastEditDate":1789491172353,"schemaLastEditDate":1789491172353,"dataLastEditDate":1772222389984},"supportsAttachmentsByUploadId":true,"relationships":[],"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,"supportsReturnEditResults":true,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF","supportsTranslation":false,"supportsMaxTranslations":10},"supportsQuantizationEditMode":true,"objectIdField":"OBJECTID","hasContingentValuesDefinition":false,"viewSourceHasAttachments":false,"name":"Metro_Budget_to_Actual_Expenses_FY2010_Present__tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","description":"{\"value\":\"Unique system-generated identifier for each record.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fund","alias":"Fund","description":"{\"value\":\"Numeric code identifying the fund associated with the budget or expense record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fund_Description","length":8000,"alias":"Fund Description","description":"{\"value\":\"Name or description of the fund associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department","alias":"Department","description":"{\"value\":\"Numeric code identifying the department associated with the budget or expense record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Description","length":8000,"alias":"Department Description","description":"{\"value\":\"Name or description of the department associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Business_Unit","alias":"Business Unit","description":"{\"value\":\"Numeric code identifying the business unit associated with the record.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Business_Unit_Description","length":8000,"alias":"Business Unit Description","description":"{\"value\":\"Name or description of the business unit associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Object_Account","alias":"Object Account","description":"{\"value\":\"Numeric code identifying the object account for the budget or expense line item.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Object_Account_Description","length":8000,"alias":"Object Account Description","description":"{\"value\":\"Name or description of the object account category for the line item.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2010_Budgeted_Expenses","alias":"FY2010 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2010, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2010_Actual_Expenses","alias":"FY2010 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2010, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2011_Budgeted_Expenses","alias":"FY2011 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2011, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2011_Actual_Expenses","alias":"FY2011 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2011, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2012_Budgeted_Expenses","alias":"FY2012 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2012, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2012_Actual_Expenses","alias":"FY2012 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2012, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2013_Budgeted_Expenses","alias":"FY2013 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2013, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2013_Actual_Expenses","alias":"FY2013 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2013, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2014_Budgeted_Expenses","alias":"FY2014 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2014, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2014_Actual_Expenses","alias":"FY2014 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2014, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2015_Budgeted_Expenses","alias":"FY2015 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2015, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2015_Actual_Expenses","alias":"FY2015 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2015, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2016_Budgeted_Expenses","alias":"FY2016 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2016, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2016_Actual_Expenses","alias":"FY2016 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2016, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2017_Budgeted_Expenses","alias":"FY2017 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2017, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2017_Actual_Expenses","alias":"FY2017 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2017, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2018_Budgeted_Expenses","alias":"FY2018 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2018, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2018_Actual_Expenses","alias":"FY2018 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2018, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2019_Budgeted_Expenses","alias":"FY2019 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2019, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2019_Actual_Expenses","alias":"FY2019 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2019, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2020_Budgeted_Expenses","alias":"FY2020 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2020, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2020_Actual_Expenses","alias":"FY2020 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2020, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2021_Budgeted_Expenses","alias":"FY2021 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2021, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2021_Actual_Expenses","alias":"FY2021 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2021, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2022_Budgeted_Expenses","alias":"FY2022 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2022, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2022_Actual_Expenses","alias":"FY2022 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2022, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2023_Budgeted_Expenses","alias":"FY2023 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2023, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2023_Actual_Expenses","alias":"FY2023 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2023, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2024_Budgeted_Expenses","alias":"FY2024 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2024, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2024_Actual_Expenses","alias":"FY2024 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2024, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2025_Budgeted_Expenses","alias":"FY2025 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2025, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2025_Actual_Expenses","alias":"FY2025 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2025, in dollars.\",\"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":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","isUpdatableView":true,"supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__METRO_BU__F4B70D85D7193181","isUnique":true,"description":"","fields":"OBJECTID","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"queryBinsCapabilities":{"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsFixedIntervalBin":true,"supportsStackBy":true,"supportsDateBin":true,"supportsSplitBy":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,"supportsReturnStackValueRange":true,"supportsClassificationBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","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,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":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,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"serviceItemId":"eed2428238124a05afd72bfa047fdcfa","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":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,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsColumnStoreIndex":true,"supportsLayerOverrides":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":false,"editingInfo":{"lastEditDate":1789491172353,"schemaLastEditDate":1789491172353,"dataLastEditDate":1772222389984},"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_Budget_to_Actual_Expenses_FY2010_Present__tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","description":"{\"value\":\"Unique system-generated identifier for each record.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fund","alias":"Fund","description":"{\"value\":\"Numeric code identifying the fund associated with the budget or expense record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fund_Description","length":8000,"alias":"Fund Description","description":"{\"value\":\"Name or description of the fund associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department","alias":"Department","description":"{\"value\":\"Numeric code identifying the department associated with the budget or expense record.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Description","length":8000,"alias":"Department Description","description":"{\"value\":\"Name or description of the department associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Business_Unit","alias":"Business Unit","description":"{\"value\":\"Numeric code identifying the business unit associated with the record.\",\"fieldValueType\":\"uniqueIdentifier\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Business_Unit_Description","length":8000,"alias":"Business Unit Description","description":"{\"value\":\"Name or description of the business unit associated with the record.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Object_Account","alias":"Object Account","description":"{\"value\":\"Numeric code identifying the object account for the budget or expense line item.\",\"fieldValueType\":\"typeOrCategory\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Object_Account_Description","length":8000,"alias":"Object Account Description","description":"{\"value\":\"Name or description of the object account category for the line item.\",\"fieldValueType\":\"nameOrTitle\"}","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2010_Budgeted_Expenses","alias":"FY2010 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2010, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2010_Actual_Expenses","alias":"FY2010 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2010, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2011_Budgeted_Expenses","alias":"FY2011 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2011, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2011_Actual_Expenses","alias":"FY2011 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2011, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2012_Budgeted_Expenses","alias":"FY2012 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2012, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2012_Actual_Expenses","alias":"FY2012 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2012, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2013_Budgeted_Expenses","alias":"FY2013 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2013, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2013_Actual_Expenses","alias":"FY2013 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2013, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2014_Budgeted_Expenses","alias":"FY2014 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2014, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2014_Actual_Expenses","alias":"FY2014 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2014, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2015_Budgeted_Expenses","alias":"FY2015 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2015, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2015_Actual_Expenses","alias":"FY2015 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2015, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2016_Budgeted_Expenses","alias":"FY2016 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2016, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2016_Actual_Expenses","alias":"FY2016 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2016, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2017_Budgeted_Expenses","alias":"FY2017 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2017, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2017_Actual_Expenses","alias":"FY2017 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2017, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2018_Budgeted_Expenses","alias":"FY2018 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2018, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2018_Actual_Expenses","alias":"FY2018 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2018, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2019_Budgeted_Expenses","alias":"FY2019 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2019, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2019_Actual_Expenses","alias":"FY2019 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2019, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2020_Budgeted_Expenses","alias":"FY2020 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2020, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2020_Actual_Expenses","alias":"FY2020 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2020, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2021_Budgeted_Expenses","alias":"FY2021 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2021, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2021_Actual_Expenses","alias":"FY2021 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2021, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2022_Budgeted_Expenses","alias":"FY2022 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2022, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2022_Actual_Expenses","alias":"FY2022 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2022, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2023_Budgeted_Expenses","alias":"FY2023 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2023, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2023_Actual_Expenses","alias":"FY2023 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2023, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2024_Budgeted_Expenses","alias":"FY2024 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2024, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2024_Actual_Expenses","alias":"FY2024 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2024, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2025_Budgeted_Expenses","alias":"FY2025 Budgeted Expenses","description":"{\"value\":\"Budgeted expenses for fiscal year 2025, in dollars.\",\"fieldValueType\":\"currency\"}","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","isViewOverride":true,"nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"FY2025_Actual_Expenses","alias":"FY2025 Actual Expenses","description":"{\"value\":\"Actual expenses for fiscal year 2025, in dollars.\",\"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_BU__F4B70D85D7193181","isUnique":true,"description":"","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":"eed2428238124a05afd72bfa047fdcfa","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query","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":1789491172353,"modifiedProvenance":"layer.editingInfo.lastEditDate","name":"Metro Budget to Actual Expenses (FY2010 - Present) ","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":34050,"region":"US","searchDescription":"Budgeted and actual expenses divided by fun, department, business unit, and account with details for each fiscal year.  This dataset is updated annually. Source Link: https://www.nashville.gov/departments/finance/management-and-budget/citizens-guide-budgetMetadata Document: Metro Budget to Actual Expenses (FY2010 - Present) Metadata.pdfContact Data Owner: opendata@nashville.gov","sector":"Local and State Government","server":{"supportedContingentValuesFormats":"JSON, PBF","allowGeometryUpdates":true,"supportsQueryContingentValues":true,"isView":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"],"supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"supportedConvertContentFormats":"LayerEditCollection","description":"","units":"esriFeet","isUpdatableView":true,"onlyAllowTrueCurveUpdatesByTrueCurveClients":false,"supportsSharedDomains":true,"hasStaticData":false,"syncEnabled":false,"tables":[{"subLayerIds":null,"maxScale":0,"name":"Metro_Budget_to_Actual_Expenses_FY2010_Present__tbl","defaultVisibility":true,"id":0,"minScale":0,"parentLayerId":-1}],"hasVersionedData":false,"layerOverridesEnabled":true,"layers":[],"supportedConvertFileFormats":"JSON,PBF","serviceItemId":"eed2428238124a05afd72bfa047fdcfa","fullExtent":null,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel","capabilities":"Query","supportsTrueCurve":true,"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,"supportedCurveTypes":["esriGeometryCircularArc"],"allowTrueCurvesUpdates":true,"supportsTemporalLayers":true,"serviceDescription":"","copyrightText":"","supportsLayerOverrides":true,"supportsSharedTemplates":true,"hasSharedTemplates":true,"supportedAppendCapabilities":"Features","supportedTrueCurvePbfFeatureEncodings":["esriCompressedShapeBuffer","esriDefault"],"trueCurveSupportMode":"OGC","maxIdsCount":1000000},"serverCapabilities":"Query","size":0,"slug":"Nashville::metro-budget-to-actual-expenses-fy2010-present-","source":"Nashville GIS","sourceProvenance":"org.name","statistics":{"objectid":{"objectid":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":716.2143829999986,"values":{"avg":17025.5,"min":1,"max":34050,"count":34050,"sum":579718275}}}},"numeric":{"fy2012_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":48713.182731277535,"min":-100400,"max":45833500,"var":415631681493.62195,"count":34050,"sum":1658683872,"stddev":644695.0298347444}}},"fy2010_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":52421.65652657865,"min":-5957021.44,"max":103661294.72,"var":1007181960437.8771,"count":34050,"sum":1784957404.7300029,"stddev":1003584.5556991583}}},"fy2010_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":46998.17876651982,"min":-462794,"max":75878600,"var":497584884209.2456,"count":34050,"sum":1600287987,"stddev":705396.9692373547}}},"fund":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":17965.01685756241,"min":10101,"max":35131,"var":132732775.1191026,"count":34050,"sum":611708824,"stddev":11520.971101391697}}},"object_account":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":502708.49800293683,"min":501101,"max":590002,"var":21537740.761197098,"count":34050,"sum":17117224357,"stddev":4640.877154288519}}},"fy2011_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":46592.479882525695,"min":-700000,"max":45819100,"var":381672705059.08844,"count":34050,"sum":1586473940,"stddev":617796.6534864756}}},"fy2011_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":55913.00261703381,"min":-2974007.38,"max":164791083.95,"var":1753658980260.8755,"count":34050,"sum":1903837739.1100013,"stddev":1324257.8979416643}}},"department":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":45.94581497797357,"min":1,"max":91,"var":649.4215697563616,"count":34050,"sum":1564455,"stddev":25.483751092732827}}},"business_unit":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":46063379.21022026,"min":1101104,"max":91112900,"var":649074295161312.2,"count":34050,"sum":1568458062108,"stddev":25476936.534075525}}},"fy2012_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":269.8297770000063,"values":{"avg":59657.43675154184,"min":-694409.15,"max":248449894.65,"var":2588722724591.885,"count":34050,"sum":2031335721.3899996,"stddev":1608950.8148454647}}},"fy2017_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":63002.196850513916,"min":-7649600,"max":92721000,"var":1075486943490.3522,"count":34050,"sum":2145224802.7599988,"stddev":1037056.8660832212}}},"fy2014_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":53154.776137738845,"min":-48204.81,"max":60399187.77,"var":600745062315.8842,"count":34050,"sum":1809920127.4900076,"stddev":775077.4556880649}}},"fy2014_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":54098.57268722467,"min":-1043800,"max":52114700,"var":608976770547.2919,"count":34050,"sum":1842056400,"stddev":780369.6371254406}}},"fy2017_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":65305.2849606463,"min":-666445.04,"max":113347203.4,"var":1280726437312.7349,"count":34050,"sum":2223644952.9100065,"stddev":1131691.8473297998}}},"fy2013_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":51562.003847283406,"min":-417200,"max":49896200,"var":485466769058.1102,"count":34050,"sum":1755686231,"stddev":696754.4539205403}}},"fy2016_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":70132.50947753323,"min":-436488,"max":280386840.51,"var":3431489761035.7373,"count":34050,"sum":2388011947.710006,"stddev":1852428.0717576426}}},"fy2015_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":57185.48609339203,"min":-4775547,"max":60735000,"var":741935373659.9142,"count":34050,"sum":1947165801.4799986,"stddev":861356.7052388425}}},"fy2013_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":63309.20812422911,"min":-252766.91,"max":235033630.45,"var":2896659623924.013,"count":34050,"sum":2155678536.630001,"stddev":1701957.5858181699}}},"fy2015_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":61257.942373862184,"min":-285967.08,"max":114235260.17,"var":1168512077283.967,"count":34050,"sum":2085832937.8300073,"stddev":1080977.3713098564}}},"fy2016_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":337.66412599998876,"values":{"avg":59113.64757709251,"min":-12641780,"max":73008000,"var":849144238858.0807,"count":34050,"sum":2012819700,"stddev":921490.2272178911}}},"fy2019_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":67492.67844581495,"min":-18340563.2,"max":130552500,"var":1543076577525.7112,"count":34050,"sum":2298125701.079999,"stddev":1242206.3345216492}}},"fy2019_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":66290.83378032284,"min":-708645.88,"max":129579575.67,"var":1482024320364.6616,"count":34050,"sum":2257202890.2199926,"stddev":1217384.212303027}}},"fy2022_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":79988.72246696035,"min":-25607200,"max":184600000,"var":2711104905195.143,"count":34050,"sum":2723616000,"stddev":1646543.320169604}}},"fy2020_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":70914.50029368575,"min":-13126136,"max":137992900,"var":1851643819843.344,"count":34050,"sum":2414638735,"stddev":1360751.1968921225}}},"fy2021_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":72112.60499265786,"min":-2366900,"max":163197600,"var":2017619208856.1736,"count":34050,"sum":2455434200,"stddev":1420429.2340191305}}},"fy2021_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":89026.93590837,"min":-4192268.74,"max":409331354.46,"var":7952160967088.199,"count":34050,"sum":3031367167.6799984,"stddev":2819957.617959568}}},"fy2018_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":65305.2849606463,"min":-666445.04,"max":113347203.4,"var":1280726437312.7349,"count":34050,"sum":2223644952.9100065,"stddev":1131691.8473297998}}},"fy2018_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":67216.46156593227,"min":-14785376.160000004,"max":112389200,"var":1361968216694.2974,"count":34050,"sum":2288720516.319994,"stddev":1167033.9398210736}}},"fy2022_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":78356.49159353926,"min":-9542840.16,"max":188143216.57,"var":2609875555770.455,"count":34050,"sum":2668038538.760012,"stddev":1615510.9271591}}},"fy2020_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":1014.9392949999965,"values":{"avg":67655.71595183527,"min":-119933.12,"max":134418112.09,"var":1536511146654.7598,"count":34050,"sum":2303677128.159991,"stddev":1239560.8684751063}}},"fy2023_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":202.25489900000684,"values":{"avg":90116.11156358306,"min":-3971000,"max":194834745.6,"var":3327913042367.0986,"count":34050,"sum":3068453598.740003,"stddev":1824256.8466000336}}},"fy2024_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":202.25489900000684,"values":{"avg":102909.5007342144,"min":-7400,"max":212395700,"var":4331131136363.3745,"count":34050,"sum":3504068500,"stddev":2081136.9816432975}}},"fy2024_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":202.25489900000684,"values":{"avg":101507.06343259946,"min":-10256808.72,"max":207442884.05,"var":4055949971226.4795,"count":34050,"sum":3456315509.8800116,"stddev":2013938.9194378462}}},"fy2023_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":202.25489900000684,"values":{"avg":91421.52422907489,"min":-130000,"max":190395700,"var":3459182142160.8535,"count":34050,"sum":3112902900,"stddev":1859887.6692318958}}},"fy2025_actual_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":202.25489900000684,"values":{"avg":100427.63899148273,"min":-10717744.35,"max":190705715.83,"var":3350432172316.5244,"count":34050,"sum":3419561107.659987,"stddev":1830418.5784449754}}},"fy2025_budgeted_expenses":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":202.25489900000684,"values":{"avg":99470.12628487518,"min":-7232500,"max":205847900,"var":3731661872763.761,"count":34050,"sum":3386957800,"stddev":1931750.9862204706}}}},"string":{"fund_description":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":305.81476900000416,"values":[{"count":22999,"value":"GSD General"},{"count":10495,"value":"MNPS General Purpose"},{"count":468,"value":"USD General"},{"count":33,"value":"GSD Debt Service"},{"count":28,"value":"MNPS Debt Service"},{"count":27,"value":"USD Debt Service"}],"count":34050,"uniqueCount":6}},"department_description":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":445.45246799999586,"values":[{"count":10523,"value":"MNPS"},{"count":3160,"value":"Police"},{"count":2660,"value":"Parks"},{"count":2240,"value":"Public Library"},{"count":2098,"value":"Sheriff"},{"count":1694,"value":"Health"},{"count":1248,"value":"Nashville Department of Transportation"},{"count":1110,"value":"Fire"},{"count":1047,"value":"Juvenile Court"},{"count":792,"value":"Finance"},{"count":703,"value":"Administrative"},{"count":620,"value":"Social Services"},{"count":533,"value":"Planning Commission"},{"count":480,"value":"Human Resources"},{"count":471,"value":"General Services"},{"count":362,"value":"Codes Administration"},{"count":349,"value":"General Sessions Court"},{"count":342,"value":"Public Defender"},{"count":246,"value":"Law"},{"count":240,"value":"Department of Emergency Communications"},{"count":221,"value":"Mayor's Office"},{"count":196,"value":"Arts Commission"},{"count":191,"value":"Justice Integration Services"},{"count":175,"value":"Election Commission"},{"count":149,"value":"Historical Commission"},{"count":140,"value":"Human Relations Commission"},{"count":132,"value":"Information Technology Service"},{"count":127,"value":"State Trial Courts"},{"count":122,"value":"Metropolitan Clerk"},{"count":119,"value":"Beer Board"},{"count":119,"value":"Internal Audit"},{"count":112,"value":"Agricultural Extension"},{"count":102,"value":"X-Transportation Licensing"},{"count":97,"value":"Soil and Water Conservation"},{"count":91,"value":"Assessor of Property"},{"count":91,"value":"District Attorney"},{"count":82,"value":"County Clerk"},{"count":82,"value":"Office of Homeless Services"},{"count":72,"value":"Criminal Court Clerk"},{"count":69,"value":"Juvenile Court Clerk"},{"count":67,"value":"Metropolitan Council"},{"count":67,"value":"Trustee"},{"count":60,"value":"Clerk and Master - Chancery"},{"count":60,"value":"Debt Service"},{"count":58,"value":"Office of Emergency Management"},{"count":56,"value":"Circuit Court Clerk"},{"count":51,"value":"Office of Family Safety"},{"count":50,"value":"Community Oversight Board"},{"count":47,"value":"Community Education Commission"},{"count":46,"value":"Community Review Board"}],"count":34050,"uniqueCount":54}},"object_account_description":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":574.7833759999994,"values":[{"count":862,"value":"Employer Group Health"},{"count":862,"value":"Regular Pay"},{"count":860,"value":"Employer OASDI"},{"count":858,"value":"Employer Pension"},{"count":850,"value":"Employer SSN Medical"},{"count":808,"value":"Employer Group Life"},{"count":802,"value":"Employer Dental Group"},{"count":714,"value":"Offc & Admin Supply"},{"count":646,"value":"Employee Local Travel/Park"},{"count":607,"value":"Overtime Pay"},{"count":600,"value":"Registration"},{"count":569,"value":"Printing/Binding"},{"count":536,"value":"Employee Out-of-town Travel"},{"count":528,"value":"Cafe Plan Pre-Tax Savings"},{"count":521,"value":"Other Rpr & Maint Srvc"},{"count":516,"value":"Leave Pay"},{"count":503,"value":"Longevity"},{"count":475,"value":"Rent Equipment"},{"count":468,"value":"Injured on Duty Pay"},{"count":458,"value":"Membership Dues"},{"count":453,"value":"Holiday Pay"},{"count":449,"value":"FSA Pre-Tax Savings"},{"count":438,"value":"YE Biweekly Sal/Fringe Accr"},{"count":436,"value":"Host & Hostess"},{"count":422,"value":"Management Consultant"},{"count":390,"value":"Educational Supply"},{"count":371,"value":"Shift Differential Pay"},{"count":370,"value":"Computer Software"},{"count":367,"value":"Furniture/Fixtures<$10K"},{"count":350,"value":"Subscriptions"},{"count":347,"value":"Advertising & Promot'n"},{"count":344,"value":"Postage & Delivery Srvc"},{"count":339,"value":"Other Special Pay"},{"count":333,"value":"Computer Hardware <$10K"},{"count":327,"value":"FY11 2% Adjustment"},{"count":325,"value":"Out of Class Pay"},{"count":316,"value":"Paid Family Leave"},{"count":313,"value":"FY12 1.5% Adjustment"},{"count":300,"value":"Allowance-Cell/Mobile Devices"},{"count":289,"value":"Books/Magazines/Periodicals"},{"count":282,"value":"Small Equipment Supply"},{"count":282,"value":"Software License"},{"count":262,"value":"Transfer Operational"},{"count":260,"value":"MNPS Emp'r Pension TCRS"},{"count":256,"value":"Telecmmnct'n Charge"},{"count":255,"value":"Electric"},{"count":250,"value":"Repair & Maint Supply"},{"count":242,"value":"Gas"},{"count":234,"value":"Water"},{"count":233,"value":"Employee Air Travel"}],"count":34050,"uniqueCount":443}},"business_unit_description":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":3330.7602630000038,"values":[{"count":133,"value":"SHE Admin Support Svcs Key"},{"count":118,"value":"PAR Sportsplex"},{"count":115,"value":"PAR McCabe Golf Course"},{"count":111,"value":"NDOT GSD Administration"},{"count":108,"value":"PAR Facility Repair Sessions"},{"count":108,"value":"PAR Harpeth Hills Golf Course"},{"count":107,"value":"NDOT GSD Roadway Maintenance"},{"count":105,"value":"PAR Comm Ctr Drop-in Activitie"},{"count":104,"value":"PAR Shelby Park Golf Course"},{"count":103,"value":"LIB Operation and Maintenance"},{"count":103,"value":"PAR Ted Rhodes Golf Course"},{"count":100,"value":"HEA ALOB Facilities Mgmt"},{"count":98,"value":"PAR Grass Mowing Sessions"},{"count":97,"value":"PAR Non Allocated Fin Trans"},{"count":96,"value":"PAR Two Rivers Golf Course"},{"count":91,"value":"PAR Warner Golf Course"},{"count":87,"value":"SHE CDC-M Offend Mgmt Key"},{"count":87,"value":"STC Administration"},{"count":85,"value":"GSR BOSS Building Services"},{"count":85,"value":"LIB Administrative Support"},{"count":85,"value":"MNPS Maintenance"},{"count":85,"value":"PAR Parthenon"},{"count":85,"value":"SHE MC2 Offender Management"},{"count":84,"value":"DA Administration"},{"count":84,"value":"PAR Environmental Ed Prog"},{"count":84,"value":"PAR Wave Country"},{"count":83,"value":"MNPS Curriculum & Instruction"},{"count":83,"value":"PAR Arts/History Classes"},{"count":82,"value":"HEA Animal Services All Other"},{"count":82,"value":"POL ALOB Executive Leadersh"},{"count":82,"value":"SHE CJC Offender Mgmt Key"},{"count":81,"value":"PAR Vinny Links Golf Course"},{"count":80,"value":"SHE Correct Svcs Key"},{"count":79,"value":"PDF Criminal Court Team"},{"count":79,"value":"SHE ORC Offend Mgmt Key"},{"count":78,"value":"SHE Training Key"},{"count":77,"value":"MNPS Transportation"},{"count":76,"value":"x-LIB ALOB Building Cleanings"},{"count":75,"value":"COU Admin"},{"count":75,"value":"POL Aviation Section"},{"count":75,"value":"POL Specialized Investigations"},{"count":74,"value":"SHE Transportation Key"},{"count":73,"value":"MNPS Business Office"},{"count":73,"value":"POL Patrol Central Sector Key"},{"count":73,"value":"SHE DDC Offender Management"},{"count":72,"value":"PAR Dept Leadership Sessions"},{"count":72,"value":"PAR Park Police Patrols"},{"count":72,"value":"POL Crime Lab"},{"count":71,"value":"ELE Election Comm Operating"},{"count":71,"value":"JUV ALOB HR Key Product"}],"count":34050,"uniqueCount":1263}}}},"structuredLicense":{"type":"none"},"license":"none","supportedQueryFormats":"JSON, geoJSON, PBF","supportsAdvancedQueries":true,"tags":["budget","expense","finance","cost","expenditure","money","department","fund","business"],"thumbnail":"thumbnail/thumbnail1677015452307.png","thumbnailUrl":"thumbnail/thumbnail1677015452307.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_Budget_to_Actual_Expenses_(FY2010_-_Present)_/FeatureServer/0","useStandardizedQueries":true,"validExtent":true,"xFrameOptions":null,"boundary":null,"snippet":"Metro Budget to Actual Expenses (FY2010 - Present)","culture":""},"links":{"self":"https://hub.arcgis.com/api/v3/datasets/eed2428238124a05afd72bfa047fdcfa_0","rawEs":"https://hub.arcgis.com/api/es/datasets/eed2428238124a05afd72bfa047fdcfa_0","itemPage":"https://www.arcgis.com/home/item.html?id=eed2428238124a05afd72bfa047fdcfa","esriRest":"https://www.arcgis.com/sharing/content/items/eed2428238124a05afd72bfa047fdcfa?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/eed2428238124a05afd72bfa047fdcfa_0"}}