Re: [mapserver-users] MapServer + Database + WFS
Hi, I have successfully created WFS layers from Oracle 9i database. I have not used that service very much, though, because for some reason ready made GIS clients had troubles in parsing the returned gml and I started to use GeoServer for WFS instead. I believe the trouble was not anything great, because ogr2ogr was happily translating the gml files to other vector formats if I stored them on disk first. I think there are three things in your DATA line which may go wrong. They may be OK as well, but perhaps you may have a look on them anyway. First is in this SELECT: geom FROM (SELECT swt.switch_id, swt.switch_descr, sgt.geom I would try in like new_geom FROM (SELECT swt.switch_id, swt.switch_descr, sgt.geom AS new_geom Just to be sure that a correct item will be queried by the final query. Another thing is SRID USING SRID 8307 I do not know if Oracle for sure nowadays understands automatically that this is jsut the epsg code it should be using. I would make a try by importing a simple dataset into Oracle with shp2sdo or something. First import by leaving the SRID as empty, and second be giving the correct epsg code. Then I would make two new layers in mapfile and start playing with WFS queries. Perhaps you can even just cut out the USING SRID 8307 from your current mapfile. I suppose the data is actually in epsg:8307 in Oracle and you do not need to reproject it when running queries? By the way, you seem not to have projections set for your layers. It is not necessary if you are working with one projection only, but you will have much better control on what will really happen if you set projections for all the layers and for the whole mapfile. Finally, your DATA is missing using unique. I am not sure if it is necessary, though. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: [EMAIL PROTECTED] puolesta: Nolte, Tim Lähetetty: ke 30.7.2008 18:59 Vastaanottaja: Yewondwossen Assefa Kopio: mapserver-users@lists.osgeo.org Aihe: RE: [mapserver-users] MapServer + Database + WFS So the specific issue I'm having is that my Oracle Spatial layers are not coming back with any features. Here's a couple of my Mapfile entries: LAYER GROUP switchboundaries NAME davenport TYPE POLYGON STATUS ON CONNECTIONTYPE oraclespatial CONNECTION .../[EMAIL PROTECTED] PROCESSING CLOSE_CONNECTION=DEFER DATA geom FROM (SELECT swt.switch_id, swt.switch_descr, sgt.geom FROM ms_switch_vw swt, switch_geom_tab sgt WHERE swt.switch_id = sgt.switch_id AND swt.switch_id = 7) USING SRID 8307 LABELITEM switch_descr METADATA wfs_title Switch Boundaries: Davenport wfs_latlonboundingbox -104.29 29.71 -71.55 52.63 wfs_typename davenport gml_featureid switch_id gml_include_items switch_id,switch_descr gml_switch_descr_alias Switch END DUMP TRUE TRANSPARENCY 100 END LAYER GROUP cellsites NAME onair TYPE POINT STATUS ON CONNECTIONTYPE oraclespatial CONNECTION .../[EMAIL PROTECTED] PROCESSING CLOSE_CONNECTION=DEFER DATA geom FROM (SELECT st.site_id, st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab sgt WHERE st.site_id = sgt.site_id AND st.site_status_id IN (4,7)) USING SRID 8307 LABELITEM bts_nbr METADATA wfs_title Cell Sites: On-Air wfs_latlonboundingbox -104.29 29.71 -71.55 52.63 wfs_typename onair gml_geometries geom gml_boundary_type point gml_featureid site_id gml_include_items site_id,bts_nbr gml_bts_nbr_alias BTS# END DUMP TRUE END Any help would be greastly appreciated. Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: Yewondwossen Assefa [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2008 11:38 AM To: Nolte, Tim Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] MapServer + Database + WFS Tim, I have used mainly Postgis with Mapserver and WFS. I am pretty sure some have used SDE as a back end. Oracle spatial is also known to work with Mapserver for a while so I see no reason why it could not be used as a WFS server too. Are you facing particular problems? Are you concerned about performance issues? As for the documentation, I am assuming that you are taking about http://mapserver.gis.umn.edu/docs/howto/wfs_server, It has been a while that It has been updated but information in it is still correct. Maybe specific issues/comment could help improving it. best Regards, Nolte, Tim wrote: Is no one out there using Oracle Spatial, or any other DB, with MapServer and WFS? There is pretty much a huge lack of documentation for serving WFS from MapServer. It would be nice to know if what I'm attempting is even possible
Re: [mapserver-users] SLD in a wms service
Hey David, SLD enables remote classification and symbolization of data. So a sld can be defined by a user, doing a request. See this doc: http://mapserver.gis.umn.edu/docs/howto/sldhowto and of course the WMS/SLD specifications. Roy Braam From: David Martinez Morata [mailto:[EMAIL PROTECTED] To: mapserver [mailto:[EMAIL PROTECTED] Sent: Wed, 30 Jul 2008 16:08:17 +0200 Subject: [mapserver-users] SLD in a wms service Hello List. I'm trying to made a WMS service with an SLD definition, but WHERE i must define the SLD file? In layer? In Map? in wms metadata? Sorry i'm confused about this. Thanks ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Output image resolution - explanation needed
Thanks, you helped me a lot In my example, I have printed an area of aproximately 1km wide on an A4 Landscape that is 29,7cm wide, so 1inch is about 85.5m. So that should be the reason? :-) regards, dejan Rahkonen Jukka [EMAIL PROTECTED] wrote on 31.07.2008 11:00:15: Hi, What are the dimensions of the image you have captured in real world utits? Your original aerial images have half a metre pixel size. It mean that at 300 dpi one original image pixel corresponds with one pixel at paper if square inch on your printout is presenting exactly 150 by 150 meters in nature. That is the maximum quality you can achieve. If square inch on paper equals to 75 by 75 meters the maximum quolity is achieved already at 150 dpi. Multiplicating original image pixels for printing cannot improve the quality. But if you have zoomed out so far that creating output image means downsampling the original imagery you should see the differense. So, if your 2150x low resolution image is covering a considerably larger area than 1075x555 meters in real world it should look better when downloaded at 300 dpi with 4300x pixels. -Jukka Rahkonen- Lähettäjä: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Puolesta [EMAIL PROTECTED] Lähetetty: 31. heinäkuuta 2008 9:32 Vastaanottaja: mapserver-users@lists.osgeo.org Aihe: Re: [mapserver-users] Output image resolution - explanation needed Thanks Steve I still (unfortunatelly) don't understand why I am getting the same quality image on the paper with the first and second print (the second image has twice more pixels). Is it because of the input image itself? To be specific - the raster input is aerial image that gdalinfor reports as: Driver: GTiff/GeoTIFF Files: 5C14-05-DOF.tif Size is 4500, 6000 Coordinate System is `' Origin = (5419000.15465885310,4964998.79465280470) Pixel Size = (0.499829146050620,-0.499829146050620) Corner Coordinates: Upper Left ( 5419000.155, 4964998.795) Lower Left ( 5419000.155, 4961999.820) Upper Right ( 5421249.386, 4964998.795) Lower Right ( 5421249.386, 4961999.820) Center ( 5420124.770, 4963499.307) Band 1 Block=256x256 Type=Byte, ColorInterp=Red Overviews: 2250x3000, 1125x1500, 563x750, 282x375 Band 2 Block=256x256 Type=Byte, ColorInterp=Green Overviews: 2250x3000, 1125x1500, 563x750, 282x375 Band 3 Block=256x256 Type=Byte, ColorInterp=Blue Overviews: 2250x3000, 1125x1500, 563x750, 282x375 regards, dejan Steve Lime [EMAIL PROTECTED] wrote on 30.07.2008 21:13:55: Resolution in MapServer-speak is referring to the resolution of the output device a map will be displayed on. The value is used for scale computations and nothing else. It does not affect the size (in pixels) of MapServer. Scale values do impact the size at which features and text are rendered IF scaling (via SYMBOLSCALE) is turned on. Higher quality output is usually a matter of having more pixels to print, however you usually want larger features too which is where the resolution parameter combined with scaling can help. Steve On 7/30/2008 at 2:21 AM, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: Hi, I am trying to download a high resolution image and print it on a paper. I am using p.mapper and its download function that enables downloading the map image on different resolutions. I have turned on my raster layer (ortophoto image). I have zoomed in to an area of interest. I have downloaded the map twice - with a resolution of 150 and 300. The image is shown i a new page/tab (firefox). I right click on the image and save it as a png (also tried with a jpeg) file.Now, the first file is 2150x pixels, 120 dpi vertical and horizontal resolution (right click on a file, properties, summary, what does it mean?), the second file is 4300x pixels, 120 dpi vertical and horizontal resolution. Seems ok. The second image is doubled in pixel size. Now, when I try to print this image on A4 paper, using 300dpi, the images are the same, there is no better quality in second image. I have just finshed reading the Mapserver thread on Change image resolution in mapfile. Several limitations are mentioned there - max. image size supported by Mapserver, resolution value/tag embedded in output format, etc. Can it be related to my problem? Or is it maybe that software I am using to print this image doesn't use this extra pixels? Or I am just missing some basic stuff I need to know :-( thanks very much on any explanation regards, dejan ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] XLS to shape file.
Hello to everyone. i would like to ask if someone knows how can i create a shape file with points from an xls .file. In .xls file i have written the coordinates of every point of interest in the form +39,2158 +22,5618 (latitude and longitude in diffirent columns). I also have written some other information for every point in different column. Thank you in advance. Nikos Papadakis. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Ploblems with labels.
Te recomiendo que en el directorio donde se encuentra tu archivo .MAP, crea un directorio llamado fuentes en donde copies los archivos .TTF para que en el archivo FONTS.LIST solo hagas referencia a /fuentes/nombre_archivo.ttf I suggest you to create a folder named fuentes within the place where your .MAP file is, and then, copy the .TTF files there. Then, in the FONTS.LIST file you just put the /fonts/file_name.ttf reference. IC Carlos Ruiz --- On Thu, 7/31/08, Stephen Woodbridge [EMAIL PROTECTED] wrote: From: Stephen Woodbridge [EMAIL PROTECTED] Subject: Re: [mapserver-users] Ploblems with labels. To: David Martinez Morata [EMAIL PROTECTED] Cc: mapserver mapserver-users@lists.osgeo.org Date: Thursday, July 31, 2008, 11:47 AM David Martinez Morata wrote: Hello list. I try to conect ArcGIS with a WMS server. But when I try to render Labels in other Font type tha the first of my font.list arcgis send an error msGetLabelSize() TrueType Font error. Request (arial-bold-italic)not found My fonts.list file its: arial C:\WINDOWS\Fonts\arial.ttf arial-italic C:\WINDOWS\Fonts\ariali.ttf arial-bold-italic C:\WINDOWS\Fonts\arialbi.ttf Thanks try changing you \ to / in the file paths. Also confirm that the file actually exists ar the cmd promopt: dir C:\WINDOWS\Fonts\arialbi.ttf -Steve W ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
