| 02:02:46 | statim: | anything i can do to make this work? select point( 1,2 ) <@ any array_accum( circle( point( latitude, longitude ), 0.5 ) ) from location_jobs; im trying to see if a point falls in any of the circles in an array |
| 02:22:44 | CIA-6: | mcayland * r2882 /trunk/configure.ac: |
| 02:22:44 | CIA-6: | Add PROJ.4 version check to ensure that a minimum version of 4.5.0 is installed. |
| 02:22:44 | CIA-6: | This is to ensure that the pj_set_searchpath( ) function is present ( note: it was |
| 02:22:44 | CIA-6: | actually added in 4.4.9, however we version detect on major.minor rather than |
| 02:22:44 | CIA-6: | major.minor.release ) |
| 07:23:38 | darkblue_B: | postgis docs make succeeded this time |
| 19:29:34 | fgarat: | hi all!! |
| 19:31:40 | fgarat: | i need to get the orientation of pointA to pointB. ( pointA and pointB are geometries )... and i have to know if pointA is at north,south,east or west of pointB |
| 19:31:47 | fgarat: | any help? |
| 20:15:53 | fgarat: | anyone? |
| 20:18:32 | pimpaa: | hello |
| 20:19:04 | pimpaa: | use |
| 20:19:08 | pimpaa: | select ST_azimuth( geometry, geometry ) |
| 20:19:10 | pimpaa: | like |
| 20:19:20 | pimpaa: | select st_azimuth( pointa, pointb ) |
| 20:19:44 | pimpaa: | Return value is in radian |
| 20:44:28 | fgarat: | thanks pimpaa |
| 20:50:13 | pimpaa: | np |