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

[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