Cover Music

Here are some of my favorite cover bands. Altering an existing work enough to make it your own while still respecting the original is a fine line to walk.

Since these are all covers, I’ve added a separate link to each original, after each video, marked by a ***.

These are “my” bands. The bands that helped shape who I am, roughly in order of how much they mean to me.

Dave Mattingly: The Musical, Part 9

  • Nouvelle VagueNouvelle Vague

Go back to Part 8: Punk or on to Part 10: Collegiate A Cappella

Tech Community Events

“In the spring, a young man’s fancy turns to thoughts of tech…”

That’s not quite how Tennyson wrote it, but he would have, if he’d lived in Louisville at a time when coders, hackers, designers, and other geeks and nerds offer such a remarkable smorgasbord of creative techie activities. That’s my story, anyway.

Here are a few specific events that you can become a part of, plus some other cool ones further down the screen.

Code Across

Code Across America

The fifth annual Code Across is a volunteer event for civic hacking.

What is civic hacking, you ask? It’s “hacking” in the good sense, to improve something, not to break down. Code for America

Over the course of one day, coders and designers pitch ideas and settle into teams. They create an app, a site, or something else. At the end of the afternoon, they present what they’ve created and give it away to the world. There are even snacks and prizes.

It’s a great way to make friends, learn a new approach, work together, create or solve something, gain experience, and help the community.

Some cool projects we’ve done in the past include:Code Louisville

  • a pet adopter that helps you find the animal you want at a shelter close to you
  • a restaurant recommender which takes into account health scores, nearby crime, and reviews
  • a park amenities locator, to find the nearest potty while you’re on that hike

This year, the event will be held at Code Louisville, 252 E Market St, Louisville, KY 40202.

Keep June 4, 2016 open on your calendar for the National Day of Civic Hacking, also a Code for America event.Civic Data Alliance

Our local “Code for America Brigade” is the Civic Data Alliance. We advocate to make government data open and transparent, so that everyone can learn from it. We also host hackathons and educational sessions.

Startup Weekend

Startup Weekend

Louisville’s Startup Weekend is a twice annual volunteer event for business idea creation.

Similar to Code Across, people gather, pitch ideas, form into teams, work, then show their results at the end.

The difference here is that the projects tend to be entrepreneurial, with an ongoing sustainable profit plan. This one is 54-hours long (Friday afternoon through Sunday afternoon), with judges and valuable prizes. On Sunday, teams show off their creations to compete for valuable prizes.

Our local Startup Weekend has gotten some national attention. Lat year, more women than men participated. And the winning team was led by a high school girl!

Projects we’ve had in the past include:

  • Moov — Uber for pickup trucks
  • MixxThis — an easier way to process your drink orders
  • Foodinary — an app to explain the ingredients in your meal

This year, the event will take place at the UofL School of Business.

A lot of the movers and shakers of the local business and tech scenes help out with and attend these.

There is a modest fee to attend this one, but I believe it’s well worth it. I’ve attended four startup weekends so far.

Here’s my post about last year’s event.

Other Events

Here are even more ways that you, too, can join in on the fun.

Leadership

  • 3/11 – Nonprofit Leadership Network
    • American Printing House for the Blind, 1839 Frankfort Ave
    • If you work with any volunteer or charity group, the KNN can keep you abreast of resources, policies, and happenings.

 Social/Networking

Learning/Sharing

  • 2/26 – Lean Coffee
    • Press, 252 E Market St
    • Lean Coffee is a cool way of meeting in which the agenda is created during the meeting itself.

Robots/Drones

Games/Entertainment

  • 3/4-3/6 – Louisville Arcade Expo
    • Ramada Plaza, 9700 Bluegrass Parkway
    • Play Pac-Man, pinball, and hundreds of other games all weekend! Proceeds go to the children’s hospital.

Fandom/Comics/Gaming

  • 3/26 – Random Fandom Con
    • Louisville Public Library, 9725 Dixie Highway
    • Meet other fans of comics, anime, sci-fi, fantasy, horror, and other fun nerdy pursuits.
  • 4/8 – ConGlomeration
    • Ramada Plaza, 9700 Bluegrass Parkway
    • ConGlomeration is Louisville’s oldest and friendliest science fiction con. Highly recommended. The weekend includes expert panels, costumes, gaming, music, and food.

Shopping

Keep in Touch

Want to stay in the loop about events like this? There are several ways that you can do that.

 

Greater Than Jesus

I’m a Christian, and sometimes a teacher/preacher.Greater

This sermon discusses what is better than and greater than Jesus.

Bigger Than Jesus

In 1966, John Lennon said that the Beatles were more popular than Jesus.

There’s a riddle that goes:

What is greater than God,
and worse than the devil?
The rich need it,q-mark
the poor have it,
and if you eat it, you’ll die?
(click here for the answer)

Discussion Questions

  • What are some of the biggest (most important) things in your life?
  • If you could rearrange your priorities, what would you change?

Apostle Miracles

The Apostles were doing amazing things before they had received the Holy Spirit.

Jesus called his twelve disciples and gave them authority to cast out evil spirits and to heal every kind of disease and illness. (Matthew 10:1)

They drove out many demons and healed many sick people. (Mark 6:13)

John, don’t be such a tattletale.

But the Twelve didn’t have a corner on the market.

John said, “Teacher, we saw someone driving out demons in your name and we told him to stop, because he was not one of us.” Jesus answered, “Do not stop him, for no one who does a miracle in my name can say anything bad about me, for whoever is not against us is for us.” (Mark 9:38-40)

The Lord appointed seventy-two others and sent them two by two. “Heal the sick there and tell them the kingdom of God has come.” The seventy-two returned with joy saying, “Lord, even the demons submit to us in your name.” (Luke 10:1,9,17)

Your shadow is a confirmation that light has traveled nearly 93 million miles unobstructed, only to be deprived of reaching the ground in the final few feet thanks to you.

After Christ died, rose, and ascended, they upped their game.

The apostles performed many signs and wonders among the people. (Acts 5:12)

Even Peter’s shadow got into the act. People lined up just to get close enough to Peter that his shadow would touch them.

People brought the sick into the streets and laid them on beds and mats so that at least Peter’s shadow might fall on some of them as he passed by. (Acts 5:15)

Paul’s groupies did Peter one better by sending Paul’s used handkerchiefs away to cure people. Paul didn’t even need to be in the neighborhood.

When handkerchiefs or aprons that had merely touched Paul’s skin were placed on sick people, they were healed of their diseases, and evil spirits were expelled. (Acts 19:12)

Well, I guess as long as they got a referral from their primary physicians, and their insurance covered it…

They even rose the dead back to life.

In Joppa there was a disciple named Tabitha; she was always doing good and helping the poor. About that time she became sick and died, and her body was washed and placed in an upstairs room. Lydda was near Joppa; so when the disciples heard that Peter was in Lydda, they sent two men to him and urged him, “Please come at once!”
Peter went with them, and when he arrived he was taken upstairs to the room. All the widows stood around him, crying and showing him the robes and other clothing that Dorcas had made while she was still with them.
Peter sent them all out of the room; then he got down on his knees and prayed. Turning toward the dead woman, he said, “Tabitha, get up.” She opened her eyes, and seeing Peter she sat up. He took her by the hand and helped her to her feet. Then he called for the believers, especially the widows, and presented her to them alive. (Acts 9:36-41)

But not everyone on the receiving end of an Apostle’s miracle was happy about it.

“You are going to be blind for a time, not even able to see the light of the sun.” Immediately, darkness came over him, and he groped about, seeking someone to lead him by the hand. (Acts 13:11)

A man named Ananias, with his wife Sapphira, sold a piece of property, and kept back some of the price for himself, with his wife’s full knowledge, and bringing a portion of it, he laid it at the apostles’ feet. But Peter said, “Ananias, why has Satan filled your heart to lie to the Holy Spirit and to keep back some of the price of the land? “While it remained unsold, did it not remain your own? And after it was sold, was it not under your control? Why is it that you have conceived this deed in your heart? You have not lied to men but to God.” And as he heard these words, Ananias fell down and breathed his last; and great fear came over all who heard of it. The young men got up and covered him up, and after carrying him out, they buried him.
Now there elapsed an interval of about three hours, and his wife came in, not knowing what had happened. And Peter responded to her, “Tell me whether you sold the land for such and such a price?” And she said, “Yes, that was the price.” Then Peter said to her, “Why is it that you have agreed together to put the Spirit of the Lord to the test? Behold, the feet of those who have buried your husband are at the door, and they will carry you out as well.” And immediately she fell at his feet and breathed her last, and the young men came in and found her dead, and they carried her out and buried her beside her husband. And great fear came over the whole church, and over all who heard of these things. (Acts 5:1-10)

But that was just the beginning.

Whoever believes in me will do the works I have been doing, and they will do even greater things than these because I am going to the Father. (John 14:12)

Whoever believes will do even greater things.

Even greater things.

We as believers can do even greater things than those.

Discussion Questions

  • What miracles has God performed in your life?
  • What great things can we do in Jesus’ name?

Better Than Jesus

Jesus repeatedly told his followers that he wouldn’t be with them forever, but that it would be worth it.

Jesus said, “If I go, I will prepare a place for you. I will come back and take you to be with me that you also may be where I am.” (John 14:3)

It would have been amazing to be one of Jesus’ original followers, and to know him personally when he walked the earth as a man.

But there’s something even better than that.

Jesus told them, “It is best for you that I go away. Because if I don’t, the Advocate won’t come. If I do go away, then I will send him to you.” (John 16:7)

It is best for you that I go. There is something better than God walking along alongside us after all — and that’s to have God inside us.

“I will ask the Father, and he will give you another Advocate, who will never leave you.” (John 14:16)

“The Spirit of truth will glorify me because it is from me that he will receive what he will make known to you.” (John 16:14)

“The Advocate, the Holy Spirit, will teach you all things and will remind you of everything I have said to you.” (John 14:26)

Sort of like being a person of interest in a murder investigation, if television crime dramas are to be believed.

“I will send the Holy Spirit, just as my Father promised. But stay here in the city until the Holy Spirit comes and fills you with power from heaven.” (Luke 24:49)

Jesus knew that the Spirit was so important that He didn’t want the apostles to even leave town until the Spirit had come.

The Holy Spirit

The Holy Spirit has the powers of God, but takes up residence inside our own hearts.

He breathed on them and said, “Receive the Holy Spirit. If you forgive anyone’s sins, their sins are forgiven; if you do not forgive them, they are not forgiven.” (John 20:22-23)

Let the Holy Spirit guide your lives. Then you won’t be doing what your sinful nature craves. This love surpasses knowledge. You will be filled to the measure of all the fullness of God. (Galatians 5:6, Ephesians 3:9)

The Spirit can bestow us with many gifts.

We have different gifts, according to the grace given to each of us. If your gift is prophesying, then prophesy in accordance with your faith; if it is serving, then serve; if it is teaching, then teach; if it is encouraging, then encourage; if it is giving, then give generously; if it is leading, lead diligently; if it is mercy, do it cheerfully. (Romans 12:6-8)

To one the Spirit gives wisdom, to another knowledge, to another faith, to another healing, to another miraculous powers, to another prophecy, to another discernment, to another speaking in different tongues, and to another interpretation of tongues. (1 Corinthians 12:8-10)

The Spirits help us in many ways:The Holy Spirit

  • Knows all things (1 Corinthians 2:10-11)
  • Prays for us (Romans 8:26-27)
  • Guides us (John 14:16-17, 26)
  • Decides for us (1 Corinthians 12:7-11)
  • Lives with us and in us (John 14:16-17)
  • Fills us with living water (John 7:37-39)
  • Shows Jesus to us (John 15:26)
  • Produces holiness in us (Galatians 5:16-25)
  • Transforms us (2 Corinthians 3:18)
  • Gives us gifts (Romans 12:4-8; 1 Co 12)
  • Grieves for our sin (Ephesians 4:30)

But it’s not a free ride. As that last item shows, the downside is that we can hurt his feelings.

Discussion Questions

  • What spiritual gifts do you have, and how do you use them?
  • What are some ways that the Holy Spirit worked through you?

Download

You can download the PowerPoint file here.

 

Punk

Here are some of my favorite punk bands. Most of these are the newer punk revivalists, pop-punk, which I’ve gradually come to live more than the original genre.

These are “my” bands. The bands that helped shape who I am, roughly in order of how much they mean to me.

Dave Mattingly: The Musical, Part 8

  • RancidRancid
    • Known For: Time Bomb
    • Memories: Back in 2001, my wife interpreted for the deaf at the Billy Graham Crusade in Louisville, so I was there with her for the whole multi-day event. Since I’d hear the same things over the course of those days, I’d often wander around. While strolling the promenade, I
      saw a teenager (presumably dragged along by a family member as he pretty obviously didn’t want to be there) wearing a Rancid shirt. I eagerly talked with him about the band, and asked if he’d ever heard their cover of the “Gilligan’s Island” theme song, which he hadn’t. It totally blew his mind that someone else at a Billy Graham event was a fan of the band.
    • Favorite Songs: Fall Back Down, Ruby Soho, Gilligan’s Island, Roots Radicals, MemphisTransplants
  • Public Image LtdPublic Image Ltd
    • Known For: (This is Not a) Love Song
    • Memories: PIL is best known for spinning off from the Sex Pistols, and John(ny Rotten) Lydon’s lyric “anger is an energy” still rings true, and helps to spur me into action. Whereas the Pistols were raw and angry, Public Image was smoother and stylized, but still with some crazy in the mix.
    • Favorite Songs: Rise, Seattle

Go back to Part 7: Rap and Hip-Hop or on to Part 9: Covers

Rap and Hip-Hop

Here are some of my favorite rap and hip-hop bands, with maybe a little funk and soul mixed in.

These are “my” bands. The bands that helped shape who I am, roughly in order of how much they mean to me.

Dave Mattingly: The Musical, Part 7

  • Beastie BoysBeastie Boys
    • Known For: Fight for Your Right to Party
    • Memories: When I was a DJ, record labels would always send us cool stuff in an effort to encourage us to promote their bands. Back when Beastie Boys was brand new, we got some shirts along with other merchandise. When I wore that shirt to their concert, someone offered me $50 for it. As it turns out, that was the same shirt that the crew wore, so it made me look like I was with the band. I also was wearing that shirt (complete with a rude saying on the back) when I met my wife.
    • Favorite Songs: Girls, Rhymin’ and Stealin’, She’s Crafty, Sabotage, Remote Control, IntergalacticFishbone
  • Fat Boys
    • Known For: All You Can Eat
    • Memories: I have the Fat Boys to thank for my love of beatboxing. I’d heard rap before, and enjoyed the rhyme-throwing aspect of it, but hadn’t appreciated the possibilities of making goofy noises as a musical instrument until Human Beat Box. RIP Buff Love.
    • Favorite Songs: Human Beat Box, Human Beat Box Part III, The Twist, WipeoutGorillaz
  • De La Soul
    • Known For: Me Myself and IDe La Soul
    • Memories: De La Soul were sometimes pegged as hip-hop hippies thanks to their positive messages focusing on peace and love. I like that about them. They’re light, fun, and uplifting.
    • Favorite Songs: Tread Water, Three is a Magic Number

Okay, so it seems my favorite hip-hop music is the kind that doesn’t take itself very seriously. Which is generally true for me across all music genres, and indeed all walks of life.

Go back to Part 6: Psychobilly or on to Part 8: Punk

Cool Job: Floor Show

Rug

Rug

I’ve done a lot of things for a living over the years, and after working with outer space and virtual reality I dove into the creative half of my brain. I was an artist before switching to math and tech, and I combined my art background and my programming background by working at Khazai Rug Gallery.

Cool Job, Part 3: Floor Show

The oriental rug industry certainly seems like an odd fit for developing custom software, but there was a small market of companies that needed to be able to design rugs on the computer quickly. This was back in the days of Windows 3.1. The software was essentially a cleverly disguised MS Paint, with some custom add-ins that we’d written.

Zoom

Close-Up

What we created was a very primitive version of the modern photoshop. It could do a variety of common image tricks, and some that were more useful for rugs than for general images like copying and flipping rug sections (take take a corner design and mirror it into a full rug), simplify the colors (to use fewer yarn colors), and such. It could even randomize some of the threads to create “mistakes” in the weaving, making them more quaint and obviously hand-woven, right?

The end result was that the software would spit out a “rug map” — the thread-by-thread instructions for how to weave that particular rug. The rug map was made up of large colored squares, that individual craftsmen would use as a guide. If you’ve ever seen a cross-stitch pattern book, it’s sort of like that.

Map

Rug Map

It was cool to travel to various rug design firms and demo the software. (I found out that New York City has a “rug district” where everybody who’s anybody in rug design had to have a building. Who knew?) I even got to use my art skills as a contractor designing rugs for a few weeks at such a place in Atlanta.

Mad Skillz

Thanks to writing this software, I gained the geek skill to look at any color, and take a pretty good guess to its hex value.

Color Chart

Roses are FF0000,
Violets are 0000FF

In a computer, colors are based on red/green/blue combinations, with values going from 0 to 255 (or 00 to FF in hexadecimal terms). So pure red would be FF0000, green would be 00FF00, and blue 0000FF. White is FFFFFF (all the colors at once), and black is 000000. All other colors fall somewhere between 00 and FF in those three

My color-hexing skill has waned over the years, but by guesstimating the RGB makeup of a color, I can still come relatively close much of the time. I’m told that many professional artists and designers can do the same thing with pantone colors (another way to uniquely identify a color).

Full Circle

The original way of writing computer software was through a series punch cards, similar to the way that a player piano plays music from rolls.

Loom Punch Cards

Loom Punch Cards

What’s cool is that the idea of punch cards actually came from the weaving industry. So that means the software I wrote could be used to control the predecessor of computers. As Homer & Jethro once sang, “I’m My Own Grandpaw.”

The Louisville Science Center has a kiosk showcasing that software project. The similarity between pixels and thread maps is a strong one, and finding the right match from one technology to another is still a force for innovation. “I think I see a pattern here.”

Go back to Part 2: Wolf3D or on to Part 4: Corporate Agent

The Greatest of These is Love

I’m a Christian, and sometimes a teacher/preacher.

This sermon is my take on the Ephesians advice about marriage.

Biblical Marriage

“Wives submit to your husbands” has been a highly disputed (and often misused) piece of scripture throughout the centuries.

Wives, submit yourselves to your own husbands as you do to the Lord. For the husband is the head of the wife as Christ is the head of the church, his body, of which he is the Savior. Now as the church submits to Christ, so also wives should submit to their husbands in everything.

Husbands, love your wives, just as Christ loved the church and gave himself up for her to make her holy, cleansing her by the washing with water through the word, and to present her to himself as a radiant church, without stain or wrinkle or any other blemish, but holy and blameless. In this same way, husbands ought to love their wives as their own bodies. He who loves his wife loves himself. After all, no one ever hated their own body, but they feed and care for their body, just as Christ does the church — for we are members of his body. “For this reason a man will leave his father and mother and be united to his wife, and the two will become one flesh.” This is a profound mystery—but I am talking about Christ and the church. However, each one of you also must love his wife as he loves himself, and the wife must respect her husband. (Ephesians 5:22-33)

This passage in Ephesians is written using a literary device known as a chiasm.

A chiasm uses a reversed repeating pattern. Instead of A B A B, a chiasm uses A B B A (crossing the last line so that the arrows form an X, the Greek letter chi).

Finish These Chiasmschiasm

  • All for one and…
  • Ask not what your country can do for you…
  • People don’t care how much you know until…
  • I’m stuck on Band-Aid…
  • If you can’t be with the one you love, honey…
  • Whoever exalts himself will be humbled but…

A Noah Chiasm

Noah and his sons (Gen 6:10)
___All life on earth (6:13:a)
______Curse on earth (6:13:b)
_________Flood announced (6:7)
____________Ark (6:14-16)
_______________All living creatures (6:17–20)
__________________Food (6:21)
_____________________Animals (7:2–3)
________________________Entering the Ark (7:13–16)
___________________________Waters increase (7:17–20)
______________________________God remembers Noah (8:1)
___________________________Waters decrease (8:13–14)
________________________Exiting the Ark (8:15–19)
_____________________Animals (9:2,3)
__________________Food (9:3,4)
_______________All living creatures (9:10a)
____________Ark (9:10b)
_________No more floods (9:11)
______Blessing on earth (9:12–17)
___All life on earth (9:16)
Noah and his sons (9:18,19a)

The bracketing verses repeat the same topics (Noah and his sons appears at the top and the bottom), but sometimes negate them (waters increase / waters decrease), yet still complete the pairing.

An Ephesians Chiasm

Wives, submit to your own husbands as to the Lord
___For the husband is head of the wife, as Christ head of the church
______He himself is the Savior of the body
_________But as the church is subject to Christ, and wives to their husbands
____________Husbands, love your wives just as Christ also loved the church
_______________That He might sanctify her, having cleansed her by the word
__________________That he might present to himself the church in all her glory
_______________She would be holy and blameless, having no spot or wrinkle
____________So husbands ought to love their wives as their own bodies
_________No one hates his body but nourishes it, as Christ does the church
______Because we are members of his body
___For this cause a man shall cleave to his wife, and the two become one flesh
______This mystery is great, but I refer to Christ and the church
___Nevertheless, let each among you also love his own wife even as himself
And the wife is to respect her husband

The chiasmus verse (the “centers” of the x) is the crux of the passage; the theme that ties together the entire thought.

That he might present to himself the church in all her glory
This mystery is great, but I refer to Christ and the church

In this example, Paul wrote two chiasmus verses. He must have gotten an A+ on his essay test. (Or an aleph plus.)

So, wives should submit to their husbands because husbands are the head because Christ is the head who makes the church holy because he loves us so that He and His pure bride can give themselves to each other.

Submit to One Another

The Ephesians chiasm is prefaced by this verse:

Submit to one another out of reverence for Christ.

Submit is translated from the Greek ὑποτασσόμενοι (hupotasso) which has two meanings.

  • Military – to subordinate
  • Civilian – to cooperate

Wives, submit yourselves to your own husbands as you do to the Lord. 

Husbands, love your wives, just as Christ loved the church

Looking at the two commands for submitting and loving, each comes with the same qualifier – as.

Give, and it will be given to you. With the measure you use, it will be measured to you. (Luke 6:38)

Whatever you do, work at it with all your heart, as working for the Lord! (Colossians 3:23)

Do you want your spouse to give more of themself to you? Give more first.

Wives, submit yourselvesto your own husbands so that, if any of them do not believe, they may be won over without words by the behavior of their wives, when they see the purity and reverence of your lives. (1 Peter 3:1-2)

Husbands, in the same way be considerate as you live with your wives, and treat them with respect as the weaker partner and as heirs with you of the gracious gift of life. (1 Peter 3:7)

Submission isn’t one-way here. Peter exhorts husbands to submit in the same way as he’d just outlined above.
Christ saves us from what we deserve. The only cost is who we were.

The wife does not have authority over her own body but yields it to her husband. In the same way, the husband does not have authority over his own body but yields it to his wife. (1 Corinthians 7:4)

You are not your own; you were bought at a price. Therefore honor God with your bodies. (1 Corinthians 6:20)

Putting others first in marriage shouldn’t come as a surprise. We’re commanded to do the same to others.

Honor one another above yourselves. (Romans 12:10)

None of you should seek his own good, but the good of others. (1 Corinthians 10:24)

Humbly value others above yourselves, not looking to your own interests but to the interests of the others. Your attitude should be the same as that of Christ Jesus: Who being in the very nature God, did not consider equality with God a thing to be grasped, But made himself nothing, taking the very nature of a servant, being made in the likeness of man, He humbled Himself and became obedient to death: even death on a cross! (Philippians 2:3-8)love

The Church is the Bride

“Wives submit to your husbands” can be taken a step further in our spiritual lives.

The church is several times referred to as the bride of Christ.

The bride belongs to the groom. The friend who attends the groom waits and listens for him, and is full of joy when he hears the groom’s voice. That joy is mine, and it is now complete. (John 3:29)

Jesus answered, “How can the guests of the groom fast while he is with them? The time will come when the groom will be taken from them; then they will fast.” (Matthew 9:15)

Let us rejoice and be glad and give him glory! For the wedding of the Lamb has come, and his bride has made herself ready. Fine linen, bright and clean, was given her to wear. (Fine linen stands for the righteous acts of God’s holy people.) (Revelation 19:7-8)

Study Questions

As the perfect groom, how did Christ love the church?

How can we as a church become a better bride?

Download

Download the PowerPoint.

Body of Work – Fanzines

Over the years, I’ve worked on a lot of fanzines and APAzines (amateur press association zines).

Here are some of the zines I’ve written for, published, edited, or otherwise contributed to. (I don’t have images for them all.)

Not pictured here are the first 23 issues of Haymaker, a couple dozen Rogues Gallery, and a few Herozines.

Haymaker 24 Haymaker 25 Haymaker 26 Haymaker 27 Haymaker 29 Haymaker 30 Haymaker 31 Haymaker 32 Haymaker 33 Haymaker 34 Haymaker 35 Haymaker 36 Haymaker 37 Haymaker 38 Haymaker 39 Haymaker 40 Haymaker 41 Haymaker 42 Haymaker 43 Haymaker 44 Haymaker 45 Haymaker 46 Haymaker 48 Haymaker 49 Haymaker 50 Haymaker 51 Haymaker 52 Haymaker 53 Haymaker 54 Haymaker 55 Haymaker 56 Haymaker 57 Haymaker 58 Haymaker 59 Haymaker 60 Haymaker 62 Haymaker 63 Haymaker 64 Haymaker 67 Haymaker 68 Haymaker 69

The Clobberin' Times 01 The Clobberin' Times 02 The Clobberin' Times 04 The Clobberin' Times 05 The Clobberin' Times 06 The Clobberin' Times 07 The Clobberin' Times 08 The Clobberin' Times 09 The Clobberin' Times 11 The Clobberin' Times 12 The Clobberin' Times 13 The Clobberin' Times 14 The Clobberin' Times 15 The Clobberin' Times 16 The Clobberin' Times 17 The Clobberin' Times 19

Click here to see my full body of work.

Spatial Data, Part 6: Cleveland

This is followup to my part five series on spatial data:

At SQL Saturday Cleveland 473, I showed some Ohio- and Cleveland-specific examples.

Downloading the Cleveland Data

You can download the scripts and data input files here at the event page, or individually below.

Importing the Cleveland Data

Querying the Cleveland Data

This query joins those tables together into a single spatial result.

select '' name, geometry::Point(-81.935191, 41.470970, 0).STBuffer(.08).STBoundary() geom union all 
select isnull(nullif(name,''),type), geom from cle_roads union all 
select isnull(nullif(name,''),type), geom.STBoundary() from cle_landuse union all 
select isnull(nullif(name,''),type), geom.STBoundary() from cle_natural union all 
select isnull(nullif(name,''),type), geom from cle_railways union all 
select isnull(nullif(name,''),type), geom.STBoundary() from cle_waterways union all 
select isnull(nullif(name,''),type), geom.STBuffer(.00002) from cle_points union all 
select isnull(nullif(name,''),type), geom from cle_buildings

Spatial Results

Let’s break the script down:

  • the first line in the script draws the big circle around the area.
  • the other lines bring in the geom field from each table (either the whole object or just its outline via STBoundary).
  • the nullif lets us convert any blank into nulls, which lets us use ifnull to insert another value, essentially giving us the name column unless it is blank or null, in which case it gives us the type column

From here, we can:

  • zoom in for more detail
  • hover over a building, road, or other feature to see its name or other column
  • display a label on the results
  • apply filters to only show parts of the data
  • change the widths of the features by changing the STBuffer
  • do lots of other cool stuff

Digging Deeper

To download the data for your entire state, go to download.geofabrik.de (or a variety of other geodata sites), and drill down to the state or other area you’d like.

Download the .shp.zip file, then unzip the contents and import them using Shape2Sql.

 

 

Get in the Game

I’m a Christian, and sometimes a teacher/preacher.

"Find me someone who can play well." (1 Samuel 16:17)

“Find me someone who can play well.”
(1 Samuel 16:17)

This sermon is timed to tie in with Superbowl Sunday.

Selected

We aren’t just spectators in this life, or in the next. We’re major players. The A team. The starters.

As followers of Christ, we have been chosen — specifically — to be the front line in the battle for human souls.

We are here for a reason. We are specifically chosen. God Almighty has a job for us to do.

Jesus saw Simon and Andrew casting a net into the lake, for they were fishermen. Jesus said, “Come, follow me, and I will make you fishers of men.” At once they left their nets and followed him. (Mark 1:16)

“Go and make disciples of all nations, baptizing them in the name of the Father and of the Son and of the Holy Spirit, and teaching them to obey everything I have commanded you. Surely I am with you always, to the end of the age.” (Matthew 28:19-20)

You are a chosen people, a royal priesthood, a holy nation, God’s special possession, that you may declare the praises of him who called you out of darkness into his wonderful light. (1 Peter 2:9)

PracticePractice

Every new skill that we learn is hard before it becomes easy. Many occupations require constant training and updating, as the methods, regulations, and technologies change.

Our spiritual skills also need updating. The only time that you can coast on a bicycle is when you’re going downhill. Without some exercise in our prayer life, evangelism, mercy, and other spiritual muscles, we’ll end up with a soft-in-the-middle spiritual paunch.

Let us run with perseverance the race marked out for us, fixing our eyes on Jesus, the pioneer and perfecter of faith. For the joy set before him he endured the cross, scorning its shame, to sit down at the right hand of the throne of God. Consider him who endured such opposition from sinners, so that you will not grow weary and lose heart. (Hebrews 12:1-3)

No discipline seems pleasant at the time, but painful. Later on, however, it produces a harvest of righteousness and peace for those who have been trained by it. Therefore, strengthen your feeble arms and weak knees. (Hebrews 12:11-12)

Whatever you do, work at it with all your heart, as working for the Lord, not for human masters, since you know that you will receive an inheritance from the Lord as a reward. It is the Lord Christ you are serving. (Colossians 3:23-24)

We rejoice, for we know that trials develop endurance.  And endurance develops character, and character strengthens our confident hope of salvation. (Romans 5:3-4)

“He has blocked me so I cannot pass.” (Job 19:8)

Obstacles

News Flash: life isn’t easy. Marathon runners often talk about “hitting the wall.” That’s the point at which (to oversimplify) the body has run out of easy-to-burn fuel like carbohydrates and begins to eat fat cells from the body. Breathing becomes labored, muscles feel like they’re on fire, and the road ahead seems longer and harder than it probably really is.

There are times in our life when God seems absent, or the circumstances of life become overwhelming.

He gives strength to the weary and increases the power of the weak. Even youths grow tired and weary, and young men stumble and fall; but those who hope in the Lord will renew their strength. They will soar on wings like eagles; they will run and not grow weary, they will walk and not be faint. (Isaiah 40:29-31)

Do not be surprised at the fiery trial that has come on you to test you, as though something strange were happening to you. However, if you suffer as a Christian, do not be ashamed, but praise God that you bear that name. (1 Peter 4:12,16)

Do you not know that your body is a temple of the Holy Spirit who is in you, whom you have from God, and that you are not your own? You have been bought with a price: therefore glorify God in your body. (1 Corinthians 6:19)

Physical training is of some value, but godliness has value for all things, holding promise for both the present life and the life to come. (1 Timothy 4:8)

ReasonReason

When we’re “down at the half” — when you’ve hit that wall — we can regain our energy by focusing on our purpose.

 

What we are fighting for is worth far more than any temporary pain or difficulty. Our eternal salvation and the salvation of our friends and family are at stake. Our choices and words have everlasting impact.

Fight the good fight for the true faith. Hold tightly to the eternal life to which God has called you, which you have confessed so well before many witnesses. (1 Timothy 6:12)

My only aim is to finish the race and complete the task that the Lord Jesus has given me –  the task of testifying to the good news of God’s grace. (Acts 20:24)

I press on to take hold of that for which Christ Jesus took hold of me. Brothers and sisters, I do not consider myself yet to have taken hold of it. But one thing I do: Forgetting what is behind and straining toward what is ahead – I press on toward the goal to win the prize for which God has called me heavenward in Christ Jesus. (Philippians 3:12-14)

Triumph

We can win, and will win. The war is already over, even though we still fight individual skirmishes.

The crown is waiting for us at the end of the race, and Christ will supply us with the strength we need to win.

TriumphDo you not know that in a race all the runners run, but only one gets the prize? Run in such a way as to get the prize. Everyone who competes in the games goes into strict training. They do it for a crown that will not last, but we do it to get a crown that will last forever. Therefore I do not run like someone running aimlessly; and I do not fight like a boxer beating the air. No, I strike a blow to my body and make it my slave so that after I have preached to others, I will not be disqualified for the prize. (1 Corinthians 9:24-27)

I can do all things through Christ who strengthens me. (Philippians 4:13)

I have fought the good fight, I have finished the race, I have kept the faith. (2 Timothy 4:7)

Well done, good and faithful servant. (Matthew 25:21)

Summary

We have been chosen, and should train to overcome trials by focusing on the goal, which will take us to victory.

S – Selected (1 Peter 2:9)
P – Practice (Romans 5:4)
O – Obstacles (1 Timothy 4:8)
R – Reason (Philippians 3:13)
T – Triumph (1 Corinthians 9:25)

Download

Download the PowerPoint.