Archive for July, 2010

XMap Advice—Reestablishing a Connection to your SQL Database

July 1, 2010

The symptoms are clear. You attempt to import a GIS layer into XMap and the only options in the database list are “Other” and “New.” “Where is my database?,” you ponder. “What happened to all of my other layers?” It feels like someone has walked into your office and removed the filing cabinet containing all of your important documents. “What do I do now? Where’s the panic button?”

Fortunately, the solution to this temporary predicament is usually quick and painless. The panic button is not needed.

The problem stems from the fact that XMap employs a Microsoft SQL database to store GIS data and occasionally, for reasons often too complex and bewildering to explain here, XMap refuses to “talk” to SQL and vice versa. The problem is easily solved by reintroducing both parties.

This reintroduction can be initiated in XMap from either the Manage Layers or the Import Layer window, both of which are accessed by clicking the Layers button above the Workspace table. In either case, select Other from the database drop-down list to display the Attach Database window.

Usually, the errant SQL server will be listed in the server drop-down list and will appear as either (LOCAL)\XMAP* or [your computer name]\XMAP* (* represents the version of XMap on your computer). If this is the case, simply select the server from the list, make sure Windows Authentication is checked, and click the Connect button. After a few seconds, the database list will display all of the XMap databases on your local server. For new XMap users, this list will be limited to the preconfigured database entitled DeLormeSampleDB. After selecting this or any other available database, click the OK button and continue importing or managing your layers as before.

It is likely that most of you can now stop reading this article and go back to work, secure in the knowledge that you have solved your database connection problem. However, there is a small group of you who will probably want to read on for the simple reason that your server list in the Attach Database window is conspicuously empty and you could not perform the succeeding steps.

If you are one of those unfortunate XMap users, there is an additional but very simple step that must be taken. In the blank server window, type (LOCAL)\XMAP* (* should be either 7, 6, or 5 depending on the version of XMap that was first installed on your computer and, correspondingly, the version of SQL that was created) and continue with the steps outlined above.

On rare occasions, the two solutions described will fail to rectify the database connection issue; this is usually because the SQL service is not running. Often, this problem occurs after an update to your operating system during which Windows fails to restart the service. The solution for this problem takes place outside of XMap.

  1. From the Start menu, right-click My Computer and select Manage.
  2. Click the plus sign next to Services and Applications and click Services.
  3. In the Services window, right-click SQL Server (XMAP*) and choose either Start or Restart.

Your database should now be available in XMap.

If the XMap instance of SQL is not listed in the Services widow, you will need to reinstall it from your XMap install disk. Instructions are available here.

Thankfully, the solutions for the common XMap database connection problems are reasonably straightforward and usually the disconnection problems will not reoccur.

XMap Q&A—I’ve been using the Draw tools for asset mapping; could this be described as GIS?

July 1, 2010

This issue could be debated at length and the response will likely vary depending on who is being asked. Before proceeding, it is worthwhile that we first come up with an explanation for the phrase Geographic Information System. By individually considering the three components of the term, we can create a clear and concise definition.

The word Geographic obviously means that it relates to location; Information tells us that there is some sort of data related to that location; and, finally, System implies that we are dealing with more than just a map or even mapping software—but, rather, a multi-faceted process that allows us to consider the data in the context of its location. Therefore, a GIS is simply a system for analyzing information as it relates to location.

So can it be argued that a map generated using the Draw tools in XMap or any other DeLorme software is a GIS? Certainly the Draw tab provides a variety of tools placing points, lines, and polygons on the map and for customizing the symbolization of each object. What’s missing is the ability to assign data or attributes to these objects. The flag on the map might convey to the viewer that there is an item of interest at that location, but it will not paint the complete picture by offering access to the relevant data about that item.

In most cases, the step up from simple mapping to a fully-fledged GIS is fairly straightforward. If you have already taken the time to create a draw layer that shows the location of your data objects, you are halfway there. All you need to do is import the draw layer into the GIS tab in XMap, then either manually add as many different attribute fields as you need or, better yet, import and link existing data in such formats as Microsoft® Excel, Access, or even text, and then automatically assign each row of data to the appropriate point.

Before long, you will realize the benefit of having your data geographically assigned in this way. Through processes such as classification and querying, you will be able to discern patterns in your data that would otherwise have gone unnoticed. Furthermore, data stored in a GIS format can be easily shared through a common database connection, within which permission settings will allow varying levels of access. This helps ensure that everyone in your organization has the latest versions of your data.

To read more about the benefits of a GIS click here.

If you have a question that you would like to have answered in the DeLorme Professional Newsletter XMap Q&A section, send it to newsletter@delorme.com with XMap Q&A in the subject line.

XMap at Work–Using XMap Forms to Collect or Edit Data

July 1, 2010

Those of you who follow the DeLorme Professional Newsletter will hopefully be familiar with the functional capabilities XMap Forms. In recent editions, we have described the procedure of creating a form, for establishing constraints within a layer, for deploying a form and any accompanying data to multiple XMap users utilizing XMap’s synchronization process, and for sending data to and from the PN-Series GPS receivers. Upon reflection it would appear that we neglected to cover what is perhaps the most important aspect of XMap Forms functionality: How is it used?

At the risk of jumping in at the deep end, this article will bypass the XMap Forms setup process and discuss the use of this technology in real world situations. If you would like to read more of the background information, refer to this article from the November 2009 newsletter or visit the XMap Forms page on xmap.com.

The following are some examples of XMap Forms at work in a variety of fields.

Oil and Gas Pipeline Inspection and Maintenance

One of the challenges in the energy sector is that a lot of work is done in remote and often inhospitable environments. DeLorme has addressed some of the specific concerns of the oil and gas industry by developing GIS tools that are ideally suited for field technicians and that provide a mechanism for collecting and submitting data to a central GIS. XMap’s synchronization tool, which offers an efficient means to transfer updated, location-specific data to work crews at the jobsite, becomes even more powerful when those same technicians can remotely collect information about their field assets and automatically integrate this data in to an Enterprise database at the corporate office.

In this context, XMap forms functionality transforms the Professional version of XMap from a field data viewer into a powerful data collector. These field-based personnel do not need to have an intimate knowledge of the workings of a GIS; instead, they simply fill out the required information about a pipeline at each location using preconfigured dropdown lists and simple text entry. XMap Forms, as an add-on feature of the synchronization process, empowers field technicians to become direct participants in the process of building and maintaining the company’s GIS infrastructure.

Natural Resource Management and Habitat Monitoring

When considering the protection of areas of environmental concern, two key questions must be addressed: Where is it? and What is it? Thankfully, the form-based data collection on the PN-Series GPS receivers can help answer both questions. GPS has long been an important component of the field biologist’s toolkit. When collecting data on such things as nesting sites, it is critical to note specifically where each nest is located as well as any additional site-specific information. Most GPS receivers offer limited data collection functionality and usually allow only a label and a brief comment to be assigned to each collected waypoint. Any additional information must be hand-written and manually assigned to each point back at the office or lab. Needless to say, this process is highly susceptible to human error and to the creation of incorrect data that may impact any derived scientific study.

The PN-Series GPS receivers are comparable to many handheld GPS devices on the market today in terms of price and ease of use. The distinction lies in the fact the entire process of field data collection, including the collection of a complete set of attributes for each point, can be performed in the field. The structure of the data collection form ensures that each attribute is consistent and it allows the resulting data to be directly integrated into a GIS, eliminating the need for any manual transfer of additional detail from handwritten notes.

Crime Mapping and Evidence Collection

In recent years, GIS has found a firm foothold in the field of criminal investigation and forensic analysis. It is often the spatial nature of the collected evidence that provides the essential clues for solving the crime. To ensure this process works effectively, evidence must be accurately cataloged, preferably onsite, so a robust location-based data collection device is essential. The PN-Series GPS receiver works well in this situation because it is rugged, waterproof, and compact. Furthermore, using XMap Forms offers the means to create a complete database of information about the crime.

Criminal investigators are usually called into action at a moment’s notice, so having a preconfigured form is strategically important. Because forms reside on the external SD card inserted into the PN-Series device, a library of different forms can be created and the appropriate form activated for a given situation.

Highway Maintenance and Repair

Anyone who lives in the northern tier states of the U.S. or any similar cold climate zone will attest to the fact that the roads take a beating in the winter months. Come spring, work crews are quickly deployed to patch the potholes and, if necessary, resurface the pavement. Before this work is undertaken, a thorough inspection process must be performed to ascertain which areas are of most concern and to document the level of damage, often with accompanying photographs.

XMap Forms deployed on a laptop computer in the inspection vehicle is ideally suited for this task. Each damage location can be quickly assigned as a GIS point and, using a series of preconfigured attribute fields and drop-down lists, the relevant information can be attached to each location. Photographic evidence can also be associated with each collected point after uploading images from a digital camera. The form interface offers a simple upload button which copies the photograph or any other file into the GIS database.

After the inspection work is complete, XMap’s synchronization function automatically transfers the points and the accompanying photographs to the department’s GIS administrator. With immediate access to this information, maintenance managers can allocate resources quickly and effectively.

Utility Pole Data Collection

To the layperson, all utility poles seem to be the same, but to a utility technician, each has its own characteristics and hardware configuration. Cataloging this information is essential for maintenance planning, service upgrading, and emergency preparedness. Collecting data on utility poles can be a laborious and time-consuming process, but using XMap Forms on either a laptop computer or on a PN-Series device, the process is not only faster but much more accurate.

Many of the attributes associated with a utility pole inventory will be consistent for each pole. For instance, most of the poles might be owned by one specific utility agency or company, so it is inefficient to manually add this attribute for each point. XMap Forms offers a simple solution for this. If necessary, each field can be assigned an initial or default value in XMap, which means the form can be pre-populated with the most common values and edited only if needed.

While most poles are likely to be adjacent to a road, allowing the collection of data by vehicle, there are occasions when the technician is required to venture off-road to gather the necessary information. In such situations, XMap Forms on both the in-vehicle laptop and on the handheld PN-Series GPS receiver can be used to populate a single GIS layer with pole data. At the end of the day, the technician simply merges the data from the PN and the computer and a complete GIS dataset is created.

These scenarios describe some typical uses for XMap Forms technology; however, there is virtually no limit to the ways in which this innovative data collection tool can be put to work. As always, we want to hear from you. If you are interested in sharing an account of how you use XMap Forms, please email prosales@delorme.com with the details.


Follow

Get every new post delivered to your Inbox.