[Mapserver-users] Virtual Spatial Data from SQL Server

[Kalpin]

I was successfull if my data in point (x,y in longitude and latitude) but
how if my data in blocks ? what must I do ?



Thank you



Kalpin Erlangga Silaen

----- Original Message ----- 
From: "IMD Listuser" <imd_listuser at comcast.net>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Friday, June 04, 2004 4:14 AM
Subject: [Mapserver-users] Virtual Spatial Data from SQL Server


> Greetings all,
>
> I would like to plot point data that is stored in a single table in my
> sql server db. According to
> http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData, I have
> configured what I believe that I need:
>
> My mapserver is:
> <!-- MapServer version 4.0.1 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
> OUTPUT=PDF OUTPUT=SWF SUPPORTS=PROJ SUPPORTS=FREETYPE
> SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
> SUPPORTS=WFS_CLIENT INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL
> INPUT=SHAPEFILE -->
>
> My VesselServer.ovf file contains:
> <OGRVRTDataSource>
>     <OGRVRTLayer name="VesselPosition">
>
> <SrcDataSource>ODBC:VSClient/VSClient at VesselTracking</SrcDataSource>
> <SrcSQL>SELECT * FROM Log WHERE ID = 496600</SrcSQL>
> <GeometryType>wkbPoint</GeometryType>
>         <LayerSRS>WGS84</LayerSRS>
> <GeometryField encoding="PointFromColumns" x="longitude_dd"
> y="latitude_dd"/>
>     </OGRVRTLayer>
> </OGRVRTDataSource>
>
> My Map file contains a layer as follows:
>
>   LAYER
>     NAME "Vessel"
>     TYPE POINT
>     CONNECTIONTYPE OGR
>     CONNECTION "C:\Inetpub\wwwroot\VesselServer\VesselServer.ovf"
>     DATA "VesselPosition"
>     STATUS ON
>     LABELITEM log.timestamp_local
>     CLASS
>       COLOR 255 255 0
>       OUTLINECOLOR 0 0 0
>       SYMBOL 'circle'
>       SIZE 12
>       LABEL
> SIZE MEDIUM
> TYPE BITMAP
> COLOR 0 0 0
>       END
>     END
>   END
>
> Im able to confirm that the OGR driver works by using ogrinfo as
> follows:
> C:\Inetpub\wwwroot\VESSEL~1>ogrinfo VesselServer.ovf VesselPosition
> ERROR 4: Update access not supported for VRT datasources.
> Had to open data source read-only.
> INFO: Open of `VesselServer.ovf'
> using driver `VRT' successful.
>
> Layer name: VesselPosition
> Geometry: Point
> Feature Count: 1
> ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
> Extent: (24.973143, 74.614543) - (24.973143, 74.614543)
> Layer SRS WKT:
> GEOGCS["WGS 84",
>     DATUM["WGS_1984",
>         SPHEROID["WGS 84",6378137,298.257223563,
>             AUTHORITY["EPSG","7030"]],
>         TOWGS84[0,0,0,0,0,0,0],
>         AUTHORITY["EPSG","6326"]],
>     PRIMEM["Greenwich",0,
>         AUTHORITY["EPSG","8901"]],
>     UNIT["degree",0.0174532925199433,
>         AUTHORITY["EPSG","9108"]],
>     AXIS["Lat",NORTH],
>     AXIS["Long",EAST],
>     AUTHORITY["EPSG","4326"]]
> id: Integer (10.0)
> timestamp_local: String (23.0)
> vessel_id: String (36.0)
> coordinate_utc: String (23.0)
> latitude_dd: Real (0.0)
> longitude_dd: Real (0.0)
> heading_degrees: Real (0.0)
> speed_knots: Real (0.0)
> ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
> OGRFeature(VesselPosition):0
>   id (Integer) = 496600
>   timestamp_local (String) = 2004-06-03 16:52:53.907
>   vessel_id (String) = 1DD0D82A-ADC1-4237-BF28-2DCC0CBC9D52
>   coordinate_utc (String) = 2004-06-03 20:52:53.907
>   latitude_dd (Real) = 74.61454299820765
>   longitude_dd (Real) = 24.97314251396685
>   heading_degrees (Real) = 3
>   speed_knots (Real) = 63
>   POINT (24.97314251 74.61454300 0.000)
>
> But, I am unable to see the results in a map :(
>
> Any suggestions, anyone?
>
> TIA
>
> Charlie
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>