Since everything is wrong except for GML, which has to reverse things
that are correct in order to do the right thing vis-a-vis GML, my
guess is that the data were loaded in the wrong order to start with.
That is, if you run ST_AsText() you'll find the coordinates in Lat-Lon
order, when the
ST_HasArc() should do what you want
On Tue, May 5, 2015 at 1:52 AM, Andrea Aime
andrea.a...@geo-solutions.it wrote:
Hi,
I have some generic build of code that are building queries to postgis
includingthe st_simplify function, e.g:
select st_simplify(geometry, tolerance) from mytable where
Due to a critical bug in GeoJSON ingestion we have made an early release of
versions 2.0.7 and 2.1.7. If you are running an earlier version on a public
site and accepting incoming GeoJSON, we recommend you update as soon as
possible.
http://postgis.net/source
The resolved issue would
Igor,
Your supposition is is all correct (you might want to ask your
questions on postgis-devel, where the developer density is higher).
lwalloc by default is just a facade over malloc, for standalone use.
But, when used in PostGIS, it it backed by palloc, which is in turn
the memory manager
width value
#3031, Allow restore of Geometry(Point) tables dumped with empties in them
View all closed tickets.
--
Paul Ramsey
http://cleverelephant.ca
http://postgis.net___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org
Users,
Per this ticket:
http://trac.osgeo.org/postgis/ticket/3061
We currently strip out repeated points from GML, KML and GeoJSON inputs. We
allow them on WKT and WKB input. This seems arbitrary (probably it is, just a
random development choice at the time).
Would anyone have a problem w/
Stop writing so many subqueries, think in joins; the poor planner!
SELECT DISTINCT ON (a.id) a.id AS a_id, b.id AS b_id
FROM a
JOIN b
ON ST_Contains(b.shape, a.shape)
WHERE b.kind != 1
Also, the DISTINCT ON syntax (PgSQL custom) lets you winnow a result
set down to just one of the inputs.
P.
a feeling it will, since
most likely the query planner will decide to process A row by row and find a
suitable B each time. In this case, we need a GiST index on B, so that we
could find the B that is contained in A right?
Thanks again,
Igor
On Tue, Mar 3, 2015 at 5:47 PM Paul Ramsey pram
Stick that puppy in a trac ticket, I'll have a look.
On Mon, Jan 26, 2015 at 6:25 AM, cwright colin.wri...@thinkwhere.com wrote:
Hi,
I’ve loaded a shapefile containing height information into PostGIS using
OGR2OGR. The shapefile has loaded OK and the geometry all seems to be fine
in PostGIS,
Yes, I could see that as a reasonable interpretation. Just another in
the large collection of corner cases opened up by allowing typed empty
(my fault). The code probably just tests for empty and reflects the
input back in that case.
P.
On Fri, Jan 9, 2015 at 2:26 PM, BladeOfLight16
You have created an index on your geometry column using something like
CREATE INDEX myindex ON mytable (geom);
This has created a b-tree index, which is limited in the object size
it can handle (and won't answer spatial questions efficiently in any
event). Drop it, and replace with a GIST
Move up to the latest patch revision of postgis, the 2.1.0 release
definitely had a few subtle issues with geography distance of the sort
you are describing.
P.
On Thu, Jan 8, 2015 at 2:09 PM, Hartranft, Robert M.
(GSFC-423.0)[RAYTHEON COMPANY] robert.m.hartra...@nasa.gov wrote:
Hi All,
I am
I would think that scaling by 180/pi should do the trick in general?
select st_astext(st_setsrid(st_scale('POINT(1
1)'::geometry,180.0/pi(),180.0/pi()),4326));
P
On Thu, Dec 4, 2014 at 3:24 PM, Burgess, Freddie
fburg...@radiantblue.com wrote:
Given a polygon geometry with no SRID, the vertices
Correct, the curves were likely ruined on the way through GDAL. In
some ways, fortunate they ever got through at all.
On Wed, Nov 12, 2014 at 7:48 AM, Bborie Park dustym...@gmail.com wrote:
If I remember correctly, curve geometries are not currently supported in
GDAL/OGR. There is a GDAL RFC
Correct, I was thinking more PC_Transform(pcpatch, pcid), which would look
for common dimension names and map between them by default, or could maybe
accept a mapping (dim-dim) to control the conversion. But yes. Danger I
suppose in downgrading data (pushing a 4 byte into 2 byte) but that could
be
to fix your problem would be to just alter the type to a 2d
point, and then the stats gathering system will work right. It's worth
doing this, since as the NOTICE says, you aren't currently gathering
any stats.
P.
On Wed, Oct 1, 2014 at 3:26 PM, Paul Ramsey pram...@cleverelephant.ca wrote:
Well
So, I have a “solution” but I’m not 100% happy with it. It’s attached to the
ticket here,
http://trac.osgeo.org/postgis/ticket/2953
P.
--
Paul Ramsey
http://cleverelephant.ca
http://postgis.net
On October 2, 2014 at 9:58:13 AM, Paul Ramsey (pram...@cleverelephant.ca) wrote:
OK
)) * sin(2*pi()*u2),
50 * sqrt(-2 * ln(u1)) * sin(2*pi()*u2),
50 * sqrt(-2 * ln(u1)) *
sin(2*pi()*u2)),4326)::Geometry(PointZM,4326) AS geom
FROM rands;
P
On Tue, Sep 23, 2014 at 3:54 PM, Paul Ramsey pram...@cleverelephant.ca wrote:
I guess in theory I could reproduce it with some random xyz
Hey all,
I'm thinking about organizing a PostGIS day (Nov 20) in Washington DC,
and I'm looking for folks who would be willing to present about (a)
their use of PostGIS or (b) the amazing insane magic they do with
PostGIS. We'd host in the spacious Boundless office, likely, and
probably do an
location
you’ll end up naturally with bottlenecks on hot nodes. (Like, you will tend to
roll up on spatial areas, which means only the node that serves that area will
end up hot during the query, and the rest of the nodes will be idle: the
absolute worst utilization situation.)
P
--
Paul Ramsey
/longs
and viola no “notice” message.
Is it only an issue with three or four dimensional data?
Thanks,
jason
On September 22, 2014 at 5:43:43 PM, Paul Ramsey (pram...@cleverelephant.ca)
wrote:
If you can share data, I'm happy to try and reproduce it here.
P
On Mon, Sep 22, 2014 at 2:01 PM
It means it sampled 3 rows and didn't find any geometries that
were non-null or non-empty. I suppose it could mean a bug, though that
code's been around for a while.
select count(*) from yourtable where geom is null;
select count(*) from yourtable where st_isempty(geom);
select
r12547 GEOS=3.4.2-CAPI-1.8.2 r3921 PROJ=Rel. 4.8.0, 6
March 2012 GDAL=GDAL 1.9.2, released 2012/10/08 LIBXML=2.7.6
LIBJSON=UNKNOWN RASTER'
i even tried putting a bogus null row in there but I still got the message.
thanks!
On September 22, 2014 at 2:52:00 PM, Paul Ramsey (pram
No, there's nothing in 1.5 to find anti-podal edges. I'm willing to
guess though that yours involve pole-to-pole lines, so you could look
for objects with an ymax-ymin of ~180.
Alternately, is the hgc_bbox column real data, or is it derived from
other data? (ie, there's real lines or polygons
The version of GEOS on your system is old, and lacks the
GEOSDelaunayTriangulation, you'll have to upgrade it. Not sure why
your PostGIS package didn't complain. One possibility (if it's an old
system, and you've manually installed software in the past) is that
you have two copies, and old one and
Running queries does not build up an index, you CREATE INDEX, and
that's it, it's built.
The time differences you are seeing are almost certainly the result of
data being transferred up into the operating system's virtual file
system (VFS) from the disk. Reading from disk is slow; reading from
LineMerge is implemented via the GEOS library which, unlike PostGIS,
only understands 3 dimensions max. So the 4th is sacrificed in the
process. There's no good / easy way to retain it. you could write a
post-process routine that took every output vertex and compared it to
the input geometry to
Well, you had me scared, but it's not an attribute of the 2.1.2
release, it's something specific about either windows or your
installation in particular. After building and installing 2.1.2 on
OSX, I can:
foo=# create extension postgis version '2.1.2';
CREATE EXTENSION
foo=# create table bar
Baris, we're just unwashed innocents abroad. I know maven exists and
does something useful in principle, but getting things onto public
repositories etc, is way above my paygrade. Please, do whatever the
right thing is, in this situation.
P.
On Thu, Apr 3, 2014 at 11:40 AM, Baris Ergun
Hi all,
Spring is here (in the northern hemisphere, mostly) and that means it’s time to
release some fresh patch releases of PostGIS 2.1 and 2.0 branches!
http://download.osgeo.org/postgis/source/postgis-2.1.2.tar.gz
http://download.osgeo.org/postgis/source/postgis-2.0.5.tar.gz
For detailed
first line imply that temperatures have risen above the freezing
level, for at least carbon dioxide, north of, say, Chicago?
On Mon, Mar 31, 2014 at 8:40 AM, Paul Ramsey pram...@cleverelephant.ca
wrote:
Hi all,
Spring is here (in the northern hemisphere, mostly) and that means it's
time
Stephen's advice should work, and you shouldn't have lost any data.
You probably broke the GDAL dependency PostGIS has, which would just
mean every time you try to do a PostGIS function it won't work. so no
data will go away, things just won't *work*. Follows Stephen's advice
in making sure your
As long as the input GeoJSON is in lon/lat, there's no reason you
can't just cast the geometry to geography.
On Mon, Mar 17, 2014 at 9:12 AM, Gutfreund, Yechezkal
ygutfre...@draper.com wrote:
Yes, there is a ST_GeomFromGeoJSON() but what is the status of:
ST_GeogFromGeoJSON()?
Would it be
the 2.1 SVN branch, but will only be able to spend limited
time with it. I will still try to isolate a test case if I can.
On Mon, Feb 3, 2014 at 10:10 PM, Paul Ramsey pram...@cleverelephant.ca
wrote:
That's really quite disturbing, since it would seem to indicate that
even the core algorithms
Pretty sure I have this one tracked, will update shortly.
On Mon, Feb 3, 2014 at 12:55 PM, Jerry Sievert
je...@legitimatesounding.com wrote:
The workaround as provided exposes multiple other issues for us. I can try
to isolate them, but essentially it causes random looking test failures in
our
Jerry,
Pretty important to isolate them, as that function's at the bottom of
the cached tree algorithm, so even if I fix the gap in the cache logic
I think I have found, you'll still run into other issues later.
_ST_DistanceUncached uses brute force (aka 2.0) methods, and should
work without
Yes, probably the installer is missing the file (go to the location of
shp2pgsql and ls ../lib/ and see if libintl shows up there, probably
it doesn't. So inform EDB that their packager is forgetting to include
a file. They probably don't test the commandline components as much as
the GUI ones.
The PostGIS notices are being generated using PostgreSQL
infrastructure (elog(NOTICE, message)) so I'm surprised they are
behaving differently from any other generated notice...
P.
On Fri, Jan 17, 2014 at 1:15 PM, Shira Bezalel sh...@sfei.org wrote:
Our Postgres log is set to send only WARNING
Maybe on OL3?
http://vimeo.com/78298228
P
On Fri, Jan 3, 2014 at 4:14 AM, Jan Hartmann j.l.h.hartm...@uva.nl wrote:
Hi all,
I have written a simple OpenLayers-application to edit a PostGIS polygon
layer: read one polygon from the server as GeoJSON, adapt it interactively,
and write it back
We need patches for Java issues as we have no active JDBC/Java maintainers ATM.
P.
On Sat, Dec 21, 2013 at 11:31 AM, Baris Ergun barisergu...@gmail.com wrote:
I have tested the issue with latest snapshot 2.1.0SVN for jdbc driver. The
GeometryCollection still cannot parse the String value
Yes, it sounds like a difference in the stats results, which
ST_EstimatedExtent leans upon, and likely QGIS uses for quick extent
determination. Checking the results of that function over the two
versions will confirm/deny hypothesis.
On Thu, Dec 12, 2013 at 6:26 PM, Paragon Corporation
Might also be a nice thing for us to add to the end of the load process :/
On Tue, Dec 10, 2013 at 12:09 PM, Stephen Woodbridge
wood...@swoodbridge.com wrote:
Paul,
Cool! And yes, anytime you load a database or table like from shp2pgsql you
should analyze it to update the database statistics
You might have to put the password into the environment to avoid the
prompt screwing up the pipe...
export PGPASSWORD=yourpassword
(Im' assuming you've already tested psql connectivity and ensured you
can in fact connect via psql)
P.
On Tue, Dec 10, 2013 at 12:05 PM, Paul Caroline Lewis
srsDimension has inconsistent values, could that be it? (error message
seems pretty small :)
On Tue, Dec 10, 2013 at 12:36 PM, Dave Potts dave.po...@pinan.co.uk wrote:
Hi List,
I am trying to load some gml data, most of the time it works, but some of
the records fail with constructs such as
Can't, it's not implemented against nd.
P.
On Tue, Dec 3, 2013 at 12:05 PM, Stephen Mather
step...@smathermather.com wrote:
If I create an nd aware index, say:
CREATE INDEX lidar_the_geom_3dx ON lidar USING gist(the_geom
gist_geometry_ops_nd);
Can - and # be made to use that? If so, how?
Hopefully I'm not too immodest in saying this
http://workshops.boundlessgeo.com/postgis-intro/knn.html
P
On Wed, Nov 20, 2013 at 10:49 AM, Stephen Mather
step...@smathermather.com wrote:
Hi All,
What's the best (normal) human readable reference for the PostGIS distance
operators-- but deep
to raster2pgsql to skip checking that band is NODATA
--
Paul Ramsey | Boundless
http://boundlessgeo.com/support/postgis
2508850632 | @pwramsey
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman
Coming back to this a bit late (hah!) ... what PostGIS version is this on?
P
On Wed, Jun 12, 2013 at 1:23 AM, BladeOfLight16
bladeofligh...@gmail.com wrote:
I have a table that contains many point rows. The points all fall within a
polygon in another table. There are roughly 5 to 20 thousand
, 2013 at 10:12 PM, Paul Ramsey pram...@boundlessgeo.com
wrote:
Coming back to this a bit late (hah!) ... what PostGIS version is this on?
2.0.4. Haven't tested with 2.1 yet, but I think it persists. There's a nice
script in my original report to test with if you have 2.1 installed. =) It
needs
Wow, that page really goes out of its way to make sure you don't want
to use PostGIS! All those notes and caveats in the PostGIS boxes!
Beginning with ArcGIS 10.1, all databases used with ArcGIS must be
64-bit WHAT?!?!? Client apps, by and large, don't give a damn about
what platform the database
Except when one or more of the geometries includes circular arcs (v 2.1+)
P
On Fri, Oct 18, 2013 at 6:39 AM, Nicklas Avén
nicklas.a...@jordogskog.no wrote:
If I understand you right your assumption is true.
What makes you wondering?
In 2d you will always get the distance to a vertexpoint in
of curves on ST_CurveToLine
* Enhancements *
- #2269, Avoid uselessly de-toasting full geometries on ANALYZE
* Known Issues *
- #2111, Raster bands can only reference the first 256 bands of out-db rasters
--
Paul Ramsey
http://opengeo.org
http://postgis.net
function - much faster
(Nathan
Wagner)
#739, UpdateRasterSRID()
#945, improved join selectivity, N-D selectivity calculations,
user accessible selectivity and stats reader functions for testing
(Paul Ramsey /
OpenGeo)
toTopoGeom with TopoGeometry sink (Sandro Santilli
Without seeing your data it's quite hard to say. Many large things vs
many large things yields a problem where indexes and so on don't have
a lot of leverage on the problem.
On Tue, Jul 2, 2013 at 6:39 AM, Evan Martin
postgre...@realityexists.net wrote:
Hi,
I have tables of ~25,000 polygons
point_ops has nothing at all to do with PostGIS, it's an opclass for
the internal 'point' type of PostgreSQL (let confusion reign).
You may find that you get better PostGIS plans with 2.1 when it comes
out, as the selectivity calculation logic has been refined a bit
further. I strongly doubt
I can live w/ it. +1
On Sat, May 4, 2013 at 3:49 PM, Sandro Santilli s...@keybit.net wrote:
+1 for feature freeze of 2.1.0 --strk;
On Fri, May 03, 2013 at 08:52:35PM -0400, Paragon Corporation wrote:
I want to officially vote for feature freeze for 2.1. And I'm asking both
PostGIS devs and
The caching strategy used by proj and geos creates objects in memory
that live for the span of the STATEMENT, not the backend. So I
wouldn't worry too much about that. On the other hand, if you have a
lot of individual geocode requests coming in it could get expensive as
each one has to set up a
the framework spelled out by GPL V2. Go for it! Is there someone (Paul
Ramsey? PostGIS foundation?) who can make this unequivocal? If you don't
change the library you are free to use it in your own program without that
program becoming GPL.
When I use open source code in a library and I make
Rather than using the postgresql packages included in the distro, go to the
postgresl yum repo. That always has much fresher versions, of both pgsql and
postgis.
http://yum.postgresql.org
P
--
Paul Ramsey
http://cleverelephant.ca/
http://postgis.net/
On Monday, 4 February, 2013 at 3:44
at 11:13 PM, Paul Ramsey pram...@opengeo.org wrote:
Ah. Geography is version 1.5+
You can put st_distance_spheroid in place of st_distance for a metric
answer.
p
On Thu, Dec 6, 2012 at 9:40 AM, tasneem dewaswala
tasneem.eur...@gmail.com wrote:
Thank you for the suggestion
i tried
The PostGIS development team is happy to release the second patch
version of PostGIS 2, the 2.0.2 release. As befits a patch release,
the focus is on bugs and breakages, and there are a large number of
obscure things that are now better in this release.
It's normal, assuming that some of your geometries are quite large. If
someone wants to fund a prepared intersection development task I'm
sure we could make it 10x-40x faster.
P.
On Thu, Nov 29, 2012 at 10:04 AM, Étienne Desgagné
etienne.desga...@roche.ca wrote:
It take millisecond to me to
For information: ST_Intersects used to be slow, and the caching system
and prepared intersects development made it 10-20x faster. A similar
approach to intersection would yield similar results.
On Thu, Nov 29, 2012 at 10:36 AM, Paul Ramsey pram...@opengeo.org wrote:
It's normal, assuming
ST_Segmentize in geography will just segmentize along the great
circle. You'll have to choose whether you want your model in geometry
or geography. If geometry, then you can use Mercator as your
projection (rhumb lines are then straight line) and use
ST_Segmentize(geography) to convert your great
301 - 364 of 364 matches
Mail list logo