The avatar for @justingosses
Justin Gosses
JavaScript | Python | Data Visualization | Web Development | Geology | Space | Analytics | IoT | Learn, Build Stuff, and Figure Things Out
Public
Houston
Edited
Aug 13, 2023
Fork of SQL + Chart
5
Houston
SQL queries to Map
Insert cell
Insert cell
Houston bike share data jam quick demographics - Internet plans@1.csv
Type Table, then Shift-Enter. Ctrl-space for more options.

Insert cell
houstonBikeShareDataJamQuickDemographicsInternetPl
SELECT * FROM houstonBikeShareDataJamQuickDemographicsInternetPl
where percentWhiteResidentsPerTractNumber < 0.5 and suspended != ''
Insert cell
Insert cell
query_results
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
// Plot.plot({
// // projection: "albers-usa",
// marks: [
// Plot.geo(commissioner_precincts, {strokeOpacity: 0.4}),
// Plot.dot(houstonBikeShareDataJamQuickDemographicsInternetPl, {x: "Longitude", y: "Latitude", r: 1, stroke: "red", fill: "red", fillOpacity: 0.2})
// ]
// })
Insert cell
commissioner_precincts = FileAttachment("Commissioner_Precincts.geojson").json()
Insert cell
Plot.geo({projection: {type: "identity", domain: houstonBikeShareDataJamQuickDemographicsInternetPl}})
Insert cell
import {us} from "@observablehq/plot-albers-usa-projection"
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more