Aplicar acrescimo de info na optim.jurisdiction

[ppKrauss]

Aplicar acrescimo de info na optim.jurisdiction

[ppKrauss]

Usando elongation_factor para obter boas amostragens para teste de cobertura, ver https://github.com/osm-codes/WS/blob/main/src/country_sample_function.sql Exemplo: select * from osmc_country_sample('CO');. Falta ajustar ao schema optim, hoje na base dl03t_main.

citype	isolabel_ext	osm_id	side	elongfact
peq-nonalong	CO-ANT-Sabaneta	1307270	3.9	1.14
peq-nonalong	CO-RIS-Virginia	1348326	5.7	1.58
peq-nonalong	CO-BOY-Iza	1315386	5.9	1.54
peq-nonalong	CO-QUI-Buenavista	1347532	6.1	1.24
peq-nonalong	CO-ANT-Estrella	1307284	6.2	1.53
peq-nonalong	CO-ATL-Sabanagrande	1341558	6.4	1.32
peq-along	CO-NAR-Providencia	11894047	6.4	2.61
peq-along	CO-VAC-Ulloa	1311763	6.5	3.64
peq-along	CO-NSA-PuertoSantander	11896145	6.7	2.95
peq-along	CO-SAN-California	1343387	6.7	2.74
peq-along	CO-NAR-Aldana	11333702	6.8	2.74
peq-along	CO-CUN-Alban	1355693	7.3	2.8
gr-nonalong	CO-VAU-Mitu	11382140	127	1.67
gr-nonalong	CO-CAU-Guapi	1310021	50.6	1.36
gr-nonalong	CO-TOL-Rioblanco	1308614	45.2	1.63
gr-nonalong	CO-COR-Ayapel	1343439	43.9	1.61
gr-nonalong	CO-LAG-Dibulla	1314633	41.9	1.55
gr-nonalong	CO-CHO-SanJosePalmar	1343038	39.7	1.26
gr-along	CO-CAQ-Solano	1342101	205.3	3.39
gr-along	CO-CAQ-SanVicenteCaguan	1342095	132.8	2.73
gr-along	CO-GUV-SanJoseGuaviare	11378346	129.4	4.19
gr-along	CO-GUA-Inirida	2346720	125.9	2.62
gr-along	CO-GUA-Barrancominas	11334013	119.9	3.23
gr-along	CO-AMA-PuertoArica	1335190	116.7	2.69
big	CO-VID-Cumaribo	11319781	255.3	2.45
big	CO-VID-Primavera	11319669	132.7	1.95
big	CO-MET-PuertoCarreno	11371824	131.3	1.81
small	CO-SAN-Palmar	1423515	4.5	2.24
small	CO-ANT-Itagui	1343279	4.5	1.81
small	CO-BOY-Busbanza	1315385	5.2	1.62

[0e1]

As views citadas na issue foram adicionadas em optim-step6-metrics.

Os updates devem ser realizados sempre que novas geometrias forem adicionadas na tabela de jurisdições.

Em man-updateJurisd estão os passos para trabalhar em optim.jurisdiction e optim.jurisdiction_geom.

Issues associadas: #37, digital-guard/preserv#116