filter_by_area_geometry
- filter_by_area_geometry(
table_name: string,
view_name: string | undefined,
column_name: string,
x_vector: number[],
y_vector: number[],
options?: Record<string, string>,
callback?: GPUdbCallback,
): Promise<FilterByAreaGeometryResponse>Parameters
- table_name: string
Name of the table to filter, in [schema_name.]table_name format, using standard name resolution rules. This may be the name of a table or a view (when chaining queries).
- view_name: string | undefined
If provided, then this will be the name of the view containing the results, in [schema_name.]view_name format, using standard name resolution rules and meeting table naming criteria. Must not be an already existing table or view.
- column_name: string
Name of the geospatial geometry column to be filtered.
- x_vector: number[]
List of x coordinates of the vertices of the polygon representing the area to be filtered.
- y_vector: number[]
List of y coordinates of the vertices of the polygon representing the area to be filtered.
Optionaloptions: Record<string, string>Optional parameters.
Optionalcallback: GPUdbCallbackOptional callback function
Returns Promise<FilterByAreaGeometryResponse>
Promise<Types.FilterByAreaGeometryResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:9030
- table_name: string
filter_by_area_geometry_request
- filter_by_area_geometry_request(
request: FilterByAreaGeometryRequest,
callback?: GPUdbCallback,
): Promise<FilterByAreaGeometryResponse>Calculates which geospatial geometry objects from a table intersect a named area of interest (NAI/polygon). The operation is synchronous, meaning that a response will not be returned until all the matching objects are fully available. The response payload provides the count of the resulting set. A new resultant set (view) which satisfies the input NAI restriction specification is created with the name
view_namepassed in as part of the input.Parameters
- request: FilterByAreaGeometryRequest
Request object containing the parameters for the operation
Optionalcallback: GPUdbCallbackOptional callback function
Returns Promise<FilterByAreaGeometryResponse>
Promise<Types.FilterByAreaGeometryResponse> - Promise resolving to the response
- Defined in src/GPUdb.ts:8993
- request: FilterByAreaGeometryRequest
Calculates which geospatial geometry objects from a table intersect a named area of interest (NAI/polygon). The operation is synchronous, meaning that a response will not be returned until all the matching objects are fully available. The response payload provides the count of the resulting set. A new resultant set (view) which satisfies the input NAI restriction specification is created with the name
view_namepassed in as part of the input.