[pgrouting-users] pgrouting workshop

[Pedro Costa]

I'm trying to adapt this function (findnearestedge) [1] to my routing 
data that are in srs 27492.

Someone can help me with that?


thanks





[1]

$startEdge = findNearestEdge($startPoint);
  $endEdge   = findNearestEdge($endPoint);

   function findNearestEdge($lonlat) {

SELECT gid, source, target, the_geom,
                   distance(the_geom, GeometryFromText(
                        'POINT(".$lonlat[0]." ".$lonlat[1].")', 4326)) 
AS dist
                  FROM ".TABLE."
                  WHERE the_geom && setsrid(
                        'BOX3D(".($lonlat[0]-0.1)."
                               ".($lonlat[1]-0.1).",
                               ".($lonlat[0]+0.1)."
                               ".($lonlat[1]+0.1).")'::box3d, 4326)
                  ORDER BY dist LIMIT 1"












Em 10-07-2012 09:33, Daniel Kastl escreveu:
> Hi Pedro,
>
> The years before it was always available on OSGeo server: 
> http://download.osgeo.org/pgrouting/foss4g2010/
> It seems I forgot to place the 2011 workshop there as well.
>
> The workshop documentation source is on Github: 
> https://github.com/pgRouting/workshop
> So all you're missing is the sample data. But you can download any OSM 
> data or even use the sample data of 2010.
>
> In case you're using Ubuntu/Debian you can install last years workshop 
> as a package easily:
> https://launchpad.net/~georepublic/+archive/pgrouting/+packages 
> <https://launchpad.net/%7Egeorepublic/+archive/pgrouting/+packages>
> It contains the sample data of Denver as well. Or you download the 
> tarball [1] and extract it.
>
> Or, you use OSGeo Live DVD. It contains the workshop as well:
> http://live.osgeo.org/en/quickstart/pgrouting_quickstart.html (see 
> "What's next" at the end of the page).
>
> Hope that helps,
> Daniel
>
> [1] 
> https://launchpad.net/~georepublic/+archive/pgrouting/+files/pgrouting%2Bworkshop_0.6.1.orig.tar.gz 
> <https://launchpad.net/%7Egeorepublic/+archive/pgrouting/+files/pgrouting%2Bworkshop_0.6.1.orig.tar.gz>
>
>
>
> On Tue, Jul 10, 2012 at 10:15 AM, Pedro Costa <pedrocostaarma at sapo.pt 
> <mailto:pedrocostaarma at sapo.pt>> wrote:
>
>     Hi guys,
>
>     I'm playing with pgrouting workshop of FOSS4G 2011.
>     There is any link to download the workshop material?
>
>     Thanks
>
>     Pedro
>     _______________________________________________
>     Pgrouting-users mailing list
>     Pgrouting-users at lists.osgeo.org
>     <mailto:Pgrouting-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> -- 
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de <mailto:daniel.kastl at georepublic.de>
> Web: http://georepublic.de <http://georepublic.de/>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120710/20b55a2e/attachment-0001.html>