[postgis-users] Points with in multiple Polygons

[Burgholzer,Robert]

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
rwburgholzer at deq.virginia.gov
804-698-4405
Open Source Modeling Tools:
http://sourceforge.net/projects/npsource/

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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
<rwburgholzer at deq.virginia.gov> 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
>  rwburgholzer at deq.virginia.gov
>  804-698-4405
>  Open Source Modeling Tools:
>  http://sourceforge.net/projects/npsource/
>
>
>  -----Original Message-----
>  From: postgis-users-bounces at postgis.refractions.net
>  [mailto:postgis-users-bounces at postgis.refractions.net] 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
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users