Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 22361

PostGIS is an extension for the PostgreSQL object-relational database that adds support for geographic objects.

4 votes
2 answers
7k views

ST_GeomFromText not found

Then I installed PostGIS. Then I created database named geodb. In it I created column with type polygon and several others like id. …
Dmitry Bubnenkov's user avatar
1 vote
1 answer
599 views

Slow execution of request for searching nearest street to GPS point

PostGIS 2.2 PostgreSQL 9.6 …
Dmitry Bubnenkov's user avatar
0 votes
0 answers
137 views

Updating OpenStreetMap in PostgreSQL?

I can't use imposm tool, because it is not compatible with Nominatim. So it seems that I can use only osm2pgsql. But is there any ready to use toolchain, that allows to update OSM in an easy way. I …
Dmitry Bubnenkov's user avatar
1 vote
0 answers
59 views

Can I work directly with spatial (PostGIS/SDE) DB with SQL queries? [closed]

I have heard that PostGIS/SDE add some tables and if I will do it without touching PostGIS/SDE tables (that possible store some of indexes for my data) I will damage my data. …
Dmitry Bubnenkov's user avatar
2 votes
1 answer
967 views

How to load OpenStreatMap dump to PostgreSQL?

I run it with follow command: imposm3 run -config /apps/imposm/config.json Config is next: { "cachedir": "/home/osmdata/diff/", "connection": "postgis://postgres:123456@localhost:5432/geodb? …
Dmitry Bubnenkov's user avatar
4 votes
1 answer
728 views

ST_DISTANCE return not same distance as QGIS

PostGIS 2.2 …
Dmitry Bubnenkov's user avatar