Peter Körner wrote:
I was looking
on how to connect to the osm-db and if there is phpMyAdmin
access to it? I browsed thru the toolserver and OSM wikis but did not
find much.
If you got an account on cassini you can connect to the local PostGIS-Db
with username gis and no password to the database named gis on localhost
via postgresql functions e.g. from php or with psql from the command line.
Great, it works! :)
This information is public available on cassini at the
end of
/sql/mapnik-stylesheets/osm-like/osm-de.xml, so that i hopefully don't
disclose a secret here.
This DB is only transitional and hopefully soon there will be a better
kind of login together with an updated database. (That one on cassini is
from 2009-07-15 and not updated since then).
I tried what should be a simple query:
select * from planet_osm_nodes where lat >= 44.81 and lat <= 44.83 and
lon >= 20.43 and lon <= 20.45 limit 5;
And it works a very long time without returning results. Perhaps there
should be indexes over lat and lon columns in planet_osm_nodes table.