distance_matrix.sql

SELECT name FROM upstate ORDER BY name;

SELECT * FROM
Crosstab('SELECT row.name::text, col.name::text, (ST_Distance(row.geometry, col.geometry, true)*0.00062)::text AS dist 
          FROM upstate AS row, upstate AS col
          ORDER BY 1, 2;'
        ) AS
        ct(row_name text, Auburn text, Binghamton text, Elmira text, Ithaca text, Rochester text, Syracuse text);