Administrative Area - not able to differentiate states/provinces in Views

I'm having this same issue. I would like to create an exposed filter listing, say, the 50 US states as a drop down.

I'm willing to do some of the coding, but don't know where to begin. Any pointers would be appreciated.

One problem I could foresee is that the administrative areas change depending upon the country. However, if one were to set which countries administrative areas one was filtering against, that would eliminate this issue entirely.

I'm looking at this right now

class addressfield_views_handler_filter_country extends views_handler_filter_in_operator {
  function get_value_options() {
    $this->value_title = t('Country');
    $field = field_info_field($this->definition['field_name']);
    $this->value_options = _addressfield_country_options_list($field);
  }
}

Basically the address field is extending a class and providing the name, field name, and list of options.

Trying to see if I can drop in the states right now...

Here's the other area. I feel like I'm close. Basically add all the options to the area in #1. And then register the filter in this area below.

function addressfield_field_views_data($field) {
  $data = field_views_field_default_views_data($field);

  // Add a handler for countries.
  foreach ($field['storage']['details']['sql'] as $type => $tables) {
    foreach ($tables as $table_name => $columns) {
      if (!isset($columns['country'])) {
        continue;
      }
      
      $column_real_name = $columns['country'];
      if (!isset($data[$table_name][$column_real_name]['filter'])) {
        continue;
      }

      $data[$table_name][$column_real_name]['filter']['handler'] = 'addressfield_views_handler_filter_country';
    }
  }

  return $data;
}

Did you get any further with this? I need to do a state dropdown exposed filter on addressfield data...

I would like to achieve the same thing. I read something similar here But cant quite get it to work right.

This is a duplicate of #1304288: Add a Views handler to filter by administrative area using a select list instead of a textfield, and to the question above, no, Views doesn't just populate the select list based on options present in the Views results. We have to figure out how to populate it in advance ourselves, and that does make it tricky to know how to populate it - i.e. which countries' administrative areas should be taken into account? Follow-up discussion should take place in the linked issue.