Re: [postgis-users] Intersection query problem
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.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 INNER JOIN extents.tiles ON ST_Intersects(extents.tiles.the_geom, source.track_cl.the_geom) WHERE extents.tiles.name='BP33' ) As clipped WHERE st_geometrytype(clipped.clipped_geom) = st_geometrytype(source.track_cl.the_geom); cheers Ben On 11/05/2011, at 11:15 AM, George Washington wrote: > 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 > INNER JOIN extents.tiles > ON ST_Intersects(extents.tiles.the_geom, source.track_cl.the_geom) where > extents.tiles.name='BP33' ) As clipped > WHERE st_geometrytype(clipped.clipped_geom) = > st_geometrytype(source.track_cl.the_geom); > > which gives me: > > ERROR: missing FROM-clause entry for table "track_cl" > LINE 6: ...metrytype(clipped.clipped_geom) = st_geometrytype(source.tra... > SQL state: 42P01 > Character: 471 > > > On the other hand this version of the same query works (only the last line > differs): > > 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 > INNER JOIN extents.tiles > ON ST_Intersects(extents.tiles.the_geom, source.track_cl.the_geom) where > tiles.name='BP33' ) As clipped > WHERE ST_Dimension(clipped.clipped_geom) >0; > > I cannot figure out what is wrong with the first query. > Many thanks. > George > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Intersection query problem
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 INNER JOIN extents.tiles ON ST_Intersects(extents.tiles.the_geom, source.track_cl.the_geom) where extents.tiles.name='BP33' ) As clipped WHERE st_geometrytype(clipped.clipped_geom) = st_geometrytype(source.track_cl.the_geom); which gives me: ERROR: missing FROM-clause entry for table "track_cl" LINE 6: ...metrytype(clipped.clipped_geom) = st_geometrytype(source.tra... SQL state: 42P01 Character: 471 On the other hand this version of the same query works (only the last line differs): 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 INNER JOIN extents.tiles ON ST_Intersects(extents.tiles.the_geom, source.track_cl.the_geom) where tiles.name='BP33' ) As clipped WHERE ST_Dimension(clipped.clipped_geom) >0; I cannot figure out what is wrong with the first query. Many thanks. George ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] [postgis-devel] Change in PSC
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.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Change in PSC
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 PostGIS user support and colorful examples, the automatic building of the tars and PDFs, our buildbot setup, the general template of the functions in the docbook which made it trivial to generate postgresql help, the automatic generation of images for the documentation from WKT, and many maintenance functions such as populate_geometry, we owe to him. We will miss him greatly and hope to see him come back again in the future. With that said, we have been discussing who best to fill the void he left behind. We decided we need two new members because the PostGIS community is growing and the code base is growing along with it. Our two nominations are: Sandro Santilli (aka strk) -- strk has been a long time member of both PostGIS and GEOS development team and has been working tirelessly to make the PostGIS 2.0 release a success on all avenues. He's been working on topology, GEOS integration, general PostGIS bug fixing and even a little work on raster. He's a top notch C/C++ programmer. Chris Hodgson -- is a long time developer at Refractions and the PostGIS project. He has graciously stepped in to take on the chores that Kevin managed such as making sure postgis.org is in good shape and fixing buildbot issues. In addition to that he has started getting his hands dirty again with bug fixes. If that were not enough he has been working tirelessly to finish all the loose items needed to graduate PostGIS from an incubation project of OSGeo to a full fledged OSGeo project. We think he will serve as a great asset to our PSC. We ask Sandro and Chris now if they accept our offer to join the PSC? Furthermore if anyone has any other thoughts or objections in the matter, please speak now. PostGISly yours, The PostGIS PSC Team: Mark Cave-Ayland Paul Ramsey Regina Obe ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] postgis-1.5.2 build failure on HP-UX
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 '^#'> postgis.sql.incc: error > > >1914: bad form for `-t' optionmake[1]: *** [postgis.sql.in] Error > > >1make[1]: *** Deleting file `postgis.sql.in'make[1]: Leaving directory > > >`/home/edb/AS90/postgis/postgis-1.5.2/postgis' > > > > > >To fix it, I just removed the -traditional-cpp option that is related to > > >GCC. Build seems fine. It can be compiled with non gcc compilers then why > > >is there option "-traditional-cpp" hard coded related to GCC. Thanks. > > > > I think Sandro was the person who did this part of the build system, so > > perhaps he may know? > > I see that actually -traditional-cpp flag is now handled by configure > script, so should likely be taken out from out use of it. > > I'll take a look. So, if I take -traditional-cpp out, I get tons of these: warning: missing terminating ' character Which is basically everytime a line ends before a quote is closed. That said, it'd surely be better not to use a "C" preprocessor for something which isn't "C"... --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] postgis-1.5.2 build failure on HP-UX
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 postgismake[1]: Entering directory > >`/home/edb/AS90/postgis/postgis-1.5.2/postgis'cc +DD64 -Ae -E > >-traditional-cpp postgis.sql.in.c | grep -v '^#'> postgis.sql.incc: error > >1914: bad form for `-t' optionmake[1]: *** [postgis.sql.in] Error > >1make[1]: *** Deleting file `postgis.sql.in'make[1]: Leaving directory > >`/home/edb/AS90/postgis/postgis-1.5.2/postgis' > >To fix it, I just removed the -traditional-cpp option that is related to > >GCC. Build seems fine. It can be compiled with non gcc compilers then why > >is there option "-traditional-cpp" hard coded related to GCC. Thanks. > > I think Sandro was the person who did this part of the build system, so > perhaps he may know? I see that actually -traditional-cpp flag is now handled by configure script, so should likely be taken out from out use of it. I'll take a look. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] postgis-1.5.2 build failure on HP-UX
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 +DD64 -Ae -E -traditional-cpp postgis.sql.in.c | grep -v '^#'> postgis.sql.incc: error 1914: bad form for `-t' optionmake[1]: *** [postgis.sql.in] Error 1make[1]: *** Deleting file `postgis.sql.in'make[1]: Leaving directory `/home/edb/AS90/postgis/postgis-1.5.2/postgis' To fix it, I just removed the -traditional-cpp option that is related to GCC. Build seems fine. It can be compiled with non gcc compilers then why is there option "-traditional-cpp" hard coded related to GCC. Thanks. I think Sandro was the person who did this part of the build system, so perhaps he may know? I also think that we should move away from using cpp and move the #ifdef function logic into the main .c files so that they elog ERROR if they are called on a server that doesn't have the necessary library. This would also help my hacked up CMake build system I started working on a while back... ATB, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS Error: Loading with SPIT-Plugin-> MULTINULL
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 regarded as
quite old builds of all the architecture - there may well have been bugs that
are long since fixed. If you can try on a more modern set of tools, you might
have more luck.
good luck.
cheers
Ben
On 10/05/2011, at 4:19 PM, Florian Reimer wrote:
> 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 ones are:
> GEOMETRY, GEOMETRYCOLLECTION, POINT,
> MULTIPOINT, POLYGON, MULTIPOLYGON,
> LINESTRING, MULTILINESTRING,
> GEOMETRYCOLLECTIONM, POINTM,
> MULTIPOINTM, POLYGONM, MULTIPOLYGONM,
> LINESTRINGM, or MULTILINESTRINGM
> CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 ,
> $6 )"
> PL/pgSQL function "addgeometrycolumn" line 4 at select into variables
>
> There might be some error with Geometry, though the file works fine in QGIS
> and ArcGIS. Anyone had this problem before and might know something about it?
>
> We are using:
>
> PostGIS
> Library: 1.1.6
> Scripts: 1.1.6
> GEOS: 3.0.0-CAPI-1.4.1
> Proj: Rel. 4.6.0, 21 Dec 2007
>
> PostgreSQL 8.1.19 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2
> 20061115 (prerelease) (Debian 4.1.1-21)
>
> Thank you very much!
> Florian
>
>
> --
> Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
> belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] PostGIS Error: Loading with SPIT-Plugin-> MULTINULL
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 ones are:
GEOMETRY, GEOMETRYCOLLECTION, POINT,
MULTIPOINT, POLYGON, MULTIPOLYGON,
LINESTRING, MULTILINESTRING,
GEOMETRYCOLLECTIONM, POINTM,
MULTIPOINTM, POLYGONM, MULTIPOLYGONM,
LINESTRINGM, or MULTILINESTRINGM
CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 ,
$6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at select into variables
There might be some error with Geometry, though the file works fine in QGIS and
ArcGIS. Anyone had this problem before and might know something about it?
We are using:
PostGIS
Library:1.1.6
Scripts:1.1.6
GEOS: 3.0.0-CAPI-1.4.1
Proj: Rel. 4.6.0, 21 Dec 2007
PostgreSQL 8.1.19 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115
(prerelease) (Debian 4.1.1-21)
Thank you very much!
Florian
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
