First, thank you to the developers. Until about a week ago, my code for
range map generation was ugly and complex and broke frequently, and now
that I am using PostGIS - it's a LOT simpler.
I have one map that still needs to be ported to the new way of doing things.
Hallo
ST_Expand should do the trick.
http://postgis.org/documentation/manual-1.5/ST_Expand.html
/Nicklas
2010-07-20 Michael A. Peters wrote:
First, thank you to the developers. Until about a week ago, my code for
range map generation was ugly and complex and broke frequently, and now
that I am
Ok Abe, I misunderstood what you meant. Then the user with which SPIT is
connecting needs USAGE and CREATE privileges on the target schema.
If these privileges exist and SPIT still can't list the schemas, then it may
be a bug with SPIT.
Luís
On Wed, Jul 14, 2010 at 8:42 PM, Richard (Abe)
Sorry yuriesky for the unintended hijack of your thread...
Both arguments are very interesting... and I am interested in both of
them...
Probably we could split the thread.
Guys, do you follow any convention in this list for splitting treads ?
On Mon, Jul 19, 2010 at 11:18 PM, salas
Hi Pierre,
Does gdal2wktraster.py have any limitation on the maximum number of
columnsxrows ?
in my case, my raster is 107759 x 168633...
gdal works well:
se...@seanspc:~/rasters$ gdal_translate -of PNG raster/ test.png
Input file size is 107759, 168633
salas wrote:
Hello to all:
I am working in a project where they are managed more than 20
geoespatials thematics. Each thematic one has a considerable volume of
since information it is of the whole country (I am speaking of a lot
more than a million of records). In the project we need to make
hello
I want to make a linestring from a known point and known direction (as
azimuth) with
certain length.
how can I do that ?
regards
___
postgis-users mailing list
postgis-users@postgis.refractions.net
El Tuesday 20 July 2010, ahmet temiz escribió:
hello
I want to make a linestring from a known point and known direction (as
azimuth) with
certain length.
how can I do that ?
Can you calculate the final point instead of the direction?
--
María Arias de Reyna Domínguez
Área de Operaciones
Hi ahmet,
you can use something like that (and easily write a function):
here, the point is (0 0) : ST_makepoint(0,0)
,azimuth is 45 and distance is 50.
select st_makeline(st_makepoint(0,0),st_makepoint(xx,yy)) as the_geom
FROM
(
select
ST_x(st_makepoint(0,0)) + (50 * (sin(45))) as xx,
Hi there,
Currently I'm working on my master thesis regarding the topic
of crisis management. During my research I came across the idea of
versioned databases.
Since I don't have access to ArcSDE and being a total newbie to PostGIS
I'd really like to know if there is any possibility to
Hello Dominik,
Although it's not a versioning system, PostGIS has a Historic Tables module.
You can find it in extras folder.
Att
George
On Tue, Jul 20, 2010 at 9:29 AM, Ralf Suhr ralf.s...@itc-halle.de wrote:
http://gis.hsr.ch/wiki/images/4/44/Postgis_historisierung.pdf
Am Dienstag 20
Wait. You first said the png was working. Now it's not? Did you try
gdal_translate with the ESRI grid? For sure I haven't test yet with such big
rasters. Is this the result of a merge or all your original raster are all this
size? The point is that with WKT Raster you don't have to merge your
yes... with png worked... but it was a different png (a smaller one)...
so I've converted the ESRI into a png and tried to import it... and it
didn't work neither...
so this is the situation:
A have huge rusters (from 150kx150k).. In Oracle I would just load it (the
huge raster) in a single row
Hi.
I'm, having a problem with some geometries.
I have buildings and blocks represented by polygons, and I have to check
if buildings are contained in blocks.
The problem is that buildings that are snapped to blocks sides, aren't
considered inside the block.
These are the validations that I've
Hi.
I'm, having a problem with some geometries.
I have buildings and blocks represented by polygons, and I have to check
if buildings are contained in blocks.
The problem is that buildings that are snapped to blocks sides, aren't
considered inside the block.
These are the validations that
Sebastian,
if you don't want to work with zillions of tiles, but with large
mosaics, check out www.rasdaman.org :
single tile insert (any size; fully transparent tiling, indexing, query
optimization):
$ rasql -q insert into MyImages values inv_png( $1 ) -f myfile.png
single tile read (any
There is no real limits to PostGIS... It handle very well millions of row of
vector data. What are your apprehensions?
Pierre
-Original Message-
From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
boun...@postgis.refractions.net] On Behalf Of salas
Sent: 19
Since we have this bug with big rasters, I would suggest you split your raster
with something like GDAL gdal_retile.py and then import your tiles into a
single WKT Raster table following the instruction provided in our tutorial.
Each tile will be stored in a column cell of type RASTER similar
On 07/20/2010 05:47 PM, Pierre Racine wrote:
Since we have this bug with big rasters,
proven, any-size, ... ;-)
Who is proven? Well, running a dozen-TB seamless mosaic on PostgreSQL
for many years, having online-demos available since years, etc... you
decide, in comparison.
-Peter
I
Hi Rob
I've created a new entry in /usr/share/proj/epsg, calling it 27701 for now
presumably units are abbreviated to 'dm' ??
Not sure what you meant by this bit however
then use +init=my:
thanks
chris
Robert Coup-4 wrote:
On Tue, Jul 20, 2010 at 8:06 AM, chrispg
Hi,
I make use of the Kyngchaos builds for Postgis in Mac OS X Snow Leopard
(10.6.4). I am trying to install the WKT raster on my existing PostGIS but I
havent succeed.
I have tried downloading the same version of PostGIS code that I have installed
via Kyngchaos and use it to compile WKT
On Jul 20, 2010, at 2:11 PM, Javier de la Torre wrote:
I have tried downloading the same version of PostGIS code that I have
installed via Kyngchaos and use it to compile WKT raster. I had to copy
config.sub and config.guess because it was complaining and then I ran:
Odd. The included
On Tue, Jul 20, 2010 at 2:38 PM, William Kyngesburye
wokl...@kyngchaos.com wrote:
export CFLAGS=-Os -arch i386 -arch x86_64
export PG_CPPFLAGS=-arch i386 -arch x86_64
Does that build for both 32 and 64 bit? If I leave out the above
flags, the default build on Snow Leopard should be 64 bit, no?
So if I already have a table of, say 100 000 points, uploaded in PostGIS, how
do I use rasdaman to get the raster values of the pixels located under the
points?
Pierre
From: Peter Baumann [mailto:p.baum...@jacobs-university.de]
Sent: 20 juillet 2010 12:08
To: PostGIS Users Discussion
Cc:
On Jul 20, 2010, at 2:54 PM, P Kishor wrote:
On Tue, Jul 20, 2010 at 2:38 PM, William Kyngesburye
wokl...@kyngchaos.com wrote:
export CFLAGS=-Os -arch i386 -arch x86_64
export PG_CPPFLAGS=-arch i386 -arch x86_64
Does that build for both 32 and 64 bit? If I leave out the above
flags,
Except that you need radians .. not degrees, so multiply your degrees
by pi()/180 to convert to radians.
See this similar discussion:
http://postgis.refractions.net/pipermail/postgis-users/2010-January/025752.html
-Mike
On 20 July 2010 04:57, Fred Lehodey leho...@gmail.com wrote:
Hi ahmet,
Thank you. It did work with one caveat, I assume because all my shape data
is in WGS84 it added an equal number of specified decimal degrees to each
side but that was cake to adjust post ST_Expand and it now does exactly
what I want it to do.
Hallo
ST_Expand should do the trick.
You might want to look into the GEOGRAPHY type
http://postgis.refractions.net/docs/ch04.html#PostGIS_Geography to do
this nicely.
-Francis
On 21 July 2010 12:57, Michael A. Peters mpet...@shastaherps.org wrote:
Thank you. It did work with one caveat, I assume because all my shape data
is in
28 matches
Mail list logo