[OSM-dev] making osm2pgsql import relations?

2012-11-07 Thread Ákos Maróy
Hi, I working on an open aviation map project, using OSM technology such as OSM XML files, which describe my datasets. These consists of polygons, points, and I also have some relations. I'm using osm2pgsql to import my OSM file into a PostGIS database. I'm using a custom osm2pgsql style file to

Re: [OSM-dev] making osm2pgsql import relations?

2012-11-07 Thread Ákos Maróy
On 07/11/12 21:50, sly (sylvain letuffe) wrote: Yes : To do nothing special. Which mean, there is a problem somewhere. Can you provide your osm2pgsql command line, style file and a simple xml test case to show the problem ? sure, here is the style file:

Re: [OSM-dev] making osm2pgsql import relations?

2012-11-07 Thread Ákos Maróy
On 07/11/12 21:52, Jukka Rahkonen wrote: Hi, One alternative is to use the GDAL/OGR OSM driver http://www.gdal.org/ogr/drv_osm.html A short document about how to use it http://latuviitta.org/documents/OSM_relations_visualized_with_GDAL_and_OpenJUMP.pdf In the document the output goes to

Re: [OSM-dev] determining the boundaries of cities?

2012-05-31 Thread Ákos Maróy
On 31/05/12 08:18, Peter Wendorff wrote: I think, that's legally correct, but probably not, what is needed here. Even if legally every location is legally assigned to a city and legally part of it, it's not what a map should show in every case. A map that should show cities may be targeted on

Re: [OSM-dev] determining the boundaries of cities?

2012-05-31 Thread Ákos Maróy
Peter, In Germany the speed limit is the case by default, but in the city there may be different limit signs even increasing that. One problem with this kind of boundary is, that it's only defined along streets, not on every small way and not in between. One proposal to tag this is [1],

Re: [OSM-dev] determining the boundaries of cities?

2012-05-31 Thread Ákos Maróy
Martin, It is not as easy as it sounds like. Actually we often do not have this information (directly) in OSM. What you could do is: * use the landuses and extend them slightly (to also get the streets, which are sometimes enclosed in the adjacent landuse but actually shouldn't). yes, this

[OSM-dev] determining the boundaries of cities?

2012-05-30 Thread Ákos Maróy
Hi, I wonder what is the best way to determine city boundaries based on the OSM dataset. What I want to do is simply to have each city colored in light yellow (uniformly), with a black outline at the edge of each city. I'm not concerned about the streets inside the cities, etc. I looked at the

Re: [OSM-dev] osm2pgsql - COPY_END SSL error?

2012-05-29 Thread Ákos Maróy
On 29/05/12 15:06, Sven Geggus wrote: On Unix -H localhost does not make sence as does SSL because local access using unix domain sockets should be much faster and encryption is not needed on localhost. well, still it does, as access via a network socket is different than direct local access,

Re: [OSM-dev] osm2pgsql - COPY_END SSL error?

2012-05-29 Thread Ákos Maróy
On 29/05/12 16:18, sly (sylvain letuffe) wrote: I wonder what it is doing all this time.. building indexes mostly interesting I chose a bounding box that is only slightly larger than Hungary - so that the content doesn't stop at the national border. while importing hungary.osm.bz2 is very

Re: [OSM-dev] osm2pgsql - COPY_END SSL error?

2012-05-29 Thread Ákos Maróy
On 29/05/12 16:36, sly (sylvain letuffe) wrote: I chose a bounding box that is only slightly larger than Hungary - so that the content doesn't stop at the national border. while importing hungary.osm.bz2 is very fast (less then an hour), importing this bounding box via europe.osm.bz2 takes

[OSM-dev] osm2pgsql - COPY_END SSL error?

2012-05-27 Thread Ákos Maróy
Hi, I was about to import the European part of the OSM planet file into a PostGIS database, and after about 3 days of processing I ended up with the following error: COPY_END for planet_osm_point failed: SSL error: sslv3 alert unexpected message Error occurred, cleaning up and an empty

[OSM-dev] having a regularly updated OSM database?

2012-04-11 Thread Ákos Maróy
Hi, I wonder what is the best way to have a regularly updated, up-to-date OSM database? By regularly, I mean an update about say once a month. Previously I experimented with osm2pgsql, but that took me 5 days to import, and the 'update' process was on the same order of magnitude. (this is on an

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-07 Thread Ákos Maróy
On 07/12/11 01:28, Erik Johansson wrote: http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.39#Replication_Tasks Or the well written prose version: http://ksmapper.blogspot.com/2011/04/keeping-database-up-to-date-with.html or lots of links in

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-07 Thread Ákos Maróy
On 07/12/11 21:28, Andreas Hubel wrote: Am 07.12.2011 um 08:14 schrieb Ákos Maróy: as a full import took me 5 days, maintaining a considerable IO load (and thus a lot of waiting processes) during this period. Try using the PBF version of the planet. Compared with the .osm.bz2 version

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-07 Thread Ákos Maróy
On 08/12/11 08:23, Andre Joost wrote: Am 08.12.2011 02:00, schrieb Ákos Maróy: On 07/12/11 01:28, Erik Johansson wrote: http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.39#Replication_Tasks Or the well written prose version: http://ksmapper.blogspot.com/2011/04/keeping-database

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-06 Thread Ákos Maróy
On 06/12/11 09:35, Peter Körner wrote: Am 06.12.2011 07:55, schrieb Ákos Maróy: $ osm2pgsql -d osm -S /usr/share/osm2pgsql/default.style --append -G -v -m -K changesets-16.osm.bz2 changesets*.osm.bz2 only contains changeset meta information, no content. You'll need one of the replicate

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-06 Thread Ákos Maróy
On 06/12/11 12:37, Peter Körner wrote: Am 06.12.2011 11:30, schrieb Ákos Maróy: on the OSM wiki, I found a number of update options, and I have to say I'm a bit confused. which is the best option if I want to get all the updates for the whole planet file, say, each week? Call osmosis once

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-06 Thread Ákos Maróy
On 07/12/11 01:28, Erik Johansson wrote: could you be more specific? http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.39#Replication_Tasks Or the well written prose version: http://ksmapper.blogspot.com/2011/04/keeping-database-up-to-date-with.html or lots of links in

Re: [OSM-dev] osm2pgsql not appending changeset?

2011-12-06 Thread Ákos Maróy
On 07/12/11 07:36, Kai Krueger wrote: If you are intending to only update the diffs every week or less (as opposed to minutely, hourly or daily), you might want to consider simply doing a fresh import every week. If you have sufficient ram, then you can use the non-slim mode, otherwise you

[OSM-dev] osm2pgsql not appending changeset?

2011-12-05 Thread Ákos Maróy
Hi, I'm trying to append a changeset to an existing OSM database using osm2pgsql, but it seems nothing is appended. I have a database which just had planet-09.osm.bz2 imported. I'm trying to apply changesets-16.osm.bz2 using the command: $ osm2pgsql -d osm -S

Re: [OSM-dev] speeding up loading an OSM dump into PostGIS?

2011-11-30 Thread Ákos Maróy
Dear All, Thank your the detailed responses. Indeed, I'm using the pg_dump pg_restore method to transfer a database to a system running a different version of posgresql. my hope is that this is faster than loading everything from scratch using osm2pgsql. so it seems I'll just wait see :)

[OSM-dev] speeding up loading an OSM dump into PostGIS?

2011-11-29 Thread Ákos Maróy
Hi, I wonder what ways are there to speed up importing an OSM planet file into a PostGIS database? What I've tried so far is importing the current planet-XXX.osm.bz2 file into PostGIS via osm2pgsl, which I have used with the --slim option, as without it the memory load exceeded the 16GB memory I

Re: [OSM-dev] generate_xml.py not generating osm.xml file?

2010-08-30 Thread Ákos Maróy
Lennard, That is correct, also because *you* have to tell mapnik *where* your style comes in the whole rendering order, by putting your layer-xxx; at the correct spot. now I see how it works. thank you for the clarification. Akos ___ dev mailing

Re: [OSM-dev] generate_xml.py not generating osm.xml file?

2010-08-29 Thread Ákos Maróy
Lennard, What does happen when you run generate_xml.py is that three files are created (or updated) in the inc directory. They are: datasource-settings.xml.inc, fontset-settings.xml.inc, settings.xml.inc thanks for the info - now I see that. Some guides still give a syntax like:

Re: [OSM-dev] generate_xml.py not generating osm.xml file?

2010-08-29 Thread Ákos Maróy
Lennard, They are dynamically included, by putting the relevant layer-xxx; references at the right spot in osm.xml. The ordering of Layer elements in the stylesheet determines the order in which mapnik renders. what do you mean by 'stylesheet' in this context? So water, for instance, is

[OSM-dev] generate_xml.py not generating osm.xml file?

2010-08-27 Thread Ákos Maróy
Hi, Maybe I'm misunderstanding the generic purpose of the generate_xml.py file from the mapnik rendering toolset, but for me, it does not seem to touch my osm.xml file in any way. when I execute generate_xml.py with appropriate database setttings, osm.xml is not changed in any way. if I remove

[OSM-dev] adding custom symbology into the map generation process?

2010-08-18 Thread Ákos Maróy
Hi, I'm trying to get my own custom mapnik symbology rules into the open street map map generation process. By the map generation process, I mean what is described here: http://wiki.openstreetmap.org/wiki/Mapnik basically what I'm aiming for: - import the planet.osm file into a pgsql database,

Re: [OSM-dev] adding custom symbology into the map generation process?

2010-08-18 Thread Ákos Maróy
Peter, To import your own .osm file you'll need osm2pgsql in append mode (specify --append on the command line). I tried, and it seems some data is left out of the import. this is the osm XML file I have: ?xml version='1.0' encoding='UTF-8'? osm version='0.6' node id=-6 lat=47.934167

Re: [OSM-dev] aviation maps? - conclusion

2010-08-12 Thread Ákos Maróy
Dear All, Thank you for all the valuable information regarding the aviation map topic on the list. How I see it, the following would be the solution for what I'm looking for: - I'd need to host my own OSM server, using the rails port, as described here:

Re: [OSM-dev] aviation maps? - conclusion

2010-08-12 Thread Ákos Maróy
Peter, On 12/08/10 16:32, Peter Körner wrote: Am 12.08.2010 13:23, schrieb Ákos Maróy: - I'd use Mapnik, as described here: http://wiki.openstreetmap.org/wiki/Mapnik to render the map into bitmaps. to handle the specialties of aviation map artifacts, I'd need to create rendering rules within

Re: [OSM-dev] aviation maps? - conclusion

2010-08-12 Thread Ákos Maróy
John, On 12/08/10 17:04, John Smith wrote: On 13 August 2010 00:54, Julio Costa Zambelli julio.co...@openstreetmap.cl wrote: http://www.openlayers.org/ That would be for displaying, they could still use OSM tools to convert or create data, eg JOSM, but instead of uploading to a server

[OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Hi, I'm new to OpenStreetMaps, and I'm not sure if this is the right forum to ask questions about this topic. I saw an initiative about airspace mapping here: http://wiki.openstreetmap.org/wiki/Proposed_features/Airspace I wonder how aviation maps would be defined / managed / handled from a

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Dear Frederik, OJ, Pieren Tom, Thank you for your quick responses in the subject. Maybe I'm using bad terminology, as I'm new to OSM in general, so let me try to line out what I was thinking about, before trying to react to what you write specifically. Please correct my terminology if I'm

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Andy, On 11/08/10 17:54, Andy Allan wrote: On Wed, Aug 11, 2010 at 3:00 PM, Ákos Maróy a...@maroy.hu wrote: totally agree - I would put all this into a separate database. BTW, how would one set up his own OSM online database for such a purpose? Have a look at http://wiki.openstreetmap.org

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Eric, On 11/08/10 18:09, Eric Wolf wrote: An argument for creating at least a sister project to OSM for airspace mapping is that, in the USA at least, FAA regulations limit the operation of kites and balloons based on airspace. If projects like OpenAerialMap and Cartagen are to take off

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Julio, We talked about an OpenAeroMap with Ivan Sanchez back in Amsterdam (SoTM2009), but when Ivan told the crowd about the idea, the reception went from simple skepticism to total disagreement (security issues being one of the main reasons). oh my :) well, let's leave the security skeptics

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Ivan, On 11/08/10 18:52, Iván Sánchez Ortega wrote: El día Wednesday 11 August 2010 18:25:39, Julio Costa Zambelli dijo: We talked about an OpenAeroMap with Ivan Sanchez back in Amsterdam (SoTM2009), And I've still got the idea somewhere in my notebooks. I haven't forgotten about that :-)

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Jeffrey, On 11/08/10 19:15, Jeffrey Johnson wrote: Will have to jump in with a full response later, but have any of you checked out AIXM? http://www.aixm.aero/public/subsite_homepage/homepage.html yes, I'am aware of the AIXM format, and the eAIP publications that are made using these

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Chris, On 11/08/10 19:28, Chris Hill wrote: Ákos Maróy wrote: in Europe at least, airspace information is freely available, and I'm sure the US is no different. anyone can get VFR and IFR airspace maps, either from the appropriate government agency (FAA, Eurocontrol), or from commercial

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Jeff, Just note that these things (airspace, route structures, waypoints etc) change, and there is a *very* specific schedule that they must change on this is all very tightly controlled and defined. If your aim is to do this for fun, much of that is not important, OTOH, if you intend for

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
On 11/08/10 19:29, OJ W wrote: On Wed, Aug 11, 2010 at 5:57 PM, Ákos Maróy a...@maroy.hu wrote: in Europe at least, airspace information is freely available Like this? http://www.nats-uk.ead-it.com/public/index.php%3Foption=com_contenttask=blogcategoryid=167Itemid=220.html correct, like

Re: [OSM-dev] aviation maps?

2010-08-11 Thread Ákos Maróy
Jukka, X-Plane project has lots of free aerial charts, see http://data.x-plane.com/ I have checked some years ago a few of the Finnish airports and at least in that sample the quality was excellent. License is not OSM compatible (GPL). This is what the author says about the license: yes,