| 02:20:56 | sigq: | geosfeed: WikiStart edited by mloskot <http://trac.osgeo.org/geos/wiki/WikiStart> |
| 02:30:10 | sigq: | geosfeed: Ticket #179 ( defect updated ): VC makefile failures <http://trac.osgeo.org/geos/ticket/179#comment:1> |
| 03:04:13 | CIA-6: | robe * r2851 /trunk/doc/ ( reference.xml reference_new.xml ): Move ST_MakeLine from reference.xml to reference_new.xml and add an additional example to ST_MakeLine |
| 03:34:59 | CIA-6: | robe * r2852 /trunk/doc/reference_new.xml: typo |
| 05:19:15 | sigq: | geosfeed: WikiStart edited by mloskot <http://trac.osgeo.org/geos/wiki/WikiStart> |
| 05:34:52 | CIA-6: | mloskot * r2130 /trunk/source/Makefile.vc: For building with Visual C++, added new flag DEBUG=1 ( see GEOS building instructions on GEOS Wiki ). Added missing flags for Visual C++ compiler, in release and debug configuration. |
| 06:26:48 | mumrah: | Can anyone direct me to the SRID for WGS84? or perhaps a good reference for figuring out srids? The spatial_ref_sys table is a bit dense for me |
| 06:26:56 | mumrah: | !srid |
| 06:31:47 | darkblue_B: | ... http://spatialreference.org/ref/epsg/4326/postgis/ |
| 06:32:55 | mumrah: | danke! |
| 06:33:15 | bitner: | http://spatialreference.org/ref/epsg/4326 will give you info on that projection |
| 06:33:17 | sigq: | Title: WGS 84: EPSG Projection -- Spatial Reference ( at spatialreference.org ) |
| 06:33:46 | bitner: | http://spatialreference.org/ provides some utilities for searching for projections and srids too |
| 06:33:47 | sigq: | Title: Home -- Spatial Reference ( at spatialreference.org ) |
| 07:03:44 | sigq: | geosfeed: Ticket #189 ( defect updated ): Build problems with Sun Studio compiler ( on Solaris x86 & Sparc ) <http://trac.osgeo.org/geos/ticket/189#comment:2> |
| 07:04:52 | sigq: | geosfeed: Ticket #192 ( defect updated ): configure.in assumes gcc / autogen.sh assumes GNU which <http://trac.osgeo.org/geos/ticket/192#comment:2> |
| 07:33:47 | CIA-6: | kneufeld * r2853 /trunk/doc/Makefile.in: applied patch from Mark to fix the if/then/else so the Makefile can run on older systems ( ie. FC3 ) |
| 09:52:07 | CIA-6: | robe * r2854 /trunk/doc/ ( reference.xml reference_new.xml ): Move ST_Intersection, ST_Disjoint provide examples for both. |
| 09:55:05 | CIA-6: | robe * r2855 /trunk/doc/reference_new.xml: remove includes index note for ST_MakeLine |
| 10:02:34 | CIA-6: | robe * r2856 /trunk/doc/reference_new.xml: minor corrections to ST_SetSRID and UpdateGeometrySRID |
| 10:23:36 | arkygeek: | jef: hi :- ) |
| 10:23:58 | arkygeek: | jef: wondering if you might be able to help me with a join ... :s |
| 10:24:33 | arkygeek: | jef: http://pgsql.privatepaste.com/9c1Vov3pnS |
| 10:24:37 | sigq: | Title: Private Paste :: Paste 9c1Vov3pnS ( at pgsql.privatepaste.com ) |
| 10:26:20 | arkygeek: | that works great.... but I need more data, and it is in another table ( SiteReports ) where the common link is SiteNo |
| 10:28:50 | jef: | arkygeek: ...from jardis join sitereports on jardis.siteno=sitereports.siteno where... |
| 10:33:52 | arkygeek: | jef: does it matter if one is integer and the other is bigint ? |
| 10:35:10 | jef: | arkygeek: no, I don't think so. |
| 10:38:48 | arkygeek: | jef: http://pgsql.privatepaste.com/f6hWcCtlIv |
| 10:38:53 | sigq: | Title: Private Paste :: Paste f6hWcCtlIv ( at pgsql.privatepaste.com ) |
| 10:39:25 | jef: | arkygeek: quote both. |
| 10:41:23 | arkygeek: | jef: ok, cool. now, to display a couple of fields from those records in SitesReport..... |
| 10:43:51 | arkygeek: | jef: http://pgsql.privatepaste.com/200wo6Q7DB |
| 10:43:54 | sigq: | Title: Private Paste :: Paste 200wo6Q7DB ( at pgsql.privatepaste.com ) |
| 10:44:13 | arkygeek: | \o/ :-D |
| 10:46:09 | arkygeek: | jef: thanks dude |
| 10:46:16 | jef: | arkygeek: np |
| 11:38:38 | CIA-6: | robe * r2857 /trunk/doc/ ( reference.xml reference_new.xml template.xml ): Move ST_Equals, ST_OrderingEquals - provide examples. Make Geometry - geometry |
| 13:20:59 | CIA-6: | kneufeld * r2858 /trunk/doc/ ( reference.xml reference_new.xml ): fixed a small typo so the autobuild process will still work. |
| 14:04:37 | CIA-6: | mloskot * r2131 /trunk/ ( 24 files in 19 dirs ): Fixed compilation on with Sun Studio compiler on Solaris x86 and Sparc ( Ticket #189 ). Thanks to Magne Mahre for the patch. |
| 14:05:40 | sigq: | geosfeed: Ticket #189 ( defect closed ): Build problems with Sun Studio compiler ( on Solaris x86 & Sparc ) <http://trac.osgeo.org/geos/ticket/189#comment:4> |
| 20:54:48 | CIA-6: | kneufeld * r2859 /trunk/doc/template.xml: Apparently, the <inlinegraphic> will become deprecated in a future version of DocBook. Now replaced with <inlinemediaobject>. |
| 20:56:21 | CIA-6: | kneufeld * r2860 /trunk/doc/using_postgis.xml: fixed small typo |
| 21:03:55 | CIA-6: | kneufeld * r2861 /trunk/doc/ ( 8 files in 3 dirs ): |
| 21:03:55 | CIA-6: | Moved ST_Crosses into new reference_new.xml file, complete with images. |
| 21:03:55 | CIA-6: | Updated css to use fixed-width fonts for programlistings. |
| 21:11:00 | CIA-6: | kneufeld * r2862 /trunk/doc/reference_new.xml: |
| 21:11:00 | CIA-6: | updated the st_crosses method: |
| 21:11:00 | CIA-6: | made the geometry parameters lowercase and made a few changes to content. |
| 22:42:26 | CIA-6: | kneufeld * r2863 /trunk/doc/ ( reference.xml reference_new.xml ): moved ST_Envelope, complete with examples. |