Step4_BigQueryLoad.bat

::This code (step 4) loads data from the GCP bucket into Big Query.  Run via two sub-steps:
::1. In Command Prompt, navigate to directory where the bat file is saved
::2. Run bat using: filename.bat
::Once all data is loaded, union into single datasset using series of appends, saving result as rpscentroids_all


call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch1 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch1.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch2 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch2.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch3 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch3.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch4 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch4.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch5 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch5.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch6 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch6.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch7 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch7.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch8 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch8.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch9 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch9.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch10 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch10.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch11 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch11.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch12 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch12.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch13 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch13.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch14 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch14.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch15 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch15.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch16 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch16.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch17 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch17.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch18 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch18.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch19 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch19.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch20 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch20.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch21 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch21.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string
call bq load --source_format=CSV --skip_leading_rows=1 --field_delimiter="|" tnc_ny_parcels.rpscentroids_batch22 gs://tnc-eny-bucket01/rpscentroids/rpscentroids_batch22.csv id:integer,geom:string,objectid:integer,county_name:string,muni_name:string,swis:string,parcel_addr:string,print_key:string,sbl:string,citytown_name:string,citytown_swis:string,loc_st_nbr:string,loc_street:string,loc_unit:string,loc_zip:string,prop_class:string,roll_section:string,land_av:numeric,total_av:numeric,full_market_val:numeric,yr_blt:integer,front:integer,depth:integer,sq_ft:numeric,acres:numeric,school_code:string,school_name:string,sewer_type:string,sewer_desc:string,water_supply:string,water_desc:string,utilities:string,utilities_desc:string,bldg_style:string,bldg_style_desc:string,heat_type:string,heat_type_desc:string,fuel_type:string,fuel_type_desc:string,sqft_living:numeric,nbr_kitchens:integer,nbr_full_baths:integer,nbr_bedrooms:integer,used_as_code:string,used_as_desc:string,ag_dist_code:string,ag_dist_name:string,primary_owner:string,mail_addr:string,po_box:string,mail_city:string,mail_state:string,mail_zip:string,add_owner:string,add_mail_addr:string,add_mail_po_box:string,add_mail_city:string,add_mail_state:string,add_mail_zip:string,book:integer,page:integer,grid_east:numeric,grid_north:numeric,muni_parcel_id:string,swis_sbl_id:string,swis_print_key_id:string,roll_yr:integer,spatial_yr:integer,owner_type:string,nys_name:string,nys_name_source:string,dup_geo:string,calc_acres:float,orig_fid:integer,std_owner:string,std_addr:string,std_add_owner:string,std_add_addr:string,geog_wkt:string