Sorry I can't understand what you are trying to do !
what is your data :
line, poly?
is it topological (if yes how did you build it?).
What is the problem you are trying to solve ? (snapping in the topology
model, or snapping of your non topological data?).
You seems to begin in plpgsql, may I
Remi –
Thanks. I am trying to generate nodes I think based on endpoints. A separate
list of nodes does not exist at the onset of this procedure. At least, that is
my perception.
I included the following at the bottom of the function:
END$$;'
EXECUTE 'return ' ||
Hi Nicolas,
Thanks for the detailed description that make the unclear clear...
Now I feel ready to implement ...
Your support is a great example for the strength of the open source
community ...
BR.
Ofer
On Tue, Feb 10, 2015 at 11:07 AM, Nicolas Ribot nicolas.ri...@gmail.com
wrote:
Hi
Hi Ofer,
Some precisions regarding the query I sent:
A topoGeometry objects stores the following information (
http://postgis.net/docs/manual-2.1/topogeometry.html):
• topopology_id: id of the topology, as stored in the Topology metadata
• layer_id : the id of the layer in the topology
• id:
Hmm, any thoughts on this? Just to expand my use case: I have a time series of
images that are all spatially aligned, i.e. same size, geo-location, pixel
spacing, projection.
Thus, raster2pgsql -R would always create the same tiled raster entries for
each image where only the (binary) file name
Hey,
nice project =)
If you use something like qgis, each user can easily have a dozen
connection open to server, so with 10 users, you may need to use something
like pgpool.
About hardware dimension, it is more a question for postgres list.
You may stress that your usage is probably mostly
Bborie,
In the meantime, I managed to use postgresql overlay to change the filename in
the rast, but this results in a bytea which cannot be cached back to a raster.
I found a 2013 thread
http://lists.osgeo.org/pipermail/postgis-users/2013-June/037163.html which
asked for bytea - raster
The input data consists of (millions) of digitized line strings. Despite
efforts to avoid gaps at the endpoints, gaps do occur. This function is
reconcile the slight differences (within a tolerance) and queue the others for
review and edit.
The actual conversion from unconnected linestrings
Hey Rémi,
Thanks for the feedback! Exactly the type of information I'm looking for.
Before commenting further, if anyone has another experience about such a
multi-user PostGIS server in a small unit, please feel free to share! The
more I get from actual users, with different experience and
Others gave lots of good feedback, but let me chime in.
* I didn't know about pgpool. It looks like it may come in handy if there
connections become sluggish or simply impossible due to too many users. I
will definitely keep this under my hat, although I understand it is a
UNIX-only
Hi,
I am a newbie to Postgres/PostGIS and have a long running query that I would
like to optimize.
There are two tables (trip and zone) that I am joining in the query, one which
has startloc and endloc columns with type Geometry(Point) and other which
contains a Geometry(MultiPolygon). There
Hey Guido,
ST_SetBandPath doesn't exist but sounds like a worthwhile addition. Can you
file a ticket for that?
http://trac.osgeo.org/postgis/
In the meantime, a workaround is to use symbolic links or mount points.
-bborie
On Tue, Feb 10, 2015 at 2:34 AM, guido lemoine
@ Stephen, I concur with the replies of Remi and strk from an earlier posting
from you several weeks back. If you trying to do topological cleaning, then
perhaps reconsider your tool of choice - e.g. consider doing it in GRASS.
If your use case is simpler, then you may be able to achieve
You didn't talk about backup, it is essential (raid, replication, backup
script?).
I'm sorry to be that guy: RAID is NOT a backup. Unless you snapshot
your replication machine, replication isn't a backup either (though,
like RAID, it enables High Availability (HA)).
For lack of a precise
14 matches
Mail list logo
