Steph and the girls had a picnic at my place today while Melissa did Walmart. Daniel dropped by, we had much fun, and I took sixty pictures worth posting. Click my wild-ass mug below to see them.
I know I tend to drop buzz words on this blog without explanation, me bad. Today I would like to explain a couple of mapping concepts that you may or may not know, and hopefully find interesting.
Like what the hell is a FIPS code? It stands for Federal Information Processing Standard and they are numeric codes used by the government to identify Places, i.e. States and Counties for my purposes. Every U.S. State has a two digit code just as they have an abbreviation and I have no idea where they originated from and it really doesn't matter. For example: Tennessee = 47, California = 06, Washington = 53, Idaho = 16 and Florida = 12.
Every County has a three digit code which are subsets of the State FIPS code in which they reside. For example: my County code is 099 which combined with my State code 47 makes up a unique FIPS code for Lawrence County, TN of 47099. This 5 digit FIPS code is the magic number from which all government mapping functions operate, just like the 5 digit Zip Code, which in my case is 38464.
Every FIPS Code and Zip Code have a defined geographical area in the form of an outline of the area (polygon) that are maintained by the government, which is where I get my data. This morning I extracted 33,144 Zip Code polygons from their website and stored them in my database. Combined with the 3,233 Counties and 50 States I stored yesterday, I have a good handle on the data and can present them on any map platform I choose. I hope you learned something from this!
This virus thing hasn't impacted me as much as most folks. I didn't lose my job because I didn't have one and I didn't get any extra money from the government because I didn't deserve it. It has kept my sorry ass home and because of that I have achieved a goal that has escaped me for years: Storing individual U.S. State and County geojson datasets converted from the Census TIGER/Line Shapefiles into a MySql Blob binary data type with a FIPS code key. Seriously, I've been chasing this one down for a long time...
I've implemented them into the State and County Map polygons from my Covid Analysis app and the extra detail is significant.
Here's the code to read a State polygon:
Here's how it's stored in the Database on my server: (54 = West Virginia, 12 = Florida)
Which results in detail like this:
My next door neighbor Daniel is the maintenance guy for the school district and a master electrician but like a lot of folks, not good with computer maintenance. He asked me if I could clean up his very sluggish Windows 10 laptop, so I did. I got rid of a ton of crap and deep cleaned the Avast antivirus from his registry so Windows Defender could work again and protect his machine. The computer was also locked in that Windows Update/Repair loop so I killed the Service. Then I installed some tools and a secure version of Firefox, and the box is purring like a kitten.
Yesterday he asked me if I could take a look at his son Drew's computer, a six year old HP laptop running 8.1 and loaded up with all the crap a twenty year old normally acquires. I asked Drew if he was willing to give it all up and restore his OS to it's original state from the recovery partition and he said absolutely. I left that process running all night, upgraded the box with all of the 8.1 updates this morning, extracted his product key from the registry, then installed Windows 10 right on top of it. Again, new OS, purring like a kitten.
They just dropped by to pick up the box and they were very happy campers. Daniel keeps saying he want's to pay me and I keep declining. You never know when you're going to need a handyman. :-) When he said My wife's laptop has some issues... I shouted "What am I, your computer repair bitch?". You should have seen the look on his face until I told him I was kidding. The truth is, I take great satisfaction out of using my experience and knowledge to bring an old computer back to life. Wife's computer, next...
My friend and neighbor Daniel rode shotgun in my truck today and gave me a tour of Amish country I've never seen. Along the way we dropped into Top Gun and I grabbed some shots of their bad ass truck sitting out front. Man, you got to love the deep South!
I've got a new and vastly improved version of my Covid Analysis app, with fixed sort headers and internal County polygon outlines. Give it spin Here.
Update: I screwed up, that's what happens when you wake up at 0200 with COTB (Code On The Brain) and your only recourse is to turn the coffee on and have at it. I wrote a convoluted sort routine that apparently only my developer version of Firefox understood and implemented it without checking my other browsers. Sheesh, rookie mistake. Anyway, I have it fixed and if you tried it before, try to refresh your browser on the Here link above.
Eeester Sunday. I haven't been to the grocery store in two weeks and supplies are running low. The only time I've been out was to buy egg hunt stuff for the girls at the drugstore up the road. I've had frozen brussel sprouts for dinner the last two days. My neighbor dropped by the other night with a bottle of Texas craft vodka and I don't remember much more about it. We're under a flash flood and tornado warning until 2200 and it's only 1700. Piper's well and my code is going good. Jesus has risen, amen.
Update: The band of storms heading my way last night went south. You just never know around here...
I've written some code to massage the Covid by County data. There are two tables, one for number of Cases and one for number of Deaths. The top 100 U.S. Counties are included and the tables are sortable by clicking on the headings. Click on a County name to show it's outline.
Here you go!
I've created a heatmap of my daily Covid geojson data. This shows the number of cases only, not deaths. Click the image below to launch it, drag it around and zoom it in and out.
China is definitely out to get us. First, the virus, now the giant asian hornet which originated in China is invading the U.S. (it can drop you dead with one sting) and I've got tornados heading towards my house on Easter Sunday that I have no doubt originated in China.
Hey, I'm not complaining and just glad to be alive! I wrote two geojson parsers for the covid data yesterday and now I'm going to go plot them on a Leaflet heatmap, so take that China.
Page 8 of 12