<commit_before>CREATE OR REPLACE FUNCTION viirs_nlcd_fire_events(schema text) 
   RETURNS void AS
$BODY$
    BEGIN

    EXECUTE 'ALTER TABLE ' || quote_ident(schema) || '.fire_events ' ||
              'DROP COLUMN IF EXISTS geom_nlcd' ;
    EXECUTE 'ALTER TABLE ' || quote_ident(schema) || '.fire_events ' || 
              'ADD COLUMN geom_nlcd geometry(Multipoint, 96630)'; 
              
    EXECUTE 'UPDATE ' || quote_ident(schema) || '.fire_events ' ||
             'SET geom_nlcd = ST_Transform(geom, 96630)';
    
    END
$BODY$ 
  LANGUAGE plpgsql VOLATILE
  COST 100 ; 
ALTER FUNCTION viirs_nlcd_fire_events(schema text)
  OWNER to postgres ;
<commit_msg>generalized viirs_nlcd_fire_events to reproject other tables.<commit_after>CREATE OR REPLACE FUNCTION viirs_nlcd_geom(schema text, tbl text) 
   RETURNS void AS
$BODY$
    BEGIN

    EXECUTE 'ALTER TABLE ' || quote_ident(schema) || '.' || 
              quote_ident(tbl) || 
              ' DROP COLUMN IF EXISTS geom_nlcd' ;
    EXECUTE 'ALTER TABLE ' || quote_ident(schema) || '.' || 
              quote_ident(tbl) || 
              ' ADD COLUMN geom_nlcd geometry'; 
              
    EXECUTE 'UPDATE ' || quote_ident(schema) || '.' ||
             quote_ident(tbl) || 
             ' SET geom_nlcd = ST_Transform(geom, 96630)';
    
    END
$BODY$ 
  LANGUAGE plpgsql VOLATILE
  COST 100 ; 
ALTER FUNCTION viirs_nlcd_geom(schema text, tbl text)
  OWNER to postgres ;

{'fraction_non_alphanumeric': 0.10284920083391244, 'fraction_numerical': 0.014593467685892982, 'mean_word_length': 2.5732009925558312, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, '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': '6322166', 'n_tokens_mistral': 538, 'n_tokens_neox': 486, 'n_words': 114}