StatePlaneToLatLon()

 StatePlaneToLatLon(Easting, Northing, State_Code) Converts input state plane (NAD83) coordinates to latitude and longitude. Can also convert Minnesota and Wisconsin County Coordinates to latitude and longitude (see below). Input:       Easting = State plane or county easting coordinate, in meters                        (northing positive) (number)                   Northing = State plane or county northing coordinate, in meters (number)                  State_Code = U.S. state plane or county code (see below) (number) Output:      Latitude and longitude in decimal degrees                        (easting, northing positive) (vector)

Notes:

- If unfamiliar with Excel vector functions, see Vector Functions reference

- State plane coordinates are often provided in feet.  Be sure to convert to meters before using this function.  Also note that most state plane coordinates are in U.S. Survey Feet (3937 yards = 3600 meters).  This is slightly different than the more common international foot (1 foot = 0.3048 meters).  If you are not doing very high precision work, the slight difference between these two conversions will not matter.

- The list of  state codes follows the convention in SPCS83, reproduced below.

- By special request, this function can also convert from Minnesota County Coordinates.  See below for county codes.

 State Region State Code State Region State Code AL E 101 MS E 2301 W 102 W 2302 AK 1 5001 MO E 2401 2 5002 C 2402 3 5003 W 2403 4 5004 5 5005 MT 2500 6 5006 7 5007 NE 2600 8 5008 9 5009 NV E 2701 10 5010 C 2702 W 2703 AZ E 201 C 202 NH 2800 W 203 NJ 2900 AR N 301 S 302 NM E 3001 C 3002 CA 1 401 W 3003 2 402 3 403 4 404 NY E 3101 5 405 C 3102 6 406 W 3103 L 3104 NC 3200 CO N 501 C 502 ND N 3301 S 503 S 3302 CT 600 OH N 3401 S 3402 DE 700 OK N 3501 FL E 901 S 3502 W 902 N 903 OR N 3601 S 3602 GA E 1001 W 1002 PA N 3701 S 3702 HI 1 5101 2 5102 RI 3800 3 5103 4 5104 SC 3900 5 5105 SD N 4001 ID E 1101 S 4002 C 1102 W 1103 TN 4100 IL E 1201 TX N 4201 W 1202 NC 4202 C 4203 IN E 1301 SC 4204 W 1302 S 4205 IA N 1401 UT N 4301 S 1402 C 4302 S 4303 KS N 1501 S 1502 VT 4400 KY 1Z 1600 VA N 4501 N 1601 S 4501 S 1602 WA N 4601 LA N 1701 S 4602 S 1702 SH 1703 WV N 4701 S 4702 ME E 1801 W 1802 WI N 4801 C 4802 MD 1900 S 4803 MA M 2001 WY E 4901 I 2002 EC 4902 WC 4903 MI N 2111 W 4904 C 2112 S 2113 VI PR 5200 MN N 2201 C 2202 AS 5300 S 2203 GU 5400

Minnesota County Codes

 County Code County Code Aitkin 22001 Marshal 220048 Anoka 22002 Martin 220049 Becker 22003 Mc Leod 220050 Beltrami North 22004 Meeker 220051 Beltrami South 22005 Mille Lacs 220052 Benton 22006 Morrison 220053 Big Stone 22007 Mower 220054 Blue Earth 22008 Murray 220055 Brown 22009 Nicollet 220056 Carlton 220010 Nobles 220057 Carver 220011 Norman 220058 Cass North 220012 Olmsted 220059 Cass South 220013 Ottertail 220060 Chippewa 220014 Pennington 220061 Chisago 220015 Pine 220062 Clay 220016 Pipestone 220063 Clearwater 220017 Polk 220064 Cook North 220018 Pope 220065 Cook South 220019 Ramsey 220066 Cottonwood 220020 Red Lake 220067 Crow Wing 220021 Redwood 220068 Dakota 220022 Renville 220069 Dodge 220023 Rice 220070 Douglas 220024 Rock 220071 Faribault 220025 Roseau 220072 Fillmore 220026 Scott 220073 Freeborn 220027 Sherburne 220074 Goodhue 220028 Sibley 220075 Grant 220029 Stearns 220076 Houston 220030 Steele 220077 Hubbard 220031 Stevens 220078 Isanti 220032 St Louis Central 220079 Itasca North 220033 St Louis North 220080 Itasca South 220034 St Louis South 220081 Jackson 22035 Swift 220082 Kanabec 22036 Todd 220083 Kandiyohi 22037 Traverse 220084 Kittson 22038 Wabasha 220085 Koochiching 22039 Wadena 220086 Lac Qui Parle 22040 Waseca 220087 Lake 22041 Washington 220088 Lake Woods North 22042 Watonwan 220089 Lake Woods South 220043 Wilkin 220090 Le Sueur 220044 Winona 220091 Lincoln 220045 Wright 220092 Lyon 220046 Yellow Medicine 220093 Mahnomen 220047

Wisconsin County Coordinate System Codes

 County Code County Code Adams 48001 Manitowoc 480037 Ashland 48002 Marathon 480038 Barron 48003 Marinette 480039 Bayfield 48004 Marquette 480040 Brown 48005 Menominee 480041 Buffalo 48006 Monroe 480042 Burnett 48007 Oconto 480043 Calumet 48008 Oneida 480044 Chippewa 48009 Outagamie 480045 Clark 480010 Ozaukee 480046 Columbia 480011 Pepin 480047 Crawford 480012 Pierce 480048 Dane 480013 Polk 480049 Dodge 480014 Portage 480050 Door 480015 Price 480051 Douglas 480016 Racine 480052 Dunn 480017 Richland 480053 Eau Claire 480018 Rock 480054 Florence 480019 Rusk 480055 Fond Du Lac 480020 Sauk 480056 Forest 480021 Sawyer 480057 Grant 480022 Shawano 480058 Green Lake 480023 Sheboygan 480059 Green 480024 St Croix 480060 Iowa 480025 Taylor 480061 Iron 480026 Trempealeau 480062 Jackson 480027 Vernon 480063 Jefferson 480028 Vilas 480064 Juneau 480029 Walworth 480065 Kenosha 480030 Washburn 480066 Kewaunee 480031 Washington 480067 Langlade 480032 Waukesha 480068 La Crosse 480033 Waupaca 480069 La Fayette 480034 Waushara 480070 Lincoln 22035 Winnebago 480071 Milwaukee 22036 Wood 480072
© DimensionEngine 2015.   For questions or bug reports, email us.