Using this statement,
SELECT ST_AsGeoJSON(ST_Split(ST_GeomFromText('LINESTRING(0 0,2 0,2 2,0
2,0 0)'), ST_GeomFromText('LINESTRING(0 2,2 0)')))
I get this,
{"type":"GeometryCollection","geometries":[{"type":"LineString","coordinates":[[0,0],[2,0]]},{"type":"LineString","coordinates":[[2,0],[2,2],[
You could work around it by loading each overview as a separate layer
and specifying visibility rules for each layer.
I don't know if the GDAL driver is working on pyramid usage.
-bborie
On 09/07/2012 10:50 AM, Brian Fitzgerald wrote:
> "The rendering of the raster in QGIS is slow because the GD
"The rendering of the raster in QGIS is slow because the GDAL PostGIS
raster driver does not use pyramids in addition to several other
inefficiencies (one query per row)
Is this something can be worked around or is being worked on?
On Fri, Sep 7, 2012 at 12:47 PM, Bborie Park wrote:
> Brian,
Hi,
If you built Postgis from sources with right configure options, then I
think raster2pgsql should be there, in the pgsql/bin directory if you
run sudo make install
Nicolas
On 7 September 2012 18:09, Brian Fitzgerald wrote:
> I've finally manged to get the following stack working
>
> - Linux
Brian,
You should have raster2pgsql already since you compiled PostGIS from
source. There is no option in the build process to not compile
raster2pgsql.
The rendering of the raster in QGIS is slow because the GDAL PostGIS
raster driver does not use pyramids in addition to several other
inefficie
I've finally manged to get the following stack working
- Linux Mint 13 Mate
- Postgresql 9.1
- GDAL 1.9.1 built from source
- GEOS 3.3.5 built from source
- Postgis 2.0.1 built from source with GEOS and GDAL above
- QGIS nightlies for ubuntu
- I imported a digital ortho raster tiff (in SRID 2273)
It's something wrong here.
When I make the counting, it returns "1" for every row. So I get 10 rows of "1"
for a rasttable that I have loaded 10 rasters. So next at the generate_series I
have to give "1" or "10"? I'm confused.
Also, whatever I give here (I tried both), then it's creates normal
That's the point. You hardly can.
This is why I suggest to create an index from scratch by creating a new table
generating a new number for each unique filename.
Start by counting the number of unique filenames you have:
SELECT count(*) FROM rasttable GROUP BY filename;
Then generate the uniq
Now worked, thanks!
I can't understand how this "substring(filename from 4 for 2)" works.
My filenames are like that: cc00h00m15s, cc00h32m45s etc, how I create a unique
for these?
From: Pierre Racine
To: Giannis Giakoumidakis ; PostGIS Users Discussion
Ok. There was an error in the function. Fixed now. Copy again and execute.
Pierre
> -Original Message-
> From: Giannis Giakoumidakis [mailto:ggiakoumida...@yahoo.com]
> Sent: Friday, September 07, 2012 10:28 AM
> To: Pierre Racine; PostGIS Users Discussion
> Subject: Re: [postgis-users]
So you mean I firstly create SplitTable as it is and then I change arguments in
SELECT SplitTable(), am I right?
All right but when I execute the query to create the function at the SQL Editor
I get an error: ERROR: syntax error at or near "(", LINE 19: ...
quote_ident(targettableschema) |
I never you had to change the SplitTable function, just change the argument you
pass to it. and you have to create a new id per filename. rid is not unique per
filename.
Pierre
> -Original Message-
> From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-
> boun...@po
The DDF files I have look like :
-rw-r--r--. 1 13123 13704 1947 Aug 22 2001 8333CATD.DDF
-rw-r--r--. 1 13123 13704 1416 Aug 22 2001 8333DQLC.DDF
-rw-r--r--. 1 13123 13704 4726 Aug 22 2001 8333DQHL.DDF
-rw-r--r--. 1 13123 13704 2711 Aug 22 2001 8333DQCG.DDF
-rw-r--r--. 1 13123 137043
Hi Nicolas,
Is there a GDAL tool that can take a SDTS raster in .DDF files and convert
it to
raw x,y,z points?
Thanks,
Ed
On Fri, Sep 7, 2012 at 10:08 AM, Nicolas Ribot wrote:
> Hi,
>
> GDAL seems to handle the format:
> http://www.gdal.org/frmt_various.html#SDTS.
> (format specs: http://mcmcweb
I have no idea how to use GDAL to load in the SDTS .DDF files. Are you
saying I
have to write C/C++ code to do this or are you suggesting a way I could
import
this into postgis and get the raw co-ordinates?
On Fri, Sep 7, 2012 at 10:08 AM, Nicolas Ribot wrote:
> Hi,
>
> GDAL seems to handle the f
On Friday 07 September 2012, Sandro Santilli wrote:
> If you hard-code, try including the ".so" suffix.
> Also see if ``ldd /usr/lib/pgsql/postgis-1.5.so`` works
> (and gives you no 'not found').
Thanks for reply, but I solved the problem.
--
Regards,
Sergey
On Wednesday 05 September 2012, Sergey wrote:
> > > ERROR: could not access file "$libdir/postgis-1.5": No such file or
> > > directory
> > > SQL state: 58P01
>
> Puneet, can you describe your case ? I ran into this same problem.
Problem solved.
I did not pay attention what Postgresql works in
I firstly try with rid to see if it's working. It gives me an error:
ERROR: syntax error at or near "("
LINE 19: ... FROM ' || quote_ident(public) || '.' quote_ident(cc_all ) ...
^
See anything wron
Hi,
GDAL seems to handle the format: http://www.gdal.org/frmt_various.html#SDTS.
(format specs: http://mcmcweb.er.usgs.gov/sdts/sdtsfaq.html)
So it could be converted into a postgis raster, or processed directly
with GDAL/OGR.
Nicolas
On 7 September 2012 09:53, Ed Linde wrote:
> Hi All,
> I ju
Hi All,
I just downloaded a DEM file from geocomm.com, and its in a format that I
do not understand, I want to do a Delaunay triangulation on it to generate
a TIN.
I was wondering if someone here knows how I can go about getting the raw
x,y,z co-ordinates so I can go about triangulating this datase
On Fri, Sep 07, 2012 at 10:45:02AM +0400, Sergey wrote:
> On Wednesday 05 September 2012, Sergey wrote:
>
> > > > ERROR: could not access file "$libdir/postgis-1.5": No such file or
> > > > directory
> > > > SQL state: 58P01
>
> I attempted to change $libdir to hardcoded path in postgis.sql and
21 matches
Mail list logo
