Re: [postgis-users] memory problems

2010-11-11 Thread Paul Ramsey
Till, Upgrade to 1.3.5 at least. There were massive memory leaks in comes cases of point-in-polygon tests in the early 1.3 series. P On Thu, Nov 11, 2010 at 7:45 AM, Till Kirchner till.kirch...@vti.bund.de wrote: Hi together, I have a memory problem when executing a Point-In-Polygon function.

Re: [postgis-users] Determine latitude/longitude of a point given initial latitude/longitude, bearing and distance on a spheroid.

2010-11-08 Thread Paul Ramsey
There is code for this in the lwspheroid.c file in liblwgeom. Note it is GPL. It's not exposed in SQL at the moment, I didn't realize people would have that use case. So file a ticket to make azimuth/bearing translations on the spheroid available in SQL. P On Mon, Nov 8, 2010 at 11:52 PM, Luke

Re: [postgis-users] ST_GeomFromText function doubt

2010-10-27 Thread Paul Ramsey
Try this: SELECT name, the_geom, ST_AsText(the_geom),ST_GeomFromText(ST_AsText(the_geom),ST_SRID(the_geom)) FROM nyc_subway_stations WHERE name = 'Broad St'; The trouble is that ST_AsText drops the SRID information, so when you convert that back into a binary geometry, it has a different

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Paul Ramsey
And that DBF field dates from the Time Before UTF-8, so there won't be a UTF8 number to put in it, in any event. DBF files with UTF in them (OSM!) are scary scary scary (for example, should your code for reading a CHAR(8) field in DBF expect 8 bytes, or 8 characters? yay!) It would be nice to

Re: [postgis-users] pgsql2shp dbf file encoding

2010-10-25 Thread Paul Ramsey
. On Tue, Oct 26, 2010 at 12:03 AM, Paul Ramsey pram...@opengeo.org wrote: And that DBF field dates from the Time Before UTF-8, so there won't be a UTF8 number to put in it, in any event.  DBF files with UTF in them (OSM!) are scary scary scary (for example, should your code for reading a CHAR(8

Re: [postgis-users] Hello

2010-10-02 Thread Paul Ramsey
And there is a more recent tutorial available here: http://workshops.opengeo.org/postgis-intro/ On Sat, Oct 2, 2010 at 9:00 AM, MarkW mark.wi...@gmail.com wrote: Nitesh, (There is a good tutorial about mapserver here: http://mapserver.org/tutorial/index.html ) As for the PostGIS part, it's

Re: [postgis-users] shape to postgis inporter fails or crashes

2010-09-30 Thread Paul Ramsey
...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Thursday, September 30, 2010 1:22 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] shape to postgis inporter fails or crashes Just use the -w switch to specify WINDOWS-1252 as your encoding. Should work fine from there. P. BTW

Re: [postgis-users] srid for epsg 26915

2010-09-22 Thread Paul Ramsey
There's no such thing as a PostGIS SRID, the SRID only has true meaning local to a database instance. Now, because we happen to install a spatial_ref_sys.sql file which not only has SRID values but makes them identical to the EPSG numbers, there is an assumption that the SRID == EPSG number, but

[postgis-users] RTree Read

2010-09-05 Thread Paul Ramsey
Interesting paper: http://dke.cti.gr/pubs/confs/adbis02.pdf P ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Problem cleaning invalid geometries

2010-08-20 Thread Paul Ramsey
You could use ST_Dump() to split your multipolygon up and then run validity check/fix on the individual components...? P On Fri, Aug 20, 2010 at 9:44 AM, L Bogert-OBrien dlaw...@ncf.ca wrote: Hi, I am just wondering if there is a way to minimize the extent on which the cleangeometry()

Re: [postgis-users] QGIS requires

2010-08-18 Thread Paul Ramsey
If this isn't a ticket for qgis, it should be. They should be able to do readonly access to tables and views that do not have unique keys, no excuses. P. On 2010-08-18, at 10:51 AM, William Furnass w...@thearete.co.uk wrote: Hi, QGIS requires that all PostGIS tables/views have a numeric

Re: [postgis-users] st_transform, irreversible?

2010-08-17 Thread Paul Ramsey
It should be, our spatial_ref_sys is generated from gdal which generates from epsg. You have a pretty recent postgis, so I'm surprised it's missing. P On Tue, Aug 17, 2010 at 1:57 AM, Erik Rehn e...@slagkryssaren.com wrote: Thank you guys! You were right, I had flipped the coordinates in the

Re: [postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-13 Thread Paul Ramsey
Aman, Thanks for the informative post. Could you put the relevant parts and your example file into the issue tracker at http://trac.osgeo.org/postgis so we have a record of it? I can see the benefit in handling data in the way others do for maximum ease of use. Yours, Paul On Fri, Aug 13, 2010

Re: [postgis-users] Convert already loaded table into a spatial table (points)

2010-08-12 Thread Paul Ramsey
the overhead of the create table as ... approach, though I am not smart enough to tell you why. Kevin has many experiences and useful tips on handling really large tables. P. On Thu, Aug 12, 2010 at 12:24 PM, Mauricio Miranda mmira...@xoomcode.com wrote: On Aug 12, 2010, at 15:56 PM, Paul Ramsey

Re: [postgis-users] st_transform, irreversible?

2010-08-11 Thread Paul Ramsey
Seems to be an underlying problem with proj4: echo 59 21 | proj +init=epsg:3021 | invproj +init=epsg:3021 58d49'47.733E 21d2'54.745N And that's without doing the datum shift part. P On Wed, Aug 11, 2010 at 1:10 PM, Erik Rehn e...@slagkryssaren.com wrote: Hello Postgis Users! This is my

Re: [postgis-users] st_transform, irreversible?

2010-08-11 Thread Paul Ramsey
58d49'47.733E 21d2'54.745N P. On Wed, Aug 11, 2010 at 1:35 PM, Paul Ramsey pram...@opengeo.org wrote: Seems to be an underlying problem with proj4: echo 59 21 | proj +init=epsg:3021 | invproj +init=epsg:3021 58d49'47.733E  21d2'54.745N And that's without doing the datum shift part. P

Re: [postgis-users] ST_Azimuth on the spheroid

2010-08-04 Thread Paul Ramsey
Indeed, the code is there, it just needs to be exposed to SQL. Do you build your own PostGIS Francis? If so you can open a ticket for the feature and I'll provide a patch there you can apply. If not, it could be a long wait for PostGIS 2.0 and new features. (several months) P On Wed, Aug 4, 2010

Re: [postgis-users] Modify PCS Units

2010-08-03 Thread Paul Ramsey
Add a +to_meter parameter to your proj4 definition, that might nail it. I'm not sure specifying +units actually does any math. P On Tue, Aug 3, 2010 at 10:48 AM, robert_cl...@doh.state.fl.us wrote: Good afternoon all: I'm working on a project in which I feed parameters to our intern for

Re: [postgis-users] Efficient within / intersection of large polygons

2010-07-30 Thread Paul Ramsey
Chris, The advice from the manual stands... Your best bet will be to chop up your big polygons into smaller regions. My personal preference is to use a grid for the chopping. You can then test fir containment by checking to see that all the fragments your test polygon intersects share the

[postgis-users] Sol Katz Award Time

2010-07-30 Thread Paul Ramsey
Not sure if I mentioned this earlier, but in case I failed to: http://www.osgeo.org/node/1057 -- The Open Source Geospatial Foundation would like to open nominations for the 2010 Sol Katz Award for Geospatial Free and Open Source Software. The Sol Katz Award for Geospatial Free and Open Source

Re: [postgis-users] may have postgis store limits for a big project?

2010-07-22 Thread Paul Ramsey
It's still on an experimental branch... but who knows, maybe someone has a big production deployment :) people are strange (like the folks who deployed PostGIS 0.1 in Solothurn, right Horst?) You might want to at least try it and see... the two days you invest in research are probably well worth

Re: [postgis-users] Deleting many points falling outside a large polygon (but within the bbox)

2010-07-22 Thread Paul Ramsey
Are you using 1.4? The pip shortcuts all got into that release series... P. On 2010-07-22, at 1:17 PM, Dan Putler dan.put...@sauder.ubc.ca wrote: Hi Tim, A point-in-polygon test approach would seem to make sense. I did a quick Google search and ran into posting on Paul Ramsey's Clever

Re: [postgis-users] Antwort: Re: Projection(s) for global point-and-radius searches

2010-07-08 Thread Paul Ramsey
, 2010 at 11:51 PM, Stefan Priess stefan.pri...@iav.de wrote: Hey Paul, i need the ST_Expand() function with a radius/expand of 10 Meters, how i will do that? The Point to expand is in SRID 4326 . Thanks Stefan Paul Ramsey pram...@opengeo.org Gesendet von: postgis-users-boun

Re: [postgis-users] lidar: what is the recommended way of storing/indexing

2010-07-08 Thread Paul Ramsey
There is no recommended way right now. It's a core development activity I'd love to have funded... :) http://opengeo.org/products/coredevelopment/postgis/pointclouds/ In the meanwhile a approach might be to put the x/y/z into a postgis geometry and stuff the rest of the data into an array of

Re: [postgis-users] lidar: what is the recommended wayof storing/indexing

2010-07-08 Thread Paul Ramsey
array query language on top. See www.rasdaman.org. -Peter Paul Ramsey wrote: Oh, actually one-row-per-point is a bad idea, because the size of lidar sets mitigates against that. Putting them into multipoint collections of 50 or 100 points is better. But that implies preprocessing things

Re: [postgis-users] Projection(s) for global point-and-radius searches

2010-07-07 Thread Paul Ramsey
David, Consider using the GEOGRAPHY type if your queries are just going to be ST_DWithin style. That will remove all projection issues. P. On Wed, Jul 7, 2010 at 11:19 AM, David Jantzen djant...@ql2.com wrote: Hey All, It's been a couple years but happily I have a reason to work with PostGIS

Re: [postgis-users] Projection(s) for global point-and-radius searches

2010-07-07 Thread Paul Ramsey
.com wrote: Sweet!  It must do on-the-fly projections under the covers, right?  That's a huge improvement since I used PostGIS last time. On Jul 7, 2010, at 11:40 AM, Paul Ramsey wrote: David, Consider using the GEOGRAPHY type if your queries are just going to be ST_DWithin style

Re: [postgis-users] Projection(s) for global point-and-radius searches

2010-07-07 Thread Paul Ramsey
On Wed, Jul 7, 2010 at 12:25 PM, Paul Ramsey pram...@opengeo.org wrote: ST_Buffer(geography, float8) returns geography ST_Intersection(geography, geography) returns geography These last two actually *do* carry out projections under the covers, so watch out. P

[postgis-users] Sol Katz Award 2010 Nomination Call

2010-07-06 Thread Paul Ramsey
acknowledge the work of community members, and pay tribute to one of its founders, for years to come. It should be noted that past awardees and selection committee members are not eligible. Past Awardees: 2009: Daniel Morissette 2008: Paul Ramsey 2007: Steve Lime 2006: Markus Neteler 2005: Frank

Re: [postgis-users] Space partitioning index for points

2010-07-01 Thread Paul Ramsey
GeoHash doesn't cut it? It's space partitioned, just not as balanced as a kd-tree, but for points... no? I'll look up my info on the GiST work that was done, but note that it didn't make it into 9.0, but into 9.1, and as I recall Oleg and co did not seem to think the kd implementation was going to

Re: [postgis-users] Wondering why I can't use the geometry type in a CREATE statement.

2010-06-28 Thread Paul Ramsey
On Sun, Jun 27, 2010 at 7:03 PM, Greg Militello j...@thinkof.net wrote: Why isn't this possible? CREATE TABLE parks (  park_id    INTEGER,  park_name  VARCHAR,  park_date  DATE,  park_type  VARCHAR,  parks   GEOMETRY(128, 'MULTIPOLYGON', 2) ); Until recently (pgsql 8.3), PostgreSQL

Re: [postgis-users] Unable to build PostGIS 1.4.2 on MacOS 10.6.4

2010-06-23 Thread Paul Ramsey
OS/X includes it's own iconv, and somehow you're getting a conflict based on the software you've installed. It looks like you've compiled against GNU libiconv (hence 'libiconv_open') but are linking against OSX iconv (which uses plain 'iconv_open'). Hope that helps you track things. Watch what

Re: [postgis-users] Error in shp2pgsql

2010-06-22 Thread Paul Ramsey
João Paulo, If you could provide the shapefile in question (or, even better, a reduced version with just the one polygon that causes trouble) that would make it easier for us to fix things up! Thanks P 2010/6/22 João Paulo Hespanha jphespa...@gmx.com: Dear Sirs: While importing a shapefile

Re: [postgis-users] Shapefile GUI loader

2010-06-11 Thread Paul Ramsey
(a) ensure you have the gtk libs and devel support packages installed (gtk+-dev) including pkg-config (b) ./configure including the --with-gui directive P On Fri, Jun 11, 2010 at 7:12 AM, Bruno Friedmann br...@ioda-net.ch wrote: Hi Regina, may I ask a question about building this under linux ?

[postgis-users] FOSS4G 2010 Early Bird Deadline: June 15

2010-06-09 Thread Paul Ramsey
If you plan to come to Barcelona, Spain for the Free and Open Source Software for Geospatial conference in Semptember this year, then you best register right now, as early bird registration ends this Tuesday 15 June 2010. http://2010.foss4g.org/registration.php FOSS4G is the international Free

Re: [postgis-users] No index usage on geography query plan?

2010-06-01 Thread Paul Ramsey
On Mon, May 31, 2010 at 10:27 PM, Paragon Corporation l...@pcorp.us wrote: On that thought.  Remember how geometry intersects performance significantly increased with prepared geometry algorithm, are we using that same kind of prepared geometry logic for geography. No, we are not. The

Re: [postgis-users] No index usage on geography query plan?

2010-06-01 Thread Paul Ramsey
...@refractions.net wrote: Perhaps it could use an in-memory bounding prism index?  You're using a disk-based one used for geography types, right? Paul Ramsey wrote: On Mon, May 31, 2010 at 10:27 PM, Paragon Corporation l...@pcorp.us wrote: On that thought.  Remember how geometry intersects performance

Re: [postgis-users] No index usage on geography query plan?

2010-05-31 Thread Paul Ramsey
Actually it's slower because the calculations require lots of transcendental math. Anyhow, it's slower. If anyone wants a quote on speed improvements, I'm happy to provide one, I have some good ideas about how to speed things up with some better data structures and caching. P. On Mon, May 31,

Re: [postgis-users] No index usage on geography query plan?

2010-05-31 Thread Paul Ramsey
for intersecting 150k polygons is not stellar given how we've been spoiled with geometries in the past. Anyway, maybe a warning is in order for people considering moving across what do you think? On 1 June 2010 07:00, Paul Ramsey pram...@opengeo.org wrote: Actually it's slower because

Re: [postgis-users] st_isvalid stop the server

2010-05-30 Thread Paul Ramsey
Sounds like all calls to st_isvalid fail, yes? As you can imagine, this is not behaviour we see on other platforms. I wonder if anyone else on Win2008 Server using the EBD distribution see a similar thing? P On Sun, May 30, 2010 at 1:58 AM, Colin East colin.e...@geospatial-ict.com.au wrote:

Re: [postgis-users] ERROR: could not load library /usr/local/pgsql/lib/postgis-1.5.so

2010-05-27 Thread Paul Ramsey
Run ldd /usr/local/pgsql/lib/postgis-1.5.so And see what it says... BTW, you shouldn't install PostGIS into template1 unless you want all your databases to be PostGIS enabled. A better practice is to make a template_postgis database and install into that. Paul On Thu, May 27, 2010 at 10:06

Re: [postgis-users] ERROR: could not load library /usr/local/pgsql/lib/postgis-1.5.so

2010-05-27 Thread Paul Ramsey
Yes, after installing a new library, run ldconfig as root. This informs the linker to check for new libraries (in the directories listed in /etc/ld.so.conf) P On Thu, May 27, 2010 at 10:31 AM, Kai Behncke kai-behn...@gmx.de wrote: Hi you I bet on missing ldconfig after libproj install.

Re: [postgis-users] ERROR: could not load library /usr/local/pgsql/lib/postgis-1.5.so

2010-05-27 Thread Paul Ramsey
/postgis-1.5.so: undefined symbol: GEOSHausdorffDistance -- That is really weird?? Best regards, Kai Original-Nachricht Datum: Thu, 27 May 2010 10:39:10 -0400 Von: Paul Ramsey pram...@opengeo.org An: PostGIS Users Discussion postgis-users

Re: [postgis-users] Retrieving and storing Geography column data through JDBC (Java/Hibernate)

2010-05-21 Thread Paul Ramsey
You should file a ticket on it... I think if you create a function geography(bytea) that just call the ST_GeogFromWKB() function that should get around your casting problem. CREATE OR REPLACE FUNCTION geography(bytea) RETURNS geography AS 'SELECT ST_GeogFromWKB($1)'

Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Paul Ramsey
3857 is a Mercator projection. Your coordinates are geographics. If you mis-declare your SRS (as, in your case, declaring that geographics are mercators) then transform will spit out funny numbers on the basis of that initial mistake. P On Thu, May 20, 2010 at 9:38 AM, Ronald Phillips

Re: [postgis-users] I can't make sense of this.

2010-05-20 Thread Paul Ramsey
While the underlying map tiles in GMaps are mercator, the actual API only talks to you in geographics. This causes many people, including you, confusion. Either of the form of the map is in lat lon (it's not) or, in your case the coordinates I'm working with are in the Google projection (they

Re: [postgis-users] Question on GEOMETRY type

2010-05-19 Thread Paul Ramsey
ST_NDims() returns the number of dimensions, but that doesn't distinguish between XYM and XYZ. The ESRI compatibility functions SE_IsMeasured() and SE_Is3D() (hey, they are useful after all!) return the information you are looking for. P On Wed, May 19, 2010 at 7:23 AM, 孙琦 qsu...@gmail.com

Re: [postgis-users] Question on GEOMETRY type

2010-05-19 Thread Paul Ramsey
If you have an older version of PostGIS, the zmflag() function also returns the information you need. P 2010/5/19 Paul Ramsey pram...@opengeo.org: ST_NDims() returns the number of dimensions, but that doesn't distinguish between XYM and XYZ. The ESRI compatibility functions SE_IsMeasured

Re: [postgis-users] Question on GEOMETRY type

2010-05-19 Thread Paul Ramsey
No, it's still around. On Wed, May 19, 2010 at 8:25 AM, strk s...@keybit.net wrote: On Wed, May 19, 2010 at 07:43:03AM -0700, Paul Ramsey wrote: If you have an older version of PostGIS, the zmflag() function also returns the information you need. Which was even more useful as you could get

Re: [postgis-users] Bug or Problem with st_transform

2010-05-18 Thread Paul Ramsey
Those are the correct answers... On Tue, May 18, 2010 at 10:15 AM, Charles Galpin cgal...@lhsw.com wrote: Steve, I get the same results on 1.4 and 1.5 (but they differ from yours) On 1.4 PostgreSQL 8.4.2, compiled by Visual C++ build 1400, 32-bit POSTGIS=1.4.1 GEOS=3.2.0-CAPI-1.6.0

Re: [postgis-users] ST_CoveredBy supporting geography?

2010-05-11 Thread Paul Ramsey
Bad sentence construction in the error, perhaps? The restriction only polygon and point means that one argument must be a polygon and one must be a point. Both your arguments are polygons. P. On Tue, May 11, 2010 at 4:51 AM, Nicholas Bower n...@petangent.net wrote: I've read the 1.5 reference

Re: [postgis-users] ST_CoveredBy supporting geography?

2010-05-11 Thread Paul Ramsey
On Tue, May 11, 2010 at 4:30 PM, Nicholas Bower n...@petangent.net wrote: On 12 May 2010 08:14, Paul Ramsey pram...@opengeo.org wrote: The doc example appears to not mention the limitation in the geography implementation, which can be fixed.  The example is correct, insofar as it is against

Re: [postgis-users] ST_CoveredBy supporting geography?

2010-05-11 Thread Paul Ramsey
cushioned as you would expect.  Maybe it's just a compromise we have to live with for not returning views of New Zealand in searches of the Indian Ocean. ;-) On 12 May 2010 10:08, Paul Ramsey pram...@opengeo.org wrote: On Tue, May 11, 2010 at 4:30 PM, Nicholas Bower n...@petangent.net wrote

Re: [postgis-users] Cannot install postgis 1.5.1 on Postgres 9.0 beta1

2010-05-11 Thread Paul Ramsey
No, seems to compile and install perfectly fine under OS/X. Two regression failures (*sigh*) due to a slight change in output from SQL (select queries that don't return rows now return 'SELECT number of rows' instead of just 'SELECT') P. On Tue, May 11, 2010 at 6:13 PM, Joel Pearson

Re: [postgis-users] Dot Density idea

2010-05-06 Thread Paul Ramsey
Even-yet-random :) nice requirement. How about just starting with a regular grid and then perturbing the elements randomly with a radius of a cell size? You can use the area of the polygon and number of needed points to calculate the appropriate cell size and go from there. P On Thu, May 6, 2010

[postgis-users] FOSS4G Community Program Review

2010-04-30 Thread Paul Ramsey
It's that time of year again! The Community Program Review for FOSS4G has begun! http://2010.foss4g.org/review/ If you're going to FOSS4G, or seriously thinking about going, the review is a way to ensure that the program includes topics you are interested in. You scroll through a list of all the

Re: [postgis-users] Build errors in MAC OSX

2010-04-26 Thread Paul Ramsey
version:      2.6.16  PostGIS debug level:  0   Documentation Generation  xsltproc:             /usr/bin/xsltproc  xsl style sheets:  dblatex:  convert: On Fri, 23 Apr 2010 19:46:44 -0700, Paul Ramsey pram...@cleverelephant.ca wrote: What happens when you run 'touch

Re: [postgis-users] Build errors in MAC OSX

2010-04-26 Thread Paul Ramsey
(first use in this function) g_box.c:596: error: 'COLLECTIONTYPE' undeclared (first use in this function) g_box.c:597: error: 'LWCOLLECTION' undeclared (first use in this function) g_box.c:597: error: syntax error before ')' token On Mon, 26 Apr 2010 11:43:34 -0700, Paul Ramsey pram

Re: [postgis-users] Build errors in MAC OSX

2010-04-26 Thread Paul Ramsey
Since you're compiling from source, get it straight from the elephant's mouth: postgis.org On Mon, Apr 26, 2010 at 12:55 PM, John Connors jconn...@berkeley.edu wrote: Ok. That's what I thought. I downloaded the source from KyngChaos. -John On Mon, 26 Apr 2010 12:50:45 -0700, Paul Ramsey pram

Re: [postgis-users] Build errors in MAC OSX

2010-04-23 Thread Paul Ramsey
What happens when you run 'touch test'? P On Fri, Apr 23, 2010 at 5:33 PM, John Connors jconn...@berkeley.edu wrote: I am trying to build the PostGIS 1.5 files in Mac OSX and I am getting the following error: make -C liblwgeom gcc -g -O2  -fno-common -DPIC  -Wall -Wmissing-prototypes  -c -o

Re: [postgis-users] ST_length_spheroid and ST_distance_spheroid

2010-04-22 Thread Paul Ramsey
They don't, at least for me: postgis14=# select st_length_spheroid(GeomFromText('LINESTRING(0 0,180 0)',4326),'SPHEROID[WGS 84,6378137,298.257223563]') ; st_length_spheroid 20037508.3427892 (1 row) postgis14=# select

Re: [postgis-users] ST_length_spheroid and ST_distance_spheroid

2010-04-22 Thread Paul Ramsey
If you change the 180 to 179 do the results match up again? (ie, do any distance less than a perfect half-sphere?) P On Thu, Apr 22, 2010 at 8:06 AM, Olivier Courtin olivier.cour...@oslandia.com wrote: On Apr 22, 2010, at 4:49 PM, Paul Ramsey wrote: They don't, at least for me: postgis14

Re: [postgis-users] ST_length_spheroid and ST_distance_spheroid

2010-04-22 Thread Paul Ramsey
, at 6:54 PM, Paul Ramsey wrote: If you change the 180 to 179 do the results match up again? (ie, do any distance less than a perfect half-sphere?) Yes, right assertion. Values are the same below 180 -- Olivier ___ postgis-users mailing list

Re: [postgis-users] ST_length_spheroid and ST_distance_spheroid

2010-04-22 Thread Paul Ramsey
Explication http://a.mongers.org/clueful/20020402-peopleware-blackteam On Thu, Apr 22, 2010 at 10:48 AM, Paul Ramsey pram...@cleverelephant.ca wrote: You're such a Black Team member, Regina :) I think the geography spheroid calculation falls back to a sphere calculation if it is handed the 180

Re: [postgis-users] Error building postgis 1.5.1 on Solaris Sparc 64 bit

2010-04-16 Thread Paul Ramsey
Dunno if you have control over it, but the -xc99=none flag is worrisome if it means no c99 since postgis does in fact include a number of c99 constructs. P On Fri, Apr 16, 2010 at 7:05 AM, Teresa Fazio fa...@planetek.it wrote: Hi, I'm trying to install postgis 1.5.1 on a Solaris Sparc 64 bit,

Re: [postgis-users] PostGIS 1.5.1 causing postmaster crash on index creation

2010-04-15 Thread Paul Ramsey
Nicholas, Could you confirm that the crash is building an index on a *geography* column, not a *geometry* column? Ie, the problem has not been introduced to old geometry code, it's something in the new geography code. After that I'm going to need the data that causes the error... Paul On Thu, Apr

Re: [postgis-users] Conversion from undefined geometry to geography?

2010-04-14 Thread Paul Ramsey
- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Tuesday, April 13, 2010 11:59 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Conversion from undefined geometry to geography? Just use

Re: [postgis-users] AsBinary returns differing values on different systems

2010-04-14 Thread Paul Ramsey
Yes, the numbers will probably be slightly different as the floating point calcs will come out slightly different. And the WKT encodes slightly less precision than the WKB, so it's visible in the latter and not the former. P On Wed, Apr 14, 2010 at 2:09 AM, Tobias Sauerwein

Re: [postgis-users] Conversion from undefined geometry to geography?

2010-04-13 Thread Paul Ramsey
Just use geography(the_geom), it'll work fine. If you fine you have srid issues (I don't think you should) use geography(setsrid(the_geom,4326)) P On Tue, Apr 13, 2010 at 8:47 PM, Nicholas Bower n...@petangent.net wrote: We have some tables in which we've used Geometry to store polygon and

Re: [postgis-users] transformation discrepancy with postgis v. cs2cs

2010-03-26 Thread Paul Ramsey
Does apt have a search function? Probably the proj packagers broke the grid files out into a different proj-something package? P On Fri, Mar 26, 2010 at 10:23 AM, Bryan Keith br...@ideotrope.org wrote: Something is definitely strange with the PROJ.4 installation on that one system. If I had

Re: [postgis-users] transformation discrepancy with postgis v. cs2cs

2010-03-25 Thread Paul Ramsey
It's probably a function of your installation, I get the same results as cs2cs on my PostGIS; postgis15=# select astext(transform(setsrid(makepoint(1234488, 744181), 32003), 32100)); astext -- POINT(366704.349230461 199132.534090009) (1

Re: [postgis-users] ERROR: array size exceeds themaximumallowed(134217727)

2010-03-22 Thread Paul Ramsey
:43 PM To: Paul Ramsey Cc: PostGIS Users Discussion; Paragon Corporation Subject: Re: [postgis-users] ERROR: array size exceeds themaximumallowed(134217727) Ok, I've attached the smallest version of this query I can make before the  error goes away.  It seems to be very particular

Re: [postgis-users] ERROR: array size exceeds themaximumallowed(134217727)

2010-03-22 Thread Paul Ramsey
Mike, See if this patch makes anything better. It matches tlane's changes to the 8.4 agg finalfunc. P. On Mon, Mar 22, 2010 at 1:29 PM, Greg Stark gsst...@mit.edu wrote: On Mon, Mar 22, 2010 at 4:45 PM, Paul Ramsey pram...@cleverelephant.ca wrote: Did you already try replacing your postgis

Re: [postgis-users] ERROR: array size exceeds themaximumallowed(134217727)

2010-03-22 Thread Paul Ramsey
This looks like a winner, at least insofar as it removes the max array error condition for me in OS/X. Huge thanks to Greg Stark for digging up the references to Tom Lane's changes in the array agg stuff... On Mon, Mar 22, 2010 at 2:15 PM, Paul Ramsey pram...@cleverelephant.ca wrote: Mike, See

Re: [postgis-users] ERROR: array size exceeds themaximumallowed(134217727)

2010-03-21 Thread Paul Ramsey
- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Saturday, March 20, 2010 8:23 PM To: mgle...@alumni.uwaterloo.ca; PostGIS Users Discussion Subject: Re: [postgis-users] ERROR: array size exceeds

Re: [postgis-users] ERROR: array size exceeds themaximumallowed(134217727)

2010-03-21 Thread Paul Ramsey
of the statement, are you able to get a segfault? Mike On Sunday 21 March 2010 12:57:03 Paul Ramsey wrote: As I was installing KUbuntu, I realized I should try the query on my own system, and under OS/X 10.6 I see the array error, though it seems to be cleanly trapped, there is no segfault. crashdb

Re: [postgis-users] ERROR: array size exceeds the maximum allowed (134217727)

2010-03-20 Thread Paul Ramsey
Actually, memunion does the opposite, it passes the resultant and preserves mem. The default behavior is fast-but-memory-hungry. And has been for some time, though in different forms. There were some bugs in the array handling code, but Mark CA killed most of them, so the latest 1.5 and 1.4

Re: [postgis-users] ERROR: array size exceeds the maximum allowed(134217727)

2010-03-20 Thread Paul Ramsey
-Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Saturday, March 20, 2010 10:56 AM To: PostGIS Users Discussion; mgle...@alumni.uwaterloo.ca Subject: Re: [postgis-users

Re: [postgis-users] Read file encoding from from shape file

2010-03-20 Thread Paul Ramsey
Yes, there's patches to our shapelib that don't exist in the mainline. The process needs to identify our changes to feed back to mainline, update mainline, then bring that in. P. On Sat, Mar 20, 2010 at 3:41 PM, Peter Hopfgartner peter.hopfgart...@r3-gis.com wrote: Paul Ramsey wrote: I

[postgis-users] FOSS4G 2010 Presentation Deadline is April 15, 2010

2010-03-18 Thread Paul Ramsey
From the Committee: -- We are pleased to announce that the deadline for Abstract submissions (General and Academic Sessions) has been postponed to April 15th, 2010. == General Sessions == FOSS4G presentations are 25 minute talks, with a 5 minute question and

Re: [postgis-users] PostGIS/PostGres Configuration

2010-03-18 Thread Paul Ramsey
: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Tuesday, March 16, 2010 6:25 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS/PostGres Configuration Don't need to... run this command

Re: [postgis-users] GEOS intersects() threw an error!

2010-03-17 Thread Paul Ramsey
Very reasonable... ticket that as an enhancement please! http://trac.osgeo.org/postgis p On Wed, Mar 17, 2010 at 8:54 AM, Jerry Carter je...@jerrycarter.org wrote: Thanks.  I've already started down that path. The real issue in my mind is the error text.  If GEOS throws an error, couldn't

Re: [postgis-users] PostGIS/PostGres Configuration

2010-03-16 Thread Paul Ramsey
: (250) 381-9295 Cell:     (250) 516-2481 -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Monday, March 15, 2010 8:38 PM To: PostGIS Users Discussion Subject: Re: [postgis

Re: [postgis-users] PostGIS/PostGres Configuration

2010-03-16 Thread Paul Ramsey
Services Coordinator, ICIS www.icisociety.ca Office: (250) 381-9295 Cell:     (250) 516-2481 -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent: Tuesday, March 16, 2010 5:31 PM

Re: [postgis-users] PostGIS/PostGres Configuration

2010-03-16 Thread Paul Ramsey
. Steffan Chmuryk Technical Services Coordinator, ICIS www.icisociety.ca Office:   (250) 381-9295 Cell:     (250) 516-2481 -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paul Ramsey Sent

Re: [postgis-users] PostGIS with ArcGIS Desktop

2010-03-15 Thread Paul Ramsey
Put your files in a dropbox folder. http://dropbox.com On Mon, Mar 15, 2010 at 2:26 AM, Wenbert Del Rosario wenb...@gmail.com wrote: Hello, I am new comer to the GIS world. I hope you will be able to help me with my problem. But first, I have some questions: Will ArcMap work directly with

Re: [postgis-users] Proj on centos 5.2

2010-03-15 Thread Paul Ramsey
What does from base repositories mean? If you compiled from source, and you had proj-devel installed, it would pick up your system proj library. Perhaps you haven't installed proj-devel? P On Mon, Mar 15, 2010 at 10:50 AM, Pedro Monteiro monteiro.s.pe...@gmail.com wrote: Hi, I've installed

Re: [postgis-users] Proj on centos 5.2

2010-03-15 Thread Paul Ramsey
not compiled it from source, Postgis it's working except functions related to proj.I 've been checking my installation and postgis was installed via yum from EPEL repositories and proj from centos base repositories. Pedro 2010/3/15 Paul Ramsey pram...@opengeo.org What does from base

Re: [postgis-users] PostGIS/PostGres Configuration

2010-03-15 Thread Paul Ramsey
Steffan, Leave your localhost entry in place, it's useful. Make a copy of the line and edit the copy. Change localhost to 192.168.0.0 and change 32 to 16. Ensure that listen_addresses = '*' in your postgresql.conf file. Restart the database Try again. P On Mon, Mar 15, 2010 at 11:50 AM, Steffan

Re: [postgis-users] PostGIS/PostGres Configuration

2010-03-15 Thread Paul Ramsey
] On Behalf Of Paul Ramsey Sent: Monday, March 15, 2010 12:15 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] PostGIS/PostGres Configuration Steffan, Leave your localhost entry in place, it's useful. Make a copy of the line and edit the copy. Change localhost to 192.168.0.0

Re: [postgis-users] PostGIS manager: importing multilinestring

2010-03-12 Thread Paul Ramsey
Paolo, Put the shapefile somewhere I can pull it and I'll see if I can replicate. You haven't specified your PostGIS version, which is important. P On Fri, Mar 12, 2010 at 8:30 AM, Paolo Cavallini cavall...@faunalia.it wrote: Hi all. While importing a shapefile into postgis, I see that the

Re: [postgis-users] PostGIS manager: importing multilinestring

2010-03-12 Thread Paul Ramsey
That appears to have fixed things on OS/X. Can you port back into 1.5 branch? P On Fri, Mar 12, 2010 at 10:49 AM, Sandro Santilli(strk) s...@keybit.net wrote: I found memory errors in the loader, and fixed in trunk with commit 5430. Please test again with the new version. --strk;  ()  

Re: [postgis-users] Postgis functions returning hidden weird characters! (?)

2010-03-11 Thread Paul Ramsey
It looks to me like ST_AsSVG doesn't very carefully handle empty geometry inputs, so you're getting a non-terminated string back. http://trac.osgeo.org/postgis/ticket/463 On Thu, Mar 11, 2010 at 6:36 AM, Vyron Antoniou v.anton...@ucl.ac.uk wrote: Hi, Check this out: select assvg(difference(

[postgis-users] PostGIS 1.4.2 and 1.5.1 Released

2010-03-11 Thread Paul Ramsey
Patch releases of the 1.5 and 1.4 PostGIS series are now available! http://postgis.org/download Fixes in 1.5.1: * #333, remove unnecessary VACUUM from install file (Kevin Neufeld) * #410, update embedded bbox when applying ST_SetPoint, ST_AddPoint ST_RemovePoint to a linestring (Paul Ramsey

Re: [postgis-users] PostGIS 1.5.0 build failure

2010-03-10 Thread Paul Ramsey
Wrong PostgreSQL version? We only support 8.3+ on PostGIS 1.5. On Wed, Mar 10, 2010 at 6:21 AM, Sachin Srivastava sachin.srivastava1...@gmail.com wrote: Hi all, I am building postgis-1.5.0 with proj-4.7.0, geos-3.2.0, libxml2-2.7.6, postgresql-9.0alpha4 on Windows7 (MinGW) lwgeom_accum.c:

Re: [postgis-users] PostGIS 1.5.0 build failure

2010-03-10 Thread Paul Ramsey
: 9.0alpha4 is 8.3+ or i am missing something?? On 3/10/10 8:44 PM, Paul Ramsey wrote: Wrong PostgreSQL version? We only support 8.3+ on PostGIS 1.5. On Wed, Mar 10, 2010 at 6:21 AM, Sachin Srivastava sachin.srivastava1...@gmail.com  wrote: Hi all, I am building postgis-1.5.0 with proj-4.7.0

Re: [postgis-users] PostGIS 1.5.0 build failure

2010-03-10 Thread Paul Ramsey
OK, patched in the 1.5 branch http://svn.osgeo.org/postgis/branches/1.5 another release to push 1.5.1 out... P On Wed, Mar 10, 2010 at 7:28 AM, Paul Ramsey pram...@opengeo.org wrote: No, it was me missing something. Perhaps something has changed since our last compatibility patch

Re: [postgis-users] Postgis functions returning hidden weird characters! (?)

2010-03-06 Thread Paul Ramsey
Does select ST_AsSVG('GEOMETRYCOLLECTION EMPTY'::geometry,0,5); give the same odd result? (Should, it's the same fundamental input...) I'm not sure what you're seeing though, as all attempts in the database to find anything odd in the input fail for me: geog=# select

Re: [postgis-users] error messages upgrading to 1.5.0

2010-03-02 Thread Paul Ramsey
All notices, non-harmful. We recognize that this amount of noise is probably counter-productive... http://trac.osgeo.org/postgis/ticket/415 On Tue, Mar 2, 2010 at 5:14 PM, P Kishor punk.k...@gmail.com wrote: Hi, I upgraded to Postgis 1.5.0, but in the process, encountered the following

Re: [postgis-users] Read file encoding from from shape file

2010-02-26 Thread Paul Ramsey
I was never certain that ESRI software actually respected the DBF code page flags, but your reference indicates they do, so this seems reasonable. Some investigation of the current state of shapelib WRT encoding would be wise, as I think we should update our shapelib to the current version when we

<    1   2   3   4   5   6   7   8   >