Hi Zhang,
There is no problem.
This is the ewkb format used by postgis in order to storing geo data.
Use the astext() function if you want to see you data in human
readable format (wkt)
select astext(the_geom) from pt_gsqy_point;
it should be good! :)
Quoting zhengyong zhang <[EMAIL PRO
hello
first i converted the shape files with shp2pgsql to sql files, then i tried to
import them into postgis. some imports give this error message:
FEHLER: geometry contains non-closed rings
somebody know how to find the non working lines in a reasonable time? it's
senseless work to insert t
back slash wrote:
hello
first i converted the shape files with shp2pgsql to sql files, then i tried to
import them into postgis. some imports give this error message:
FEHLER: geometry contains non-closed rings
somebody know how to find the non working lines in a reasonable time? it's
sensel
Hi
I have searched the forum but am still confused about the geometry_columns
table. Importing and deleting PostGIS layers doesn't seem to have an effect
on the geometry_columns table, very strange as this is a GIS catalog to the
spatial database.
I require this table (geometry_columns) to be up
Those tables are only modified by PostGIS using the following functions
or by direct user intervention (yes you can modify it directly and I do
when I'm creating views since there is currently no way to make the
table add a view)
The postgis functions I know of that update that table are the
foll
I have a table with foll fields( the_geom, name, latlon, )...i wanted to
make a polygon by using those points whose name like 'abc' and put it in the
map...
how to do dis?
--
View this message in context:
http://www.nabble.com/makepolygon-with-geom-info-tp18214128p18214128.html
Sent from th
Try
Are each of your the_geom single point geometries?
If so I think you can do something of the form
SELECT Max(f.gid) as newgid, ST_MakePolygon(ST_MakeLine(f.the_geom)) As
newgeom, f.name
FROM (SELECT gid, the_geom FROM foll ORDER BY name, gid) As f
WHERE f.name = 'abc'
GROUP BY f.name
Alth
You can also do this with ogr2ogr - http://fwtools.maptools.org/
If you have a personal geo database format and you are on windows, then you can
just specify the file path to the mdb something of the form
ogr2ogr -append -f "PostgreSQL" PG:"host=pghost user=pgloginname
dbname=pgdbname password
Thanks everybody for the heads up! Finally my installation worked out. I had problems
cause I installed everything from the sources except proj.4 (used an rpm package). After
installing proj.4 from the sources, and after adding the /usr/local/lib path to the
LD_LIBRARY_PATH env., it seems as if
exportSQL v3.2 does a really good job at this (Access VBA Macro).
http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt
If I recall correctly, it did not work out-of-the-box and I tuned it a
bit to suit my needs and to correct some things that had changed in
postgres ('DATETIME' -> 'TIMEST
I'm searching for a Postgis enabled web host and noticed the 2006
discussion of this topic on this list. Is there a more recent
discussion that I've missed? Is anyone on this list happy with their
Postgis enabled web host? Thanks.
___
postgis-users
I'm searching for a PostGIS enabled web host and noticed the 2006
discussion of this topic on this list. Is there a more recent
discussion that I've missed? Is anyone on this list happy with their
PostGIS enabled web host? Thanks.
___
postgis-users
It looks like HostGIS offers PostGIS, along with MapServer and some
other OS GIS software.
http://www.hostgis.com/
David.
On Tue, Jul 1, 2008 at 11:26 AM, Donald Ijams <[EMAIL PROTECTED]> wrote:
> I'm searching for a PostGIS enabled web host and noticed the 2006 discussion
> of this topic on thi
I am using HostGIS and have been very happy with it. I think there is a
new version coming out soon.
Bruce Rindahl
David Fawcett wrote:
It looks like HostGIS offers PostGIS, along with MapServer and some
other OS GIS software.
http://www.hostgis.com/
David.
On Tue, Jul 1, 2008 at 11:26 AM,
Hello,
I am interested in the SQL-MM Part 3 geometries, especially CIRCULARSTRING.
Playing a bit around I noticed the following:
- Storing and retrieving of CIRCULARSTRING instances seems to work fine
- Spatial predicates (I tested ST_Intersects) don't seem to be supported yet
- Index based quer
Support for CIRCULARSTRING is there. Loading and retrieving of the
supported curved geometries should scale to large numbers perfectly
well, but not all the SQL-MM geometries are currently supported. In
particular, PostGIS was choking when I attempted to implement curved
polygons. Index supp
I have translated some polygon data into a PostGIS table using FME. The
translation was successful with no errors reported. All the records appear
in the PostGIS table (using the pgAdminIII application) except for about 90%
of the geometries (see image below).
http://www.nabble.com/file/p18227858
On Tue, Jul 1, 2008 at 10:08 AM, Donald Ijams <[EMAIL PROTECTED]> wrote:
> I'm searching for a Postgis enabled web host and noticed the 2006 discussion
> of this topic on this list. Is there a more recent discussion that I've
> missed? Is anyone on this list happy with their Postgis enabled web ho
Geoff,
This earlier thread may be of interest:
http://postgis.refractions.net/pipermail/postgis-users/2008-March/018814.html
It deals with limitations of pgadmin and postgis.
If the geometries really are null, are you also able to try loading the
data with ogr2ogr to see if you get the same resu
Hi Tim,
First of all I can confirm that the geometries are not null by:
a) select count(*) from where geom is null;
This returns a count of 0.
b) the FME Universal Viewer successfully displays all the geometries
successfully. Features can be graphically selected and their attributes
On Tue, 2008-07-01 at 20:28 -0700, geoffi wrote:
> Hi Tim,
>
> First of all I can confirm that the geometries are not null by:
>a) select count(*) from where geom is null;
>This returns a count of 0.
>b) the FME Universal Viewer successfully displays all the geometries
> successf
Hi Tim,
OK to clarify...
I have 694 records in my table, all have geometry based on the query:
select count(*) from gen_poly
where ST_IsValid(geom);
count
---
694
(1 row)
When viewed in pgAdminIII only a handfull "appear" to have actual data in
the geo
I tried that but its givin the error as f.gid doesnt existin the 2nd
query..while the first query was fine ..it just said that lwshell doesnt
exist..as the start n end points r different..
--
View this message in context:
http://www.nabble.com/makepolygon-with-geom-info-tp18214128p182306
On Tue, 2008-07-01 at 21:53 -0700, geoffi wrote:
> Hi Tim,
>
> OK to clarify...
> I have 694 records in my table, all have geometry based on the query:
> select count(*) from gen_poly
> where ST_IsValid(geom);
>
>count
>---
> 694
> (1 row)
Ok, that's
Sorry I had a typo - try the below instead:
SELECT Max(f.gid) as newgid, f.name,
ST_MakePolygon(ST_MakeLine(f.the_geom)) As newgeom
FROM (SELECT name, 0 as psort, gid, the_geom
FROM foll
UNION ALL
SELECT fs.*
FROM
(SELECT D
Hi Tim,
We may be getting closer...
I played with 2 records as shown in the following picture...
http://www.nabble.com/file/p18231274/two_records.jpg
The first record is "good" with a geometry displayed.
The second record is "bad" with no apparent geometry, although FME says it's
there.
Usin
26 matches
Mail list logo