[mapserver-users] SDE 9.2 - GDAL - UMN Mapserver
Hello everyone! Did one of you ever achieve to get rasterdata from ArcSDE 9.1 or ArcSDE 9.2 by using GDAL (1.5) from the Mapserver (ms4w)? I would like to know how the layer has to look. LAYER DEBUG ON TYPE RASTER NAME testit CONNECTIONTYPE PLUGIN CONNECTION ipadress,port:5151,sde,user,pass PLUGIN C:/ms4w/Apache/specialplugins/msplugin_sde_92.dll DATA DATA_COLOR,FOOTPRINT,SDE.DEFAULT STATUS DEFAULT DEBUG ON PROCESSING BANDS=1,2,3 PROCESSING RASTERCOLUMN=RASTER END Thanks for help! Florian Thuerkow ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] PostGIS data in EPSG:31300 using for Google Maps overlay
Hi list, I have some data in PostGIS I wish to overlay in Google Maps using WMS I'm using the same data in a mapserver application, where EPSG code 31300 is used. Now for overlay in Google Maps, 4326 is required. I have made a copy of my map-file and specified 4326 as projection system.Yet, non of my data is showing up. Do I need to reproject my data for this use ? I thought PostGIS was capable of doing reprojection on the fly ? Can someone with some more experience help me out ? Thanks Steven ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] SDE 9.2 - GDAL - UMN Mapserver
Did one of you ever achieve to get rasterdata from ArcSDE 9.1 or ArcSDE 9.2 by using GDAL (1.5) from the Mapserver (ms4w)? I have not tested this with raster data. (i have no issues connecting with vector data, SDE 9.1, and ms4w 2.2.7 though) -jeff ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] PostGIS data in EPSG:31300 using for Google Maps overlay
--- Steven De Vriendt [EMAIL PROTECTED] wrote: Hi list, I have some data in PostGIS I wish to overlay in Google Maps using WMS I'm using the same data in a mapserver application, where EPSG code 31300 is used. Now for overlay in Google Maps, 4326 is required. I have made a copy of my map-file and specified 4326 as projection system.Yet, non of my data is showing up. Do I need to reproject my data for this use ? I thought PostGIS was capable of doing reprojection on the fly ? Hi Steven, Both mapserver POstGIS can reproject the data on the fly, but they need to be told the input output projections. As your data is all displayed via mapserver, the instructions either way will be in your mapfile. To reproject using PostGIS, edit the SQL command in your data statement which retrieves the PostGIS data. You need to tell PostGIS to return a virtual table to mapserver, and transform the data to the required projection in this. Edit the data line in the layer something like this: DATA new_geom from (select gid, transform(the_geom,4326) as new_geom from table) as mytable using unique gid using srid=4326 To reproject in mapserver, you need to set the main mapfile projection to EPSG:4326, using, in the global header part of the mapfile: UNITS DD PROJECTION init=epsg:4326 END In the METADATA section, you'll need to set the output projection for WMS, eg: METADATA wms_title My WMS Server wms_srs EPSG:4326 END Then in the layer definition, you specify the layer's native projection, so mapserver can reproject from one to the other: LAYER ... PROJECTION init=epsg:31300 END ... END Note that to reproject in PostGIS, Proj.4 support must be compiled into PostGIS, and similarly for mapserver if you do the reprojection there. If you compiled these from source, this is not done by default, you'll need to run configure with the appropriate flag. If you installed from a package, or on Windows, proj support is generally built in. HTH, Brent Wood ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] PostGIS data in EPSG:31300 using for Google Maps overlay
Brent, Very, very usefull info. Thanks. I was just about to reprojecting my data :-) I thought the SRID table was constrained to the geometry and you couldn't change it. Seems like that's why the 'virtual' table is there for. Ok, well, I'll give it a try. Thanks for your input ! Regards, Steven On Tue, Apr 8, 2008 at 7:58 PM, Brent Wood [EMAIL PROTECTED] wrote: --- Steven De Vriendt [EMAIL PROTECTED] wrote: Hi list, I have some data in PostGIS I wish to overlay in Google Maps using WMS I'm using the same data in a mapserver application, where EPSG code 31300 is used. Now for overlay in Google Maps, 4326 is required. I have made a copy of my map-file and specified 4326 as projection system.Yet, non of my data is showing up. Do I need to reproject my data for this use ? I thought PostGIS was capable of doing reprojection on the fly ? Hi Steven, Both mapserver POstGIS can reproject the data on the fly, but they need to be told the input output projections. As your data is all displayed via mapserver, the instructions either way will be in your mapfile. To reproject using PostGIS, edit the SQL command in your data statement which retrieves the PostGIS data. You need to tell PostGIS to return a virtual table to mapserver, and transform the data to the required projection in this. Edit the data line in the layer something like this: DATA new_geom from (select gid, transform(the_geom,4326) as new_geom from table) as mytable using unique gid using srid=4326 To reproject in mapserver, you need to set the main mapfile projection to EPSG:4326, using, in the global header part of the mapfile: UNITS DD PROJECTION init=epsg:4326 END In the METADATA section, you'll need to set the output projection for WMS, eg: METADATA wms_title My WMS Server wms_srs EPSG:4326 END Then in the layer definition, you specify the layer's native projection, so mapserver can reproject from one to the other: LAYER ... PROJECTION init=epsg:31300 END ... END Note that to reproject in PostGIS, Proj.4 support must be compiled into PostGIS, and similarly for mapserver if you do the reprojection there. If you compiled these from source, this is not done by default, you'll need to run configure with the appropriate flag. If you installed from a package, or on Windows, proj support is generally built in. HTH, Brent Wood ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver and Microsoft SQL Server 2008
I thought I'd share my results of my past few weeks work on resolving my problem with the location of the plugin dll I was looking for. I found the dll in a product at http://www.mapdotnet.com (simply installed the demo and copied the dll then uninstalled) And I have just finished importing all my map data in SQL 2008. I reserved the road data for last and noticed a significant decrease in performance as I switched between postgre and sql 2008. And average of 1 or 2 seconds slower than postgre with a max of about 5 or 6 seconds where lots of detail is being displayed on the map. Anyway, as much as I wana tell Bill his program stinks, we will lose the competition if I do ;) so I'm forced to stick with SQL 08 and look for ways to improve performance. (Any links will be greatly appreciated) Cheers Chris ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] using gdalinfo.exe
Hi, I'm currently generating a query from my software to access a MrSid file that I have on my MapServer; here's the link: http://206.183.188.202/cgi-bin/mapserv.exe?map=c:\ms4w\Apache\htdocs\SD\mccook-wms.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetMapLAYERS=NAIP2006STYLES=SRS=EPSG:4269BBOX=611300,4815500,613300,4817500WIDTH=800HEIGHT=800FORMAT=image/jpeg I'd like to be able to generate a URL that will get me the gdalinfo on that file... Here's what doesn't work: http://206.183.188.202/cgi-bin/gdalinfo.exe?c:\ms4w\Apache\htdocs\SD\mccook\mccook2006.sid Could someone point out A.) if I'm barking up the wrong tree completetely, and if not, B.) what does that kind of query/URL need to look like? Many Thanks, Ken S. Elvehjem MapFile: MAP NAME MCCOOK STATUS ON IMAGETYPE JPEG SIZE 600 600 PROJECTION init=epsg:26914 END UNITS METERS #[minx] [miny] [maxx] [maxy] in meters EXTENT 610471 4810318 651740 4859698 #- WEB TEMPLATE SD.html IMAGEPATH C:\ms4w\Apache\htdocs\tmp/ IMAGEURL /tmp/ METADATA wms_title WMS McCOOK wms_onlineresource http://206.183.188.202/cgi-bin/mapserv?; wms_srs EPSG:26914 EPSG:26914 END END #- LAYER NAME NAIP2006 TYPE RASTER STATUS DEFAULT DATA mccook/mccook2006.sid PROJECTION init=epsg:4269 END METADATA wms_title WMS McCOOK wms_onlineresource http://206.183.188.202/cgi-bin/mapserv?; wms_srs EPSG:4269 EPSG:4326 END END END # Map File ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] PostGIS data in EPSG:31300 using for GoogleMaps overlay
Hi, In this: DATA new_geom from (select gid, transform(the_geom,4326) as new_geom from table) as mytable using unique gid using srid=4326 First, (select gid ... is selecting the unique column of your table. Change gid to suit your table. Then using unique gid is referring to what was selected in the inner query. If the query is done in this way you must use the name of your unique column instead of gid also here. Perhaps more clear would be to write (SELECT my_unique_column AS gid,... and using unique gid I am not an experienced PostGIS user, let's hope this information is correct. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: [EMAIL PROTECTED] puolesta: Steven De Vriendt Lähetetty: ti 8.4.2008 23:29 Vastaanottaja: Brent Wood Kopio: mapserver-users@lists.osgeo.org Aihe: Re: [mapserver-users] PostGIS data in EPSG:31300 using for GoogleMaps overlay Brent, Maybe quite a basic question, but I'm not used to define my data syntax as the one you propose. Can you help me out with the gid declaration. I'm quite confused what to fill in for gid Do I leave it like it is and just write gid or doi I have or do I have to define my primary key column (f.i.: tbl_b_cabu_pkey). For both I get an error message, saying either column OID does not exist or column tbl_b_cabu_pkey does not exist. However there are both there... DATA new_geom from (select gid, transform(the_geom,4326) as new_geom from table) as mytable using unique gid using srid=4326 Thanks for helping out ! On Tue, Apr 8, 2008 at 8:25 PM, Steven De Vriendt [EMAIL PROTECTED] wrote: Brent, Very, very usefull info. Thanks. I was just about to reprojecting my data :-) I thought the SRID table was constrained to the geometry and you couldn't change it. Seems like that's why the 'virtual' table is there for. Ok, well, I'll give it a try. Thanks for your input ! Regards, Steven On Tue, Apr 8, 2008 at 7:58 PM, Brent Wood [EMAIL PROTECTED] wrote: --- Steven De Vriendt [EMAIL PROTECTED] wrote: Hi list, I have some data in PostGIS I wish to overlay in Google Maps using WMS I'm using the same data in a mapserver application, where EPSG code 31300 is used. Now for overlay in Google Maps, 4326 is required. I have made a copy of my map-file and specified 4326 as projection system.Yet, non of my data is showing up. Do I need to reproject my data for this use ? I thought PostGIS was capable of doing reprojection on the fly ? Hi Steven, Both mapserver POstGIS can reproject the data on the fly, but they need to be told the input output projections. As your data is all displayed via mapserver, the instructions either way will be in your mapfile. To reproject using PostGIS, edit the SQL command in your data statement which retrieves the PostGIS data. You need to tell PostGIS to return a virtual table to mapserver, and transform the data to the required projection in this. Edit the data line in the layer something like this: DATA new_geom from (select gid, transform(the_geom,4326) as new_geom from table) as mytable using unique gid using srid=4326 To reproject in mapserver, you need to set the main mapfile projection to EPSG:4326, using, in the global header part of the mapfile: UNITS DD PROJECTION init=epsg:4326 END In the METADATA section, you'll need to set the output projection for WMS, eg: METADATA wms_title My WMS Server wms_srs EPSG:4326 END Then in the layer definition, you specify the layer's native projection, so mapserver can reproject from one to the other: LAYER ... PROJECTION init=epsg:31300 END ... END Note that to reproject in PostGIS, Proj.4 support must be compiled into PostGIS, and similarly for mapserver if you do the reprojection there. If you compiled these from source, this is not done by default, you'll need to run configure with the appropriate flag. If you installed from a package, or on Windows, proj support is generally built in. HTH, Brent Wood ___ 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] OSS application to serve file based images
Hello I understand that most experts are saying it is far better not to load images in a database but rather to serve them from a file based system. There are two commercial products that I know of ER Mapper - Image Web Server and ArcGIS Image Server what OSS products provide comparable functionalities. If these are available are there any bench mark studies done and also I would like to integrate such products with ArcGIS Server. -- Sindile Bidla ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapserver 5 and Openlayers 2.5 passing of parameters.
- Original Message - From: Aileen [EMAIL PROTECTED] To: mapserver-users@lists.osgeo.org Sent: Wednesday, April 09, 2008 8:28 AM Subject: Mapserver 5 and Openlayers 2.5 passing of parameters. Hi all, We are currently using the latest release of Mapserver, the 5.0.2 version and Openlayers 2.5 We are having problems with rendering lines and polygons because although it worked for us in Mapserver 4.10, we are told that there's a new syntax for passing values to mapserver. Currently, here's part of the url that we are using to pass to mapserver: map_layer_class_expression=makatimap_layer_class_color=255 0 0. We already have looked at your samples but with no avail. Can you help us with the new syntax? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] using gdalinfo.exe
Ken S. Elvehjem wrote: Hi, I'm currently generating a query from my software to access a MrSid file that I have on my MapServer; here's the link: http://206.183.188.202/cgi-bin/mapserv.exe?map=c:\ms4w\Apache\htdocs\SD\mccook-wms.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetMapLAYERS=NAIP2006STYLES=SRS=EPSG:4269BBOX=611300,4815500,613300,4817500WIDTH=800HEIGHT=800FORMAT=image/jpeg http://206.183.188.202/cgi-bin/mapserv.exe?map=c:\ms4w\Apache\htdocs\SD\mccook-wms.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetMapLAYERS=NAIP2006STYLES=SRS=EPSG:4269BBOX=611300,4815500,613300,4817500WIDTH=800HEIGHT=800FORMAT=image/jpeg I'd like to be able to generate a URL that will get me the gdalinfo on that file... Here's what doesn't work: http://206.183.188.202/cgi-bin/gdalinfo.exe?c:\ms4w\Apache\htdocs\SD\mccook\mccook2006.sid Could someone point out A.) if I'm barking up the wrong tree completetely, and if not, B.) what does that kind of query/URL need to look like? Ken, I'm not aware of anyone doing anything quite like this. gdalinfo isn't setup to be used as a cgi, and doesn't return things html encoded or with a content-type header. And MapServer does not have an equivelent functionality. But, in theory, you could write a little gdalinfo script in php/perl/python that would execute gdalinfo on a passed argument filename and then return the result with a proper Content-type: text/plain header. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| President OSGeo, http://osgeo.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users