[postgis-users] Import 3D-Geometry into PostGIS
Hello PostGIS - Community, i am very new in PostgreSQL and PostGIS. I want to use PostGIS to realize a combined 3D-WebGIS and Building Information System. But i can not find a way to import existing 3D-models (VRML and X3D) into PostGIS. You have an idea? Frank ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] CityGML in PostGIS - 3D City Database released
On Tuesday 17 July 2012 14:47:59 Felix Kunde wrote: Hello PostGIS - Community for everybody who is interested in storing 3D city models based on the OGC standard CityGML in an DBMS, I would like to annouce the release of the 3D City Database for PostGIS. Further information, software downloads and the source code repository can be found at: http://opportunity.bv.tu-berlin.de/software/projects/3dcitydb-imp-exp/ or on the official homepage of the 3D City Database http://www.3dcitydb.net (will be updated soon). The relational schema and a tool to import and export CityGML documents were developed by the Institute for Geodesy and Geoinformation Science (IGG) at the Technische Universität Berlin for the last five years. It is free software under the GNU Lesser General Public License Version 3.0. Until now it could only be used on an Oracle Spatial DBMS. Last fall I came to the developers asking if I could write my Master's thesis about the possibilities to port their open source software to the open source DBMS PostGIS. Well, it was possible and now I'm really curious about some reactions of interested users. I'm still relatively new to spatial database so I can't say if I have programmed the scripts and java-code in the best way. At least comparing performance tests to the Oracle version looked very good ;) I would also like to thank the developers of PostGIS. Your hard work on PostGIS 2.0 made this all possible. I'm looking forward to the next releases, especially the 3D stuff. Have a nice day! Felix ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Very interesting, I'm looking forward to learn more about it, have a great week. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Export from schema with pgsql2shp broken for Windows 64?
Hi, Would it be possible that exporting a geometry table to a shapefile with pgsql2shp from a schema different then public does not work for the Windows 64 version of PostGIS 2.0? It works fine on my other Windows 32 bit installation. I could not find anything on this on the web or in trac about this problem. Here is my command and the output: pgsql2shp -f c:/temp/targetfile2.shp -g geom -u postgres -P secret foundry03 ovlp.bug03 bug03 Initializing... Table bug03 does not exist Pierre ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
On Wed, 2012-07-18 at 12:48 -0700, Nahum Castro wrote: I have this error when compiling postgis 2.0.1 snip http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/repoview/postgis2_91.html has the RPM if you want, so that you don't need to compile from sources. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Better way of removing pixelation with postgis raster
Hi Tom, Im trying to create a landuse map for a customer that requires the removal of pixelation (isolated islands of pixels, possible larger than 1 pixel). To make things complicated, different pixelclasses have different tresholds for removal. For instance, class 1 is removed when the combined pixels are less than 4, whereas class2 is removed when the combined pixels are less than 50. Furthermore, some classes count diagonal neighbours as 'touching' whereas other classes discard them. My solution is given below. As you can see there is an expensive buffer-union-buffer trio to make sure I connect the correct polygons before I can calculate their area. This calculation is part of a big raster calculation. All of the calculations are going very fast, except this one. Anyone with an idea to make it faster? In the end all I need is removal of isolated islands of pixels so any matrix calculation would be fine as well. I think you could easily implement a filter function to remove the 1 pixel type of island as a custom function of ST_MapAlgebraFctNgb(). See http://www.postgis.org/documentation/manual-svn/RT_ST_MapAlgebraFctNgb.html The size of the window should be 3x3 in this case. Return the pixel value if at least one neighbour has a value, null otherwise. I am 99% sure ST_MapAlgebraFctNgb would be faster on big rasters than vectorizing/union/rasterizing... However I have no idea how to implement such a filter to remove bigger islands (or speckles?) spanning on many pixels. Maybe with a little of research... Pierre ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
Hard to go wrong with Devrim's RPMs, fire and forget. Your particular problem is probably caused by /usr/local/lib not being in /etc/ld.so.conf (the library exists, but the linker isn't aware of it until you configure that directory in) P. On Wed, Jul 18, 2012 at 12:59 PM, Devrim GÜNDÜZ dev...@gunduz.org wrote: On Wed, 2012-07-18 at 12:48 -0700, Nahum Castro wrote: I have this error when compiling postgis 2.0.1 snip http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/repoview/postgis2_91.html has the RPM if you want, so that you don't need to compile from sources. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
there is a line to /usr/local/lib in a file that i created named /etc/ld.so.conf.d/mapas.conf here are the out from ldconfig -v /usr/local/lib: libgdalconstjni.so.1 - libgdalconstjni.so liblwgeom-2.0.1.so - liblwgeom.so libosrjni.so.1 - libosrjni.so libNCSEcw.so.0 - libNCSEcw.so.0.0.0 libNCSCnet.so.0 - libNCSCnet.so.0.0.0 libjson.so.0 - libjson.so.0.0.1 libgdaljni.so.1 - libgdaljni.so libogrjni.so.1 - libogrjni.so libgdal.so.1 - libgdal.so.1.16.1 libproj.so.0 - libproj.so.0.7.0 libNCSUtil.so.0 - libNCSUtil.so.0.0.0 libgeos-3.3.5.so - libgeos.so libNCSEcwC.so.0 - libNCSEcwC.so.0.0.0 libgeos_c.so.1 - libgeos_c.so.1.7.5 /usr/local/pgsql/lib: libpqwalreceiver.so - libpqwalreceiver.so libecpg_compat.so.3 - libecpg_compat.so.3.3 libpgtypes.so.3 - libpgtypes.so.3.2 libpq.so.5 - libpq.so.5.4 libecpg.so.6 - libecpg.so.6.3 The problem with the postgresql.org repo is that do not have gdal and raster capabilities. I'd like to learn pgraster. Thanks. -- Nahum Castro Leon, Guanajuato, Mexico http://www.leon-linux.com e-mail: pedro1_72 [en] yahoo [punto] com De: Paul Ramsey pram...@opengeo.org Para: PostGIS Users Discussion postgis-users@postgis.refractions.net CC: Nahum Castro pedro1...@yahoo.com Enviado: Miércoles, 18 de julio, 2012 15:25:51 Asunto: Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3 Hard to go wrong with Devrim's RPMs, fire and forget. Your particular problem is probably caused by /usr/local/lib not being in /etc/ld.so.conf (the library exists, but the linker isn't aware of it until you configure that directory in) P. On Wed, Jul 18, 2012 at 12:59 PM, Devrim GÜNDÜZ dev...@gunduz.org wrote: On Wed, 2012-07-18 at 12:48 -0700, Nahum Castro wrote: I have this error when compiling postgis 2.0.1 snip http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/repoview/postgis2_91.html has the RPM if you want, so that you don't need to compile from sources. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
Hi, On Wed, 2012-07-18 at 13:44 -0700, Nahum Castro wrote: The problem with the postgresql.org repo is that do not have gdal and raster capabilities. That is not correct: %configure --with-pgconfig=%{pginstdir}/bin/pg_config --with-raster --disable-rpath --with-gui Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
On 19 July 2012 08:44, Nahum Castro pedro1...@yahoo.com wrote: The problem with the postgresql.org repo is that do not have gdal and raster capabilities. Hi Nahum, A few days ago I finished some instructions for CentOS 6, using PGDG and EPEL. http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20CentOS6pgdg GDAL is now mostly in PGDG (it wasn't before), but there are still a few missing dependencies for CentOS 6, which are supplied by EPEL. Devrim, I have in the instructions these [extra GDAL dependency] packages may be included as part of PGDG in future release, I'm not sure if that's true or not. Do you want a list of what else is missing? (I realize there is an impressive list of dependencies) -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
Hi, On Thu, 2012-07-19 at 11:18 +1200, Mike Toews wrote: A few days ago I finished some instructions for CentOS 6, using PGDG and EPEL. http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20CentOS6pgdg Thanks! GDAL is now mostly in PGDG (it wasn't before), but there are still a few missing dependencies for CentOS 6, which are supplied by EPEL. Devrim, I have in the instructions these [extra GDAL dependency] packages may be included as part of PGDG in future release, I'm not sure if that's true or not. Do you want a list of what else is missing? (I realize there is an impressive list of dependencies) Yes, I am aware of those dependencies, and as you wrote, it is too many RPMs to copy to our repo -- so I'm not inclined to copy them, sorry :( -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
On 19 July 2012 11:28, Devrim GÜNDÜZ dev...@gunduz.org wrote: Yes, I am aware of those dependencies, and as you wrote, it is too many RPMs to copy to our repo -- so I'm not inclined to copy them, sorry :( OK, I've reworded instructions to reflect this situation with respect to CentOS. -Mike ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3
I disabled Intel TXT from the motherboard. Now can be compiled, by the way I noticed that the system needs to be connected to the Internet to install. postgis-out.xml:11: warning: failed to load external entity http://www.w3.org/Math/DTD/mathml2/mathml2.dtd; %mathml; ^ Entity: line 1: %mathml; ^ using_postgis_dataman.xml:1372: namespace error : Namespace prefix mml on math is not defined mml:math display=block Thanks to all. Nahum -- Nahum Castro Leon, Guanajuato, Mexico http://www.leon-linux.com e-mail: pedro1_72 [en] yahoo [punto] com De: Nahum Castro pedro1...@yahoo.com Para: Paul Ramsey pram...@opengeo.org; PostGIS Users Discussion postgis-users@postgis.refractions.net Enviado: Miércoles, 18 de julio, 2012 15:44:55 Asunto: Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3 there is a line to /usr/local/lib in a file that i created named /etc/ld.so.conf.d/mapas.conf here are the out from ldconfig -v /usr/local/lib: libgdalconstjni.so.1 - libgdalconstjni.so liblwgeom-2.0.1.so - liblwgeom.so libosrjni.so.1 - libosrjni.so libNCSEcw.so.0 - libNCSEcw.so.0.0.0 libNCSCnet.so.0 - libNCSCnet.so.0.0.0 libjson.so.0 - libjson.so.0.0.1 libgdaljni.so.1 - libgdaljni.so libogrjni.so.1 - libogrjni.so libgdal.so.1 - libgdal.so.1.16.1 libproj.so.0 - libproj.so.0.7.0 libNCSUtil.so.0 - libNCSUtil.so.0.0.0 libgeos-3.3.5.so - libgeos.so libNCSEcwC.so.0 - libNCSEcwC.so.0.0.0 libgeos_c.so.1 - libgeos_c.so.1.7.5 /usr/local/pgsql/lib: libpqwalreceiver.so - libpqwalreceiver.so libecpg_compat.so.3 - libecpg_compat.so.3.3 libpgtypes.so.3 - libpgtypes.so.3.2 libpq.so.5 - libpq.so.5.4 libecpg.so.6 - libecpg.so.6.3 The problem with the postgresql.org repo is that do not have gdal and raster capabilities. I'd like to learn pgraster. Thanks. -- Nahum Castro Leon, Guanajuato, Mexico http://www.leon-linux.com e-mail: pedro1_72 [en] yahoo [punto] com De: Paul Ramsey pram...@opengeo.org Para: PostGIS Users Discussion postgis-users@postgis.refractions.net CC: Nahum Castro pedro1...@yahoo.com Enviado: Miércoles, 18 de julio, 2012 15:25:51 Asunto: Re: [postgis-users] Error compiling postgis 2.0.1 in Centos 6.3 Hard to go wrong with Devrim's RPMs, fire and forget. Your particular problem is probably caused by /usr/local/lib not being in /etc/ld.so.conf (the library exists, but the linker isn't aware of it until you configure that directory in) P. On Wed, Jul 18, 2012 at 12:59 PM, Devrim GÜNDÜZ dev...@gunduz.org wrote: On Wed, 2012-07-18 at 12:48 -0700, Nahum Castro wrote: I have this error when compiling postgis 2.0.1 snip http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/repoview/postgis2_91.html has the RPM if you want, so that you don't need to compile from sources. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users