Jendrusk
  • Member for 7 years, 8 months
  • Last seen more than 1 year ago
Openstreetmap [OSM] not readable
9 votes

OSM Tiles are static png images. Qgis is rescaling them to achieve scale you've set. To get sharp images you have to match scale in qgis with a scale of tiles or render map locally using for example ...

View answer
Get different SRIDs of geometry column in a table
Accepted answer
8 votes

If column in your table has explicitly defined geometry type and srid, like: CREATE TABLE geom_table (id serial, geom geometry(point,3857); Your database will not allow to place there any other ...

View answer
How to QUERY (SQL) in QGIS DB Manager?
Accepted answer
7 votes

When you're using capital letters in names of tables or columns you need to place it in " ". Postgres is case sensitive

View answer
Extracting Cities, Towns and Villages boundary coordinates
7 votes

To extract selective data from OSM you can use Overpass, you could also check download server of Geofabrik EDIT after some comments: In OSM boundaries of cities and villages are tagged with boundary=...

View answer
Reverse geocode with PostGIS use OpenStreetMap Database
7 votes

As I understand this function will give you all points from planet_osm_point ordered by distance from your point. If you need one answer you have to use 'limit 1'. Not every nearest point in table ...

View answer
Error importing shapefile into postgreSQL using shp2psql?
Accepted answer
7 votes

Are you sure you checked whole instruction including creation of new database and spatialy enabled it? You can't import to any of templates, so you have to create new database, connect to it and ...

View answer
Adding another spatial DataBase in PostGIS?
6 votes

It's not a case of second (third ...) spatial database but as your error said your template database is in use. Following documentation: The principal limitation is that no other sessions can be ...

View answer
Geoserver SLD style PointSymbolizer ExternalGraphic issue
Accepted answer
5 votes

Check please if your style isn't in some workspace - workspaces has their own store, so images for styles in workspace should be placed in (geoserver_data_dir)/workspaces/(workspace_name)/styles not ...

View answer
Split lines at intersection points
Accepted answer
5 votes

There is few resolutions of this issue, maybe there are few better ones but this two should do also: 'By hand' (in steps) Cut every line with another line which intersects it Create table road_1 ...

View answer
Hex grid value interpolation in POSTGIS
Accepted answer
5 votes

I don't know what kind of interpolation you're talking about but if average of all neighbours will be good value this could be the solution: create table hex_grid_data_av as ( select gid, ...

View answer
How to create more networking osm
Accepted answer
5 votes

I had the same problem few weeks ago and solved it by manually drawing lines from nearest node. I don't know if it's one and only resolution, it's quite hard and tricky but its working quite good. ...

View answer
How to join data in postgis tables to form layer with subset of attributes
Accepted answer
4 votes

Try to add to your QGIS DB Manager plugin - the SQL window (under the Database menu) allows you to write any query to your database (including joins). Adding layers from sql window is little tricky ...

View answer
pgr_dijkstra function with geometry column in result
4 votes

Join to table ways is as for now only solution (BTW recommended in all official documentation and workshops)

View answer
Where is my Geowebcache tile directory?
4 votes

By default the tiles are in data_dir/gwc, if not maybe try fo find file geowebcache.xml - it should be placed in folder with tiles

View answer
Switch line direction for PostGIS-lines in QGIS or Pgadmin
Accepted answer
4 votes

If postgis resolution is also good maybe you're looking for ST_Reverse function

View answer
Qgis composer attribute table
Accepted answer
3 votes

You're getting more than one line because other lines also in intersects this atlas feature. To do this you have to use filtering by expression (button with epsilon). There is few variables to get ...

View answer
How to download a big area OSM by JOSM editor
Accepted answer
3 votes

OSM API doesn't allow to download areas greater than few sq km. Try to use downloading using overpassAPI - it's in File menu, but this also doesn't allow you to download all planet. Keep in mind that ...

View answer
Is there another way to put raster into PostGIS?
3 votes

It's a case of space in your path... try to wrap it into " " or place file in some path without spaces in names

View answer
Dissolve adjacent parts of multipolygon into a single Polygon
Accepted answer
3 votes

It's a kind of hack but you can use ST_Buffer(geom,0)... Proof of concept: select 1 as id, ST_astext(ST_Buffer(ST_Geomfromtext('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 0,1 1,2 1,2 0,1 0)))'),0)) ...

View answer
Converting set of Shapefiles to OpenStreetMap (OSM) file?
3 votes

You can do it with JOSM + OpenData plugin. With this extension JOSM can open SHP (4326) than you can save it as OSM file

View answer
Building a graph from OSM?
Accepted answer
3 votes

If you're a very beginner you should try this tutorial of osm2po by @Underdark Osm2po will give you ready to use graph from osm data as sql script file, all you have to do is load it into database ...

View answer
Generating own vector tiles on OpenStreetMap with filtered layers
Accepted answer
2 votes

If you just need to disable some layers you can do this in yaml file (https://github.com/openmaptiles/openmaptiles/blob/master/openmaptiles.yaml). If you need to change a content of a layer - ...

View answer
Can I import Network Dataset in PostgreSQL through pgRouting or Polyline Shapefile?
Accepted answer
2 votes

It all depends of what you need to achieve... but If you need only data for routing to be done in PostgreSQL (so assuming postGIS and PGRouting) you'll need a topology (network). You can use OSM2PO ...

View answer
pgr_drivingDistance How to split edge if max distance is reached halfway through the edge (PGROUTING)
2 votes

I'm sure there is other, maybe simpler way, but I did it as follows: created new table (t1) using driving distance created another table as select from t1 with all edges which have cost < defined (...

View answer
Does OSM road segment has GPS information about the Intersecting roads in them?
2 votes

I think you didn't understood linked answers... RAW OSM data doesn't contain strict information about crossings (intersections)... one road could be splitted in many places and for many reasons (4 ...

View answer
How to convert x y coordinates to OSM using QGIS?
2 votes

If you have your layer in qgis you can save it as .shp file using epsg:4326, then you can open it with JOSM (you need OpenData plugin). Take a look at formats provided by OpenData - there is few more ...

View answer
How to get OSM data for different areas at once?
2 votes

In overpass-turbo you can union search areas, like this (pharmacies in Bielsko-Biala, Żywiec and Pszczyna)

View answer
Transform EPSG 25830 to EPSG 900913
2 votes

Or in one step, following docummentation: root@mapa:/var/log# shp2pgsql RELEASE: 2.2.1 (r14555) USAGE: shp2pgsql [<options>] <shapefile> [[<schema>.]<table>] OPTIONS: -s [...

View answer
PostGIS or QGIS: Convert unsorted points to a single line by connecting each 2 closest points
Accepted answer
2 votes

This problem is quite complex... or it's a compilation of several problems... I can see at least two Which of points is first and which is last What is correct order of points As a resolution of ...

View answer
Osmosis plugin map-writer doesn't exist
Accepted answer
2 votes

I've found an answer... Following another documentation i've placed plugin file in sub-folder /plugins in current folder - it works.

View answer