Mattolaiturit pt. II: does the carpet match the drapes?

Quite recently, the accessibility research group at the University of Helsinki published an updated version of their modified digiroad data. I had previously tried to use the data to calculate service/catchment areas, but ran into technical difficulties caused by my lack of SQL skills. But! I decided to give it a go once again.

I won’t go through the steps since Anita Graser has already done that. Some modifications to the SQL statements were necessary, and apparently some of the SQL functions have deprecated (?), too. So, below you can see the 10 minute service areas to the carpet washing places (places where you can wash your carpets, not sure what they’re called in English)  located in the Helsinki metropolitan area. The darker the red, the more time it takes to get to a carpet washing place. Areas outside the reds have dirty carpets, I assume.


I used the daily average travel time as the cost attribute. The end result is an interpolation of the vertices including the cost value. I am not really content with the use of IDW (had some issues with the other interpolation tools) but it will have to do for now. I cut the raster by using an alpha shape I produced earlier.

All in all, a nice exercise, although a bit burdensome to do. It would be nice to have a tool where you could just input the service locations as a point file and the tool would take care of the rest, provided that a working network data set is available. Still, it is amazing that the guys at the department of geology and geography produce these great data sets, not to mention the rest of you who created pgrouting tools and whatnot!



Täytä tietosi alle tai klikkaa kuvaketta kirjautuaksesi sisään:

Olet kommentoimassa -tilin nimissä. Log Out /  Muuta )

Google+ photo

Olet kommentoimassa Google+ -tilin nimissä. Log Out /  Muuta )


Olet kommentoimassa Twitter -tilin nimissä. Log Out /  Muuta )


Olet kommentoimassa Facebook -tilin nimissä. Log Out /  Muuta )


Muodostetaan yhteyttä palveluun %s