[mapserver-users] posting variable to map file from html page
Dear Friend After installing mapserver 6.0.1 I have faced a problem that I could not post string variable into the map file. It was working well for mapserver 5.4.2 but it doesn't work for new version from html file I have sending eq_id to the map file and in layer I use the following SELECT sta_id,latitude,longitude from pgav where eq_id like "%eq_id%" it was worked for mapserver 5.4.2 but I could not sent when I installed new version of map file. May be it caused by new apache2 server. But in case please help me. Regards... Murat ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] line issue in mapserver 6
Dear All, I have installed mapserver 6.0.1 on ubuntu 12.10 and I tried to draw map which is including some line and polygon layers. By the way I have been using mapserver 5.4.2 for a long time. Same map file which is working to draw map using mapserver 5.4.2 working well under mandriva 2010. When I try to draw it on new Mapserver the line looking like a point on the map even if its shapefile is line data. BUt for old mapsever it seems line without any problem. When I try to find reason I understood style and symbol has minor change. Then I would like to solve my problem making some test. Then I have found a solution but it is little bit strange. like this for old version of mapserver layers as follows in the map and it seems like a point on the map when I zoomed much. LAYER NAME Faults TYPE line DATA faults_line STATUS on CLASS SYMBOL "cline" SIZE 1 COLOR 200 10 0 END END and symbol cline as follows SYMBOL NAME "cline" TYPE line POINTS 0 0 END FILLED TRUE END these are workng for the mapserver 5.4.2 well. But for Mapserver 6.0 it look like a points instead of line on the map. Then I have used style and I modified map file as follows LAYER TYPE line STATUS on CLASS STYLE WIDTH 2.0 COLOR 200 10 20 END END LAYER NAME Faults DATA fault_lines STATUS on END it works well but for all line layer I should use layer for style for any layer which are including line data. I mean if I try to draw another layer after the fault_lines layer I have to add layer for style before the layer. So if I use layer for style for all line layer it gives confusion on the map file. Do you have any suggestion What I'm missing. Regards. Murat /usr/lib/cgi-bin/mapserv -v MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=CAIRO SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] convert projection from UTM to WGS84 using proj
Dear friends, I have solved my problem using ogr gui tool easily and thank you for your interest. Regards... On Mon, 2012-05-21 at 09:43 +, Rahkonen Jukka wrote: > Hi, > > Ogr2ogr is your tool for converting shapefiles. There must be something wrong > in the predefined EPSG parameteres. Give projections as +proj strings and > you will have a full control over what happens. An example about conversion > from EPSG:2393 into EPSG:3067 > > ogr2ogr -f "ESRI Shapefile" -s_srs "+proj=tmerc +lat_0=0 +lon_0=27 +k=1 > +x_0=350 +y_0=0 +ellps=intl > +towgs84=-96.0617,-82.4278,-121.7535,4.80107,0.34543,-1.37646,1.4964 > +units=m" -t_srs "+proj=utm +zone=35 +ellps=GRS80 +units=m +towgs84=0,0,0,0 > +no_defs" target.shp original.shp > > Mapserver takes the parameters from the text file named "epsg" and it is easy > to edit by hand. However, ogr2ogr does not use that file. Therefore you did > not see any difference after your edits. > > -Jukka Rahkonen- > > Murat Beyhan wrote: > > > > Hi, > > > is cs2cs a tool for converting shape data and > are there any example for this purpose > actually I added +x_0=50. to ogr2ogr command but doesn't cahaged the > result :( > > > On Fri, 2012-05-18 at 14:00 +0200, Jørn Vegard Røsnes wrote: > > Hi, > > > > I lost your previous email, so this is just by memory. > > I'm not an projection expert, but here we go :-) > > > > Regarding 3dg offset: > > In your .prj file there is an false easting=50, so maybe it helps > > adding +x_0=50. > > http://proj.maptools.org/gen_parms.html > > Se also +towgs84 in the same link and .prj file, and adjust accordingly. > > > > Maybe a shot in the dark because 3dg = 333958,33m (40 075,017km / 360dg). > > I think you're near the solution. > > > > See also > > http://spatialreference.org/ > > http://spatialreference.org/ref/epsg/4230/ > > > > kind regards > > Jørn-Vegard Røsnes > > > > - Original Message - > > > From: "Jørn Vegard Røsnes" > > > To: "Murat Beyhan" > > > Cc: "mapserver-users" > > > Sent: Wednesday, 16 May, 2012 11:21:22 AM > > > Subject: Re: [mapserver-users] convert projection from UTM to WGS84 using > > > proj > > > > > > Hi, > > > maybe something like this: > > > > > > ogr2ogr -s_srs epsg:4230 -t_srs epsg:4326> > shapefile> > > > > > > http://www.gdal.org/ogr2ogr.html > > > > > > kind regards > > > Jørn-Vegard Røsnes > > > > > > - Original Message - > > > > From: "Murat Beyhan" > > > > To: "mapserver-users" > > > > Sent: Wednesday, 16 May, 2012 10:41:39 AM > > > > Subject: [mapserver-users] convert projection from UTM to WGS84 > > > > using proj > > > > > > > > Dear friends, > > > > I'm sorry, I'm not good at GIS applications but I wondering about > > > > conversion between various projection or datum of the data files. > > > > > > > > data.shp data.shx data.dbf and data.prj files are available. > > > > > > > > shpdump data.shp gives following > > > > > > > > Shape:0 (ArcZ) nVertices=4, nParts=1 > > > > Bounds:( 513275.786, 4006041.761, 0, 0) > > > > to ( 513345.812, 4006078.182, 0, 0) > > > > ( 513275.786, 4006078.182, 0, 0) Ring > > > > ( 513301.130, 4006064.906, 0, 0) > > > > ( 513321.636, 4006053.249, 0, 0) > > > > ( 513345.812, 4006041.761, 0, 0) > > > > ... > > > > > > > > > > > > > > > > > > > > > > > > data.prj as follows > > > > > > > > PROJCS["(UTM)Universal Transvers Merkator 3�",GEOGCS["EUROPEAN > > > > 1950",DATUM["European_Datum_1950",SPHEROID["International",6378388.,297.], > > > > TOWGS84[-87.,-98.,-121.,0.,0.,0.,0.]], > > > > PRIMEM["Greenwich",0.],UNIT["Degree",0.01745329],AUTHORITY["EPSG","4230"]],PROJECTION["TRANSVERSE_MERCATOR"], > > > > PARAMETER["SCALE_FACTOR",1.],PARAMETER["CENTRAL_MERIDIAN",36.],PARAMETER["LATITUDE_OF_ORIGIN",0.], > > > > PARAMETER["FALSE_EASTING",
Re: [mapserver-users] convert projection from UTM to WGS84 using proj
Hi, is cs2cs a tool for converting shape data and are there any example for this purpose actually I added +x_0=50. to ogr2ogr command but doesn't cahaged the result :( On Fri, 2012-05-18 at 14:00 +0200, Jørn Vegard Røsnes wrote: > Hi, > > I lost your previous email, so this is just by memory. > I'm not an projection expert, but here we go :-) > > Regarding 3dg offset: > In your .prj file there is an false easting=50, so maybe it helps adding > +x_0=50. > http://proj.maptools.org/gen_parms.html > Se also +towgs84 in the same link and .prj file, and adjust accordingly. > > Maybe a shot in the dark because 3dg = 333958,33m (40 075,017km / 360dg). > I think you're near the solution. > > See also > http://spatialreference.org/ > http://spatialreference.org/ref/epsg/4230/ > > kind regards > Jørn-Vegard Røsnes > > - Original Message - > > From: "Jørn Vegard Røsnes" > > To: "Murat Beyhan" > > Cc: "mapserver-users" > > Sent: Wednesday, 16 May, 2012 11:21:22 AM > > Subject: Re: [mapserver-users] convert projection from UTM to WGS84 using > > proj > > > > Hi, > > maybe something like this: > > > > ogr2ogr -s_srs epsg:4230 -t_srs epsg:4326> shapefile> > > > > http://www.gdal.org/ogr2ogr.html > > > > kind regards > > Jørn-Vegard Røsnes > > > > - Original Message - > > > From: "Murat Beyhan" > > > To: "mapserver-users" > > > Sent: Wednesday, 16 May, 2012 10:41:39 AM > > > Subject: [mapserver-users] convert projection from UTM to WGS84 > > > using proj > > > > > > Dear friends, > > > I'm sorry, I'm not good at GIS applications but I wondering about > > > conversion between various projection or datum of the data files. > > > > > > data.shp data.shx data.dbf and data.prj files are available. > > > > > > shpdump data.shp gives following > > > > > > Shape:0 (ArcZ) nVertices=4, nParts=1 > > > Bounds:( 513275.786, 4006041.761, 0, 0) > > > to ( 513345.812, 4006078.182, 0, 0) > > > ( 513275.786, 4006078.182, 0, 0) Ring > > > ( 513301.130, 4006064.906, 0, 0) > > > ( 513321.636, 4006053.249, 0, 0) > > > ( 513345.812, 4006041.761, 0, 0) > > > ... > > > > > > > > > > > > > > > > > > data.prj as follows > > > > > > PROJCS["(UTM)Universal Transvers Merkator 3�",GEOGCS["EUROPEAN > > > 1950",DATUM["European_Datum_1950",SPHEROID["International",6378388.,297.], > > > TOWGS84[-87.,-98.,-121.,0.,0.,0.,0.]], > > > PRIMEM["Greenwich",0.],UNIT["Degree",0.01745329],AUTHORITY["EPSG","4230"]],PROJECTION["TRANSVERSE_MERCATOR"], > > > PARAMETER["SCALE_FACTOR",1.],PARAMETER["CENTRAL_MERIDIAN",36.],PARAMETER["LATITUDE_OF_ORIGIN",0.], > > > PARAMETER["FALSE_EASTING",50.],PARAMETER["FALSE_NORTHING",0.],UNIT["meter",1.]] > > > > > > > > > using these data How to convert a file which is created using > > > european_datum_1950 to WGS84 (World Geodetic System 1984) > > > or where I have to start to understand these method of applications > > > using PROJ4. > > > Thanks > > > muratB > > > > > > > > > -- > > > This message has been scanned for viruses and > > > dangerous content by MailScanner, and is > > > believed to be clean. > > > > > > ___ > > > mapserver-users mailing list > > > mapserver-users@lists.osgeo.org > > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > > > > CONFIDENTIALITY > This e-mail and any attachment contain KONGSBERG information which may be > proprietary, confidential or subject to export regulations, and is only meant > for the intended recipient(s). Any disclosure, copying, distribution or use is > prohibited, if not otherwise explicitly agreed with KONGSBERG. If received in > error, please delete it immediately from your system and notify the sender > properly. > > Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] convert projection from UTM to WGS84 using proj
Dear Jorn Vegard, thanks for this help I have done it and I obtained DD WGS84 shape file but problem the data which I study on it goes 3 degree east of the actual places. I mean 3 degree shifted on the longitude. So how can I ignore this problem. here is command: ogr2ogr -s_srs "+proj=utm +datum=European_Datum_1950 +epsg:4230 +zone=37" -t_srs "+proj=latlong +datum=wgs84 +epsg:4326" mahalle1.shp mahalle.shp thanks On Wed, 2012-05-16 at 11:21 +0200, Jørn Vegard Røsnes wrote: > Hi, > maybe something like this: > > ogr2ogr -s_srs epsg:4230 -t_srs epsg:4326 > > http://www.gdal.org/ogr2ogr.html > > kind regards > Jørn-Vegard Røsnes > > - Original Message - > > From: "Murat Beyhan" > > To: "mapserver-users" > > Sent: Wednesday, 16 May, 2012 10:41:39 AM > > Subject: [mapserver-users] convert projection from UTM to WGS84 using proj > > > > Dear friends, > > I'm sorry, I'm not good at GIS applications but I wondering about > > conversion between various projection or datum of the data files. > > > > data.shp data.shx data.dbf and data.prj files are available. > > > > shpdump data.shp gives following > > > > Shape:0 (ArcZ) nVertices=4, nParts=1 > > Bounds:( 513275.786, 4006041.761, 0, 0) > > to ( 513345.812, 4006078.182, 0, 0) > > ( 513275.786, 4006078.182, 0, 0) Ring > > ( 513301.130, 4006064.906, 0, 0) > > ( 513321.636, 4006053.249, 0, 0) > > ( 513345.812, 4006041.761, 0, 0) > > ... > > > > > > > > > > > > data.prj as follows > > > > PROJCS["(UTM)Universal Transvers Merkator 3�",GEOGCS["EUROPEAN > > 1950",DATUM["European_Datum_1950",SPHEROID["International",6378388.,297.], > > TOWGS84[-87.,-98.,-121.,0.,0.,0.,0.]], > > PRIMEM["Greenwich",0.],UNIT["Degree",0.01745329],AUTHORITY["EPSG","4230"]],PROJECTION["TRANSVERSE_MERCATOR"], > > PARAMETER["SCALE_FACTOR",1.],PARAMETER["CENTRAL_MERIDIAN",36.],PARAMETER["LATITUDE_OF_ORIGIN",0.], > > PARAMETER["FALSE_EASTING",50.],PARAMETER["FALSE_NORTHING",0.],UNIT["meter",1.]] > > > > > > using these data How to convert a file which is created using > > european_datum_1950 to WGS84 (World Geodetic System 1984) > > or where I have to start to understand these method of applications > > using PROJ4. > > Thanks > > muratB > > > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > > > ___ > > mapserver-users mailing list > > mapserver-users@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > > > CONFIDENTIALITY > This e-mail and any attachment contain KONGSBERG information which may be > proprietary, confidential or subject to export regulations, and is only meant > for the intended recipient(s). Any disclosure, copying, distribution or use is > prohibited, if not otherwise explicitly agreed with KONGSBERG. If received in > error, please delete it immediately from your system and notify the sender > properly. > > Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] convert projection from UTM to WGS84 using proj
Dear friends, I'm sorry, I'm not good at GIS applications but I wondering about conversion between various projection or datum of the data files. data.shp data.shx data.dbf and data.prj files are available. shpdump data.shp gives following Shape:0 (ArcZ) nVertices=4, nParts=1 Bounds:( 513275.786, 4006041.761, 0, 0) to ( 513345.812, 4006078.182, 0, 0) ( 513275.786, 4006078.182, 0, 0) Ring ( 513301.130, 4006064.906, 0, 0) ( 513321.636, 4006053.249, 0, 0) ( 513345.812, 4006041.761, 0, 0) ... data.prj as follows PROJCS["(UTM)Universal Transvers Merkator 3�",GEOGCS["EUROPEAN 1950",DATUM["European_Datum_1950",SPHEROID["International",6378388.,297.], TOWGS84[-87.,-98.,-121.,0.,0.,0.,0.]], PRIMEM["Greenwich",0.],UNIT["Degree",0.01745329],AUTHORITY["EPSG","4230"]],PROJECTION["TRANSVERSE_MERCATOR"], PARAMETER["SCALE_FACTOR",1.],PARAMETER["CENTRAL_MERIDIAN",36.],PARAMETER["LATITUDE_OF_ORIGIN",0.], PARAMETER["FALSE_EASTING",50.],PARAMETER["FALSE_NORTHING",0.],UNIT["meter",1.]] using these data How to convert a file which is created using european_datum_1950 to WGS84 (World Geodetic System 1984) or where I have to start to understand these method of applications using PROJ4. Thanks muratB -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] draw line using mysql sahpe file
Dear Paolo, Thanks for your advice, as you said just change select * form sfault then it works fine... wonderful it took 2 weeks to see these result many thanks murat On Wed, 2012-03-07 at 11:36 +0100, Paolo Corti wrote: > SELECT eq_id from sfault where eq_id like "%eq_id%" Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] draw line using mysql sahpe file
Dear All, For 2 weeks I struggled to draw simple line using mysql database in order to collect to many lines and draw only desired one on the map I followed many way but could not solve the problem at the beginning of my work I stored start and end of the line point on the database as a table on mysql then I try to draw it using ogr. but I could not draw it. Then I firs create shape file of lines than I store it on mysql spatial database by following ogr2ogr -f MySQL MySQL:testogr,user=root,password=password123 sfault1.shp -nln sfault -append -overwrite -lco GEOMETRY_NAME=SHAPE2 then structure of the table created by this command as follows: OGR_FID int(11) Yes NULL SHAPE2 geometry Yes NULL id decimal(1,0) Yes NULL lon double(8,4) Yes NULL lat double(7,4) Yes NULL eq_id varchar(14) Yes NULL same database testogr has a two another table which collect geometry_column and spatial_ref_sys. then I try to draw it on mapserver then I succeeded but it draws all of the line stored in this table using following map layer. LAYER NAME "fault" TYPE line STATUS default CONNECTIONTYPE OGR CONNECTION ' MYSQL:testogr,user=root,password=password123,host=localhost,port=3306,tables=sfault ' DATA sfault CLASS NAME "Kaynak Fay/Source Fault" SYMBOL "cline" SIZE 3 COLOR 255 0 0 END END But I desire only one of them using eq_id column but when I make sql statement as follows. I mean when I add sql statement it draws nothing. But be sure same eq_id comes to map file correctly to draw point of epicenter. There is no problem for it. Also I use EXPRESSION FOR CLASS also it doesn't draw line on the map. Previous map draws all, following draws nothing. How can I pass this handicap. Please let help me. LAYER NAME "fault" TYPE line STATUS default CONNECTIONTYPE OGR CONNECTION ' MYSQL:testogr,user=root,password=password123,host=localhost,port=3306,tables=sfault SELECT eq_id from sfault where eq_id like "%eq_id%" ' DATA sfault # CLASSITEM "eq_id" CLASS # EXPRESSION ([eq_id] EQ 'eq_id') !! this also doesn't work NAME "Kaynak Fay/Source Fault" SYMBOL "cline" SIZE 3 COLOR 255 0 0 END END -- Murat BEYHAN Geophysical Engineer, M.Sc. Prime Ministry Disaster and Emergency Management Presidency Earthquake Department Address: Eskisehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] ogr csv layer in mapserver
The problem solved by giving full path of csv file in map file as follows than it works thanks /var/www/html/dynamic/kyh_sta_ogr.csv thanks again Murat On Tue, 2012-03-06 at 09:56 +0200, Murat Beyhan wrote: > Dear all, > > I used gdal 1.7.2 and mapserver 5.2.1 > > I try to draw layer which data csv file as follows > > filename : kyh_sta_ogr.csv > > "ID","STA_ID","Latitude","Longitude" > 1,0104,37.02403,35.80947 > 2,0118,37.02100,35.19100 > . > . > . > > > then I use ogr for reading data from that file as follows and map file > also here > > > > LAYER > NAME "kyh_vrt_ogr" >CONNECTIONTYPE OGR >CONNECTION ' > > kyh_sta_ogr.csv > wkbPoint > WGS84 > y="Latitude"/> > > ' > DATA kyh_sta_ogr > STATUS default > TYPE POINT > CLASS > NAME "kyh" > SYMBOL "cpoint" > SIZE 1 > COLOR 0 0 0 > END > END > > Please let me inform what is wrong in my code and why always trouble to > draw ogr layer in mapserver. > mapserver gives following error message > > msDrawMap(): Image handling error. Failed to draw layer named > 'kyh_vrt_ogr'. msOGRFileOpen(): OGR error. Open failed for OGR > connection in layer `kyh_vrt_ogr'. Failed to open datasource > `kyh_sta_ogr.csv'. > > > > but command > ogrinfo -ro -al kyh.vrt > as follows: > > ogrinfo -ro -al kyh.vrt > INFO: Open of `kyh.vrt' > using driver `VRT' successful. > > Layer name: kyh_sta_ogr > Geometry: Point > Feature Count: 327 > 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"]], > AUTHORITY["EPSG","4326"]] > ID: String (0.0) > STA_ID: String (0.0) > Latitude: String (0.0) > Longitude: String (0.0) > OGRFeature(kyh_sta_ogr):1 > ID (String) = 1 > STA_ID (String) = 0104 > Latitude (String) = 37.02403 > Longitude (String) = 35.80947 > POINT (35.8094697 37.0240303) > > OGRFeature(kyh_sta_ogr):2 > ID (String) = 2 > STA_ID (String) = 0118 > Latitude (String) = 37.02100 > Longitude (String) = 35.19100 > POINT (35.1910003 37.021) > > > > > Murat BEYHAN > > Jeofizik Y.Müh. > T.C. Başbakanlık > Afet ve Acil Durum Yönetimi Başkanlığı > Deprem Dairesi Başkanlığı > Eskişehir Yolu 12. Km. > Lodumlu/ANKARA > Tel: 312 2872680-1556 > email:bey...@deprem.gov.tr > > > > Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ogr csv layer in mapserver
Dear all, I used gdal 1.7.2 and mapserver 5.2.1 I try to draw layer which data csv file as follows filename : kyh_sta_ogr.csv "ID","STA_ID","Latitude","Longitude" 1,0104,37.02403,35.80947 2,0118,37.02100,35.19100 . . . then I use ogr for reading data from that file as follows and map file also here LAYER NAME "kyh_vrt_ogr" CONNECTIONTYPE OGR CONNECTION ' kyh_sta_ogr.csv wkbPoint WGS84 ' DATA kyh_sta_ogr STATUS default TYPE POINT CLASS NAME "kyh" SYMBOL "cpoint" SIZE 1 COLOR 0 0 0 END END Please let me inform what is wrong in my code and why always trouble to draw ogr layer in mapserver. mapserver gives following error message msDrawMap(): Image handling error. Failed to draw layer named 'kyh_vrt_ogr'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `kyh_vrt_ogr'. Failed to open datasource `kyh_sta_ogr.csv'. but command ogrinfo -ro -al kyh.vrt as follows: ogrinfo -ro -al kyh.vrt INFO: Open of `kyh.vrt' using driver `VRT' successful. Layer name: kyh_sta_ogr Geometry: Point Feature Count: 327 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"]], AUTHORITY["EPSG","4326"]] ID: String (0.0) STA_ID: String (0.0) Latitude: String (0.0) Longitude: String (0.0) OGRFeature(kyh_sta_ogr):1 ID (String) = 1 STA_ID (String) = 0104 Latitude (String) = 37.02403 Longitude (String) = 35.80947 POINT (35.8094697 37.0240303) OGRFeature(kyh_sta_ogr):2 ID (String) = 2 STA_ID (String) = 0118 Latitude (String) = 37.02100 Longitude (String) = 35.19100 POINT (35.1910003 37.021) Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] how can I adjust size of label
Dear All, I plot map file which is including villages. Data stored in MySQL and read via OGR. My question is it possible to adjust size of the label changing automatically considering the zoom level? I mean when I zoom in size of the label also will increase, and decrease when I zoom out. is STYLEITEM "AUTO" is a way to do? or which doc will be useful to do this. regards Murat -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] draw line readinf from mysql
Dear All,
I have solved to read data from virtual data access using ogr and Mysql
but my mapserver gives an error message, Please let me know What I'm
doing wrong.
the map file layer for drawing line as follows
LAYER
NAME sfault1
connectiontype ogr
CONNECTION '
MYSQL:dynamic,user=root,password=mysql_passwd,host=localhost,port=3306,tables=lineview1
select eq_id, geom from lineview1 where eq_id like "%eq_id%"
wkbLineString
eq_id
'
DATA sfault1
STATUS default
TYPE line
CLASS
name "Kaynak Fay1/Source Fault"
SYMBOL "cline"
SIZE 6
COLOR 0 255 255
END
END
ogr vrt can access succesfully
to mysql as follows
[murat@localhost stations]$ ogrinfo -ro -al test.vrt
INFO: Open of `test.vrt'
using driver `VRT' successful.
Layer name: dynamic
Geometry: Line String
Feature Count: 2
Layer SRS WKT:
(unknown)
eq_id: String (42.0)
geom: Real (23.0)
OGRFeature(dynamic):0
eq_id (String) = 20111023101120
geom (Real) = 164
OGRFeature(dynamic):1
eq_id (String) = 20100308023229
geom (Real) = 163
please give me hint What Shall I do
Regards
Murat
On Fri, 2012-02-24 at 12:38 +0200, Murat Beyhan wrote:
> Dear all,
>
> Still could not achieve to draw line using start and stop point line
> data stored in MySql database.
>
> I have tried Mr. Robert's solution but I have faced an error message.
>
>
> in map file
> I changed Geometrytype from wkbline to wkblinestring.
>
> LAYER
> NAME sfault1
> CONNECTIONTYPE OGR
> CONNECTION '
>
> MYSQL:dynamic,user=root,password=mysqlpasswd,host=localhost,port=3306,tables=lineview
>
> lineview
> wkbLineString
>
> WGS84
> eq_id
>
> '
> DATA sfault1
> STATUS on
> TYPE line
> CLASS
> NAME "Source Fault"
> SYMBOL "cline"
>SIZE 3
> COLOR 0 0 255
> END
> END
>
> in database
> I have two table
> one is store id lat1 lon1 lat2 lon2
> and another is view
> of this table created by following
>
> create view lineview as select eq_id, "LINESTRING(" + lon1 + " " + lat1
> + "," + lon2 + " " + lat2 + ")" as geom from sfault
>
>
> there is an another issue,
> I have to draw line by considering id
> so in the map When I select one id, line should be belong to this id's
> information
> so I have to make a sql statement as follow instead of draw all line
> stored in database I have to draw just one line considering id
>
> something like this select eq_id, geom from lineview where id like '%id
> %'
>
>
> please help about this subject
>
>
> Regards
>
>
>
> Murat
>
>
>
> On Tue, 2012-02-21 at 09:15 +1300, Robert Sanson wrote:
> > Hi Murat
> >
> > Is it possible for you to create a view from the columns that presents the
> > data as a WKT line feature:
> >
> > create view lineview as select id, "LINESTRING(" + lon1 + " " + lat1 + ","
> > + lon2 + " " + lat2 + ")" as geom from mytable
> >
> > Then set up your OGR ovf file representing this view:
> >
> >
> >
> > ODBC:user/passwd@DSN
> > lineview
> > wkbLine
> > EPSG:2193
> >
> > id
> >
> >
> >
> > Best wishes,
> >
> > Robert
> >
> > >>> Murat Beyhan 21/02/2012 2:52 a.m. >>>
> > Dear friend,
> >
> > I'm trying to draw a line using MySql database
> > the table in database as follows,
> >
> > idlat1lon1lat2lon2
> > 20100308023229 40.1113 38.7901 40.0311 38.7428
> >
> > actually using ogr connection I can draw point using ogr and mysql, but
> > How can I draw line using such database table, please help me and give
> > the idea...
> >
> > Thanks
> >
> > Murat
> > --
> > Murat BEYHAN
> > Geophysical Engineer, M.Sc.
> > Prime Ministry
> > Disaster and Emergency Management Presidency
> > Earthquake Department
> > Address: Eskisehir Yolu 12. Km.
> > Lodumlu/ANKARA
> > Tel: 312 2872680-1556
> > email:bey...@deprem.gov.tr
> >
> >
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> >
> > ___
> > mapserver-users mailing list
> > mapserver-users@lists.osgeo.org
> > http://lists.o
Re: [mapserver-users] draw line readinf from mysql
Dear all,
Still could not achieve to draw line using start and stop point line
data stored in MySql database.
I have tried Mr. Robert's solution but I have faced an error message.
in map file
I changed Geometrytype from wkbline to wkblinestring.
LAYER
NAME sfault1
CONNECTIONTYPE OGR
CONNECTION '
MYSQL:dynamic,user=root,password=mysqlpasswd,host=localhost,port=3306,tables=lineview
lineview
wkbLineString
WGS84
eq_id
'
DATA sfault1
STATUS on
TYPE line
CLASS
NAME "Source Fault"
SYMBOL "cline"
SIZE 3
COLOR 0 0 255
END
END
in database
I have two table
one is store id lat1 lon1 lat2 lon2
and another is view
of this table created by following
create view lineview as select eq_id, "LINESTRING(" + lon1 + " " + lat1
+ "," + lon2 + " " + lat2 + ")" as geom from sfault
there is an another issue,
I have to draw line by considering id
so in the map When I select one id, line should be belong to this id's
information
so I have to make a sql statement as follow instead of draw all line
stored in database I have to draw just one line considering id
something like this select eq_id, geom from lineview where id like '%id
%'
please help about this subject
Regards
Murat
On Tue, 2012-02-21 at 09:15 +1300, Robert Sanson wrote:
> Hi Murat
>
> Is it possible for you to create a view from the columns that presents the
> data as a WKT line feature:
>
> create view lineview as select id, "LINESTRING(" + lon1 + " " + lat1 + "," +
> lon2 + " " + lat2 + ")" as geom from mytable
>
> Then set up your OGR ovf file representing this view:
>
>
>
> ODBC:user/passwd@DSN
> lineview
> wkbLine
> EPSG:2193
>
> id
>
>
>
> Best wishes,
>
> Robert
>
> >>> Murat Beyhan 21/02/2012 2:52 a.m. >>>
> Dear friend,
>
> I'm trying to draw a line using MySql database
> the table in database as follows,
>
> idlat1 lon1lat2lon2
> 20100308023229 40.1113 38.7901 40.0311 38.7428
>
> actually using ogr connection I can draw point using ogr and mysql, but
> How can I draw line using such database table, please help me and give
> the idea...
>
> Thanks
>
> Murat
> --
> Murat BEYHAN
> Geophysical Engineer, M.Sc.
> Prime Ministry
> Disaster and Emergency Management Presidency
> Earthquake Department
> Address: Eskisehir Yolu 12. Km.
> Lodumlu/ANKARA
> Tel: 312 2872680-1556
> email:bey...@deprem.gov.tr
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> This email and any attachments are confidential and intended solely for the
> addressee(s). If you are not the intended recipient, please notify us
> immediately and then delete this email from your system.
>
> This message has been scanned for Malware and Viruses by Websense Hosted
> Security.
> www.websense.com
>
Murat BEYHAN
Jeofizik Y.Müh.
T.C. Başbakanlık
Afet ve Acil Durum Yönetimi Başkanlığı
Deprem Dairesi Başkanlığı
Eskişehir Yolu 12. Km.
Lodumlu/ANKARA
Tel: 312 2872680-1556
email:bey...@deprem.gov.tr
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] draw line readinf from mysql
Dear Robert,
Thanks for your reply,
Actually I have tried your suggestion but I could not succeed.
as follows in .map file directly
and in MySQL database I created a lineview view as follows
create view lineview as select eq_id, "LINESTRING(" + lon1 + " " + lat1
+ "," + lon2 + " " + lat2 + ")" as geom from sfault
in map file
I changed Geometrytype from wkbline to wkblinestring.
LAYER
NAME sfault1
connectiontype ogr
CONNECTION '
MYSQL:dynamic,user=root,password=mysqlpasswd,host=localhost,port=3306,tables=lineview
lineview
wkbLineString
WGS84
eq_id
'
#ODBC:user/passwd@DSN
DATA sfault1
STATUS on
TYPE line
CLASS
name "Source Fault"
SYMBOL "cline"
SIZE 3
COLOR 0 0 255
END
END
There is an another issue I have to make a query in layer because I
select only one line from database so I have try to add SQL statement. I
'm not good at OGR GDAL so I need some advice and help.
Thank you for your interest
On Tue, 2012-02-21 at 09:15 +1300, Robert Sanson wrote:
> Hi Murat
>
> Is it possible for you to create a view from the columns that presents the
> data as a WKT line feature:
>
> create view lineview as select id, "LINESTRING(" + lon1 + " " + lat1 + "," +
> lon2 + " " + lat2 + ")" as geom from mytable
>
> Then set up your OGR ovf file representing this view:
>
>
>
> ODBC:user/passwd@DSN
> lineview
> wkbLine
> EPSG:2193
>
> id
>
>
>
> Best wishes,
>
> Robert
>
> >>> Murat Beyhan 21/02/2012 2:52 a.m. >>>
> Dear friend,
>
> I'm trying to draw a line using MySql database
> the table in database as follows,
>
> idlat1lon1lat2lon2
> 20100308023229 40.1113 38.7901 40.0311 38.7428
>
> actually using ogr connection I can draw point using ogr and mysql, but
> How can I draw line using such database table, please help me and give
> the idea...
>
> Thanks
>
> Murat
> --
> Murat BEYHAN
> Geophysical Engineer, M.Sc.
> Prime Ministry
> Disaster and Emergency Management Presidency
> Earthquake Department
> Address: Eskisehir Yolu 12. Km.
> Lodumlu/ANKARA
> Tel: 312 2872680-1556
> email:bey...@deprem.gov.tr
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
>
> This email and any attachments are confidential and intended solely for the
> addressee(s). If you are not the intended recipient, please notify us
> immediately and then delete this email from your system.
>
> This message has been scanned for Malware and Viruses by Websense Hosted
> Security.
> www.websense.com
>
Murat BEYHAN
Jeofizik Y.Müh.
T.C. Başbakanlık
Afet ve Acil Durum Yönetimi Başkanlığı
Deprem Dairesi Başkanlığı
Eskişehir Yolu 12. Km.
Lodumlu/ANKARA
Tel: 312 2872680-1556
email:bey...@deprem.gov.tr
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] draw line readinf from mysql
Dear friend, I'm trying to draw a line using MySql database the table in database as follows, idlat1lon1lat2lon2 20100308023229 40.1113 38.7901 40.0311 38.7428 actually using ogr connection I can draw point using ogr and mysql, but How can I draw line using such database table, please help me and give the idea... Thanks Murat -- Murat BEYHAN Geophysical Engineer, M.Sc. Prime Ministry Disaster and Emergency Management Presidency Earthquake Department Address: Eskisehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Open failed for OGR connection
Dear friends, I could not solve the problem for OGR connections. from terminal I use the following codes and it works fine [mu...@localhost makedaskmap]$ ogrinfo "MySQL:testogr,user=root,password=mysql_123" INFO: Open of `MySQL:testogr,user=root,password=mysql_123' using driver `MySQL' successful. 1: deniz (Polygon) 2: il_merkezleri (Point) 3: il_sinirlari (Polygon) 4: ilce_merkezleri (Point) 5: ilce_sinirlari (Polygon) 6: iller (Polygon) 7: iller_sil (Polygon) 8: komsular (Polygon) But when I try to read data from mysql database it doesn't work for it. and mapserver gives error as follows msDrawMap(): Image handling error. Failed to draw layer named 'ilcmrk'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `ilcmrk'. File not found or unsupported format. part of map file as follows for the layer ilcmrk data ilce_merkezleri is stored in Mysql table testogr as point I have reganerated the ilce_merkezleri data in MySql database as follows ogr2ogr -f MySQL MySQL:testogr,user=root,password=mysql_123 ilcmrk.shp -nln ilce_merkezleri -update -overwrite -lco GEOMETRY_NAME=SHAPE2 LAYER connectiontype ogr CONNECTION "MySQL:testogr,user=root,password=mysql_123" NAME "ilcmrk" DATA ilce_merkezleri STATUS default TYPE POINT CLASS NAME "iLCE MERKEZi" SYMBOL "cpoint" SIZE 1 COLOR 72 118 255 END END What is wrong with my procedures. Please help me. Murat -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Could not read data from MySQL database
Dear David and friends, I have install rpm package of Mapserver and MySql. But When I use gdal I compiled source code. Because rpm package of gdal doesn't support MySQl formats. Then I checked ogrinfo file it was under /usr/local/bin and when I use whereis ogrinfo command it says same place for ogrinfo. [mu...@localhost apps]$ whereis ogrinfo ogrinfo: /usr/local/bin/ogrinfo So I updated MySQL table by using ogr2ogr for update the data stored in MySQL database. But still same problem is continuing. I can't catch the problem where it is. So, do you have any idea? Murat On Fri, 2010-09-17 at 09:14 -0500, Fawcett, David (MPCA) wrote: > I don't know if this applies to your case at all. In other cases where > people have had mysql connections fail, it has sometimes been due to the lack > of mysql support in ogr. One question to figure out is whether the ogr being > used by MapServer is the same ogr that you are hitting when you run ogrinfo. > > David. > > -Original Message- > From: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Murat Beyhan > Sent: Thursday, September 16, 2010 5:18 PM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] Could not read data from MySQL database > > Dear Friends, > > I was succeeded to read and draw data from MySQL database using OGR > connection until upgrade mapserver and gdal. > > Now I use the same codes but could not read data form MySql database. > I have created tables using ogr2ogr again. > but still When I open webpage the following error message occurred. > > msDrawMap(): Image handling error. Failed to draw layer named 'sea'. > msOGRFileOpen(): OGR error. Open failed for OGR connection in layer > `sea'. File not found or unsupported format. > > What is wrong for that, please help. > > When I try ogrinfo as follows it works > [mu...@localhost mapdata]$ ogrinfo > "MySQL:testogr,user=root,password=mysql_123" > INFO: Open of `MySQL:testogr,user=root,password=mysql_pass' > using driver `MySQL' successful. > 1: deniz (Polygon) > 2: il_merkezleri (Point) > 3: il_sinirlari (Polygon) > 4: ilce_merkezleri (Point) > 5: ilce_sinirlari (Polygon) > 6: iller (Polygon) > 7: iller_sil (Polygon) > 8: komsular (Polygon) > [mu...@localhost mapdata]$ > > > AND > my mapserver version info as follows > > [mu...@localhost mapdata]$ mapserv -v > MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP > OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=ICONV > SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER > SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS > INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE > > and > [mu...@localhost mapdata]$ ogrinfo > --formats > Supported > Formats: > > -> "ESRI > Shapefile" (read/write) > > -> "MapInfo > File" (read/write) > > -> > "UK .NTF" (readonly) > > -> "SDTS" (readonly) > -> "TIGER" (read/write) > -> "S57" (read/write) > -> "DGN" (read/write) > -> "VRT" (readonly) > -> "REC" (readonly) > -> "Memory" (read/write) > -> "BNA" (read/write) > -> "CSV" (read/write) > -> "GML" (read/write) > -> "GPX" (read/write) > -> "KML" (read/write) > -> "GeoJSON" (read/write) > -> "Interlis 1" (read/write) > -> "Interlis 2" (read/write) > -> "GMT" (read/write) > -> "SQLite" (read/write) > -> "ODBC" (read/write) > -> "PGeo" (readonly) > -> "OGDI" (readonly) > -> "MySQL" (read/write) > -> "PCIDSK" (readonly) > -> "XPlane" (readonly) > -> "AVCBin" (readonly) > -> "AVCE00" (readonly) > -> "DXF" (read/write) > -> "GRASS" (readonly) > -> "Geoconcept" (read/write) > -> "GeoRSS" (read/write) > -> "GPSTrackMaker" (read/write) > -> "VFK" (readonly) > > > > > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > -- Murat BEYHAN Jeofizik Y.Müh. T.C. Başbakanlık Afet ve Acil Durum Yönetimi Başkanlığı Deprem Dairesi Başkanlığı Eskişehir Yolu 12. Km. Lodumlu/ANKARA Tel: 312 2872680-1556 email:bey...@deprem.gov.tr -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Could not read data from MySQL database
Dear Friends, I was succeeded to read and draw data from MySQL database using OGR connection until upgrade mapserver and gdal. Now I use the same codes but could not read data form MySql database. I have created tables using ogr2ogr again. but still When I open webpage the following error message occurred. msDrawMap(): Image handling error. Failed to draw layer named 'sea'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `sea'. File not found or unsupported format. What is wrong for that, please help. When I try ogrinfo as follows it works [mu...@localhost mapdata]$ ogrinfo "MySQL:testogr,user=root,password=mysql_123" INFO: Open of `MySQL:testogr,user=root,password=mysql_pass' using driver `MySQL' successful. 1: deniz (Polygon) 2: il_merkezleri (Point) 3: il_sinirlari (Polygon) 4: ilce_merkezleri (Point) 5: ilce_sinirlari (Polygon) 6: iller (Polygon) 7: iller_sil (Polygon) 8: komsular (Polygon) [mu...@localhost mapdata]$ AND my mapserver version info as follows [mu...@localhost mapdata]$ mapserv -v MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE and [mu...@localhost mapdata]$ ogrinfo --formats Supported Formats: -> "ESRI Shapefile" (read/write) -> "MapInfo File" (read/write) -> "UK .NTF" (readonly) -> "SDTS" (readonly) -> "TIGER" (read/write) -> "S57" (read/write) -> "DGN" (read/write) -> "VRT" (readonly) -> "REC" (readonly) -> "Memory" (read/write) -> "BNA" (read/write) -> "CSV" (read/write) -> "GML" (read/write) -> "GPX" (read/write) -> "KML" (read/write) -> "GeoJSON" (read/write) -> "Interlis 1" (read/write) -> "Interlis 2" (read/write) -> "GMT" (read/write) -> "SQLite" (read/write) -> "ODBC" (read/write) -> "PGeo" (readonly) -> "OGDI" (readonly) -> "MySQL" (read/write) -> "PCIDSK" (readonly) -> "XPlane" (readonly) -> "AVCBin" (readonly) -> "AVCE00" (readonly) -> "DXF" (read/write) -> "GRASS" (readonly) -> "Geoconcept" (read/write) -> "GeoRSS" (read/write) -> "GPSTrackMaker" (read/write) -> "VFK" (readonly) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ogr connection failed
Hi All, I have installed rpm package of Mapserver 5.6.3 adn I have installed gdal 1.7.2 by using tar.gz file when I attempt to open map file from webpage I faced the following error message msDrawMap(): Image handling error. Failed to draw layer named 'Dhuman'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `Dhuman'. Failed to open datasource `MYSQL:turkey,user=root,password=mysqlpass,host=localhost,port=3306,tables=d_damage m_village'. but when I use terminal for ogrinfo I can connect to database successfully What is wrong could you help me please [mu...@sakura cgi-bin]$ ogrinfo "MYSQL:turkey,user=root,password=mysqlpass,host=localhost,port=3306,tables=d_pgadata" INFO: Open of `MYSQL:turkey,user=root,password=mysqlpass,host=localhost,port=3306,tables=d_pgadata' using driver `MySQL' successful. 1: d_pgadata (None) [mu...@sakura cgi-bin]$ or [mu...@sakura cgi-bin]$ ogrinfo "MySQL:testogr,user=root,password=mysqlpass" INFO: Open of `MySQL:testogr,user=root,password=mysql_123' using driver `MySQL' successful. 1: deniz (Polygon) 2: il_merkezleri (Point) 3: il_sinirlari (Polygon) 4: ilce_merkezleri (Point) 5: ilce_sinirlari (Polygon) 6: iller (Polygon) 7: iller_sil (Polygon) 8: komsular (Polygon) these works fine. ogr also support these formats [mu...@sakura cgi-bin]$ ogrinfo --formats Supported Formats: -> "ESRI Shapefile" (read/write) -> "MapInfo File" (read/write) -> "UK .NTF" (readonly) -> "SDTS" (readonly) -> "TIGER" (read/write) -> "S57" (read/write) -> "DGN" (read/write) -> "VRT" (readonly) -> "REC" (readonly) -> "Memory" (read/write) -> "BNA" (read/write) -> "CSV" (read/write) -> "GML" (read/write) -> "GPX" (read/write) -> "KML" (read/write) -> "GeoJSON" (read/write) -> "GMT" (read/write) -> "SQLite" (read/write) -> "ODBC" (read/write) -> "PGeo" (readonly) -> "OGDI" (readonly) -> "MySQL" (read/write) -> "PCIDSK" (readonly) -> "XPlane" (readonly) -> "AVCBin" (readonly) -> "AVCE00" (readonly) -> "DXF" (read/write) -> "Geoconcept" (read/write) -> "GeoRSS" (read/write) -> "GPSTrackMaker" (read/write) -> "VFK" (readonly) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] get point informationand write it on the web-page
Dear Friend, I use mapserver and mysql to draw seismicity map which is showing epicenter points on the map. I would like to get information about the earthquake which are stored in MySQL database when you click on point on the map and display it or write it automatically somewhere on the web-page. Are there any way to do this and how can I do it. Thanks. Murat -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Fatal error: Call to undefined function (dl)
Hi Friends,
I have installed apache 2.2.14 and php 5.3.1
then I have installed mapserver 5.6.1 with phpMapScript module.
I have try to open a phpmapscript file on the server, which was worked
fine for php4, but the following message occured
Fatal error: Call to undefined function dl()
in /usr/local/httpd/htdocs/zone/zone30.php on line 3
line 3 in my php file is as follows
dl('php_mapscript.so');
so
I have enabled first dl on the php.ini file
than still this problem couldn't solved and I read php manuals and dl
function was deprecated so I removed that line but this time I faced the
following error
Fatal error: Call to undefined function ms_GetVersion() in
IT seems php_mapscript module could not install properly...
When I try to use phpinfo_mapscript.phtml
also same problem occured.
in httpd.conf file php loaded and other php pages works fine except than
php mapscript
LoadModule php5_module modules/libphp5.so
so I have created a directory under php directory named extensions where
I installed than I put php_mapscript.so into there. Than I write the
path into php.ini file as follows
extension_dir = "/usr/local/httpd/php/extensions"
but still could not open phpmapscript files on the server.
Could you help me please
Murat
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] how can I associate MySql and Gdal
Hi friends, I have installed mandriva 2010 and then installed Mysql mapserver and gdal which are coming with Mandriva one CD. But I could not read data from MySql database by using ogr because of the supported formats. How could I associate MySql with gdal in order to draw map using data stored in MySql Please help me the formats supported by gdal as follows murat ogrinfo --formats Supported Formats: -> "GRASS" (readonly) -> "ESRI Shapefile" (read/write) -> "MapInfo File" (read/write) -> "UK .NTF" (readonly) -> "SDTS" (readonly) -> "TIGER" (read/write) -> "S57" (read/write) -> "DGN" (read/write) -> "VRT" (readonly) -> "REC" (readonly) -> "Memory" (read/write) -> "BNA" (read/write) -> "CSV" (read/write) -> "GML" (read/write) -> "GPX" (read/write) -> "KML" (read/write) -> "GeoJSON" (read/write) -> "GMT" (read/write) -> "SQLite" (read/write) -> "ODBC" (read/write) -> "PGeo" (readonly) -> "OGDI" (readonly) -> "PostgreSQL" (read/write) -> "XPlane" (readonly) -> "AVCBin" (readonly) -> "AVCE00" (readonly) -> "Geoconcept" (read/write) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] how can I associate MySql and Gdal
Hi friends, I have installed mandriva 2010 and then installed Mysql mapserver and gdal which are coming with Mandriva one CD. But I could not read data from MySql database by using ogr because of the supported formats. How could I associate MySql with gdal in order to draw map using data stored in MySql Please help me the formats supported by gdal as follows murat ogrinfo --formats Supported Formats: -> "GRASS" (readonly) -> "ESRI Shapefile" (read/write) -> "MapInfo File" (read/write) -> "UK .NTF" (readonly) -> "SDTS" (readonly) -> "TIGER" (read/write) -> "S57" (read/write) -> "DGN" (read/write) -> "VRT" (readonly) -> "REC" (readonly) -> "Memory" (read/write) -> "BNA" (read/write) -> "CSV" (read/write) -> "GML" (read/write) -> "GPX" (read/write) -> "KML" (read/write) -> "GeoJSON" (read/write) -> "GMT" (read/write) -> "SQLite" (read/write) -> "ODBC" (read/write) -> "PGeo" (readonly) -> "OGDI" (readonly) -> "PostgreSQL" (read/write) -> "XPlane" (readonly) -> "AVCBin" (readonly) -> "AVCE00" (readonly) -> "Geoconcept" (read/write) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
