search

digital-guard / preserv-CO

Preservación digital de las principales fuentes de la base de datos AddressForAll-Colombia.
http://git.digital-guard.org/preserv-co
0 stars 0 forks source link

preserv-CO/data/_pk003 make paercel trava o servidor #4

Closed crebollobr closed 3 years ago

crebollobr commented 3 years ago

preserv-CO/data/_pk003 make parcel trava o servidor

NOTICE: Ring Self-intersection at or near point -72.629879971999969 2.3329534630000239 SSL SYSCALL error: EOF detected connection to server was lost psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: the database system is in recovery mode psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: the database system is in recovery mode Shapefile type: Polygon Postgis type: MULTIPOLYGON[2] psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: FATAL: the database system is in recovery mode Confira os resultados nas tabelas ingest.layer_file e ingest.feature_asis. FIM.

0e1 commented 3 years ago

Utilizar method_opts: -D no layer faz com que o shp2pgsql importe os arquivos sem muita demora.

No entanto, o arquivo _RTERRENO.shp é muito grande para a função jsonb_pg_stat_file, especificamente a função pg_read_binary_file que lê o arquivo para ser calculado o md5:

ERROR:  file length too large
CONTEXT:  SQL function "jsonb_pg_stat_file" statement 1
SQL function "getmeta_to_file" statement 1

Já o arquivo _UTERRENO.shp parece ter vários problemas nas geometrias o que leva a operação de insert em feature_asis retornar:

SSL SYSCALL error: EOF detected
connection to server was lost

Reparar que a quantidade de feições de _UTERRENO.shp parece não ser o problema. A ingestão de _U_NOMENCLATURADOMICILIARIA.shp, que é da mesma ordem de grandeza de _UTERRENO.shp, ocorreu sem problemas.

Acho que o caminho mais simples é quebrar os arquivos _RTERRENO e _UTERRENO em arquivos menores.

Tamanho e feições dos arquivos:

R_TERRENO.shp 2.735.483 feições 1,7G

U_TERRENO.shp 3.296.595 feições 801M

R_NOMENCLATURA_DOMICILIARIA.shp 87.040 feições 292M

U_NOMENCLATURA_DOMICILIARIA.shp 3.027.719 feições 737M

Resultados de teste de ingestão:

a4a@ubuntu:/opt/gits/_dg/preserv-CO/data/_pk003$ make geoaddress
------------------------------------------
------ Layer tipo geoaddress_full  ------
-- Incluindo dados do arquivo-1 do package-3_001 na base ingest1 --
 Nome-hash do arquivo-1: 2db40c6a0a4ddc0bb0f765a9195c34b258de49b179f90cd54244406e0c62df83.zip
 Tabela do layer geoaddress sem nome de rua, só com numero predial: pk3_001_p1_geoaddress
 Sub-arquivos do arquivo-1 com o conteúdo alvo: NOMENCLATURA_DOMICILIARIA.*
 Tema dos sub-arquivos: Nomenclatura Domiciliaria urbano e rural
Run with tmux and sudo! (DANGER: seems not idempotent on psql)
a4a
Above user is root? If not, you have permissions for all paths?
 [press ENTER for yes else ^C]
psql postgres://postgres@localhost/ingest1 -c "DROP TABLE IF EXISTS pk3_001_p1_geoaddress CASCADE"
NOTICE:  table "pk3_001_p1_geoaddress" does not exist, skipping
DROP TABLE
Extracting ....
cd /tmp/sandbox/_pk3_001;  7z  x -y  /var/www/preserv.addressforall.org/download/2db40c6a0a4ddc0bb0f765a9195c34b258de49b179f90cd54244406e0c62df83.zip "*NOMENCLATURA_DOMICILIARIA*" ; chmod -R a+rx . > /dev/null

7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,4 CPUs Intel Xeon E312xx (Sandy Bridge) (206A1),ASM)

Scanning the drive for archives:
1 file, 146145734 bytes (140 MiB)                     

Extracting archive: /var/www/preserv.addressforall.org/download/2db40c6a0a4ddc0bb0f765a9195c34b258de49b179f90cd54244406e0c62df83.zip
--
Path = /var/www/preserv.addressforall.org/download/2db40c6a0a4ddc0bb0f765a9195c34b258de49b179f90cd54244406e0c62df83.zip
Type = zip
Physical Size = 146145734

Everything is Ok                            

Files: 2
Size:       146145316
Compressed: 146145734
Extraindo ...
cd /tmp/sandbox/_pk3_001;  7z x -y "*NOMENCLATURA_DOMICILIARIA*" ; chmod -R a+rx . > /dev/null

7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,4 CPUs Intel Xeon E312xx (Sandy Bridge) (206A1),ASM)

Scanning the drive for archives:
2 files, 146145316 bytes (140 MiB)

Extracting archive: R_NOMENCLATURA_DOMICILIARIA.shp.zip
--
Path = R_NOMENCLATURA_DOMICILIARIA.shp.zip
Type = zip
Physical Size = 3607975

Everything is Ok

Extracting archive: U_NOMENCLATURA_DOMICILIARIA.shp.zip
--
Path = U_NOMENCLATURA_DOMICILIARIA.shp.zip
Type = zip
Physical Size = 142537341

Everything is Ok                            

Archives: 2
OK archives: 2
Files: 8
Size:       1132840203
Compressed: 146145316
Executando shp2pgsql ...
cd /tmp/sandbox/_pk3_001;  find /tmp/sandbox/_pk3_001 -iname "*NOMENCLATURA_DOMICILIARIA*.shp" -exec sh -c "psql postgres://postgres@localhost/ingest1 -c 'DROP TABLE IF EXISTS pk3_001_p1_geoaddress'; shp2pgsql -D -s 4686 {} pk3_001_p1_geoaddress | psql -q postgres://postgres@localhost/ingest1; psql postgres://postgres@localhost/ingest1 -c \"SELECT ingest.any_load('shp2sql','{}','geoaddress_full','pk3_001_p1_geoaddress','3_001','2db40c6a0a4ddc0bb0f765a9195c34b258de49b179f90cd54244406e0c62df83.zip',array['gid', 'texto AS house_number', 'geom'])\"; chmod -R a+rx . 2> /dev/null" \;
NOTICE:  table "pk3_001_p1_geoaddress" does not exist, skipping
DROP TABLE
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
                            addgeometrycolumn                             
--------------------------------------------------------------------------
 public.pk3_001_p1_geoaddress.geom SRID:4686 TYPE:MULTILINESTRING DIMS:2 
(1 row)

                   any_load                   
----------------------------------------------
 From file_id=1 inserted type=geoaddress_full+
 in feature_asis 3027719 items.
(1 row)

DROP TABLE
Shapefile type: Arc
Postgis type: MULTILINESTRING[2]
                            addgeometrycolumn                             
--------------------------------------------------------------------------
 public.pk3_001_p1_geoaddress.geom SRID:4686 TYPE:MULTILINESTRING DIMS:2 
(1 row)

                   any_load                   
----------------------------------------------
 From file_id=2 inserted type=geoaddress_full+
 in feature_asis 87040 items.
(1 row)

Confira os resultados nas tabelas ingest.layer_file e ingest.feature_asis.
FIM.

a4a@ubuntu:/opt/gits/_dg/preserv-CO/data/_pk003$ make parcel

------------------------------------------
------ Layer tipo parcel_none  ------
-- Incluindo dados do arquivo-3 do package-3_001 na base ingest1 --
 Nome-hash do arquivo-3: 44a4c74ad768a9c4a91ff9fb168ebcd555dc0ea4b6eb1c405cc6c3fa993f8514.zip
 Tabela do layer geoaddress sem nome de rua, só com numero predial: pk3_001_p3_parcel
 Sub-arquivos do arquivo-3 com o conteúdo alvo: TERRENO.*
 Tema dos sub-arquivos: Terreno urbano e rural
Run with tmux and sudo! (DANGER: seems not idempotent on psql)
a4a
Above user is root? If not, you have permissions for all paths?
 [press ENTER for yes else ^C]
psql postgres://postgres@localhost/ingest1 -c "DROP TABLE IF EXISTS pk3_001_p3_parcel CASCADE"
NOTICE:  table "pk3_001_p3_parcel" does not exist, skipping
DROP TABLE
Extracting ....
cd /tmp/sandbox/_pk3_001;  7z  x -y  /var/www/preserv.addressforall.org/download/44a4c74ad768a9c4a91ff9fb168ebcd555dc0ea4b6eb1c405cc6c3fa993f8514.zip "*TERRENO*" ; chmod -R a+rx . > /dev/null

7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,4 CPUs Intel Xeon E312xx (Sandy Bridge) (206A1),ASM)

Scanning the drive for archives:
1 file, 1411579335 bytes (1347 MiB)                   

Extracting archive: /var/www/preserv.addressforall.org/download/44a4c74ad768a9c4a91ff9fb168ebcd555dc0ea4b6eb1c405cc6c3fa993f8514.zip
--
Path = /var/www/preserv.addressforall.org/download/44a4c74ad768a9c4a91ff9fb168ebcd555dc0ea4b6eb1c405cc6c3fa993f8514.zip
Type = zip
Physical Size = 1411579335

Everything is Ok          

Files: 2
Size:       1411578989
Compressed: 1411579335
Extraindo ...
cd /tmp/sandbox/_pk3_001;  7z x -y "*TERRENO*" ; chmod -R a+rx . > /dev/null

7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=en_US.UTF-8,Utf16=on,HugeFiles=on,64 bits,4 CPUs Intel Xeon E312xx (Sandy Bridge) (206A1),ASM)

Scanning the drive for archives:
2 files, 1411578989 bytes (1347 MiB)

Extracting archive: R_TERRENO.shp.zip
--
Path = R_TERRENO.shp.zip
Type = zip
Physical Size = 1019355945

Everything is Ok          

Extracting archive: U_TERRENO.shp.zip
--
Path = U_TERRENO.shp.zip
Type = zip
Physical Size = 392223044

Everything is Ok          

Archives: 2
OK archives: 2
Files: 8
Size:       3063656061
Compressed: 1411578989
Executando shp2pgsql ...
cd /tmp/sandbox/_pk3_001;  find /tmp/sandbox/_pk3_001 -iname "*TERRENO*.shp" -exec sh -c "psql postgres://postgres@localhost/ingest1 -c 'DROP TABLE IF EXISTS pk3_001_p3_parcel'; shp2pgsql -D -s 4686 {} pk3_001_p3_parcel | psql -q postgres://postgres@localhost/ingest1; psql postgres://postgres@localhost/ingest1 -c \"SELECT ingest.any_load('shp2sql','{}','parcel_none','pk3_001_p3_parcel','3_001','44a4c74ad768a9c4a91ff9fb168ebcd555dc0ea4b6eb1c405cc6c3fa993f8514.zip',array['gid', 'codigo', 'geom'])\"; chmod -R a+rx . 2> /dev/null" \;
NOTICE:  table "pk3_001_p3_parcel" does not exist, skipping
DROP TABLE
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
                         addgeometrycolumn                         
-------------------------------------------------------------------
 public.pk3_001_p3_parcel.geom SRID:4686 TYPE:MULTIPOLYGON DIMS:2 
(1 row)

ERROR:  file length too large
CONTEXT:  SQL function "jsonb_pg_stat_file" statement 1
SQL function "getmeta_to_file" statement 1
SQL function "getmeta_to_file" statement 1
PL/pgSQL function ingest.any_load(text,text,text,text,real,text,text[],text,boolean) line 17 at assignment
DROP TABLE
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
                         addgeometrycolumn                         
-------------------------------------------------------------------
 public.pk3_001_p3_parcel.geom SRID:4686 TYPE:MULTIPOLYGON DIMS:2 
(1 row)

NOTICE:  Ring Self-intersection at or near point -74.950580546999959 10.323073629000021
NOTICE:  Ring Self-intersection at or near point -74.918675891999953 10.639235798000072
NOTICE:  Ring Self-intersection at or near point -74.759615863999954 10.751276099000052
NOTICE:  Self-intersection at or near point -75.424288880999939 10.327520755000023
NOTICE:  Ring Self-intersection at or near point -74.917466548999982 10.236987273000068
NOTICE:  Ring Self-intersection at or near point -73.805359254999985 5.6231222060000619
NOTICE:  Ring Self-intersection at or near point -73.468490738999947 5.0069029480000609
NOTICE:  Ring Self-intersection at or near point -74.00297005799996 5.5488287610000384
NOTICE:  Ring Self-intersection at or near point -74.103089359999956 5.5347151090000466
NOTICE:  Ring Self-intersection at or near point -73.460848029999966 5.3539217380000537
NOTICE:  Ring Self-intersection at or near point -73.978958392999971 5.6536261530000615
NOTICE:  Ring Self-intersection at or near point -73.544960230999948 5.5864855610000745
NOTICE:  Ring Self-intersection at or near point -73.603879679999977 5.7153300940000236
NOTICE:  Ring Self-intersection at or near point -73.646987095999975 5.5771254650000515
NOTICE:  Ring Self-intersection at or near point -73.517698831999951 5.3715661150000642
NOTICE:  Ring Self-intersection at or near point -73.338922990999947 5.5610713920000308
NOTICE:  Ring Self-intersection at or near point -73.367366262999951 5.5142200360000402
NOTICE:  Ring Self-intersection at or near point -73.369610845999944 5.5420000040000446
NOTICE:  Ring Self-intersection at or near point -72.881236850999983 5.5161711660000492
NOTICE:  Ring Self-intersection at or near point -73.295319899999981 5.4102895200000489
NOTICE:  Ring Self-intersection at or near point -73.027711041999964 5.8200314440000511
NOTICE:  Ring Self-intersection at or near point -73.030361609999943 5.8190918170000714
NOTICE:  Ring Self-intersection at or near point -73.366117405999944 5.5762809880000646
NOTICE:  Ring Self-intersection at or near point -73.483635658999958 6.0550151100000562
NOTICE:  Ring Self-intersection at or near point -72.470967907999977 6.1874290080000378
NOTICE:  Ring Self-intersection at or near point -72.499330544999964 6.4580090970000583
NOTICE:  Ring Self-intersection at or near point -72.752506293999943 5.9865218240000218
NOTICE:  Ring Self-intersection at or near point -72.782782773999941 5.9081246600000554
NOTICE:  Ring Self-intersection at or near point -75.459589321999943 5.0341523410000377
NOTICE:  Ring Self-intersection at or near point -75.523865567999962 5.081903508000039
NOTICE:  Ring Self-intersection at or near point -75.518206068999973 5.0586262200000647
NOTICE:  Ring Self-intersection at or near point -75.781558455999971 5.2384103790000722
NOTICE:  Ring Self-intersection at or near point -75.783553777999941 5.2397591750000743
NOTICE:  Ring Self-intersection at or near point -75.783451738999986 5.2438906140000654
NOTICE:  Ring Self-intersection at or near point -75.495177469999987 5.2693567130000361
NOTICE:  Ring Self-intersection at or near point -75.564971023999988 5.2983420860000479
NOTICE:  Ring Self-intersection at or near point -75.702097884999944 5.1094036320000669
NOTICE:  Ring Self-intersection at or near point -75.700942417999954 5.1092503510000711
NOTICE:  Ring Self-intersection at or near point -75.702020705999985 5.1126740440000731
NOTICE:  Ring Self-intersection at or near point -75.508980221999934 5.0358250090000638
NOTICE:  Ring Self-intersection at or near point -75.511022629999957 5.0395869290000519
NOTICE:  Ring Self-intersection at or near point -75.054292617999977 5.2975788830000283
NOTICE:  Ring Self-intersection at or near point -74.905139585999962 5.3178554430000418
NOTICE:  Ring Self-intersection at or near point -75.538523358999953 5.6148531660000458
NOTICE:  Ring Self-intersection at or near point -75.696940653999945 5.4123922400000311
NOTICE:  Ring Self-intersection at or near point -75.700304194999944 5.4263480220000702
NOTICE:  Ring Self-intersection at or near point -74.890283679999982 5.5762135380000473
NOTICE:  Ring Self-intersection at or near point -74.951369940999939 5.5964775510000209
NOTICE:  Ring Self-intersection at or near point -75.615497356999981 1.6377369670000235
NOTICE:  Ring Self-intersection at or near point -74.775857268999971 2.1170510830000353
NOTICE:  Ring Self-intersection at or near point -77.212790710999968 2.0441957740000589
NOTICE:  Ring Self-intersection at or near point -77.215402177999977 2.0438430360000552
NOTICE:  Ring Self-intersection at or near point -77.16391635399998 1.7851988800000527
NOTICE:  Ring Self-intersection at or near point -76.98147374399997 2.1168264710000244
NOTICE:  Ring Self-intersection at or near point -76.981413274999966 2.1172946410000577
NOTICE:  Ring Self-intersection at or near point -76.978329339999959 2.1238465240000437
NOTICE:  Ring Self-intersection at or near point -77.89574900599996 2.573153393000041
NOTICE:  Ring Self-intersection at or near point -77.662511803999962 2.7738469070000633
NOTICE:  Ring Self-intersection at or near point -77.667177527999968 2.7751327830000605
NOTICE:  Ring Self-intersection at or near point -77.663523448999968 2.770919827000057
NOTICE:  Ring Self-intersection at or near point -76.572431150999989 2.4916672840000729
NOTICE:  Ring Self-intersection at or near point -76.567426188999946 2.493050022000034
NOTICE:  Ring Self-intersection at or near point -76.631207675999974 2.4447481990000597
NOTICE:  Ring Self-intersection at or near point -76.592664973999945 2.4676226710000719
NOTICE:  Ring Self-intersection at or near point -76.585286235999945 2.4897041290000743
NOTICE:  Ring Self-intersection at or near point -76.579987396999968 2.4822548400000528
NOTICE:  Ring Self-intersection at or near point -76.579812420999986 2.4777948160000278
NOTICE:  Ring Self-intersection at or near point -76.57814932399998 2.4860758850000479
NOTICE:  Ring Self-intersection at or near point -76.584227240999951 2.462397931000055
NOTICE:  Ring Self-intersection at or near point -76.562466780999955 2.4785275320000437
NOTICE:  Ring Self-intersection at or near point -76.561729815999968 2.4857368820000261
NOTICE:  Ring Self-intersection at or near point -76.629372955999941 2.4419879800000217
NOTICE:  Ring Self-intersection at or near point -76.580746677999969 2.4782366100000672
NOTICE:  Ring Self-intersection at or near point -76.561228544999949 2.4904288440000641
NOTICE:  Ring Self-intersection at or near point -76.593570753999984 2.4671725410000249
NOTICE:  Ring Self-intersection at or near point -76.599325315999977 2.4347755260000667
NOTICE:  Nested shells at or near point -76.576062416999946 2.4912529260000724
NOTICE:  Ring Self-intersection at or near point -76.569442041999935 2.6199530280000545
NOTICE:  Ring Self-intersection at or near point -76.551073723999934 2.7995198440000308
NOTICE:  Ring Self-intersection at or near point -76.254428909999945 3.1706951580000577
NOTICE:  Ring Self-intersection at or near point -76.812117778999948 2.4490838610000196
NOTICE:  Ring Self-intersection at or near point -76.390218137999966 3.1368676520000349
NOTICE:  Ring Self-intersection at or near point -76.389251617999946 3.129328666000049
NOTICE:  Ring Self-intersection at or near point -76.048574543999962 2.4970252810000488
NOTICE:  Ring Self-intersection at or near point -76.627227840999979 2.7498938280000402
NOTICE:  Ring Self-intersection at or near point -76.536160450999944 2.6419576460000371
NOTICE:  Ring Self-intersection at or near point -76.494949006999946 2.3446275460000265
NOTICE:  Ring Self-intersection at or near point -76.475193942999965 3.0068685390000383
NOTICE:  Ring Self-intersection at or near point -76.479915373999972 3.0043491690000224
NOTICE:  Ring Self-intersection at or near point -76.493330334999939 3.0143885120000391
NOTICE:  Ring Self-intersection at or near point -76.61511158899998 2.2521965550000687
NOTICE:  Ring Self-intersection at or near point -76.613551134999966 2.2517957790000196
NOTICE:  Ring Self-intersection at or near point -76.69975242299995 2.9550470110000333
NOTICE:  Ring Self-intersection at or near point -76.694531500999972 2.9543771410000659
NOTICE:  Ring Self-intersection at or near point -76.698746820999986 2.9549879130000249
NOTICE:  Ring Self-intersection at or near point -76.700178111999946 2.9545423060000644
NOTICE:  Ring Self-intersection at or near point -76.699276199999986 2.953697858000055
NOTICE:  Ring Self-intersection at or near point -76.673725246999936 2.3504951630000619
NOTICE:  Self-intersection at or near point -73.492479922999962 10.225396080000053
NOTICE:  Ring Self-intersection at or near point -73.28409897399996 10.486550991000058
NOTICE:  Ring Self-intersection at or near point -73.225710850999974 10.453717493000056
NOTICE:  Ring Self-intersection at or near point -73.285956739999961 10.481271249000031
NOTICE:  Ring Self-intersection at or near point -73.263754827999946 10.434383485000069
NOTICE:  Ring Self-intersection at or near point -73.259152533999952 10.437283355000034
NOTICE:  Ring Self-intersection at or near point -73.597502362999933 8.3203477410000346
NOTICE:  Ring Self-intersection at or near point -73.238380837999955 10.028592863000029
NOTICE:  Ring Self-intersection at or near point -73.596359494999945 9.357900159000053
NOTICE:  Ring Self-intersection at or near point -73.675201294999965 8.8425437990000546
NOTICE:  Ring Self-intersection at or near point -73.663752612999986 8.6882532080000487
NOTICE:  Ring Self-intersection at or near point -73.50547757399994 7.9974266580000517
NOTICE:  Ring Self-intersection at or near point -76.068529488999957 8.1631977070000517
NOTICE:  Ring Self-intersection at or near point -76.07437052299997 8.1573830610000755
NOTICE:  Ring Self-intersection at or near point -75.123886296999956 8.3198008920000461
NOTICE:  Ring Self-intersection at or near point -75.413688628999978 7.983830643000033
NOTICE:  Ring Self-intersection at or near point -75.418538394999985 7.9700976240000614
NOTICE:  Ring Self-intersection at or near point -75.581760453999948 8.4161854260000268
NOTICE:  Ring Self-intersection at or near point -75.510800088999986 8.5065802080000594
NOTICE:  Ring Self-intersection at or near point -75.882221285999947 8.7374910230000751
NOTICE:  Ring Self-intersection at or near point -75.85665408999995 8.8109426820000749
NOTICE:  Ring Self-intersection at or near point -75.896664966999936 8.7644205480000323
NOTICE:  Ring Self-intersection at or near point -75.824542129999941 9.243703063000055
NOTICE:  Ring Self-intersection at or near point -75.831911095999942 8.9669569050000746
NOTICE:  Ring Self-intersection at or near point -75.834882311999934 8.9590197640000611
NOTICE:  Ring Self-intersection at or near point -75.626182640999957 9.1515079980000564
NOTICE:  Ring Self-intersection at or near point -75.394020319999981 9.1127610280000226
NOTICE:  Ring Self-intersection at or near point -75.402636937999944 9.0959676600000421
NOTICE:  Ring Self-intersection at or near point -75.445797375999973 8.9632810380000478
NOTICE:  Ring Self-intersection at or near point -75.45414440899998 8.9630819850000307
NOTICE:  Ring Self-intersection at or near point -75.453050475999987 8.9629904390000661
NOTICE:  Ring Self-intersection at or near point -74.664823040999977 4.3733534970000392
NOTICE:  Ring Self-intersection at or near point -74.801661524999986 4.3250258490000419
NOTICE:  Ring Self-intersection at or near point -74.796511830999975 4.2985065230000714
NOTICE:  Ring Self-intersection at or near point -74.796156575999987 4.2901906000000736
NOTICE:  Ring Self-intersection at or near point -74.801709889999984 4.3266925070000752
NOTICE:  Ring Self-intersection at or near point -74.801973385999986 4.3249042030000737
NOTICE:  Ring Self-intersection at or near point -74.80233485399998 4.3237776900000426
NOTICE:  Ring Self-intersection at or near point -74.802327085999934 4.3239814600000273
NOTICE:  Ring Self-intersection at or near point -74.816636102999951 4.3160900220000258
NOTICE:  Ring Self-intersection at or near point -74.801632046999941 4.311556332000066
NOTICE:  Ring Self-intersection at or near point -74.879244711999945 4.2856106090000594
NOTICE:  Ring Self-intersection at or near point -74.257467439999971 4.4933083500000635
NOTICE:  Ring Self-intersection at or near point -74.257134447999988 4.4951483090000579
NOTICE:  Ring Self-intersection at or near point -73.922528340999975 4.5235506740000346
NOTICE:  Ring Self-intersection at or near point -74.225236222999968 4.7086431200000334
NOTICE:  Ring Self-intersection at or near point -74.227444442999968 4.7065106250000213
NOTICE:  Ring Self-intersection at or near point -74.029985789999955 4.9112799840000321
NOTICE:  Ring Self-intersection at or near point -74.162182346999941 5.1237610130000348
NOTICE:  Ring Self-intersection at or near point -73.916099637999935 4.9604014400000551
NOTICE:  Ring Self-intersection at or near point -76.648723575999952 5.7159390990000247
NOTICE:  Ring Self-intersection at or near point -76.657281119999936 5.7026808590000542
NOTICE:  Ring Self-intersection at or near point -76.658353549999958 5.7022203770000601
NOTICE:  Ring Self-intersection at or near point -76.653069068999969 5.708550634000062
NOTICE:  Ring Self-intersection at or near point -76.649143866999964 5.7089508290000595
NOTICE:  Ring Self-intersection at or near point -76.648098546999961 5.7174451690000296
NOTICE:  Ring Self-intersection at or near point -76.649836450999942 5.7169646720000742
NOTICE:  Ring Self-intersection at or near point -76.649873399999933 5.7162841150000645
NOTICE:  Ring Self-intersection at or near point -76.645120432999988 5.6785394990000668
NOTICE:  Ring Self-intersection at or near point -76.649397876999956 5.6925418340000533
NOTICE:  Ring Self-intersection at or near point -76.65289474399998 5.6806500240000446
NOTICE:  Ring Self-intersection at or near point -76.644754949999935 5.6880723810000404
NOTICE:  Ring Self-intersection at or near point -76.648660416999974 5.6849652470000365
NOTICE:  Ring Self-intersection at or near point -76.649465290999956 5.6790165190000721
NOTICE:  Ring Self-intersection at or near point -76.643218632999947 5.6813949180000236
NOTICE:  Ring Self-intersection at or near point -76.644748267999944 5.6849961440000243
NOTICE:  Ring Self-intersection at or near point -76.656462540999939 5.6834578740000552
NOTICE:  Ring Self-intersection at or near point -76.651095261999956 5.7129795840000384
NOTICE:  Ring Self-intersection at or near point -76.654917173999934 5.7058972670000685
NOTICE:  Ring Self-intersection at or near point -76.658407046999969 5.7044240810000701
NOTICE:  Ring Self-intersection at or near point -76.652770228999941 5.7073918440000284
NOTICE:  Ring Self-intersection at or near point -76.653916489999972 5.7039846630000284
NOTICE:  Ring Self-intersection at or near point -76.649377357999981 5.7006173550000767
NOTICE:  Ring Self-intersection at or near point -76.650508321999951 5.6994319630000518
NOTICE:  Ring Self-intersection at or near point -76.65110468599994 5.6861666810000315
NOTICE:  Ring Self-intersection at or near point -76.643748940999956 5.6839180310000756
NOTICE:  Ring Self-intersection at or near point -76.643627375999984 5.6896975740000357
NOTICE:  Ring Self-intersection at or near point -76.64269008499997 5.6798534610000502
NOTICE:  Ring Self-intersection at or near point -76.649464299999977 5.6801351380000256
NOTICE:  Ring Self-intersection at or near point -76.645753390999971 5.680601336000052
NOTICE:  Ring Self-intersection at or near point -76.648801358999947 5.7151504040000418
NOTICE:  Ring Self-intersection at or near point -76.649036938999984 5.7142712880000204
NOTICE:  Ring Self-intersection at or near point -76.650434864999966 5.6880440200000635
NOTICE:  Ring Self-intersection at or near point -76.638300362999985 5.6728625340000463
NOTICE:  Ring Self-intersection at or near point -76.640763989999982 5.6812472480000338
NOTICE:  Ring Self-intersection at or near point -76.883601760999966 6.5557937530000459
NOTICE:  Ring Self-intersection at or near point -76.689518817999954 5.1596174470000733
NOTICE:  Ring Self-intersection at or near point -76.689149844999974 5.1574629300000652
NOTICE:  Ring Self-intersection at or near point -76.685218516999953 5.1622965930000646
NOTICE:  Ring Self-intersection at or near point -76.606429249999962 4.9556946060000655
NOTICE:  Ring Self-intersection at or near point -76.606081324999934 4.9570170550000512
NOTICE:  Ring Self-intersection at or near point -77.109015833999933 7.4337948670000742
NOTICE:  Ring Self-intersection at or near point -75.622416169999951 2.1862757740000234
NOTICE:  Ring Self-intersection at or near point -75.622634141999981 2.1868646250000552
NOTICE:  Ring Self-intersection at or near point -75.774442644999965 2.4523392830000716
NOTICE:  Ring Self-intersection at or near point -76.040998783999953 1.8558688790000701
NOTICE:  Ring Self-intersection at or near point -76.058323223999935 1.8439893870000219
NOTICE:  Ring Self-intersection at or near point -75.253292208999937 2.9401246190000734
NOTICE:  Ring Self-intersection at or near point -75.289787865999983 2.9746022180000296
NOTICE:  Ring Self-intersection at or near point -75.281700986999965 2.9113404580000406
NOTICE:  Ring Self-intersection at or near point -75.271907949999957 2.926698545000022
NOTICE:  Ring Self-intersection at or near point -75.254469781999944 2.932777465000072
NOTICE:  Ring Self-intersection at or near point -75.050881790999938 3.1551466180000602
NOTICE:  Ring Self-intersection at or near point -75.258769753999957 2.7826773300000696
NOTICE:  Ring Self-intersection at or near point -73.978075969999963 8.9909666960000436
NOTICE:  Ring Self-intersection at or near point -73.974967440999933 8.9972058240000479
NOTICE:  Ring Self-intersection at or near point -73.965191248999986 9.014859877000049
NOTICE:  Ring Self-intersection at or near point -73.965281164999965 9.013877333000039
NOTICE:  Ring Self-intersection at or near point -74.193121127999973 10.508190076000062
NOTICE:  Ring Self-intersection at or near point -74.202278600999989 10.50842681000006
NOTICE:  Ring Self-intersection at or near point -74.205292246999988 10.514599090000047
NOTICE:  Ring Self-intersection at or near point -74.196266655999978 10.52175716000005
NOTICE:  Ring Self-intersection at or near point -74.159771801999966 10.753766822000046
NOTICE:  Ring Self-intersection at or near point -73.612575233999962 4.1496588730000212
NOTICE:  Ring Self-intersection at or near point -73.616497040999946 4.1443037950000416
NOTICE:  Ring Self-intersection at or near point -73.612424867999948 4.1469589230000565
NOTICE:  Ring Self-intersection at or near point -73.635346143999982 4.124553689000038
NOTICE:  Ring Self-intersection at or near point -73.397237289999964 4.0628176550000603
NOTICE:  Ring Self-intersection at or near point -73.686788800999977 3.7096064150000529
NOTICE:  Ring Self-intersection at or near point -77.288567151999985 1.1971693600000322
NOTICE:  Ring Self-intersection at or near point -77.287047350999956 1.1986678050000705
NOTICE:  Ring Self-intersection at or near point -77.288408754999978 1.1978107300000715
NOTICE:  Ring Self-intersection at or near point -77.287527153999974 1.1982293580000487
NOTICE:  Ring Self-intersection at or near point -77.288232386999937 1.1977133860000322
NOTICE:  Ring Self-intersection at or near point -77.288863645999982 1.1973739800000658
NOTICE:  Ring Self-intersection at or near point -77.289513281999973 1.1964384460000588
NOTICE:  Ring Self-intersection at or near point -77.289344235999977 1.1968970580000473
NOTICE:  Ring Self-intersection at or near point -77.287212551999971 1.198159563000047
NOTICE:  Ring Self-intersection at or near point -77.289195623999944 1.1982060410000486
NOTICE:  Ring Self-intersection at or near point -77.288869555999952 1.1988125620000574
NOTICE:  Ring Self-intersection at or near point -77.288331224999979 1.1973675160000425
NOTICE:  Ring Self-intersection at or near point -77.270013837999954 1.1984343590000321
NOTICE:  Ring Self-intersection at or near point -77.258966609999959 1.1873267270000269
NOTICE:  Ring Self-intersection at or near point -77.469076247999965 1.2089546500000665
NOTICE:  Ring Self-intersection at or near point -77.573588037999968 0.80264290200005917
NOTICE:  Ring Self-intersection at or near point -77.616752348999967 1.0909217020000597
NOTICE:  Ring Self-intersection at or near point -77.404455009999936 1.1138145520000649
NOTICE:  Ring Self-intersection at or near point -77.404873668999983 1.1141019670000674
NOTICE:  Ring Self-intersection at or near point -78.783078232999969 1.7852821760000666
NOTICE:  Ring Self-intersection at or near point -77.016050029999974 1.5936808270000711
NOTICE:  Ring Self-intersection at or near point -77.519756195999946 1.4957210890000283
NOTICE:  Ring Self-intersection at or near point -72.810586296999986 7.775948321000044
NOTICE:  Ring Self-intersection at or near point -72.605185379999966 7.6031293520000531
NOTICE:  Ring Self-intersection at or near point -72.787918705999971 7.9134214710000492
NOTICE:  Ring Self-intersection at or near point -72.651246656999945 7.3676913660000309
NOTICE:  Ring Self-intersection at or near point -73.348628259999941 8.241160361000027
NOTICE:  Ring Self-intersection at or near point -73.335975249999933 8.2266672810000614
NOTICE:  Ring Self-intersection at or near point -73.351464695999937 8.2498404570000616
NOTICE:  Ring Self-intersection at or near point -73.343326975999958 8.2271143280000274
NOTICE:  Ring Self-intersection at or near point -72.898698773999968 9.0032478700000524
NOTICE:  Ring Self-intersection at or near point -75.739156789999981 4.3595090320000622
NOTICE:  Ring Self-intersection at or near point -75.785184882999943 4.209982099000058
NOTICE:  Ring Self-intersection at or near point -75.71056346599994 4.5292066180000461
NOTICE:  Ring Self-intersection at or near point -75.693043288999945 4.5354053070000759
NOTICE:  Ring Self-intersection at or near point -75.689479535999965 4.5332101910000233
NOTICE:  Ring Self-intersection at or near point -75.698834311999974 4.5319971790000295
NOTICE:  Ring Self-intersection at or near point -75.702160215999982 4.5322050190000596
NOTICE:  Ring Self-intersection at or near point -75.70194179799995 4.5228029570000672
NOTICE:  Ring Self-intersection at or near point -75.704171630999952 4.5238243300000249
NOTICE:  Ring Self-intersection at or near point -75.708951885999966 4.5148464770000487
NOTICE:  Ring Self-intersection at or near point -75.693579131999968 4.535558768000044
NOTICE:  Ring Self-intersection at or near point -75.691010915999982 4.5087802200000624
NOTICE:  Ring Self-intersection at or near point -75.690847953999935 4.5086712300000613
NOTICE:  Ring Self-intersection at or near point -75.690884710999967 4.5085173010000403
NOTICE:  Ring Self-intersection at or near point -75.69144879299995 4.5088136050000571
NOTICE:  Ring Self-intersection at or near point -75.691574784999943 4.5085638620000736
NOTICE:  Ring Self-intersection at or near point -75.691578471999946 4.5066451390000566
NOTICE:  Ring Self-intersection at or near point -75.690857061999964 4.5082472340000663
NOTICE:  Ring Self-intersection at or near point -75.69092877199995 4.5080777740000713
NOTICE:  Ring Self-intersection at or near point -75.691293453999947 4.5085386110000627
NOTICE:  Ring Self-intersection at or near point -75.690919304999966 4.5077285490000349
NOTICE:  Ring Self-intersection at or near point -75.691102225999941 4.5080462920000741
NOTICE:  Ring Self-intersection at or near point -75.69099547899998 4.5079303630000709
NOTICE:  Ring Self-intersection at or near point -75.691087530999937 4.5071299390000377
NOTICE:  Ring Self-intersection at or near point -75.691642921999971 4.5066524720000416
NOTICE:  Ring Self-intersection at or near point -75.69115392599997 4.5079650290000473
NOTICE:  Ring Self-intersection at or near point -75.708405379999988 4.5252774070000328
NOTICE:  Ring Self-intersection at or near point -75.690890047999972 4.5088673930000596
NOTICE:  Ring Self-intersection at or near point -75.691235746999951 4.5085002080000436
NOTICE:  Ring Self-intersection at or near point -75.692384527999934 4.5079803300000663
NOTICE:  Ring Self-intersection at or near point -75.691321934999962 4.5067699860000516
NOTICE:  Ring Self-intersection at or near point -75.691896713999938 4.5087057900000218
NOTICE:  Ring Self-intersection at or near point -75.715740474999961 4.5131229060000351
NOTICE:  Ring Self-intersection at or near point -75.69287817299994 4.5073008140000752
NOTICE:  Ring Self-intersection at or near point -75.691005742999948 4.5085231830000225
NOTICE:  Ring Self-intersection at or near point -75.692295800999943 4.5082850380000536
NOTICE:  Ring Self-intersection at or near point -75.692295800999943 4.5082850380000536
NOTICE:  Ring Self-intersection at or near point -75.692751679999958 4.5071015970000303
NOTICE:  Ring Self-intersection at or near point -75.692751679999958 4.5071015970000303
NOTICE:  Ring Self-intersection at or near point -75.691896713999938 4.5087057900000218
NOTICE:  Ring Self-intersection at or near point -75.691832418999979 4.5071603690000757
NOTICE:  Ring Self-intersection at or near point -75.69135377799995 4.5081338100000607
NOTICE:  Ring Self-intersection at or near point -75.691549170999963 4.5089057020000496
NOTICE:  Ring Self-intersection at or near point -75.691527873999974 4.5312026230000697
NOTICE:  Ring Self-intersection at or near point -75.693183526999974 4.5067208130000722
NOTICE:  Ring Self-intersection at or near point -75.694321238999976 4.5041271070000448
NOTICE:  Ring Self-intersection at or near point -75.790876290999961 4.4569594060000668
NOTICE:  Ring Self-intersection at or near point -75.64569788099999 4.5086326230000395
NOTICE:  Ring Self-intersection at or near point -75.653742191999982 4.563731616000041
NOTICE:  Ring Self-intersection at or near point -75.651936531999979 4.5581115460000206
NOTICE:  Ring Self-intersection at or near point -75.640806433999956 4.5686188720000587
NOTICE:  Ring Self-intersection at or near point -75.637612601999933 4.6129301210000335
NOTICE:  Ring Self-intersection at or near point -75.637441087999946 4.6237143350000451
NOTICE:  Ring Self-intersection at or near point -75.659909562999985 4.6750511050000227
NOTICE:  Ring Self-intersection at or near point -75.641125570999975 4.5203564880000613
NOTICE:  Ring Self-intersection at or near point -76.000764720999939 5.0079105090000553
NOTICE:  Ring Self-intersection at or near point -76.002811464999979 4.9990033550000703
NOTICE:  Ring Self-intersection at or near point -75.628236111999968 4.8983506570000372
NOTICE:  Ring Self-intersection at or near point -75.617933474999973 4.8715558930000498
NOTICE:  Ring Self-intersection at or near point -75.618683786999952 4.8712715690000437
NOTICE:  Ring Self-intersection at or near point -75.618683786999952 4.8712715690000437
NOTICE:  Ring Self-intersection at or near point -75.799037985999973 5.3181541200000311
NOTICE:  Ring Self-intersection at or near point -75.733408216999976 5.3495240200000467
NOTICE:  Ring Self-intersection at or near point -73.769533486999933 5.8107498060000466
NOTICE:  Self-intersection at or near point -73.868535345999987 7.0586382490000688
NOTICE:  Ring Self-intersection at or near point -73.867927391999956 7.0663291180000556
NOTICE:  Ring Self-intersection at or near point -73.286550428999988 6.9018111320000344
NOTICE:  Self-intersection at or near point -72.69993681397105 6.5351230610092523
NOTICE:  Ring Self-intersection at or near point -73.954402949999974 6.3140530660000422
NOTICE:  Self-intersection at or near point -73.221059544999946 7.1143687990000331
NOTICE:  Self-intersection at or near point -73.215149668100906 7.1158324034423961
NOTICE:  Self-intersection at or near point -73.217877123999983 7.1098959880000621
NOTICE:  Self-intersection at or near point -73.217300119999948 7.1100116650000587
NOTICE:  Too few points in geometry component at or near point -73.221535510999956 7.1084181470000658
NOTICE:  Self-intersection at or near point -73.224148374529705 7.1117781155462163
NOTICE:  Self-intersection at or near point -73.224167853999973 7.1117454210000233
NOTICE:  Self-intersection at or near point -73.218476946999942 7.1178176200000394
NOTICE:  Self-intersection at or near point -73.215432008999983 7.1147192340000629
NOTICE:  Self-intersection at or near point -73.217914101504348 7.1148497047725066
NOTICE:  Ring Self-intersection at or near point -73.297226371999955 6.2680388880000351
NOTICE:  Self-intersection at or near point -73.150122188999944 7.2637531130000639
NOTICE:  Self-intersection at or near point -73.151667969899236 7.2663061230135852
NOTICE:  Self-intersection at or near point -73.57878182099995 7.6094471440000575
NOTICE:  Too few points in geometry component at or near point -73.154954491999945 7.264670178000074
NOTICE:  Self-intersection at or near point -73.150849314999959 7.2698928030000616
NOTICE:  Self-intersection at or near point -73.131688650962644 6.5408730427861022
NOTICE:  Self-intersection at or near point -73.130155677951734 6.5541645249643681
NOTICE:  Ring Self-intersection at or near point -73.402398475999973 6.8731170910000401
NOTICE:  Ring Self-intersection at or near point -73.263567020999972 6.4553296060000207
NOTICE:  Ring Self-intersection at or near point -73.365527971999938 6.1218894150000551
NOTICE:  Self-intersection at or near point -72.876810368999941 7.1858624850000297
NOTICE:  Self-intersection at or near point -72.876865321999958 7.1866225360000726
NOTICE:  Ring Self-intersection at or near point -73.676754858999971 6.0052913080000394
NOTICE:  Ring Self-intersection at or near point -73.677485446999981 6.008711445000074
NOTICE:  Ring Self-intersection at or near point -74.539414325999985 8.4658117240000479
NOTICE:  Ring Self-intersection at or near point -75.407707263999953 9.312926338000068
NOTICE:  Ring Self-intersection at or near point -75.388212402999955 9.3208609840000349
NOTICE:  Ring Self-intersection at or near point -75.403149943999949 9.2895257670000433
NOTICE:  Ring Self-intersection at or near point -75.403149943999949 9.2895257670000433
NOTICE:  Ring Self-intersection at or near point -75.403149943999949 9.2895257670000433
NOTICE:  Ring Self-intersection at or near point -75.442861916999959 9.4536942690000387
NOTICE:  Ring Self-intersection at or near point -74.969453077999958 9.3226576110000678
NOTICE:  Ring Self-intersection at or near point -75.064562889999934 9.3989155080000728
NOTICE:  Ring Self-intersection at or near point -75.187530319999951 4.4469393250000735
NOTICE:  Ring Self-intersection at or near point -75.138209457999949 4.4502006430000733
NOTICE:  Ring Self-intersection at or near point -75.158476092999933 4.4512827350000634
NOTICE:  Ring Self-intersection at or near point -75.156252884999958 4.4508414920000519
NOTICE:  Ring Self-intersection at or near point -75.176855286999967 4.4508695150000221
NOTICE:  Ring Self-intersection at or near point -75.165719963999948 4.4443125270000223
NOTICE:  Ring Self-intersection at or near point -75.228058597999961 4.4544504810000376
NOTICE:  Ring Self-intersection at or near point -75.25958245399994 4.4214009140000599
NOTICE:  Ring Self-intersection at or near point -75.25276241399996 4.4199220770000238
NOTICE:  Ring Self-intersection at or near point -75.252626150999959 4.4205708550000509
NOTICE:  Ring Self-intersection at or near point -75.172724616999972 4.4398241180000468
NOTICE:  Ring Self-intersection at or near point -75.158749678999982 4.4006796390000318
NOTICE:  Ring Self-intersection at or near point -75.152973045999943 4.4464622450000206
NOTICE:  Ring Self-intersection at or near point -74.713381138999978 4.1509015950000503
NOTICE:  Ring Self-intersection at or near point -74.694165993999945 4.058868890000042
NOTICE:  Ring Self-intersection at or near point -74.891882704999944 4.1574459560000605
NOTICE:  Ring Self-intersection at or near point -74.895016096999939 4.1528804220000666
NOTICE:  Ring Self-intersection at or near point -74.737562822999962 5.213174021000043
NOTICE:  Ring Self-intersection at or near point -74.535609661999956 4.1756693790000554
NOTICE:  Ring Self-intersection at or near point -74.916558042999952 4.859472027000038
NOTICE:  Ring Self-intersection at or near point -74.912020310999935 5.3006581020000567
NOTICE:  Ring Self-intersection at or near point -74.637507281999945 4.1983483890000457
NOTICE:  Ring Self-intersection at or near point -75.096632912999951 3.9676259600000208
NOTICE:  Ring Self-intersection at or near point -75.023128546999942 5.1169566590000386
NOTICE:  Ring Self-intersection at or near point -74.936136769999962 3.8533118800000352
NOTICE:  Ring Self-intersection at or near point -75.243737141999986 4.2352599280000618
NOTICE:  Ring Self-intersection at or near point -75.025023869999984 3.9248759770000561
NOTICE:  Ring Self-intersection at or near point -74.602641504999951 3.935893194000073
NOTICE:  Ring Self-intersection at or near point -76.992322188999935 3.8684151980000365
NOTICE:  Ring Self-intersection at or near point -76.987836323999943 3.8624247050000236
NOTICE:  Ring Self-intersection at or near point -77.005681304999939 3.84830312400004
NOTICE:  Ring Self-intersection at or near point -76.289996046999988 3.8959360110000603
NOTICE:  Ring Self-intersection at or near point -76.543348108999965 3.2521606950000432
NOTICE:  Ring Self-intersection at or near point -76.506215188999988 3.272889947000067
NOTICE:  Ring Self-intersection at or near point -76.505888255999935 3.274417622000044
NOTICE:  Ring Self-intersection at or near point -76.547303031999945 3.2594673130000729
NOTICE:  Ring Self-intersection at or near point -76.103448679999985 4.5269281390000629
NOTICE:  Ring Self-intersection at or near point -76.094618268999966 4.5345528890000537
NOTICE:  Ring Self-intersection at or near point -76.295319254999981 3.5593341050000618
NOTICE:  Ring Self-intersection at or near point -76.357350073999953 4.0552022510000256
NOTICE:  Self-intersection at or near point -76.188138045999949 4.0800152450000269
NOTICE:  Ring Self-intersection at or near point -76.201391609999973 4.0658100840000202
NOTICE:  Ring Self-intersection at or near point -76.43924663699994 3.6949759560000643
NOTICE:  Ring Self-intersection at or near point -76.078087211999957 4.3981903280000552
NOTICE:  Ring Self-intersection at or near point -76.077027729999941 4.3971525210000664
NOTICE:  Self-intersection at or near point -72.550287329999946 5.1801663880000319
NOTICE:  Ring Self-intersection at or near point -72.541053284999975 5.166156370000067
NOTICE:  Ring Self-intersection at or near point -72.925567710999985 4.6204722750000542
NOTICE:  Ring Self-intersection at or near point -72.374253176999957 5.334475866000048
NOTICE:  Ring Self-intersection at or near point -71.664695760999962 5.4123786110000651
NOTICE:  Ring Self-intersection at or near point -76.873490783999955 0.67000508400002445
NOTICE:  Ring Self-intersection at or near point -76.606241798999974 0.68591082600005393
NOTICE:  Ring Self-intersection at or near point -76.648170840999967 1.1426068480000708
NOTICE:  Ring Self-intersection at or near point -76.644171332999974 1.1511708010000348
NOTICE:  Ring Self-intersection at or near point -76.649939921999987 1.1731035100000327
NOTICE:  Ring Self-intersection at or near point -81.70632281099995 12.574836666000067
NOTICE:  Ring Self-intersection at or near point -72.629879971999969 2.3329534630000239
SSL SYSCALL error: EOF detected
connection to server was lost
Confira os resultados nas tabelas ingest.layer_file e ingest.feature_asis.
FIM.
0e1 commented 3 years ago

Arquivos foram divididos e reempacotados. Com isso, ingestão funciona. Foi utilizado o seguinte trecho de bash:

limite=500000
counter=0
for k in $(seq 0 500000 2735483)
do
    ogr2ogr -f "ESRI Shapefile" -dialect sqlite -sql "SELECT * FROM R_TERRENO LIMIT ${limite} OFFSET ${k}" R_TERRENO_00${counter}.shp R_TERRENO.shp
    zip -r R_TERRENO_00${counter}.zip R_TERRENO_00${counter}.*
    counter=$((counter+1))
done

limite=500000
counter=0
for k in $(seq 0 500000 3296595)
do
    ogr2ogr -f "ESRI Shapefile" -dialect sqlite -sql "SELECT * FROM U_TERRENO LIMIT ${limite} OFFSET ${k}" U_TERRENO_00${counter}.shp U_TERRENO.shp
    zip -r U_TERRENO_00${counter}.zip U_TERRENO_00${counter}.*
    counter=$((counter+1))
done

zip -r ../U_R_TERRENO.zip R_TERRENO_00{0..5}.zip U_TERRENO_00{0..6}.zip