also make sure Mapserevre connects as a UTF-8 client to PG by satining
including in the CONNECTION object:
options='-c client_encoding=UTF8'
--
Barend Köbben
International Institute for Geo-Information
Sciences and Earth Observation (ITC)
PO Box 6
7500AA Enschede, The Netherlands
+31 (0)53
On Thu, 2008-04-03 at 20:31 -0400, Stephen Frost wrote:
Jonathan,
* Jonathan W. Lowe ([EMAIL PROTECTED]) wrote:
...And in case the images don't persist through the mail server, they're
viewable at: http://www.giswebsite.com/demos/tiger_overlays.html
You know, I just realized that you
On Fri, Apr 4, 2008 at 11:01 AM, Jonathan W. Lowe [EMAIL PROTECTED] wrote:
On Thu, 2008-04-03 at 20:31 -0400, Stephen Frost wrote:
Jonathan,
* Jonathan W. Lowe ([EMAIL PROTECTED]) wrote:
...And in case the images don't persist through the mail server, they're
viewable at:
Hi all,
I'm in the phase of evaluating an upgrade of postgres/postgis from
8.1.4/1.1.2 to 8.3.X/1.3.2.
But while testing, I ran into trouble with one of the queries that worked
before
Now I have postgresql-8.3.1.tar.bz2 or postgresql-8.3.0.tar.bz2, and
proj-4.6.0.tar.gz, postgis-1.3.2.tar.gz,
This is a known issue which is fixed in the postgis-svn version. Use
that instead of 1.3.2. I think 1.3.3 will be out soon too that will
have the patch in it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Sebastian Reitenbach
Sent: Friday, April 04,
Stephen,
Changing the subject on this thread.
Have look into using inherited tables? This would allow you to have a
nation view or a state view of the county data. View being used in the
literal not postgres in this case.
create table us_tiger.blocks ;
create table ST_tiger.blocks
Stephen,
* Stephen Woodbridge ([EMAIL PROTECTED]) wrote:
Have look into using inherited tables? This would allow you to have a
nation view or a state view of the county data. View being used in the
literal not postgres in this case.
Honestly, I havn't. I'm really not all that keen on
* Paul Ramsey ([EMAIL PROTECTED]) wrote:
Look at constraint exclusion as a strategy...
Yes, certainly this approach will be taking advantage of constraint
exclusion.
http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html
It actually *does* use inheritance, but it does fancy
The only caveat there is that constraint exclusion only works with range
queries and range constraints or at least I haven't had success getting
it work with spatial indexes.
So if you put a constraint on state code or something of that sort, it
will work great. But for super performance a
Interestingly enough there does appear to be some speed benefit (at
least I've noticed) with using inheritance even without constraint
exclusion. My guess is something along the line of parallel reads.
I'd be interested in real, repeatable, performance metrics which show
this. Certainly I'm
Hi all,
I have spent the last three hours trying to find a plain-English
description of how you change the projection of a PostGIS layer, and I
am now giving up. I have found quite a few questions about this on the
internet, but not a single answer that allows for a newbie to SQL. Every
Hi again,
As a follow-up to the last question, I would like to know - and please
assume here my utmost stupidity as I have only recently come from the
GUI world of ArcGIS - how do you add a column to a PostGIS layer that
automatically calculates the area of each polygon feature in the layer?
select ST_Transform( the_geom, 26911) from california_counties;
If you want it to be readable, you will need to convert it to text:
select ST_AsText( ST_Transform( the_geom, 26911 ) ) from california_counties;
Hope this helps.
On Fri, Apr 4, 2008 at 6:57 PM, Marcus C. England
[EMAIL PROTECTED]
On Fri, Apr 04, 2008 at 10:03:10PM -0400, Paul Tomblin wrote:
Sorry about the off topic posting, but does anybody know a cleaner way to
convert a Unix time_t date to timestamp than
select '1970-01-01'::timestamp + interval '1207360519 seconds';
The above is wrong unless you always want
14 matches
Mail list logo
