Martin Spott wrote:
> I've been using "osm2pgsql" for years for importing The Planet Dump
> into PostGIS and so far I'm quite satisfied. After the bare import I'm
> using a custom script to separate the various road types into distinct
> tables/layers, something like:
>
> landcover=> SELECT osm_id, access, admin_level, z_order, way_area,
> wkb_geometry
> landcover-> INTO osm_motorway
> landcover-> FROM planet_osm_line
> landcover-> WHERE highway LIKE 'motorway%'
> landcover-> AND ST_GeometryType(wkb_geometry) LIKE 'ST_LineString';
>
>
> That way I don't have to query the entire "planet_osm_line" if the user
> selects a large scale which doesn't include all the residential roads.
> I'd certainly extend this to "SELECT * [...]" if required ;-)
Done - works,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Flightgear-devel mailing list
Flightgear-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/flightgear-devel
