[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