Custom Query (1118 matches)

Cameron,

It looks like you guys never had much on the overview page anyway except for the version number.

​https://github.com/OSGeo/OSGeoLive-doc/blob/master/en/overview/postgis_overview.rst

So given that I would just update the version to 2.2.1 .

The quick starter guide on the other hand needs some work.

​https://github.com/OSGeo/OSGeoLive-doc/blob/master/en/quickstart/postgis_quickstart.rst

1) It is using ST_Distance_Sphere which got deprecated in 2.2.0 and will be removed in the future. That should be changed to ST_DistanceSphere. ​http://postgis.net/docs/ST_DistanceSphere.html

2) The QGIS images are a bit out of date. For example I think PostGIS Manager got renamed to DB Manager and got more encompassing to satisfy SpatialIte too.

I'm a bit strapped for time this month, but if you are not in too much of a rush, I could spruce up the quick start next month and send a pull request.

Thanks, Regina

From: Cameron Shorter cameron.shorter@… Sent: Thursday, March 03, 2016 6:12 AM To: Regina Obe Subject: Re: Any features added to postgis between versions 2.1.3 and 2.2.1 worth mentioning in the Project Overview?

Hey guys, Any chance one of you could take a crack at fixing up the Project Overview (or tell me there is nothing to do).

Cheers, Cameron

On 1/03/2016 8:39 am, Cameron Shorter wrote:

Hi Regina, Brian, Barry, Sounds like a doc update is in order? Would one of you mind updating the Project Overview, create a git pull request, and then I'll review.

Are there any updates required for the Quickstart?

Warm regards, Cameron

On 29/02/2016 11:54 pm, Regina Obe wrote:

Key features in PostGIS 2.2 are

1) KNN now supported for geography and 3D geometries. Prior versions only supported for 2D geometry. 2) KNN true-distance functionality for PostgreSQL 9.5. This is for all KNN including the new 3D and geography. Does OSGeo live have 9.5? What this means is the distance returned by the spatial index KNN operators is the actual distance and not the bounding box or bounding box centroid distance Of prior versions.

3) Ability to build raster overviews in the database without having to rely on raster2pgsql. Means you can have overviews without reloading your raster data. 4) Tiger geocoder upgraded to support Tiger 2015 5) New extensions address_standardizer (not sure if you have postgis_sfcgal packaged, but that became an extension in PostGIS 2.2)

6) Lots of other neat functions noted in the release notes

​http://postgis.net/2015/10/07/postgis-2.2.0/

Open QGIS (from command line if you want to see error logs) Follow first 2 quickstart steps:

1. Launch QGIS from Geospatial ‣ Desktop GIS ‣ QGIS and select Project ‣ Open from the menu bar.

Open a QGIS project

2. Choose QGIS-NaturalEarth-Example.qgs and press Open.

QGIS crashed. (I assume it ran out of memory). Tried again but opening the other example dataset: Itisca, and the datset did open without crashing.

I was running using VirtualBox on a Mac, with 1024 Gig RAM allocated, booting from an ISO.

When Cesium opens up in the "Hello World" demo, the default map, Bing Arial Map, is not visible. Selecting of the Marble, Natural Earth, ESRI World Street maps do show a map. Good.

I assume that the base map from Bing not accessible. I haven't tested all maps. Note, this has been tested with a connection to the internet.

Suggest the default install, and quickstart be amended to access maps which are available.