I am using Arcmap2SLD it is working fine with Arcmap 9.3 It has some small bugs which can be fixed with search/replace function of a text editor. I shall document these when I have some time :-S It works for vector, not raster styles Regards
George Mu'Ammar Programme Officer Food Security Analysis Service United Nations World Food Programme Tel: +39 06 6513 3087 Fax: +39 06 6513 2817 Mob: +39 346 5841 850 www.wfp.org/food-security www.twitter.com/wfpvam -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: 20 April 2011 08:19 AM To: [email protected] Subject: Geoserver-users Digest, Vol 59, Issue 69 Send Geoserver-users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/geoserver-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of Geoserver-users digest..." Today's Topics: 1. Re: How to maintain ArcMap mxd symbology in geoserver (Radoslaw Panczak) 2. Re: Can we install Geoserver at port less than 1024 ([email protected]) 3. Re: Geoserver with OGC filter not working with inclusive range >= AND <= (andrew walsh) 4. Publishing 1300 orthophotos with geoserver (Robert Buckley) ---------------------------------------------------------------------- Message: 1 Date: Wed, 20 Apr 2011 01:56:00 +0200 From: Radoslaw Panczak <[email protected]> Subject: Re: [Geoserver-users] How to maintain ArcMap mxd symbology in geoserver To: Viola Anne <[email protected]> Cc: "[email protected]" <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" Viola, It's not exactly mxd solution but you might want to have a look at uDig software http://udig.refractions.net/ creating SLD files with it is a breeze.. and hopefully you might get it automated somehow. Best, r On 19 April 2011 22:46, Viola Anne <[email protected]> wrote: > Hi Steve, > Much thanks, appreciate your contribution. So far I have tried 3 ways: > > I have tried the Arcmap2SLD http://www.cadmaps.com/gisblog/?p=75 but I > ran into the error; > *"Could not load file or assembly > 'ESRI.ArcGIS.Framework,Version=9.2.0.1324, Culture=neutral, > PublicKeyToken=8fc3cc631e44ad86' or one of its dependencies." the system > cannot find the file specified.* > * * > So I tried something else which seems to work Arc2Earth > http://help.arc2earth.com/kb/arc2earth-desktop/export-map-symbols-to-styled-layer-descriptor-sld. > I also found out that uDig might come in handy > http://udig.refractions.net/. > > The other option is GeoExt styler extension but am still having problems > with this, its legend panel does not show anything and it works halfway on > internet explorer and not at all on google chrome still trying to figure out > why. > > > > > On Tue, Apr 19, 2011 at 11:04 PM, Steve Way < > [email protected]> wrote: > >> Hi Viola, >> >> I'm afraid the only way is to migrate your MXD styles to an SLD. >> >> The sure fire way to do this is manually, but for complicated styles this >> could take a while. >> >> Some people have created tools - I've not used these but would be a good >> starting point. The thing to remember is that GeoServer has some great >> VendorOptions which enhance the cartographic quality of the maps, so try the >> tools, verify the styles then using the vendoroptions tweak the SLD to >> improve the mpa quality. Here is something I got from a quick goolge: >> >> http://www.cadmaps.com/gisblog/?p=75 >> >> Cheers, >> Steve >> >> ________________________________________ >> From: Viola Anne [[email protected]] >> Sent: 19 April 2011 11:00 >> To: [email protected] >> Subject: [Geoserver-users] How to maintain ArcMap mxd symbology in >> geoserver >> >> Hello, >> >> I am a newbie in open source web mapping, I have been using ESRI products >> but a new client has requested to have his web mapping application developed >> using open source namely Geoserver, Openlayers and GeoExt. The client would >> like us to maintain the symbology as it is in the ArcMap mxd. I would >> appreciate any help on how to do this or directions on how to go about it. >> been reading around and understand that I need to declare the symbology in >> SLD for each layer, but this looks a little too much work, any easier way >> out? >> -- >> Kind Regards, >> Viola >> >> >> DISCLAIMER: >> >> This email may contain confidential information and is intended only for >> the use of the specific individual(s) to which it is addressed. If you are >> not the intended recipient of this email, you are hereby notified that any >> unauthorized use, dissemination or copying of this email or the information >> contained in it or attached to it is strictly prohibited. If you received >> this message in error, please immediately notify the sender at Infotech or >> [email protected] and delete the original message. >> > > > > -- > Kind Regards, > Viola > > > > ------------------------------------------------------------------------------ > Benefiting from Server Virtualization: Beyond Initial Workload > Consolidation -- Increasing the use of server virtualization is a top > priority.Virtualization can reduce costs, simplify management, and improve > application availability and disaster protection. Learn more about boosting > the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Wed, 20 Apr 2011 08:40:39 +0800 From: <[email protected]> Subject: Re: [Geoserver-users] Can we install Geoserver at port less than 1024 To: <[email protected]>, <[email protected]> Cc: [email protected] Message-ID: <4e88c091a57493498eec9f2a21d5bf432c9a06b...@exwa-mbx01.nexus.csiro.au> Content-Type: text/plain; charset="iso-8859-1" Common practice it to proxy your JEE application instances out via your load balancer or web server. You can either use direct HTTP or AJP protocols. In house our preference was to use AJP. An apache based example is here: http://tomcat.apache.org/connectors-doc-archive/jk2/proxy.html Regards, Terry -----Original Message----- From: Andrea Aime [mailto:[email protected]] Sent: Tuesday, 19 April 2011 10:29 PM To: Mustafa646 Cc: [email protected] Subject: Re: [Geoserver-users] Can we install Geoserver at port less than 1024 On Tue, Apr 19, 2011 at 4:09 PM, Mustafa646 <[email protected]> wrote: > I want to know, is it possible to install GeoServer at port less than 1024. > My web mapping application is in production environment and user needs to > access the geoserver at port less than 1024. Is it possible to install > Geoserver at any port less than 1024 ? Yes, you have to modify the web container of choice to use the port in question, and also, normally, you have to start it with a user that has the privileges to open a low number port, normally an administrator Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------ Message: 3 Date: Wed, 20 Apr 2011 10:53:55 +1000 From: "andrew walsh" <[email protected]> Subject: Re: [Geoserver-users] Geoserver with OGC filter not working with inclusive range >= AND <= To: <[email protected]> Cc: [email protected] Message-ID: <89DE8DCCD2B64EECAD92B1DBD8036210@awalsh1> Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Hi Rudi, Thanks for you comments, good to know I was not the only one who had these issues -:). My problem (GEOT-3507) arose using the URL-CQL filter and your earlier issue (GEOT-2944) was with the OGC filter but the error is the same, i.e bad sql sent to Oracle. Actually I had same error as you got when I first tried the OGC filter with operator <ogc:PropertyIsGreaterThan> and an the <ogc:Literal>2010-01-03T13:51:01</ogc:Literal>. I then discovered I could work around this error using a filter function [see http://docs.geoserver.org/latest/en/user/filter/function.html and http://docs.geoserver.org/latest/en/user/filter/function_reference.html ] called dateParse(format:String,dateString:String,) like follows: <wfs:GetFeature service="WFS" version="1.1.0" xmlns:test="http://www.metoc.gov.au/test"; xmlns:wfs="http://www.opengis.net/wfs"; xmlns:ogc="http://www.opengis.net/ogc"; xmlns:gml="http://www.opengis.net/gml"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd";> <wfs:Query typeName="test:TEST.BEACH_TEMPS"> <ogc:Filter> <ogc:And> <ogc:PropertyIsEqualTo escapeChar="\" singleChar="_" wildCard="%"> <ogc:PropertyName>test:LOCATION</ogc:PropertyName> <ogc:Literal>Bilgola</ogc:Literal> </ogc:PropertyIsEqualTo> <ogc:PropertyIsGreaterThan> <ogc:PropertyName>test:OBS_DATE_TIME</ogc:PropertyName> <ogc:Function name="dateParse"> <ogc:Literal>yyyy-MM-dd HH:mm:ss</ogc:Literal> <ogc:Literal>2009-12-31 23:59:59</ogc:Literal> </ogc:Function> </ogc:PropertyIsGreaterThan> <ogc:PropertyIsLessThan> <ogc:PropertyName>test:OBS_DATE_TIME</ogc:PropertyName> <ogc:Function name="dateParse"> <ogc:Literal>yyyy-MM-dd HH:mm:ss</ogc:Literal> <ogc:Literal>2011-01-01 00:00:00</ogc:Literal> </ogc:Function> </ogc:PropertyIsLessThan> </ogc:And> </ogc:Filter> </wfs:Query> </wfs:GetFeature> This worked fine and I was able to do 'exclusive' date range queries with the like DATE > X AND DATE < Y using the ogc:PropertyIsGreaterThan and ogc:PropertyIsLessThan. However I then hit a problem using an 'inclusive' range like DATE >= X AND DATE <= Y, this doesn't work. So I have reported this ticket: http://jira.codehaus.org/browse/GEOT-3526 and possibly related issue http://jira.codehaus.org/browse/GEOT-3526 That said, there remains the issue of bad SQL with the CQL filter (GEOT-3507). I would be nice to be able to do the DATE range queries properly in CQL as it offers a very short and convenient URL compared to the OGC filter. The patch and comments you gave in GEOT-2944 are a good start at fixing the CQL/bad SQL issue. I am wondering, since you have some of knowledge of the code workings, (I know very little) which Java class->methods might do the following: 1) Output a DATE field in GML or CSV format (want to know why the random 1/1000 sec + tzone added?) 2) Contructs the to_date( ) part of the query to Oracle (perhaps we could debug this code so we can see the actual SQL to goes to Oracle, we tried to see the SQL through the Oracle system logs but you only see this when there are SQL errors). Andrew ----- Original Message ----- From: "Rudi Hochmeister (JIRA)" <[email protected]> To: <[email protected]> Sent: Tuesday, April 19, 2011 6:05 PM Subject: [jira] Commented: (GEOT-3507) Date comparison with CQL - Bad SQL sent to Oracle > > [ > http://jira.codehaus.org/browse/GEOT-3507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=263907#action_263907 > ] > > Rudi Hochmeister commented on GEOT-3507: > ---------------------------------------- > > Hi, we had the same problem. > http://jira.codehaus.org/browse/GEOT-2944 introduces a patch (it is more like > a dirty hack) for correct Oracle Date to SQL in ArcSDE datastore. > The problem is, that ArcSDE also supports other databases than ORACLE, so I > guess this patch will never make it > into trunk, because it is to ORACLE specific! Maybe you can patch the source > code yourself and give feedback to Gabriel (who does great work with ArcSDE > datastore by the way)! > >> Date comparison with CQL - Bad SQL sent to Oracle >> ------------------------------------------------- >> >> Key: GEOT-3507 >> URL: http://jira.codehaus.org/browse/GEOT-3507 >> Project: GeoTools >> Issue Type: Bug >> Components: data arcsde >> Affects Versions: 2.6.0 >> Environment: Solaris 9, Tomcat 6, Java 1.6.0_17 >> Reporter: Andrew Walsh >> Assignee: Gabriel Rold?n >> >> I am getting some problems using an OGC CQL filter >> on a Oracle DATE type through ARCSDE-Oracle. >> The database table is a view which contains an attribute called OBS_DATE_TIME >> I am using Geoserver 2.0.1 WFS with an ESRI ARCSDE-Oracle 9.3 data store. >> I try a date comparsion using the cql_filter and the 'AFTER' >> operator as follows but this didn't work: >> http://server.metoc.gov.au:8080/geoserver/wfs?request=GetFeature&typeName=TEST:TEST.BEACH_TEMPS&cql_Filter=LOCATION%3D%27Bilgola%27%20AND%20OBS_DATE_TIME%20AFTER%202011-01-01T00:01:00Z&version=1.1.0&outputFormat=csv >> This gave back 0 results and the following error message in the >> geoserver.log: >> 2011-04-11 13:39:31,083 WARN [data.ArcSDEQuery] - Error fetching row for >> TEST.BEACH_TEMPS[ >> Filter: [[ LOCATION = Bilgola ] AND [ OBS_DATE_TIME > Sat Jan 01 00:01:00 EST >> 2011 ]] >> where clause sent: (TEST.BEACH_TEMPS.LOCATION = 'Bilgola' AND >> TEST.BEACH_TEMPS.OBS_DATE_TIME > 'Sat Jan 01 00:01:00 EST 2011') >> geometry filter:Filter.INCLUDE >> org.geotools.arcsde.ArcSdeException: [SDE error -51][Error desc=DATABASE >> LEVEL >> ERROR OCCURRED.][Extended desc= >> ] >> It seems Oracle does not like the SQL sent since a DATE (OBS_DATE_TIME) >> is being compared to a string. The SQL should compare a DATE to a DATE >> by using the to_date() function converting the string to a DATE like: >> WHERE TEST.BEACH_TEMPS.LOCATION = 'Bilgola' AND >> TEST.BEACH_TEMPS.OBS_DATE_TIME > >> to_date('2011-01-01 00:01:00','YYYY-MM-DD HH24:MI:SS')' > > -- > This message is automatically generated by JIRA. > - > If you think it was sent incorrectly contact one of the administrators: > http://jira.codehaus.org/secure/Administrators.jspa > - > For more information on JIRA, see: http://www.atlassian.com/software/jira > > > > > ------------------------------ Message: 4 Date: Wed, 20 Apr 2011 07:18:50 +0100 (BST) From: Robert Buckley <[email protected]> Subject: [Geoserver-users] Publishing 1300 orthophotos with geoserver To: [email protected] Message-ID: <[email protected]> Content-Type: text/plain; charset="iso-8859-1" Hi, There are many threads which explain how to create an imagemosaic or pyramid, but not so many regarding the preparation of the raw data. I have ~1300 orthophotos which have been bought for desktop use in ArcGIS. Resolution (X,Y) = 0,4m, 0,4m columngs/rows = 5003 x 5003 total Area = 2km x 2km (4km?) Format = TIFF Size = ~70mb total size of region: 5000km? I have been asked if I can serve these with geoserver. The alternative seems to be the purchase of ArcServer which is a cop-out in my view! My first problem is the preparation. 1. Transform all photos into wgs84 2. Convert to geoTIFFs and now i?m a bit lost! what are my choices to take this further? 1. Do I have to convert 1300 photos using the gdal_retile and upload them into geoserver? I can?t image having to upload 1300 pyramid stores into geoserver! Any help would be great. Thanks, Robert -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev ------------------------------ _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users End of Geoserver-users Digest, Vol 59, Issue 69 *********************************************** ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
