Warning: Table './archive_cnu/cache_page' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_page WHERE cid = 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database' in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:62:\"Non-static method view::load() should not be called statically\";s:5:\"%file\";s:100:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/views.module\";s:5:\"%line\";i:906;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:134:\"Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state)\";s:5:\"%file\";s:121:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/handlers/views_handler_filter.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:130:\"Declaration of views_handler_filter::options_submit() should be compatible with views_handler::options_submit($form, &$form_state)\";s:5:\"%file\";s:121:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/handlers/views_handler_filter.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:154:\"Declaration of views_handler_filter_boolean_operator::value_validate() should be compatible with views_handler_filter::value_validate($form, &$form_state)\";s:5:\"%file\";s:138:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/handlers/views_handler_filter_boolean_operator.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:151:\"Declaration of views_handler_filter_term_node_tid::value_validate() should be compatible with views_handler_filter::value_validate($form, &$form_state)\";s:5:\"%file\";s:143:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/modules/taxonomy/views_handler_filter_term_node_tid.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:102:\"Declaration of views_plugin_style_default::options() should be compatible with views_object::options()\";s:5:\"%file\";s:126:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/plugins/views_plugin_style_default.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:130:\"Declaration of views_plugin_row::options_validate() should be compatible with views_plugin::options_validate(&$form, &$form_state)\";s:5:\"%file\";s:116:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/plugins/views_plugin_row.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:126:\"Declaration of views_plugin_row::options_submit() should be compatible with views_plugin::options_submit(&$form, &$form_state)\";s:5:\"%file\";s:116:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/plugins/views_plugin_row.inc\";s:5:\"%line\";i:0;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:62:\"Non-static method view::load() should not be called statically\";s:5:\"%file\";s:100:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/contrib-stable/views/views.module\";s:5:\"%line\";i:906;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495719) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:78:\"Non-static method PEAR_ErrorStack::singleton() should not be called statically\";s:5:\"%file\";s:103:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/packages/PEAR/ErrorStack.php\";s:5:\"%line\";i:983;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:212:\"Declaration of CRM_Core_Error::singleton() should be compatible with & PEAR_ErrorStack::singleton($package, $msgCallback = false, $contextCallback = false, $throwPEAR_Error = false, $stackClass = \'PEAR_Error...\')\";s:5:\"%file\";s:93:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/Error.php\";s:5:\"%line\";i:52;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:78:\"Non-static method PEAR_ErrorStack::singleton() should not be called statically\";s:5:\"%file\";s:93:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/Error.php\";s:5:\"%line\";i:625;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:74:\"Non-static method PEAR::setErrorHandling() should not be called statically\";s:5:\"%file\";s:94:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/Config.php\";s:5:\"%line\";i:183;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:117:\"Declaration of CRM_Utils_System_Drupal6::cmsRootPath() should be compatible with CRM_Utils_System_Base::cmsRootPath()\";s:5:\"%file\";s:103:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Utils/System/Drupal6.php\";s:5:\"%line\";i:41;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:82:\"Non-static method CRM_Core_Config::isUpgradeMode() should not be called statically\";s:5:\"%file\";s:105:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/BAO/ConfigSetting.php\";s:5:\"%line\";i:199;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:82:\"Non-static method CRM_Core_Config::isUpgradeMode() should not be called statically\";s:5:\"%file\";s:105:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/BAO/ConfigSetting.php\";s:5:\"%line\";i:228;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:74:\"Non-static method PEAR::setErrorHandling() should not be called statically\";s:5:\"%file\";s:93:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/Error.php\";s:5:\"%line\";i:532;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:74:\"Non-static method PEAR::setErrorHandling() should not be called statically\";s:5:\"%file\";s:93:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/Error.php\";s:5:\"%line\";i:567;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:14:\"strict warning\";s:8:\"%message\";s:74:\"Non-static method PEAR::setErrorHandling() should not be called statically\";s:5:\"%file\";s:93:\"/var/www/archive.cnu.org/htdocs/sites/cnu.civicactions.net/modules/civicrm/CRM/Core/Error.php\";s:5:\"%line\";i:567;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135
Exciting New Database | Congress for the New Urbanism

Exciting New Database

MLewyn's picture

The Lincoln Institute of Land Policy just came out with a fun new database of fiscal information about cities.   A few of the things I learned after playing around in the database for an hour:

*Highways and transit are really a pretty minor part of most cities' budgets.  In the average city, highway and transit spending combined were $212 per capita, only about 7 percent of all local expenditures (just over $3,100 per capita).  By contrast, education gobbled up about 12 percent of municipal spending, and public safety about 18 percent.  So I'm not sure we need worry about either highways or transit bankrupting cities.  The most sprawl-happy cities don't seem to spend more than more compact cities; for example, 800-square mile Jacksonville spent only about 5 percent of its budget on roads and transit (although electric utility spending, which I suppose might be greater in more sprawling areas, were a significant part of the Jacksonville budget).

*Despite media commentary blaming Detroit's bankruptcy on overspending, Detroit spending actually went down in the 2000s ,from $7789 per capita in 2003 to $4852 in 2010 (adjusting for inflation). (On the other hand, I note that the city's budget increased during the 1990s).  Detroit does spend more money than the average city, but by no means has the largest government.  Detroit spends about $4800 per capita, less than such relatively conservative cities as Knoxville and Chattanooga. 

*The most tax-happy cities were Washington, New York, Boston and San Francisco.  However, this does not mean that older, more compact cities always have higher taxes: Chicago and Portland actually had below-average tax levels per capita, while Richmond and Virginia Beach were in the national "top 10" of taxation.   Only six cities (not counting large suburbs such as Garland, Texas) had tax levels below $500 per capita: Bakersfield, Las Vegas, Flint, Jackson, Wichita and Tuscon.  Flint has been economically depressed for a long time, and Las Vegas has suffered horribly from the recession - a fact suggesting that low taxes indicate poverty more than lean government.  On the other hand, the high-tax cities, though not rapidly growing, are not losing population either; dying Rust Belt cities such as Detroit and Cleveland tend to have fairly average tax levels. 

*The Lincoln Institute also has a "fiscally standardized cities" variable, to account for local spending by counties, school districts, and special districts.  The top taxers were still New York, Washington, and San Francisco (although Atlanta of all places was fourth). The lowest tax burden was in Flint, with a variety of small and mid-sized cities close behind (including Grand Rapids and Modesto).

 

 

Comments

Write your comments in the box below and share on your Facebook!

 

Warning: Table './archive_cnu/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:0:\"\";s:5:\"%file\";s:50:\"/var/www/archive.cnu.org/htdocs/includes/cache.inc\";s:5:\"%line\";i:112;}', 3, '', 'http://archive.cnu.org/cnu-salons/2013/09/exciting-new-database', '', '3.21.100.34', 1713495720) in /var/www/archive.cnu.org/htdocs/includes/database.mysql.inc on line 135