#POSTGIS IRC Log - 2009-06-19

For logs after Feb 3, 2007, all times are GMT-8. Prior logs are GMT-9.
Back to Logs
00:09:19 Viivi: hi, question about creating polygons from linework
00:10:09 Viivi: using polygonize on linework like this: http://globus.eomap.ee/test/postgis/shape.png will create only one big polygon, right?
00:47:16 Viivi: nope, my mistake, polygonize works as espected : )
03:56:40 mlechner: hi, i need a print-quality ( or vector ) version of the official postgis logo - where can i download it?
04:15:30 CIA-3: robe * r4182 /trunk/doc/installation.xml: fix type and add --with-gui description for building loader gui
06:14:19 CIA-3: robe * r4183 /trunk/doc/reference.xml: typo in docs --
07:08:28 CIA-3: robe * r4184 /trunk/doc/xsl/postgis_gardentest.sql.xsl: test not handling aggregates right
09:08:06 CIA-3: robe * r4185 /trunk/doc/xsl/postgis_gardentest.sql.xsl: get rid of ref_geom so doesn't break agg checks
09:25:41 CIA-3: mloskot * r4186 /spike/wktraster/scripts/windownsample.py:
09:25:41 CIA-3: [wktraster] windownsample.py: implemented mechanism of appending padding pixels
09:25:41 CIA-3: to the right-most edge of raster. For instance, read 4x4 raster as 8x4 and 4
09:25:41 CIA-3: pixels of padding are appended to the right edge. Should work with changing
09:25:42 CIA-3: resolution.
11:39:16 TJCRI: can postgis do conversion from say lat/lon to a diff. projection?
11:39:21 TJCRI: on the fly
11:45:57 darkblue_B: yes
12:04:14 pramsey: select st_transform( st_setsrid( 'POINT( -126 40 )',4326 ),26910 );
12:04:56 pramsey: select st_astext( st_transform( st_setsrid( 'POINT( -126 40 )',4326 ),26910 ) );
12:09:00 darkblue_B: when do you need GeomFromText( ) and when can you just say POINT as a literal like that? well, no matter because you rarely have hard coded data in queries I'd guess
12:09:30 darkblue_B: the box2d data type cast
12:09:51 darkblue_B: I fumble around with that every time
12:10:33 darkblue_B: the 1.4 manual is sooo much better
12:10:49 darkblue_B: what a great undertaking.. its been a while now
12:18:28 darkblue_B: TJCRI: PostGIS 1.4 manual, FAQ 3.8 "How do I pefoem a coordinate reprojection as part of a query ?"
12:19:56 darkblue_B: ok, section 4.1.1 goes into some detail about valid represenations
12:20:38 darkblue_B: 4.1.x
12:22:15 darkblue_B: aha faq.xml in trunk
12:23:19 TJCRI: thank you pramsey and darkblue_B
12:24:11 TJCRI: that seems like it will work perfectly
12:24:40 darkblue_B: TJCRI: you're welcome.. its an undertaking, this system.. I find it clearer than the small bit of Oracle I've done
12:25:18 TJCRI: well I just have to jump in the lake and get wet .. which I will be doing with this project i have going on : )
12:25:42 TJCRI: so far I have just dabbled my toes to get a feeling for it but soon need to jump head first
12:26:34 darkblue_B: here is a reasonably recent 1.4 doc build
12:26:50 darkblue_B: http://71.202.181.1/postgis/
12:26:51 sigq: Title: PostGIS 1.4.0SVN Manual ( at 71.202.181.1 )
12:26:53 TJCRI: what is the proper name for the projection #? for example: 4326 ? how would I ask for that number based on a projection name?
12:27:13 darkblue_B: those numbers correspond to entries in the spatial_ref_sys table
12:27:49 TJCRI: ok so If I have MI State Plain NAD feet I should be able to find a corresponding number?
12:28:02 darkblue_B: which could be anything literally, but correspond to conventions on ESRI and EPSG numbering schemes
12:28:38 darkblue_B: http://spatialreference.org is handy
12:28:39 sigq: Title: Home -- Spatial Reference ( at spatialreference.org )
12:28:45 TJCRI: ah EPSG numbering scheme ok so thats what I have to compare probably
12:28:51 darkblue_B: sometimes its hard to search though
12:29:50 TJCRI: well I have a nice listing for MI here: http://spatialreference.org/ref/epsg/?search=michigan&srtext=Search
12:29:51 sigq: Title: Spatial Reference List -- Spatial Reference ( at spatialreference.org )
12:32:41 TJCRI: well it looks like I need EPSG:2898
14:27:37 CIA-3: strk * r2593 /trunk/capi/ ( geos_c.cpp geos_c.h.in geos_ts_c.cpp ): Extend the C-API interface to expose a GEOSBufferWithStyle ( and corresponding thread-safe version ) and related enums.