Manual definition of import table fields
Based on datablob: Sporthallen
Cancel
Submit
0
Source Table Details
0
Field Definitions
0
Source Table Details
Here you can specify the details of the source table.
Name
Description
Comment
kompletter Datensatz mit allen im Datenblob vorhandenen Feldern
Internal ID
Type
Entity (start with "FULL:" to avoid iterated XML load for fields with outside references)
Encoding
UTF-8 (Im Zweifel immer eine gute Wahl)
ISO 8859-1 (western europe)
ISO 8859-16 (central, eastern and southern europe)
Windows-1252 (Eine gute Wahl, wenn das Dokument auf einem Windows-PC erstellt wurde)
UTF-16
UTF-32
ascii (sehr primitiv, kann keine Umlaute etc.)
Geometric Specifications
Here you can check and change the geometric data. These concern the column of type 'geom' . There is exactly one column of this type.
SRID (The central element of this design. Take special care here. Insert 0 to set SRID when converting (manually))
CRS (A more human readable variant of srid)
Number of dimensions (Usually 2)
Geometry Type
Column Definitions
Every row defines a column of the source table.
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Name
Key
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Description
Comment
Internal ID
Edit column definition
Changes made here will be transfered to the main form when pressing save.
Name
Type
Integer
Text
Double Precision
Boolean
Calendar Date
Time
Time with Time Zone
Timestamp
Timestamp with Time Zone
Interval
Geometry
Point
Line (lseg)
Box
Polygon
Circle
JSON
binary JSON
XML
Key
Description
Comment
Internal ID