On Tue, Nov 27, 2018 at 10:59:00AM +0100, Jochen Topf wrote:
> On Tue, Nov 27, 2018 at 10:10:35AM +0100, Florian Lohoff wrote:
> > i am using poly exports from Wambacher (thanks) to extract pbf
> > content from a germany export. Now i am trying to use the
> > admin boundary
On Tue, Nov 27, 2018 at 10:59:00AM +0100, Jochen Topf wrote:
> On Tue, Nov 27, 2018 at 10:10:35AM +0100, Florian Lohoff wrote:
> > i am using poly exports from Wambacher (thanks) to extract pbf
> > content from a germany export. Now i am trying to use the
> > admin boundary
ml
I know that - That means i need to rexport the admin boundarys from
wambacher as shape. Use shp2pgsql to put them into the postgis,
buffer them and rexport somehow as poly.
I though i would not be the only one having the problem.
I whished osmconvert had a "ready to use" buffer funct
- is there a tool(-chain) for poly -> poly adding some buffer
e.g. 50-100m ?
Flo
--
Florian Lohoff f...@zz.de
UTF-8 Test: The 🐈 ran after a 🐁, but the 🐁 ran away
signature.asc
Description: PGP s
or the old files I quickly did that with a too
> broad search-and-replace command ;)
So you actually say that geofabrik pbf/osc files dont contain valid
usernames anymore?
I was wondering why i saw numerical usernames but if thats the case
i can drop usernames from my QA tools.
Flo
--
Florian
time.
> Depending how things go, next up would be the tile.openstreetmap.org caches.
From my understanding TFO solves the problem HTTP/2 (or SPDY) solved by
muxing streams of data into the same tcp connection or am i wrong?
What about HTTP/2 support?
Flo
--
Florian Lohoff
ady have a generic Osmium Object Spatial Index
storage at hand that i just overlooked?
Flo
--
Florian Lohoff f...@zz.de
We need to self-defend - GnuPG/PGP enable your email today!
signature.asc
Description: Digital
ything is possible
but its hard to get it wrong.
Flo
--
Florian Lohoff f...@zz.de
We need to self-defend - GnuPG/PGP enable your email today!
signature.asc
Description: Digital signature
___
dev
actionDao.addAction(entityMapper.getEntityType(),
ChangesetAction.DELETE, entityId);
+
+
namedParameterJdbcTemplate.update(entityMapper.getSqlDelete(true), args);
}
Flo
--
Florian Lohoff f...@zz.de
We need
vice as to how I could address this issue?
I would enable statement + time logging in postgres to
see which statement results in the delay.
Then modify osmosis to not call that statement. In the
end its open source and if it breaks you may keep both halves.
Flo
--
Florian Lohoff
m solving as a steiner tree). Takes some seconds.
This works pretty well but most likely not on a per country size.
Flo
--
Florian Lohoff f...@zz.de
We need to self-defense - GnuPG/PGP enable your email today!
signature.asc
Description: Digital
~/bin/osmi ~/germany.osm.pbf germany
node processing in FirstHandler finished
terminate called after throwing an instance of 'std::out_of_range'
what(): Missing location
Aborted
As all production machines i have are Wheezy i am lost here.
Flo
--
Fl
Anything else? ;-)
Is it planned to offer an export of the subset of open and possibly
recently closed notes?
12M is not that much today but for creating a garmin gmapsupp with
notes pulling the full history might not be the desired process.
Flo
--
Florian Lohoff
ore than just thanks.
> Not just for your continued expertise, but for the ten years of
> commitment so far.
Sysadmin appriciantion day is on 28th of July :)
SCNR
Flo
PS: http://de.wikipedia.org/wiki/System_Administrator_Appreciation_Day
--
Florian Lohoff
eone who likes to play with OSM Data i'd simply add an OSM
Repository and be able to install osmosis, mapnik, postgis in their
current version. As a newbie you spend a lot of time getting all the
software together, built and then you Discover you need mapnik 2.2 and
not 2.0 and for this you miss
ofile from profile.lua
[error Contractor/../DataStructures/ImportEdge.h:44] Type: -1
which is not very helpful on what i did wrong.
I am using cc73ed19b3f83cc7e718a94580c79d02aea8567a May 14
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Descriptio
ore concurrent accesses.
SSDs will help accelerate indexes but today are not a solution for the
full database comparing € or $.
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital signature
__
Hi,
is anyone still maintaining the AIO styles? It seems most of
it is unmaintained and throws warnings about deprecated usage of
display_name in current mkgmap versions.
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital
Hi,
is there a full notes dump available somewhere for processing with
mkgmap e.g. Garmin maps?
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital signature
___
dev mailing list
dev
00b0: 91 .
Did anyone try to decode this or even use it within the JOSM Videomapping
plugin?
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digi
ynamic temporary layers
to the view like pasting a kml url to google maps search bar.
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital signature
___
dev mailing list
dev@openstreetmap.org
ank you - MapOSMatic is one of my favorite sites to show the
advantages of OpenStreetMap and it is a fantastic Service.
I love the changes and new features.
Keep going
Flo
--
Florian Lohoff f...@zz.de
signature.a
>
> All of that, plus that the UI is usable w gloves (which you need
> while biking at least half of the year), even in the rain, and still
> gives tactile feedback.
Which excludes any kind of touch interface which is a PITA.
> And the handlebar mount.
Flo
--
Florian Lohoff
ewhere ;)
> * Are you interested in developing your own firmware (if drivers were
> available)?
Definitly.
> * Why would you but an outdoor GPS anyway instead of using your smartphone?
More robust - Better battery life - Better display in direct sunlight.
> Your opinion on these questi
ld probably have a strange effect of letting people use the
track but prefer a route of 50km when avoiding 10m of track :)
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital signature
__
On Fri, Jul 08, 2011 at 09:34:35AM -0500, Ian Dees wrote:
> On Fri, Jul 8, 2011 at 9:12 AM, Florian Lohoff wrote:
>
> >
> > Hi,
> > i just found a future bug when postgis 2.0 will be used more - osmosis 0.39
> > uses legacy functions e.h. MakeLine which should be
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 14 more
--
Florian Lohoff f...@zz.de
„Für eine ausgewogene Energiepolitik über das Jahr 2020 hinaus ist die
Nutzung von Atomenergie eine Brückentechnologie und unverzichtbar
a PITA and it was simply an undocumented change in
default behaviour..
Flo
--
Florian Lohoff f...@zz.de
„Für eine ausgewogene Energiepolitik über das Jahr 2020 hinaus ist die
Nutzung von Atomenergie eine Brückentechnologie und unverzichtbar. Ein
Ausst
d process once it takes to long.
Just put it to any value which always works so the update has at least
a chance to recover.
Flo
--
Florian Lohoff f...@zz.de
„Für eine ausgewogene Energiepolitik über das Jahr 2020 hinaus ist die
Nutzung von Atomene
Hi,
just a Heads up - the minutely replication broke this morning 5:59
t...@h stopped rendering soon later as all TRAPIs were out of date.
Flo
--
Florian Lohoff f...@zz.de
Professionell gesehen bin ich zu haben
and not individually care on reading the PBF itself.
And C would have been my preferred choice anyway ;)
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital signature
___
dev mailing lis
es I guess.
I did - and it broken - and i am on vacation ;) Will try to repair it
tonight with a flaky gprs link :(
Flo
--
Florian Lohoff f...@zz.de
signature.asc
Description: Digital signature
t them into a hstore tags column in the
way table and then cluster the way table with the geom index on the linestring
for example.
Does anyone have speed/place comparisons?
Flo
--
Florian Lohoff f...@zz.de
"Es ist ein grobes Missverständnis und eine
wn
Source)
at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
Flo
--
Florian Lohoff f...@zz.de
"Es ist ein grobes Missverständnis und eine Fehlw
one has a half way speedy connection.
Flo
--
Florian Lohoff f...@zz.de
"Es ist ein grobes Missverständnis und eine Fehlwahrnehmung, dem Staat
im Internet Zensur- und Überwachungsabsichten zu unterstellen."
- - Bundesminister Dr. Wolfgang S
te these if nobody yells.
> I'll give it at least a few days though.
How do i init the --rri task (--rrii) to a specific date/time?
I am set off at 7th of Jan 0:00 and i'd like to continue with --rri from
there.
Flo
--
Florian Lohoff
nt of the
boundary but rather show the user the box on a map which "would be mapped"
and let it be moved and resized.
I made a map of "Langenberg Germany" which has some odd shape and some parts
of it are of no real interest - the result is that we have a very large extent
of the ma
he replicated
diff stuff has not been documented and i didnt want to read java code
to find out ...
Flo
--
Florian Lohoff f...@rfc822.org
"Es ist ein grobes Missverständnis und eine Fehlwahrnehmung, dem Staat
im Internet Zensur- und Überwachungsabsichten zu
hes and
those simply fall-back to a If-Modified-Since query for an individual object. A
map call which josm uses to download map data is a multi-objects-in-an-area
call which would when fall-back to an if-modified-since query need to do the
very same query to the database - So - you would not s
e people are aware of the problem. I'll try to
> spend some time on IRC over the next few days. Whatever the solution, I
> won't have the time (or skills) to do it on my own.
Is this fixed or at least somebody has an idea how to fix this? Its
On Wed, Sep 09, 2009 at 06:07:35PM +, Ævar Arnfjörð Bjarmason wrote:
> On Wed, Sep 9, 2009 at 2:41 PM, Florian Lohoff wrote:
> > If OSM usernames would not allow spaces and be case sensitive
> > it would be possible to make the OSM usernames an email adress.
>
> RFC 822 i
On Tue, Sep 08, 2009 at 08:35:51AM +0100, Tom Hughes wrote:
> Subject: Re: [OSM-dev] what server next?
>
> On 08/09/09 08:21, Florian Lohoff wrote:
>
>> Sometimes i'd like to actively contact mappers in that distant region and
>> mostly i dont care what they are ca
he attribution-db and spreads the extended OpenLayer lib.
Sometimes i'd like to actively contact mappers in that distant region and
mostly i dont care what they are called - simply - send email to top most
recently active mappers in that region.
Flo
--
Florian Lohoff
On Tue, Aug 11, 2009 at 10:24:56PM +0200, Stephan Knauss wrote:
>
> The list talk-de is configured for replies to the list.
Which i consider a bug and eliminate that header:
:0 fhc
* ^List-Id: Openstreetmap allgemeines in Deutsch
| formail -R Reply-To X-No-Reply-To
Flo
--
Florian
On Tue, Aug 11, 2009 at 10:24:56PM +0200, Stephan Knauss wrote:
> Florian Lohoff wrote:
>> Reply-To: to the list has some bad side effects concerning bounces,
>> vacation etc - The list software has to be very good in eliminating
>> those.
>
> Vacation mails sh
- The list software has to be very good in eliminating those.
http://www.unicom.com/pw/reply-to-harmful.html
Flo
--
Florian Lohoff f...@rfc822.org
"Es ist ein grobes Missverständnis und eine Fehlwahrnehmung, dem Staat
im Internet Ze
Hi,
there are no newer diffs for the last 12 hours ...
Flo
--
Florian Lohoff f...@rfc822.org
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
gt; one each street is inside of.
The problem with those polyons are that they are not fast - To make
this usable for renderers one needs to apply a lot of optimization
and precomputing.
Flo
--
Florian Lohoff f...@rfc822.org
Those who wou
wn in Germany
so it makes sense to create the correct abbreviations once ...
Flo
--
Florian Lohoff f...@rfc822.org
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Fr
Hi,
planet.openstreetmap.org does not have any hourly diffs
since 0:00 this morning.
Known bug? Havent seen any mention so far ...
Flo
PS: Minute diffs stop at 200907080153.osc.gz ...
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up
On Sat, Jul 04, 2009 at 02:57:35PM +0200, Lennard wrote:
> Florian Lohoff wrote:
>
>> The problem with the different projection will be that you'll need
>> to modify the sql queries made in the mapnik xml to reproject
>> to a different projection. IIRC the default osm2
2pgsql and
yes - you'll need the postgis extension.
The problem with the different projection will be that you'll need
to modify the sql queries made in the mapnik xml to reproject
to a different projection. IIRC the default osm2pgsql imports
with is ESRI:900913 aka google/mercator.
Flo
On Thu, May 07, 2009 at 10:56:01AM +0200, Frederik Ramm wrote:
> Subject: Re: [OSM-dev] osmosis - planet import pgsql simple schema
>
> Hi,
>
> Florian Lohoff wrote:
>> i tried to import the current planet into a psql simple schema 0.6 and it
>> fails with osmosis 0.30
)
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)
Line 6663 is not suspicious:
f...@tiles-two:~/initialimport$ bzcat planet-090506.osm.bz2 | sed -ne '6663p'
^C
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would
BBOX.
>
> Was it like that before, is it new and on purpose or a bug?
It was the same before - The database does not have any line geometries
so the way to get all entitys in the bbox is to get all nodes in the bbox.
Get all ways to those nodes, get all nodes to those ways.
F
more tasks
failed.
at
org.openstreetmap.osmosis.core.pipeline.common.Pipeline.waitForCompletion(Pipeline.java:146)
at org.openstreetmap.osmosis.core.Osmosis.run(Osmosis.java:85)
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)
--
Florian Lohoff
mosis.java:85)
at org.openstreetmap.osmosis.core.Osmosis.main(Osmosis.java:30)
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjami
This is why 72GB disks are still common in storage systems.
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
De
ee where a way
is split up instead of selecting the way and detect it by the highlighting
I put arrows in " because it would not necessarily be arrows but some
end/start of segment indicator - probably just some change in line
thickness or something.
Flo
--
Florian Lohoff f
master database. Synchronization is a big issue
here but it should be a good point for scalability ...
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - B
e list about the TomTom case or about osm related bithacking in
> general? When it is about a certain format, an svn-repo or wiki-pages
> would be my choice.
tomtom format list i'd say - we could use an svn (although i meanwhile
prefer git as its a lot faster and imho easier)...
Flo
--
Flo
On Wed, Dec 31, 2008 at 11:43:48AM +0100, Stefan de Konink wrote:
> Florian Lohoff wrote:
> >>But what is your motivation about this? Just to enlarge userbase (OSM)?
> >
> >Dont we all wish OSM "run-everywhere" maps?
>
> My main motivation is still n
On Wed, Dec 31, 2008 at 12:11:42AM +0100, Stefan de Konink wrote:
> Florian Lohoff wrote:
> >My rough guess is that they have no interest - They make money by
> >selling the maps and it would be unwise to help the "others" ..
>
> There is another variable to th
On Tue, Dec 30, 2008 at 11:42:36PM +0100, Stefan de Konink wrote:
> Florian Lohoff wrote:
> >I'd be interested in bit hacking too - Have the findings been documented
> >somewhere? Would a seperate list make sense?
>
> My attempt was 'illegal' because I
e observation; I wouldn't be surprised if they first
> define the scope of the structures in the file format to be compatible
> between every release that is using that interpreter; and then bit
> efficient encode it.
I'd be interested in bit hacking too - Have the findings been
nes in the database (sequence wise) so the database/api
needs to reorganize sequence numbers of nodes you didnt edit. Id say -
very ugly ..
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up a little freedom to get a little
sec
ough to take over the old content and
recreate the index ...
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither -
number on the way - so you may
only address -32768 to +32767 number of nodes on a way - 40k nodes
is out of scope of a smallint so osmosis breaks on importing the
changeset.
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who would give up a little f
osmosis in
> read-change-interval mode to get the db current.
>
> Is this the correct method?
Thats how i did it in the past ... Typically i delayed the rebuild until
wednesdays ;)
Flo
--
Florian Lohoff f...@rfc822.org +49-171-2280134
Those who wou
ment and i couldnt find anything strange
in the data.
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
sign
or
51.777981,8.365480,J,service,service
51.777903,8.365700,j,service,service
51.73,8.365780,j,service,service
51.777598,8.365851,j,service,service
51.777361,8.365932,j,service,service
I tried to find out what the Jump means but the code is non obvious.
gosmore and data of today (data
mirror:
http://roma.osm.lab.rfc822.org/api/0.5/map?bbox=16.35103,48.21466,16.35432,48.21705
But its already fixed as i said ...
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get
On Sat, Nov 08, 2008 at 04:02:13PM +0100, Frederik Ramm wrote:
> Hi,
>
> Florian Lohoff wrote:
> >I dont think anyone expects every reponse of the server to be validated.
>
> I was under the impression that Hugh did.
>
> >I have no problems if the DTD is a moving
So I am in
favour of a possibility to validate xml output from time to time
against a DTD - I have no problems if the DTD is a moving target and
people get told something changed. But currently there is nothing to
check against (except loading into josm and trying to interpret the
error message). But
Hi,
does anyone have a easy method to convert the maproom country polygon
to a postgis area? That would allow selecting only germany etc ...
or is there a different method i have not thought about?
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
On Fri, Oct 31, 2008 at 11:17:16AM +0100, Florian Lohoff wrote:
> Hi,
> i just discovered that osmosis was not able to apply the hourly osc file
> starting 2008-10-29T20:00:00Z - It failed with:
>
> 2008-10-31 11:09:52 CET ERROR: smallint out of range
> 2008-10-31 11:09:52 CET
there a way with >2^16 aka 65536 nodes?
Or did someone manage to enter a completely broken sequence number?
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon h
On Fri, Oct 24, 2008 at 12:49:47PM +1100, Brett Henderson wrote:
>It looks like there's some broken UTF-8 in changesets again. Presumably
>another tag has been truncated half way through a UTF-8 sequence when
>writing to the database.
>
>I'm heading away for the weekend and won't
Hi,
i promised to write a ROMA Wiki page to make it clear whats behind it
(its really simple) and how to set up your personal ROMA ;)
http://wiki.openstreetmap.org/index.php/Read_Only_Map_API
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who
On Sat, Oct 04, 2008 at 06:34:12PM +1000, Brett Henderson wrote:
> Subject: Re: [OSM-dev] way 27483626 UTF-8 truncation
>
> Florian Lohoff wrote:
> >On Sat, Oct 04, 2008 at 03:24:12PM +1000, Brett Henderson wrote:
> >
> >>>Another 2 change files contain utf-8 bu
On Sat, Oct 04, 2008 at 03:24:12PM +1000, Brett Henderson wrote:
> >Another 2 change files contain utf-8 bugs and osmosis refuses to process
> >them:
> >
> >200810031022-200810031023.osc
> >200810031023-200810031024.osc
> >
> I've tested both of these files and they seem okay. The only problem I
dev/2008-August/011525.html
Another 2 change files contain utf-8 bugs and osmosis refuses to process
them:
200810031022-200810031023.osc
200810031023-200810031024.osc
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give
s/postgis is faster than mysql and i prefer postgres
anyway so i'd not have to deal with this.
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither
i.pl
Is a perl variant - look for "sql_for_area"
In the rails_ports its done with a C helper - look in
sites/rails_port/lib/quad_tile/
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a littl
hat do you think?
The code in the api calculates all possible quadtile areas and does a
quadtile in ( x, y, z, a, b, c, d, e, f ) or quadtile between x and y
etc
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a lit
22.org/~flo/map.cgi
pgsql: http://tiles-two.lab.rfc822.org/~flo/map-pgsql.cgi
The pgsql is much simpler as i shifted most of the work of selection,
exclusion and merging into the database temp tables.
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who
On Thu, Sep 11, 2008 at 08:54:15AM +0200, Frederik Ramm wrote:
> Subject: Re: [OSM-dev] Invalid XML?
>
> Hi,
>
> Florian Lohoff wrote:
> >Its not that the xml is broken afterwards but people could start putting
> >bad things into the database by closing a tag and reope
hought it was invalid because
> some other XML page mentioned to use \\)
>
> Since this clearly looks like a typo (trying to hit enter) one my ask if
> a client should check for this...
A couple of days back i started a thread about this kind of problems.
Its not that the xm
gt; >the map api call does for a bbox, is current up to date X.
>
> Planet dumps don't - they only have a date.
But the convention says - contains all changes up to 1:00Z on that date
and possibly some later ones occuring through the dump.
Flo
--
Florian Lohoff [E
On Tue, Sep 09, 2008 at 01:52:24PM +0200, Stefan de Konink wrote:
> Subject: Re: [OSM-dev] osm schema/dtd - planet and request timestamp
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Florian Lohoff schreef:
> > Do you have a url? One can find tons of
On Tue, Sep 09, 2008 at 12:37:14PM +0100, Tom Hughes wrote:
> Florian Lohoff wrote:
>
> >No need for object versioning here - I want to enable everyone to look
> >at when the data was generated and from which database state.
>
> Well for planet that's simple
On Tue, Sep 09, 2008 at 11:15:54AM +0100, Shaun McDonald wrote:
> Subject: Re: [OSM-dev] osm schema/dtd - planet and request timestamp
>
> Florian Lohoff wrote:
> >Hi,
> >with the increasing number of database mirrors satisfying requests for
> >the various types of appl
On Tue, Sep 09, 2008 at 12:31:43PM +0200, Stefan de Konink wrote:
> Subject: Re: [OSM-dev] osm schema/dtd - planet and request timestamp
>
> On Tue, 9 Sep 2008, Florian Lohoff wrote:
>
> > I was looking at http://kinkrsoftware.nl/contrib/osm/osm-0.5.xsd which
> > does no
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
Description: Digital sign
On Mon, Sep 08, 2008 at 10:35:19PM +0200, Florian Lohoff wrote:
> The URL to try with is here:
>
> http://tiles-two.lab.rfc822.org/api/0.5/map?bbox=
>
> The biggest advantage though is that it seems not to have the obscure
> utf-8 bugs i have seen with the mysql. All outp
drivers don't expose
> that kind of functionality.
Shure - the point is that you cant keep the database up to date with
the write-changes as it throws an exception when you simple drop the
bbox column ...
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
case the planet is older than 15 minutes.
Flo
--
Florian Lohoff [EMAIL PROTECTED] +49-171-2280134
Those who would give up a little freedom to get a little
security shall soon have neither - Benjamin Franklin
signature.asc
Description: Digital
stead of
pulling the data together in perl. Concerning the simple scheme. Its
also missing an index on the way_nodes table for the way_id but thats
just peanuts.
> On Mon, Sep 08, 2008 at 11:58:18AM +0200, Florian Lohoff wrote:
> > i was trying to use the postgresql simple schema from osmo
On Mon, Sep 08, 2008 at 02:29:18PM +0200, Jochen Topf wrote:
> Subject: Re: [OSM-dev] osmosis pgsql schema / way.bbox removal/option
>
> On Mon, Sep 08, 2008 at 11:58:18AM +0200, Florian Lohoff wrote:
> > i was trying to use the postgresql simple schema from osmosis to import
&
dx_relation_tags_relation_id ON relation_tags
USING btree (relation_id)",
- "UPDATE ways SET bbox = (SELECT Envelope(Collect(geom)) FROM
nodes JOIN way_nodes ON way_nodes.node_id = nodes.id WHERE way_nodes.way_id =
ways.id)",
- "CREATE INDEX idx_way
1 - 100 of 103 matches
Mail list logo
