<commit_before>﻿
DROP TABLE IF EXISTS  model_draft.scn_nep2035_b2_line ;
CREATE TABLE model_draft.scn_nep2035_b2_line
(
  scn_name character varying NOT NULL DEFAULT 'Status Quo'::character varying,
  project character varying,
  project_id bigint,
  startpunkt character varying,
  endpunkt character varying,
  spannung bigint,
  s_nom numeric DEFAULT 0,
  cables bigint,
  nova character varying,
  geom geometry(MultiLineString,4326)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE model_draft.scn_nep2035_b2_line
  OWNER TO oeuser;
  
COPY model_draft.scn_nep2035_b2_line FROM '/home/clara/GitHub/data_processing/documentation/scn_nep2035_b2.csv' DELIMITER ',' CSV HEADER;

DROP TABLE IF EXISTS  model_draft.ego_grid_pf_hv_extension_temp_resolution;
CREATE TABLE model_draft.ego_grid_pf_hv_extension_temp_resolution AS (SELECT * FROM model_draft.ego_grid_pf_hv_temp_resolution);

DROP TABLE IF EXISTS model_draft.ego_grid_pf_hv_extension_source ;
CREATE TABLE model_draft.ego_grid_pf_hv_extension_source AS (SELECT * FROM model_draft.ego_grid_pf_hv_source);
ALTER TABLE model_draft.ego_grid_pf_hv_extension_source<commit_msg>Add header and remove copy from csv<commit_after>/*
In a postprocessing this script includes grid variations to the grid model. 

__copyright__ 	= "Flensburg University of Applied Sciences, Centre for Sustainable Energy Systems"
__license__ 	= "GNU Affero General Public License Version 3 (AGPL-3.0)"
__url__ 	= "https://github.com/openego/data_processing/blob/master/LICENSE"
__author__ 	= "ClaraBüttner, IlkaCu" 
*/

DROP TABLE IF EXISTS  model_draft.ego_grid_pf_hv_extension_temp_resolution;
CREATE TABLE model_draft.ego_grid_pf_hv_extension_temp_resolution AS (SELECT * FROM model_draft.ego_grid_pf_hv_temp_resolution);

DROP TABLE IF EXISTS model_draft.ego_grid_pf_hv_extension_source ;
CREATE TABLE model_draft.ego_grid_pf_hv_extension_source AS (SELECT * FROM model_draft.ego_grid_pf_hv_source);
ALTER TABLE model_draft.ego_grid_pf_hv_extension_source
{'fraction_non_alphanumeric': 0.057663125948406675, 'fraction_numerical': 0.01669195751138088, 'mean_word_length': 6.912, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 1, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5939072', 'n_tokens_mistral': 725, 'n_tokens_neox': 686, 'n_words': 154}