SELECT * FROM fwa.fwa_assessment_watersheds_poly
WHERE "gnis_name_1" NOT LIKE '% Lake'

# FileGDB
# 11252 records returned (incorrect)
"GNIS_NAME_1" NOT LIKE '% Lake'

# PostGIS
# 11252 records returned (incorrect)
"gnis_name_1" NOT LIKE '% Lake'

# Shapfile
# 19358 records returned (correct!)
"GNIS_NAME_" NOT LIKE '% Lake'