Re: [OSM-talk] Wanted: Osm2pgsql.exe developer
On Wed, 2008-11-12 20:38:15 +0100, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Tue, Nov 11, 2008 at 9:54 AM, Jukka Rahkonen > <[EMAIL PROTECTED]> wrote: > > I would like to make clear that I do not demand any special services for the > > Windows users. I understand that this project is running on Linux and that > > osm2pgsql is done for Mapnik rendering and it is not meant to be used as a > > general OSM data conversion tool. For that purpose having an ogr2ogr driver > > would be a better solution. Osm2pgsql.exe is just damn fast in importing OSM > > data into PostGIS in Windows environment and therefore I am, if not so very > > willing, but anyway ready to pay for the kind developer who would add those > > two > > missing features. > > I have in the past asked for anyone who got osm2pgsql to compile under > windows to send the patches needed to make it work. However, there > seems to be a lack of windows developers out there :( I think I already built something that used PostgreSQL with Windows and the Cygwin stuff. I do have one Windows host (even with Cygwin installed) accessible at work. Maybe I can give it a try the other day. However, I don't really know how to distribute the binary. Should the needed libs be shipped along with it? Or ask the users to install enough Cygwin stuff until all library dependencies are fulfilled? > There has to be someone out there which a windows devel environment > would can spend an afternoon fixing any issues I don't think it'll be too hard. I'll try to give it a try. MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: Zensur im Internet? Nein danke! the second : signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Databases?
On Thu, 2008-10-16 02:53:46 +1200, Joseph Gentle <[EMAIL PROTECTED]> wrote: > So how good is postgis? Does anyone know if its performant enough for > real-time map rendering? Can it do level-of-detail stuff ("fetch all > data in europe with at least city level significance")? Current versions of gpsdrive (http://www.gpsdrive.de/) and gpsdisplay (http://lug-owl.de/~jbglaw/gpsdisplay.git) will render their maps directly off a PostGIS database. On my laptop, rendering a map in a zoom level useable for in-city driving will take about 400ms, including parsing of the osm.xml file and fetching the data from a (possibly almost-hot) PostgreSQL page cache. Larger maps, covering half of Germany, will need between about 60 and 250 seconds. MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: GDB has a 'break' feature; why doesn't it have 'fix' too? the second : signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] [ANN] GPSdisplay v0.1.5
Hi! This is v0.1.5 of GPSdisplay, downloadable at wget http://lug-owl.de/~jbglaw/gpsdisplay/gpsdisplay-latest.tar.gz git clone http://lug-owl.de/~jbglaw/gpsdisplay.git GPSdisplay is a small application using Mapnik and thus PostGIS to display your current position, north-wise, with the track you already left behind you. Position fixes are read off the system DBUS (from gpsd), a GPX file with the positions as well as POIs can be written (think of "here's a post box, traffic lights, ..."), Bugs for OpenStreetBugs can be submitted. It's also nice for testing osm.xml changes. Suggestions, complaints and patches welcome :) MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: Fortschritt bedeutet, einen Schritt so zu machen, the second : daß man den nächsten auch noch machen kann. signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] [Talk-de] [ANN] GPSdisplay v0.0.6
Hi! This is v0.0.6 of GPSdisplay, downloadable at http://lug-owl.de/~jbglaw/gpsdisplay/gpsdisplay-0.0.6.tar.gz It can now write GPX files with comments (eg. "Here's a post box") and write out a small shell script to place OpenStreetBugs for errors you spot that aren't easily correctable ("There's another street here...") (GPSdisplay is a small application using Mapnik and thus PostGIS to display your current position, north-wise. It's *not* a routing application, nor can it display the track you already went with your GPS receiver. Simply a small app for data display, playing with Mapnik styles and an aid to fix the simple bugs you find in reality:-)) Suggestions, complaints and patches welcome :) MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: "Debugging is twice as hard as writing the code in the first place. the second : Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." - Brian W. Kernighan signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Running Mapnik under Windows/Win32 | How to convert the Planet-File and Render World Tiles
On Fri, 2008-09-12 15:13:23 +0200, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > My Source: http://wiki.openstreetmap.org/index.php/Mapnik > > I have installed everything under Windows 2000 (SP4) and > the demo (with the 3 pictures) works fine. Now i've two questions: > > *Question 1: How to convert the PLANET IN FILE on Windows/WIN32 * > I know i've to execute this Command ... > * ./osm2pgsql osm-U-m-d f: / osm/planet-080910.osm * osm2pgsql is binary program written in C. It may compile eg. under Cygwin, even easily. As an alternative, you'd run it on a Linux box and use the PostGIS database on your Windows box, which should work fine. > but where ... Python-Shell ... Windows-Command ... or do i have > to compile this command before i can use it on my win32-OS and > how does this compilation work ? I cannot really help you with the compilation. Either run it on a Linux box (Debian even has it as a package), or try to build it with Cygwin. If that works, it's by far the easiest way to get it build for Windows. > *Question 2: RENDERN TILES OF THE WORLD? * > I rendered the deom and it works fine, but what are all the other steps, > i've to do, before i can use the generate_tiles.py srcript to generate the > world map level x (x=1-14)? > http://svn.openstreetmap.org/applications/rendering/mapnik/generate_tiles.py Don't know, never did that :) MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: 17:45 <@Eimann> Hrm, das E90 hat keinen Lebenszeit Call-Time Counter mehr the second : 17:46 <@jbglaw> Eimann: Wofür braucht man das? 17:46 <@jbglaw> Eimann: Für mich ist an 'nem Handy wichtig, daß ich mein Gegeüber hören kann. Und daß mein Gegenüber mich versteht... 17:47 <@KrisK> jbglaw: was du meinst ist wodka. 17:47 <@KrisK> jbglaw: es klingelt und man hört stimmen signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] House numbers... One more suggestion
On Tue, 2008-07-29 12:02:34 +0200, Frederik Ramm <[EMAIL PROTECTED]> wrote: > Tagging house numbers onto intersections or ways is just a lame > workaround employed by many existing data sets because they can't > model every single house. I have absolutely zero doubt that sooner or > later, OSM *will* model every single house. At that time, every > single house will simply be tagged with its address and that's it. To me, it looks like a difference between modeling every house (and adding some kind of address tag) and describing house numbers along a way for eg. routing purposes. There are other schemes, which could work out quite well I guess: 119 121 ..127 129 131 ... 137 139 ... x1 --> x2 ---> x3 ... 120 122 .. 128 130 132 ... 139 140 House numbers are complicated (in a city like Berlin, you'll probably find non-continuous house numbers, and they not always follow the even-odd-scheme, and the house number on the opposite side of the street may even be in a completely other range...) x1: housenumber_righthand=120-128/+2 housenumber_lefthand=119-127/+2 x2: housenumber_righthand=130-138/+2 housenumber_lefthand=129-137/+2 x3: housenumber_righthand=140-148/+2 housenumber_lefthand=139-147/+2 I only picked two tags and overloading them a bit, overloading them somewhat. It describes a starting house number and the common house number difference on the right/left side of the street. At least for Germany, that could describe house number distribution and the right/left information (which I find *quite* useful!) well enough even for the more exotic cases. However, it'll be somewhat of a pain optimizing a way. MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: Fortschritt bedeutet, einen Schritt so zu machen, the second : daß man den nächsten auch noch machen kann. signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk
Re: [OSM-talk] OSM -> MS Access
On Fri, 2008-07-18 12:40:55 +, GS <[EMAIL PROTECTED]> wrote: > could someone point out how to convert OSM-XML to MS Access? I guess this simply won't work. You'd probably start a try using CSV, but if you, as suggested, bring Excel into the game, please remember that it used to have a 64K row limit. That's only a quite little number for nodes... If you want to *work* with access, it is a better idea to import all the data into MySQL or PostgreSQL and access that database from Access. MfG, JBG -- Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481 Signature of: Eine Freie Meinung in einem Freien Kopf the second : für einen Freien Staat voll Freier Bürger. signature.asc Description: Digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk