[prev in list] [next in list] [prev in thread] [next in thread] 

List:       fdo-commits
Subject:    [fdo-commits] r5836 -
From:       svn_fdo () osgeo ! org
Date:       2010-11-29 8:14:38
Message-ID: 20101129081438.222523900B6 () trac ! osgeo ! org
[Download RAW message or body]

Author: leaf
Date: 2010-11-29 00:14:38 -0800 (Mon, 29 Nov 2010)
New Revision: 5836

Modified:
   trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/SpatialContextReader.cpp
Log:
On behalf of Cheney Sun

Ticket #731: PostGIS: Add the prefix for the coordinate system name
Select the 'auth_name' from the table spatial_ref_sys as the prefix of the CS name.



Modified: trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/SpatialContextReader.cpp
 ===================================================================
--- trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/SpatialContextReader.cpp	2010-11-26 \
                19:56:01 UTC (rev 5835)
+++ trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/SpatialContextReader.cpp	2010-11-29 \
08:14:38 UTC (rev 5836) @@ -167,11 +167,14 @@
             mCSname = L"";
         }
 */
-        mCSname = FdoSmPhReader::GetString(L"", L"srid");;
+        mCSname = FdoSmPhReader::GetString(L"", L"srid");
 
-		double xmin = -2000000;
-		double xmax = 2000000;
-		double ymin = -2000000;
+        if (mCSname != L"")
+            mCSname = FdoSmPhReader::GetString(L"", L"authname") + L":" + \
FdoSmPhReader::GetString(L"", L"srid"); +
+        double xmin = -2000000;
+        double xmax = 2000000;
+        double ymin = -2000000;
 		double ymax = 2000000;
 
 		FdoPtr<FdoFgfGeometryFactory> gf = FdoFgfGeometryFactory::GetInstance();
@@ -213,6 +216,7 @@
     // Generate sql statement if not already done
     sqlString = FdoStringP::Format(
           L"select b.srid, a.f_table_schema||'.'||a.f_table_name as geomtablename, \
a.f_geometry_column as geomcolumnname, \n" +          L" b.auth_name as authname, \n"
 		  L" b.srtext as wktext, \n"
 		  L" a.coord_dimension as dimension,\n"
 		  L" a.type as geomtype\n"
@@ -265,6 +269,12 @@
 
     pField = new FdoSmPhField(
         row, 
+        L"authname",
+        row->CreateColumnChar(L"authname",true, 32)
+    );
+
+    pField = new FdoSmPhField(
+        row, 
         L"wktext",
         row->CreateColumnChar(L"wktext",true, 2048)
     );

_______________________________________________
fdo-commits mailing list
fdo-commits@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-commits


[prev in list] [next in list] [prev in thread] [next in thread]