<div dir="ltr">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.<div><br></div><div>thanks </div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Jul 12, 2015 at 5:30 PM, <span dir="ltr"><<a href="mailto:dev-request@openstreetmap.org" target="_blank">dev-request@openstreetmap.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send dev mailing list submissions to<br>
<a href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.openstreetmap.org/listinfo/dev" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:dev-request@openstreetmap.org">dev-request@openstreetmap.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:dev-owner@openstreetmap.org">dev-owner@openstreetmap.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of dev digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Simplified osm2pgsql database dump available (Paul Norman)<br>
2. Re: Simplified osm2pgsql database dump available<br>
(Matthijs Melissen)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sat, 11 Jul 2015 21:02:53 -0700<br>
From: Paul Norman <<a href="mailto:penorman@mac.com">penorman@mac.com</a>><br>
To: dev Openstreetmap <<a href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>><br>
Subject: [OSM-dev] Simplified osm2pgsql database dump available<br>
Message-ID: <<a href="mailto:55A1E6ED.90205@mac.com">55A1E6ED.90205@mac.com</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
To help with some OpenStreetMap carto development work, I've created a<br>
dump of the rendering tables with certain features removed, for testing<br>
at low zoom. This allows someone to load the database if using a machine<br>
incapable of importing the planet, and the dropped features cut the<br>
database size in half.<br>
<br>
It is available at <a href="http://tile.paulnorman.ca/planet-lz-150202.dump" rel="noreferrer" target="_blank">http://tile.paulnorman.ca/planet-lz-150202.dump</a>, but<br>
before downloading please read the notes below<br>
<br>
- Buildings without a name, amenity, shop, or similar tag have been removed<br>
<br>
- Residential roads have been removed<br>
<br>
- It comes with no indexes. To create the indexes, do<br>
<br>
CREATE INDEX ON planet_osm_point USING GIST (way) WITH (fillfactor = 100);<br>
CREATE INDEX ON planet_osm_line USING GIST (way) WITH (fillfactor = 100);<br>
CREATE INDEX ON planet_osm_polygon USING GIST (way) WITH (fillfactor = 100);<br>
CREATE INDEX ON planet_osm_roads USING GIST (way) WITH (fillfactor = 100);<br>
<br>
- Don't try to download this from your browser, as it is 26GB<br>
<br>
- I *will* be removing this dump from my server at some point.<br>
<br>
- The dump has been generated with pg_dump from PostgreSQL 9.4 in the<br>
pg_dump "custom" format. To get 9.4 on Debian or Ubuntu based systems,<br>
see <a href="https://wiki.postgresql.org/wiki/Apt" rel="noreferrer" target="_blank">https://wiki.postgresql.org/wiki/Apt</a><br>
<br>
- The dump is based on the planet dump from 150202 and is not current<br>
<br>
- The database size is about 50GB after loading<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.openstreetmap.org/pipermail/dev/attachments/20150711/c277a9c7/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.openstreetmap.org/pipermail/dev/attachments/20150711/c277a9c7/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sun, 12 Jul 2015 10:10:03 +0200<br>
From: Matthijs Melissen <<a href="mailto:info@matthijsmelissen.nl">info@matthijsmelissen.nl</a>><br>
To: Paul Norman <<a href="mailto:penorman@mac.com">penorman@mac.com</a>><br>
Cc: dev Openstreetmap <<a href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a>><br>
Subject: Re: [OSM-dev] Simplified osm2pgsql database dump available<br>
Message-ID:<br>
<CAD940MoKbDE3KV_-maKEkBbgCyuRvAWQe=<a href="mailto:2nD_o5oDaJB5HGMQ@mail.gmail.com">2nD_o5oDaJB5HGMQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset=UTF-8<br>
<br>
On 12 July 2015 at 06:02, Paul Norman <<a href="mailto:penorman@mac.com">penorman@mac.com</a>> wrote:<br>
> To help with some OpenStreetMap carto development work, I've created a dump<br>
> of the rendering tables with certain features removed, for testing at low<br>
> zoom.<br>
<br>
Very useful, thanks a lot!<br>
<br>
-- Matthijs<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
dev mailing list<br>
<a href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/dev" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br>
<br>
<br>
------------------------------<br>
<br>
End of dev Digest, Vol 124, Issue 6<br>
***********************************<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Er. Sukhjit Singh Sehra<br>Assistant Professor<br>Dept of Computer Science Engg.<br>Guru Nanak Dev Engineering College, Ludhiana, Punjab <br>Mobile No:- 09855959200<br>*In your free time kindly visit Sikh-relics.com - A Gallery of Blessed Relics of Sikh Guru Sahib </div>
</div></div>