My last question here was " Install webpage Admin in Ubuntu GIS (Server) " but i´m trying to do something new while i´m waiting for the possible answers:

  • I have Windows 10 in PC (With QGIS 2.18.7 and PostgreSQL 4v1 installed) and i installed Virtual Box to run UBUNTU Desktop 17.04 as you can see:

enter image description here

  • My question is: What is the best spatial data server I can use in ubuntu to allow connection to Postgresql?

NB: With a friendly work environment.

I have read it:

a) https://geoind.wordpress.com/2014/02/17/r-e-rstudio-no-ubuntu/

b) http://www.oslandia.com/full-spatial-database-power-in-2-lines-en.html

c) https://wiki.osgeo.org/wiki/Wms

d) https://help.ubuntu.com/community/UbuntuGIS

closed as primarily opinion-based by underdark May 29 '17 at 17:15

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.


Your question "What is the best spatial data server I can use in ubuntu to allow connection to Postgresql?" is not really specific enough.

Do you mean, what is the best way to get data out of Postgresql in terms of open spatial standards? The answer to that is GeoServer or Mapserver.

If you want to just get it on a simple map? Use QGIS.

If you mean from a purely server-side framework? Try Psocopg or Psocopg-PostGIS in a Python script, and if you want that in an API that you write, perhaps use Flask.

But your actual question suggests that you don't know exactly what you want to do, so, go get experimenting with all these links I've sent!

Not the answer you're looking for? Browse other questions tagged or ask your own question.