Planilha Nova Cidades.xlsx

ESTADO

CIDADE

Bahia

Feira de Santana

Bahia

Salvador

Distrito Federal

Brasília

Ceará

Fortaleza

Espírito Santo

Alegre

Espírito Santo

Boa Esperança

Espírito Santo

Linhares

Espírito Santo

Santa Tereza

Espírito Santo

São Gabriel da Palha

Espírito Santo

São Mateus

Espírito Santo

Venda Nova

Espírito Santo Goiás

Viória Alvorada do Norte

Goiás

Alto Garças

Goiás

Aporé

Goiás

Aruamã

Goiás

Caipônia

Goiás

Campo Alegre

Goiás

Catalão

Goiás Goiás Goiás Goiás Goiás Mato Grosso do Sul Mato Grosso do Sul Minas Gerais Minas Gerais Paraíba Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná

Ceres Goiânia Israelândia Morrinhos Niquelândia Campo Grande Chapadão do Sul Belo Horizonte Belo Horizonte 1.1 João Pessoa Antonina Araucária Apucarana Bandeirantes Cambará Cascavel Cerro Azul Cianorte Clevelânida Curitiba Curitiba - Prado Velho Francisco Beltrão Guarapuava Guaraqueçaba Ivaiporã Jacarezinho

Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Paraná Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio de Janeiro Rio Grande do Sul Rio Grande do Sul Rio Grande do Sul Rio Grande do Sul Santa Catarina Santa Catarina Santa Catarina Santa Catarina São Paulo São Paulo São Paulo São Paulo

Jacarezinho 1.1 Laranjeiras do Sul Londrina Morretes Nova Cantu Palmas Palmital Palotina Palotina 1.1 Palotina 1.2 Palotina 1.3 Palotina 1.4 Paranavaí Pato Branco Piraquara Planalto Ponta Grossa Porto Amazonas Santa Izabel do Ivai São Miguel do Iguaçu Teixeiras Soares Telêmaco Borba Tibagi Tomazina Umuarama Álcalis Alto da Boa Vista Angra dos Reis Campos Cidade do Rio de Janeiro Cidade do Rio de Janeiro Cidade do Rio de Janeiro Cordeiro Escola Agrícola Ilha Guaíba Itaperuna Macaé Nova Friburgo Resende Santa Cruz Vassoura Porto Alegre Porto Alegre 1.1 Porto Alegre 1.2 Porto Alegre 1.3 Aracruz Florianópolis Florianópolis 1.1 Urussanga São Carlos Campinas 1.1 Campinas 1.1 Presidente Prudente

São Paulo São Paulo São Paulo São Paulo São Paulo Tocantins Tocantins Tocantins Tocantins Tocantins Tocantins Tocantins Tocantins Tocantins Tocantins Sertão Oriental Nordestino

Cidade de São Paulo Cidade de São Paulo 1.1 Cidade de São Paulo 1.2 Cidade de São Paulo 1.3 Cidade de São Paulo 1.4 Alvorada Araguatins Dianópolis Formoso do Araguaia Guaraí Miracema do Tocantins Natividade Projeto Rio Formoso Turipantins Tocantinópolis Nordeste

K

m

to

n

716

0.241

11

0.761

1065.66

0.163

24

0.743

10125

10

16

0.945

506.99

8

1497.781

0.181 0.258

19.294

0.61 0.855

596.38

0.23

8.534

0.67

3647.235

0.223

20.665

1

632.265

0.714

13.543

0.714

1309.205

0.23

15.375

0.821

4999.206

0.191

49.999

0.983

4147.062

0.205

33.842

1

4003.611 1018.591

0.203

49.997

0.931

0.1354

12

0.7598

873.374

0.1328

10

0.7418

1265.319

0.1368

15

0.7853

1274.09

0.152

12

0.7599

1138.151

0.1643

12

0.7599

975.439

0.1643

12

0.7598

1018.591

0.1323

12

0.76

959.621 920.45 1120.211 1003.46 972.299 43.019 8092.229 1447.87 24.131 369.4 5209.55 2505.53 1301.07 1077.21 1772.96 1062.92 1625.55 2115.18 2553.88 5950 5726.64 1012.28 1039.68 1479.78 676.71 31200

0.1764 0.1422 0.1598 0.1376 0.1204 0.55 0.1335 0.1 0.1 0.15 0.16 0.177 0.177 0.157 0.126 0.141 0.138 0.145 0.166 0.217 0.159 0.182 0.171 0.172 0.158 3

12 12 12 10 10 62 9.2 20 20 5 57 13 15 10 17 5 18 22 24 26 41 9 10 19 1 50

0.7601 0.7599 0.7598 0.7418 0.742 0.053 0.6999 0.84 0.84 0.568 0.978 0.988 0.836 0.781 0.867 0.776 0.86 0.849 0.917 1.15 1041 0.76 0.799 0.802 0.726 1.38

59820 771.97 3132.56 2160.23 2778.43 1303.47 1548.46 2492.3 2618.18 2737.79 2866.82 3041.59 2808.67 879.43 1537.8 1659.59 1902.39 254.31 1824.73 2886.69 959.18 3235.19 1592.58 2676.7 1752.27 3281.158 4378.133 721.802 1133.836 5950 99.154 3463 612.197 3812.02 1045.123 4999.882 444.258 2629.477 1652.972 2474.281 3086.29 23 29 48 95 1298.382 145 597 3445.7 25.33 42.081 2524.86 5069.059

10 0.148 0.0093 0.155 0.149 0.126 0.13 2 5 10 20 50 0.104 0.152 0.12 0.156 0.152 0.196 0.166 0.124 0.177 0.162 0.136 0.149 0.148 0.222 0.227 0.211 0.183 0.217 0.217 0.172 0.185 0.218 0.244 0.196 0.263 0.236 0.182 0.2113 0.2 5 10 15 30 0.12 0.25 0.32 0.138 0.236 0.1429 0.1359 0.168

50 8 30 24 24 12 16 29 29 29 29 29 33 9 17 14 21 27 17 26 9 24 11 29 17 44.204 49.157 10.566 20.667 26 26 22 5 34.565 49.945 34.462 6.266 24.664 21.410 37.4228 22.081 20.981 1.18 3 26 16 20 20 8

1.49 0.726 0.939 0.89 0.94 0.815 0.834 0.873 0.848 0.833 0.822 0.81 0.93 0.732 0.859 0.84 0.893 0.952 0.892 0.927 0.789 0.968 0.882 0.931 0.84 1 0.999 0.72 0.807 1.15 1.15 0.761 0.695 0.999 0.679 0.986 0.655 0.975 0.767 0.9491 1 2.4 3.9 8.6 16.5 0.786 0.34 0.73 1012 0.935 0.9483 0.948 0.61

29.13 1747 4855.3 57.71 3463 9989.56 4732.318 4642.242 8740.42 8650.36 5958095 2113.85 8950.25 2300.09 9862 3609.11

0.181 0.181 0.181 0.172 0.172 0.211 0.229 0.162 0.176 0.178 0.173 0.206 0.194 0.155 0.187 0.12

15 15 15 22 22 56.638 46.957 35.878 54.663 41.365 35.298 30.296 71.072 31.386 69.638 30

0.89 0.89 0.89 0.74 1025 1087 0.995 1051 1078 1098 1043 0.845 1027 0.869 1072 0.95

STRING DE ADIÇÃO AO BD (NÃO ALTERAR ('Feira de Santana',716,0.241,11,0.761) ('Salvador',1065.66,0.163,24,0.743) ('Brasília',10125,10,16,0.945) ('Fortaleza',506.99,0.181,8,0.61) ('Alegre',1497.781,0.258,19.294,0.855) ('Boa Esperança',596.38,0.23,8.534,0.67) ('Linhares',3647.235,0.223,20.665,1) ('Santa Tereza',632.265,0.714,13.543,0.714) ('São Gabriel da Palha',1309.205,0.23,15.375,0.821) ('São Mateus ',4999.206,0.191,49.999,0.983) ('Venda Nova',4147.062,0.205,33.842,1) ('Viória',4003.611,0.203,49.997,0.931) ('Alvorada do Norte',1018.591,0.1354,12,0.7598) ('Alto Garças',873.374,0.1328,10,0.7418) ('Aporé',1265.319,0.1368,15,0.7853) ('Aruamã',1274.09,0.152,12,0.7599) ('Caipônia',1138.151,0.1643,12,0.7599) ('Campo Alegre',975.439,0.1643,12,0.7598) ('Catalão',1018.591,0.1323,12,0.76) ('Ceres',959.621,0.1764,12,0.7601) ('Goiânia',920.45,0.1422,12,0.7599) ('Israelândia',1120.211,0.1598,12,0.7598) ('Morrinhos',1003.46,0.1376,10,0.7418) ('Niquelândia',972.299,0.1204,10,0.742) ('Campo Grande',43.019,0.55,62,0.053) ('Chapadão do Sul',8092.229,0.1335,9.2,0.6999) ('Belo Horizonte ',1447.87,0.1,20,0.84) ('Belo Horizonte 1.1',24.131,0.1,20,0.84) ('João Pessoa',369.4,0.15,5,0.568) ('Antonina',5209.55,0.16,57,0.978) ('Araucária',2505.53,0.177,13,0.988) ('Apucarana',1301.07,0.177,15,0.836) ('Bandeirantes',1077.21,0.157,10,0.781) ('Cambará',1772.96,0.126,17,0.867) ('Cascavel',1062.92,0.141,5,0.776) ('Cerro Azul',1625.55,0.138,18,0.86) ('Cianorte',2115.18,0.145,22,0.849) ('Clevelânida',2553.88,0.166,24,0.917) ('Curitiba ',5950,0.217,26,1.15) ('Curitiba - Prado Velho',5726.64,0.159,41,1041) ('Francisco Beltrão',1012.28,0.182,9,0.76) ('Guarapuava',1039.68,0.171,10,0.799) ('Guaraqueçaba',1479.78,0.172,19,0.802) ('Ivaiporã',676.71,0.158,1,0.726) ('Jacarezinho ',31200,3,50,1.38)

('Jacarezinho 1.1',59820,10,50,1.49) ('Laranjeiras do Sul',771.97,0.148,8,0.726) ('Londrina',3132.56,0.0093,30,0.939) ('Morretes',2160.23,0.155,24,0.89) ('Nova Cantu',2778.43,0.149,24,0.94) ('Palmas',1303.47,0.126,12,0.815) ('Palmital',1548.46,0.13,16,0.834) ('Palotina',2492.3,2,29,0.873) ('Palotina 1.1',2618.18,5,29,0.848) ('Palotina 1.2',2737.79,10,29,0.833) ('Palotina 1.3',2866.82,20,29,0.822) ('Palotina 1.4',3041.59,50,29,0.81) ('Paranavaí',2808.67,0.104,33,0.93) ('Pato Branco',879.43,0.152,9,0.732) ('Piraquara',1537.8,0.12,17,0.859) ('Planalto',1659.59,0.156,14,0.84) ('Ponta Grossa',1902.39,0.152,21,0.893) ('Porto Amazonas',254.31,0.196,27,0.952) ('Santa Izabel do Ivai',1824.73,0.166,17,0.892) ('São Miguel do Iguaçu',2886.69,0.124,26,0.927) ('Teixeiras Soares',959.18,0.177,9,0.789) ('Telêmaco Borba',3235.19,0.162,24,0.968) ('Tibagi',1592.58,0.136,11,0.882) ('Tomazina',2676.7,0.149,29,0.931) ('Umuarama',1752.27,0.148,17,0.84) ('Álcalis',3281.158,0.222,44.204,1) ('Alto da Boa Vista',4378.133,0.227,49.157,0.999) ('Angra dos Reis',721.802,0.211,10.566,0.72) ('Campos',1133.836,0.183,20.667,0.807) ('Cidade do Rio de Janeiro',5950,0.217,26,1.15) ('Cidade do Rio de Janeiro',99.154,0.217,26,1.15) ('Cidade do Rio de Janeiro',3463,0.172,22,0.761) ('Cordeiro',612.197,0.185,5,0.695) ('Escola Agrícola',3812.02,0.218,34.565,0.999) ('Ilha Guaíba',1045.123,0.244,49.945,0.679) ('Itaperuna',4999.882,0.196,34.462,0.986) ('Macaé',444.258,0.263,6.266,0.655) ('Nova Friburgo',2629.477,0.236,24.664,0.975) ('Resende',1652.972,0.182,21.410,0.767) ('Santa Cruz',2474.281,0.2113,37.4228,0.9491) ('Vassoura',3086.29,0.2,22.081,1) ('Porto Alegre',23,5,-,2.4) ('Porto Alegre 1.1',29,10,-,3.9) ('Porto Alegre 1.2',48,15,-,8.6) ('Porto Alegre 1.3',95,30,-,16.5) ('Aracruz',1298.382,0.12,20.981,0.786) ('Florianópolis ',145,0.25,1.18,0.34) ('Florianópolis 1.1',597,0.32,3,0.73) ('Urussanga',3445.7,0.138,26,1012) ('São Carlos',25.33,0.236,16,0.935) ('Campinas 1.1',42.081,0.1429,20,0.9483) ('Campinas 1.1',2524.86,0.1359,20,0.948) ('Presidente Prudente',5069.059,0.168,8,0.61)

('Cidade de São Paulo',29.13,0.181,15,0.89) ('Cidade de São Paulo 1.1',1747,0.181,15,0.89) ('Cidade de São Paulo 1.2',4855.3,0.181,15,0.89) ('Cidade de São Paulo 1.3',57.71,0.172,22,0.74) ('Cidade de São Paulo 1.4',3463,0.172,22,1025) ('Alvorada ',9989.56,0.211,56.638,1087) ('Araguatins',4732.318,0.229,46.957,0.995) ('Dianópolis',4642.242,0.162,35.878,1051) ('Formoso do Araguaia',8740.42,0.176,54.663,1078) ('Guaraí',8650.36,0.178,41.365,1098) ('Miracema do Tocantins',5958095,0.173,35.298,1043) ('Natividade',2113.85,0.206,30.296,0.845) ('Projeto Rio Formoso',8950.25,0.194,71.072,1027) ('Turipantins',2300.09,0.155,31.386,0.869) ('Tocantinópolis',9862,0.187,69.638,1072) ('Nordeste',3609.11,0.12,30,0.95) ('',,,,) ('',,,,) ('',,,,) ('',,,,) ('',,,,) ('',,,,) ('',,,,)

OBSERVAÇÕES

USAR PONTO PARA SEPARAR (369.4)