<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Arial","sans-serif";
color:black;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">From an inventory management point of view, an information rich label such as this really identifies a location and not the hydrant itself. If asset management
is important, when a hydrant is moved then the label for that hydrant would change. From a database design standpoint that is an problematic system since you then have the identifier for an object changing. Of course you could have a location label and an
inventory label but that kind of begs the question of why bother.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Lance Peterson<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Web Applications Developer<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Technology and Innovation Dept.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">City of Tallahassee<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">850-891-2019<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> SHRUG-L [mailto:shrug-l-bounces@lists.dep.state.fl.us]
<b>On Behalf Of </b>Eric Songer<br>
<b>Sent:</b> Wednesday, May 18, 2016 10:07 AM<br>
<b>To:</b> Porter, Bill<br>
<b>Cc:</b> Espinosa, Dan; shrug-l@lists.dep.state.fl.us<br>
<b>Subject:</b> Re: shrug-l: Numbering Hydrants<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">I'll be honest. I find the whole "smart" identifier a monumental pain in the butt and never worth the effort. When I drive around my home town, I don't know what lat long to 8 decimal places, PLSS section, or National Map Grid I am in.
Why is this in the ID? Now you have to have an application, or a spreadsheet to generate an ID.I don't see the utility (see what I did there?)<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"> -Eric<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, May 18, 2016 at 9:50 AM, Porter, Bill <<a href="mailto:bporter@spartanburgcounty.org" target="_blank">bporter@spartanburgcounty.org</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> That is an impressive system and it’s well thought out.
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> It seems like a lot of effort to reduce two 9 digit Dec degree values to 15 places (the dashes need
to be counted).</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">In my humble application of Occam’s razor and the principle of scientific parsimony, the simplest
solution is best. Why make the coordinates occult, hiding under a conversion?
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> In the Americas, from the equator to the northernmost tip of Greenland, Lat is positive and Long
negative, so drop the longitude negative sign unless this scheme is adopted outside of the US. Then it’s their problem.
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">19 charaters 15 characters</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">30.434478|84.277222 vs 0XD-89E-JM8-EQ6</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> A unique ID for each hydrant would be only one field in the data base of whatever essential info
firefighters need: Hydrant into (GPM flow? Type of hydrant? Wrench size? Adapter size?) . They will need a street address and landmarks. Since fire trucks can’t fly as the crow does, any code has to be convertible to street routing. All Counties build
street data bases. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> Scott’s initial parameters stated that the trucks can’t be guided by 911 dispatch and firemen don’t
want to carry and learn GPS. Nor would the county spring for meter-level GPS units on each fire truck. $250 Garmin WAAS-corrected units are more likely if any are considered.
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">One elegant solution is to have GPS/GIS elves at each fire station (one for each shift) that would
have a tablet with WAAS GPS and mapping software. This could save lives, would build better street maps over time and provide employment for freshly minted GIS elves. It would also give GIS analysts a much needed macho-rep boost. It’s better to swagger into
a bar with a fireman’s coat and tablet than just a tablet. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:black">Another option would be to stop fighting interminable, pointless and immoral foreign wars and use those
$trillions to upgrade Emergency Services equipment across the US. (End of editorial portion)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> SHRUG-L [mailto:<a href="mailto:shrug-l-bounces@lists.dep.state.fl.us" target="_blank">shrug-l-bounces@lists.dep.state.fl.us</a>]
<b>On Behalf Of </b>Rick Labs<br>
<b>Sent:</b> Tuesday, May 17, 2016 2:56 PM<br>
<b>To:</b> Bassett, Seth; Scott Warner; <a href="mailto:shrug-l@lists.dep.state.fl.us" target="_blank">
shrug-l@lists.dep.state.fl.us</a><br>
<b>Subject:</b> Re: shrug-l: Numbering Hydrants</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt">Scott, Seth, others who may be interested,<br>
<br>
I worked up a demo spreadsheet that shows how you can label anything with a simple
<b>12 character code</b> (for instance hydrants, or even mail/packages) and have that code encapsulate 6 decimal accuracy geo coding (about 1 meter accuracy). The code is designed to be compact and easy to speak. Case is not important and the letters O, I,
L, and Z are not used because of frequent confusion with numbers (0,1,2). <br>
<br>
The spreadsheet both encodes and decodes. Unambiguous, universal format works worldwide down to a meter.
<br>
<br>
You can get the file named <b>encodelatlon.xls</b> from this directory:<br>
<a href="http://clbcm.com/shrug/" target="_blank">http://clbcm.com/shrug/</a><br>
<br>
There are no macros (or VBA code) in the spreadsheet but you will likely have to "allow editing" if you want to play around with it.
<br>
<br>
Rick<span style="color:#888888"><br>
<br>
<br>
</span><o:p></o:p></p>
<pre><span style="color:#888888">-- <o:p></o:p></span></pre>
<pre><span style="color:#888888">Richard J. Labs, CFA, CPA<o:p></o:p></span></pre>
<pre><span style="color:#888888">CL&B Capital Management, LLC<o:p></o:p></span></pre>
<pre><span style="color:#888888">Phone: <a href="tel:315-637-0915" target="_blank">315-637-0915</a><o:p></o:p></span></pre>
<pre><span style="color:#888888">E-mail (preferred for efficiency): <a href="mailto:rick@clbcm.com" target="_blank">rick@clbcm.com</a><o:p></o:p></span></pre>
<pre><span style="color:#888888">Mailing address: 8 Laureldale Dr., Pittsford, NY 14534-3508<o:p></o:p></span></pre>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
SHRUG-L mailing list<br>
<a href="mailto:SHRUG-L@lists.dep.state.fl.us">SHRUG-L@lists.dep.state.fl.us</a><br>
<a href="http://lists.dep.state.fl.us/mailman/listinfo/shrug-l" target="_blank">http://lists.dep.state.fl.us/mailman/listinfo/shrug-l</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<p class="MsoNormal"><br>
-Eric-<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>