: PostGIS Users Discussion
Subject: Re: [postgis-users] Help with query
Hi Regina
Many thanks to your prompt answer, the query works great now! In my
query the coordinates were in Plate Carree metres and I think I confused
myself with the transform function. Much appreciated, any news on the
to:
> postgis-users-boun...@postgis.refractions.net] *On Behalf Of *mark balman
> *Sent:* Tuesday, March 10, 2009 7:04 AM
> *To:* postgis-users@postgis.refractions.net
> *Subject:* [postgis-users] Help with query
>
> Hi all
>
> I am trying to create a query that returns t
: postgis-users@postgis.refractions.net
Subject: [postgis-users] Help with query
Hi all
I am trying to create a query that returns the features intersected by a
user defined area. I can do this with the following query which works
fine and returns what I want:
select areaname, country
FROM pas_n
Hi all
I am trying to create a query that returns the features intersected by a
user defined area. I can do this with the following query which works fine
and returns what I want:
select areaname, country
FROM pas_nat_iv_pnt
where ST_Intersects(pas_nat_iv_pnt.the_geom ,
ST_GeomFromText('POLYGON((
users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Todd
Fagin
Sent: Tuesday, December 30, 2008 9:46 AM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Help with query
Greetings,
I am rather new to PostGIS and somewhat new to SQL, so please
Greetings,
I am rather new to PostGIS and somewhat new to SQL, so please bear with me.
I have a question about a query. I have two spatial tables, OK_Cites and
OKCounties. The former is a list of various cities and towns in Oklahoma
and the latter is all of the counties in Oklahoma. Whi
Hi All
I have managed to resolve the query with the following suggestion - thanks
to Rob Burgholzer's suggestion to use UNION
Keeping this simple, I kept the following Layer for selecting the polygon
features within the specified distances defined in the class expressions
DATA "the_geom FROM (SE
artment 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 mark
balman
Sent: Tuesday, December 09, 2008 11:53 AM
To: postgis-
Hi All
I am trying to create a query that uses a mouse click to get coordinates
(from mapserver) and then features within a specified distance are selected
and displayed in different colours. The query I have at the moment works
well, however, the problem I am trying to solve is how to indicate th
Many thanks Regina for your help,
I wondered why I was using OGR - I guess I got confused as I was trying
this earlier with joining a shapefile dbf to postgresql, which is where
my problem arose! I will figure this out over the next few days.
Thanks again
Mark
___
, 2008 2:01 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Help with query
Hi All
I am currently trying to create a query to pass through to mapserver but am
having a problem. Here is my scenario:
Two tables in postgresql
A quarter degree grid with 273600 records (spatial
Hi All
I am currently trying to create a query to pass through to mapserver but
am having a problem. Here is my scenario:
Two tables in postgresql
A quarter degree grid with 273600 records (spatial geometry) with GiST index on
the geometry and a btree index on FID
A species table with 10 mil
12 matches
Mail list logo
