Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
R
R
remo0012020-10-12 02:16:20
PostgreSQL
remo001, 2020-10-12 02:16:20

Openstreetmap how to get a list of countries, regions, localities?

There is a database in postgresql, which is formed using osm2pgsql. It is necessary to get a list of countries, a list of regions of a particular country, and a list of settlements in this region. How can this be done with SQL queries?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
F
freeExec, 2020-10-12
@freeExec

https://postgis.net/docs/ST_Within.html

Similar questions
G
GrimJack2017-09-05 13:04:04
Why doesn't carbon parse the timestamp correctly? 2Reply
S
Sanders Rocket2020-03-17 05:41:55
VK API Python subscriptions? 2Reply
B
Bogdan2017-08-31 16:59:37
Autoincrement in INSERT INTO ... ON CONFLICT? 1Reply
L
Leo_Eldorado2020-02-03 13:10:38
Why is an IN query in PostgreSQL DBMS much slower than a similar OR query? 2Reply
B
Bazis9112020-02-08 22:38:07
Installed on Windows 10 PostgeSQL 12. How to log in to the server in psql (SQL Shell)? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question