ALBERT

Note: Contents: Managing Water, Soil, and Waste in the Context of Global Change ; Climate Change Adaptation ; Climate Change Impacts and Adaptation in Water and Land Context ; Climate Change, Profligacy, Poverty and Destruction: All Things Are Connected ; Urbanization as a Main Driver of Global Change ; A Nexus Approach to Urban and Regional Planning Using the Four-Capital Framework of Ecological Economics ; The Urban Water–Energy Nexus: Building Resilience for Global Change in the “Urban Century” ; Population Growth and Increased Demand for Resources ; Role of Soils for Satisfying Global Demands for Food, Water, and Bioenergy ; Implications of the Nexus Approach When Assessing Water and Soil Quality as a Function of Solid and Liquid Waste Management

Note: Contents: Introduction ; Crisis, Reform and Innovation in Local Government ; Political and Administrative Decentralization in Portugal: Four Decades of Democratic Local Government ; Why and When Countries Implement Local Public Administration Reforms: A Long-Term View of Reform Dynamics in Slovakia, 1990–2015 ; Local Self-Government in Hungary: The Impact of Crisis ; Local Government Innovation in Italy and its Impact on Urban and Regional Planning with a Focus on the Milanese Context ; Eu Policies, The Urban Agenda and Local Governance ; Urban Dimension of the European Policies and the New EU Urban Agenda in Croatia ; The Relationship Between the European Commission and Local Government Through European Urban Initiatives: Constraints and Solidarities ; Mega-Events and New Patterns of Cooperation: The European Capitals of Culture ; Urban Regeneration and Local Governance in Italy: Three Emblematic Cases ; Involving Citizens in the Reuse and Regeneration of Urban Peripheral Spaces ; Citizen Participation in Local Self-Government ; Assessment of Socio-Economic Status Relevance for Latvian Electoral Participation ; Making Informed Citizens in Local Direct Democracy. What Part Does Their Government Perform?

Note: Contents 1 Nitrogen Excretion in Aquatic Crustaceans / Dirk Weihrauch, Sandra Fehsenfeld, and Alex Quijada-Rodriguez 2 Nitrogenous Waste Metabolism Within Terrestrial Crustacea, with Special Reference to Purine Deposits and Their Metabolism / Stuart M. Linton, Jonathan C. Wright, and Caitlin G. Howe 3 Gill Ion Transport ATPases and Ammonia Excretion in Aquatic Crustaceans / Francisco A. Leone, Malson N. Lucena, Daniela P. Garçon, Marcelo R. Pinto, and John C. McNamara 4 Nitrogen Excretion and Metabolism in Insects / M. J. O’Donnell and Andrew Donini 5 Nitrogen Excretion in Nematodes, Platyhelminthes, and Annelids / Alex R. Quijada-Rodriguez, Aida Adlimoghaddam, and Dirk Weihrauch 6 Acid–Base Regulation in Aquatic Decapod Crustaceans / Sandra Fehsenfeld and Dirk Weihrauch 7 Cell Biology of Reef-Building Corals: Ion Transport, Acid/Base Regulation, and Energy Metabolism / Martin Tresguerres, Katie L. Barott, Megan E. Barron, Dimitri D. Deheyn, David I. Kline, and Lauren B. Linsmayer 8 Acid–Base Regulation in Insect Haemolymph / Philip G.D. Matthews 9 Acid–Base Loops in Insect Larvae with Extremely Alkaline Midgut Regions / Horst Onken and David F. Moffett 10 pH Regulation and Excretion in Echinoderms / Meike Stumpp and Marian Y. Hu 11 Acid–Base Regulation and Ammonia Excretion in Cephalopods: An Ontogenetic Overview / Marian Hu and Yung-Che Tseng Service Part Index

Note: Contents 1 “Data Science” and “Big Data” 1.1 Transport Data Science Examples 1.1.1 Origin-Destination Analysis on the London Orbital Motorway 1.1.2 Airline Pricing and Arbitrage 1.1.3 Pothole Monitoring 1.1.4 Foursquare 1.1.5 Self-driving Cars 1.1.6 Taxi Services 1.2 The Claim 1.3 Definitions 1.4 Relationship with Other Fields 1.5 Ethics 1.6 Cynical Views 1.7 Exercise: itsleeds Virtual Desktop Setup 1.8 Further Reading 1.9 Appendix: Native Installation 2 Python for Data Science Primer 2.1 Programming Skills Check 2.2 Programming Languages 2.3 Programming Environment 2.4 Core Language 2.4.1 Lists 2.4.2 Dictionaries 2.4.3 Control Structures 2.4.4 Files 2.4.5 Functions 2.5 Libraries 2.5.1 Modules 2.5.2 Mathematics 2.5.3 Plotting 2.5.4 Data Frames 2.5.5 Debugging 2.6 Further Reading 3 Database Design 3.1 Before the Relational Model 3.2 Picturing the World 3.2.1 Ontology 3.2.2 Philosophical Ontology 3.2.3 Data Ontology 3.2.4 Structured Query Language (SQL) 3.3 Exercises 3.3.1 Setting up PostgreSQL 3.3.2 SQL Creation Language 3.3.3 SQL Query Language 3.3.4 SQL Python Binding 3.3.5 Importing Vehicle Bluetooth Data 3.4 Further Reading 4 Data Preparation 4.1 Obtaining Data 4.2 Basic Text Processing 4.3 Formal Grammar: The Chomsky Hierarchy 4.3.1 Regular Languages (Type 3) 4.3.2 Context-Free Languages (Type 2) 4.3.3 Beyond CFGs (Types 1 and 0) 4.4 Special Types 4.4.1 Strings and Numbers 4.4.2 Dates and Times 4.4.3 National Marine Electronics Association (NMEA) Format 4.5 Common Formats 4.6 Cleaning 4.7 B + Tree Implementation 4.8 Exercises 4.8.1 Reading the Database with Pandas 4.8.2 printf Notation 4.8.3 DateTimes 4.8.4 Time Alignment and Differencing 4.8.5 Parsing 4.8.6 Vehicle Bluetooth Munging 4.9 Further Reading 5 Spatial Data 5.1 Geodesy 5.2 Global Navigation Satellite System (GNSS) 5.3 Geographic Information Systems (GIS) 5.3.1 Role of GIS System 5.3.2 Spatial Ontology 5.3.3 Spatial Data Structures 5.4 Implementations 5.4.1 Spatial Files 5.4.2 Spatial Data Sources 5.4.3 Spatial Databases 5.4.4 Spatial Data Frames 5.5 Exercises 5.5.1 GPS Projections 5.5.2 PostGIS 5.5.3 GeoPandas 5.5.4 QGIS Road Maps 5.5.5 Plotting Open Street Map (OSM) Roads 5.5.6 Obtaining OSM Data 5.5.7 Bluetooth Traffic Sensor Sites 5.6 Further Reading 6 Bayesian Inference 6.1 Bayesian Inference Versus “Statistics” 6.2 Motorway Journey Times 6.3 Bayesian Inference 6.3.1 Bayes’ Theorem 6.3.2 Legal Inference: A Pedestrian Hit-and-Run Incident 6.3.3 Priors and Posteriors 6.3.4 Road User Tracking 6.4 Bayesian Networks 6.4.1 Bayesian Network for Traffic Lights 6.4.2 Bayesian Network for Traffic Accidents 6.4.3 Reporting 6.4.4 Car Insurance 6.5 Priors and Prejudice 6.6 Causality 6.7 Model Comparison and Combination 6.8 Exercises 6.8.1 Inferring Traffic Lights with PyMC3 6.8.2 Inferring Accident Road State Change with PyMC3 6.8.3 Switching Poisson Journey Times 6.9 Further Reading 7 Machine Learning 7.1 Generative Versus Discriminative Vehicle Emissions 7.2 Simple Classifiers 7.2.1 Linear Discriminant Analysis (LDA) 7.2.2 Nearest Neighbor 7.2.3 Template Matching 7.2.4 Naïve Bayes Classification 7.2.5 Decision Trees 7.3 Neural Networks and “Deep Learning” 7.3.1 Parallel Computing Back-Propagation 7.4 Limitations and Extensions 7.5 Exercises 7.6 Further Reading 8 Spatial Analysis 8.1 Spatial Statistics 8.2 Bayesian Spatial Models 8.2.1 Markov Random Fields (MRF) 8.2.2 Gaussian Processes (Kriging) 8.3 Vehicle Routing 8.3.1 Link-breaking 8.4 Spatial Features 8.5 Exploratory Analysis 8.6 Scaling Issues 8.7 Exercises 8.7.1 Gaussian Processes in GPy 8.7.2 Gaussian Process Traffic Densities 8.7.3 Vehicle Routing with PostGIS 8.7.4 Finding Roadside Sensor Sites 8.8 Further Reading 9 Data Visualisation 9.1 Visual Perception 9.1.1 Colours 9.1.2 Visual Attention 9.2 Geographic Visualization (Maps) 9.2.1 Traffic Flow Maps 9.2.2 Slippy Maps 9.2.3 Info-Graphics 9.3 Exercises 9.3.1 Web Page Maps with Leaflet 9.3.2 Bluetooth Origin-Destination Flows 9.3.3 Large Project Suggestions 9.4 Further Reading 10 Big Data 10.1 Medium-Sized Data Speedups 10.2 Enterprise Data Scaling 10.3 CAP Theorem 10.4 Big Data Scaling 10.4.1 Data “Lakes” 10.4.2 Grid Computing 10.4.3 Map-Reduce and Cloud Computing 10.4.4 Hadoop Ecosystem 10.4.5 Non-relational Databases (“NoSQL”) 10.4.6 Distributed Relational Databases (“NewSQL”) 10.5 Exercises 10.5.1 Prolog AI Car Insurance Queries 10.5.2 Map-Reduce on Vehicle Bluetooth Data 10.5.3 Setting up Hadoop and Spark 10.5.4 Finding Vehicle Matches in Hadoop 10.5.5 Traffic Flow Prediction with Spark 10.5.6 Large Project Suggestions 10.6 Further Reading 11 Professional Issues 11.1 Morals, Ethics, and Law 11.2 Ethical Issues 11.2.1 Privacy 11.2.2 De-anonymization (“Doxing”) 11.2.3 Predictive Analytics 11.2.4 Social and Selfish Equilibria 11.2.5 Monetization 11.2.6 Ontological Bias 11.2.7 p-hacking 11.2.8 Code Quality 11.2.9 Agency Conflicts 11.2.10 Server Jurisdiction 11.2.11 Security Services 11.3 UK Legal Framework 11.3.1 Data Protection Act 1988 11.3.2 General Data Protection Regulation (GPDR) 11.4 Role of the Data Scientist 11.5 Exercises 11.6 Further Reading Index

Note: Contents Part I Introduction to Scientific Python 1 Bird’s Eye View 2 Visualization 3 Fast Python: NumPy and Cython Part II Second Part: Mechanics 4 Mechanics I: Kinematics 5 Mechanics II: Newtonian Dynamics 6 Physics of Stokes Flow Part III Lattice Methods 7 Lagrangian Transport 8 Operator Formulation 9 Laplacian Operator and Diffusion 10 Beyond Linearity Part IV Advanced Techniques 11 Trees, Particles, and Boundaries 12 Applications to Geodynamics 13 The Future References Index

Note: Contents Part I Introduction 1 Famines: At the Interface of Nature and Society / Dominik Collet and Maximilian Schuh Part II Interdisciplinary Approaches 2 The European Mortality Crises of 1346–52 and Advent of the Little Ice Age / Bruce M.S. Campbell 3 Combining Written and Tree-Ring Evidence to Trace Past Food Crises: A Case Study from Finland / Heli Huhtamaa Part III Socionatural Entanglements 4 Two Decades of Crisis: Famine and Dearth During the 1480s and 1490s in Western and Central Europe / Chantal Camenisch 5 Climate and Famines in the Czech Lands Prior to AD 1500: Possible Interconnections in a European Context / Rudolf Brázdil, Oldřich Kotyza and Martin Bauch 6 Food Insecurity and Political Instability in the Southern Red Sea Region During the ‘Little Ice Age,’ 1650–1840 / Steven Serels Part IV Coping 7 The Role of Climate and Famine in the Medieval Eastern Expansion / Andreas Rüther 8 Famines in Late Medieval and Early Modern Italy: A Test for an Advanced Economy / Guido Alfani 9 Bread for the Poor: Poor Relief and the Mitigation of the Food Crises of the 1590s and the 1690s in Berkel, Holland / Jessica Dijkman 10 Educationalizing Hunger. Dealing with the Famine of 1770/71 in Zurich / Andrea De Vincenti Part V Perceiving and Remembering 11 Starvation Under Carolingian Rule. The Famine of 779 and the Annales Regni Francorum / Stephan Ebert 12 Staging the Return to Normality. Socio-cultural Coping Strategies with the Crisis of 1816/1817 / Maren Schulz 13 Remembering Hunger. Museums and the Material Culture of Famine / Andrea Fadani

Note: Contents In Search of New Narratives for Informed Decisions on Climate Change Crisis in the African Drylands / Aliyu Barau and Adamu Idris Tanko Assessing High School Student Perceptions and Comprehension of Climate Change / Ulisses M. Azeiteiro, P. Bacelar-Nicolau, P. T. Santos, L. Bacelar-Nicolau and F. Morgado A Sustainability Livelihood Approach (SLA) Model for Assessing Disaster Preparedness and Resilience of the People: Case Study of Cox’s Bazar Sadar Upazila in Bangladesh / Md. Mokhlesur Rahman and Weifeng Li Loving Glacier National Park Online: Climate Change Communication and Virtual Place Attachment / Salma Monani, Sarah Principato, Dori Gorczyca and Elizabeth Cooper Understanding Communication Needs: A Marikina Barangay Experience Linking Flooding to Climate Change Communication / Charlotte Kendra Gotangco and Inez Ponce de Leon Climate: The Great Maestro of Life on Earth. History, Didactics and Case Studies / Maria Rosário Bastos, Joana Gaspar de Freitas and João Pedro Cunha Ribeiro Children Communicating on Climate Change: The Case of a Summer Camp at a Greek Island / Constantina Skanavis and Aristea Kounani Communicating the IPCC: Challenges and Opportunities / Jonathan Lynn Performative Methods for Climate Change Communication in Academic Settings: Case Study of the Freiburg Scientific Theatre / Sadhbh Juárez-Bourke Watershed Discipleship: Communicating Climate Change Within a Christian Framework: A Case Study Analysis / Cherice Bock Assessment of Outdoor Workers Perception Working in Extreme Hot Climate / Haruna Musa Moda and Abdullah Alshahrani Games for Knowledge Transfer and as a Stimulus for Climate Change Mitigation in Agriculture—Lessons Learned from a Game Prototype / Anja Hansen, Kathrin Schneider and Johanna Lange Climate Impacts for German Schools—An Educational Web Portal Solution / Ines Blumenthal, Carolin Schlenther, Simon Hirsbrunner, Manfred Stock and Thomas Nocke Communicating Climate Change in a Museum Setting—A Case Study / Bettina C. Lackner, Sajeev Erangu Purath Mohankumar, Matthias Damert, Daniel Petz, Lukas Meyer, Roman Klug and Barbara Reiter Climate Change Communication in Higher Education Institutions: The Case of the North-West University in South Africa / Paola Villavicencio Calzadilla, Romain Mauger and Anél Du Plessis Traditional Ecological Knowledge as a Contribution to Climate Change Mitigation and Adaptation: The Case of the Portuguese Coastal Populations / Joana Gaspar de Freitas, Maria Rosário Bastos and João Alveirinho Dias Building Carbon Literacy: How the Irish Press Normalise Public Discussion About Climate Mitigation Actions / Brenda McNally Climate Change Communication and User Engagement: A Tool to Anticipate Climate Change / Marta Terrado, Isadora Christel, Dragana Bojovic, Albert Soret and Francisco J. Doblas-Reyes Encouraging 10,000 Staff to Take Action on Sustainability: A Case Study of a Sustainability Engagement Programme in Higher Education / Lucy Millard Disseminating Climate Change: The Role of Museums in Activating the Global Public / Morien Rees and Walter Leal Filho Engaging People with Climate Change Through Museums / Henry McGhie, Sarah Mander and Ralph Underhill Considering the Role of Government in Communicating Climate Change: Lessons from the US Public Flood Insurance Program / Chad J. McGuire Istanbul’s Vulnerability to Climate Change: An Urban Sectors’ Based Assessment / Aysun Aygün and Tüzin Baycan Enhancing Intergenerational Communication Around Climate Change / Susan A. Brown and Raichael Lock