Web Map Showing Chicago Neighborhood Crime Trends and Statistics

In this post I provide a behind the scenes look and quick explanation of how I prepared and mapped Chicago crime data using a Content Management System (CMS) specially designed for GIS data. The system allows you to create, manage, collaborate and share your maps, apps and data with groups you setup or via social media. The hallmark of any CMS is access control, the ability to create user roles, set permissions, and enable better use of resources by making content available to those who need them most. I attempt to demonstrate these concepts in this short blog. At the end of the blog, there is a link to the crime web map where you can access and use the resources through the CMS where you can then modify the map for your own purposes.

Web Map Showing Chicago Neighborhood Crime Trends and Statistics

I created this map several years ago as one of three submissions to a technology contest called ‘Apps for Metro Chicago’ (#A4MC on Twitter), no I didn’t take any of the prize money but I learned a lot and had some fun participating in the contest. The web map is built with ESRI’s ArcGIS cloud-based technology. The crime data is from the Chicago Police Department’s crime data API, which is downloadable from the City of Chicago’s open data portal. There are approximately 5 million records represented on this map.

Data Preparation

Before I was able to create the web map, I had to prepare the data for mapping at the neighborhood level. I used professional GIS desktop software to do this, figure 1. This phase took about a month. I started with an Excel spreadsheet, performed many spatial overlay queries on the data to allocate each crime record to its corresponding Chicago Neighborhood.

Geospatial Information System

Further data analysis created new fields to store the neighborhood crime totals by type of crime. These fields were used for displaying the totals on the web map’s pie chart in figure 2.

Map Design

The next phase was linking the data to and designing the web map, figure 2. The web map is highly interactive, using popup window graphs to show crime trend data over a ten year period in popup window 1, and a click-able pie chart showing the total number of crimes by type in each neighborhood in popup window 2 (hint: look for the small left/right facing arrows). The map itself is designed as a choropleth thematic map that color codes polygons to convey information about the area, neighborhoods in this case (a thematic map is a type of map especially designed to show a particular theme connected with a specific geographic area). The map’s numeric values representing the total number of crimes in a neighborhood consist of four value intervals displayed on the map in varying shades of blue.

Demo Map

Geospatial Information System

Now try out the map for yourself. Follow the link below and then the instructions to open the CMS’s built-in map viewer. After the map opens, you’ll be able to use the map as is, or modify it, creating your own mashup by adding data and maps shared by others. Look for the ‘Modify Map’ link in the upper right-hand corner. Start by changing the basemap choosing one of the included aerial/satellite imagery backgrounds, topographic or street maps. The topographic basemap includes authoritative content provided by a global online community. Next, you can add additional data by searching for and adding new data layers (for example Census demographic data, business locations, crime indexes, etc.) to the map. You can even add your own data from an Excel spreadsheet and change map symbols through the built-in map viewer. You can then share your modified version of the map with groups within your organization or using social media. You can even use your new version of the map embedded in your own website or blog. Look for the share link then the Embed in Website link. Here you can configure the settings for your own mapping application as I’ve done, shown below.

View: Web Map Showing Chicago Neighborhood Crime Trends and Statistics
Note: clicking this link will take you away from this website.

Web mapping application

When you’re ready to discuss your project, give us a call!
+1 (847) 635-4752






Today’s Mantra for the Web and Your Business Needs to be Mobile First

Moving forward, your business presence on the Web requires a mobile Web site, optimized for location and social media and powered by a modern Content Management System (CMS). Your customers and clients will want to find and interact with your Web site and with you while on-the-go, this includes sharing their findings with others via. social media. With a modern responsive Web design your one Web site can meet both desktop and mobile needs.

A recent survey by technology research firm “Net Market Share” reports that more than 90 screen resolutions are in use when you count up all the desktop, table, smartphone, and related mobile devices in the world. Depending on your project’s requirements, Responsive Web Design (RWD) would allow you to build one Web site that would look good on all devices.

Read about the RWD concept in this seminal article by the man who coined the term, Ethan Marcotte at the Web site A List Apart.

Responsive Web Design

Responsive Web design is illustrated in the graphic below. The key to making responsive Web design work is: fluid layouts, flexible images, and media queries. In landscape orientation on an Apple iOS iPad, our Web site looks as it would on any laptop or desktop with the typical horizontal menu system (see red arrow). Switch to portrait orientation on the same Apple iOS iPad and the menu system collapses to better fit the smaller form of the device.

The reconfiguration that took place provides a much improved user interface and a much more pleasant experience for the end-user of the Web site. When the mobile device is a smartphone, a responsive design is even more compelling, integrating seamlessly with the device maker’s unique user interface component.

In this example we see the Apple iOS iPhone’s “Picker” rotary user-interface component to present the menu system to the end-user. What does this do? It presents your business in a more positive light, it shows you care about your Web site’s visitors, and shows that you’re a progressive, tech savvy business.

Content Management System (CMS)

Being mobile and responsive also means that you’ll need to be more active | proactive in the day-to-day operations of your Web site. In order for you to quickly respond to rapidly changing business situations, you need to be in control of your Web site content.

Adhere to these 4 design fundamentals: 1. Simplicity 2. Usability 3. Quick Load 4. Focused Content.

With a CMS you can easily login and manage your content and communicate with your clients and customers through contact forms.

The key to all of this is your CMS infrastructure features Click >>See our list of the features that come with our CMS solutions.

In summary

The desktop version of your Web site needs to reformat for mobile devices;
You need a modern CMS to manage the backend; this will liberate you from unnecessary technical support;
Your social media activities need to drive traffic to your Web site as social media signals play a more important role for search results;
Where to start? Use a responsive theme for a Drupal CMS; and
Adhere to these 4 design fundamentals: 1. Simplicity 2. Usability 3. Quick Load 4. Focused Content.
We can build your CMS for mobile, and optimized for social media.

Call for a free estimate when you’re ready.
Ross Capaccio
+1 (847) 635-4752




Marketing your APP

Marketing your Apps – Getting an app into the marketplace is a tough task. The whole process of building and submitting to Apple takes a long time.

Apps submitted to Apple are rejected for all sorts of reasons, not always technical. My Garden Journal App was rejected just once because of the graphics used that show up in the Apple App Store where you purchase the app.

After your app finally makes it into the app store, it’s only natural that you want to see your first downloads, validation for all your hard work and bragging rights, telling all your friends that you made your first sale of your $1.99 app (which Apple takes 30%) and that now you can kickback and watch your dashboard as the $$ roll in-NOT SO!

Marketing, yes, marketing the age old art of advertising and salesmanship. Guess what, people are cheap, won’t even spend a $1.99 for for a complex piece of software that they know they need. So what do you do? Work as as hard marketing the app. Since the launch of the Garden Journal app, I’ve spent hundreds of hours on social media building a community, ad campaigns and direct marketing. Don’t get me wrong, the time was necessary and well spent. I’m just saying anticipate spending a lot of time and money on an app project. After my first two weeks of setting up social media accounts and experimenting with the various best practice marketing techniques, I can only say that Internet marketing is amazing. At no cost to me I ‘m now communicating directly with serious gardening/landscape design types all over the World, it’s actually very cool.

Even if you don’t sell your app at first, what I’ve found is that people all over the World are basically the same, friendly and love to give feedback, which is fine because the first step in the marketing process is building awareness for your product. Casual conversation on social media is need to build a community for your app. Twitter has been an invaluable tool for building a community around the app. The next most valuable digital ad platform has been YouTube; I once read that if you can’t draw a crowd with a 30 second spot ad on YouTube, you need to re-thing your app.

Taking this advice to heart, I produced a 30 second spot ad (actually 29 seconds) and created a YouTube channel for the app. At first I used Google AdWords to create an ad campaign with the objective to have people click a link to watch the YouTube video. At the same time I joined the Google Partners program in order to monetize my videos. This arrangement places ads in my video. The length of the video is important. Using YouTube analytics I discovered that people are watching the full 30 second ad, but the average watch time on a (similar) one minute app features video falls off quickly. Lesson learned: there’s a delicate balance between marketing and closing the deal.

Internet Marketing

In Internet marketing there’s something called the conversion funnel that is split into four steps:

Desire, and
Each step requires that your conversion objectives will differ, they have to, you’re trying to navigate a completely different set of emotions at each step. If you ever do an app project you’ll soon learn that each of the social media platforms has its own particular strength corresponding to the 4 stages of the conversion funnel. I’m aggressively using Twitter, YouTube, Facebook, and to a lesser degree Instagram and Pinterest. And yes, you have to have a Web presence for marketing the app. I’m using WordPress. Here is a mind map with the details.

If you have any questions, please feel free to contact me.

(847) 635-4752