Skip to content

Data Profile: sap_zaehlpunkt

Generated: 2025-11-27 00:26:39.357706 Schema: raw_results.sap_zaehlpunkt Total Rows: 65,270 Columns: 10 Completeness: 100.00%

Source Files

File Rows Size
sap_zaehlpunkt.csv 65,270 9.6 MB
Total 65,270 9.6 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 OBJECTID integer INTEGER No 0.00% 0
2 recz integer INTEGER No 0.00% 0
3 anlage integer INTEGER No 0.00% 0
4 dateto string VARCHAR(40) No 0.00% 0
5 datefrom string VARCHAR(40) No 0.00% 0
6 grid_id string VARCHAR(9) No 0.00% 0
7 grid_level string VARCHAR(6) No 0.00% 0
8 distributor string VARCHAR(12) No 0.00% 0
9 ext_ui string VARCHAR(49) No 0.00% 0
10 MD_prozessiert timestamp TIMESTAMP No 0.00% 0

Detailed Column Profiles

1. OBJECTID

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

65252, 65268, 65135, 65136, 65138

2. recz

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

65252, 65268, 65135, 65136, 65138

3. anlage

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

2047385, 2047395, 2047412, 2047415, 2047432

4. dateto

Type: string → VARCHAR(40)
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 27
Avg Length 0.0
Buffered Length 40 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

9999-12-31 00:00:00.0000000

5. datefrom

Type: string → VARCHAR(40)
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 27
Avg Length 0.0
Buffered Length 40 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

1994-01-01 00:00:00.0000000, 2013-10-01 00:00:00.0000000, 2008-10-01 00:00:00.0000000, 2018-01-01 00:00:00.0000000, 2024-10-01 00:00:00.0000000

6. grid_id

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

EZ-02, EZ-01, N_RESO, EGO-01, N_COSV

7. grid_level

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

ND, MD, HD5, HD25, HD

8. distributor

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

GN_EGZ, GN_RESOL, GN_EGO, GN_COSVE, GN_EWL

9. ext_ui

Type: string → VARCHAR(49)
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 33
Avg Length 0.0
Buffered Length 49 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

CH7000011234500000000000000000588, CH7000011234500000000000000033016, CH7000011234500000000000000016765, CH7000011234500000000000000031464, CH7000011234500000000000000050461

10. MD_prozessiert

Type: timestamp → TIMESTAMP
Nullable: No

Metric Value
Total Rows 65,270
Non-null 65,270 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 65,270 - Parse Success: 65,270 / 65,270

Sample Values: 

2025-11-02 00:00:00

PostgreSQL DDL

See sap_zaehlpunkt_schema.sql

Generated by process-csv-to-postgres v1.0.0