[mapserver-users] Re: ODBC OGR MS SQL CONNECTION
Hi all, Everything is ok now.. Works and fast enough.. Best Regards.. -- View this message in context: http://n2.nabble.com/ODBC-OGR-MS-SQL-CONNECTION-tp4824960p4829341.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Adjacent letter problem
Dear all; This is my style and label definition; STYLE SYMBOL 'otopark_img' SIZE 30 END LABEL COLOR 0 0 0 FONT calibri-bold TYPE truetype SIZE 8 POSITION LC PARTIALS FALSE OUTLINECOLOR 255 255 255 ALIGN CENTER WRAP ' ' BUFFER 3 PRIORITY 10 ANTIALIAS TRUE END This is a sample of results; http://n2.nabble.com/file/n4830536/adjasent.jpg Why are some letters adjecent? How can I prevent this situation? Thanks in advance.. -- View this message in context: http://n2.nabble.com/Adjacent-letter-problem-tp4830536p4830536.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ODBC OGR MS SQL CONNECTION
Dear all, This definition works, CONNECTIONTYPE OGR CONNECTION OGRVRTDataSource OGRVRTLayer name='Araclar' SrcDataSourceODBC:webuser/webu...@mssql/SrcDataSource SrcSQLSELECT TOP 10 * FROM MUGPSDATALOG/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding='PointFromColumns' x='LONGITUDE' y='LATITUDE'/GeometryField /OGRVRTLayer /OGRVRTDataSource This doesn't and syas; msDrawMap(): Image handling error. Failed to draw layer named 'Araclar'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `Araclar'. Parse error at EOF, not all elements have been closed, starting with SrcSQL CONNECTIONTYPE OGR CONNECTION OGRVRTDataSource OGRVRTLayer name='Araclar' SrcDataSourceODBC:webuser/webu...@mssql/SrcDataSource SrcSQLSELECT MOBILEUNIT.MUID, MOBILEUNIT.PLATE, MUGPSDATALOG.LONGITUDE, MUGPSDATALOG.LATITUDE FROM MOBILEUNIT INNER JOIN MUGPSDATALOG ON MOBILEUNIT.MUID=MUGPSDATALOG.MUID WHERE MUGPSDATALOG.EVENTLOGID IN(SELECT MAX(EVENTLOGID) FROM MUFLEET INNER JOIN MUGROUP ON MUFLEET.FLEETID = MUGROUP.FLEETID INNER JOIN MOBILEUNIT ON MUGROUP.GROUPID = MOBILEUNIT.GROUPID INNER JOIN MUGPSDATALOG ON MOBILEUNIT.MUID=MUGPSDATALOG.MUID where MUFLEET.FLEETID=37144 group by MOBILEUNIT.MUID) ORDER BY MOBILEUNIT.PLATE/SrcSQL GeometryTypewkbPoint/GeometryType GeometryField encoding='PointFromColumns' x='LONGITUDE' y='LATITUDE'/GeometryField /OGRVRTLayer /OGRVRTDataSource But why? And why ogr connection is too slow? Is there a way for speeding-up? Regards... -- View this message in context: http://n2.nabble.com/ODBC-OGR-MS-SQL-CONNECTION-tp4824960p4824960.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: ODBC OGR MS SQL CONNECTION
Hi all, This now works, I've used * instead of listing columns.. SrcSQLSELECT * FROM MOBILEUNIT INNER JOIN MUGPSDATALOG ON MOBILEUNIT.MUID=MUGPSDATALOG.MUID WHERE MUGPSDATALOG.EVENTLOGID IN(SELECT MAX(EVENTLOGID) FROM MUFLEET INNER JOIN MUGROUP ON MUFLEET.FLEETID = MUGROUP.FLEETID INNER JOIN MOBILEUNIT ON MUGROUP.GROUPID = MOBILEUNIT.GROUPID INNER JOIN MUGPSDATALOG ON MOBILEUNIT.MUID=MUGPSDATALOG.MUID where MUFLEET.FLEETID=37144 group by MOBILEUNIT.MUID) ORDER BY MOBILEUNIT.PLATE/SrcSQL And I'll try for ogr performance suggestions... Regards.. -- View this message in context: http://n2.nabble.com/ODBC-OGR-MS-SQL-CONNECTION-tp4824960p4829220.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Wfs without geometry information
Is there a way of getting a wfs request without geometry information? How can i filter geometry in upcoming xml? -- View this message in context: http://n2.nabble.com/Wfs-without-geometry-information-tp4574847p4574847.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] No bound at the line end
Hi all; I use for road segments and for segment borders; STYLE OUTLINECOLOR 25 25 25 WIDTH 3 ANTIALIAS TRUE END STYLE OUTLINECOLOR 255 225 5 WIDTH 2 ANTIALIAS TRUE END Is there a way for not to define border at the line end? There is a Google Street Ex. on the screenshot... Regards IBO... http://n2.nabble.com/file/n4439927/line_end.jpg -- View this message in context: http://n2.nabble.com/No-bound-at-the-line-end-tp4439927p4439927.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Get table name from WFS
Hi all; Is there a way to get the table name in XML package? What sould I do for such an WFS mapfile? (I wanna see the table name of the object, I clicked on Openlayers...) Thanks, all.. -- View this message in context: http://n2.nabble.com/Get-table-name-from-WFS-tp4266874p4266874.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Get table name from WFS
Hi; I have two Postgis tables. Now on Openlayers, I can see table data of my objects in a pop-up window, clicking on the object. (by parsing xml) I mean is there a way to get the table name of the object beside table contents? Thanks... -- View this message in context: http://n2.nabble.com/Get-table-name-from-WFS-tp4266874p4270951.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapinfo Tab Objects and Symbols
Hi, I get the colors, mapinfo automatically using a font type, i've added to windows.. i can see on mapinfo but can't on mapserver.. Any comment about using these fonts with ANGLES..? thanks to all.. ibrahimsaricicek wrote: Hi all, I have a tab file including points and lines joint to points. With ogr2ogr i've converted those to postgis as GEOMETRY type. How can i show them on mapserver as it's seen on Mapinfo. I've added a screenshot of 2 objects on Mapinfo with symbols. http://n2.nabble.com/file/n3814551/MapinfoSym.jpg -- View this message in context: http://n2.nabble.com/Pls-help-Mapinfo-Tab-Objects-and-Symbols-tp3814551p3865361.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Pls help!! Mapinfo Tab Objects and Symbols
Hi all, I have a tab file including points and lines joint to points. With ogr2ogr i've converted those to postgis as GEOMETRY type. How can i show them on mapserver as it's seen on Mapinfo. I've added a screenshot of 2 objects on Mapinfo with symbols. http://n2.nabble.com/file/n3814551/MapinfoSym.jpg -- View this message in context: http://n2.nabble.com/Pls-help-Mapinfo-Tab-Objects-and-Symbols-tp3814551p3814551.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users