#POSTGIS IRC Log - 2009-05-21

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
01:35:10 rullzer: hi, I have a geom objet ( LINESTRING ) is it possible to split it into lines so I get all the parts the LINESTRING is constructed from?
01:51:55 CIA-34: strk * r2513 /trunk/ ( ChangeLog.svn Makefile.am authors.svn ):
01:51:55 CIA-34: Add a rule to generate a ChangeLog using svn2cl. The authors.svn file will be
01:51:55 CIA-34: used to map usernames and full names: please expand your own nick. The generated
01:51:55 CIA-34: ChangeLog is added to repository to show you how it looks. If everybody agree we
01:51:55 CIA-34: could rename this to ChangeLog and stop requiring manual edits ( +1 from me: )
02:03:52 CIA-34: strk * r2514 /trunk/ ( ChangeLog.svn Makefile.am authors.svn ): Add Mat's and Paul's entries, make ChangeLog.svn rule phony
06:43:11 strk: GEOS wishes anyone ?
07:15:41 : * bitner wishes someone would make an sdeemu equivalent to sit in front postgis ala the old imsemu in front of mapserver, really doesn't want to shell out for ArcGIS Server
10:51:01 DavidAndCarr: is there a way to query and create a box based off a lat/lng point with a distance of 5 miles off that point? so I pass in a lat/lng and a radius distance, and I'm returned a NW and SE lat/lng pairings?
10:52:15 springmeyer: buffer the point and take the extent of the resulting polygon
10:56:30 DavidAndCarr: :: googles that ::
10:58:42 jlivni: better: use box2d or buffer( geom,1,1 )
11:02:41 jlivni: DavidAndCarr: that last param is the # of segments per 1/4 circle, so a value of 1 means you get a box
11:02:52 DavidAndCarr: gotcha
11:02:59 jlivni: but i think st_box2d might be the smoother method
11:03:03 DavidAndCarr: thank you : )
11:04:40 jlivni: DavidAndCarr: should mention that to get miles you need to transform the lat/lon to a projection where distance makes sense
11:04:52 DavidAndCarr: ok
11:06:07 jlivni: eg st_buffer( st_transform( orig_geom,1234 ),5*1609,1 )
11:06:19 jlivni: where 1234 = epsg code of your chosen projection
11:06:28 : * jlivni gets lunch