Open crebollobr opened 1 month ago
cd /var/gits/_dg/preserv-MX/data/_pk0002.01
make geoaddress
Postgis type: POINT[2] Shapefile type: Point Postgis type: POINT[2] Shapefile type: Point Postgis type: POINT[2] cd /tmp/sandbox/_pk48400000201_002; psql postgres://postgres@localhost/ingest21 -c "CREATE VIEW vw1_pk48400000201102_p1_geoaddress AS SELECT gid,numext AS hnum,idunico,cvegeo AS ref,idnexft,cveft,tipovial || ' ' || nomvial AS via,cveref1,tipovr1,nomref1,cveref2,tipovr2,nomref2,cveasen,tipoasen,nomasen AS nsvia,cp,codigo,fechaact,observ,nomserv,tipoarea,geografico,acceso,instituc,geometria,tipodom,tiposerv,geom FROM pk48400000201102_p1_geoaddress" | psql postgres://postgres@localhost/ingest21 -c "SELECT ingest.any_load('shp2sqlparalell','$(find /tmp/sandbox/_pk48400000201_002 -path "direccion/ne*.shp" | head -n 1)','geoaddress_full','vw1_pk48400000201102_p1_geoaddress','48400000201102','cf292acbe8d4b1b562a9af3172b2e8571de0f24be7fd814f10fdc50323d9494f.zip',array[]::text[],1,1,true)" | psql postgres://postgres@localhost/ingest21 -c "DROP VIEW vw1_pk48400000201102_p1_geoaddress" ERROR: view "vw1_pk48400000201102_p1_geoaddress" does not exist
colocar um drop if nos comandos
cd /var/gits/_dg/preserv-MX/data/_pk0002.01
make geoaddress
Postgis type: POINT[2] Shapefile type: Point Postgis type: POINT[2] Shapefile type: Point Postgis type: POINT[2] cd /tmp/sandbox/_pk48400000201_002; psql postgres://postgres@localhost/ingest21 -c "CREATE VIEW vw1_pk48400000201102_p1_geoaddress AS SELECT gid,numext AS hnum,idunico,cvegeo AS ref,idnexft,cveft,tipovial || ' ' || nomvial AS via,cveref1,tipovr1,nomref1,cveref2,tipovr2,nomref2,cveasen,tipoasen,nomasen AS nsvia,cp,codigo,fechaact,observ,nomserv,tipoarea,geografico,acceso,instituc,geometria,tipodom,tiposerv,geom FROM pk48400000201102_p1_geoaddress" | psql postgres://postgres@localhost/ingest21 -c "SELECT ingest.any_load('shp2sqlparalell','$(find /tmp/sandbox/_pk48400000201_002 -path "direccion/ne*.shp" | head -n 1)','geoaddress_full','vw1_pk48400000201102_p1_geoaddress','48400000201102','cf292acbe8d4b1b562a9af3172b2e8571de0f24be7fd814f10fdc50323d9494f.zip',array[]::text[],1,1,true)" | psql postgres://postgres@localhost/ingest21 -c "DROP VIEW vw1_pk48400000201102_p1_geoaddress" ERROR: view "vw1_pk48400000201102_p1_geoaddress" does not exist
colocar um drop if nos comandos