Re: [OSM-dev] PostgreSQL 11 - osm2pgsql performance problems during --append?

2019-09-13 Thread Sven Geggus
Michael Kussmaul wrote: > - Or PostgreSQL 11 has some regressions? Unlikely. I'm using PostgreSQL 11 + Debian 10 on my new tile.openstreetmap.de machines without problems. Sven -- If we want hardware to work to its full potential, we need to claim to be a recent version of Windows. (Matthew

Re: [OSM-dev] Rendering OSM carto from epsg:4326 database

2019-09-11 Thread Sven Geggus
Frederik Ramm wrote: > (Or potentially run an update on your existing database the > re-calculates all the way_area values based on a reprojected polygon.) > > There might be other issues - how exactly does it not work? I get empty tiles thus I expect a reprojection issue. Sven -- Threading

[OSM-dev] Rendering OSM carto from epsg:4326 database

2019-09-11 Thread Sven Geggus
Hello, I just got stuck while trying to render osm-carto style from a database imported epsg:in 4326 format. I just changed the following: osm2pgsql: type: "postgis" dbname: "gis" key_field: "" geometry_field: "way" extent: "-20037508,-20037508,20037508,20037508" to osm2pgsql:

Re: [OSM-dev] osm2pgsql tile expiry performance

2019-06-04 Thread Sven Geggus
j wrote: > I'm afraid I do not have precise timings, but I'm seeing what appears > to be at least an order of magnitude performance penalty, probably due > to memory exhaustion. I can not confirm this. I have running the new tile Expiry code at least since December 2017. As I am about to setup

Re: [OSM-dev] Any problem with Debian tile servers?

2019-04-12 Thread Sven Geggus
: > On Thu, Apr 11, 2019 at 3:24 AM Sven Geggus > wrote: > ... >> tile.openstreetmap.de is running Debian from day one. So yes, this is >> working fine. > > Thanks, Sven. > > -Tom > > ___ > dev ma

Re: [OSM-dev] Any problem with Debian tile servers?

2019-04-11 Thread Sven Geggus
Tom Browder wrote: > I want to run my own tile server but I run Debian 9 on the server I plan to > use. All the docs I have seen so far target Ubuntu. Is there any problem > with using other Linux distros? tile.openstreetmap.de is running Debian from day one. So yes, this is working fine. Sven

Re: [OSM-dev] OpenStreetMap Carto release v4.12.0

2018-06-26 Thread Sven Geggus
Daniel Koć wrote: > Today, v4.12.0 of the OpenStreetMap Carto stylesheet (the default > stylesheet on the OSM website) has been released. This seems to completely kill my rendering performance. Will I need additional indexes? > time render_single_tile.py -s osm.xml -o test-v4.11.0.png -u >

Re: [OSM-dev] OpenStreetMap Carto release v4.12.0

2018-06-24 Thread Sven Geggus
Daniel Koć wrote: > Moreover this particular approach to surface rendering has been > developed for about a year, so I'm surprised you missed the whole > discussion. The problem is not with surface rendering but this: "* code re-ordering - no rendering change" I just try to manually re-add

Re: [OSM-dev] OpenStreetMap Carto release v4.12.0

2018-06-24 Thread Sven Geggus
Christoph Hormann wrote: > That's a really tough call. May I mention the fact, that Mapserver is still actively maintained and that there even is a carto preprocessor called magnacarto which is able to produce mapserver style files. Sven -- Freiheit ist immer die Freiheit des Andersdenkenden

Re: [OSM-dev] OpenStreetMap Carto release v4.12.0

2018-06-23 Thread Sven Geggus
Daniel Koć wrote: > Changes > - Added rendering “surface” tag on roads with a pattern This is not supposed to be a huge change, right? Are you unaware of the fact that there are forks of OpenStreetMap Carto like German style which are keept in sync by merging them with every upstream release?

Re: [OSM-dev] Coastline – osm2pgsql

2018-06-20 Thread Sven Geggus
SandorS wrote: > As I understand the two involved processes are independent and the results > are just mixed together at certain moment during the map-making process. Right. The main reason for doing this is, that coastlines tend to be broken very often. Likely they are broken more often than

[OSM-dev] Advantages PostgreSQL 10.0 + PostGIS 2.4

2017-10-08 Thread Sven Geggus
Hello, Debian stable 9.x comes with PostgreSQL 9.6 and Postgis 2.3. However the now released PostgreSQL 10.0 and Postgis 2.4 are an easy backport. Will the newer version provide any advantage for a osm2pgsql database use case? Sven -- If we want hardware to work to its full potential, we

[OSM-dev] Question regarding Carto 4.x database scheme

2017-07-31 Thread Sven Geggus
Hello, looking at the hstore support in Carto 4.x I was wondering if the provided lua script would work with an hstore-only database as well. I have been using such a scheme in carto-de for quite a while now and would like to continue doing so. osm=> \d planet_osm_hstore_line Tabelle

[OSM-dev] Questions regarding carto 4.0 release and German style fork

2017-05-28 Thread Sven Geggus
Hello, looking at the Openstreetmap Carto 4.0 release I see two major changes regarding the database layout. 1. We finally have hstore 2. Tags are pre-processed by a lua script. Is there more which might be relevant for the fork? Up till know Mapnik German style (an Openstreetmap Carto fork)

Re: [OSM-dev] OpenStreetMap Carto release v3.0.0

2016-12-22 Thread Sven Geggus
Christoph Hormann wrote: > No, the new project.mml is just a renamed project.yaml. *argh* So it would be best to do a git mv project.yaml project.mml before trying to merge? Sven -- Das Internet wird vor allem von Leuten genutzt, die sich Pornografie ansehen, während

Re: [OSM-dev] OpenStreetMap Carto release v3.0.0

2016-12-22 Thread Sven Geggus
Paul Norman wrote: > - Official Tilemill support is dropped Is this the reason why project.yaml has been removed? Thus project.mml is now the official style file? As yaml files are more readable why did you do this? Unfortunately my german style fork is based on a modified

Re: [OSM-dev] Taginfo files from osm2pgsql style files

2016-07-13 Thread Sven Geggus
Paul Norman wrote: > It's not the most useful utility but there's a chance it might be useful > for someone else. Hm, looks like this does not make that much sense in case of a hstore-only database like the one I am using in the german style setup. One should at least pass

Re: [OSM-dev] Mukti and Gargi fonts for openstreetmap-carto

2016-06-16 Thread Sven Geggus
Rory McCann wrote: > I'm also having this problem with "Mukti Narrow Bold". I have no problem > with "gargi Medium", that worked for me on stock Ubuntu 14.04 *shrug*. Jepp. Debian stable is slightly newer here than 14.04 thus gargi.ttf has already been removed from

Re: [OSM-dev] Mukti and Gargi fonts for openstreetmap-carto

2016-06-11 Thread Sven Geggus
Paul Norman wrote: > Something I've found when researching fonts for Asian languages is that > the versioning, releases, name consistency, and other releasing > engineering matters are often inadequate. Coupled to this, many webpages > for fonts disappear after a few years.

[OSM-dev] Mukti and Gargi fonts for openstreetmap-carto

2016-06-07 Thread Sven Geggus
Hello, I'm trying to install all required fonts for openstreetmap-carto on debian stable. Two fonts seem to be troublesome: "Mukti Narrow Bold" and "gargi Medium" While the former seems to be there (/usr/share/fonts/truetype/fonts-beng-extra/MuktiNarrowBold.ttf) but is not found by fc-match -s

Re: [OSM-dev] cross-fade map sample code (ol3 or leaflet)

2016-06-03 Thread Sven Geggus
Sven Geggus <li...@fuchsschwanzdomain.de> wrote: > Jepp. Is there a way to set layer opacity in OL3? Found the answer myself :) Opacity can be changed as follows: layername.setOpacity(x); With x between 0 and 1. Done that I am now looking for a way to reload tiles of a given lay

Re: [OSM-dev] cross-fade map sample code (ol3 or leaflet)

2016-06-03 Thread Sven Geggus
Mattias Dalkvist wrote: > The word you are looking for is opacity [1] Jepp. Is there a way to set layer opacity in OL3? Sven -- "Thinking of using NT for your critical apps? Isn't there enough suffering in the world?"

Re: [OSM-dev] cross-fade map sample code (ol3 or leaflet)

2016-06-03 Thread Sven Geggus
lars lingner wrote: > There are examples for OL3 [1] and for Leaflet [2] and [3]. This is simular, but not exactly what I'm up to. What I actually want is dissolving layers transparently like in http://sautter.com/map Sven P.S.: Looks like the correct word for

[OSM-dev] cross-fade map sample code (ol3 or leaflet)

2016-05-31 Thread Sven Geggus
Hello, you probably know http://sautter.com/map/ This is Openlayers 2 code which uses the concept of Base Layers and Overlays thus this map is kind of an abusing this concept. I was wondering if there is some sample code for leaflet or Openlayers 3 which will do something like this. I would

Re: [OSM-dev] Updated simplified osm2pgsql database dump available

2016-05-26 Thread Sven Geggus
Paul Norman wrote: > You'd still have the full storage footprint on one machine, it just > helps with the requirements on your read-only replica slaves. Yes,. I imagine that this machine can be run on a central server and peaple can use this one as a master. > What is not

Re: [OSM-dev] Updated simplified osm2pgsql database dump available

2016-05-25 Thread Sven Geggus
Paul Norman wrote: > To help with some OpenStreetMap carto development work, I've created a > dump of the rendering tables I have always been wondering if it would be possible to get rid of the special tables used for the sole purpose of keeping the rendering database

Re: [OSM-dev] osm2pgsql polygon handling semantic?

2015-10-20 Thread Sven Geggus
Paul Norman wrote: > For the osm2pgsql pgsql backend, a polygon is formed when a way is > closed and the tag transform sets a polygon flag. If either of these is > false, it is a linear feature. ... which is then inserted into planet_osm_line, right? For some reason I would

Re: [OSM-dev] osm2pgsql polygon handling semantic?

2015-10-20 Thread Sven Geggus
Simon Poole wrote: > Roundabouts? Or in fact any other way that is closed but clearly a > linear feature. I think those are usually not defined as a polygon anyway at least without area=yes. So far I have found two types of tags (waterway and aeroway) which will end up in

Re: [OSM-dev] osm2pgsql polygon handling semantic?

2015-10-20 Thread Sven Geggus
Paul Norman wrote: > Assuming it matches some tag with a column, yes. In a case where it has > only a key with polygon,nocolumn (or phstore), it wouldn't make it into > the line table or polygon table. This does not seem to be true. Artificial waterway.osm --cut--

[OSM-dev] osm2pgsql polygon handling semantic?

2015-10-19 Thread Sven Geggus
Hello, looking at the code of osm2pgsql and checking with a hand-crafted .osm file I came to the conclusion that polygons in osm2pgsql are handled in the following way: If a polygon is defined in the .style file a function is called which generates the simple-feature geometry object. If this

[OSM-dev] osm2pgsql: meaning of z_order column in polygon and point tables

2015-07-17 Thread Sven Geggus
Hello, I'm currently investigating the capabilities of imposm3 as a drop-in replacement for osm2pgsql. The Generation of the z_order column seems to be the only showstopper which is left to make an imposm3 generated databases suitable for rendering tiles with the osm standard style.

[OSM-dev] osm2pgsql: Unable to import planet

2015-01-12 Thread Sven Geggus
Hello, unfortunately I'm unable to import current planet files using osm2pgsql. This might be a psql issue because the strange error message I get seems to come from postgress rather than osm2pgsql: osm2pgsql -U postgres -s --number-processes=8 -C4000 -S hstore-match-only.style --flat-nodes

[OSM-dev] No more PBF planet files?

2014-12-28 Thread Sven Geggus
Hello, looking at the current osm planet file I only find osm.bz2 Versions. While http://planet.openstreetmap.org/planet/planet-latest.osm.bz2 is from 2014-12-22 http://planet.openstreetmap.org/pbf/planet-latest.osm.pbf is still dating back to 2014-12-07 An Idea? Sven -- Ich fürchte mich

Re: [OSM-dev] Release openstreetmap-carto v2.25.0

2014-12-11 Thread Sven Geggus
Andy Allan gravityst...@gmail.com wrote: So I pose a question that's most pressing on my mind - should the other maintainers be merging PRs without me reviewing them first? Will this lead to a better result? Hm, with osmarender we already had something like this in the past. Back then I

Re: [OSM-dev] load-osm.sh

2014-10-13 Thread Sven Geggus
Ilya Zverev i...@zverev.info wrote: The solution is obvious: I rented a huge hourly-priced droplet, installed postgresql and osm2pgsql there, imported a big OSM extract, deleted slim tables and transferred database contents to said rendering server. Jepp. I already did something like this

Re: [OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-10-09 Thread Sven Geggus
Jochen Topf joc...@remote.org wrote: I think a quick-and-dirty 80/20 solution would still be useful. Most projects currently supplying data to taginfo do not supply a complete list of tags they use either. +1 A list of the database table columns in use would be something like this. Sven --

Re: [OSM-dev] Adding Slippy Map to Taginfo's Projects Tab?

2014-10-08 Thread Sven Geggus
Holger Jeromin mailgm...@katur.de wrote: This is the problem. Some of the tags are transformed by an SQL query, which is not easy convertable to taginfo. How about just using the rendering database table or view column names. While symbols can not be added this way it would at least be a

Re: [OSM-dev] tirex and mapnik 3, make deb fails

2014-07-01 Thread Sven Geggus
Stephan Knauss o...@stephans-server.de wrote: Is a newer build automatically recognized as a newer package? No, use dch -i Regards Sven -- Der wichtigste Aspekt, den Sie vor der Entscheidung für ein Open Source-Betriebssystem bedenken sollten, ist, dass Sie kein Windows-Betriebssystem

Re: [OSM-dev] Vector tile based raster rendering - toolchain?architecture

2014-06-25 Thread Sven Geggus
Frederik Ramm frede...@remote.org wrote: I'd be interested to hear your opinions on this. IMO one of the big advantages of the mod_tile/tirex aproach is that it is in not bound to use mapnik as a renderer at all. Using tirex it is currently possible to use mapserver or any other renderer which

Re: [OSM-dev] New OSM Test Data Repository

2014-02-24 Thread Sven Geggus
Jochen Topf joc...@remote.org wrote: It also depends on what you are testing. If you are testing the OSM XML parser, those cases are valid data that the OSM parser must understand. If you are testing the renderer, it might be different. For the renderer it would be nice to have a model

Re: [OSM-dev] New OSM Test Data Repository

2014-02-24 Thread Sven Geggus
Jochen Topf joc...@remote.org wrote: I have started to work on a common OSM test data repository that can be used to test all sorts of software that works with OSM data. Hm, you seem to user real osm id-numbers. Don't you think we should define a private id-range for this purpose?

[OSM-dev] An alternative rendering-database setup and update strategy!

2013-11-25 Thread Sven Geggus
Hello, on my day-job I recently had to solve the Problem of setting up a Postgis database contaning a full-planet extract using one of those cheap 180GB SSD on a semi-potent machine (only 8GB of RAM). I first tried to use osm2pgsql for this purpose which is almost impossible for a couple of

[OSM-dev] My Openstreetmap style localization howto

2013-09-12 Thread Sven Geggus
Hello, I just wrote the missing documentation about how I did the localization of the german Tileserver. Probably of interest to people from other countries speaking languages written in latin script: http://blog.gegg.us/2013/09/a-simple-way-to-localize-latinize-an-openstreetmap-style/ Regards

Re: [OSM-dev] osmcoastline install question

2013-08-19 Thread Sven Geggus
Jochen Topf joc...@remote.org wrote: The osmcoastline README mentions the ubuntugis repository. Yes, it could probably be made clearer how to install this, but then I'd have to explain it for each and every distribution. I will second this. There are people (like me) which do not like to use

Re: [OSM-dev] Changing language in tile server

2013-08-12 Thread Sven Geggus
Gurpinder Chahal chahalgurpinde...@gmail.com wrote: I'm trying to change language in my OSM tile server. I have modified my fontset-settings.xml.inc and osm.xml. But these things didn't worked. These just gave rectangular boxes on my map. Can you describe in more detail what you tried to do?

Re: [OSM-dev] Bug in OSM.org map stylesheet? Text partially missing...

2013-08-06 Thread Sven Geggus
Manuel Reimer manuel.s...@nurfuerspam.de wrote: So for me it seems to be a bug somewhere in Mapnik. This is a tile edge artifact. Same on german style: http://www.openstreetmap.de/karte.html?lat=49.959186lon=9.656336zoom=18 Same Problem as with our Autobahn signs:

Re: [OSM-dev] disk size for planet osm import into PostGIS (on an SSD)?

2013-06-27 Thread Sven Geggus
Frederik Ramm frede...@remote.org wrote: and use a stripped style.xml I assume you meant osm2pgsql style. that ensures you don't store tons and tons of note and source tags and other import side products. You don't want to burden your SSD with tags like gnis:Class, NHD:FType,

Re: [OSM-dev] mod_tile on windows?

2013-06-07 Thread Sven Geggus
Vince Berubey scream...@hotmail.com wrote: Has any development been done since to be compatible with Windows? Besides the fact that I do not see a particular good reason for running a tileserver on windows (mapnik works fine on windows, so style development can already take place on windows), I

Re: [OSM-dev] Generate tiles with generate_tiles.py

2013-05-24 Thread Sven Geggus
Vince Berubey scream...@hotmail.com wrote: For example, I download an .osm.bz2 from Cloudmade, the map of Ile-De-France=Paris http://downloads.cloudmade.com/europe/western_europe/france/ile-de-france#downloads_breadcrumbs I would like to call generate_tyles.py from another language. I want

[OSM-dev] mod_tile causes segfault on debian 7.0

2013-05-22 Thread Sven Geggus
Hello, I have massive trouble running a recent version of mod_tile (git commit 03dedd4ec33c9d5e6495ea54d8a36b4ad916f65b) with my usual tirex backend. I get segmentation faults in mod_tile on a more or less regular basis which will leave apache in a 100% CPU on all cores state! [248792.019396]

Re: [OSM-dev] mod_tile causes segfault on debian 7.0

2013-05-22 Thread Sven Geggus
Andy Allan schrieb am Mittwoch, den 22. Mai um 13:34 Uhr: Ah, that's interesting, I'm seeing something very similar. I'm using 1341e129e5 (22 April) with apache2-mpm-event 2.2.22 (on Ubuntu 12.04) Debian stable is also using apache 2.2.22 (with apache2-mpm-worker in my case). I'm not sure

Re: [OSM-dev] lua+osm2pgsql=?

2013-04-28 Thread Sven Geggus
Kai Krueger kakrue...@gmail.com wrote: The question now is what to do with this? Is there enough interest for it to be worth cleaning it up and committing it? I once did a somewhat ugly hardcoded hack for converting width and height tags to useful floating point values by doing a lot of

Re: [OSM-dev] osm2pgsql: support for local route names

2013-04-15 Thread Sven Geggus
Kai Krueger kakrue...@gmail.com wrote: So name:de and name:fr are already available in the standard osm2pgsql db. Also all other tags of the route relation are in the db. Why osm2pgsql translates the name tag into route_name, I don't know. Also I wonder why there is so much special casing of

Re: [OSM-dev] tirex: Can't locate mapscript.pm

2013-04-15 Thread Sven Geggus
Marcus Kruse kr...@vivai.de wrote: where can I find the mapscript.pm? Hm, are you trying to manually build tirex? You should really build a package instead using dpkg-buildpackage (at least on Debian and Ubuntu). The required perl dependencies can be found in debian/control back to your

Re: [OSM-dev] osm2pgsql: support for local route names

2013-04-12 Thread Sven Geggus
RainerU ra...@sfr.fr wrote: As it works fine and the risk of regression or side effects seems very low to me, I propose to include this feature into the repository. Do the maintainers of osm2pgsql agree? Wouldnt it make more sense to copy all tags probably prefixing route_ to be compatible to

Re: [OSM-dev] mod_tile stable version ?

2013-03-30 Thread Sven Geggus
Sarah Hoffmann lon...@denofr.de wrote: I'd be very happy to see you step up as maintainer and move the stuff to github. I'd feel much more comfortable to submit pull requests to github instead of doing direct SVN commits that nobody even knows about unless the code fails in some annoying

Re: [OSM-dev] announcing a new mailinglist tile-serving

2013-03-30 Thread Sven Geggus
Simone Cortesi sim...@cortesi.com wrote: having two or more styles based on the same data. this is something I believe tirex will allow me to do. IMO the main advantage of tirex is its independance of render backends. While renderd intermixes actual rendering and queue management tirex uses

Re: [OSM-dev] mod_tile stable version ?

2013-03-28 Thread Sven Geggus
Jochen Topf joc...@remote.org wrote: Frederik uses Tirex and it works reliable for him As do I on tile.openstreetmap.de. NOP is also using Tirex on wanderreitkarte.de This is only solved by somebody taking up the torch and running with it. Jepp! I currently have a small patch for osm2pgsql

Re: [OSM-dev] mod_tile stable version ?

2013-03-27 Thread Sven Geggus
Bernard Fouché bernard.fou...@kuantic.com wrote: My time was mostly spent because of the lack of stable releases and documentation related to package versions, quirks here and there (for instance when making Tirex there is no check of what perl packages are already available Hm, this is

Re: [OSM-dev] mod_tile stable version ?

2013-03-26 Thread Sven Geggus
Bernard Fouché bernard.fou...@kuantic.com wrote: - but I have crashes with renderd with what's currently available on the SVN repo Frustration about renderd was the main reason why tirex was born a few years ago. So you will probably give it a try instead of renderd.

Re: [OSM-dev] mod_tile stable version ?

2013-03-26 Thread Sven Geggus
Bernard Fouché bernard.fou...@kuantic.com wrote: Tirex compilation completed, now I'm battling to understand where to fix a mysterious renderer internal error generated by tirex-backend-manager: I have mod_tile talking to tirex-master, the back-end manager sees the requests and then takes

Re: [OSM-dev] osm2pgsql way_area is 0 for small areas

2013-03-22 Thread Sven Geggus
Michael Kussmaul kussmaul.l...@nix.ch wrote: I'm using osm2pgsql in hstore+latlon configuration and experienced a problem with the calculated way_area. For small areas (parks, buildings) the value stored in the database is always 0. Looking at the code output_pgsql.c (line 931, 1162, 1215), I

Re: [OSM-dev] Getting lat and long from an address

2013-03-19 Thread Sven Geggus
drugdu fjb.pa...@gmail.com wrote: I’m trying develop an desktop application to get the lat and long base on an address, the problem is that I must do this offline, I tried to export the map, but I need all my county and the export tab says that I need to choose a smaller area, it’s my first

Re: [OSM-dev] Zeroing or Extending a Hillshade-Tiff

2013-03-11 Thread Sven Geggus
Peter Körner osm-li...@mazdermind.de wrote: what way would you choose and wich tools could be used to go that way? Use the Water-Polygons from openstreetmapdata.com instead of land polygons. This way you can use a layer order like this: * gray background * hillshade * water polygons without

Re: [OSM-dev] Reminder: Node 32-bit exhaustion

2013-02-08 Thread Sven Geggus
Andrew M. Bishop a...@gedanken.demon.co.uk wrote: If using the standard toolchain of osm2psql, postgresql and mapnik what is the minimum software versions that are needed to continue creating maps after ids reach 2^31-1? osm2pgsql supports 64bit id space already for a long time. But since

Re: [OSM-dev] Reminder: Node 32-bit exhaustion

2013-02-06 Thread Sven Geggus
Stephan Knauss o...@stephans-server.de wrote: How do I find out how many bits my server OS has? A portable ANSI C code for bitsize detection would be this one: #include stdio.h #include stdint.h int main() { printf(%d\n,8*sizeof(uintptr_t)); return(0); } I'm using the size of an unsigned

Re: [OSM-dev] How to make osm2pgsql quiet?

2012-12-19 Thread Sven Geggus
Svavar Kjarrval sva...@kjarrval.is wrote: I was wondering what methods you use to make osm2pgsql be quiet when run by crontab. Why calling it directly instead calling a wrapper script? At least if you go for incremental updates you need to run a wrapper script anyway because this will also

Re: [OSM-dev] installing Osmium on ubuntu 11.10

2012-12-04 Thread Sven Geggus
Martin Alegre tin.ale...@gmail.com wrote: I'm not sure what I did wrong and therefore any feedback is happily welcomed! Did you look at the readme? --cut-- PREREQUISITES - ... OSMPBF (for PBF support) https://github.com/scrosby/OSM-binary You need to build this first.

Re: [OSM-dev] Status of the Mapnik stylesheets

2012-11-14 Thread Sven Geggus
Lennard l...@xs4all.nl wrote: This requires a reload of the database to at least get public_transport=* in. To get a little bit more flexibility which such stuff we now use hstore and views on the german-style tileserver. The overhead is acceptable when using --hstore-match-only Our views

Re: [OSM-dev] Switch osm2pgsql to 64 bit mode

2012-09-15 Thread Sven Geggus
mar...@gmx.eu wrote: Oh, I see. Is there any chance you might update it for the previous (and still supported) LTS 10.04? Unfortunately I cannot update to 12.04. at present. :-( Just compile osm2pqsql yourself from svn version. That's what I always do and it is is not that complicated (at

Re: [OSM-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-20 Thread Sven Geggus
Even Rouault even.roua...@mines-paris.org wrote: Testing with larger areas, like whole France or Europe, shows sluggish performance when ways are built from nodes, but that's perhaps expected. I didn't compare with other tools to know if the indexing or request strategy is particularly

Re: [OSM-dev] osm2psql .style file parameters/values

2012-07-10 Thread Sven Geggus
mick bare...@tpg.com.au wrote: osm2pgsql does a decent job as far as _I_ can use it, the style file looks to me like it should be able to refine things more with different data types, eg. boolean, short int, int, long int, float,... No! In osm2pgsql tags are always assumed to be text which is

Re: [OSM-dev] Retina tiles - best way to support them?

2012-06-27 Thread Sven Geggus
Frederik Ramm frede...@remote.org wrote: Your thoughts on these options - are there more than these three, perhaps? - would be most welcome. Hm, I consider this to be a renderer rather than a stylefile issue. On Mapserver (which is unpopular in the OSM world for some reason) there is are two

[OSM-dev] Origin of shoreline_300.tar.bz2

2012-06-13 Thread Sven Geggus
Hello, looks like shoreline_300.shp is somewhat broken: http://www.openstreetmap.org/?lat=25.387lon=56.27zoom=9layers=M Where does this data originate from? Is this a simplifierd Version from processed_p? Probably it would be possible to re-tile it. Regards Sven -- Das allgemeine

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

2012-05-29 Thread Sven Geggus
Ákos Maróy a...@maroy.hu wrote: the command I used for the import was: /usr/local/bin/osm2pgsql -d osm -U osm -W -H localhost -S /usr/local/share/osm2pgsql/default.style -G -v -m -s -k -K -C 2048 europe-120525.osm.bz2 On Unix -H localhost does not make sence as does SSL because local

Re: [OSM-dev] A few coastline related questions

2012-05-07 Thread Sven Geggus
Preet prismatic.proj...@gmail.com wrote: * without splitting up of polys into tiles Are you shure that you want an unsplitted europe-asia-afrika? Both of these process planet.osm.pbf, which sometimes needs a 64bit machine with a certain amount of ram etc, depending on what exactly the tool

Re: [OSM-dev] osm2pgsql invalid polygons

2012-05-07 Thread Sven Geggus
Ramas ies...@ramuno.lt wrote: From user point this relation is correct but from geos point - not. Whatever your definition of OK may be. The Problem with multipolygons in their current form ist that there is no definition of a correct multipolygon AFAIK. As far as your Example is concerned

Re: [OSM-dev] osm2pgsql invalid polygons

2012-05-06 Thread Sven Geggus
Ramas ies...@ramuno.lt wrote: how do you solve problem with skipped invalid polygons? Fix it in the osm database? with error: Self-intersection at or near point 2889220.240002 7470212.12 This does not look as a valid polygon to me at leadt in OGC Simple Features terms. This

Re: [OSM-dev] Coastline by Name

2012-04-24 Thread Sven Geggus
Peter Körner osm-li...@mazdermind.de wrote: I was looking for Coastline-Polygons by Country-Name, that would be the coastline intersected with the administrative border and saved under that name. Before I start to build that on myself I'd like to ask if there's already Code to do that.

Re: [OSM-dev] hacking outdoor GPS devices

2012-04-17 Thread Sven Geggus
Mitja Kleider schrieb am Montag, den 16. April um 20:26 Uhr: * Are you satisfied with the available devices? No! They are either not really usable for outdoor stuff (Smartphones even true for Motorola DEFY) or use proprietary firmware which can not be hacked (Garmin devices) What would you

[OSM-dev] converting mod-tile dir to flat files?

2012-04-15 Thread Sven Geggus
Hello, I have a local mod-tile+ tirex installation running on my desktop at home. Now to publish this tiles on a machine without mod-tile I would like to convert this stuff to a flat file layout z/x/y.png I already found convert_meta which will produce the required png files but not the z/x/y

Re: [OSM-dev] converting mod-tile dir to flat files?

2012-04-15 Thread Sven Geggus
Stefan de Konink ste...@konink.de wrote: So nothing 'on the fly'? Only postprocessed? Yes. Sven -- If you continue running Windows, your system may become unstable. (Windows 95 BSOD) /me is giggls@ircnet, http://sven.gegg.us/ on the Web ___ dev

Re: [OSM-dev] Exhaustion of 32bit signed integer range expected this year

2012-04-13 Thread Sven Geggus
Frederik Ramm frede...@remote.org wrote: Software processing OSM data will need to either use unsigned integers (which can be problematic in cases where negative values are also required), or switch to 64bit integers altogether. Or used for other purposes like in osm2pgsql. Will the

[OSM-dev] Licence of the Mapnik style?

2012-04-10 Thread Sven Geggus
Hello altogether, with the upcoming adoption of the ODBL for OSM data the licence of common Mapnik styles will definitely get more important! I strongly feel the need of a decent map style to be distributed under a copyleft style licence (IMO Affero GPL would be best suited, but IANAL) to make

Re: [OSM-dev] Licence of the Mapnik style?

2012-04-10 Thread Sven Geggus
Richard Fairhurst rich...@systemed.net wrote: The shields are mine, and I think the core highway colours (motorway, trunk, primary, secondary) might be too, and I'm happy to see them go under WTFPL. (But, AGPL, ugh.) The reason why I have been thinking about AGPL ist that Mapnik stuff is

Re: [OSM-dev] Licence of the Mapnik style?

2012-04-10 Thread Sven Geggus
Komяpa m...@komzpa.net wrote: If mapnik sytlesheet will become AGPL we'll have to get rid of our local instance, just to make sure our stylesheet won't be affected. I have not been talking about changing the (unknown) licence of the original mapnik stylesheet but of our germanstyle which is a

Re: [OSM-dev] Licence of the Mapnik style?

2012-04-10 Thread Sven Geggus
Cartinus carti...@xs4all.nl wrote: That would already be achieved with GPL. You don't need AGPL for that. You might be right. Given that the analogy is as follows: (mapnik=compiler, stylefile=sourcecode, tile=binary) Distributing tiles without stylefile would be like distributing binaries

Re: [OSM-dev] different rendering with mapnik based on area?

2012-04-02 Thread Sven Geggus
Peter Körner osm-li...@mazdermind.de wrote: Choose whichever way fits your needs best - and tell us about. The question is how Mapquest is actually doing it? Regards Sven -- Every time you use Google, you're using a Linux machine (Chris DiBona, a programs

[OSM-dev] different rendering with mapnik based on area?

2012-03-31 Thread Sven Geggus
Hi there, is it possible to have different rendering rules based on the area where rendring takes place using an ordinary mapnik rendering stack (osm2pgsql+mod_tile+tirex)? What I would like to do (for now) is implementing a name rendering logic for the german mapnik style: name outside europe:

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread Sven Geggus
Darafei Praliaskouski m...@komzpa.net wrote: I am not using route= relations in osm2pgsql. Is there a way to skip their processing, to get more speed than 4 relations/sec? You could just skip the code following if( strcmp(type, route) == 0 ) in output-pgsql.c, but I doubt that this will

Re: [OSM-dev] Using custom renderer with mod_tile

2012-03-01 Thread Sven Geggus
Skye Book skye.b...@gmail.com wrote: Thanks for the clear explanation.. That meshes well with what I understood from reading the wiki and cursory looks at source code http://wiki.openstreetmap.org/wiki/Tirex/Overview has a nice diagram about how the different modules communicate. It is

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread Sven Geggus
sly (sylvain letuffe) li...@letuffe.org wrote: Reading that thread, I remembered that I don't need type=route either, I've commented that part of osm2pgsql but the speed gain is hardly noticeable (if at all) Quite in contrast to multipolygon relations, there is almost no computation in

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-02-29 Thread Sven Geggus
Frederik Ramm frede...@remote.org wrote: If we start coding special cases into osm2pgsql, we have to code the same special cases into lots of other applications too. AFAIK osm2pgsql currently supports two types of relations: type=route amd type=multipolygon. Both of them _are_ special cases.

Re: [OSM-dev] Osm2pgsql not importing routes?

2012-02-24 Thread Sven Geggus
yvecai yve...@gmail.com wrote: Which contains 49 relations according to osm2pgsql output, but the following requests find nothing: select count(*) from planet_osm_line where osm_id = -1401913; select count(*) from planet_osm_line where osm_id 0; and the column route_name does not

Re: [OSM-dev] processed_p.tar.bz2 inverted?

2012-02-23 Thread Sven Geggus
Paul Norman penor...@mac.com wrote: You might be able to generate an inverted one by inverting the coastline_*.shp files before passing them to the rest of the coastcheck process to generate processed_p. Is this coastcheck process a documented workflow? Sven -- Den Rechtsstaat macht aus,

Re: [OSM-dev] processed_p.tar.bz2 inverted?

2012-02-23 Thread Sven Geggus
Paul Norman penor...@mac.com wrote: You might be able to generate an inverted one by inverting the coastline_*.shp files before passing them to the rest of the coastcheck process to generate processed_p. Are these available for download somewhere or would I need to extract them from a

[OSM-dev] processed_p.tar.bz2 inverted?

2012-02-22 Thread Sven Geggus
Hello, this is probably more of a GIS Question than an OSM one. For a nice combination of hillshade and water I would like to invert the processed_p.shp file from http://tile.openstreetmap.org/processed_p.tar.bz2 This should prevent rendering of hillshaded water on the edges as water can be

Re: [OSM-dev] Our #switch2osm story

2012-02-11 Thread Sven Geggus
Helge Fahrnberger he...@toursprung.com wrote: As existing options don't cater very well for the world of tourism and outdoor sports we have decided to render our own tiles, with hill shading and contours. Would you mind sharing some Information about the technology in use? tirex, mod_tile,

[OSM-dev] Rendering rivers in real width

2012-02-11 Thread Sven Geggus
Hello, on Osmarender I once implemented rendering of rivers, stream, canal, etc. in their real width. A Cartographer once told me that unlike roads waterbodies are usually drawn in their real extent on maps after all. With Osmarender beeing abandoned now, there will soon be no map available

Re: [OSM-dev] ANNOUNCEMENT: T@H server will go away end of February

2012-02-06 Thread Sven Geggus
Matthias Meißer dig...@arcor.de wrote: Bad to hear. But maybe this is the right moment, we should care about a real easy to use distributed rendering approach, again? To be serious, I consider distributed rendering broken by design. Here is why: Distributed computing is usually a good idea

  1   2   >