Skip to content

Instantly share code, notes, and snippets.

@afcotroneo

afcotroneo/omni-pre-5.7

Last active August 26, 2021 16:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save afcotroneo/45d3ff82cc23a71ca612d56f3ad457ce to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save afcotroneo/45d3ff82cc23a71ca612d56f3ad457ce to your computer and use it in GitHub Desktop.
Download ZIP
Raw
omni-pre-5.7
select
sum(number_injured) as number_injured,
avg(party_count) as avg_party_count,
b.osm_id
from la_collisions a,
la_street_buffer b
where
st_contains(b.omnisci_geo,st_setsrid(st_point(a.point_x, a.point_y), 4326))
group by
b.osm_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment