Link of the Day Lat - Long Finder

Exactly what it says on the tin, find a Latitude and Longitude using a google maps application. It will give you an answer in decimals and degrees and minutes. If you have an address use the search box to the right of the map.

http://www.satsig.net/maps/lat-long-finder.htm

Recommended text editor: NOTEPAD++

My favourite text editor, not much more to say, try it you might like it...

http://notepad-plus.sourceforge.net/uk/site.htm

Here are the features of Notepad++ :

• Syntax Highlighting and Syntax Folding
• WYSIWYG
• User Defined Syntax Highlighting
• Auto-completion
• Multi-Document
• Multi-View
• Regular Expression Search/Replace supported
• Full Drag ‘N' Drop supported
• Dynamic position of Views
• File Status Auto-detection
• Zoom in and zoom out
• Multi-Language environment supported
• Bookmark
• Brace and Indent guideline Highlighting
• Macro recording and playback

2008 Free and Open Source Software for Geospatial (FOSS4G) Conference, September 29 - October 3, Cape Town, South Africa

2008 Free and Open Source Software for Geospatial (FOSS4G) Conference incorporating GISSA 2008, is coming up soon, in September 29 - October 3, Cape Town, South Africa.

Lots of workshops and talks on all things opensource including GeoNetwork, Mapserver, Geoserver, OpenLayers, GRASS PostGIS and many more.

Check out the website from more details...
http://www.foss4g2008.org

The current line up can be viewed here...
http://wiki.osgeo.org/wiki/FOSS4G2008_Workshops_and_Technical_Visits

Monkey Karma

A little more neo-googleography here in its loosest sense. The GISDataMonkey would like to share some good karma and recommend to you all those places that treat me well when I visit, whether its quality or value for money I shall add it to this map. I shall be adding more places from time to as I think of them (or as they earn it)...

View Larger Map

There are restauranrs, cafes, pubs, places to stay and I'm sure I'll be adding things to do too. Leave a comment on either the blog or the map to let me know if you take up any of my recommendations and whether you agree or disagree with me on the service, cheers!

Installing GeoNetwork22 IIS Tomcat and MySQL

Below is a record of how I installed Geonetwork 2.2 on my XP box running off MySQL and served by Tomcat 5.5 and IIS5

Required Files:

Apache Tomcat 5.5.26 .exe file - download here
Tomcat ISAPI Connector 1.2.14 .exe - download here
IIS 5.x
MySQL Server 5.0: The Windows ZIP/Setup.EXE (x86) - downloaded from here
Geonetwork 2.2.0 with JRE1.5 embedded - download here

Configure IIS and Tomcat for GeoNetwork:

If you have not already done so install and configure IIS and the Tomcat connector as described in my previous post Configuring Tomcat 5.5 with IIS 5 on XP. This outlines how I set up IIS to serve Java based applications by passing them on to Tomcat using the Tomcat IIS connector. The reason this is necessary is because GeoNetwork is a Java based application which IIS cannot serve by default.

Once you have successfully configured and tested that the Tomcat Connector is working successfully with IIS it is necessary to configure the Tomcat connector to serve GeoNetwork once it is installed. To do this we have to edit the following files.

In the server.xml found in the Tomcat conf directory (in my install it was C:\apache\tomcat55\conf\server.xml) add the following code at the bottom of the file just before the tag...

<Context
path="/geonetwork"
docBase="C:\geonetwork\web\geonetwork"
crossContext="false"
debug="1"
reloadable="false" />
<Context
path="/intermap"
docBase="C:\geonetwork\web\intermap"
crossContext="false"
debug="1"
reloadable="false" />
<Context
path="/geoserver"
docBase="C:\geonetwork\web\geoserver"
crossContext="false"
debug="1"
reloadable="false" />

then search from the start of the file for port="8080" and replace the text with the text below.

<Connector
port="8080"
maxHttpHeaderSize="8192"
maxThreads="150"
minSpareThreads="25"
maxSpareThreads="75"
enableLookups="false"
redirectPort="8443"
acceptCount="100"
connectionTimeout="20000"
disableUploadTime="true"
URIEncoding="UTF-8"/>

Save and close the file.

Then open the uriworkermap.properties file (which is found in the same directory as the file above) with a text editor and add the following before the line /servlets-examples/*=wlb:

/geonetwork/*=wlb
/geoserver/*=wlb
/intermap/*=wlb

Save and close the file.

Restart the Tomcat windows service: Control panel>administration tools>services - look for and select the service called Apache Tomcat and select restart.

Then restart IIS: Control panel>administration tools>Internet Information Services. Then right click on the local computer entry, select all tasks and restart IIS.

Install and configure MySQL:

Download the MySQL file from the required files section above and install a default installation accepting the default settings. Remember to make a note of the password for future reference.

Once installed run a command window and type:
mysql –u root –p
press enter and enter the password. Then type:
create database geonetwork character set utf8 collate utf8_unicode_ci;
In order to see if the database is created successfully using the utf-8 character set type:
show create database geonetwork;
Then type:
grant select, insert, update, delete, drop, alter, index, create on table geonetwork.* to geonetwork@’localhost’ identified by ‘password’;
Then type”
exit;
to close the command window.

Installing Geonetwork 2.2.x:

Download the GeoNetwork 2.2.0 windows installer file with JRE1.5

Install geonetwork accepting default values. Though I installed to C:\geonetwork rather than the program files directory.

Ensure your tomcat service is switched off : Start>control panel>administration tools>services>apache tomcat stop service.

Check Geonetwork is installed directory by starting the inbuilt Jetty server from Start>programs>GeoNetwork Opensource>start server. Then open GeoNetwork from http://localhost:8080/geonetwork/

If it works correctly stop the server: Start>programs>GeoNetwork Opensource>stop server.

Configuring GeoNetwork to run with MySQL:

Now we are going to link it mySQL. Open GAST: Start>programs>GeoNetwork Opensource>start GAST. Then from the options drop down select config and enter the admin username and password then press OK (default is user: admin pw: admin)

Then from DBNS setup select MySQL and enter the following:

Server: localhost (if MySQL is on same server as Geonetwork)
Database: geonetwork
Username: geonetwork
Password: password (or the password used in the MySQL command entered above identified by ‘password’;).

Then click save.

Go to Database set up, and press set up (ignore the Cyclic error if it appears press OK).

Close GAST.

Start up the Tomcat service: Start>control panel>administration tools>services>apache tomcat start service. Then restart IIS: Control panel>administration tools>Internet Information Services. Then right click on the local computer entry, select all tasks and restart IIS.

Then open GeoNetwork here Then open GeoNetwork from http://localhost/geonetwork/ Your GeoNetwork is now served by Tomcat via IIS (notice the address is now localhost not localhost:8080). With the GeoNetwork Data is served by MySQL.

Congratulations!

Resources:

GeoNetwork OpenSource Website
GeoNetwork installation: Presentation by Andrea Carboni
Geonetwork Catalog installation tutorial using Tomcat & MySQL by Dimitrios G. Simos
Installing Geonetwork21 under IIS, Tomcat and PGSQL by Michel Le page

Configuring Tomcat 5.5 with IIS 5 on XP

I recently set this webserver configuration up because I wanted to run GeoNetwork-Opensource alongside my other websites on IIS default port 80 rather than the GeoNetwork default port 8080. Since IIS can't serve up Java code it is necessary to use Apache Tomcat in conjunction with IIS to successfully serve GeoNetwork and other Java based applications.

*Disclaimer: I am not a Tomcat guru, I am just passing on to you what worked for me, after a couple of wasted days of searching!*

Required Files:

Apache Tomcat 5.5.26 .exe file - download here
Tomcat ISAPI Connector 1.2.14 .exe - download here
IIS 5.x - (see installation instructions below)

Installing IIS:

IIS was already installed on my machine, but for the sake of completeness...

1. Open control panel from your start menu and select (double click) Add/remove programs.
2. From the buttons on the left handside of the Add/remove programs window select Add/remove Windows Components.
3. Select/tick Internet Information Services (IIS) then press the next button.
4. Then press finish and IIS is now installed.
5. Check IIS has successfully installed by going to http://localhost in your browser. If it has successfully worked you should see redirected to localstart.asp and see a page which informs you that your web service is now running.

Installing Tomcat 5.5:

This installer sets up Tomcat 5.5 as a windows service...

1. Save the Tomcat-5.5.26.exe to your hard drive then double click on it to start the installer.
2. I followed the default installation, with the exception of installing it to C:\apache\Tomcat55 simply to remove any danger of spaces causing a problem in the directory structure at a later date.
3. Also remember to take a note of your admin password. Otherwise you will have problems at a later stage!
4. Once installation is complete click OK to start Tomcat as a service.
5. To check on a sccessful installation navigate to http://localhost:8080 in your browser. If it works you will see an Apache Tomcat default page informing you that " If you're seeing this page via a web browser, it means you've setup Tomcat successfully. Congratulations!"
6. To check that Tomcat is successfully serving Java servlets and JSPs click the links to the JSP-Examples and Servlet Examples on the Tomcat default page, then execute some of the available examples.

Installing the Tomcat/IIS ISAPI Connector:

Currently if all has gone well you have IIS web server running (on its default port 80 which means you don't have to specify the port in your url ie. http://localhost ), IIS can't support Java applications. You also have Tomcat web server running on port 8080 which you do have to specify in your url - http://localhost:8080, but it can support Java applications.

The next stage is to set up an ISAPI conector so that IIS will serve up your web pages unless it is requested pages including Java servlets or .jsps from certain folders which we have defined. In these cases we want IIS to pass these requests onto Tomcat seamlessly without having to define port 8080 in the url. To do this we need to install Tomcat/IIS ISAPI conector like this...

1. Save the isapi_redirect-1.2.14.exe to your hard drive and double click on it to start the installer.
2. Install it to the same directory as your tomat installation (in my case C:\apache\Tomcat55).
3. The installer automatically copies and installes the relevent files, registry settings needed for the conector. It also creates a virtual directory in IIS called jakarta which is required and also adds the new isapi_redirect.dll as an ISAPI filter for the default website also in IIS. To understand more of what is required to set the ISAPI connector up manually Please check the resources at the end of this article.
4. Once the installation is completed, restart the Tomcat wondows service: Control panel>administration tools>services - look for and select the service called Apache Tomcat and select restart.
5. Then restart IIS: Control panel>administration tools>Internet Information Services. Then right click on the local computer entry, select all tasks and restart IIS.
6. Once both servers have restarted in that order view the JSP-Examples from the tomcat page again. The url should be something like http://localhost:8080/jsp-examples/ the try again removing the ":8080" like this http://localhost/jsp-examples/ - If the installation worked correctly you should be able to successfully view the examples without specifying the port:8080.
7. To learn a little more about adding your own applications/sites to be served via Tomcat and IIS in this way view the Tomcat resources below. Or use my GeoNetwork install as an worked example (will be published shortly)...

*Note the first time I tried to run the JSP-Examples without the :8080 in the url it didn't work. On further investigation I noticed that the ISAPI filter hadn't loaded properly in IIS and was showing a red arrow. To fix this I simply opened IIS, right clicked the default website and selected properties. I clicked on the ISAPI Filters tab. The filter named jakarta showed a red down arrow. I clicked on it and pressed edit. Then re-brwosed to the ISAPI_redirect.dll which is found in my case at C:\apache\Tomcat55\bin\isapi_redirect.dll. I pressed Apply and OK. Then restarted Tomcat and IIS for good measure. The JSP-Examples then worked correctly without the :8080.

Resources:

Apache Tomcat 5.5 Official Documentation Index
Apache Tomcat Connector Official Documentation Index
Apache Tomcat Connector Official IIS How To Documentation
OnJava.com: Configuring Tomcat with IIS Web Server - Easier to read than official docs!