| 02:15:04 | sigq: | geosfeed: Ticket #202 ( defect updated ): Undefined behavior in Coordinate::hashCode <http://trac.osgeo.org/geos/ticket/202#comment:10> |
| 15:23:20 | magic_hat: | hey all. i have a table that has geometries in SRID 4326. I'm using ST_distance to measure between points, but I'd like the results in miles. how do I get there? |
| 17:06:55 | jlivni: | st_distance_spheroid would be one quick way ( meters ) |
| 17:07:13 | jlivni: | magic_hat: or you could transform your projections to something that makes more sense for your local area ( not sure where your points are ) |
| 17:08:02 | jlivni: | for example, here in California, i might do st_distance( st_transform( geom,26910 ),st_transform( othergeom,26910 ) ) |
| 19:16:58 | KBlade: | need some guide on mapserver postgis |
| 19:17:11 | KBlade: | i have this column wkb_geometry |
| 19:17:26 | KBlade: | and ogc_fid |
| 19:17:39 | KBlade: | how do I specify the DATA |