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. _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
