[postgis-tickets] [PostGIS] #2363: st_distance with an added Integer value is not working in 2.0

PostGIS trac at osgeo.org
Mon Jun 24 12:52:53 PDT 2013


#2363: st_distance with an added Integer value is not working in 2.0
-------------------------+--------------------------------------------------
  Reporter:  vbalent     |       Owner:  pramsey      
      Type:  defect      |      Status:  closed       
  Priority:  blocker     |   Milestone:  PostGIS 2.0.4
 Component:  postgis     |     Version:  2.0.x        
Resolution:  worksforme  |    Keywords:               
-------------------------+--------------------------------------------------
Changes (by vbalent):

 * cc: vbalent (added)
  * status:  new => closed
  * resolution:  => worksforme


Comment:

 Thanks,

 For all your help.

 I finally got the Query to work.

 SELECT * FROM PART_1_CRIMES where
 ST_DISTANCE(ST_TRANSFORM(ST_POINTFROMTEXT('POINT(-73.76545859999999
 42.658618)', 4326), 2260),
  ST_Transform(ST_POINTFROMTEXT(ST_AsText(GEOM),4326),2260))<=5280;

 Was not a proj issue, just getting the syntax correct.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2363#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list