Table Definition
CREATE MATERIALIZED VIEW point_clusters_11 AS (
SELECT get_clusters.cluster_id,
get_clusters.size,
(st_setsrid(get_clusters.cluster_geom, 4326))::geometry(Point,4326) AS cluster_geom,
get_clusters."cityName",
get_clusters.tarmo_category,
get_clusters.props
FROM kooste.get_clusters((0.0125)::double precision) get_clusters(cluster_id, size, cluster_geom, "cityName", tarmo_category, props)
)
- kooste.get_clusters
Name | Type | Default | Nullable | Children | Parents | Comment |
---|---|---|---|---|---|---|
cluster_id | integer | true | ||||
size | bigint | true | ||||
cluster_geom | geometry(Point,4326) | true | ||||
cityName | text | true | ||||
tarmo_category | text | true | ||||
props | jsonb | true |
Name | Definition |
---|---|
point_clusters_11_cityName_idx | CREATE INDEX "point_clusters_11_cityName_idx" ON kooste.point_clusters_11 USING btree ("cityName") |
Generated by tbls