It Works!!! Thanks!! I might one day want to remove the "the_geom" is that hard to do.
Thanks On Tue, May 6, 2008 at 1:43 PM, Burgholzer,Robert <[EMAIL PROTECTED]> wrote: > You probably need the name of your database in the command line call > with the "-d" switch. > > > Robert W. Burgholzer > Surface Water Modeler > Office of Water Supply and Planning > Virginia Department of Environmental Quality > [EMAIL PROTECTED] > 804-698-4405 > Open Source Modeling Tools: > http://sourceforge.net/projects/npsource/ > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > chris brisendine > > > Sent: Tuesday, May 06, 2008 1:25 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Points with in multiple Polygons > > I get a relation "nqaatt" does not exist. I changed the sql to show > storm cells in the tornadowarning, it works fine in the pgAdmin III > tool area here is the sql statement > > SELECT DISTINCT ON (ncities.name) > ncities.name, ncities.the_geom > FROM ncities INNER JOIN torpoly ON ST_Within(ncities.the_geom, > torpoly.the_geom) > ORDER BY ncities.name > > the command I am using is psql -f run.psql > > > > > > On Tue, May 6, 2008 at 12:12 PM, Burgholzer,Robert > <[EMAIL PROTECTED]> wrote: > > You want to run that command with the "-f" switch, the "-c" switch is > > for a single command, not a script file. > > > > HTH > > > > Robert W. Burgholzer > > Surface Water Modeler > > Office of Water Supply and Planning > > Virginia Department of Environmental Quality > > [EMAIL PROTECTED] > > 804-698-4405 > > Open Source Modeling Tools: > > http://sourceforge.net/projects/npsource/ > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > chris brisendine > > > > > > Sent: Tuesday, May 06, 2008 11:35 AM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] Points with in multiple Polygons > > > > Great Idea on the tornado intersect it does from time to time! It > > worked great ! thanks, maybe one day it can save a life, If i wanted > > to run the query from the command line would i use the psql -c > > run.psql to output a list to a txt file? im getting a error with that > > ERROR: syntax error at or near "run" at character 1 > > LINE 1: run.psql > > Thanks alot your time is very appreciated! > > > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
