## Profile

Dr.Geo500
30 followers|8,361 views

## Stream

### Dr.Geo500

Shared publicly  -

1

### Dr.Geo500

Shared publicly  -

Public access: http://goo.gl/SER5w﻿
1

### Dr.Geo500

Shared publicly  -
1

ottimo, grazie, le iniziative di collegare l'attività quotidiana ad un social network non indefinito come facebook risponde al bisogno dei cittadini di partecipare, essere responsabili e responsabilizzare, sta sconvolgendo queste tecnologie le "normali" istituzioni﻿
·  Translate

### Dr.Geo500

Shared publicly  -
1

### Dr.Geo500

Shared publicly  -
1

Un giorno di ordinaria follia﻿
·  Translate

### Dr.Geo500

Shared publicly  -

Here is a new "report" of my work around PostGIS, OSM, QGis, PgRouting, etc.

When displaying a shortest path, the "end" of the path can be far away from the point we want to reach. So I wondered how to "solve" this.

When you ask for a shortest path, you get a set of geometries. They are almost always in the "wrong" order : we don't care for just displaying the path, but If you want to really work with your paths, you need to fix this. It's easy to do : just use the source and target ids to check if they are in correct order, something like A-B B-C C-D and so on. I do this in the script that talk with PgSQL, in Java, with a few loops and comparisons. Now we can determine the last geometry.

Our geometries are multilines,so we need to find witch segment is the closest to the target point T. It would be either the first or the last one, but another one may be a good choice too; so we'll test all the segments of our last path. I say segments, but actually we have to check distance between each points and our target point and keep the one with the lowest result. In my example, this is the path from A to E.

Now we need to find a point on the segment D-E closer to our target point T than point E. We have two methods we can use:

- The first one is to use interpolation : you can either use ST_Interpolate in PostGis or like me code it by yourself. This is the I cyan point in the picture.

- The second one is to use an orthogonal projection : here again I code it by myself, don't know any PostGis equivalent. This is green H point.

As you can see, even if it's less accurate than orthogonal projection, interpolation can do a good job.﻿
1
In their circles
49 people
Have them in circles
30 people

### Dr.Geo500

Shared publicly  -

Ci sono diversi modi per la fare la stessa azione, alcuni convegono altri sono soltanto prove... l'unica certezza è che il poter scegliere da spazio alle idee.

riferimenti: QGis, plug-in Place a Pin
·  Translate
1

### Dr.Geo500

Shared publicly  -

Tutorial GIS 001 - http://youtu.be/-pXYk9EkDDY - Usate gli automatismi, non soltanto quando le azioni diventano difficili﻿
·  Translate
1

### Dr.Geo500

Shared publicly  -

INPUT2012 - +Pjhooker - Yet another strategic planning Tool

The land use planning (which in this paper we call “LUPlanning”) is a complex matter that needs of clearness and standardize methods. This work proposes an effective tool for strategic planning, which provides the use of informatic systems to aid the decision makers and insiders of public body that are not professionals. The use of informatics makes easier and real time the public participation, an important critical point of planning, often difficult to implement for scepticism and in many town hard to really carry out, due to inadequate means.
The aim of the proposed tool is to furnish a way to simplification of LUPlanning process and decision, using available and cheap hardware and software solutions. Computerization is not just a fad, but is almost inevitable evolution of management systems, so make it the most for the municipality means facilitating the work of technicians and insiders and the active involvement of citizens, for a more effective, rational and strategic land planning.﻿
The land use planning (which in this paper we call “LUPlanning”) is a complex matter that needs of clearness and standardize methods. This work proposes an
View original post
1

### Dr.Geo500

Shared publicly  -

When: 10 May 2012 - 12 May 2012. Venue: University of Cagliari, Sardinia. URL: http://www.input2012.it/. Tags: 2012, input, urban and regional planning. The University of Cagliari will host the Sevent...
1

### Dr.Geo500

Shared publicly  -

New design for my site
limacityplanner﻿
1

### Dr.Geo500

Shared publicly  -

Topographic maps from Dutch Kadaster Top10NL open geodata: transformed with with NLExtract http://nlextract.nl from GML to PostGIS and styled with QGIS by JW van Aalst. Read more on http://www.qgis.nl/2012/02/10/een-kleurenschema-voor-de-top10nl/﻿
1