dg:Funções de ingestã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