Medina County: Finding Survey, Deed, and Permit Info
I had downloaded some PDF files of the county survey books after we first bought our house. We wanted a little more info, but were completely unable to find where I’d gotten the survey book pages. Fortunately, a very helpful individual at the County Recorders office knew what I had and exactly how to get there. Figured I’d write it down for the next time we want to pull up survey information. The trick is to not use the new Medina County GIS website.
From http://engineer.medinaco.org, select “Traditional” from the GIS menu. This will bring you to the old county GIS interface at http://engineer.medinaco.org/cgi-bin/mchequery.cgi
From the drop-down menu hidden between the red bar and an text input and select a search type (Parcel Number, Address, Owner Last Name)
Click Query/Refresh
You will now see information about the searched parcel and a map. Scroll down.
From here, you can access a bunch of different information – for the survey books, select “Scans”.
There’s a lot of information available. In the Surveys, there’s a cool feature — the top part of the page contains a portion of the document and a light gray outline showing the searched parcel — when you cannot figure out why a particular page shows up when your parcel isn’t involved — look for a tiny portion of your parcel that’s technically on the page. In this example, a few feet of our lot appear under the information block. There are a few pages where the little section of land on the public right-of-way appear somewhere along the bottom portion of a scan. I expect they’ve got the corners of each page tagged with geographic information & your scan query retrieves anything where any of your lot falls within those bounds. Survey and tax map go back over a hundred years, and it’s neat to see how the property lines have changed (and not changed). Plus, I now know Bellus Rd was named after the family that owned the farm across the street from us.
Since I’m writing down where I’ve found important documentation … I’ll add:
Building permits are available through the Medina County Building Department at https://medina.onlama.com/Default.aspx
Deed transfers, mortgage instruments, etc are available through the Medina County Recorder at http://recordersearch.co.medina.oh.us/OHMedina/AvaWeb/#!/search
Statistics and Mortality
Linux Network Manager GUI
School Considerations
Oracle – Select Top
I discovered the “rownum” trick early in my usage of Oracle databases — especially useful for sampling data to see what’s in there, something like “select * from dataTable where rownum < 6” gets you the first five records. But that’s not suitable if you want to sort the records. In this particular case, I have a series of names. I want to find the highest number value in the series so I can name my object with the next sequential name.
Enter “fetch first” … this appears to be available since 12c (so older database installations may still require a more convoluted solution):
SELECT set_name from set_data WHERE set_name LIKE 'Something-With-A-Series-%' ORDER BY set_name DESC fetch first 1 row only;
Which returns the last name in the series.
PHP Sub-Second Sleep
I needed to add a sleep to a PHP process, but I didn’t want to waste a whole second on each cycle. That’s usleep:
<?php
date_default_timezone_set('America/New_York');
$t = microtime(true);
$micro = sprintf("%06d",($t - floor($t)) * 1000000);
$d = new DateTime( date('Y-m-d H:i:s.'.$micro, $t) );
print $d->format("Y-m-d H:i:s.u") . "\n";
usleep(100000);
$t = microtime(true);
$micro = sprintf("%06d",($t - floor($t)) * 1000000);
$d = new DateTime( date('Y-m-d H:i:s.'.$micro, $t) );
print $d->format("Y-m-d H:i:s.u") . "\n";
sleep(1);
$t = microtime(true);
$micro = sprintf("%06d",($t - floor($t)) * 1000000);
$d = new DateTime( date('Y-m-d H:i:s.'.$micro, $t) );
print $d->format("Y-m-d H:i:s.u") . "\n";
?>
Run the script, and you’ll see sub-second sleeps.
[tempuser@564240601ac2 /]# php testSleep.php
2020-07-09 14:06:20.641449
2020-07-09 14:06:20.741952
2020-07-09 14:06:21.742347
Marketing Fail
School’s Out For …
I want to know what schools are going to do in September/November after what they did in August proves to be foolishly optimistic (either ‘the virus will disappear’ or ‘one person will be able to ensure twenty six-year-old kids wear masks and stay 6 feet apart, plus we can have a janitor in each restroom sanitizing after each use’) and they’ve failed to use the intervening 4-5 months to develop a decent online teaching approach.
Ohio Public Health Warning Level
Ohio now has a per-county public health alert level rating that reminds me of the terror alert color-coded system we had after 9/11.
Of course there will be people in red or purple counties heading out to neighboring counties to shop/eat/socialize/party because those neighboring counties are only in orange so they don’t need to wear a mask there. I don’t get why I’ve got to get my car e-checked because my county borders Cuyahoga but we wouldn’t have to wear a mask for the same reason … but it’s a step in the right direction deeming masks mandatory *somewhere* based on *something*.