Does OGR understand MS SQL Spatial geometry ?
On Wednesday 24 September 2008 18:26, you wrote: > Hi, > > First thing that comes into my mind is the good old STATUS ON thing. LAYER > ON in mapfile means that the layer can be requested, but not that it is > automatically included in a map. STATUS DEFAULT includes it automatic. Try > what happens if you use: > > shp2img -m test.map -l ku2 -o test.png > > Alternatively, change LAYER DEFAULT and use the old command. > > -Jukka Rahkonen- > > > -----Alkuperäinen viesti----- > Lähettäjä: [EMAIL PROTECTED] puolesta: Ivan Mincik > Lähetetty: ke 24.9.2008 19:09 > Vastaanottaja: [email protected] > Aihe: [mapserver-users] RE:mapserver + MS SQL > > I have started testing OGR ODBC connection from linux to MS SQL on win. > There is polygon layer at MS SQL. > > *** I have configured ovf file: > > <OGRVRTDataSource> > <OGRVRTLayer name="ku2"> > <SrcDataSource>ODBC:test/[EMAIL PROTECTED]</SrcDataSource> > <GeometryType>wkbPolygon</GeometryType> > <LayerSRS></LayerSRS> > <GeometryField encoding="wkb" field="geom"/> > <SrcSQL>select geom from ku2</SrcSQL> > </OGRVRTLayer> > </OGRVRTDataSource> > > *** With ogrinfo -ro -al test.ovf I get: > > OGRFeature(ku2):1599 > geom (Binary) = > 000000000104BA0000003EB1148070BF20C15D1DF97FB5C832C11B1727C08FBF20C16F23... > POINT (0.0 -0.0) > > OGRFeature(ku2):1600 > geom (Binary) = > 000000000104C8010000C23023A08D2C19C1BC001400308E32C1C84A35A0372C19C1CF70... > POINT (0.0 -0.0) > > OGRFeature(ku2):1601 > geom (Binary) = > 0000000001047905000038864D009A7818C19A41F1FF68B732C19092B3BF6C7818C10808... > POINT (0.0 0.0) > > > *** In the mapfile : > > LAYER > NAME 'ku2' > DEBUG 5 > TYPE LINE > CONNECTIONTYPE OGR > CONNECTION "test.ovf" > DATA "ku2" > STATUS ON > PROJECTION > "init=epsg:2065" > END > METADATA > "DESCRIPTION" "test" > 'wms_title' 'test' > "wms_format" "image/png" > END > CLASS > NAME "test" > STYLE > OUTLINECOLOR 239 110 115 > COLOR 204 204 204 > WIDTH 8 > END > END > END > > *** shp2img -m test.map -o test.png will run without error, but output image > is BLANK. Any idea ? > I have tried this with 2 different layers, different coordinate systems. > > > > > >Hi list, > >At first, I would like to say that I am not a fan in replacing perfect > >PostGIS database to MS SQL, but I must to adapt to customer's needs. > >I would like to ask if somebody has experience with loading data to > >mapserver from MS SQL Spatial 2008. > >Now, in 5.2 there is possibility to use new PLUGIN for MS SQL, which is only > >for Windows .... > >Other possibility is to use ODBC connection through OGR which can be working > >also in Linux. > > > >So my questions are : > >1. Is there any other possibility ? > >2. What is Your experience with performance when using ODBC connection > >through OGR ? > >3. What is Your experience with performance when using new PLUGIN for MS SQL > >in 5.2 ? > > > >Thanks a lot > >-- > > >Ivan > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > -- Mgr. Ivan Minčík Gista s.r.o tel:. 0907 639 570 email: [EMAIL PROTECTED] http://www.gista.sk, http://demo.gisplan.sk _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
