pgrouting-logo.png
RELEASES
pgRouting announces pgRouting 2.0.0 release
September 27, 2013

This 2.0 release brings a number of major new features: All Pairs Shortest Path, Johnson’s Algorithm NEW All Pairs Shortest Path, Floyd-Warshall Algorithm NEW Shortest Path A* Bi-directional Dijkstra Shortest Path NEW Bi-directional A* Shortest Path NEW Shortest Path Dijkstra Driving Distance K-Shortest Path, Multiple Alternative Paths NEW K-Dijkstra, One to Many Shortest Path NEW Traveling Sales Person NEW Implementation Turn Restriction Shortest Path (TRSP) NEW New functions for creating routing topology New functions for analyzing a graph for problems pgRouting 2.

pyqgis_table_1.png
ENGINEERING
Joining Tables with SQL using pyQGIS
September 21, 2013

One of the features that makes MapInfo’s MapBasic very useful is the ability to join a normal tabular data with a spatial data using plain SQL statements within an application. This is useful because it makes it possible to link numerous attribute tables (census, crime, marketing, etc.

geoserver.png
SECURITY
Geoserver Security using the Seasar Web Framework
September 5, 2013

Although Geoserver has its own valid Security system, exposing it directly to the internet still raises concerns, especially if Geoserver is being used to host corporate data. One source of these concerns is that Geoserver offers numerous Services that have to be closed properly, and a single unintended mistake in closing these Services might lead to an unauthorised access to the Services or sensitive data.

pgrouting-logo.png
RELEASES
pgRouting 2.0 is coming soon
August 5, 2013

With the (inofficial) alpha, beta and rc1 release of the new pgRouting 2.0.0 lots of smaller and bigger issues have been fixed: for example TSP now accepts a start and also an end point, the “develop” branch is checked on Travis CI with every commit and tested with different versions of PostgreSQL/PostGIS, the documentation can be translated with Transifex , etc.

foss4g2013-white-300.png
COMPANY
Georepublic at FOSS4G in Notthingham
August 4, 2013

In September the annual FOSS4G will take place in Nottingham, and beside being a sponsor Georepublic will attend the event with three of us travelling from Tokyo and Osaka. We are also planning to attend State of the Map in Birmingham, UK and the Quantum GIS Developer Meeting in Brighton before heading to FOSS4G.

berlin.png
CULTURE
The Cuisines of the world
January 23, 2013

Tags or tagging are quite underrated in mapping where colourful lines/dots make up for most of the look and feel. OpenStreetMap as the name says is an open map but also is a open geographic database licensed under ODBL .

treemap.png
ENGINEERING
Leaflet example with WFS-T
December 15, 2012

This article is supposed to be No. 15 in the Japanese FOSS4G Advent Calendar 2012 and it’s probably the first and last one in English for this year. First I wanted to build pgRouting Ubuntu packages and write about it, but then I saw the other great blog posts and decided to change the topic.

aaron-burden-xG8IQMqMITM-unsplash.jpg
ENGINEERING
How to contribute to an existing Octopress blog
November 27, 2012

You managed to setup your own Octopress blog? Great! After a while you switch to another PC or your colleague wants to contribute an article and nothing worked as easy

diane-picchiottino-dW0gfo__uU8-unsplash.jpg
INSIGHTS
The Georepublic Times is using Octopress
October 4, 2012

Let’s start with a first post about how to publish articles on Georepublic’s brand-new blog. Since the writing of blog articles has almost stalled in this year, even if Georepublic’s population nearly doubled since 2011, there was probably something wrong the old blog system.

wolfgang-hasselmann-P7L5011nD5s-unsplash.jpg
ENGINEERING
PostGIS and pgRouting template
February 7, 2011

When creating a new database in PostgreSQL using the standard template, PostGIS and pgRouting functions and tables are missing of course. You can add these functions and tables one by one, but doing this every time for every single database is annoying work.

ankush-minda-TLBplYQvqn0-unsplash.jpg
RELEASES
pgRouting Project News
November 22, 2010

It has been a long way but finally we made it: I’m glad to be able to announce the new pgRouting website, that also comes with a lot of other changes and news!

foss4g2010osaka.png
EVENTS
Georepublic at FOSS4G 2010 Japan in Tokyo and Osaka
October 30, 2010

2010 is also Georepublic’s first year at the local FOSS4G conference in Japan. The 2-days conference + 1 day workshop will take place October 31st to November 2nd in Tokyo and November 5th, 6th and 8th (workshops) in Osaka.