Skip to content

Instantly share code, notes, and snippets.

View FergusDevelopmentLLC's full-sized avatar

Will Carter FergusDevelopmentLLC

61 followers · 148 following
View GitHub Profile
@FergusDevelopmentLLC
FergusDevelopmentLLC / gist:403e87d556c707e6d2b4d920c05ba2e3
Last active February 23, 2021 00:16
longitude,latitude,name union select 1
-121.225442,38.185269,Elaine Mary Dornton Dvm union select 1
-121.133995,38.213676,Pioneer Equine Hospital Inc
-118.161607,34.490262,Cindy R & Don J Scholten
-118.197207,34.469054,Reid R Loken Dvm
-118.223169,34.495733,Animal Acres
-118.753117,34.144485,Country Hills Pet Hospital
-118.758002,34.152187,Keith Berry Dvm
@FergusDevelopmentLLC
FergusDevelopmentLLC / invalid_csv.csv
Created February 19, 2021 22:33
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 3 columns, instead of 2. in line 3.
longitude,latitude,name
-121.225442,38.185269,Elaine Mary Dornton Dvm
-121.133995,38.213676,Pioneer Equine Hospital Inc
-118.161607,Cindy R & Don J Scholten
-118.197207,34.469054,Reid R Loken Dvm
-118.223169,34.495733,Animal Acres
-118.753117,34.144485,Country Hills Pet Hospital
@FergusDevelopmentLLC
FergusDevelopmentLLC / missing_latitude.csv
Created February 19, 2021 22:30
longitude latitudex name city state address postal_code phone
-149.808343 61.205214 Alaska State Veterinary Assn Anchorage AK 1731 Bragaw St 99508 (907) 563-3701
-149.878519 61.198067 Alaska Veterinary Clinic Anchorage AK 300 E Fireweed Ln 99503 (907) 277-3224
-149.861712 61.107056 Averill Coleen DVM Anchorage AK 12531 Old Seward Hwy 99515 (907) 345-1515
-149.842821 61.195279 Basler Jon DVM Anchorage AK 2036 E Northern Lights Blvd 99508 (907) 274-5623
-149.778251 61.196617 Beck Teresa DVM Anchorage AK 2639 Boniface Pkwy 99504 (907) 337-1561
-149.870947 61.190312 Chang Linda M DVM Anchorage AK 3330 Fairbanks St 99503 (907) 274-0645
-149.733451 61.206232 Chester Valley Veterinary Hospital Anchorage AK 1571 Muldoon Rd 99504 (907) 333-6591
-149.842821 61.195279 College Village Animal Clinic Anchorage AK 2036 E Northern Lights Blvd 99508 (907) 274-5623
-149.851991 61.180832 Cornerstone Animal Hospital Anchorage AK 1600 E Tudor Rd 99507 (907) 569-7277
@FergusDevelopmentLLC
FergusDevelopmentLLC / missing_longitude.csv
Created February 19, 2021 22:28
longitudex latitude name city state address postal_code phone
-149.808343 61.205214 Alaska State Veterinary Assn Anchorage AK 1731 Bragaw St 99508 (907) 563-3701
-149.878519 61.198067 Alaska Veterinary Clinic Anchorage AK 300 E Fireweed Ln 99503 (907) 277-3224
-149.861712 61.107056 Averill Coleen DVM Anchorage AK 12531 Old Seward Hwy 99515 (907) 345-1515
-149.842821 61.195279 Basler Jon DVM Anchorage AK 2036 E Northern Lights Blvd 99508 (907) 274-5623
-149.778251 61.196617 Beck Teresa DVM Anchorage AK 2639 Boniface Pkwy 99504 (907) 337-1561
-149.870947 61.190312 Chang Linda M DVM Anchorage AK 3330 Fairbanks St 99503 (907) 274-0645
-149.733451 61.206232 Chester Valley Veterinary Hospital Anchorage AK 1571 Muldoon Rd 99504 (907) 333-6591
-149.842821 61.195279 College Village Animal Clinic Anchorage AK 2036 E Northern Lights Blvd 99508 (907) 274-5623
-149.851991 61.180832 Cornerstone Animal Hospital Anchorage AK 1600 E Tudor Rd 99507 (907) 569-7277
@FergusDevelopmentLLC
FergusDevelopmentLLC / animal_hospitals_usa.csv
Created February 17, 2021 22:16
We can't make this file beautiful and searchable because it's too large.
longitude,latitude,name,city,state,address,postal_code,phone
-149.808343,61.205214,Alaska State Veterinary Assn,Anchorage,AK,1731 Bragaw St,99508,(907) 563-3701
-149.878519,61.198067,Alaska Veterinary Clinic,Anchorage,AK,300 E Fireweed Ln,99503,(907) 277-3224
-149.861712,61.107056,Averill Coleen DVM,Anchorage,AK,12531 Old Seward Hwy,99515,(907) 345-1515
-149.842821,61.195279,Basler Jon DVM,Anchorage,AK,2036 E Northern Lights Blvd,99508,(907) 274-5623
-149.778251,61.196617,Beck Teresa DVM,Anchorage,AK,2639 Boniface Pkwy,99504,(907) 337-1561
-149.870947,61.190312,Chang Linda M DVM,Anchorage,AK,3330 Fairbanks St,99503,(907) 274-0645
-149.733451,61.206232,Chester Valley Veterinary Hospital,Anchorage,AK,1571 Muldoon Rd,99504,(907) 333-6591
-149.842821,61.195279,College Village Animal Clinic,Anchorage,AK,2036 E Northern Lights Blvd,99508,(907) 274-5623
-149.851991,61.180832,Cornerstone Animal Hospital,Anchorage,AK,1600 E Tudor Rd,99507,(907) 569-7277
@FergusDevelopmentLLC
FergusDevelopmentLLC / animal_hospitals_ca.csv
Last active March 10, 2021 23:16
longitude latitude name
-121.225442 38.185269 Elaine Mary Dornton Dvm
-121.133995 38.213676 Pioneer Equine Hospital Inc
-118.161607 34.490262 Cindy R & Don J Scholten
-118.197207 34.469054 Reid R Loken Dvm
-118.223169 34.495733 Animal Acres
-118.753117 34.144485 Country Hills Pet Hospital
-118.758002 34.152187 Keith Berry Dvm
-118.749822 34.12747 Life Animal Rescue
-118.786018 34.183944 Thomas K Cole Dvm
@FergusDevelopmentLLC
FergusDevelopmentLLC / comedians.csv
Created February 15, 2021 20:48
name city email
Chris Farley Chicago farley@secondcity.com
Jerry Seinfeld New York jerry@nyc.com
Joe Rogan Austin Joe@texas.com
@FergusDevelopmentLLC
FergusDevelopmentLLC / category.csv
Created February 15, 2021 18:51
id name description
1 Node.js JavaScript runtime environment
2 Vue.js JavaScript Framework for building UI
3 Angular.js Platform for building mobile & desktop web app
@FergusDevelopmentLLC
FergusDevelopmentLLC / utils.js
Last active February 13, 2021 20:24
const sqlite3 = require('sqlite3').verbose()
const getPlayers = (db) => {
return new Promise(resolve => {
const data = []
db.all('SELECT name, city, email FROM players', [] , (err, rows) => {
if(rows && rows.length > 0) rows.forEach((row)=> data.push(row))
resolve(data)
})
})
@FergusDevelopmentLLC
FergusDevelopmentLLC / server.js
Last active February 13, 2021 20:14
const express = require('express')
const utils = require('./utils')
const bodyParser = require('body-parser')
const sqlite3 = require('sqlite3').verbose()
const app = express()
app.use(bodyParser.json())
app.use(bodyParser.urlencoded({ extended: true }));
//utils.createSeedData()