[postgis-users] Points with in multiple Polygons

[chris brisendine]

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
<rwburgholzer at deq.virginia.gov> 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
>  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
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>