[pgrouting-users] Rev 2.0 Update -- Release is almost ready!

Hi All,

I think we have finished up a major cleanup of the documentation, including creating test files for all the doc examples, and standardizing the name of arguments in the stored procedures. This was all made possible by a lot of work by Vicky Vergara. We are now running 65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into develop and tagged as release candidate 2 with the hope that it will become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to test it. We would love to get some feedback after all this work.

The docs are here:
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html

If you don't have time or expertise to build from source and test it, we could use proof readers to look over the docs. Email me or create a ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues that can not be deferred and of course to make the final release.

Thanks,
   -Steve

Hi,

I will present "pgRouting for dummies" at FOSS4G2013. It's a nice and quick tutorial on how to add basic routing to your site. Could you give me a brief summary, for a few slides maybe, of the greatest changes in 2.0. I may have missed the official release announcement. Please forgive me if it's the case.

Thanks
Julien

On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

Hi All,

I think we have finished up a major cleanup of the documentation,
including creating test files for all the doc examples, and
standardizing the name of arguments in the stored procedures. This was
all made possible by a lot of work by Vicky Vergara. We are now running
65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into
develop and tagged as release candidate 2 with the hope that it will
become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to test it.
We would love to get some feedback after all this work.

The docs are here:
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html

If you don't have time or expertise to build from source and test it, we
could use proof readers to look over the docs. Email me or create a
ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues
that can not be deferred and of course to make the final release.

Thanks,
   -Steve
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--
Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/

Hi Julien,

It is wonderful that you are providing an overview of pgRouting at FOSS4G2013.

For Rev 2.0, there are major changes. The basic concepts have not changed in that you load your data into the database, create a pgRouting topology, and issue SQL queries to get results.

The big changes are:

1. We have refactored all the commands so you have to look at the manual to learn it or to upgrade

2. We refactored the source tree, integrated the docs with the source tree and added tests for every command and every example in the manual.

Why did we do this? The product was getting out of hand with incremental development, things were broken and inconsistent and in general suffered from a lot of entropy over the years. This move was targeted at reviving the project and positioning it to move forward with new features.

3. We added many new features, tools and extensive documentation.
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html
     Topology Functions
         pgr_createTopology to create a topology based on the geometry.
         pgr_createVerticesTable -to reconstruct the vertices table based on the source and target information.
         pgr_analyzeGraph - to analyze the edges and vertices of the edge table.
         pgr_analyzeOneway to analyze directionality of the edges.
         pgr_nodeNetwork -to create nodes to a not noded edge table.
     Routing Functions
         pgr_apspJohnson - All Pairs Shortest Path, Johnson’s Algorithm
         pgr_apspWarshall - All Pairs Shortest Path, Floyd-Warshall Algorithm
         pgr_astar - Shortest Path A*
         pgr_bdAstar - Bi-directional A* Shortest Path
         pgr_bdDijkstra - Bi-directional Dijkstra Shortest Path
         pgr_dijkstra - Shortest Path Dijkstra
         pgr_kDijkstra - Mutliple destination Shortest Path Dijkstra
         pgr_ksp - K-Shortest Path
         pgr_tsp - Traveling Sales Person
         pgr_trsp - Turn Restriction Shortest Path (TRSP)
     With Driving Distance Enabled
         pgr_drivingDistance - Driving Distance
         pgr_alphashape - Alpha shape computation
         pgr_pointsAsPolygon - Polygon around set of points
     Developers’s Functions
         pgr_getColumnName - to get the name of the column as is stored in the postgres administration tables.
         pgr_getTableName - to retrieve the name of the table as is stored in the postgres administration tables.
         pgr_isColumnIndexed - to check if the column is indexed.
         pgr_isColumnInTable - to check only for the existance of the column.
         pgr_pointToId -to insert/get the id of the ineserted point in a vertices table.
         pgr_quote_ident - to quotes the input text to be used as an identifier in an SQL statement string.
         pgr_version - to get pgRouting’s version information.
         pgr_versionless - to compare two version numbers

Every function has an example and we supply sample data for all the examples.

If you want help review this let me know or post it on the list and I'm sure you will get some feedback and help.

Thanks,
   -Steve

On 9/4/2013 4:15 PM, Julien-Samuel Lacroix wrote:

Hi,

I will present "pgRouting for dummies" at FOSS4G2013. It's a nice and
quick tutorial on how to add basic routing to your site. Could you give
me a brief summary, for a few slides maybe, of the greatest changes in
2.0. I may have missed the official release announcement. Please forgive
me if it's the case.

Thanks
Julien

On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

Hi All,

I think we have finished up a major cleanup of the documentation,
including creating test files for all the doc examples, and
standardizing the name of arguments in the stored procedures. This was
all made possible by a lot of work by Vicky Vergara. We are now running
65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into
develop and tagged as release candidate 2 with the hope that it will
become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to test it.
We would love to get some feedback after all this work.

The docs are here:
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html

If you don't have time or expertise to build from source and test it, we
could use proof readers to look over the docs. Email me or create a
ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues
that can not be deferred and of course to make the final release.

Thanks,
   -Steve
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Hi Julien,

There will be another pgRouting presentation (as the years before, except that I won’t be able to attend this year and my colleague Hal will speak instead):
http://2013.foss4g.org/conf/programme/presentations/144/

It will actually contain exactly these slides, following the schema of previous years:
http://www.slideshare.net/kastl/foss4-g2011-pgrouting

I think we should try to make 2 different presentations :wink:
The presentation we’re planning will be a project overview (as the link before), but of course it will introduce the new algorithms. But it will not be a “practical” presentation.

Daniel

···

On Thu, Sep 5, 2013 at 5:15 AM, Julien-Samuel Lacroix <jlacroix@mapgears.com> wrote:

Hi,

I will present “pgRouting for dummies” at FOSS4G2013. It’s a nice and quick tutorial on how to add basic routing to your site. Could you give me a brief summary, for a few slides maybe, of the greatest changes in 2.0. I may have missed the official release announcement. Please forgive me if it’s the case.

Thanks
Julien

On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

Hi All,

I think we have finished up a major cleanup of the documentation,
including creating test files for all the doc examples, and
standardizing the name of arguments in the stored procedures. This was
all made possible by a lot of work by Vicky Vergara. We are now running
65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into
develop and tagged as release candidate 2 with the hope that it will
become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to test it.
We would love to get some feedback after all this work.

The docs are here:
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html

If you don’t have time or expertise to build from source and test it, we
could use proof readers to look over the docs. Email me or create a
ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues
that can not be deferred and of course to make the final release.

Thanks,
-Steve


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

On Thu, Sep 5, 2013 at 7:35 AM, Daniel Kastl <daniel@georepublic.de> wrote:

Hi Julien,

There will be another pgRouting presentation (as the years before, except
that I won't be able to attend this year and my colleague Hal will speak
instead):
http://2013.foss4g.org/conf/programme/presentations/144/

It will actually contain exactly these slides, following the schema of
previous years:
http://www.slideshare.net/kastl/foss4-g2011-pgrouting

Sorry, this could be misunderstood. The presentation will have different
slides than the one on Slideshare.
I wanted to say, that the slides you're asking for might be the same or
pretty similar to the ones I'm preparing :wink:

I think we should try to make 2 different presentations :wink:
The presentation we're planning will be a project overview (as the link
before), but of course it will introduce the new algorithms. But it will
not be a "practical" presentation.

Daniel

On Thu, Sep 5, 2013 at 5:15 AM, Julien-Samuel Lacroix <
jlacroix@mapgears.com> wrote:

Hi,

I will present "pgRouting for dummies" at FOSS4G2013. It's a nice and
quick tutorial on how to add basic routing to your site. Could you give me
a brief summary, for a few slides maybe, of the greatest changes in 2.0. I
may have missed the official release announcement. Please forgive me if
it's the case.

Thanks
Julien

On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

Hi All,

I think we have finished up a major cleanup of the documentation,
including creating test files for all the doc examples, and
standardizing the name of arguments in the stored procedures. This was
all made possible by a lot of work by Vicky Vergara. We are now running
65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into
develop and tagged as release candidate 2 with the hope that it will
become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to test it.
We would love to get some feedback after all this work.

The docs are here:
http://imaptools.com:8081/**pgr2-doc/dev/en/doc/index.html&lt;http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html&gt;

If you don't have time or expertise to build from source and test it, we
could use proof readers to look over the docs. Email me or create a
ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues
that can not be deferred and of course to make the final release.

Thanks,
   -Steve
______________________________**_________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.**org <Pgrouting-users@lists.osgeo.org>
http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users&lt;http://lists.osgeo.org/mailman/listinfo/pgrouting-users&gt;

--
Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/

______________________________**_________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.**org <Pgrouting-users@lists.osgeo.org>
http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users&lt;http://lists.osgeo.org/mailman/listinfo/pgrouting-users&gt;

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Thank you very much for this extensive review. I'll make sure to look at this and even reuse the sample dataset.

Julien

On 13-09-04 06:19 PM, Stephen Woodbridge wrote:

Hi Julien,

It is wonderful that you are providing an overview of pgRouting at
FOSS4G2013.

For Rev 2.0, there are major changes. The basic concepts have not
changed in that you load your data into the database, create a pgRouting
topology, and issue SQL queries to get results.

The big changes are:

1. We have refactored all the commands so you have to look at the manual
to learn it or to upgrade

2. We refactored the source tree, integrated the docs with the source
tree and added tests for every command and every example in the manual.

Why did we do this? The product was getting out of hand with incremental
development, things were broken and inconsistent and in general suffered
from a lot of entropy over the years. This move was targeted at reviving
the project and positioning it to move forward with new features.

3. We added many new features, tools and extensive documentation.
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html
     Topology Functions
         pgr_createTopology to create a topology based on the geometry.
         pgr_createVerticesTable -to reconstruct the vertices table
based on the source and target information.
         pgr_analyzeGraph - to analyze the edges and vertices of the
edge table.
         pgr_analyzeOneway to analyze directionality of the edges.
         pgr_nodeNetwork -to create nodes to a not noded edge table.
     Routing Functions
         pgr_apspJohnson - All Pairs Shortest Path, Johnson’s Algorithm
         pgr_apspWarshall - All Pairs Shortest Path, Floyd-Warshall
Algorithm
         pgr_astar - Shortest Path A*
         pgr_bdAstar - Bi-directional A* Shortest Path
         pgr_bdDijkstra - Bi-directional Dijkstra Shortest Path
         pgr_dijkstra - Shortest Path Dijkstra
         pgr_kDijkstra - Mutliple destination Shortest Path Dijkstra
         pgr_ksp - K-Shortest Path
         pgr_tsp - Traveling Sales Person
         pgr_trsp - Turn Restriction Shortest Path (TRSP)
     With Driving Distance Enabled
         pgr_drivingDistance - Driving Distance
         pgr_alphashape - Alpha shape computation
         pgr_pointsAsPolygon - Polygon around set of points
     Developers’s Functions
         pgr_getColumnName - to get the name of the column as is stored
in the postgres administration tables.
         pgr_getTableName - to retrieve the name of the table as is
stored in the postgres administration tables.
         pgr_isColumnIndexed - to check if the column is indexed.
         pgr_isColumnInTable - to check only for the existance of the
column.
         pgr_pointToId -to insert/get the id of the ineserted point in a
vertices table.
         pgr_quote_ident - to quotes the input text to be used as an
identifier in an SQL statement string.
         pgr_version - to get pgRouting’s version information.
         pgr_versionless - to compare two version numbers

Every function has an example and we supply sample data for all the
examples.

If you want help review this let me know or post it on the list and I'm
sure you will get some feedback and help.

Thanks,
   -Steve

On 9/4/2013 4:15 PM, Julien-Samuel Lacroix wrote:

Hi,

I will present "pgRouting for dummies" at FOSS4G2013. It's a nice and
quick tutorial on how to add basic routing to your site. Could you give
me a brief summary, for a few slides maybe, of the greatest changes in
2.0. I may have missed the official release announcement. Please forgive
me if it's the case.

Thanks
Julien

On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

Hi All,

I think we have finished up a major cleanup of the documentation,
including creating test files for all the doc examples, and
standardizing the name of arguments in the stored procedures. This was
all made possible by a lot of work by Vicky Vergara. We are now running
65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into
develop and tagged as release candidate 2 with the hope that it will
become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to test it.
We would love to get some feedback after all this work.

The docs are here:
http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html

If you don't have time or expertise to build from source and test it, we
could use proof readers to look over the docs. Email me or create a
ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues
that can not be deferred and of course to make the final release.

Thanks,
   -Steve
_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--
Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/

Hi,

I was planning on a practical presentation with only a small part covering the new features and new API. My presentation will be a "hands on" set of example to load data, create services and configure tools in OpenLayers. At the end I will provide the code and the data to reproduce the sample application.

I will boost the fact that your presentation will go more in depth with the library and the new version. My presentation [1] will be the first morning so I'll send people your way :slight_smile: I'll leave to you to present the new API and the new version.

[1] http://2013.foss4g.org/conf/programme/presentations/127/

Julien

On 13-09-04 06:35 PM, Daniel Kastl wrote:

Hi Julien,

There will be another pgRouting presentation (as the years before,
except that I won't be able to attend this year and my colleague Hal
will speak instead):
http://2013.foss4g.org/conf/programme/presentations/144/

It will actually contain exactly these slides, following the schema of
previous years:
http://www.slideshare.net/kastl/foss4-g2011-pgrouting

I think we should try to make 2 different presentations :wink:
The presentation we're planning will be a project overview (as the link
before), but of course it will introduce the new algorithms. But it will
not be a "practical" presentation.

Daniel

On Thu, Sep 5, 2013 at 5:15 AM, Julien-Samuel Lacroix
<jlacroix@mapgears.com <mailto:jlacroix@mapgears.com>> wrote:

    Hi,

    I will present "pgRouting for dummies" at FOSS4G2013. It's a nice
    and quick tutorial on how to add basic routing to your site. Could
    you give me a brief summary, for a few slides maybe, of the greatest
    changes in 2.0. I may have missed the official release announcement.
    Please forgive me if it's the case.

    Thanks
    Julien

    On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

        Hi All,

        I think we have finished up a major cleanup of the documentation,
        including creating test files for all the doc examples, and
        standardizing the name of arguments in the stored procedures.
        This was
        all made possible by a lot of work by Vicky Vergara. We are now
        running
        65 test scripts.

        This code is in the vicky-issue178 branch abd will get merged into
        develop and tagged as release candidate 2 with the hope that it will
        become 2.0.0 release shortly there after.

        You can checkout vicky-issue178 and build that if you want to
        test it.
        We would love to get some feedback after all this work.

        The docs are here:
        http://imaptools.com:8081/__pgr2-doc/dev/en/doc/index.html
        <http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html&gt;

        If you don't have time or expertise to build from source and
        test it, we
        could use proof readers to look over the docs. Email me or create a
        ticket for any issues you find.

        pgRouting v2.0 is done except to fix docs, crashes or serious issues
        that can not be deferred and of course to make the final release.

        Thanks,
            -Steve
        _________________________________________________
        Pgrouting-users mailing list
        Pgrouting-users@lists.osgeo.__org
        <mailto:Pgrouting-users@lists.osgeo.org>
        http://lists.osgeo.org/__mailman/listinfo/pgrouting-__users
        <http://lists.osgeo.org/mailman/listinfo/pgrouting-users&gt;

    --
    Julien-Samuel Lacroix
    Mapgears
    http://www.mapgears.com/

    _________________________________________________
    Pgrouting-users mailing list
    Pgrouting-users@lists.osgeo.__org
    <mailto:Pgrouting-users@lists.osgeo.org>
    http://lists.osgeo.org/__mailman/listinfo/pgrouting-__users
    <http://lists.osgeo.org/mailman/listinfo/pgrouting-users&gt;

--
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de <mailto:daniel.kastl@georepublic.de>
Web: http://georepublic.de/&gt;

_______________________________________________
Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

--
Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/

Hi Julien,

Thanks! Yes, I thought so actually when I read you presentation abstract.
So it sounds like a good combination. I just thought I better let you know in case you missed the other presentation, that you don’t need to spend much time with the general stuff.
I think the presentation of Hal will focus on the project and general topics as well as introduction of the new functions, etc… There won’t be practical “hands-on” information.

Daniel

···

On Thu, Sep 5, 2013 at 10:12 AM, Julien-Samuel Lacroix <jlacroix@mapgears.com> wrote:

Hi,

I was planning on a practical presentation with only a small part covering the new features and new API. My presentation will be a “hands on” set of example to load data, create services and configure tools in OpenLayers. At the end I will provide the code and the data to reproduce the sample application.

I will boost the fact that your presentation will go more in depth with the library and the new version. My presentation [1] will be the first morning so I’ll send people your way :slight_smile: I’ll leave to you to present the new API and the new version.

[1] http://2013.foss4g.org/conf/programme/presentations/127/

Julien

On 13-09-04 06:35 PM, Daniel Kastl wrote:

Hi Julien,

There will be another pgRouting presentation (as the years before,
except that I won’t be able to attend this year and my colleague Hal
will speak instead):
http://2013.foss4g.org/conf/programme/presentations/144/

It will actually contain exactly these slides, following the schema of
previous years:
http://www.slideshare.net/kastl/foss4-g2011-pgrouting

I think we should try to make 2 different presentations :wink:
The presentation we’re planning will be a project overview (as the link
before), but of course it will introduce the new algorithms. But it will
not be a “practical” presentation.

Daniel

On Thu, Sep 5, 2013 at 5:15 AM, Julien-Samuel Lacroix

<jlacroix@mapgears.com mailto:[jlacroix@mapgears.com](mailto:jlacroix@mapgears.com)> wrote:

Hi,

I will present “pgRouting for dummies” at FOSS4G2013. It’s a nice
and quick tutorial on how to add basic routing to your site. Could
you give me a brief summary, for a few slides maybe, of the greatest
changes in 2.0. I may have missed the official release announcement.
Please forgive me if it’s the case.

Thanks
Julien

On 13-09-03 03:24 PM, Stephen Woodbridge wrote:

Hi All,

I think we have finished up a major cleanup of the documentation,
including creating test files for all the doc examples, and
standardizing the name of arguments in the stored procedures.
This was
all made possible by a lot of work by Vicky Vergara. We are now
running
65 test scripts.

This code is in the vicky-issue178 branch abd will get merged into
develop and tagged as release candidate 2 with the hope that it will
become 2.0.0 release shortly there after.

You can checkout vicky-issue178 and build that if you want to
test it.
We would love to get some feedback after all this work.

The docs are here:

http://imaptools.com:8081/__pgr2-doc/dev/en/doc/index.html

<http://imaptools.com:8081/pgr2-doc/dev/en/doc/index.html>

If you don’t have time or expertise to build from source and
test it, we
could use proof readers to look over the docs. Email me or create a
ticket for any issues you find.

pgRouting v2.0 is done except to fix docs, crashes or serious issues
that can not be deferred and of course to make the final release.

Thanks,
-Steve


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.__org
mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)
http://lists.osgeo.org/__mailman/listinfo/pgrouting-__users

<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>


Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.__org
mailto:[Pgrouting-users@lists.osgeo.org](mailto:Pgrouting-users@lists.osgeo.org)
http://lists.osgeo.org/__mailman/listinfo/pgrouting-__users

<http://lists.osgeo.org/mailman/listinfo/pgrouting-users>


Georepublic UG & Georepublic Japan

eMail: daniel.kastl@georepublic.de mailto:[daniel.kastl@georepublic.de](mailto:daniel.kastl@georepublic.de)
Web: http://georepublic.de <http://georepublic.de/>


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Julien-Samuel Lacroix
Mapgears
http://www.mapgears.com/


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.deJulien