mapserver+postgresql求助.mapserver+postgresql怎么配置?在WINDOWS下,我把原来读取文件*.map里面的改成连接数据库,但是读取不出来?(PHP可以正常读取postgresql的数据)能不能给给范例?谢谢----------------

Question

mapserver + postgresql求助. mapserver+postgresql 怎么配置? 在WINDOWS下,我把原来读取文件*.map 里面的改成连接数据库,但是读取不出来?(PHP可以正常读取postgresql的数据) 能不能给给范例?谢谢 -------------------- 读取文件 LAYER NAME "countries" TYPE polygon DATA "countries" ------------------------------------ 读取数据库 LAYER NAME 'Countries' TYPE POLYGON CONNECTIONTYPE postgis CONNECTION 'host=localhost user=postgres_gis password=jack dbname=postgres_gis' DATA 'the_geom FROM countries' ---------------------------------------------

Answer 1

MAP IMAGETYPE PNG EXTENT 139.602 35.413 139.678 35.489 SIZE 300 300 IMAGECOLOR 255 255 255 SHAPEPATH "../data" FONTSET "../fonts/fonts.list" WEB IMAGEPATH "../tmp/" IMAGEURL "/public/pgRouting/tmp/" END PROJECTION "init=epsg:4612" # JGD2000 END UNITS DD SYMBOL NAME "hatch" TYPE hatch END LAYER NAME "roads" DATA kanagawa STATUS DEFAULT TYPE LINE CLASS COLOR 195 195 195 END END LAYER NAME "place_names" DATA chimei STATUS DEFAULT TYPE ANNOTATION LABELITEM "NAMAE" CLASS COLOR 20 20 20 LABEL TYPE TRUETYPE FONT gothic ENCODING SJIS COLOR 220 3 3 SHADOWCOLOR 210 210 5 SIZE 8 POSITION CC PARTIALS TRUE BUFFER 7 END END END LAYER NAME "path" CONNECTION "user=postgres dbname=routing host=localhost port=5432" CONNECTIONTYPE postgis STATUS OFF TYPE LINE CLASS NAME "path" STYLE COLOR 250 0 0 WIDTH 2 END END END END ------------------------------------------------------------------------------------------ IMAGETYPE [gif|png|jpeg|wbmp|gtiff|swf|userdefined] 生成图片的类型 EXTENT [minx] [miny] [maxx] [maxy] 地图边界 可以用postgis中的extent函数对geometry类型数据列计算获得 IMAGECOLOR [r] [g] [b] 地图背景色 SHAPEPATH [filename] shp所在文件夹路径 FONTSET [filename] 字体文件列表 PROJECTION ... END 设置投影，可用参数为PROJ关键字 "init=epsg:4612" 这里指定了坐标参照系统为JDG2000(其epsg id 为4612) UNITS [feet|inches|kilometers|meters|miles|dd] 地图坐标系的单位