dg:Funções de ingestão: mudanças entre as edições
Sem resumo de edição |
Sem resumo de edição |
||
Linha 1: | Linha 1: | ||
*Texto original: https://github.com/digital-guard/preserv/blob/main/docs/pt/man-ingestFunctions.md | |||
SQL Schema <code>ingest</code>. | SQL Schema <code>ingest</code>. | ||
Linha 192: | Linha 194: | ||
</tr> | </tr> | ||
</table> | </table> | ||
---- | |||
{| class="wikitable" | |||
!Function / Description / Example | |||
|- | |||
| | |||
any_load(text, text, text, text, bigint, text, ARRAY, integer, text, boolean) → text | |||
Load (into ingest.feature_asis) shapefile or any other non-GeoJSON, of a separated table. | |||
|- | |||
| | |||
any_load(text, text, text, text, text, text, ARRAY, integer, text, boolean) → text | |||
Wrap to ingest.any_load(1,2,3,4=real) using string format DD_DD. | |||
|- | |||
| | |||
any_load_debug(text, text, text, text, text, text, ARRAY, text, boolean) → jsonb | |||
|- | |||
| | |||
donated_packcomponent_distribution_prefixes(integer) → _text | |||
|- | |||
| | |||
donated_packcomponent_geomtype(bigint) → _text | |||
[Geomtype,ftname,class_ftname,shortname_pt] of a layer_file. | |||
|- | |||
| | |||
fdw_csv_paths(text, text, text) → _text | |||
|- | |||
| | |||
fdw_generate(text, text, text, ARRAY, boolean, text, text, boolean) → text | |||
Generates a structure FOREIGN TABLE for ingestion. | |||
|- | |||
| | |||
fdw_generate_direct_csv(text, text, text, boolean, boolean) → text | |||
Generates a FOREIGN TABLE for simples and direct CSV ingestion. | |||
|- | |||
| | |||
fdw_generate_getclone(text, text, text, ARRAY, ARRAY, text) → text | |||
Generates a clone-structure FOREIGN TABLE for ingestion. Wrap for fdw_generate(). | |||
|- | |||
| | |||
fdw_generate_getcsv(text, text, text, text) → text | |||
|- | |||
| | |||
feature_asis_assign(bigint) → jsonb | |||
|- | |||
| | |||
feature_asis_assign_format(bigint, text, text, text) → text | |||
|- | |||
| | |||
feature_asis_assign_signature(bigint) → jsonb | |||
|- | |||
| | |||
feature_asis_assign_volume(bigint, boolean) → jsonb | |||
|- | |||
| | |||
feature_asis_export(bigint, text, integer, jsonb, USER-DEFINED) → record | |||
|- | |||
| | |||
feature_asis_geohashes(bigint, integer) → jsonb | |||
|- | |||
| | |||
feature_asis_similarity(bigint, USER-DEFINED, ARRAY) → jsonb | |||
|- | |||
| | |||
geojson_load(text, integer, real, text, text, boolean) → text | |||
|- | |||
| | |||
getmeta_to_file(text, integer, bigint, text, integer, text) → int8 | |||
Reads file metadata and inserts it into ingest.donated_PackComponent. If proc_step=1 returns valid ID else NULL. | |||
|- | |||
| | |||
getmeta_to_file(text, integer, bigint) → int8 | |||
Reads file metadata and return id if exists in ingest.donated_PackComponent. | |||
|- | |||
| | |||
getmeta_to_file(text, text, bigint) → int8 | |||
Wrap para ingest.getmeta_to_file(text,int,bigint) usando ftName ao invés de ftID. | |||
|- | |||
| | |||
getmeta_to_file(text, text, bigint, text, integer, text) → int8 | |||
Wrap para ingest.getmeta_to_file() usando ftName ao invés de ftID. | |||
|- | |||
| | |||
insert_bytesize(jsonb) → jsonb | |||
|- | |||
| | |||
join(text, text, text, text, text, text) → text | |||
Join layer and cadlayer. | |||
|- | |||
| | |||
jplanet_inserts_and_drops(smallint, boolean) → void | |||
|- | |||
| | |||
jsonb_mustache_prepare(jsonb, text) → jsonb | |||
|- | |||
| | |||
lix_generate_make_conf_with_license(text, text) → text | |||
|- | |||
| | |||
lix_generate_make_conf_with_size(text, text) → text | |||
|- | |||
| | |||
lix_generate_makefile(text, text) → text | |||
|- | |||
| | |||
lix_generate_readme(text, text) → text | |||
|- | |||
| | |||
lix_insert(text) → void | |||
|- | |||
| | |||
load_codec_type(text, text, text) → text | |||
Load codec_type.csv. | |||
|- | |||
| | |||
load_hcode_parameters(text, text, text) → text | |||
Load hcode_parameters.csv. | |||
|- | |||
| | |||
osm_load(text, text, text, bigint, text, ARRAY, integer, text, boolean) → text | |||
|- | |||
| | |||
osm_load(text, text, text, text, text, ARRAY, integer, text, boolean) → text | |||
Wrap to ingest.osm_load(1,2,3,4=real) using string format DD_DD. | |||
|- | |||
| | |||
package_layers_summary(real, text, text) → xml | |||
|- | |||
| | |||
publicating_geojsons(bigint, text, text) → text | |||
|- | |||
| | |||
publicating_geojsons(text, text, text) → text | |||
Wrap to ingest.publicating_geojsons | |||
|- | |||
| | |||
publicating_geojsons_p1(bigint, text) → text | |||
|- | |||
| | |||
publicating_geojsons_p2(bigint, text, boolean) → text | |||
|- | |||
| | |||
publicating_geojsons_p3(bigint, text, text) → text | |||
|- | |||
| | |||
publicating_geojsons_p4(bigint, text, text) → text | |||
|- | |||
| | |||
qgis_vwadmin_feature_asis(text) → text | |||
|} | |||
[[Categoria:Digital-guard]] | [[Categoria:Digital-guard]] |
Edição das 15h58min de 3 de maio de 2023
SQL Schema ingest
.
Function / Description / Example |
Load (into ingest.feature_asis) shapefile or any other non-GeoJSON, of a separated table. |
Wrap to ingest.any_load(1,2,3,4=real) using string format DD_DD. |
|
|
[Geomtype,ftname,class_ftname,shortname_pt] of a layer_file. |
|
Generates a structure FOREIGN TABLE for ingestion. |
Generates a FOREIGN TABLE for simples and direct CSV ingestion. |
Generates a clone-structure FOREIGN TABLE for ingestion. Wrap for fdw_generate(). |
|
|
|
|
|
|
|
|
|
Reads file metadata and inserts it into ingest.donated_PackComponent. If proc_step=1 returns valid ID else NULL. |
Reads file metadata and return id if exists in ingest.donated_PackComponent. |
Wrap para ingest.getmeta_to_file(text,int,bigint) usando ftName ao invés de ftID. |
Wrap para ingest.getmeta_to_file() usando ftName ao invés de ftID. |
|
Join layer and cadlayer. |
|
|
|
|
|
|
|
Load codec_type.csv. |
Load hcode_parameters.csv. |
|
Wrap to ingest.osm_load(1,2,3,4=real) using string format DD_DD. |
|
|
Wrap to ingest.publicating_geojsons |
|
|
|
|
|
Function / Description / Example |
---|
any_load(text, text, text, text, bigint, text, ARRAY, integer, text, boolean) → text Load (into ingest.feature_asis) shapefile or any other non-GeoJSON, of a separated table. |
any_load(text, text, text, text, text, text, ARRAY, integer, text, boolean) → text Wrap to ingest.any_load(1,2,3,4=real) using string format DD_DD. |
any_load_debug(text, text, text, text, text, text, ARRAY, text, boolean) → jsonb |
donated_packcomponent_distribution_prefixes(integer) → _text |
donated_packcomponent_geomtype(bigint) → _text [Geomtype,ftname,class_ftname,shortname_pt] of a layer_file. |
fdw_csv_paths(text, text, text) → _text |
fdw_generate(text, text, text, ARRAY, boolean, text, text, boolean) → text Generates a structure FOREIGN TABLE for ingestion. |
fdw_generate_direct_csv(text, text, text, boolean, boolean) → text Generates a FOREIGN TABLE for simples and direct CSV ingestion. |
fdw_generate_getclone(text, text, text, ARRAY, ARRAY, text) → text Generates a clone-structure FOREIGN TABLE for ingestion. Wrap for fdw_generate(). |
fdw_generate_getcsv(text, text, text, text) → text |
feature_asis_assign(bigint) → jsonb |
feature_asis_assign_format(bigint, text, text, text) → text |
feature_asis_assign_signature(bigint) → jsonb |
feature_asis_assign_volume(bigint, boolean) → jsonb |
feature_asis_export(bigint, text, integer, jsonb, USER-DEFINED) → record |
feature_asis_geohashes(bigint, integer) → jsonb |
feature_asis_similarity(bigint, USER-DEFINED, ARRAY) → jsonb |
geojson_load(text, integer, real, text, text, boolean) → text |
getmeta_to_file(text, integer, bigint, text, integer, text) → int8 Reads file metadata and inserts it into ingest.donated_PackComponent. If proc_step=1 returns valid ID else NULL. |
getmeta_to_file(text, integer, bigint) → int8 Reads file metadata and return id if exists in ingest.donated_PackComponent. |
getmeta_to_file(text, text, bigint) → int8 Wrap para ingest.getmeta_to_file(text,int,bigint) usando ftName ao invés de ftID. |
getmeta_to_file(text, text, bigint, text, integer, text) → int8 Wrap para ingest.getmeta_to_file() usando ftName ao invés de ftID. |
insert_bytesize(jsonb) → jsonb |
join(text, text, text, text, text, text) → text Join layer and cadlayer. |
jplanet_inserts_and_drops(smallint, boolean) → void |
jsonb_mustache_prepare(jsonb, text) → jsonb |
lix_generate_make_conf_with_license(text, text) → text |
lix_generate_make_conf_with_size(text, text) → text |
lix_generate_makefile(text, text) → text |
lix_generate_readme(text, text) → text |
lix_insert(text) → void |
load_codec_type(text, text, text) → text Load codec_type.csv. |
load_hcode_parameters(text, text, text) → text Load hcode_parameters.csv. |
osm_load(text, text, text, bigint, text, ARRAY, integer, text, boolean) → text |
osm_load(text, text, text, text, text, ARRAY, integer, text, boolean) → text Wrap to ingest.osm_load(1,2,3,4=real) using string format DD_DD. |
package_layers_summary(real, text, text) → xml |
publicating_geojsons(bigint, text, text) → text |
publicating_geojsons(text, text, text) → text Wrap to ingest.publicating_geojsons |
publicating_geojsons_p1(bigint, text) → text |
publicating_geojsons_p2(bigint, text, boolean) → text |
publicating_geojsons_p3(bigint, text, text) → text |
publicating_geojsons_p4(bigint, text, text) → text |
qgis_vwadmin_feature_asis(text) → text |