| Procedures |
| URX_PUBLIC.__st_countagg_transfn(agg agg_count, rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC._add_overview_constraint(ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, factor integer) | |
| URX_PUBLIC._add_raster_constraint(cn name, sql text) | |
| URX_PUBLIC._add_raster_constraint_alignment(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_blocksize(rastschema name, rasttable name, rastcolumn name, axis text) | |
| URX_PUBLIC._add_raster_constraint_coverage_tile(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_extent(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_nodata_values(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_num_bands(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_out_db(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_pixel_types(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_scale(rastschema name, rasttable name, rastcolumn name, axis character) | |
| URX_PUBLIC._add_raster_constraint_spatially_unique(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._add_raster_constraint_srid(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_overview_constraint(ovschema name, ovtable name, ovcolumn name) | |
| URX_PUBLIC._drop_raster_constraint(rastschema name, rasttable name, cn name) | |
| URX_PUBLIC._drop_raster_constraint_alignment(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_blocksize(rastschema name, rasttable name, rastcolumn name, axis text) | |
| URX_PUBLIC._drop_raster_constraint_coverage_tile(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_extent(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_nodata_values(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_num_bands(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_out_db(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_pixel_types(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_regular_blocking(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_scale(rastschema name, rasttable name, rastcolumn name, axis character) | |
| URX_PUBLIC._drop_raster_constraint_spatially_unique(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._drop_raster_constraint_srid(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._overview_constraint(ov raster, factor integer, refschema name, reftable name, refcolumn name) | |
| URX_PUBLIC._overview_constraint_info(ovschema name, ovtable name, ovcolumn name) | |
| URX_PUBLIC._postgis_deprecate(oldname text, newname text, version text) | |
| URX_PUBLIC._postgis_join_selectivity(regclass, text, regclass, text, text) | |
| URX_PUBLIC._postgis_pgsql_version() | |
| URX_PUBLIC._postgis_scripts_pgsql_version() | |
| URX_PUBLIC._postgis_selectivity(tbl regclass, att_name text, geom geometry, mode text) | |
| URX_PUBLIC._postgis_stats(tbl regclass, att_name text, text) | |
| URX_PUBLIC._raster_constraint_info_alignment(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_blocksize(rastschema name, rasttable name, rastcolumn name, axis text) | |
| URX_PUBLIC._raster_constraint_info_coverage_tile(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_extent(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_index(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_nodata_values(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_num_bands(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_out_db(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_pixel_types(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_regular_blocking(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_scale(rastschema name, rasttable name, rastcolumn name, axis character) | |
| URX_PUBLIC._raster_constraint_info_spatially_unique(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_info_srid(rastschema name, rasttable name, rastcolumn name) | |
| URX_PUBLIC._raster_constraint_nodata_values(rast raster) | |
| URX_PUBLIC._raster_constraint_out_db(rast raster) | |
| URX_PUBLIC._raster_constraint_pixel_types(rast raster) | |
| URX_PUBLIC._st_3ddfullywithin(geom1 geometry, geom2 geometry, double precision) | |
| URX_PUBLIC._st_3ddwithin(geom1 geometry, geom2 geometry, double precision) | |
| URX_PUBLIC._st_3dintersects(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_asgeojson(integer, geography, integer, integer) | |
| URX_PUBLIC._st_asgeojson(integer, geometry, integer, integer) | |
| URX_PUBLIC._st_asgml(integer, geography, integer, integer, text, text) | |
| URX_PUBLIC._st_asgml(integer, geometry, integer, integer, text, text) | |
| URX_PUBLIC._st_askml(integer, geography, integer, text) | |
| URX_PUBLIC._st_askml(integer, geometry, integer, text) | |
| URX_PUBLIC._st_aspect4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC._st_asraster(geom geometry, scalex double precision, scaley double precision, width integer, height integer, pixeltype text[], value double precision[], nodataval double precision[], upperleftx double precision, upperlefty double precision, gridx double precision, gridy double precision, skewx double precision, skewy double precision, touched boolean) | |
| URX_PUBLIC._st_asx3d(integer, geometry, integer, integer, text) | |
| URX_PUBLIC._st_bestsrid(geography) | |
| URX_PUBLIC._st_bestsrid(geography, geography) | |
| URX_PUBLIC._st_buffer(geometry, double precision, cstring) | |
| URX_PUBLIC._st_clip(rast raster, nband integer[], geom geometry, nodataval double precision[], crop boolean) | |
| URX_PUBLIC._st_colormap(rast raster, nband integer, colormap text, method text) | |
| URX_PUBLIC._st_concavehull(param_inputgeom geometry) | |
| URX_PUBLIC._st_contains(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_contains(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_containsproperly(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_containsproperly(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_convertarray4ma(value double precision[]) | |
| URX_PUBLIC._st_count(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC._st_count(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC._st_countagg_finalfn(agg agg_count) | |
| URX_PUBLIC._st_countagg_transfn(agg agg_count, rast raster, exclude_nodata_value boolean) | |
| URX_PUBLIC._st_countagg_transfn(agg agg_count, rast raster, nband integer, exclude_nodata_value boolean) | |
| URX_PUBLIC._st_countagg_transfn(agg agg_count, rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC._st_coveredby(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_coveredby(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_covers(geography, geography) | |
| URX_PUBLIC._st_covers(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_covers(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_crosses(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_dfullywithin(geom1 geometry, geom2 geometry, double precision) | |
| URX_PUBLIC._st_dfullywithin(rast1 raster, nband1 integer, rast2 raster, nband2 integer, distance double precision) | |
| URX_PUBLIC._st_distance(geography, geography, double precision, boolean) | |
| URX_PUBLIC._st_distancetree(geography, geography) | |
| URX_PUBLIC._st_distancetree(geography, geography, double precision, boolean) | |
| URX_PUBLIC._st_distanceuncached(geography, geography) | |
| URX_PUBLIC._st_distanceuncached(geography, geography, boolean) | |
| URX_PUBLIC._st_distanceuncached(geography, geography, double precision, boolean) | |
| URX_PUBLIC._st_dwithin(geography, geography, double precision, boolean) | |
| URX_PUBLIC._st_dwithin(geom1 geometry, geom2 geometry, double precision) | |
| URX_PUBLIC._st_dwithin(rast1 raster, nband1 integer, rast2 raster, nband2 integer, distance double precision) | |
| URX_PUBLIC._st_dwithinuncached(geography, geography, double precision) | |
| URX_PUBLIC._st_dwithinuncached(geography, geography, double precision, boolean) | |
| URX_PUBLIC._st_equals(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_expand(geography, double precision) | |
| URX_PUBLIC._st_gdalwarp(rast raster, algorithm text, maxerr double precision, srid integer, scalex double precision, scaley double precision, gridx double precision, gridy double precision, skewx double precision, skewy double precision, width integer, height integer) | |
| URX_PUBLIC._st_geomfromgml(text, integer) | |
| URX_PUBLIC._st_hillshade4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC._st_histogram(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], right boolean, min double precision, max double precision) | |
| URX_PUBLIC._st_histogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], right boolean) | |
| URX_PUBLIC._st_intersects(geom geometry, rast raster, nband integer) | |
| URX_PUBLIC._st_intersects(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_intersects(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_linecrossingdirection(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_longestline(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_mapalgebra(rastbandargset rastbandarg[], callbackfunc regprocedure, pixeltype text, distancex integer, distancey integer, extenttype text, customextent raster, mask double precision[], weighted boolean, userargs text[]) | |
| URX_PUBLIC._st_mapalgebra(rastbandargset rastbandarg[], expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision) | |
| URX_PUBLIC._st_maxdistance(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_neighborhood(rast raster, band integer, columnx integer, rowy integer, distancex integer, distancey integer, exclude_nodata_value boolean) | |
| URX_PUBLIC._st_orderingequals(geometrya geometry, geometryb geometry) | |
| URX_PUBLIC._st_overlaps(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_overlaps(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_pixelaspolygons(rast raster, band integer, columnx integer, rowy integer, exclude_nodata_value boolean) | |
| URX_PUBLIC._st_pointoutside(geography) | |
| URX_PUBLIC._st_quantile(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC._st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC._st_rastertoworldcoord(rast raster, columnx integer, rowy integer) | |
| URX_PUBLIC._st_reclass(rast raster, reclassargset reclassarg[]) | |
| URX_PUBLIC._st_roughness4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC._st_samealignment_finalfn(agg agg_samealignment) | |
| URX_PUBLIC._st_samealignment_transfn(agg agg_samealignment, rast raster) | |
| URX_PUBLIC._st_setvalues(rast raster, nband integer, x integer, y integer, newvalueset double precision[], noset boolean[], hasnosetvalue boolean, nosetvalue double precision, keepnodata boolean) | |
| URX_PUBLIC._st_slope4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC._st_summarystats(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC._st_summarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC._st_summarystats_finalfn(internal) | |
| URX_PUBLIC._st_summarystats_transfn(internal, raster, boolean, double precision) | |
| URX_PUBLIC._st_summarystats_transfn(internal, raster, integer, boolean) | |
| URX_PUBLIC._st_summarystats_transfn(internal, raster, integer, boolean, double precision) | |
| URX_PUBLIC._st_tile(rast raster, width integer, height integer, nband integer[], padwithnodata boolean, nodataval double precision) | |
| URX_PUBLIC._st_touches(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_touches(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_tpi4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC._st_tri4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC._st_union_finalfn(internal) | |
| URX_PUBLIC._st_union_transfn(internal, raster) | |
| URX_PUBLIC._st_union_transfn(internal, raster, integer) | |
| URX_PUBLIC._st_union_transfn(internal, raster, integer, text) | |
| URX_PUBLIC._st_union_transfn(internal, raster, text) | |
| URX_PUBLIC._st_union_transfn(internal, raster, unionarg[]) | |
| URX_PUBLIC._st_valuecount(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC._st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC._st_voronoi(g1 geometry, clip geometry, tolerance double precision, return_polygons boolean) | |
| URX_PUBLIC._st_within(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC._st_within(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | |
| URX_PUBLIC._st_worldtorastercoord(rast raster, longitude double precision, latitude double precision) | |
| URX_PUBLIC._updaterastersrid(schema_name name, table_name name, column_name name, new_srid integer) | |
| URX_PUBLIC._urx_abi_certificate_create() | |
| URX_PUBLIC._urx_abi_certificate_type_create() | |
| URX_PUBLIC._urx_abi_employee_certificate_create() | |
| URX_PUBLIC._urx_abi_employee_create() | |
| URX_PUBLIC._urx_abi_function_create() | |
| URX_PUBLIC._urx_abi_rule_create() | |
| URX_PUBLIC._urx_act_status_dt() | |
| URX_PUBLIC._urx_adm_business_unit_create(_ser_group integer[], _db_password character varying, _per_name character varying, _per_email character varying, _per_nick_name character varying, _per_legal_number character varying, _uni_activity character varying, _uni_type character varying, _uni_website_address character varying, _uni_legal_state_number character varying, _uni_legal_city_number character varying, _uni_marketing_tx character varying, _use_full_name character varying, _use_name character varying, _use_email character varying, _use_password character varying, _use_salt character varying, _use_ip_address character varying, _add_street character varying, _add_number character varying, _add_neighbor character varying, _add_city character varying, _add_location_type character varying, _pho_fixed1 character varying, _pho_mobile1 character varying, _use_gender integer, _add_cep integer, _add_state_id integer) | |
| URX_PUBLIC._urx_adm_business_unit_delete(_uni_person_id integer) | |
| URX_PUBLIC._urx_adm_calendar_holliday_create() | |
| URX_PUBLIC._urx_adm_department_create() | |
| URX_PUBLIC._urx_adm_from_zero_paper_create() | |
| URX_PUBLIC._urx_adm_unit_auto_set_default_account(_acc_person_id integer) | |
| URX_PUBLIC._urx_ana_request_status_dt() | |
| URX_PUBLIC._urx_ana_status_dt() | |
| URX_PUBLIC._urx_array_accum(anyelement) | |
| URX_PUBLIC._urx_ban_order_feedback_dt() | |
| URX_PUBLIC._urx_ban_order_status_dt() | |
| URX_PUBLIC._urx_cas_flow_dt() | |
| URX_PUBLIC._urx_cas_flow_reset_dt() | |
| URX_PUBLIC._urx_deb_status_dt() | |
| URX_PUBLIC._urx_delete_delete_bit() | |
| URX_PUBLIC._urx_doc_dt() | |
| URX_PUBLIC._urx_doc_status_dt() | |
| URX_PUBLIC._urx_eva_effective_dt() | |
| URX_PUBLIC._urx_fin_account_create() | |
| URX_PUBLIC._urx_fin_account_create(_acc_person_id integer, _acc_agency integer, _acc_number integer, _acc_type_id integer, _acc_number_dv integer, _acc_agency_dv character varying, _acc_bank_id character varying) | |
| URX_PUBLIC._urx_fin_account_status_create() | |
| URX_PUBLIC._urx_fin_account_type_create() | |
| URX_PUBLIC._urx_fin_bank_event_create() | |
| URX_PUBLIC._urx_fin_bank_order_create() | |
| URX_PUBLIC._urx_fin_bank_order_feedback_create() | |
| URX_PUBLIC._urx_fin_bank_order_feedback_item_create() | |
| URX_PUBLIC._urx_fin_bank_order_item_create() | |
| URX_PUBLIC._urx_fin_bank_order_number() | |
| URX_PUBLIC._urx_fin_bank_order_status_list_create() | |
| URX_PUBLIC._urx_fin_bank_order_update_value(_ban_order_id integer) | A ser executado a cada inclusão, alteração e exclusão de itens à Ordem Bancária. |
| URX_PUBLIC._urx_fin_billing_create() | |
| URX_PUBLIC._urx_fin_billing_tax_create() | |
| URX_PUBLIC._urx_fin_cash_flow_create() | |
| URX_PUBLIC._urx_fin_cash_flow_insert_from_debt(_uni_person_id integer) | A ser executada diariamente. Importa para o fluxo de caixa os movimentos correspondentes aos débitos realizados. |
| URX_PUBLIC._urx_fin_cash_flow_insert_from_transference(_uni_person_id integer) | A ser executada diariamente. Importa para o fluxo de caixa os movimentos correspondentes às transferências realizadas. |
| URX_PUBLIC._urx_fin_cash_flow_reset_create() | |
| URX_PUBLIC._urx_fin_contract_create() | |
| URX_PUBLIC._urx_fin_credit_cell_create() | |
| URX_PUBLIC._urx_fin_credit_cell_type_create() | |
| URX_PUBLIC._urx_fin_debt_check_create() | |
| URX_PUBLIC._urx_fin_debt_create() | |
| URX_PUBLIC._urx_fin_debt_group_adjustments(_uni_person_id integer) | |
| URX_PUBLIC._urx_fin_debt_group_create() | |
| URX_PUBLIC._urx_fin_debt_set_status(_deb_id integer, _deb_is_approved integer, _deb_status_id integer, _deb_payment_date date) | Atualiza a situação do débito correspondente a cada registro. |
| URX_PUBLIC._urx_fin_debt_status_list_create() | |
| URX_PUBLIC._urx_fin_invoice_auto_set(_ser_id integer, _account_id integer) | Geração em bloco, a ser chamada pela função que dispara o processo batch. |
| URX_PUBLIC._urx_fin_invoice_auto_set_interface(_account_id integer, _date date) | Geração em bloco. Comanda o processo batch. Deve ser executada diariamente, antes do início do expediente. Cria o registro de entrada de recurso financeiro (fin_invoice). |
| URX_PUBLIC._urx_fin_invoice_boleto_check_create(_inv_id integer) | Verificação a ser realizada antes da inclusão de boletos em bloco, a ser chamada pelo usuário. |
| URX_PUBLIC._urx_fin_invoice_create() | |
| URX_PUBLIC._urx_fin_invoice_create(_inv_issue_date date, _inv_due_date date, _inv_service_id integer, _inv_type_id integer, _inv_seq_number integer, _inv_baseline_bit integer, _inv_service_value numeric, _inv_discount_initial_value numeric, _inv_interest_initial_value numeric, _inv_remarks character varying, _inv_number character varying, _account_id integer) | Geração unitária, a ser chamada pelas demais funções. |
| URX_PUBLIC._urx_fin_invoice_create_set(_due_date date, _qty integer, _ser_id integer, _type_id integer, _service_value numeric, _discount_initial_value numeric, _interest_initial_value numeric, _remarks character varying, _account_id integer) | Geração em bloco, a ser chamada pelo usuário. |
| URX_PUBLIC._urx_fin_invoice_feedback_create() | |
| URX_PUBLIC._urx_fin_invoice_feedback_item_create() | |
| URX_PUBLIC._urx_fin_invoice_our_number() | |
| URX_PUBLIC._urx_fin_invoice_request_create() | |
| URX_PUBLIC._urx_fin_invoice_request_number() | |
| URX_PUBLIC._urx_fin_invoice_set_account_credit(_account_id integer) | Insere o status 'PAGO'e realiza o crédito em sua devida célula de crédito via fluxo de caixa, para todos os registros cuja data de crédito seja igual a data corrente ou anterior. |
| URX_PUBLIC._urx_fin_invoice_set_invoice_credit(_inv_id integer) | Insere o status 'PAGO'e realiza o crédito em sua devida célula de crédito via fluxo de caixa, para todos os registros cuja data de crédito seja igual a data corrente ou anterior. |
| URX_PUBLIC._urx_fin_invoice_status_list_create() | |
| URX_PUBLIC._urx_fin_nfse_cancel_create() | |
| URX_PUBLIC._urx_fin_nfse_cancel_tag() | |
| URX_PUBLIC._urx_fin_nfse_create() | |
| URX_PUBLIC._urx_fin_rps_cancel_create() | |
| URX_PUBLIC._urx_fin_rps_cancel_tag() | |
| URX_PUBLIC._urx_fin_rps_create() | |
| URX_PUBLIC._urx_fin_rps_number() | |
| URX_PUBLIC._urx_fin_rps_set_create() | |
| URX_PUBLIC._urx_fin_rps_set_number() | |
| URX_PUBLIC._urx_fin_supplier_type_create() | |
| URX_PUBLIC._urx_fin_taxing_create() | |
| URX_PUBLIC._urx_fin_taxing_type_create() | |
| URX_PUBLIC._urx_fin_transaction_type_create() | |
| URX_PUBLIC._urx_fin_transference_create() | |
| URX_PUBLIC._urx_fol_call_dt() | |
| URX_PUBLIC._urx_fol_dt() | |
| URX_PUBLIC._urx_import_data_from_zero_paper(_uni_person_id integer) | |
| URX_PUBLIC._urx_import_data_reset(_uni_person_id integer) | |
| URX_PUBLIC._urx_inv_feedback_dt() | |
| URX_PUBLIC._urx_inv_status_dt() | |
| URX_PUBLIC._urx_isnumeric(_text character varying) | |
| URX_PUBLIC._urx_kno_notice_create() | |
| URX_PUBLIC._urx_kno_notice_create(_mod_id integer, _uni_person_id integer, _not_title character varying, _not_text text) | |
| URX_PUBLIC._urx_kno_notice_type_create() | |
| URX_PUBLIC._urx_kno_notice_user_create() | |
| URX_PUBLIC._urx_kno_torpedo_create() | |
| URX_PUBLIC._urx_migration_tool_abi_employee_from_bank_order(_legal_number character varying, _uni_person_id integer) | A ser executado para importar dados de funcionário a partir do arquivo de retorno de Folha de Pagamento. |
| URX_PUBLIC._urx_migration_tool_create_cadaclie_tmp() | |
| URX_PUBLIC._urx_migration_tool_create_servclie_tmp() | |
| URX_PUBLIC._urx_migration_tool_employee_accounts(_ban_id character varying) | A ser executado apenas na importação dos dados das contas bancárias. |
| URX_PUBLIC._urx_migration_tool_fin_debt(_uni_person_id integer) | |
| URX_PUBLIC._urx_migration_tool_fin_debt_checks(_ban_id character varying) | A ser executado apenas na migração inicial dos dados. Importa os cheques. Cria a tabela Cheques Duplicados, carregando nessa os cheques com números duplicados |
| URX_PUBLIC._urx_migration_tool_fin_debt_status(_uni_person_id integer) | A ser executado apenas na migração inicial dos dados. Atualiza a situação do débito. |
| URX_PUBLIC._urx_migration_tool_fin_invoice() | |
| URX_PUBLIC._urx_migration_tool_fin_invoice_bank_data(_filename character varying, _propagate boolean, _ban_id character varying) | Importação dos arquivos de Títulos Pendentes. |
| URX_PUBLIC._urx_migration_tool_fin_invoice_update_number(_uni_person_id integer) | |
| URX_PUBLIC._urx_migration_tool_fin_transference(_uni_person_id integer) | A ser executado apenas na migração inicial dos dados. Importa as transferências realizadas entre contas. |
| URX_PUBLIC._urx_migration_tool_ope_analysis_item() | |
| URX_PUBLIC._urx_migration_tool_ope_service(_uni_person_id integer) | |
| URX_PUBLIC._urx_migration_tool_ope_service_activity() | |
| URX_PUBLIC._urx_migration_tool_ope_service_item_exception() | A ser executado apenas na migração inicial dos dados. Inclui itens do serviço quando estiverem vazios após as validações padrão. |
| URX_PUBLIC._urx_migration_tool_ope_service_item_tank() | |
| URX_PUBLIC._urx_migration_tool_ope_service_item_tank_unit(_ser_tank_service_item_id integer, _description text) | |
| URX_PUBLIC._urx_migration_tool_ope_service_product(_uni_person_id integer) | |
| URX_PUBLIC._urx_migration_tool_ope_service_recall_activity() | |
| URX_PUBLIC._urx_migration_tool_ope_service_recall_item_tank() | |
| URX_PUBLIC._urx_migration_tool_ope_service_recall_item_tank_unit(_ser_tank_service_recall_item_id integer, _description text) | |
| URX_PUBLIC._urx_migration_tool_ope_service_reorder_ser_id() | |
| URX_PUBLIC._urx_migration_tool_ope_service_type_product() | |
| URX_PUBLIC._urx_migration_tool_sel_commission() | |
| URX_PUBLIC._urx_migration_tool_sel_customer(_uni_person_id integer) | |
| URX_PUBLIC._urx_migration_tool_sel_customer_delete_without_address(_uni_person_id integer) | Remove clientes sem endereço e sem serviço aprovado |
| URX_PUBLIC._urx_migration_tool_sel_customer_email() | |
| URX_PUBLIC._urx_migration_tool_sel_customer_phone() | |
| URX_PUBLIC._urx_migration_tool_sel_customer_phone_unit(_id integer, _ddd integer, _number integer[], _ramal integer) |
Tipos de Números de Telefones:
'1' => 'fixed1',
'2' => 'fixed2',
'3' => 'fixed3',
'4' => 'fixed4',
'5' => 'mobile1',
'6' => 'mobile2',
'7' => 'mobile3',
'8' => 'mobile4'
|
| URX_PUBLIC._urx_migration_tool_sel_customer_remove_duplicates(_dry_running boolean) | |
| URX_PUBLIC._urx_migration_tool_sel_customer_remove_duplicates_fallback() | |
| URX_PUBLIC._urx_migration_tool_sel_customer_to_customer_location(_per_legal_number character varying) | |
| URX_PUBLIC._urx_migration_tool_sel_customer_to_customer_location_fallback(_per_legal_number character varying) | |
| URX_PUBLIC._urx_migration_tool_sel_customer_to_customer_location_fallback_() | |
| URX_PUBLIC._urx_migration_tool_sel_customer_to_customer_location_starter() | |
| URX_PUBLIC._urx_migration_tool_set_all_sequences() | |
| URX_PUBLIC._urx_migration_tool_starter(_manager character varying, _invoice_data_file_path character varying, _uni_person_id integer, _ban_id character varying) | |
| URX_PUBLIC._urx_migration_tool_sys_address_sanitize() | |
| URX_PUBLIC._urx_migration_tool_sys_person() | |
| URX_PUBLIC._urx_migration_tool_sys_person_export(_uni_person_id integer) | |
| URX_PUBLIC._urx_migration_tool_sys_person_sanitize() | |
| URX_PUBLIC._urx_migration_tool_sys_person_tmp_create() | |
| URX_PUBLIC._urx_not_dt() | |
| URX_PUBLIC._urx_ope_analysis_create() | |
| URX_PUBLIC._urx_ope_analysis_create(_ana_service_id integer) | |
| URX_PUBLIC._urx_ope_analysis_item_create() | |
| URX_PUBLIC._urx_ope_analysis_request_create() | |
| URX_PUBLIC._urx_ope_analysis_request_number() | |
| URX_PUBLIC._urx_ope_analysis_request_status_list_create() | |
| URX_PUBLIC._urx_ope_analysis_status_list_create() | |
| URX_PUBLIC._urx_ope_document_create() | |
| URX_PUBLIC._urx_ope_document_status_list_create() | |
| URX_PUBLIC._urx_ope_equipment_create() | |
| URX_PUBLIC._urx_ope_fuel_create() | |
| URX_PUBLIC._urx_ope_pre_doc_create() | |
| URX_PUBLIC._urx_ope_ruled_report_create() | |
| URX_PUBLIC._urx_ope_service_clone(_ser_id integer, _ser_operator integer, _ser_planned_date date) | |
| URX_PUBLIC._urx_ope_service_create() | |
| URX_PUBLIC._urx_ope_service_item_chemical_create() | |
| URX_PUBLIC._urx_ope_service_item_chemical_item_create() | |
| URX_PUBLIC._urx_ope_service_item_create() | |
| URX_PUBLIC._urx_ope_service_item_non_chemical_create() | |
| URX_PUBLIC._urx_ope_service_item_product_create() | |
| URX_PUBLIC._urx_ope_service_item_tank_create() | |
| URX_PUBLIC._urx_ope_service_number() | |
| URX_PUBLIC._urx_ope_service_payment_quantity() | |
| URX_PUBLIC._urx_ope_service_propagation(_ser_id integer) | |
| URX_PUBLIC._urx_ope_service_propagation_set_activity(_service_id integer, _project_id integer, _category_id integer, _service_nr character varying, _full_desc text, _abbrev_desc text) | |
| URX_PUBLIC._urx_ope_service_recall_create() | |
| URX_PUBLIC._urx_ope_service_recall_item_create() | |
| URX_PUBLIC._urx_ope_service_recall_item_tank_create() | |
| URX_PUBLIC._urx_ope_service_recall_number() | |
| URX_PUBLIC._urx_ope_service_recall_propagation(_ser_recall_id integer) | |
| URX_PUBLIC._urx_ope_service_recall_status_create() | |
| URX_PUBLIC._urx_ope_service_recall_type_create() | |
| URX_PUBLIC._urx_ope_service_status_create() | |
| URX_PUBLIC._urx_ope_service_status_drop_approved(_ser_number integer, _uni_person_id integer) | Retornar o serviço "APROVADO" a condição de "ORÇAMENTO", realiza validações e altera a situação para
"ORÇAMENTO", quando possível. O acesso a esse recurso será disponibilizado para usuários privilegiados.
Validações:
O programa não vai funcionar nas seguintes situações:
- quando a data corrente (a data em que o usuário executa o programa de alteração da situação) ocorrer
após a data de início do serviço, pois o serviço já está na rua, e isso acarretaria em impacto também no
financeiro, já que o sistema vai gerar automaticamente os boletos.
- quando a situação for "CONCLUÍDO".
- quando a opção de pagamento selecionada pelo usuário seja "Iniciando na data de aprovação", pois da
mesma forma, os boletos já terão sido emitidos. |
| URX_PUBLIC._urx_ope_service_status_list_create() | |
| URX_PUBLIC._urx_ope_service_tank_reload() | |
| URX_PUBLIC._urx_ope_service_type_category_create() | |
| URX_PUBLIC._urx_ope_service_type_chemical_create() | |
| URX_PUBLIC._urx_ope_service_type_chemical_label() | |
| URX_PUBLIC._urx_ope_service_type_create() | |
| URX_PUBLIC._urx_ope_service_type_group_create() | |
| URX_PUBLIC._urx_ope_service_type_group_for_desentupimento() | |
| URX_PUBLIC._urx_ope_service_update_schedule(_ser_id integer, _ser_planned_date date) | Atualiza a data de planejamento da execução do serviço e as datas de garantia dos serviços não concluídos |
| URX_PUBLIC._urx_ope_service_update_values(_ser_id integer) | |
| URX_PUBLIC._urx_ope_service_vector_create() | |
| URX_PUBLIC._urx_ope_team_create() | |
| URX_PUBLIC._urx_ope_team_type_create() | |
| URX_PUBLIC._urx_ope_vector_create() | |
| URX_PUBLIC._urx_ope_vehicle_create() | |
| URX_PUBLIC._urx_ope_vehicle_type_create() | |
| URX_PUBLIC._urx_ope_work_order_create() | |
| URX_PUBLIC._urx_ope_work_order_number() | |
| URX_PUBLIC._urx_pro_activity_create() | |
| URX_PUBLIC._urx_pro_activity_create_from_service(_pro_id integer, _ser_id integer, _act_category_id integer, _act_desc_abbrev text, _act_description text) | |
| URX_PUBLIC._urx_pro_activity_create_from_service_recall(_pro_id integer, _ser_recall_id integer, _act_category_id integer, _act_desc_abbrev text, _act_description text) | |
| URX_PUBLIC._urx_pro_activity_kind_create() | |
| URX_PUBLIC._urx_pro_activity_sequence_number() | |
| URX_PUBLIC._urx_pro_activity_status_list_create() | |
| URX_PUBLIC._urx_pro_activity_type_create() | |
| URX_PUBLIC._urx_pro_project_create() | |
| URX_PUBLIC._urx_pro_project_priority_create() | |
| URX_PUBLIC._urx_pro_project_status_list_create() | |
| URX_PUBLIC._urx_pro_project_type_create() | |
| URX_PUBLIC._urx_pro_status_dt() | |
| URX_PUBLIC._urx_replace_ope_pre_doc_variable_names() | |
| URX_PUBLIC._urx_rps_set_issue_dt() | |
| URX_PUBLIC._urx_rul_report_dt() | |
| URX_PUBLIC._urx_sel_commission_create() | |
| URX_PUBLIC._urx_sel_customer_create() | |
| URX_PUBLIC._urx_sel_customer_tank_create() | |
| URX_PUBLIC._urx_sel_customer_tank_material_create() | |
| URX_PUBLIC._urx_sel_customer_tank_order() | |
| URX_PUBLIC._urx_sel_customer_tank_type_create() | |
| URX_PUBLIC._urx_sel_customer_type_create() | |
| URX_PUBLIC._urx_sel_way_in_create() | |
| URX_PUBLIC._urx_ser_recall_status_dt() | |
| URX_PUBLIC._urx_ser_status_dt() | |
| URX_PUBLIC._urx_smart_delete_from_ope_service_status(_ser_id integer, _ser_status_id integer) | |
| URX_PUBLIC._urx_smart_delete_from_pro_activity(_ser_id integer) | |
| URX_PUBLIC._urx_smart_delete_from_sto_request(_ser_id integer) | Torna sem efeito os registros correspondentes a determinado serviço, a ser utilizado por exemplo quando o serviço é 'desaprovado'.
Os registros referentes a remanejamento interno, ou seja do estoque comum para o estoque de produtos à granel (Requsição do tipo 4), bem como os referentes a aquisição de produtos para recomposição de estoque (Requisição do tipo 2) não são contemplados, pois pode ter ocorrido de outro serviço ter-se beneficiado desses registros, e a anulação causaria erro. |
| URX_PUBLIC._urx_smart_delete_from_sto_request_by_id(_req_id integer) | Torna sem efeito o registro correspondente ao id passado. |
| URX_PUBLIC._urx_smart_delete_from_sto_request_grain(_ser_id integer) | Torna sem efeito os registros correspondentes a determinado serviço, a ser utilizado por exemplo quando o serviço é 'desaprovado'.
Os registros referentes a remanejamento interno, ou seja do estoque comum para o estoque de produtos à granel não é contemplado, pois pode ter ocorrido de outro serviço ter-se utilizado do produto remanejado internamente para obter a quantidade desejada, e a anulação causaria erro. |
| URX_PUBLIC._urx_smart_delete_from_sto_request_grain_by_req_id(_req_id integer) | Torna sem efeito os registros correspondentes a determinada requisição. |
| URX_PUBLIC._urx_smart_delete_from_sto_request_item(_req_id integer) | |
| URX_PUBLIC._urx_sto_chemical_class_create() | |
| URX_PUBLIC._urx_sto_chemical_dosage_create() | |
| URX_PUBLIC._urx_sto_chemical_dosage_label() | |
| URX_PUBLIC._urx_sto_chemical_group_application_create() | |
| URX_PUBLIC._urx_sto_chemical_group_create() | |
| URX_PUBLIC._urx_sto_chemical_product_substance_create() | |
| URX_PUBLIC._urx_sto_chemical_subgroup_create() | |
| URX_PUBLIC._urx_sto_chemical_substance_create() | |
| URX_PUBLIC._urx_sto_container_create() | |
| URX_PUBLIC._urx_sto_container_label() | |
| URX_PUBLIC._urx_sto_devolution_create() | |
| URX_PUBLIC._urx_sto_dosage_element_create() | |
| URX_PUBLIC._urx_sto_location_create() | |
| URX_PUBLIC._urx_sto_location_type_create() | |
| URX_PUBLIC._urx_sto_product_at_location_create() | |
| URX_PUBLIC._urx_sto_product_category_create() | |
| URX_PUBLIC._urx_sto_product_create() | |
| URX_PUBLIC._urx_sto_product_grain_inventory(_pro_id integer, _location_id integer) | |
| URX_PUBLIC._urx_sto_product_grain_price(_pro_id integer, _location_id integer) | Obtem o preço do produto existente no estoque à granel, considerando o último remanejamento realizado. |
| URX_PUBLIC._urx_sto_product_gtin13() | |
| URX_PUBLIC._urx_sto_product_inventory(_pro_id integer, _location_id integer) | Obtem a quantidade calculada de itens do produto existente no estoque, considerando apenas os que foram autorizados e efetivados em data anterior ao dia corrente. |
| URX_PUBLIC._urx_sto_product_price(_pro_id integer, _location_id integer) | Obtem o preço do produto existente no estoque, considerando a última aquisição efetivada. |
| URX_PUBLIC._urx_sto_product_type_create() | |
| URX_PUBLIC._urx_sto_product_virtual_inventory(_pro_id integer, _location_id integer) | Obtem a quantidade calculada de itens do produto existente no estoque, incluindo os que não foram autorizados ou efetivados. Tem o propósito de evitar o lançamento repetido de requisições que porventura tenham sido lançadas e não autorizadas ou efetivadas. |
| URX_PUBLIC._urx_sto_product_virtual_price(_pro_id integer, _location_id integer) | Obtem o preço calculado do produto existente no estoque. |
| URX_PUBLIC._urx_sto_replenishment_alert_create() | |
| URX_PUBLIC._urx_sto_request_create() | |
| URX_PUBLIC._urx_sto_request_full_create_from_service(_ser_id integer) | |
| URX_PUBLIC._urx_sto_request_grain_create() | |
| URX_PUBLIC._urx_sto_request_grain_create_from_service(_ser_id integer) | |
| URX_PUBLIC._urx_sto_request_grain_number() | |
| URX_PUBLIC._urx_sto_request_item_create() | |
| URX_PUBLIC._urx_sto_request_item_insert() | |
| URX_PUBLIC._urx_sto_request_number() | |
| URX_PUBLIC._urx_sto_request_set_total_price(_req_id integer) | |
| URX_PUBLIC._urx_sto_request_stock_replenishment(_unit_id integer, _pro_id integer, _qty integer, _location_id integer, _good_dt timestamp without time zone) | Gera uma requisição de 'Entrada no Estoque' a ser processada posteriormente.
Como processamento, entenda-se emitir ordem de compra, receber e dar entrada no produto, registrando:
- a Data-Hora de Efetivação;
- o valor efetivo do produto adquirido, uma vez que o valor lançado no momento da geração do registro foi baseado no preço da última aquisição realizada. |
| URX_PUBLIC._urx_sto_request_type_create() | |
| URX_PUBLIC._urx_sys_address_bound_create() | |
| URX_PUBLIC._urx_sys_address_component_create() | |
| URX_PUBLIC._urx_sys_address_create() | |
| URX_PUBLIC._urx_sys_address_google_component_type_create() | |
| URX_PUBLIC._urx_sys_address_google_place_location_type_create() | |
| URX_PUBLIC._urx_sys_address_google_place_status_create() | |
| URX_PUBLIC._urx_sys_address_google_type_create() | |
| URX_PUBLIC._urx_sys_address_query_create() | |
| URX_PUBLIC._urx_sys_address_query_result_create() | |
| URX_PUBLIC._urx_sys_address_viewport_create() | |
| URX_PUBLIC._urx_sys_attribute_create() | |
| URX_PUBLIC._urx_sys_attribute_group_create() | |
| URX_PUBLIC._urx_sys_cep_city_create() | |
| URX_PUBLIC._urx_sys_cep_neighbor_create() | |
| URX_PUBLIC._urx_sys_cep_state_create() | |
| URX_PUBLIC._urx_sys_domain_create() | |
| URX_PUBLIC._urx_sys_file_create() | |
| URX_PUBLIC._urx_sys_function_create() | |
| URX_PUBLIC._urx_sys_module_create() | |
| URX_PUBLIC._urx_sys_object_create() | |
| URX_PUBLIC._urx_sys_object_create(_has_priv boolean, _fun_domain_id integer, _obj_module_id integer, _obj_is_gender boolean, _default_form_width integer, _obj_table_name character varying, _obj_label character varying, _obj_name character varying, _obj_icon_name character varying, _obj_attribute_prefix character varying, _obj_description character varying, _obj_order_by character varying, _obj_label_plural character varying) | |
| URX_PUBLIC._urx_sys_parameter_create() | |
| URX_PUBLIC._urx_sys_parameter_data_text(_par_label character varying, _par_data_code character varying) | |
| URX_PUBLIC._urx_sys_person_create() | |
| URX_PUBLIC._urx_sys_person_validate_cnpj(_input text) | |
| URX_PUBLIC._urx_sys_person_validate_cpf(_input text) | |
| URX_PUBLIC._urx_sys_phone_create() | |
| URX_PUBLIC._urx_sys_phone_operator_create() | |
| URX_PUBLIC._urx_sys_prevent_update() | |
| URX_PUBLIC._urx_sys_region_create() | |
| URX_PUBLIC._urx_sys_report_attribute_create() | |
| URX_PUBLIC._urx_sys_report_attribute_group_create() | |
| URX_PUBLIC._urx_sys_report_object_create() | |
| URX_PUBLIC._urx_sys_role_create() | |
| URX_PUBLIC._urx_sys_role_create(_role character varying, _password character varying) | |
| URX_PUBLIC._urx_sys_role_drop(_role character varying) | |
| URX_PUBLIC._urx_sys_role_grant_superuser(_role character varying) | |
| URX_PUBLIC._urx_sys_role_revoke_superuser(_role character varying) | |
| URX_PUBLIC._urx_sys_ticket_create() | |
| URX_PUBLIC._urx_sys_ticket_status_list_create() | |
| URX_PUBLIC._urx_sys_ticket_type_create() | |
| URX_PUBLIC._urx_sys_transaction_create(_hstore hstore) | |
| URX_PUBLIC._urx_sys_transaction_create(_tra_id integer, _hstore hstore) | |
| URX_PUBLIC._urx_sys_user_create() | |
| URX_PUBLIC._urx_tel_evaluation_answer_create() | |
| URX_PUBLIC._urx_tel_evaluation_create() | |
| URX_PUBLIC._urx_tel_evaluation_question_create() | |
| URX_PUBLIC._urx_tel_followup_call_create() | |
| URX_PUBLIC._urx_tel_followup_create() | |
| URX_PUBLIC._urx_tel_followup_status_list_create() | |
| URX_PUBLIC._urx_tel_followup_status_type_create() | |
| URX_PUBLIC._urx_tel_followup_type_create() | |
| URX_PUBLIC._urx_tic_status_dt() | |
| URX_PUBLIC._urx_tor_dt() | |
| URX_PUBLIC._urx_tra_dt() | |
| URX_PUBLIC._urx_update_point(table_name character varying, pk_column_name character varying, pk_column_value integer, point_column_name character varying, latitude double precision, longitude double precision) | |
| URX_PUBLIC._urx_update_sto_request_item_quantity() | |
| URX_PUBLIC._urx_use_session_start() | |
| URX_PUBLIC._urx_use_torpedo_from() | |
| URX_PUBLIC._urx_use_torpedo_read() | |
| URX_PUBLIC._urx_utils_beautify_name(_input character varying) | Makes 'vERY goOD' become 'Very Good' |
| URX_PUBLIC._urx_utils_calculate_max_column_length(_table_name character varying) | |
| URX_PUBLIC._urx_utils_chunck_string(_input character varying) | Makes ba_na_na become baNaNa |
| URX_PUBLIC._urx_utils_count_working_days(_start date, _end date) | |
| URX_PUBLIC._urx_utils_create_after_insert_triggers_and_functions() | |
| URX_PUBLIC._urx_utils_create_date_column_with_function_and_trigger(_table_name character varying, _column_name character varying) | |
| URX_PUBLIC._urx_utils_create_delete_bit() | |
| URX_PUBLIC._urx_utils_create_multiple_select(_att_object_id integer, _att_group_id integer, _att_form_width integer, _att_max_length integer, _att_order integer, _label_left character varying, _label_right character varying, _att_data_source character varying, _att_data_source_value character varying, _att_data_source_text character varying, _nxn_object_name character varying, _target_element_id character varying, _database character varying) |
USAGE:
PERFORM _urx_utils_create_multiple_select(
145,
169,
440,
12,
5,
'Tipos de Serviço',
'Tipo(s) de Serviço Requerido(s)',
'dataArray.sysFunction.opeServiceType',
'ser_type_id',
'ser_type_label',
'opeServiceRecallItem',
'ser_recall_item_ser_type_id',
'uranux_homolog'
);
PERFORM _urx_utils_create_multiple_select(
42,
168,
440,
12,
3,
'Colaboradores Disponíveis',
'Colaboradores Alocados',
'dataArray.abiEmployee',
'per_id',
'per_nick_name',
'proActivityEmployee',
'act_emp_employee_id',
'uranux_homolog'
);
PERFORM _urx_utils_create_multiple_select(
62,
62,
440,
12,
3,
'Colaboradores Disponíveis',
'Membos',
'dataArray.sysFunction.abiEmployee',
'emp_id',
'per_nick_name',
'opeTeamItem',
'tea_item_employee_id',
'uranux_homolog'
);
SELECT _urx_utils_create_multiple_select(
159,
184,
450,
12,
2,
'Documentos Disponíveis',
'Documentos Aplicáveis',
'dataArray.sysFunction.opePreDoc',
'pre_doc_id',
'pre_doc_label',
'opeServiceTypeGroupPreDoc',
'ser_type_group_pre_doc_pre_doc_id',
'uranux_homolog'
);
|
| URX_PUBLIC._urx_utils_create_status_date_time_columns_and_triggers() | |
| URX_PUBLIC._urx_utils_date_add(_date date, _unit character varying, _qty integer) | |
| URX_PUBLIC._urx_utils_date_diff(_unit character varying, start_t timestamp without time zone, end_t timestamp without time zone) | How to Use PostgreSQL DATEDIFF Function\n\nThe syntax is similar to SQL Server DATEDIFF, but you have to specify a TIME unit (second, minute etc. and their abbreviations) as a string literal in PostgreSQL, for example:\n\n-- Difference between Dec 30, 2011 08:54:55 and Dec 30, 2011 08:56:10 in seconds\nSELECT DATEDIFF('second', '2011-12-30 08:54:55'::TIMESTAMP, '2011-12-30 08:56:10'::TIMESTAMP);\n-- Result: 75\n\nRef.: http://www.sqlines.com/"URX_PUBLIC"ql/how-to/datediff |
| URX_PUBLIC._urx_utils_day(date) | |
| URX_PUBLIC._urx_utils_decimal2varchar(_numeric numeric) | |
| URX_PUBLIC._urx_utils_delete_from_sys_person(_per_id integer) | Exclui registro de sys_person e seus dependentes. |
| URX_PUBLIC._urx_utils_drop_auto_vaccum() | |
| URX_PUBLIC._urx_utils_fin_invoice_set_commission(_ser_id integer) | Calcula os itens de comissão a serem pagos aos funcionários.
Deve ser executada quando o serviço for aprovado. |
| URX_PUBLIC._urx_utils_fin_invoice_unset_commission(_ser_id integer) | Exclui os itens de comissão previamente calculados.
Deve ser executada quando o serviço considerado aprovado retornar a condição de orçamento. |
| URX_PUBLIC._urx_utils_first_dow_of_month(date, integer) | _urx_utils_first_dow_of_month(date, integer) returns the first occurrence of a particular weekday in a given month.
The first argument supplies the month (as a date), and the second argument is the day of the week index as returned by extract('dow') |
| URX_PUBLIC._urx_utils_first_letter_uppercase(_input character varying) | Makes 'vERY goOD' become 'Very good' |
| URX_PUBLIC._urx_utils_hstore2url(_hstore hstore) | |
| URX_PUBLIC._urx_utils_hstore_key_exists(hstore, text) | Workaround for the fact that the question mark is a valid PostgreSQL operator, but PDO condsider it as a placeholder (there is a ticket to solve this bug). |
| URX_PUBLIC._urx_utils_is_date(_text character varying) | |
| URX_PUBLIC._urx_utils_kno_notice_explode_to_modules(_obj_id integer) | |
| URX_PUBLIC._urx_utils_last_day_in_month(_month integer, _year integer) | Retorna o último dia do mês e ano informados. |
| URX_PUBLIC._urx_utils_month(date) | |
| URX_PUBLIC._urx_utils_month(timestamp with time zone) | |
| URX_PUBLIC._urx_utils_month(timestamp without time zone) | |
| URX_PUBLIC._urx_utils_next_working_day(_date date, _state integer, _unit integer) | |
| URX_PUBLIC._urx_utils_nth_dow_of_month(date, integer, integer) | _urx_utils_nth_dow_of_month(date, integer, integer) returns the nth occurrence of a particular weekday in a given month.
The first argument supplies the month (as a date).
The second argument supplies the day of the week index as returned by extract('dow').
The third argument supplies the zero-based index of the desired occurrence,
e.g. 0 indicates the first occurrence and 1 indicates the second.
A negative index will count from the end of the month,
i.e., -1 is the last occurrence, -2 is the second to last 'occurrence.
No bounds checking is done to ensure that the returned date is within the 'specified month. |
| URX_PUBLIC._urx_utils_number_of_working_days(lowerdate date, higherdate date) | Retorna o número de dias úteis existentes no período compreendido entre duas datas. |
| URX_PUBLIC._urx_utils_ope_service_items_update(_ser_id integer) | |
| URX_PUBLIC._urx_utils_random_date(date) | |
| URX_PUBLIC._urx_utils_setup_audit() | |
| URX_PUBLIC._urx_utils_sys_object_clone(_obj_name character varying, _new_object_name character varying) | |
| URX_PUBLIC._urx_utils_sys_user_session_fix_all() | |
| URX_PUBLIC._urx_utils_timediff(units character varying, start_t time without time zone, end_t time without time zone) | How to Use PostgreSQL TIMEDIFF Function\n-- Difference between 08:54:55 and 08:56:10 in seconds\nSELECT DATEDIFF('second', '08:54:55'::TIME, '08:56:10'::TIME);\n-- Result: 75\n\nRef: http://www.sqlines.com/"URX_PUBLIC"ql/how-to/datediff |
| URX_PUBLIC._urx_utils_update_sequence(_sequence_name character varying, _table_name character varying, _column_name character varying) | |
| URX_PUBLIC._urx_utils_update_sequence(_sequence_name character varying, _table_name character varying, _column_name character varying, _min_value bigint) | |
| URX_PUBLIC._urx_utils_update_sequences() | |
| URX_PUBLIC._urx_utils_url_encode(in_str text) | |
| URX_PUBLIC._urx_utils_week(date) | |
| URX_PUBLIC._urx_utils_year(date) | |
| URX_PUBLIC._urx_validate_gtin13(_codigo_barra character varying) | |
| URX_PUBLIC.addauth(text) | args: auth_token - Add an authorization token to be used in current transaction. |
| URX_PUBLIC.addgeometrycolumn(catalog_name character varying, schema_name character varying, table_name character varying, column_name character varying, new_srid_in integer, new_type character varying, new_dim integer, use_typmod boolean) | args: catalog_name, schema_name, table_name, column_name, srid, type, dimension, use_typmod=true - Adds a geometry column to an existing table of attributes. By default uses type modifier to define rather than constraints. Pass in false for use_typmod to get old check constraint based behavior |
| URX_PUBLIC.addgeometrycolumn(schema_name character varying, table_name character varying, column_name character varying, new_srid integer, new_type character varying, new_dim integer, use_typmod boolean) | args: schema_name, table_name, column_name, srid, type, dimension, use_typmod=true - Adds a geometry column to an existing table of attributes. By default uses type modifier to define rather than constraints. Pass in false for use_typmod to get old check constraint based behavior |
| URX_PUBLIC.addgeometrycolumn(table_name character varying, column_name character varying, new_srid integer, new_type character varying, new_dim integer, use_typmod boolean) | args: table_name, column_name, srid, type, dimension, use_typmod=true - Adds a geometry column to an existing table of attributes. By default uses type modifier to define rather than constraints. Pass in false for use_typmod to get old check constraint based behavior |
| URX_PUBLIC.addoverviewconstraints(ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, ovfactor integer) | args: ovschema, ovtable, ovcolumn, refschema, reftable, refcolumn, ovfactor - Tag a raster column as being an overview of another. |
| URX_PUBLIC.addoverviewconstraints(ovtable name, ovcolumn name, reftable name, refcolumn name, ovfactor integer) | args: ovtable, ovcolumn, reftable, refcolumn, ovfactor - Tag a raster column as being an overview of another. |
| URX_PUBLIC.addrasterconstraints(rastschema name, rasttable name, rastcolumn name, constraints text[]) | args: rastschema, rasttable, rastcolumn, VARIADIC constraints - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice. |
| URX_PUBLIC.addrasterconstraints(rastschema name, rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, out_db boolean, extent boolean) | args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice. |
| URX_PUBLIC.addrasterconstraints(rasttable name, rastcolumn name, constraints text[]) | args: rasttable, rastcolumn, VARIADIC constraints - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice. |
| URX_PUBLIC.addrasterconstraints(rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, out_db boolean, extent boolean) | args: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice. |
| URX_PUBLIC.box(box3d) | |
| URX_PUBLIC.box(geometry) | |
| URX_PUBLIC.box2d(box3d) | |
| URX_PUBLIC.box2d(geometry) | args: geomA - Returns a BOX2D representing the maximum extents of the geometry. |
| URX_PUBLIC.box2d_in(cstring) | |
| URX_PUBLIC.box2d_out(box2d) | |
| URX_PUBLIC.box2df_in(cstring) | |
| URX_PUBLIC.box2df_out(box2df) | |
| URX_PUBLIC.box3d(box2d) | |
| URX_PUBLIC.box3d(geometry) | args: geomA - Returns a BOX3D representing the maximum extents of the geometry. |
| URX_PUBLIC.box3d(raster) | |
| URX_PUBLIC.box3d_in(cstring) | |
| URX_PUBLIC.box3d_out(box3d) | |
| URX_PUBLIC.box3dtobox(box3d) | |
| URX_PUBLIC.bytea(geography) | |
| URX_PUBLIC.bytea(geometry) | |
| URX_PUBLIC.bytea(raster) | |
| URX_PUBLIC.checkauth(text, text) | args: a_table_name, a_key_column_name - Creates trigger on a table to prevent/allow updates and deletes of rows based on authorization token. |
| URX_PUBLIC.checkauth(text, text, text) | args: a_schema_name, a_table_name, a_key_column_name - Creates trigger on a table to prevent/allow updates and deletes of rows based on authorization token. |
| URX_PUBLIC.checkauthtrigger() | |
| URX_PUBLIC.contains_2d(box2df, box2df) | |
| URX_PUBLIC.contains_2d(box2df, geometry) | |
| URX_PUBLIC.contains_2d(geometry, box2df) | |
| URX_PUBLIC.disablelongtransactions() | Disable long transaction support. This function removes the long transaction support metadata tables, and drops all triggers attached to lock-checked tables. |
| URX_PUBLIC.dropgeometrycolumn(catalog_name character varying, schema_name character varying, table_name character varying, column_name character varying) | args: catalog_name, schema_name, table_name, column_name - Removes a geometry column from a spatial table. |
| URX_PUBLIC.dropgeometrycolumn(schema_name character varying, table_name character varying, column_name character varying) | args: schema_name, table_name, column_name - Removes a geometry column from a spatial table. |
| URX_PUBLIC.dropgeometrycolumn(table_name character varying, column_name character varying) | args: table_name, column_name - Removes a geometry column from a spatial table. |
| URX_PUBLIC.dropgeometrytable(catalog_name character varying, schema_name character varying, table_name character varying) | args: catalog_name, schema_name, table_name - Drops a table and all its references in geometry_columns. |
| URX_PUBLIC.dropgeometrytable(schema_name character varying, table_name character varying) | args: schema_name, table_name - Drops a table and all its references in geometry_columns. |
| URX_PUBLIC.dropgeometrytable(table_name character varying) | args: table_name - Drops a table and all its references in geometry_columns. |
| URX_PUBLIC.dropoverviewconstraints(ovschema name, ovtable name, ovcolumn name) | args: ovschema, ovtable, ovcolumn - Untag a raster column from being an overview of another. |
| URX_PUBLIC.dropoverviewconstraints(ovtable name, ovcolumn name) | args: ovtable, ovcolumn - Untag a raster column from being an overview of another. |
| URX_PUBLIC.droprasterconstraints(rastschema name, rasttable name, rastcolumn name, constraints text[]) | args: rastschema, rasttable, rastcolumn, constraints - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data. |
| URX_PUBLIC.droprasterconstraints(rastschema name, rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, out_db boolean, extent boolean) | args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data. |
| URX_PUBLIC.droprasterconstraints(rasttable name, rastcolumn name, constraints text[]) | |
| URX_PUBLIC.droprasterconstraints(rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, out_db boolean, extent boolean) | args: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data. |
| URX_PUBLIC.enablelongtransactions() | Enable long transaction support. This function creates the required metadata tables, needs to be called once before using the other functions in this section. Calling it twice is harmless. |
| URX_PUBLIC.equals(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.find_srid(character varying, character varying, character varying) | args: a_schema_name, a_table_name, a_geomfield_name - The syntax is find_srid(a_db_schema, a_table, a_column) and the function returns the integer SRID of the specified column by searching through the GEOMETRY_COLUMNS table. |
| URX_PUBLIC.geog_brin_inclusion_add_value(internal, internal, internal, internal) | |
| URX_PUBLIC.geography(bytea) | |
| URX_PUBLIC.geography(geography, integer, boolean) | |
| URX_PUBLIC.geography(geometry) | |
| URX_PUBLIC.geography_analyze(internal) | |
| URX_PUBLIC.geography_cmp(geography, geography) | |
| URX_PUBLIC.geography_distance_knn(geography, geography) | |
| URX_PUBLIC.geography_eq(geography, geography) | |
| URX_PUBLIC.geography_ge(geography, geography) | |
| URX_PUBLIC.geography_gist_compress(internal) | |
| URX_PUBLIC.geography_gist_consistent(internal, geography, integer) | |
| URX_PUBLIC.geography_gist_decompress(internal) | |
| URX_PUBLIC.geography_gist_distance(internal, geography, integer) | |
| URX_PUBLIC.geography_gist_penalty(internal, internal, internal) | |
| URX_PUBLIC.geography_gist_picksplit(internal, internal) | |
| URX_PUBLIC.geography_gist_same(box2d, box2d, internal) | |
| URX_PUBLIC.geography_gist_union(bytea, internal) | |
| URX_PUBLIC.geography_gt(geography, geography) | |
| URX_PUBLIC.geography_in(cstring, oid, integer) | |
| URX_PUBLIC.geography_le(geography, geography) | |
| URX_PUBLIC.geography_lt(geography, geography) | |
| URX_PUBLIC.geography_out(geography) | |
| URX_PUBLIC.geography_overlaps(geography, geography) | |
| URX_PUBLIC.geography_recv(internal, oid, integer) | |
| URX_PUBLIC.geography_send(geography) | |
| URX_PUBLIC.geography_typmod_in(cstring[]) | |
| URX_PUBLIC.geography_typmod_out(integer) | |
| URX_PUBLIC.geom2d_brin_inclusion_add_value(internal, internal, internal, internal) | |
| URX_PUBLIC.geom3d_brin_inclusion_add_value(internal, internal, internal, internal) | |
| URX_PUBLIC.geom4d_brin_inclusion_add_value(internal, internal, internal, internal) | |
| URX_PUBLIC.geometry(box2d) | |
| URX_PUBLIC.geometry(box3d) | |
| URX_PUBLIC.geometry(bytea) | |
| URX_PUBLIC.geometry(geography) | |
| URX_PUBLIC.geometry(geometry, integer, boolean) | |
| URX_PUBLIC.geometry(path) | |
| URX_PUBLIC.geometry(point) | |
| URX_PUBLIC.geometry(polygon) | |
| URX_PUBLIC.geometry(text) | |
| URX_PUBLIC.geometry_above(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_analyze(internal) | |
| URX_PUBLIC.geometry_below(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_cmp(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_contained_by_raster(geometry, raster) | |
| URX_PUBLIC.geometry_contains(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_distance_box(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_distance_centroid(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_distance_centroid_nd(geometry, geometry) | |
| URX_PUBLIC.geometry_distance_cpa(geometry, geometry) | |
| URX_PUBLIC.geometry_eq(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_ge(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_gist_compress_2d(internal) | |
| URX_PUBLIC.geometry_gist_compress_nd(internal) | |
| URX_PUBLIC.geometry_gist_consistent_2d(internal, geometry, integer) | |
| URX_PUBLIC.geometry_gist_consistent_nd(internal, geometry, integer) | |
| URX_PUBLIC.geometry_gist_decompress_2d(internal) | |
| URX_PUBLIC.geometry_gist_decompress_nd(internal) | |
| URX_PUBLIC.geometry_gist_distance_2d(internal, geometry, integer) | |
| URX_PUBLIC.geometry_gist_distance_nd(internal, geometry, integer) | |
| URX_PUBLIC.geometry_gist_penalty_2d(internal, internal, internal) | |
| URX_PUBLIC.geometry_gist_penalty_nd(internal, internal, internal) | |
| URX_PUBLIC.geometry_gist_picksplit_2d(internal, internal) | |
| URX_PUBLIC.geometry_gist_picksplit_nd(internal, internal) | |
| URX_PUBLIC.geometry_gist_same_2d(geom1 geometry, geom2 geometry, internal) | |
| URX_PUBLIC.geometry_gist_same_nd(geometry, geometry, internal) | |
| URX_PUBLIC.geometry_gist_union_2d(bytea, internal) | |
| URX_PUBLIC.geometry_gist_union_nd(bytea, internal) | |
| URX_PUBLIC.geometry_gt(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_in(cstring) | |
| URX_PUBLIC.geometry_le(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_left(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_lt(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_out(geometry) | |
| URX_PUBLIC.geometry_overabove(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_overbelow(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_overlaps(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_overlaps_nd(geometry, geometry) | |
| URX_PUBLIC.geometry_overleft(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_overright(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_raster_contain(geometry, raster) | |
| URX_PUBLIC.geometry_raster_overlap(geometry, raster) | |
| URX_PUBLIC.geometry_recv(internal) | |
| URX_PUBLIC.geometry_right(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_same(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometry_send(geometry) | |
| URX_PUBLIC.geometry_typmod_in(cstring[]) | |
| URX_PUBLIC.geometry_typmod_out(integer) | |
| URX_PUBLIC.geometry_within(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.geometrytype(geography) | |
| URX_PUBLIC.geometrytype(geometry) | args: geomA - Returns the type of the geometry as a string. Eg: LINESTRING, POLYGON, MULTIPOINT, etc. |
| URX_PUBLIC.geomfromewkb(bytea) | |
| URX_PUBLIC.geomfromewkt(text) | |
| URX_PUBLIC.get_proj4_from_srid(integer) | |
| URX_PUBLIC.gettransactionid() | |
| URX_PUBLIC.gidx_in(cstring) | |
| URX_PUBLIC.gidx_out(gidx) | |
| URX_PUBLIC.gserialized_gist_joinsel_2d(internal, oid, internal, smallint) | |
| URX_PUBLIC.gserialized_gist_joinsel_nd(internal, oid, internal, smallint) | |
| URX_PUBLIC.gserialized_gist_sel_2d(internal, oid, internal, integer) | |
| URX_PUBLIC.gserialized_gist_sel_nd(internal, oid, internal, integer) | |
| URX_PUBLIC.is_contained_2d(box2df, box2df) | |
| URX_PUBLIC.is_contained_2d(box2df, geometry) | |
| URX_PUBLIC.is_contained_2d(geometry, box2df) | |
| URX_PUBLIC.lockrow(text, text, text) | args: a_table_name, a_row_key, an_auth_token - Set lock/authorization for specific row in table |
| URX_PUBLIC.lockrow(text, text, text, text) | |
| URX_PUBLIC.lockrow(text, text, text, text, timestamp without time zone) | args: a_schema_name, a_table_name, a_row_key, an_auth_token, expire_dt - Set lock/authorization for specific row in table |
| URX_PUBLIC.lockrow(text, text, text, timestamp without time zone) | args: a_table_name, a_row_key, an_auth_token, expire_dt - Set lock/authorization for specific row in table |
| URX_PUBLIC.longtransactionsenabled() | |
| URX_PUBLIC.overlaps_2d(box2df, box2df) | |
| URX_PUBLIC.overlaps_2d(box2df, geometry) | |
| URX_PUBLIC.overlaps_2d(geometry, box2df) | |
| URX_PUBLIC.overlaps_geog(geography, gidx) | |
| URX_PUBLIC.overlaps_geog(gidx, geography) | |
| URX_PUBLIC.overlaps_geog(gidx, gidx) | |
| URX_PUBLIC.overlaps_nd(geometry, gidx) | |
| URX_PUBLIC.overlaps_nd(gidx, geometry) | |
| URX_PUBLIC.overlaps_nd(gidx, gidx) | |
| URX_PUBLIC.path(geometry) | |
| URX_PUBLIC.point(geometry) | |
| URX_PUBLIC.polygon(geometry) | |
| URX_PUBLIC.populate_geometry_columns(tbl_oid oid, use_typmod boolean) | args: relation_oid, use_typmod=true - Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints This ensures they will be registered correctly in geometry_columns view. By default will convert all geometry columns with no type modifier to ones with type modifiers. To get old behavior set use_typmod=false |
| URX_PUBLIC.populate_geometry_columns(use_typmod boolean) | args: use_typmod=true - Ensures geometry columns are defined with type modifiers or have appropriate spatial constraints This ensures they will be registered correctly in geometry_columns view. By default will convert all geometry columns with no type modifier to ones with type modifiers. To get old behavior set use_typmod=false |
| URX_PUBLIC.postgis_addbbox(geometry) | args: geomA - Add bounding box to the geometry. |
| URX_PUBLIC.postgis_cache_bbox() | |
| URX_PUBLIC.postgis_constraint_dims(geomschema text, geomtable text, geomcolumn text) | |
| URX_PUBLIC.postgis_constraint_srid(geomschema text, geomtable text, geomcolumn text) | |
| URX_PUBLIC.postgis_constraint_type(geomschema text, geomtable text, geomcolumn text) | |
| URX_PUBLIC.postgis_dropbbox(geometry) | args: geomA - Drop the bounding box cache from the geometry. |
| URX_PUBLIC.postgis_full_version() | Reports full postgis version and build configuration infos. |
| URX_PUBLIC.postgis_gdal_version() | Reports the version of the GDAL library in use by PostGIS. |
| URX_PUBLIC.postgis_geos_version() | Returns the version number of the GEOS library. |
| URX_PUBLIC.postgis_getbbox(geometry) | |
| URX_PUBLIC.postgis_hasbbox(geometry) | args: geomA - Returns TRUE if the bbox of this geometry is cached, FALSE otherwise. |
| URX_PUBLIC.postgis_lib_build_date() | Returns build date of the PostGIS library. |
| URX_PUBLIC.postgis_lib_version() | Returns the version number of the PostGIS library. |
| URX_PUBLIC.postgis_libjson_version() | |
| URX_PUBLIC.postgis_liblwgeom_version() | Returns the version number of the liblwgeom library. This should match the version of PostGIS. |
| URX_PUBLIC.postgis_libprotobuf_version() | |
| URX_PUBLIC.postgis_libxml_version() | Returns the version number of the libxml2 library. |
| URX_PUBLIC.postgis_noop(geometry) | |
| URX_PUBLIC.postgis_noop(raster) | |
| URX_PUBLIC.postgis_proj_version() | Returns the version number of the PROJ4 library. |
| URX_PUBLIC.postgis_raster_lib_build_date() | Reports full raster library build date. |
| URX_PUBLIC.postgis_raster_lib_version() | Reports full raster version and build configuration infos. |
| URX_PUBLIC.postgis_raster_scripts_installed() | |
| URX_PUBLIC.postgis_scripts_build_date() | Returns build date of the PostGIS scripts. |
| URX_PUBLIC.postgis_scripts_installed() | Returns version of the postgis scripts installed in this database. |
| URX_PUBLIC.postgis_scripts_released() | Returns the version number of the postgis.sql script released with the installed postgis lib. |
| URX_PUBLIC.postgis_svn_version() | |
| URX_PUBLIC.postgis_transform_geometry(geometry, text, text, integer) | |
| URX_PUBLIC.postgis_type_name(geomname character varying, coord_dimension integer, use_new_name boolean) | |
| URX_PUBLIC.postgis_typmod_dims(integer) | |
| URX_PUBLIC.postgis_typmod_srid(integer) | |
| URX_PUBLIC.postgis_typmod_type(integer) | |
| URX_PUBLIC.postgis_version() | Returns PostGIS version number and compile-time options. |
| URX_PUBLIC.raster_above(raster, raster) | |
| URX_PUBLIC.raster_below(raster, raster) | |
| URX_PUBLIC.raster_contain(raster, raster) | |
| URX_PUBLIC.raster_contained(raster, raster) | |
| URX_PUBLIC.raster_contained_by_geometry(raster, geometry) | |
| URX_PUBLIC.raster_eq(raster, raster) | |
| URX_PUBLIC.raster_geometry_contain(raster, geometry) | |
| URX_PUBLIC.raster_geometry_overlap(raster, geometry) | |
| URX_PUBLIC.raster_hash(raster) | |
| URX_PUBLIC.raster_in(cstring) | |
| URX_PUBLIC.raster_left(raster, raster) | |
| URX_PUBLIC.raster_out(raster) | |
| URX_PUBLIC.raster_overabove(raster, raster) | |
| URX_PUBLIC.raster_overbelow(raster, raster) | |
| URX_PUBLIC.raster_overlap(raster, raster) | |
| URX_PUBLIC.raster_overleft(raster, raster) | |
| URX_PUBLIC.raster_overright(raster, raster) | |
| URX_PUBLIC.raster_right(raster, raster) | |
| URX_PUBLIC.raster_same(raster, raster) | |
| URX_PUBLIC.spheroid_in(cstring) | |
| URX_PUBLIC.spheroid_out(spheroid) | |
| URX_PUBLIC.st_3dclosestpoint(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 3-dimensional point on g1 that is closest to g2. This is the first point of the 3D shortest line. |
| URX_PUBLIC.st_3ddfullywithin(geom1 geometry, geom2 geometry, double precision) | args: g1, g2, distance - Returns true if all of the 3D geometries are within the specified distance of one another. |
| URX_PUBLIC.st_3ddistance(geom1 geometry, geom2 geometry) | args: g1, g2 - For geometry type Returns the 3-dimensional cartesian minimum distance (based on spatial ref) between two geometries in projected units. |
| URX_PUBLIC.st_3ddwithin(geom1 geometry, geom2 geometry, double precision) | args: g1, g2, distance_of_srid - For 3d (z) geometry type Returns true if two geometries 3d distance is within number of units. |
| URX_PUBLIC.st_3dextent(geometry) | args: geomfield - an aggregate function that returns the box3D bounding box that bounds rows of geometries. |
| URX_PUBLIC.st_3dintersects(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns TRUE if the Geometries "spatially intersect" in 3d - only for points, linestrings, polygons, polyhedral surface (area). With SFCGAL backend enabled also supports TINS |
| URX_PUBLIC.st_3dlength(geometry) | args: a_3dlinestring - Returns the 3-dimensional or 2-dimensional length of the geometry if it is a linestring or multi-linestring. |
| URX_PUBLIC.st_3dlength_spheroid(geometry, spheroid) | |
| URX_PUBLIC.st_3dlongestline(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 3-dimensional longest line between two geometries |
| URX_PUBLIC.st_3dmakebox(geom1 geometry, geom2 geometry) | args: point3DLowLeftBottom, point3DUpRightTop - Creates a BOX3D defined by the given 3d point geometries. |
| URX_PUBLIC.st_3dmaxdistance(geom1 geometry, geom2 geometry) | args: g1, g2 - For geometry type Returns the 3-dimensional cartesian maximum distance (based on spatial ref) between two geometries in projected units. |
| URX_PUBLIC.st_3dperimeter(geometry) | args: geomA - Returns the 3-dimensional perimeter of the geometry, if it is a polygon or multi-polygon. |
| URX_PUBLIC.st_3dshortestline(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 3-dimensional shortest line between two geometries |
| URX_PUBLIC.st_accum(geometry) | args: geomfield - Aggregate. Constructs an array of geometries. |
| URX_PUBLIC.st_addband(rast raster, addbandargset addbandarg[]) | args: rast, addbandargset - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addband(rast raster, index integer, outdbfile text, outdbindex integer[], nodataval double precision) | args: rast, index, outdbfile, outdbindex, nodataval=NULL - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addband(rast raster, index integer, pixeltype text, initialvalue double precision, nodataval double precision) | args: rast, index, pixeltype, initialvalue=0, nodataval=NULL - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addband(rast raster, outdbfile text, outdbindex integer[], index integer, nodataval double precision) | args: rast, outdbfile, outdbindex, index=at_end, nodataval=NULL - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addband(rast raster, pixeltype text, initialvalue double precision, nodataval double precision) | args: rast, pixeltype, initialvalue=0, nodataval=NULL - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addband(torast raster, fromrast raster, fromband integer, torastindex integer) | args: torast, fromrast, fromband=1, torastindex=at_end - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addband(torast raster, fromrasts raster[], fromband integer, torastindex integer) | args: torast, fromrasts, fromband=1, torastindex=at_end - Returns a raster with the new band(s) of given type added with given initial value in the given index location. If no index is specified, the band is added to the end. |
| URX_PUBLIC.st_addmeasure(geometry, double precision, double precision) | args: geom_mline, measure_start, measure_end - Return a derived geometry with measure elements linearly interpolated between the start and end points. |
| URX_PUBLIC.st_addpoint(geom1 geometry, geom2 geometry) | args: linestring, point - Add a point to a LineString. |
| URX_PUBLIC.st_addpoint(geom1 geometry, geom2 geometry, integer) | args: linestring, point, position - Add a point to a LineString. |
| URX_PUBLIC.st_affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision) | args: geomA, a, b, d, e, xoff, yoff - Apply a 3d affine transformation to a geometry. |
| URX_PUBLIC.st_affine(geometry, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision, double precision) | args: geomA, a, b, c, d, e, f, g, h, i, xoff, yoff, zoff - Apply a 3d affine transformation to a geometry. |
| URX_PUBLIC.st_approxcount(rast raster, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rast raster, nband integer, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rast raster, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rastertable text, rastercolumn text, nband integer, sample_percent double precision) | |
| URX_PUBLIC.st_approxcount(rastertable text, rastercolumn text, sample_percent double precision) | |
| URX_PUBLIC.st_approxhistogram(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, right boolean) | |
| URX_PUBLIC.st_approxhistogram(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], right boolean) | |
| URX_PUBLIC.st_approxhistogram(rast raster, nband integer, sample_percent double precision) | |
| URX_PUBLIC.st_approxhistogram(rast raster, nband integer, sample_percent double precision, bins integer, right boolean) | |
| URX_PUBLIC.st_approxhistogram(rast raster, nband integer, sample_percent double precision, bins integer, width double precision[], right boolean) | |
| URX_PUBLIC.st_approxhistogram(rast raster, sample_percent double precision) | |
| URX_PUBLIC.st_approxhistogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, right boolean) | |
| URX_PUBLIC.st_approxhistogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], right boolean) | |
| URX_PUBLIC.st_approxhistogram(rastertable text, rastercolumn text, nband integer, sample_percent double precision) | |
| URX_PUBLIC.st_approxhistogram(rastertable text, rastercolumn text, nband integer, sample_percent double precision, bins integer, right boolean) | |
| URX_PUBLIC.st_approxhistogram(rastertable text, rastercolumn text, nband integer, sample_percent double precision, bins integer, width double precision[], right boolean) | |
| URX_PUBLIC.st_approxhistogram(rastertable text, rastercolumn text, sample_percent double precision) | |
| URX_PUBLIC.st_approxquantile(rast raster, exclude_nodata_value boolean, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rast raster, nband integer, sample_percent double precision, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rast raster, nband integer, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rast raster, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rast raster, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rast raster, sample_percent double precision, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rast raster, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, exclude_nodata_value boolean, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, nband integer, sample_percent double precision, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, nband integer, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, quantiles double precision[]) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, sample_percent double precision, quantile double precision) | |
| URX_PUBLIC.st_approxquantile(rastertable text, rastercolumn text, sample_percent double precision, quantiles double precision[]) | |
| URX_PUBLIC.st_approxsummarystats(rast raster, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxsummarystats(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxsummarystats(rast raster, nband integer, sample_percent double precision) | |
| URX_PUBLIC.st_approxsummarystats(rast raster, sample_percent double precision) | |
| URX_PUBLIC.st_approxsummarystats(rastertable text, rastercolumn text, exclude_nodata_value boolean) | |
| URX_PUBLIC.st_approxsummarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision) | |
| URX_PUBLIC.st_approxsummarystats(rastertable text, rastercolumn text, nband integer, sample_percent double precision) | |
| URX_PUBLIC.st_approxsummarystats(rastertable text, rastercolumn text, sample_percent double precision) | |
| URX_PUBLIC.st_area(geog geography, use_spheroid boolean) | args: geog, use_spheroid=true - Returns the area of the surface if it is a Polygon or MultiPolygon. For geometry, a 2D Cartesian area is determined with units specified by the SRID. For geography, area is determined on a curved surface with units in square meters. |
| URX_PUBLIC.st_area(geometry) | args: g1 - Returns the area of the surface if it is a Polygon or MultiPolygon. For geometry, a 2D Cartesian area is determined with units specified by the SRID. For geography, area is determined on a curved surface with units in square meters. |
| URX_PUBLIC.st_area(text) | |
| URX_PUBLIC.st_area2d(geometry) | |
| URX_PUBLIC.st_asbinary( raster, outasin boolean) | args: rast, outasin=FALSE - Return the Well-Known Binary (WKB) representation of the raster. |
| URX_PUBLIC.st_asbinary(geography) | args: g1 - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data. |
| URX_PUBLIC.st_asbinary(geography, text) | args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data. |
| URX_PUBLIC.st_asbinary(geometry) | args: g1 - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data. |
| URX_PUBLIC.st_asbinary(geometry, text) | args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry/geography without SRID meta data. |
| URX_PUBLIC.st_asencodedpolyline(geom geometry, integer) | args: geom, precision=5 - Returns an Encoded Polyline from a LineString geometry. |
| URX_PUBLIC.st_asewkb(geometry) | args: g1 - Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data. |
| URX_PUBLIC.st_asewkb(geometry, text) | args: g1, NDR_or_XDR - Return the Well-Known Binary (WKB) representation of the geometry with SRID meta data. |
| URX_PUBLIC.st_asewkt(geography) | args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data. |
| URX_PUBLIC.st_asewkt(geometry) | args: g1 - Return the Well-Known Text (WKT) representation of the geometry with SRID meta data. |
| URX_PUBLIC.st_asewkt(text) | |
| URX_PUBLIC.st_asgdalraster(rast raster, format text, options text[], srid integer) | args: rast, format, options=NULL, srid=sameassource - Return the raster tile in the designated GDAL Raster format. Raster formats are one of those supported by your compiled library. Use ST_GDALDrivers() to get a list of formats supported by your library. |
| URX_PUBLIC.st_asgeobuf(anyelement) | args: row - Return a Geobuf representation of a set of rows. |
| URX_PUBLIC.st_asgeobuf(anyelement, text) | args: row, geom_name - Return a Geobuf representation of a set of rows. |
| URX_PUBLIC.st_asgeojson(geog geography, maxdecimaldigits integer, options integer) | args: geog, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element. |
| URX_PUBLIC.st_asgeojson(geom geometry, maxdecimaldigits integer, options integer) | args: geom, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element. |
| URX_PUBLIC.st_asgeojson(gj_version integer, geog geography, maxdecimaldigits integer, options integer) | args: gj_version, geog, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element. |
| URX_PUBLIC.st_asgeojson(gj_version integer, geom geometry, maxdecimaldigits integer, options integer) | args: gj_version, geom, maxdecimaldigits=15, options=0 - Return the geometry as a GeoJSON element. |
| URX_PUBLIC.st_asgeojson(text) | |
| URX_PUBLIC.st_asgml(geog geography, maxdecimaldigits integer, options integer) | args: geog, maxdecimaldigits=15, options=0 - Return the geometry as a GML version 2 or 3 element. |
| URX_PUBLIC.st_asgml(geom geometry, maxdecimaldigits integer, options integer) | args: geom, maxdecimaldigits=15, options=0 - Return the geometry as a GML version 2 or 3 element. |
| URX_PUBLIC.st_asgml(text) | |
| URX_PUBLIC.st_asgml(version integer, geog geography, maxdecimaldigits integer, options integer, nprefix text, id text) | args: version, geog, maxdecimaldigits=15, options=0, nprefix=null, id=null - Return the geometry as a GML version 2 or 3 element. |
| URX_PUBLIC.st_asgml(version integer, geom geometry, maxdecimaldigits integer, options integer, nprefix text, id text) | args: version, geom, maxdecimaldigits=15, options=0, nprefix=null, id=null - Return the geometry as a GML version 2 or 3 element. |
| URX_PUBLIC.st_ashexewkb(geometry) | args: g1 - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding. |
| URX_PUBLIC.st_ashexewkb(geometry, text) | args: g1, NDRorXDR - Returns a Geometry in HEXEWKB format (as text) using either little-endian (NDR) or big-endian (XDR) encoding. |
| URX_PUBLIC.st_asjpeg(rast raster, nband integer, options text[]) | args: rast, nband, options=NULL - Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB. |
| URX_PUBLIC.st_asjpeg(rast raster, nband integer, quality integer) | args: rast, nband, quality - Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB. |
| URX_PUBLIC.st_asjpeg(rast raster, nbands integer[], options text[]) | args: rast, nbands, options=NULL - Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB. |
| URX_PUBLIC.st_asjpeg(rast raster, nbands integer[], quality integer) | args: rast, nbands, quality - Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB. |
| URX_PUBLIC.st_asjpeg(rast raster, options text[]) | args: rast, options=NULL - Return the raster tile selected bands as a single Joint Photographic Exports Group (JPEG) image (byte array). If no band is specified and 1 or more than 3 bands, then only the first band is used. If only 3 bands then all 3 bands are used and mapped to RGB. |
| URX_PUBLIC.st_askml(geog geography, maxdecimaldigits integer) | args: geog, maxdecimaldigits=15 - Return the geometry as a KML element. Several variants. Default version=2, default precision=15 |
| URX_PUBLIC.st_askml(geom geometry, maxdecimaldigits integer) | args: geom, maxdecimaldigits=15 - Return the geometry as a KML element. Several variants. Default version=2, default precision=15 |
| URX_PUBLIC.st_askml(text) | |
| URX_PUBLIC.st_askml(version integer, geog geography, maxdecimaldigits integer, nprefix text) | args: version, geog, maxdecimaldigits=15, nprefix=NULL - Return the geometry as a KML element. Several variants. Default version=2, default precision=15 |
| URX_PUBLIC.st_askml(version integer, geom geometry, maxdecimaldigits integer, nprefix text) | args: version, geom, maxdecimaldigits=15, nprefix=NULL - Return the geometry as a KML element. Several variants. Default version=2, default precision=15 |
| URX_PUBLIC.st_aslatlontext(geom geometry, tmpl text) | args: pt, format=' - Return the Degrees, Minutes, Seconds representation of the given point. |
| URX_PUBLIC.st_asmvt(anyelement) | args: row - Return a Mapbox Vector Tile representation of a set of rows. |
| URX_PUBLIC.st_asmvt(anyelement, text) | args: row, name - Return a Mapbox Vector Tile representation of a set of rows. |
| URX_PUBLIC.st_asmvt(anyelement, text, integer) | args: row, name, extent - Return a Mapbox Vector Tile representation of a set of rows. |
| URX_PUBLIC.st_asmvt(anyelement, text, integer, text) | args: row, name, extent, geom_name - Return a Mapbox Vector Tile representation of a set of rows. |
| URX_PUBLIC.st_asmvtgeom(geom geometry, bounds box2d, extent integer, buffer integer, clip_geom boolean) | args: geom, bounds, extent=4096, buffer=256, clip_geom=true - Transform a geometry into the coordinate space of a Mapbox Vector Tile. |
| URX_PUBLIC.st_aspect(rast raster, nband integer, customextent raster, pixeltype text, units text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_aspect(rast raster, nband integer, pixeltype text, units text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_aspng(rast raster, nband integer, compression integer) | args: rast, nband, compression - Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1, 3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space. |
| URX_PUBLIC.st_aspng(rast raster, nband integer, options text[]) | args: rast, nband, options=NULL - Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1, 3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space. |
| URX_PUBLIC.st_aspng(rast raster, nbands integer[], compression integer) | args: rast, nbands, compression - Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1, 3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space. |
| URX_PUBLIC.st_aspng(rast raster, nbands integer[], options text[]) | args: rast, nbands, options=NULL - Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1, 3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space. |
| URX_PUBLIC.st_aspng(rast raster, options text[]) | args: rast, options=NULL - Return the raster tile selected bands as a single portable network graphics (PNG) image (byte array). If 1, 3, or 4 bands in raster and no bands are specified, then all bands are used. If more 2 or more than 4 bands and no bands specified, then only band 1 is used. Bands are mapped to RGB or RGBA space. |
| URX_PUBLIC.st_asraster(geom geometry, ref raster, pixeltype text, value double precision, nodataval double precision, touched boolean) | args: geom, ref, pixeltype, value=1, nodataval=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, ref raster, pixeltype text[], value double precision[], nodataval double precision[], touched boolean) | args: geom, ref, pixeltype=ARRAY['8BUI'], value=ARRAY[1], nodataval=ARRAY[0], touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, scalex double precision, scaley double precision, gridx double precision, gridy double precision, pixeltype text, value double precision, nodataval double precision, skewx double precision, skewy double precision, touched boolean) | args: geom, scalex, scaley, gridx, gridy, pixeltype, value=1, nodataval=0, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, scalex double precision, scaley double precision, gridx double precision, gridy double precision, pixeltype text[], value double precision[], nodataval double precision[], skewx double precision, skewy double precision, touched boolean) | args: geom, scalex, scaley, gridx=NULL, gridy=NULL, pixeltype=ARRAY['8BUI'], value=ARRAY[1], nodataval=ARRAY[0], skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, scalex double precision, scaley double precision, pixeltype text, value double precision, nodataval double precision, upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean) | args: geom, scalex, scaley, pixeltype, value=1, nodataval=0, upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, scalex double precision, scaley double precision, pixeltype text[], value double precision[], nodataval double precision[], upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean) | args: geom, scalex, scaley, pixeltype, value=ARRAY[1], nodataval=ARRAY[0], upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, width integer, height integer, gridx double precision, gridy double precision, pixeltype text, value double precision, nodataval double precision, skewx double precision, skewy double precision, touched boolean) | args: geom, width, height, gridx, gridy, pixeltype, value=1, nodataval=0, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, width integer, height integer, gridx double precision, gridy double precision, pixeltype text[], value double precision[], nodataval double precision[], skewx double precision, skewy double precision, touched boolean) | args: geom, width, height, gridx=NULL, gridy=NULL, pixeltype=ARRAY['8BUI'], value=ARRAY[1], nodataval=ARRAY[0], skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, width integer, height integer, pixeltype text, value double precision, nodataval double precision, upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean) | args: geom, width, height, pixeltype, value=1, nodataval=0, upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_asraster(geom geometry, width integer, height integer, pixeltype text[], value double precision[], nodataval double precision[], upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean) | args: geom, width, height, pixeltype, value=ARRAY[1], nodataval=ARRAY[0], upperleftx=NULL, upperlefty=NULL, skewx=0, skewy=0, touched=false - Converts a PostGIS geometry to a PostGIS raster. |
| URX_PUBLIC.st_assvg(geog geography, rel integer, maxdecimaldigits integer) | args: geog, rel=0, maxdecimaldigits=15 - Returns a Geometry in SVG path data given a geometry or geography object. |
| URX_PUBLIC.st_assvg(geom geometry, rel integer, maxdecimaldigits integer) | args: geom, rel=0, maxdecimaldigits=15 - Returns a Geometry in SVG path data given a geometry or geography object. |
| URX_PUBLIC.st_assvg(text) | |
| URX_PUBLIC.st_astext(geography) | args: g1 - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata. |
| URX_PUBLIC.st_astext(geometry) | args: g1 - Return the Well-Known Text (WKT) representation of the geometry/geography without SRID metadata. |
| URX_PUBLIC.st_astext(text) | |
| URX_PUBLIC.st_astiff(rast raster, compression text, srid integer) | args: rast, compression=', srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands. |
| URX_PUBLIC.st_astiff(rast raster, nbands integer[], compression text, srid integer) | args: rast, nbands, compression=', srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands. |
| URX_PUBLIC.st_astiff(rast raster, nbands integer[], options text[], srid integer) | args: rast, nbands, options, srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands. |
| URX_PUBLIC.st_astiff(rast raster, options text[], srid integer) | args: rast, options=', srid=sameassource - Return the raster selected bands as a single TIFF image (byte array). If no band is specified, then will try to use all bands. |
| URX_PUBLIC.st_astwkb(geom geometry, prec integer, prec_z integer, prec_m integer, with_sizes boolean, with_boxes boolean) | args: g1, decimaldigits_xy=0, decimaldigits_z=0, decimaldigits_m=0, include_sizes=false, include_bounding boxes=false - Returns the geometry as TWKB, aka "Tiny Well-Known Binary" |
| URX_PUBLIC.st_astwkb(geom geometry[], ids bigint[], prec integer, prec_z integer, prec_m integer, with_sizes boolean, with_boxes boolean) | args: geometries, unique_ids, decimaldigits_xy=0, decimaldigits_z=0, decimaldigits_m=0, include_sizes=false, include_bounding_boxes=false - Returns the geometry as TWKB, aka "Tiny Well-Known Binary" |
| URX_PUBLIC.st_asx3d(geom geometry, maxdecimaldigits integer, options integer) | args: g1, maxdecimaldigits=15, options=0 - Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-X3DEncodings-XML |
| URX_PUBLIC.st_azimuth(geog1 geography, geog2 geography) | args: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB. |
| URX_PUBLIC.st_azimuth(geom1 geometry, geom2 geometry) | args: pointA, pointB - Returns the north-based azimuth as the angle in radians measured clockwise from the vertical on pointA to pointB. |
| URX_PUBLIC.st_band(rast raster, nband integer) | args: rast, nband - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters. |
| URX_PUBLIC.st_band(rast raster, nbands integer[]) | args: rast, nbands = ARRAY[1] - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters. |
| URX_PUBLIC.st_band(rast raster, nbands text, delimiter character) | args: rast, nbands, delimiter=, - Returns one or more bands of an existing raster as a new raster. Useful for building new rasters from existing rasters. |
| URX_PUBLIC.st_bandisnodata(rast raster, band integer, forcechecking boolean) | args: rast, band, forceChecking=true - Returns true if the band is filled with only nodata values. |
| URX_PUBLIC.st_bandisnodata(rast raster, forcechecking boolean) | args: rast, forceChecking=true - Returns true if the band is filled with only nodata values. |
| URX_PUBLIC.st_bandmetadata(rast raster, band integer) | args: rast, bandnum=1 - Returns basic meta data for a specific raster band. band num 1 is assumed if none-specified. |
| URX_PUBLIC.st_bandmetadata(rast raster, band integer[]) | |
| URX_PUBLIC.st_bandnodatavalue(rast raster, band integer) | args: rast, bandnum=1 - Returns the value in a given band that represents no data. If no band num 1 is assumed. |
| URX_PUBLIC.st_bandpath(rast raster, band integer) | args: rast, bandnum=1 - Returns system file path to a band stored in file system. If no bandnum specified, 1 is assumed. |
| URX_PUBLIC.st_bandpixeltype(rast raster, band integer) | args: rast, bandnum=1 - Returns the type of pixel for given band. If no bandnum specified, 1 is assumed. |
| URX_PUBLIC.st_bdmpolyfromtext(text, integer) | args: WKT, srid - Construct a MultiPolygon given an arbitrary collection of closed linestrings as a MultiLineString text representation Well-Known text representation. |
| URX_PUBLIC.st_bdpolyfromtext(text, integer) | args: WKT, srid - Construct a Polygon given an arbitrary collection of closed linestrings as a MultiLineString Well-Known text representation. |
| URX_PUBLIC.st_boundary(geometry) | args: geomA - Returns the closure of the combinatorial boundary of this Geometry. |
| URX_PUBLIC.st_boundingdiagonal(geom geometry, fits boolean) | args: geom, fits=false - Returns the diagonal of the supplied geometrys bounding box. |
| URX_PUBLIC.st_box2dfromgeohash(text, integer) | args: geohash, precision=full_precision_of_geohash - Return a BOX2D from a GeoHash string. |
| URX_PUBLIC.st_buffer(geography, double precision) | args: g1, radius_of_buffer_in_meters - (T)Returns a geometry covering all points within a given distancefrom the input geometry. |
| URX_PUBLIC.st_buffer(geography, double precision, integer) | args: g1, radius_of_buffer, num_seg_quarter_circle - (T)Returns a geometry covering all points within a given distancefrom the input geometry. |
| URX_PUBLIC.st_buffer(geography, double precision, text) | args: g1, radius_of_buffer, buffer_style_parameters - (T)Returns a geometry covering all points within a given distancefrom the input geometry. |
| URX_PUBLIC.st_buffer(geometry, double precision) | args: g1, radius_of_buffer - (T)Returns a geometry covering all points within a given distancefrom the input geometry. |
| URX_PUBLIC.st_buffer(geometry, double precision, integer) | args: g1, radius_of_buffer, num_seg_quarter_circle - (T)Returns a geometry covering all points within a given distancefrom the input geometry. |
| URX_PUBLIC.st_buffer(geometry, double precision, text) | args: g1, radius_of_buffer, buffer_style_parameters - (T)Returns a geometry covering all points within a given distancefrom the input geometry. |
| URX_PUBLIC.st_buffer(text, double precision) | |
| URX_PUBLIC.st_buffer(text, double precision, integer) | |
| URX_PUBLIC.st_buffer(text, double precision, text) | |
| URX_PUBLIC.st_buildarea(geometry) | args: A - Creates an areal geometry formed by the constituent linework of given geometry |
| URX_PUBLIC.st_centroid( geography, use_spheroid boolean) | args: g1, use_spheroid=true - Returns the geometric center of a geometry. |
| URX_PUBLIC.st_centroid(geometry) | args: g1 - Returns the geometric center of a geometry. |
| URX_PUBLIC.st_centroid(text) | |
| URX_PUBLIC.st_cleangeometry(geometry) | |
| URX_PUBLIC.st_clip(rast raster, geom geometry, crop boolean) | |
| URX_PUBLIC.st_clip(rast raster, geom geometry, nodataval double precision, crop boolean) | |
| URX_PUBLIC.st_clip(rast raster, geom geometry, nodataval double precision[], crop boolean) | |
| URX_PUBLIC.st_clip(rast raster, nband integer, geom geometry, crop boolean) | |
| URX_PUBLIC.st_clip(rast raster, nband integer, geom geometry, nodataval double precision, crop boolean) | |
| URX_PUBLIC.st_clip(rast raster, nband integer[], geom geometry, nodataval double precision[], crop boolean) | |
| URX_PUBLIC.st_clipbybox2d(geom geometry, box box2d) | args: geom, box - Returns the portion of a geometry falling within a rectangle. |
| URX_PUBLIC.st_closestpoint(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 2-dimensional point on g1 that is closest to g2. This is the first point of the shortest line. |
| URX_PUBLIC.st_closestpointofapproach(geometry, geometry) | args: track1, track2 - Returns the measure at which points interpolated along two lines are closest. |
| URX_PUBLIC.st_clusterdbscan( geometry, eps double precision, minpoints integer) | args: geom, eps, minpoints - Windowing function that returns integer id for the cluster each input geometry is in based on 2D implementation of Density-based spatial clustering of applications with noise (DBSCAN) algorithm. |
| URX_PUBLIC.st_clusterintersecting(geometry) | args: g - Aggregate. Returns an array with the connected components of a set of geometries |
| URX_PUBLIC.st_clusterintersecting(geometry[]) | |
| URX_PUBLIC.st_clusterkmeans(geom geometry, k integer) | args: geom, number_of_clusters - Windowing function that returns integer id for the cluster each input geometry is in. |
| URX_PUBLIC.st_clusterwithin(geometry, double precision) | args: g, distance - Aggregate. Returns an array of GeometryCollections, where each GeometryCollection represents a set of geometries separated by no more than the specified distance. |
| URX_PUBLIC.st_clusterwithin(geometry[], double precision) | |
| URX_PUBLIC.st_collect(geom1 geometry, geom2 geometry) | args: g1, g2 - Return a specified ST_Geometry value from a collection of other geometries. |
| URX_PUBLIC.st_collect(geometry) | args: g1field - Return a specified ST_Geometry value from a collection of other geometries. |
| URX_PUBLIC.st_collect(geometry[]) | args: g1_array - Return a specified ST_Geometry value from a collection of other geometries. |
| URX_PUBLIC.st_collectionextract(geometry, integer) | args: collection, type - Given a (multi)geometry, return a (multi)geometry consisting only of elements of the specified type. |
| URX_PUBLIC.st_collectionhomogenize(geometry) | args: collection - Given a geometry collection, return the "simplest" representation of the contents. |
| URX_PUBLIC.st_colormap(rast raster, colormap text, method text) | |
| URX_PUBLIC.st_colormap(rast raster, nband integer, colormap text, method text) | |
| URX_PUBLIC.st_combine_bbox(box2d, geometry) | |
| URX_PUBLIC.st_combine_bbox(box3d, geometry) | |
| URX_PUBLIC.st_combinebbox(box2d, geometry) | |
| URX_PUBLIC.st_combinebbox(box3d, box3d) | |
| URX_PUBLIC.st_combinebbox(box3d, geometry) | |
| URX_PUBLIC.st_concavehull(param_geom geometry, param_pctconvex double precision, param_allow_holes boolean) | args: geomA, target_percent, allow_holes=false - The concave hull of a geometry represents a possibly concave geometry that encloses all geometries within the set. You can think of it as shrink wrapping. |
| URX_PUBLIC.st_contains(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns true if and only if no points of B lie in the exterior of A, and at least one point of the interior of B lies in the interior of A. |
| URX_PUBLIC.st_contains(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastB lie in the exterior of raster rastA and at least one point of the interior of rastB lies in the interior of rastA. |
| URX_PUBLIC.st_contains(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if no points of raster rastB lie in the exterior of raster rastA and at least one point of the interior of rastB lies in the interior of rastA. |
| URX_PUBLIC.st_containsproperly(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns true if B intersects the interior of A but not the boundary (or exterior). A does not contain properly itself, but does contain itself. |
| URX_PUBLIC.st_containsproperly(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if rastB intersects the interior of rastA but not the boundary or exterior of rastA. |
| URX_PUBLIC.st_containsproperly(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if rastB intersects the interior of rastA but not the boundary or exterior of rastA. |
| URX_PUBLIC.st_convexhull(geometry) | args: geomA - The convex hull of a geometry represents the minimum convex geometry that encloses all geometries within the set. |
| URX_PUBLIC.st_convexhull(raster) | |
| URX_PUBLIC.st_coorddim(geometry geometry) | args: geomA - Return the coordinate dimension of the ST_Geometry value. |
| URX_PUBLIC.st_count(rast raster, exclude_nodata_value boolean) | args: rast, exclude_nodata_value - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value. |
| URX_PUBLIC.st_count(rast raster, nband integer, exclude_nodata_value boolean) | args: rast, nband=1, exclude_nodata_value=true - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value. |
| URX_PUBLIC.st_count(rastertable text, rastercolumn text, exclude_nodata_value boolean) | args: rastertable, rastercolumn, exclude_nodata_value - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value. |
| URX_PUBLIC.st_count(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean) | args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns the number of pixels in a given band of a raster or raster coverage. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the nodata value. |
| URX_PUBLIC.st_countagg(raster, boolean) | args: rast, exclude_nodata_value - Aggregate. Returns the number of pixels in a given band of a set of rasters. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the NODATA value. |
| URX_PUBLIC.st_countagg(raster, integer, boolean) | args: rast, nband, exclude_nodata_value - Aggregate. Returns the number of pixels in a given band of a set of rasters. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the NODATA value. |
| URX_PUBLIC.st_countagg(raster, integer, boolean, double precision) | args: rast, nband, exclude_nodata_value, sample_percent - Aggregate. Returns the number of pixels in a given band of a set of rasters. If no band is specified defaults to band 1. If exclude_nodata_value is set to true, will only count pixels that are not equal to the NODATA value. |
| URX_PUBLIC.st_coveredby(geography, geography) | args: geogA, geogB - Returns 1 (TRUE) if no point in Geometry/Geography A is outside Geometry/Geography B |
| URX_PUBLIC.st_coveredby(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns 1 (TRUE) if no point in Geometry/Geography A is outside Geometry/Geography B |
| URX_PUBLIC.st_coveredby(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastA lie outside raster rastB. |
| URX_PUBLIC.st_coveredby(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if no points of raster rastA lie outside raster rastB. |
| URX_PUBLIC.st_coveredby(text, text) | |
| URX_PUBLIC.st_covers(geography, geography) | args: geogpolyA, geogpointB - Returns 1 (TRUE) if no point in Geometry B is outside Geometry A |
| URX_PUBLIC.st_covers(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns 1 (TRUE) if no point in Geometry B is outside Geometry A |
| URX_PUBLIC.st_covers(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastB lie outside raster rastA. |
| URX_PUBLIC.st_covers(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if no points of raster rastB lie outside raster rastA. |
| URX_PUBLIC.st_covers(text, text) | |
| URX_PUBLIC.st_cpawithin(geometry, geometry, double precision) | args: track1, track2, maxdist - Returns true if the trajectories closest points of approachare within the specified distance. |
| URX_PUBLIC.st_createoverview(tab regclass, col name, factor integer, algo text) | args: tab, col, factor, algo='NearestNeighbor' - Create an reduced resolution version of a given raster coverage. |
| URX_PUBLIC.st_crosses(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns TRUE if the supplied geometries have some, but not all, interior points in common. |
| URX_PUBLIC.st_curvetoline(geom geometry, tol double precision, toltype integer, flags integer) | args: curveGeom, tolerance, tolerance_type, flags - Converts a CIRCULARSTRING/CURVEPOLYGON to a LINESTRING/POLYGON |
| URX_PUBLIC.st_curvetoline(geometry) | args: curveGeom - Converts a CIRCULARSTRING/CURVEPOLYGON to a LINESTRING/POLYGON |
| URX_PUBLIC.st_curvetoline(geometry, integer) | args: curveGeom, segments_per_qtr_circle - Converts a CIRCULARSTRING/CURVEPOLYGON to a LINESTRING/POLYGON |
| URX_PUBLIC.st_delaunaytriangles(g1 geometry, tolerance double precision, flags integer) | args: g1, tolerance, flags - Return a Delaunay triangulation around the given input points. |
| URX_PUBLIC.st_dfullywithin(geom1 geometry, geom2 geometry, double precision) | args: g1, g2, distance - Returns true if all of the geometries are within the specified distance of one another |
| URX_PUBLIC.st_dfullywithin(rast1 raster, nband1 integer, rast2 raster, nband2 integer, distance double precision) | args: rastA, nbandA, rastB, nbandB, distance_of_srid - Return true if rasters rastA and rastB are fully within the specified distance of each other. |
| URX_PUBLIC.st_dfullywithin(rast1 raster, rast2 raster, distance double precision) | args: rastA, rastB, distance_of_srid - Return true if rasters rastA and rastB are fully within the specified distance of each other. |
| URX_PUBLIC.st_difference(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns a geometry that represents that part of geometry A that does not intersect with geometry B. |
| URX_PUBLIC.st_dimension(geometry) | args: g - The inherent dimension of this Geometry object, which must be less than or equal to the coordinate dimension. |
| URX_PUBLIC.st_disjoint(geom1 geometry, geom2 geometry) | args: A, B - Returns TRUE if the Geometries do not "spatially intersect" - if they do not share any space together. |
| URX_PUBLIC.st_disjoint(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if raster rastA does not spatially intersect rastB. |
| URX_PUBLIC.st_disjoint(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if raster rastA does not spatially intersect rastB. |
| URX_PUBLIC.st_distance(geography, geography) | args: gg1, gg2 - For geometry type Returns the 2D Cartesian distance between two geometries in projected units (based on spatial ref). For geography type defaults to return minimum geodesic distance between two geographies in meters. |
| URX_PUBLIC.st_distance(geography, geography, boolean) | args: gg1, gg2, use_spheroid - For geometry type Returns the 2D Cartesian distance between two geometries in projected units (based on spatial ref). For geography type defaults to return minimum geodesic distance between two geographies in meters. |
| URX_PUBLIC.st_distance(geom1 geometry, geom2 geometry) | args: g1, g2 - For geometry type Returns the 2D Cartesian distance between two geometries in projected units (based on spatial ref). For geography type defaults to return minimum geodesic distance between two geographies in meters. |
| URX_PUBLIC.st_distance(text, text) | |
| URX_PUBLIC.st_distance_sphere(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.st_distance_spheroid(geom1 geometry, geom2 geometry, spheroid) | |
| URX_PUBLIC.st_distancecpa(geometry, geometry) | args: track1, track2 - Returns the distance between closest points of approach in two trajectories. |
| URX_PUBLIC.st_distancesphere(geom1 geometry, geom2 geometry) | args: geomlonlatA, geomlonlatB - Returns minimum distance in meters between two lon/lat geometries. Uses a spherical earth and radius derived from the spheroid defined by the SRID. Faster than ST_DistanceSpheroid , but less accurate. PostGIS versions prior to 1.5 only implemented for points. |
| URX_PUBLIC.st_distancespheroid(geom1 geometry, geom2 geometry, spheroid) | args: geomlonlatA, geomlonlatB, measurement_spheroid - Returns the minimum distance between two lon/lat geometries given a particular spheroid. PostGIS versions prior to 1.5 only support points. |
| URX_PUBLIC.st_distinct4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_distinct4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_dump(geometry) | args: g1 - Returns a set of geometry_dump (geom,path) rows, that make up a geometry g1. |
| URX_PUBLIC.st_dumpaspolygons(rast raster, band integer, exclude_nodata_value boolean) | |
| URX_PUBLIC.st_dumppoints(geometry) | args: geom - Returns a set of geometry_dump (geom,path) rows of all points that make up a geometry. |
| URX_PUBLIC.st_dumprings(geometry) | args: a_polygon - Returns a set of geometry_dump rows, representing the exterior and interior rings of a polygon. |
| URX_PUBLIC.st_dumpvalues(rast raster, nband integer, exclude_nodata_value boolean) | args: rast, nband, exclude_nodata_value=true - Get the values of the specified band as a 2-dimension array. |
| URX_PUBLIC.st_dumpvalues(rast raster, nband integer[], exclude_nodata_value boolean) | args: rast, nband=NULL, exclude_nodata_value=true - Get the values of the specified band as a 2-dimension array. |
| URX_PUBLIC.st_dwithin(geography, geography, double precision) | args: gg1, gg2, distance_meters - Returns true if the geometries are within the specified distance of one another. For geometry units are in those of spatial reference and For geography units are in meters and measurement is defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere. |
| URX_PUBLIC.st_dwithin(geography, geography, double precision, boolean) | args: gg1, gg2, distance_meters, use_spheroid - Returns true if the geometries are within the specified distance of one another. For geometry units are in those of spatial reference and For geography units are in meters and measurement is defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere. |
| URX_PUBLIC.st_dwithin(geom1 geometry, geom2 geometry, double precision) | args: g1, g2, distance_of_srid - Returns true if the geometries are within the specified distance of one another. For geometry units are in those of spatial reference and For geography units are in meters and measurement is defaulted to use_spheroid=true (measure around spheroid), for faster check, use_spheroid=false to measure along sphere. |
| URX_PUBLIC.st_dwithin(rast1 raster, nband1 integer, rast2 raster, nband2 integer, distance double precision) | args: rastA, nbandA, rastB, nbandB, distance_of_srid - Return true if rasters rastA and rastB are within the specified distance of each other. |
| URX_PUBLIC.st_dwithin(rast1 raster, rast2 raster, distance double precision) | args: rastA, rastB, distance_of_srid - Return true if rasters rastA and rastB are within the specified distance of each other. |
| URX_PUBLIC.st_dwithin(text, text, double precision) | |
| URX_PUBLIC.st_endpoint(geometry) | args: g - Returns the last point of a LINESTRING or CIRCULARLINESTRING geometry as a POINT. |
| URX_PUBLIC.st_envelope(geometry) | args: g1 - Returns a geometry representing the double precision (float8) bounding box of the supplied geometry. |
| URX_PUBLIC.st_envelope(raster) | |
| URX_PUBLIC.st_equals(geom1 geometry, geom2 geometry) | args: A, B - Returns true if the given geometries represent the same geometry. Directionality is ignored. |
| URX_PUBLIC.st_estimated_extent(text, text) | |
| URX_PUBLIC.st_estimated_extent(text, text, text) | |
| URX_PUBLIC.st_estimatedextent(text, text) | args: table_name, geocolumn_name - Return the estimated extent of the given spatial table. The estimated is taken from the geometry columns statistics. The current schema will be used if not specified. |
| URX_PUBLIC.st_estimatedextent(text, text, text) | args: schema_name, table_name, geocolumn_name - Return the estimated extent of the given spatial table. The estimated is taken from the geometry columns statistics. The current schema will be used if not specified. |
| URX_PUBLIC.st_estimatedextent(text, text, text, boolean) | args: schema_name, table_name, geocolumn_name, parent_ony - Return the estimated extent of the given spatial table. The estimated is taken from the geometry columns statistics. The current schema will be used if not specified. |
| URX_PUBLIC.st_expand(box box2d, dx double precision, dy double precision) | args: box, dx, dy - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision |
| URX_PUBLIC.st_expand(box box3d, dx double precision, dy double precision, dz double precision) | args: box, dx, dy, dz=0 - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision |
| URX_PUBLIC.st_expand(box2d, double precision) | args: box, units_to_expand - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision |
| URX_PUBLIC.st_expand(box3d, double precision) | args: box, units_to_expand - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision |
| URX_PUBLIC.st_expand(geom geometry, dx double precision, dy double precision, dz double precision, dm double precision) | args: geom, dx, dy, dz=0, dm=0 - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision |
| URX_PUBLIC.st_expand(geometry, double precision) | args: geom, units_to_expand - Returns bounding box expanded in all directions from the bounding box of the input geometry. Uses double-precision |
| URX_PUBLIC.st_extent(geometry) | args: geomfield - an aggregate function that returns the bounding box that bounds rows of geometries. |
| URX_PUBLIC.st_exteriorring(geometry) | args: a_polygon - Returns a line string representing the exterior ring of the POLYGON geometry. Return NULL if the geometry is not a polygon. Will not work with MULTIPOLYGON |
| URX_PUBLIC.st_find_extent(text, text) | |
| URX_PUBLIC.st_find_extent(text, text, text) | |
| URX_PUBLIC.st_findextent(text, text) | |
| URX_PUBLIC.st_findextent(text, text, text) | |
| URX_PUBLIC.st_flipcoordinates(geometry) | args: geom - Returns a version of the given geometry with X and Y axis flipped. Useful for people who have built latitude/longitude features and need to fix them. |
| URX_PUBLIC.st_force2d(geometry) | args: geomA - Force the geometries into a "2-dimensional mode". |
| URX_PUBLIC.st_force3d(geometry) | args: geomA - Force the geometries into XYZ mode. This is an alias for ST_Force3DZ. |
| URX_PUBLIC.st_force3dm(geometry) | args: geomA - Force the geometries into XYM mode. |
| URX_PUBLIC.st_force3dz(geometry) | args: geomA - Force the geometries into XYZ mode. |
| URX_PUBLIC.st_force4d(geometry) | args: geomA - Force the geometries into XYZM mode. |
| URX_PUBLIC.st_force_2d(geometry) | |
| URX_PUBLIC.st_force_3d(geometry) | |
| URX_PUBLIC.st_force_3dm(geometry) | |
| URX_PUBLIC.st_force_3dz(geometry) | |
| URX_PUBLIC.st_force_4d(geometry) | |
| URX_PUBLIC.st_force_collection(geometry) | |
| URX_PUBLIC.st_forcecollection(geometry) | args: geomA - Convert the geometry into a GEOMETRYCOLLECTION. |
| URX_PUBLIC.st_forcecurve(geometry) | args: g - Upcast a geometry into its curved type, if applicable. |
| URX_PUBLIC.st_forcepolygonccw(geometry) | args: geom - Orients all exterior rings counter-clockwise and all interior rings clockwise. |
| URX_PUBLIC.st_forcepolygoncw(geometry) | args: geom - Orients all exterior rings clockwise and all interior rings counter-clockwise. |
| URX_PUBLIC.st_forcerhr(geometry) | args: g - Force the orientation of the vertices in a polygon to follow the Right-Hand-Rule. |
| URX_PUBLIC.st_forcesfs( geometry, version text) | args: geomA, version - Force the geometries to use SFS 1.1 geometry types only. |
| URX_PUBLIC.st_forcesfs(geometry) | args: geomA - Force the geometries to use SFS 1.1 geometry types only. |
| URX_PUBLIC.st_frechetdistance(geom1 geometry, geom2 geometry, double precision) | args: g1, g2, densifyFrac = -1 - Returns the Fréchet distance between two geometries. This is a measure of similarity between curves that takes into account the location and ordering of the points along the curves. Units are in the units of the spatial reference system of the geometries. |
| URX_PUBLIC.st_fromgdalraster(gdaldata bytea, srid integer) | args: gdaldata, srid=NULL - Returns a raster from a supported GDAL raster file. |
| URX_PUBLIC.st_gdaldrivers(idx ) | args: OUT idx, OUT short_name, OUT long_name, OUT create_options - Returns a list of raster formats supported by your lib gdal. These are the formats you can output your raster using ST_AsGDALRaster. |
| URX_PUBLIC.st_generatepoints(area geometry, npoints numeric) | args: g, npoints - Converts a polygon or multi-polygon into a multi-point composed of randomly location points within the original areas. |
| URX_PUBLIC.st_geogfromtext(text) | args: EWKT - Return a specified geography value from Well-Known Text representation or extended (WKT). |
| URX_PUBLIC.st_geogfromwkb(bytea) | args: wkb - Creates a geography instance from a Well-Known Binary geometry representation (WKB) or extended Well Known Binary (EWKB). |
| URX_PUBLIC.st_geographyfromtext(text) | args: EWKT - Return a specified geography value from Well-Known Text representation or extended (WKT). |
| URX_PUBLIC.st_geohash(geog geography, maxchars integer) | |
| URX_PUBLIC.st_geohash(geom geometry, maxchars integer) | args: geom, maxchars=full_precision_of_point - Return a GeoHash representation of the geometry. |
| URX_PUBLIC.st_geomcollfromtext(text) | args: WKT - Makes a collection Geometry from collection WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_geomcollfromtext(text, integer) | args: WKT, srid - Makes a collection Geometry from collection WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_geomcollfromwkb(bytea) | |
| URX_PUBLIC.st_geomcollfromwkb(bytea, integer) | |
| URX_PUBLIC.st_geometricmedian(g geometry, tolerance double precision, max_iter integer, fail_if_not_converged boolean) | args:
g
,
tolerance
,
max_iter
,
fail_if_not_converged
- Returns the geometric median of a MultiPoint. |
| URX_PUBLIC.st_geometryfromtext(text) | args: WKT - Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText |
| URX_PUBLIC.st_geometryfromtext(text, integer) | args: WKT, srid - Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText |
| URX_PUBLIC.st_geometryn(geometry, integer) | args: geomA, n - Return the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON, POLYHEDRALSURFACE Otherwise, return NULL. |
| URX_PUBLIC.st_geometrytype(geometry) | args: g1 - Return the geometry type of the ST_Geometry value. |
| URX_PUBLIC.st_geomfromewkb(bytea) | args: EWKB - Return a specified ST_Geometry value from Extended Well-Known Binary representation (EWKB). |
| URX_PUBLIC.st_geomfromewkt(text) | args: EWKT - Return a specified ST_Geometry value from Extended Well-Known Text representation (EWKT). |
| URX_PUBLIC.st_geomfromgeohash(text, integer) | args: geohash, precision=full_precision_of_geohash - Return a geometry from a GeoHash string. |
| URX_PUBLIC.st_geomfromgeojson(text) | args: geomjson - Takes as input a geojson representation of a geometry and outputs a PostGIS geometry object |
| URX_PUBLIC.st_geomfromgml(text) | args: geomgml - Takes as input GML representation of geometry and outputs a PostGIS geometry object |
| URX_PUBLIC.st_geomfromgml(text, integer) | args: geomgml, srid - Takes as input GML representation of geometry and outputs a PostGIS geometry object |
| URX_PUBLIC.st_geomfromkml(text) | args: geomkml - Takes as input KML representation of geometry and outputs a PostGIS geometry object |
| URX_PUBLIC.st_geomfromtext(text) | args: WKT - Return a specified ST_Geometry value from Well-Known Text representation (WKT). |
| URX_PUBLIC.st_geomfromtext(text, integer) | args: WKT, srid - Return a specified ST_Geometry value from Well-Known Text representation (WKT). |
| URX_PUBLIC.st_geomfromtwkb(bytea) | args: twkb - Creates a geometry instance from a TWKB ("Tiny Well-Known Binary") geometry representation. |
| URX_PUBLIC.st_geomfromwkb(bytea) | args: geom - Makes a geometry from WKB with the given SRID |
| URX_PUBLIC.st_geomfromwkb(bytea, integer) | args: geom, srid - Makes a geometry from WKB with the given SRID |
| URX_PUBLIC.st_georeference(rast raster, format text) | args: rast, format=GDAL - Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. Default is GDAL. |
| URX_PUBLIC.st_geotransform( raster) | |
| URX_PUBLIC.st_gmltosql(text) | args: geomgml - Return a specified ST_Geometry value from GML representation. This is an alias name for ST_GeomFromGML |
| URX_PUBLIC.st_gmltosql(text, integer) | args: geomgml, srid - Return a specified ST_Geometry value from GML representation. This is an alias name for ST_GeomFromGML |
| URX_PUBLIC.st_hasarc(geometry geometry) | args: geomA - Returns true if a geometry or geometry collection contains a circular string |
| URX_PUBLIC.st_hasnoband(rast raster, nband integer) | args: rast, bandnum=1 - Returns true if there is no band with given band number. If no band number is specified, then band number 1 is assumed. |
| URX_PUBLIC.st_hausdorffdistance(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the Hausdorff distance between two geometries. Basically a measure of how similar or dissimilar 2 geometries are. Units are in the units of the spatial reference system of the geometries. |
| URX_PUBLIC.st_hausdorffdistance(geom1 geometry, geom2 geometry, double precision) | args: g1, g2, densifyFrac - Returns the Hausdorff distance between two geometries. Basically a measure of how similar or dissimilar 2 geometries are. Units are in the units of the spatial reference system of the geometries. |
| URX_PUBLIC.st_height(raster) | args: rast - Returns the height of the raster in pixels. |
| URX_PUBLIC.st_hillshade(rast raster, nband integer, customextent raster, pixeltype text, azimuth double precision, altitude double precision, max_bright double precision, scale double precision, interpolate_nodata boolean) | |
| URX_PUBLIC.st_hillshade(rast raster, nband integer, pixeltype text, azimuth double precision, altitude double precision, max_bright double precision, scale double precision, interpolate_nodata boolean) | |
| URX_PUBLIC.st_histogram(rast raster, nband integer, bins integer, right boolean) | args: rast, nband, bins, right - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rast raster, nband integer, bins integer, width double precision[], right boolean) | args: rast, nband, bins, width=NULL, right=false - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rast raster, nband integer, exclude_nodata_value boolean, bins integer, right boolean) | args: rast, nband, exclude_nodata_value, bins, right - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rast raster, nband integer, exclude_nodata_value boolean, bins integer, width double precision[], right boolean) | args: rast, nband=1, exclude_nodata_value=true, bins=autocomputed, width=NULL, right=false - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rastertable text, rastercolumn text, nband integer, bins integer, right boolean) | args: rastertable, rastercolumn, nband, bins, right - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rastertable text, rastercolumn text, nband integer, bins integer, width double precision[], right boolean) | args: rastertable, rastercolumn, nband=1, bins, width=NULL, right=false - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, bins integer, right boolean) | args: rastertable, rastercolumn, nband, exclude_nodata_value, bins, right - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_histogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, bins integer, width double precision[], right boolean) | args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, bins=autocomputed, width=NULL, right=false - Returns a set of record summarizing a raster or raster coverage data distribution separate bin ranges. Number of bins are autocomputed if not specified. |
| URX_PUBLIC.st_interiorringn(geometry, integer) | args: a_polygon, n - Return the Nth interior linestring ring of the polygon geometry. Return NULL if the geometry is not a polygon or the given N is out of range. |
| URX_PUBLIC.st_interpolatepoint(line geometry, point geometry) | args: line, point - Return the value of the measure dimension of a geometry at the point closed to the provided point. |
| URX_PUBLIC.st_intersection(geography, geography) | args: geogA, geogB - (T)Returns a geometry that represents the shared portion of geomA and geomB. |
| URX_PUBLIC.st_intersection(geom1 geometry, geom2 geometry) | args: geomA, geomB - (T)Returns a geometry that represents the shared portion of geomA and geomB. |
| URX_PUBLIC.st_intersection(geomin geometry, rast raster, band integer) | |
| URX_PUBLIC.st_intersection(rast raster, band integer, geomin geometry) | |
| URX_PUBLIC.st_intersection(rast raster, geomin geometry) | |
| URX_PUBLIC.st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, nodataval double precision) | |
| URX_PUBLIC.st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, nodataval double precision[]) | |
| URX_PUBLIC.st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, returnband text, nodataval double precision) | |
| URX_PUBLIC.st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, returnband text, nodataval double precision[]) | |
| URX_PUBLIC.st_intersection(rast1 raster, rast2 raster, nodataval double precision) | |
| URX_PUBLIC.st_intersection(rast1 raster, rast2 raster, nodataval double precision[]) | |
| URX_PUBLIC.st_intersection(rast1 raster, rast2 raster, returnband text, nodataval double precision) | |
| URX_PUBLIC.st_intersection(rast1 raster, rast2 raster, returnband text, nodataval double precision[]) | |
| URX_PUBLIC.st_intersection(text, text) | |
| URX_PUBLIC.st_intersects(geography, geography) | args: geogA, geogB - Returns TRUE if the Geometries/Geography "spatially intersect in 2D" - (share any portion of space) and FALSE if they dont (they are Disjoint). For geography -- tolerance is 0.00001 meters (so any points that close are considered to intersect) |
| URX_PUBLIC.st_intersects(geom geometry, rast raster, nband integer) | args: geommin, rast, nband=NULL - Return true if raster rastA spatially intersects raster rastB. |
| URX_PUBLIC.st_intersects(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns TRUE if the Geometries/Geography "spatially intersect in 2D" - (share any portion of space) and FALSE if they dont (they are Disjoint). For geography -- tolerance is 0.00001 meters (so any points that close are considered to intersect) |
| URX_PUBLIC.st_intersects(rast raster, geom geometry, nband integer) | args: rast, geommin, nband=NULL - Return true if raster rastA spatially intersects raster rastB. |
| URX_PUBLIC.st_intersects(rast raster, nband integer, geom geometry) | args: rast, nband, geommin - Return true if raster rastA spatially intersects raster rastB. |
| URX_PUBLIC.st_intersects(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if raster rastA spatially intersects raster rastB. |
| URX_PUBLIC.st_intersects(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if raster rastA spatially intersects raster rastB. |
| URX_PUBLIC.st_intersects(text, text) | |
| URX_PUBLIC.st_invdistweight4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_isclosed(geometry) | args: g - Returns TRUE if the LINESTRINGs start and end points are coincident. For Polyhedral surface is closed (volumetric). |
| URX_PUBLIC.st_iscollection(geometry) | args: g - Returns TRUE if the argument is a collection (MULTI*, GEOMETRYCOLLECTION, ...) |
| URX_PUBLIC.st_iscoveragetile(rast raster, coverage raster, tilewidth integer, tileheight integer) | |
| URX_PUBLIC.st_isempty(geometry) | args: geomA - Returns true if this Geometry is an empty geometrycollection, polygon, point etc. |
| URX_PUBLIC.st_isempty(rast raster) | args: rast - Returns true if the raster is empty (width = 0 and height = 0). Otherwise, returns false. |
| URX_PUBLIC.st_ispolygonccw(geometry) | args: geom - Returns true if all exterior rings are oriented counter-clockwise and all interior rings are oriented clockwise. |
| URX_PUBLIC.st_ispolygoncw(geometry) | args: geom - Returns true if all exterior rings are oriented clockwise and all interior rings are oriented counter-clockwise. |
| URX_PUBLIC.st_isring(geometry) | args: g - Returns TRUE if this LINESTRING is both closed and simple. |
| URX_PUBLIC.st_issimple(geometry) | args: geomA - Returns (TRUE) if this Geometry has no anomalous geometric points, such as self intersection or self tangency. |
| URX_PUBLIC.st_isvalid(geometry) | args: g - Returns true if the ST_Geometry is well formed. |
| URX_PUBLIC.st_isvalid(geometry, integer) | args: g, flags - Returns true if the ST_Geometry is well formed. |
| URX_PUBLIC.st_isvaliddetail(geometry) | args: geom - Returns a valid_detail (valid,reason,location) row stating if a geometry is valid or not and if not valid, a reason why and a location where. |
| URX_PUBLIC.st_isvaliddetail(geometry, integer) | args: geom, flags - Returns a valid_detail (valid,reason,location) row stating if a geometry is valid or not and if not valid, a reason why and a location where. |
| URX_PUBLIC.st_isvalidreason(geometry) | args: geomA - Returns text stating if a geometry is valid or not and if not valid, a reason why. |
| URX_PUBLIC.st_isvalidreason(geometry, integer) | args: geomA, flags - Returns text stating if a geometry is valid or not and if not valid, a reason why. |
| URX_PUBLIC.st_isvalidtrajectory(geometry) | args: line - Returns true if the geometry is a valid trajectory. |
| URX_PUBLIC.st_length(geog geography, use_spheroid boolean) | args: geog, use_spheroid=true - Returns the 2d length of the geometry if it is a linestring or multilinestring. geometry are in units of spatial reference and geography are in meters (default spheroid) |
| URX_PUBLIC.st_length(geometry) | args: a_2dlinestring - Returns the 2d length of the geometry if it is a linestring or multilinestring. geometry are in units of spatial reference and geography are in meters (default spheroid) |
| URX_PUBLIC.st_length(text) | |
| URX_PUBLIC.st_length2d(geometry) | args: a_2dlinestring - Returns the 2-dimensional length of the geometry if it is a linestring or multi-linestring. This is an alias for ST_Length |
| URX_PUBLIC.st_length2d_spheroid(geometry, spheroid) | args: a_geometry, a_spheroid - Calculates the 2D length/perimeter of a geometry on an ellipsoid. This is useful if the coordinates of the geometry are in longitude/latitude and a length is desired without reprojection. |
| URX_PUBLIC.st_length2dspheroid(geometry, spheroid) | |
| URX_PUBLIC.st_length_spheroid(geometry, spheroid) | |
| URX_PUBLIC.st_lengthspheroid(geometry, spheroid) | args: a_geometry, a_spheroid - Calculates the 2D or 3D length/perimeter of a geometry on an ellipsoid. This is useful if the coordinates of the geometry are in longitude/latitude and a length is desired without reprojection. |
| URX_PUBLIC.st_line_interpolate_point(geometry, double precision) | |
| URX_PUBLIC.st_line_locate_point(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.st_line_substring(geometry, double precision, double precision) | |
| URX_PUBLIC.st_linecrossingdirection(geom1 geometry, geom2 geometry) | args: linestringA, linestringB - Given 2 linestrings, returns a number between -3 and 3 denoting what kind of crossing behavior. 0 is no crossing. |
| URX_PUBLIC.st_linefromencodedpolyline(text, integer) | args: polyline, precision=5 - Creates a LineString from an Encoded Polyline. |
| URX_PUBLIC.st_linefrommultipoint(geometry) | args: aMultiPoint - Creates a LineString from a MultiPoint geometry. |
| URX_PUBLIC.st_linefromtext(text) | args: WKT - Makes a Geometry from WKT representation with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_linefromtext(text, integer) | args: WKT, srid - Makes a Geometry from WKT representation with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_linefromwkb(bytea) | args: WKB - Makes a LINESTRING from WKB with the given SRID |
| URX_PUBLIC.st_linefromwkb(bytea, integer) | args: WKB, srid - Makes a LINESTRING from WKB with the given SRID |
| URX_PUBLIC.st_lineinterpolatepoint(geometry, double precision) | args: a_linestring, a_fraction - Returns a point interpolated along a line. Second argument is a float8 between 0 and 1 representing fraction of total length of linestring the point has to be located. |
| URX_PUBLIC.st_linelocatepoint(geom1 geometry, geom2 geometry) | args: a_linestring, a_point - Returns a float between 0 and 1 representing the location of the closest point on LineString to the given Point, as a fraction of total 2d line length. |
| URX_PUBLIC.st_linemerge(geometry) | args: amultilinestring - Return a (set of) LineString(s) formed by sewing together a MULTILINESTRING. |
| URX_PUBLIC.st_linestringfromwkb(bytea) | args: WKB - Makes a geometry from WKB with the given SRID. |
| URX_PUBLIC.st_linestringfromwkb(bytea, integer) | args: WKB, srid - Makes a geometry from WKB with the given SRID. |
| URX_PUBLIC.st_linesubstring(geometry, double precision, double precision) | args: a_linestring, startfraction, endfraction - Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length. Second and third arguments are float8 values between 0 and 1. |
| URX_PUBLIC.st_linetocurve(geometry geometry) | args: geomANoncircular - Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVEPOLYGON |
| URX_PUBLIC.st_locate_along_measure(geometry, double precision) | |
| URX_PUBLIC.st_locate_between_measures(geometry, double precision, double precision) | |
| URX_PUBLIC.st_locatealong(geometry geometry, measure double precision, leftrightoffset double precision) | args: ageom_with_measure, a_measure, offset - Return a derived geometry collection value with elements that match the specified measure. Polygonal elements are not supported. |
| URX_PUBLIC.st_locatebetween(geometry geometry, frommeasure double precision, tomeasure double precision, leftrightoffset double precision) | args: geomA, measure_start, measure_end, offset - Return a derived geometry collection value with elements that match the specified range of measures inclusively. Polygonal elements are not supported. |
| URX_PUBLIC.st_locatebetweenelevations(geometry geometry, fromelevation double precision, toelevation double precision) | args: geom_mline, elevation_start, elevation_end - Return a derived geometry (collection) value with elements that intersect the specified range of elevations inclusively. Only 3D, 4D LINESTRINGS and MULTILINESTRINGS are supported. |
| URX_PUBLIC.st_longestline(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 2-dimensional longest line points of two geometries. The function will only return the first longest line if more than one, that the function finds. The line returned will always start in g1 and end in g2. The length of the line this function returns will always be the same as st_maxdistance returns for g1 and g2. |
| URX_PUBLIC.st_m(geometry) | args: a_point - Return the M coordinate of the point, or NULL if not available. Input must be a point. |
| URX_PUBLIC.st_makebox2d(geom1 geometry, geom2 geometry) | args: pointLowLeft, pointUpRight - Creates a BOX2D defined by the given point geometries. |
| URX_PUBLIC.st_makeemptycoverage(tilewidth integer, tileheight integer, width integer, height integer, upperleftx double precision, upperlefty double precision, scalex double precision, scaley double precision, skewx double precision, skewy double precision, srid integer) | args: tilewidth, tileheight, width, height, upperleftx, upperlefty, scalex, scaley, skewx, skewy, srid=unknown - Cover georeferenced area with a grid of empty raster tiles. |
| URX_PUBLIC.st_makeemptyraster(rast raster) | args: rast - Returns an empty raster (having no bands) of given dimensions (width & height), upperleft X and Y, pixel size and rotation (scalex, scaley, skewx & skewy) and reference system (srid). If a raster is passed in, returns a new raster with the same size, alignment and SRID. If srid is left out, the spatial ref is set to unknown (0). |
| URX_PUBLIC.st_makeemptyraster(width integer, height integer, upperleftx double precision, upperlefty double precision, pixelsize double precision) | args: width, height, upperleftx, upperlefty, pixelsize - Returns an empty raster (having no bands) of given dimensions (width & height), upperleft X and Y, pixel size and rotation (scalex, scaley, skewx & skewy) and reference system (srid). If a raster is passed in, returns a new raster with the same size, alignment and SRID. If srid is left out, the spatial ref is set to unknown (0). |
| URX_PUBLIC.st_makeemptyraster(width integer, height integer, upperleftx double precision, upperlefty double precision, scalex double precision, scaley double precision, skewx double precision, skewy double precision, srid integer) | args: width, height, upperleftx, upperlefty, scalex, scaley, skewx, skewy, srid=unknown - Returns an empty raster (having no bands) of given dimensions (width & height), upperleft X and Y, pixel size and rotation (scalex, scaley, skewx & skewy) and reference system (srid). If a raster is passed in, returns a new raster with the same size, alignment and SRID. If srid is left out, the spatial ref is set to unknown (0). |
| URX_PUBLIC.st_makeenvelope(double precision, double precision, double precision, double precision, integer) | args: xmin, ymin, xmax, ymax, srid=unknown - Creates a rectangular Polygon formed from the given minimums and maximums. Input values must be in SRS specified by the SRID. |
| URX_PUBLIC.st_makeline(geom1 geometry, geom2 geometry) | args: geom1, geom2 - Creates a Linestring from point, multipoint, or line geometries. |
| URX_PUBLIC.st_makeline(geometry) | args: geoms - Creates a Linestring from point, multipoint, or line geometries. |
| URX_PUBLIC.st_makeline(geometry[]) | args: geoms_array - Creates a Linestring from point, multipoint, or line geometries. |
| URX_PUBLIC.st_makepoint(double precision, double precision) | args: x, y - Creates a 2D,3DZ or 4D point geometry. |
| URX_PUBLIC.st_makepoint(double precision, double precision, double precision) | args: x, y, z - Creates a 2D,3DZ or 4D point geometry. |
| URX_PUBLIC.st_makepoint(double precision, double precision, double precision, double precision) | args: x, y, z, m - Creates a 2D,3DZ or 4D point geometry. |
| URX_PUBLIC.st_makepointm(double precision, double precision, double precision) | args: x, y, m - Creates a point geometry with an x y and m coordinate. |
| URX_PUBLIC.st_makepolygon(geometry) | args: linestring - Creates a Polygon formed by the given shell. Input geometries must be closed LINESTRINGS. |
| URX_PUBLIC.st_makepolygon(geometry, geometry[]) | args: outerlinestring, interiorlinestrings - Creates a Polygon formed by the given shell. Input geometries must be closed LINESTRINGS. |
| URX_PUBLIC.st_makevalid(geometry) | args: input - Attempts to make an invalid geometry valid without losing vertices. |
| URX_PUBLIC.st_mapalgebra(rast raster, nband integer, callbackfunc regprocedure, mask double precision[], weighted boolean, pixeltype text, extenttype text, customextent raster, userargs text[]) | |
| URX_PUBLIC.st_mapalgebra(rast raster, nband integer, callbackfunc regprocedure, pixeltype text, extenttype text, customextent raster, distancex integer, distancey integer, userargs text[]) | |
| URX_PUBLIC.st_mapalgebra(rast raster, nband integer, pixeltype text, expression text, nodataval double precision) | |
| URX_PUBLIC.st_mapalgebra(rast raster, nband integer[], callbackfunc regprocedure, pixeltype text, extenttype text, customextent raster, distancex integer, distancey integer, userargs text[]) | |
| URX_PUBLIC.st_mapalgebra(rast raster, pixeltype text, expression text, nodataval double precision) | |
| URX_PUBLIC.st_mapalgebra(rast1 raster, band1 integer, rast2 raster, band2 integer, expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision) | |
| URX_PUBLIC.st_mapalgebra(rast1 raster, nband1 integer, rast2 raster, nband2 integer, callbackfunc regprocedure, pixeltype text, extenttype text, customextent raster, distancex integer, distancey integer, userargs text[]) | |
| URX_PUBLIC.st_mapalgebra(rast1 raster, rast2 raster, expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision) | |
| URX_PUBLIC.st_mapalgebra(rastbandargset rastbandarg[], callbackfunc regprocedure, pixeltype text, extenttype text, customextent raster, distancex integer, distancey integer, userargs text[]) | |
| URX_PUBLIC.st_mapalgebraexpr(rast raster, band integer, pixeltype text, expression text, nodataval double precision) | |
| URX_PUBLIC.st_mapalgebraexpr(rast raster, pixeltype text, expression text, nodataval double precision) | |
| URX_PUBLIC.st_mapalgebraexpr(rast1 raster, band1 integer, rast2 raster, band2 integer, expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision) | |
| URX_PUBLIC.st_mapalgebraexpr(rast1 raster, rast2 raster, expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, band integer, onerastuserfunc regprocedure) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, band integer, onerastuserfunc regprocedure, args text[]) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, band integer, pixeltype text, onerastuserfunc regprocedure) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, band integer, pixeltype text, onerastuserfunc regprocedure, args text[]) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, onerastuserfunc regprocedure) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, onerastuserfunc regprocedure, args text[]) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, pixeltype text, onerastuserfunc regprocedure) | |
| URX_PUBLIC.st_mapalgebrafct(rast raster, pixeltype text, onerastuserfunc regprocedure, args text[]) | |
| URX_PUBLIC.st_mapalgebrafct(rast1 raster, band1 integer, rast2 raster, band2 integer, tworastuserfunc regprocedure, pixeltype text, extenttype text, userargs text[]) | |
| URX_PUBLIC.st_mapalgebrafct(rast1 raster, rast2 raster, tworastuserfunc regprocedure, pixeltype text, extenttype text, userargs text[]) | |
| URX_PUBLIC.st_mapalgebrafctngb(rast raster, band integer, pixeltype text, ngbwidth integer, ngbheight integer, onerastngbuserfunc regprocedure, nodatamode text, args text[]) | |
| URX_PUBLIC.st_max4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_max4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_maxdistance(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 2-dimensional largest distance between two geometries in projected units. |
| URX_PUBLIC.st_mean4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_mean4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_mem_size(geometry) | |
| URX_PUBLIC.st_memcollect(geometry) | |
| URX_PUBLIC.st_memsize(geometry) | args: geomA - Returns the amount of space (in bytes) the geometry takes. |
| URX_PUBLIC.st_memsize(raster) | args: rast - Returns the amount of space (in bytes) the raster takes. |
| URX_PUBLIC.st_memunion(geometry) | args: geomfield - Same as ST_Union, only memory-friendly (uses less memory and more processor time). |
| URX_PUBLIC.st_metadata(rast raster) | args: rast - Returns basic meta data about a raster object such as pixel size, rotation (skew), upper, lower left, etc. |
| URX_PUBLIC.st_min4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_min4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_minconvexhull(rast raster, nband integer) | |
| URX_PUBLIC.st_mindist4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_minimumboundingcircle(inputgeom geometry, segs_per_quarter integer) | args: geomA, num_segs_per_qt_circ=48 - Returns the smallest circle polygon that can fully contain a geometry. Default uses 48 segments per quarter circle. |
| URX_PUBLIC.st_minimumboundingradius( geometry) | args: geom - Returns the center point and radius of the smallest circle that can fully contain a geometry. |
| URX_PUBLIC.st_minimumclearance(geometry) | args: g - Returns the minimum clearance of a geometry, a measure of a geometrys robustness. |
| URX_PUBLIC.st_minimumclearanceline(geometry) | args: g - Returns the two-point LineString spanning a geometrys minimum clearance. |
| URX_PUBLIC.st_minpossiblevalue(pixeltype text) | |
| URX_PUBLIC.st_mlinefromtext(text) | args: WKT - Return a specified ST_MultiLineString value from WKT representation. |
| URX_PUBLIC.st_mlinefromtext(text, integer) | args: WKT, srid - Return a specified ST_MultiLineString value from WKT representation. |
| URX_PUBLIC.st_mlinefromwkb(bytea) | |
| URX_PUBLIC.st_mlinefromwkb(bytea, integer) | |
| URX_PUBLIC.st_mpointfromtext(text) | args: WKT - Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_mpointfromtext(text, integer) | args: WKT, srid - Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_mpointfromwkb(bytea) | |
| URX_PUBLIC.st_mpointfromwkb(bytea, integer) | |
| URX_PUBLIC.st_mpolyfromtext(text) | args: WKT - Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_mpolyfromtext(text, integer) | args: WKT, srid - Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_mpolyfromwkb(bytea) | |
| URX_PUBLIC.st_mpolyfromwkb(bytea, integer) | |
| URX_PUBLIC.st_multi(geometry) | args: g1 - Return the geometry as a MULTI* geometry. |
| URX_PUBLIC.st_multilinefromwkb(bytea) | |
| URX_PUBLIC.st_multilinestringfromtext(text) | |
| URX_PUBLIC.st_multilinestringfromtext(text, integer) | |
| URX_PUBLIC.st_multipointfromtext(text) | |
| URX_PUBLIC.st_multipointfromwkb(bytea) | |
| URX_PUBLIC.st_multipointfromwkb(bytea, integer) | |
| URX_PUBLIC.st_multipolyfromwkb(bytea) | |
| URX_PUBLIC.st_multipolyfromwkb(bytea, integer) | |
| URX_PUBLIC.st_multipolygonfromtext(text) | |
| URX_PUBLIC.st_multipolygonfromtext(text, integer) | |
| URX_PUBLIC.st_ndims(geometry) | args: g1 - Returns coordinate dimension of the geometry as a small int. Values are: 2,3 or 4. |
| URX_PUBLIC.st_nearestvalue(rast raster, band integer, columnx integer, rowy integer, exclude_nodata_value boolean) | args: rast, bandnum, columnx, rowy, exclude_nodata_value=true - Returns the nearest non-NODATA value of a given bands pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_nearestvalue(rast raster, band integer, pt geometry, exclude_nodata_value boolean) | args: rast, bandnum, pt, exclude_nodata_value=true - Returns the nearest non-NODATA value of a given bands pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_nearestvalue(rast raster, columnx integer, rowy integer, exclude_nodata_value boolean) | args: rast, columnx, rowy, exclude_nodata_value=true - Returns the nearest non-NODATA value of a given bands pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_nearestvalue(rast raster, pt geometry, exclude_nodata_value boolean) | args: rast, pt, exclude_nodata_value=true - Returns the nearest non-NODATA value of a given bands pixel specified by a columnx and rowy or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_neighborhood(rast raster, band integer, columnx integer, rowy integer, distancex integer, distancey integer, exclude_nodata_value boolean) | args: rast, bandnum, columnX, rowY, distanceX, distanceY, exclude_nodata_value=true - Returns a 2-D double precision array of the non-NODATA values around a given bands pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_neighborhood(rast raster, band integer, pt geometry, distancex integer, distancey integer, exclude_nodata_value boolean) | args: rast, bandnum, pt, distanceX, distanceY, exclude_nodata_value=true - Returns a 2-D double precision array of the non-NODATA values around a given bands pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_neighborhood(rast raster, columnx integer, rowy integer, distancex integer, distancey integer, exclude_nodata_value boolean) | args: rast, columnX, rowY, distanceX, distanceY, exclude_nodata_value=true - Returns a 2-D double precision array of the non-NODATA values around a given bands pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_neighborhood(rast raster, pt geometry, distancex integer, distancey integer, exclude_nodata_value boolean) | args: rast, pt, distanceX, distanceY, exclude_nodata_value=true - Returns a 2-D double precision array of the non-NODATA values around a given bands pixel specified by either a columnX and rowY or a geometric point expressed in the same spatial reference coordinate system as the raster. |
| URX_PUBLIC.st_node(geometry) | args: geom - Node a set of linestrings. |
| URX_PUBLIC.st_normalize(geom geometry) | args: geom - Return the geometry in its canonical form. |
| URX_PUBLIC.st_notsamealignmentreason(rast1 raster, rast2 raster) | args: rastA, rastB - Returns text stating if rasters are aligned and if not aligned, a reason why. |
| URX_PUBLIC.st_npoints(geometry) | args: g1 - Return the number of points (vertexes) in a geometry. |
| URX_PUBLIC.st_nrings(geometry) | args: geomA - If the geometry is a polygon or multi-polygon returns the number of rings. |
| URX_PUBLIC.st_numbands(raster) | args: rast - Returns the number of bands in the raster object. |
| URX_PUBLIC.st_numgeometries(geometry) | args: geom - If geometry is a GEOMETRYCOLLECTION (or MULTI*) return the number of geometries, for single geometries will return 1, otherwise return NULL. |
| URX_PUBLIC.st_numinteriorring(geometry) | args: a_polygon - Return the number of interior rings of a polygon in the geometry. Synonym for ST_NumInteriorRings. |
| URX_PUBLIC.st_numinteriorrings(geometry) | args: a_polygon - Return the number of interior rings of a polygon geometry. |
| URX_PUBLIC.st_numpatches(geometry) | args: g1 - Return the number of faces on a Polyhedral Surface. Will return null for non-polyhedral geometries. |
| URX_PUBLIC.st_numpoints(geometry) | args: g1 - Return the number of points in an ST_LineString or ST_CircularString value. |
| URX_PUBLIC.st_offsetcurve(line geometry, distance double precision, params text) | args: line, signed_distance, style_parameters=' - Return an offset line at a given distance and side from an input line. Useful for computing parallel lines about a center line |
| URX_PUBLIC.st_orderingequals(geometrya geometry, geometryb geometry) | args: A, B - Returns true if the given geometries represent the same geometry and points are in the same directional order. |
| URX_PUBLIC.st_overlaps(geom1 geometry, geom2 geometry) | args: A, B - Returns TRUE if the Geometries share space, are of the same dimension, but are not completely contained by each other. |
| URX_PUBLIC.st_overlaps(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if raster rastA and rastB intersect but one does not completely contain the other. |
| URX_PUBLIC.st_overlaps(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if raster rastA and rastB intersect but one does not completely contain the other. |
| URX_PUBLIC.st_patchn(geometry, integer) | args: geomA, n - Return the 1-based Nth geometry (face) if the geometry is a POLYHEDRALSURFACE, POLYHEDRALSURFACEM. Otherwise, return NULL. |
| URX_PUBLIC.st_perimeter(geog geography, use_spheroid boolean) | args: geog, use_spheroid=true - Return the length measurement of the boundary of an ST_Surface or ST_MultiSurface geometry or geography. (Polygon, Multipolygon). geometry measurement is in units of spatial reference and geography is in meters. |
| URX_PUBLIC.st_perimeter(geometry) | args: g1 - Return the length measurement of the boundary of an ST_Surface or ST_MultiSurface geometry or geography. (Polygon, Multipolygon). geometry measurement is in units of spatial reference and geography is in meters. |
| URX_PUBLIC.st_perimeter2d(geometry) | args: geomA - Returns the 2-dimensional perimeter of the geometry, if it is a polygon or multi-polygon. This is currently an alias for ST_Perimeter. |
| URX_PUBLIC.st_pixelascentroid(rast raster, x integer, y integer) | args: rast, x, y - Returns the centroid (point geometry) of the area represented by a pixel. |
| URX_PUBLIC.st_pixelascentroids(rast raster, band integer, exclude_nodata_value boolean) | args: rast, band=1, exclude_nodata_value=TRUE - Returns the centroid (point geometry) for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The point geometry is the centroid of the area represented by a pixel. |
| URX_PUBLIC.st_pixelaspoint(rast raster, x integer, y integer) | args: rast, columnx, rowy - Returns a point geometry of the pixels upper-left corner. |
| URX_PUBLIC.st_pixelaspoints(rast raster, band integer, exclude_nodata_value boolean) | args: rast, band=1, exclude_nodata_value=TRUE - Returns a point geometry for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The coordinates of the point geometry are of the pixels upper-left corner. |
| URX_PUBLIC.st_pixelaspolygon(rast raster, x integer, y integer) | args: rast, columnx, rowy - Returns the polygon geometry that bounds the pixel for a particular row and column. |
| URX_PUBLIC.st_pixelaspolygons(rast raster, band integer, exclude_nodata_value boolean) | args: rast, band=1, exclude_nodata_value=TRUE - Returns the polygon geometry that bounds every pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. |
| URX_PUBLIC.st_pixelheight(raster) | args: rast - Returns the pixel height in geometric units of the spatial reference system. |
| URX_PUBLIC.st_pixelofvalue(rast raster, nband integer, search double precision, exclude_nodata_value boolean) | args: rast, nband, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value. |
| URX_PUBLIC.st_pixelofvalue(rast raster, nband integer, search double precision[], exclude_nodata_value boolean) | args: rast, nband, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value. |
| URX_PUBLIC.st_pixelofvalue(rast raster, search double precision, exclude_nodata_value boolean) | args: rast, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value. |
| URX_PUBLIC.st_pixelofvalue(rast raster, search double precision[], exclude_nodata_value boolean) | args: rast, search, exclude_nodata_value=true - Get the columnx, rowy coordinates of the pixel whose value equals the search value. |
| URX_PUBLIC.st_pixelwidth(raster) | args: rast - Returns the pixel width in geometric units of the spatial reference system. |
| URX_PUBLIC.st_point(double precision, double precision) | args: x_lon, y_lat - Returns an ST_Point with the given coordinate values. OGC alias for ST_MakePoint. |
| URX_PUBLIC.st_point_inside_circle(geometry, double precision, double precision, double precision) | |
| URX_PUBLIC.st_pointfromgeohash(text, integer) | args: geohash, precision=full_precision_of_geohash - Return a point from a GeoHash string. |
| URX_PUBLIC.st_pointfromtext(text) | args: WKT - Makes a point Geometry from WKT with the given SRID. If SRID is not given, it defaults to unknown. |
| URX_PUBLIC.st_pointfromtext(text, integer) | args: WKT, srid - Makes a point Geometry from WKT with the given SRID. If SRID is not given, it defaults to unknown. |
| URX_PUBLIC.st_pointfromwkb(bytea) | |
| URX_PUBLIC.st_pointfromwkb(bytea, integer) | |
| URX_PUBLIC.st_pointinsidecircle(geometry, double precision, double precision, double precision) | args: a_point, center_x, center_y, radius - Is the point geometry inside the circle defined by center_x, center_y, radius |
| URX_PUBLIC.st_pointn(geometry, integer) | args: a_linestring, n - Return the Nth point in the first LineString or circular LineString in the geometry. Negative values are counted backwards from the end of the LineString. Returns NULL if there is no linestring in the geometry. |
| URX_PUBLIC.st_pointonsurface(geometry) | args: g1 - Returns a POINT guaranteed to lie on the surface. |
| URX_PUBLIC.st_points(geometry) | args: geom - Returns a MultiPoint containing all of the coordinates of a geometry. |
| URX_PUBLIC.st_polyfromtext(text) | |
| URX_PUBLIC.st_polyfromtext(text, integer) | |
| URX_PUBLIC.st_polyfromwkb(bytea) | |
| URX_PUBLIC.st_polyfromwkb(bytea, integer) | |
| URX_PUBLIC.st_polygon(geometry, integer) | args: aLineString, srid - Returns a polygon built from the specified linestring and SRID. |
| URX_PUBLIC.st_polygon(rast raster, band integer) | |
| URX_PUBLIC.st_polygonfromtext(text) | args: WKT - Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_polygonfromtext(text, integer) | args: WKT, srid - Makes a Geometry from WKT with the given SRID. If SRID is not given, it defaults to 0. |
| URX_PUBLIC.st_polygonfromwkb(bytea) | |
| URX_PUBLIC.st_polygonfromwkb(bytea, integer) | |
| URX_PUBLIC.st_polygonize(geometry) | args: geomfield - Aggregate. Creates a GeometryCollection containing possible polygons formed from the constituent linework of a set of geometries. |
| URX_PUBLIC.st_polygonize(geometry[]) | args: geom_array - Aggregate. Creates a GeometryCollection containing possible polygons formed from the constituent linework of a set of geometries. |
| URX_PUBLIC.st_project(geog geography, distance double precision, azimuth double precision) | args: g1, distance, azimuth - Returns a POINT projected from a start point using a distance in meters and bearing (azimuth) in radians. |
| URX_PUBLIC.st_quantile(rast raster, exclude_nodata_value boolean, quantile double precision) | args: rast, exclude_nodata_value, quantile=NULL - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rast raster, nband integer, exclude_nodata_value boolean, quantile double precision) | args: rast, nband, exclude_nodata_value, quantile - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rast raster, nband integer, exclude_nodata_value boolean, quantiles double precision[]) | args: rast, nband=1, exclude_nodata_value=true, quantiles=NULL - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rast raster, nband integer, quantile double precision) | args: rast, nband, quantile - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rast raster, nband integer, quantiles double precision[]) | args: rast, nband, quantiles - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rast raster, quantile double precision) | args: rast, quantile - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rast raster, quantiles double precision[]) | args: rast, quantiles - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, exclude_nodata_value boolean, quantile double precision) | |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, quantile double precision) | |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, quantiles double precision[]) | args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, quantiles=NULL - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, nband integer, quantile double precision) | |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, nband integer, quantiles double precision[]) | args: rastertable, rastercolumn, nband, quantiles - Compute quantiles for a raster or raster table coverage in the context of the sample or population. Thus, a value could be examined to be at the rasters 25%, 50%, 75% percentile. |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, quantile double precision) | |
| URX_PUBLIC.st_quantile(rastertable text, rastercolumn text, quantiles double precision[]) | |
| URX_PUBLIC.st_range4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_range4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_rastertoworldcoord(rast raster, columnx integer, rowy integer) | args: rast, xcolumn, yrow - Returns the rasters upper left corner as geometric X and Y (longitude and latitude) given a column and row. Column and row starts at 1. |
| URX_PUBLIC.st_rastertoworldcoordx(rast raster, xr integer) | args: rast, xcolumn - Returns the geometric X coordinate upper left of a raster, column and row. Numbering of columns and rows starts at 1. |
| URX_PUBLIC.st_rastertoworldcoordx(rast raster, xr integer, yr integer) | args: rast, xcolumn, yrow - Returns the geometric X coordinate upper left of a raster, column and row. Numbering of columns and rows starts at 1. |
| URX_PUBLIC.st_rastertoworldcoordy(rast raster, xr integer, yr integer) | args: rast, xcolumn, yrow - Returns the geometric Y coordinate upper left corner of a raster, column and row. Numbering of columns and rows starts at 1. |
| URX_PUBLIC.st_rastertoworldcoordy(rast raster, yr integer) | args: rast, yrow - Returns the geometric Y coordinate upper left corner of a raster, column and row. Numbering of columns and rows starts at 1. |
| URX_PUBLIC.st_reclass(rast raster, nband integer, reclassexpr text, pixeltype text, nodataval double precision) | |
| URX_PUBLIC.st_reclass(rast raster, reclassargset reclassarg[]) | |
| URX_PUBLIC.st_reclass(rast raster, reclassexpr text, pixeltype text) | |
| URX_PUBLIC.st_relate(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns true if this Geometry is spatially related to anotherGeometry, by testing for intersections between the Interior, Boundary and Exterior of the two geometries as specified by the values in the intersectionMatrixPattern. If no intersectionMatrixPattern is passed in, then returns the maximum intersectionMatrixPattern that relates the 2 geometries. |
| URX_PUBLIC.st_relate(geom1 geometry, geom2 geometry, integer) | args: geomA, geomB, BoundaryNodeRule - Returns true if this Geometry is spatially related to anotherGeometry, by testing for intersections between the Interior, Boundary and Exterior of the two geometries as specified by the values in the intersectionMatrixPattern. If no intersectionMatrixPattern is passed in, then returns the maximum intersectionMatrixPattern that relates the 2 geometries. |
| URX_PUBLIC.st_relate(geom1 geometry, geom2 geometry, text) | args: geomA, geomB, intersectionMatrixPattern - Returns true if this Geometry is spatially related to anotherGeometry, by testing for intersections between the Interior, Boundary and Exterior of the two geometries as specified by the values in the intersectionMatrixPattern. If no intersectionMatrixPattern is passed in, then returns the maximum intersectionMatrixPattern that relates the 2 geometries. |
| URX_PUBLIC.st_relatematch(text, text) | args: intersectionMatrix, intersectionMatrixPattern - Returns true if intersectionMattrixPattern1 implies intersectionMatrixPattern2 |
| URX_PUBLIC.st_removepoint(geometry, integer) | args: linestring, offset - Remove point from a linestring. |
| URX_PUBLIC.st_removerepeatedpoints(geom geometry, tolerance double precision) | args: geom, tolerance - Returns a version of the given geometry with duplicated points removed. |
| URX_PUBLIC.st_resample(rast raster, ref raster, algorithm text, maxerr double precision, usescale boolean) | args: rast, ref, algorithm=NearestNeighbour, maxerr=0.125, usescale=true - Resample a raster using a specified resampling algorithm, new dimensions, an arbitrary grid corner and a set of raster georeferencing attributes defined or borrowed from another raster. |
| URX_PUBLIC.st_resample(rast raster, ref raster, usescale boolean, algorithm text, maxerr double precision) | args: rast, ref, usescale, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster using a specified resampling algorithm, new dimensions, an arbitrary grid corner and a set of raster georeferencing attributes defined or borrowed from another raster. |
| URX_PUBLIC.st_resample(rast raster, scalex double precision, scaley double precision, gridx double precision, gridy double precision, skewx double precision, skewy double precision, algorithm text, maxerr double precision) | args: rast, scalex=0, scaley=0, gridx=NULL, gridy=NULL, skewx=0, skewy=0, algorithm=NearestNeighbor, maxerr=0.125 - Resample a raster using a specified resampling algorithm, new dimensions, an arbitrary grid corner and a set of raster georeferencing attributes defined or borrowed from another raster. |
| URX_PUBLIC.st_resample(rast raster, width integer, height integer, gridx double precision, gridy double precision, skewx double precision, skewy double precision, algorithm text, maxerr double precision) | args: rast, width, height, gridx=NULL, gridy=NULL, skewx=0, skewy=0, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster using a specified resampling algorithm, new dimensions, an arbitrary grid corner and a set of raster georeferencing attributes defined or borrowed from another raster. |
| URX_PUBLIC.st_rescale(rast raster, scalex double precision, scaley double precision, algorithm text, maxerr double precision) | args: rast, scalex, scaley, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by adjusting only its scale (or pixel size). New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_rescale(rast raster, scalexy double precision, algorithm text, maxerr double precision) | args: rast, scalexy, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by adjusting only its scale (or pixel size). New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_resize(rast raster, percentwidth double precision, percentheight double precision, algorithm text, maxerr double precision) | args: rast, percentwidth, percentheight, algorithm=NearestNeighbor, maxerr=0.125 - Resize a raster to a new width/height |
| URX_PUBLIC.st_resize(rast raster, width integer, height integer, algorithm text, maxerr double precision) | args: rast, width, height, algorithm=NearestNeighbor, maxerr=0.125 - Resize a raster to a new width/height |
| URX_PUBLIC.st_resize(rast raster, width text, height text, algorithm text, maxerr double precision) | args: rast, width, height, algorithm=NearestNeighbor, maxerr=0.125 - Resize a raster to a new width/height |
| URX_PUBLIC.st_reskew(rast raster, skewx double precision, skewy double precision, algorithm text, maxerr double precision) | args: rast, skewx, skewy, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by adjusting only its skew (or rotation parameters). New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_reskew(rast raster, skewxy double precision, algorithm text, maxerr double precision) | args: rast, skewxy, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by adjusting only its skew (or rotation parameters). New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_retile(tab regclass, col name, ext geometry, sfx double precision, sfy double precision, tw integer, th integer, algo text) | args: tab, col, ext, sfx, sfy, tw, th, algo='NearestNeighbor' - Return a set of configured tiles from an arbitrarily tiled raster coverage. |
| URX_PUBLIC.st_reverse(geometry) | args: g1 - Return the geometry with vertex order reversed. |
| URX_PUBLIC.st_rotate(geometry, double precision) | args: geomA, rotRadians - Rotate a geometry rotRadians counter-clockwise about an origin. |
| URX_PUBLIC.st_rotate(geometry, double precision, double precision, double precision) | args: geomA, rotRadians, x0, y0 - Rotate a geometry rotRadians counter-clockwise about an origin. |
| URX_PUBLIC.st_rotate(geometry, double precision, geometry) | args: geomA, rotRadians, pointOrigin - Rotate a geometry rotRadians counter-clockwise about an origin. |
| URX_PUBLIC.st_rotatex(geometry, double precision) | args: geomA, rotRadians - Rotate a geometry rotRadians about the X axis. |
| URX_PUBLIC.st_rotatey(geometry, double precision) | args: geomA, rotRadians - Rotate a geometry rotRadians about the Y axis. |
| URX_PUBLIC.st_rotatez(geometry, double precision) | args: geomA, rotRadians - Rotate a geometry rotRadians about the Z axis. |
| URX_PUBLIC.st_rotation(raster) | args: rast - Returns the rotation of the raster in radian. |
| URX_PUBLIC.st_roughness(rast raster, nband integer, customextent raster, pixeltype text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_roughness(rast raster, nband integer, pixeltype text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_samealignment(rast1 raster, rast2 raster) | args: rastA, rastB - Returns true if rasters have same skew, scale, spatial ref, and offset (pixels can be put on same grid without cutting into pixels) and false if they dont with notice detailing issue. |
| URX_PUBLIC.st_samealignment(raster) | args: rastfield - Returns true if rasters have same skew, scale, spatial ref, and offset (pixels can be put on same grid without cutting into pixels) and false if they dont with notice detailing issue. |
| URX_PUBLIC.st_samealignment(ulx1 double precision, uly1 double precision, scalex1 double precision, scaley1 double precision, skewx1 double precision, skewy1 double precision, ulx2 double precision, uly2 double precision, scalex2 double precision, scaley2 double precision, skewx2 double precision, skewy2 double precision) | args: ulx1, uly1, scalex1, scaley1, skewx1, skewy1, ulx2, uly2, scalex2, scaley2, skewx2, skewy2 - Returns true if rasters have same skew, scale, spatial ref, and offset (pixels can be put on same grid without cutting into pixels) and false if they dont with notice detailing issue. |
| URX_PUBLIC.st_scale(geometry, double precision, double precision) | args: geomA, XFactor, YFactor - Scale a geometry by given factors. |
| URX_PUBLIC.st_scale(geometry, double precision, double precision, double precision) | args: geomA, XFactor, YFactor, ZFactor - Scale a geometry by given factors. |
| URX_PUBLIC.st_scale(geometry, geometry) | args: geom, factor - Scale a geometry by given factors. |
| URX_PUBLIC.st_scalex(raster) | args: rast - Returns the X component of the pixel width in units of coordinate reference system. |
| URX_PUBLIC.st_scaley(raster) | args: rast - Returns the Y component of the pixel height in units of coordinate reference system. |
| URX_PUBLIC.st_segmentize(geog geography, max_segment_length double precision) | args: geog, max_segment_length - Return a modified geometry/geography having no segment longer than the given distance. |
| URX_PUBLIC.st_segmentize(geometry, double precision) | args: geom, max_segment_length - Return a modified geometry/geography having no segment longer than the given distance. |
| URX_PUBLIC.st_setbandisnodata(rast raster, band integer) | args: rast, band=1 - Sets the isnodata flag of the band to TRUE. |
| URX_PUBLIC.st_setbandnodatavalue(rast raster, band integer, nodatavalue double precision, forcechecking boolean) | args: rast, band, nodatavalue, forcechecking=false - Sets the value for the given band that represents no data. Band 1 is assumed if no band is specified. To mark a band as having no nodata value, set the nodata value = NULL. |
| URX_PUBLIC.st_setbandnodatavalue(rast raster, nodatavalue double precision) | args: rast, nodatavalue - Sets the value for the given band that represents no data. Band 1 is assumed if no band is specified. To mark a band as having no nodata value, set the nodata value = NULL. |
| URX_PUBLIC.st_seteffectivearea(geometry, double precision, integer) | args: geomA, threshold = 0, set_area = 1 - Sets the effective area for each vertex, storing the value in the M ordinate. A simplified geometry can then be generated by filtering on the M ordinate. |
| URX_PUBLIC.st_setgeoreference(rast raster, georef text, format text) | args: rast, georefcoords, format=GDAL - Set Georeference 6 georeference parameters in a single call. Numbers should be separated by white space. Accepts inputs in GDAL or ESRI format. Default is GDAL. |
| URX_PUBLIC.st_setgeoreference(rast raster, upperleftx double precision, upperlefty double precision, scalex double precision, scaley double precision, skewx double precision, skewy double precision) | args: rast, upperleftx, upperlefty, scalex, scaley, skewx, skewy - Set Georeference 6 georeference parameters in a single call. Numbers should be separated by white space. Accepts inputs in GDAL or ESRI format. Default is GDAL. |
| URX_PUBLIC.st_setgeotransform(rast raster, imag double precision, jmag double precision, theta_i double precision, theta_ij double precision, xoffset double precision, yoffset double precision) | |
| URX_PUBLIC.st_setpoint(geometry, integer, geometry) | args: linestring, zerobasedposition, point - Replace point of a linestring with a given point. |
| URX_PUBLIC.st_setrotation(rast raster, rotation double precision) | args: rast, rotation - Set the rotation of the raster in radian. |
| URX_PUBLIC.st_setscale(rast raster, scale double precision) | args: rast, xy - Sets the X and Y size of pixels in units of coordinate reference system. Number units/pixel width/height. |
| URX_PUBLIC.st_setscale(rast raster, scalex double precision, scaley double precision) | args: rast, x, y - Sets the X and Y size of pixels in units of coordinate reference system. Number units/pixel width/height. |
| URX_PUBLIC.st_setskew(rast raster, skew double precision) | args: rast, skewxy - Sets the georeference X and Y skew (or rotation parameter). If only one is passed in, sets X and Y to the same value. |
| URX_PUBLIC.st_setskew(rast raster, skewx double precision, skewy double precision) | args: rast, skewx, skewy - Sets the georeference X and Y skew (or rotation parameter). If only one is passed in, sets X and Y to the same value. |
| URX_PUBLIC.st_setsrid(geog geography, srid integer) | |
| URX_PUBLIC.st_setsrid(geometry, integer) | args: geom, srid - Set the SRID on a geometry to a particular integer value. |
| URX_PUBLIC.st_setsrid(rast raster, srid integer) | args: rast, srid - Sets the SRID of a raster to a particular integer srid defined in the spatial_ref_sys table. |
| URX_PUBLIC.st_setupperleft(rast raster, upperleftx double precision, upperlefty double precision) | args: rast, x, y - Sets the value of the upper left corner of the pixel of the raster to projected X and Y coordinates. |
| URX_PUBLIC.st_setvalue(rast raster, band integer, x integer, y integer, newvalue double precision) | args: rast, bandnum, columnx, rowy, newvalue - Returns modified raster resulting from setting the value of a given band in a given columnx, rowy pixel or the pixels that intersect a particular geometry. Band numbers start at 1 and assumed to be 1 if not specified. |
| URX_PUBLIC.st_setvalue(rast raster, geom geometry, newvalue double precision) | args: rast, geom, newvalue - Returns modified raster resulting from setting the value of a given band in a given columnx, rowy pixel or the pixels that intersect a particular geometry. Band numbers start at 1 and assumed to be 1 if not specified. |
| URX_PUBLIC.st_setvalue(rast raster, nband integer, geom geometry, newvalue double precision) | args: rast, bandnum, geom, newvalue - Returns modified raster resulting from setting the value of a given band in a given columnx, rowy pixel or the pixels that intersect a particular geometry. Band numbers start at 1 and assumed to be 1 if not specified. |
| URX_PUBLIC.st_setvalue(rast raster, x integer, y integer, newvalue double precision) | args: rast, columnx, rowy, newvalue - Returns modified raster resulting from setting the value of a given band in a given columnx, rowy pixel or the pixels that intersect a particular geometry. Band numbers start at 1 and assumed to be 1 if not specified. |
| URX_PUBLIC.st_setvalues(rast raster, nband integer, geomvalset geomval[], keepnodata boolean) | args: rast, nband, geomvalset, keepnodata=FALSE - Returns modified raster resulting from setting the values of a given band. |
| URX_PUBLIC.st_setvalues(rast raster, nband integer, x integer, y integer, newvalueset double precision[], noset boolean[], keepnodata boolean) | args: rast, nband, columnx, rowy, newvalueset, noset=NULL, keepnodata=FALSE - Returns modified raster resulting from setting the values of a given band. |
| URX_PUBLIC.st_setvalues(rast raster, nband integer, x integer, y integer, newvalueset double precision[], nosetvalue double precision, keepnodata boolean) | args: rast, nband, columnx, rowy, newvalueset, nosetvalue, keepnodata=FALSE - Returns modified raster resulting from setting the values of a given band. |
| URX_PUBLIC.st_setvalues(rast raster, nband integer, x integer, y integer, width integer, height integer, newvalue double precision, keepnodata boolean) | args: rast, nband, columnx, rowy, width, height, newvalue, keepnodata=FALSE - Returns modified raster resulting from setting the values of a given band. |
| URX_PUBLIC.st_setvalues(rast raster, x integer, y integer, width integer, height integer, newvalue double precision, keepnodata boolean) | args: rast, columnx, rowy, width, height, newvalue, keepnodata=FALSE - Returns modified raster resulting from setting the values of a given band. |
| URX_PUBLIC.st_sharedpaths(geom1 geometry, geom2 geometry) | args: lineal1, lineal2 - Returns a collection containing paths shared by the two input linestrings/multilinestrings. |
| URX_PUBLIC.st_shift_longitude(geometry) | |
| URX_PUBLIC.st_shiftlongitude(geometry) | args: geomA - Toggle geometry coordinates between -180..180 and 0..360 ranges. |
| URX_PUBLIC.st_shortestline(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns the 2-dimensional shortest line between two geometries |
| URX_PUBLIC.st_simplify(geometry, double precision) | |
| URX_PUBLIC.st_simplify(geometry, double precision, boolean) | args: geomA, tolerance, preserveCollapsed - Returns a "simplified" version of the given geometry using the Douglas-Peucker algorithm. |
| URX_PUBLIC.st_simplifypreservetopology(geometry, double precision) | args: geomA, tolerance - Returns a "simplified" version of the given geometry using the Douglas-Peucker algorithm. Will avoid creating derived geometries (polygons in particular) that are invalid. |
| URX_PUBLIC.st_simplifyvw(geometry, double precision) | args: geomA, tolerance - Returns a "simplified" version of the given geometry using the Visvalingam-Whyatt algorithm |
| URX_PUBLIC.st_skewx(raster) | args: rast - Returns the georeference X skew (or rotation parameter). |
| URX_PUBLIC.st_skewy(raster) | args: rast - Returns the georeference Y skew (or rotation parameter). |
| URX_PUBLIC.st_slope(rast raster, nband integer, customextent raster, pixeltype text, units text, scale double precision, interpolate_nodata boolean) | |
| URX_PUBLIC.st_slope(rast raster, nband integer, pixeltype text, units text, scale double precision, interpolate_nodata boolean) | |
| URX_PUBLIC.st_snap(geom1 geometry, geom2 geometry, double precision) | args: input, reference, tolerance - Snap segments and vertices of input geometry to vertices of a reference geometry. |
| URX_PUBLIC.st_snaptogrid(geom1 geometry, geom2 geometry, double precision, double precision, double precision, double precision) | args: geomA, pointOrigin, sizeX, sizeY, sizeZ, sizeM - Snap all points of the input geometry to a regular grid. |
| URX_PUBLIC.st_snaptogrid(geometry, double precision) | args: geomA, size - Snap all points of the input geometry to a regular grid. |
| URX_PUBLIC.st_snaptogrid(geometry, double precision, double precision) | args: geomA, sizeX, sizeY - Snap all points of the input geometry to a regular grid. |
| URX_PUBLIC.st_snaptogrid(geometry, double precision, double precision, double precision, double precision) | args: geomA, originX, originY, sizeX, sizeY - Snap all points of the input geometry to a regular grid. |
| URX_PUBLIC.st_snaptogrid(rast raster, gridx double precision, gridy double precision, algorithm text, maxerr double precision, scalex double precision, scaley double precision) | args: rast, gridx, gridy, algorithm=NearestNeighbour, maxerr=0.125, scalex=DEFAULT 0, scaley=DEFAULT 0 - Resample a raster by snapping it to a grid. New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_snaptogrid(rast raster, gridx double precision, gridy double precision, scalex double precision, scaley double precision, algorithm text, maxerr double precision) | args: rast, gridx, gridy, scalex, scaley, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by snapping it to a grid. New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_snaptogrid(rast raster, gridx double precision, gridy double precision, scalexy double precision, algorithm text, maxerr double precision) | args: rast, gridx, gridy, scalexy, algorithm=NearestNeighbour, maxerr=0.125 - Resample a raster by snapping it to a grid. New pixel values are computed using the NearestNeighbor (english or american spelling), Bilinear, Cubic, CubicSpline or Lanczos resampling algorithm. Default is NearestNeighbor. |
| URX_PUBLIC.st_split(geom1 geometry, geom2 geometry) | args: input, blade - Returns a collection of geometries resulting by splitting a geometry. |
| URX_PUBLIC.st_srid(geog geography) | |
| URX_PUBLIC.st_srid(geometry) | args: g1 - Returns the spatial reference identifier for the ST_Geometry as defined in spatial_ref_sys table. |
| URX_PUBLIC.st_srid(raster) | args: rast - Returns the spatial reference identifier of the raster as defined in spatial_ref_sys table. |
| URX_PUBLIC.st_startpoint(geometry) | args: geomA - Returns the first point of a LINESTRING geometry as a POINT. |
| URX_PUBLIC.st_stddev4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_stddev4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_subdivide(geom geometry, maxvertices integer) | args: geom, max_vertices=256 - Returns a set of geometry where no geometry in the set has more than the specified number of vertices. |
| URX_PUBLIC.st_sum4ma(matrix double precision[], nodatamode text, args text[]) | |
| URX_PUBLIC.st_sum4ma(value double precision[], pos integer[], userargs text[]) | |
| URX_PUBLIC.st_summary(geography) | args: g - Returns a text summary of the contents of the geometry. |
| URX_PUBLIC.st_summary(geometry) | args: g - Returns a text summary of the contents of the geometry. |
| URX_PUBLIC.st_summary(rast raster) | args: rast - Returns a text summary of the contents of the raster. |
| URX_PUBLIC.st_summarystats(rast raster, exclude_nodata_value boolean) | args: rast, exclude_nodata_value - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_summarystats(rast raster, nband integer, exclude_nodata_value boolean) | args: rast, nband, exclude_nodata_value - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_summarystats(rastertable text, rastercolumn text, exclude_nodata_value boolean) | args: rastertable, rastercolumn, exclude_nodata_value - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_summarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean) | args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true - Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a raster or raster coverage. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_summarystatsagg(raster, boolean, double precision) | args: rast, exclude_nodata_value, sample_percent - Aggregate. Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a set of raster. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_summarystatsagg(raster, integer, boolean) | args: rast, nband, exclude_nodata_value - Aggregate. Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a set of raster. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_summarystatsagg(raster, integer, boolean, double precision) | args: rast, nband, exclude_nodata_value, sample_percent - Aggregate. Returns summarystats consisting of count, sum, mean, stddev, min, max for a given raster band of a set of raster. Band 1 is assumed is no band is specified. |
| URX_PUBLIC.st_swapordinates(geom geometry, ords cstring) | args: geom, ords - Returns a version of the given geometry with given ordinate values swapped. |
| URX_PUBLIC.st_symdifference(geom1 geometry, geom2 geometry) | args: geomA, geomB - Returns a geometry that represents the portions of A and B that do not intersect. It is called a symmetric difference because ST_SymDifference(A,B) = ST_SymDifference(B,A). |
| URX_PUBLIC.st_symmetricdifference(geom1 geometry, geom2 geometry) | |
| URX_PUBLIC.st_tile(rast raster, nband integer, width integer, height integer, padwithnodata boolean, nodataval double precision) | args: rast, nband, width, height, padwithnodata=FALSE, nodataval=NULL - Returns a set of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters. |
| URX_PUBLIC.st_tile(rast raster, nband integer[], width integer, height integer, padwithnodata boolean, nodataval double precision) | args: rast, nband, width, height, padwithnodata=FALSE, nodataval=NULL - Returns a set of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters. |
| URX_PUBLIC.st_tile(rast raster, width integer, height integer, padwithnodata boolean, nodataval double precision) | args: rast, width, height, padwithnodata=FALSE, nodataval=NULL - Returns a set of rasters resulting from the split of the input raster based upon the desired dimensions of the output rasters. |
| URX_PUBLIC.st_touches(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns TRUE if the geometries have at least one point in common, but their interiors do not intersect. |
| URX_PUBLIC.st_touches(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if raster rastA and rastB have at least one point in common but their interiors do not intersect. |
| URX_PUBLIC.st_touches(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if raster rastA and rastB have at least one point in common but their interiors do not intersect. |
| URX_PUBLIC.st_tpi(rast raster, nband integer, customextent raster, pixeltype text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_tpi(rast raster, nband integer, pixeltype text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_transform(geom geometry, from_proj text, to_proj text) | args: geom, from_proj, to_proj - Return a new geometry with its coordinates transformed to a different spatial reference. |
| URX_PUBLIC.st_transform(geom geometry, from_proj text, to_srid integer) | args: geom, from_proj, to_srid - Return a new geometry with its coordinates transformed to a different spatial reference. |
| URX_PUBLIC.st_transform(geom geometry, to_proj text) | args: geom, to_proj - Return a new geometry with its coordinates transformed to a different spatial reference. |
| URX_PUBLIC.st_transform(geometry, integer) | args: g1, srid - Return a new geometry with its coordinates transformed to a different spatial reference. |
| URX_PUBLIC.st_transform(rast raster, alignto raster, algorithm text, maxerr double precision) | args: rast, alignto, algorithm=NearestNeighbor, maxerr=0.125 - Reprojects a raster in a known spatial reference system to another known spatial reference system using specified resampling algorithm. Options are NearestNeighbor, Bilinear, Cubic, CubicSpline, Lanczos defaulting to NearestNeighbor. |
| URX_PUBLIC.st_transform(rast raster, srid integer, algorithm text, maxerr double precision, scalex double precision, scaley double precision) | args: rast, srid, algorithm=NearestNeighbor, maxerr=0.125, scalex, scaley - Reprojects a raster in a known spatial reference system to another known spatial reference system using specified resampling algorithm. Options are NearestNeighbor, Bilinear, Cubic, CubicSpline, Lanczos defaulting to NearestNeighbor. |
| URX_PUBLIC.st_transform(rast raster, srid integer, scalex double precision, scaley double precision, algorithm text, maxerr double precision) | args: rast, srid, scalex, scaley, algorithm=NearestNeighbor, maxerr=0.125 - Reprojects a raster in a known spatial reference system to another known spatial reference system using specified resampling algorithm. Options are NearestNeighbor, Bilinear, Cubic, CubicSpline, Lanczos defaulting to NearestNeighbor. |
| URX_PUBLIC.st_transform(rast raster, srid integer, scalexy double precision, algorithm text, maxerr double precision) | |
| URX_PUBLIC.st_translate(geometry, double precision, double precision) | args: g1, deltax, deltay - Translate a geometry by given offsets. |
| URX_PUBLIC.st_translate(geometry, double precision, double precision, double precision) | args: g1, deltax, deltay, deltaz - Translate a geometry by given offsets. |
| URX_PUBLIC.st_transscale(geometry, double precision, double precision, double precision, double precision) | args: geomA, deltaX, deltaY, XFactor, YFactor - Translate a geometry by given factors and offsets. |
| URX_PUBLIC.st_tri(rast raster, nband integer, customextent raster, pixeltype text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_tri(rast raster, nband integer, pixeltype text, interpolate_nodata boolean) | |
| URX_PUBLIC.st_unaryunion(geometry) | args: geom - Like ST_Union, but working at the geometry component level. |
| URX_PUBLIC.st_union(geom1 geometry, geom2 geometry) | args: g1, g2 - Returns a geometry that represents the point set union of the Geometries. |
| URX_PUBLIC.st_union(geometry) | args: g1field - Returns a geometry that represents the point set union of the Geometries. |
| URX_PUBLIC.st_union(geometry[]) | args: g1_array - Returns a geometry that represents the point set union of the Geometries. |
| URX_PUBLIC.st_union(raster) | |
| URX_PUBLIC.st_union(raster, integer) | |
| URX_PUBLIC.st_union(raster, integer, text) | |
| URX_PUBLIC.st_union(raster, text) | |
| URX_PUBLIC.st_union(raster, unionarg[]) | |
| URX_PUBLIC.st_upperleftx(raster) | args: rast - Returns the upper left X coordinate of raster in projected spatial ref. |
| URX_PUBLIC.st_upperlefty(raster) | args: rast - Returns the upper left Y coordinate of raster in projected spatial ref. |
| URX_PUBLIC.st_value(rast raster, band integer, pt geometry, exclude_nodata_value boolean) | args: rast, band, pt, exclude_nodata_value=true - Returns the value of a given band in a given columnx, rowy pixel or at a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified. If exclude_nodata_value is set to false, then all pixels include nodata pixels are considered to intersect and return value. If exclude_nodata_value is not passed in then reads it from metadata of raster. |
| URX_PUBLIC.st_value(rast raster, band integer, x integer, y integer, exclude_nodata_value boolean) | args: rast, band, x, y, exclude_nodata_value=true - Returns the value of a given band in a given columnx, rowy pixel or at a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified. If exclude_nodata_value is set to false, then all pixels include nodata pixels are considered to intersect and return value. If exclude_nodata_value is not passed in then reads it from metadata of raster. |
| URX_PUBLIC.st_value(rast raster, pt geometry, exclude_nodata_value boolean) | args: rast, pt, exclude_nodata_value=true - Returns the value of a given band in a given columnx, rowy pixel or at a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified. If exclude_nodata_value is set to false, then all pixels include nodata pixels are considered to intersect and return value. If exclude_nodata_value is not passed in then reads it from metadata of raster. |
| URX_PUBLIC.st_value(rast raster, x integer, y integer, exclude_nodata_value boolean) | args: rast, x, y, exclude_nodata_value=true - Returns the value of a given band in a given columnx, rowy pixel or at a particular geometric point. Band numbers start at 1 and assumed to be 1 if not specified. If exclude_nodata_value is set to false, then all pixels include nodata pixels are considered to intersect and return value. If exclude_nodata_value is not passed in then reads it from metadata of raster. |
| URX_PUBLIC.st_valuecount(rast raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) | args: rast, nband, exclude_nodata_value, searchvalue, roundto=0 - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) | args: rast, nband=1, exclude_nodata_value=true, searchvalues=NULL, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rast raster, nband integer, searchvalue double precision, roundto double precision) | args: rast, nband, searchvalue, roundto=0 - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rast raster, nband integer, searchvalues double precision[], roundto double precision) | args: rast, nband, searchvalues, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rast raster, searchvalue double precision, roundto double precision) | args: rast, searchvalue, roundto=0 - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rast raster, searchvalues double precision[], roundto double precision) | args: rast, searchvalues, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) | args: rastertable, rastercolumn, nband, exclude_nodata_value, searchvalue, roundto=0 - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) | args: rastertable, rastercolumn, nband=1, exclude_nodata_value=true, searchvalues=NULL, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision) | args: rastertable, rastercolumn, nband, searchvalue, roundto=0 - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision) | args: rastertable, rastercolumn, nband, searchvalues, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision) | args: rastertable, rastercolumn, searchvalue, roundto=0 - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuecount(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision) | args: rastertable, rastercolumn, searchvalues, roundto=0, OUT value, OUT count - Returns a set of records containing a pixel band value and count of the number of pixels in a given band of a raster (or a raster coverage) that have a given set of values. If no band is specified defaults to band 1. By default nodata value pixels are not counted. and all other values in the pixel are output and pixel band values are rounded to the nearest integer. |
| URX_PUBLIC.st_valuepercent(rast raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rast raster, nband integer, searchvalue double precision, roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rast raster, nband integer, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rast raster, searchvalue double precision, roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rast raster, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision) | |
| URX_PUBLIC.st_valuepercent(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision) | |
| URX_PUBLIC.st_voronoilines(g1 geometry, tolerance double precision, extend_to geometry) | args: g1, tolerance, extend_to - Returns the boundaries between the cells of the Voronoi diagram constructed from the vertices of a geometry. |
| URX_PUBLIC.st_voronoipolygons(g1 geometry, tolerance double precision, extend_to geometry) | args: g1, tolerance, extend_to - Returns the cells of the Voronoi diagram constructed from the vertices of a geometry. |
| URX_PUBLIC.st_width(raster) | args: rast - Returns the width of the raster in pixels. |
| URX_PUBLIC.st_within(geom1 geometry, geom2 geometry) | args: A, B - Returns true if the geometry A is completely inside geometry B |
| URX_PUBLIC.st_within(rast1 raster, nband1 integer, rast2 raster, nband2 integer) | args: rastA, nbandA, rastB, nbandB - Return true if no points of raster rastA lie in the exterior of raster rastB and at least one point of the interior of rastA lies in the interior of rastB. |
| URX_PUBLIC.st_within(rast1 raster, rast2 raster) | args: rastA, rastB - Return true if no points of raster rastA lie in the exterior of raster rastB and at least one point of the interior of rastA lies in the interior of rastB. |
| URX_PUBLIC.st_wkbtosql(wkb bytea) | args: WKB - Return a specified ST_Geometry value from Well-Known Binary representation (WKB). This is an alias name for ST_GeomFromWKB that takes no srid |
| URX_PUBLIC.st_wkttosql(text) | args: WKT - Return a specified ST_Geometry value from Well-Known Text representation (WKT). This is an alias name for ST_GeomFromText |
| URX_PUBLIC.st_worldtorastercoord(rast raster, longitude double precision, latitude double precision) | args: rast, longitude, latitude - Returns the upper left corner as column and row given geometric X and Y (longitude and latitude) or a point geometry expressed in the spatial reference coordinate system of the raster. |
| URX_PUBLIC.st_worldtorastercoord(rast raster, pt geometry) | args: rast, pt - Returns the upper left corner as column and row given geometric X and Y (longitude and latitude) or a point geometry expressed in the spatial reference coordinate system of the raster. |
| URX_PUBLIC.st_worldtorastercoordx(rast raster, pt geometry) | args: rast, pt - Returns the column in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster. |
| URX_PUBLIC.st_worldtorastercoordx(rast raster, xw double precision) | args: rast, xw - Returns the column in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster. |
| URX_PUBLIC.st_worldtorastercoordx(rast raster, xw double precision, yw double precision) | args: rast, xw, yw - Returns the column in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster. |
| URX_PUBLIC.st_worldtorastercoordy(rast raster, pt geometry) | args: rast, pt - Returns the row in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster. |
| URX_PUBLIC.st_worldtorastercoordy(rast raster, xw double precision, yw double precision) | args: rast, xw, yw - Returns the row in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster. |
| URX_PUBLIC.st_worldtorastercoordy(rast raster, yw double precision) | args: rast, xw - Returns the row in the raster of the point geometry (pt) or a X and Y world coordinate (xw, yw) represented in world spatial reference system of raster. |
| URX_PUBLIC.st_wrapx(geom geometry, wrap double precision, move double precision) | args: geom, wrap, move - Wrap a geometry around an X value. |
| URX_PUBLIC.st_x(geometry) | args: a_point - Return the X coordinate of the point, or NULL if not available. Input must be a point. |
| URX_PUBLIC.st_xmax(box3d) | args: aGeomorBox2DorBox3D - Returns X maxima of a bounding box 2d or 3d or a geometry. |
| URX_PUBLIC.st_xmin(box3d) | args: aGeomorBox2DorBox3D - Returns X minima of a bounding box 2d or 3d or a geometry. |
| URX_PUBLIC.st_y(geometry) | args: a_point - Return the Y coordinate of the point, or NULL if not available. Input must be a point. |
| URX_PUBLIC.st_ymax(box3d) | args: aGeomorBox2DorBox3D - Returns Y maxima of a bounding box 2d or 3d or a geometry. |
| URX_PUBLIC.st_ymin(box3d) | args: aGeomorBox2DorBox3D - Returns Y minima of a bounding box 2d or 3d or a geometry. |
| URX_PUBLIC.st_z(geometry) | args: a_point - Return the Z coordinate of the point, or NULL if not available. Input must be a point. |
| URX_PUBLIC.st_zmax(box3d) | args: aGeomorBox2DorBox3D - Returns Z minima of a bounding box 2d or 3d or a geometry. |
| URX_PUBLIC.st_zmflag(geometry) | args: geomA - Returns ZM (dimension semantic) flag of the geometries as a small int. Values are: 0=2d, 1=3dm, 2=3dz, 3=4d. |
| URX_PUBLIC.st_zmin(box3d) | args: aGeomorBox2DorBox3D - Returns Z minima of a bounding box 2d or 3d or a geometry. |
| URX_PUBLIC.text(geometry) | |
| URX_PUBLIC.unlockrows(text) | args: auth_token - Remove all locks held by specified authorization id. Returns the number of locks released. |
| URX_PUBLIC.updategeometrysrid(catalogn_name character varying, schema_name character varying, table_name character varying, column_name character varying, new_srid_in integer) | args: catalog_name, schema_name, table_name, column_name, srid - Updates the SRID of all features in a geometry column, geometry_columns metadata and srid. If it was enforced with constraints, the constraints will be updated with new srid constraint. If the old was enforced by type definition, the type definition will be changed. |
| URX_PUBLIC.updategeometrysrid(character varying, character varying, character varying, integer) | args: schema_name, table_name, column_name, srid - Updates the SRID of all features in a geometry column, geometry_columns metadata and srid. If it was enforced with constraints, the constraints will be updated with new srid constraint. If the old was enforced by type definition, the type definition will be changed. |
| URX_PUBLIC.updategeometrysrid(character varying, character varying, integer) | args: table_name, column_name, srid - Updates the SRID of all features in a geometry column, geometry_columns metadata and srid. If it was enforced with constraints, the constraints will be updated with new srid constraint. If the old was enforced by type definition, the type definition will be changed. |
| URX_PUBLIC.updaterastersrid(schema_name name, table_name name, column_name name, new_srid integer) | args: schema_name, table_name, column_name, new_srid - Change the SRID of all rasters in the user-specified column and table. |
| URX_PUBLIC.updaterastersrid(table_name name, column_name name, new_srid integer) | args: table_name, column_name, new_srid - Change the SRID of all rasters in the user-specified column and table. |