[OSM-dev] Can we do Optimisation of data to be imported in database?

2011-06-23 Thread Parveen Arora
Hello Everyone,
As we can import the OSM data file into the database using osm2pgsql,
I want to know that can we optimise that data before importing.
Means If I need only the Information of National Highways, what is the
need of storing all the data in the database.
So can I optimise the data before importing to the database.

Please let know how can I do this?

Thank You.

--
Parveen Arora
www.parveenarora.in
E-Mail: o...@parveenarora.in

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] Can we do Optimisation of data to be imported in database?

2011-06-23 Thread Frederik Ramm

Hi,

On 06/23/2011 01:19 PM, Parveen Arora wrote:

As we can import the OSM data file into the database using osm2pgsql,
I want to know that can we optimise that data before importing.
Means If I need only the Information of National Highways, what is the
need of storing all the data in the database.
So can I optimise the data before importing to the database.


Sure, you can run it through Osmosis with the --tag-filter option to 
filter out only what you are interested in. You can also modify 
osm2pgsql's default.style file to import only some tags (but it will not 
allow you to say I want only highway=motorway and highway=trunk).


This only works if you are not planning to do incremental updates however.

Bye
Frederik

___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev


Re: [OSM-dev] Can we do Optimisation of data to be imported in database?

2011-06-23 Thread Oliver Tonnhofer
Hi,

On 23.06.2011, at 13:19, Parveen Arora wrote:
 Hello Everyone,
 As we can import the OSM data file into the database using osm2pgsql,
 I want to know that can we optimise that data before importing.
 Means If I need only the Information of National Highways, what is the
 need of storing all the data in the database.
 So can I optimise the data before importing to the database.

you should have a look at imposm[0]. You can define custom mappings that only 
import the data you need (highways in your case). It can also create tables 
with generalized/simplified geometries.

[0] http://imposm.org


Regards,
Oliver

-- 
Oliver Tonnhofer| Omniscale GmbH  Co KG| http://omniscale.de
http://mapproxy.org | https://bitbucket.org/olt | @oltonn





___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev