Ah, yes - good idea. Will do! : ) Thanks, Jeff
On Fri, Dec 14, 2012 at 4:16 PM, mick wrote:
> On Fri, 14 Dec 2012 16:01:06 -0800
> Jeff Meyer wrote:
>
> > I'm planning to seed the db with shoreline information & not much else.
> >
> I would add water courses as well, throughout history they ha
On Fri, 14 Dec 2012 16:01:06 -0800
Jeff Meyer wrote:
> I'm planning to seed the db with shoreline information & not much else.
>
I would add water courses as well, throughout history they have been used as
boundaries, both physical and spiritual.
mick
_
Anyone have any advice on hosting the Rails Port?
I'm looking at setting up a sandbox for Historical OSM and am both
impressed and daunted by the range of hosting options available. I've
installed it on AWS, but it seems a little on the steep side ($$) for 24x7
operations.
I realize every option
On Fri, Dec 14, 2012 at 3:02 PM, Martin Schafran wrote:
>
>
> > Thanks a lot for the advice. The query as I previously mentioned it would
> > be as simple as a "SELECT * FROM db WHERE X=X AND DISTANCE<5km". There
> > wouldn't be more type of queries.
> >
> >
>
> what happens if X=X matches the hal
> Thanks a lot for the advice. The query as I previously mentioned it would
> be as simple as a "SELECT * FROM db WHERE X=X AND DISTANCE<5km". There
> wouldn't be more type of queries.
>
>
what happens if X=X matches the half database?
a lot of comparisons.
filter nodes by bbox
WHERE ST_Make
2012/12/14 Martin Schafran
> use ssd,
> cluster nodes on spatial index,
> perform vacuum
> and show us your query.
>
Thanks a lot for the advice. The query as I previously mentioned it would
be as simple as a "SELECT * FROM db WHERE X=X AND DISTANCE<5km". There
wouldn't be more type of queries.
> The idea behind the same location was so that any documentation or
> links that still point to that location would automatically be
> up-to-date again. That would probably be easier than finding any and
> all documentation for windows and update them. Although perhaps it
> would be good anyway t
Hi,
If the only thing you are interested in is asking for the amount of points
within a given radius, I would strongly advise not to use a database, but
quickly implement a dedicated data structure for that. That can usually be
an order of magnitude faster than a general purpose database.
E.g. co
On Fri 14.12.2012 19:39:04 Ander Pijoan wrote:
> Hi all,
>
> I am starting to develope an application that needs of a spatial database.
>
> I'm almost sure that I will use PostGIS because it works great but taking
> into account that I will ONLY make querys to get a number of points near to
> a
Hi all,
I am starting to develope an application that needs of a spatial database.
I'm almost sure that I will use PostGIS because it works great but taking
into account that I will ONLY make querys to get a number of points near to
another point and that what I most need is the answer to be fast
On Fri, Dec 14, 2012 at 9:32 AM, Alex Barth wrote:
> Ian Dees - how hard is it to update the style on the server you set up? We
> should probably reexport Mapnik XML from Tilemill as stuff gets fixed and
> update the server from time to time. This way we can continue to look here
> for spot check
Ian Dees - how hard is it to update the style on the server you set up? We
should probably reexport Mapnik XML from Tilemill as stuff gets fixed and
update the server from time to time. This way we can continue to look here for
spot checking:
http://bl.ocks.org/d/4271706/#15.00/37.7698/-122.418
2012/11/11 Simon Legner :
> Hi all,
>
> I tweaked Zverik's WHODIDIT script to speed-up the queries. These
> performance improvements are mainly due to the usage of a spatial index in
> the database.
>
> I deployed minutely-synced version on the dev server:
>http://simon04.dev.openstreetmap.org/
Frederik Ramm wrote:
> Hi,
>
> On 13.12.2012 19:04, Dominik Perpeet wrote:
>> I would be willing to refactor the code into C++ classes.
>> Once the connection variables are a bit more concentrated, it wouldn't
>> affect fork() and other threading systems could be implemented.
>
> osm2pgsql is a ver
14 matches
Mail list logo