Custom query (1088 matches)

[...]
2011-08-22 14:20:05 (154 KB/s) - `/tmp/build_sahana/web2py_src-1.96.4.zip' saved [7127316/7127316]

You have not informed bzr of your Launchpad ID, and you must do this to
write to Launchpad or access private data.  See "bzr help launchpad-login".
S3 Debug: s3utils: XLRD not installed, Spreadsheet Importer not available.
Warning: Running Web2Py < 3566, so Scheduled Tasks aren't available - please upgrade
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.96.4 (2011-06-07 21:08:15)
Database drivers available: SQLite3, pymysql, PostgreSQL
S3 Debug: s3utils: XLRD not installed, Spreadsheet Importer not available.
Warning: Running Web2Py < 3566, so Scheduled Tasks aren't available - please upgrade
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.96.4 (2011-06-07 21:08:15)
Database drivers available: SQLite3, pymysql, PostgreSQL
Traceback (most recent call last):
  File "web2py.py", line 19, in <module>
    gluon.widget.start(cron=True)
  File "/usr/local/lib/web2py/gluon/widget.py", line 808, in start
    import_models=options.import_models, startfile=options.run)
  File "/usr/local/lib/web2py/gluon/shell.py", line 200, in run
    execfile(startfile, _env)
  File "applications/eden/static/scripts/tools/compile.py", line 33, in <module>
    compile_application(folder)
  File "/usr/local/lib/web2py/gluon/compileapp.py", line 506, in compile_application
    os.mkdir(os.path.join(folder, 'compiled'))
OSError: [Errno 13] Permission denied: 'applications/eden/compiled'
                      addgeometrycolumn                       
--------------------------------------------------------------
 public.gis_location.the_geom SRID:4326 TYPE:GEOMETRY DIMS:2 
(1 row)

Enabling module proxy.

no idea if that is fatal or harmless, ..

Hamish

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.