timwis · April 13, 2016 22:39
diff --git a/loader.ctl b/loader.ctl
 load data
  infile '/Users/tim/Sites/property-assessments-pipeline/output/merged_properties.csv'
  into table GIS_OPA.PROPERTIES
  fields terminated by ',' optionally enclosed by '"'
  (location,owner_1,owner_2,census_tract,zip_code,geographic_ward,house_number,suffix,unit,house_extension,recording_date,sale_date,sale_price,unfinished,assessment_date,market_value_date,market_value,taxable_land,taxable_building,exempt_land,exempt_building,category_code,zoning,site_type,frontage,depth,parcel_shape,total_area,topography,garage_type,garage_spaces,off_street_open,view,other_building,number_stories,general_construction,type_dwelling,date_exterior_condition,exterior_condition,quality_grade,year_built,year_built_estimate,number_of_rooms,number_of_bedrooms,number_of_bathrooms,basements,fireplaces,type_heater,fuel,central_air,interior_condition,utility,sewer,separate_utilities,total_livable_area,book_and_page,registry_number,cross_reference,category_code_description,building_code,building_code_description,state_code,street_name,street_direction,street_designation,street_code,parcel_number,mailing_care_of,mailing_address_1,mailing_address_2,mailing_street,mailing_city_state,mailing_zip)
	load data
	infile '/Users/tim/Sites/property-assessments-pipeline/output/merged_properties.csv'
	into table GIS_OPA.PROPERTIES
	fields terminated by ',' optionally enclosed by '"'
	(location,owner_1,owner_2,census_tract,zip_code,geographic_ward,house_number,suffix,unit,house_extension,recording_date,sale_date,sale_price,unfinished,assessment_date,market_value_date,market_value,taxable_land,taxable_building,exempt_land,exempt_building,category_code,zoning,site_type,frontage,depth,parcel_shape,total_area,topography,garage_type,garage_spaces,off_street_open,view,other_building,number_stories,general_construction,type_dwelling,date_exterior_condition,exterior_condition,quality_grade,year_built,year_built_estimate,number_of_rooms,number_of_bedrooms,number_of_bathrooms,basements,fireplaces,type_heater,fuel,central_air,interior_condition,utility,sewer,separate_utilities,total_livable_area,book_and_page,registry_number,cross_reference,category_code_description,building_code,building_code_description,state_code,street_name,street_direction,street_designation,street_code,parcel_number,mailing_care_of,mailing_address_1,mailing_address_2,mailing_street,mailing_city_state,mailing_zip)