[OSM-dev] [GSoC] OpenStreetMapWidget

2012-06-18 Thread Aleksandra Milanovic
Hi, Posting my first update. The project: http://wiki.openstreetmap.org/wiki/Google_Summer_of_Code/2012/OSM_widget_constructor The actual project :) : http://sandra-milanovic.github.com/OpenStreetMapWidget/ The repository: https://github.com/Sandra-Milanovic/OpenStreetMapWidget Every feedback i

Re: [OSM-dev] Table/Index Access (for SSD)

2012-06-18 Thread Alan Mintz
At 2012-06-18 12:43, Lynn W. Deffenbaugh (Mr) wrote: Very good. That's exactly what I was looking for. In my DB, I get: planet_osm_point: 4369MB planet_osm_line: 41GB planet_osm_roads: 8530MB planet_osm_polygon: 34GB for a total of just under 88GB so a 120GB SSD should do the job. Now, to

Re: [OSM-dev] Table/Index Access (for SSD)

2012-06-18 Thread Lynn W. Deffenbaugh (Mr)
On 6/18/2012 3:31 PM, Frederik Ramm wrote: Use select pg_size_pretty(pg_total_relation_size('tablename')); to find out how much your tables need. If your database is nothing fancy then planet_osm_{point,line,roads,polygon} will total about 90 GB including their indexes (which pg_total_relatio

Re: [OSM-dev] [GSoC] Data Tile Service

2012-06-18 Thread Graham Jones
Hi Michael, Sounds good - I will have a look at your code. How do you propose deal with expiring the tiles when the underlying data changes? Also, please will you link to your source code repository from your osm wiki page so we can find it easily. Thanks! Graham. -- Graham Jones Hartlepoo

Re: [OSM-dev] Table/Index Access (for SSD)

2012-06-18 Thread Frederik Ramm
Hi, On 18.06.2012 19:50, Lynn W. Deffenbaugh (Mr) wrote: My current DB is just under 300GB (yes, it needs a VACUUM), and I'm trying to figure out if 120GB or 240GB worth of SSD could be employed for selected tables to improve diff application as well as rendering performance, primarily the latte

Re: [OSM-dev] Anomaly detection

2012-06-18 Thread Derick Rethans
Hi Adam, Could you please provide us with some updates? We've seen *very* little output from you so far. cheers, Derick On Wed, 13 Jun 2012, Derick Rethans wrote: > Hi Adam, > > how is the progress going. I would sort of like to see a little bit more > output from you. It's now week three a

Re: [OSM-dev] [GSoC] Data Tile Service

2012-06-18 Thread Michael Daines
One more thing: screenshots from the web-based debugging tool. http://osm-data-tiles.tumblr.com/ On 2012-06-18, at 1:03 PM, Michael Daines wrote: > Hello, > > Here are some updates for the GSoC Data Tile Service project. > > The repository for the tile rendering script is available here: >

[OSM-dev] [GSoC] Data Tile Service

2012-06-18 Thread Michael Daines
Hello, Here are some updates for the GSoC Data Tile Service project. The repository for the tile rendering script is available here: https://github.com/mdaines/render-data-tile The script will render JSON tiles using data imported to PostgreSQL/PostGIS with osm2pgsql. It can render individua

[OSM-dev] Table/Index Access (for SSD)

2012-06-18 Thread Lynn W. Deffenbaugh (Mr)
Greetings, Has anyone done any work on which tables and/or indices are most effectively targeted at SSD media for those of us that can't afford enough space to hold the entire global DB for osmpgsql/renderd/mod_tile updates and access? My current DB is just under 300GB (yes, it needs a VACUU