#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.