I am new to the field of GIS and am trying to view source tags in OSM. I have downloaded the shapefiles from http://downloads.cloudmade.com and have loaded them into Postgres. When I view the data, I am unable to see any tagging data. Should I be following a different process or using shapefiles at all?
[GIS] How to load OSM data into PostGIS preserving all Tags
openstreetmappostgresqlshapefile
Related Solutions
You cannot combine filter options (condition A && condition B).
What you can do is filter in two different steps - first keep only ways satisfying the source condition and then filter the first step's result using the attribution condition.
E.g.:
./bin/osmosis --rx file=ireland.osm --tf accept-ways source=* --un --wx step1.osm
./bin/osmosis --rx file=step1.osm --tf accept-ways attribution=* --un --wx result.osm
Use the spatialite_osm_raw tool for importing OSM files (raw format tables, strictly corresponding to XML
"Also this tool is intended to parse a whole OSM dataset, thus creating the corresponding SpatiaLite's DB-file; but in this case the generated DB-file will adopt a completely different data layout than in the previous scenario. In this case will be adopted a data layout closely mapping OSM objects, their data attributes and their mutual relationships; fully preserving the original OSM data model, and carefully avoiding to introduce any unpleasant information suppression. The intended goal of this tool is not at all to produce a DB-file usable by GIS applications: it's instead the one to get a DB-file you can use in order to gather statistical infos, to support some post-processing task and so on."
Example:
$ spatialite_osm_raw -o my_country.osm.pbf -d my_country.sqlite
SQLite version: 3.7.11
SpatiaLite version: 3.1.0
inserted 3047972 nodes
166634 tags
inserted 233481 ways
423462 tags
3461321 node-refs
inserted 6068 relations
14815 tags
56617 refs
$
You can view the imported data with spatlite_gui
https://www.gaia-gis.it/fossil/spatialite-tools/index
Online Examples:
https://www.gaia-gis.it/fossil/spatialite-tools/wiki?name=spatialite_osm_raw
Best Answer
Download the OSM files (in .osm format) and import using osm2pgsql.
When using osm2pgsql, there's a file called
default.stylethat allows you to control which OSM feature goes into which postgresql table, e.g.:means that