Re: [mapserver-users] WMS TIME parameter slow
Hello, i have setup a test db with a 'timestamp' date field (-MM-DD HH:MM:SS). Tests have been done with various request patterns i.e. leaving out the HH:MM:SS part etc. This works just fine and you allways get fast INDEXED SCANS on this. Requests with an interval to seconds is possible and fast, even within millions of data sets. So to me it looks like that you don't need 'date_trunc' at all. But as said i'am not a db/sql guru. Just two observations: 1) Postgres default is to cast the request to '::timestamp without time zone' in Version 5.3: i.e. Index Scan using bro_v32_timed_y2003_datum on bro_v32_timed_y2003 bro_v32_timed (cost=0.00..8.28 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1) Index Cond: ((datum '2007-12-10 10:00:00'::timestamp without time zone) AND (datum '2007-12-10 13:00:15'::timestamp without time zone)) So it might be an idea to cast the request explicitly and not to rely on POSTGRES defaults (or let the user specify a time zone). I have done no tests with time zones set. 2) The HH:MM:SS part if present (it can be left out) needs to be regexped because POSTGRES won't accept 'HH' or 'HH:' only. A minimum of HH:M is required. Just my 2ct. I have patched MS 5.6.1 with the above for our setup and it works just fine. Thanks for working this over in MS6. Regards Heiko Sorry to jump late on this. The use of the date_trunc function for postgis layers (described http://mapserver.org/ogc/wms_time.html) was from what I remember to allow queries (on a timestamp field) like time=2001-01-01 expecting to get back all values of the day regardless of the time set. I have entered a bug on it (http://trac.osgeo.org/mapserver/ticket/3382) to be able to review it before the 6.0 release. regards, Paul Ramsey wrote: Sorry, there's not much more I can offer, you've done a great job debugging, but at the end of the day the SQL being generated by the WMS Time module is not great. Make sure to run 'ANALYZE' on your database so the planner has the latest stats. P. On Thu, Mar 11, 2010 at 5:59 AM, Heiko Schröter schro...@iup.physik.uni-bremen.de wrote: Am Donnerstag 11 März 2010 14:35:53 schrieben Sie: Paul, thanks for staying at it. These timings i get with the variation of the theme. The second best is to cast 'datum::timestamp'. But still beeing 32times slower than just a trivial compare on the index as in 1). The slowest run is the brute force 'date_trunc' without cast 3). So to me this is a bit voodo why postgres refuses to scan the indices in proper speed in 2) and 3). The maximum index scan i get with 'date_trunc' is a 'Bitmap Heap Scan' on the index with scenario 2). Of what i have found inside the docs/google is that even when casting 'datum' inside postgres the request, here generated by MS, should or have to be casted as well which is not (at least by now). Heiko 1) The brute force compare: sc_gis=# explain analyze select datum,farbe,encode(AsBinary(force_collection(force_2d(rechteck)),'NDR'),'hex') as geom,datum from o_v20 where rechteck GeomFromText('POLYGON((-134.90506329114 -78.2278481012662,-134.90506329114 78.2278481012663,134.90506329114 78.2278481012663,134.90506329114 -78.2278481012662,-134.90506329114 -78.2278481012662))',-1) and (datum = '2007-12-10' and datum = '2007-12-11'); snipsnap Total runtime: 41.018 ms (32 rows) Now Create Immutable Index on our play table: CREATE INDEX o_v20_y2007_date_trunc ON o_v20_y2007 (date_trunc('day', datum::timestamp without time zone)); 2) sc_gis=# CREATE INDEX o3_v20_y2007_date_trunc ON o3_v20_y2007 (date_trunc('day', datum::timestamp without time zone)); ERROR: relation o3_v20_y2007_date_trunc already exists scia_gis=# explain analyze select datum,farbe,encode(AsBinary(force_collection(force_2d(rechteck)),'NDR'),'hex') as geom,datum from o_v20 where rechteck GeomFromText('POLYGON((-134.90506329114 -78.2278481012662,-134.90506329114 78.2278481012663,134.90506329114 78.2278481012663,134.90506329114 -78.2278481012662,-134.90506329114 -78.2278481012662))',-1) and ((date_trunc('day', datum::timestamp without time zone) = '2007-12-10' AND date_trunc('day', datum::timestamp without time zone) = '2007-12-11')); snipsnap Total runtime: 1250.679 ms (26 rows) 3) sc_gis=# explain analyze select datum,farbe,encode(AsBinary(force_collection(force_2d(rechteck)),'NDR'),'hex') as geom,datum from o_v20 where rechteck GeomFromText('POLYGON((-134.90506329114 -78.2278481012662,-134.90506329114 78.2278481012663,134.90506329114 78.2278481012663,134.90506329114 -78.2278481012662,-134.90506329114 -78.2278481012662))',-1) and ((date_trunc('day', datum) = '2007-12-10' AND date_trunc('day', datum) = '2007-12-11')); snipsnap Total runtime: 2329.380 ms (23 rows) Good job getting this far on your own! Create a SQL
Re: [mapserver-users] WFS limit time interval to POSTGIS
Hi there, There is no explicit support of a TIME parameter in wfs but I believe It should be possible on a postgis layer to use the FilterEncoding to limit the request: would something like this work for you: Filter=FilterAndPropertyIsGreaterThanPropertyNameyour_time_field/PropertyNameLiteral2007-01-02/Literal/PropertyIsGreaterThanPropertyIsLessThanPropertyNameyour_time_field/PropertyNameLiteral2007-01-03/Literal/PropertyIsLessThan/And/Filter regards, Thanks very much for the suggestion. It does not work that easy (of course ;-) ) but you can filter using the following converting the date to UNIX epochs first and compare the integers. Unfortunatly the WFS part of MS 5.6.1 does not handle the type 'date' -MM-DD for comparison or calculus. This works: http://localhost/cgi-bin/mapserv.patched/?map=/var/www/localhost/mapserver/wfs6_include.mapSERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=BRO_V32_TIMEDFILTER=FilterAndPropertyIsGreaterThanPropertyNamedate_part('epoch',datum::timestamp without time zone)/PropertyNameLiteral1191359000/Literal/PropertyIsGreaterThanPropertyIsLessThanPropertyNamedate_part('epoch',datum::timestamp without time zone)/PropertyNameLiteral1191359640/Literal/PropertyIsLessThan/And/Filter Still quite ugly to mee. Is there a deeper reason for not having a time spec within WFS ? To me you usually have data points in space _and_ time. But i'am not a GEO man either (daily satellite based measurements we have). Thanks and Regards Heiko The LAYER definition is as follows. Funny enough one needs not to specify the FILTER at all ... ok, one learns something new every day: LAYER EXTENT -180 -90 180 90 CONNECTIONTYPE POSTGIS NAME BRO_V32_TIMED PROCESSING CLOSE_CONNECTION=DEFER OPACITY 60 STATUS ON DUMP TRUE METADATA wfs_title bro_v32_timed wfs_maxfeatures 10 gml_featureid ID ## REQUIRED gml_include_items all ## Optional (serves all attributes for layer) gml_geometries rechteck gml_rechteck_type polygon END PROJECTION init=epsg:4326 END CONNECTION user={BF961C25A57BA226} password={C9748CA35D48D049} dbname={6B40E65B12B92106} host=localhost DATA rechteck from bro_v32_timed using srid=-1 using unique datum TYPE POLYGON SIZEUNITS meters CLASS NAME bro_v32_timed_total_class STYLE OUTLINECOLOR 0 0 0 COLOR [farbe] END END END # Layer ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Versioned queries arcSDE
Hy all I would like to ask for help . How can i do versioned queries? I have an Oracle database with SDE on it.Can someone post some example mapfile or code or just a discusson about the question?:) Thanks, bye ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Google Mercator and +nadgri...@null
UPDATE: we managed to reproject in google mercator the map on OpenLayers with this code: http://www.copypastecode.com/24724 It looks ok but when I added a transparent Google Maps layer, our geometries are shifted south by about 30km. Any idea of what might cause this issue? BTW, we didn't manage to reproject the geometries directly on MapServer, that kept crashing or generating latlon tiles. Cheers, Mulone - Mulone PhD student -- View this message in context: http://n2.nabble.com/MapServer-OpenStreetMap-OpenLayers-Reprojection-from-Latlong-to-Mercator-a-real-nightmare-tp4753197p4762619.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] Versioned queries arcSDE
Not sure what you mean by versioned queries. You can do MapServer queries against a versioned SDE database. I'm doing so against SDE 9.3 backed by Oracle. I don't have access to our ESRI environment at the moment but I let you know how I mapped connection settings in ArcCatalog to MapServer CONNECTION/DATA settings first thing next week if that would help... Steve From: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] On Behalf Of Medve Zsolt [medvez...@gmail.com] Sent: Friday, March 19, 2010 4:39 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Versioned queries arcSDE Hy all I would like to ask for help . How can i do versioned queries? I have an Oracle database with SDE on it.Can someone post some example mapfile or code or just a discusson about the question?:) Thanks, bye ___ 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
Re: [mapserver-users] Versioned queries arcSDE
Medve Zsolt wrote: Hy all I would like to ask for help . How can i do versioned queries? I have an Oracle database with SDE on it.Can someone post some example mapfile or code or just a discusson about the question?:) I've never done versioned queries, but noticed mention of it in the DATA string as the last parameter. http://mapserver.org/input/vector/arcsde.html SDE.DEFAULT - As of MapServer 4.2, you can query against a specific version of the layer. SDE supports multi-user editing with versions. If a layer has been Registered with the GeoDatabase and Registered as Versioned (ArcGIS terms), MapServer can query against specified versions of those edits. If not specified, SDE.DEFAULT will be used for all queries. Thanks, bye ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Russell McOrmond, Internet Consultant: http://www.flora.ca/ Please help us tell the Canadian Parliament to protect our property rights as owners of Information Technology. Sign the petition! http://www.digital-copyright.ca/petition/ict/ The government, lobbied by legacy copyright holders and hardware manufacturers, can pry my camcorder, computer, home theatre, or portable media player from my cold dead hands! ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] getting Feature Info data directly from .shp files
Dear Friends, I want to get the Feature Info data directly from .shp files i.e shape files. Previously I had put all data into the database (postgres) then ran queries on the DB and the data returned is shown in a pop up. But now I want to get all the column information of all the layers by directly firing query on the individual .shp files. How to do it? Pls give me a working example. Thanks for your replies. -- View this message in context: http://n2.nabble.com/getting-Feature-Info-data-directly-from-shp-files-tp4763187p4763187.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] 3D display of data
Kishore, Can you be more specific? Did you mean display of: - contours (isolines of height with labels) - shaded terrain (see GDAL's gdal_dem utility to create) - perspective viewing of terrain (mapserver can't do this) Best Regards, Brent Fraser Kishore Reddy wrote: Hi all, I have built a website which shows geographic data in 2D. The following is the configuration used for the website MapServer Postgresql - Data is stored with accordance with the OpenGeo standards. OpenLayers Php But the website is intended for the rural community. So I thought of displaying the data in 3D using MapServer. So can anyone please give some references? -- Kishore ___ 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
Re: [mapserver-users] Multiples shapefiles, one LAYER
Conociendo más a fondo tu situación, pudiera ser que exista una alternativa si en vez de archivos SHP hicieras uso de bases de datos relacionales como PostgreSQL, MySQL u Oracle. Mi idea consiste en que cada propietario integrara su información en una base de datos, en donde podrían actualizar cuando quisieran. Tú por tu parte, creas una vista en la que unes (JOIN) las diferentes tablas de cada propietario, si y solo si la representación geometrica es la misma. Ya solo generas un archivo MAP con una sola capa haciendo referencia a la vista. Yo en lo personal trabajo con PostgreSQL+PostGIS y ha resultado una excelente opción. Con afán de que conozcas un poco más de mi proyecto y veas si existe alguna relación hasta cierto punto en lo que estás trabajando, te hago llegar el siguiente vínculo: http://www.postgis.org/documentation/casestudies/sitel/ Saludos ! IC Carlos Ruiz From: Carmen Delia Hernández Pérez cdhernan...@tenerife.es To: Carlos Ruiz boolean10...@yahoo.com Sent: Fri, March 19, 2010 2:15:25 AM Subject: RE: [mapserver-users] Multiples shapefiles, one LAYER Hola!! Sí, lo de fusionar los shapefiles en uno previamente es la solución que ya había pensado. En el caso de capas de la misma topología me serviría, lo que quería es ver si no tenía que hacer esa fusión previa y mantener los distintos shp ya que son ficheros que no son creados por mí y así conservo la estructura original que me hacen llegar. Pero bueno, me parece que optaré finalmente por esta opción. Muchas gracias. Saludos. De:Carlos Ruiz [mailto:boolean10...@yahoo.com] Enviado el: jueves, 18 de marzo de 2010 15:52 Para: Carmen Delia Hernández Pérez Asunto: Re: [mapserver-users] Multiples shapefiles, one LAYER Carmen, Es imposible que quieras manejar múltiples archivos SHP y tratarlos como una sola capa. Primeramente, por la representación, tal vez, algunas de las capas se representan con puntos y otras con líneas, por lo que la estructura de la simbología es distinta. Si todas las capas tienen la misma representación y los mismos atributos, por qué no pensar en fusionarlas en un solo archivo SHP ? Saludos desde México IC Carlos Ruiz From:Carmen Delia Hernández Pérez cdhernan...@tenerife.es To: mapserver-users@lists.osgeo.org Sent: Thu, March 18, 2010 9:05: 14 AM Subject: [mapserver-users] Multiples shapefiles, one LAYER Hello!! I need help. I´m using Mapserver and I`ve some shapefiles of the “same region” but I would like only appear as a single layer. I tried with GROUP property but I don´t want it to appear the individual layers. Use TILEINDEX does not help me because they are of the same region. I don´t know if it´s possible to do. For example I´ve some text shapefiles with different styles but I would like they were activated as a single layer. Any solution? Thanks. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] QGIS MapServer Export error
Dear All, I have encountered a problem while trying to export map files from QGIS using MapServer Export plugin. The mapfile that I got back cannot be viewed using shp2img utilities. I got an error saying : msLoadMap(): Regular expression error. MS_DEFAULT_MAPFILE_PATTERN validation failed. msEvalRegex(): Regular expression error. String failed expression test. In addition, when I tried displaying the mapfile obtained from QGIS through openlayers, I got blank gray images. I have also tried removing all the layer info in the mapfile, but still got the same error. However, if I write a mapfile by myself, then the shp2img utility works fine. Is there any problem with the QGIS MapServer Export plugin? Or have I done anything wrong? Thanks in advance! Scarlett _ Hotmail: Trusted email with Microsoft’s powerful SPAM protection. https://signup.live.com/signup.aspx?id=60969___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] 3D display of data
Hi ! - perspective viewing of terrain (mapserver can't do this) I don't totally agree with this. ;) I have been able to use mapserver with WorldWind Java in order to display a raster layer on terrain. And both (raster and terrain) were served by mapserver. What, I think, is not possible (and perhaps what you mean) is to have mapserver render the terrain model given a custom viewpoint and serve the result to openlayers. I think there were some discussion about this some times ago... Regards, Benoît Andrieu Le 19/03/2010 15:28, Brent Fraser a écrit : Kishore, Can you be more specific? Did you mean display of: - contours (isolines of height with labels) - shaded terrain (see GDAL's gdal_dem utility to create) - perspective viewing of terrain (mapserver can't do this) Best Regards, Brent Fraser Kishore Reddy wrote: Hi all, I have built a website which shows geographic data in 2D. The following is the configuration used for the website MapServer Postgresql - Data is stored with accordance with the OpenGeo standards. OpenLayers Php But the website is intended for the rural community. So I thought of displaying the data in 3D using MapServer. So can anyone please give some references? -- Kishore ___ 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Map file xsl transformation and regular expressions
Hi, When I transform my xml map file to a map file, my expressions that contain a regular expression (the same is true for filters) are rendered with double quotes (because the stylesheet has the quote=1 param for those templates). Is there an intended way to achieve this? I know I could modify the stylesheet to not quote those elements and then quote-wrap my value if I need them (in case of string comparison). Thank you! ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Map file xsl transformation and regular expressions
Alexandre, you are right, if the expression is an regular expression, it shouldn't be quoted. I think the only solution would be to add an attribute in the xml schema, that will specify if the expression is an regular expression of not. Something like: expression regex=ON/expression In this case, the xsl transformation would not quote it. I take a note on that and should fix this in the next few days. Thanks for reporting! Alan On March 19, 2010 02:21:45 pm Alexandre Soares wrote: Hi, When I transform my xml map file to a map file, my expressions that contain a regular expression (the same is true for filters) are rendered with double quotes (because the stylesheet has the quote=1 param for those templates). Is there an intended way to achieve this? I know I could modify the stylesheet to not quote those elements and then quote-wrap my value if I need them (in case of string comparison). Thank you! -- Alan Boudreault Mapgears http://www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Map file xsl transformation and regular expressions
The symbol attribute (which does not get quoted by default) causes a problem if the value references a stmbol's name. I think it could also benefit from your fix. Thank you! On Fri, Mar 19, 2010 at 2:49 PM, Alan Boudreault aboudrea...@mapgears.comwrote: Alexandre, you are right, if the expression is an regular expression, it shouldn't be quoted. I think the only solution would be to add an attribute in the xml schema, that will specify if the expression is an regular expression of not. Something like: expression regex=ON/expression In this case, the xsl transformation would not quote it. I take a note on that and should fix this in the next few days. Thanks for reporting! Alan On March 19, 2010 02:21:45 pm Alexandre Soares wrote: Hi, When I transform my xml map file to a map file, my expressions that contain a regular expression (the same is true for filters) are rendered with double quotes (because the stylesheet has the quote=1 param for those templates). Is there an intended way to achieve this? I know I could modify the stylesheet to not quote those elements and then quote-wrap my value if I need them (in case of string comparison). Thank you! -- Alan Boudreault Mapgears http://www.mapgears.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Map file xsl transformation and regular expressions
Alan Boudreault wrote: Alexandre, you are right, if the expression is an regular expression, it shouldn't be quoted. I think the only solution would be to add an attribute in the xml schema, that will specify if the expression is an regular expression of not. Something like: expression regex=ON/expression Since MapServer has three possible types of expressions, would it not be better to use a type attribute with three possible values, e.g. expression type=constant/expression expression type=regex/expression expression type=logical/expression The default would be constant, the only type that needs to be quoted. The logical expressions are enclosed inside (...) and should not be quoted either. Daniel -- Daniel Morissette http://www.mapgears.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] html query templates
I am trying to calculate the sum of several numeric values returned in a query template. Is there a cgi variable for this or a way to distinguish say the first [length] of a line segment returned as apposed to subsequent [length] values returned for the same poly line shape. Eric ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] 3D display of data
Hi ! Then, as Brent said, you should take a look at gdaldem. http://www.gdal.org/gdaldem.html Some pictures : http://research.dmsolutions.ca/?p=350 Regards, Benoît Andrieu Le 19/03/2010 18:13, Kishore Reddy a écrit : What I mean to say, with the given appropriate form of data (DEM or DTM or whatever) we can not do relief shading (perspective viewing of terrain - to be more specific with the defined aspect ratio, slope and direction of light source) using maservers mapengine. So my question is whether I can hook any 3D rendering engines / drivers (designed for the geodatabases) into the mapengine so that relief shading could be accomplished? Hope I am clear now. -- Kishore On Fri, Mar 19, 2010 at 10:25 PM, Benoît Andrieub...@ixsea.com wrote: Hi ! - perspective viewing of terrain (mapserver can't do this) I don't totally agree with this. ;) I have been able to use mapserver with WorldWind Java in order to display a raster layer on terrain. And both (raster and terrain) were served by mapserver. What, I think, is not possible (and perhaps what you mean) is to have mapserver render the terrain model given a custom viewpoint and serve the result to openlayers. I think there were some discussion about this some times ago... Regards, Benoît Andrieu Le 19/03/2010 15:28, Brent Fraser a écrit : Kishore, Can you be more specific? Did you mean display of: - contours (isolines of height with labels) - shaded terrain (see GDAL's gdal_dem utility to create) - perspective viewing of terrain (mapserver can't do this) Best Regards, Brent Fraser Kishore Reddy wrote: Hi all, I have built a website which shows geographic data in 2D. The following is the configuration used for the website MapServer Postgresql - Data is stored with accordance with the OpenGeo standards. OpenLayers Php But the website is intended for the rural community. So I thought of displaying the data in 3D using MapServer. So can anyone please give some references? -- Kishore ___ 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 ___ 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
Re: [mapserver-users] WMS For Open Street Maps for MapServer?
You might want to try to use the GDAL WMS/TMS driverhttp://www.gdal.org/frmt_wms.html, as something like: LAYER DATA frmt_wms_openstreetmap_tms.xml NAME frmt_wms_openstreetmap_tms PROJECTION proj=merc a=6378137 b=6378137 lat_ts=0.0 lon_0=0.0 x_0=0.0 y_0=0 k=1.0 units=m nadgri...@null no_defs END STATUS ON TYPE RASTER UNITS METERS END Along with the following xml file: GDAL_WMS Service name=TMS ServerUrlhttp://tile.openstreetmap.org/${z}/${x}/${y}.png /ServerUrl /Service DataWindow UpperLeftX-20037508.34/UpperLeftX UpperLeftY20037508.34/UpperLeftY LowerRightX20037508.34/LowerRightX LowerRightY-20037508.34/LowerRightY TileLevel18/TileLevel TileCountX1/TileCountX TileCountY1/TileCountY YOrigintop/YOrigin /DataWindow ProjectionEPSG:900913/Projection BlockSizeX256/BlockSizeX BlockSizeY256/BlockSizeY BandsCount3/BandsCount Cache / /GDAL_WMS Best regards, Tamas 2010/3/19 Bill Thoen bth...@gisnet.com Can anyone tell me if there is a WMS server out there (that's working) that serves Open Street Maps data? I've searched and found some old sites that don't seem to be working now, and I found some information that talks about a MapServer solution that involves downloading several helper files and running things through PostGIS, but is it that complicated? Isn't there just a simple WMS server out there I could use to load US streets into a MapServer map or is this not the best way to go about it? I also tried http://services.giub.uni-bonn.de/wms?, with no luck. I couldn't even get capabilities from it. Here's one of the ones I tried. I'll post the code so if anyone sees a problem with it, please let me know? That would be helpful. But as it is, this server also doesn't appear to be working. Both of these were mentioned in search googlits, but there's not a heck of a lot out there about this. LAYER NAME osm GROUP Roads TYPE RASTER METADATA wms_title Open Street Map wms_group_title Roads Highways wms_format image/jpeg wms_srs EPSG:4326 wms_nameosm wms_server_version 1.1.1 wms_transparent true END STATUS ON CONNECTIONTYPE WMS CONNECTION http://data1.vizure.net/server/services/request.php?jname=/wms;http://data1.vizure.net/server/services/request.php?jname=/wms PROJECTION init=epsg:4326 END END TIA, - Bill Thoen -- GISnet - www.gisnet.com 1401 Walnut St., Suite C Boulder, CO 80302 303-786-9961 tel 303-443-4856 fax ___ 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