Everything but the State

Can someone tell me why we don't have a "state" field on our join forms?

My site is all about locations, it is nice with the Geo map, but when someone lives in "Birmingham" but is that Alabama or in England.

Yes the country is there but that can get over looked.

I guess a generic text box asking for it but it would be better like the countries.

[edit] Another example is "Jacksonville" there are very many cities in the US named Jacksonville.

I suppose you could create some predefined values (look at the Country list for an example), then add a drop-down field.

Dolphin is intended to be somewhat generic.

The term state is not used by all countries. Perhaps only about a half dozen of so. Some countries refer to their divisions as provinces, or regions, or departments or prefectures, ect. Some are labeled as communities which are further sub divided into province. Russia is real complicated. They have oblasts, republics, okrugs, krays, and federal cities.

So my guess is due to the complicated mess, it was simply not included.

you could use this (I think I have all of the states):

INSERT INTO `sys_pre_values` (`Key`, `Value`, `Order`, `LKey`, `LKey2`, `LKey3`, `Extra`, `Extra2`, `Extra3`) VALUES
('State', 'OR', 43, 'Oregon', '', '', '', '', ''),
('State', 'PA', 42, 'Pennsylvania', '', '', '', '', ''),
('State', 'PW', 41, 'Palau', '', '', '', '', ''),
('State', 'OK', 40, 'Oklahoma', '', '', '', '', ''),
('State', 'OH', 39, 'Ohio', '', '', '', '', ''),
('State', 'MP', 38, 'Northern Mariana Islands', '', '', '', '', ''),
('State', 'ND', 37, 'North Dakota', '', '', '', '', ''),
('State', 'NC', 36, 'North Carolina', '', '', '', '', ''),
('State', 'NY', 35, 'New York', '', '', '', '', ''),
('State', 'NM', 34, 'New Mexico', '', '', '', '', ''),
('State', 'NJ', 33, 'New Jersey', '', '', '', '', ''),
('State', 'NH', 32, 'New Hampshire', '', '', '', '', ''),
('State', 'NV', 31, 'Nevada', '', '', '', '', ''),
('State', 'NE', 30, 'Nebraska', '', '', '', '', ''),
('State', 'MT', 29, 'Montana', '', '', '', '', ''),
('State', 'MO', 28, 'Missouri', '', '', '', '', ''),
('State', 'MS', 27, 'Mississippi', '', '', '', '', ''),
('State', 'MN', 26, 'Minnesota', '', '', '', '', ''),
('State', 'MI', 25, 'Michigan', '', '', '', '', ''),
('State', 'MA', 24, 'Massachusetts', '', '', '', '', ''),
('State', 'MD', 23, 'Maryland', '', '', '', '', ''),
('State', 'MH', 22, 'Marshall Islands', '', '', '', '', ''),
('State', 'ME', 21, 'Maine', '', '', '', '', ''),
('State', 'LA', 20, 'Louisiana', '', '', '', '', ''),
('State', 'KY', 19, 'Kentucky', '', '', '', '', ''),
('State', 'KS', 18, 'Kansas', '', '', '', '', ''),
('State', 'IA', 17, 'Iowa', '', '', '', '', ''),
('State', 'IN', 16, 'Indiana', '', '', '', '', ''),
('State', 'IL', 15, 'Illinois', '', '', '', '', ''),
('State', 'ID', 14, 'Idaho', '', '', '', '', ''),
('State', 'HI', 13, 'Hawaii', '', '', '', '', ''),
('State', 'GU', 12, 'Guam', '', '', '', '', ''),
('State', 'GA', 11, 'Georgia', '', '', '', '', ''),
('State', 'FL', 10, 'Florida', '', '', '', '', ''),
('State', 'FM', 9, 'Federated States of Micronesia', '', '', '', '', ''),
('State', 'DC', 8, 'District of Columbia', '', '', '', '', ''),
('State', 'DE', 7, 'Delaware', '', '', '', '', ''),
('State', 'CT', 6, 'Connecticut', '', '', '', '', ''),
('State', 'CO', 5, 'Colorado', '', '', '', '', ''),
('State', 'CA', 4, 'California', '', '', '', '', ''),
('State', 'PR', 44, 'Puerto Rico', '', '', '', '', ''),
('State', 'AR', 3, 'Arkansas', '', '', '', '', ''),
('State', 'AZ', 2, 'Arizona', '', '', '', '', ''),
('State', 'AK', 1, 'Alaska', '', '', '', '', ''),
('State', 'AL', 0, 'Alabama', '', '', '', '', ''),
('State', 'RI', 45, 'Rhode Island', '', '', '', '', ''),
('State', 'SC', 46, 'South Carolina', '', '', '', '', ''),
('State', 'SD', 47, 'South Dakota', '', '', '', '', ''),
('State', 'TN', 48, 'Tennessee', '', '', '', '', ''),
('State', 'TX', 49, 'Texas', '', '', '', '', ''),
('State', 'UT', 50, 'Utah', '', '', '', '', ''),
('State', 'VT', 51, 'Vermont', '', '', '', '', ''),
('State', 'VI', 52, 'Virgin Islands', '', '', '', '', ''),
('State', 'VA', 53, 'Virginia', '', '', '', '', ''),
('State', 'WA', 54, 'Washington', '', '', '', '', ''),
('State', 'WV', 55, 'West Virginia', '', '', '', '', ''),
('State', 'WI', 56, 'Wisconsin', '', '', '', '', ''),
('State', 'WY', 57, 'Wyoming', '', '', '', '', ''),
('State', 'AE', 58, 'Armed Forces Canada', '', '', '', '', ''),
('State', 'AA', 59, 'Armed Forces Americas (except Canada)', '', '', '', '', ''),
('State', '', 0, '--Any--', '', '', '', '', '');

Thanks guys, I opted for a text field asking "State or Area" and used it for profile matching. I think that will work.

Thanks for that too.

Problem is like Deano brought up, my site is global so just the US won't do.

I think all of Modzzz 'premium' modules and some 'ultimate' ones include states for all countries, might be able to use those for some sort of profile/join integration?

although Im not sure how accurate outside of the US states the lists are!

The ones for the UK show England, N Ireland, Scotland and Wales as 'states' when they are actually countries...!

You may find this useful.

Example. This is a list of all subdivisions in the UK. http://www.unece.org/fileadmin/DAM/cefact/locode/Subdivision/gbSub.htm

This list has links to all the countries. http://www.unece.org/cefact/locode/subdivisions.html

That would have been VERY handy for one of my early Dolphin projects!...