[GRASS-user] PostgreSQL append

[Pavel Iacovlev]

> g.proj -w
GEOGCS["wgs84",
    DATUM["WGS_1984",
        SPHEROID["wgs84",6378137,298.257223563],
        TOWGS84[0.000,0.000,0.000]],
    PRIMEM["Greenwich",0],
    UNIT["degree",0.0174532925199433]]

shape .prj file:
GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["wgs84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]

On Mon, Aug 3, 2009 at 12:46 AM, Markus Neteler<neteler at osgeo.org> wrote:
> On Sun, Aug 2, 2009 at 11:35 PM, Pavel Iacovlev<iacovlev.pavel at gmail.com> wrote:
>> I am very new to grass so I am not sure if it's a bug or not, maybe I
>> defined my "location" incorrectly, how do I check ?
>>
>> select * from geometry_columns where f_table_name = 'flood'
>>
>> f_table_catalog f_table_schema  f_table_name    f_geometry_column
>>  coord_dimension srid    type
>>       public  flood   wkb_geometry    2 900917 POLYGON
>
> Two ideas:
>
> - run to obtain the projection of the location as WKT output:
>  g.proj -w
>
> - export to SHAPE file first and see if the .prj file is ok (LatLong in
>   your case).
>
> If both is fine, then would I suspect some problem with the PostGIS
> export.
>
> Markus
>



-- 
http://iap.md, The future is open