CSV (comma separated values) - Revision history

Maxim@tygron.com at 13:50, 15 July 2026

2026-07-15T13:50:36Z

Frank@tygron.nl at 08:13, 6 July 2026

2026-07-06T08:13:22Z

← Older revision		Revision as of 08:13, 6 July 2026
Line 126:		Line 126:
	It is also possible to [[Export Geo data\|export geo data]] from the Platform in CSV format. The following elements of the platform support exporting as a CSV file:		It is also possible to [[Export Geo data\|export geo data]] from the Platform in CSV format. The following elements of the platform support exporting as a CSV file:

	*[[~~Buildings~~]]		*[[Building]]s
	*[[~~Terrains~~]]		*[[Terrain]]s
	*[[~~Neighborhoods~~]]		*[[Neighborhood]]s
	*[[~~Zoning~~]]		*[[Zone]]s
	*[[~~Plots~~]]		*[[Plot]]s
	*[[~~Areas~~]]		*[[Area]]s
	*[[Measurement~~\|Measurements~~]]		*[[Measurement]]s

	{{article end		{{article end

Frank@tygron.nl at 08:11, 6 July 2026

2026-07-06T08:11:58Z

← Older revision		Revision as of 08:11, 6 July 2026
Line 140:		Line 140:
	* [[Time sequence (Water Overlay)]]		* [[Time sequence (Water Overlay)]]
	* [[Measuring tool]]		* [[Measuring tool]]
	* [https://en.wikipedia.org/wiki/Comma-separated_values CSV on wikipedia]]		* [https://en.wikipedia.org/wiki/Comma-separated_values CSV on wikipedia]
	* For more information on the import and export of CSV files, see this video (Dutch only):		* For more information on the import and export of CSV files, see this video (Dutch only):
	[[File:YoutubeLogo1.jpg\|thumb\|left\|link=https://youtu.be/GnTkziMUyIU\|Import and export of data with CSV files (Dutch only)]]{{clear}}		[[File:YoutubeLogo1.jpg\|thumb\|left\|link=https://youtu.be/GnTkziMUyIU\|Import and export of data with CSV files (Dutch only)]]{{clear}}

Frank@tygron.nl at 08:11, 6 July 2026

2026-07-06T08:11:45Z

← Older revision		Revision as of 08:11, 6 July 2026
Line 2:		Line 2:
	[[File:CSV-logo2.jpg\|right]]		[[File:CSV-logo2.jpg\|right]]

	*''See also: https://en.wikipedia.org/wiki/Comma-separated_values
	CSV files are used to transfer data sets between information systems that do not use the same (proprietary) data format. For example, by using the CSV format, data from a data base in a proprietary format can be transferred to a spread sheet program with another proprietary format.		CSV files are used to transfer data sets between information systems that do not use the same (proprietary) data format. For example, by using the CSV format, data from a data base in a proprietary format can be transferred to a spread sheet program with another proprietary format.

Line 141:		Line 140:
	* [[Time sequence (Water Overlay)]]		* [[Time sequence (Water Overlay)]]
	* [[Measuring tool]]		* [[Measuring tool]]
			* [https://en.wikipedia.org/wiki/Comma-separated_values CSV on wikipedia]]
	* For more information on the import and export of CSV files, see this video (Dutch only):		* For more information on the import and export of CSV files, see this video (Dutch only):
	[[File:YoutubeLogo1.jpg\|thumb\|left\|link=https://youtu.be/GnTkziMUyIU\|Import and export of data with CSV files (Dutch only)]]{{clear}}		[[File:YoutubeLogo1.jpg\|thumb\|left\|link=https://youtu.be/GnTkziMUyIU\|Import and export of data with CSV files (Dutch only)]]{{clear}}

Frank@tygron.nl: /* Importing a CSV file in the Tygron Geodesign Platform */

2026-05-08T09:36:10Z

Importing a CSV file in the Tygron Geodesign Platform

← Older revision		Revision as of 09:36, 8 May 2026
Line 115:		Line 115:
	The CSV data structure and files are mostly used in the {{software}} as a means to import dynamic [[Attribute\|attributes]]. By default, attributes of an overlay, such as rain over time, are generated as a linear event. To incorporate for example rain over time in where the amount of rain in mm varies, a custom option is available where an [[attribute array]] can be uploaded in CSV format.		The CSV data structure and files are mostly used in the {{software}} as a means to import dynamic [[Attribute\|attributes]]. By default, attributes of an overlay, such as rain over time, are generated as a linear event. To incorporate for example rain over time in where the amount of rain in mm varies, a custom option is available where an [[attribute array]] can be uploaded in CSV format.

	''It is important to note that such a CSV file containing a dynamic array, can contain up to a maximum of 10.000 records/ timestamps.''		''It is important to note that such a CSV file containing a dynamic array, can contain up to a maximum of 5.000 records/ timestamps.''

	Examples of data that can be imported as CSV:		Examples of data that can be imported as CSV:

Frank@tygron.nl at 13:34, 5 May 2026

2026-05-05T13:34:15Z

← Older revision		Revision as of 13:34, 5 May 2026
Line 136:		Line 136:

	{{article end		{{article end
			\|notes=
			* [[Item]]s can also be exported to a CSV using the [[Api Content Items\|API endpoints]], by specifying the query parameter ''f=CSV''
	\|seealso=		\|seealso=
	* [[Time sequence (Water Overlay)]]		* [[Time sequence (Water Overlay)]]
Line 149:		Line 151:
	* [[How to load in dynamic evaporation rate (Water Overlay)]]<br>		* [[How to load in dynamic evaporation rate (Water Overlay)]]<br>
	* [[How to export objects in a project to a CSV]]		* [[How to export objects in a project to a CSV]]
			\|api=
			*[[Api Content Items]]
	}}		}}
	[[Category:Files]]		[[Category:Files]]

Maxim@tygron.com at 13:54, 16 July 2025

2025-07-16T13:54:13Z

← Older revision		Revision as of 13:54, 16 July 2025
Line 119:		Line 119:
	Examples of data that can be imported as CSV:		Examples of data that can be imported as CSV:
	*[[Rain_model_(Water_Overlay)\|Rain simulation time]]		*[[Rain_model_(Water_Overlay)\|Rain simulation time]]
	*[[~~Evaporation_model_~~(Water_Overlay)\|Dynamic evaporation rates]]		*[[Evapotranspiration_model_(Water_Overlay)\|Dynamic evaporation rates]]
	*[[Weir height (Water Overlay)\|Weir height]]		*[[Weir height (Water Overlay)\|Weir height]]
	*[[Inlet_q_(Water_Overlay)\|Inlet Q-t relation]]		*[[Inlet_q_(Water_Overlay)\|Inlet Q-t relation]]
	{{clear}}		{{clear}}

	===Exporting a CSV file from the Tygron ~~Geodesign~~ Platform===		===Exporting a CSV file from the Tygron Platform===
	It is also possible to [[Export Geo data\|export geo data]] from the Platform in CSV format. The following elements of the platform support exporting as a CSV file:		It is also possible to [[Export Geo data\|export geo data]] from the Platform in CSV format. The following elements of the platform support exporting as a CSV file:

Frank@tygron.nl: /* Exporting a CSV file from the Tygron Geodesign Platform */

2023-01-30T14:16:10Z

Exporting a CSV file from the Tygron Geodesign Platform

← Older revision		Revision as of 14:16, 30 January 2023
Line 148:		Line 148:
	* [[How to set dynamic breach height]]<br>		* [[How to set dynamic breach height]]<br>
	* [[How to load in dynamic evaporation rate (Water Overlay)]]<br>		* [[How to load in dynamic evaporation rate (Water Overlay)]]<br>
	* [[How to export objects ~~of the 3D world as~~ CSV]]		* [[How to export objects in a project to a CSV]]
	}}		}}
	[[Category:Files]]		[[Category:Files]]

Godelief@tygron.com: /* Exporting a CSV file from the Tygron Geodesign Platform */

2021-05-10T10:01:49Z

Exporting a CSV file from the Tygron Geodesign Platform

← Older revision		Revision as of 10:01, 10 May 2021
Line 142:		Line 142:
	[[File:YoutubeLogo1.jpg\|thumb\|left\|link=https://youtu.be/GnTkziMUyIU\|Import and export of data with CSV files (Dutch only)]]{{clear}}		[[File:YoutubeLogo1.jpg\|thumb\|left\|link=https://youtu.be/GnTkziMUyIU\|Import and export of data with CSV files (Dutch only)]]{{clear}}
	\|howtos=		\|howtos=
			* [[How to change multiple Attributes at once for Water Overlays]]
	* [[How to import a time sequence with a CSV]]<br>		* [[How to import a time sequence with a CSV]]<br>
	* [[How to import a time sequence for multiple structures\|How to import a time sequence for multiple hydraulic structures]]<br>		* [[How to import a time sequence for multiple structures\|How to import a time sequence for multiple hydraulic structures]]<br>

Godelief@tygron.com: /* CSV (comma separated values) and the Tygron Geodesign Platform */

2020-09-04T14:00:56Z

CSV (comma separated values) and the Tygron Geodesign Platform

← Older revision		Revision as of 14:00, 4 September 2020
Line 107:		Line 107:
	{{clear}}		{{clear}}

	==CSV ~~(comma separated values) and~~ the ~~Tygron Geodesign Platform~~==		==CSV in the {{software}}==
	[[File:DynamicRainArray1.jpg\|thumb\|right\|200px\|Example of a dynamic rain array (timestamp/ rain in mm)]]		[[File:DynamicRainArray1.jpg\|thumb\|right\|200px\|Example of a dynamic rain array (timestamp/ rain in mm)]]

← Older revision		Revision as of 13:50, 15 July 2026
Line 6:		Line 6:
	Comma separated values (CSV) is a specification of this tabulated data, where the data is stored on single lines in a text based file and entries are separated with a comma or other character.		Comma separated values (CSV) is a specification of this tabulated data, where the data is stored on single lines in a text based file and entries are separated with a comma or other character.

	In the Anglo Saxon influence sphere, commas are in use as separators and periods as decimal separators. In the rest of the world commas are already in use as decimal separators and periods as thousand-separators. In these regions semicolons are used ~~in stead~~ of commas as value separator in a CSV file.		In the Anglo Saxon influence sphere, commas are in use as separators and periods as decimal separators. In the rest of the world commas are already in use as decimal separators and periods as thousand-separators. In these regions semicolons are used instead of commas as value separator in a CSV file.

	Another variation in separator characters is when copying an HTML table into memory. When pasting it in plain text, the tab character ('\t') is automatically used as separator in stead of a comma or semicolon.		Another variation in separator characters is when copying an HTML table into memory. When pasting it in plain text, the tab character ('\t') is automatically used as separator in stead of a comma or semicolon.

	A CSV file can be created and read with a simple text editor. The file consists of line entries that correspond with the rows in a spreadsheet. Each line (row) has the same number of (columns) entries, separated with a comma or other separator. The first line can be used to name column headers of the resulting table. Lines are sometimes ended with only a line feed and no carriage return, which results in the text being displayed in a text editor as one single line without separation per table row. Spreadsheets can ~~ususally~~ read these line feeds without problem, ordering the data in its proper rows again.		A CSV file can be created and read with a simple text editor. The file consists of line entries that correspond with the rows in a spreadsheet. Each line (row) has the same number of (columns) entries, separated with a comma or other separator. The first line can be used to name column headers of the resulting table. Lines are sometimes ended with only a line feed and no carriage return, which results in the text being displayed in a text editor as one single line without separation per table row. Spreadsheets can usually read these line feeds without problem, ordering the data in its proper rows again.

	==Creating a CSV file==		==Creating a CSV file==
Line 25:		Line 25:
	apple; fruit; 10; 0,80</pre>		apple; fruit; 10; 0,80</pre>

	Now we add the other entries, resulting in a European CSV file, where the decimal separator is a comma and the value separator is a semicolon. This data convention is sometimes called SSV - Semicolon Separated ~~Valeus~~:		Now we add the other entries, resulting in a European CSV file, where the decimal separator is a comma and the value separator is a semicolon. This data convention is sometimes called SSV - Semicolon Separated Values:

	<pre>name; type; quantity; price		<pre>name; type; quantity; price
Line 33:		Line 33:
	onion; vegetable; 3; 0,50</pre>		onion; vegetable; 3; 0,50</pre>

	Save the text file with ".csv" as ~~extention~~, to save it as a CSV file and not as a regular text file.		Save the text file with ".csv" as extension, to save it as a CSV file and not as a regular text file.

	This CSV file will result in a similar table as below, when importing the file in a spread sheet program:		This CSV file will result in a similar table as below, when importing the file in a spread sheet program: