mbforr

SELECT 
polygons.*,
COUNT(points.*)
FROM polygons, points
WHERE ST_Intersects(points.the_geom, polygons.the_geom)

mbforr

import pandas as pd
from geopandas import GeoDataFrame, points_from_xy
import geopandas as gpd
import time

# Load the Uber point data

df = pd.read_csv('uber_all.csv')

# Create the GeoDataFrame and assign the proper projection

mbforr

-- written for PostGIS
-- table states is US State Polygons
-- table capitals are US State Capital points

select
a.name,
a.id,

-- create a centroid of the state polygon

mbforr

WITH
  buildings AS (
  SELECT
    id,
    latitude,
    longitude,
    username,
    osm_timestamp,
  FROM
    `bigquery-public-data.geo_openstreetmap.planet_nodes`

mbforr

select
*
from
`bigquery-public-data.geo_us_boundaries.states`

mbforr

select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`

mbforr

select 
*
from bigquery-public-data.geo_us_boundaries.state

mbforr

select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`
limit 10

mbforr

select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`
limit 10 offset 10

mbforr

select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`

# this is a comment - it won't impact your code and you can delete it if you want

# use the where clause to select rows based on a condition
# in this case an exact match to where the state_name column equals Wisconsin