[Chameleon] Displaying MySQL point over MapDHTML - ODBC / OGR
Carlo Tronnberg
temp at chello.hu
Wed Nov 16 23:52:21 EST 2005
Thanks Bart for the tip! This is MUCH better.
I have a slight problem still:
If I use in the 'virtual.ovf' file the SrcLayer tag, there are no problems.
<OGRVRTDataSource>
<OGRVRTLayer name="mylayer">
<SrcDataSource>ODBC:elu/Elu51221!@eluodbc</SrcDataSource>
<SrcLayer>lineup</SrcLayer>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding="PointFromColumns" x="gps_lat_degree" y="gps_long_degree"/>
</OGRVRTLayer>
</OGRVRTDataSource>
BUT! If I want to execute an SQL Query (which I DO!) with the SrcSQL tag, as follows,
<OGRVRTDataSource>
<OGRVRTLayer name="mylayer2">
<SrcDataSource>ODBC:elu/Elu51221!@eluodbc</SrcDataSource>
<SrcSQL>SELECT lineup.* FROM lineup WHERE lineup.team_id = 71 </SrcSQL>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding="PointFromColumns" x="gps_lat_degree" y="gps_long_degree"/>
</OGRVRTLayer>
</OGRVRTDataSource>
Then mapserver will not generate the map. (Nothing comes out then, not even the other existing layers)
I ran both versions of the ovf file with ogrinfo and the SrcSQL version threw an ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
C:\ms4w\apps\elu\map>ogrinfo -ro virtual.ovf mylayer
INFO: Open of `virtual.ovf'
using driver `VRT' successful.
Layer name: mylayer
Geometry: Point
Feature Count: 35
ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
Extent: (0.000000, 0.000000) - (42.000000, 18.000000)
Layer SRS WKT:
GEOGCS["WGS 84",
DATUM["WGS_1984",
SPHEROID["WGS 84",6378137,298.257223563,
AUTHORITY["EPSG","7030"]],
etc ....
Even the simplest SQL query will cause the same problem.
Here is the layer I am using:
LAYER
NAME "All Stations"
TYPE POINT
CONNECTIONTYPE OGR
CONNECTION "virtual.ovf"
DATA "mylayer"
STATUS ON
# LABELITEM lineup.team_id #may need to use table.name or just name depending on your OVF file.
PROJECTION
"init=epsg:4326"
END
CLASS
SYMBOL 2
SIZE 16
COLOR 100 100 100
LABEL
SIZE MEDIUM
TYPE BITMAP
COLOR 0 0 0
END
END
END
What am I doing wrong?
Best regards,
Carlo
----- Original Message -----
From: "Bart van den Eijnden" <bartvde at xs4all.nl>
To: "Carlo Tronnberg" <temp at chello.hu>
Cc: <chameleon at lists.maptools.org>
Sent: Tuesday, November 15, 2005 20:59
Subject: Re: [Chameleon] Displaying MySQL point over MapDHTML or MapImageSharedResource widgets
> Hi,
>
> with respect to your MySQL points, I would suggest looking at
> Mapserver's Virtual Spatial Data through OGR. You could use an ODBC
> connection, or compile GDAL/OGR against the MySQL client.
>
> See also here:
> http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData
>
> I would suggest sticking with the MapDHTML widget.
>
> Best regards,
> Bart
>
> Carlo Tronnberg wrote:
>
>> Dear List,
>>
>> Sorry for this rather long message, but I need to get an answer as
>> soon as possible and want to be clear from the beginning. I have a
>> feeling that this can be useful to MANY newbies like me out there.
>>
>> I have some MySQL data (basically latitude, longitude, color of the
>> icon) that I want to plot on a map.
>>
>> This is rather urgent...
>>
>> 1.
>> I use the SQLQuery Widget to get the data and tried out the
>> "MapImageSharedResource" Widget which sounded very promising,
>> extracting directly the points from the sharedresource returned by the
>> SQLQuery.
>>
>> Here is an extract of the code I used with the
>> "MapImageSharedResource" Widget:
>> __________
>> <CWC2 Type="SQLQuery" sqlquery="SELECT latitude, longitude FROM
>> dealer" Server="localhost" DBTYPE="MYSQL" Database="test2"
>> UserName="root" Password="1234" SharedResourceName="MyResult2">
>> <ONEVENT Event="ConnectFailed" Text="Connection failed."/>
>> <ONEVENT Event="SelectDBFailed" Text="Databse don't exist."/>
>> <ONEVENT Event="QueryFailed" Text="Query failed."/>
>> <ONEVENT Event="NoRowReturned" Template="noresult"/>
>> <ONEVENT Event="GeocodeFailed" Template="error"/>
>> </CWC2>
>>
>> <CWC2 TYPE="MapImageSharedResource" id="inline" Width="500"
>> Height="250" Navigable="false" Transparent="true" SYMBOLOVERLAP="true"
>> AUTOEXTENT="false">
>> <POINTS NAME="START" SRNAME="MyResult_IMAGE" SRLATCOL="latitude"
>> SRLONCOL="longitude" type="unique" LABEL="Team [$MyResult_IMAGE.Id]"/>
>> <MAP POINT="START" TYPE="STYLE" PARAM="color" VALUE="00FF00"/>
>> <MAP POINT="START" TYPE="STYLE" PARAM="size" VALUE="25"/>
>> <POINTS NAME="END" SRNAME="Elu" SRLATCOL="gps_lat_degree"
>> SRLONCOL="gps_long_degree" type="unique" LABEL="Team [$Elu.team_id]"/>
>> <MAP POINT="END" TYPE="STYLE" PARAM="color" VALUE="0000FF"/>
>> <MAP POINT="END" TYPE="STYLE" PARAM="size" VALUE="20"/>
>> </CWC2>
>> ___________
>> Unfortunately this doesn't work well. After some tweaking I got the
>> map generated OK but a lot of error messages in the web page which
>> cannot be removed.
>>
>> Error message:
>> Notice: Undefined property: sName in
>> C:\ms4w\apps\chameleon\htdocs\common\wrapper\map_session.php on line
>> 1073.
>>
>> I went through all the material online I could find but I simply could
>> not make it work well. Am I missing something?
>>
>> I use ms4w_1.2.2 and chameleon_ms4w-2.2
>> Is it possible that the versions I use do not work properly (too
>> new?). I also tried ms4w_1.3.0 but that gave even more errors with PHP
>> (not even the Cameleon samples worked!)
>>
>> 2.
>> I have generated a pretty nice environment based on the Chameleon
>> samples, using the MapDHTML widget for the map. Unfortunately I do not
>> know how to get MySQL points on it via the mapserver.
>>
>> Can the MapDHTML Widget also get points added to it in the same way as
>> the MapImageSharedResource Widget can?
>>
>> 3.
>> Anotherway around... If the MapImageSharedResource works correctly, is
>> it possible to make it behave as the MapDHTML widget (Navigation...)
>> so it can be integrated instead of it in the Chameleon samples?
>>
>> A lot of questions from a desesperate newbie... (I went through the
>> Mailing lists and could not get the answers...)
>>
>> Best Regards,
>>
>> Carlo Tronnberg
>> _______________________________________________
>> Chameleon mailing list
>> Chameleon at lists.maptools.org
>> http://lists.maptools.org/mailman/listinfo/chameleon
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/chameleon/attachments/20051117/ed215059/attachment-0001.html
More information about the Chameleon
mailing list