Raffaele Morelli | 23 Jul 11:49 2014
Picon

can't restore dump in postgis-2.1.3

Hi,

I upgraded my postgres/postgis installations but loading the dump from the production server results in tons of errors as these:

pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/postgis-2.0": No such file or directory

pg_restore: [archiver (db)] could not execute query: ERROR:  could not access file "$libdir/postgis-1.5": No such file or directory

I am running debian (testing/jessie) with postgis-2.1.3 and postgresql-9.3

$ pg_config --libdir
/usr/lib/x86_64-linux-gnu


Any suggestions?
Regards
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
j.rolland | 23 Jul 10:29 2014
Picon

A PostGIS 3D Viewer

Hello PostGIS Community,

Have a look to my blog at the following address  
http://ageoguy.blogspot.fr/2014/07/postgis-3d-viewer.html
<http://ageoguy.blogspot.fr/2014/07/postgis-3d-viewer.html>   
This tutotrial which present a tool to view 3D geometries from a
PostgreSQL/PostGIS database.

<http://postgis.17.x6.nabble.com/file/n5006710/pg3DViewer_title_small.png> 

<http://postgis.17.x6.nabble.com/file/n5006710/CAPTURE_001.jpg> 

Best regards,
Jérôme

--
View this message in context: http://postgis.17.x6.nabble.com/A-PostGIS-3D-Viewer-tp5006710.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Richard Greenwood | 23 Jul 03:17 2014
Picon

topology, joining attributes

I have a table of simple polygons named work.aliquot with a primary key named ogc_fid and several columns of attribute data. I created a topology and added a topogeometry column and then:

UPDATE aliquot SET topogeom = toTopoGeom(wkb_geometry, 'aliquot_topology', 1);

The various fields and tables all appear to have been populated correctly.

Now I need to join the attributes from the work.aliquot table to aliquot_topology.face but I'm stuck. I was guessing that aliquot_topology.relation would be the route but after some experimenting that seems not to be the case, or else I'm not getting it. Do I have to do a spatial join to get my attributes from the source table into my new topology?

Thanks,
Rich

--
Richard W. Greenwood, PLS
www.greenwoodmap.com
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Sparr | 18 Jul 16:20 2014
Picon

Using PostGIS for partial intersection/union of many polygons

On Wed, Jul 31, 2013 at 5:54 AM, Rémi Cura <remi.cura <at> gmail.com> wrote:
> Hey,
> my 2 cents (sorry I can't access your example)
>
> Depending on what you want, you may have interest in sampling :
> you create a grid of point (there is a function) or a grid of polygon
> square.
> Then you compute for each point(square) the number of polygon it is in (on
> simple sql query invovling count(*) OVER and st_intersects)
> Then when you want space where there are between N and M polygons
> overlaying, you just query the table with point/square with a WHERE count >N
> and count <M.
>
> It should run very fast, even fater if you put btree index on the count
> result.
> I don't know what you want, but if this is some kind of indicator, sampling
> may be legitimate.
> If you want crisp boundary, it may be used to fasten computing (doing the
> precise computing only on polygons on border)

I would prefer not to resort to sampling. Some of the boundaries are
drawn arbitrarily precisely, and I'd like to preserve that precision.

http://regionaldifferences.com/results.html?region=New%20England&lat=42&lon=-73&zoom=6
(now with 708 polygons)
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Antti J. Lind | 18 Jul 12:13 2014
Picon

GeomFromText

Hello again,

replacement for functions x & y found (st_x & st_y) and now one missing 
more...
GeomFromText() has been removed. Which function is replacing it?

My sql is
SELECT GeomFromText('POINT(%s %s)',4326) AS p

--
Antti J. Lind

-------- Alkuperäinen viesti --------
Aihe: [postgis-users] Where are functions x & y?
Päiväys: 2014-07-17 15:46
Lähettäjä: "Antti J. Lind" <anttij.lind <at> birdlife.fi>
Vastaanottaja: postgis-users <at> lists.osgeo.org
Vastaus osoitteeseen: PostGIS Users Discussion 
<postgis-users <at> lists.osgeo.org>

Hi,

We have previously used postgis 1.3.6 with postgres 8.4.1.
I installed postgres 9.3.4 and postgis 2.1.3

When testing our app, I noticed that functions x(geometry) and 
y(geometry) aren't there anymore?

--
Antti J. Lind

_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
David Haynes | 17 Jul 16:12 2014
Picon

Adding Raster Extent Constraint

Hello,

I am having a problem adding in the raster extent constraint on some of my rasters. My project uses world extent datasets. The problem that we have noticed is that many of these rasters have data that extends further than the defined world. Therefore if a dataset's extent may end up being -180.00001 90.000002 which doesn't exist. We have been trying to account for this by removing cells at various extents, but we are running into a problem with the MODIS data in a sinusoidal projection.

When trying to run AddRasterConstraints(gis_rasters'::name, 'modis_igbp'::name, 'rast'::name)
We essentially fail, because we can not add the extent.

I was looking at an old ticket
http://trac.osgeo.org/postgis/ticket/2050 and can get a return on the convexhull of the raster.
SELECT ST_AsText(ST_union(st_convexhull(rast))) FROM gis_rasters.modis_igbp_2012

However, this function returns false
SELECT _add_raster_constraint_extent('gis_rasters'::name, 'modis_igbp'::name, 'rast'::name)

How necessary is the extent constraint??
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Antti J. Lind | 17 Jul 14:46 2014
Picon

Where are functions x & y?

Hi,

We have previously used postgis 1.3.6 with postgres 8.4.1.
I installed postgres 9.3.4 and postgis 2.1.3

When testing our app, I noticed that functions x(geometry) and 
y(geometry) aren't there anymore?

--
Antti J. Lind
Stephen Mather | 17 Jul 04:43 2014

Re: A question on PostGIS Cookbook

No worries Cyril,

Formality always appreciated.
Try this for me-- try the "WinnieBot" installs from http://postgis.net/windows_downloads .  I'm working on the assumption you are not working (yet) toward a production version. The ones at this location: http://winnie.postgis.net/download/windows/pg94/buildbot/ will also allow you to use all the SFCGAL goodness of the 3D chapter.

I'm also cc'ing the postgis users group.

Hi all-- best suggestions for Windows PostGIS installs with 2.x Python? Have the EDB versions of Postgres switched to 3.x Python?

Thanks,
Best,
Steve






On Tue, Jul 15, 2014 at 4:33 AM, Cyril Poitevin <cyril.poitevin <at> univ-lr.fr> wrote:

Oops "Hi Steve"

Sorry.

-------- Message original --------

Objet: Date: De: À:
Re: A question on PostGIS Cookbook
15.07.2014 10:08
Cyril Poitevin <cyril.poitevin <at> univ-lr.fr>
Stephen Mather <stephen <at> smathermather.com>

 

Hi Stephen,

This is the .exe:

postgresql-9.3.3-1-windows-x64.exe

https://www.sendspace.com/file/6eabi9

And when you run it, I have this information:

"Packaged by EDB EnterpriseDB"

I have also pgadmin3 1.18.1.

Thanks for your help.

Cyril

Le 15.07.2014 00:56, Stephen Mather a écrit :

Hi Cyril,

Specifically, which installer did you use for PostgreSQL?

Best,
Steve




On Mon, Jul 14, 2014 at 4:23 AM, Paolo Corti <pcorti <at> gmail.com> wrote:
Hi
as far as I can remember, on debian/ubuntu PostgreSQL has support for
bot Python 2.x and Python 3.x. Not being a Windows user I am not
totally sure what is the situation there.
The default, though, according to the documentation
(http://www.postgresql.org/docs/9.3/static/plpython-python23.html)
should be Python 2.x for any operating system:

"The language named plpythonu implements PL/Python based on the
default Python language variant, which is currently Python 2. (This
default is independent of what any local Python installations might
consider to be their "default", for example, what /usr/bin/python
might be.) The default will probably be changed to Python 3 in a
distant future release of PostgreSQL, depending on the progress of the
migration to Python 3 in the Python community."

Now, having said this, I am not sure why on your windows box the default is 3.2.
Maybe is it just a matter of installing the correct language name on
your database (plpython2u instead than plpython3u)?

I am adding Steve in copy, as he is the author of the Voronoi recipes
and maybe he has some more suggestions
regards
p

On Fri, Jul 11, 2014 at 6:51 PM, Cyril Poitevin
<cyril.poitevin <at> univ-lr.fr> wrote:
> Ciao,
>
> I've purchased PostGIS "Cookbook" last february, and it is really pleasant
> to read. I learned a lot with it. Thanks to bring a good reference book like
> this for all the geomaticians.
>
> By the way, I have a problem that I can't solve for the moment, I can't
> reproduce the tutorial to calculate a voronoi diagram, I need this method in
> my actual job, so it's quite important.
>
> I know you are not the author of this chapter but maybe you will be able to
> help me or just redirect myself towards the author of this part.
>
> In PostgreSQL 9.3 Windows 64 package, there is no library for linking
> PostgreSQL to Python 2, only one library to link it with Python 3.2 and It
> seems all the source code necessary (from geogeek blog or pyhull) have been
> developed with Python 2.7 so I can't use them. I tried to convert the code
> from geogeek blog for Python 3 but no success for the moment.
>
> You precise at the beginning of the book to install the latest version of
> PostgreSQL (9.3) so maybe you have a solution for using Python 2.7 with
> PostgreSQL 9.3,  I don't find solution on internet for that problem.
>
> Thanks in advance for your help.
>
> Kind regards.
>
> Cyril Poitevin - Ingénieur d'étude en traitement de données
> Mail : cyril.poitevin <at> univ-lr.fr / Tel : 06 03 48 77 34
> UMR 7266 / Littoral Environnement et Sociétés (LIENSs)
> 2 rue Olympe de Gouges 17000 La Rochelle



--
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: <at> capooti
skype: capooti

 


_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Paragon Corporation | 15 Jul 05:51 2014
Picon

ST_Tesselate and TINS is it supposed to maintain solidness

I tried tesselating a cube

NOTE: 

SELECT ST_Dimension(ST_GeomFromText('POLYHEDRALSURFACE Z( ((0 0 0, 0 0 1, 0
1 1, 0 1 0, 0 0 0)), 
		((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0
1, 0 0 1, 0 0 0)), 
		((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)), 
		((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1
1, 0 1 1, 0 0 1)) )'))

Comes back as a solid -- ST_Dimension = 3

But when I tesselate it, I get back a TIN with ST_Dimension 2
SELECT ST_Dimension(ST_Tesselate(ST_GeomFromText('POLYHEDRALSURFACE Z( ((0 0
0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)), 
		((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0
1, 0 0 1, 0 0 0)), 
		((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)), 
		((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1
1, 0 1 1, 0 0 1)) )')))

= 2

Rendering both them look the same to me.

Why is the TIN not considered closed is a TIN never considered closed?

See attached images I color coded the triangles in resulting tin and as far
as I can tell rotating it all sides were accounted for.

_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
evan | 14 Jul 21:50 2014
Picon

Changing Column output from WKB to Lat Lon Coordinates

Hello,

I am attempting to store some gps coordinates that i collected for a geospatial db in precision ag.  I created a table with a geometry column called "Coordinates"  using the command "Coordinates" geometry(Point,4326).  I then populated the column using the command ST_SetSRID(ST_MakePoint(-89.53580,44.12101), 4326));
This populates the coordinate table with a string in WKB.  Is there a way I can covert the output values of the entire column from WKB to the raw lat,lon values.  I have tried the alter table command    ALTER TABLE "Customers"ALTER COLUMN "Coordinates" TYPE geometry(St_AsLatLonText), 4326));  but with no luck. 

Im relatively new to sql and postgres,  I would certainly appreciate any help.

Thanks!
Evan
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
evan | 14 Jul 21:53 2014
Picon

Changing column data type from WKB to lat lon

Hello,

I am attempting to store some gps coordinates that i collected for a geospatial db in precision ag.  I created a table with a geometry column called "Coordinates"  using the command "Coordinates" geometry(Point,4326).  I then populated the column using the command ST_SetSRID(ST_MakePoint(-89.53580,44.12101), 4326));
This populates the coordinate table with a string in WKB.  Is there a way I can covert the output values of the entire column from WKB to the raw lat,lon values.  I have tried the alter table command    ALTER TABLE "Customers"ALTER COLUMN "Coordinates" TYPE geometry(St_AsLatLonText), 4326));  but with no luck. 

Im relatively new to sql and postgres,  I would certainly appreciate any help.

Thanks!
Evan
_______________________________________________
postgis-users mailing list
postgis-users <at> lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Gmane