Solr is the popular, blazing fast open source enterprise search platform from the Apache Lucene project. Its major features include powerful full-text search, hit highlighting, faceted search, dynamic clustering, database integration, and rich document (e.g., Word, PDF) handling. Solr is highly scalable, providing distributed search and index replication, and it powers the search and navigation features of many of the world’s largest internet sites.

Solr is written in Java and runs as a standalone full-text search server within a servlet container such as Tomcat. Solr uses the Lucene Java search library at its core for full-text indexing and search, and has REST-like HTTP/XML and JSON APIs that make it easy to use from virtually any programming language. Solr’s powerful external configuration allows it to be tailored to almost any type of application without Java coding, and it has an extensive plugin architecture when more advanced customization is required.

See the complete feature list for more details.

You get the ability to ingest the Solr example data set out of the box so with that comes predefined schema.xml and solrconfig.xml which are the core Solr configuration files. I tested the version from the Apache website but also tested against the distribution found at the Lucid Imagination website and that seems to be a little more comprehensive as far as what is included.

Lucid actually provides a cross platform installer so you do not have to run the ant build mechanism. I like that a lot better .

Anyway, I tried to find an easy way to ingest spatial data without any serious effort and I found that you can easily update a Solr index with little to no effort with a properly formed CSV file. I downloaded one of the Geonames databases and converted it to CSV and voila…in a matter of minutes I had the whole thing ingested and ready to be queried through the Solr web interface.

There are a couple caveats that I would like to share…

1. The CSV must be comma delimited. There are provisions through Solr that will allow you to use different delimiters but none of them work unless there is an actual character in the file (eg a comma or backslash)
2. You must modify the file called schema.xml to reflect the following.
^?View Code XML

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

<field name="geonameid" type="string" indexed="true" stored="true" /> <field name="name" type="text" indexed="true" stored="true" /> <field name="asciiname" type="text" indexed="true" stored="true" /> <field name="alternatenames" type="text" indexed="true" stored="true" /> <field name="latitude" type="string" indexed="true" stored="true" /> <field name="longitude" type="string" indexed="true" stored="true" /> <field name="featureclass" type="text" indexed="true" stored="true" /> <field name="featurecode" type="string" indexed="true" stored="true" /> <field name="countrycode" type="string" indexed="true" stored="true" /> <field name="cc2" type="string" indexed="true" stored="true" /> <field name="admin1code" type="string" indexed="true" stored="true" /> <field name="admin2code" type="string" indexed="true" stored="true" /> <field name="admin3code" type="string" indexed="true" stored="true" /> <field name="admin4code" type="string" indexed="true" stored="true" /> <field name="population" type="string" indexed="true" stored="true" /> <field name="elevation" type="string" indexed="true" stored="true" /> <field name="gtopo30" type="string" indexed="true" stored="true" /> <field name="timezone" type="string" indexed="true" stored="true" /> <field name="modificationdate" type="string" indexed="true" stored="true" />   <uniquekey>geonameid</uniquekey>

3. You can then import the CSV using the following commands. The key is to define the column names using the parameter “fieldnames”.
   

   curl ‘http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=geonameid,name,asciiname,alternatenames,latitude,longitude,featureclass,featurecode,countrycode,cc2,admin1code,admin2code,admin3code,admin4code,population,elevation,gtopo30,timezone,modificationdate&stream.file=/Users/Adam/LucidWorks/cities5000.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8′

   Next, run the “optimize” command.

   curl http://localhost:8983/solr/update -H “Content-Type: text/xml” –data-binary “<optimize />”

4. Now you have an index that can be queried against using the build-in Solr query page (http://localhost:8983/solr/admin). Please read the Solr page on what params to use. A good example query is as follows which shows how to use the “mlt” or MoreLikeThis params.
   

   http://localhost:8983/solr/select/?q=alternatenames%3A%22el+Paso%22&version=2.2&start=0&rows=10&indent=on&mlt=true&mlt.fl=name&mlt.mindf=1&mlt.mintf=1&wt=json

There are quite a bit of things you can do once you get the data in the index. You can perform many different kinds of standard searches, faceted searches, MoreLikeThis, etc… For Geospatial data, we will have to extend the queryresponder classes to return KML rather than standard XML, JSON or CSV. More on that later…

Enjoy!

More from Adam Estrada

• WordPress as a CMS
• Customizing config.xml in the ESRI FlexViewer
• Oracle Spatial and USER_SDO_GEOM_METADATA
• SpatiaLite and Smart Phones
• How to copy music from your iPod to your iPhone

Adam Estrada Recommends

• Generic Host Process for Win32 Services and internet stops  (MtaraM)
• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• How To Upload Videos From Your Iphone Using PixelPipe, PPVideoEnabler, and Cyrecorder 2010  (tretre)

MapProxy can perform a wide variety of other services that will help to ensure that the WMS that is produced is fully optimized to meet your needs.

MapProxy can:

* accelerate existing WMS
* reproject to other SRS (i.e. cache in EPSG:4326, requests in EPSG:31467)
* combine individual map layers from different WMS services
* hide the origin WMS servers
* fill caches dynamic, in advance or both
* add watermarks and/or attributions to all responses

Some of the features of the new release (from the Mailing List):

* There is a new seed tool that is far more advanced than existing tools.
See below for more information.

* There is a new link_single_color_images option for layers. If enabled
MapProxy will not store tiles that only contain a single color as a
separate file. With the new option MapProxy stores these tiles only
once and uses links to this file for every occurrence. This can reduce
the size of your tile cache if you have larger areas with no data
(e.g. water areas, areas with no roads, etc.). This feature is only
available on Unix since Windows has no support for symbolic links.

* We have added some performance improvements for servers with multiple
layers and layers with smaller BBOXs.

* You can configure you own proj4 definition files. For example, if you
need to tweak some projection parameters.

More information about the new seeding tool:

* Fine control of the seeding area. You are not restricted to BBOX
anymore and can now load polygons that define the area you want to
seed. You can load the geometries from text files (WKT) and any data
source that is supported by OGR (Shapefile, PostGIS, etc.). This can
reduce the number of tiles to seed dramatically.
See http://mapproxy.org/docs/0.8.3.dev-20100430/seed.html#geographical-extend

* Uses multiple processes for the whole seeding chain (request images,
split, process, encode and store tiles) for better performance on
multi-core systems. A new –concurrency option lets you define the
number of processes.

* New sophisticated seeding strategy. The existing tools (MapProxy,
TileCache, GeoWebCache) seed from top level to bottom level, from
north to south, from east to west. This simple strategy works against
the caches of your operating system and database and results in
unneeded IO load and thus slower seeding performance. If you have
large datasets your database will have to drop cached data when your
seeding area moves to the south. When one level is seeded and the
seeding tool starts in the north of the next level all data cached by
you database and operating system is gone and needs to be loaded from
hard disk again.

This is another fine example of a project that far exceeds the needs of the community who uses it! Thanks Guys…

More from Adam Estrada

• WordPress as a CMS
• Drupal vs. Wordpress for Geo
• How to copy music from your iPod to your iPhone
• Customizing config.xml in the ESRI FlexViewer
• Open Street Map (take 1)

Adam Estrada Recommends

• Top Free Useful Cydia applications for your IPhone  (tretre)
• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• Jailbreaking and unlocking your iphone for T-mobile  (tretre)

http://finder.geocommons.com/search.kml?query=Haiti&limit=100&bbox=-72.725,17.993,-71.715,19.049

You have to parse the KML to get to the page that holds the data set. Then you have to convert the ‘.html’ extension to ‘.zip’. Wget can then be employed to do the actual downloading from the parsed KML. You can also recursively search through the directory and unzip the all the ZIP files but I have not got that far yet…

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

#!/usr/bin/python
'''
Created on May 17, 2010
 
@author: adamestrada
'''
import sys, os
import urllib, urllib2
from xml.dom import minidom
from optparse import OptionParser
 
#URL = 'http://finder.geocommons.com/search.kml?query=Haiti&limit=100&bbox=-72.725,17.993,-71.715,19.049'
FINDER_URL = 'http://finder.geocommons.com/search.kml'
 
class getGeocommons:
# =============================================================================
# Parse Command Line Args
# =============================================================================
    def main(self, object):
        try:
            if object is not None:
                parser = OptionParser(usage="%prog [-q] [-l] [-b]", version="%prog 1.0")
                parser.add_option("-q", "--query", help="Enter a query term (eg. Haiti)")
                parser.add_option("-l", "--limit", help="Record limit is set to > 1 (eg. 100)")
                parser.add_option("-b", "--bbox", help="Enter the Query Extent (eg. -74.049,17.841,-71.874,20.052")
                if object == -1:
                    print parser.print_help()
                    sys.exit(0)
            #print parser.parse_args()
            getGeocommons().buildURL()
        except:
            print parser.print_help()
 
# =============================================================================
# Build URL with appropriate querystring params.
# =============================================================================
    def buildURL(self):
        try:
            # ghetto makin it work!
            query = sys.argv[2]
            limit = sys.argv[4]
            bbox = sys.argv[6]
 
            # Build query string
            params = {}
            params['query'] = query
            params['limit'] = limit
            params['bbox']  = bbox
            urlParams = urllib.urlencode(params)
            url = FINDER_URL
            full_url = url + '?' + urlParams
            print full_url
            getGeocommons().parseKML(full_url)
        except:
            print 'Something happend when building your querystring!'
 
# =============================================================================
# Get KML from Finder, parse it, then download ZIP files...
# =============================================================================
    def parseKML(self, full_url):
        params = full_url
        try:
            request = urllib2.urlopen(params).read()
            xml = minidom.parseString(request)
 
            for node in xml.getElementsByTagName('atom:link'):
                getString = str(node.toxml())
                subString = getString[getString.find('href')+5:getString.find('rel')]
                files = subString.replace('html', 'zip').replace('\"', '')
                # Use Wget to download the files.
                # Download wget here: http://www.gnu.org/software/wget/
                os.system('wget -r -nd -A zip -P Files ' + files)
 
        except urllib2.HTTPError, e:
            print "Cannot retrieve URL: HTTP Error Code", e.code
        except urllib2.URLError, e:
            print "Cannot retrieve URL: " + e.reason[1]
 
# =============================================================================
# Program mainline.
# =============================================================================
if __name__ == '__main__':
    if not sys.argv[1:]:
        getGeocommons().main(-1)
        sys.exit(0)
    else:
        params = sys.argv[1:]
        getGeocommons().main(params)

python getfiles.py -q Haiti -l 100 -b -72.725,17.993,-71.715,19.049

This script will download all the .zip files associated to you query to a directory called “Files”. Enjoy!

More from Adam Estrada

• WordPress as a CMS
• Customizing config.xml in the ESRI FlexViewer
• GmapEZ
• More on ESRI Flex and Config.xml
• Oracle Spatial and USER_SDO_GEOM_METADATA

Adam Estrada Recommends

• Generic Host Process for Win32 Services and internet stops  (MtaraM)
• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• FIXED Generic Host Process for Win32 Services has encountered a problem........  (MtaraM)

1. Download Nutch and build it. For this you will need Ant installed and configured properly.

adam:nutch-1.0 adamestrada$ ant

This will automatically detect the build.xml that manages the build process.

2. Test to see if Nutch is properly installed

You may have to set your JAVA_HOME environment variable if it’s not already set.

JAVA_HOME=/Library/Java/Home
export JAVA_HOME

Now JAVA_HOME should be set and you are ready to move forward…

adam:nutch-1.0 adamestrada$ bin/nutch
Usage: nutch [-core] COMMAND
where COMMAND is one of:
crawl one-step crawler for intranets
readdb read / dump crawl db
convdb convert crawl db from pre-0.9 format
mergedb merge crawldb-s, with optional filtering
readlinkdb read / dump link db
inject inject new urls into the database
generate generate new segments to fetch from crawl db
freegen generate new segments to fetch from text files
fetch fetch a segment’s pages
parse parse a segment’s pages
readseg read / dump segment data
mergesegs merge several segments, with optional filtering and slicing
updatedb update crawl db from segments after fetching
invertlinks create a linkdb from parsed segments
mergelinkdb merge linkdb-s, with optional filtering
index run the indexer on parsed segments and linkdb
solrindex run the solr indexer on parsed segments and linkdb
merge merge several segment indexes
dedup remove duplicates from a set of segment indexes
solrdedup remove duplicates from solr
plugin load a plugin and run one of its classes main()
server run a search server
or
CLASSNAME run the class named CLASSNAME
Most commands print help when invoked w/o parameters.

Expert: -core option is for developers only. It avoids building the job jar,
instead it simply includes classes compiled with ant compile-core.
NOTE: this works only for jobs executed in ‘local’ mode

3. We now have to create a directory called “urls” and a flat file that will hold all the URL’s that we are going to crawl.

This is simple…Just create a file called “nutch” call add a single url to it.

I added http://www.thegisforum.com to mine…

4. Now we need to modify the file located at conf/crawl-urlfilter.txt.
^?View Code DOS

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

# Licensed to the Apache Software Foundation (ASF) under one or more # contributor license agreements. See the NOTICE file distributed with # this work for additional information regarding copyright ownership. # The ASF licenses this file to You under the Apache License, Version 2.0 # (the "License"); you may not use this file except in compliance with # the License. You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License.   # The url filter file used by the crawl command.   # Better for intranet crawling. # Be sure to change MY.DOMAIN.NAME to your domain name.   # Each non-comment, non-blank line contains a regular expression # prefixed by '+' or '-'. The first matching pattern in the file # determines whether a URL is included or ignored. If no pattern # matches, the URL is ignored.   # skip file:, ftp:, & mailto: urls -^(file|ftp|mailto):   # skip image and other suffixes we can't yet parse -\.(gif|GIF|jpg|JPG|png|PNG|ico|ICO|css|sit|eps|wmf|mpg|xls|gz|rpm|tgz|mov|MOV|exe|jpeg|JPEG|bmp|BMP)$   # skip URLs containing certain characters as probable queries, etc. #-[?*!@=] -[*!]   # skip URLs with slash-delimited segment that repeats 3+ times, to break loops -.*(/[^/]+)/[^/]+\1/[^/]+\1/   # accept hosts in MY.DOMAIN.NAME +^http://([a-z0-9]*\.)*thegisforum.com/   # skip everything else -.

5. Now set a few properties in conf/nutch-sites.xml
^?View Code XML

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52

< ?xml version="1.0"?> < ?xml-stylesheet type="text/xsl" href="configuration.xsl"?>   <!-- Put site-specific property overrides in this file. -->   <configuration> <property> <name>http.agent.name</name> <value>awe</value> <description>HTTP 'User-Agent' request header. MUST NOT be empty - please set this to a single word uniquely related to your organization.   NOTE: You should also check other related properties:   http.robots.agents http.agent.description http.agent.url http.agent.email http.agent.version   and set their values appropriately.   </description> </property>   <property> <name>http.agent.description</name> <value>Adam's Awesome Bot!!!</value> <description>Further description of our bot- this text is used in the User-Agent header. It appears in parenthesis after the agent name. </description> </property>   <property> <name>http.agent.url</name> <value>http://www.adamestrada.com</value> <description>A URL to advertise in the User-Agent header. This will appear in parenthesis after the agent name. Custom dictates that this should be a URL of a page explaining the purpose and behavior of this crawler. </description> </property>   <property> <name>http.agent.email</name> <value>estrada.adam@gmail.com</value> <description>An email address to advertise in the HTTP 'From' request header and User-Agent header. A good practice is to mangle this address (e.g. 'info at example dot com') to avoid spamming. </description> </property> </configuration>

6. You’re ready to start crawling now!

adam:nutch-1.0 adamestrada$ bin/nutch crawl urls -depth 5 -topN 100

There are many many more options to choose from with Nutch so I may explore them in future posts. Enjoy…

More from Adam Estrada

• WordPress as a CMS
• Open Street Map (take 1)
• Oracle Spatial and USER_SDO_GEOM_METADATA
• Customizing config.xml in the ESRI FlexViewer
• SpatiaLite and Smart Phones

Adam Estrada Recommends

• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• How To Upload Videos From Your Iphone Using PixelPipe, PPVideoEnabler, and Cyrecorder 2010  (tretre)
• Routing with the new Google Maps Data  (Maploser)

osm2pgsql -c -d OSM -l -s -S “C:\Program Files (x86)\osm2pgsql\default.style” -U postgres -W -H localhost C:\Workspace\OSM\planet100324.osm.bz2 -v
osm2pgsql SVN version 0.66-16423M

Password:
Using projection SRS 4326 (Latlong)
Setting up table: planet_osm_point
Setting up table: planet_osm_line
Setting up table: planet_osm_polygon
Setting up table: planet_osm_roads
Mid: pgsql, scale=10000000, cache=800MB, maxblocks=102401*8192
Setting up table: planet_osm_nodes
*** WARNING: intarray contrib module not installed
*** The resulting database will not be usable for applying diffs.
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “planet_osm_nodes_pkey” for table “planet_osm_nodes”
Setting up table: planet_osm_ways
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “planet_osm_ways_pkey” for table “planet_osm_ways”
Setting up table: planet_osm_rels
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index “planet_osm_rels_pkey” for table “planet_osm_rels”

Reading in file: C:\Workspace\OSM\planet-100324.osm.bz2
Processing: Node(574797k) Way(43465k) Relation(465k)
Node stats: total(574797076), max(673005476)
Way stats: total(43465572), max(53189409)
Relation stats: total(465800), max(533629)

Going over pending ways
processing way (12176k)

Going over pending relations

node cache: stored: 104772187(18.23%), storage efficiency: 99.92%, hit rate: 17.57%
Stopping table: planet_osm_nodes
Stopped table: planet_osm_nodes
Stopping table: planet_osm_ways
Stopped table: planet_osm_ways
Stopping table: planet_osm_rels
Stopped table: planet_osm_rels
Committing transaction for planet_osm_point
Sorting data and creating indexes for planet_osm_point
Completed planet_osm_point
Committing transaction for planet_osm_line
Sorting data and creating indexes for planet_osm_line
Completed planet_osm_line
Committing transaction for planet_osm_polygon
Sorting data and creating indexes for planet_osm_polygon
Completed planet_osm_polygon
Committing transaction for planet_osm_roads
Sorting data and creating indexes for planet_osm_roads
Completed planet_osm_roads

More from Adam Estrada

• WordPress as a CMS
• Open Street Map (take 1)
• Oracle Spatial and USER_SDO_GEOM_METADATA
• GmapEZ
• FOSS4Geo Software

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Routing with the new Google Maps Data  (Maploser)
• Layar for the iPhone  (Maploser)

WordPress:

It doesn’t get any easier than WordPress! With the stack installer, you can literally be up and running in a matter of minutes. The thing I like the most about WordPress is that there are

• 8,516 Free Plugins
• 1,136 Free Themes

Wow! To top it all off, you simply have to search for the plugin or theme want (inside of the WP Admin Panel) and then click on an “Install” button to add it to your instance. Bang! Done! End of story…Well, there are always some configuration options but that depends on what you install.

Again, WordPress is great if you want to blog or set up a huge social network ala BuddyPress and WordPress MU. You can set up advanced user roles using Capability Manager and then use those roles to provide restricted access to parts of your site via User Access Manager. Of course there are many more ways to do this, but I’ve used these and they appear to really work well.

Now, what if you want to add custom data and then retriee it from your blog? Hmmm…Yes you can do this by either extending your user profile or maybe by generating custom fields for a form on your site. Getting the data back out is the hard part and honestly, I really don’t know of a plugin to do this. (Insert Help Here!!!)

There are a ton of cool Geospatial Plugins too which is always something I tend to gravitate to first. Here are a couple that really caught my attention.

• WP Geo – This one is really cool but limited in what it can do. If you want to geocode your blog post and add GeoRSS to your blog, this is the plugin for you.
• Visitor Maps – This plugin sniffs out the IP Address of your site visitors and then uses an internal database to geocode (approximately of course) and then plot them out on a map that you can monitor in your administration panel.
• Of course…if you are serious about getting your info out there, make sure to install All in one SEO Pack.

So that’s WordPress. You can see that you can publish basic information and extend the look and feel of the site with themes and plugins. There are a lot of plugins out there to choose from but the bottom line is that WordPress is EASY!

Drupal:

At first glimpse, Drupal is a nightmare to manage and maintain. Actually, that is very true! Drupal has it’s own language and intricacies that take a while to get used to. Luckily, I had @hugoestr there to explain it all and believe me…there was a lot to explain. Like WordPress, there are many plugins (modules in Drupal) and themes to choose from. There certainly are not as many as WordPress but it’s gotta be close. I found a nice site to browse through to find the modules we needed. Check out the Drupal Modules website for a pretty good list of all the modules that the community has submitted.

Drupal too has a Bitnami stack that you can download but we decided to go with the Acquia stack for our solution. Why you ask? Well, the founder of Drupal is heavily involved with Acquia and has created a stack with what appears to be a pretty comprehensive set of included module. Also, for whatever reason…Microsoft seems to support this stack which is very strange to me

OK, so Drupal does everything that WordPress doesn’t. First, Drupal is more of an API or framework than a high-level publishing platform. It’s probably meant more for the develop-type who doesn’t mind getting their hands dirty to learn what is going on. Drupal is based on a series of “nodes” which are actually just pages. There is also a complex but very powerful taxonomy mechanism built in that allows the user to categorize the content.

Searching: The Aquia Stack comes installed with a Lucene API that adds some serious search power to your site. I really like the fact that you can add the “Did you mean” and “More results like this” functionality to you site. It gives it a bit of a Google-esque feel. Solr is installed by default too which will crawl any files attached to a node but setting it up requires that you have a Solr server up and running. There are a handful of other modules out there that will also allow you to search the content in your file attachments too…

CCK and WebForms: Drupal gives you the ability to create your own content types using the Content Construction Kit (CCK). You can create your own forms and extend current ones using the CCK module. Wow! This is awesome! There is even a Web Form module that will let you set up your forms in a wizard-type approach where the pages are related to each other. By using the Conditional Fields module you can add a decision tree to your workflow. Very nice stuff!!!

Views: Once you get your data in to the Drupal data model you will want to get it out, right? Views allow you to create what is literally a view of any content in the database you want. You can return the results in a variety of different formats ranging from whole pages to a simple table.

Now let’s get to the Geo…There are 3 that are a must have

• Location – Location is sort of like the WP Geo WordPress plugin I mentioned earlier only it does a heck of a lot more. With this module you can create your own location content type and add it to nodes across your site. This basically allows you to geocode everything in your site…from the users to the individual nodes.
• GMap – This module works with the other spatially-aware modules on your site by adding the slippy map interface.
• Geo – I have not had a chance to do anything with this one but it looks like the daddy.

The geo module is the next generation geospatial module for Drupal. Like Location, it provides storage for points, but it also supports lines and polygons.

Why is this useful? Because locations are more than addresses or dots on a map. Windmills in a field, for example, don’t have a postal address for geocoding, but still need their coordinates stored and mapped. And data such as routes, city boundaries, or flight patterns all have storage and search requirements that cannot be expressed by simple dots. Fortunately, there is an open standard for expressing this type of data, and Geo takes advantage of spatially enabled databases (PostGIS and MySQL Spatial) for native storage, which leads to faster, more informational queries.

I would love to hear some feedback from anyone who’s used this module. Spatial Queries by default in your CMS? That is very intriguing to me!

Overview:

Both Drupal and WordPress are excellent applications. WordPress is for very entry level users who have something to say while Drupal is a full blown Content Management System. Both have communities full of developers who contribute to making the project better but it looks like WordPress is a bit ahead of the curve. I suspect that it’s because WordPress is Caveman easy and even though the plugins may be complicated to develop, the user footprint is huge which is incentive to develop that most ego-starved programmer can’t pass up. Drupal is not any better or any worse…it’s just different. There is also definitely a learning curve so if you’re familiar with WordPress and want to dive in to Drupal and expect to get it right away, you’re in for a real treat I would love some feedback on this topic so please hit me up if you’ve got the time…

More from Adam Estrada

• WordPress as a CMS
• Customizing config.xml in the ESRI FlexViewer
• Open Street Map (take 1)
• MapProxy Project for Accelerating your WMS
• How to copy music from your iPod to your iPhone

Adam Estrada Recommends

• Top Free Useful Cydia applications for your IPhone  (tretre)
• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• Top Wordpress Plugins/Widgets for traffic and layout  (tretre)

Using GMapEZ

I have been using GMapEZ for a few years now and it continues to impress me by how easy it is to use. The GMapEZ  script completely eliminates the need for any javascript programming which in my opinion is a really good thing. I have used it in the past to add pushpins that are returned form any number of data sources. I like classic ASP so I’ve returned data from an ASP RecordSet or now a days from a .NET DataReader. At any rate, you simply have to read data from the DB and then write out the HTML to represent the structure needed to put pushpins on your map. Here is a C# example of what I am talking about.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84

public partial class Pages_mapPanel : System.Web.UI.UserControl
{
    #region Page Props
 
    public String defaultGmapPage = "http://maps.google.com/maps";
    public String defaultPage = ConfigurationSettings.AppSettings["defaultPage"];
 
    #endregion
 
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            string mapPlaceHolder = this.loadMapData();
            this.ctlPlaceHolder.Controls.Add(new LiteralControl(mapPlaceHolder)); 
        }
        catch (Exception ex)
        {
            throw (ex);
        }
    }
 
    #region loadMapData()
    public String loadMapData()
    {
        try
        {
            OracleConnection conn = new OracleConnection();
            String mainConn = ConfigurationManager.ConnectionStrings["MainConnStr"].ConnectionString;
            conn.ConnectionString = mainConn;
            conn.Open();
            OracleCommand cmd = new OracleCommand();
            cmd.CommandType = CommandType.Text;
 
            String query = "SELECT * FROM MYTABLE ORDER BY DATEIN DESC";
            cmd.CommandText = query;
            cmd.Connection = conn;
 
            cmd.ExecuteReader();
            OracleDataReader dr = cmd.ExecuteReader();
            StringBuilder map = new StringBuilder();
            QueryString qs = new QueryString();
 
            while (dr.Read())
            {
                qs.Add("fid", "ms");
                qs.Add("id", dr["ID"].ToString());
 
                    map.Append("<a id=\"" + dr["ID"].ToString() + "\" href=\"" + defaultGmapPage + "?ll=" + dr["LATITUDE"].ToString() + "," + dr["LONGITUDE"].ToString() + "&amp;t=k&amp;hl=en\">GREEN MINI</a>");
                    map.Append("<div title=\"Event\"><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">");
                    map.Append("<strong>Name:</strong> " + dr["NAME"].ToString() + "<br />");
                    map.Append("<strong>Type:</strong> " + dr["TYPE"].ToString() + "<br />");
                    map.Append("<strong>Description:</strong> " + dr["DESC"].ToString() + "<br />");
                    map.Append("<a href=\"" + defaultPage + qs + "\">Go To Main Page...</a>");
                    map.Append("</font></div>");
                    map.Append("<div title=\"Dates\"><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">");
                    map.Append("<strong>Date In:</strong> " + dr["DATEIN"].ToString() + "<br />");
                    map.Append("<strong>Date Out:</strong> " + dr["DATEOUT"].ToString() + "<br />");
                    map.Append("<a href=\"" + defaultPage + qs + "\">Go To Main Page...</a>");
                    map.Append("</font></div>");
                }
            }
 
            conn.Close();
            return map.ToString();
        }
        catch (Exception ex)
        {
            Zekiah.Logging.LoggingManager.WebApplication.Error("A Fatal Error has occured in the Map Control", ex);
            redirectToFailure();
            return null;
        }
    }
    #endregion
 
	#region Failure Notice 
    private void redirectToFailure()
    {
        QueryString qs = new QueryString();
        qs.Add("fid", "ERROR");
        Response.Redirect(defaultPage + qs, false);
    }    
    #endregion 
}

Please note that I am reading data from an Oracle Database and simply returning it as a properly formatted String in HTML format. Each pushpin also has two tabs which can hold extra data including another URL. For more information on what you can do with GMapEZ, check out the examples on the hosted site. You’ll also note that I used a class written by Bobby ReRosa called “QueryString”. What a freaking time saver this thing is! Thanks Bobby…I actually want to write more on how to use it in another blog post so look for that one too.

More from Adam Estrada

• WordPress as a CMS
• Oracle Spatial and USER_SDO_GEOM_METADATA
• ESRI FlexViewer and Error 1065
• Open Street Map (take 1)
• jQuery tabs view state

Adam Estrada Recommends

• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• Replace IPhone Carrier T-Mobile and AT&T with SKYPE 2010  (tretre)
• Adam – The Indian iPad killer  (MtaraM)

1
2
3
4
5
6
7
8
9

INSERT INTO USER_SDO_GEOM_METADATA
VALUES(
'EVENTS','GEOM',
    MDSYS.SDO_DIM_ARRAY(   
    MDSYS.SDO_DIM_ELEMENT('X', -180, 180, 0.000000005),
    MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, 0.000000005)
     ),
  4326   -- SRID (reserved for future Spatial releases)
);

Once you’ve Inserted that record you can look at it using the following Query:

1
2

 
SELECT * FROM USER_SDO_GEOM_METADATA

The Update query is simple…

1
2
3
4
5
6
7

UPDATE EVENTS S set S.GEOM.SDO_SRID = 4326
 
UPDATE USER_SDO_GEOM_METADATA SET SRID = 4326 WHERE TABLE_NAME='EVENTS'
 
UPDATE USER_SDO_GEOM_METADATA SET DIMINFO = 
MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-180,180,0.000000005),
MDSYS.SDO_DIM_ELEMENT('Y',-90,90,0.000000005)) WHERE TABLE_NAME = 'EVENTS'

If you want to make sure your geometries are valid, you may use Oracle’s ST_IsValid() command.

1
2

 
SELECT s.GEOM.st_isvalid() FROM EVENTS s

Finally, do you want to generate a GEOM column from latitude/longitude fields?

1
2
3
4
5
6

UPDATE EVENTS
SET GEOM = MDSYS.SDO_GEOMETRY(
2001, -- 3-dimensional point or use 2001 for 2-dimensional point
NULL,
MDSYS.SDO_POINT_TYPE(EVENTS.LON, EVENTS.LAT, NULL), -- X,Y,Z
NULL, NULL );

Have fun!

More from Adam Estrada

• SpatiaLite 2.4.0
• Customizing config.xml in the ESRI FlexViewer
• ESRI FlexViewer and Error 1065
• SpatiaLite and Smart Phones
• GeoDC Kickoff…

Adam Estrada Recommends

• Generic Host Process for Win32 Services and internet stops  (MtaraM)
• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• Replace IPhone Carrier T-Mobile and AT&T with SKYPE 2010  (tretre)

For more information on embedding maps from Geocommons in to WordPress, check out this previous post of mine.

More from Adam Estrada

• iPhone Test
• Make a Google Wave…
• Automated web site testing
• jQuery and Prototype Overview
• GeoDC Kickoff…

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Routing with the new Google Maps Data  (Maploser)
• Layar for the iPhone  (Maploser)

Take a look at the following mxml file and note that there are 3 things in particular to note.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139

< ?xml version="1.0" encoding="utf-8"?>
<mx :Application
    xmlns:mx="http://www.adobe.com/2006/mxml"
    xmlns:esri="http://www.esri.com/2008/ags"
    layout="absolute"
    initialize="init()"
    styleName="plain"
    >
  </mx><mx :Script>
    < ![CDATA[
    	import mx.collections.XMLListCollection;
    	import mx.collections.ArrayCollection;
        	import com.esri.ags.Graphic;
        	import com.esri.ags.events.MapMouseEvent;        	
        	import com.esri.ags.geometry.MapPoint;
        	import com.esri.ags.geometry.Extent;
            import com.esri.ags.events.ExtentEvent;
            import mx.rpc.events.FaultEvent;
        	import mx.rpc.events.ResultEvent;
            import mx.controls.Alert;
            import flash.external.*;
            import mx.events.FlexEvent;
            import com.esri.ags.layers.TiledMapServiceLayer;
            import mx.controls.Button;
            import mx.controls.Text;
            import com.esri.ags.layers.ArcGISDynamicMapServiceLayer;
            import mx.rpc.http.HTTPService;
 
            private function initXML():void
        	{
        		var configService:HTTPService = new HTTPService();
        		configService.url = "config.xml";
        		configService.resultFormat = "e4x";
        		configService.addEventListener(ResultEvent.RESULT, configResult);
        		configService.addEventListener(FaultEvent.FAULT, configFault);
        		configService.send();
        	}
 
            private function configResult(event:ResultEvent):void
            {
            	var configXML:XML = event.result as XML;
            	var serviceList:XMLList = configXML..service;
            	for (var i:int = 0; i < serviceList.length(); i++)
            	{
             		var serviceName:String = serviceList[i].name;
            		var serviceURL:String = serviceList[i].url;
            		var serviceAlpha:int = serviceList[i].alpha;
            		var serviceVisible:Boolean = serviceList[i].visible;
            		var serviceLayers:ArrayCollection = new ArrayCollection(serviceList[i].layers.split(","));
 
            		var tLayer:ArcGISDynamicMapServiceLayer = new ArcGISDynamicMapServiceLayer(serviceURL); 
            		tLayer.id = serviceName;
            		tLayer.visible = serviceVisible;
            		tLayer.alpha = serviceAlpha;
            		tLayer.visibleLayers = serviceLayers;
            		myMap.addLayer(tLayer);	
            	}          	
            }
 
            private function configFault(event:FaultEvent):void
            {
            	Alert.show(event.fault.faultString);
            }
 
 
            private function layerShowHandler(event:FlexEvent):void
            {
                // update the LODs/zoomslider to use/show the levels for the selected base map
                var tiledLayer:TiledMapServiceLayer = event.target as TiledMapServiceLayer;
                myMap.lods = tiledLayer.tileInfo.lods;
            }
 
			//add a callback for js to flex communication
			public function init():void
			{
				initXML();
			  if (flash.external.ExternalInterface.available)
			    flash.external.ExternalInterface.addCallback("changeExtent", changeExtent);     
			}
 
			//call from js
			public function changeExtent(sextent:String):void	
			{
				//var avals = sextent.split("|");
				//var ext:Extent = new Extent(new Number(avals[0]),new Number(avals[2]),new Number(avals[1]),new Number(avals[3]));
				//ext.spatialReference = myMap.spatialReference;
				//myMap.extent = ext;
			}
 
            public function onBasemapCreationComplete():void
			{
            	myMap.addEventListener(MouseEvent.CLICK, pushExtentEvent);
            }
 
     		//send extents to html/js
     		public function pushExtentEvent(event:MouseEvent):void           
      	 	{
      	 		if (flash.external.ExternalInterface.available)
			     {
			       const mapPoint:MapPoint = myMap.toMapFromStage(event.stageX, event.stageY);
			       var extent:Array = new Array();
			       flash.external.ExternalInterface.call("displayExtent", mapPoint.y.toFixed(6), mapPoint.x.toFixed(6));
			     }        
      	 	}
      	 	private function onMapClick(event:MapMouseEvent):void
      	 	{    	 		
      	 		myMap.infoWindow.label = "Event Location ";
      	 		myMap.infoWindow.show(event.mapPoint);
      	 	}
        ]]>
    </mx>
    <esri :Map id="myMap" width="100%" height="100%" mapClick="onMapClick(event)" >
      </esri><esri :extent>
        </esri><esri :Extent xmin="-122.2" ymin="24.89" xmax="-70.59" ymax="46.92"  >
          <esri :SpatialReference wkid="4326"/>
        </esri>
 
        <esri :ArcGISTiledMapServiceLayer
            visible="{bb.selectedIndex == 0}"
            show="layerShowHandler(event)"
            url="http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_StreetMap_World_2D/MapServer" 
            creationComplete="onBasemapCreationComplete()" />
        <esri :ArcGISTiledMapServiceLayer
            visible="{bb.selectedIndex == 1}"
            show="layerShowHandler(event)"
            url="http://server.arcgisonline.com/ArcGIS/rest/services/NGS_Topo_US_2D/MapServer" 
            creationComplete="onBasemapCreationComplete()"/>
        <esri :ArcGISTiledMapServiceLayer
            visible="{bb.selectedIndex == 2}"
            show="layerShowHandler(event)"
            url="http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_Imagery_World_2D/MapServer" 
            creationComplete="onBasemapCreationComplete()" />
 
    <mx :ToggleButtonBar id="bb" horizontalGap="2" selectedIndex="0" themeColor="0x00FF00" right="5" top="5">
        </mx><mx :dataProvider>
            </mx><mx :Array>
                </mx><mx :String>Streets</mx>
                <mx :String>Topo</mx>
                <mx :String>Imagery</mx>

First, note the code block that references an external XML file (config.xml). It really doesn’t get any easier than this. What’s really cool about this XML file is that basically, all the web service configuration options from the ArcGIS Service are configured through here. You can traverse through the config.xml file by referencing the node you want in the XMLList or serviceList:XMLList.

var serviceName:String = serviceList[i].name;
var serviceURL:String = serviceList[i].url;
var serviceAlpha:int = serviceList[i].alpha;
var serviceVisible:Boolean = serviceList[i].visible;
var serviceLayers:ArrayCollection = new ArrayCollection(serviceList[i].layers.split(“,”));

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

private function initXML():void
        	{
        		var configService:HTTPService = new HTTPService();
        		configService.url = "config.xml";
        		configService.resultFormat = "e4x";
        		configService.addEventListener(ResultEvent.RESULT, configResult);
        		configService.addEventListener(FaultEvent.FAULT, configFault);
        		configService.send();
        	}
 
            private function configResult(event:ResultEvent):void
            {
            	var configXML:XML = event.result as XML;
            	var serviceList:XMLList = configXML..service;
            	for (var i:int = 0; i < serviceList.length(); i++)
            	{
             		var serviceName:String = serviceList[i].name;
            		var serviceURL:String = serviceList[i].url;
            		var serviceAlpha:int = serviceList[i].alpha;
            		var serviceVisible:Boolean = serviceList[i].visible;
            		var serviceLayers:ArrayCollection = new ArrayCollection(serviceList[i].layers.split(","));
 
            		var tLayer:ArcGISDynamicMapServiceLayer = new ArcGISDynamicMapServiceLayer(serviceURL); 
            		tLayer.id = serviceName;
            		tLayer.visible = serviceVisible;
            		tLayer.alpha = serviceAlpha;
            		tLayer.visibleLayers = serviceLayers;
            		myMap.addLayer(tLayer);	
            	}          	
            }
 
            private function configFault(event:FaultEvent):void
            {
            	Alert.show(event.fault.faultString);
            }

The XML is below: Note the configuration options that you would normally have to set in your compiled code. I just included the service name, url, alpha and visibility in this demonstration. There are many more options to choose from…

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

< ?xml version="1.0"?>
<configuration>
<service>
	<name>
	Service Name
	</name>
	<url>
	http://yoururl.com/yourserver/rest/services/BaseMap/MapServer/
	</url>
	<alpha>
	1.0
	</alpha>
	<visible>
	true
	</visible>
	<layers>
	0,1
	</layers>
</service>
</configuration>

The next thing to take a look at is the fact that there is an Event that grabs the Latitude and Longitude from your map when it's clicked on (MouseEvent.CLICK). Moreover, it passes them to an HTML Input text box in the host page through an ExternalInterface call. The corresponding javascript should resemble the following. Note the < %= this.latitude.ClientID %> and < %= this.longitude.ClientID %> as they are required if you are embedding this in a ASP.NET for C# application.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

<script language="JavaScript" type="text/javascript">
//call flex function changeExtent
function mapextentchange(value)
{
	if(value != ''){
		getFlexApp('FlexMaps').changeExtent(value);
	}	
}
 
//called from flex
function displayExtent(latitude,longitude)
{
	document.getElementById("< %= this.latitude.ClientID %>").value = latitude;
	document.getElementById("< %= this.longitude.ClientID %>").value = longitude;
}
</script>

Finally, I snagged an example off of the ESRI Flex Community page that allowed me to toggle between Streetmap, Topographic Maps and Imagery data. As the selected Index changes, the base map changes...

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

        <esri :ArcGISTiledMapServiceLayer
            visible="{bb.selectedIndex == 0}"
            show="layerShowHandler(event)"
            url="http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_StreetMap_World_2D/MapServer" 
            creationComplete="onBasemapCreationComplete()" />
        <esri :ArcGISTiledMapServiceLayer
            visible="{bb.selectedIndex == 1}"
            show="layerShowHandler(event)"
            url="http://server.arcgisonline.com/ArcGIS/rest/services/NGS_Topo_US_2D/MapServer" 
            creationComplete="onBasemapCreationComplete()"/>
        <esri :ArcGISTiledMapServiceLayer
            visible="{bb.selectedIndex == 2}"
            show="layerShowHandler(event)"
            url="http://server.arcgisonline.com/ArcGIS/rest/services/ESRI_Imagery_World_2D/MapServer" 
            creationComplete="onBasemapCreationComplete()" />
 
    <mx :ToggleButtonBar id="bb" horizontalGap="2" selectedIndex="0" themeColor="0x00FF00" right="5" top="5">
        </mx><mx :dataProvider>
            </mx><mx :Array>
                </mx><mx :String>Streets</mx>
                <mx :String>Topo</mx>
                <mx :String>Imagery</mx>

So, I've had fun playing with this an I've actually been able to use the entire script in a project I was a part of. I hope that someone else gets as much use out of it as I did.

More from Adam Estrada

• Customizing config.xml in the ESRI FlexViewer
• WordPress as a CMS
• GmapEZ
• ESRI FlexViewer and Error 1065
• jQuery tabs view state

Adam Estrada Recommends

• Generic Host Process for Win32 Services and internet stops  (MtaraM)
• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• Update from Google Map on my Problem  (Maploser)

Road Map	libspatialite supporting 3D geometries [XY, XYZ, XYM, XYZM] implementing compressed geometries supporting ST_alias-names for OGC functions supporting SQLite v.3.6.20, and consequently truely enforcing Foreign Key constraints supporting libproj 4.7.0 [lots of new SRIDs added] added SQL functions supporting GreatCircle and Geodesic distance/lenght computation added SQL functions for unit conversions [meter to feet and alike] fixed several SHP related issues supporting 3D shapefiles
	spatialite-tools added a new CLI tool spatialite_osm supporting direct acquisition of road networks from Open Street Map XML/OSM datasets
	librasterlite minor bug-fixing and code cleaning now supporting the MSVC compiler as well Important notice: Alexender Simakov [the Wavelet codec developer] is currently evaluating my proposal to re-release his libepsilon under the LPGL. accordingly to this librasterlite will be re-released under LGPL as soon as possible
	spatialite-gui supporting an interactive Query / View builder tool added the capability to DROP or RENAME columns
	spatialite-gis supporting View-based layers [read-only] supporting VirtualSHP-based layers [read-only] supporting map labeling with optional anti-overlap optimization supporting interactive routing supporting map output generation as: PNG, JPEG, TIFF images PDF documents SVG documents
	Quantum GIS QGis updated data provider released on QGis trunk SVN

I particularly like the fact that it now supports routing using OpenStreetMap! Way cool, Sando!

More from Adam Estrada

• Oracle Spatial and USER_SDO_GEOM_METADATA
• GeoDC Kickoff…
• iPhone Test
• Automated web site testing
• ESRI FlexViewer and Error 1065

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Update from Google Map on my Problem  (Maploser)
• Update to my Google Maps Error Report  (Maploser)

I hope that someone else find this as useful as I did for spot checking large amounts of data…

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752

< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<html>
<head>
<title>Geographic/UTM Coordinate Converter</title>
<style TYPE="text/css">
<!--
TD { text-align: left; }
-->
</style>
<script TYPE="text/javascript">
<!--
var pi = 3.14159265358979;
/* Ellipsoid model constants (actual values here are for WGS84) */
var sm_a = 6378137.0;
var sm_b = 6356752.314;
var sm_EccSquared = 6.69437999013e-03;
var UTMScaleFactor = 0.9996;
 
/*
* DegToRad
*
* Converts degrees to radians.
*
*/
 
function DegToRad (deg)
{
return (deg / 180.0 * pi)
}
/*
* RadToDeg
*
* Converts radians to degrees.
*
*/
 
function RadToDeg (rad)
{
return (rad / pi * 180.0)
}
 
 
/*
* ArcLengthOfMeridian
*
* Computes the ellipsoidal distance from the equator to a point at a
* given latitude.
*
* Reference: Hoffmann-Wellenhof, B., Lichtenegger, H., and Collins, J.,
* GPS: Theory and Practice, 3rd ed. New York: Springer-Verlag Wien, 1994.
*
* Inputs:
* phi - Latitude of the point, in radians.
*
* Globals:
* sm_a - Ellipsoid model major axis.
* sm_b - Ellipsoid model minor axis.
*
* Returns:
* The ellipsoidal distance of the point from the equator, in meters.
*
*/
 
function ArcLengthOfMeridian (phi)
{
var alpha, beta, gamma, delta, epsilon, n;
var result;
 
/* Precalculate n */
n = (sm_a - sm_b) / (sm_a + sm_b);
 
/* Precalculate alpha */
alpha = ((sm_a + sm_b) / 2.0)
* (1.0 + (Math.pow (n, 2.0) / 4.0) + (Math.pow (n, 4.0) / 64.0));
 
/* Precalculate beta */
beta = (-3.0 * n / 2.0) + (9.0 * Math.pow (n, 3.0) / 16.0)
+ (-3.0 * Math.pow (n, 5.0) / 32.0);
 
/* Precalculate gamma */
gamma = (15.0 * Math.pow (n, 2.0) / 16.0)
+ (-15.0 * Math.pow (n, 4.0) / 32.0);
 
/* Precalculate delta */
delta = (-35.0 * Math.pow (n, 3.0) / 48.0)
+ (105.0 * Math.pow (n, 5.0) / 256.0);
 
/* Precalculate epsilon */
epsilon = (315.0 * Math.pow (n, 4.0) / 512.0);
 
/* Now calculate the sum of the series and return */
result = alpha
* (phi + (beta * Math.sin (2.0 * phi))
+ (gamma * Math.sin (4.0 * phi))
+ (delta * Math.sin (6.0 * phi))
+ (epsilon * Math.sin (8.0 * phi)));
 
return result;
 
}
 
/*
* UTMCentralMeridian
*
* Determines the central meridian for the given UTM zone.
*
* Inputs:
* zone - An integer value designating the UTM zone, range [1,60].
*
* Returns:
* The central meridian for the given UTM zone, in radians, or zero
* if the UTM zone parameter is outside the range [1,60].
* Range of the central meridian is the radian equivalent of [-177,+177].
*
*/
 
function UTMCentralMeridian (zone)
{
var cmeridian;
 
cmeridian = DegToRad (-183.0 + (zone * 6.0));
 
return cmeridian;
 
}
 
/*
* FootpointLatitude
*
* Computes the footpoint latitude for use in converting transverse
* Mercator coordinates to ellipsoidal coordinates.
*
* Reference: Hoffmann-Wellenhof, B., Lichtenegger, H., and Collins, J.,
* GPS: Theory and Practice, 3rd ed. New York: Springer-Verlag Wien, 1994.
*
* Inputs:
* y - The UTM northing coordinate, in meters.
*
* Returns:
* The footpoint latitude, in radians.
*
*/
 
function FootpointLatitude (y)
{
var y_, alpha_, beta_, gamma_, delta_, epsilon_, n;
var result;
 
/* Precalculate n (Eq. 10.18) */
n = (sm_a - sm_b) / (sm_a + sm_b);
 
/* Precalculate alpha_ (Eq. 10.22) */
/* (Same as alpha in Eq. 10.17) */
alpha_ = ((sm_a + sm_b) / 2.0)
* (1 + (Math.pow (n, 2.0) / 4) + (Math.pow (n, 4.0) / 64));
 
/* Precalculate y_ (Eq. 10.23) */
y_ = y / alpha_;
 
/* Precalculate beta_ (Eq. 10.22) */
beta_ = (3.0 * n / 2.0) + (-27.0 * Math.pow (n, 3.0) / 32.0)
+ (269.0 * Math.pow (n, 5.0) / 512.0);
 
/* Precalculate gamma_ (Eq. 10.22) */
gamma_ = (21.0 * Math.pow (n, 2.0) / 16.0)
+ (-55.0 * Math.pow (n, 4.0) / 32.0);
 
/* Precalculate delta_ (Eq. 10.22) */
delta_ = (151.0 * Math.pow (n, 3.0) / 96.0)
+ (-417.0 * Math.pow (n, 5.0) / 128.0);
 
/* Precalculate epsilon_ (Eq. 10.22) */
epsilon_ = (1097.0 * Math.pow (n, 4.0) / 512.0);
 
/* Now calculate the sum of the series (Eq. 10.21) */
result = y_ + (beta_ * Math.sin (2.0 * y_))
+ (gamma_ * Math.sin (4.0 * y_))
+ (delta_ * Math.sin (6.0 * y_))
+ (epsilon_ * Math.sin (8.0 * y_));
 
return result;
 
}
 
/*
* MapLatLonToXY
*
* Converts a latitude/longitude pair to x and y coordinates in the
* Transverse Mercator projection. Note that Transverse Mercator is not
* the same as UTM; a scale factor is required to convert between them.
*
* Reference: Hoffmann-Wellenhof, B., Lichtenegger, H., and Collins, J.,
* GPS: Theory and Practice, 3rd ed. New York: Springer-Verlag Wien, 1994.
*
* Inputs:
* phi - Latitude of the point, in radians.
* lambda - Longitude of the point, in radians.
* lambda0 - Longitude of the central meridian to be used, in radians.
*
* Outputs:
* xy - A 2-element array containing the x and y coordinates
* of the computed point.
*
* Returns:
* The function does not return a value.
*
*/
 
function MapLatLonToXY (phi, lambda, lambda0, xy)
{
var N, nu2, ep2, t, t2, l;
var l3coef, l4coef, l5coef, l6coef, l7coef, l8coef;
var tmp;
 
/* Precalculate ep2 */
ep2 = (Math.pow (sm_a, 2.0) - Math.pow (sm_b, 2.0)) / Math.pow (sm_b, 2.0);
 
/* Precalculate nu2 */
nu2 = ep2 * Math.pow (Math.cos (phi), 2.0);
 
/* Precalculate N */
N = Math.pow (sm_a, 2.0) / (sm_b * Math.sqrt (1 + nu2));
 
/* Precalculate t */
t = Math.tan (phi);
t2 = t * t;
tmp = (t2 * t2 * t2) - Math.pow (t, 6.0);
 
/* Precalculate l */
l = lambda - lambda0;
 
/* Precalculate coefficients for l**n in the equations below
so a normal human being can read the expressions for easting
and northing
-- l**1 and l**2 have coefficients of 1.0 */
l3coef = 1.0 - t2 + nu2;
l4coef = 5.0 - t2 + 9 * nu2 + 4.0 * (nu2 * nu2);
 
l5coef = 5.0 - 18.0 * t2 + (t2 * t2) + 14.0 * nu2
- 58.0 * t2 * nu2;
 
l6coef = 61.0 - 58.0 * t2 + (t2 * t2) + 270.0 * nu2
- 330.0 * t2 * nu2;
 
l7coef = 61.0 - 479.0 * t2 + 179.0 * (t2 * t2) - (t2 * t2 * t2);
 
l8coef = 1385.0 - 3111.0 * t2 + 543.0 * (t2 * t2) - (t2 * t2 * t2);
 
/* Calculate easting (x) */
xy[0] = N * Math.cos (phi) * l
+ (N / 6.0 * Math.pow (Math.cos (phi), 3.0) * l3coef * Math.pow (l, 3.0))
+ (N / 120.0 * Math.pow (Math.cos (phi), 5.0) * l5coef * Math.pow (l, 5.0))
+ (N / 5040.0 * Math.pow (Math.cos (phi), 7.0) * l7coef * Math.pow (l, 7.0));
 
/* Calculate northing (y) */
xy[1] = ArcLengthOfMeridian (phi)
+ (t / 2.0 * N * Math.pow (Math.cos (phi), 2.0) * Math.pow (l, 2.0))
+ (t / 24.0 * N * Math.pow (Math.cos (phi), 4.0) * l4coef * Math.pow (l, 4.0))
+ (t / 720.0 * N * Math.pow (Math.cos (phi), 6.0) * l6coef * Math.pow (l, 6.0))
+ (t / 40320.0 * N * Math.pow (Math.cos (phi), 8.0) * l8coef * Math.pow (l, 8.0));
 
return;
 
}
 
/*
* MapXYToLatLon
*
* Converts x and y coordinates in the Transverse Mercator projection to
* a latitude/longitude pair. Note that Transverse Mercator is not
* the same as UTM; a scale factor is required to convert between them.
*
* Reference: Hoffmann-Wellenhof, B., Lichtenegger, H., and Collins, J.,
* GPS: Theory and Practice, 3rd ed. New York: Springer-Verlag Wien, 1994.
*
* Inputs:
* x - The easting of the point, in meters.
* y - The northing of the point, in meters.
* lambda0 - Longitude of the central meridian to be used, in radians.
*
* Outputs:
* philambda - A 2-element containing the latitude and longitude
* in radians.
*
* Returns:
* The function does not return a value.
*
* Remarks:
* The local variables Nf, nuf2, tf, and tf2 serve the same purpose as
* N, nu2, t, and t2 in MapLatLonToXY, but they are computed with respect
* to the footpoint latitude phif.
*
* x1frac, x2frac, x2poly, x3poly, etc. are to enhance readability and
* to optimize computations.
*
*/
function MapXYToLatLon (x, y, lambda0, philambda)
{
var phif, Nf, Nfpow, nuf2, ep2, tf, tf2, tf4, cf;
var x1frac, x2frac, x3frac, x4frac, x5frac, x6frac, x7frac, x8frac;
var x2poly, x3poly, x4poly, x5poly, x6poly, x7poly, x8poly;
 
/* Get the value of phif, the footpoint latitude. */
phif = FootpointLatitude (y);
 
/* Precalculate ep2 */
ep2 = (Math.pow (sm_a, 2.0) - Math.pow (sm_b, 2.0))
/ Math.pow (sm_b, 2.0);
 
/* Precalculate cos (phif) */
cf = Math.cos (phif);
 
/* Precalculate nuf2 */
nuf2 = ep2 * Math.pow (cf, 2.0);
 
/* Precalculate Nf and initialize Nfpow */
Nf = Math.pow (sm_a, 2.0) / (sm_b * Math.sqrt (1 + nuf2));
Nfpow = Nf;
 
/* Precalculate tf */
tf = Math.tan (phif);
tf2 = tf * tf;
tf4 = tf2 * tf2;
 
/* Precalculate fractional coefficients for x**n in the equations
below to simplify the expressions for latitude and longitude. */
x1frac = 1.0 / (Nfpow * cf);
Nfpow *= Nf; /* now equals Nf**2) */
 
x2frac = tf / (2.0 * Nfpow);
Nfpow *= Nf; /* now equals Nf**3) */
 
x3frac = 1.0 / (6.0 * Nfpow * cf);
Nfpow *= Nf; /* now equals Nf**4) */
 
x4frac = tf / (24.0 * Nfpow);
Nfpow *= Nf; /* now equals Nf**5) */
 
x5frac = 1.0 / (120.0 * Nfpow * cf);
Nfpow *= Nf; /* now equals Nf**6) */
 
x6frac = tf / (720.0 * Nfpow);
Nfpow *= Nf; /* now equals Nf**7) */
 
x7frac = 1.0 / (5040.0 * Nfpow * cf);
Nfpow *= Nf; /* now equals Nf**8) */
 
x8frac = tf / (40320.0 * Nfpow);
 
/* Precalculate polynomial coefficients for x**n.
-- x**1 does not have a polynomial coefficient. */
 
x2poly = -1.0 - nuf2;
 
x3poly = -1.0 - 2 * tf2 - nuf2;
 
x4poly = 5.0 + 3.0 * tf2 + 6.0 * nuf2 - 6.0 * tf2 * nuf2
- 3.0 * (nuf2 *nuf2) - 9.0 * tf2 * (nuf2 * nuf2);
 
x5poly = 5.0 + 28.0 * tf2 + 24.0 * tf4 + 6.0 * nuf2 + 8.0 * tf2 * nuf2;
 
x6poly = -61.0 - 90.0 * tf2 - 45.0 * tf4 - 107.0 * nuf2
+ 162.0 * tf2 * nuf2;
 
x7poly = -61.0 - 662.0 * tf2 - 1320.0 * tf4 - 720.0 * (tf4 * tf2);
 
x8poly = 1385.0 + 3633.0 * tf2 + 4095.0 * tf4 + 1575 * (tf4 * tf2);
 
/* Calculate latitude */
philambda[0] = phif + x2frac * x2poly * (x * x)
+ x4frac * x4poly * Math.pow (x, 4.0)
+ x6frac * x6poly * Math.pow (x, 6.0)
+ x8frac * x8poly * Math.pow (x, 8.0);
 
/* Calculate longitude */
philambda[1] = lambda0 + x1frac * x
+ x3frac * x3poly * Math.pow (x, 3.0)
+ x5frac * x5poly * Math.pow (x, 5.0)
+ x7frac * x7poly * Math.pow (x, 7.0);
 
return;
}
 
/*
* LatLonToUTMXY
*
* Converts a latitude/longitude pair to x and y coordinates in the
* Universal Transverse Mercator projection.
*
* Inputs:
* lat - Latitude of the point, in radians.
* lon - Longitude of the point, in radians.
* zone - UTM zone to be used for calculating values for x and y.
* If zone is less than 1 or greater than 60, the routine
* will determine the appropriate zone from the value of lon.
*
* Outputs:
* xy - A 2-element array where the UTM x and y values will be stored.
*
* Returns:
* The UTM zone used for calculating the values of x and y.
*
*/
 
function LatLonToUTMXY (lat, lon, zone, xy)
{
MapLatLonToXY (lat, lon, UTMCentralMeridian (zone), xy);
 
/* Adjust easting and northing for UTM system. */
xy[0] = xy[0] * UTMScaleFactor + 500000.0;
xy[1] = xy[1] * UTMScaleFactor;
 
if (xy[1] < 0.0)
xy[1] = xy[1] + 10000000.0;
 
return zone;
 
}
 
/*
* UTMXYToLatLon
*
* Converts x and y coordinates in the Universal Transverse Mercator
* projection to a latitude/longitude pair.
*
* Inputs:
* x - The easting of the point, in meters.
* y - The northing of the point, in meters.
* zone - The UTM zone in which the point lies.
* southhemi - True if the point is in the southern hemisphere;
* false otherwise.
*
* Outputs:
* latlon - A 2-element array containing the latitude and
* longitude of the point, in radians.
*
* Returns:
* The function does not return a value.
*
*/
 
function UTMXYToLatLon (x, y, zone, southhemi, latlon)
{
var cmeridian;
x -= 500000.0;
x /= UTMScaleFactor;
 
/* If in southern hemisphere, adjust y accordingly. */
if (southhemi)
y -= 10000000.0;
y /= UTMScaleFactor;
 
cmeridian = UTMCentralMeridian (zone);
MapXYToLatLon (x, y, cmeridian, latlon);
 
return;
 
}
 
/*
* btnToUTM_onclick
*
* Called when the btnToUTM button is clicked.
*
*/
 
function btnToUTM_onclick ()
{
var xy = new Array(2);
 
if (isNaN (parseFloat (document.frmConverter.txtLongitude.value))) {
alert ("Please enter a valid longitude in the lon field.");
 
return false;
 
}
 
lon = parseFloat (document.frmConverter.txtLongitude.value);
 
if ((lon < -180.0) || (180.0 <= lon)) {
 
alert ("The longitude you entered is out of range. " +
"Please enter a number in the range [-180, 180).");
 
return false;
 
}
 
if (isNaN (parseFloat (document.frmConverter.txtLatitude.value))) {
 
alert ("Please enter a valid latitude in the lat field.");
 
return false;
 
}
 
lat = parseFloat (document.frmConverter.txtLatitude.value);
 
 
if ((lat < -90.0) || (90.0 < lat)) {
	alert ("The latitude you entered is out of range. " +
 
	"Please enter a number in the range [-90, 90].");
 
return false;
 
}
 
 
// Compute the UTM zone.
zone = Math.floor ((lon + 180.0) / 6) + 1;
zone = LatLonToUTMXY (DegToRad (lat), DegToRad (lon), zone, xy);
 
/* Set the output controls. */
document.frmConverter.txtX.value = xy[0];
document.frmConverter.txtY.value = xy[1];
document.frmConverter.txtZone.value = zone;
if (lat < 0)
// Set the S button.
document.frmConverter.rbtnHemisphere[1].checked = true;
else
// Set the N button.
document.frmConverter.rbtnHemisphere[0].checked = true;
 
return true;
 
}
 
/*
* btnToGeographic_onclick
*
* Called when the btnToGeographic button is clicked.
*
*/
 
function btnToGeographic_onclick ()
{
latlon = new Array(2);
var x, y, zone, southhemi;
 
if (isNaN (parseFloat (document.frmConverter.txtX.value))) {
	alert ("Please enter a valid easting in the x field.");
 
return false;
 
}
 
x = parseFloat (document.frmConverter.txtX.value);
if (isNaN (parseFloat (document.frmConverter.txtY.value))) {
	alert ("Please enter a valid northing in the y field.");
 
return false;
 
}
 
y = parseFloat (document.frmConverter.txtY.value);
if (isNaN (parseInt (document.frmConverter.txtZone.value))) {
	alert ("Please enter a valid UTM zone in the zone field.");
 
return false;
 
}
zone = parseFloat (document.frmConverter.txtZone.value);
if ((zone < 1) || (60 < zone)) {
	alert ("The UTM zone you entered is out of range. " +
	"Please enter a number in the range [1, 60].");
 
return false;
 
}
if (document.frmConverter.rbtnHemisphere[1].checked == true)
	southhemi = true;
else
	southhemi = false;
	UTMXYToLatLon (x, y, zone, southhemi, latlon);
	document.frmConverter.txtLongitude.value = RadToDeg (latlon[1]);
	document.frmConverter.txtLatitude.value = RadToDeg (latlon[0]);
 
return true;
 
}
 
/*
* btnToGoogle_onclick
*
* Called when the btnToGooglebutton is clicked.
*
*/
 
function btnToGoogle_onclick ()
{
latlon = new Array(2);
var x, y, zone, southhemi;
if (isNaN (parseFloat (document.frmConverter.txtX.value))) {
	alert ("Please enter a valid easting in the x field.");
 
return false;
 
}
x = parseFloat (document.frmConverter.txtX.value);
if (isNaN (parseFloat (document.frmConverter.txtY.value))) {
	alert ("Please enter a valid northing in the y field.");
 
return false;
 
}
y = parseFloat (document.frmConverter.txtY.value);
if (isNaN (parseInt (document.frmConverter.txtZone.value))) {
	alert ("Please enter a valid UTM zone in the zone field.");
 
return false;
 
}
zone = parseFloat (document.frmConverter.txtZone.value);
if ((zone < 1) || (60 < zone)) {
	alert ("The UTM zone you entered is out of range. " +
	"Please enter a number in the range [1, 60].");
 
return false;
 
}
if (document.frmConverter.rbtnHemisphere[1].checked == true)
	southhemi = true;
else
	southhemi = false;
 
UTMXYToLatLon (x, y, zone, southhemi, latlon);
document.frmConverter.txtLongitude.value = RadToDeg (latlon[1]);
document.frmConverter.txtLatitude.value = RadToDeg (latlon[0]);
 
output = latlon[1], latlon[0]
 
return output;
 
}
// -->
</script>
<script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAAFJjf-mxSkkinNxdYBv6VpxQTBlyFpWfSu1-0eUDSrXLaoA7N0hQweHWdfaizu9bnb2sEHK_PkELp4g" type="text/javascript"></script>
<script type="text/javascript">
var map;
var geocoder;
function initialize() {
	map = new GMap2(document.getElementById("map_canvas"));
	map.setCenter(new GLatLng(36, -95), 3);
	geocoder = new GClientGeocoder();
	map.addControl(new GSmallMapControl());
	var mapControl = new GMapTypeControl();
	map.addControl(mapControl);
	map.addControl(new GOverviewMapControl());
	var mapControl = new GMapTypeControl();
	map.addControl(mapControl);
}
// addAddressToMap() is called when the geocoder returns an
// answer. It adds a marker to the map with an open info window
// showing the nicely formatted version of the address and the country code.
function addAddressToMap(response) {
	map.clearOverlays();
	if (!response || response.Status.code != 200) {
		alert("Sorry, we were unable to geocode that address");
} 	else {
		place = response.Placemark[0];
		point = new GLatLng(place.Point.coordinates[1],
		place.Point.coordinates[0]);
		marker = new GMarker(point);
		map.addOverlay(marker);
	}
}
// showLocation() is called when you click on the Search button
// in the form. It geocodes the address entered into the form
// and adds a marker to the map at that location.
function showLocation() {
	var address = document.forms[0].q.value;
	geocoder.getLocations(address, addAddressToMap);
}
// findLocation() is used to enter the sample addresses into the form.
function findLocation(address) {
	document.forms[0].q.value = address;
	showLocation();
}
</script>
</head>
<body onload="initialize()" onunload="GUnload()">
<form NAME="frmConverter" action="#" onsubmit="showLocation(); return false;">
<table BORDER=0>
<!-- Header row -->
<tr>
<th COLSPAN=2 ALIGN=center>Geographic<br />(<em>decimal degrees</em>)</th>
<th ALIGN=center>To/From</th>
<th COLSPAN=2 ALIGN=center>UTM</th>
</tr>
<!-- The size attribute for the button input keeps the control
from looking too bad on browsers that don't support buttons
(even though the control is useless in this case).
The &gt; code is used for browsers that will interpret the
first right angle bracket in the VALUE field as the tag
terminator. -->
<tr>
<td ALIGN=right>lon</td>
<td><input TYPE=text SIZE=20 NAME="txtLongitude" VALUE="" id="field_long"/></td>
<td ALIGN=center><input TYPE=button SIZE=4 NAME=btnToUTM VALUE="&gt;&gt;" onclick="btnToUTM_onclick()"/> </td>
<td ALIGN=right>x</td>
<td><input TYPE=text SIZE=20 NAME="txtX" VALUE=""/></td>
</tr>
<!-- Northing row (plus command button) -->
<tr>
<td ALIGN=right>lat</td>
<td><input TYPE=text SIZE=20 NAME="txtLatitude" VALUE="" id="field_lat"/></td>
<td ALIGN=center><input TYPE=button SIZE=4 NAME=btnToGeographic VALUE="<<" onclick="btnToGeographic_onclick ()"/></td>
<td ALIGN=right>y</td>
<td><input TYPE=text SIZE=20 NAME="txtY" VALUE=""/></td>
</tr>
<!-- UTM zone row -->
<tr>
<td COLSPAN=3></td>
<td ALIGN=right>zone</td>
<td><input TYPE=text SIZE=4 NAME="txtZone" VALUE=""/></td>
</tr>
<!-- Hemisphere row -->
<tr>
<td COLSPAN=3></td>
<td COLSPAN=2>
hemisphere
<!-- onclick properties circumvent a Netscape bug that reverses
the indices of the buttons -->
<input TYPE=radio NAME="rbtnHemisphere" VALUE="N" CHECKED onclick="0"/>N
<input TYPE=radio NAME="rbtnHemisphere" VALUE="S" onclick="0"/>S
</td>
</tr>
<!-- To Google -->
<tr>
<td COLSPAN=1><input TYPE=hidden SIZE=20 VALUE="http://maps.google.com/maps?q=" id="url"/> <input TYPE=hidden SIZE=20 VALUE=", " id="comma"/></td>
<td COLSPAN=1 ALIGN=right>Google Maps...</td>
<td ALIGN=left><input TYPE=button SIZE=4 VALUE="Load" onclick="document.getElementById('google').value=(document.getElementById('url').value) + (document.getElementById('field_lat').value) + (document.getElementById('comma').value) + (document.getElementById('field_long').value)" /></td>
 
</tr>
</table>
<!-- To Browser -->
<tr>
<td ALIGN=left><input TYPE=text SIZE=80 NAME=output VALUE="" id="google" </TD/>
<br /><br />
<div id="map_canvas" style="width: 100%; height: 350px"></div>
<br /><br />
</td></tr>
<tr>Click in the text box then map it!
<input type="text" name="q" value="" class="address_input" id="search" size="40" onclick="document.getElementById('search').value=(document.getElementById('field_lat').value) + (document.getElementById('comma').value) + (document.getElementById('field_long').value)"/>
<input type="submit" name="find" value="Go..." />
<br /><br />
</tr>
</form>
 
</body>
</html>

More from Adam Estrada

• WordPress as a CMS
• Customizing config.xml in the ESRI FlexViewer
• More on ESRI Flex and Config.xml
• How to copy music from your iPod to your iPhone
• How to Load a Shapefile in to Oracle Spatial

Adam Estrada Recommends

• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• Converting Unprojected Bounding Box to the Miller Projection  (Maploser)
• Really cool reasons to get Snow Leopard  (MtaraM)

The following utility programs are distributed with GDAL and are among the most powerful command line GIS applications available today. I for one have beaten gdalwarp to death! I will include all that it can do in later posts. Until then, here is the list of what is included in the FWTools installer for Windows and Linux.

• gdalinfo – report information about a file.
• gdal_translate – Copy a raster file, with control of output format.
• gdaladdo – Add overviews to a file.
• gdalwarp – Warp an image into a new coordinate system.
• gdaltindex – Build a MapServer raster tileindex.
• gdalbuildvrt – Build a VRT from a list of datasets.
• gdal_contour – Contours from DEM.
• gdaldem – Tools to analyze and visualize DEMs.
• rgb2pct.py – Convert a 24bit RGB image to 8bit paletted.
• pct2rgb.py – Convert an 8bit paletted image to 24bit RGB.
• gdal_merge.py – Build a quick mosaic from a set of images.
• gdal2tiles.py – Create a TMS tile structure, KML and simple web viewer.
• gdal_rasterize – Rasterize vectors into raster file.
• gdaltransform – Transform coordinates.
• nearblack – Convert nearly black/white borders to exact value.
• gdal_retile.py – Retiles a set of tiles and/or build tiled pyramid levels.
• gdal_grid – Create raster from the scattered data.
• gdal_proximity.py – Compute a raster proximity map.
• gdal_polygonize.py – Generate polygons from raster.
• gdal_sieve.py – Raster Sieve filter.
• gdal_fillnodata.py – Interpolate in nodata regions.
• gdal-config – Get options required to build software using GDAL.

Note that a lot of these apps are python scripts than can be run just about anywhere. I have done quite a bit of processing with FWTools apps, especially gdalwarp, gdal_translate and then gdal_contour. If you have a project that requires some serious processing power, check some of these out. You won’t be disappointed…Note: Most FOSS GIS applications available today use GDAL and OGR on the back end in some way, shape or form. See the list here!

More from Adam Estrada

• Open Street Map (take 1)
• How to copy music from your iPod to your iPhone
• Oracle Spatial and USER_SDO_GEOM_METADATA
• Customizing config.xml in the ESRI FlexViewer
• ESRI FlexViewer and Error 1065

Adam Estrada Recommends

• Top Free Useful Cydia applications for your IPhone  (tretre)
• Layar for the iPhone  (Maploser)
• Adam – The Indian iPad killer  (MtaraM)

The nature of our business and the data we use is so simple! We deal with pixels, points, lines and polygons that can be manipulated a million different ways through attribution and symbology. There are format-specific standards to adhere to and models on how store and disseminate them so why not leverage what other people have created and published. I for one am constantly on the lookout for more data and software that will gobble it up. This is where applications (on the web) like GeoCommons and WeoGeo come in to play. They allow you to publish your data, do stuff with it and then open it up for anyone to reuse. WeoGeo’s model is pretty cool because they also allow you to monetize on other people using your data by selling it as the owner sees fit. GeoCommons has Finder! and Maker! which really help you upload or search for data and then create some cool maps but they have a model that is more like OpenStreetMap or Cloudmade. My opinion on this is that free data is good data If you’re self sufficient enough to have your own IT infrastructure and want to publish your data that way, look at ArcGIS Server or the two competing FOSS options GeoServer and MapServer.

QGIS

I am a Mac user and use QGIS pretty extensively to read WMS and WFS services that I come across over the web. I encourage anyone out there to do the same thing as the latest and greatest build of QGIS is REALLY nice! So I guess my question is, where are the services that you use the most?

More from Adam Estrada

• WordPress as a CMS
• Open Street Map (take 1)
• How to copy music from your iPod to your iPhone
• ESRI FlexViewer and Error 1065
• GeoDC Kickoff…

Adam Estrada Recommends

• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• Routing with the new Google Maps Data  (Maploser)
• Layar for the iPhone  (Maploser)

Selenium is a FREE suite of tools to automate web app testing across many platforms. Click here to see a list of all the Selenium projects…I particularly like the Firefox plugin!

More from Adam Estrada

• iPhone Test
• How to copy music from your iPod to your iPhone
• GIS For the Have Nots
• jQuery and Prototype Overview
• GeoDC Kickoff…

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Update from Google Map on my Problem  (Maploser)
• Update to my Google Maps Error Report  (Maploser)

My latest challenge was deploying an application that referenced several .NET web services that were GOING to change once delivered to the customer. So, it made no sense what so ever to hard code the URL’s for the web services in the application it self. I decided to add them to config.xml which is at the root of the web application. This file behaves much in the same way as the web.config file that is created on-the-fly in your .NET web application. This one, however, holds things elements like URLs, queries, logo assignments and like in this example, paths to web services.

Once you figure out what is going on, this is relatively simple to do so I hope that this example helps to put things in to perspective for you.

First things first…You have to first grab the XML file and because this is a web application, you are able to use HTTPService() to call you file on the server. My biggest “idiot” moment was caused because this file is at the root of the application while most of the “config” files that ride along with their corresponding .swf’s are in the same directory. No matter! See the code below that will show you how to connect to your config.xml file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14

private function doInit():void
{
        try {
	        var initService:HTTPService = new HTTPService();
	        initService.url = "config.xml";
		initService.resultFormat = "e4x";
		initService.addEventListener(ResultEvent.RESULT, initResult);
		initService.send();
	}
		catch(e:Error)
		{
			showMessage(e.message, false);
		}
}

Note that this function has an event lister (addEventListener) that calls another function which in this case is called “initResult”. Also note that with all Actionscript, it’s pretty good practice to use try/catch statements in all of your functions. Actually, isn’t this true in any programming language?

Now, on to the next function! This is the function that actually does the work and populates an “Object” with the data your specify from your XML file. Please note that I added an extra root node to config.xml called <ServiceURL>. Under that we have <service> and under that we’ve got <url> and <name>. I am merely trying to retrieve a URL based on a service name so if we do a query for <name>, the URL for that name will be returned. w00t! The function called “initResult” is as follows.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

private function initResult(event:ResultEvent):void
	{
		try
		{
			var i:int;
			var serviceArray:Array = [];
			var serviceXML:XML = event.result as XML;
			var serviceList:XMLList = serviceXML..service;
 
			for (i = 0; i < serviceList.length(); i++) {
				var name:String = serviceList[i].name;
				var url:String = serviceList[i].url;
				var serviceURL:Object =
				{
					name: name,
					url: url
				}
					trace(name, url);
			}
		serviceArray.push(serviceURL);
	}
			catch (e:Error)
			{
    			    showMessage(e.message, false);
			}
	}

You’ll first notice that I created an Array.

var serviceArray:Array = [];

I then grabbed the resulting event as XML from the event listener.

var serviceXML:XML = event.result as XML;

. From there I searched down through the XML file for the root node I was looking for which in this case was called “service” in the XML file:

var serviceList:XMLList = serviceXML..service;

. Finally, I looped through the file to find all the data in the tags using a *for* loop.

1
2
3
4
5
6
7
8
9
10
11

for (i = 0; i < serviceList.length(); i++) {
	var name:String = serviceList[i].name;
	var url:String = serviceList[i].url;
	var serviceURL:Object =
		{
			name: name,
			url: url
		}
	trace(name, url);
}
serviceArray.push(serviceURL);

There are a couple things to notice here.
1. You can loop through anything in an XML file…you’ve just got to know what you’re looking for.
2. It’s absolutely mandatory that you create an :Object and populate it using the .push command.

serviceArray.push(serviceURL);

What you’ve got now is an Object that has all of the information that you can readily reuse when the page/site loads.

More from Adam Estrada

• WordPress as a CMS
• ESRI FlexViewer and Error 1065
• More on ESRI Flex and Config.xml
• Open Street Map (take 1)
• How to Load a Shapefile in to Oracle Spatial

Adam Estrada Recommends

• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• Routing with the new Google Maps Data  (Maploser)
• Adam – The Indian iPad killer  (MtaraM)

The Project:

Green Mountain Falls, Colorado is a little municipality in the middle-of-nowhere Colorado but they do have a requirement to serve up their proprietary geospatial data to both the general public and then to those who really need it like their Fire and Police Departments.  I won’t go in to why the GMF data is private as certain geo-type people go richter over the whole “my data is private” issue, but I will say that GMF does have their reasons. We begged and pleaded with the folks at FortiusOne to work with us on this endeavor because their core technology is absolutely what the doctor ordered. There are a lot of reasons why GeoCommons (GC) was the best solution so I will only elaborate on a few.

1. GeoCommons is literally so easy a cave man can do it. With a private instance, we were able to upload our own data and show/hide it as needed in the final UI.
2. You can pick and choose from your own base maps so Google, Bing and OSM are all options to use for your final compiled cartogram.
3. Cartography, cartography, cartography!!! You gotta give it to the F1 team…they’ve provided a robust desktop-like GIS symbolization and thematic mapping experience on the web and in this case all in a private instance of GC in the Cloud.

The Problem:

Green Mountain Falls has private data…These data are from their roads network and also in their unique way of representing parcels in the town. I’d have to refer to another source to fully explain this whole thing…Bottom line is that all of their geospatial data could not be 100% open to the rest of the world. Like I mentioned earlier, we stored it a private instance or GeoCommons and then applied some role-based authentication to the layers using the GeoCommons API and a couple pieces of WordPress magic.

WordPress has literally thousands of plugins that you can pick and choose from to run and enhance your blog. We weren’t interested in SEO or any of that other jazz that really helps your site get noticed! We were interested in safe-guarding the data. In WordPress, there are two plugins in particular that will allow you to do this!

Capability Manager – The Capability Manager plugin provides a simple way to manage role capabilities. Using it, you will be able to change the capabilities of any role, add new roles, copy existing roles into new ones, and add new capabilities to existing roles. You can also delegate capabilities management to other users. In this case, some restrictions apply to this users, as them can only set/unset the capabilities they have. With the Backup/Restore tool, you can save your Roles and Capabilities before making changes and revert them if something goes wrong. You’ll find it on the Tools menu. At the current version, you cannot manage capabilities at user level (only can be managed for roles). This will be included in next versions.

The Capabilities Manager gave us an easy way to create and assign new roles to GMF users. I encourage everyone to check this plugin out!

User Access Manager – With the “User Access Manager”-plugin you can manage the access to your posts, pages and files. You only create a user group, put registered users to this and set up the rights for this group. From now on the post/page is only accessible and writable for the specified group. This plugin is useful if you need a member area or a private section at your blog or you want that other people can write at your blog but not everywhere.

With UAM, we were able to show and hide WordPress pages so that only certain Users and User Groups could see them.

How did you mashup your GeoCommons Maps?

Simple! Just like Google, Bing and Yahoo, GeoCommons allows you to embed your map directly in to your own website! See the graphic below…Note: in the map you create, you can select the “Details” button in the top-right corner of the screen which will present you with the code to embed your map. Copy and paste and you’re set!

Embedding GeoCommons Maps!

Sample code to embed a GeoCommons map in to your own website is as follows…

1
2
3
4
5
6
7
8

<style>#maker_map_1809 {width: 100%; height: 100%;}</style>
  <script type="text/javascript" charset="utf-8" src="http://maker.geocommons.com/javascripts/embed.js"></script>
<script type="text/javascript" charset="utf-8">
  Maker.maker_host='http://maker.geocommons.com';Maker.finder_host='http://finder.geocommons.com';Maker.core_host='http://core.geocommons.com';
  Maker.load_map("maker_map_1809", "1809");
</script>
<div class="geocommons_map" id="maker_map_1809"></div><br />
<a class="geocommons_map_link" id="maker_map_1809_link" href="http://maker.geocommons.com/maps/1809">View full map</a>

I’d really like to thank Kate Chapman, Andrew Turner and the folks on the Zekiah team (you know who you are) for helping to put this proof of concept together! Wanna see the Green Mountain Falls site in action? Geez…Click on the screen grab below to access it!

Green Mountain Falls, Colorado

More from Adam Estrada

• Customizing config.xml in the ESRI FlexViewer
• Open Street Map (take 1)
• ESRI FlexViewer and Error 1065
• Oracle Spatial and USER_SDO_GEOM_METADATA
• SpatiaLite and Smart Phones

Adam Estrada Recommends

• 15 Killer Hacks for WordPress that Are Extremely Useful  (MtaraM)
• Using a Columbus v900 as a tethered GPS with OSX  (Maploser)
• Windows 7 tricks and secrets  (MtaraM)

Because I am also developing a mapping application using ESRI’s FlexViewer framework, I have to integrate my CRUD forms in to the ESRI environment. Needless to say, this caused all kinds of problems! When I created a project outside of the FlexViewer project, everything worked perfectly! As soon as I tried to integrate it in to FlexVewer as a floating widget…Kaboom! I got the dreaded 1065 error. If you are reading this, it’s probably because you came across this error as well and found this page on the interwebs.

Error #1065: Variable x is not defined.

This error is a bit misleading because “Variable x” is actually a class that when integrated in to the FlexViewer framework get pushed out of scope or what some call, “Optimized out”. To get your code running in FlexViewer, you can’t just declare each variable/class as public! You have to declare each of them in Index.mxml which is the Application root. Please stick with the following syntax in order for your code to work properly.

1

public var d:services.distributionlist.RegionUser = new services.distributionlist.RegionUser();

Doing this in Index.mxml will make your class public enough to be used throughout the entire application and you won’t get the #1065 error any longer. I certainly can’t take all the credit for this. I have to Google the crap out of this and came across Simon’s post here. Hats off to you Simon for helping me out!!!

More from Adam Estrada

• Customizing config.xml in the ESRI FlexViewer
• Open Street Map (take 1)
• How to copy music from your iPod to your iPhone
• Oracle Spatial and USER_SDO_GEOM_METADATA
• SpatiaLite and Smart Phones

Adam Estrada Recommends

• Top Free Useful Cydia applications for your IPhone  (tretre)
• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• How To Upload Videos From Your Iphone Using PixelPipe, PPVideoEnabler, and Cyrecorder 2010  (tretre)

iLinkPod

A couple weeks ago, we got Allison an iPhone and put her on my AT&T account. She also has an iPod that was originally synced up with an older PC and I found that there was no easy way to move files from the iPod to the iPhone without erasing everything on the iPod. I did a little Googling and came across iLinkPod which worked wonderfully and for free too! So how does it work??? Easy, it creates a shortcut folder on the desktop pointing to your iPod so that you can add files to your personal iTunes Library.

Step 1: Download the application! Get it here…

Step 2: Hook up your iPod (DO NOT SELECT THE ERASE AND SYNC OPTION in iTunes) and then launch iLinkPod. Select the first button to “Select your iPod”

Select you iPod

Step 3: Click the button that says, “iLinkPod!” and review the console to make sure it successfully connected and retrieved your files.

Creating folder iLinkPodFolder on your desktop…OK

YOUR FILE LIST

…done…that’s all!

Step 4: Now open iTunes and browse to File | Add to Library…

Add Files from iPod

And that’s it! Now your iPod songs are on your computer and can be synced with your iPhone the next time you plug it in!

More from Adam Estrada

• WordPress as a CMS
• iPhone Test
• ESRI FlexViewer and Error 1065
• SpatiaLite 2.4.0
• Only in Alabama…

Adam Estrada Recommends

• Top Free Useful Cydia applications for your IPhone  (tretre)
• How To Upload Videos From Your Iphone Using PixelPipe, PPVideoEnabler, and Cyrecorder 2010  (tretre)
• How to Speed Up A Laggy, Slow IPhone Jailbreak Unlock  (tretre)

Flex Training?

Bill asked the question the other day and it dawned on me that it would really behoove ESRI to provide training for their Flex and  Silverlight API’s. They have done an excellent job putting together the backend achitecture for both frameworks so why not train their users on how to properly use them? I for one, have used the Sample Flex Viewer on several occasions but there is still sooo much that I don’t know about it or what it can do. So, I want to ask the general public what they would want to learn more about in regards to the ESRI Flex Framework. Would you want instructor lead training or would an online tutorial work for you? Are you more interested in how to code in Actionscript or do you really just need to know how to implement all the bells and whistles for the framework. What about the Sample Flex Viewer? Would you like a training class that is designed to demonstrate specifically how to extend that? There are a ton of options here and I am very interested to learn what other people are doing with this technology and what they might need to make the most of it. Please feel free to post a comment on what you would want to see from ESRI in a Flex training class!

More from Adam Estrada

• How to copy music from your iPod to your iPhone
• GeoDC Kickoff…
• ESRI FlexViewer and Error 1065
• SpatiaLite 2.4.0
• Oracle Spatial and USER_SDO_GEOM_METADATA

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Layar for the iPhone  (Maploser)
• Auto retweet with yahoo pipes  (MtaraM)

1. If you have five dollars and Jack Dangermond has five dollars, Jack Dangermond has more money than you.
2. There is no ‘ctrl’ button on Jack Dangermond’s computer. Jack Dangermond is always in control.
3. Apple pays Jack Dangermond 99 cents every time he listens to a song.
4. Jack Dangermond can sneeze with his eyes open.
5. Jack Dangermond can eat just one Lay’s potato chip.
6. Jack Dangermond is suing Myspace for taking the name of what he calls everything around you.
7. Jack Dangermond destroyed the periodic table, because he only recognizes the element of surprise.
8. Jack Dangermond can kill two stones with one bird.
9. When the Boogeyman goes to sleep every night, he checks his closet for Jack Dangermond.
10. Jack Dangermond doesn’t read books. He stares them down until he gets the information he wants.
11. There is no theory of evolution. Just a list of creatures Jack Dangermond has allowed to live.
12. Outer space exists because it’s afraid to be on the same planet with Jack Dangermond.
13. Jack Dangermond does not sleep. He waits.
14. Jack Dangermond is currently suing NBC, claiming Law and Order are trademarked names for his left and right legs.
15. Jack Dangermond is the reason why Waldo is hiding.
16. Jack Dangermond counted to infinity – twice.
17. There is no chin behind Jack Dangermond’ beard. There is only another fist.
18. When Jack Dangermond does a pushup, he isn’t lifting himself up, he’s pushing the Earth down.
19. Jack Dangermond is so fast, he can run around the world and punch himself in the back of the head.
20. Jack Dangermond’s hand is the only hand that can beat a Royal Flush.
21. Jack Dangermond can lead a horse to water AND make it drink.
22. Jack Dangermond doesn’t wear a watch, HE decides what time it is.
23. Jack Dangermond can slam a revolving door.
24. Jack Dangermond does not get frostbite. Jack Dangermond bites frost
25. Jack Dangermond can divide by zero.

More from Adam Estrada

• Open Street Map (take 1)
• How to copy music from your iPod to your iPhone
• Oracle Spatial and USER_SDO_GEOM_METADATA
• ESRI FlexViewer and Error 1065
• SpatiaLite 2.4.0

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Routing with the new Google Maps Data  (Maploser)
• Update from Google Map on my Problem  (Maploser)

VisualSVN Server is a package that contains everything you need to install, configure and manage Subversion server for your team on Windows platform. It includes Subversion, Apache and a management console.

So now you’ve got source control! Next you’ll need a bug tracking system that integrates nicely with SVN. I went through this list and pretty much determined that they are all either too expensive or too much for what me and my small team need. I came across Redmine after getting a heads up from Bill Dollins. I gotta say that the features that this software has right out of the box are amazing! Check out their website for how they integrate with SVN too!

The problem I had was that it was really difficult to get it configured because 1. I am not all that familiar with a Ruby on Rails application and 2. SVN installs on an entirely different server (Apache) which I thought might be an issue. Wrong! I came across Bitnami.org which is a group that specializes in Open Source Software stack dissemination. After a quick download and an even faster install, I had Ruby on Rails, Redmine, Mongrel and MySQL set up and ready to go!  Note how many stacks the Bitnami group gives you…there is something for everyone! I am having issues getting Redmine without SSL to play nicely with VisualSVN with SSL so when I figure it out I will post how I fixed it.

More from Adam Estrada

• How to copy music from your iPod to your iPhone
• Open Street Map (take 1)
• ESRI FlexViewer and Error 1065
• If you build it, they will come…
• SpatiaLite and Smart Phones

Adam Estrada Recommends

• Top Free Useful Cydia applications for your IPhone  (tretre)
• Jailbreaking and unlocking your iphone for T-mobile  (tretre)
• How To Upload Videos From Your Iphone Using PixelPipe, PPVideoEnabler, and Cyrecorder 2010  (tretre)

It looks like GeoDC is going to take place on random Thursdays for now on. Thanks to Kate and the FortiusOne folks for putting it all together! If you live in the DC area and are in to Geospatial Technology, I encourage you to register at the Ning group. It’s a great way to connect with other GeoNerds in the area and learn about all the cool stuff they are working on. There seems to be a lot of influence from the open source crowd which in this day and age is just what the doctor ordered. I’ve gotten in to OSM since my first OSM Mapping Party last month so I’m glad to see the start of a semi-active group in the area.

More from Adam Estrada

• How to copy music from your iPod to your iPhone
• GIS For the Have Nots
• Automated web site testing
• Make a Google Wave…
• jQuery and Prototype Overview

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Update from Google Map on my Problem  (Maploser)
• Layar for the iPhone  (Maploser)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106

 public void kmlFile()
        {
 
            DataTable tbl = (DataTable)Session["DataTable"];
 
            // Create a temporary file name using a GUID and start writing the File
            object tempGUID = System.Guid.NewGuid();
 
            // Grab the icon path in the web.confg file.
            object iconPath;
            iconPath = ConfigurationManager.AppSettings["kmlIcon"];
 
            // Start writing the KML
            Response.Write("\n");
            Response.Write("\n");
            Response.Write("My KML\n");
            Response.Write("<!--
\n");
            Response.Write("<IconStyle>\n");
            Response.Write("<icon>\n");
            Response.Write("
<href>" + iconPath + "</href>\n");
            Response.Write("</icon>\n");
            Response.Write("\n");
            Response.Write("
-->\n");
            Response.Write("\n");
            Response.Write("-96.1501026686213\n");
            Response.Write("37.95371359340249\n");
            Response.Write("0\n");
            Response.Write("4429395.882870826\n");
            Response.Write("0\n");
            Response.Write("\n");
 
            // Loop through the dataset and populate the placemarks.
            string Name = string.Empty;
            string owner = string.Empty;
            string class = string.Empty;
 
            foreach (DataRow dr in tbl.Rows)
            {
 
                // Replace bad characters with good ones.
                Name = dr["Name"].ToString();
                Name = Name.Replace("&amp;", "&amp;");
                Name = Name.Replace("\\", """);
                Name = Name.Replace("&lt;", "&lt;");
                Name = Name.Replace("&gt;", "&gt;");
                owner = dr["Owner"].ToString();
                owner = owner.Replace("&amp;", "&amp;");
                owner = owner.Replace("\\", """);
                owner = owner.Replace("&lt;", "&lt;");
                owner = owner.Replace("&gt;", "&gt;");
 
                // Continue writing the KML
                Response.Write("\n");
                Response.Write("" + Name + "\n");
                Response.Write("
#pushpin\n");
                Response.Write("\n");
                Response.Write("< ![CDATA[\n");
                Response.Write("\n");
                Response.Write("<head>\n");
                Response.Write("\n");
                Response.Write("\n");
                Response.Write("<body>\n");
                Response.Write("
<h3 align=\"center\"><font COLOR=\"#FF0000\">" + class + "</font></h3>
\n");
                Response.Write("
<hr />\n");
                Response.Write("<b>Name:</b> " + dr["Name"] + "");
                Response.Write("");
                Response.Write("<b>Owner:</b> " + owner + "");
                Response.Write("");
                Response.Write("<b>Latitude:</b> " + dr["Latitude"] + "");
                Response.Write("");
                Response.Write("<b>Longitide:</b> " + dr["Longitude"] + "");
                Response.Write("");
                Response.Write("
<hr />");
                Response.Write("
<h3 align=\"center\"><font COLOR=\"#FF0000\">" + class + "</font></h3>
\n");
                Response.Write("</body>\n");
                Response.Write("\n");
                Response.Write("]]>");
                Response.Write("\n");
                Response.Write("\n");
                Response.Write("" + dr["Longitude"] + ", " + dr["Latitude"] + "\n");
                Response.Write("\n");
                Response.Write("\n");
 
            }
 
            Response.Write("");
            Response.Write("\n");
 
            // Response.Write the data with the Encoding "KML". This will force the default KML
            // reader to launch when the file is done writing.
            Response.AddHeader("content-disposition", "attachment; filename=" + tempGUID + ".kml");
            Response.ContentType = "application/vnd.google-earth.kml+xml";
            Response.AppendHeader("Content-Encoding", "kml");
        }
 
    }

Enjoy!

More from Adam Estrada

• GmapEZ
• Oracle Spatial and USER_SDO_GEOM_METADATA
• SpatiaLite 2.4.0
• GeoDC Kickoff…
• SpatiaLite and Smart Phones

Adam Estrada Recommends

• Adam – The Indian iPad killer  (MtaraM)
• Update from Google Map on my Problem  (Maploser)
• Layar for the iPhone  (Maploser)