Skip to content

The CASA Blog Network

The latest outputs from researchers, alumni and friends at the UCL Centre for Advanced Spatial Analysis (CASA).

    The CASA Blog Network

    Category: Database design

    Gineau-Bissau imported 500,000 litres of ‘Ice, Snow and Potable Water’ in 2003

    Posted on Monday 5 August 2013 by roblevy

    So, like, trade data, yeah? It’s great isn’t it? All the world’s trade in tangible products, itemised by zealous customs officials, and browsable by the idle researcher, thumbing through a Who’s Who-style almanac of fascinating trade numbers, discovering little gems … Continue reading →

    Continue reading »
    Database design, Trade Data

    Connecting R to PostgreSQL

    Posted on Wednesday 8 August 2012 by roblevy

    The most stupidly named database management system is, sadly, also the system of choice for my research group, the powers that be having apparently no interest in the fact the you can’t pronounce the name, can’t remember how to write … Continue reading →

    Continue reading »
    Database design, postgresql, R, r studio

    ISO3 Country Codes (things we learn as researchers)

    Posted on Tuesday 7 August 2012 by roblevy

    This year I have mostly been mapping country names from data sources found online to ISO3 country codes which are actually useful for something. The continuing proliferation of data sources whose only country indicator is something like “Virgin Is. (UK)” … Continue reading →

    Continue reading »
    Database design

    Directly query DB in QGIS

    Posted on Thursday 2 August 2012 by roblevy

    Sometimes a plugin comes along which changes your life. Fast SQL Layer from Pablo T. Carreira is just such a plugin. It allows you to execute arbitrary SQL queries against your underlying database, meaning that views and queries can now … Continue reading →

    Continue reading »
    Database design

    My first choropleth

    Posted on Thursday 2 August 2012 by roblevy

    I’ve managed to get some data onto my PostGIS database, and have got my first visualisation result. Since the aid dataset is large (c. 1,000,000, source: aiddata.org, the dataset is called ‘aid data 2 short’) I’ve summed over donors and … Continue reading →

    Continue reading »
    Database design, Development Aid

    Giving aid to non-existent countries

    Posted on Tuesday 31 July 2012 by roblevy

    In the big, fat dataset I’m using to study what affects the global flow of development aid, I’ve come across a problem which researchers must have dealt with a million times from scratch, and never published the results of how … Continue reading →

    Continue reading »
    Database design, Development Aid

    Categorising data

    Posted on Monday 23 July 2012 by roblevy

    In developing a data structure which will provide for the needs of many different research projects, there’s a difficult balance to be struck. The structure needs to be generic enough to cope with the very different needs of all these … Continue reading →

    Continue reading »
    categorisation, Database design

    CASA Website

    Our main website

    Contributors

    • Networking City Research blog on urban environment and citizen movements in complex networks
    • @emergentcity The personal blog-space of Gareth Simons -> architect | urbanist interested in performative simulation at the urban scale; space and flows as computational processes; information entropy & irreversibility; and the ‘edge of chaos’. Views are my own.
    • A Science of Cities complexcity
    • Adam Dennett
    • Alex Singleton
    • BDTK Blog Just another WordPress site
    • blog – ENFOLDing Global Dynamics and Complex Systems
    • CEDE Creating and Exploring Digital Empathy
    • CityGeographics Urban visualisation and spatial analysis research blog by Duncan A Smith
    • Crowd Simulation
    • Data-driven economics Why economics should be about observing and understanding the economy, duh.
    • DataShine Blog DataShine is an output of the ESRC BODMAS project which ran from 2013-2015 at UCL. To cite the project or websites, please use: Oliver O’Brien & James Cheshire (2016) Interactive mapping for large, open demographic data sets using familiar geographical fe
    • Digital Urban Data, Cities, IoT and Making Things
    • en-topia Urban Planning and the future of the city
    • GENeSIS Digital Social Research
    • George MacKerron: code blog GIS, software development, and other snippets
    • GIS + AR (Augmented Reality)
    • GIS and Agent-Based Modeling This is a research site focused around my interests in Geographical Information Science (GIS) and Agent-Based Modeling (ABM).
    • heartcode Coding “hard”, with the heart… :-)
    • James Cheshire Geography & Cartography
    • jpg4.us – little caprice dp' Search ,Fujian Shipbuilding Trading Co. Ltd. Shipbuilding in China
    • Mapping London Highlighting the best London maps
    • mechanicity.info An ERC Advanced Grant
    • O.O'Brien Thoughts on urban mobility services, digital cartography and data visualisation.
    • Output Area Classification User Group – OAC Open and Free Geodemographics
    • Pablo Mateos Associate Professor
    • Paul Longley Professor of Geographic Information Science, University College London
    • Placetique People, Data, Place
    • Po Ve Sham – Muki Haklay's personal blog GIScience, Citizen Science & Environmental Information
    • Population Geography promoting population geography, supporting population geographers
    • Python – Hannah Fry Dr. of fluid dynamics, researcher of complexity theory and all round bad-ass.
    • Quaestio research: questioning, inquiring, seeking, searching and scrutinising
    • QuanTile Quantitative Teaching, Research and Outreach in Geography
    • Quantitative Methods Research Group (QMRG) – Royal Geographical Society with IBG
    • Simone Caschili UCL QASER Lab & CASA Research Associate, University College London
    • Simulacra Showcasing land use transport modelling, urban complexity and sustainability research from the Centre for Advanced Spatial Analysis, University College London
    • Smart Cities Mainly Based on my Lectures on Models, Complexity, and Smart Cities at ASU, CUHK, CUSP at NYU, Ritsumeikan, SUFE-Shanghai, Tel Aviv, and UCL, with blogging odds and ends thrown in for good measure
    • Snakes on a brain Attempting scientific and mathematical programming in Python.
    • Sociable Physics Because “social physicist” is not an oxymoron.
    • Spatial Analysis | Scoop.it All the new curated posts for the topic: Spatial Analysis
    • Steven Gray
    • Stories by Max Nathan on Medium Stories by Max Nathan on Medium
    • Talisman Geospatial Data Analysis and Simulation
    • topometries Land-use dynamics, pedestrian behaviour and transport simulation, multi-agent systems and spatial morphology
    • Urbagram An Instiki wiki
    • UrbanMovements Flows, Behaviour and Networks in the City
    • UrbanTick
    • Volunteered Geographic Information A Geography/GIS blog by Daniel J Lewis
    Powered by WordPress and Momentous.