Hi everyone!
I have installed PostgreSQL 8.3 and PostGIS (postgis_1_3_3_pg83). I have a
table with many stations in Southern Spain (POINT) and their coordinates
LATITUDE, LONGITUDE and ELEVATION.
How can I create a geometry column? I try with AddGeometryColumn but I couldn't.
Thanks.
Javier
Hi everyone!
I have installed PostgreSQL 8.3 and PostGIS (postgis_1_3_3_pg83). I have a
table with many stations in Southern Spain (POINT) and their coordinates
LATITUDE, LONGITUDE and ELEVATION.
How can I create a geometry column? I try with AddGeometryColumn but I
couldn't.
Hi,
What
I recall having similar issues when moving to 8.3. I think I had to put in
a using UNIQUE in there for some of my layers but mostly layers that were
view based
Try doing
DATA geoloc from consejospopulares USING UNIQUE gid USING
SRID=sridgoeshere
Or
DATA geoloc from consejospopulares
First of all, Postgres display me the next error with this query:
My database is named postgres
My table is named estac_aemet
The name of the new column I want to create is the_geom
23030 is UTM-ED50 huso 30 (Proyection I want)
SELECT addgeometrycolumn('postgres','estac_aemet', 'the_geom',
First of all, Postgres display me the next error with this query:
My database is named postgres
My table is named estac_aemet
The name of the new column I want to create is the_geom
23030 is UTM-ED50 huso 30 (Proyection I want)
SELECT addgeometrycolumn('postgres','estac_aemet', 'the_geom',
Now, with you purpose, this error:
ERROR: no existe la relación «public.estac_aemet»
CONTEXTO: sentencia SQL: «ALTER TABLE public.estac_aemet ADD COLUMN the_geom
geometry »
PL/pgSQL function addgeometrycolumn line 90 at EXECUTE statement
sentencia SQL: «SELECT AddGeometryColumn('', $1 , $2 ,
Now, with you purpose, this error:
ERROR: no existe la relación «public.estac_aemet»
Is the estac_aemet table exists ? If so, in which schema was it created ?
___
postgis-users mailing list
postgis-users@postgis.refractions.net
Yes, the tabla estac_aemet exists. The schema is public
Now, with you purpose, this error:
ERROR: no existe la relación «public.estac_aemet»
Is the estac_aemet table exists ? If so, in which schema was it created ?
___
postgis-users mailing
Yes, the tabla estac_aemet exists. The schema is public
Did you create the table using double quotes to name it ? ESTAC_AEMET maybe ?
If so, then you have to respect the case in the table name when naming it:
SELECT addgeometrycolumn('public','ESTAC_AEMET', 'the_geom', 23030,'POINT',2)
You
No, is correct like 'estac_aemet'
How do I know if my POSTGIS functions are installed ok?
In my DB called 'postgres' I have no Functions.
Yes, the tabla estac_aemet exists. The schema is public
Did you create the table using double quotes to name it ? ESTAC_AEMET maybe
?
If so, then you
Carmen,
The trouble here is not with PostGIS per se, but with the SQL statement
and what Qgis expects. When Qgis loads a table from postgres, it wants
there to be a column named OID.
You can do this by creating a view that includes an OID column -
although this is most easily done if your
Regina ,
thanks, very much for your help.
with this sentence I resolve the problem
DATA geoloc from consejospopulares USING UNIQUE gid
Best Regards,Salas
- Original Message -
From: Paragon Corporation [EMAIL PROTECTED]
To: 'PostGIS Users Discussion'
Hi,
maybe your instalation of postgis functions and etc are not in postgres db.
If you are using windwos search for others databases, maybe a postgis or
postgis_template. At that databases you will find the the functions.
If you are using linux then you will have to add that functions to some
I tried one thing:
I create a new table in the database including PostGIS functions. This query
is CORRECT now:
SELECT addgeometrycolumn('public','tablenew','the_geom',23030,'POINT',2)
The problem right now is... How can I import the PostGIS functions into my
DATABASE??
The function is
The easiest way is to create your database using the template_postgis as
the template database.
The after the fact way is to execute the SQL script located at
\Program Files\PostgreSQL\8.3\share\contrib\lwpostgis.sql (For windows
installations)
-Original Message-
From: [EMAIL
Hi,
How I can obtain the X,Y coordinates in one Multipoint table.
When I try to execute this
select ST_X(geoloc), ST_Y(geoloc) from consultorios
PostgreeSql/Postgis show the error
ERROR: Argument to X() must be a point
ERROR: Argument to X() must be a point
Best Regards,Salas
Okay this is a bit dated now, but I needed to get everything entered
correctly before proceeding. The point-in-polygon method you referenced
is what I'm looking for and searching for good examples of implementing
this has not yielded good results. This is most likely due to my
ignorance is
¡Hola Javier!
Maybe you did not create your database properly...
from http://www.postgis.org/documentation/
createlang plpgsql postgres
psql -d postgres -f lwpostgis.sql
psql -d postgres -f spatial_ref_sys.sql
the two scripts could be in a number of places on your system: if you
built postgis
Thanks, Kevin
Now being working very good
Best Regards,Salas
- Original Message -
From: Kevin Neufeld [EMAIL PROTECTED]
To: fsalas [EMAIL PROTECTED]; PostGIS Users Discussion
postgis-users@postgis.refractions.net
Sent: Wednesday, August 27, 2008 1:09 PM
Subject: Re: [postgis-users]
Hai.., I was on a tour, so that I couldn't reply promptly. Please excuse me.
2008/8/24 Paragon Corporation [EMAIL PROTECTED]
If you haven't considered it already, PgRouting might be something to
look at for the shortest route to a place functionality.
http://pgrouting.postlbs.org/
Thank
Hai..,
2008/8/24 Sandeep Kumar Jakkaraju [EMAIL PROTECTED]
u can even think of geocoding some nice pictures and videos
...that might make it interesting for some one like me
It is developed as a decision support system for plan/development activities
for a rural local authority.
21 matches
Mail list logo