Exploring Mapping Data In a continuation from part 2a, this post will explore the spatial points datasets from my database. I need to assess what each dataset contains. To aid in the exploration of spatial data, I will demonstrate plotting spatial points. This can be a lot easier to look at this particular structure in…
Category: spatial analysis
Criminal Analysis: Data Exploration (part 2a)
Exploring Mapping Data My next exploration task is the mapping/geospatial tables in my database. I need to assess the what each dataset contains. To aid in the exploration of spatial data, I will demonstrate plotting of spatial points and polygons. This can be a lot easier to looking at this particular structure in tabular or…
Criminal Analysis: Data Search (part 4)
I have gathered three quarters of my branches on the “Other Data Sources” category. The next up is to get real estate data based on the project plan. Real Estate Data Finding good real estate data took a some work to explore and gather. I’m sure there is a lot of data available privately for…
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…
