api.stays_geojson_view
Description
List stays as geojson
Table Definition
CREATE VIEW stays_geojson_view AS (
SELECT (st_asgeojson(tbl.*))::jsonb AS geojson
FROM ( SELECT stays_explore_view.stay_id,
stays_explore_view.moorage_id,
stays_explore_view.moorage_name,
stays_explore_view.stay_name,
stays_explore_view.arrived,
stays_explore_view.stay_code,
stays_explore_view.latitude,
stays_explore_view.longitude,
stays_explore_view.stay_notes,
stays_explore_view.moorage_notes,
stays_explore_view.has_images,
stays_explore_view.images,
st_makepoint(stays_explore_view.longitude, stays_explore_view.latitude) AS st_makepoint
FROM api.stays_explore_view) tbl
)
Columns
| Name | Type | Default | Nullable |
|---|---|---|---|
| geojson | jsonb | true |
Referenced Tables
| Name | Columns | Comment | Type |
|---|---|---|---|
| api.stays_explore_view | 14 | List moorages notes order by stays | VIEW |
Relations
erDiagram
"api.stays_geojson_view" {
jsonb geojson ""
}
Generated by tbls