Oshyn Home Page
  • expertise
    • Overview
    • Contact Us |
    • Latest work: www.miramax.com
  • solutions
    • Overview
    • Content Management
      • Choosing a CMS
      • Sitecore Consulting
      • EPiServer CMS Consulting
      • Jahia Integration
      • Open Text Web Solutions RedDot CMS
      • Drupal Development
      • Common Issues
      • Training
    • Web Strategy
    • Mobile Platforms
    • Social Media
    • E-commerce
    • Portals & Collaboration
    • SOA
    • Contact Us |
    • Latest work: www.miramax.com
  • work
    • Overview
    • Client Quotes
    • Contact Us |
    • Latest work: www.websense.com
  • resources
    • Overview
    • News & Events
    • Newsletters
    • Blog
    • White Papers
    • Success Stories
    • Press Kit
    • Contact Us |
    • Latest work: www.disneydvd.com
  • partners
    • Overview
    • Agency Partner Program
    • Technology Partners
    • Contact Us |
    • Latest work: www.nea.org
  • company
    • Overview
    • Contact
    • Careers
    • Leadership Team
    • News & Events
    • Social Responsibility
    • Contact Us |
    • Latest work: www.icon4x4.com
Drupal Location Module: Zip Code Proximity Search
  • Tweet
Tuesday, March 30, 2010  /   Carlos Martinez Carlos Martinez
close

Carlos Martinez


Carlos is a Technical Team Lead at Oshyn.

Drupal Location Module: Zip Code Proximity Search

The Drupal Location Module is a community module that allows geographic information to be associated with nodes. A Geographic Information System (GIS) describes any information system that integrates, stores, edits, analyzes, shares, and displays geographic information. In a more generic sense, GIS applications are tools that allow users to create interactive queries (user-created searches), analyze spatial information, edit data, maps, and present the results of all these operations.

Among the mentioned searches we find the Zip Code Proximity Search which will give us a list of places (nodes) that are located within a given distance of the zip code estimate center.

House Cleaning

First of all, you must install the Location and Views modules.
For this particular procedure I am using the following versions:
  • Location: 6.x-3.0
  • Views: 6.x-2.8
Once you install the Location module, you will need to import the zip codes to the database. To achieve this, take a look at the INSTALL.txt file located in the folder where you installed the module.

Alternatively, you can go to the following folder:
{path_to_location_module}\database
and using any MySQL execute window, run the script containing the data for the country you want to do searches against.

The Procedure

1.    Create a new or use an existing Content Template capable of holding location information. Configure the Locative Information to hold one position.

 
2.    Create some content using the Content Type defined before.  For this blog post, I have created the following sample nodes:

Place Latitude Longitude
Oshyn Inc. 34.049886 -118.253961
Dodgertown 34.073919 -118.242803
Griffith Park 34.039503 -118.249197
San Diego Int. Airport 32.733538 -117.189746

Note:
If you have Gmap module installed and enabled, then you will be able to use the Google Maps interface to select the location of a point.

3.    Create a new view. You can name the view anything you like. Choose Node as the View type.
 

4.    Add a filter to the view so you can only see nodes created with the Content Type we defined earlier.

 

5.    Add a Location Distance/Proximity filter.  
  • Chose Proximity Circular as the Operator.
  • Expose the filter.
  • Choose Postal Code as the Form mode.
 

6.    Add the following fields to the view: Node Id (Nid), Node Title.

7.    Add another field to the view, but this time use the Location group and choose Distance/Proximity.
  • On the configuration page for this field, choose the Units you want to use the do the searches (Miles or Kilometers) and set the Origin as Use Distance/Proximity filter.
 

8.    (Optional)Choose a Style for the view. In this case I have used a table style so it’s easier to see the results.

9.    Add a Page Display to the view so you can test the page in your browser.
  • Configure the Path to this page display. You can set it to something like “SearchByZip”.

10.    Save the view.

11.    Open in your browser the page you just created. In my case this is the URL:
http://localhost/drupal/SearchByZip
but yours may differ. You can now input some values for Postal Code and for Distance. You will see the following results.
 

As a side note, if you look at the address bar you will notice that the page uses arguments to do the search, so you can now use those arguments to call the page directly. The arguments are:
  • distance[postal_code]    
  • distance[search_distance]
  • distance[search_units]
Check out Oshyn's white paper on Drupal Multisite Installation options and Oshyn's white paper about Drupal and Social Media. 


Related Blog Posts

  • Drupal: Why Its Not Perfect...Yet
  • Drupal and Social Media:  A Flexible and Customizable Web Content Management Framework
  • Best Practices for Deploying Multilingual Websites with Drupal

Download the 
Performance Tuning Drupal White Paper.

Trackback Link
http://oshyn.com/BlogRetrieve.aspx?BlogID=1907&PostID=136961&A=Trackback
Trackbacks
Post has no trackbacks.

Pages: Previous Next

TwitterFacebookLinkedIn
ajax rotator

Blog Authors

Christian Burne Christian Burne
Subscribe Subscribe Subscribe Subscribe Subscribe
OTHER CATEGORIES
  • ALL

  • General

  • Web Content Management

  • Sitecore CMS

  • Open Text

  • Jahia

  • Drupal

  • EpiServer

  • SOA

  • Social Media and Mobile

  • Software Development

  • Visit Bloggers Profiles

RELATED POSTS
  • Introduction to Jahia's RSS Social Component Module
  • Using the Jahia Admin Tool
  • EPiServer Property Configuration with PageTypeBuilder
  • Sitecore Navigation Using Renderings
  • EPiServer Tab Assignment with PageTypeBuilder
  • Introduction to Jahia JCR Query Languages
  • Installation Tips for a Jahia Setup on Linux OS
  • What to Expect When Implementing a New CMS
  • Creating a Simple EPiServer Page Type Hierarchy Using PageTypeBuilder
  • PageTypeBuilder for EPiServer

WHITE PAPERS

    Web Content Management, Social Media, Content: Three Kings for Your Website Web Content Management, Social Media, Content: Three Kings for Your Website (846 KB)
    Companies pursuing online marketing success, including Social Media, can increase the power of their online presence with right strategy and technology to maximize online visibility and engagement. Download this FREE white paper on the WCM, Social Media, and Content triad.

    Drupal Performance Tuning Drupal Performance Tuning (1213 KB)
    In this Free White Paper Oshyn evaluates Drupal Performance Tuning, sharing the results of testing response time and Requests Per Second (RPS) that a server can hold before the response rate becomes unacceptable. In this paper you will learn about optimizing performance of a website through changes to settings and the server.

    Enterprise Drupal: Social Media, Mobile, and Rich Media in your Website Enterprise Drupal: Social Media, Mobile, and Rich Media in your Website (1015 KB)
    In this free WCM white paper, Oshyn examines advanced Drupal capabilities: Multisite Environment, Access Control and Security, Enhanced User Profiles, Custom Breadcrumbs, Mobile Support, Podcasts, Advanced Multimedia, Locations and Maps, Internationalization and Locale based content, Events and Scheduled Tasks, Rules Actions and E-Commerce Solutions.

    Drupal Multilingual Drupal Multilingual (636 KB)
    There are several multilingual installation methods for Drupal. In this free white paper Oshyn evaluates and recommends several methods of using Drupal Open Source CMS to manage websites in multiple languages.

    Drupal Social Media Drupal Social Media (1297 KB)
    Looking for an Open Source CMS to for “Social Media Optimization” of your website? Download this free white paper, “Drupal and Social Media”, to learn about the extensive Social Media this Open Source CMS offers to create a dynamic and engaging website and online community.

    Drupal Multisite Options Drupal Multisite Options (427 KB)
    There are several multisite installation methods for Drupal. In this free white paper Oshyn evaluates and recommends several methods of using Drupal Open Source CMS to manage multiple sites.

    Open Source CMS: Is It Right for your Organization Open Source CMS: Is It Right for your Organization (496 KB)
    In this free white paper, “Open Source CMS: Is It Right for your Organization?” we share an in-depth look at the pros and cons of using Open Source Content Management Systems (CMS) or Open Source Web Content Management (WCM) platforms. Oshyn helps clients select CMS/WCM solutions based on the specific requirements of each client.

    Affiliate Content Sharing in a CMS/WCM World Affiliate Content Sharing in a CMS/WCM World (273 KB)
    The Content Editors at your company have created GREAT content! Now how do you share it? In this Free white paper learn several methods for using a Content Syndication tool to automatically repurpose content and how Content Sharing can generate business value.

    Sitecore and Social Media - An Interactive Web Content Management Platform Sitecore and Social Media - An Interactive Web Content Management Platform (898 KB)
    Social Media has revolutionized how people interact with business. In this white paper Oshyn’s Lead Sitecore Developer, Prasanth Nittala, discusses key points from the perspectives of marketing and Web development that make Sitecore a compelling choice for engaging in Social Media via your website. This Sitecore white paper draws from Oshyn’s expertise as a certified Sitecore partner, helping organizations understand the distinct capabilities offered by Sitecore CMS.

    The Business Case for Leveraging Open Text Web Solutions Delivery Manager The Business Case for Leveraging Open Text Web Solutions Delivery Manager (451 KB)
    This free white paper explores the evolving needs of small and medium size businesses and explains how the Open Text Web Solutions Delivery Manager (formerly RedDot LiveServer) can help businesses build their brand, reputation, and client base. This white paper examines strategies, key points and tips to leverage the features available in Open Text Web Solutions (RedDot CMS) to achieve an impactful user experience and to maximize visitor engagement through a reliable and powerful implementation.

    Open Text Best Practices: Part One Open Text Best Practices: Part One (763 KB)
    Authored by Oshyn Senior Consultant, Adaeze Okorie, this free CMS white paper draws from Oshyn’s vast experience as an Open Text Certified Partner, in helping organizations define strategies to meet business goals while implementing Open Text Web Solutions (RedDot CMS). Specifically in this free white paper Adaeze Okorie discusses strategies, key points and tips to leverage the features available in Open Text Web Solutions (RedDot CMS) to achieve an effective, reliable and robust implementation.

    Improving the ROI of Business Software: Service Oriented Architecture from a Business Perspective Improving the ROI of Business Software: Service Oriented Architecture from a Business Perspective (398 KB)
    Software selection and technology decision making should no longer be left to the IT department alone. By gaining an understanding of Service-Oriented Architecture, business people outside of the IT department will be better positioned to maximize the ROI of the company's technology platforms. Download this free white paper to learn more.

    Getting Over Social Media Marketing Paralysis for B2B Getting Over Social Media Marketing Paralysis for B2B (2254 KB)
    Many companies are well aware that Social Media has become critically important to engaging audiences and promoting online "presence" while some wonder how to approach their C-level executives and prove that it is not all hype. With so many ways to engage in Social Media, how can they get buy-in and begin execution with so many different venues and tools available? Staying on the sidelines and becoming a latecomer might make it more difficult to create a convincing "social" presence. Put the ove

    Performance Tuning Open Text Web Solutions Management Server and Delivery Server Performance Tuning Open Text Web Solutions Management Server and Delivery Server (235 KB)
    If you've made an investment in Open Text Web Solutions (formerly RedDot) Web Content Management products, you’ve undoubtedly experienced performance issues. While every CMS requires tuning, Open Text Web Solutions - RedDot is especially susceptible to mis-configuration and poor performance as the out-of-the-box installation comes untuned and ready for Development Environments only. In this FREE white paper we share performance tuning expertise as an Open Text Certified Partner that has optimize

    The Business Case for Leveraging Open Text Web Solutions Within Higher Education The Business Case for Leveraging Open Text Web Solutions Within Higher Education (430 KB)
    Academic institutions have a long reputation for being slower to adopt new technologies for their audiences. However, many schools are taking serious steps in improving the online experience they are providing. This white paper explores the unique needs of the higher education market, applying new tools & trends and specifically how the Open Text Web Solutions’ Delivery Manager (formerly known as RedDot LiveServer) can be leveraged to achieve those goals.

    SEO Best Practices within a Content Management System SEO Best Practices within a Content Management System (712 KB)
    In this free white paper, we share Search Engine Optimization (SEO) tips and best practices to follow when implementing a Content Management System (CMS). Certain features and functionality will help your content editors make website changes faster while minimizing the risk of human error. Download this free white paper to learn strategies to improve search engine rankings.

    Best Practices for Sitecore CMS Best Practices for Sitecore CMS (1121 KB)
    Sitecore CMS is an extensive Web Content Management (WCM) platform for the mid-market. It offers reduced IT expenditures, a streamlined content lifecycle, and a return of content control to the subject matter experts. The newest incarnation of Sitecore CMS version 6.0 is a mature product that incorporates standard social media components such as wikis, blogs, RSS syndication and “e-mail a friend” features.

    Optimizing SEO in your CMS (WCM) Optimizing SEO in your CMS (WCM) (3108 KB)
    Oshyn's Christian Burne spoke in depth about SEO in CMS at the Gilbane San Francisco Conference on June 3rd, 2009. Christian discussed the pressues of keyword competition and how the CMS can add tremendous power to climbing Google SERPs and other search engine rankings. The presentation was later part of a featured article on CMSWire. We've made the presentation available in PDF format. Download now to learn more about strategies for using your CMS to optimize SEO.

    The Best CMS for You: Tips on How to Select Your Next CMS The Best CMS for You: Tips on How to Select Your Next CMS (909 KB)
    As websites continue to grow in size, features and functionality, the visitors to these websites are also becoming more demanding and have higher expectations than ever before. Companies who committed valuable time and resources to web strategies just five years ago are finding they must re-evaluate and explore new options as their content, features and online offerings must keep pace with the constant and rapid movement in the digital marketplace. For many of these companies, there is a strong.

    Oshyn Sample Voluntary Product Accessibility Template (VPAT) Oshyn Sample Voluntary Product Accessibility Template (VPAT) (741 KB)
    Section 508 requires that when federal government and agencies procure, develop, and maintain or use electronic and information technology (EIT), they must ensure that it is accessible and in compliance with Section 508 standards developed by the Architectural and Transportation Barriers Compliance Board (Access Board). Oshyn understands these requirements and has delivered reports like these countless times.

    Sitecore CMS Implementation Best Practices Sitecore CMS Implementation Best Practices (481 KB)

    Twitter Facebook LinkedIn Featured in Alltop
    question button image

     



    Captcha Image

    question button image
    Oshyn, Inc.17785 Center Court Drive N Cerritos, CA 90703    1.888.483.1770 newbusiness@oshyn.com
    2012 Copyright Oshyn. All rights reserved.
    • View Mobile Version
    • Terms of Use
    • Privacy Policy
    • Contact Us
    x
    • Contact Us Oshyn 1.888.483.1770
      Have Oshyn Call Me Have Oshyn call you
      Request Further Information Request further information

      Submit an RFP Submit an RFP