Now that we have collected our data, lets work on building a database to store our project data. For this project I have decided to use a PostgreSQL database. The image below provides some planning details to help us implement the database. Installing and Setting up On a Linux machine, getting PostgreSQL installed and running…
Category: data
Criminal Analysis: Data Search (part 3)
So far I have gathered half of my other data sources. The next up is to get employment and real estate data based on the project plan. Employment Data I generally searched for “Washington DC” and “employment data” but later modified it a little based on the results I got. https://duckduckgo.com/?t=lm&q=washington+dc+employment+data&ia=web https://duckduckgo.com/?t=lm&q=Washington+DC+unemployment+data+historical+data&ia=web DC Department of…
Criminal Analysis: Data Search (part 2)
Now that we have our crime and mapping data, lets work on gathering the other data I wrote down during the previous Planning post. Part 2 of Data Search will focus on our Other Data Sources branch in the project plan. Moon Phases On previous work projects, I have come across a couple of R…
Criminal Analysis: Data Search (part 1)
Now that we have our crime data, lets work on gathering the other data I wrote down during the previous Planning post. Part 1 of Data Search will focus on our Map Data branch in the project plan. Map Data Boundary Data Using the same Open Data website, I just queried for DC boundary and…
Spatial Visualizations in R Part 2
Now we will be working with and visualizing COVID-19 data on top of our current spatial plots. To see catch up, check out these associated shapefile and GeoJSON posts. The output used used in this post comes from the GeoJSON post since it is in the desired coordinate system. The R script was simplified from…
Working with GeoJSON in R
This post is a supplemental tutorial to my initial post on Spatial Visualizations in R (Part 1) to work through processing a GeoJSON file in R from the https://www.geospatialhub.org/ for this particular example. You can work with the same GeoJSON file at the following link: https://www.geospatialhub.org/datasets/b0e0a99ec14748eeae750949c7bbb2ec_0?geometry=-123.671%2C40.158%2C-91.437%2C45.779 You can explore and tailor the API under the…
Spatial Visualizations in R Part 1
*** Updated Code on GitHub *** https://github.com/problemxsolutions/wyoming-r In this post I will be covering spatial visualizations using data from the state of Wyoming. For structure sake, I will be walking through each of the step outlined in my Analytic Methodology workflow. We will identify the sources of data, the processes to analyze and visualize the…
Project Workflow: Data Analysis
***This was created and valid in 2016. Data for this specific data project may no longer be current*** Data analysis is our investigation of the questions we set out to answer for our project during the planning stage. At this point we should have a good understanding of what are data contains, and various value…
Project Workflow: Data Preparation
***This was created and valid in 2016. Data for this specific data project may no longer be current*** Surveying the Data Data Preparation is a valuable stage that steps up the rest of the stages in our project. It allows you to survey the data and figure out what needs to be done. Its your…
