D3 Visualization of the Median Market Value of Two Bedroom Homes within some LA Neighborhoods

I have picked the median market values of two bedroom homes within seven LA counties to visualize them over time and compare them with each other.

The counties that I have chosen are:

  1. Beverly Hills (of course, why not),
  2. Santa Monica (this area is really fancy too),
  3. Downtown Los Angeles
  4. West Los Angeles
  5. Culver City
  6. Brentwood
  7. Westwood

As you can see from the above chart, there is basically the same pattern of the median market value of two bedroom homes within each chosen LA neighborhood, and I really like the prices back in 2000.

Continue reading ‘D3 Visualization of the Median Market Value of Two Bedroom Homes within some LA Neighborhoods’ »

Place the results of a MySQL query into a CSV file

The results of a MySQL query can be placed into a CSV file using the following query:

INTO OUTFILE 'file_path'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

To include header write another query before the “main” query. It returns the header, and the “main” query returns the data. Union joins them together:

SELECT 'COLUMN1_NAME', 'COLUMN2_NAME'
UNION 
… Your MySQL query here;

View on Github