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, <[email protected]> wrote: > Send dev mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: dev Openstreetmap <[email protected]> > Subject: [OSM-dev] Simplified osm2pgsql database dump available > Message-ID: <[email protected]> > 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 <[email protected]> > To: Paul Norman <[email protected]> > Cc: dev Openstreetmap <[email protected]> > Subject: Re: [OSM-dev] Simplified osm2pgsql database dump available > Message-ID: > <CAD940MoKbDE3KV_-maKEkBbgCyuRvAWQe= > [email protected]> > Content-Type: text/plain; charset=UTF-8 > > On 12 July 2015 at 06:02, Paul Norman <[email protected]> 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 > [email protected] > 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
_______________________________________________ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
