observation
observationid
BIGINT
seriesid
BIGINT
phenomenontimestart
TIMESTAMP(6) WITHOUT TIME ZONE
phenomenontimeend
TIMESTAMP(6) WITHOUT TIME ZONE
resulttime
TIMESTAMP(6) WITHOUT TIME ZONE
identifier
CHARACTER VARYING(255)
codespace
BIGINT
name
CHARACTER VARYING(255)
codespacename
BIGINT
description
CHARACTER VARYING(255)
deleted
CHARACTER(1)
child
CHARACTER(1)
parent
CHARACTER(1)
validtimestart
TIMESTAMP(6) WITHOUT TIME ZONE
validtimeend
TIMESTAMP(6) WITHOUT TIME ZONE
samplinggeometry
geometry
unitid
BIGINT
blobvalue
observationid
BIGINT
value
OID
featureparameter
parameterid
BIGINT
featureofinterestid
BIGINT
name
CHARACTER VARYING(255)
booleanfeatparamvalue
parameterid
BIGINT
value
CHARACTER(1)
parameter
parameterid
BIGINT
observationid
BIGINT
name
CHARACTER VARYING(255)
booleanparametervalue
parameterid
BIGINT
value
CHARACTER(1)
booleanvalue
observationid
BIGINT
value
CHARACTER(1)
categoryfeatparamvalue
parameterid
BIGINT
value
CHARACTER VARYING(255)
unitid
BIGINT
unit
unitid
BIGINT
unit
CHARACTER VARYING(255)
name
CHARACTER VARYING(255)
link
CHARACTER VARYING(255)
categoryparametervalue
parameterid
BIGINT
value
CHARACTER VARYING(255)
unitid
BIGINT
categoryvalue
observationid
BIGINT
value
CHARACTER VARYING(255)
identifier
CHARACTER VARYING(255)
name
CHARACTER VARYING(255)
description
CHARACTER VARYING(255)
codespace
codespaceid
BIGINT
codespace
CHARACTER VARYING(255)
complexvalue
observationid
BIGINT
compositeobservation
observationid
BIGINT
childobservationid
BIGINT
observableproperty
observablepropertyid
BIGINT
identifier
CHARACTER VARYING(255)
codespace
BIGINT
name
CHARACTER VARYING(255)
codespacename
BIGINT
description
CHARACTER VARYING(255)
disabled
CHARACTER(1)
hiddenchild
CHARACTER(1)
compositephenomenon
parentobservablepropertyid
BIGINT
childobservablepropertyid
BIGINT
countfeatparamvalue
parameterid
BIGINT
value
INTEGER
countparametervalue
parameterid
BIGINT
value
INTEGER
countvalue
observationid
BIGINT
value
INTEGER
featureofinterest
featureofinterestid
BIGINT
hibernatediscriminator
CHARACTER VARYING(255)
featureofinteresttypeid
BIGINT
identifier
CHARACTER VARYING(255)
codespace
BIGINT
name
CHARACTER VARYING(255)
codespacename
BIGINT
description
CHARACTER VARYING(255)
geom
geometry
descriptionxml
TEXT
url
CHARACTER VARYING(255)
featureofinteresttype
featureofinteresttypeid
BIGINT
featureofinteresttype
CHARACTER VARYING(255)
featurerelation
parentfeatureid
BIGINT
childfeatureid
BIGINT
geometryvalue
observationid
BIGINT
value
geometry
numericfeatparamvalue
parameterid
BIGINT
value
DOUBLE PRECISION
unitid
BIGINT
numericparametervalue
parameterid
BIGINT
value
DOUBLE PRECISION
unitid
BIGINT
numericvalue
observationid
BIGINT
value
DOUBLE PRECISION
series
seriesid
BIGINT
featureofinterestid
BIGINT
observablepropertyid
BIGINT
procedureid
BIGINT
offeringid
BIGINT
deleted
CHARACTER(1)
published
CHARACTER(1)
hiddenchild
CHARACTER(1)
firsttimestamp
TIMESTAMP(6) WITHOUT TIME ZONE
lasttimestamp
TIMESTAMP(6) WITHOUT TIME ZONE
firstnumericvalue
DOUBLE PRECISION
lastnumericvalue
DOUBLE PRECISION
unitid
BIGINT
identifier
CHARACTER VARYING(255)
codespace
BIGINT
name
CHARACTER VARYING(255)
codespacename
BIGINT
description
CHARACTER VARYING(255)
seriestype
CHARACTER VARYING(255)
observationconstellation
observationconstellationid
BIGINT
observablepropertyid
BIGINT
procedureid
BIGINT
observationtypeid
BIGINT
offeringid
BIGINT
deleted
CHARACTER(1)
hiddenchild
CHARACTER(1)
disabled
CHARACTER(1)
observationtype
observationtypeid
BIGINT
observationtype
CHARACTER VARYING(255)
offering
offeringid
BIGINT
hibernatediscriminator
CHARACTER(1)
identifier
CHARACTER VARYING(255)
codespace
BIGINT
name
CHARACTER VARYING(255)
codespacename
BIGINT
description
CHARACTER VARYING(255)
disabled
CHARACTER(1)
procedure
procedureid
BIGINT
hibernatediscriminator
CHARACTER(1)
proceduredescriptionformatid
BIGINT
identifier
CHARACTER VARYING(255)
codespace
BIGINT
name
CHARACTER VARYING(255)
codespacename
BIGINT
description
CHARACTER VARYING(255)
deleted
CHARACTER(1)
disabled
CHARACTER(1)
descriptionfile
TEXT
referenceflag
CHARACTER(1)
typeof
BIGINT
istype
CHARACTER(1)
isaggregation
CHARACTER(1)
mobile
CHARACTER(1)
insitu
CHARACTER(1)
offeringallowedobservationtype
offeringid
BIGINT
observationtypeid
BIGINT
offeringrelation
parentofferingid
BIGINT
childofferingid
BIGINT
pointcloud_formats
pcid
INTEGER
srid
INTEGER
schema
TEXT
proceduredescriptionformat
proceduredescriptionformatid
BIGINT
proceduredescriptionformat
CHARACTER VARYING(255)
profileobservation
observationid
BIGINT
childobservationid
BIGINT
profilevalue
observationid
BIGINT
fromlevel
DOUBLE PRECISION
tolevel
DOUBLE PRECISION
levelunitid
BIGINT
referencevalue
observationid
BIGINT
href
CHARACTER VARYING(255)
title
CHARACTER VARYING(255)
role
CHARACTER VARYING(255)
relatedobservation
relatedobservationid
BIGINT
observationid
BIGINT
relatedobservation
BIGINT
role
CHARACTER VARYING(255)
relatedurl
CHARACTER VARYING(255)
sensorsystem
parentsensorid
BIGINT
childsensorid
BIGINT
seriesreference
seriesid
BIGINT
referenceseriesid
BIGINT
sortorder
INTEGER
spatial_ref_sys
srid
INTEGER
auth_name
CHARACTER VARYING(256)
auth_srid
INTEGER
srtext
CHARACTER VARYING(2048)
proj4text
CHARACTER VARYING(2048)
swedataarrayvalue
observationid
BIGINT
value
TEXT
textfeatparamvalue
parameterid
BIGINT
value
CHARACTER VARYING(255)
textparametervalue
parameterid
BIGINT
value
CHARACTER VARYING(255)
textvalue
observationid
BIGINT
value
TEXT
identifier
CHARACTER VARYING(255)
name
CHARACTER VARYING(255)
description
CHARACTER VARYING(255)
xmlfeatparamvalue
parameterid
BIGINT
value
TEXT
xmlparametervalue
parameterid
BIGINT
value
TEXT