[SAC] [OSGeo] #1972: Remove "planet" prefix from OSM data in PostGIS

[OSGeo]

#1972: Remove "planet" prefix from OSM data in PostGIS
-------------------------+-------------------------------------------------
 Reporter:  bufferclip   |      Owner:  sac@…
     Type:  task         |     Status:  new
 Priority:  minor        |  Milestone:  Unplanned
Component:  Systems      |   Keywords:  openstreetmap, osm, postgis,
  Admin                  |  postgres
-------------------------+-------------------------------------------------
 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 [http://www.linuxcertif.com/man/1/osm2pgsql/ osm2pgsql]
 . This is the corresponding
 [https://github.com/OSGeo/OSGeoLive/blob/aaec0fddf95fd5ebf6b1af19dad41719075e9b15/bin/load_postgis.sh#L103-L106
 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", ...

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1972>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.