Hi,
We've managed to solve the problem with the cookie cutter. The quick (and quite
smart) solution was to generate a buffer of the geometries of 0 distance,
thereby creating the buffer around all the geometries, lines and polygons, thus
rendering insignificant the linestring problem.
Hi,
I have installed a database on the standard tablespace, but the database grows
fast and there's no more space on the partition available.
So I've created another tablespace on another partition. Is it possible to move
my existing database to this new tablespace? If yes, what steps have to
Hi
I am trying to update an attribute field within a polygon with data held in a
attribute field associated with a point. The polygon that needs updating
contains the point holding the update data. Both the polygon and point data is
contained within a single table containing a single
On Tue, 2007-11-20 at 14:53 +0530, [EMAIL PROTECTED] wrote:
Thanks Paul. We are already using multiple instances of geoservers with
single postgis server. (We are starting new geoserver dynamically based
on the load). At this point, I don't have enough load to saturate the
database but I
Finding the maximum distance between two polygons from a set is going to
be very slow. Also, there's no built-in function to do this, so you'd
have to code it up yourself.
It would be faster to find the bounding box of all the geometries and
use that to determine a visibility area.
Kevin
Hi,
I am very new to PostGIS, please bear with me. I've had a lot of help
from #postgis on IRC but I continue to have trouble and hope someone
here can assist.
I have two data sets from the UK Ordnance Survey which when imported
to PostGIS and plotted are not matching up:
Hello!
I have to find out which polygons have the longest distance between any
two polygons (or points of them) from a set of multiple polygons. For
example:
I have 5 polygons.
Find out where's the biggest distance between them and give back the two
points.
I need this to be able to zoom
Unfortunately, PostgreSQL does not yet have the command ALTER DATABASE
SET TABLESPACE new_tablespace (I don't see it in v.8.3 either).
The easiest solution I think is to simply create a new database using
your current database as a template in your new tablespace.
From the command line:
Hello All,
I'm trying to populate a newly-added geometry column in a table using
two existing columns: LON, LAT. The only way I see to do it seems a
little clumsy:
update grid_points set SHAPE = GeomFromText('POINT(' || lon ||' ' ||
lat || ')',4326);
Is there a better way than
Yes, clustering your table based on your GIST index does help because it
physically orders the rows in your table based on the spatial index.
The disk head won't have far to move to retrieve the next page.
I've worked with a table of about 170 million points (not as large as
your 300m :) )
ST_SetSRID( ST_MakePoint(lon, lat), 4326)
http://postgis.refractions.net/docs/ch06.html
-- Kevin
John Cartwright wrote:
Hello All,
I'm trying to populate a newly-added geometry column in a table using
two existing columns: LON, LAT. The only way I see to do it seems a
little clumsy:
Dear all,
Ok, it has taken me ages to find a solution to what should be a simple
task. I have written a pg/plsql function to do this, and I'd like to know
where I've gone wrong, if I have. I'm not a mathematician.
I think the function will work with conformal coordinate systems, however
I'd
On Mon, 2007-11-19 at 22:40 +0100, Ivan Mincik wrote:
thanks a lot. these wrong are coming from some special format of
cadastral data in my country. data where first saved to ESRI
shapefile by OGR, then imported to postgis by shp2pgsgl. I think that
they are invalid also for the shapefile.
On Tue, 2007-11-20 at 18:40 +0100, Christoph Stasch wrote:
Hi,
I am using PostgreSQL 8.2 together with PostGIS 1.2.1. and I have a
problem with the EXTENT function of PostGIS:
POINT(-86.644724 34.725302) and POINT(-86.644724 34.725183) are
contained in the geom column of myTable.
If
Hi,
On Tue, 2007-11-20 at 07:44 -0700, Rob Nagler wrote:
Aha! http://postgis.refractions.net/rpms/ is out of date. I just
downloaded the srpm assuming it was the latest. It hasn't been
updated since 1/4/06, and binary RPMs for Fedora have not been updated
either.
Heh. I lost my webdav
Currently I am working on an Open Source GIS project and was looking for
some advice on which way to go with it.
What I am trying to do is use an openlayers front end which is queryable and
searchable to display custom geodata (raster and vector) of our business
using Google Maps as the backdrop.
Hello,
because i'm very new to the postgis topic, i want to know where to find
informations about handling 3D geometry in Postgis.
I found out that i can store 3D points, polygons and so on without any
problems.
What i want to know is are operations like intersect working for these
3D objects
17 matches
Mail list logo