Opened 19 months ago

Last modified 19 months ago

#1972 new task

Remove "planet" prefix from OSM data in PostGIS

Reported by: bufferclip Owned by: live-demo@…
Priority: minor Milestone: Unplanned
Component: OSGeoLive Keywords: openstreetmap, osm, postgis, postgres
Cc:

Description

The tables of the OSM data in PostGIS are called like: "planet_osm_line", "planet_osm_point" ...

I find this very confusing, because the tables only contain the data for the feature city. (and obviously not of the planet)

I suggest to rename these tables. This can easily be done by using the "--prefix" flag from osm2pgsql . This is the corresponding text file in OSGeo-live.

I see two possibilities for renaming:

  • a static prefix like "feature_city_line", "feature_city_point", ...

OR

  • a dynamic prefix like "bonn_line", "bonn_point", ...

Change history (1)

comment:1 Changed 19 months ago by bufferclip

Component: Systems AdminLiveDVD
Owner: changed from sac@… to live-demo@…
Note: See TracTickets for help on using tickets.