Usuário:Peter/Notes2023-08

Mosaico de países cabe em menos de 300

Pelo NaturalEarthData temos max(gid)=254 e 237 mapas relevantes: AD, AE, AF, AG, AI, AL, AM, AO, AQ, AR, AS, AT, AU, AW, AX, AZ, BA, BB, BD, BE, BF, BG, BH, BI, BJ, BL, BM, BN, BO, BR, BS, BT, BW, BY, BZ, CA, CD, CF, CG, CH, CI, CK, CL, CM, CN, CO, CR, CU, CV, CW, CY, CZ, DE, DJ, DK, DM, DO, DZ, EC, EE, EG, EH, ER, ES, ET, FI, FJ, FK, FM, FO, GA, GB, GD, GE, GG, GH, GI, GL, GM, GN, GQ, GR, GS, GT, GU, GW, GY, HK, HM, HN, HR, HT, HU, ID, IE, IL, IM, IN, IO, IQ, IR, IS, IT, JE, JM, JO, JP, KE, KG, KH, KI, KM, KN, KP, KR, KW, KY, KZ, LA, LB, LC, LI, LK, LR, LS, LT, LU, LV, LY, MA, MC, MD, ME, MF, MG, MH, MK, ML, MM, MN, MO, MP, MR, MS, MT, MU, MV, MW, MX, MY, MZ, NA, NC, NE, NF, NG, NI, NL, NP, NR, NU, NZ, OM, PA, PE, PF, PG, PH, PK, PL, PM, PN, PR, PS, PT, PW, PY, QA, RO, RS, RU, RW, SA, SB, SC, SD, SE, SG, SH, SI, SK, SL, SM, SN, SO, SR, SS, ST, SV, SX, SY, SZ, TC, TD, TF, TG, TH, TJ, TL, TM, TN, TO, TR, TT, TV, TW, TZ, UA, UG, UM, US, UY, UZ, VA, VC, VE, VG, VI, VN, VU, WF, WS, XK, YE, ZA, ZM, ZW.

Conclusão: vamos usar ID padrão NaturalEarthData ao invés de ISO.

Questões sobre PostgIS BBOX

é uma geometria ou um outro tipo de dado?
se não é geometria, faz uso do SRID ou normaliza tudo para LatLong?

Sobre ser outro tipo de dado, sim, aparentemente temos

ST_Extent(geom) = "BOX(-74.01847469099994 -33.74228037499992,-28.877064581999946 5.267224833000029)"
ST_SetSRID(ST_Extent(geom),4326) = "POLYGON((-74.01847469099994 -33.74228037499992,-74.01847469099994 5.267224833000029,-28.877064581999946 5.267224833000029,-28.877064581999946 -33.74228037499992,-74.01847469099994 -33.74228037499992))"