On Sat, Oct 20, 2012 at 05:39:51PM -0700, Daniel Devine wrote:
Hi,
I'm having the same trouble building PostGIS on AWS that some other posters
here have encountered.
ERROR: could not load library …..postgis-2.0.so: undefined symbol:
json_tokener_errors
Did you install postgis from
OK, my view is called puntigronda and is based on a layer storing height of
civil buildings ( 4P000QG_QUOTA_GRONDA). It's geometry column is the_geom.
SELECT f_table_name, f_geometry_column, srid, type
FROM geometry_columns;
returns:
gtest;geom;0;LINESTRING
puntigronda;the_geom;3004;POINT
On Mon, Oct 22, 2012 at 08:40:07AM +0200, Pietro Rossin wrote:
DELETE FROM geometry_columns WHERE f_table_name = 'puntigronda';
...
Is there something wrong?
What's wrong is that the geometry_columns table should be a view,
in PostGIS-2.0. If it is a view, your DELETE and INSERT and UPDATE
to
DELETE FROM geometry_columns WHERE f_table_name = 'puntigronda';
Query returned successfully: 0 rows affected, 0 ms execution time.
INSERT INTO geometry_columns (f_table_catalog,f_table_schema, f_table_name,
f_geometry_column, coord_dimension, srid,type)
VALUES ('','', 'puntigronda',
Hello
This because I cannot remove the entities geometry column unless I remove the
entity table first.
And if I don't remove (or make invisible to qgis if possible) the entities
geometry column it slow down the qgis connection.
Did you try to edit the view, using the where clause to exclude
Hello Hugues
in my database I have both views and a main table on which these views pick
data from.
All of them have their own geometry column registered into the geometry
column set by postgis
My problem is that the main table (a huge one with mixed geometry data
type) has its own geometry
Your view is defined by a sql select so you should try to leave this select as
is except for the where clause where you could add something like : and
c.relname not like 'your_table_name'
I tried it with one of my table and this was ok, the table disappeared from the
geometry_columns view
Super!
I didn't realize that the geometry_column view could be edited...
So
I added at the end of the view sql statement:
AND c.relname not like 'entities'
that was converted by the system to
AND c.relname !~~ 'entities'::text
Then in qgis I had to specify that it must look only in
On Mon, Oct 22, 2012 at 02:39:31AM -0700, Pietro Rossin wrote:
My problem is that the main table (a huge one with mixed geometry data
type) has its own geometry column.
When qgis starts the connection to this db automatically looks into the
geometry column set and find the geom.column
Hi all,
After several tries, I am still unable to get this feature to work within
Postgis 2.0...
And with PostgreSQL 9.2, it is no more possible to downgrade to Postgis 1.5...
I am completely locked.
I try, once again, to give the steps to reproduce my bug:
1/ insert spatial_ref_sys entries
Hi Cédric,
+nadgrids=ntf_r93.gsb is a reference to the file:
/usr/share/proj/ntf_r93.gsb or
/usr/local/share/proj/ntf_r93.gsb
Have you verified that you have this file and the permissions are
something like 644?
-Steve W
On 10/22/2012 11:16 AM, DUPREZ Cédric wrote:
Hi all,
After several
It is a reference to the file :
/usr/share/proj/ntf_r93.gsb
The permissions are the following : -rw-r--r--
Cedric
-Message d'origine-
De : postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] De la part de Stephen
Woodbridge
Envoyé :
This question has a long history. Theoretically has good solutions that
worked for me:
http://trac.osgeo.org/postgis/wiki/UsersWikiExamplesOverlayTables
A good hint for this solution is that input geometries MUST BE SINGLE not
MULTI. It cost me a few days guessing that:
SELECT a.ogc_fid AS
Hello,
I've tried to make a linestring with z value as below
select st_isvalid(a.p), st_isvalid(b.q)
from (select st_geomfromtext ('LINESTRING Z(0 0 0, 1 0 0)') as p) as a,
(select st_geomfromtext('LINESTRING Z(0 0 0, 0 0 1)') as q) as b
the result shows that linestring from table b is not
Yes it is possible. Just download the newest setup from here
http://opportunity.bv.tu-berlin.de/software/projects/3dcitydb-imp-exp/files
.
Check out the tutorial pdf how to set up the relational schema (tables etc.)
for the 3d city database.
If your database is ready to be filled with CityGML
Hi Sandro,
Yes, installed from source.
Yes, the make check step is where I'm seeing the problem.
An interesting thing occurred though. Once (exactly once out of perhaps 20
builds now) it all worked correctly, but failed the one of the topology tests.
At that time I was unaware that the single
On Mon, Oct 22, 2012 at 09:40:46AM -0700, ps.tiara wrote:
Hello,
I've tried to make a linestring with z value as below
select st_isvalid(a.p), st_isvalid(b.q)
from (select st_geomfromtext ('LINESTRING Z(0 0 0, 1 0 0)') as p) as a,
(select st_geomfromtext('LINESTRING Z(0 0 0, 0 0 1)') as
select st_isvalid(a.p), st_isvalid(b.q) from
(select st_geomfromtext('LINESTRINGZ(0 0 0, 1 0 0)')as p) as a,
(select st_geomfromtext('LINESTRINGZ(0 0 0, 0.0001 0 1)') as q) as b;
st_isvalid (a.p) st_isvalid(b.q)
t t
LINESTRING(s) have an work obligation to
Hello,
I am trying to load my parcels into PostGIS, which will eventually be consumed
by MapServer, and ArcGIS. Initially when loaded my data I received a warning
that I should change my encoding from UTF-8 to LATIN1. Doing so allowed me to
load data into PostGIS however, I could not consume
On Mon, Oct 22, 2012 at 1:01 PM, Mark Volz markv...@co.lyon.mn.us wrote:
I am trying to load my parcels into PostGIS, which will eventually be
consumed by MapServer, and ArcGIS. Initially when loaded my data I received
a warning that I should change my encoding from UTF-8 to LATIN1.
How did
persistence pays off !!!
I threw the directions from the postgresql page that deals with
upgrading 8.4 to 9.1 away
that is where 90% of my problems came from.
Trying to update a re-constructed 8.4 database to postGIS2 was causing
all kinds of trouble
started from scratch..
mysql 5.0.95
On Oct 21, 2012, at 2:40 PM, Sandro Santilli wrote:
On Fri, Oct 19, 2012 at 11:56:18AM -0500, William Kyngesburye wrote:
Can the attributes of child layers be seen from a layer?
Sure, given enough neurons to build the appropriate SQL query...
(TopoGeomeometry management still has rough
22 matches
Mail list logo