Tag Info

New answers tagged

3

Fixed. The problem was is no primary key. In pgAdmin do this request. ALTER TABLE tableName ADD PRIMARY KEY (id); Example for planet_osm_line table and setting osm_id column ,as primary key : ALTER TABLE planet_osm_line ADD PRIMARY KEY (osm_id); untill osm_id is unique.


2

I think this is a primary key issue - does your table have one and is it recognized when you view the table through PGAdmin? I had this same problem, but re-loaded the layer with a primary key field called ID (arbitrary) and all my edit tools are now active on the toolbar. EDIT Using SQL you can add an OID column of 'serial' data type and create a ...


1

I have resolved this issue. Go through this link and follow all the instructions posted there. Problem Resolved


0

I think you are hitting https://github.com/openstreetmap/osm2pgsql/issues/90 (i.e. this is a known issue on EC2). A possible reason is that your cache size is way too high. Based on the osm2pgsql instructions, you should be using 24000. Not specific to your question, but if you intend to render off this, remember that EC2 isn't a great database solution: ...


3

The purpose of a tile server is to deliver tiles (raster images). If you want to geocode then use/install a geocoder, for example Nominatim. If you want to access raw data then use/install a service offering raw data, for example Overpass API.


1

I have resolved this error: The problem is still your pg_hba.conf file (/etc/postgresql/9.3/main/pg_hba.conf). This line: local all postgres peer Should be local all postgres trust After altering this file, don't forget to restart your PostgreSQL server. If you're ...


0

It seems to me, that you can't do it with osm2pgsql. You may: Use osmosis http://wiki.openstreetmap.org/wiki/Osmosis/Detailed_Usage_0.44 but it uses different db schema, and there is no such thing as separate import of changesets into sole table. Do it yourself. It's actually quite easy to use SAX xml parser to get changesets and their tags. Just don't ...


0

You need one more step which is adding the values to your style file. For details: http://wiki.openstreetmap.org/wiki/Osm2pgsql#Import_style Default Style file: https://raw.githubusercontent.com/openstreetmap/osm2pgsql/master/default.style



Top 50 recent answers are included