PDA

View Full Version : SCRIPT: Community Table Depository



Centauri Soldier
08-19-2009, 02:28 PM
I thought it would be helpful if we all shared out tables of commonly used elements.

Here's my first to start us off.

Name
State Abbreviations
Type
Numerically Indexed
Tiers/Levels
1
Description
This tables includes all USPS state abbreviations including possessions and military regions.


tUSStatesAbbr = {};
tUSStatesAbbr[1] = "AL";
tUSStatesAbbr[2] = "AK";
tUSStatesAbbr[3] = "AS";
tUSStatesAbbr[4] = "AZ";
tUSStatesAbbr[5] = "AR";
tUSStatesAbbr[6] = "CA";
tUSStatesAbbr[7] = "CO";
tUSStatesAbbr[8] = "CT";
tUSStatesAbbr[9] = "DE";
tUSStatesAbbr[10] = "DC";
tUSStatesAbbr[11] = "FM";
tUSStatesAbbr[12] = "FL";
tUSStatesAbbr[13] = "GA";
tUSStatesAbbr[14] = "GU";
tUSStatesAbbr[15] = "HI";
tUSStatesAbbr[16] = "ID";
tUSStatesAbbr[17] = "IL";
tUSStatesAbbr[18] = "IN";
tUSStatesAbbr[19] = "IA";
tUSStatesAbbr[20] = "KS";
tUSStatesAbbr[21] = "KY";
tUSStatesAbbr[22] = "LA";
tUSStatesAbbr[23] = "ME";
tUSStatesAbbr[24] = "MH";
tUSStatesAbbr[25] = "MD";
tUSStatesAbbr[26] = "MA";
tUSStatesAbbr[27] = "MI";
tUSStatesAbbr[28] = "MN";
tUSStatesAbbr[29] = "MS";
tUSStatesAbbr[30] = "MO";
tUSStatesAbbr[31] = "MT";
tUSStatesAbbr[32] = "NE";
tUSStatesAbbr[33] = "NV";
tUSStatesAbbr[34] = "NH";
tUSStatesAbbr[35] = "NJ";
tUSStatesAbbr[36] = "NM";
tUSStatesAbbr[37] = "NY";
tUSStatesAbbr[38] = "NC";
tUSStatesAbbr[39] = "ND";
tUSStatesAbbr[40] = "MP";
tUSStatesAbbr[41] = "OH";
tUSStatesAbbr[42] = "OK";
tUSStatesAbbr[43] = "OR";
tUSStatesAbbr[44] = "PW";
tUSStatesAbbr[45] = "PA";
tUSStatesAbbr[46] = "PR";
tUSStatesAbbr[47] = "RI";
tUSStatesAbbr[48] = "SC";
tUSStatesAbbr[49] = "SD";
tUSStatesAbbr[50] = "TN";
tUSStatesAbbr[51] = "TX";
tUSStatesAbbr[52] = "UT";
tUSStatesAbbr[53] = "VT";
tUSStatesAbbr[54] = "VI";
tUSStatesAbbr[55] = "VA";
tUSStatesAbbr[56] = "WA";
tUSStatesAbbr[57] = "WV";
tUSStatesAbbr[58] = "WI";
tUSStatesAbbr[59] = "WY";
tUSStatesAbbr[60] = "AE";
tUSStatesAbbr[61] = "AE";
tUSStatesAbbr[62] = "AA";
tUSStatesAbbr[63] = "AE";
tUSStatesAbbr[64] = "AP";

Imagine Programming
08-19-2009, 04:54 PM
Something like:

Name
Country name codes and full names.
Type
Numerically Indexed
Tiers/Levels
2
Description
All (i believe) countries. every country is a table
containing the field Code and FullName.



tCountryCodes = {};
tCountryCodes[1] = {Code="AFG", FullName="Afghanistan"};
tCountryCodes[2] = {Code="ALA", FullName="Aland Islands"};
tCountryCodes[3] = {Code="ALB", FullName="Albania"};
tCountryCodes[4] = {Code="DZA", FullName="Algeria"};
tCountryCodes[5] = {Code="ASM", FullName="American Samoa"};
tCountryCodes[6] = {Code="AND", FullName="Andorra"};
tCountryCodes[7] = {Code="AGO", FullName="Angola"};
tCountryCodes[8] = {Code="AIA", FullName="Anguilla"};
tCountryCodes[9] = {Code="ATA", FullName="Antarctica"};
tCountryCodes[10] = {Code="ATG", FullName="Antigua and Barbuda"};
tCountryCodes[11] = {Code="ARG", FullName="Argentina"};
tCountryCodes[12] = {Code="ARM", FullName="Armenia"};
tCountryCodes[13] = {Code="ABW", FullName="Aruba"};
tCountryCodes[14] = {Code="AUS", FullName="Australia"};
tCountryCodes[15] = {Code="AUT", FullName="Austria"};
tCountryCodes[16] = {Code="AZE", FullName="Azerbaijan"};
tCountryCodes[17] = {Code="BHS", FullName="Bahamas"};
tCountryCodes[18] = {Code="BHR", FullName="Bahrain"};
tCountryCodes[19] = {Code="BGD", FullName="Bangladesh"};
tCountryCodes[20] = {Code="BRB", FullName="Barbados"};
tCountryCodes[21] = {Code="BLR", FullName="Belarus"};
tCountryCodes[22] = {Code="BEL", FullName="Belgium"};
tCountryCodes[23] = {Code="BLZ", FullName="Belize"};
tCountryCodes[24] = {Code="BEN", FullName="Benin"};
tCountryCodes[25] = {Code="BMU", FullName="Bermuda"};
tCountryCodes[26] = {Code="BTN", FullName="Bhutan"};
tCountryCodes[27] = {Code="BOL", FullName="Bolivia"};
tCountryCodes[28] = {Code="BIH", FullName="Bosnia and Herzegovina"};
tCountryCodes[29] = {Code="BWA", FullName="Botswana"};
tCountryCodes[30] = {Code="BVT", FullName="Bouvet Island"};
tCountryCodes[31] = {Code="BRA", FullName="Brazil"};
tCountryCodes[32] = {Code="IOT", FullName="British Indian Ocean Territory"};
tCountryCodes[33] = {Code="BRN", FullName="Brunei"};
tCountryCodes[34] = {Code="BGR", FullName="Bulgaria"};
tCountryCodes[35] = {Code="BFA", FullName="Burkina Faso"};
tCountryCodes[36] = {Code="BDI", FullName="Burundi"};
tCountryCodes[37] = {Code="KHM", FullName="Cambodia"};
tCountryCodes[38] = {Code="CMR", FullName="Cameroon"};
tCountryCodes[39] = {Code="CAN", FullName="Canada"};
tCountryCodes[40] = {Code="CPV", FullName="Cape Verde"};
tCountryCodes[41] = {Code="CYM", FullName="Cayman Islands"};
tCountryCodes[42] = {Code="CAF", FullName="Central African Republic"};
tCountryCodes[43] = {Code="TCD", FullName="Chad"};
tCountryCodes[44] = {Code="CHL", FullName="Chile"};
tCountryCodes[45] = {Code="CHN", FullName="People's Republic of China"};
tCountryCodes[46] = {Code="CXR", FullName="Christmas Island"};
tCountryCodes[47] = {Code="CCK", FullName="Cocos (Keeling) Islands"};
tCountryCodes[48] = {Code="COL", FullName="Colombia"};
tCountryCodes[49] = {Code="COM", FullName="Comoros"};
tCountryCodes[50] = {Code="COG", FullName="Republic of the Congo"};
tCountryCodes[51] = {Code="COD", FullName="Democratic Republic of the Congo"};
tCountryCodes[52] = {Code="COK", FullName="Cook Islands"};
tCountryCodes[53] = {Code="CRI", FullName="Costa Rica"};
tCountryCodes[54] = {Code="CIV", FullName="Côte d'Ivoire"};
tCountryCodes[55] = {Code="CRO", FullName="Croatia"};
tCountryCodes[56] = {Code="CUB", FullName="Cuba"};
tCountryCodes[57] = {Code="CYP", FullName="Cyprus"};
tCountryCodes[58] = {Code="CZE", FullName="Czech Republic"};
tCountryCodes[59] = {Code="DNK", FullName="Denmark"};
tCountryCodes[60] = {Code="DJI", FullName="Djibouti"};
tCountryCodes[61] = {Code="DMA", FullName="Dominica"};
tCountryCodes[62] = {Code="DOM", FullName="Dominican Republic"};
tCountryCodes[63] = {Code="ECU", FullName="Ecuador"};
tCountryCodes[64] = {Code="EGY", FullName="Egypt"};
tCountryCodes[65] = {Code="SLV", FullName="El Salvador"};
tCountryCodes[66] = {Code="GNQ", FullName="Equatorial Guinea"};
tCountryCodes[67] = {Code="EAS", FullName="East Timor"};
tCountryCodes[68] = {Code="ERI", FullName="Eritrea"};
tCountryCodes[69] = {Code="EST", FullName="Estonia"};
tCountryCodes[70] = {Code="ETH", FullName="Ethiopia"};
tCountryCodes[71] = {Code="FLK", FullName="Falkland Islands (Malvinas)"};
tCountryCodes[72] = {Code="FRO", FullName="Faroe Islands"};
tCountryCodes[73] = {Code="FJI", FullName="Fiji"};
tCountryCodes[74] = {Code="FIN", FullName="Finland"};
tCountryCodes[75] = {Code="FRA", FullName="France"};
tCountryCodes[76] = {Code="GUF", FullName="French Guiana"};
tCountryCodes[77] = {Code="PYF", FullName="French Polynesia"};
tCountryCodes[78] = {Code="ATF", FullName="French Southern Territories"};
tCountryCodes[79] = {Code="GAB", FullName="Gabon"};
tCountryCodes[80] = {Code="GMB", FullName="Gambia"};
tCountryCodes[81] = {Code="GEO", FullName="Georgia"};
tCountryCodes[82] = {Code="GER", FullName="Germany"};
tCountryCodes[83] = {Code="GHA", FullName="Ghana"};
tCountryCodes[84] = {Code="GIB", FullName="Gibraltar"};
tCountryCodes[85] = {Code="GRC", FullName="Greece"};
tCountryCodes[86] = {Code="GRL", FullName="Greenland"};
tCountryCodes[87] = {Code="GRD", FullName="Grenada"};
tCountryCodes[88] = {Code="GLP", FullName="Guadeloupe"};
tCountryCodes[89] = {Code="GUM", FullName="Guam"};
tCountryCodes[90] = {Code="GTM", FullName="Guatemala"};
tCountryCodes[91] = {Code="GGY", FullName="Guernsey"};
tCountryCodes[92] = {Code="GIN", FullName="Guinea"};
tCountryCodes[93] = {Code="GNB", FullName="Guinea-Bissau"};
tCountryCodes[94] = {Code="GUY", FullName="Guyana"};
tCountryCodes[95] = {Code="HTI", FullName="Haiti"};
tCountryCodes[96] = {Code="HMD", FullName="Heard Island and McDonald Islands"};
tCountryCodes[97] = {Code="HND", FullName="Honduras"};
tCountryCodes[98] = {Code="HKG", FullName="Hong Kong"};
tCountryCodes[99] = {Code="HUN", FullName="Hungary"};
tCountryCodes[100] = {Code="ISL", FullName="Iceland"};
tCountryCodes[101] = {Code="IND", FullName="India"};
tCountryCodes[102] = {Code="IDN", FullName="Indonesia"};
tCountryCodes[103] = {Code="IRN", FullName="Iran"};
tCountryCodes[104] = {Code="IRQ", FullName="Iraq"};
tCountryCodes[105] = {Code="IRL", FullName="Ireland"};
tCountryCodes[106] = {Code="IMN", FullName="Isle of Man"};
tCountryCodes[107] = {Code="ISR", FullName="Israel"};
tCountryCodes[108] = {Code="ITA", FullName="Italy"};
tCountryCodes[109] = {Code="JAM", FullName="Jamaica"};
tCountryCodes[110] = {Code="JPN", FullName="Japan"};
tCountryCodes[111] = {Code="JEY", FullName="Jersey"};
tCountryCodes[112] = {Code="JOR", FullName="Jordan"};
tCountryCodes[113] = {Code="KAZ", FullName="Kazakhstan"};
tCountryCodes[114] = {Code="KEN", FullName="Kenya"};
tCountryCodes[115] = {Code="KIR", FullName="Kiribati"};
tCountryCodes[116] = {Code="PRK", FullName="North Korea"};
tCountryCodes[117] = {Code="KOR", FullName="South Korea"};
tCountryCodes[118] = {Code="KWT", FullName="Kuwait"};
tCountryCodes[119] = {Code="KGZ", FullName="Kyrgyzstan"};
tCountryCodes[120] = {Code="LAO", FullName="Laos"};
tCountryCodes[121] = {Code="LVA", FullName="Latvia"};
tCountryCodes[122] = {Code="LBN", FullName="Lebanon"};
tCountryCodes[123] = {Code="LSO", FullName="Lesotho"};
tCountryCodes[124] = {Code="LBR", FullName="Liberia"};
tCountryCodes[125] = {Code="LBY", FullName="Libya"};
tCountryCodes[126] = {Code="LIE", FullName="Liechtenstein"};
tCountryCodes[127] = {Code="LTU", FullName="Lithuania"};
tCountryCodes[128] = {Code="LUX", FullName="Luxembourg"};
tCountryCodes[129] = {Code="MAC", FullName="Macao"};
tCountryCodes[130] = {Code="MKD", FullName="Republic of Macedonia"};
tCountryCodes[131] = {Code="MDG", FullName="Madagascar"};
tCountryCodes[132] = {Code="MWI", FullName="Malawi"};
tCountryCodes[133] = {Code="MYS", FullName="Malaysia"};
tCountryCodes[134] = {Code="MDV", FullName="Maldives"};
tCountryCodes[135] = {Code="MLI", FullName="Mali"};
tCountryCodes[136] = {Code="MLT", FullName="Malta"};
tCountryCodes[137] = {Code="MHL", FullName="Marshall Islands"};
tCountryCodes[138] = {Code="MTQ", FullName="Martinique"};
tCountryCodes[139] = {Code="MRT", FullName="Mauritania"};
tCountryCodes[140] = {Code="MUS", FullName="Mauritius"};
tCountryCodes[141] = {Code="MYT", FullName="Mayotte"};
tCountryCodes[142] = {Code="MEX", FullName="Mexico"};
tCountryCodes[143] = {Code="FSM", FullName="Federated States of Micronesia"};
tCountryCodes[144] = {Code="MDA", FullName="Republic of Moldova"};
tCountryCodes[145] = {Code="MCO", FullName="Monaco"};
tCountryCodes[146] = {Code="MNG", FullName="Mongolia"};
tCountryCodes[147] = {Code="MON", FullName="Montenegro"};
tCountryCodes[148] = {Code="MSR", FullName="Montserrat"};
tCountryCodes[149] = {Code="MAR", FullName="Morocco"};
tCountryCodes[150] = {Code="MOZ", FullName="Mozambique"};
tCountryCodes[151] = {Code="MMR", FullName="Myanmar"};
tCountryCodes[152] = {Code="NAM", FullName="Namibia"};
tCountryCodes[153] = {Code="NRU", FullName="Nauru"};
tCountryCodes[154] = {Code="NPL", FullName="Nepal"};
tCountryCodes[155] = {Code="NLD", FullName="Netherlands"};
tCountryCodes[156] = {Code="ANT", FullName="Netherlands Antilles"};
tCountryCodes[157] = {Code="NCL", FullName="New Caledonia"};
tCountryCodes[158] = {Code="NZL", FullName="New Zealand"};
tCountryCodes[159] = {Code="NIC", FullName="Nicaragua"};
tCountryCodes[160] = {Code="NER", FullName="Niger"};
tCountryCodes[161] = {Code="NGA", FullName="Nigeria"};
tCountryCodes[162] = {Code="NIU", FullName="Niue"};
tCountryCodes[163] = {Code="NFK", FullName="Norfolk Island"};
tCountryCodes[164] = {Code="MNP", FullName="Northern Mariana Islands"};
tCountryCodes[165] = {Code="NOR", FullName="Norway"};
tCountryCodes[166] = {Code="OMN", FullName="Oman"};
tCountryCodes[167] = {Code="PAK", FullName="Pakistan"};
tCountryCodes[168] = {Code="PLW", FullName="Palau"};
tCountryCodes[169] = {Code="PSE", FullName="Palestinian territories"};
tCountryCodes[170] = {Code="PAN", FullName="Panama"};
tCountryCodes[171] = {Code="PNG", FullName="Papua New Guinea"};
tCountryCodes[172] = {Code="PRY", FullName="Paraguay"};
tCountryCodes[173] = {Code="PER", FullName="Peru"};
tCountryCodes[174] = {Code="PHL", FullName="Philippines"};
tCountryCodes[175] = {Code="PCN", FullName="Pitcairn Islands"};
tCountryCodes[176] = {Code="POL", FullName="Poland"};
tCountryCodes[177] = {Code="PRT", FullName="Portugal"};
tCountryCodes[178] = {Code="PRI", FullName="Puerto Rico"};
tCountryCodes[179] = {Code="QAT", FullName="Qatar"};
tCountryCodes[180] = {Code="REU", FullName="Réunion"};
tCountryCodes[181] = {Code="ROU", FullName="Romania"};
tCountryCodes[182] = {Code="RUS", FullName="Russia"};
tCountryCodes[183] = {Code="RWA", FullName="Rwanda"};
tCountryCodes[184] = {Code="SHN", FullName="Saint Helena"};
tCountryCodes[185] = {Code="KNA", FullName="Saint Kitts and Nevis"};
tCountryCodes[186] = {Code="LCA", FullName="Saint Lucia"};
tCountryCodes[187] = {Code="SPM", FullName="Saint Pierre and Miquelon"};
tCountryCodes[188] = {Code="VCT", FullName="Saint Vincent and the Grenadines"};
tCountryCodes[189] = {Code="WSM", FullName="Samoa"};
tCountryCodes[190] = {Code="SMR", FullName="San Marino"};
tCountryCodes[191] = {Code="STP", FullName="Sao Tome and Principe"};
tCountryCodes[192] = {Code="SAU", FullName="Saudi Arabia"};
tCountryCodes[193] = {Code="SEN", FullName="Senegal"};
tCountryCodes[194] = {Code="SCG", FullName="Serbia"};
tCountryCodes[195] = {Code="SYC", FullName="Seychelles"};
tCountryCodes[196] = {Code="SLE", FullName="Sierra Leone"};
tCountryCodes[197] = {Code="SGP", FullName="Singapore"};
tCountryCodes[198] = {Code="SVK", FullName="Slovakia"};
tCountryCodes[199] = {Code="SVN", FullName="Slovenia"};
tCountryCodes[200] = {Code="SLB", FullName="Solomon Islands"};
tCountryCodes[201] = {Code="SOM", FullName="Somalia"};
tCountryCodes[202] = {Code="SAF", FullName="South Africa"};
tCountryCodes[203] = {Code="SGS", FullName="South Georgia and the South Sandwich Islands"};
tCountryCodes[204] = {Code="SPA", FullName="Spain"};
tCountryCodes[205] = {Code="SRI", FullName="Sri Lanka"};
tCountryCodes[206] = {Code="SDN", FullName="Sudan"};
tCountryCodes[207] = {Code="SUR", FullName="Suriname"};
tCountryCodes[208] = {Code="SJM", FullName="Svalbard and Jan Mayen"};
tCountryCodes[209] = {Code="SWZ", FullName="Swaziland"};
tCountryCodes[210] = {Code="SWE", FullName="Sweden"};
tCountryCodes[211] = {Code="CHE", FullName="Switzerland"};
tCountryCodes[212] = {Code="SYR", FullName="Syrianame=Syrian Arab Republic"};
tCountryCodes[213] = {Code="TWN", FullName="Taiwan (Republic of China)"};
tCountryCodes[214] = {Code="TJK", FullName="Tajikistan"};
tCountryCodes[215] = {Code="TZA", FullName="United Republic of Tanzania"};
tCountryCodes[216] = {Code="THA", FullName="Thailand"};
tCountryCodes[217] = {Code="TLS", FullName="Timor-Leste"};
tCountryCodes[218] = {Code="TGO", FullName="Togo"};
tCountryCodes[219] = {Code="TKL", FullName="Tokelau"};
tCountryCodes[220] = {Code="TON", FullName="Tonga"};
tCountryCodes[221] = {Code="TTO", FullName="Trinidad and Tobago"};
tCountryCodes[222] = {Code="TUN", FullName="Tunisia"};
tCountryCodes[223] = {Code="TUR", FullName="Turkey"};
tCountryCodes[224] = {Code="TKM", FullName="Turkmenistan"};
tCountryCodes[225] = {Code="TCA", FullName="Turks and Caicos Islands"};
tCountryCodes[226] = {Code="TUV", FullName="Tuvalu"};
tCountryCodes[227] = {Code="UGA", FullName="Uganda"};
tCountryCodes[228] = {Code="UKR", FullName="Ukraine"};
tCountryCodes[229] = {Code="ARE", FullName="United Arab Emirates"};
tCountryCodes[230] = {Code="UK ", FullName="United Kingdom"};
tCountryCodes[231] = {Code="USA", FullName="United States"};
tCountryCodes[232] = {Code="UMI", FullName="United States Minor Outlying Islands"};
tCountryCodes[233] = {Code="URY", FullName="Uruguay"};
tCountryCodes[234] = {Code="UZB", FullName="Uzbekistan"};
tCountryCodes[235] = {Code="VUT", FullName="Vanuatu"};
tCountryCodes[236] = {Code="VAT", FullName="Vatican City (Holy See)"};
tCountryCodes[237] = {Code="VEN", FullName="Venezuela"};
tCountryCodes[238] = {Code="VNM", FullName="Vietnam"};
tCountryCodes[239] = {Code="VGB", FullName="British Virgin Islands"};
tCountryCodes[240] = {Code="VIR", FullName="United States Virgin Islands"};
tCountryCodes[241] = {Code="WLF", FullName="Wallis and Futuna"};
tCountryCodes[242] = {Code="ESH", FullName="Western Sahara"};
tCountryCodes[243] = {Code="YEM", FullName="Yemen"};
tCountryCodes[244] = {Code="ZMB", FullName="Zambia"};
tCountryCodes[245] = {Code="ZWE", FullName="Zimbabwe"};