dg:Funções de ingestão

De Documentação

SQL Schema ingest.

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