update highway_only_motor
set has_business_value = true
where st_intersects(geom, (select geom from admin_boundary where id = 10236))

QUERY PLAN                                                                                         |
---------------------------------------------------------------------------------------------------|
Update on highway_only_motor  (cost=8.30..1241137.48 rows=1431564 width=1782)                      |
  InitPlan 1 (returns $0)                                                                          |
    ->  Index Scan using admin_boundary_pkey on admin_boundary  (cost=0.29..8.30 rows=1 width=6768)|
          Index Cond: (id = 10236)                                                                 |
  ->  Seq Scan on highway_only_motor  (cost=0.00..1241129.18 rows=1431564 width=1782)              |
        Filter: st_intersects(geom, $0)                                                            |

CREATE TABLE public.highway_only_motor (
    osm_id int8 NULL,
    geom geometry NULL,
    "name" text NULL,
    highway text NULL,
    "ref" text NULL,
    oneway text NULL,
    id serial NOT NULL,
    city varchar(255) NULL,
    state varchar(255) NULL,
    country varchar(255) NULL,
    has_business_value bool NOT NULL DEFAULT false,
    CONSTRAINT highway_only_motor_pkey PRIMARY KEY (id)
);
CREATE INDEX highway_only_motor_geom_idx ON public.highway_only_motor USING gist (geom);

CREATE TABLE public.admin_boundary (
    osm_id int8 NULL,
    admin_level int4 NULL,
    boundary text NULL,
    "name" text NULL,
    place text NULL,
    population text NULL,
    geom geometry NULL,
    id serial NOT NULL,
    CONSTRAINT admin_boundary_pkey PRIMARY KEY (id)
);
CREATE INDEX admin_boundary_geom_idx ON public.admin_boundary USING gist (geom);