G'day all,
We have a problem with erroneous geometries that we can't edit using QGIS - the
geometries are too big, and the application just hangs.
The geometries are multipolygons, and they contain invalid rings. To get at
them using postgis seems to require two levels of dumping. First, st_dum
Steve,
Haven't tried myself. Off-hand I don't see why there would be an issue
since the on disk structure didn't change between 1.4 and 1.5.
At anyrate, probably the first thing you want to do is run the postgis
1.4-1_5 upgrade
> -Original Message-
> From: postgis-users-boun...@postgis
Thanks Regina!
On 2011-10-20, at 6:04 PM, Paragon Corporation wrote:
> […]
> As far as short-hand for all states. You could do
>
> SELECT loader_generate_script(ARRAY(SELECT abbrev FROM state_lookup ORDER BY
> abbrev), 'windows');
>
> That still isn't perfect since you get duplicate path sett
I do not have enough disk space to use dump/reload to migrate an 8.4.1 spatial
database to 9.0.4 so hope to use pg_upgrade.
However, to do that, it seems that I need to have a 9.0.4 version of
postgis-1.4.so:
| Your installation references loadable libraries that are missing
| from the new inst
Steve,
As mentioned in other note. We already do. If René is seeing something
else, then something is wrong with his install.
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen
Woodbridge
Sen
They don't consolidate into same tables - each state is put in a separate
table in tiger_data schema, which inherit from the similarly named tables in
tiger schema.
So for example
In tiger_data you will see
ri_edges, ri_county etc.
Which inherit from the tables in
Tiger.edges
Tiger.county
On 10/20/2011 6:22 PM, René Fournier wrote:
This:
SELECT loader_generate_script(ARRAY['DC','RI'], 'windows');
…returns a shell script that will wget the Tiger data for the states
of DC and Rhode Island. And, aside from a couple small bugs, works
very well. I was wondering if there were a shorth
This:
SELECT loader_generate_script(ARRAY['DC','RI'], 'windows');
…returns a shell script that will wget the Tiger data for the states of DC and
Rhode Island. And, aside from a couple small bugs, works very well. I was
wondering if there were a shorthand for generating a shell script th
Fred,
Try increasing the cost of _st_overlaps and _st_buffer so it doesn't know
using these is more costly than the index or the index costs we have may be
messed up in some way.
There is a report that we might have these set too low. I haven't done
enough analysis to know wha the right costing w
Hello,
With postgis 1.3.3 on postgresql 8.3.14, the following select uses the indexes:
EXPLAIN SELECT 1 FROM grid_pk25, grid_geocover WHERE
st_overlaps(st_buffer(grid_geocover.the_geom, -1),
grid_pk25.the_geom);
QUERY PLAN
-
Now I'm trying to form the polygon but with ST_ConcaveHull and 80% but this
error message appears:
***
ERROR: function st_concavehull(geometry, numeric) does not exist
LINE 1: INSERT INTO splitbeam_area_polygon (geom) SELECT ST_ConcaveH...
you're a genius man, my mistake again, my input is 3D point, so, the polygon
should be 3D also, thanks man.
> Date: Thu, 20 Oct 2011 14:56:24 +0200
> From: s...@keybit.net
> To: gameji...@hotmail.com
> CC: postgis-users@postgis.refractions.net
> Subject
On Thu, Oct 20, 2011 at 12:09:01PM +, Gery . wrote:
>
>
> or should be 3 in my table! Bingo! after running: "select
> st_ndims(st_convexhull(st_collect(geom)) from splitbeam_point;" I got 3
> instead of 2, so I put this3 into my table and ready! that did the trick. Now
> I'm wondering why
or should be 3 in my table! Bingo! after running: "select
st_ndims(st_convexhull(st_collect(geom)) from splitbeam_point;" I got 3 instead
of 2, so I put this3 into my table and ready! that did the trick. Now I'm
wondering why this has to be 3, I mean, this is a 2D polygon, I think I'll
realiz
On Thu, Oct 20, 2011 at 09:26:48AM +, Gery . wrote:
> mop=# \d unaprueba
> Table "public.unaprueba"
> Column | Type | Modifiers
> +--+---
> id | smallint |
> geom | geometry |
> Indexes:
> "unaprueba_geom" gist (geom)
> Check constraints:
> "e
Hello Sandro,
Thanks and yes my mistake, I have 2 tables by mistake, ie., 'unaprueba' and
'testone', the first one is the right one, this is what I get after your
suggestion:
mop=# \d unaprueba
Table "public.unaprueba"
Column | Type | Modifiers
+--+---
id
On Thu, Oct 20, 2011 at 01:53:03PM +1030, Stephen Davies wrote:
> The "rounding error" in test 47 remains. Has this been fixed yet?
I belive it was fixed in trunk. Not sure about 1.5 branch.
--strk;
() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html
__
On Wed, Oct 19, 2011 at 06:03:27PM +, Gery . wrote:
> mop=# insert into testone (geom) SELECT ST_ConvexHull(ST_Collect(geom)) as
> geom FROM splitbeam_point ;
> ERROR: new row for relation "unaprueba" violates check constraint
> "enforce_geotype_geom"
>
> where could be the error? any hint
On Thu, Oct 20, 2011 at 10:10:21AM +0200, Sandro Santilli wrote:
> On Thu, Oct 20, 2011 at 10:27:29AM +1030, Stephen Davies wrote:
> > I totally zapped the postgis source tree and started again from the tarball.
> >
> > Same result.
> >
> > However, this time I captured the PostgreSQL log. For th
On Thu, Oct 20, 2011 at 10:27:29AM +1030, Stephen Davies wrote:
> I totally zapped the postgis source tree and started again from the tarball.
>
> Same result.
>
> However, this time I captured the PostgreSQL log. For the period of the make
> check run, the log is 5577 lines long but the first f
20 matches
Mail list logo
