Re: [postgis-users] Intersections on polyhedral surfaces....

2013-12-12 Thread Oliver Courtin
Le 12 déc. 2013 à 08:42, Rémi Cura a écrit : waht would you mean by intersection in 3D space? volumetric intersection, or 2D intersection of colinear geometries? Both ST_3DIntersects and ST_3DIntersection (with SFCGAL support) can handle 3D space volumetric intersection. O.

Re: [postgis-users] Old question resurfacing

2013-12-12 Thread Frank Henze
Hi Bobb, hi all, https://hub.sharedgeo.org/apps/x3d/ looks great! We have similar requirements for a 3d WebGIS. A first prototype you can find at: http://www2.htw-dresden.de/~s68071/3DWebGIS/ For Projektauswahl: select W3DS and then select Historische Gebäude (Historical Buildings) If there

Re: [postgis-users] help with the Union of 2 shp

2013-12-12 Thread islanis
Hi, Try pg 21 of this: http://presentations.opengeo.org/2011_FOSS4G/postgis-power.pdf That will give you the metacode. Overlays. (he sighs.) Be glad you only have 2 layers... . Best, Steve Hey steve thanks for the book is really good as a resume, but the only apart that it have to do

Re: [postgis-users] help with the Union of 2 shp

2013-12-12 Thread Rémi Cura
Seems like If you want : for each little square, get the id of big square overlaping. If this is simply this, you don't need the intersection function, but only the intersects function : You could do something like this SELECT ss.id, bs.id , ss.geom FROM smal_square_table AS ss, big_square_table

Re: [postgis-users] Old question resurfacing

2013-12-12 Thread Basques, Bob (CI-StPaul)
All, I have a development team wanting to work on this, just need a funded project to work from, otherwise it’s going to happen much more slowly as time permits. So if you know of any projects in the works, etc. . . . Bobb From: postgis-users-boun...@lists.osgeo.org

[postgis-users] How can get EPSG 15948 into PG?

2013-12-12 Thread Andreas Laggner
Hi list, epsg 15948 is needed to transform from DE_DHDN(BeTA, 2007) (for example 31467) to ETRS89. BUT epsg 15948 is neither available in spatial_ref_sys (postgis 2.1) nor at http://spatialreference.org!! I have about 10.000 tables in 31467, because that was standard in germany last

Re: [postgis-users] help with the Union of 2 shp

2013-12-12 Thread Rémi Cura
I'm very sorry it is difficult to understand what you mean. Maybe with a real drawing and link here to it, or to some screenshots? ;-) Cheers, Rémi-C 2013/12/12 isla...@infomed.sld.cu thanks for the quick answer Rémi, but, thats right thats one of answers, but my idea was not

Re: [postgis-users] help with the Union of 2 shp

2013-12-12 Thread islanis
no is not dificult to understand, what ever you want i'll give , just ask what do you want to a better understanding. please i need it Rémi Cura remi.c...@gmail.com escribió: I'm very sorry it is difficult to understand what you mean. Maybe with a real drawing and link here to it, or to some

Re: [postgis-users] How can get EPSG 15948 into PG?

2013-12-12 Thread Rémi Cura
Hey, first you add your custom projection to qgis, so you can check that everything is good. For this go in the options/custom projection and add yours. If you already have a shapefile with this projection, just import it in qgis and save the created user defined projection. When you know you

Re: [postgis-users] help with the Union of 2 shp

2013-12-12 Thread Rémi Cura
Sorry I'm not trying to offend you. For example in this thread https://groups.google.com/forum/#!topic/postgis-users/9pozIoUAZuI The asker posted an image to explain better. Cheers, Rémi-C 2013/12/12 isla...@infomed.sld.cu no is not dificult to understand, what ever you want i'll give ,

Re: [postgis-users] Overlapping of polygons with SimplifyPreserveTopology

2013-12-12 Thread Luca Morandini
On 11/12/13 19:15, Sandro Santilli wrote: A topological approach would solve it. Simplifying a polygon may overlap with the still-unsimplified adjacent one, so you can't check after each single simplification. You could check afterwards, at the end, but then resolving one overlap on one side

[postgis-users] postgis 2.0 and postgist 2.1 compatibility issues

2013-12-12 Thread Marty O'Neill II
I am running postgresql 9.1 with postgis 2.0 in Windows 7. After creating a dump from the database, I tried to restore on a machine running Ubuntu with postgresql 9.3 and postgis 2.1. However, the spatial extent is incorrect when viewed in QuantumGIS and in other custom GIS software. The spatial

Re: [postgis-users] Intersections on polyhedral surfaces....

2013-12-12 Thread Stephen Mather
Volumetric intersection. On Thu, Dec 12, 2013 at 2:42 AM, Rémi Cura remi.c...@gmail.com wrote: waht would you mean by intersection in 3D space? volumetric intersection, or 2D intersection of colinear geometries? Rémi-C 2013/12/12 Mateusz Loskot mate...@loskot.net

Re: [postgis-users] Intersections on polyhedral surfaces....

2013-12-12 Thread Stephen Mather
Brilliant. I'll give it a whirl then. On Thu, Dec 12, 2013 at 3:20 AM, Oliver Courtin olivier.cour...@oslandia.com wrote: Le 12 déc. 2013 à 08:42, Rémi Cura a écrit : waht would you mean by intersection in 3D space? volumetric intersection, or 2D intersection of colinear geometries? Both

Re: [postgis-users] Intersections on polyhedral surfaces....

2013-12-12 Thread Stephen Mather
The docs don't have ST_3DIntersection, just ST_3DIntersects: http://postgis.net/docs/manual-2.1/reference.html#Geometry_Constructors http://postgis.net/docs/manual-dev/reference.html#Geometry_Constructors And, my 2.1.2 Ubuntu build (with SFCGAL) doesn't have the function. Would I have it if I

Re: [postgis-users] Intersections on polyhedral surfaces....

2013-12-12 Thread Oliver Courtin
Le 13 déc. 2013 à 05:29, Stephen Mather a écrit : Forgot that when I dropped and recreated the database… . It's still not in the docs. You're right it's was forgotten in the doc. But available since 2.1 I'll add this to my list of things to ticket, if someone doesn't beat me to it… .