Johdot ja putkilinjat - Merikartan johtotiedot

Tables

• Johdot Ja Linjat V, Avoinjohdot Ja Linjat VTSV

  Merikartan johtotiedot sisältää vedenalaiset johdot ja putket.

• avoin
• johdot_ja_linjat_v
• meriliikenne

Column Descriptions

Johdot Ja Linjat V, Avoinjohdot Ja Linjat V

Column	Type	Comment
hisoid	string	Data source did not contain a description for HISOID. Column hisoid has 7941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is FI210000000293933 and maximum string is FI644000005000009.
horcbllne	int	Data source did not contain a description for HORCBLLNE. Column horcbllne has 7941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. This column is filled with a constant value. Constant value is 1.
usecable	int	Data source did not contain a description for USECABLE. Column usecable has 7941 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 9.
vercsa	string	Data source did not contain a description for VERCSA. Column vercsa has 7941 rows, out of which 7938 are empty, making the null percent 99.96.
cdate	string	Data source did not contain a description for CDATE. Column is empty.
inform_en	string	Data source did not contain a description for INFORM_EN. Column inform_en has 7941 rows, out of which 7907 are empty, making the null percent 99.57.
inform_fi	string	Data source did not contain a description for INFORM_FI. Column inform_fi has 7941 rows, out of which 7906 are empty, making the null percent 99.56.
inform_se	string	Data source did not contain a description for INFORM_SE. Column inform_se has 7941 rows, out of which 7937 are empty, making the null percent 99.95. First 25 characters of minimum string: Ankring och fiske med bot...
ntmentry	string	Data source did not contain a description for NTMENTRY. Column ntmentry has 7941 rows, out of which 7695 are empty, making the null percent 96.90.
statuscabl	int	Data source did not contain a description for STATUSCABL. Column statuscabl has 7941 rows, out of which 5 are empty, making the null percent 0.06. Minimum value is 1 and maximum value is 2.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV.
geom_geojson	string	Geometry in GeoJSON format.
orig_extractdate	string

Additional Info

Last Updated	September 2, 2023
Created	July 9, 2018