crebollobr
commented
2 years ago Erro no make block
carlos@addressforall:/var/gits/_dg/preserv-BR/data/RS/Bage/_pk0082.01$ make block pg_db=ingest20
------------------------------------------
------ BR-RS-Bage ------
------ Layer tipo block_none ------
-- Incluindo dados do arquivo-3 do package-7600008201301 na base ingest20 --
Nome-hash do arquivo-3: 47063f994f552e27c3b528fcc60cb03e36923b6875dd862dc54062e0ecb3bf60.zip
Tabela do layer: pk7600008201301_p3_block
Sub-arquivos do arquivo-3 com o conteúdo alvo: *QUARTEIRAO*
Tema dos sub-arquivos: quarteirões
Run with tmux and sudo! (DANGER: seems not idempotent on psql)
carlos
Above user is root? If not, you have permissions for all paths?
[Press ENTER to continue or Ctrl+C to quit]
psql postgres://postgres@localhost/ingest20 -c "DROP TABLE IF EXISTS pk7600008201301_p3_block CASCADE"
DROP TABLE
Extracting ....
cd /tmp/sandbox/_pkBR821_001; 7z x -y /var/www/preserv.addressforall.org/download/47063f994f552e27c3b528fcc60cb03e36923b6875dd862dc54062e0ecb3bf60.zip "*QUARTEIRAO*" ; chmod -R a+rwx . > /dev/null
7-Zip [64] 16.02 : Copyright (c) 1999-2016 Igor Pavlov : 2016-05-21
p7zip Version 16.02 (locale=pt_BR.UTF-8,Utf16=on,HugeFiles=on,64 bits,4 CPUs DO-Regular (306F2),ASM,AES-NI)
Scanning the drive for archives:
1 file, 1496124 bytes (1462 KiB)
Extracting archive: /var/www/preserv.addressforall.org/download/47063f994f552e27c3b528fcc60cb03e36923b6875dd862dc54062e0ecb3bf60.zip
--
Path = /var/www/preserv.addressforall.org/download/47063f994f552e27c3b528fcc60cb03e36923b6875dd862dc54062e0ecb3bf60.zip
Type = zip
Physical Size = 1496124
Everything is Ok
Size: 4019215
Compressed: 1496124
Conferindo se SRID 31981 está configurado:
srid | proj4text
-------+----------------------------------------------------------------------------------
31981 | +proj=utm +zone=21 +south +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs
(1 row)
[Press ENTER to continue or Ctrl+C to quit]
Executando geojson2sql ...
psql postgres://postgres@localhost/ingest20 -c "DROP TABLE IF EXISTS pk7600008201301_p3_block"
NOTICE: table "pk7600008201301_p3_block" does not exist, skipping
DROP TABLE
psql postgres://postgres@localhost/ingest20 -c "CREATE TABLE pk7600008201301_p3_block AS SELECT * FROM geojson_readfile_features_jgeom('/tmp/sandbox/_pkBR821_001/QUARTEIRAO.geojson',null)"
SELECT 2141
psql postgres://postgres@localhost/ingest20 -c "CREATE VIEW vw3_pk7600008201301_p3_block AS SELECT row_number() OVER () as gid, jgeom AS geom \
FROM pk7600008201301_p3_block"
CREATE VIEW
psql postgres://postgres@localhost/ingest20 -c "SELECT ingest.any_load('geojson2sql','/tmp/sandbox/_pkBR821_001/QUARTEIRAO.geojson','block_none','vw3_pk7600008201301_p3_block','7600008201301','47063f994f552e27c3b528fcc60cb03e36923b6875dd862dc54062e0ecb3bf60.zip',array[]::text[],5,1)"
ERROR: Geohash requires inputs in decimal degrees, got (779590 6.52928e+06, 779590 6.52928e+06).
CONTEXT: SQL statement "
WITH
scan AS (
SELECT 22 AS file_id,
CASE
WHEN true THEN gid
ELSE gid+COALESCE((SELECT MAX(feature_id) FROM ingest.feature_asis WHERE file_id=22),0)
END AS gid,
properties,
CASE
WHEN ST_SRID(geom)=0 THEN ST_SetSRID(geom,4326)
WHEN true AND ST_SRID(geom)!=4326 AND true THEN ST_Transform(geom,4326)
ELSE geom
END AS geom
FROM (
SELECT gid, -- feature_id_col
to_jsonb(subq) as properties,
ST_GeomFromGeoJSON(geom) AS geom -- geom
FROM vw3_pk7600008201301_p3_block , LATERAL (SELECT ) subq
) t
),
a0 AS (
SELECT *
FROM scan
WHERE ST_IsValid(geom)
),
a AS (
SELECT *
FROM a0
WHERE ST_IsClosed(geom) = TRUE OR GeometryType(geom) IN ('LINESTRING','MULTILINESTRING')
),
mask AS (SELECT ingest.buffer_geom(geom,1) AS geom FROM ingest.vw02full_donated_packfilevers WHERE id=7600008201301 LIMIT 1),
b AS (
SELECT file_id, gid, properties, geom, ( B'000000000' || (NOT(ST_IsSimple(geom)))::int::bit || (NOT(ST_IsValid(geom)))::int::bit || (NOT(ST_Intersects(geom,(SELECT geom FROM mask))))::int::bit ) AS error_mask
FROM a
),
c AS (
(
SELECT file_id, gid, properties, geom, (error_mask | (
B'00' ||
(CASE (SELECT (ingest.donated_PackComponent_geomtype(22))[1]) WHEN 'poly' THEN ST_Area(geom,true) > 2147483647 WHEN 'line' THEN ST_Length(geom,true) > 2147483647 ELSE FALSE END)::int::bit ||
B'00' ||
(GeometryType(geom) NOT IN ('POLYGON' ,'MULTIPOLYGON'))::int::bit ||
(geom IS NULL)::int::bit ||
(CASE (SELECT (ingest.donated_PackComponent_geomtype(22))[1]) WHEN 'poly' THEN ST_Area(geom,true) < 5 WHEN 'line' THEN ST_Length(geom,true) < 2 ELSE FALSE END)::int::bit ||
(ST_IsEmpty(geom))::int::bit ||
B'000' )) AS error_mask
FROM (
SELECT file_id, gid,
properties,
CASE (SELECT (ingest.donated_PackComponent_geomtype(22))[1])
WHEN 'point' THEN ST_ReducePrecision( ST_Intersection(geom,(SELECT geom FROM mask)), 0.000001 )
ELSE ST_SimplifyPreserveTopology( -- remove collinear points
ST_ReducePrecision( -- round decimal degrees of SRID 4326, ~1 meter
ST_Intersection( geom, (SELECT geom FROM mask) )
,0.000001
),
0.00000001
)
END AS geom,
error_mask
FROM b
WHERE bit_count(error_mask) = 0
) t
)
UNION
(
SELECT * FROM b WHERE bit_count(error_mask) <> 0
)
UNION
(
SELECT file_id, gid, properties, ST_MakeValid(geom) AS geom, B'000100000000' AS error_mask
FROM a0
WHERE ST_IsClosed(geom) = FALSE AND GeometryType(geom) NOT IN ('LINESTRING','MULTILINESTRING')
)
UNION
(
SELECT file_id, gid, properties, ST_MakeValid(geom) AS geom, B'000000000010' AS error_mask
FROM scan
WHERE ST_IsValid(geom) = FALSE
)
),
stats AS (
SELECT ARRAY [
(SELECT COUNT(*) FROM scan)::bigint,
(COUNT(*) filter (WHERE get_bit(error_mask,11) = 1))::bigint, -- intersects
(COUNT(*) filter (WHERE get_bit(error_mask,10) = 1))::bigint, -- invalid
(COUNT(*) filter (WHERE get_bit(error_mask, 9) = 1))::bigint, -- simple
(COUNT(*) filter (WHERE get_bit(error_mask, 8) = 1))::bigint, -- empty
(COUNT(*) filter (WHERE get_bit(error_mask, 7) = 1))::bigint, -- small
(COUNT(*) filter (WHERE get_bit(error_mask, 6) = 1))::bigint, -- null
(COUNT(*) filter (WHERE get_bit(error_mask, 5) = 1))::bigint, -- invalid_type
-- bit 4 é reservado para duplicados
(COUNT(*) filter (WHERE get_bit(error_mask, 3) = 1))::bigint, -- is_closed
(COUNT(*) filter (WHERE get_bit(error_mask, 2) = 1))::bigint -- large
-- bit 1 uso futuro
-- bit 0 uso futuro
]
FROM c
),
ins_asis AS (
INSERT INTO ingest.feature_asis
SELECT file_id, gid, properties, geom
FROM c
WHERE bit_count(error_mask) = 0
RETURNING 1
),
ins_asis_discarded AS (
INSERT INTO ingest.feature_asis_discarded
SELECT file_id, gid, properties || jsonb_build_object('error_mask',error_mask), geom
FROM c
WHERE bit_count(error_mask) <> 0
RETURNING 1
)
SELECT array_append(array_append( (SELECT * FROM stats), (SELECT COUNT(*) FROM ins_asis) ), (SELECT COUNT(*) FROM ins_asis_discarded))
"
PL/pgSQL function ingest.any_load(text,text,text,text,bigint,text,text[],integer,integer,boolean,text,boolean) line 213 at EXECUTE
make: *** [makefile:66: block] Error 1
0e1
Erro no comando make via