George,
You need to put source.track_cl into the table list for your query...
hint - it is in the table list for your sub-select, but not for the main query,
I know some people scorn indenting, but :
SELECT gid, name, track_use, st_astext(clipped_geom)
FROM (
SELECT source.track_cl.
Hi, I have the following query:
SELECT gid, name, track_use, st_astext(clipped_geom)
FROM (SELECT source.track_cl.gid, source.track_cl.name,
source.track_cl.track_use,(ST_Dump(ST_Intersection(extents.tiles.the_geom,
source.track_cl.the_geom))).geom As clipped_geom
FROM source.track_cl
On Tue, May 10, 2011 at 02:34:37PM -0400, Paragon Corporation wrote:
> We ask Sandro and Chris now if they accept our offer to join the PSC?
I'm glad to join the PSC.
You guys seem to have lots of fun in your meetings :)
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.ke
It is with great sadness that we report the stepping down of Kevin Neufeld
as a PSC member. Unfortunately Kevin has new obligations occupying most of
his time
that he felt it would be best for all if he stepped down.
He was a great asset to our group. A good chunk of the documentation,the
Pos
On Tue, May 10, 2011 at 05:02:32PM +0200, Sandro Santilli wrote:
> On Tue, May 10, 2011 at 02:58:07PM +0100, Mark Cave-Ayland wrote:
> > On 06/05/11 17:47, MUHAMMAD ASIF wrote:
> > >`/home/edb/AS90/postgis/postgis-1.5.2/postgis'cc +DD64 -Ae -E
> > >-traditional-cpp postgis.sql.in.c | grep -v '^#'
On Tue, May 10, 2011 at 02:58:07PM +0100, Mark Cave-Ayland wrote:
> On 06/05/11 17:47, MUHAMMAD ASIF wrote:
>
> >I am trying to build 64 bit binaries for postgis-1.5.2 on HP-UX B.11.31
> >(ia64 hp Integrity rx2800 i2). HP compiler was giving the following error
> >message i.e.
> >make -C postgis
On 06/05/11 17:47, MUHAMMAD ASIF wrote:
I am trying to build 64 bit binaries for postgis-1.5.2 on HP-UX B.11.31 (ia64
hp Integrity rx2800 i2). HP compiler was giving the following error message i.e.
make -C postgismake[1]: Entering directory
`/home/edb/AS90/postgis/postgis-1.5.2/postgis'cc +DD
Florian,
I've never used SPIT, but I'm sure you can see that there is no geometry type
in postgis known as MULTINULL. I suspect you might be better to follow this up
with the qgis mailing lists.
Does it work using shp2pgsql?
As a second observation, you are using what I think would now be reg
Hello,
we have a large Multipolygon Shapefile and try to load it from QGIS into
PostGIS via the SPIT-Plugin. The file is recognized only as MULTINULL while it
should be MULTIPOLYGON.
SELECT AddGeometryColumn('public','PA-Prop','the_geom',32617,'MULTINULL',2)
ERROR: Invalid type name - valid o