Open in app

Sign In

Write

Sign In

Richard Peterson
Richard Peterson

565 Followers

Home

About

Published in

SelectFrom

·Apr 17, 2022

Mapping Fracking Wells in Colorado with PostgreSQL

Use SQL to Analyze Data and Draw Maps Analysis Plan Requirements: PostgreSQL with PostGIS enabled and pgAdmin4. Load Data into PostgreSQL — Colorado counties boundary shapefile and a shapefile of fracking well locations from FracTracker Data cleaning — specifying SRIDs, creating the geospatial index, and creating a geometry column from latitude and…

Sql

6 min read

Mapping Fracking Wells in Colorado with PostgreSQL
Mapping Fracking Wells in Colorado with PostgreSQL
Sql

6 min read


Published in

Dev Genius

·Mar 31, 2022

3 Easy Ways to import a shapefile into a PostgreSQL database

Before we begin, you must have an instance of PostgreSQL installed with the PostGIS extension. PGAdmin is a good database administration software that can be installed with PostgreSQL. Download PostgreSQL — https://www.postgresql.org/ Install PostGIS — https://postgis.net/install/ We also need a dataset. In this post, we will use the University of…

Postgis

3 min read

3 Easy Ways to import a shapefile into a PostgreSQL database
3 Easy Ways to import a shapefile into a PostgreSQL database
Postgis

3 min read


Oct 13, 2021

Tips from deploying my first Python Google Cloud Function

Some quirks of Cloud Functions. The python script was a relatively simple ETL job that tested my abilities to architect and debug, but it was a great experience in deploying production code under constraints. The script simply compared two Google Sheets, and updated the target page with new or updated…

Python

3 min read

Tips from deploying my first Python Google Cloud Function
Tips from deploying my first Python Google Cloud Function
Python

3 min read


Nov 30, 2020

Monitor a Honeypot with Azure App Insights

Have you ever wanted to watch foreign malicious actors attack a virtual machine in real time? In this article, we will do just that with a python honeypot and Azure Monitor. First, I need to give a shout-out to the Microsoft docs for setting up Application Insights. …

Azure

7 min read

Monitor a Honeypot with Azure App Insights
Monitor a Honeypot with Azure App Insights
Azure

7 min read


Published in

Towards Data Science

·Aug 2, 2020

Data Viz using Python and Tableau: from API call to Hosted Dashboard

Interactive charts are key to visual storytelling. — Building an infographic often starts while you are first exploring the data. Matplotlib, Seaborn, and ggplot2 are the classic programming charts, while Plotly has also exploded in popularity. But for me, nothing matches the clean professional aesthetic of Tableau. …

Python

5 min read

Data Viz using Python and Tableau: from API call to Hosted Dashboard
Data Viz using Python and Tableau: from API call to Hosted Dashboard
Python

5 min read


Published in

Towards Data Science

·Jul 30, 2020

COVID-19 Unemployment Brief: State, Race and Industry

COVID-19 has been the greatest influence on the US labor market since the 2008 financial crisis. — Faced with a fast-spreading disease, a slew of misinformation and unclear guidance from all levels of government, the national economy contracted as businesses temporarily or permanently shut down. …

Data Visualization

3 min read

COVID-19's Affect on Unemployment: State, Race and Industry
COVID-19's Affect on Unemployment: State, Race and Industry
Data Visualization

3 min read


Published in

Towards Data Science

·Apr 11, 2020

Linear Regression by Hand

Linear regression is a data scientist’s most basic and powerful tool. Let’s take a closer look at the Least Squares Line and Correlation Coefficient. — Invention of Linear Regression Linear regression is a form of linear algebra that was allegedly invented by Carl Friedrich Gauss (1777–1855), but was first published in a scientific paper by Adrien-Marie Legendre (1752–1833). Gauss used the least squares method to guess when and where the asteroid Ceres would appear in the night sky (The…

Machine Learning

6 min read

Linear Regression by Hand
Linear Regression by Hand
Machine Learning

6 min read


Published in

The Startup

·Apr 7, 2020

The Academic Stack

Elevate your mind with a modern productivity stack — Your tools are an extension of your mind As such, they should work maximize your retention and help you realize connections and deeper meanings for your area of study. Your computer is a powerful sidekick for your brain, and its greatest strength is its ability to aid a human mind store information. …

Productivity

6 min read

The Academic Stack
The Academic Stack
Productivity

6 min read


Published in

Towards Data Science

·Mar 21, 2020

Deploy a .NET API to Azure

Create a SQL database and Serve your API in the cloud! — Introduction This article is the fourth in a series dedicated to building a .NET API for the Angular Tour Of Heroes tutorial. So far, we have: Set up our environment. Built a MSSQL Docker container database for local development. Wrote a .NET API for the Angular Tour of Heroes app. You…

Dotnet

8 min read

Deploy a .NET API to Azure
Deploy a .NET API to Azure
Dotnet

8 min read


Published in

Towards Data Science

·Mar 19, 2020

.NET Core API — Dive into C#

Build a back end web server for the Angular Tour of Heroes tutorial — If you have been following along from the Series outline, and have a working database, an Angular Tour of Heroes App, and a generic .NET API, we have now come to the meat of the Series, writing the C# code for our .NET API. To follow along, you can download…

Angular

9 min read

.NET Core API — Dive into C#
.NET Core API — Dive into C#
Angular

9 min read

Richard Peterson

Richard Peterson

565 Followers

SQL CSI by day and Northwestern University Master’s in Public Policy Student by night

Following
  • ODSC - Open Data Science

    ODSC - Open Data Science

  • Aldric Chen

    Aldric Chen

  • Bex T.

    Bex T.

  • Angelica Lo Duca

    Angelica Lo Duca

  • Soner Yıldırım

    Soner Yıldırım

See all (275)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech