Vardaman.org

My Github




Browse

Bellco ATM

Bellco Credit Union:

Your ATM ate my debit card.

You have no idea how much damage that did to me. My rent was up today at 10:00am, and to pay it I used your ATM to get cash. But all your ATMs on the 16th Street Mall (outside; which I used, and inside as well) were malfunctioning. I asked inside; they checked the machine as best as they could, but they told me when a card doesn't get ejected, the machine destroys it. I logged into my bank's website, and there was a $357 balance and all listed transactions were only my own. I called the bank, and they said my account was fine. Your ATM swallowed my card for no legitimate reason. Because I don't know the card number, there's no way for me to access my money like Western Union or a bank transfer to my Wells Fargo account. They told me a replacement card could be sent in 7-10 business days. To expedite, I had to pay a $35 fee (effing nearly 10% of my balance) to have a replacement card shipped via FedEx, and because a person has to sign for it, I can't work tomorrow because I have to sit outside and wait for delivery.

With no ability to access my money and pay my rent, for tonight I either need to beg a friend for a roof, or sleep on a park bench in 10 degree weather and a half-foot of snow on the ground. My card is now reported lost, my access to my account via web is gone as of the 20 minute phone call I had with my bank, I'm out $35 to Fedex (who knows when they will show up tomorrow), an expected $65-$75 in lost wages (waiting for Fedex), a $6 bus pass that I otherwise didn't have to buy, and about four miles of walking I didn't have to do.

Forgive me if I spend the rest of this cold, cold evening speaking badly about your ATM on social media and places like Yelp.

Stewart Vardaman

(If you need my email address or phone number, pull that damned card out of your damned machine, call my damned bank at the 800 number on the back, give them the last four digits of the card number [3077], and spend a few damned minutes on hold).

permalinkOctober 30, 2019

Western Stock Show

Western Stock Show - just a horse trick exhibit. Nice gig - concession stand; not hard work, only half-full crowd, got free food, they paid us for 9.5 hours. All I did was prep nachos, wash dishes, swept floor. I ate a bacon cheeseburger, two slices of pizza, a half-order of nachos and cheese, and a few spoonfuls of beef brisket.

I will tell you one thing about gigs like this: they are not playing around with cleanliness. I must have washed my hands and changed gloves 40 times that night. The boss insisted that even if I rubbed my brow; wash and new gloves. I adhered to that. The sanitary levels at these events is to higher standards than what I've seen in Fast Food.

A few things I would change:

* Weigh pizza ingredients (a woman got yelled at for using too much cheese during the shift I worked).

* They use NCR cash registers, and use a dedicated person to transmit orders from the NCR to the kitchen. How hard is it to use terminals and a touch button to do that? I could set up hardware and write software for that in ONE DAY, for under $1,000.

* You have to use analytics. Get the gate ticket sales and figure out why you don't have to dump 8 pizzas and ten trays of chips each night.

* Inventory - Running low on Jalapeno peppers for nachos? There's a world of under-employed people who can tell you how many peppers to order each week.

permalinkOctober 30, 2019

Weather Widget

Added a Weather Widget to my info panel. Updates every three hours; takes under one second to update:

Weather Widget

permalinkOctober 28, 2019

Denver spending 2019 above $10 million

Denver spending so far in 2019, by program/department/category where the category total payments exceeded $10 million. It didn't make the $10m cutoff, but Denver spent $5,125,713.53 so far this year on Snow Removal at the airport; $2,229,896.87 on golf and golf course-related expenses. The City Council has spent nearly $4,800 at Turin Cycles (on the NE corner of 7th Ave and Lincoln St). The Denver Central Library paid a total of $24.35 this year out of their Petty Cash Account for Office Supplies and Fixtures.

BTW, shout to Turin Bikes: I love the Specialized Bike I got a couple of years ago from you. Sweet deal for $900.

Your website sucks.

The person who created it should be forced to write on a blackboard 500 times 'I do not know what I am doing -- all I am is a copy-and-paste HTML thief; a mimicker of actual talent, and causing serious harm to clients like the Bike Shop.'

+-----------------------+---------------------------------+--------------------------------+-----------------+
| program               | department                      | category                       | amount          |
+-----------------------+---------------------------------+--------------------------------+-----------------+
| Airport               | Airport                         | Construction Services          | $146,575,109.51 |
| Airport               | Airport                         | Professional Services          | $142,811,581.94 |
| General Government    | Career Service Authority        | Payroll Liabilities            | $58,459,938.64  |
| Public Works          | Wastewater Management Division  | Construction Services          | $57,242,847.68  |
| Public Works          | Public Works                    | Construction Services          | $54,372,045.56  |
| Public Works          | Public Works                    | Professional Services          | $47,260,527.56  |
| Cultural Activities   | Arts and Venues Division        | Professional Services          | $21,363,807.51  |
| Public Works          | Public Works                    | Repair and Maintenance of Road | $21,300,349.65  |
| General Government    | Department of Finance           | Professional Services          | $20,963,124.58  |
| Airport               | Airport                         | Repair and Maintenance of Equi | $20,585,882.90  |
| General Government    | Department of General Services  | Utilities                      | $18,447,126.61  |
| General Government    | Department of Finance           | Payroll Liabilities            | $17,999,999.82  |
| General Government    | Technology Services             | Maintenance Agreements and Lic | $17,989,403.21  |
| Airport               | Airport                         | Utilities                      | $17,969,368.89  |
| Public Works          | Public Works                    | Vehicles                       | $16,939,488.05  |
| General Government    | Department of General Services  | Professional Services          | $15,479,901.38  |
| Public Safety         | Safety Administration           | Professional Services          | $13,812,310.88  |
| Community Development | Housing & Neighborhood Division | Business Housing and Construct | $12,339,978.36  |
| Public Works          | Wastewater Management Division  | Professional Services          | $12,278,331.69  |
| General Government    | Technology Services             | Professional Services          | $11,968,246.18  |
| Public Safety         | Undersheriff                    | Professional Services          | $11,516,338.88  |
| Airport               | Airport                         | Maintenance Agreements and Lic | $10,935,803.63  |
| Airport               | Airport                         | Travel and Transportation - No | $10,097,887.77  |
+-----------------------+---------------------------------+--------------------------------+-----------------+
permalinkOctober 19, 2019

Denver Library Spending

Just rambling through Denver's 2019 checkbook for what the city paid for the Denver Public Library (DPL); amount totals only over $50,000. So far in 2019 they spent (some samples):

Century Link  = $76,854.42
Comcast Cable = $92,626.96
Dell Computer = $209,627.16
Staples (Office Supplies) = $68,846.97

DPL uses overdrive.com for some of their digital content; they spent $984,000.00 with overdrive.com so far. DPL operates library trucks that they apparently lease from Transwest Trucks and Trailers for $88,832.00 so far in 2019. They spent $51,062.76 on elevators and escalators this year, and $117,837.19 on security guards.

Here is what drives me nuts: get a library card, get their app on your phone, and play around with their site and app. I can write the website and app to a presentable level in two weeks for under $5,000.

permalinkOctober 18, 2019

Denver payments to Goodyear in 2019

Denver payments to Goodyear in 2019:

SELECT c_name AS company, c_program_area AS program, c_exp_categ AS expense_category, 
    CONCAT('$', FORMAT(SUM(c_amount), 2)) AS total
  FROM food.chex
  WHERE c_name LIKE 'Goodyear%' AND c_year = 2019
  GROUP BY 1, 2, 3
  ORDER BY SUM(c_amount) DESC

+-----------------------------+--------------+--------------------------------+-------------+
| company                     | program      | expense_category               | total       |
+-----------------------------+--------------+--------------------------------+-------------+
| GOODYEAR TIRE AND RUBBER CO | Public Works | Auto Supplies and Materials    | $689,916.32 |
| GOODYEAR TIRE AND RUBBER CO | Airport      | Consumable Inventory           | $22,358.06  |
| GOODYEAR TIRE AND RUBBER CO | Public Works | Repair and Maintenance of Equi | $665.00     |
| GOODYEAR TIRE AND RUBBER CO | Airport      | Auto Supplies and Materials    | $330.20     |
| GOODYEAR TIRE AND RUBBER CO | Airport      | Administrative Expense         | $59.79      |
| GOODYEAR TIRE AND RUBBER CO | Public Works | Professional Services          | $2.20       |
+-----------------------------+--------------+--------------------------------+-------------+

Here is something worth mentioning: MySQL/MariaDB cannot use an INDEX when you use a LIKE clause. It's imperceptible by eyeballing on our sample query because the record set is so small (121,659 rows). The LIKE for 'Goodyear' is fine at (0.00477872) seconds, but explicitly spelling out 'GOODYEAR TIRE AND RUBBER CO' and using EQUAL vs LIKE is (0.00417095) seconds because it can use the INDEX on company name. Six thousands of a second might seem trivial, but think about the scale if you're dealing with US Census data on about 330 million people against a JOIN on 300 million cell phone numbers and another JOIN against the USPS's massive address database (maybe 170 million?), and total pieces of mail north of 40 billion.

permalinkOctober 17, 2019

Airport checks

Let's look at Denver's checkbook to see how much they are spending at Denver International Airport. For just the airport, only 2019, only totals of over $2 million, and only non-Colorado companies:

SELECT c_name AS company, c_addy AS city, c_state AS st, c_fund_desc AS description,
    CONCAT('$', FORMAT(SUM(c_amount), 2)) AS totals 
  FROM food.chex
  WHERE c_program_area = 'Airport' 
    AND c_year = 2019 
    AND c_state <> 'CO'
  GROUP BY c_name
  HAVING SUM(c_amount) > 2000000
  ORDER by c_amount DESC

+-------------------------------------------+--------------------+----+------------------------------+----------------+
| company                                   | city               | st | description                  | totals         |
+-------------------------------------------+--------------------+----+------------------------------+----------------+
| HOLDER-FCI JV                             | ATLANTA            | GA | Airport Capital Improvement  | $20,208,536.30 |
| JACOBS ENGINEERING GROUP INC              | PASADENA           | CA | Airport Capital Improvement  | $14,556,132.89 |
| BOMBARDIER TRANSPORTATION HOLDING USA INC | PITTSBURGH         | PA | Airport Operations and Maint | $14,373,094.05 |
| HNTB CORPORATIONv                         | KANSAS CITY        | MO | Airport Capital Improvement  | $13,092,850.54 |
| DBA PUBLIC SERVICE COMPANY OF COLORADO    | MINNEAPOLIS        | MN | Airport Operations and Maint | $12,265,528.59 |
| WSP USA INC                               | NEW YORK           | NY | Airport Capital Improvement  |  $7,604,563.92 |
| JSM AND ASSOCIATES LLC                    | MOUNT DORA         | FL | Airport Operations and Maint |  $5,369,487.46 |
| JA WATTS INC                              | CHICAGO            | IL | Airport Capital Improvement  |  $5,023,423.79 |
| AERO SNOW REMOVAL CORP                    | PORT WASHINGTON    | NY | Airport Operations and Maint |  $4,796,672.77 |
| THYSSENKRUPP ELEVATOR CORPORATION         | COTTONWOOD HEIGHTS | UT | Airport Operations and Maint |  $4,025,689.00 |
| RS AND H INC                              | JACKSONVILLE       | FL | Airport Capital Improvement  |  $2,870,219.34 |
| SANTANDER LEASING LLC                     | MELVILLE           | NY | Airport Capital Improvement  |  $2,696,803.80 |
| NACHURS ALPINE SOLUTIONS INDUSTRIAL       | MARION             | OH | Airport Operations and Maint |  $2,669,881.88 |
| WORLD WIDE TECHNOLOGY LLC                 | ST LOUIS           | MO | Airport Capital Improvement  |  $2,426,782.48 |  
| FAITHFUL GOULD INC                        | NEW YORK           | NY | Airport Operations and Maint |  $2,160,108.63 |
| MCKINSEY AND COMPANY INC                  | WASHINGTON         | DC | Airport Operations and Maint |  $2,100,000.00 |
+-------------------------------------------+--------------------+----+------------------------------+----------------+
permalinkOctober 16, 2019

IQ

Your IQ changes with age. I'd bet my IQ score has dropped ten or twenty points in the last decade.

permalinkOctober 15, 2019

Flat-lining SPAM emails

Flat-lining SPAM emails:

More SPAM

The drop-off on Rejects are firewall rule changes.

permalinkOctober 14, 2019

Murder Comparison between Jackson MS and Denver CO

A sad fact about my hometown of Jackson, MS

For the years with comparable data, in absolute terms, there's been more murders in Jackson than in Denver in three out of four years. Even though Denver (pop. = 600,158) is well over the size of Jackson (pop. = 173,514). As of the 2010 US Census. Denver is nearly 3.5 times larger than Jackson.

+------+---------+-------+--------+-------+
| year | city_1  | j_tot | city_2 | d_tot |
+------+---------+-------+--------+-------+
| 2014 | Jackson |    61 | Denver |    32 |
| 2015 | Jackson |    53 | Denver |    57 |
| 2016 | Jackson |    58 | Denver |    54 |
| 2017 | Jackson |    60 | Denver |    58 |
+------+---------+-------+--------+-------+

It's even worse than the numbers appear. Since the 2010 census, Denver has grown mightily; Jackson has been losing population. By 2014 where I first found matching data and through 2017, the city size difference is probably more like 4X to even 5x.

permalinkOctober 1, 2019

Denver Historic Landmarks

Denver's Open Data table of historic landmarks is so bad it's essentially unusable. A lot of data is in the wrong fields, there's no city/state/zip, and there's three places that aren't even in Denver; as far away as Pueblo.

https://www.denvergov.org/media/gis/DataCatalog/historic_landmarks/csv/historic_landmarks.csv

346 total records, the US Postal Service was able to encode 273 total, of which 251 they were able to add the ZIP+4 code. The rest I googled, then cleaned up manually. So, let's look at downtown Denver only, with Districts filled out, fully ZIP+4 encoded, and ordered alphabetically:

SELECT landmark_name, address, city, state, zip, district,
    year_built AS built
  FROM food.landmarks
  WHERE LENGTH(zip) > 5
    AND district <> ''
    AND LEFT(zip, 5) = '80202'
  ORDER BY landmark_name

+---------------------------------------------+-----------------+--------+----+------------+-----------------+---------+
| landmark_name                               | address         | city   | st | zip        | district        | built   |
+---------------------------------------------+-----------------+--------+----+------------+-----------------+---------+
| 1642 Market Street                          | 1642 MARKET ST  | DENVER | CO | 80202-1514 | Lower Downtown  | 1885    |
| 1644-1650 Market Street                     | 1644 MARKET ST  | DENVER | CO | 80202-1514 | Lower Downtown  | 1884-88 |
| American National Bank Building             | 818 17TH ST     | DENVER | CO | 80202-3101 | Downtown Denver | 1910    |
| Barnum Building                             | 1412 LARIMER ST | DENVER | CO | 80202-1705 | Larimer Square  | 1889    |
| Barth Hotel                                 | 1514 17TH ST    | DENVER | CO | 80202-1202 | Lower Downtown  | 1882    |
| Baur Confectionery Company                  | 1512 CURTIS ST  | DENVER | CO | 80202-2343 | Downtown Denver | 1881    |
| Brown Palace Hotel                          | 321 17TH ST     | DENVER | CO | 80202-4003 | Downtown Denver | 1888-92 |
| Congdon Building/Apollo Hall                | 1421 LARIMER ST | DENVER | CO | 80202-1704 | Larimer Square  | 1870s   |
| Crawford Building                           | 1437 LARIMER ST | DENVER | CO | 80202-1704 | Larimer Square  | 1875    |
| Denver Tramway Company Building (REI store) | 1100 14TH ST    | DENVER | CO | 80202-2201 | Downtown Denver | 1893    |
| Gallup-Stanbury Building                    | 1445 LARIMER ST | DENVER | CO | 80202-1704 | Larimer Square  | 1873    |
| Granite Building                            | 1460 LARIMER ST | DENVER | CO | 80202-1705 | Larimer Square  | 1882    |
| Kettle Building                             | 1422 LARIMER ST | DENVER | CO | 80202-1705 | Larimer Square  | 1873    |
| Miller Building                             | 1401 LARIMER ST | DENVER | CO | 80202-1704 | Larimer Square  | 1889    |
| Navarre Building/Bricker Collegiate Inst.   | 1727 TREMONT PL | DENVER | CO | 80202-4006 | Downtown Denver | 1880    |
| Oxford Hotel and Office Annex               | 1600 17TH ST    | DENVER | CO | 80202-1204 | Wazee           | 1891    |
| Paramount Theatre                           | 1621 GLENARM PL | DENVER | CO | 80202-4301 | Downtown Denver | 1930    |
| Sheridan/Hendrie & Bolthoff Building        | 1635 17TH ST    | DENVER | CO | 80202-1203 | Lower Downtown  | 1892    |
| Trinty Methodist Church                     | 1820 BROADWAY   | DENVER | CO | 80202-3815 | Downtown Denver | 1888    |
| Windsor Stables Storefront Building         | 1732 BLAKE ST   | DENVER | CO | 80202-1226 | Lower Downtown  | 1881-86 |
+---------------------------------------------+-----------------+--------+----+------------+-----------------+---------+

Here's a JOIN on my version and their original to show you how crappy their data is:

+--------------------------------------+------------------------------+-------------------------------------------------------+------------------------------------------------+
| lm_name                              | lm_aka                       | addy_1                                                | addy_2                                         |
+--------------------------------------+------------------------------+-------------------------------------------------------+------------------------------------------------+
| 1642 Market Street                   | None                         | 1642 Market Street                                    | None                                           |
| 1644-1650 Market Street              | None                         | 1644-1650 Market Street                               | None                                           |
| 20th Street Recreation Center        | None                         | 1011 20th Street                                      | None                                           |
| American National Bank Building      | None                         | 818 17th Street                                       | None                                           |
| Barnum Building                      | None                         | 1412 Larimer Street                                   | 1408 Larimer Street                            |
| Barth Hotel                          | None                         | 1514 17th Street                                      | 1510-16 17th Street                            |
| Baur Confectionary Company           | None                         | 1512-1514 Curtis Street                               | None                                           |
| Brown Palace Hotel                   | None                         | 321 17th Street                                       | 321-401 17th Street                            |
| Congdon Building                     | Apollo Hall                  | 1421-1425 Larimer Street                              | 1419-27 Larimer Street                         |
| Crawford Building                    | None                         | 1437-1439 Larimer Street                              | 1439 Larimer Street                            |
| Curry-Chucovich House                | None                         | 1439 Court Place                                      | None                                           |
| Denver Tramway Power Plant           | REI                          | None                                                  | 1416 Platte Street                             |
| Gallup-Stanbury Building             | None                         | 1445-1451 Larimer Street                              | 1445 Larimer Street                            |
| Granite Building                     | None                         | 1460 Larimer Street, 1224-30 15th Street              | 1454-60 Larimer Street, 1226-28 15th Street    |
| Guaranty Bank Building               | None                         | 815 17th Street                                       | 801-17 17th Street, 1715-17 Stout Street       |
| Hose Company No. 1                   | None                         | 1963 Chestnut Place                                   | 1999 Chestnut Place                            |
| Kettle Building                      | None                         | 1422 Larimer Street                                   | None                                           |
| Masonic Temple Building              | None                         | 1614 Welton Street                                    | 1614 Welton Street, 535 16th Street            |
| Miller Building                      | None                         | 1401-1407 Larimer Street                              | None                                           |
| Navarre Building                     | Bricker Collegiate Institute | 1727 Tremont Street                                   | 1725 Tremont Place                             |
| Oxford Hotel and Office Annex        | None                         | 1600 17th Street, 1645 Wazee Street, 1624-28 17th St. | 1600 17th St, 1612-16 17th St., 1659 Wazee St. |
| Paramount Theatre                    | None                         | 1621 Glenarm Place                                    | 1621-41 Glenarm Place                          |
| Sheridan/Hendrie & Bolthoff Building | None                         | 1635 17th Street                                      | None                                           |
| Trinty Methodist Church              | None                         | None                                                  | 1820 Broadway                                  |
| Windsor Stables Storefront Building  | None                         | 1732-1770 Blake Street                                | 1738-1770 Blake Street                         |
+--------------------------------------+------------------------------+-------------------------------------------------------+------------------------------------------------+

Hell, why not total up by district with more than one:

SELECT district, COUNT(district) AS dist_count
  FROM food.landmarks
  WHERE district <> ''
  GROUP BY district
  HAVING dist_count > 1
  ORDER BY dist_count DESC, district

+----------------------------------------+------------+
| district                               | dist_count |
+----------------------------------------+------------+
| Downtown Denver                        |         15 |
| East 7th Avenue                        |         15 |
| Larimer Square                         |         11 |
| Lower Downtown                         |         10 |
| Wyman                                  |          7 |
| Pennsylvania Street                    |          6 |
| Quality Hill                           |          6 |
| Potter Highlands                       |          5 |
| Civic Center                           |          3 |
| Curtis Park E                          |          3 |
| Sherman-Grant                          |          3 |
| Swallow Hill                           |          3 |
| Wolff Place                            |          3 |
| Clements                               |          2 |
| Five Points Historic Cultural District |          2 |
| Montclair                              |          2 |
| Morgan's Subdivision                   |          2 |
| Packard's Hill                         |          2 |
| Witter-Cofield                         |          2 |
+----------------------------------------+------------+
permalinkSeptember 29, 2019

Spam email blocking

Made some adjustments to my firewall rules to block some entire IP address netblocks coming from countries like Russia and China I've seen in my Postfix email server logs. The change in my REJECT blocklist is noticeable, because the email server can't REJECT what the firewall won't allow to connect in the first place:

Spam REJECT stats

(Updated chart Oct 1st 2019 around 8pm)

permalinkSeptember 25, 2019

Denver City Data

A few random totals from Denver's 2019 financials so far this year. The biggest total goes to retirement, followed by funding Denver Health hospital:

DENVER EMPLOYEES RETIREMENT PLAN  = $99,873,949.24
DENVER HEALTH MEDICAL CENTER = $87,664,306.95

More:

DENVER BOTANIC GARDENS INC = $1,341,882.36
THE DENVER CENTER FOR THE PERFORMING ARTS =  $7,849,046.24

THE DENVER POST LLC = $3,105,208.45
(Newspaper - that was probably advertising buys)

BOMBARDIER TRANSPORTATION HOLDING USA INC = $24,907,025.94
(Bombardier is a maker of private jets)

CORRECTIONAL MANAGEMENT INC = $3,433,443.82
(Private jail. Been outside their work-release place's front door on Dahlia St; 
orked with some guys from the inside before)

CENTURYLINK COMMUNICATIONS LLC = $3,108,654.34
(And you thought your Internet bill was high)

REVISION INC = $1,538,546.09
(IT contracting, but as a sideline Tony the owner rents apartments; one I lived in for five years)

ALABAMA AGRICULTURAL AND MECHANICAL UNIV = $3.00
(The city's smallest total payment, but the data contains refunds and dummy payments of one cent)

CARING FOR DENVER FOUNDATION = $24,390,712.00
(The largest one-time payment the city has made, but combined payments to others ends up higher)

Across all departments, petty cash came to $27,136.72; the Police about $2,800 and Fire about $2,000.

permalinkSeptember 17, 2019

Denver data for Elway car dealerships

Another stupid database operation.

Denver makes their payments for expenses open. Let's go see how much the city has paid auto dealership John Elway Chevrolet so far in 2019, and break it down by department area. Overall, Mr. Elway's Chevy dealership has gotten paid $2,547,936.69 this year. The other dealership with Elway's name on it (Jeep) did $372,309.67 in business with the city, and someone working for the city spent a total of $60 on three visits to Elway's Steak House at the airport (I'll bet on only drinks).

PayeeProgramAreaTotalAmount
JOHN ELWAY CHEVROLETPublic Works$1,729,453.79
JOHN ELWAY CHEVROLETHuman Services$338,714.81
JOHN ELWAY CHEVROLETAirport$253,498.09
JOHN ELWAY CHEVROLETGeneral Government$226,270.00

permalinkSeptember 17, 2019

More Nonsense

Because I'm an idiot:

Let's look at liquor licenses. Again, the city's DB has messed-up addresses and no ZIP code, So yet another encoding and another JOIN. But this time, we can only compare the first five digits rather than the full ZIP+4. So we have 588 licensed stores and 1,969 liquor licenses. In my old apartment on Ogden Street in ZIP code 80218; after some data correction, there's 60 places with liquor licenses, broken down by category:

store_typest_count
HOTEL AND RESTAURANT18
BEER & WINE6
FERMENTED MALT BEVERAGE6
TAVERN6
TAVERN AND CABARET6
HOTEL AND RESTAURANT AND CABARET5
RETAIL3
CLUB2
STORE2
SPECIAL EVENTS1
TASTINGS1

Next, it's kinda pointless to do a JOIN on adult and child obesity tables when the numbers are zero. I could add a WHERE clause, but I think it may be faster to just delete the records from those tables with zero values before I even do the SELECT. In the lifespan table alone there's five records with zero values.

Then there's neighborhoods that do not exist - city data sometimes had a GIS coordinate in that field. I blanked those out.

Final output here

permalinkSeptember 13, 2019

Show more posts...

Elsewhere

Cowboy Junkies
Reason Magazine
Scientology
Web Site Optimization
JD Hodges
Cato Institute
Field of Schemes
Oleg Volk
vardaman.net
vardaman.com