Digital Geography

A Digital Earth: the Potential of Data Brokers

Introduction In my previous two posts I introduced the Cloud based data broker technology ERDDAP and demonstrated how one can use it to obtain geo-spatial scientific environmental data: Access sensor data on an buoy located in the Irish Sea . Get and display weather forecast data from the Global Forecast System (GFS). The use of data brokers to unify data catalogues is an approach taken by both the National Oceanic and Atmospheric Administration of the USA (ERDDAP) and the intergovernmental Group on Earth Observation (GEO Discovery and Access Broker). In this post I discuss the potential impact of this type…

How to organize geodata storage?

In the past I’ve learned one thing: the only chance to do efficient geodata-projects is to have a clean data structure.
In this post I’ll show you some tools and share my thoughts about organizing (geo)data to have more efficient project-workflows. After that I would be very interested in your solutions and approaches to do smart data-projects.

geo.admin.ch: bringing Swiss geodata potential to life

A priorized project of eGovernment Switzerland Usage and exchange of geodata is fostered by geo.admin.ch in a significant way. The Federal geoportal is operated by the Federal Office of Topography, swisstopo, on behalf of the coordinating body for Federal geographical information with the aim to implement the Geoinformation Act. The purpose of this Act is to ensure that geodata relating to the territory of the Swiss Confederation is made available to the Federal, Cantonal and municipal authorities, to industry and commerce, to academic and scientific institutions and to society at large, for the broadest possible use, in a sustainable, up-to-date,…

HeidiSQL vs. pgAdmin III – a small speed-test

HeidiSQL, a free database-client, now supports PostgreSQL/PostGIS in the newest nightly builds. Using HeidiSQL with MySQL was always a pleasure and I often had the feeling that the pgAdmin III client of PostgreSQL is slow and not very user-friendly in some points. Because of this I had to test the difference of performance of these two clients. I don’t want to talk about features and handling because this is on the one hand a matter of taste and on the other hand the support of PostgreSQL is very new in HeidiSQL. Instead, I want to compare some simple SQL-queries in…

DataSF or how to do open data right

In 2010 the City and County of San Francisco’s official open data portal was launched. To me it is the ultimate experience for publishing/consuming open data: based on a WordPress system the city distributes data for several categories: Economy and Community City Management and Ethics Transportation Public Safety Health and Social Services Geographic Locations and Boundaries Energy and Environment Housing and Buildings City Infrastructure Culture and Recreation There are 820 datasets available at the moment. Depending on the source of the dataset you will either be able to download the data directly or to display it as table: You can…

Geodatabases: a little insight

Most GIS-users I know don’t use Geodatabases. But as your project may grow, participation and co-working gets more and more usual in your projects and you would like to share not only your results but also your data the usage of geodatabases will be one thing to keep in mind. Normaly each feature or raster is stored in separate files and maybe folders as well. This concept will stay alive in a geodatabase but in a more professional way: ArcGIS gives you the possibility to store your features in a file geodatabase, perosnal geodatabase or an ArcSDE Geodatabase. So what…

Geodatabases

In my years at the university i was playing around with a lot of data. These were sorted “somehow” and totally distributed. after a short while i have lost control and my pc behaved like HAL… One advice: USE GEODATABASES! YOu can see here how to do that using ArcCatalog