hi,i have this table:
CREATE TABLE pois(
uid integer not null,
name VARCHAR(128),
catcode VARCHAR(32) not null,
catname VARCHAR(32),
others VARCHAR(32)
);
SELECT AddGeometryColumn('pois', 'location', 4214, 'POINT', 2);
and then in my codes,i use this invoke to get location column i
Hi all,
I just wanted to mention for those interested that a new driver has landed in
GDAL/OGR svn trunk (target release : 1.8.0). It is called PGDump and offers
features quite similar to the PostGIS shp2pgsql utility, that is to say the
capability of dumping the INSERT / COPY statements into a
On 14 May 2010 10:21, rakesh modi wrote:
> hi,
> i am using select query which is shown below
> SELECT sum(length(the_geom))/1000 AS km_roads FROM routable;
> and get error like -
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
what
El Friday 14 May 2010, rakesh modi escribió:
> hi,
> i am using select query which is shown below
> SELECT sum(length(the_geom))/1000 AS km_roads FROM routable;
> and get error like -
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
I usu
hi,
i am using select query which is shown below
SELECT sum(length(the_geom))/1000 AS km_roads FROM routable;
and get error like -
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
--
Rakesh Modi
Software Engineer
GIS Consortium
_
Drop the opts from the parentheses for geog I think.
On 14/05/2010, at 5:14 PM, rakesh modi
wrote:
Hi All,
I am newer to use postgres.
I get an error using this query :- operator class
"gist_geometry_ops" does not accept data type geography
when i run query :-
CREATE INDEX geom_idx ON
Hi All,
I am newer to use postgres.
I get an error using this query :- operator class "gist_geometry_ops" does
not accept data type geography
when i run query :-
CREATE INDEX geom_idx ON routable USING GIST(the_geom GIST_GEOMETRY_OPS);
What's the problem
--
Rakesh Modi
Software Engineer
GIS Con