Project : School Marketing System

Web Development : Database Analysis & Management

Project Type: Web Development
Application: Database Analysis & Management
Client: Slim Goodbody Corporation


Description

The School Marketing System is an advanced web application designed to analyze and filter a database of over 130,000 public and private schools in the United States. The Slim Goodbody Corporation currently uses it to locate profitable venue locations and focus its marketing campaign for the company's nation wide educational performances. The system is for private use at this time. Feel free to contact me if interested.

The School Database

The 130,000 school database was created by exporting official data from the National Center for Educational Statistics (NCES). The public NCES tools allow the data to be exported as Excel files. I then wrote scripts to reimport, optimize and divide the data into a custom MySQL School database.

Database Content Overview

  • General School Information
    • Public Schools (100,917) & Private Schools (29,492)
      • Name, Address, City, State, Zip, Postal Code
      • Longitude, Latitude ( Used for proximity searches and visually mapping )
      • Phone, Fax
    • Total Students
    • Number of Students Per Grade Level Per School
    • Teacher / Student Ratio
    • Charter, Magnet, Shared Status
    • # Students in Free Lunch
  • Related Tables
    • Level ( Primary, Middle, High, Other )
    • Locale ( Large City, Town, Rural, etc. )
    • Type ( Regular, Montessori, Special Education, etc. )
    • Operation Status ( Operational, New, Reopened, etc . )
    • Orientation ( Roman Catholic, Church of Christ, Jewish, etc )
    • Association ( None, Accelerated Christian Education, Solomon Schechter Day Schools, etc. )

I also gathered and imported other database information including geographic economic statistics and district and county information. The NCES had longitude and latitude points for public schools but did not have them for private, so I used a batch geocoding script to calculate the coordinates from their addresses. Coordinates were required for proximity searches and displaying schools on a Map.

The database maintains the NCES school, district and county unique id's to allow updates to the data in the future.

School Data Filters

The system provides data filters to generate lists of schools with particular properties. The filters can be combined and tweaked to provide very different and specific lists. Some examples of the type of filters you could apply include:

  • Primary and Elementary Schools in Maine and New Hampshire with greater than 500 students.
  • Schools within X mile radius of Y Address.
  • All Schools in the United States considered to be in a Large Central City with the Per Capita above $30,000
  • All schools that match the keyword "Max"

Once a list is generated it can be saved to be opened again at a later date or exported into a excel file perhaps to be sent to your mailing service.

Generated lists can be excluded from new lists. So for example, you could save a list of schools within a 5 mile radius of a city in Maine and then run a new list of Maine excluding the schools in the previous list.

Application Screen Shot

School Marketing Filters
Request Your Quote

Submit your project for an evaluation, cost and time estimate.

News & Events

June 4th, 2012

I am working on in-house projects.

March 17th, 2011

Maine Trail Finder wins an American Trails Website Award.

American Trails Award

November 8th, 2010

Launched my second personal e-venture Planet Minecraft today! Creative community of gamers sharing custom content created in and for an indie game called Minecraft.

September 10th, 2010

Developing a networking service bartering website due to come out next year.

June 18th, 2010

Launched Maine Trail Finder today! Finding trails to hike, snowshoe, ski, or mountain bike in Maine just got a whole lot easier!

June 1st, 2010

Camp Sunshine raised $250,000 by selling 3,299 inscribed bricks. The bricks are now a walkway and they needed a way for donators to locate their particular brick.

May 20th, 2010

March 10th, 2010

Developing several projects:

  • Interactive Map & Community Website for finding Maine trails for hiking, biking, snowshoeing and skiing
  • National Bartering Website for connecting individuals to exchange services
  • Social site for promoting awareness & discussion of the Anglophone history.
  • Two more University of Maine Department website redesigns.

December 18th, 2009

Launch of Land of First Contact Website - An interactive map of historical locations in Northern Newfoundland.

November 28th, 2009

Updated portfolio with 8 projects:

September 2nd, 2009

Launched the redesign of the University of Maine's School of Engineering Technology

August 14th, 2009

The Androscoggin Land Trust website launched today! Androscogginlandtrust.org

August 7th, 2009

Phase 1 of VisitAndroscoggin.com was announced today.

August 1st, 2009

Updated the portfolio with 4 completed projects. See below for the specific links. More to come.

June 30th, 2009

I completed several projects over the last few months including:

February 13th, 2009

Working with the Androscoggin Land Trust to develop and design a new dynamic website and custom Google Maps solution.

January 14th, 2009

Launched website for Parallax Expressionist Artist, Megan Jean Morris.

December 18th, 2008

Finished e-commerce web development & design of the Slim Goodbody Kids Health & Fitness Store.

November 16th, 2008

Completed web application development for an advanced Tour Management System.

October 20th, 2008

Released redesign of the Electrical & Computer Engineering Departmental Website at the University of Maine.

August 15th, 2008

Developing a Booking Agent Web Application to manage customer orders for multiple actors performing shows across the country. Details coming soon.

June 1st, 2008

I am now located in Portland, Maine.

May 10th, 2008

Developed a School Marketing System (SMS) for national educational performances featuring powerful analyzing features on a custom database of over 130,000 schools.

April 28th, 2008

Released Tour de Baccalieu, the interactive map of New Foundland's business and tourism locations.

March 30th, 2008

RightPlate.com Released! Create custom laser engraved electrical plates online for your home or business. Responsible for site conceptualization, design and development including the Create-A-Plate flash application and custom e-commerce system. Joshua Bolduc of PartDigital.com responsible for Admin system.
View Site >

Testimonials

"The Internet is very important to my work, I travel the world to bring my music to people and the computer keeps them in touch with my manager and booking agent. I have found many of my long lost friends and past band members this way. The clubs can find me too."

- Eddie Kirkland, Blues Musician, Geogia, USA
View More Testimonials

Project Sample

Web Development : Tourism  Website & Interactive Map Visit Androscoggin

Tourism Website & Interactive Map
Why should you visit the Maine Androscoggin County?

Web Development : E-Commerce Solution Baby's World Online

E-Commerce Solution
Baby & Teen Store

Web Development : Library Informational Website Phillips Public Library

Library Informational Website
New site for a recently digitized library in Maine.