2017 Tulsa Homicides: Maps, Statistics, & Perspective

 

 

 

 

Parents, siblings, co-workers, and friends. 81 individuals lost their lives to murder in the city of Tulsa last year. 81 lives taken away at the hands of another. 81 people who lived life just the same as you do. 81 lifetimes of human experience no more or no less valuable than yours. 81 of us are gone.

We’ve become numb to hearing of these horrific tragedies. It’s an issue all over the world, but it’s important to acknowledge that it’s an issue right here in our home town. I believe we’re all guilty of ignoring the problem and living almost as if it doesn’t exist. We may think it’s not our responsibility to do anything about it, but I beg to differ… There’s an easy way for each and everyone of us to contribute. I believe it’s as simple as acknowledging the problem, accepting that it’s real, and being thankful for the women and men who dedicate their lives to confronting it. Our police officers, as well as all other first responders, live in this treacherous reality so that we don’t have to.. As citizens, we have the power to influence change by the effortless swipe of a pen. We can vote.. Any time there is an opportunity to vote with the implications of helping out our first responders, we should jump at it. When they express a need for funding, I’m confident in saying that it is only in our best interest to help give them what they need. They are the ones who can directly impact the volume of crime in our city. They are the ones who keep us safe. Why wouldn’t we help?

No life is more valuable than another.. It’s not 81 data points.. It’s 81 names..

NoNames

Names..

  • Altercation: 9
  • Gang Related: 3
  • Domestic: 12
  • Drug Related: 3
  • Robbery: 11
  • Dispute: 13
  • Child Death: 6
  • Officer Involved: 6
  • Other: 7
  • Unknown: 11

Tulsa’s NewsOn6 reported on this project. Link: Story from NewsOn6

The data used in this project was obtained from Tulsa’s NewsOn6 via the Tulsa Police Department.
Advertisements

All Realtors Need This..

I see it far too often.. “10 ACRES FOR SALE!” with a snapshot from Google Earth showing about where the property is located with some unofficial property boundaries drawn on the photo, likely using paint. I’m not being sarcastic, because I would do the same exact thing if I was attempting to sell some property without my current expertise..

1I’m writing this short blog because I want property owners,  real estate agents, and real estate companies to realize that it is incredibly simple and incredibly cheap to up your marketing game in this area. All you need to do is find a licensed drone pilot with some basic knowledge of GIS, tell them what property you want updated imagery for, and pay them when the job is done. With what I do, you wouldn’t just receive photos from a drone showing you the property, you’d receive a product similar to how google earth works. You can click, drag around, zoom in and out, and really see what the property looks like in the now. Imagine clicking on that “10 ACRES FOR SALE!” link and getting to look around the property in high resolution. That’s much more attractive than looking at a Google Earth snapshot, or even looking on Google Earth Pro!

It’s more than just up-to-date high resolution imagery though. If you had me go fly a property, you’d get the aerial, a digital elevation display, a 3D model, and a vegetation health display. It’d go something like this…

“Hi {x name}! I just finished processing your job request for {x property address} and it looks good! Here’s your link. You can share this link with whoever you’d like and they can see everything the way you can. If you have any questions don’t hesitate to call, text, or email me! I just shot you an email with your invoice. Thank you so much!  – Trent”

If you’re interested in this kind of product, shoot me an email. Just put your name and email in the form below. I’d love to go fly for you. I keep it simple and convenient. I believe it should be super seamless for people to get this kind of product when they want it. I promote the idea of my customers shooting me a text when they want something flown. It should be THAT easy. (btw, that hyperlink takes you to an example property)

 

 

I am indeed a licensed drone pilot as well as a GIS professional. I’m based out of Claremore, Oklahoma and am willing to do projects pretty much anywhere in Eastern/Northeastern Oklahoma. I know there are people like me elsewhere too so please find them if you’re too far for me. I want to be able to look at land for sale in random places and actually be able to see the land that is for sale haha. People like myself who can pair drones with GIS with real estate agents could revolutionize what it’s like to look for property.

Capture

Maps, Beets, Battlestar Galactica

My all-time favorite television show is The Office hands down. I was introduced to the show in the spring of 2012 by Paxton Biggs. I recall the night very distinctly because I had just enrolled at OU and was excited about this new coming chapter in my life.

The night I first watched The Office I was sleeping on a blow-up mattress in the living room of Tosha King’s house where lots of my friends lived at the time. This was in Norman, Oklahoma. My friends living there at the time were Tosha, Wes Hammons, Matt Denton, Ray King, and Paxton Biggs (kind of sort of).

So there I was laying on this blow up mattress when Paxton, who was on the couch, decided to turn The Office on for some casual entertainment as we fell asleep. I can still remember the exact opening scene of the very first episode I ever watched. I laughed so hard and was hooked immediately on the show.. The scene that I’m talking about is set in the conference room and Michael Scott is talking to his employees about some nonsense that they aren’t paying attention to, but Michael believes he really has their undivided attention because they are watching a television screen behind him. On this screen there is the bouncing cube that you would see if you left your DVD player untouched long enough. All the employees are in deep anticipation hoping this cube hits the very corner of the screen exactly. I feel like we can all relate to this…

Jim Halpert (a character on the show) does a great job explaining this: https://www.youtube.com/watch?v=SmFEK2gq4QQ

So then and there my love for The Office was born. It seems silly to write about my emotional attachment to a TV show, but what people don’t understand is that The Office was there to shine a small light in some dark times of my life. I have watched the office roughly 25 or 30 times through. At one time, I couldn’t go to sleep if I wasn’t listening to the show..

Recently I came up with an idea to create a map that showed where each branch of  the Dunder Mifflin Paper Company was. I did some research to make sure I plotted every single branch that was ever mentioned in the show. Luckily there were a few good sources online that discussed each branch that was mentioned. They even provided what episode the branch was mentioned in which was pretty impressive.

This was a fun little project I completed, and I hope my fellow fans of The Office get a kick out of the map.

TO

 

GIS & U.S. Presidents 

From time to time I get an urge to create geospatial datasets by doing half-hearted research online. It’s just a nerdy hobby of mine but it’s something I enjoy. With this research though, my goal is to produce maps that display my data in a variety of ways. I query my datasets to narrow down something that I think would be interesting to see spatially…

I became interested in following American politics and global events roughly 2 or 3 years ago. With my growing interest, I always come up with mapping ideas for current events and trending topics, but I never seem to act on them because I stay so busy with work.. Recently I did some simple research and created a table of data on our Presidents. The dataset I created is relatively extensive and I will likely create a few more maps from it, but these two are the two I have made so far. 

I think it’s interesting to see on a map where our presidents were all born. And in a morbid way, it’s also interesting to see where they have died. I think this mapping idea of mine was extremely simple but unique at the same time. 


The ESRI User Conference’s Impact on a Young GIS Professional

img_1434

I’m 24 years old and I’ve been in the world of GIS for only 4 years. 3 of those years being a mixture of internships and college classroom exposure . I didn’t realize my passion for GIS until I had completed my first 40 or 50 hours of school… I’ve now been working as a GIS Analyst in the energy industry for a little over a year.

This year I was blessed with the opportunity to attend the world renowned User Conference that esri puts on every summer. There were a staggering 16,000+ GIS professionals in attendance. We came from all over the world. I met so many people that I lost track of them in my head. I mingled with folks from Sweden, India, Abu Dhabi, Japan, and a trillion others who live right here in the United States. One of the most important aspects of this conference is networking and sharing perspectives with other like minded individuals. I believe that in itself makes coming to this conference worthwhile.

I sat through session after session, workshop after workshop, speech after speech, and demonstration after demonstration to let it all wash over me. I was so energized and excited about ideas I had come up with for my current employer that I sat up late into the nights working on them. It’s difficult to describe the atmosphere of the ESRI UC, but it’s refreshing to experience. I’m looking forward to the conference next year already. I’m hoping some of my college GIS friends will be able to attend so we can experience it together, as well as the San Diego night life. I’ll be bringing Tay to this thing next year no doubt. I want to expose her to this environment. I think she’ll thoroughly enjoy it.

Until next year!

Passing the FAA’s Remote Pilot Exam

There is no question that drones are the future in GIS. Sure they have an enormous presence in the industry today, but at a capacity that is microscopic to what it will be in the future. ESRI has even taken recognition by launching the robust Drone2Map software. If you haven’t had the chance to play with this software or at least watch some tutorials on it, I would highly recommend you do so.
So about the CFR Part 107 Exam

Back in August of 2016 the FAA instituted regulations that must be adhered to when piloting any UAV. This means you must obtain a certificate for commercial use here in the United States. Commercial use simply means that you’re either flying on behalf of your employer or you’re flying it personally to earn money. 

Now to get your certificate you must pass an aeronautical exam that was developed by the FAA and is administered by the FAA. This is no joke either.. It isn’t  something you can go and pass using the product of elimination or just plain common sense. You MUST STUDY. As long as you care about passing the exam and you study for a good week (about 2 hours per night), you’ll be fine. 

Some basic info to know if you’re going to go after your certificate. 

  • There are 60 multiple choice questions
  • There are 3 answers to choose from
  • You must earn a 70% to pass
  • You must take it at an FAA testing center
  • The test costs $150.00
  • You must wait 2 weeks to retake it if you fail on your first attempt
  • When you finish your test, you’ll know right away what your score is

My studying approach…

I chose to read the actual Part 107 study guide that the FAA released word for word. Once I read all 70+ pages and let it wash over me, I went back through and made some notes. On top of this, I watched YouTube videos discussing airspace classifications, how to interpret weather reports, how to read sectional charts, and other things that I found to be a bit abstract from the FAA’s study guide. Once I did all of these things I had created quite the study guide. Well… my girlfriend had created quite the study guide haha. She took it upon herself to organize all the information into an interpretable document that she could quiz me with. We studied for roughly 5 or 6 days and then I went and took the exam. I earned an 83%. I felt that the amount of studying I did was a bit of an overkill, but I learned quickly during the exam that I was lucky I studied as much as I did. I expected an A, but an 83% gets me off the ground so I was happy with that. 

If you’d like to discuss the exam with me please just shoot me an email. I’d love to help in any way I can.

trentpollard7@gmail.com

Here is the FAA issued study guide to get you started:

https://www.faa.gov/regulations_policies/handbooks_manuals/aviation/media/remote_pilot_study_guide.pdf
Good luck!!

    Mapping Global Terrorism

    About 3 months ago I stumbled upon an interesting geodatabase that housed global terrorism data. This database was established by the University of Maryland and was very well put together. I started scrolling through the spreadsheets of metadata to check out what information they had for each act of terrorism, and I was astounding by how much detail and effort was put forth in this project. I get embarrassingly excited when I find well organized information like this, because it means running queries will be simple, thus making map generation relatively simple. I began querying with various parameters just to kind of play with with the data, and I decided that I wanted to create 3 maps based on 3 separate parameters. The first parameter being “fatalities per instance”. With this, I wanted to create a world map with every recorded act of terrorism this database had, and within each instance display the number of fatalities. I created 3 categories that would color the point/instance based on the number of people killed. A red dot meaning >19 deaths, a yellow dot meaning >5 but <20, and a green dot meaning <6.

    IMG_0507

    __________________________________________

    The second map I created was focused on a specific terrorist organization. “Al-Qaeda claimed acts of terrorism” was the second parameter I was interested in mapping. I wanted this map to be simple to read, and I wanted it to capture the mood that someone experiences when thinking about or discussing terrorism. This is why the map is made up of all dark colors. In this map you will see red points that indicate an act of terrorism that was claimed by the Al-Qaeda group, and you will see dark gray points that represent all other instances of terrorism. I acknowledge the three countries with high outlying numbers of fatalities in the map as well.

    IMG_0506

    __________________________________________

    The third and final map I created with this amazing database focuses on South Asia. I put the focus here due to the high concentration of attacks that were recorded in the region. I wanted to investigate a little as to who was responsible for most of these attacks in such a densely populated and attacked area, so I queried the data around for quite some time to figure out who the top 5 culprits were. This was my third and final parameter of interest. I wanted to display, using 5 different colors, who the top 5 terrorist organizations were based on deaths in that area. You will see the different colors for each organization in this map as well as a dark gray color for other terrorist organizations who fell below the top 5.

    IMG_0579

    __________________________________________

     

    All data that is displayed in the maps was obtained from the University of Maryland’s Global Terrorism Database (GTD).