[OSM-dev] How to support name:* in MapOSMatic?
Hello, I'm part of MapOSMatic developers. Currently, we are using osm2pgsql to translate OSM data into Posgresql, as usual. We are using the default configuration for osm2pgsql. In particular, the tag name is translated into a pgsql column name. We would like to support multiple names for a given street: name:fr, name:ar, etc. As far as I have understood, we could configure osm2pgsql to create columns name:fr, name:ar, etc. and change our SQL requests to use those columns. That does not seems very scalable. The ideal configuration would be to have all names (name:fr, name:ar, ...) into a single name column and use it. Or have a kind of couple (name, country_code) that would store all different names for a street. But I don't know how to do this. Would any reader of this list have a suggestion on the best way to handle this issue? Best regards, david ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] How to support name:* in MapOSMatic?
Hello Brian, 2010/1/8 Brian Quinion openstreet...@brian.quinion.co.uk: That is how the gazetteer output from osm2pgsql handles it already. Thanks a lot! Regards, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Major improvements to MapOSMatic
Hello, 2010/1/5 Jukka Rahkonen jukka.rahko...@mmmtike.fi: Does MapOSMatic create for example a corresponding .pgw world file for georeferencing the image so that it could be used as a background image in GIS programs? Currently no. Contributions are welcome. ;-) Regards, david ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Major improvements to MapOSMatic
Hello John, 2010/1/5 John Smith deltafoxtrot...@gmail.com: Any plans to make the index + map output in the same PDF? Any plans to split the map into multiple pages in the PDF like a street directory? We have such plans but haven't had time to do it yet (contributions welcomed): https://savannah.nongnu.org/task/?9695 https://savannah.nongnu.org/task/?9665 Regards, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Major improvements to MapOSMatic
Hello John, 2010/1/5 John Smith deltafoxtrot...@gmail.com: Also the admin boundaries don't seem to work, or maposmatic is looking for something completely different than is entered in Australia. As a result it's telling people to enter admin boundaries that effectively already exist. Could you provide us a use case so we can debug it? (relation name and/or OSM ID) Could you open a bug with this use case? http://savannah.nongnu.org/bugs/?func=additemgroup=maposmatic We have a similar issue elsewhere, we don't know if this is the same one or another (different country). Regards, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Major improvements to MapOSMatic
2010/1/5 John Smith deltafoxtrot...@gmail.com: Do I have to add yet another account, on yet another bug tracker? No. http://savannah.nongnu.org/bugs/?func=additemgroup=maposmatic Thanks, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Major improvements to MapOSMatic
Hello, 2010/1/5 Matthias Julius li...@julius-net.net: I have one request: The PDFs are very nice vector graphics - except for the icons. When zooming in to detail level they look ugly. Could they be included as vectors, too? (Aren't they derived from SVGs?) No. As far as I know, Mapnik icons for PDF are bitmaps. We are using Mapnik, so any request regarding rendering should be adressed to Mapnik. If you know how to use vector icons in Mapnik, I'll be glad to know it. :-) Best regards, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Questions on Nominatim and administrative boundaries + osm2pgsql
Hello Jon, Thank you for the detailed reply. We have made significant progress with your explanations. Regards, david -- for MapOSMatic team ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Questions on Nominatim and administrative boundaries + osm2pgsql
Dear fellow OSM hackers, We are working on improving MapOSMatic, especially for international support. We are using http://nominatim.openstreetmap.org to query OSM in a human-friendly way, which, indeed, is a wonderful tool! Now we would like to use its results to query our own copy of the DB (created with osm2pgsql). We found a way to do this, but we are not quite sure it's the right way (tm) to do it... For example, we query Nominatim for Paris. One of the results is an administrative boundary limit (the one with osm_id 7444). For that entry, we would like to query our OSM DB to determine its administrative level. If we do: select * from planet_osm_line where osm_id=7444; then we don't get anything. However, when we do: select * from planet_osm_line where osm_id=-7444; then we get exactly what we need. Is this the right way to do it? Can we assume that, when nominatim returns an entry with class=boundary type=administrative and osm_type=relation, then we can safely query the planet_osm_line table with the _opposite_ of osm_id? Now, we already know that it does not always work like this... For example, if we try this with the entry for Paris, Kentucky, United States of America (osm_id 130722), then it simply does not work at all. In fact, it doesn't seem to work at all with none of the other administrative boundary query results that nominatim returns us for Paris. Should we instead query the planet_osm_rels table? Can we assume this table is always present in the database? If yes, how do we parse its fields to get the IDs to the other tables? Are there any documentation on the DB tables produced by osm2pgsql? Thanks a lot in advance! Regards, david -- for MapOSMatic dev team ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [ANNOUCEMENT] MapOSMatic: automatic generation of cities' map from OpenStreetMap data
Hello Philip and Frederik, 2009/9/21 Frederik Ramm frede...@remote.org: Philip Gillißen wrote: 1. I tried to enter Leverkusen but your application did not found administrative boundaries. 2. I created a map for the boundary box: http://maposmatic.org/jobs/2534 As you can see, there's no map, but a nice border ;) As David wrote in the announcement that you quoted: For now, it only supports rendering French metropolitan cities' maps. Thus your observations don't really come as a surprise. Yes, as Frederik underlined, we are only supporting metropolitan France right now. But we are working on world support. The change of scale (75 GiB of database, 9h to import a daily diff) has a bit surprised us. We are discovering that the OSM world is huge! ;-) Best regards, david ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [ANNOUCEMENT] MapOSMatic: automatic generation of cities' map from OpenStreetMap data
Hello Roeland, 2009/9/18 Roeland Douma u...@rullzer.com: First of all: Awesome! Thank you! One minor point: I did notice that you are still using the bitmap icons on the map. This is a pity since the whole map is nice vector data and if you are zooming (in the pdf or svg version) the icons get quite ugly. Yes, we noticed that. But I did not even know there were vector icons for Mapnik! :-) Would you have a pointer (doc, source code, blog post, ...) to help us integrate those vector icons? Best regards, david ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] [ANNOUCEMENT] MapOSMatic: automatic generation of cities' map from OpenStreetMap data
== Short Version == We are pleased to announce the release of MapOSMatic, a set of tools to automatically generate cities' map from OpenStreetMap data. MapOSMatic takes care of generating a labelled grid over the map, a list of street with references matching the grid as well as a nice layout of the city if its administrative boundaries are known. For now, it only supports rendering French metropolitan cities' maps, but it will soon be extended to other parts of the world. MapOSMatic is Open Source / Free Software licensed under AGPLv3. Generation of maps can be requested on-line: http://maposmatic.org/ Example of generated map: * Map: http://maposmatic.org/smedia/chavagne.png http://maposmatic.org/smedia/chavagne.pdf * Street index: http://maposmatic.org/smedia/chavagne_index.png http://maposmatic.org/smedia/chavagne_index.pdf == Longer Version == = MapOSMatic = MapOSMatic is a web application to generate maps of cities or towns, including index of streets, from OpenStreetMap data. It is written in Python. http://maposmatic.org/ It is made of two components: * MapOSMatic, the web front-end. An application written using the Django framework which allows to submit and visualize map rendering jobs. The rendering is done in the background by a daemon called maposmaticd; * OCitySMap, the back-end that generates the map. It is available as a Python module, used both by the maposmaticd daemon (above) and by a simple command line application. MapOSMatic is currently limited to France metropolitan area for several technical reasons. We are eager to get contribution helping us to lift up this limitation. MapOSMatic depends on PostgreSQL, PostGIS, Mapnik, OpenStreetMap data, Python, Cairo and Django. = License = MapOSMatic is Open Source / Free Software. All maposmatic and ocitysmap code is licensed under GNU Affero General Public License 3.0. = Contributing = The MapOSMatic development project is hosted at Savannah: http://savannah.nongnu.org/projects/maposmatic/ A development and user mailing list is available: http://lists.nongnu.org/mailman/listinfo/maposmatic-dev To clone the git repositories of modules do: git clone git://git.savannah.nongnu.org/maposmatic.git git clone git://git.savannah.nongnu.org/maposmatic/ocitysmap.git To browse those git repositories, look at: * http://git.savannah.gnu.org/cgit/maposmatic.git * http://git.savannah.gnu.org/cgit/maposmatic/ocitysmap.git Yours, david -- for maposmatic.org ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [ANNOUCEMENT] MapOSMatic: automatic generation of cities' map from OpenStreetMap data
Hello, 2009/9/10 Simone Cortesi sim...@cortesi.com: Is the limitation to france just because of postgis size? or is it something different? We have three main limitations: * locale used for sorting is hard coded to fr_FR currently: http://git.savannah.gnu.org/cgit/maposmatic/ocitysmap.git/tree/ocitysmap/street_index.py#n472 * Street prefixes are hard-coded for French: http://git.savannah.gnu.org/cgit/maposmatic/ocitysmap.git/tree/ocitysmap/street_index.py#n35 * We have only made an import of france.osm.bz2 (could be easily solved, modulo the size of our web server). Of course, we also need a way to control that through the web interface. Yours, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] [ANNOUCEMENT] MapOSMatic: automatic generation of cities' map from OpenStreetMap data
2009/9/10 David MENTRE dmen...@linux-france.org: 2009/9/10 Simone Cortesi sim...@cortesi.com: Is the limitation to france just because of postgis size? or is it something different? We have three main limitations: * locale used for sorting is hard coded to fr_FR currently: http://git.savannah.gnu.org/cgit/maposmatic/ocitysmap.git/tree/ocitysmap/street_index.py#n472 * Street prefixes are hard-coded for French: http://git.savannah.gnu.org/cgit/maposmatic/ocitysmap.git/tree/ocitysmap/street_index.py#n35 * We have only made an import of france.osm.bz2 (could be easily solved, modulo the size of our web server). There is a fourth limitation: * function _equal_without_accent() is hard-coded for French: http://git.savannah.gnu.org/cgit/maposmatic/ocitysmap.git/tree/ocitysmap/street_index.py#n154 Yours, d. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Good explanation of latitude-to-pixel conversion?
Hello, Robert (Jamie) Munro [EMAIL PROTECTED] writes: I don't understand. Why was it necessary? According to the original poster, it improves the mapping by some 50 meters for some points, compared to projections made by a dedicated software (proj4). But I suppose all of this is quite subjective to the kind of projection you are using and your purpose. And I'm certainly not a cartographer. :-) AFAICS, taking into account the variation of radius is *not* necessary, but can be done if you want to make the maths much harder for yourself. The maths are not so difficult for Mercator projection but I agree are more involved for other calculations. I have personally considered the Earth a sphere when computing the distance between two points. Sincerely yours, david -- GPG/PGP key: A3AD7A2A David MENTRE [EMAIL PROTECTED] 5996 CC46 4612 9CA4 3562 D7AC 6C67 9E96 A3AD 7A2A ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
Re: [OSM-dev] Good explanation of latitude-to-pixel conversion?
Hello, On Sat, May 17, 2008 at 2:29 PM, Nick Whitelegg [EMAIL PROTECTED] wrote: I have the code to do this, but I guess I'm one of these people that like to understand what's actually going on :-) You are not the only one. I followed the same path (pun intended) a few weeks ago. The specific formula I mean (represented in Java) is: public static int latToY(double lat,int zoom) { double f = Math.sin((Math.PI/180)*lat); int y = (int)Math.round (Math.pow(2,zoom+7) + 0.5*Math.log((1+f)/(1-f)) * (-Math.pow(2,zoom+8)/(2*Math.PI))); return y; } The code you give is to translate a (lat, zoom) to x coordinate, you have a more direct formula applying the Mercator projection to the lat value: http://wiki.openstreetmap.org/index.php/Mercator In the above page, it helps to know that r_minor and r_major are Earth Equatorial and Polar radii[1]. The original post helps to understand why taking into account the variation of radius was necessary: http://osdir.com/ml/gis.openstreetmap.devel/2006-12/msg00016.html OJ W [EMAIL PROTECTED] writes: e.g. wikipedia will tell you all about how mercator itself works: http://en.wikipedia.org/wiki/Mercator_projection This is a very useful page. and for the tiles, alll you do is say select the bit of mercator-projected map between two arbitrary latitudes (which happen to be numerically special but you don't need to care about that) and call that range the limits of your map in Y. you then just start dividing Y into halves and quarters etc. to do the tiles. In fact, I found explanation in http://wiki.openstreetmap.org/index.php/Slippy_map_tilenames sufficient after thinking a little about it. I hope it helps, Yours, d. Footnotes: [1] http://en.wikipedia.org/wiki/Earth -- GPG/PGP key: A3AD7A2A David MENTRE [EMAIL PROTECTED] 5996 CC46 4612 9CA4 3562 D7AC 6C67 9E96 A3AD 7A2A ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev