[postgis-users] AUTO: Wouter Boasson is out of the office. (returning Wed 08/17/2011)
I am out of the office from Sat 07/16/2011 until Wed 08/17/2011. Geachte mevrouw, mijnheer, Op het moment kan ik uw mail niet beantwoorden. Voor dringende zaken kunt u zich wenden tot het secretariaat van het EMI: marion.linneb...@rivm.nl, T 030-2742913 anne.marie.van.kl...@rivm.nl, T 030-2748570 Met vriendelijke groet, Wouter Boasson Note: This is an automated response to your message "postgis-users Digest, Vol 112, Issue 5" sent on 18-10-2010 21:00:01. This is the only notification you will receive while this person is away. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] ST_distance_sphere and creating new geom from distance and direction values
Dear all, I have two questions to ask: Q1: I have a table that has one geometry column and I want to calculate distance (in Km) between two geometries which is in one column. I am using select query as under, and wanted to know if this is the right way of doing distance calculation between two points. Since, both the points are in one table but in different rows so I am using select statement to pick the geom from each row. select st_distance_sphere((select the_geom from table_name where place_name='PL1'), (select the_geom from table_name where place_name='PL2'))/1000; Q2: I have a table that has columns distance, direction, place_name and geometry (with SRID 4326) as under. Iddistance direction Place_name geom 1 42 kmE PL1 some geometry Now I want to calculate new geometry with reference to given geometry based on some distance and direction. Such that new geometry is at “42km E of some reference geometry”. Is there a function that can do this? Or if someone can point me to a specific link.. Thanks, YJ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error when building from source on mac os x 10.6
It looks like the different parts of postgis compilation (ie most of it comes from the Postgres make system) don't have the same information about what architectures to compile for. I always specify these before configuring postgis: export CFLAGS="-Os -arch i386 -arch x86_64" export PG_CPPFLAGS="-arch i386 -arch x86_64" export SHLIB_LINK="-arch i386 -arch x86_64" export LDFLAGS="-arch i386 -arch x86_64" Note that you need to know which architectures GEOS, PROJ and Postgres are compiled for. Use as many -arch flags in each of the above exports as is common to these. It may be i386 and x86_64, but it could also be only x86_64. If i386 is the only common arch, you should recompile to get at least x86_64. On Jul 17, 2011, at 11:42 AM, Gis Mage wrote: > Hi list! > I'm trying to build postgis from source on a snow leopard machine. > So I download the 1.5.3 source, configure like this: > > sudo ./configure --prefix=/opt/postgis > --with-pgconfig=/opt/pgsql/bin/pg_config --mandir=/opt/pgsql/man > --with-geosconfig=/opt/geos/bin/geos-config --with-projdir=/opt/proj > > and get a successful result: > > PostGIS is now configured for x86_64-apple-darwin10.7.0 > > -- Compiler Info - > C compiler: gcc -g -O2 > C++ compiler: g++ -g -O2 > > -- Dependencies -- > GEOS config: /opt/geos/bin/geos-config > GEOS version: 3.3.0 > PostgreSQL config:/opt/pgsql/bin/pg_config > PostgreSQL version: PostgreSQL 9.1beta3 > PROJ4 version:47 > Libxml2 config: /usr/bin/xml2-config > Libxml2 version: 2.7.3 > PostGIS debug level: 0 > > Documentation Generation > xsltproc: /usr/bin/xsltproc > xsl style sheets: > dblatex: > convert: > > Then I do > sudo make > And get an error: > > "_lwline_free", referenced from: > _askml2_inspected_buf in lwgeom_kml.o > _askml2_inspected_size in lwgeom_kml.o > ld: symbol(s) not found for architecture i386 > collect2: ld returned 1 exit status > lipo: can't open input file: /var/tmp//ccsIJfa2.out (No such file or > directory) > make[1]: *** [postgis-1.5.so] Error 1 > make: *** [postgis] Error 2 > > So I've checked my /var/tmp dir and I really don't have ccsIJfa2.out file. > What am I doing wrong here? > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users - William Kyngesburye http://www.kyngchaos.com/ "Oh, look, I seem to have fallen down a deep, dark hole. Now what does that remind me of? Ah, yes - life." - Marvin ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] AsText returns nothing but geometries exist in table
In lieu of an informed answer, logic would suggest the geometry must be in the table (if it is displaying correctly in a GIS application). Therefore, I would suggest that there may be some aspect of displaying it other than in a GIS application that is the problem. Are you using pgAdmin to view the table data? What operating system? There is a character limit - the normal limit on postgres rows is 2048 characters. But geometry data are not actually stored in the table, rather they are stored in a TOAST table. I would suggest that you try looking at it in psql (the command line application) or I believe there is a plug-in for pgAdmin that might help display the data there. Be aware also that if your geometries are large, the rows will be wide, and so displaying them in psql might be somewhat frustrating as you will have a large amount of blank space in the table heading etc. cheers Ben On 18/07/2011, at 8:30 PM, Phil James wrote: > I have loaded some geometry into a postgis table but although the geometry is > there (displays in Quantum and can query with ST_various correctly) it does > not appear with AsText() or in the Edit Table view. The type is MultiPolygon > using postgres 9 Postgis 1.5. Is there some character limit it exceeds? If > so why does the the_geom column appear blank in Edit Table using PGADMIN as > well? I have checked the geometry and it is valid. > > Thanks > > Phil > ___ > 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] AsText returns nothing but geometries exist in table
I have loaded some geometry into a postgis table but although the geometry is there (displays in Quantum and can query with ST_various correctly) it does not appear with AsText() or in the Edit Table view. The type is MultiPolygon using postgres 9 Postgis 1.5. Is there some character limit it exceeds? If so why does the the_geom column appear blank in Edit Table using PGADMIN as well? I have checked the geometry and it is valid. Thanks Phil___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
Mmmm I never worked with Mac. You should ask a Mac-user Horst Am 18.07.2011 13:56, schrieb maning sambale: Thanks horst! I just tested using ubuntu and it works just fine. Are there "binaries" of libqt4-sql libqt4-sql-psql python-qt4-sql in mac? On Mon, Jul 18, 2011 at 7:53 PM, Horst Düster wrote: Am 18.07.2011 13:45, schrieb maning sambale: What about the errors on the postgis version table creation? This is not an error only a notice, that the function which should be dropped doesnt exists and the drop action is skipped. Everything should be fine. Regards Horst -- Dr. Horst Düster Burchacker 6 CH-4556 Aeschi Tel.: +41(0)62 961 03 74 Mobil: +41(0)76 408 51 06 E-Mail: horst.dues...@kappasys.ch Skype: horstduester Web: http://www.kappasys.ch ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Dr. Horst Düster Burchacker 6 CH-4556 Aeschi Tel.: +41(0)62 961 03 74 Mobil: +41(0)76 408 51 06 E-Mail: horst.dues...@kappasys.ch Skype: horstduester Web: http://www.kappasys.ch <>___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
Thanks horst! I just tested using ubuntu and it works just fine. Are there "binaries" of libqt4-sql libqt4-sql-psql python-qt4-sql in mac? On Mon, Jul 18, 2011 at 7:53 PM, Horst Düster wrote: > > > Am 18.07.2011 13:45, schrieb maning sambale: >> >> What about the errors on the postgis version >> table creation? > > This is not an error only a notice, that the function which should be > dropped doesnt exists and the drop action is skipped. Everything should be > fine. > > Regards > Horst > > -- > > Dr. Horst Düster > Burchacker 6 > CH-4556 Aeschi > > Tel.: +41(0)62 961 03 74 > Mobil: +41(0)76 408 51 06 > E-Mail: horst.dues...@kappasys.ch > Skype: horstduester > Web: http://www.kappasys.ch > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- cheers, maning -- "Freedom is still the most radical idea of all" -N.Branden wiki: http://esambale.wikispaces.com/ blog: http://epsg4253.wordpress.com/ -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
Am 18.07.2011 13:45, schrieb maning sambale: What about the errors on the postgis version table creation? This is not an error only a notice, that the function which should be dropped doesnt exists and the drop action is skipped. Everything should be fine. Regards Horst -- Dr. Horst Düster Burchacker 6 CH-4556 Aeschi Tel.: +41(0)62 961 03 74 Mobil: +41(0)76 408 51 06 E-Mail: horst.dues...@kappasys.ch Skype: horstduester Web: http://www.kappasys.ch <>___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
I assume this is on the qgis install (I'm using mac) and not on the remote postgis server? What about the errors on the postgis version table creation? 2011/7/18 Horst Düster : > sudo apt-get install libqt4-sql libqt4-sql-psql python-qt4-sql -- cheers, maning -- "Freedom is still the most radical idea of all" -N.Branden wiki: http://esambale.wikispaces.com/ blog: http://epsg4253.wordpress.com/ -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
you have to install some additional python and qt stuff with: sudo apt-get install libqt4-sql libqt4-sql-psql python-qt4-sql Regards Horst Am 18.07.2011 13:36, schrieb maning sambale: Fehlermeldung:' Driver not loaded.' Es kann keine Verbindung zur Datenbank aufgebaut werden! Einige Funktionen des PlugIn doInit funktionieren deshalb nicht! -- Dr. Horst Düster Burchacker 6 CH-4556 Aeschi Tel.: +41(0)62 961 03 74 Mobil: +41(0)76 408 51 06 E-Mail: horst.dues...@kappasys.ch Skype: horstduester Web: http://www.kappasys.ch <>___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
>> The pgadminIII showed the added versions schema but I can't use it in qgis >> 1.7. > > What do you mean with I can't use it in qgis 1.7? Please explain your > problem more precise.. On QGIS 1.7, I can load the postgis layer but using the PG_version Plugin: Database > PG Version > Prepare Layer for Versioning, I get the following messages: Fehlermeldung:' Driver not loaded.' Es kann keine Verbindung zur Datenbank aufgebaut werden! Einige Funktionen des PlugIn doInit funktionieren deshalb nicht! Followed by: Please upgrade the DB-functions from the file: /pgversion/tools/updateFunctions.sql If you have appropriate DB permissions you can update the DB directly with click on DB-Update. Driver not loaded Driver not loaded I tried to manually update the updateFunctions.sql using psql but I also get errors. > > Dr. Horst Düster > Burchacker 6 > CH-4556 Aeschi > > Tel.: +41(0)62 961 03 74 > Mobil: +41(0)76 408 51 06 > E-Mail: horst.dues...@kappasys.ch > Skype: horstduester > Web: http://www.kappasys.ch > > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- cheers, maning -- "Freedom is still the most radical idea of all" -N.Branden wiki: http://esambale.wikispaces.com/ blog: http://epsg4253.wordpress.com/ -- ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
Hi maning sambale CREATE FUNCTION psql:createFunctions.sql.1:920: NOTICE: function versions.pgvsreverse(pg_catalog.varchar) does not exist, skipping DROP FUNCTION CREATE FUNCTION You didnt get an error its only a notice. Dont worry. The pgadminIII showed the added versions schema but I can't use it in qgis 1.7. What do you mean with I can't use it in qgis 1.7? Please explain your problem more precise.. Regrads Horst -- Dr. Horst Düster Burchacker 6 CH-4556 Aeschi Tel.: +41(0)62 961 03 74 Mobil: +41(0)76 408 51 06 E-Mail: horst.dues...@kappasys.ch Skype: horstduester Web: http://www.kappasys.ch <>___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
I have created a new database for the pg_versioning. I created pgvs functions and got this error: $ psql -d philippines -U -h -f createFunctions.sql CREATE SCHEMA CREATE TYPE GRANT psql:createFunctions.sql.1:32: NOTICE: CREATE TABLE will create implicit sequence "version_tables_version_table_id_seq" for serial column "version_tables.version_table_id" psql:createFunctions.sql.1:32: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "version_table_pkey" for table "version_tables" CREATE TABLE GRANT CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:createFunctions.sql.1:920: NOTICE: function versions.pgvsreverse(pg_catalog.varchar) does not exist, skipping DROP FUNCTION CREATE FUNCTION The pgadminIII showed the added versions schema but I can't use it in qgis 1.7. On Mon, Nov 8, 2010 at 7:37 PM, maning sambale wrote: > Sweet! It's working on qgis 1.5 (ubuntu). Will be watching this > plugin. Thanks! > > On Mon, Nov 8, 2010 at 7:13 PM, Düster Horst wrote: >> I made an update to handle a non existing pgvs in the layers source db. >> Please reinstall the plugin and try again. >> >> Dr. Horst Düster >> Stv. Amtschef / kantonaler GIS-Koordinator >> Kanton Solothurn >> Bau- und Justizdepartement >> Amt für Geoinformation >> SO!GIS Koordination >> Rötistrasse 4 >> CH-4501 Solothurn >> Telefon ++41(0)32 627 25 32 >> Mobil ++41(0)79 511 54 12 >> Telefax ++41(0)32 627 22 14 >> mailto:horst.dues...@bd.so.ch >> http://www.agi.so.ch >> -Ursprüngliche Nachricht- >> Von: emmanuel.samb...@gmail.com [mailto:emmanuel.samb...@gmail.com] >> Gesendet am: Montag, 8. November 2010 10:58 >> An: Düster Horst >> Cc: postgis-users >> Betreff: Re: Re: [postgis-users] Announcement: PostGIS Versioning System >> pgversion and QGIS Plugin >> On QGIS 1.4 (mac), I overridden the 1.5 warning and continued with the >> install. Plugin manager didn't activate it. >> On qgis 1.5.0 (ubuntu): >> I had to install qtsql. Then the plugin was activated. Tested with >> my test postgis data, I got this error when I used "Prepare layer for >> versioning": >> An error has occured while executing Python code: >> Traceback (most recent call last): >> File "/home/maning/.qgis/python/plugins/pgversion/pgVersion.py", >> line 170, in doInit >> if not self.tools.versionExists(mySchema, myTable): >> File "/home/maning/.qgis/python/plugins/pgversion/pgVersionTools.py", >> line 107, in versionExists >> if len(result["SCHEMA"]) 0: >> KeyError: 'SCHEMA' >> Python version: >> 2.6.5 (r265:79063, Apr 16 2010, 13:28:26) >> [GCC 4.4.3] >> QGIS version: >> 1.5.0-Tethys Tethys, exported >> Python path: ['/usr/share/qgis/python', '/home/maning/.qgis/python', >> '/home/maning/.qgis/python/plugins', '/usr/share/qgis/python/plugins', >> '/usr/local/lib/python2.6/dist-packages/Sphinx-0.6.5-py2.6.egg', >> '/usr/local/lib/python2.6/dist-packages/docutils-0.6-py2.6.egg', >> '/usr/local/lib/python2.6/dist-packages/Jinja2-2.4.1-py2.6.egg', >> '/usr/local/lib/python2.6/dist-packages/Pygments-1.3.1-py2.6.egg', >> '/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2', >> '/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old', >> '/usr/lib/python2.6/lib-dynload', '/usr/lib/python2.6/dist-packages', >> '/usr/lib/python2.6/dist-packages/PIL', >> '/usr/lib/python2.6/dist-packages/gst-0.10', >> '/usr/lib/pymodules/python2.6', >> '/usr/lib/python2.6/dist-packages/gtk-2.0', >> '/usr/lib/pymodules/python2.6/gtk-2.0', >> '/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode', >> '/usr/local/lib/python2.6/dist-packages', >> u'/home/maning/.qgis//python/plugins', >> '/usr/share/qgis/python/plugins/fTools/tools'] >> On Mon, Nov 8, 2010 at 5:21 PM, Düster Horst wrote: >>> The plugin is marked as experimental and I had set the qgis minimum >>> version >>> to 1.5 due to I tested the plugin with 1.5. I changed the minimum version >>> 1.4. Please try it and give me a responce whether it works. >>> Regards >>> Horst >>> >>> Dr. Horst Düster >>> Stv. Amtschef / kantonaler GIS-Koordinator >>> Kanton Solothurn >>> Bau- und Justizdepartement >>> Amt für Geoinformation >>> SO!GIS Koordination >>> Rötistrasse 4 >>> CH-4501 Solothurn >>> Telefon ++41(0)32 627 25 32 >>> Mobil ++41(0)79 511 54 12 >>> Telefax ++41(0)32 627 22 14 >>> mailto:horst.dues...@bd.so.ch >>> http://www.agi.so.ch >>> -Ursprüngliche Nachricht- >>> Von: maning sambale [mailto:emmanuel.samb...@gmail.com] >>> Gesendet am: Montag, 8. November 2010 10:10 >>> An: PostGIS Users Discussion >>> Betreff: Re: [postgis-users] Announcement: PostGIS Versioning System >>> pgversion and QGIS Plugin >>> Nice! What version of QGIS does it use. I added your repoe, but I >>> can't find the plugin in my 1.4 version >>> On Mon, Nov 8, 2010 at 4:08 PM, Javier de la Torre >>> wrote: Hi, Thats great. Congratulations. One question. If I understand corr
