#POSTGIS IRC Log - 2009-05-07

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
00:38:26 sigq: geosfeed: Ticket #135 ( defect closed ): *_getDimensions functions do not return correct dimensions <http://trac.osgeo.org/geos/ticket/135#comment:7>
00:41:49 CIA-34: strk * r2485 /trunk/tests/unit/capi/GEOSCoordSeqTest.cpp: Add test for creating a CoordinateSequence with at least 2 dimension
00:48:45 CIA-34: strk * r2486 /trunk/source/ ( 2 files in 2 dirs ): Port info, doxygen cleanups
01:11:19 strk: uhm, can't remember why buffer.xml isn't automatically run
01:11:25 strk: it even fail, btw
01:22:38 sigq: geosfeed: Ticket #188 ( defect updated ): Crash in RightmostEdgeFinder::findEdge( ) <http://trac.osgeo.org/geos/ticket/188#comment:3>
07:32:31 CIA-34: strk * r2487 /trunk/tests/xmltester/XMLTester.cpp: remove code duplication on buffer result validation
07:32:55 CIA-34: strk * r2488 /trunk/tests/xmltester/ ( Makefile.am tests/bug188.xml ): Add XML testcase for bug 188
07:34:20 sigq: geosfeed: Ticket #188 ( defect closed ): Crash in RightmostEdgeFinder::findEdge( ) <http://trac.osgeo.org/geos/ticket/188#comment:4>
07:38:53 sigq: geosfeed: Ticket #234 ( defect updated ): Intersection Crashes On Multipolygons With Empty Holes <http://trac.osgeo.org/geos/ticket/234#comment:3>
07:53:28 CIA-34: strk * r2489 /trunk/ ( 4 files in 2 dirs ): Skip empty components when building GeometryGraph. Fixes bug #234. Add non-automated test for it, and README file in the directory containing it...
07:56:47 CIA-34: strk * r2490 /trunk/tests/bigtest/bug234.cpp: minor debug output improvement
07:58:52 sigq: geosfeed: Ticket #234 ( defect closed ): Intersection Crashes On Multipolygons With Empty Holes <http://trac.osgeo.org/geos/ticket/234#comment:4>
08:11:43 CIA-34: strk * r2491 /trunk/capi/ ( geos_c.cpp geos_c.h.in geos_ts_c.cpp ): Add "thread-safe" version of GEOSGeom_setSRID. Closes bug #242.
08:14:13 sigq: geosfeed: Ticket #242 ( defect updated ): GEOSSetSRID_r missing, GEOSSetSRID duplicated <http://trac.osgeo.org/geos/ticket/242#comment:6>
08:32:34 sjzzalx: I have an index on my geometry column, and I run st_distance, but it doesn't seem to use the index. Is there a way I can help it to do so? My query is slower than I'd like right now
08:35:11 pramsey: use st_dwithin( )
08:35:33 DavidAndCarr: I'm trying to confirm GIS is installed, is there some kind of beginner walkthrough that I can use?
08:39:17 TheSteve0: pramsey: ping
08:39:29 pramsey: TheSteve0: pong
08:39:36 TheSteve0: nice post btw
08:40:00 TheSteve0: Do you care about scalability and stability or speed on that app?
08:40:11 pramsey: nope, it's an example
08:40:18 TheSteve0: cool
08:40:25 pramsey: "write SQL, see the result in your browser
08:40:33 TheSteve0: very nice way to do it!
08:40:35 sjzzalx: pramsey: thanks, that works great.
08:40:40 pramsey: I just shudder at hte thought someone would take it home and deploy it ( how handy! )
08:41:20 TheSteve0: pramsey: that is always the fine line with providing sample code - especially when it's goal is to teach, NOT to build a production app
08:41:32 sjzzalx: Is there somewhere I can understand better why ST_DWithin uses an index and ST_Distance doesn't?
08:42:17 pramsey: funny, I just wrote 5 paragraphs on that sjzzalx
08:42:48 sjzzalx: pramsey: : )
08:43:54 pramsey: your luck day http://pastebin.com/m35334e23
08:43:56 sigq: Title: pastebin - collaborative debugging tool ( at pastebin.com )
08:45:16 TheSteve0: pramsey: nice explanation and I will update my slides accordingly
08:45:23 TheSteve0: where is that doc going to be put?
08:45:37 pramsey: it'll end up on the opengeo workshops site eventually
08:45:48 pramsey: not sure what the ETA is to roll our all our sphinx doco
08:46:37 TheSteve0: I am doing a big FOSS4G workshop at geoweb and would love to have access to this doc while I am prepping the course
08:47:14 pramsey: Sure. I think the repo is publicly viewable. http://svn.opengeo.org/workshops/postgis/spatialdbtips
08:47:15 sigq: Title: Revision 54: /postgis/spatialdbtips ( at svn.opengeo.org )
08:48:24 TheSteve0: postgis -> Desktop clients, postgis -> GeoServer, postgis -> GeoServer -> desktop clients and web clients
08:48:33 TheSteve0: that is great - I love this screenshot - http://svn.opengeo.org/workshops/postgis/spatialdbtips/source/img/arbitrary-sql1.png
08:49:51 pramsey: thanks, TheSteve0, I've been feeding this material my blood sweat and tears for the past week.
08:49:55 pramsey: I'm not sure if I love it or hate it.
08:50:04 TheSteve0: well it looks like a great way to teach the course
08:50:22 TheSteve0: where are you teaching the workshop?
08:50:32 TheSteve0: or is it a for hire kind of workshop
08:50:43 TheSteve0: If so then I will pimp your course at the end of mine
08:51:02 TheSteve0: mine is supposed to be a 4 hour - see what is possible and hope you now want to go home and use it?
08:51:05 pramsey: where 2.0
08:51:20 TheSteve0: Whoaaaaaa - you are close aren't you
08:51:32 TheSteve0: hence the blood sweat and tears
08:52:36 TheSteve0: I don't want to take too much of your time now since you are probably still prepping
08:52:40 TheSteve0: are you coming to WhereCamp?
08:52:57 TheSteve0: pramsey: I would love to talk to you about the class after you are finished with it
08:53:07 pramsey: sadly no, TheSteve0 , have to get home to the family, so back on Thurday night
08:53:32 TheSteve0: rats
08:55:04 TheSteve0: pramsey: can you see my PMs?
09:42:38 DavidAndCarr: libpq.dylib, file is not of required architecture is coming up when i try to make my ./config
09:42:39 DavidAndCarr: any ideas?
09:42:48 DavidAndCarr: os: OSX
09:43:13 pramsey: mmmm
09:43:20 pramsey: probably, install and build postgresql yourself
09:43:26 pramsey: instead of using someone else's binary
09:43:28 DavidAndCarr: :(
09:43:31 pramsey: sounds like a 32/64 mismatch
09:43:37 DavidAndCarr: yuck
09:43:44 DavidAndCarr: thats not the answer i was hoping for :x
09:43:45 DavidAndCarr: haha
09:44:18 DavidAndCarr: I bet it was one of the libraries i installed
09:44:22 DavidAndCarr: ill go back and re-install those
20:08:31 nofxx: How to calculate the bearing from a point to another? I`m missing something, is "bearing" the right keyword for this? heh
20:08:50 nofxx: I mean like degree that I can convert to N/S/E/W
20:09:15 nofxx: P1 2Km N of P2