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

2012-11-07 Thread Ákos Maróy
On 07/11/12 22:12, sly (sylvain letuffe) wrote: > osm2pgsql only uses it's multipolygon building ability when relations > have a tag "type" with value "multipolygon" or "boundary" (unless > patched) relation n°25 for exemple hasn't. it hasn't on purpose. the relations I use are not used to stitch

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 goe

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

2012-11-07 Thread Ákos Maróy
On 07/11/12 22:01, Lennard wrote: > On 7-11-2012 21:34, Ákos Maróy wrote: > >> But, I can't seem to be able to have osm2pgsql import my relations - >> after the import, the content of the planet_osm_rels table is empty. I >> was looking at the osm2pgsql documentation,

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: http://code.google.com/p/openaviation

[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] 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, t

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
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

[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 OS

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 t

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 ver

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 acce

[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 databas

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

2012-04-12 Thread Ákos Maróy
On 11/04/12 15:22, andrzej zaborowski wrote: >> If you're updating it may be easier to keep it continually up to date with >> minutely replication diffs. > > But note that on usual hardware (the type that takes 5 days to import > the planet), applying replication diffs can take more than 2/3rds of

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

2012-04-10 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 i

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 vers

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 p

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 > http://wiki.openstreetmap.org/wiki

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

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 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,

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

[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 /usr/share/osm2pgsql/default

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 :) A

[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 maili

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 > 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 load

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: > > gen

[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 os

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: and

[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, u

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 > 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 > they could then convert

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

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: http://wiki.openstreetmap.org/wiki/The_Rail

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:

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 wrote: >> in Europe at least, airspace information is freely available > > Like this? > > http://www.nats-uk.ead-it.com/public/index.php%3Foption=com_content&task=blogcategory&id=167&It

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 fo

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

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 for

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 t

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 skept

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
Andy, On 11/08/10 17:54, Andy Allan wrote: > On Wed, Aug 11, 2010 at 3:00 PM, Ákos Maróy 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://wik

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 misus

[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 tech