Custom Query (1118 matches)

run LiveDVD RC2

user@osgeo-live:/home/shared$ psql pgrouting psql (8.4.8) Type "help" for help.

pgrouting=# \d

List of relations

Schema | Name | Type | Owner

public | classes | table | user public | geography_columns | view | user public | geometry_columns | table | user public | nodes | table | user public | spatial_ref_sys | table | user public | types | table | user public | vertices_tmp | table | user public | vertices_tmp_id_seq | sequence | user public | ways | table | user

(9 rows)

pgrouting=# SELECT * FROM shortest_path(' pgrouting'# SELECT gid as id, pgrouting'# source::integer, pgrouting'# target::integer, pgrouting'# length::double precision as cost pgrouting'# FROM ways', pgrouting(# 1888, 4738, false, false);

vertex_id | edge_id | cost

(0 rows)

pgrouting=# SELECT gid, AsText(the_geom) AS the_geom pgrouting-# FROM dijkstra_sp('ways', 1888, 4738);

gid | the_geom

(0 rows)

pgrouting=# \l+ pgrouting=# \df dijkstra_sp pgrouting=# \d ways pgrouting=# select min(gid), max(gid), count(gid) from ways;

min | max | count

1 | 10640 | 8486

(1 row)

pgrouting=# select gid from ways where gid = 1888;

gid

1888

(1 row)

pgrouting=# select gid from ways where gid = 4738;

gid

(0 rows)

pgrouting=# select gid from ways where gid > 4700 and gid < 5000; pgrouting=# select gid from ways where gid > 4700 and gid < 5000 order by gid; pgrouting=# SELECT gid, AsText(the_geom) AS the_geom

FROM dijkstra_sp('ways', 1888, 4739);

gid | the_geom

(0 rows)

pgrouting=# SELECT gid, AsText(the_geom) AS the_geom

FROM dijkstra_sp('ways', 1888, 4732);

gid | the_geom

(0 rows)

The MapServer itasca demo on the LiveDVD does not support WMS. It is missing a projection definition and the ows_enable_request settings. I reported that two month ago ​http://lists.osgeo.org/pipermail/live-demo/2011-June/003504.html

It is not possible to use the demo in uDig/QGIS/MapProxy/etc. The MapServer demo/quick guide works, but it should also support WMS since we (OSGeo) advocate open standards.

Hi,

5.0rc2 ISO.

as reported by others, and I see it too, when you boot using the ISO it seems impossible to log out.

the first time you click on "are you sure you want to log out?" it seems to do nothing. the second time you try you get this error message:

Failed to log out.
Session manager must be in idle state
when requesting a shutdown
                               [Close]

I haven't experienced this in the VM.7zip version. (although technically I am running the ISO in a VM, but I think others reported it once the ISO was installed onto a USB drive & booted natively)

if I look at ps fax | less I can see [xfce4-session] <defunct>

workarounds

• it's a read-only file system & you can't hurt it: just power off the PC and all will be ok in the morning. (maybe not so healthy for a USB install)

• killall xfce4-session : takes you back to the login screen

• sudo poweroff : shuts down the disc

hmm, I was thinking it might be molly-guard, but that package isn't installed.

this seems to work on a stock xubuntu CD, even if I remove the indicator-messages package.

?, Hamish