[postgis-tickets] [PostGIS] #2369: SQL Statemant Works in Windows version 1.5x Not in Liunx version 2.0x
PostGIS
trac at osgeo.org
Tue Jun 25 17:05:18 PDT 2013
#2369: SQL Statemant Works in Windows version 1.5x Not in Liunx version 2.0x
----------------------+-----------------------------------------------------
Reporter: vbalent | Owner: pramsey
Type: defect | Status: closed
Priority: high | Milestone: PostGIS 2.0.4
Component: postgis | Version: 2.0.x
Resolution: invalid | Keywords:
----------------------+-----------------------------------------------------
Changes (by robe):
* status: new => closed
* resolution: => invalid
Comment:
vbalent based on the last ticket you posted, I suggested you do the below
query because given the convoluted query you gave I had already concluded
your data is stamped as 2260 but is really in wgs 84 long lat (4326) as
Bborie also mentioned above.
Sorry I had a typo in the last ticket could I gave. I apologize for the
confusion there. You should run this
{{{
ALTER TABLE part_1_crimes ALTER TYPE geom geometry(POINT,2260) USING
ST_Transform(ST_SetSRID(geom, 4326),2260);
}}}
I'm marking this as invalid again because your issue seems to not be a bug
but just a newbie misunderstanding about using PostGIS. Please subscribe
to our user's list and post your questions there before assuming they are
bugs in the software.
http://lists.osgeo.org/mailman/listinfo/postgis-users
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2369#comment:5>
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