-- Name: address_usa_tx_77019_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_2_index ON public.address_usa_tx_77019 USING btree (first_2);


--
-- Name: address_usa_tx_77019_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_3_index ON public.address_usa_tx_77019 USING btree (first_3);


--
-- Name: address_usa_tx_77019_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_4_index ON public.address_usa_tx_77019 USING btree (first_4);


--
-- Name: address_usa_tx_77019_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_5_index ON public.address_usa_tx_77019 USING btree (first_5);


--
-- Name: address_usa_tx_77019_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_6_index ON public.address_usa_tx_77019 USING btree (first_6);


--
-- Name: address_usa_tx_77019_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_7_index ON public.address_usa_tx_77019 USING btree (first_7);


--
-- Name: address_usa_tx_77019_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_8_index ON public.address_usa_tx_77019 USING btree (first_8);


--
-- Name: address_usa_tx_77019_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77019_first_9_index ON public.address_usa_tx_77019 USING btree (first_9);


--
-- Name: address_usa_tx_7701_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_1_index ON public.address_usa_tx_7701 USING btree (first_1);


--
-- Name: address_usa_tx_7701_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_2_index ON public.address_usa_tx_7701 USING btree (first_2);


--
-- Name: address_usa_tx_7701_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_3_index ON public.address_usa_tx_7701 USING btree (first_3);


--
-- Name: address_usa_tx_7701_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_4_index ON public.address_usa_tx_7701 USING btree (first_4);


--
-- Name: address_usa_tx_7701_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_5_index ON public.address_usa_tx_7701 USING btree (first_5);


--
-- Name: address_usa_tx_7701_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_6_index ON public.address_usa_tx_7701 USING btree (first_6);


--
-- Name: address_usa_tx_7701_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_7_index ON public.address_usa_tx_7701 USING btree (first_7);


--
-- Name: address_usa_tx_7701_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_8_index ON public.address_usa_tx_7701 USING btree (first_8);


--
-- Name: address_usa_tx_7701_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7701_first_9_index ON public.address_usa_tx_7701 USING btree (first_9);


--
-- Name: address_usa_tx_77020_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_esiid_index ON public.address_usa_tx_77020 USING btree (esiid);


--
-- Name: address_usa_tx_77020_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_1_index ON public.address_usa_tx_77020 USING btree (first_1);


--
-- Name: address_usa_tx_77020_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_2_index ON public.address_usa_tx_77020 USING btree (first_2);


--
-- Name: address_usa_tx_77020_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_3_index ON public.address_usa_tx_77020 USING btree (first_3);


--
-- Name: address_usa_tx_77020_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_4_index ON public.address_usa_tx_77020 USING btree (first_4);


--
-- Name: address_usa_tx_77020_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_5_index ON public.address_usa_tx_77020 USING btree (first_5);


--
-- Name: address_usa_tx_77020_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_6_index ON public.address_usa_tx_77020 USING btree (first_6);


--
-- Name: address_usa_tx_77020_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_7_index ON public.address_usa_tx_77020 USING btree (first_7);


--
-- Name: address_usa_tx_77020_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_8_index ON public.address_usa_tx_77020 USING btree (first_8);


--
-- Name: address_usa_tx_77020_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77020_first_9_index ON public.address_usa_tx_77020 USING btree (first_9);


--
-- Name: address_usa_tx_77021_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_esiid_index ON public.address_usa_tx_77021 USING btree (esiid);


--
-- Name: address_usa_tx_77021_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_1_index ON public.address_usa_tx_77021 USING btree (first_1);


--
-- Name: address_usa_tx_77021_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_2_index ON public.address_usa_tx_77021 USING btree (first_2);


--
-- Name: address_usa_tx_77021_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_3_index ON public.address_usa_tx_77021 USING btree (first_3);


--
-- Name: address_usa_tx_77021_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_4_index ON public.address_usa_tx_77021 USING btree (first_4);


--
-- Name: address_usa_tx_77021_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_5_index ON public.address_usa_tx_77021 USING btree (first_5);


--
-- Name: address_usa_tx_77021_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_6_index ON public.address_usa_tx_77021 USING btree (first_6);


--
-- Name: address_usa_tx_77021_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_7_index ON public.address_usa_tx_77021 USING btree (first_7);


--
-- Name: address_usa_tx_77021_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_8_index ON public.address_usa_tx_77021 USING btree (first_8);


--
-- Name: address_usa_tx_77021_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77021_first_9_index ON public.address_usa_tx_77021 USING btree (first_9);


--
-- Name: address_usa_tx_77022_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_esiid_index ON public.address_usa_tx_77022 USING btree (esiid);


--
-- Name: address_usa_tx_77022_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_1_index ON public.address_usa_tx_77022 USING btree (first_1);


--
-- Name: address_usa_tx_77022_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_2_index ON public.address_usa_tx_77022 USING btree (first_2);


--
-- Name: address_usa_tx_77022_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_3_index ON public.address_usa_tx_77022 USING btree (first_3);


--
-- Name: address_usa_tx_77022_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_4_index ON public.address_usa_tx_77022 USING btree (first_4);


--
-- Name: address_usa_tx_77022_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_5_index ON public.address_usa_tx_77022 USING btree (first_5);


--
-- Name: address_usa_tx_77022_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_6_index ON public.address_usa_tx_77022 USING btree (first_6);


--
-- Name: address_usa_tx_77022_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_7_index ON public.address_usa_tx_77022 USING btree (first_7);


--
-- Name: address_usa_tx_77022_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_8_index ON public.address_usa_tx_77022 USING btree (first_8);


--
-- Name: address_usa_tx_77022_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77022_first_9_index ON public.address_usa_tx_77022 USING btree (first_9);


--
-- Name: address_usa_tx_77023_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_esiid_index ON public.address_usa_tx_77023 USING btree (esiid);


--
-- Name: address_usa_tx_77023_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_1_index ON public.address_usa_tx_77023 USING btree (first_1);


--
-- Name: address_usa_tx_77023_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_2_index ON public.address_usa_tx_77023 USING btree (first_2);


--
-- Name: address_usa_tx_77023_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_3_index ON public.address_usa_tx_77023 USING btree (first_3);


--
-- Name: address_usa_tx_77023_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_4_index ON public.address_usa_tx_77023 USING btree (first_4);


--
-- Name: address_usa_tx_77023_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_5_index ON public.address_usa_tx_77023 USING btree (first_5);


--
-- Name: address_usa_tx_77023_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_6_index ON public.address_usa_tx_77023 USING btree (first_6);


--
-- Name: address_usa_tx_77023_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_7_index ON public.address_usa_tx_77023 USING btree (first_7);


--
-- Name: address_usa_tx_77023_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_8_index ON public.address_usa_tx_77023 USING btree (first_8);


--
-- Name: address_usa_tx_77023_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77023_first_9_index ON public.address_usa_tx_77023 USING btree (first_9);


--
-- Name: address_usa_tx_77024_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_esiid_index ON public.address_usa_tx_77024 USING btree (esiid);


--
-- Name: address_usa_tx_77024_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_1_index ON public.address_usa_tx_77024 USING btree (first_1);


--
-- Name: address_usa_tx_77024_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_2_index ON public.address_usa_tx_77024 USING btree (first_2);


--
-- Name: address_usa_tx_77024_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_3_index ON public.address_usa_tx_77024 USING btree (first_3);


--
-- Name: address_usa_tx_77024_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_4_index ON public.address_usa_tx_77024 USING btree (first_4);


--
-- Name: address_usa_tx_77024_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_5_index ON public.address_usa_tx_77024 USING btree (first_5);


--
-- Name: address_usa_tx_77024_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_6_index ON public.address_usa_tx_77024 USING btree (first_6);


--
-- Name: address_usa_tx_77024_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_7_index ON public.address_usa_tx_77024 USING btree (first_7);


--
-- Name: address_usa_tx_77024_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_8_index ON public.address_usa_tx_77024 USING btree (first_8);


--
-- Name: address_usa_tx_77024_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77024_first_9_index ON public.address_usa_tx_77024 USING btree (first_9);


--
-- Name: address_usa_tx_77025_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_esiid_index ON public.address_usa_tx_77025 USING btree (esiid);


--
-- Name: address_usa_tx_77025_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_1_index ON public.address_usa_tx_77025 USING btree (first_1);


--
-- Name: address_usa_tx_77025_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_2_index ON public.address_usa_tx_77025 USING btree (first_2);


--
-- Name: address_usa_tx_77025_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_3_index ON public.address_usa_tx_77025 USING btree (first_3);


--
-- Name: address_usa_tx_77025_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_4_index ON public.address_usa_tx_77025 USING btree (first_4);


--
-- Name: address_usa_tx_77025_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_5_index ON public.address_usa_tx_77025 USING btree (first_5);


--
-- Name: address_usa_tx_77025_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_6_index ON public.address_usa_tx_77025 USING btree (first_6);


--
-- Name: address_usa_tx_77025_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_7_index ON public.address_usa_tx_77025 USING btree (first_7);


--
-- Name: address_usa_tx_77025_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_8_index ON public.address_usa_tx_77025 USING btree (first_8);


--
-- Name: address_usa_tx_77025_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77025_first_9_index ON public.address_usa_tx_77025 USING btree (first_9);


--
-- Name: address_usa_tx_77026_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_esiid_index ON public.address_usa_tx_77026 USING btree (esiid);


--
-- Name: address_usa_tx_77026_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_1_index ON public.address_usa_tx_77026 USING btree (first_1);


--
-- Name: address_usa_tx_77026_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_2_index ON public.address_usa_tx_77026 USING btree (first_2);


--
-- Name: address_usa_tx_77026_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_3_index ON public.address_usa_tx_77026 USING btree (first_3);


--
-- Name: address_usa_tx_77026_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_4_index ON public.address_usa_tx_77026 USING btree (first_4);


--
-- Name: address_usa_tx_77026_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_5_index ON public.address_usa_tx_77026 USING btree (first_5);


--
-- Name: address_usa_tx_77026_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_6_index ON public.address_usa_tx_77026 USING btree (first_6);


--
-- Name: address_usa_tx_77026_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_7_index ON public.address_usa_tx_77026 USING btree (first_7);


--
-- Name: address_usa_tx_77026_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_8_index ON public.address_usa_tx_77026 USING btree (first_8);


--
-- Name: address_usa_tx_77026_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77026_first_9_index ON public.address_usa_tx_77026 USING btree (first_9);


--
-- Name: address_usa_tx_77027_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_esiid_index ON public.address_usa_tx_77027 USING btree (esiid);


--
-- Name: address_usa_tx_77027_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_1_index ON public.address_usa_tx_77027 USING btree (first_1);


--
-- Name: address_usa_tx_77027_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_2_index ON public.address_usa_tx_77027 USING btree (first_2);


--
-- Name: address_usa_tx_77027_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_3_index ON public.address_usa_tx_77027 USING btree (first_3);


--
-- Name: address_usa_tx_77027_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_4_index ON public.address_usa_tx_77027 USING btree (first_4);


--
-- Name: address_usa_tx_77027_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_5_index ON public.address_usa_tx_77027 USING btree (first_5);


--
-- Name: address_usa_tx_77027_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_6_index ON public.address_usa_tx_77027 USING btree (first_6);


--
-- Name: address_usa_tx_77027_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_7_index ON public.address_usa_tx_77027 USING btree (first_7);


--
-- Name: address_usa_tx_77027_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_8_index ON public.address_usa_tx_77027 USING btree (first_8);


--
-- Name: address_usa_tx_77027_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77027_first_9_index ON public.address_usa_tx_77027 USING btree (first_9);


--
-- Name: address_usa_tx_77028_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_esiid_index ON public.address_usa_tx_77028 USING btree (esiid);


--
-- Name: address_usa_tx_77028_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_1_index ON public.address_usa_tx_77028 USING btree (first_1);


--
-- Name: address_usa_tx_77028_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_2_index ON public.address_usa_tx_77028 USING btree (first_2);


--
-- Name: address_usa_tx_77028_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_3_index ON public.address_usa_tx_77028 USING btree (first_3);


--
-- Name: address_usa_tx_77028_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_4_index ON public.address_usa_tx_77028 USING btree (first_4);


--
-- Name: address_usa_tx_77028_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_5_index ON public.address_usa_tx_77028 USING btree (first_5);


--
-- Name: address_usa_tx_77028_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_6_index ON public.address_usa_tx_77028 USING btree (first_6);


--
-- Name: address_usa_tx_77028_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_7_index ON public.address_usa_tx_77028 USING btree (first_7);


--
-- Name: address_usa_tx_77028_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_8_index ON public.address_usa_tx_77028 USING btree (first_8);


--
-- Name: address_usa_tx_77028_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77028_first_9_index ON public.address_usa_tx_77028 USING btree (first_9);


--
-- Name: address_usa_tx_77029_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_esiid_index ON public.address_usa_tx_77029 USING btree (esiid);


--
-- Name: address_usa_tx_77029_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_1_index ON public.address_usa_tx_77029 USING btree (first_1);


--
-- Name: address_usa_tx_77029_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_2_index ON public.address_usa_tx_77029 USING btree (first_2);


--
-- Name: address_usa_tx_77029_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_3_index ON public.address_usa_tx_77029 USING btree (first_3);


--
-- Name: address_usa_tx_77029_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_4_index ON public.address_usa_tx_77029 USING btree (first_4);


--
-- Name: address_usa_tx_77029_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_5_index ON public.address_usa_tx_77029 USING btree (first_5);


--
-- Name: address_usa_tx_77029_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_6_index ON public.address_usa_tx_77029 USING btree (first_6);


--
-- Name: address_usa_tx_77029_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_7_index ON public.address_usa_tx_77029 USING btree (first_7);


--
-- Name: address_usa_tx_77029_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_8_index ON public.address_usa_tx_77029 USING btree (first_8);


--
-- Name: address_usa_tx_77029_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77029_first_9_index ON public.address_usa_tx_77029 USING btree (first_9);


--
-- Name: address_usa_tx_7702_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_1_index ON public.address_usa_tx_7702 USING btree (first_1);


--
-- Name: address_usa_tx_7702_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_2_index ON public.address_usa_tx_7702 USING btree (first_2);


--
-- Name: address_usa_tx_7702_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_3_index ON public.address_usa_tx_7702 USING btree (first_3);


--
-- Name: address_usa_tx_7702_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_4_index ON public.address_usa_tx_7702 USING btree (first_4);


--
-- Name: address_usa_tx_7702_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_5_index ON public.address_usa_tx_7702 USING btree (first_5);


--
-- Name: address_usa_tx_7702_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_6_index ON public.address_usa_tx_7702 USING btree (first_6);


--
-- Name: address_usa_tx_7702_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_7_index ON public.address_usa_tx_7702 USING btree (first_7);


--
-- Name: address_usa_tx_7702_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_8_index ON public.address_usa_tx_7702 USING btree (first_8);


--
-- Name: address_usa_tx_7702_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7702_first_9_index ON public.address_usa_tx_7702 USING btree (first_9);


--
-- Name: address_usa_tx_77030_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_esiid_index ON public.address_usa_tx_77030 USING btree (esiid);


--
-- Name: address_usa_tx_77030_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_1_index ON public.address_usa_tx_77030 USING btree (first_1);


--
-- Name: address_usa_tx_77030_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_2_index ON public.address_usa_tx_77030 USING btree (first_2);


--
-- Name: address_usa_tx_77030_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_3_index ON public.address_usa_tx_77030 USING btree (first_3);


--
-- Name: address_usa_tx_77030_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_4_index ON public.address_usa_tx_77030 USING btree (first_4);


--
-- Name: address_usa_tx_77030_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_5_index ON public.address_usa_tx_77030 USING btree (first_5);


--
-- Name: address_usa_tx_77030_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_6_index ON public.address_usa_tx_77030 USING btree (first_6);


--
-- Name: address_usa_tx_77030_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_7_index ON public.address_usa_tx_77030 USING btree (first_7);


--
-- Name: address_usa_tx_77030_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_8_index ON public.address_usa_tx_77030 USING btree (first_8);


--
-- Name: address_usa_tx_77030_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77030_first_9_index ON public.address_usa_tx_77030 USING btree (first_9);


--
-- Name: address_usa_tx_77031_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_esiid_index ON public.address_usa_tx_77031 USING btree (esiid);


--
-- Name: address_usa_tx_77031_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_1_index ON public.address_usa_tx_77031 USING btree (first_1);


--
-- Name: address_usa_tx_77031_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_2_index ON public.address_usa_tx_77031 USING btree (first_2);


--
-- Name: address_usa_tx_77031_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_3_index ON public.address_usa_tx_77031 USING btree (first_3);


--
-- Name: address_usa_tx_77031_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_4_index ON public.address_usa_tx_77031 USING btree (first_4);


--
-- Name: address_usa_tx_77031_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_5_index ON public.address_usa_tx_77031 USING btree (first_5);


--
-- Name: address_usa_tx_77031_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_6_index ON public.address_usa_tx_77031 USING btree (first_6);


--
-- Name: address_usa_tx_77031_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_7_index ON public.address_usa_tx_77031 USING btree (first_7);


--
-- Name: address_usa_tx_77031_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_8_index ON public.address_usa_tx_77031 USING btree (first_8);


--
-- Name: address_usa_tx_77031_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77031_first_9_index ON public.address_usa_tx_77031 USING btree (first_9);


--
-- Name: address_usa_tx_77032_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_esiid_index ON public.address_usa_tx_77032 USING btree (esiid);


--
-- Name: address_usa_tx_77032_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_1_index ON public.address_usa_tx_77032 USING btree (first_1);


--
-- Name: address_usa_tx_77032_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_2_index ON public.address_usa_tx_77032 USING btree (first_2);


--
-- Name: address_usa_tx_77032_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_3_index ON public.address_usa_tx_77032 USING btree (first_3);


--
-- Name: address_usa_tx_77032_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_4_index ON public.address_usa_tx_77032 USING btree (first_4);


--
-- Name: address_usa_tx_77032_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_5_index ON public.address_usa_tx_77032 USING btree (first_5);


--
-- Name: address_usa_tx_77032_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_6_index ON public.address_usa_tx_77032 USING btree (first_6);


--
-- Name: address_usa_tx_77032_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_7_index ON public.address_usa_tx_77032 USING btree (first_7);


--
-- Name: address_usa_tx_77032_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_8_index ON public.address_usa_tx_77032 USING btree (first_8);


--
-- Name: address_usa_tx_77032_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77032_first_9_index ON public.address_usa_tx_77032 USING btree (first_9);


--
-- Name: address_usa_tx_77033_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_esiid_index ON public.address_usa_tx_77033 USING btree (esiid);


--
-- Name: address_usa_tx_77033_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_1_index ON public.address_usa_tx_77033 USING btree (first_1);


--
-- Name: address_usa_tx_77033_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_2_index ON public.address_usa_tx_77033 USING btree (first_2);


--
-- Name: address_usa_tx_77033_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_3_index ON public.address_usa_tx_77033 USING btree (first_3);


--
-- Name: address_usa_tx_77033_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_4_index ON public.address_usa_tx_77033 USING btree (first_4);


--
-- Name: address_usa_tx_77033_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_5_index ON public.address_usa_tx_77033 USING btree (first_5);


--
-- Name: address_usa_tx_77033_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_6_index ON public.address_usa_tx_77033 USING btree (first_6);


--
-- Name: address_usa_tx_77033_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_7_index ON public.address_usa_tx_77033 USING btree (first_7);


--
-- Name: address_usa_tx_77033_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_8_index ON public.address_usa_tx_77033 USING btree (first_8);


--
-- Name: address_usa_tx_77033_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77033_first_9_index ON public.address_usa_tx_77033 USING btree (first_9);


--
-- Name: address_usa_tx_77034_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_esiid_index ON public.address_usa_tx_77034 USING btree (esiid);


--
-- Name: address_usa_tx_77034_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_1_index ON public.address_usa_tx_77034 USING btree (first_1);


--
-- Name: address_usa_tx_77034_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_2_index ON public.address_usa_tx_77034 USING btree (first_2);


--
-- Name: address_usa_tx_77034_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_3_index ON public.address_usa_tx_77034 USING btree (first_3);


--
-- Name: address_usa_tx_77034_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_4_index ON public.address_usa_tx_77034 USING btree (first_4);


--
-- Name: address_usa_tx_77034_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_5_index ON public.address_usa_tx_77034 USING btree (first_5);


--
-- Name: address_usa_tx_77034_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_6_index ON public.address_usa_tx_77034 USING btree (first_6);


--
-- Name: address_usa_tx_77034_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_7_index ON public.address_usa_tx_77034 USING btree (first_7);


--
-- Name: address_usa_tx_77034_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_8_index ON public.address_usa_tx_77034 USING btree (first_8);


--
-- Name: address_usa_tx_77034_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77034_first_9_index ON public.address_usa_tx_77034 USING btree (first_9);


--
-- Name: address_usa_tx_77035_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_esiid_index ON public.address_usa_tx_77035 USING btree (esiid);


--
-- Name: address_usa_tx_77035_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_1_index ON public.address_usa_tx_77035 USING btree (first_1);


--
-- Name: address_usa_tx_77035_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_2_index ON public.address_usa_tx_77035 USING btree (first_2);


--
-- Name: address_usa_tx_77035_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_3_index ON public.address_usa_tx_77035 USING btree (first_3);


--
-- Name: address_usa_tx_77035_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_4_index ON public.address_usa_tx_77035 USING btree (first_4);


--
-- Name: address_usa_tx_77035_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_5_index ON public.address_usa_tx_77035 USING btree (first_5);


--
-- Name: address_usa_tx_77035_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_6_index ON public.address_usa_tx_77035 USING btree (first_6);


--
-- Name: address_usa_tx_77035_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_7_index ON public.address_usa_tx_77035 USING btree (first_7);


--
-- Name: address_usa_tx_77035_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_8_index ON public.address_usa_tx_77035 USING btree (first_8);


--
-- Name: address_usa_tx_77035_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77035_first_9_index ON public.address_usa_tx_77035 USING btree (first_9);


--
-- Name: address_usa_tx_77036_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_esiid_index ON public.address_usa_tx_77036 USING btree (esiid);


--
-- Name: address_usa_tx_77036_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_1_index ON public.address_usa_tx_77036 USING btree (first_1);


--
-- Name: address_usa_tx_77036_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_2_index ON public.address_usa_tx_77036 USING btree (first_2);


--
-- Name: address_usa_tx_77036_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_3_index ON public.address_usa_tx_77036 USING btree (first_3);


--
-- Name: address_usa_tx_77036_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_4_index ON public.address_usa_tx_77036 USING btree (first_4);


--
-- Name: address_usa_tx_77036_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_5_index ON public.address_usa_tx_77036 USING btree (first_5);


--
-- Name: address_usa_tx_77036_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_6_index ON public.address_usa_tx_77036 USING btree (first_6);


--
-- Name: address_usa_tx_77036_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_7_index ON public.address_usa_tx_77036 USING btree (first_7);


--
-- Name: address_usa_tx_77036_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_8_index ON public.address_usa_tx_77036 USING btree (first_8);


--
-- Name: address_usa_tx_77036_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77036_first_9_index ON public.address_usa_tx_77036 USING btree (first_9);


--
-- Name: address_usa_tx_77037_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_esiid_index ON public.address_usa_tx_77037 USING btree (esiid);


--
-- Name: address_usa_tx_77037_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_1_index ON public.address_usa_tx_77037 USING btree (first_1);


--
-- Name: address_usa_tx_77037_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_2_index ON public.address_usa_tx_77037 USING btree (first_2);


--
-- Name: address_usa_tx_77037_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_3_index ON public.address_usa_tx_77037 USING btree (first_3);


--
-- Name: address_usa_tx_77037_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_4_index ON public.address_usa_tx_77037 USING btree (first_4);


--
-- Name: address_usa_tx_77037_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_5_index ON public.address_usa_tx_77037 USING btree (first_5);


--
-- Name: address_usa_tx_77037_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_6_index ON public.address_usa_tx_77037 USING btree (first_6);


--
-- Name: address_usa_tx_77037_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_7_index ON public.address_usa_tx_77037 USING btree (first_7);


--
-- Name: address_usa_tx_77037_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_8_index ON public.address_usa_tx_77037 USING btree (first_8);


--
-- Name: address_usa_tx_77037_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77037_first_9_index ON public.address_usa_tx_77037 USING btree (first_9);


--
-- Name: address_usa_tx_77038_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_esiid_index ON public.address_usa_tx_77038 USING btree (esiid);


--
-- Name: address_usa_tx_77038_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_1_index ON public.address_usa_tx_77038 USING btree (first_1);


--
-- Name: address_usa_tx_77038_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_2_index ON public.address_usa_tx_77038 USING btree (first_2);


--
-- Name: address_usa_tx_77038_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_3_index ON public.address_usa_tx_77038 USING btree (first_3);


--
-- Name: address_usa_tx_77038_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_4_index ON public.address_usa_tx_77038 USING btree (first_4);


--
-- Name: address_usa_tx_77038_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_5_index ON public.address_usa_tx_77038 USING btree (first_5);


--
-- Name: address_usa_tx_77038_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_6_index ON public.address_usa_tx_77038 USING btree (first_6);


--
-- Name: address_usa_tx_77038_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_7_index ON public.address_usa_tx_77038 USING btree (first_7);


--
-- Name: address_usa_tx_77038_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_8_index ON public.address_usa_tx_77038 USING btree (first_8);


--
-- Name: address_usa_tx_77038_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77038_first_9_index ON public.address_usa_tx_77038 USING btree (first_9);


--
-- Name: address_usa_tx_77039_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_esiid_index ON public.address_usa_tx_77039 USING btree (esiid);


--
-- Name: address_usa_tx_77039_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_1_index ON public.address_usa_tx_77039 USING btree (first_1);


--
-- Name: address_usa_tx_77039_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_2_index ON public.address_usa_tx_77039 USING btree (first_2);


--
-- Name: address_usa_tx_77039_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_3_index ON public.address_usa_tx_77039 USING btree (first_3);


--
-- Name: address_usa_tx_77039_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_4_index ON public.address_usa_tx_77039 USING btree (first_4);


--
-- Name: address_usa_tx_77039_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_5_index ON public.address_usa_tx_77039 USING btree (first_5);


--
-- Name: address_usa_tx_77039_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_6_index ON public.address_usa_tx_77039 USING btree (first_6);


--
-- Name: address_usa_tx_77039_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_7_index ON public.address_usa_tx_77039 USING btree (first_7);


--
-- Name: address_usa_tx_77039_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_8_index ON public.address_usa_tx_77039 USING btree (first_8);


--
-- Name: address_usa_tx_77039_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77039_first_9_index ON public.address_usa_tx_77039 USING btree (first_9);


--
-- Name: address_usa_tx_7703_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_1_index ON public.address_usa_tx_7703 USING btree (first_1);


--
-- Name: address_usa_tx_7703_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_2_index ON public.address_usa_tx_7703 USING btree (first_2);


--
-- Name: address_usa_tx_7703_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_3_index ON public.address_usa_tx_7703 USING btree (first_3);


--
-- Name: address_usa_tx_7703_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_4_index ON public.address_usa_tx_7703 USING btree (first_4);


--
-- Name: address_usa_tx_7703_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_5_index ON public.address_usa_tx_7703 USING btree (first_5);


--
-- Name: address_usa_tx_7703_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_6_index ON public.address_usa_tx_7703 USING btree (first_6);


--
-- Name: address_usa_tx_7703_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_7_index ON public.address_usa_tx_7703 USING btree (first_7);


--
-- Name: address_usa_tx_7703_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_8_index ON public.address_usa_tx_7703 USING btree (first_8);


--
-- Name: address_usa_tx_7703_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7703_first_9_index ON public.address_usa_tx_7703 USING btree (first_9);


--
-- Name: address_usa_tx_77040_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_esiid_index ON public.address_usa_tx_77040 USING btree (esiid);


--
-- Name: address_usa_tx_77040_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_1_index ON public.address_usa_tx_77040 USING btree (first_1);


--
-- Name: address_usa_tx_77040_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_2_index ON public.address_usa_tx_77040 USING btree (first_2);


--
-- Name: address_usa_tx_77040_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_3_index ON public.address_usa_tx_77040 USING btree (first_3);


--
-- Name: address_usa_tx_77040_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_4_index ON public.address_usa_tx_77040 USING btree (first_4);


--
-- Name: address_usa_tx_77040_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_5_index ON public.address_usa_tx_77040 USING btree (first_5);


--
-- Name: address_usa_tx_77040_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_6_index ON public.address_usa_tx_77040 USING btree (first_6);


--
-- Name: address_usa_tx_77040_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_7_index ON public.address_usa_tx_77040 USING btree (first_7);


--
-- Name: address_usa_tx_77040_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_8_index ON public.address_usa_tx_77040 USING btree (first_8);


--
-- Name: address_usa_tx_77040_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77040_first_9_index ON public.address_usa_tx_77040 USING btree (first_9);


--
-- Name: address_usa_tx_77041_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_esiid_index ON public.address_usa_tx_77041 USING btree (esiid);


--
-- Name: address_usa_tx_77041_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_1_index ON public.address_usa_tx_77041 USING btree (first_1);


--
-- Name: address_usa_tx_77041_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_2_index ON public.address_usa_tx_77041 USING btree (first_2);


--
-- Name: address_usa_tx_77041_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_3_index ON public.address_usa_tx_77041 USING btree (first_3);


--
-- Name: address_usa_tx_77041_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_4_index ON public.address_usa_tx_77041 USING btree (first_4);


--
-- Name: address_usa_tx_77041_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_5_index ON public.address_usa_tx_77041 USING btree (first_5);


--
-- Name: address_usa_tx_77041_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_6_index ON public.address_usa_tx_77041 USING btree (first_6);


--
-- Name: address_usa_tx_77041_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_7_index ON public.address_usa_tx_77041 USING btree (first_7);


--
-- Name: address_usa_tx_77041_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_8_index ON public.address_usa_tx_77041 USING btree (first_8);


--
-- Name: address_usa_tx_77041_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77041_first_9_index ON public.address_usa_tx_77041 USING btree (first_9);


--
-- Name: address_usa_tx_77042_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_esiid_index ON public.address_usa_tx_77042 USING btree (esiid);


--
-- Name: address_usa_tx_77042_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_1_index ON public.address_usa_tx_77042 USING btree (first_1);


--
-- Name: address_usa_tx_77042_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_2_index ON public.address_usa_tx_77042 USING btree (first_2);


--
-- Name: address_usa_tx_77042_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_3_index ON public.address_usa_tx_77042 USING btree (first_3);


--
-- Name: address_usa_tx_77042_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_4_index ON public.address_usa_tx_77042 USING btree (first_4);


--
-- Name: address_usa_tx_77042_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_5_index ON public.address_usa_tx_77042 USING btree (first_5);


--
-- Name: address_usa_tx_77042_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_6_index ON public.address_usa_tx_77042 USING btree (first_6);


--
-- Name: address_usa_tx_77042_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_7_index ON public.address_usa_tx_77042 USING btree (first_7);


--
-- Name: address_usa_tx_77042_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_8_index ON public.address_usa_tx_77042 USING btree (first_8);


--
-- Name: address_usa_tx_77042_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77042_first_9_index ON public.address_usa_tx_77042 USING btree (first_9);


--
-- Name: address_usa_tx_77043_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_esiid_index ON public.address_usa_tx_77043 USING btree (esiid);


--
-- Name: address_usa_tx_77043_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_1_index ON public.address_usa_tx_77043 USING btree (first_1);


--
-- Name: address_usa_tx_77043_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_2_index ON public.address_usa_tx_77043 USING btree (first_2);


--
-- Name: address_usa_tx_77043_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_3_index ON public.address_usa_tx_77043 USING btree (first_3);


--
-- Name: address_usa_tx_77043_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_4_index ON public.address_usa_tx_77043 USING btree (first_4);


--
-- Name: address_usa_tx_77043_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_5_index ON public.address_usa_tx_77043 USING btree (first_5);


--
-- Name: address_usa_tx_77043_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_6_index ON public.address_usa_tx_77043 USING btree (first_6);


--
-- Name: address_usa_tx_77043_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_7_index ON public.address_usa_tx_77043 USING btree (first_7);


--
-- Name: address_usa_tx_77043_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_8_index ON public.address_usa_tx_77043 USING btree (first_8);


--
-- Name: address_usa_tx_77043_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77043_first_9_index ON public.address_usa_tx_77043 USING btree (first_9);


--
-- Name: address_usa_tx_77044_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_esiid_index ON public.address_usa_tx_77044 USING btree (esiid);


--
-- Name: address_usa_tx_77044_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_1_index ON public.address_usa_tx_77044 USING btree (first_1);


--
-- Name: address_usa_tx_77044_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_2_index ON public.address_usa_tx_77044 USING btree (first_2);


--
-- Name: address_usa_tx_77044_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_3_index ON public.address_usa_tx_77044 USING btree (first_3);


--
-- Name: address_usa_tx_77044_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_4_index ON public.address_usa_tx_77044 USING btree (first_4);


--
-- Name: address_usa_tx_77044_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_5_index ON public.address_usa_tx_77044 USING btree (first_5);


--
-- Name: address_usa_tx_77044_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_6_index ON public.address_usa_tx_77044 USING btree (first_6);


--
-- Name: address_usa_tx_77044_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_7_index ON public.address_usa_tx_77044 USING btree (first_7);


--
-- Name: address_usa_tx_77044_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_8_index ON public.address_usa_tx_77044 USING btree (first_8);


--
-- Name: address_usa_tx_77044_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77044_first_9_index ON public.address_usa_tx_77044 USING btree (first_9);


--
-- Name: address_usa_tx_77045_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_esiid_index ON public.address_usa_tx_77045 USING btree (esiid);


--
-- Name: address_usa_tx_77045_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_1_index ON public.address_usa_tx_77045 USING btree (first_1);


--
-- Name: address_usa_tx_77045_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_2_index ON public.address_usa_tx_77045 USING btree (first_2);


--
-- Name: address_usa_tx_77045_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_3_index ON public.address_usa_tx_77045 USING btree (first_3);


--
-- Name: address_usa_tx_77045_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_4_index ON public.address_usa_tx_77045 USING btree (first_4);


--
-- Name: address_usa_tx_77045_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_5_index ON public.address_usa_tx_77045 USING btree (first_5);


--
-- Name: address_usa_tx_77045_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_6_index ON public.address_usa_tx_77045 USING btree (first_6);


--
-- Name: address_usa_tx_77045_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_7_index ON public.address_usa_tx_77045 USING btree (first_7);


--
-- Name: address_usa_tx_77045_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_8_index ON public.address_usa_tx_77045 USING btree (first_8);


--
-- Name: address_usa_tx_77045_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77045_first_9_index ON public.address_usa_tx_77045 USING btree (first_9);


--
-- Name: address_usa_tx_77046_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_esiid_index ON public.address_usa_tx_77046 USING btree (esiid);


--
-- Name: address_usa_tx_77046_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_1_index ON public.address_usa_tx_77046 USING btree (first_1);


--
-- Name: address_usa_tx_77046_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_2_index ON public.address_usa_tx_77046 USING btree (first_2);


--
-- Name: address_usa_tx_77046_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_3_index ON public.address_usa_tx_77046 USING btree (first_3);


--
-- Name: address_usa_tx_77046_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_4_index ON public.address_usa_tx_77046 USING btree (first_4);


--
-- Name: address_usa_tx_77046_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_5_index ON public.address_usa_tx_77046 USING btree (first_5);


--
-- Name: address_usa_tx_77046_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_6_index ON public.address_usa_tx_77046 USING btree (first_6);


--
-- Name: address_usa_tx_77046_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_7_index ON public.address_usa_tx_77046 USING btree (first_7);


--
-- Name: address_usa_tx_77046_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_8_index ON public.address_usa_tx_77046 USING btree (first_8);


--
-- Name: address_usa_tx_77046_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77046_first_9_index ON public.address_usa_tx_77046 USING btree (first_9);


--
-- Name: address_usa_tx_77047_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_esiid_index ON public.address_usa_tx_77047 USING btree (esiid);


--
-- Name: address_usa_tx_77047_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_1_index ON public.address_usa_tx_77047 USING btree (first_1);


--
-- Name: address_usa_tx_77047_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_2_index ON public.address_usa_tx_77047 USING btree (first_2);


--
-- Name: address_usa_tx_77047_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_3_index ON public.address_usa_tx_77047 USING btree (first_3);


--
-- Name: address_usa_tx_77047_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_4_index ON public.address_usa_tx_77047 USING btree (first_4);


--
-- Name: address_usa_tx_77047_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_5_index ON public.address_usa_tx_77047 USING btree (first_5);


--
-- Name: address_usa_tx_77047_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_6_index ON public.address_usa_tx_77047 USING btree (first_6);


--
-- Name: address_usa_tx_77047_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_7_index ON public.address_usa_tx_77047 USING btree (first_7);


--
-- Name: address_usa_tx_77047_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_8_index ON public.address_usa_tx_77047 USING btree (first_8);


--
-- Name: address_usa_tx_77047_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77047_first_9_index ON public.address_usa_tx_77047 USING btree (first_9);


--
-- Name: address_usa_tx_77048_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_esiid_index ON public.address_usa_tx_77048 USING btree (esiid);


--
-- Name: address_usa_tx_77048_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_1_index ON public.address_usa_tx_77048 USING btree (first_1);


--
-- Name: address_usa_tx_77048_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_2_index ON public.address_usa_tx_77048 USING btree (first_2);


--
-- Name: address_usa_tx_77048_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_3_index ON public.address_usa_tx_77048 USING btree (first_3);


--
-- Name: address_usa_tx_77048_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_4_index ON public.address_usa_tx_77048 USING btree (first_4);


--
-- Name: address_usa_tx_77048_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_5_index ON public.address_usa_tx_77048 USING btree (first_5);


--
-- Name: address_usa_tx_77048_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_6_index ON public.address_usa_tx_77048 USING btree (first_6);


--
-- Name: address_usa_tx_77048_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_7_index ON public.address_usa_tx_77048 USING btree (first_7);


--
-- Name: address_usa_tx_77048_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_8_index ON public.address_usa_tx_77048 USING btree (first_8);


--
-- Name: address_usa_tx_77048_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77048_first_9_index ON public.address_usa_tx_77048 USING btree (first_9);


--
-- Name: address_usa_tx_77049_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_esiid_index ON public.address_usa_tx_77049 USING btree (esiid);


--
-- Name: address_usa_tx_77049_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_1_index ON public.address_usa_tx_77049 USING btree (first_1);


--
-- Name: address_usa_tx_77049_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_2_index ON public.address_usa_tx_77049 USING btree (first_2);


--
-- Name: address_usa_tx_77049_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_3_index ON public.address_usa_tx_77049 USING btree (first_3);


--
-- Name: address_usa_tx_77049_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_4_index ON public.address_usa_tx_77049 USING btree (first_4);


--
-- Name: address_usa_tx_77049_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_5_index ON public.address_usa_tx_77049 USING btree (first_5);


--
-- Name: address_usa_tx_77049_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_6_index ON public.address_usa_tx_77049 USING btree (first_6);


--
-- Name: address_usa_tx_77049_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_7_index ON public.address_usa_tx_77049 USING btree (first_7);


--
-- Name: address_usa_tx_77049_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_8_index ON public.address_usa_tx_77049 USING btree (first_8);


--
-- Name: address_usa_tx_77049_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77049_first_9_index ON public.address_usa_tx_77049 USING btree (first_9);


--
-- Name: address_usa_tx_7704_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_1_index ON public.address_usa_tx_7704 USING btree (first_1);


--
-- Name: address_usa_tx_7704_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_2_index ON public.address_usa_tx_7704 USING btree (first_2);


--
-- Name: address_usa_tx_7704_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_3_index ON public.address_usa_tx_7704 USING btree (first_3);


--
-- Name: address_usa_tx_7704_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_4_index ON public.address_usa_tx_7704 USING btree (first_4);


--
-- Name: address_usa_tx_7704_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_5_index ON public.address_usa_tx_7704 USING btree (first_5);


--
-- Name: address_usa_tx_7704_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_6_index ON public.address_usa_tx_7704 USING btree (first_6);


--
-- Name: address_usa_tx_7704_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_7_index ON public.address_usa_tx_7704 USING btree (first_7);


--
-- Name: address_usa_tx_7704_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_8_index ON public.address_usa_tx_7704 USING btree (first_8);


--
-- Name: address_usa_tx_7704_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7704_first_9_index ON public.address_usa_tx_7704 USING btree (first_9);


--
-- Name: address_usa_tx_77050_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_esiid_index ON public.address_usa_tx_77050 USING btree (esiid);


--
-- Name: address_usa_tx_77050_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_1_index ON public.address_usa_tx_77050 USING btree (first_1);


--
-- Name: address_usa_tx_77050_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_2_index ON public.address_usa_tx_77050 USING btree (first_2);


--
-- Name: address_usa_tx_77050_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_3_index ON public.address_usa_tx_77050 USING btree (first_3);


--
-- Name: address_usa_tx_77050_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_4_index ON public.address_usa_tx_77050 USING btree (first_4);


--
-- Name: address_usa_tx_77050_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_5_index ON public.address_usa_tx_77050 USING btree (first_5);


--
-- Name: address_usa_tx_77050_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_6_index ON public.address_usa_tx_77050 USING btree (first_6);


--
-- Name: address_usa_tx_77050_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_7_index ON public.address_usa_tx_77050 USING btree (first_7);


--
-- Name: address_usa_tx_77050_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_8_index ON public.address_usa_tx_77050 USING btree (first_8);


--
-- Name: address_usa_tx_77050_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77050_first_9_index ON public.address_usa_tx_77050 USING btree (first_9);


--
-- Name: address_usa_tx_77051_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_esiid_index ON public.address_usa_tx_77051 USING btree (esiid);


--
-- Name: address_usa_tx_77051_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_1_index ON public.address_usa_tx_77051 USING btree (first_1);


--
-- Name: address_usa_tx_77051_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_2_index ON public.address_usa_tx_77051 USING btree (first_2);


--
-- Name: address_usa_tx_77051_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_3_index ON public.address_usa_tx_77051 USING btree (first_3);


--
-- Name: address_usa_tx_77051_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_4_index ON public.address_usa_tx_77051 USING btree (first_4);


--
-- Name: address_usa_tx_77051_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_5_index ON public.address_usa_tx_77051 USING btree (first_5);


--
-- Name: address_usa_tx_77051_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_6_index ON public.address_usa_tx_77051 USING btree (first_6);


--
-- Name: address_usa_tx_77051_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_7_index ON public.address_usa_tx_77051 USING btree (first_7);


--
-- Name: address_usa_tx_77051_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_8_index ON public.address_usa_tx_77051 USING btree (first_8);


--
-- Name: address_usa_tx_77051_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77051_first_9_index ON public.address_usa_tx_77051 USING btree (first_9);


--
-- Name: address_usa_tx_77053_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_esiid_index ON public.address_usa_tx_77053 USING btree (esiid);


--
-- Name: address_usa_tx_77053_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_1_index ON public.address_usa_tx_77053 USING btree (first_1);


--
-- Name: address_usa_tx_77053_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_2_index ON public.address_usa_tx_77053 USING btree (first_2);


--
-- Name: address_usa_tx_77053_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_3_index ON public.address_usa_tx_77053 USING btree (first_3);


--
-- Name: address_usa_tx_77053_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_4_index ON public.address_usa_tx_77053 USING btree (first_4);


--
-- Name: address_usa_tx_77053_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_5_index ON public.address_usa_tx_77053 USING btree (first_5);


--
-- Name: address_usa_tx_77053_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_6_index ON public.address_usa_tx_77053 USING btree (first_6);


--
-- Name: address_usa_tx_77053_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_7_index ON public.address_usa_tx_77053 USING btree (first_7);


--
-- Name: address_usa_tx_77053_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_8_index ON public.address_usa_tx_77053 USING btree (first_8);


--
-- Name: address_usa_tx_77053_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77053_first_9_index ON public.address_usa_tx_77053 USING btree (first_9);


--
-- Name: address_usa_tx_77054_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_esiid_index ON public.address_usa_tx_77054 USING btree (esiid);


--
-- Name: address_usa_tx_77054_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_1_index ON public.address_usa_tx_77054 USING btree (first_1);


--
-- Name: address_usa_tx_77054_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_2_index ON public.address_usa_tx_77054 USING btree (first_2);


--
-- Name: address_usa_tx_77054_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_3_index ON public.address_usa_tx_77054 USING btree (first_3);


--
-- Name: address_usa_tx_77054_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_4_index ON public.address_usa_tx_77054 USING btree (first_4);


--
-- Name: address_usa_tx_77054_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_5_index ON public.address_usa_tx_77054 USING btree (first_5);


--
-- Name: address_usa_tx_77054_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_6_index ON public.address_usa_tx_77054 USING btree (first_6);


--
-- Name: address_usa_tx_77054_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_7_index ON public.address_usa_tx_77054 USING btree (first_7);


--
-- Name: address_usa_tx_77054_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_8_index ON public.address_usa_tx_77054 USING btree (first_8);


--
-- Name: address_usa_tx_77054_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77054_first_9_index ON public.address_usa_tx_77054 USING btree (first_9);


--
-- Name: address_usa_tx_77055_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_esiid_index ON public.address_usa_tx_77055 USING btree (esiid);


--
-- Name: address_usa_tx_77055_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_1_index ON public.address_usa_tx_77055 USING btree (first_1);


--
-- Name: address_usa_tx_77055_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_2_index ON public.address_usa_tx_77055 USING btree (first_2);


--
-- Name: address_usa_tx_77055_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_3_index ON public.address_usa_tx_77055 USING btree (first_3);


--
-- Name: address_usa_tx_77055_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_4_index ON public.address_usa_tx_77055 USING btree (first_4);


--
-- Name: address_usa_tx_77055_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_5_index ON public.address_usa_tx_77055 USING btree (first_5);


--
-- Name: address_usa_tx_77055_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_6_index ON public.address_usa_tx_77055 USING btree (first_6);


--
-- Name: address_usa_tx_77055_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_7_index ON public.address_usa_tx_77055 USING btree (first_7);


--
-- Name: address_usa_tx_77055_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_8_index ON public.address_usa_tx_77055 USING btree (first_8);


--
-- Name: address_usa_tx_77055_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77055_first_9_index ON public.address_usa_tx_77055 USING btree (first_9);


--
-- Name: address_usa_tx_77056_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_esiid_index ON public.address_usa_tx_77056 USING btree (esiid);


--
-- Name: address_usa_tx_77056_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_1_index ON public.address_usa_tx_77056 USING btree (first_1);


--
-- Name: address_usa_tx_77056_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_2_index ON public.address_usa_tx_77056 USING btree (first_2);


--
-- Name: address_usa_tx_77056_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_3_index ON public.address_usa_tx_77056 USING btree (first_3);


--
-- Name: address_usa_tx_77056_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_4_index ON public.address_usa_tx_77056 USING btree (first_4);


--
-- Name: address_usa_tx_77056_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_5_index ON public.address_usa_tx_77056 USING btree (first_5);


--
-- Name: address_usa_tx_77056_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_6_index ON public.address_usa_tx_77056 USING btree (first_6);


--
-- Name: address_usa_tx_77056_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_7_index ON public.address_usa_tx_77056 USING btree (first_7);


--
-- Name: address_usa_tx_77056_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_8_index ON public.address_usa_tx_77056 USING btree (first_8);


--
-- Name: address_usa_tx_77056_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77056_first_9_index ON public.address_usa_tx_77056 USING btree (first_9);


--
-- Name: address_usa_tx_77057_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_esiid_index ON public.address_usa_tx_77057 USING btree (esiid);


--
-- Name: address_usa_tx_77057_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_1_index ON public.address_usa_tx_77057 USING btree (first_1);


--
-- Name: address_usa_tx_77057_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_2_index ON public.address_usa_tx_77057 USING btree (first_2);


--
-- Name: address_usa_tx_77057_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_3_index ON public.address_usa_tx_77057 USING btree (first_3);


--
-- Name: address_usa_tx_77057_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_4_index ON public.address_usa_tx_77057 USING btree (first_4);


--
-- Name: address_usa_tx_77057_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_5_index ON public.address_usa_tx_77057 USING btree (first_5);


--
-- Name: address_usa_tx_77057_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_6_index ON public.address_usa_tx_77057 USING btree (first_6);


--
-- Name: address_usa_tx_77057_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_7_index ON public.address_usa_tx_77057 USING btree (first_7);


--
-- Name: address_usa_tx_77057_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_8_index ON public.address_usa_tx_77057 USING btree (first_8);


--
-- Name: address_usa_tx_77057_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77057_first_9_index ON public.address_usa_tx_77057 USING btree (first_9);


--
-- Name: address_usa_tx_77058_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_esiid_index ON public.address_usa_tx_77058 USING btree (esiid);


--
-- Name: address_usa_tx_77058_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_1_index ON public.address_usa_tx_77058 USING btree (first_1);


--
-- Name: address_usa_tx_77058_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_2_index ON public.address_usa_tx_77058 USING btree (first_2);


--
-- Name: address_usa_tx_77058_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_3_index ON public.address_usa_tx_77058 USING btree (first_3);


--
-- Name: address_usa_tx_77058_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_4_index ON public.address_usa_tx_77058 USING btree (first_4);


--
-- Name: address_usa_tx_77058_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_5_index ON public.address_usa_tx_77058 USING btree (first_5);


--
-- Name: address_usa_tx_77058_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_6_index ON public.address_usa_tx_77058 USING btree (first_6);


--
-- Name: address_usa_tx_77058_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_7_index ON public.address_usa_tx_77058 USING btree (first_7);


--
-- Name: address_usa_tx_77058_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_8_index ON public.address_usa_tx_77058 USING btree (first_8);


--
-- Name: address_usa_tx_77058_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77058_first_9_index ON public.address_usa_tx_77058 USING btree (first_9);


--
-- Name: address_usa_tx_77059_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_esiid_index ON public.address_usa_tx_77059 USING btree (esiid);


--
-- Name: address_usa_tx_77059_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_1_index ON public.address_usa_tx_77059 USING btree (first_1);


--
-- Name: address_usa_tx_77059_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_2_index ON public.address_usa_tx_77059 USING btree (first_2);


--
-- Name: address_usa_tx_77059_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_3_index ON public.address_usa_tx_77059 USING btree (first_3);


--
-- Name: address_usa_tx_77059_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_4_index ON public.address_usa_tx_77059 USING btree (first_4);


--
-- Name: address_usa_tx_77059_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_5_index ON public.address_usa_tx_77059 USING btree (first_5);


--
-- Name: address_usa_tx_77059_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_6_index ON public.address_usa_tx_77059 USING btree (first_6);


--
-- Name: address_usa_tx_77059_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_7_index ON public.address_usa_tx_77059 USING btree (first_7);


--
-- Name: address_usa_tx_77059_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_8_index ON public.address_usa_tx_77059 USING btree (first_8);


--
-- Name: address_usa_tx_77059_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77059_first_9_index ON public.address_usa_tx_77059 USING btree (first_9);


--
-- Name: address_usa_tx_7705_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_1_index ON public.address_usa_tx_7705 USING btree (first_1);


--
-- Name: address_usa_tx_7705_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_2_index ON public.address_usa_tx_7705 USING btree (first_2);


--
-- Name: address_usa_tx_7705_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_3_index ON public.address_usa_tx_7705 USING btree (first_3);


--
-- Name: address_usa_tx_7705_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_4_index ON public.address_usa_tx_7705 USING btree (first_4);


--
-- Name: address_usa_tx_7705_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_5_index ON public.address_usa_tx_7705 USING btree (first_5);


--
-- Name: address_usa_tx_7705_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_6_index ON public.address_usa_tx_7705 USING btree (first_6);


--
-- Name: address_usa_tx_7705_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_7_index ON public.address_usa_tx_7705 USING btree (first_7);


--
-- Name: address_usa_tx_7705_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_8_index ON public.address_usa_tx_7705 USING btree (first_8);


--
-- Name: address_usa_tx_7705_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7705_first_9_index ON public.address_usa_tx_7705 USING btree (first_9);


--
-- Name: address_usa_tx_77060_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_esiid_index ON public.address_usa_tx_77060 USING btree (esiid);


--
-- Name: address_usa_tx_77060_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_1_index ON public.address_usa_tx_77060 USING btree (first_1);


--
-- Name: address_usa_tx_77060_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_2_index ON public.address_usa_tx_77060 USING btree (first_2);


--
-- Name: address_usa_tx_77060_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_3_index ON public.address_usa_tx_77060 USING btree (first_3);


--
-- Name: address_usa_tx_77060_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_4_index ON public.address_usa_tx_77060 USING btree (first_4);


--
-- Name: address_usa_tx_77060_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_5_index ON public.address_usa_tx_77060 USING btree (first_5);


--
-- Name: address_usa_tx_77060_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_6_index ON public.address_usa_tx_77060 USING btree (first_6);


--
-- Name: address_usa_tx_77060_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_7_index ON public.address_usa_tx_77060 USING btree (first_7);


--
-- Name: address_usa_tx_77060_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_8_index ON public.address_usa_tx_77060 USING btree (first_8);


--
-- Name: address_usa_tx_77060_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77060_first_9_index ON public.address_usa_tx_77060 USING btree (first_9);


--
-- Name: address_usa_tx_77061_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_esiid_index ON public.address_usa_tx_77061 USING btree (esiid);


--
-- Name: address_usa_tx_77061_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_1_index ON public.address_usa_tx_77061 USING btree (first_1);


--
-- Name: address_usa_tx_77061_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_2_index ON public.address_usa_tx_77061 USING btree (first_2);


--
-- Name: address_usa_tx_77061_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_3_index ON public.address_usa_tx_77061 USING btree (first_3);


--
-- Name: address_usa_tx_77061_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_4_index ON public.address_usa_tx_77061 USING btree (first_4);


--
-- Name: address_usa_tx_77061_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_5_index ON public.address_usa_tx_77061 USING btree (first_5);


--
-- Name: address_usa_tx_77061_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_6_index ON public.address_usa_tx_77061 USING btree (first_6);


--
-- Name: address_usa_tx_77061_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_7_index ON public.address_usa_tx_77061 USING btree (first_7);


--
-- Name: address_usa_tx_77061_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_8_index ON public.address_usa_tx_77061 USING btree (first_8);


--
-- Name: address_usa_tx_77061_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77061_first_9_index ON public.address_usa_tx_77061 USING btree (first_9);


--
-- Name: address_usa_tx_77062_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_esiid_index ON public.address_usa_tx_77062 USING btree (esiid);


--
-- Name: address_usa_tx_77062_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_1_index ON public.address_usa_tx_77062 USING btree (first_1);


--
-- Name: address_usa_tx_77062_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_2_index ON public.address_usa_tx_77062 USING btree (first_2);


--
-- Name: address_usa_tx_77062_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_3_index ON public.address_usa_tx_77062 USING btree (first_3);


--
-- Name: address_usa_tx_77062_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_4_index ON public.address_usa_tx_77062 USING btree (first_4);


--
-- Name: address_usa_tx_77062_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_5_index ON public.address_usa_tx_77062 USING btree (first_5);


--
-- Name: address_usa_tx_77062_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_6_index ON public.address_usa_tx_77062 USING btree (first_6);


--
-- Name: address_usa_tx_77062_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_7_index ON public.address_usa_tx_77062 USING btree (first_7);


--
-- Name: address_usa_tx_77062_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_8_index ON public.address_usa_tx_77062 USING btree (first_8);


--
-- Name: address_usa_tx_77062_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77062_first_9_index ON public.address_usa_tx_77062 USING btree (first_9);


--
-- Name: address_usa_tx_77063_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_esiid_index ON public.address_usa_tx_77063 USING btree (esiid);


--
-- Name: address_usa_tx_77063_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_1_index ON public.address_usa_tx_77063 USING btree (first_1);


--
-- Name: address_usa_tx_77063_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_2_index ON public.address_usa_tx_77063 USING btree (first_2);


--
-- Name: address_usa_tx_77063_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_3_index ON public.address_usa_tx_77063 USING btree (first_3);


--
-- Name: address_usa_tx_77063_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_4_index ON public.address_usa_tx_77063 USING btree (first_4);


--
-- Name: address_usa_tx_77063_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_5_index ON public.address_usa_tx_77063 USING btree (first_5);


--
-- Name: address_usa_tx_77063_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_6_index ON public.address_usa_tx_77063 USING btree (first_6);


--
-- Name: address_usa_tx_77063_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_7_index ON public.address_usa_tx_77063 USING btree (first_7);


--
-- Name: address_usa_tx_77063_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_8_index ON public.address_usa_tx_77063 USING btree (first_8);


--
-- Name: address_usa_tx_77063_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77063_first_9_index ON public.address_usa_tx_77063 USING btree (first_9);


--
-- Name: address_usa_tx_77064_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_esiid_index ON public.address_usa_tx_77064 USING btree (esiid);


--
-- Name: address_usa_tx_77064_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_1_index ON public.address_usa_tx_77064 USING btree (first_1);


--
-- Name: address_usa_tx_77064_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_2_index ON public.address_usa_tx_77064 USING btree (first_2);


--
-- Name: address_usa_tx_77064_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_3_index ON public.address_usa_tx_77064 USING btree (first_3);


--
-- Name: address_usa_tx_77064_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_4_index ON public.address_usa_tx_77064 USING btree (first_4);


--
-- Name: address_usa_tx_77064_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_5_index ON public.address_usa_tx_77064 USING btree (first_5);


--
-- Name: address_usa_tx_77064_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_6_index ON public.address_usa_tx_77064 USING btree (first_6);


--
-- Name: address_usa_tx_77064_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_7_index ON public.address_usa_tx_77064 USING btree (first_7);


--
-- Name: address_usa_tx_77064_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_8_index ON public.address_usa_tx_77064 USING btree (first_8);


--
-- Name: address_usa_tx_77064_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77064_first_9_index ON public.address_usa_tx_77064 USING btree (first_9);


--
-- Name: address_usa_tx_77065_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_esiid_index ON public.address_usa_tx_77065 USING btree (esiid);


--
-- Name: address_usa_tx_77065_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_1_index ON public.address_usa_tx_77065 USING btree (first_1);


--
-- Name: address_usa_tx_77065_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_2_index ON public.address_usa_tx_77065 USING btree (first_2);


--
-- Name: address_usa_tx_77065_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_3_index ON public.address_usa_tx_77065 USING btree (first_3);


--
-- Name: address_usa_tx_77065_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_4_index ON public.address_usa_tx_77065 USING btree (first_4);


--
-- Name: address_usa_tx_77065_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_5_index ON public.address_usa_tx_77065 USING btree (first_5);


--
-- Name: address_usa_tx_77065_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_6_index ON public.address_usa_tx_77065 USING btree (first_6);


--
-- Name: address_usa_tx_77065_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_7_index ON public.address_usa_tx_77065 USING btree (first_7);


--
-- Name: address_usa_tx_77065_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_8_index ON public.address_usa_tx_77065 USING btree (first_8);


--
-- Name: address_usa_tx_77065_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77065_first_9_index ON public.address_usa_tx_77065 USING btree (first_9);


--
-- Name: address_usa_tx_77066_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_esiid_index ON public.address_usa_tx_77066 USING btree (esiid);


--
-- Name: address_usa_tx_77066_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_1_index ON public.address_usa_tx_77066 USING btree (first_1);


--
-- Name: address_usa_tx_77066_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_2_index ON public.address_usa_tx_77066 USING btree (first_2);


--
-- Name: address_usa_tx_77066_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_3_index ON public.address_usa_tx_77066 USING btree (first_3);


--
-- Name: address_usa_tx_77066_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_4_index ON public.address_usa_tx_77066 USING btree (first_4);


--
-- Name: address_usa_tx_77066_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_5_index ON public.address_usa_tx_77066 USING btree (first_5);


--
-- Name: address_usa_tx_77066_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_6_index ON public.address_usa_tx_77066 USING btree (first_6);


--
-- Name: address_usa_tx_77066_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_7_index ON public.address_usa_tx_77066 USING btree (first_7);


--
-- Name: address_usa_tx_77066_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_8_index ON public.address_usa_tx_77066 USING btree (first_8);


--
-- Name: address_usa_tx_77066_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77066_first_9_index ON public.address_usa_tx_77066 USING btree (first_9);


--
-- Name: address_usa_tx_77067_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_esiid_index ON public.address_usa_tx_77067 USING btree (esiid);


--
-- Name: address_usa_tx_77067_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_1_index ON public.address_usa_tx_77067 USING btree (first_1);


--
-- Name: address_usa_tx_77067_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_2_index ON public.address_usa_tx_77067 USING btree (first_2);


--
-- Name: address_usa_tx_77067_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_3_index ON public.address_usa_tx_77067 USING btree (first_3);


--
-- Name: address_usa_tx_77067_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_4_index ON public.address_usa_tx_77067 USING btree (first_4);


--
-- Name: address_usa_tx_77067_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_5_index ON public.address_usa_tx_77067 USING btree (first_5);


--
-- Name: address_usa_tx_77067_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_6_index ON public.address_usa_tx_77067 USING btree (first_6);


--
-- Name: address_usa_tx_77067_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_7_index ON public.address_usa_tx_77067 USING btree (first_7);


--
-- Name: address_usa_tx_77067_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_8_index ON public.address_usa_tx_77067 USING btree (first_8);


--
-- Name: address_usa_tx_77067_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77067_first_9_index ON public.address_usa_tx_77067 USING btree (first_9);


--
-- Name: address_usa_tx_77068_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_esiid_index ON public.address_usa_tx_77068 USING btree (esiid);


--
-- Name: address_usa_tx_77068_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_1_index ON public.address_usa_tx_77068 USING btree (first_1);


--
-- Name: address_usa_tx_77068_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_2_index ON public.address_usa_tx_77068 USING btree (first_2);


--
-- Name: address_usa_tx_77068_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_3_index ON public.address_usa_tx_77068 USING btree (first_3);


--
-- Name: address_usa_tx_77068_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_4_index ON public.address_usa_tx_77068 USING btree (first_4);


--
-- Name: address_usa_tx_77068_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_5_index ON public.address_usa_tx_77068 USING btree (first_5);


--
-- Name: address_usa_tx_77068_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_6_index ON public.address_usa_tx_77068 USING btree (first_6);


--
-- Name: address_usa_tx_77068_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_7_index ON public.address_usa_tx_77068 USING btree (first_7);


--
-- Name: address_usa_tx_77068_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_8_index ON public.address_usa_tx_77068 USING btree (first_8);


--
-- Name: address_usa_tx_77068_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77068_first_9_index ON public.address_usa_tx_77068 USING btree (first_9);


--
-- Name: address_usa_tx_77069_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_esiid_index ON public.address_usa_tx_77069 USING btree (esiid);


--
-- Name: address_usa_tx_77069_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_1_index ON public.address_usa_tx_77069 USING btree (first_1);


--
-- Name: address_usa_tx_77069_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_2_index ON public.address_usa_tx_77069 USING btree (first_2);


--
-- Name: address_usa_tx_77069_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_3_index ON public.address_usa_tx_77069 USING btree (first_3);


--
-- Name: address_usa_tx_77069_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_4_index ON public.address_usa_tx_77069 USING btree (first_4);


--
-- Name: address_usa_tx_77069_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_5_index ON public.address_usa_tx_77069 USING btree (first_5);


--
-- Name: address_usa_tx_77069_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_6_index ON public.address_usa_tx_77069 USING btree (first_6);


--
-- Name: address_usa_tx_77069_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_7_index ON public.address_usa_tx_77069 USING btree (first_7);


--
-- Name: address_usa_tx_77069_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_8_index ON public.address_usa_tx_77069 USING btree (first_8);


--
-- Name: address_usa_tx_77069_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77069_first_9_index ON public.address_usa_tx_77069 USING btree (first_9);


--
-- Name: address_usa_tx_7706_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_1_index ON public.address_usa_tx_7706 USING btree (first_1);


--
-- Name: address_usa_tx_7706_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_2_index ON public.address_usa_tx_7706 USING btree (first_2);


--
-- Name: address_usa_tx_7706_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_3_index ON public.address_usa_tx_7706 USING btree (first_3);


--
-- Name: address_usa_tx_7706_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_4_index ON public.address_usa_tx_7706 USING btree (first_4);


--
-- Name: address_usa_tx_7706_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_5_index ON public.address_usa_tx_7706 USING btree (first_5);


--
-- Name: address_usa_tx_7706_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_6_index ON public.address_usa_tx_7706 USING btree (first_6);


--
-- Name: address_usa_tx_7706_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_7_index ON public.address_usa_tx_7706 USING btree (first_7);


--
-- Name: address_usa_tx_7706_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_8_index ON public.address_usa_tx_7706 USING btree (first_8);


--
-- Name: address_usa_tx_7706_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7706_first_9_index ON public.address_usa_tx_7706 USING btree (first_9);


--
-- Name: address_usa_tx_77070_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_esiid_index ON public.address_usa_tx_77070 USING btree (esiid);


--
-- Name: address_usa_tx_77070_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_1_index ON public.address_usa_tx_77070 USING btree (first_1);


--
-- Name: address_usa_tx_77070_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_2_index ON public.address_usa_tx_77070 USING btree (first_2);


--
-- Name: address_usa_tx_77070_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_3_index ON public.address_usa_tx_77070 USING btree (first_3);


--
-- Name: address_usa_tx_77070_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_4_index ON public.address_usa_tx_77070 USING btree (first_4);


--
-- Name: address_usa_tx_77070_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_5_index ON public.address_usa_tx_77070 USING btree (first_5);


--
-- Name: address_usa_tx_77070_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_6_index ON public.address_usa_tx_77070 USING btree (first_6);


--
-- Name: address_usa_tx_77070_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_7_index ON public.address_usa_tx_77070 USING btree (first_7);


--
-- Name: address_usa_tx_77070_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_8_index ON public.address_usa_tx_77070 USING btree (first_8);


--
-- Name: address_usa_tx_77070_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77070_first_9_index ON public.address_usa_tx_77070 USING btree (first_9);


--
-- Name: address_usa_tx_77071_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_esiid_index ON public.address_usa_tx_77071 USING btree (esiid);


--
-- Name: address_usa_tx_77071_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_1_index ON public.address_usa_tx_77071 USING btree (first_1);


--
-- Name: address_usa_tx_77071_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_2_index ON public.address_usa_tx_77071 USING btree (first_2);


--
-- Name: address_usa_tx_77071_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_3_index ON public.address_usa_tx_77071 USING btree (first_3);


--
-- Name: address_usa_tx_77071_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_4_index ON public.address_usa_tx_77071 USING btree (first_4);


--
-- Name: address_usa_tx_77071_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_5_index ON public.address_usa_tx_77071 USING btree (first_5);


--
-- Name: address_usa_tx_77071_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_6_index ON public.address_usa_tx_77071 USING btree (first_6);


--
-- Name: address_usa_tx_77071_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_7_index ON public.address_usa_tx_77071 USING btree (first_7);


--
-- Name: address_usa_tx_77071_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_8_index ON public.address_usa_tx_77071 USING btree (first_8);


--
-- Name: address_usa_tx_77071_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77071_first_9_index ON public.address_usa_tx_77071 USING btree (first_9);


--
-- Name: address_usa_tx_77072_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_esiid_index ON public.address_usa_tx_77072 USING btree (esiid);


--
-- Name: address_usa_tx_77072_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_1_index ON public.address_usa_tx_77072 USING btree (first_1);


--
-- Name: address_usa_tx_77072_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_2_index ON public.address_usa_tx_77072 USING btree (first_2);


--
-- Name: address_usa_tx_77072_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_3_index ON public.address_usa_tx_77072 USING btree (first_3);


--
-- Name: address_usa_tx_77072_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_4_index ON public.address_usa_tx_77072 USING btree (first_4);


--
-- Name: address_usa_tx_77072_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_5_index ON public.address_usa_tx_77072 USING btree (first_5);


--
-- Name: address_usa_tx_77072_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_6_index ON public.address_usa_tx_77072 USING btree (first_6);


--
-- Name: address_usa_tx_77072_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_7_index ON public.address_usa_tx_77072 USING btree (first_7);


--
-- Name: address_usa_tx_77072_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_8_index ON public.address_usa_tx_77072 USING btree (first_8);


--
-- Name: address_usa_tx_77072_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77072_first_9_index ON public.address_usa_tx_77072 USING btree (first_9);


--
-- Name: address_usa_tx_77073_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_esiid_index ON public.address_usa_tx_77073 USING btree (esiid);


--
-- Name: address_usa_tx_77073_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_1_index ON public.address_usa_tx_77073 USING btree (first_1);


--
-- Name: address_usa_tx_77073_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_2_index ON public.address_usa_tx_77073 USING btree (first_2);


--
-- Name: address_usa_tx_77073_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_3_index ON public.address_usa_tx_77073 USING btree (first_3);


--
-- Name: address_usa_tx_77073_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_4_index ON public.address_usa_tx_77073 USING btree (first_4);


--
-- Name: address_usa_tx_77073_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_5_index ON public.address_usa_tx_77073 USING btree (first_5);


--
-- Name: address_usa_tx_77073_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_6_index ON public.address_usa_tx_77073 USING btree (first_6);


--
-- Name: address_usa_tx_77073_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_7_index ON public.address_usa_tx_77073 USING btree (first_7);


--
-- Name: address_usa_tx_77073_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_8_index ON public.address_usa_tx_77073 USING btree (first_8);


--
-- Name: address_usa_tx_77073_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77073_first_9_index ON public.address_usa_tx_77073 USING btree (first_9);


--
-- Name: address_usa_tx_77074_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_esiid_index ON public.address_usa_tx_77074 USING btree (esiid);


--
-- Name: address_usa_tx_77074_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_1_index ON public.address_usa_tx_77074 USING btree (first_1);


--
-- Name: address_usa_tx_77074_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_2_index ON public.address_usa_tx_77074 USING btree (first_2);


--
-- Name: address_usa_tx_77074_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_3_index ON public.address_usa_tx_77074 USING btree (first_3);


--
-- Name: address_usa_tx_77074_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_4_index ON public.address_usa_tx_77074 USING btree (first_4);


--
-- Name: address_usa_tx_77074_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_5_index ON public.address_usa_tx_77074 USING btree (first_5);


--
-- Name: address_usa_tx_77074_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_6_index ON public.address_usa_tx_77074 USING btree (first_6);


--
-- Name: address_usa_tx_77074_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_7_index ON public.address_usa_tx_77074 USING btree (first_7);


--
-- Name: address_usa_tx_77074_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_8_index ON public.address_usa_tx_77074 USING btree (first_8);


--
-- Name: address_usa_tx_77074_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77074_first_9_index ON public.address_usa_tx_77074 USING btree (first_9);


--
-- Name: address_usa_tx_77075_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_esiid_index ON public.address_usa_tx_77075 USING btree (esiid);


--
-- Name: address_usa_tx_77075_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_1_index ON public.address_usa_tx_77075 USING btree (first_1);


--
-- Name: address_usa_tx_77075_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_2_index ON public.address_usa_tx_77075 USING btree (first_2);


--
-- Name: address_usa_tx_77075_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_3_index ON public.address_usa_tx_77075 USING btree (first_3);


--
-- Name: address_usa_tx_77075_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_4_index ON public.address_usa_tx_77075 USING btree (first_4);


--
-- Name: address_usa_tx_77075_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_5_index ON public.address_usa_tx_77075 USING btree (first_5);


--
-- Name: address_usa_tx_77075_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_6_index ON public.address_usa_tx_77075 USING btree (first_6);


--
-- Name: address_usa_tx_77075_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_7_index ON public.address_usa_tx_77075 USING btree (first_7);


--
-- Name: address_usa_tx_77075_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_8_index ON public.address_usa_tx_77075 USING btree (first_8);


--
-- Name: address_usa_tx_77075_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77075_first_9_index ON public.address_usa_tx_77075 USING btree (first_9);


--
-- Name: address_usa_tx_77076_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_esiid_index ON public.address_usa_tx_77076 USING btree (esiid);


--
-- Name: address_usa_tx_77076_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_1_index ON public.address_usa_tx_77076 USING btree (first_1);


--
-- Name: address_usa_tx_77076_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_2_index ON public.address_usa_tx_77076 USING btree (first_2);


--
-- Name: address_usa_tx_77076_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_3_index ON public.address_usa_tx_77076 USING btree (first_3);


--
-- Name: address_usa_tx_77076_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_4_index ON public.address_usa_tx_77076 USING btree (first_4);


--
-- Name: address_usa_tx_77076_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_5_index ON public.address_usa_tx_77076 USING btree (first_5);


--
-- Name: address_usa_tx_77076_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_6_index ON public.address_usa_tx_77076 USING btree (first_6);


--
-- Name: address_usa_tx_77076_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_7_index ON public.address_usa_tx_77076 USING btree (first_7);


--
-- Name: address_usa_tx_77076_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_8_index ON public.address_usa_tx_77076 USING btree (first_8);


--
-- Name: address_usa_tx_77076_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77076_first_9_index ON public.address_usa_tx_77076 USING btree (first_9);


--
-- Name: address_usa_tx_77077_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_esiid_index ON public.address_usa_tx_77077 USING btree (esiid);


--
-- Name: address_usa_tx_77077_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_1_index ON public.address_usa_tx_77077 USING btree (first_1);


--
-- Name: address_usa_tx_77077_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_2_index ON public.address_usa_tx_77077 USING btree (first_2);


--
-- Name: address_usa_tx_77077_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_3_index ON public.address_usa_tx_77077 USING btree (first_3);


--
-- Name: address_usa_tx_77077_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_4_index ON public.address_usa_tx_77077 USING btree (first_4);


--
-- Name: address_usa_tx_77077_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_5_index ON public.address_usa_tx_77077 USING btree (first_5);


--
-- Name: address_usa_tx_77077_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_6_index ON public.address_usa_tx_77077 USING btree (first_6);


--
-- Name: address_usa_tx_77077_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_7_index ON public.address_usa_tx_77077 USING btree (first_7);


--
-- Name: address_usa_tx_77077_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_8_index ON public.address_usa_tx_77077 USING btree (first_8);


--
-- Name: address_usa_tx_77077_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77077_first_9_index ON public.address_usa_tx_77077 USING btree (first_9);


--
-- Name: address_usa_tx_77078_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_esiid_index ON public.address_usa_tx_77078 USING btree (esiid);


--
-- Name: address_usa_tx_77078_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_1_index ON public.address_usa_tx_77078 USING btree (first_1);


--
-- Name: address_usa_tx_77078_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_2_index ON public.address_usa_tx_77078 USING btree (first_2);


--
-- Name: address_usa_tx_77078_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_3_index ON public.address_usa_tx_77078 USING btree (first_3);


--
-- Name: address_usa_tx_77078_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_4_index ON public.address_usa_tx_77078 USING btree (first_4);


--
-- Name: address_usa_tx_77078_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_5_index ON public.address_usa_tx_77078 USING btree (first_5);


--
-- Name: address_usa_tx_77078_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_6_index ON public.address_usa_tx_77078 USING btree (first_6);


--
-- Name: address_usa_tx_77078_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_7_index ON public.address_usa_tx_77078 USING btree (first_7);


--
-- Name: address_usa_tx_77078_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_8_index ON public.address_usa_tx_77078 USING btree (first_8);


--
-- Name: address_usa_tx_77078_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77078_first_9_index ON public.address_usa_tx_77078 USING btree (first_9);


--
-- Name: address_usa_tx_77079_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_esiid_index ON public.address_usa_tx_77079 USING btree (esiid);


--
-- Name: address_usa_tx_77079_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_1_index ON public.address_usa_tx_77079 USING btree (first_1);


--
-- Name: address_usa_tx_77079_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_2_index ON public.address_usa_tx_77079 USING btree (first_2);


--
-- Name: address_usa_tx_77079_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_3_index ON public.address_usa_tx_77079 USING btree (first_3);


--
-- Name: address_usa_tx_77079_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_4_index ON public.address_usa_tx_77079 USING btree (first_4);


--
-- Name: address_usa_tx_77079_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_5_index ON public.address_usa_tx_77079 USING btree (first_5);


--
-- Name: address_usa_tx_77079_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_6_index ON public.address_usa_tx_77079 USING btree (first_6);


--
-- Name: address_usa_tx_77079_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_7_index ON public.address_usa_tx_77079 USING btree (first_7);


--
-- Name: address_usa_tx_77079_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_8_index ON public.address_usa_tx_77079 USING btree (first_8);


--
-- Name: address_usa_tx_77079_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77079_first_9_index ON public.address_usa_tx_77079 USING btree (first_9);


--
-- Name: address_usa_tx_7707_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_1_index ON public.address_usa_tx_7707 USING btree (first_1);


--
-- Name: address_usa_tx_7707_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_2_index ON public.address_usa_tx_7707 USING btree (first_2);


--
-- Name: address_usa_tx_7707_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_3_index ON public.address_usa_tx_7707 USING btree (first_3);


--
-- Name: address_usa_tx_7707_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_4_index ON public.address_usa_tx_7707 USING btree (first_4);


--
-- Name: address_usa_tx_7707_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_5_index ON public.address_usa_tx_7707 USING btree (first_5);


--
-- Name: address_usa_tx_7707_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_6_index ON public.address_usa_tx_7707 USING btree (first_6);


--
-- Name: address_usa_tx_7707_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_7_index ON public.address_usa_tx_7707 USING btree (first_7);


--
-- Name: address_usa_tx_7707_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_8_index ON public.address_usa_tx_7707 USING btree (first_8);


--
-- Name: address_usa_tx_7707_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7707_first_9_index ON public.address_usa_tx_7707 USING btree (first_9);


--
-- Name: address_usa_tx_77080_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_esiid_index ON public.address_usa_tx_77080 USING btree (esiid);


--
-- Name: address_usa_tx_77080_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_1_index ON public.address_usa_tx_77080 USING btree (first_1);


--
-- Name: address_usa_tx_77080_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_2_index ON public.address_usa_tx_77080 USING btree (first_2);


--
-- Name: address_usa_tx_77080_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_3_index ON public.address_usa_tx_77080 USING btree (first_3);


--
-- Name: address_usa_tx_77080_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_4_index ON public.address_usa_tx_77080 USING btree (first_4);


--
-- Name: address_usa_tx_77080_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_5_index ON public.address_usa_tx_77080 USING btree (first_5);


--
-- Name: address_usa_tx_77080_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_6_index ON public.address_usa_tx_77080 USING btree (first_6);


--
-- Name: address_usa_tx_77080_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_7_index ON public.address_usa_tx_77080 USING btree (first_7);


--
-- Name: address_usa_tx_77080_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_8_index ON public.address_usa_tx_77080 USING btree (first_8);


--
-- Name: address_usa_tx_77080_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77080_first_9_index ON public.address_usa_tx_77080 USING btree (first_9);


--
-- Name: address_usa_tx_77081_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_esiid_index ON public.address_usa_tx_77081 USING btree (esiid);


--
-- Name: address_usa_tx_77081_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_1_index ON public.address_usa_tx_77081 USING btree (first_1);


--
-- Name: address_usa_tx_77081_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_2_index ON public.address_usa_tx_77081 USING btree (first_2);


--
-- Name: address_usa_tx_77081_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_3_index ON public.address_usa_tx_77081 USING btree (first_3);


--
-- Name: address_usa_tx_77081_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_4_index ON public.address_usa_tx_77081 USING btree (first_4);


--
-- Name: address_usa_tx_77081_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_5_index ON public.address_usa_tx_77081 USING btree (first_5);


--
-- Name: address_usa_tx_77081_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_6_index ON public.address_usa_tx_77081 USING btree (first_6);


--
-- Name: address_usa_tx_77081_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_7_index ON public.address_usa_tx_77081 USING btree (first_7);


--
-- Name: address_usa_tx_77081_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_8_index ON public.address_usa_tx_77081 USING btree (first_8);


--
-- Name: address_usa_tx_77081_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77081_first_9_index ON public.address_usa_tx_77081 USING btree (first_9);


--
-- Name: address_usa_tx_77082_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_esiid_index ON public.address_usa_tx_77082 USING btree (esiid);


--
-- Name: address_usa_tx_77082_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_1_index ON public.address_usa_tx_77082 USING btree (first_1);


--
-- Name: address_usa_tx_77082_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_2_index ON public.address_usa_tx_77082 USING btree (first_2);


--
-- Name: address_usa_tx_77082_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_3_index ON public.address_usa_tx_77082 USING btree (first_3);


--
-- Name: address_usa_tx_77082_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_4_index ON public.address_usa_tx_77082 USING btree (first_4);


--
-- Name: address_usa_tx_77082_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_5_index ON public.address_usa_tx_77082 USING btree (first_5);


--
-- Name: address_usa_tx_77082_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_6_index ON public.address_usa_tx_77082 USING btree (first_6);


--
-- Name: address_usa_tx_77082_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_7_index ON public.address_usa_tx_77082 USING btree (first_7);


--
-- Name: address_usa_tx_77082_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_8_index ON public.address_usa_tx_77082 USING btree (first_8);


--
-- Name: address_usa_tx_77082_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77082_first_9_index ON public.address_usa_tx_77082 USING btree (first_9);


--
-- Name: address_usa_tx_77083_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_esiid_index ON public.address_usa_tx_77083 USING btree (esiid);


--
-- Name: address_usa_tx_77083_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_1_index ON public.address_usa_tx_77083 USING btree (first_1);


--
-- Name: address_usa_tx_77083_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_2_index ON public.address_usa_tx_77083 USING btree (first_2);


--
-- Name: address_usa_tx_77083_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_3_index ON public.address_usa_tx_77083 USING btree (first_3);


--
-- Name: address_usa_tx_77083_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_4_index ON public.address_usa_tx_77083 USING btree (first_4);


--
-- Name: address_usa_tx_77083_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_5_index ON public.address_usa_tx_77083 USING btree (first_5);


--
-- Name: address_usa_tx_77083_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_6_index ON public.address_usa_tx_77083 USING btree (first_6);


--
-- Name: address_usa_tx_77083_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_7_index ON public.address_usa_tx_77083 USING btree (first_7);


--
-- Name: address_usa_tx_77083_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_8_index ON public.address_usa_tx_77083 USING btree (first_8);


--
-- Name: address_usa_tx_77083_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77083_first_9_index ON public.address_usa_tx_77083 USING btree (first_9);


--
-- Name: address_usa_tx_77084_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_esiid_index ON public.address_usa_tx_77084 USING btree (esiid);


--
-- Name: address_usa_tx_77084_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_1_index ON public.address_usa_tx_77084 USING btree (first_1);


--
-- Name: address_usa_tx_77084_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_2_index ON public.address_usa_tx_77084 USING btree (first_2);


--
-- Name: address_usa_tx_77084_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_3_index ON public.address_usa_tx_77084 USING btree (first_3);


--
-- Name: address_usa_tx_77084_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_4_index ON public.address_usa_tx_77084 USING btree (first_4);


--
-- Name: address_usa_tx_77084_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_5_index ON public.address_usa_tx_77084 USING btree (first_5);


--
-- Name: address_usa_tx_77084_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_6_index ON public.address_usa_tx_77084 USING btree (first_6);


--
-- Name: address_usa_tx_77084_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_7_index ON public.address_usa_tx_77084 USING btree (first_7);


--
-- Name: address_usa_tx_77084_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_8_index ON public.address_usa_tx_77084 USING btree (first_8);


--
-- Name: address_usa_tx_77084_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77084_first_9_index ON public.address_usa_tx_77084 USING btree (first_9);


--
-- Name: address_usa_tx_77085_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_esiid_index ON public.address_usa_tx_77085 USING btree (esiid);


--
-- Name: address_usa_tx_77085_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_1_index ON public.address_usa_tx_77085 USING btree (first_1);


--
-- Name: address_usa_tx_77085_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_2_index ON public.address_usa_tx_77085 USING btree (first_2);


--
-- Name: address_usa_tx_77085_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_3_index ON public.address_usa_tx_77085 USING btree (first_3);


--
-- Name: address_usa_tx_77085_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_4_index ON public.address_usa_tx_77085 USING btree (first_4);


--
-- Name: address_usa_tx_77085_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_5_index ON public.address_usa_tx_77085 USING btree (first_5);


--
-- Name: address_usa_tx_77085_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_6_index ON public.address_usa_tx_77085 USING btree (first_6);


--
-- Name: address_usa_tx_77085_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_7_index ON public.address_usa_tx_77085 USING btree (first_7);


--
-- Name: address_usa_tx_77085_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_8_index ON public.address_usa_tx_77085 USING btree (first_8);


--
-- Name: address_usa_tx_77085_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77085_first_9_index ON public.address_usa_tx_77085 USING btree (first_9);


--
-- Name: address_usa_tx_77086_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_esiid_index ON public.address_usa_tx_77086 USING btree (esiid);


--
-- Name: address_usa_tx_77086_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_1_index ON public.address_usa_tx_77086 USING btree (first_1);


--
-- Name: address_usa_tx_77086_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_2_index ON public.address_usa_tx_77086 USING btree (first_2);


--
-- Name: address_usa_tx_77086_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_3_index ON public.address_usa_tx_77086 USING btree (first_3);


--
-- Name: address_usa_tx_77086_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_4_index ON public.address_usa_tx_77086 USING btree (first_4);


--
-- Name: address_usa_tx_77086_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_5_index ON public.address_usa_tx_77086 USING btree (first_5);


--
-- Name: address_usa_tx_77086_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_6_index ON public.address_usa_tx_77086 USING btree (first_6);


--
-- Name: address_usa_tx_77086_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_7_index ON public.address_usa_tx_77086 USING btree (first_7);


--
-- Name: address_usa_tx_77086_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_8_index ON public.address_usa_tx_77086 USING btree (first_8);


--
-- Name: address_usa_tx_77086_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77086_first_9_index ON public.address_usa_tx_77086 USING btree (first_9);


--
-- Name: address_usa_tx_77087_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_esiid_index ON public.address_usa_tx_77087 USING btree (esiid);


--
-- Name: address_usa_tx_77087_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_1_index ON public.address_usa_tx_77087 USING btree (first_1);


--
-- Name: address_usa_tx_77087_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_2_index ON public.address_usa_tx_77087 USING btree (first_2);


--
-- Name: address_usa_tx_77087_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_3_index ON public.address_usa_tx_77087 USING btree (first_3);


--
-- Name: address_usa_tx_77087_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_4_index ON public.address_usa_tx_77087 USING btree (first_4);


--
-- Name: address_usa_tx_77087_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_5_index ON public.address_usa_tx_77087 USING btree (first_5);


--
-- Name: address_usa_tx_77087_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_6_index ON public.address_usa_tx_77087 USING btree (first_6);


--
-- Name: address_usa_tx_77087_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_7_index ON public.address_usa_tx_77087 USING btree (first_7);


--
-- Name: address_usa_tx_77087_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_8_index ON public.address_usa_tx_77087 USING btree (first_8);


--
-- Name: address_usa_tx_77087_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77087_first_9_index ON public.address_usa_tx_77087 USING btree (first_9);


--
-- Name: address_usa_tx_77088_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_esiid_index ON public.address_usa_tx_77088 USING btree (esiid);


--
-- Name: address_usa_tx_77088_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_1_index ON public.address_usa_tx_77088 USING btree (first_1);


--
-- Name: address_usa_tx_77088_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_2_index ON public.address_usa_tx_77088 USING btree (first_2);


--
-- Name: address_usa_tx_77088_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_3_index ON public.address_usa_tx_77088 USING btree (first_3);


--
-- Name: address_usa_tx_77088_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_4_index ON public.address_usa_tx_77088 USING btree (first_4);


--
-- Name: address_usa_tx_77088_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_5_index ON public.address_usa_tx_77088 USING btree (first_5);


--
-- Name: address_usa_tx_77088_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_6_index ON public.address_usa_tx_77088 USING btree (first_6);


--
-- Name: address_usa_tx_77088_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_7_index ON public.address_usa_tx_77088 USING btree (first_7);


--
-- Name: address_usa_tx_77088_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_8_index ON public.address_usa_tx_77088 USING btree (first_8);


--
-- Name: address_usa_tx_77088_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77088_first_9_index ON public.address_usa_tx_77088 USING btree (first_9);


--
-- Name: address_usa_tx_77089_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_esiid_index ON public.address_usa_tx_77089 USING btree (esiid);


--
-- Name: address_usa_tx_77089_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_1_index ON public.address_usa_tx_77089 USING btree (first_1);


--
-- Name: address_usa_tx_77089_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_2_index ON public.address_usa_tx_77089 USING btree (first_2);


--
-- Name: address_usa_tx_77089_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_3_index ON public.address_usa_tx_77089 USING btree (first_3);


--
-- Name: address_usa_tx_77089_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_4_index ON public.address_usa_tx_77089 USING btree (first_4);


--
-- Name: address_usa_tx_77089_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_5_index ON public.address_usa_tx_77089 USING btree (first_5);


--
-- Name: address_usa_tx_77089_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_6_index ON public.address_usa_tx_77089 USING btree (first_6);


--
-- Name: address_usa_tx_77089_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_7_index ON public.address_usa_tx_77089 USING btree (first_7);


--
-- Name: address_usa_tx_77089_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_8_index ON public.address_usa_tx_77089 USING btree (first_8);


--
-- Name: address_usa_tx_77089_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77089_first_9_index ON public.address_usa_tx_77089 USING btree (first_9);


--
-- Name: address_usa_tx_7708_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_1_index ON public.address_usa_tx_7708 USING btree (first_1);


--
-- Name: address_usa_tx_7708_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_2_index ON public.address_usa_tx_7708 USING btree (first_2);


--
-- Name: address_usa_tx_7708_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_3_index ON public.address_usa_tx_7708 USING btree (first_3);


--
-- Name: address_usa_tx_7708_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_4_index ON public.address_usa_tx_7708 USING btree (first_4);


--
-- Name: address_usa_tx_7708_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_5_index ON public.address_usa_tx_7708 USING btree (first_5);


--
-- Name: address_usa_tx_7708_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_6_index ON public.address_usa_tx_7708 USING btree (first_6);


--
-- Name: address_usa_tx_7708_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_7_index ON public.address_usa_tx_7708 USING btree (first_7);


--
-- Name: address_usa_tx_7708_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_8_index ON public.address_usa_tx_7708 USING btree (first_8);


--
-- Name: address_usa_tx_7708_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7708_first_9_index ON public.address_usa_tx_7708 USING btree (first_9);


--
-- Name: address_usa_tx_77090_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_esiid_index ON public.address_usa_tx_77090 USING btree (esiid);


--
-- Name: address_usa_tx_77090_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_1_index ON public.address_usa_tx_77090 USING btree (first_1);


--
-- Name: address_usa_tx_77090_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_2_index ON public.address_usa_tx_77090 USING btree (first_2);


--
-- Name: address_usa_tx_77090_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_3_index ON public.address_usa_tx_77090 USING btree (first_3);


--
-- Name: address_usa_tx_77090_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_4_index ON public.address_usa_tx_77090 USING btree (first_4);


--
-- Name: address_usa_tx_77090_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_5_index ON public.address_usa_tx_77090 USING btree (first_5);


--
-- Name: address_usa_tx_77090_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_6_index ON public.address_usa_tx_77090 USING btree (first_6);


--
-- Name: address_usa_tx_77090_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_7_index ON public.address_usa_tx_77090 USING btree (first_7);


--
-- Name: address_usa_tx_77090_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_8_index ON public.address_usa_tx_77090 USING btree (first_8);


--
-- Name: address_usa_tx_77090_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77090_first_9_index ON public.address_usa_tx_77090 USING btree (first_9);


--
-- Name: address_usa_tx_77091_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_esiid_index ON public.address_usa_tx_77091 USING btree (esiid);


--
-- Name: address_usa_tx_77091_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_1_index ON public.address_usa_tx_77091 USING btree (first_1);


--
-- Name: address_usa_tx_77091_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_2_index ON public.address_usa_tx_77091 USING btree (first_2);


--
-- Name: address_usa_tx_77091_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_3_index ON public.address_usa_tx_77091 USING btree (first_3);


--
-- Name: address_usa_tx_77091_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_4_index ON public.address_usa_tx_77091 USING btree (first_4);


--
-- Name: address_usa_tx_77091_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_5_index ON public.address_usa_tx_77091 USING btree (first_5);


--
-- Name: address_usa_tx_77091_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_6_index ON public.address_usa_tx_77091 USING btree (first_6);


--
-- Name: address_usa_tx_77091_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_7_index ON public.address_usa_tx_77091 USING btree (first_7);


--
-- Name: address_usa_tx_77091_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_8_index ON public.address_usa_tx_77091 USING btree (first_8);


--
-- Name: address_usa_tx_77091_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77091_first_9_index ON public.address_usa_tx_77091 USING btree (first_9);


--
-- Name: address_usa_tx_77092_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_esiid_index ON public.address_usa_tx_77092 USING btree (esiid);


--
-- Name: address_usa_tx_77092_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_1_index ON public.address_usa_tx_77092 USING btree (first_1);


--
-- Name: address_usa_tx_77092_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_2_index ON public.address_usa_tx_77092 USING btree (first_2);


--
-- Name: address_usa_tx_77092_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_3_index ON public.address_usa_tx_77092 USING btree (first_3);


--
-- Name: address_usa_tx_77092_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_4_index ON public.address_usa_tx_77092 USING btree (first_4);


--
-- Name: address_usa_tx_77092_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_5_index ON public.address_usa_tx_77092 USING btree (first_5);


--
-- Name: address_usa_tx_77092_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_6_index ON public.address_usa_tx_77092 USING btree (first_6);


--
-- Name: address_usa_tx_77092_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_7_index ON public.address_usa_tx_77092 USING btree (first_7);


--
-- Name: address_usa_tx_77092_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_8_index ON public.address_usa_tx_77092 USING btree (first_8);


--
-- Name: address_usa_tx_77092_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77092_first_9_index ON public.address_usa_tx_77092 USING btree (first_9);


--
-- Name: address_usa_tx_77093_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_esiid_index ON public.address_usa_tx_77093 USING btree (esiid);


--
-- Name: address_usa_tx_77093_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_1_index ON public.address_usa_tx_77093 USING btree (first_1);


--
-- Name: address_usa_tx_77093_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_2_index ON public.address_usa_tx_77093 USING btree (first_2);


--
-- Name: address_usa_tx_77093_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_3_index ON public.address_usa_tx_77093 USING btree (first_3);


--
-- Name: address_usa_tx_77093_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_4_index ON public.address_usa_tx_77093 USING btree (first_4);


--
-- Name: address_usa_tx_77093_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_5_index ON public.address_usa_tx_77093 USING btree (first_5);


--
-- Name: address_usa_tx_77093_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_6_index ON public.address_usa_tx_77093 USING btree (first_6);


--
-- Name: address_usa_tx_77093_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_7_index ON public.address_usa_tx_77093 USING btree (first_7);


--
-- Name: address_usa_tx_77093_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_8_index ON public.address_usa_tx_77093 USING btree (first_8);


--
-- Name: address_usa_tx_77093_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77093_first_9_index ON public.address_usa_tx_77093 USING btree (first_9);


--
-- Name: address_usa_tx_77094_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_esiid_index ON public.address_usa_tx_77094 USING btree (esiid);


--
-- Name: address_usa_tx_77094_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_1_index ON public.address_usa_tx_77094 USING btree (first_1);


--
-- Name: address_usa_tx_77094_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_2_index ON public.address_usa_tx_77094 USING btree (first_2);


--
-- Name: address_usa_tx_77094_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_3_index ON public.address_usa_tx_77094 USING btree (first_3);


--
-- Name: address_usa_tx_77094_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_4_index ON public.address_usa_tx_77094 USING btree (first_4);


--
-- Name: address_usa_tx_77094_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_5_index ON public.address_usa_tx_77094 USING btree (first_5);


--
-- Name: address_usa_tx_77094_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_6_index ON public.address_usa_tx_77094 USING btree (first_6);


--
-- Name: address_usa_tx_77094_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_7_index ON public.address_usa_tx_77094 USING btree (first_7);


--
-- Name: address_usa_tx_77094_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_8_index ON public.address_usa_tx_77094 USING btree (first_8);


--
-- Name: address_usa_tx_77094_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77094_first_9_index ON public.address_usa_tx_77094 USING btree (first_9);


--
-- Name: address_usa_tx_77095_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_esiid_index ON public.address_usa_tx_77095 USING btree (esiid);


--
-- Name: address_usa_tx_77095_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_1_index ON public.address_usa_tx_77095 USING btree (first_1);


--
-- Name: address_usa_tx_77095_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_2_index ON public.address_usa_tx_77095 USING btree (first_2);


--
-- Name: address_usa_tx_77095_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_3_index ON public.address_usa_tx_77095 USING btree (first_3);


--
-- Name: address_usa_tx_77095_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_4_index ON public.address_usa_tx_77095 USING btree (first_4);


--
-- Name: address_usa_tx_77095_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_5_index ON public.address_usa_tx_77095 USING btree (first_5);


--
-- Name: address_usa_tx_77095_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_6_index ON public.address_usa_tx_77095 USING btree (first_6);


--
-- Name: address_usa_tx_77095_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_7_index ON public.address_usa_tx_77095 USING btree (first_7);


--
-- Name: address_usa_tx_77095_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_8_index ON public.address_usa_tx_77095 USING btree (first_8);


--
-- Name: address_usa_tx_77095_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77095_first_9_index ON public.address_usa_tx_77095 USING btree (first_9);


--
-- Name: address_usa_tx_77096_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_esiid_index ON public.address_usa_tx_77096 USING btree (esiid);


--
-- Name: address_usa_tx_77096_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_1_index ON public.address_usa_tx_77096 USING btree (first_1);


--
-- Name: address_usa_tx_77096_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_2_index ON public.address_usa_tx_77096 USING btree (first_2);


--
-- Name: address_usa_tx_77096_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_3_index ON public.address_usa_tx_77096 USING btree (first_3);


--
-- Name: address_usa_tx_77096_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_4_index ON public.address_usa_tx_77096 USING btree (first_4);


--
-- Name: address_usa_tx_77096_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_5_index ON public.address_usa_tx_77096 USING btree (first_5);


--
-- Name: address_usa_tx_77096_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_6_index ON public.address_usa_tx_77096 USING btree (first_6);


--
-- Name: address_usa_tx_77096_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_7_index ON public.address_usa_tx_77096 USING btree (first_7);


--
-- Name: address_usa_tx_77096_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_8_index ON public.address_usa_tx_77096 USING btree (first_8);


--
-- Name: address_usa_tx_77096_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77096_first_9_index ON public.address_usa_tx_77096 USING btree (first_9);


--
-- Name: address_usa_tx_77098_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_esiid_index ON public.address_usa_tx_77098 USING btree (esiid);


--
-- Name: address_usa_tx_77098_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_1_index ON public.address_usa_tx_77098 USING btree (first_1);


--
-- Name: address_usa_tx_77098_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_2_index ON public.address_usa_tx_77098 USING btree (first_2);


--
-- Name: address_usa_tx_77098_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_3_index ON public.address_usa_tx_77098 USING btree (first_3);


--
-- Name: address_usa_tx_77098_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_4_index ON public.address_usa_tx_77098 USING btree (first_4);


--
-- Name: address_usa_tx_77098_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_5_index ON public.address_usa_tx_77098 USING btree (first_5);


--
-- Name: address_usa_tx_77098_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_6_index ON public.address_usa_tx_77098 USING btree (first_6);


--
-- Name: address_usa_tx_77098_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_7_index ON public.address_usa_tx_77098 USING btree (first_7);


--
-- Name: address_usa_tx_77098_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_8_index ON public.address_usa_tx_77098 USING btree (first_8);


--
-- Name: address_usa_tx_77098_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77098_first_9_index ON public.address_usa_tx_77098 USING btree (first_9);


--
-- Name: address_usa_tx_77099_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_esiid_index ON public.address_usa_tx_77099 USING btree (esiid);


--
-- Name: address_usa_tx_77099_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_1_index ON public.address_usa_tx_77099 USING btree (first_1);


--
-- Name: address_usa_tx_77099_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_2_index ON public.address_usa_tx_77099 USING btree (first_2);


--
-- Name: address_usa_tx_77099_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_3_index ON public.address_usa_tx_77099 USING btree (first_3);


--
-- Name: address_usa_tx_77099_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_4_index ON public.address_usa_tx_77099 USING btree (first_4);


--
-- Name: address_usa_tx_77099_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_5_index ON public.address_usa_tx_77099 USING btree (first_5);


--
-- Name: address_usa_tx_77099_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_6_index ON public.address_usa_tx_77099 USING btree (first_6);


--
-- Name: address_usa_tx_77099_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_7_index ON public.address_usa_tx_77099 USING btree (first_7);


--
-- Name: address_usa_tx_77099_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_8_index ON public.address_usa_tx_77099 USING btree (first_8);


--
-- Name: address_usa_tx_77099_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77099_first_9_index ON public.address_usa_tx_77099 USING btree (first_9);


--
-- Name: address_usa_tx_7709_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_1_index ON public.address_usa_tx_7709 USING btree (first_1);


--
-- Name: address_usa_tx_7709_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_2_index ON public.address_usa_tx_7709 USING btree (first_2);


--
-- Name: address_usa_tx_7709_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_3_index ON public.address_usa_tx_7709 USING btree (first_3);


--
-- Name: address_usa_tx_7709_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_4_index ON public.address_usa_tx_7709 USING btree (first_4);


--
-- Name: address_usa_tx_7709_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_5_index ON public.address_usa_tx_7709 USING btree (first_5);


--
-- Name: address_usa_tx_7709_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_6_index ON public.address_usa_tx_7709 USING btree (first_6);


--
-- Name: address_usa_tx_7709_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_7_index ON public.address_usa_tx_7709 USING btree (first_7);


--
-- Name: address_usa_tx_7709_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_8_index ON public.address_usa_tx_7709 USING btree (first_8);


--
-- Name: address_usa_tx_7709_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7709_first_9_index ON public.address_usa_tx_7709 USING btree (first_9);


--
-- Name: address_usa_tx_770_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_1_index ON public.address_usa_tx_770 USING btree (first_1);


--
-- Name: address_usa_tx_770_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_2_index ON public.address_usa_tx_770 USING btree (first_2);


--
-- Name: address_usa_tx_770_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_3_index ON public.address_usa_tx_770 USING btree (first_3);


--
-- Name: address_usa_tx_770_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_4_index ON public.address_usa_tx_770 USING btree (first_4);


--
-- Name: address_usa_tx_770_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_5_index ON public.address_usa_tx_770 USING btree (first_5);


--
-- Name: address_usa_tx_770_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_6_index ON public.address_usa_tx_770 USING btree (first_6);


--
-- Name: address_usa_tx_770_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_7_index ON public.address_usa_tx_770 USING btree (first_7);


--
-- Name: address_usa_tx_770_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_8_index ON public.address_usa_tx_770 USING btree (first_8);


--
-- Name: address_usa_tx_770_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_770_first_9_index ON public.address_usa_tx_770 USING btree (first_9);


--
-- Name: address_usa_tx_77201_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_esiid_index ON public.address_usa_tx_77201 USING btree (esiid);


--
-- Name: address_usa_tx_77201_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_1_index ON public.address_usa_tx_77201 USING btree (first_1);


--
-- Name: address_usa_tx_77201_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_2_index ON public.address_usa_tx_77201 USING btree (first_2);


--
-- Name: address_usa_tx_77201_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_3_index ON public.address_usa_tx_77201 USING btree (first_3);


--
-- Name: address_usa_tx_77201_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_4_index ON public.address_usa_tx_77201 USING btree (first_4);


--
-- Name: address_usa_tx_77201_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_5_index ON public.address_usa_tx_77201 USING btree (first_5);


--
-- Name: address_usa_tx_77201_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_6_index ON public.address_usa_tx_77201 USING btree (first_6);


--
-- Name: address_usa_tx_77201_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_7_index ON public.address_usa_tx_77201 USING btree (first_7);


--
-- Name: address_usa_tx_77201_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_8_index ON public.address_usa_tx_77201 USING btree (first_8);


--
-- Name: address_usa_tx_77201_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77201_first_9_index ON public.address_usa_tx_77201 USING btree (first_9);


--
-- Name: address_usa_tx_77204_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_esiid_index ON public.address_usa_tx_77204 USING btree (esiid);


--
-- Name: address_usa_tx_77204_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_1_index ON public.address_usa_tx_77204 USING btree (first_1);


--
-- Name: address_usa_tx_77204_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_2_index ON public.address_usa_tx_77204 USING btree (first_2);


--
-- Name: address_usa_tx_77204_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_3_index ON public.address_usa_tx_77204 USING btree (first_3);


--
-- Name: address_usa_tx_77204_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_4_index ON public.address_usa_tx_77204 USING btree (first_4);


--
-- Name: address_usa_tx_77204_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_5_index ON public.address_usa_tx_77204 USING btree (first_5);


--
-- Name: address_usa_tx_77204_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_6_index ON public.address_usa_tx_77204 USING btree (first_6);


--
-- Name: address_usa_tx_77204_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_7_index ON public.address_usa_tx_77204 USING btree (first_7);


--
-- Name: address_usa_tx_77204_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_8_index ON public.address_usa_tx_77204 USING btree (first_8);


--
-- Name: address_usa_tx_77204_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77204_first_9_index ON public.address_usa_tx_77204 USING btree (first_9);


--
-- Name: address_usa_tx_7720_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_1_index ON public.address_usa_tx_7720 USING btree (first_1);


--
-- Name: address_usa_tx_7720_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_2_index ON public.address_usa_tx_7720 USING btree (first_2);


--
-- Name: address_usa_tx_7720_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_3_index ON public.address_usa_tx_7720 USING btree (first_3);


--
-- Name: address_usa_tx_7720_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_4_index ON public.address_usa_tx_7720 USING btree (first_4);


--
-- Name: address_usa_tx_7720_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_5_index ON public.address_usa_tx_7720 USING btree (first_5);


--
-- Name: address_usa_tx_7720_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_6_index ON public.address_usa_tx_7720 USING btree (first_6);


--
-- Name: address_usa_tx_7720_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_7_index ON public.address_usa_tx_7720 USING btree (first_7);


--
-- Name: address_usa_tx_7720_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_8_index ON public.address_usa_tx_7720 USING btree (first_8);


--
-- Name: address_usa_tx_7720_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7720_first_9_index ON public.address_usa_tx_7720 USING btree (first_9);


--
-- Name: address_usa_tx_77210_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_esiid_index ON public.address_usa_tx_77210 USING btree (esiid);


--
-- Name: address_usa_tx_77210_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_1_index ON public.address_usa_tx_77210 USING btree (first_1);


--
-- Name: address_usa_tx_77210_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_2_index ON public.address_usa_tx_77210 USING btree (first_2);


--
-- Name: address_usa_tx_77210_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_3_index ON public.address_usa_tx_77210 USING btree (first_3);


--
-- Name: address_usa_tx_77210_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_4_index ON public.address_usa_tx_77210 USING btree (first_4);


--
-- Name: address_usa_tx_77210_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_5_index ON public.address_usa_tx_77210 USING btree (first_5);


--
-- Name: address_usa_tx_77210_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_6_index ON public.address_usa_tx_77210 USING btree (first_6);


--
-- Name: address_usa_tx_77210_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_7_index ON public.address_usa_tx_77210 USING btree (first_7);


--
-- Name: address_usa_tx_77210_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_8_index ON public.address_usa_tx_77210 USING btree (first_8);


--
-- Name: address_usa_tx_77210_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77210_first_9_index ON public.address_usa_tx_77210 USING btree (first_9);


--
-- Name: address_usa_tx_7721_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_1_index ON public.address_usa_tx_7721 USING btree (first_1);


--
-- Name: address_usa_tx_7721_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_2_index ON public.address_usa_tx_7721 USING btree (first_2);


--
-- Name: address_usa_tx_7721_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_3_index ON public.address_usa_tx_7721 USING btree (first_3);


--
-- Name: address_usa_tx_7721_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_4_index ON public.address_usa_tx_7721 USING btree (first_4);


--
-- Name: address_usa_tx_7721_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_5_index ON public.address_usa_tx_7721 USING btree (first_5);


--
-- Name: address_usa_tx_7721_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_6_index ON public.address_usa_tx_7721 USING btree (first_6);


--
-- Name: address_usa_tx_7721_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_7_index ON public.address_usa_tx_7721 USING btree (first_7);


--
-- Name: address_usa_tx_7721_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_8_index ON public.address_usa_tx_7721 USING btree (first_8);


--
-- Name: address_usa_tx_7721_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7721_first_9_index ON public.address_usa_tx_7721 USING btree (first_9);


--
-- Name: address_usa_tx_77227_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_esiid_index ON public.address_usa_tx_77227 USING btree (esiid);


--
-- Name: address_usa_tx_77227_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_1_index ON public.address_usa_tx_77227 USING btree (first_1);


--
-- Name: address_usa_tx_77227_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_2_index ON public.address_usa_tx_77227 USING btree (first_2);


--
-- Name: address_usa_tx_77227_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_3_index ON public.address_usa_tx_77227 USING btree (first_3);


--
-- Name: address_usa_tx_77227_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_4_index ON public.address_usa_tx_77227 USING btree (first_4);


--
-- Name: address_usa_tx_77227_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_5_index ON public.address_usa_tx_77227 USING btree (first_5);


--
-- Name: address_usa_tx_77227_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_6_index ON public.address_usa_tx_77227 USING btree (first_6);


--
-- Name: address_usa_tx_77227_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_7_index ON public.address_usa_tx_77227 USING btree (first_7);


--
-- Name: address_usa_tx_77227_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_8_index ON public.address_usa_tx_77227 USING btree (first_8);


--
-- Name: address_usa_tx_77227_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77227_first_9_index ON public.address_usa_tx_77227 USING btree (first_9);


--
-- Name: address_usa_tx_77229_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_esiid_index ON public.address_usa_tx_77229 USING btree (esiid);


--
-- Name: address_usa_tx_77229_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_1_index ON public.address_usa_tx_77229 USING btree (first_1);


--
-- Name: address_usa_tx_77229_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_2_index ON public.address_usa_tx_77229 USING btree (first_2);


--
-- Name: address_usa_tx_77229_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_3_index ON public.address_usa_tx_77229 USING btree (first_3);


--
-- Name: address_usa_tx_77229_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_4_index ON public.address_usa_tx_77229 USING btree (first_4);


--
-- Name: address_usa_tx_77229_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_5_index ON public.address_usa_tx_77229 USING btree (first_5);


--
-- Name: address_usa_tx_77229_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_6_index ON public.address_usa_tx_77229 USING btree (first_6);


--
-- Name: address_usa_tx_77229_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_7_index ON public.address_usa_tx_77229 USING btree (first_7);


--
-- Name: address_usa_tx_77229_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_8_index ON public.address_usa_tx_77229 USING btree (first_8);


--
-- Name: address_usa_tx_77229_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77229_first_9_index ON public.address_usa_tx_77229 USING btree (first_9);


--
-- Name: address_usa_tx_7722_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_1_index ON public.address_usa_tx_7722 USING btree (first_1);


--
-- Name: address_usa_tx_7722_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_2_index ON public.address_usa_tx_7722 USING btree (first_2);


--
-- Name: address_usa_tx_7722_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_3_index ON public.address_usa_tx_7722 USING btree (first_3);


--
-- Name: address_usa_tx_7722_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_4_index ON public.address_usa_tx_7722 USING btree (first_4);


--
-- Name: address_usa_tx_7722_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_5_index ON public.address_usa_tx_7722 USING btree (first_5);


--
-- Name: address_usa_tx_7722_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_6_index ON public.address_usa_tx_7722 USING btree (first_6);


--
-- Name: address_usa_tx_7722_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_7_index ON public.address_usa_tx_7722 USING btree (first_7);


--
-- Name: address_usa_tx_7722_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_8_index ON public.address_usa_tx_7722 USING btree (first_8);


--
-- Name: address_usa_tx_7722_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7722_first_9_index ON public.address_usa_tx_7722 USING btree (first_9);


--
-- Name: address_usa_tx_77236_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_esiid_index ON public.address_usa_tx_77236 USING btree (esiid);


--
-- Name: address_usa_tx_77236_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_1_index ON public.address_usa_tx_77236 USING btree (first_1);


--
-- Name: address_usa_tx_77236_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_2_index ON public.address_usa_tx_77236 USING btree (first_2);


--
-- Name: address_usa_tx_77236_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_3_index ON public.address_usa_tx_77236 USING btree (first_3);


--
-- Name: address_usa_tx_77236_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_4_index ON public.address_usa_tx_77236 USING btree (first_4);


--
-- Name: address_usa_tx_77236_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_5_index ON public.address_usa_tx_77236 USING btree (first_5);


--
-- Name: address_usa_tx_77236_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_6_index ON public.address_usa_tx_77236 USING btree (first_6);


--
-- Name: address_usa_tx_77236_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_7_index ON public.address_usa_tx_77236 USING btree (first_7);


--
-- Name: address_usa_tx_77236_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_8_index ON public.address_usa_tx_77236 USING btree (first_8);


--
-- Name: address_usa_tx_77236_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77236_first_9_index ON public.address_usa_tx_77236 USING btree (first_9);


--
-- Name: address_usa_tx_7723_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_1_index ON public.address_usa_tx_7723 USING btree (first_1);


--
-- Name: address_usa_tx_7723_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_2_index ON public.address_usa_tx_7723 USING btree (first_2);


--
-- Name: address_usa_tx_7723_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_3_index ON public.address_usa_tx_7723 USING btree (first_3);


--
-- Name: address_usa_tx_7723_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_4_index ON public.address_usa_tx_7723 USING btree (first_4);


--
-- Name: address_usa_tx_7723_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_5_index ON public.address_usa_tx_7723 USING btree (first_5);


--
-- Name: address_usa_tx_7723_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_6_index ON public.address_usa_tx_7723 USING btree (first_6);


--
-- Name: address_usa_tx_7723_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_7_index ON public.address_usa_tx_7723 USING btree (first_7);


--
-- Name: address_usa_tx_7723_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_8_index ON public.address_usa_tx_7723 USING btree (first_8);


--
-- Name: address_usa_tx_7723_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7723_first_9_index ON public.address_usa_tx_7723 USING btree (first_9);


--
-- Name: address_usa_tx_77251_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_1_index ON public.address_usa_tx_77251 USING btree (first_1);


--
-- Name: address_usa_tx_77251_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_2_index ON public.address_usa_tx_77251 USING btree (first_2);


--
-- Name: address_usa_tx_77251_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_3_index ON public.address_usa_tx_77251 USING btree (first_3);


--
-- Name: address_usa_tx_77251_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_4_index ON public.address_usa_tx_77251 USING btree (first_4);


--
-- Name: address_usa_tx_77251_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_5_index ON public.address_usa_tx_77251 USING btree (first_5);


--
-- Name: address_usa_tx_77251_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_6_index ON public.address_usa_tx_77251 USING btree (first_6);


--
-- Name: address_usa_tx_77251_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_7_index ON public.address_usa_tx_77251 USING btree (first_7);


--
-- Name: address_usa_tx_77251_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_8_index ON public.address_usa_tx_77251 USING btree (first_8);


--
-- Name: address_usa_tx_77251_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77251_first_9_index ON public.address_usa_tx_77251 USING btree (first_9);


--
-- Name: address_usa_tx_77253_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_esiid_index ON public.address_usa_tx_77253 USING btree (esiid);


--
-- Name: address_usa_tx_77253_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_1_index ON public.address_usa_tx_77253 USING btree (first_1);


--
-- Name: address_usa_tx_77253_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_2_index ON public.address_usa_tx_77253 USING btree (first_2);


--
-- Name: address_usa_tx_77253_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_3_index ON public.address_usa_tx_77253 USING btree (first_3);


--
-- Name: address_usa_tx_77253_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_4_index ON public.address_usa_tx_77253 USING btree (first_4);


--
-- Name: address_usa_tx_77253_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_5_index ON public.address_usa_tx_77253 USING btree (first_5);


--
-- Name: address_usa_tx_77253_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_6_index ON public.address_usa_tx_77253 USING btree (first_6);


--
-- Name: address_usa_tx_77253_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_7_index ON public.address_usa_tx_77253 USING btree (first_7);


--
-- Name: address_usa_tx_77253_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_8_index ON public.address_usa_tx_77253 USING btree (first_8);


--
-- Name: address_usa_tx_77253_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77253_first_9_index ON public.address_usa_tx_77253 USING btree (first_9);


--
-- Name: address_usa_tx_77256_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_esiid_index ON public.address_usa_tx_77256 USING btree (esiid);


--
-- Name: address_usa_tx_77256_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_1_index ON public.address_usa_tx_77256 USING btree (first_1);


--
-- Name: address_usa_tx_77256_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_2_index ON public.address_usa_tx_77256 USING btree (first_2);


--
-- Name: address_usa_tx_77256_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_3_index ON public.address_usa_tx_77256 USING btree (first_3);


--
-- Name: address_usa_tx_77256_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_4_index ON public.address_usa_tx_77256 USING btree (first_4);


--
-- Name: address_usa_tx_77256_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_5_index ON public.address_usa_tx_77256 USING btree (first_5);


--
-- Name: address_usa_tx_77256_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_6_index ON public.address_usa_tx_77256 USING btree (first_6);


--
-- Name: address_usa_tx_77256_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_7_index ON public.address_usa_tx_77256 USING btree (first_7);


--
-- Name: address_usa_tx_77256_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_8_index ON public.address_usa_tx_77256 USING btree (first_8);


--
-- Name: address_usa_tx_77256_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77256_first_9_index ON public.address_usa_tx_77256 USING btree (first_9);


--
-- Name: address_usa_tx_7725_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_1_index ON public.address_usa_tx_7725 USING btree (first_1);


--
-- Name: address_usa_tx_7725_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_2_index ON public.address_usa_tx_7725 USING btree (first_2);


--
-- Name: address_usa_tx_7725_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_3_index ON public.address_usa_tx_7725 USING btree (first_3);


--
-- Name: address_usa_tx_7725_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_4_index ON public.address_usa_tx_7725 USING btree (first_4);


--
-- Name: address_usa_tx_7725_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_5_index ON public.address_usa_tx_7725 USING btree (first_5);


--
-- Name: address_usa_tx_7725_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_6_index ON public.address_usa_tx_7725 USING btree (first_6);


--
-- Name: address_usa_tx_7725_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_7_index ON public.address_usa_tx_7725 USING btree (first_7);


--
-- Name: address_usa_tx_7725_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_8_index ON public.address_usa_tx_7725 USING btree (first_8);


--
-- Name: address_usa_tx_7725_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7725_first_9_index ON public.address_usa_tx_7725 USING btree (first_9);


--
-- Name: address_usa_tx_77262_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_esiid_index ON public.address_usa_tx_77262 USING btree (esiid);


--
-- Name: address_usa_tx_77262_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_1_index ON public.address_usa_tx_77262 USING btree (first_1);


--
-- Name: address_usa_tx_77262_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_2_index ON public.address_usa_tx_77262 USING btree (first_2);


--
-- Name: address_usa_tx_77262_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_3_index ON public.address_usa_tx_77262 USING btree (first_3);


--
-- Name: address_usa_tx_77262_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_4_index ON public.address_usa_tx_77262 USING btree (first_4);


--
-- Name: address_usa_tx_77262_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_5_index ON public.address_usa_tx_77262 USING btree (first_5);


--
-- Name: address_usa_tx_77262_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_6_index ON public.address_usa_tx_77262 USING btree (first_6);


--
-- Name: address_usa_tx_77262_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_7_index ON public.address_usa_tx_77262 USING btree (first_7);


--
-- Name: address_usa_tx_77262_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_8_index ON public.address_usa_tx_77262 USING btree (first_8);


--
-- Name: address_usa_tx_77262_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77262_first_9_index ON public.address_usa_tx_77262 USING btree (first_9);


--
-- Name: address_usa_tx_77265_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_esiid_index ON public.address_usa_tx_77265 USING btree (esiid);


--
-- Name: address_usa_tx_77265_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_1_index ON public.address_usa_tx_77265 USING btree (first_1);


--
-- Name: address_usa_tx_77265_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_2_index ON public.address_usa_tx_77265 USING btree (first_2);


--
-- Name: address_usa_tx_77265_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_3_index ON public.address_usa_tx_77265 USING btree (first_3);


--
-- Name: address_usa_tx_77265_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_4_index ON public.address_usa_tx_77265 USING btree (first_4);


--
-- Name: address_usa_tx_77265_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_5_index ON public.address_usa_tx_77265 USING btree (first_5);


--
-- Name: address_usa_tx_77265_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_6_index ON public.address_usa_tx_77265 USING btree (first_6);


--
-- Name: address_usa_tx_77265_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_7_index ON public.address_usa_tx_77265 USING btree (first_7);


--
-- Name: address_usa_tx_77265_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_8_index ON public.address_usa_tx_77265 USING btree (first_8);


--
-- Name: address_usa_tx_77265_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77265_first_9_index ON public.address_usa_tx_77265 USING btree (first_9);


--
-- Name: address_usa_tx_77267_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_esiid_index ON public.address_usa_tx_77267 USING btree (esiid);


--
-- Name: address_usa_tx_77267_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_1_index ON public.address_usa_tx_77267 USING btree (first_1);


--
-- Name: address_usa_tx_77267_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_2_index ON public.address_usa_tx_77267 USING btree (first_2);


--
-- Name: address_usa_tx_77267_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_3_index ON public.address_usa_tx_77267 USING btree (first_3);


--
-- Name: address_usa_tx_77267_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_4_index ON public.address_usa_tx_77267 USING btree (first_4);


--
-- Name: address_usa_tx_77267_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_5_index ON public.address_usa_tx_77267 USING btree (first_5);


--
-- Name: address_usa_tx_77267_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_6_index ON public.address_usa_tx_77267 USING btree (first_6);


--
-- Name: address_usa_tx_77267_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_7_index ON public.address_usa_tx_77267 USING btree (first_7);


--
-- Name: address_usa_tx_77267_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_8_index ON public.address_usa_tx_77267 USING btree (first_8);


--
-- Name: address_usa_tx_77267_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77267_first_9_index ON public.address_usa_tx_77267 USING btree (first_9);


--
-- Name: address_usa_tx_7726_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_1_index ON public.address_usa_tx_7726 USING btree (first_1);


--
-- Name: address_usa_tx_7726_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_2_index ON public.address_usa_tx_7726 USING btree (first_2);


--
-- Name: address_usa_tx_7726_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_3_index ON public.address_usa_tx_7726 USING btree (first_3);


--
-- Name: address_usa_tx_7726_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_4_index ON public.address_usa_tx_7726 USING btree (first_4);


--
-- Name: address_usa_tx_7726_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_5_index ON public.address_usa_tx_7726 USING btree (first_5);


--
-- Name: address_usa_tx_7726_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_6_index ON public.address_usa_tx_7726 USING btree (first_6);


--
-- Name: address_usa_tx_7726_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_7_index ON public.address_usa_tx_7726 USING btree (first_7);


--
-- Name: address_usa_tx_7726_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_8_index ON public.address_usa_tx_7726 USING btree (first_8);


--
-- Name: address_usa_tx_7726_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7726_first_9_index ON public.address_usa_tx_7726 USING btree (first_9);


--
-- Name: address_usa_tx_77274_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_esiid_index ON public.address_usa_tx_77274 USING btree (esiid);


--
-- Name: address_usa_tx_77274_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_1_index ON public.address_usa_tx_77274 USING btree (first_1);


--
-- Name: address_usa_tx_77274_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_2_index ON public.address_usa_tx_77274 USING btree (first_2);


--
-- Name: address_usa_tx_77274_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_3_index ON public.address_usa_tx_77274 USING btree (first_3);


--
-- Name: address_usa_tx_77274_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_4_index ON public.address_usa_tx_77274 USING btree (first_4);


--
-- Name: address_usa_tx_77274_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_5_index ON public.address_usa_tx_77274 USING btree (first_5);


--
-- Name: address_usa_tx_77274_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_6_index ON public.address_usa_tx_77274 USING btree (first_6);


--
-- Name: address_usa_tx_77274_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_7_index ON public.address_usa_tx_77274 USING btree (first_7);


--
-- Name: address_usa_tx_77274_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_8_index ON public.address_usa_tx_77274 USING btree (first_8);


--
-- Name: address_usa_tx_77274_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77274_first_9_index ON public.address_usa_tx_77274 USING btree (first_9);


--
-- Name: address_usa_tx_7727_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_1_index ON public.address_usa_tx_7727 USING btree (first_1);


--
-- Name: address_usa_tx_7727_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_2_index ON public.address_usa_tx_7727 USING btree (first_2);


--
-- Name: address_usa_tx_7727_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_3_index ON public.address_usa_tx_7727 USING btree (first_3);


--
-- Name: address_usa_tx_7727_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_4_index ON public.address_usa_tx_7727 USING btree (first_4);


--
-- Name: address_usa_tx_7727_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_5_index ON public.address_usa_tx_7727 USING btree (first_5);


--
-- Name: address_usa_tx_7727_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_6_index ON public.address_usa_tx_7727 USING btree (first_6);


--
-- Name: address_usa_tx_7727_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_7_index ON public.address_usa_tx_7727 USING btree (first_7);


--
-- Name: address_usa_tx_7727_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_8_index ON public.address_usa_tx_7727 USING btree (first_8);


--
-- Name: address_usa_tx_7727_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7727_first_9_index ON public.address_usa_tx_7727 USING btree (first_9);


--
-- Name: address_usa_tx_772_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_1_index ON public.address_usa_tx_772 USING btree (first_1);


--
-- Name: address_usa_tx_772_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_2_index ON public.address_usa_tx_772 USING btree (first_2);


--
-- Name: address_usa_tx_772_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_3_index ON public.address_usa_tx_772 USING btree (first_3);


--
-- Name: address_usa_tx_772_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_4_index ON public.address_usa_tx_772 USING btree (first_4);


--
-- Name: address_usa_tx_772_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_5_index ON public.address_usa_tx_772 USING btree (first_5);


--
-- Name: address_usa_tx_772_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_6_index ON public.address_usa_tx_772 USING btree (first_6);


--
-- Name: address_usa_tx_772_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_7_index ON public.address_usa_tx_772 USING btree (first_7);


--
-- Name: address_usa_tx_772_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_8_index ON public.address_usa_tx_772 USING btree (first_8);


--
-- Name: address_usa_tx_772_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_772_first_9_index ON public.address_usa_tx_772 USING btree (first_9);


--
-- Name: address_usa_tx_77301_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_esiid_index ON public.address_usa_tx_77301 USING btree (esiid);


--
-- Name: address_usa_tx_77301_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_1_index ON public.address_usa_tx_77301 USING btree (first_1);


--
-- Name: address_usa_tx_77301_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_2_index ON public.address_usa_tx_77301 USING btree (first_2);


--
-- Name: address_usa_tx_77301_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_3_index ON public.address_usa_tx_77301 USING btree (first_3);


--
-- Name: address_usa_tx_77301_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_4_index ON public.address_usa_tx_77301 USING btree (first_4);


--
-- Name: address_usa_tx_77301_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_5_index ON public.address_usa_tx_77301 USING btree (first_5);


--
-- Name: address_usa_tx_77301_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_6_index ON public.address_usa_tx_77301 USING btree (first_6);


--
-- Name: address_usa_tx_77301_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_7_index ON public.address_usa_tx_77301 USING btree (first_7);


--
-- Name: address_usa_tx_77301_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_8_index ON public.address_usa_tx_77301 USING btree (first_8);


--
-- Name: address_usa_tx_77301_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77301_first_9_index ON public.address_usa_tx_77301 USING btree (first_9);


--
-- Name: address_usa_tx_77302_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_esiid_index ON public.address_usa_tx_77302 USING btree (esiid);


--
-- Name: address_usa_tx_77302_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_1_index ON public.address_usa_tx_77302 USING btree (first_1);


--
-- Name: address_usa_tx_77302_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_2_index ON public.address_usa_tx_77302 USING btree (first_2);


--
-- Name: address_usa_tx_77302_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_3_index ON public.address_usa_tx_77302 USING btree (first_3);


--
-- Name: address_usa_tx_77302_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_4_index ON public.address_usa_tx_77302 USING btree (first_4);


--
-- Name: address_usa_tx_77302_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_5_index ON public.address_usa_tx_77302 USING btree (first_5);


--
-- Name: address_usa_tx_77302_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_6_index ON public.address_usa_tx_77302 USING btree (first_6);


--
-- Name: address_usa_tx_77302_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_7_index ON public.address_usa_tx_77302 USING btree (first_7);


--
-- Name: address_usa_tx_77302_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_8_index ON public.address_usa_tx_77302 USING btree (first_8);


--
-- Name: address_usa_tx_77302_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77302_first_9_index ON public.address_usa_tx_77302 USING btree (first_9);


--
-- Name: address_usa_tx_77303_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_esiid_index ON public.address_usa_tx_77303 USING btree (esiid);


--
-- Name: address_usa_tx_77303_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_1_index ON public.address_usa_tx_77303 USING btree (first_1);


--
-- Name: address_usa_tx_77303_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_2_index ON public.address_usa_tx_77303 USING btree (first_2);


--
-- Name: address_usa_tx_77303_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_3_index ON public.address_usa_tx_77303 USING btree (first_3);


--
-- Name: address_usa_tx_77303_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_4_index ON public.address_usa_tx_77303 USING btree (first_4);


--
-- Name: address_usa_tx_77303_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_5_index ON public.address_usa_tx_77303 USING btree (first_5);


--
-- Name: address_usa_tx_77303_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_6_index ON public.address_usa_tx_77303 USING btree (first_6);


--
-- Name: address_usa_tx_77303_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_7_index ON public.address_usa_tx_77303 USING btree (first_7);


--
-- Name: address_usa_tx_77303_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_8_index ON public.address_usa_tx_77303 USING btree (first_8);


--
-- Name: address_usa_tx_77303_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77303_first_9_index ON public.address_usa_tx_77303 USING btree (first_9);


--
-- Name: address_usa_tx_77304_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_esiid_index ON public.address_usa_tx_77304 USING btree (esiid);


--
-- Name: address_usa_tx_77304_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_1_index ON public.address_usa_tx_77304 USING btree (first_1);


--
-- Name: address_usa_tx_77304_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_2_index ON public.address_usa_tx_77304 USING btree (first_2);


--
-- Name: address_usa_tx_77304_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_3_index ON public.address_usa_tx_77304 USING btree (first_3);


--
-- Name: address_usa_tx_77304_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_4_index ON public.address_usa_tx_77304 USING btree (first_4);


--
-- Name: address_usa_tx_77304_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_5_index ON public.address_usa_tx_77304 USING btree (first_5);


--
-- Name: address_usa_tx_77304_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_6_index ON public.address_usa_tx_77304 USING btree (first_6);


--
-- Name: address_usa_tx_77304_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_7_index ON public.address_usa_tx_77304 USING btree (first_7);


--
-- Name: address_usa_tx_77304_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_8_index ON public.address_usa_tx_77304 USING btree (first_8);


--
-- Name: address_usa_tx_77304_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77304_first_9_index ON public.address_usa_tx_77304 USING btree (first_9);


--
-- Name: address_usa_tx_77305_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_esiid_index ON public.address_usa_tx_77305 USING btree (esiid);


--
-- Name: address_usa_tx_77305_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_1_index ON public.address_usa_tx_77305 USING btree (first_1);


--
-- Name: address_usa_tx_77305_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_2_index ON public.address_usa_tx_77305 USING btree (first_2);


--
-- Name: address_usa_tx_77305_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_3_index ON public.address_usa_tx_77305 USING btree (first_3);


--
-- Name: address_usa_tx_77305_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_4_index ON public.address_usa_tx_77305 USING btree (first_4);


--
-- Name: address_usa_tx_77305_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_5_index ON public.address_usa_tx_77305 USING btree (first_5);


--
-- Name: address_usa_tx_77305_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_6_index ON public.address_usa_tx_77305 USING btree (first_6);


--
-- Name: address_usa_tx_77305_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_7_index ON public.address_usa_tx_77305 USING btree (first_7);


--
-- Name: address_usa_tx_77305_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_8_index ON public.address_usa_tx_77305 USING btree (first_8);


--
-- Name: address_usa_tx_77305_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77305_first_9_index ON public.address_usa_tx_77305 USING btree (first_9);


--
-- Name: address_usa_tx_77306_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_esiid_index ON public.address_usa_tx_77306 USING btree (esiid);


--
-- Name: address_usa_tx_77306_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_1_index ON public.address_usa_tx_77306 USING btree (first_1);


--
-- Name: address_usa_tx_77306_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_2_index ON public.address_usa_tx_77306 USING btree (first_2);


--
-- Name: address_usa_tx_77306_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_3_index ON public.address_usa_tx_77306 USING btree (first_3);


--
-- Name: address_usa_tx_77306_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_4_index ON public.address_usa_tx_77306 USING btree (first_4);


--
-- Name: address_usa_tx_77306_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_5_index ON public.address_usa_tx_77306 USING btree (first_5);


--
-- Name: address_usa_tx_77306_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_6_index ON public.address_usa_tx_77306 USING btree (first_6);


--
-- Name: address_usa_tx_77306_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_7_index ON public.address_usa_tx_77306 USING btree (first_7);


--
-- Name: address_usa_tx_77306_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_8_index ON public.address_usa_tx_77306 USING btree (first_8);


--
-- Name: address_usa_tx_77306_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77306_first_9_index ON public.address_usa_tx_77306 USING btree (first_9);


--
-- Name: address_usa_tx_7730_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_1_index ON public.address_usa_tx_7730 USING btree (first_1);


--
-- Name: address_usa_tx_7730_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_2_index ON public.address_usa_tx_7730 USING btree (first_2);


--
-- Name: address_usa_tx_7730_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_3_index ON public.address_usa_tx_7730 USING btree (first_3);


--
-- Name: address_usa_tx_7730_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_4_index ON public.address_usa_tx_7730 USING btree (first_4);


--
-- Name: address_usa_tx_7730_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_5_index ON public.address_usa_tx_7730 USING btree (first_5);


--
-- Name: address_usa_tx_7730_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_6_index ON public.address_usa_tx_7730 USING btree (first_6);


--
-- Name: address_usa_tx_7730_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_7_index ON public.address_usa_tx_7730 USING btree (first_7);


--
-- Name: address_usa_tx_7730_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_8_index ON public.address_usa_tx_7730 USING btree (first_8);


--
-- Name: address_usa_tx_7730_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7730_first_9_index ON public.address_usa_tx_7730 USING btree (first_9);


--
-- Name: address_usa_tx_77316_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_esiid_index ON public.address_usa_tx_77316 USING btree (esiid);


--
-- Name: address_usa_tx_77316_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_1_index ON public.address_usa_tx_77316 USING btree (first_1);


--
-- Name: address_usa_tx_77316_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_2_index ON public.address_usa_tx_77316 USING btree (first_2);


--
-- Name: address_usa_tx_77316_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_3_index ON public.address_usa_tx_77316 USING btree (first_3);


--
-- Name: address_usa_tx_77316_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_4_index ON public.address_usa_tx_77316 USING btree (first_4);


--
-- Name: address_usa_tx_77316_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_5_index ON public.address_usa_tx_77316 USING btree (first_5);


--
-- Name: address_usa_tx_77316_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_6_index ON public.address_usa_tx_77316 USING btree (first_6);


--
-- Name: address_usa_tx_77316_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_7_index ON public.address_usa_tx_77316 USING btree (first_7);


--
-- Name: address_usa_tx_77316_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_8_index ON public.address_usa_tx_77316 USING btree (first_8);


--
-- Name: address_usa_tx_77316_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77316_first_9_index ON public.address_usa_tx_77316 USING btree (first_9);


--
-- Name: address_usa_tx_77318_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_esiid_index ON public.address_usa_tx_77318 USING btree (esiid);


--
-- Name: address_usa_tx_77318_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_1_index ON public.address_usa_tx_77318 USING btree (first_1);


--
-- Name: address_usa_tx_77318_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_2_index ON public.address_usa_tx_77318 USING btree (first_2);


--
-- Name: address_usa_tx_77318_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_3_index ON public.address_usa_tx_77318 USING btree (first_3);


--
-- Name: address_usa_tx_77318_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_4_index ON public.address_usa_tx_77318 USING btree (first_4);


--
-- Name: address_usa_tx_77318_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_5_index ON public.address_usa_tx_77318 USING btree (first_5);


--
-- Name: address_usa_tx_77318_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_6_index ON public.address_usa_tx_77318 USING btree (first_6);


--
-- Name: address_usa_tx_77318_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_7_index ON public.address_usa_tx_77318 USING btree (first_7);


--
-- Name: address_usa_tx_77318_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_8_index ON public.address_usa_tx_77318 USING btree (first_8);


--
-- Name: address_usa_tx_77318_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77318_first_9_index ON public.address_usa_tx_77318 USING btree (first_9);


--
-- Name: address_usa_tx_7731_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_1_index ON public.address_usa_tx_7731 USING btree (first_1);


--
-- Name: address_usa_tx_7731_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_2_index ON public.address_usa_tx_7731 USING btree (first_2);


--
-- Name: address_usa_tx_7731_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_3_index ON public.address_usa_tx_7731 USING btree (first_3);


--
-- Name: address_usa_tx_7731_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_4_index ON public.address_usa_tx_7731 USING btree (first_4);


--
-- Name: address_usa_tx_7731_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_5_index ON public.address_usa_tx_7731 USING btree (first_5);


--
-- Name: address_usa_tx_7731_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_6_index ON public.address_usa_tx_7731 USING btree (first_6);


--
-- Name: address_usa_tx_7731_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_7_index ON public.address_usa_tx_7731 USING btree (first_7);


--
-- Name: address_usa_tx_7731_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_8_index ON public.address_usa_tx_7731 USING btree (first_8);


--
-- Name: address_usa_tx_7731_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7731_first_9_index ON public.address_usa_tx_7731 USING btree (first_9);


--
-- Name: address_usa_tx_77320_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_esiid_index ON public.address_usa_tx_77320 USING btree (esiid);


--
-- Name: address_usa_tx_77320_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_1_index ON public.address_usa_tx_77320 USING btree (first_1);


--
-- Name: address_usa_tx_77320_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_2_index ON public.address_usa_tx_77320 USING btree (first_2);


--
-- Name: address_usa_tx_77320_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_3_index ON public.address_usa_tx_77320 USING btree (first_3);


--
-- Name: address_usa_tx_77320_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_4_index ON public.address_usa_tx_77320 USING btree (first_4);


--
-- Name: address_usa_tx_77320_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_5_index ON public.address_usa_tx_77320 USING btree (first_5);


--
-- Name: address_usa_tx_77320_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_6_index ON public.address_usa_tx_77320 USING btree (first_6);


--
-- Name: address_usa_tx_77320_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_7_index ON public.address_usa_tx_77320 USING btree (first_7);


--
-- Name: address_usa_tx_77320_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_8_index ON public.address_usa_tx_77320 USING btree (first_8);


--
-- Name: address_usa_tx_77320_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77320_first_9_index ON public.address_usa_tx_77320 USING btree (first_9);


--
-- Name: address_usa_tx_77325_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_esiid_index ON public.address_usa_tx_77325 USING btree (esiid);


--
-- Name: address_usa_tx_77325_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_1_index ON public.address_usa_tx_77325 USING btree (first_1);


--
-- Name: address_usa_tx_77325_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_2_index ON public.address_usa_tx_77325 USING btree (first_2);


--
-- Name: address_usa_tx_77325_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_3_index ON public.address_usa_tx_77325 USING btree (first_3);


--
-- Name: address_usa_tx_77325_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_4_index ON public.address_usa_tx_77325 USING btree (first_4);


--
-- Name: address_usa_tx_77325_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_5_index ON public.address_usa_tx_77325 USING btree (first_5);


--
-- Name: address_usa_tx_77325_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_6_index ON public.address_usa_tx_77325 USING btree (first_6);


--
-- Name: address_usa_tx_77325_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_7_index ON public.address_usa_tx_77325 USING btree (first_7);


--
-- Name: address_usa_tx_77325_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_8_index ON public.address_usa_tx_77325 USING btree (first_8);


--
-- Name: address_usa_tx_77325_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77325_first_9_index ON public.address_usa_tx_77325 USING btree (first_9);


--
-- Name: address_usa_tx_77326_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_esiid_index ON public.address_usa_tx_77326 USING btree (esiid);


--
-- Name: address_usa_tx_77326_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_1_index ON public.address_usa_tx_77326 USING btree (first_1);


--
-- Name: address_usa_tx_77326_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_2_index ON public.address_usa_tx_77326 USING btree (first_2);


--
-- Name: address_usa_tx_77326_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_3_index ON public.address_usa_tx_77326 USING btree (first_3);


--
-- Name: address_usa_tx_77326_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_4_index ON public.address_usa_tx_77326 USING btree (first_4);


--
-- Name: address_usa_tx_77326_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_5_index ON public.address_usa_tx_77326 USING btree (first_5);


--
-- Name: address_usa_tx_77326_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_6_index ON public.address_usa_tx_77326 USING btree (first_6);


--
-- Name: address_usa_tx_77326_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_7_index ON public.address_usa_tx_77326 USING btree (first_7);


--
-- Name: address_usa_tx_77326_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_8_index ON public.address_usa_tx_77326 USING btree (first_8);


--
-- Name: address_usa_tx_77326_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77326_first_9_index ON public.address_usa_tx_77326 USING btree (first_9);


--
-- Name: address_usa_tx_77327_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_esiid_index ON public.address_usa_tx_77327 USING btree (esiid);


--
-- Name: address_usa_tx_77327_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_1_index ON public.address_usa_tx_77327 USING btree (first_1);


--
-- Name: address_usa_tx_77327_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_2_index ON public.address_usa_tx_77327 USING btree (first_2);


--
-- Name: address_usa_tx_77327_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_3_index ON public.address_usa_tx_77327 USING btree (first_3);


--
-- Name: address_usa_tx_77327_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_4_index ON public.address_usa_tx_77327 USING btree (first_4);


--
-- Name: address_usa_tx_77327_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_5_index ON public.address_usa_tx_77327 USING btree (first_5);


--
-- Name: address_usa_tx_77327_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_6_index ON public.address_usa_tx_77327 USING btree (first_6);


--
-- Name: address_usa_tx_77327_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_7_index ON public.address_usa_tx_77327 USING btree (first_7);


--
-- Name: address_usa_tx_77327_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_8_index ON public.address_usa_tx_77327 USING btree (first_8);


--
-- Name: address_usa_tx_77327_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77327_first_9_index ON public.address_usa_tx_77327 USING btree (first_9);


--
-- Name: address_usa_tx_77328_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_esiid_index ON public.address_usa_tx_77328 USING btree (esiid);


--
-- Name: address_usa_tx_77328_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_1_index ON public.address_usa_tx_77328 USING btree (first_1);


--
-- Name: address_usa_tx_77328_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_2_index ON public.address_usa_tx_77328 USING btree (first_2);


--
-- Name: address_usa_tx_77328_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_3_index ON public.address_usa_tx_77328 USING btree (first_3);


--
-- Name: address_usa_tx_77328_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_4_index ON public.address_usa_tx_77328 USING btree (first_4);


--
-- Name: address_usa_tx_77328_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_5_index ON public.address_usa_tx_77328 USING btree (first_5);


--
-- Name: address_usa_tx_77328_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_6_index ON public.address_usa_tx_77328 USING btree (first_6);


--
-- Name: address_usa_tx_77328_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_7_index ON public.address_usa_tx_77328 USING btree (first_7);


--
-- Name: address_usa_tx_77328_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_8_index ON public.address_usa_tx_77328 USING btree (first_8);


--
-- Name: address_usa_tx_77328_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77328_first_9_index ON public.address_usa_tx_77328 USING btree (first_9);


--
-- Name: address_usa_tx_7732_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_1_index ON public.address_usa_tx_7732 USING btree (first_1);


--
-- Name: address_usa_tx_7732_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_2_index ON public.address_usa_tx_7732 USING btree (first_2);


--
-- Name: address_usa_tx_7732_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_3_index ON public.address_usa_tx_7732 USING btree (first_3);


--
-- Name: address_usa_tx_7732_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_4_index ON public.address_usa_tx_7732 USING btree (first_4);


--
-- Name: address_usa_tx_7732_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_5_index ON public.address_usa_tx_7732 USING btree (first_5);


--
-- Name: address_usa_tx_7732_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_6_index ON public.address_usa_tx_7732 USING btree (first_6);


--
-- Name: address_usa_tx_7732_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_7_index ON public.address_usa_tx_7732 USING btree (first_7);


--
-- Name: address_usa_tx_7732_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_8_index ON public.address_usa_tx_7732 USING btree (first_8);


--
-- Name: address_usa_tx_7732_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7732_first_9_index ON public.address_usa_tx_7732 USING btree (first_9);


--
-- Name: address_usa_tx_77331_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_esiid_index ON public.address_usa_tx_77331 USING btree (esiid);


--
-- Name: address_usa_tx_77331_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_1_index ON public.address_usa_tx_77331 USING btree (first_1);


--
-- Name: address_usa_tx_77331_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_2_index ON public.address_usa_tx_77331 USING btree (first_2);


--
-- Name: address_usa_tx_77331_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_3_index ON public.address_usa_tx_77331 USING btree (first_3);


--
-- Name: address_usa_tx_77331_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_4_index ON public.address_usa_tx_77331 USING btree (first_4);


--
-- Name: address_usa_tx_77331_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_5_index ON public.address_usa_tx_77331 USING btree (first_5);


--
-- Name: address_usa_tx_77331_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_6_index ON public.address_usa_tx_77331 USING btree (first_6);


--
-- Name: address_usa_tx_77331_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_7_index ON public.address_usa_tx_77331 USING btree (first_7);


--
-- Name: address_usa_tx_77331_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_8_index ON public.address_usa_tx_77331 USING btree (first_8);


--
-- Name: address_usa_tx_77331_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77331_first_9_index ON public.address_usa_tx_77331 USING btree (first_9);


--
-- Name: address_usa_tx_77332_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_esiid_index ON public.address_usa_tx_77332 USING btree (esiid);


--
-- Name: address_usa_tx_77332_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_1_index ON public.address_usa_tx_77332 USING btree (first_1);


--
-- Name: address_usa_tx_77332_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_2_index ON public.address_usa_tx_77332 USING btree (first_2);


--
-- Name: address_usa_tx_77332_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_3_index ON public.address_usa_tx_77332 USING btree (first_3);


--
-- Name: address_usa_tx_77332_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_4_index ON public.address_usa_tx_77332 USING btree (first_4);


--
-- Name: address_usa_tx_77332_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_5_index ON public.address_usa_tx_77332 USING btree (first_5);


--
-- Name: address_usa_tx_77332_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_6_index ON public.address_usa_tx_77332 USING btree (first_6);


--
-- Name: address_usa_tx_77332_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_7_index ON public.address_usa_tx_77332 USING btree (first_7);


--
-- Name: address_usa_tx_77332_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_8_index ON public.address_usa_tx_77332 USING btree (first_8);


--
-- Name: address_usa_tx_77332_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77332_first_9_index ON public.address_usa_tx_77332 USING btree (first_9);


--
-- Name: address_usa_tx_77333_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_esiid_index ON public.address_usa_tx_77333 USING btree (esiid);


--
-- Name: address_usa_tx_77333_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_1_index ON public.address_usa_tx_77333 USING btree (first_1);


--
-- Name: address_usa_tx_77333_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_2_index ON public.address_usa_tx_77333 USING btree (first_2);


--
-- Name: address_usa_tx_77333_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_3_index ON public.address_usa_tx_77333 USING btree (first_3);


--
-- Name: address_usa_tx_77333_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_4_index ON public.address_usa_tx_77333 USING btree (first_4);


--
-- Name: address_usa_tx_77333_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_5_index ON public.address_usa_tx_77333 USING btree (first_5);


--
-- Name: address_usa_tx_77333_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_6_index ON public.address_usa_tx_77333 USING btree (first_6);


--
-- Name: address_usa_tx_77333_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_7_index ON public.address_usa_tx_77333 USING btree (first_7);


--
-- Name: address_usa_tx_77333_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_8_index ON public.address_usa_tx_77333 USING btree (first_8);


--
-- Name: address_usa_tx_77333_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77333_first_9_index ON public.address_usa_tx_77333 USING btree (first_9);


--
-- Name: address_usa_tx_77334_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_esiid_index ON public.address_usa_tx_77334 USING btree (esiid);


--
-- Name: address_usa_tx_77334_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_1_index ON public.address_usa_tx_77334 USING btree (first_1);


--
-- Name: address_usa_tx_77334_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_2_index ON public.address_usa_tx_77334 USING btree (first_2);


--
-- Name: address_usa_tx_77334_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_3_index ON public.address_usa_tx_77334 USING btree (first_3);


--
-- Name: address_usa_tx_77334_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_4_index ON public.address_usa_tx_77334 USING btree (first_4);


--
-- Name: address_usa_tx_77334_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_5_index ON public.address_usa_tx_77334 USING btree (first_5);


--
-- Name: address_usa_tx_77334_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_6_index ON public.address_usa_tx_77334 USING btree (first_6);


--
-- Name: address_usa_tx_77334_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_7_index ON public.address_usa_tx_77334 USING btree (first_7);


--
-- Name: address_usa_tx_77334_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_8_index ON public.address_usa_tx_77334 USING btree (first_8);


--
-- Name: address_usa_tx_77334_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77334_first_9_index ON public.address_usa_tx_77334 USING btree (first_9);


--
-- Name: address_usa_tx_77335_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_esiid_index ON public.address_usa_tx_77335 USING btree (esiid);


--
-- Name: address_usa_tx_77335_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_1_index ON public.address_usa_tx_77335 USING btree (first_1);


--
-- Name: address_usa_tx_77335_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_2_index ON public.address_usa_tx_77335 USING btree (first_2);


--
-- Name: address_usa_tx_77335_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_3_index ON public.address_usa_tx_77335 USING btree (first_3);


--
-- Name: address_usa_tx_77335_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_4_index ON public.address_usa_tx_77335 USING btree (first_4);


--
-- Name: address_usa_tx_77335_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_5_index ON public.address_usa_tx_77335 USING btree (first_5);


--
-- Name: address_usa_tx_77335_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_6_index ON public.address_usa_tx_77335 USING btree (first_6);


--
-- Name: address_usa_tx_77335_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_7_index ON public.address_usa_tx_77335 USING btree (first_7);


--
-- Name: address_usa_tx_77335_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_8_index ON public.address_usa_tx_77335 USING btree (first_8);


--
-- Name: address_usa_tx_77335_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77335_first_9_index ON public.address_usa_tx_77335 USING btree (first_9);


--
-- Name: address_usa_tx_77336_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_esiid_index ON public.address_usa_tx_77336 USING btree (esiid);


--
-- Name: address_usa_tx_77336_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_1_index ON public.address_usa_tx_77336 USING btree (first_1);


--
-- Name: address_usa_tx_77336_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_2_index ON public.address_usa_tx_77336 USING btree (first_2);


--
-- Name: address_usa_tx_77336_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_3_index ON public.address_usa_tx_77336 USING btree (first_3);


--
-- Name: address_usa_tx_77336_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_4_index ON public.address_usa_tx_77336 USING btree (first_4);


--
-- Name: address_usa_tx_77336_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_5_index ON public.address_usa_tx_77336 USING btree (first_5);


--
-- Name: address_usa_tx_77336_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_6_index ON public.address_usa_tx_77336 USING btree (first_6);


--
-- Name: address_usa_tx_77336_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_7_index ON public.address_usa_tx_77336 USING btree (first_7);


--
-- Name: address_usa_tx_77336_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_8_index ON public.address_usa_tx_77336 USING btree (first_8);


--
-- Name: address_usa_tx_77336_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77336_first_9_index ON public.address_usa_tx_77336 USING btree (first_9);


--
-- Name: address_usa_tx_77337_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_esiid_index ON public.address_usa_tx_77337 USING btree (esiid);


--
-- Name: address_usa_tx_77337_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_1_index ON public.address_usa_tx_77337 USING btree (first_1);


--
-- Name: address_usa_tx_77337_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_2_index ON public.address_usa_tx_77337 USING btree (first_2);


--
-- Name: address_usa_tx_77337_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_3_index ON public.address_usa_tx_77337 USING btree (first_3);


--
-- Name: address_usa_tx_77337_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_4_index ON public.address_usa_tx_77337 USING btree (first_4);


--
-- Name: address_usa_tx_77337_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_5_index ON public.address_usa_tx_77337 USING btree (first_5);


--
-- Name: address_usa_tx_77337_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_6_index ON public.address_usa_tx_77337 USING btree (first_6);


--
-- Name: address_usa_tx_77337_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_7_index ON public.address_usa_tx_77337 USING btree (first_7);


--
-- Name: address_usa_tx_77337_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_8_index ON public.address_usa_tx_77337 USING btree (first_8);


--
-- Name: address_usa_tx_77337_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77337_first_9_index ON public.address_usa_tx_77337 USING btree (first_9);


--
-- Name: address_usa_tx_77338_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77338_esiid_index ON public.address_usa_tx_77338 USING btree (esiid);


--
-- Name: address_usa_tx_77338_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77338_first_1_index ON public.address_usa_tx_77338 USING btree (first_1);


--
-- Name: address_usa_tx_77338_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77338_first_2_index ON public.address_usa_tx_77338 USING btree (first_2);


--
-- Name: address_usa_tx_77338_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77338_first_3_index ON public.address_usa_tx_77338 USING btree (first_3);


--
-- Name: address_usa_tx_77338_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77338_first_4_index ON public.address_usa_tx_77338 USING btree (first_4);


--
