[OSM-dev] dev Digest, Vol 124, Issue 6

sukhjit sehra sukhjitsehra at gmail.com
Mon Jul 13 09:36:48 UTC 2015


I am working on OSM Data, please suggest that how can i find the center of
any city in OSM data. If any mathematical model used then please suggest.

thanks

On Sun, Jul 12, 2015 at 5:30 PM, <dev-request at openstreetmap.org> wrote:

> Send dev mailing list submissions to
>         dev at openstreetmap.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.openstreetmap.org/listinfo/dev
> or, via email, send a message with subject or body 'help' to
>         dev-request at openstreetmap.org
>
> You can reach the person managing the list at
>         dev-owner at openstreetmap.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of dev digest..."
>
>
> Today's Topics:
>
>    1. Simplified osm2pgsql database dump available (Paul Norman)
>    2. Re: Simplified osm2pgsql database dump available
>       (Matthijs Melissen)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 11 Jul 2015 21:02:53 -0700
> From: Paul Norman <penorman at mac.com>
> To: dev Openstreetmap <dev at openstreetmap.org>
> Subject: [OSM-dev] Simplified osm2pgsql database dump available
> Message-ID: <55A1E6ED.90205 at mac.com>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> To help with some OpenStreetMap carto development work, I've created a
> dump of the rendering tables with certain features removed, for testing
> at low zoom. This allows someone to load the database if using a machine
> incapable of importing the planet, and the dropped features cut the
> database size in half.
>
> It is available at http://tile.paulnorman.ca/planet-lz-150202.dump, but
> before downloading please read the notes below
>
> - Buildings without a name, amenity, shop, or similar tag have been removed
>
> - Residential roads have been removed
>
> - It comes with no indexes. To create the indexes, do
>
> CREATE INDEX ON planet_osm_point USING GIST (way) WITH (fillfactor = 100);
> CREATE INDEX ON planet_osm_line USING GIST (way) WITH (fillfactor = 100);
> CREATE INDEX ON planet_osm_polygon USING GIST (way) WITH (fillfactor =
> 100);
> CREATE INDEX ON planet_osm_roads USING GIST (way) WITH (fillfactor = 100);
>
> - Don't try to download this from your browser, as it is 26GB
>
> - I *will* be removing this dump from my server at some point.
>
> - The dump has been generated with pg_dump from PostgreSQL 9.4 in the
> pg_dump "custom" format. To get 9.4 on Debian or Ubuntu based systems,
> see https://wiki.postgresql.org/wiki/Apt
>
> - The dump is based on the planet dump from 150202 and is not current
>
> - The database size is about 50GB after loading
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.openstreetmap.org/pipermail/dev/attachments/20150711/c277a9c7/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Sun, 12 Jul 2015 10:10:03 +0200
> From: Matthijs Melissen <info at matthijsmelissen.nl>
> To: Paul Norman <penorman at mac.com>
> Cc: dev Openstreetmap <dev at openstreetmap.org>
> Subject: Re: [OSM-dev] Simplified osm2pgsql database dump available
> Message-ID:
>         <CAD940MoKbDE3KV_-maKEkBbgCyuRvAWQe=
> 2nD_o5oDaJB5HGMQ at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> On 12 July 2015 at 06:02, Paul Norman <penorman at mac.com> wrote:
> > To help with some OpenStreetMap carto development work, I've created a
> dump
> > of the rendering tables with certain features removed, for testing at low
> > zoom.
>
> Very useful, thanks a lot!
>
> -- Matthijs
>
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/dev
>
>
> ------------------------------
>
> End of dev Digest, Vol 124, Issue 6
> ***********************************
>



-- 
Er. Sukhjit Singh Sehra
Assistant Professor
Dept of Computer Science Engg.
Guru Nanak Dev Engineering College, Ludhiana, Punjab
Mobile No:- 09855959200
*In your free time kindly visit Sikh-relics.com  -  A Gallery of Blessed
Relics of Sikh Guru Sahib
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20150713/9aa7e52f/attachment.html>


More information about the dev mailing list