MySQL_Scripts/export_to_csv_full_2018_parcels_table at master · msimonson-psrc/MySQL_Scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121

/* Add column headers */
SELECT
'parcel_id'
,'parcel_id_fips'
,'parking_space_daily'
,'parking_space_hourly'
,'hschool_id'
,'city_id'
,'minority_id'
,'census_tract_id'
,'grid_id'
,'tod_id'
,'census_block_id'
,'y_coord_sp'
,'county_id'
,'plan_type_id'
,'use_code'
,'transit_buffer_id'
,'school_district_id'
,'gross_sqft'
,'is_inside_urban_growth_boundary'
,'park_buffer_id'
,'x_coord_sp'
,'elem_id'
,'is_waterfront'
,'growth_center_id'
,'zip_id'
,'parking_price_hourly'
,'hex_id'
,'regional_geography_id'
,'large_area_id'
,'mschool_id'
,'land_value'
,'hct_block_id'
,'baseyear_built'
,'poverty_id'
,'zone_id'
,'tractcity_id'
,'faz_id'
,'growth_amenities_id'
,'is_in_transit_zone'
,'parking_price_daily'
,'subarea_id'
,'census_block_group_id'
,'faz_group_id'
,'land_use_type_id'
,'mix_split_id'
,'parcel_sqft'
,'uga_buffer_id'
,'exemption'
,'stacked_parcel_id'
,'stacked_flag'
,'original_parcel_id'
,'address'
,'census_2010_block_id'

UNION ALL

/* Now the actual query */
SELECT
parcel_id
,parcel_id_fips
,parking_space_daily
,parking_space_hourly
,hschool_id
,city_id
,minority_id
,census_tract_id
,grid_id
,tod_id
,census_block_id
,y_coord_sp
,county_id
,plan_type_id
,use_code
,transit_buffer_id
,school_district_id
,gross_sqft
,is_inside_urban_growth_boundary
,park_buffer_id
,x_coord_sp
,elem_id
,is_waterfront
,growth_center_id
,zip_id
,parking_price_hourly
,hex_id
,regional_geography_id
,large_area_id
,mschool_id
,land_value
,hct_block_id
,baseyear_built
,poverty_id
,zone_id
,tractcity_id
,faz_id
,growth_amenities_id
,is_in_transit_zone
,parking_price_daily
,subarea_id
,census_block_group_id
,faz_group_id
,land_use_type_id
,mix_split_id
,parcel_sqft
,uga_buffer_id
,exemption
,stacked_parcel_id
,stacked_flag
,original_parcel_id
,address
,census_2010_block_id
FROM 2018_parcel_baseyear.parcels

/* Save the query results to a file */
INTO OUTFILE 'E:\parcels_2018.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';