[ka-Map-users] kamap w/ pgsql

[Pg]

I use PostGIS layers in kaMap and it's ok for me.

I usualy specify the PROJECTION in the layer using the same EPSG number used
as SRID of the PostGIS table. For example:

  PROJECTION
    "init=epsg:42304"
  END

Hope this could help you.


2005/12/30, Ryan <ollerery at engr.orst.edu>:
>
>  I am able to get kamap to render images from a shp file just fine, but
> when I make a call to my postgres database in my map file I get nothing but
> broken images.  I am able to make calls the to the database just fine with
> the gmap75 framework, but for some reason when I try and use the same map
> file with kamap, the layers that include calls to the database seem to be
> breaking things.
>
>
>
> Any suggestions?
>
>
>
> Here is a layer from my map file that when drawn with kamap results in
> nothing but broken images
>
>
>
> # tr_highway - normal
>
> LAYER
>
>   NAME "tr_highway"
>
>   GROUP "grp_tr_highway"
>
>   CONNECTIONTYPE postgis
>
>   CONNECTION "user=xxxxx password=xxxxxxxx dbname=transport"
>
>   DATA "the_geom from tr_highway"
>
>   TYPE LINE
>
>   STATUS ON
>
>   CLASS
>
>     COLOR 255 180 0
>
>     SIZE 6
>
>     MAXSCALE 3600000
>
>     MINSCALE 6000
>
>   END
>
> PROJECTION
>
>     "proj=lcc"
>
>     "lat_1=43.0"
>
>     "lat_2=45.5"
>
>     "lat_0=41.75"
>
>     "lon_0=-120.5"
>
>     "x_0=400000"
>
>     "y_0=0"
>
>     "ellps=GRS80"
>
>     "datum=NAD83"
>
>     "units=ft"
>
>   END # of projection
>
> END # end of tr_highway - normal layer
>
>
>
>
>
> Thanks,
>
> -Ryan
>
> _______________________________________________
> ka-Map-users mailing list
> ka-Map-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/ka-map-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ka-map-users/attachments/20051230/810fcccc/attachment.html