swmm_vw_coordinates

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

node

varchar

2147483647

√

null

x_coord

numeric

0

√

null

y_coord

numeric

0

√

null

state

text

2147483647

√

null

hierarchy

text

2147483647

√

null

obj_id

varchar

16

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT swmm_vw_junctions.name AS node,
    round((st_x(swmm_vw_junctions.geom))::numeric, 2) AS x_coord,
    round((st_y(swmm_vw_junctions.geom))::numeric, 2) AS y_coord,
    swmm_vw_junctions.state,
    swmm_vw_junctions.hierarchy,
    swmm_vw_junctions.obj_id
   FROM tww_app.swmm_vw_junctions
  WHERE (swmm_vw_junctions.geom IS NOT NULL)
UNION
 SELECT swmm_vw_outfalls.name AS node,
    round((st_x(swmm_vw_outfalls.geom))::numeric, 2) AS x_coord,
    round((st_y(swmm_vw_outfalls.geom))::numeric, 2) AS y_coord,
    swmm_vw_outfalls.state,
    swmm_vw_outfalls.hierarchy,
    swmm_vw_outfalls.obj_id
   FROM tww_app.swmm_vw_outfalls
  WHERE (swmm_vw_outfalls.geom IS NOT NULL)
UNION
 SELECT swmm_vw_dividers.name AS node,
    round((st_x(swmm_vw_dividers.geom))::numeric, 2) AS x_coord,
    round((st_y(swmm_vw_dividers.geom))::numeric, 2) AS y_coord,
    swmm_vw_dividers.state,
    swmm_vw_dividers.hierarchy,
    swmm_vw_dividers.obj_id
   FROM tww_app.swmm_vw_dividers
  WHERE (swmm_vw_dividers.geom IS NOT NULL)
UNION
 SELECT swmm_vw_storages.name AS node,
    round((st_x(swmm_vw_storages.geom))::numeric, 2) AS x_coord,
    round((st_y(swmm_vw_storages.geom))::numeric, 2) AS y_coord,
    swmm_vw_storages.state,
    swmm_vw_storages.hierarchy,
    swmm_vw_storages.obj_id
   FROM tww_app.swmm_vw_storages
  WHERE (swmm_vw_storages.geom IS NOT NULL)
UNION
 SELECT swmm_vw_raingages.name AS node,
    round((st_x(swmm_vw_raingages.geom))::numeric, 2) AS x_coord,
    round((st_y(swmm_vw_raingages.geom))::numeric, 2) AS y_coord,
    swmm_vw_raingages.state,
    swmm_vw_raingages.hierarchy,
    swmm_vw_raingages.obj_id
   FROM tww_app.swmm_vw_raingages
  WHERE (swmm_vw_raingages.geom IS NOT NULL);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views