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

CREATE INDEX address_usa_tx_77706_first_4_index ON public.address_usa_tx_77706 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77706_first_5_index ON public.address_usa_tx_77706 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77706_first_6_index ON public.address_usa_tx_77706 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77706_first_7_index ON public.address_usa_tx_77706 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77706_first_8_index ON public.address_usa_tx_77706 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77706_first_9_index ON public.address_usa_tx_77706 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77707_esiid_index ON public.address_usa_tx_77707 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77707_first_1_index ON public.address_usa_tx_77707 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77707_first_2_index ON public.address_usa_tx_77707 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77707_first_3_index ON public.address_usa_tx_77707 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77707_first_4_index ON public.address_usa_tx_77707 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77707_first_5_index ON public.address_usa_tx_77707 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77707_first_6_index ON public.address_usa_tx_77707 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77707_first_7_index ON public.address_usa_tx_77707 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77707_first_8_index ON public.address_usa_tx_77707 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77707_first_9_index ON public.address_usa_tx_77707 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77708_esiid_index ON public.address_usa_tx_77708 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77708_first_1_index ON public.address_usa_tx_77708 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77708_first_2_index ON public.address_usa_tx_77708 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77708_first_3_index ON public.address_usa_tx_77708 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77708_first_4_index ON public.address_usa_tx_77708 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77708_first_5_index ON public.address_usa_tx_77708 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77708_first_6_index ON public.address_usa_tx_77708 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77708_first_7_index ON public.address_usa_tx_77708 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77708_first_8_index ON public.address_usa_tx_77708 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77708_first_9_index ON public.address_usa_tx_77708 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7770_first_1_index ON public.address_usa_tx_7770 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7770_first_2_index ON public.address_usa_tx_7770 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7770_first_3_index ON public.address_usa_tx_7770 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7770_first_4_index ON public.address_usa_tx_7770 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7770_first_5_index ON public.address_usa_tx_7770 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7770_first_6_index ON public.address_usa_tx_7770 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7770_first_7_index ON public.address_usa_tx_7770 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7770_first_8_index ON public.address_usa_tx_7770 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7770_first_9_index ON public.address_usa_tx_7770 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77713_esiid_index ON public.address_usa_tx_77713 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77713_first_1_index ON public.address_usa_tx_77713 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77713_first_2_index ON public.address_usa_tx_77713 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77713_first_3_index ON public.address_usa_tx_77713 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77713_first_4_index ON public.address_usa_tx_77713 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77713_first_5_index ON public.address_usa_tx_77713 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77713_first_6_index ON public.address_usa_tx_77713 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77713_first_7_index ON public.address_usa_tx_77713 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77713_first_8_index ON public.address_usa_tx_77713 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77713_first_9_index ON public.address_usa_tx_77713 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7771_first_1_index ON public.address_usa_tx_7771 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7771_first_2_index ON public.address_usa_tx_7771 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7771_first_3_index ON public.address_usa_tx_7771 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7771_first_4_index ON public.address_usa_tx_7771 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7771_first_5_index ON public.address_usa_tx_7771 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7771_first_6_index ON public.address_usa_tx_7771 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7771_first_7_index ON public.address_usa_tx_7771 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7771_first_8_index ON public.address_usa_tx_7771 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7771_first_9_index ON public.address_usa_tx_7771 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77720_esiid_index ON public.address_usa_tx_77720 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77720_first_1_index ON public.address_usa_tx_77720 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77720_first_2_index ON public.address_usa_tx_77720 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77720_first_3_index ON public.address_usa_tx_77720 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77720_first_4_index ON public.address_usa_tx_77720 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77720_first_5_index ON public.address_usa_tx_77720 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77720_first_6_index ON public.address_usa_tx_77720 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77720_first_7_index ON public.address_usa_tx_77720 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77720_first_8_index ON public.address_usa_tx_77720 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77720_first_9_index ON public.address_usa_tx_77720 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77723_esiid_index ON public.address_usa_tx_77723 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77723_first_1_index ON public.address_usa_tx_77723 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77723_first_2_index ON public.address_usa_tx_77723 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77723_first_3_index ON public.address_usa_tx_77723 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77723_first_4_index ON public.address_usa_tx_77723 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77723_first_5_index ON public.address_usa_tx_77723 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77723_first_6_index ON public.address_usa_tx_77723 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77723_first_7_index ON public.address_usa_tx_77723 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77723_first_8_index ON public.address_usa_tx_77723 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77723_first_9_index ON public.address_usa_tx_77723 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77725_esiid_index ON public.address_usa_tx_77725 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77725_first_1_index ON public.address_usa_tx_77725 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77725_first_2_index ON public.address_usa_tx_77725 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77725_first_3_index ON public.address_usa_tx_77725 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77725_first_4_index ON public.address_usa_tx_77725 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77725_first_5_index ON public.address_usa_tx_77725 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77725_first_6_index ON public.address_usa_tx_77725 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77725_first_7_index ON public.address_usa_tx_77725 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77725_first_8_index ON public.address_usa_tx_77725 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77725_first_9_index ON public.address_usa_tx_77725 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77726_esiid_index ON public.address_usa_tx_77726 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77726_first_1_index ON public.address_usa_tx_77726 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77726_first_2_index ON public.address_usa_tx_77726 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77726_first_3_index ON public.address_usa_tx_77726 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77726_first_4_index ON public.address_usa_tx_77726 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77726_first_5_index ON public.address_usa_tx_77726 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77726_first_6_index ON public.address_usa_tx_77726 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77726_first_7_index ON public.address_usa_tx_77726 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77726_first_8_index ON public.address_usa_tx_77726 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77726_first_9_index ON public.address_usa_tx_77726 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7772_first_1_index ON public.address_usa_tx_7772 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7772_first_2_index ON public.address_usa_tx_7772 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7772_first_3_index ON public.address_usa_tx_7772 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7772_first_4_index ON public.address_usa_tx_7772 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7772_first_5_index ON public.address_usa_tx_7772 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7772_first_6_index ON public.address_usa_tx_7772 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7772_first_7_index ON public.address_usa_tx_7772 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7772_first_8_index ON public.address_usa_tx_7772 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7772_first_9_index ON public.address_usa_tx_7772 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77777_first_1_index ON public.address_usa_tx_77777 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77777_first_2_index ON public.address_usa_tx_77777 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77777_first_3_index ON public.address_usa_tx_77777 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77777_first_4_index ON public.address_usa_tx_77777 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77777_first_5_index ON public.address_usa_tx_77777 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77777_first_6_index ON public.address_usa_tx_77777 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77777_first_7_index ON public.address_usa_tx_77777 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77777_first_8_index ON public.address_usa_tx_77777 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77777_first_9_index ON public.address_usa_tx_77777 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7777_first_1_index ON public.address_usa_tx_7777 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7777_first_2_index ON public.address_usa_tx_7777 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7777_first_3_index ON public.address_usa_tx_7777 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7777_first_4_index ON public.address_usa_tx_7777 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7777_first_5_index ON public.address_usa_tx_7777 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7777_first_6_index ON public.address_usa_tx_7777 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7777_first_7_index ON public.address_usa_tx_7777 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7777_first_8_index ON public.address_usa_tx_7777 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7777_first_9_index ON public.address_usa_tx_7777 USING btree (first_9);


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

CREATE INDEX address_usa_tx_777_first_1_index ON public.address_usa_tx_777 USING btree (first_1);


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

CREATE INDEX address_usa_tx_777_first_2_index ON public.address_usa_tx_777 USING btree (first_2);


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

CREATE INDEX address_usa_tx_777_first_3_index ON public.address_usa_tx_777 USING btree (first_3);


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

CREATE INDEX address_usa_tx_777_first_4_index ON public.address_usa_tx_777 USING btree (first_4);


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

CREATE INDEX address_usa_tx_777_first_5_index ON public.address_usa_tx_777 USING btree (first_5);


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

CREATE INDEX address_usa_tx_777_first_6_index ON public.address_usa_tx_777 USING btree (first_6);


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

CREATE INDEX address_usa_tx_777_first_7_index ON public.address_usa_tx_777 USING btree (first_7);


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

CREATE INDEX address_usa_tx_777_first_8_index ON public.address_usa_tx_777 USING btree (first_8);


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

CREATE INDEX address_usa_tx_777_first_9_index ON public.address_usa_tx_777 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77801_esiid_index ON public.address_usa_tx_77801 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77801_first_1_index ON public.address_usa_tx_77801 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77801_first_2_index ON public.address_usa_tx_77801 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77801_first_3_index ON public.address_usa_tx_77801 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77801_first_4_index ON public.address_usa_tx_77801 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77801_first_5_index ON public.address_usa_tx_77801 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77801_first_6_index ON public.address_usa_tx_77801 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77801_first_7_index ON public.address_usa_tx_77801 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77801_first_8_index ON public.address_usa_tx_77801 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77801_first_9_index ON public.address_usa_tx_77801 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77802_esiid_index ON public.address_usa_tx_77802 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77802_first_1_index ON public.address_usa_tx_77802 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77802_first_2_index ON public.address_usa_tx_77802 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77802_first_3_index ON public.address_usa_tx_77802 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77802_first_4_index ON public.address_usa_tx_77802 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77802_first_5_index ON public.address_usa_tx_77802 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77802_first_6_index ON public.address_usa_tx_77802 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77802_first_7_index ON public.address_usa_tx_77802 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77802_first_8_index ON public.address_usa_tx_77802 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77802_first_9_index ON public.address_usa_tx_77802 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77803_esiid_index ON public.address_usa_tx_77803 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77803_first_1_index ON public.address_usa_tx_77803 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77803_first_2_index ON public.address_usa_tx_77803 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77803_first_3_index ON public.address_usa_tx_77803 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77803_first_4_index ON public.address_usa_tx_77803 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77803_first_5_index ON public.address_usa_tx_77803 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77803_first_6_index ON public.address_usa_tx_77803 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77803_first_7_index ON public.address_usa_tx_77803 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77803_first_8_index ON public.address_usa_tx_77803 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77803_first_9_index ON public.address_usa_tx_77803 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77805_esiid_index ON public.address_usa_tx_77805 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77805_first_1_index ON public.address_usa_tx_77805 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77805_first_2_index ON public.address_usa_tx_77805 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77805_first_3_index ON public.address_usa_tx_77805 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77805_first_4_index ON public.address_usa_tx_77805 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77805_first_5_index ON public.address_usa_tx_77805 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77805_first_6_index ON public.address_usa_tx_77805 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77805_first_7_index ON public.address_usa_tx_77805 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77805_first_8_index ON public.address_usa_tx_77805 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77805_first_9_index ON public.address_usa_tx_77805 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77807_esiid_index ON public.address_usa_tx_77807 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77807_first_1_index ON public.address_usa_tx_77807 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77807_first_2_index ON public.address_usa_tx_77807 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77807_first_3_index ON public.address_usa_tx_77807 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77807_first_4_index ON public.address_usa_tx_77807 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77807_first_5_index ON public.address_usa_tx_77807 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77807_first_6_index ON public.address_usa_tx_77807 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77807_first_7_index ON public.address_usa_tx_77807 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77807_first_8_index ON public.address_usa_tx_77807 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77807_first_9_index ON public.address_usa_tx_77807 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7780_first_1_index ON public.address_usa_tx_7780 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7780_first_2_index ON public.address_usa_tx_7780 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7780_first_3_index ON public.address_usa_tx_7780 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7780_first_4_index ON public.address_usa_tx_7780 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7780_first_5_index ON public.address_usa_tx_7780 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7780_first_6_index ON public.address_usa_tx_7780 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7780_first_7_index ON public.address_usa_tx_7780 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7780_first_8_index ON public.address_usa_tx_7780 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7780_first_9_index ON public.address_usa_tx_7780 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77830_esiid_index ON public.address_usa_tx_77830 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77830_first_1_index ON public.address_usa_tx_77830 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77830_first_2_index ON public.address_usa_tx_77830 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77830_first_3_index ON public.address_usa_tx_77830 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77830_first_4_index ON public.address_usa_tx_77830 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77830_first_5_index ON public.address_usa_tx_77830 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77830_first_6_index ON public.address_usa_tx_77830 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77830_first_7_index ON public.address_usa_tx_77830 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77830_first_8_index ON public.address_usa_tx_77830 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77830_first_9_index ON public.address_usa_tx_77830 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77831_esiid_index ON public.address_usa_tx_77831 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77831_first_1_index ON public.address_usa_tx_77831 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77831_first_2_index ON public.address_usa_tx_77831 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77831_first_3_index ON public.address_usa_tx_77831 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77831_first_4_index ON public.address_usa_tx_77831 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77831_first_5_index ON public.address_usa_tx_77831 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77831_first_6_index ON public.address_usa_tx_77831 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77831_first_7_index ON public.address_usa_tx_77831 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77831_first_8_index ON public.address_usa_tx_77831 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77831_first_9_index ON public.address_usa_tx_77831 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77836_esiid_index ON public.address_usa_tx_77836 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77836_first_1_index ON public.address_usa_tx_77836 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77836_first_2_index ON public.address_usa_tx_77836 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77836_first_3_index ON public.address_usa_tx_77836 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77836_first_4_index ON public.address_usa_tx_77836 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77836_first_5_index ON public.address_usa_tx_77836 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77836_first_6_index ON public.address_usa_tx_77836 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77836_first_7_index ON public.address_usa_tx_77836 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77836_first_8_index ON public.address_usa_tx_77836 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77836_first_9_index ON public.address_usa_tx_77836 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77837_esiid_index ON public.address_usa_tx_77837 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77837_first_1_index ON public.address_usa_tx_77837 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77837_first_2_index ON public.address_usa_tx_77837 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77837_first_3_index ON public.address_usa_tx_77837 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77837_first_4_index ON public.address_usa_tx_77837 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77837_first_5_index ON public.address_usa_tx_77837 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77837_first_6_index ON public.address_usa_tx_77837 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77837_first_7_index ON public.address_usa_tx_77837 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77837_first_8_index ON public.address_usa_tx_77837 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77837_first_9_index ON public.address_usa_tx_77837 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77839_esiid_index ON public.address_usa_tx_77839 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77839_first_1_index ON public.address_usa_tx_77839 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77839_first_2_index ON public.address_usa_tx_77839 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77839_first_3_index ON public.address_usa_tx_77839 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77839_first_4_index ON public.address_usa_tx_77839 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77839_first_5_index ON public.address_usa_tx_77839 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77839_first_6_index ON public.address_usa_tx_77839 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77839_first_7_index ON public.address_usa_tx_77839 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77839_first_8_index ON public.address_usa_tx_77839 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77839_first_9_index ON public.address_usa_tx_77839 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7783_first_1_index ON public.address_usa_tx_7783 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7783_first_2_index ON public.address_usa_tx_7783 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7783_first_3_index ON public.address_usa_tx_7783 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7783_first_4_index ON public.address_usa_tx_7783 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7783_first_5_index ON public.address_usa_tx_7783 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7783_first_6_index ON public.address_usa_tx_7783 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7783_first_7_index ON public.address_usa_tx_7783 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7783_first_8_index ON public.address_usa_tx_7783 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7783_first_9_index ON public.address_usa_tx_7783 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77840_esiid_index ON public.address_usa_tx_77840 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77840_first_1_index ON public.address_usa_tx_77840 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77840_first_2_index ON public.address_usa_tx_77840 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77840_first_3_index ON public.address_usa_tx_77840 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77840_first_4_index ON public.address_usa_tx_77840 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77840_first_5_index ON public.address_usa_tx_77840 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77840_first_6_index ON public.address_usa_tx_77840 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77840_first_7_index ON public.address_usa_tx_77840 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77840_first_8_index ON public.address_usa_tx_77840 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77840_first_9_index ON public.address_usa_tx_77840 USING btree (first_9);


--
-- Name: address_usa_tx_77841_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_1_index ON public.address_usa_tx_77841 USING btree (first_1);


--
-- Name: address_usa_tx_77841_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_2_index ON public.address_usa_tx_77841 USING btree (first_2);


--
-- Name: address_usa_tx_77841_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_3_index ON public.address_usa_tx_77841 USING btree (first_3);


--
-- Name: address_usa_tx_77841_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_4_index ON public.address_usa_tx_77841 USING btree (first_4);


--
-- Name: address_usa_tx_77841_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_5_index ON public.address_usa_tx_77841 USING btree (first_5);


--
-- Name: address_usa_tx_77841_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_6_index ON public.address_usa_tx_77841 USING btree (first_6);


--
-- Name: address_usa_tx_77841_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_7_index ON public.address_usa_tx_77841 USING btree (first_7);


--
-- Name: address_usa_tx_77841_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_8_index ON public.address_usa_tx_77841 USING btree (first_8);


--
-- Name: address_usa_tx_77841_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77841_first_9_index ON public.address_usa_tx_77841 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77842_esiid_index ON public.address_usa_tx_77842 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77842_first_1_index ON public.address_usa_tx_77842 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77842_first_2_index ON public.address_usa_tx_77842 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77842_first_3_index ON public.address_usa_tx_77842 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77842_first_4_index ON public.address_usa_tx_77842 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77842_first_5_index ON public.address_usa_tx_77842 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77842_first_6_index ON public.address_usa_tx_77842 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77842_first_7_index ON public.address_usa_tx_77842 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77842_first_8_index ON public.address_usa_tx_77842 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77842_first_9_index ON public.address_usa_tx_77842 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77845_esiid_index ON public.address_usa_tx_77845 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77845_first_1_index ON public.address_usa_tx_77845 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77845_first_2_index ON public.address_usa_tx_77845 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77845_first_3_index ON public.address_usa_tx_77845 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77845_first_4_index ON public.address_usa_tx_77845 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77845_first_5_index ON public.address_usa_tx_77845 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77845_first_6_index ON public.address_usa_tx_77845 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77845_first_7_index ON public.address_usa_tx_77845 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77845_first_8_index ON public.address_usa_tx_77845 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77845_first_9_index ON public.address_usa_tx_77845 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7784_first_1_index ON public.address_usa_tx_7784 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7784_first_2_index ON public.address_usa_tx_7784 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7784_first_3_index ON public.address_usa_tx_7784 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7784_first_4_index ON public.address_usa_tx_7784 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7784_first_5_index ON public.address_usa_tx_7784 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7784_first_6_index ON public.address_usa_tx_7784 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7784_first_7_index ON public.address_usa_tx_7784 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7784_first_8_index ON public.address_usa_tx_7784 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7784_first_9_index ON public.address_usa_tx_7784 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77852_esiid_index ON public.address_usa_tx_77852 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77852_first_1_index ON public.address_usa_tx_77852 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77852_first_2_index ON public.address_usa_tx_77852 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77852_first_3_index ON public.address_usa_tx_77852 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77852_first_4_index ON public.address_usa_tx_77852 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77852_first_5_index ON public.address_usa_tx_77852 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77852_first_6_index ON public.address_usa_tx_77852 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77852_first_7_index ON public.address_usa_tx_77852 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77852_first_8_index ON public.address_usa_tx_77852 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77852_first_9_index ON public.address_usa_tx_77852 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77855_first_1_index ON public.address_usa_tx_77855 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77855_first_2_index ON public.address_usa_tx_77855 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77855_first_3_index ON public.address_usa_tx_77855 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77855_first_4_index ON public.address_usa_tx_77855 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77855_first_5_index ON public.address_usa_tx_77855 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77855_first_6_index ON public.address_usa_tx_77855 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77855_first_7_index ON public.address_usa_tx_77855 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77855_first_8_index ON public.address_usa_tx_77855 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77855_first_9_index ON public.address_usa_tx_77855 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77856_esiid_index ON public.address_usa_tx_77856 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77856_first_1_index ON public.address_usa_tx_77856 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77856_first_2_index ON public.address_usa_tx_77856 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77856_first_3_index ON public.address_usa_tx_77856 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77856_first_4_index ON public.address_usa_tx_77856 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77856_first_5_index ON public.address_usa_tx_77856 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77856_first_6_index ON public.address_usa_tx_77856 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77856_first_7_index ON public.address_usa_tx_77856 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77856_first_8_index ON public.address_usa_tx_77856 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77856_first_9_index ON public.address_usa_tx_77856 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77857_esiid_index ON public.address_usa_tx_77857 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77857_first_1_index ON public.address_usa_tx_77857 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77857_first_2_index ON public.address_usa_tx_77857 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77857_first_3_index ON public.address_usa_tx_77857 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77857_first_4_index ON public.address_usa_tx_77857 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77857_first_5_index ON public.address_usa_tx_77857 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77857_first_6_index ON public.address_usa_tx_77857 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77857_first_7_index ON public.address_usa_tx_77857 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77857_first_8_index ON public.address_usa_tx_77857 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77857_first_9_index ON public.address_usa_tx_77857 USING btree (first_9);


--
-- Name: address_usa_tx_77858_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_1_index ON public.address_usa_tx_77858 USING btree (first_1);


--
-- Name: address_usa_tx_77858_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_2_index ON public.address_usa_tx_77858 USING btree (first_2);


--
-- Name: address_usa_tx_77858_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_3_index ON public.address_usa_tx_77858 USING btree (first_3);


--
-- Name: address_usa_tx_77858_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_4_index ON public.address_usa_tx_77858 USING btree (first_4);


--
-- Name: address_usa_tx_77858_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_5_index ON public.address_usa_tx_77858 USING btree (first_5);


--
-- Name: address_usa_tx_77858_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_6_index ON public.address_usa_tx_77858 USING btree (first_6);


--
-- Name: address_usa_tx_77858_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_7_index ON public.address_usa_tx_77858 USING btree (first_7);


--
-- Name: address_usa_tx_77858_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_8_index ON public.address_usa_tx_77858 USING btree (first_8);


--
-- Name: address_usa_tx_77858_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_tx_77858_first_9_index ON public.address_usa_tx_77858 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77859_esiid_index ON public.address_usa_tx_77859 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77859_first_1_index ON public.address_usa_tx_77859 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77859_first_2_index ON public.address_usa_tx_77859 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77859_first_3_index ON public.address_usa_tx_77859 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77859_first_4_index ON public.address_usa_tx_77859 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77859_first_5_index ON public.address_usa_tx_77859 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77859_first_6_index ON public.address_usa_tx_77859 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77859_first_7_index ON public.address_usa_tx_77859 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77859_first_8_index ON public.address_usa_tx_77859 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77859_first_9_index ON public.address_usa_tx_77859 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7785_first_1_index ON public.address_usa_tx_7785 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7785_first_2_index ON public.address_usa_tx_7785 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7785_first_3_index ON public.address_usa_tx_7785 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7785_first_4_index ON public.address_usa_tx_7785 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7785_first_5_index ON public.address_usa_tx_7785 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7785_first_6_index ON public.address_usa_tx_7785 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7785_first_7_index ON public.address_usa_tx_7785 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7785_first_8_index ON public.address_usa_tx_7785 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7785_first_9_index ON public.address_usa_tx_7785 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77861_esiid_index ON public.address_usa_tx_77861 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77861_first_1_index ON public.address_usa_tx_77861 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77861_first_2_index ON public.address_usa_tx_77861 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77861_first_3_index ON public.address_usa_tx_77861 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77861_first_4_index ON public.address_usa_tx_77861 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77861_first_5_index ON public.address_usa_tx_77861 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77861_first_6_index ON public.address_usa_tx_77861 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77861_first_7_index ON public.address_usa_tx_77861 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77861_first_8_index ON public.address_usa_tx_77861 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77861_first_9_index ON public.address_usa_tx_77861 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77862_esiid_index ON public.address_usa_tx_77862 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77862_first_1_index ON public.address_usa_tx_77862 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77862_first_2_index ON public.address_usa_tx_77862 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77862_first_3_index ON public.address_usa_tx_77862 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77862_first_4_index ON public.address_usa_tx_77862 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77862_first_5_index ON public.address_usa_tx_77862 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77862_first_6_index ON public.address_usa_tx_77862 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77862_first_7_index ON public.address_usa_tx_77862 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77862_first_8_index ON public.address_usa_tx_77862 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77862_first_9_index ON public.address_usa_tx_77862 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77863_esiid_index ON public.address_usa_tx_77863 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77863_first_1_index ON public.address_usa_tx_77863 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77863_first_2_index ON public.address_usa_tx_77863 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77863_first_3_index ON public.address_usa_tx_77863 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77863_first_4_index ON public.address_usa_tx_77863 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77863_first_5_index ON public.address_usa_tx_77863 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77863_first_6_index ON public.address_usa_tx_77863 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77863_first_7_index ON public.address_usa_tx_77863 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77863_first_8_index ON public.address_usa_tx_77863 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77863_first_9_index ON public.address_usa_tx_77863 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77864_esiid_index ON public.address_usa_tx_77864 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77864_first_1_index ON public.address_usa_tx_77864 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77864_first_2_index ON public.address_usa_tx_77864 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77864_first_3_index ON public.address_usa_tx_77864 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77864_first_4_index ON public.address_usa_tx_77864 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77864_first_5_index ON public.address_usa_tx_77864 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77864_first_6_index ON public.address_usa_tx_77864 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77864_first_7_index ON public.address_usa_tx_77864 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77864_first_8_index ON public.address_usa_tx_77864 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77864_first_9_index ON public.address_usa_tx_77864 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77865_esiid_index ON public.address_usa_tx_77865 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77865_first_1_index ON public.address_usa_tx_77865 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77865_first_2_index ON public.address_usa_tx_77865 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77865_first_3_index ON public.address_usa_tx_77865 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77865_first_4_index ON public.address_usa_tx_77865 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77865_first_5_index ON public.address_usa_tx_77865 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77865_first_6_index ON public.address_usa_tx_77865 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77865_first_7_index ON public.address_usa_tx_77865 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77865_first_8_index ON public.address_usa_tx_77865 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77865_first_9_index ON public.address_usa_tx_77865 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77867_esiid_index ON public.address_usa_tx_77867 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77867_first_1_index ON public.address_usa_tx_77867 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77867_first_2_index ON public.address_usa_tx_77867 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77867_first_3_index ON public.address_usa_tx_77867 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77867_first_4_index ON public.address_usa_tx_77867 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77867_first_5_index ON public.address_usa_tx_77867 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77867_first_6_index ON public.address_usa_tx_77867 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77867_first_7_index ON public.address_usa_tx_77867 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77867_first_8_index ON public.address_usa_tx_77867 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77867_first_9_index ON public.address_usa_tx_77867 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77868_esiid_index ON public.address_usa_tx_77868 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77868_first_1_index ON public.address_usa_tx_77868 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77868_first_2_index ON public.address_usa_tx_77868 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77868_first_3_index ON public.address_usa_tx_77868 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77868_first_4_index ON public.address_usa_tx_77868 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77868_first_5_index ON public.address_usa_tx_77868 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77868_first_6_index ON public.address_usa_tx_77868 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77868_first_7_index ON public.address_usa_tx_77868 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77868_first_8_index ON public.address_usa_tx_77868 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77868_first_9_index ON public.address_usa_tx_77868 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7786_first_1_index ON public.address_usa_tx_7786 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7786_first_2_index ON public.address_usa_tx_7786 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7786_first_3_index ON public.address_usa_tx_7786 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7786_first_4_index ON public.address_usa_tx_7786 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7786_first_5_index ON public.address_usa_tx_7786 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7786_first_6_index ON public.address_usa_tx_7786 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7786_first_7_index ON public.address_usa_tx_7786 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7786_first_8_index ON public.address_usa_tx_7786 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7786_first_9_index ON public.address_usa_tx_7786 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77870_esiid_index ON public.address_usa_tx_77870 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77870_first_1_index ON public.address_usa_tx_77870 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77870_first_2_index ON public.address_usa_tx_77870 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77870_first_3_index ON public.address_usa_tx_77870 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77870_first_4_index ON public.address_usa_tx_77870 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77870_first_5_index ON public.address_usa_tx_77870 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77870_first_6_index ON public.address_usa_tx_77870 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77870_first_7_index ON public.address_usa_tx_77870 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77870_first_8_index ON public.address_usa_tx_77870 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77870_first_9_index ON public.address_usa_tx_77870 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77871_esiid_index ON public.address_usa_tx_77871 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77871_first_1_index ON public.address_usa_tx_77871 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77871_first_2_index ON public.address_usa_tx_77871 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77871_first_3_index ON public.address_usa_tx_77871 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77871_first_4_index ON public.address_usa_tx_77871 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77871_first_5_index ON public.address_usa_tx_77871 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77871_first_6_index ON public.address_usa_tx_77871 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77871_first_7_index ON public.address_usa_tx_77871 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77871_first_8_index ON public.address_usa_tx_77871 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77871_first_9_index ON public.address_usa_tx_77871 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77872_esiid_index ON public.address_usa_tx_77872 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77872_first_1_index ON public.address_usa_tx_77872 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77872_first_2_index ON public.address_usa_tx_77872 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77872_first_3_index ON public.address_usa_tx_77872 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77872_first_4_index ON public.address_usa_tx_77872 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77872_first_5_index ON public.address_usa_tx_77872 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77872_first_6_index ON public.address_usa_tx_77872 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77872_first_7_index ON public.address_usa_tx_77872 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77872_first_8_index ON public.address_usa_tx_77872 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77872_first_9_index ON public.address_usa_tx_77872 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77873_esiid_index ON public.address_usa_tx_77873 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77873_first_1_index ON public.address_usa_tx_77873 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77873_first_2_index ON public.address_usa_tx_77873 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77873_first_3_index ON public.address_usa_tx_77873 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77873_first_4_index ON public.address_usa_tx_77873 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77873_first_5_index ON public.address_usa_tx_77873 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77873_first_6_index ON public.address_usa_tx_77873 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77873_first_7_index ON public.address_usa_tx_77873 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77873_first_8_index ON public.address_usa_tx_77873 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77873_first_9_index ON public.address_usa_tx_77873 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77875_esiid_index ON public.address_usa_tx_77875 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77875_first_1_index ON public.address_usa_tx_77875 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77875_first_2_index ON public.address_usa_tx_77875 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77875_first_3_index ON public.address_usa_tx_77875 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77875_first_4_index ON public.address_usa_tx_77875 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77875_first_5_index ON public.address_usa_tx_77875 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77875_first_6_index ON public.address_usa_tx_77875 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77875_first_7_index ON public.address_usa_tx_77875 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77875_first_8_index ON public.address_usa_tx_77875 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77875_first_9_index ON public.address_usa_tx_77875 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77876_esiid_index ON public.address_usa_tx_77876 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77876_first_1_index ON public.address_usa_tx_77876 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77876_first_2_index ON public.address_usa_tx_77876 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77876_first_3_index ON public.address_usa_tx_77876 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77876_first_4_index ON public.address_usa_tx_77876 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77876_first_5_index ON public.address_usa_tx_77876 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77876_first_6_index ON public.address_usa_tx_77876 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77876_first_7_index ON public.address_usa_tx_77876 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77876_first_8_index ON public.address_usa_tx_77876 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77876_first_9_index ON public.address_usa_tx_77876 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77878_esiid_index ON public.address_usa_tx_77878 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77878_first_1_index ON public.address_usa_tx_77878 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77878_first_2_index ON public.address_usa_tx_77878 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77878_first_3_index ON public.address_usa_tx_77878 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77878_first_4_index ON public.address_usa_tx_77878 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77878_first_5_index ON public.address_usa_tx_77878 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77878_first_6_index ON public.address_usa_tx_77878 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77878_first_7_index ON public.address_usa_tx_77878 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77878_first_8_index ON public.address_usa_tx_77878 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77878_first_9_index ON public.address_usa_tx_77878 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77879_esiid_index ON public.address_usa_tx_77879 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77879_first_1_index ON public.address_usa_tx_77879 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77879_first_2_index ON public.address_usa_tx_77879 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77879_first_3_index ON public.address_usa_tx_77879 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77879_first_4_index ON public.address_usa_tx_77879 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77879_first_5_index ON public.address_usa_tx_77879 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77879_first_6_index ON public.address_usa_tx_77879 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77879_first_7_index ON public.address_usa_tx_77879 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77879_first_8_index ON public.address_usa_tx_77879 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77879_first_9_index ON public.address_usa_tx_77879 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7787_first_1_index ON public.address_usa_tx_7787 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7787_first_2_index ON public.address_usa_tx_7787 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7787_first_3_index ON public.address_usa_tx_7787 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7787_first_4_index ON public.address_usa_tx_7787 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7787_first_5_index ON public.address_usa_tx_7787 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7787_first_6_index ON public.address_usa_tx_7787 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7787_first_7_index ON public.address_usa_tx_7787 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7787_first_8_index ON public.address_usa_tx_7787 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7787_first_9_index ON public.address_usa_tx_7787 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77880_esiid_index ON public.address_usa_tx_77880 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77880_first_1_index ON public.address_usa_tx_77880 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77880_first_2_index ON public.address_usa_tx_77880 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77880_first_3_index ON public.address_usa_tx_77880 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77880_first_4_index ON public.address_usa_tx_77880 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77880_first_5_index ON public.address_usa_tx_77880 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77880_first_6_index ON public.address_usa_tx_77880 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77880_first_7_index ON public.address_usa_tx_77880 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77880_first_8_index ON public.address_usa_tx_77880 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77880_first_9_index ON public.address_usa_tx_77880 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7788_first_1_index ON public.address_usa_tx_7788 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7788_first_2_index ON public.address_usa_tx_7788 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7788_first_3_index ON public.address_usa_tx_7788 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7788_first_4_index ON public.address_usa_tx_7788 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7788_first_5_index ON public.address_usa_tx_7788 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7788_first_6_index ON public.address_usa_tx_7788 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7788_first_7_index ON public.address_usa_tx_7788 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7788_first_8_index ON public.address_usa_tx_7788 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7788_first_9_index ON public.address_usa_tx_7788 USING btree (first_9);


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

CREATE INDEX address_usa_tx_778_first_1_index ON public.address_usa_tx_778 USING btree (first_1);


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

CREATE INDEX address_usa_tx_778_first_2_index ON public.address_usa_tx_778 USING btree (first_2);


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

CREATE INDEX address_usa_tx_778_first_3_index ON public.address_usa_tx_778 USING btree (first_3);


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

CREATE INDEX address_usa_tx_778_first_4_index ON public.address_usa_tx_778 USING btree (first_4);


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

CREATE INDEX address_usa_tx_778_first_5_index ON public.address_usa_tx_778 USING btree (first_5);


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

CREATE INDEX address_usa_tx_778_first_6_index ON public.address_usa_tx_778 USING btree (first_6);


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

CREATE INDEX address_usa_tx_778_first_7_index ON public.address_usa_tx_778 USING btree (first_7);


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

CREATE INDEX address_usa_tx_778_first_8_index ON public.address_usa_tx_778 USING btree (first_8);


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

CREATE INDEX address_usa_tx_778_first_9_index ON public.address_usa_tx_778 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77901_esiid_index ON public.address_usa_tx_77901 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77901_first_1_index ON public.address_usa_tx_77901 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77901_first_2_index ON public.address_usa_tx_77901 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77901_first_3_index ON public.address_usa_tx_77901 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77901_first_4_index ON public.address_usa_tx_77901 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77901_first_5_index ON public.address_usa_tx_77901 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77901_first_6_index ON public.address_usa_tx_77901 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77901_first_7_index ON public.address_usa_tx_77901 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77901_first_8_index ON public.address_usa_tx_77901 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77901_first_9_index ON public.address_usa_tx_77901 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77903_first_1_index ON public.address_usa_tx_77903 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77903_first_2_index ON public.address_usa_tx_77903 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77903_first_3_index ON public.address_usa_tx_77903 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77903_first_4_index ON public.address_usa_tx_77903 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77903_first_5_index ON public.address_usa_tx_77903 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77903_first_6_index ON public.address_usa_tx_77903 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77903_first_7_index ON public.address_usa_tx_77903 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77903_first_8_index ON public.address_usa_tx_77903 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77903_first_9_index ON public.address_usa_tx_77903 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77904_esiid_index ON public.address_usa_tx_77904 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77904_first_1_index ON public.address_usa_tx_77904 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77904_first_2_index ON public.address_usa_tx_77904 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77904_first_3_index ON public.address_usa_tx_77904 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77904_first_4_index ON public.address_usa_tx_77904 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77904_first_5_index ON public.address_usa_tx_77904 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77904_first_6_index ON public.address_usa_tx_77904 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77904_first_7_index ON public.address_usa_tx_77904 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77904_first_8_index ON public.address_usa_tx_77904 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77904_first_9_index ON public.address_usa_tx_77904 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77905_esiid_index ON public.address_usa_tx_77905 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77905_first_1_index ON public.address_usa_tx_77905 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77905_first_2_index ON public.address_usa_tx_77905 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77905_first_3_index ON public.address_usa_tx_77905 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77905_first_4_index ON public.address_usa_tx_77905 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77905_first_5_index ON public.address_usa_tx_77905 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77905_first_6_index ON public.address_usa_tx_77905 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77905_first_7_index ON public.address_usa_tx_77905 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77905_first_8_index ON public.address_usa_tx_77905 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77905_first_9_index ON public.address_usa_tx_77905 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7790_first_1_index ON public.address_usa_tx_7790 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7790_first_2_index ON public.address_usa_tx_7790 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7790_first_3_index ON public.address_usa_tx_7790 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7790_first_4_index ON public.address_usa_tx_7790 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7790_first_5_index ON public.address_usa_tx_7790 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7790_first_6_index ON public.address_usa_tx_7790 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7790_first_7_index ON public.address_usa_tx_7790 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7790_first_8_index ON public.address_usa_tx_7790 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7790_first_9_index ON public.address_usa_tx_7790 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77950_esiid_index ON public.address_usa_tx_77950 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77950_first_1_index ON public.address_usa_tx_77950 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77950_first_2_index ON public.address_usa_tx_77950 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77950_first_3_index ON public.address_usa_tx_77950 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77950_first_4_index ON public.address_usa_tx_77950 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77950_first_5_index ON public.address_usa_tx_77950 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77950_first_6_index ON public.address_usa_tx_77950 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77950_first_7_index ON public.address_usa_tx_77950 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77950_first_8_index ON public.address_usa_tx_77950 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77950_first_9_index ON public.address_usa_tx_77950 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77951_esiid_index ON public.address_usa_tx_77951 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77951_first_1_index ON public.address_usa_tx_77951 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77951_first_2_index ON public.address_usa_tx_77951 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77951_first_3_index ON public.address_usa_tx_77951 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77951_first_4_index ON public.address_usa_tx_77951 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77951_first_5_index ON public.address_usa_tx_77951 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77951_first_6_index ON public.address_usa_tx_77951 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77951_first_7_index ON public.address_usa_tx_77951 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77951_first_8_index ON public.address_usa_tx_77951 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77951_first_9_index ON public.address_usa_tx_77951 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77957_esiid_index ON public.address_usa_tx_77957 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77957_first_1_index ON public.address_usa_tx_77957 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77957_first_2_index ON public.address_usa_tx_77957 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77957_first_3_index ON public.address_usa_tx_77957 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77957_first_4_index ON public.address_usa_tx_77957 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77957_first_5_index ON public.address_usa_tx_77957 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77957_first_6_index ON public.address_usa_tx_77957 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77957_first_7_index ON public.address_usa_tx_77957 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77957_first_8_index ON public.address_usa_tx_77957 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77957_first_9_index ON public.address_usa_tx_77957 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7795_first_1_index ON public.address_usa_tx_7795 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7795_first_2_index ON public.address_usa_tx_7795 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7795_first_3_index ON public.address_usa_tx_7795 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7795_first_4_index ON public.address_usa_tx_7795 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7795_first_5_index ON public.address_usa_tx_7795 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7795_first_6_index ON public.address_usa_tx_7795 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7795_first_7_index ON public.address_usa_tx_7795 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7795_first_8_index ON public.address_usa_tx_7795 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7795_first_9_index ON public.address_usa_tx_7795 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77962_esiid_index ON public.address_usa_tx_77962 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77962_first_1_index ON public.address_usa_tx_77962 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77962_first_2_index ON public.address_usa_tx_77962 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77962_first_3_index ON public.address_usa_tx_77962 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77962_first_4_index ON public.address_usa_tx_77962 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77962_first_5_index ON public.address_usa_tx_77962 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77962_first_6_index ON public.address_usa_tx_77962 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77962_first_7_index ON public.address_usa_tx_77962 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77962_first_8_index ON public.address_usa_tx_77962 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77962_first_9_index ON public.address_usa_tx_77962 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77963_esiid_index ON public.address_usa_tx_77963 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77963_first_1_index ON public.address_usa_tx_77963 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77963_first_2_index ON public.address_usa_tx_77963 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77963_first_3_index ON public.address_usa_tx_77963 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77963_first_4_index ON public.address_usa_tx_77963 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77963_first_5_index ON public.address_usa_tx_77963 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77963_first_6_index ON public.address_usa_tx_77963 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77963_first_7_index ON public.address_usa_tx_77963 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77963_first_8_index ON public.address_usa_tx_77963 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77963_first_9_index ON public.address_usa_tx_77963 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77964_esiid_index ON public.address_usa_tx_77964 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77964_first_1_index ON public.address_usa_tx_77964 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77964_first_2_index ON public.address_usa_tx_77964 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77964_first_3_index ON public.address_usa_tx_77964 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77964_first_4_index ON public.address_usa_tx_77964 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77964_first_5_index ON public.address_usa_tx_77964 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77964_first_6_index ON public.address_usa_tx_77964 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77964_first_7_index ON public.address_usa_tx_77964 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77964_first_8_index ON public.address_usa_tx_77964 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77964_first_9_index ON public.address_usa_tx_77964 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77968_esiid_index ON public.address_usa_tx_77968 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77968_first_1_index ON public.address_usa_tx_77968 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77968_first_2_index ON public.address_usa_tx_77968 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77968_first_3_index ON public.address_usa_tx_77968 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77968_first_4_index ON public.address_usa_tx_77968 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77968_first_5_index ON public.address_usa_tx_77968 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77968_first_6_index ON public.address_usa_tx_77968 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77968_first_7_index ON public.address_usa_tx_77968 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77968_first_8_index ON public.address_usa_tx_77968 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77968_first_9_index ON public.address_usa_tx_77968 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7796_first_1_index ON public.address_usa_tx_7796 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7796_first_2_index ON public.address_usa_tx_7796 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7796_first_3_index ON public.address_usa_tx_7796 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7796_first_4_index ON public.address_usa_tx_7796 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7796_first_5_index ON public.address_usa_tx_7796 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7796_first_6_index ON public.address_usa_tx_7796 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7796_first_7_index ON public.address_usa_tx_7796 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7796_first_8_index ON public.address_usa_tx_7796 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7796_first_9_index ON public.address_usa_tx_7796 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77971_esiid_index ON public.address_usa_tx_77971 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77971_first_1_index ON public.address_usa_tx_77971 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77971_first_2_index ON public.address_usa_tx_77971 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77971_first_3_index ON public.address_usa_tx_77971 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77971_first_4_index ON public.address_usa_tx_77971 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77971_first_5_index ON public.address_usa_tx_77971 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77971_first_6_index ON public.address_usa_tx_77971 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77971_first_7_index ON public.address_usa_tx_77971 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77971_first_8_index ON public.address_usa_tx_77971 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77971_first_9_index ON public.address_usa_tx_77971 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77972_first_1_index ON public.address_usa_tx_77972 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77972_first_2_index ON public.address_usa_tx_77972 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77972_first_3_index ON public.address_usa_tx_77972 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77972_first_4_index ON public.address_usa_tx_77972 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77972_first_5_index ON public.address_usa_tx_77972 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77972_first_6_index ON public.address_usa_tx_77972 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77972_first_7_index ON public.address_usa_tx_77972 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77972_first_8_index ON public.address_usa_tx_77972 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77972_first_9_index ON public.address_usa_tx_77972 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77977_esiid_index ON public.address_usa_tx_77977 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77977_first_1_index ON public.address_usa_tx_77977 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77977_first_2_index ON public.address_usa_tx_77977 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77977_first_3_index ON public.address_usa_tx_77977 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77977_first_4_index ON public.address_usa_tx_77977 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77977_first_5_index ON public.address_usa_tx_77977 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77977_first_6_index ON public.address_usa_tx_77977 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77977_first_7_index ON public.address_usa_tx_77977 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77977_first_8_index ON public.address_usa_tx_77977 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77977_first_9_index ON public.address_usa_tx_77977 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77978_esiid_index ON public.address_usa_tx_77978 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77978_first_1_index ON public.address_usa_tx_77978 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77978_first_2_index ON public.address_usa_tx_77978 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77978_first_3_index ON public.address_usa_tx_77978 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77978_first_4_index ON public.address_usa_tx_77978 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77978_first_5_index ON public.address_usa_tx_77978 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77978_first_6_index ON public.address_usa_tx_77978 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77978_first_7_index ON public.address_usa_tx_77978 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77978_first_8_index ON public.address_usa_tx_77978 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77978_first_9_index ON public.address_usa_tx_77978 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77979_esiid_index ON public.address_usa_tx_77979 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77979_first_1_index ON public.address_usa_tx_77979 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77979_first_2_index ON public.address_usa_tx_77979 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77979_first_3_index ON public.address_usa_tx_77979 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77979_first_4_index ON public.address_usa_tx_77979 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77979_first_5_index ON public.address_usa_tx_77979 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77979_first_6_index ON public.address_usa_tx_77979 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77979_first_7_index ON public.address_usa_tx_77979 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77979_first_8_index ON public.address_usa_tx_77979 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77979_first_9_index ON public.address_usa_tx_77979 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7797_first_1_index ON public.address_usa_tx_7797 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7797_first_2_index ON public.address_usa_tx_7797 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7797_first_3_index ON public.address_usa_tx_7797 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7797_first_4_index ON public.address_usa_tx_7797 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7797_first_5_index ON public.address_usa_tx_7797 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7797_first_6_index ON public.address_usa_tx_7797 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7797_first_7_index ON public.address_usa_tx_7797 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7797_first_8_index ON public.address_usa_tx_7797 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7797_first_9_index ON public.address_usa_tx_7797 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77983_esiid_index ON public.address_usa_tx_77983 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77983_first_1_index ON public.address_usa_tx_77983 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77983_first_2_index ON public.address_usa_tx_77983 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77983_first_3_index ON public.address_usa_tx_77983 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77983_first_4_index ON public.address_usa_tx_77983 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77983_first_5_index ON public.address_usa_tx_77983 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77983_first_6_index ON public.address_usa_tx_77983 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77983_first_7_index ON public.address_usa_tx_77983 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77983_first_8_index ON public.address_usa_tx_77983 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77983_first_9_index ON public.address_usa_tx_77983 USING btree (first_9);


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

CREATE INDEX address_usa_tx_7798_first_1_index ON public.address_usa_tx_7798 USING btree (first_1);


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

CREATE INDEX address_usa_tx_7798_first_2_index ON public.address_usa_tx_7798 USING btree (first_2);


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

CREATE INDEX address_usa_tx_7798_first_3_index ON public.address_usa_tx_7798 USING btree (first_3);


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

CREATE INDEX address_usa_tx_7798_first_4_index ON public.address_usa_tx_7798 USING btree (first_4);


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

CREATE INDEX address_usa_tx_7798_first_5_index ON public.address_usa_tx_7798 USING btree (first_5);


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

CREATE INDEX address_usa_tx_7798_first_6_index ON public.address_usa_tx_7798 USING btree (first_6);


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

CREATE INDEX address_usa_tx_7798_first_7_index ON public.address_usa_tx_7798 USING btree (first_7);


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

CREATE INDEX address_usa_tx_7798_first_8_index ON public.address_usa_tx_7798 USING btree (first_8);


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

CREATE INDEX address_usa_tx_7798_first_9_index ON public.address_usa_tx_7798 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77990_esiid_index ON public.address_usa_tx_77990 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77990_first_1_index ON public.address_usa_tx_77990 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77990_first_2_index ON public.address_usa_tx_77990 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77990_first_3_index ON public.address_usa_tx_77990 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77990_first_4_index ON public.address_usa_tx_77990 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77990_first_5_index ON public.address_usa_tx_77990 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77990_first_6_index ON public.address_usa_tx_77990 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77990_first_7_index ON public.address_usa_tx_77990 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77990_first_8_index ON public.address_usa_tx_77990 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77990_first_9_index ON public.address_usa_tx_77990 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77991_esiid_index ON public.address_usa_tx_77991 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77991_first_1_index ON public.address_usa_tx_77991 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77991_first_2_index ON public.address_usa_tx_77991 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77991_first_3_index ON public.address_usa_tx_77991 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77991_first_4_index ON public.address_usa_tx_77991 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77991_first_5_index ON public.address_usa_tx_77991 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77991_first_6_index ON public.address_usa_tx_77991 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77991_first_7_index ON public.address_usa_tx_77991 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77991_first_8_index ON public.address_usa_tx_77991 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77991_first_9_index ON public.address_usa_tx_77991 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77993_esiid_index ON public.address_usa_tx_77993 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77993_first_1_index ON public.address_usa_tx_77993 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77993_first_2_index ON public.address_usa_tx_77993 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77993_first_3_index ON public.address_usa_tx_77993 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77993_first_4_index ON public.address_usa_tx_77993 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77993_first_5_index ON public.address_usa_tx_77993 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77993_first_6_index ON public.address_usa_tx_77993 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77993_first_7_index ON public.address_usa_tx_77993 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77993_first_8_index ON public.address_usa_tx_77993 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77993_first_9_index ON public.address_usa_tx_77993 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77994_esiid_index ON public.address_usa_tx_77994 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77994_first_1_index ON public.address_usa_tx_77994 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77994_first_2_index ON public.address_usa_tx_77994 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77994_first_3_index ON public.address_usa_tx_77994 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77994_first_4_index ON public.address_usa_tx_77994 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77994_first_5_index ON public.address_usa_tx_77994 USING btree (first_5);


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

CREATE INDEX address_usa_tx_77994_first_6_index ON public.address_usa_tx_77994 USING btree (first_6);


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

CREATE INDEX address_usa_tx_77994_first_7_index ON public.address_usa_tx_77994 USING btree (first_7);


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

CREATE INDEX address_usa_tx_77994_first_8_index ON public.address_usa_tx_77994 USING btree (first_8);


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

CREATE INDEX address_usa_tx_77994_first_9_index ON public.address_usa_tx_77994 USING btree (first_9);


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

CREATE INDEX address_usa_tx_77995_esiid_index ON public.address_usa_tx_77995 USING btree (esiid);


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

CREATE INDEX address_usa_tx_77995_first_1_index ON public.address_usa_tx_77995 USING btree (first_1);


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

CREATE INDEX address_usa_tx_77995_first_2_index ON public.address_usa_tx_77995 USING btree (first_2);


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

CREATE INDEX address_usa_tx_77995_first_3_index ON public.address_usa_tx_77995 USING btree (first_3);


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

CREATE INDEX address_usa_tx_77995_first_4_index ON public.address_usa_tx_77995 USING btree (first_4);


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

CREATE INDEX address_usa_tx_77995_first_5_index ON public.address_usa_tx_77995 USING btree (first_5);


--
-- Name: address_usa_tx_77995_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77995_first_6_index ON public.address_usa_tx_77995 USING btree (first_6);


--
-- Name: address_usa_tx_77995_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77995_first_7_index ON public.address_usa_tx_77995 USING btree (first_7);


--
-- Name: address_usa_tx_77995_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77995_first_8_index ON public.address_usa_tx_77995 USING btree (first_8);


--
-- Name: address_usa_tx_77995_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77995_first_9_index ON public.address_usa_tx_77995 USING btree (first_9);


--
-- Name: address_usa_tx_7799_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_1_index ON public.address_usa_tx_7799 USING btree (first_1);


--
-- Name: address_usa_tx_7799_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_2_index ON public.address_usa_tx_7799 USING btree (first_2);


--
-- Name: address_usa_tx_7799_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_3_index ON public.address_usa_tx_7799 USING btree (first_3);


--
-- Name: address_usa_tx_7799_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_4_index ON public.address_usa_tx_7799 USING btree (first_4);


--
-- Name: address_usa_tx_7799_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_5_index ON public.address_usa_tx_7799 USING btree (first_5);


--
-- Name: address_usa_tx_7799_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_6_index ON public.address_usa_tx_7799 USING btree (first_6);


--
-- Name: address_usa_tx_7799_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_7_index ON public.address_usa_tx_7799 USING btree (first_7);


--
-- Name: address_usa_tx_7799_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_8_index ON public.address_usa_tx_7799 USING btree (first_8);


--
-- Name: address_usa_tx_7799_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7799_first_9_index ON public.address_usa_tx_7799 USING btree (first_9);


--
-- Name: address_usa_tx_779_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_1_index ON public.address_usa_tx_779 USING btree (first_1);


--
-- Name: address_usa_tx_779_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_2_index ON public.address_usa_tx_779 USING btree (first_2);


--
-- Name: address_usa_tx_779_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_3_index ON public.address_usa_tx_779 USING btree (first_3);


--
-- Name: address_usa_tx_779_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_4_index ON public.address_usa_tx_779 USING btree (first_4);


--
-- Name: address_usa_tx_779_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_5_index ON public.address_usa_tx_779 USING btree (first_5);


--
-- Name: address_usa_tx_779_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_6_index ON public.address_usa_tx_779 USING btree (first_6);


--
-- Name: address_usa_tx_779_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_7_index ON public.address_usa_tx_779 USING btree (first_7);


--
-- Name: address_usa_tx_779_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_8_index ON public.address_usa_tx_779 USING btree (first_8);


--
-- Name: address_usa_tx_779_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_779_first_9_index ON public.address_usa_tx_779 USING btree (first_9);


--
-- Name: address_usa_tx_77_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_1_index ON public.address_usa_tx_77 USING btree (first_1);


--
-- Name: address_usa_tx_77_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_2_index ON public.address_usa_tx_77 USING btree (first_2);


--
-- Name: address_usa_tx_77_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_3_index ON public.address_usa_tx_77 USING btree (first_3);


--
-- Name: address_usa_tx_77_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_4_index ON public.address_usa_tx_77 USING btree (first_4);


--
-- Name: address_usa_tx_77_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_5_index ON public.address_usa_tx_77 USING btree (first_5);


--
-- Name: address_usa_tx_77_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_6_index ON public.address_usa_tx_77 USING btree (first_6);


--
-- Name: address_usa_tx_77_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_7_index ON public.address_usa_tx_77 USING btree (first_7);


--
-- Name: address_usa_tx_77_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_8_index ON public.address_usa_tx_77 USING btree (first_8);


--
-- Name: address_usa_tx_77_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_77_first_9_index ON public.address_usa_tx_77 USING btree (first_9);


--
-- Name: address_usa_tx_78001_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_1_index ON public.address_usa_tx_78001 USING btree (first_1);


--
-- Name: address_usa_tx_78001_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_2_index ON public.address_usa_tx_78001 USING btree (first_2);


--
-- Name: address_usa_tx_78001_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_3_index ON public.address_usa_tx_78001 USING btree (first_3);


--
-- Name: address_usa_tx_78001_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_4_index ON public.address_usa_tx_78001 USING btree (first_4);


--
-- Name: address_usa_tx_78001_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_5_index ON public.address_usa_tx_78001 USING btree (first_5);


--
-- Name: address_usa_tx_78001_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_6_index ON public.address_usa_tx_78001 USING btree (first_6);


--
-- Name: address_usa_tx_78001_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_7_index ON public.address_usa_tx_78001 USING btree (first_7);


--
-- Name: address_usa_tx_78001_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_8_index ON public.address_usa_tx_78001 USING btree (first_8);


--
-- Name: address_usa_tx_78001_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78001_first_9_index ON public.address_usa_tx_78001 USING btree (first_9);


--
-- Name: address_usa_tx_78005_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_esiid_index ON public.address_usa_tx_78005 USING btree (esiid);


--
-- Name: address_usa_tx_78005_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_1_index ON public.address_usa_tx_78005 USING btree (first_1);


--
-- Name: address_usa_tx_78005_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_2_index ON public.address_usa_tx_78005 USING btree (first_2);


--
-- Name: address_usa_tx_78005_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_3_index ON public.address_usa_tx_78005 USING btree (first_3);


--
-- Name: address_usa_tx_78005_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_4_index ON public.address_usa_tx_78005 USING btree (first_4);


--
-- Name: address_usa_tx_78005_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_5_index ON public.address_usa_tx_78005 USING btree (first_5);


--
-- Name: address_usa_tx_78005_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_6_index ON public.address_usa_tx_78005 USING btree (first_6);


--
-- Name: address_usa_tx_78005_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_7_index ON public.address_usa_tx_78005 USING btree (first_7);


--
-- Name: address_usa_tx_78005_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_8_index ON public.address_usa_tx_78005 USING btree (first_8);


--
-- Name: address_usa_tx_78005_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78005_first_9_index ON public.address_usa_tx_78005 USING btree (first_9);


--
-- Name: address_usa_tx_7800_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_1_index ON public.address_usa_tx_7800 USING btree (first_1);


--
-- Name: address_usa_tx_7800_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_2_index ON public.address_usa_tx_7800 USING btree (first_2);


--
-- Name: address_usa_tx_7800_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_3_index ON public.address_usa_tx_7800 USING btree (first_3);


--
-- Name: address_usa_tx_7800_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_4_index ON public.address_usa_tx_7800 USING btree (first_4);


--
-- Name: address_usa_tx_7800_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_5_index ON public.address_usa_tx_7800 USING btree (first_5);


--
-- Name: address_usa_tx_7800_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_6_index ON public.address_usa_tx_7800 USING btree (first_6);


--
-- Name: address_usa_tx_7800_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_7_index ON public.address_usa_tx_7800 USING btree (first_7);


--
-- Name: address_usa_tx_7800_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_8_index ON public.address_usa_tx_7800 USING btree (first_8);


--
-- Name: address_usa_tx_7800_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7800_first_9_index ON public.address_usa_tx_7800 USING btree (first_9);


--
-- Name: address_usa_tx_78011_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_esiid_index ON public.address_usa_tx_78011 USING btree (esiid);


--
-- Name: address_usa_tx_78011_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_1_index ON public.address_usa_tx_78011 USING btree (first_1);


--
-- Name: address_usa_tx_78011_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_2_index ON public.address_usa_tx_78011 USING btree (first_2);


--
-- Name: address_usa_tx_78011_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_3_index ON public.address_usa_tx_78011 USING btree (first_3);


--
-- Name: address_usa_tx_78011_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_4_index ON public.address_usa_tx_78011 USING btree (first_4);


--
-- Name: address_usa_tx_78011_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_5_index ON public.address_usa_tx_78011 USING btree (first_5);


--
-- Name: address_usa_tx_78011_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_6_index ON public.address_usa_tx_78011 USING btree (first_6);


--
-- Name: address_usa_tx_78011_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_7_index ON public.address_usa_tx_78011 USING btree (first_7);


--
-- Name: address_usa_tx_78011_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_8_index ON public.address_usa_tx_78011 USING btree (first_8);


--
-- Name: address_usa_tx_78011_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78011_first_9_index ON public.address_usa_tx_78011 USING btree (first_9);


--
-- Name: address_usa_tx_78012_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_esiid_index ON public.address_usa_tx_78012 USING btree (esiid);


--
-- Name: address_usa_tx_78012_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_1_index ON public.address_usa_tx_78012 USING btree (first_1);


--
-- Name: address_usa_tx_78012_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_2_index ON public.address_usa_tx_78012 USING btree (first_2);


--
-- Name: address_usa_tx_78012_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_3_index ON public.address_usa_tx_78012 USING btree (first_3);


--
-- Name: address_usa_tx_78012_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_4_index ON public.address_usa_tx_78012 USING btree (first_4);


--
-- Name: address_usa_tx_78012_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_5_index ON public.address_usa_tx_78012 USING btree (first_5);


--
-- Name: address_usa_tx_78012_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_6_index ON public.address_usa_tx_78012 USING btree (first_6);


--
-- Name: address_usa_tx_78012_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_7_index ON public.address_usa_tx_78012 USING btree (first_7);


--
-- Name: address_usa_tx_78012_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_8_index ON public.address_usa_tx_78012 USING btree (first_8);


--
-- Name: address_usa_tx_78012_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78012_first_9_index ON public.address_usa_tx_78012 USING btree (first_9);


--
-- Name: address_usa_tx_78014_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_esiid_index ON public.address_usa_tx_78014 USING btree (esiid);


--
-- Name: address_usa_tx_78014_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_1_index ON public.address_usa_tx_78014 USING btree (first_1);


--
-- Name: address_usa_tx_78014_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_2_index ON public.address_usa_tx_78014 USING btree (first_2);


--
-- Name: address_usa_tx_78014_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_3_index ON public.address_usa_tx_78014 USING btree (first_3);


--
-- Name: address_usa_tx_78014_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_4_index ON public.address_usa_tx_78014 USING btree (first_4);


--
-- Name: address_usa_tx_78014_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_5_index ON public.address_usa_tx_78014 USING btree (first_5);


--
-- Name: address_usa_tx_78014_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_6_index ON public.address_usa_tx_78014 USING btree (first_6);


--
-- Name: address_usa_tx_78014_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_7_index ON public.address_usa_tx_78014 USING btree (first_7);


--
-- Name: address_usa_tx_78014_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_8_index ON public.address_usa_tx_78014 USING btree (first_8);


--
-- Name: address_usa_tx_78014_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78014_first_9_index ON public.address_usa_tx_78014 USING btree (first_9);


--
-- Name: address_usa_tx_78016_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_esiid_index ON public.address_usa_tx_78016 USING btree (esiid);


--
-- Name: address_usa_tx_78016_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_1_index ON public.address_usa_tx_78016 USING btree (first_1);


--
-- Name: address_usa_tx_78016_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_2_index ON public.address_usa_tx_78016 USING btree (first_2);


--
-- Name: address_usa_tx_78016_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_3_index ON public.address_usa_tx_78016 USING btree (first_3);


--
-- Name: address_usa_tx_78016_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_4_index ON public.address_usa_tx_78016 USING btree (first_4);


--
-- Name: address_usa_tx_78016_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_5_index ON public.address_usa_tx_78016 USING btree (first_5);


--
-- Name: address_usa_tx_78016_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_6_index ON public.address_usa_tx_78016 USING btree (first_6);


--
-- Name: address_usa_tx_78016_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_7_index ON public.address_usa_tx_78016 USING btree (first_7);


--
-- Name: address_usa_tx_78016_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_8_index ON public.address_usa_tx_78016 USING btree (first_8);


--
-- Name: address_usa_tx_78016_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78016_first_9_index ON public.address_usa_tx_78016 USING btree (first_9);


--
-- Name: address_usa_tx_78017_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_esiid_index ON public.address_usa_tx_78017 USING btree (esiid);


--
-- Name: address_usa_tx_78017_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_1_index ON public.address_usa_tx_78017 USING btree (first_1);


--
-- Name: address_usa_tx_78017_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_2_index ON public.address_usa_tx_78017 USING btree (first_2);


--
-- Name: address_usa_tx_78017_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_3_index ON public.address_usa_tx_78017 USING btree (first_3);


--
-- Name: address_usa_tx_78017_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_4_index ON public.address_usa_tx_78017 USING btree (first_4);


--
-- Name: address_usa_tx_78017_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_5_index ON public.address_usa_tx_78017 USING btree (first_5);


--
-- Name: address_usa_tx_78017_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_6_index ON public.address_usa_tx_78017 USING btree (first_6);


--
-- Name: address_usa_tx_78017_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_7_index ON public.address_usa_tx_78017 USING btree (first_7);


--
-- Name: address_usa_tx_78017_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_8_index ON public.address_usa_tx_78017 USING btree (first_8);


--
-- Name: address_usa_tx_78017_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78017_first_9_index ON public.address_usa_tx_78017 USING btree (first_9);


--
-- Name: address_usa_tx_78019_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_esiid_index ON public.address_usa_tx_78019 USING btree (esiid);


--
-- Name: address_usa_tx_78019_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_1_index ON public.address_usa_tx_78019 USING btree (first_1);


--
-- Name: address_usa_tx_78019_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_2_index ON public.address_usa_tx_78019 USING btree (first_2);


--
-- Name: address_usa_tx_78019_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_3_index ON public.address_usa_tx_78019 USING btree (first_3);


--
-- Name: address_usa_tx_78019_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_4_index ON public.address_usa_tx_78019 USING btree (first_4);


--
-- Name: address_usa_tx_78019_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_5_index ON public.address_usa_tx_78019 USING btree (first_5);


--
-- Name: address_usa_tx_78019_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_6_index ON public.address_usa_tx_78019 USING btree (first_6);


--
-- Name: address_usa_tx_78019_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_7_index ON public.address_usa_tx_78019 USING btree (first_7);


--
-- Name: address_usa_tx_78019_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_8_index ON public.address_usa_tx_78019 USING btree (first_8);


--
-- Name: address_usa_tx_78019_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78019_first_9_index ON public.address_usa_tx_78019 USING btree (first_9);


--
-- Name: address_usa_tx_7801_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_1_index ON public.address_usa_tx_7801 USING btree (first_1);


--
-- Name: address_usa_tx_7801_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_2_index ON public.address_usa_tx_7801 USING btree (first_2);


--
-- Name: address_usa_tx_7801_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_3_index ON public.address_usa_tx_7801 USING btree (first_3);


--
-- Name: address_usa_tx_7801_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_4_index ON public.address_usa_tx_7801 USING btree (first_4);


--
-- Name: address_usa_tx_7801_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_5_index ON public.address_usa_tx_7801 USING btree (first_5);


--
-- Name: address_usa_tx_7801_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_6_index ON public.address_usa_tx_7801 USING btree (first_6);


--
-- Name: address_usa_tx_7801_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_7_index ON public.address_usa_tx_7801 USING btree (first_7);


--
-- Name: address_usa_tx_7801_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_8_index ON public.address_usa_tx_7801 USING btree (first_8);


--
-- Name: address_usa_tx_7801_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7801_first_9_index ON public.address_usa_tx_7801 USING btree (first_9);


--
-- Name: address_usa_tx_78022_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_esiid_index ON public.address_usa_tx_78022 USING btree (esiid);


--
-- Name: address_usa_tx_78022_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_1_index ON public.address_usa_tx_78022 USING btree (first_1);


--
-- Name: address_usa_tx_78022_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_2_index ON public.address_usa_tx_78022 USING btree (first_2);


--
-- Name: address_usa_tx_78022_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_3_index ON public.address_usa_tx_78022 USING btree (first_3);


--
-- Name: address_usa_tx_78022_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_4_index ON public.address_usa_tx_78022 USING btree (first_4);


--
-- Name: address_usa_tx_78022_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_5_index ON public.address_usa_tx_78022 USING btree (first_5);


--
-- Name: address_usa_tx_78022_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_6_index ON public.address_usa_tx_78022 USING btree (first_6);


--
-- Name: address_usa_tx_78022_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_7_index ON public.address_usa_tx_78022 USING btree (first_7);


--
-- Name: address_usa_tx_78022_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_8_index ON public.address_usa_tx_78022 USING btree (first_8);


--
-- Name: address_usa_tx_78022_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78022_first_9_index ON public.address_usa_tx_78022 USING btree (first_9);


--
-- Name: address_usa_tx_78026_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_esiid_index ON public.address_usa_tx_78026 USING btree (esiid);


--
-- Name: address_usa_tx_78026_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_1_index ON public.address_usa_tx_78026 USING btree (first_1);


--
-- Name: address_usa_tx_78026_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_2_index ON public.address_usa_tx_78026 USING btree (first_2);


--
-- Name: address_usa_tx_78026_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_3_index ON public.address_usa_tx_78026 USING btree (first_3);


--
-- Name: address_usa_tx_78026_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_4_index ON public.address_usa_tx_78026 USING btree (first_4);


--
-- Name: address_usa_tx_78026_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_5_index ON public.address_usa_tx_78026 USING btree (first_5);


--
-- Name: address_usa_tx_78026_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_6_index ON public.address_usa_tx_78026 USING btree (first_6);


--
-- Name: address_usa_tx_78026_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_7_index ON public.address_usa_tx_78026 USING btree (first_7);


--
-- Name: address_usa_tx_78026_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_8_index ON public.address_usa_tx_78026 USING btree (first_8);


--
-- Name: address_usa_tx_78026_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78026_first_9_index ON public.address_usa_tx_78026 USING btree (first_9);


--
-- Name: address_usa_tx_7802_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_1_index ON public.address_usa_tx_7802 USING btree (first_1);


--
-- Name: address_usa_tx_7802_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_2_index ON public.address_usa_tx_7802 USING btree (first_2);


--
-- Name: address_usa_tx_7802_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_3_index ON public.address_usa_tx_7802 USING btree (first_3);


--
-- Name: address_usa_tx_7802_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_4_index ON public.address_usa_tx_7802 USING btree (first_4);


--
-- Name: address_usa_tx_7802_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_5_index ON public.address_usa_tx_7802 USING btree (first_5);


--
-- Name: address_usa_tx_7802_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_6_index ON public.address_usa_tx_7802 USING btree (first_6);


--
-- Name: address_usa_tx_7802_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_7_index ON public.address_usa_tx_7802 USING btree (first_7);


--
-- Name: address_usa_tx_7802_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_8_index ON public.address_usa_tx_7802 USING btree (first_8);


--
-- Name: address_usa_tx_7802_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7802_first_9_index ON public.address_usa_tx_7802 USING btree (first_9);


--
-- Name: address_usa_tx_78040_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_esiid_index ON public.address_usa_tx_78040 USING btree (esiid);


--
-- Name: address_usa_tx_78040_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_1_index ON public.address_usa_tx_78040 USING btree (first_1);


--
-- Name: address_usa_tx_78040_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_2_index ON public.address_usa_tx_78040 USING btree (first_2);


--
-- Name: address_usa_tx_78040_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_3_index ON public.address_usa_tx_78040 USING btree (first_3);


--
-- Name: address_usa_tx_78040_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_4_index ON public.address_usa_tx_78040 USING btree (first_4);


--
-- Name: address_usa_tx_78040_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_5_index ON public.address_usa_tx_78040 USING btree (first_5);


--
-- Name: address_usa_tx_78040_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_6_index ON public.address_usa_tx_78040 USING btree (first_6);


--
-- Name: address_usa_tx_78040_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_7_index ON public.address_usa_tx_78040 USING btree (first_7);


--
-- Name: address_usa_tx_78040_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_8_index ON public.address_usa_tx_78040 USING btree (first_8);


--
-- Name: address_usa_tx_78040_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78040_first_9_index ON public.address_usa_tx_78040 USING btree (first_9);


--
-- Name: address_usa_tx_78041_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_esiid_index ON public.address_usa_tx_78041 USING btree (esiid);


--
-- Name: address_usa_tx_78041_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_1_index ON public.address_usa_tx_78041 USING btree (first_1);


--
-- Name: address_usa_tx_78041_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_2_index ON public.address_usa_tx_78041 USING btree (first_2);


--
-- Name: address_usa_tx_78041_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_3_index ON public.address_usa_tx_78041 USING btree (first_3);


--
-- Name: address_usa_tx_78041_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_4_index ON public.address_usa_tx_78041 USING btree (first_4);


--
-- Name: address_usa_tx_78041_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_5_index ON public.address_usa_tx_78041 USING btree (first_5);


--
-- Name: address_usa_tx_78041_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_6_index ON public.address_usa_tx_78041 USING btree (first_6);


--
-- Name: address_usa_tx_78041_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_7_index ON public.address_usa_tx_78041 USING btree (first_7);


--
-- Name: address_usa_tx_78041_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_8_index ON public.address_usa_tx_78041 USING btree (first_8);


--
-- Name: address_usa_tx_78041_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78041_first_9_index ON public.address_usa_tx_78041 USING btree (first_9);


--
-- Name: address_usa_tx_78042_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_esiid_index ON public.address_usa_tx_78042 USING btree (esiid);


--
-- Name: address_usa_tx_78042_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_1_index ON public.address_usa_tx_78042 USING btree (first_1);


--
-- Name: address_usa_tx_78042_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_2_index ON public.address_usa_tx_78042 USING btree (first_2);


--
-- Name: address_usa_tx_78042_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_3_index ON public.address_usa_tx_78042 USING btree (first_3);


--
-- Name: address_usa_tx_78042_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_4_index ON public.address_usa_tx_78042 USING btree (first_4);


--
-- Name: address_usa_tx_78042_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_5_index ON public.address_usa_tx_78042 USING btree (first_5);


--
-- Name: address_usa_tx_78042_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_6_index ON public.address_usa_tx_78042 USING btree (first_6);


--
-- Name: address_usa_tx_78042_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_7_index ON public.address_usa_tx_78042 USING btree (first_7);


--
-- Name: address_usa_tx_78042_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_8_index ON public.address_usa_tx_78042 USING btree (first_8);


--
-- Name: address_usa_tx_78042_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78042_first_9_index ON public.address_usa_tx_78042 USING btree (first_9);


--
-- Name: address_usa_tx_78043_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_esiid_index ON public.address_usa_tx_78043 USING btree (esiid);


--
-- Name: address_usa_tx_78043_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_1_index ON public.address_usa_tx_78043 USING btree (first_1);


--
-- Name: address_usa_tx_78043_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_2_index ON public.address_usa_tx_78043 USING btree (first_2);


--
-- Name: address_usa_tx_78043_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_3_index ON public.address_usa_tx_78043 USING btree (first_3);


--
-- Name: address_usa_tx_78043_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_4_index ON public.address_usa_tx_78043 USING btree (first_4);


--
-- Name: address_usa_tx_78043_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_5_index ON public.address_usa_tx_78043 USING btree (first_5);


--
-- Name: address_usa_tx_78043_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_6_index ON public.address_usa_tx_78043 USING btree (first_6);


--
-- Name: address_usa_tx_78043_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_7_index ON public.address_usa_tx_78043 USING btree (first_7);


--
-- Name: address_usa_tx_78043_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_8_index ON public.address_usa_tx_78043 USING btree (first_8);


--
-- Name: address_usa_tx_78043_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78043_first_9_index ON public.address_usa_tx_78043 USING btree (first_9);


--
-- Name: address_usa_tx_78045_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_esiid_index ON public.address_usa_tx_78045 USING btree (esiid);


--
-- Name: address_usa_tx_78045_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_1_index ON public.address_usa_tx_78045 USING btree (first_1);


--
-- Name: address_usa_tx_78045_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_2_index ON public.address_usa_tx_78045 USING btree (first_2);


--
-- Name: address_usa_tx_78045_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_3_index ON public.address_usa_tx_78045 USING btree (first_3);


--
-- Name: address_usa_tx_78045_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_4_index ON public.address_usa_tx_78045 USING btree (first_4);


--
-- Name: address_usa_tx_78045_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_5_index ON public.address_usa_tx_78045 USING btree (first_5);


--
-- Name: address_usa_tx_78045_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_6_index ON public.address_usa_tx_78045 USING btree (first_6);


--
-- Name: address_usa_tx_78045_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_7_index ON public.address_usa_tx_78045 USING btree (first_7);


--
-- Name: address_usa_tx_78045_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_8_index ON public.address_usa_tx_78045 USING btree (first_8);


--
-- Name: address_usa_tx_78045_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78045_first_9_index ON public.address_usa_tx_78045 USING btree (first_9);


--
-- Name: address_usa_tx_78046_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_esiid_index ON public.address_usa_tx_78046 USING btree (esiid);


--
-- Name: address_usa_tx_78046_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_1_index ON public.address_usa_tx_78046 USING btree (first_1);


--
-- Name: address_usa_tx_78046_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_2_index ON public.address_usa_tx_78046 USING btree (first_2);


--
-- Name: address_usa_tx_78046_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_3_index ON public.address_usa_tx_78046 USING btree (first_3);


--
-- Name: address_usa_tx_78046_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_4_index ON public.address_usa_tx_78046 USING btree (first_4);


--
-- Name: address_usa_tx_78046_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_5_index ON public.address_usa_tx_78046 USING btree (first_5);


--
-- Name: address_usa_tx_78046_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_6_index ON public.address_usa_tx_78046 USING btree (first_6);


--
-- Name: address_usa_tx_78046_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_7_index ON public.address_usa_tx_78046 USING btree (first_7);


--
-- Name: address_usa_tx_78046_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_8_index ON public.address_usa_tx_78046 USING btree (first_8);


--
-- Name: address_usa_tx_78046_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78046_first_9_index ON public.address_usa_tx_78046 USING btree (first_9);


--
-- Name: address_usa_tx_7804_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_1_index ON public.address_usa_tx_7804 USING btree (first_1);


--
-- Name: address_usa_tx_7804_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_2_index ON public.address_usa_tx_7804 USING btree (first_2);


--
-- Name: address_usa_tx_7804_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_3_index ON public.address_usa_tx_7804 USING btree (first_3);


--
-- Name: address_usa_tx_7804_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_4_index ON public.address_usa_tx_7804 USING btree (first_4);


--
-- Name: address_usa_tx_7804_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_5_index ON public.address_usa_tx_7804 USING btree (first_5);


--
-- Name: address_usa_tx_7804_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_6_index ON public.address_usa_tx_7804 USING btree (first_6);


--
-- Name: address_usa_tx_7804_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_7_index ON public.address_usa_tx_7804 USING btree (first_7);


--
-- Name: address_usa_tx_7804_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_8_index ON public.address_usa_tx_7804 USING btree (first_8);


--
-- Name: address_usa_tx_7804_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7804_first_9_index ON public.address_usa_tx_7804 USING btree (first_9);


--
-- Name: address_usa_tx_78050_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_esiid_index ON public.address_usa_tx_78050 USING btree (esiid);


--
-- Name: address_usa_tx_78050_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_1_index ON public.address_usa_tx_78050 USING btree (first_1);


--
-- Name: address_usa_tx_78050_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_2_index ON public.address_usa_tx_78050 USING btree (first_2);


--
-- Name: address_usa_tx_78050_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_3_index ON public.address_usa_tx_78050 USING btree (first_3);


--
-- Name: address_usa_tx_78050_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_4_index ON public.address_usa_tx_78050 USING btree (first_4);


--
-- Name: address_usa_tx_78050_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_5_index ON public.address_usa_tx_78050 USING btree (first_5);


--
-- Name: address_usa_tx_78050_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_6_index ON public.address_usa_tx_78050 USING btree (first_6);


--
-- Name: address_usa_tx_78050_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_7_index ON public.address_usa_tx_78050 USING btree (first_7);


--
-- Name: address_usa_tx_78050_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_8_index ON public.address_usa_tx_78050 USING btree (first_8);


--
-- Name: address_usa_tx_78050_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78050_first_9_index ON public.address_usa_tx_78050 USING btree (first_9);


--
-- Name: address_usa_tx_78052_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_esiid_index ON public.address_usa_tx_78052 USING btree (esiid);


--
-- Name: address_usa_tx_78052_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_1_index ON public.address_usa_tx_78052 USING btree (first_1);


--
-- Name: address_usa_tx_78052_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_2_index ON public.address_usa_tx_78052 USING btree (first_2);


--
-- Name: address_usa_tx_78052_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_3_index ON public.address_usa_tx_78052 USING btree (first_3);


--
-- Name: address_usa_tx_78052_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_4_index ON public.address_usa_tx_78052 USING btree (first_4);


--
-- Name: address_usa_tx_78052_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_5_index ON public.address_usa_tx_78052 USING btree (first_5);


--
-- Name: address_usa_tx_78052_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_6_index ON public.address_usa_tx_78052 USING btree (first_6);


--
-- Name: address_usa_tx_78052_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_7_index ON public.address_usa_tx_78052 USING btree (first_7);


--
-- Name: address_usa_tx_78052_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_8_index ON public.address_usa_tx_78052 USING btree (first_8);


--
-- Name: address_usa_tx_78052_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78052_first_9_index ON public.address_usa_tx_78052 USING btree (first_9);


--
-- Name: address_usa_tx_78057_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_esiid_index ON public.address_usa_tx_78057 USING btree (esiid);


--
-- Name: address_usa_tx_78057_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_1_index ON public.address_usa_tx_78057 USING btree (first_1);


--
-- Name: address_usa_tx_78057_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_2_index ON public.address_usa_tx_78057 USING btree (first_2);


--
-- Name: address_usa_tx_78057_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_3_index ON public.address_usa_tx_78057 USING btree (first_3);


--
-- Name: address_usa_tx_78057_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_4_index ON public.address_usa_tx_78057 USING btree (first_4);


--
-- Name: address_usa_tx_78057_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_5_index ON public.address_usa_tx_78057 USING btree (first_5);


--
-- Name: address_usa_tx_78057_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_6_index ON public.address_usa_tx_78057 USING btree (first_6);


--
-- Name: address_usa_tx_78057_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_7_index ON public.address_usa_tx_78057 USING btree (first_7);


--
-- Name: address_usa_tx_78057_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_8_index ON public.address_usa_tx_78057 USING btree (first_8);


--
-- Name: address_usa_tx_78057_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78057_first_9_index ON public.address_usa_tx_78057 USING btree (first_9);


--
-- Name: address_usa_tx_78059_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_esiid_index ON public.address_usa_tx_78059 USING btree (esiid);


--
-- Name: address_usa_tx_78059_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_1_index ON public.address_usa_tx_78059 USING btree (first_1);


--
-- Name: address_usa_tx_78059_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_2_index ON public.address_usa_tx_78059 USING btree (first_2);


--
-- Name: address_usa_tx_78059_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_3_index ON public.address_usa_tx_78059 USING btree (first_3);


--
-- Name: address_usa_tx_78059_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_4_index ON public.address_usa_tx_78059 USING btree (first_4);


--
-- Name: address_usa_tx_78059_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_5_index ON public.address_usa_tx_78059 USING btree (first_5);


--
-- Name: address_usa_tx_78059_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_6_index ON public.address_usa_tx_78059 USING btree (first_6);


--
-- Name: address_usa_tx_78059_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_7_index ON public.address_usa_tx_78059 USING btree (first_7);


--
-- Name: address_usa_tx_78059_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_8_index ON public.address_usa_tx_78059 USING btree (first_8);


--
-- Name: address_usa_tx_78059_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78059_first_9_index ON public.address_usa_tx_78059 USING btree (first_9);


--
-- Name: address_usa_tx_7805_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_1_index ON public.address_usa_tx_7805 USING btree (first_1);


--
-- Name: address_usa_tx_7805_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_2_index ON public.address_usa_tx_7805 USING btree (first_2);


--
-- Name: address_usa_tx_7805_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_3_index ON public.address_usa_tx_7805 USING btree (first_3);


--
-- Name: address_usa_tx_7805_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_4_index ON public.address_usa_tx_7805 USING btree (first_4);


--
-- Name: address_usa_tx_7805_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_5_index ON public.address_usa_tx_7805 USING btree (first_5);


--
-- Name: address_usa_tx_7805_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_6_index ON public.address_usa_tx_7805 USING btree (first_6);


--
-- Name: address_usa_tx_7805_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_7_index ON public.address_usa_tx_7805 USING btree (first_7);


--
-- Name: address_usa_tx_7805_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_8_index ON public.address_usa_tx_7805 USING btree (first_8);


--
-- Name: address_usa_tx_7805_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7805_first_9_index ON public.address_usa_tx_7805 USING btree (first_9);


--
-- Name: address_usa_tx_78060_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_esiid_index ON public.address_usa_tx_78060 USING btree (esiid);


--
-- Name: address_usa_tx_78060_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_1_index ON public.address_usa_tx_78060 USING btree (first_1);


--
-- Name: address_usa_tx_78060_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_2_index ON public.address_usa_tx_78060 USING btree (first_2);


--
-- Name: address_usa_tx_78060_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_3_index ON public.address_usa_tx_78060 USING btree (first_3);


--
-- Name: address_usa_tx_78060_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_4_index ON public.address_usa_tx_78060 USING btree (first_4);


--
-- Name: address_usa_tx_78060_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_5_index ON public.address_usa_tx_78060 USING btree (first_5);


--
-- Name: address_usa_tx_78060_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_6_index ON public.address_usa_tx_78060 USING btree (first_6);


--
-- Name: address_usa_tx_78060_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_7_index ON public.address_usa_tx_78060 USING btree (first_7);


--
-- Name: address_usa_tx_78060_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_8_index ON public.address_usa_tx_78060 USING btree (first_8);


--
-- Name: address_usa_tx_78060_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78060_first_9_index ON public.address_usa_tx_78060 USING btree (first_9);


--
-- Name: address_usa_tx_78061_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_esiid_index ON public.address_usa_tx_78061 USING btree (esiid);


--
-- Name: address_usa_tx_78061_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_1_index ON public.address_usa_tx_78061 USING btree (first_1);


--
-- Name: address_usa_tx_78061_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_2_index ON public.address_usa_tx_78061 USING btree (first_2);


--
-- Name: address_usa_tx_78061_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_3_index ON public.address_usa_tx_78061 USING btree (first_3);


--
-- Name: address_usa_tx_78061_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_4_index ON public.address_usa_tx_78061 USING btree (first_4);


--
-- Name: address_usa_tx_78061_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_5_index ON public.address_usa_tx_78061 USING btree (first_5);


--
-- Name: address_usa_tx_78061_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_6_index ON public.address_usa_tx_78061 USING btree (first_6);


--
-- Name: address_usa_tx_78061_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_7_index ON public.address_usa_tx_78061 USING btree (first_7);


--
-- Name: address_usa_tx_78061_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_8_index ON public.address_usa_tx_78061 USING btree (first_8);


--
-- Name: address_usa_tx_78061_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78061_first_9_index ON public.address_usa_tx_78061 USING btree (first_9);


--
-- Name: address_usa_tx_78064_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_esiid_index ON public.address_usa_tx_78064 USING btree (esiid);


--
-- Name: address_usa_tx_78064_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_1_index ON public.address_usa_tx_78064 USING btree (first_1);


--
-- Name: address_usa_tx_78064_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_2_index ON public.address_usa_tx_78064 USING btree (first_2);


--
-- Name: address_usa_tx_78064_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_3_index ON public.address_usa_tx_78064 USING btree (first_3);


--
-- Name: address_usa_tx_78064_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_4_index ON public.address_usa_tx_78064 USING btree (first_4);


--
-- Name: address_usa_tx_78064_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_5_index ON public.address_usa_tx_78064 USING btree (first_5);


--
-- Name: address_usa_tx_78064_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_6_index ON public.address_usa_tx_78064 USING btree (first_6);


--
-- Name: address_usa_tx_78064_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_7_index ON public.address_usa_tx_78064 USING btree (first_7);


--
-- Name: address_usa_tx_78064_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_8_index ON public.address_usa_tx_78064 USING btree (first_8);


--
-- Name: address_usa_tx_78064_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78064_first_9_index ON public.address_usa_tx_78064 USING btree (first_9);


--
-- Name: address_usa_tx_78065_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_esiid_index ON public.address_usa_tx_78065 USING btree (esiid);


--
-- Name: address_usa_tx_78065_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_1_index ON public.address_usa_tx_78065 USING btree (first_1);


--
-- Name: address_usa_tx_78065_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_2_index ON public.address_usa_tx_78065 USING btree (first_2);


--
-- Name: address_usa_tx_78065_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_3_index ON public.address_usa_tx_78065 USING btree (first_3);


--
-- Name: address_usa_tx_78065_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_4_index ON public.address_usa_tx_78065 USING btree (first_4);


--
-- Name: address_usa_tx_78065_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_5_index ON public.address_usa_tx_78065 USING btree (first_5);


--
-- Name: address_usa_tx_78065_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_6_index ON public.address_usa_tx_78065 USING btree (first_6);


--
-- Name: address_usa_tx_78065_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_7_index ON public.address_usa_tx_78065 USING btree (first_7);


--
-- Name: address_usa_tx_78065_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_8_index ON public.address_usa_tx_78065 USING btree (first_8);


--
-- Name: address_usa_tx_78065_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78065_first_9_index ON public.address_usa_tx_78065 USING btree (first_9);


--
-- Name: address_usa_tx_78067_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_esiid_index ON public.address_usa_tx_78067 USING btree (esiid);


--
-- Name: address_usa_tx_78067_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_1_index ON public.address_usa_tx_78067 USING btree (first_1);


--
-- Name: address_usa_tx_78067_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_2_index ON public.address_usa_tx_78067 USING btree (first_2);


--
-- Name: address_usa_tx_78067_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_3_index ON public.address_usa_tx_78067 USING btree (first_3);


--
-- Name: address_usa_tx_78067_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_4_index ON public.address_usa_tx_78067 USING btree (first_4);


--
-- Name: address_usa_tx_78067_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_5_index ON public.address_usa_tx_78067 USING btree (first_5);


--
-- Name: address_usa_tx_78067_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_6_index ON public.address_usa_tx_78067 USING btree (first_6);


--
-- Name: address_usa_tx_78067_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_7_index ON public.address_usa_tx_78067 USING btree (first_7);


--
-- Name: address_usa_tx_78067_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_8_index ON public.address_usa_tx_78067 USING btree (first_8);


--
-- Name: address_usa_tx_78067_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78067_first_9_index ON public.address_usa_tx_78067 USING btree (first_9);


--
-- Name: address_usa_tx_7806_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_1_index ON public.address_usa_tx_7806 USING btree (first_1);


--
-- Name: address_usa_tx_7806_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_2_index ON public.address_usa_tx_7806 USING btree (first_2);


--
-- Name: address_usa_tx_7806_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_3_index ON public.address_usa_tx_7806 USING btree (first_3);


--
-- Name: address_usa_tx_7806_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_4_index ON public.address_usa_tx_7806 USING btree (first_4);


--
-- Name: address_usa_tx_7806_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_5_index ON public.address_usa_tx_7806 USING btree (first_5);


--
-- Name: address_usa_tx_7806_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_6_index ON public.address_usa_tx_7806 USING btree (first_6);


--
-- Name: address_usa_tx_7806_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_7_index ON public.address_usa_tx_7806 USING btree (first_7);


--
-- Name: address_usa_tx_7806_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_8_index ON public.address_usa_tx_7806 USING btree (first_8);


--
-- Name: address_usa_tx_7806_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7806_first_9_index ON public.address_usa_tx_7806 USING btree (first_9);


--
-- Name: address_usa_tx_78070_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_1_index ON public.address_usa_tx_78070 USING btree (first_1);


--
-- Name: address_usa_tx_78070_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_2_index ON public.address_usa_tx_78070 USING btree (first_2);


--
-- Name: address_usa_tx_78070_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_3_index ON public.address_usa_tx_78070 USING btree (first_3);


--
-- Name: address_usa_tx_78070_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_4_index ON public.address_usa_tx_78070 USING btree (first_4);


--
-- Name: address_usa_tx_78070_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_5_index ON public.address_usa_tx_78070 USING btree (first_5);


--
-- Name: address_usa_tx_78070_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_6_index ON public.address_usa_tx_78070 USING btree (first_6);


--
-- Name: address_usa_tx_78070_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_7_index ON public.address_usa_tx_78070 USING btree (first_7);


--
-- Name: address_usa_tx_78070_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_8_index ON public.address_usa_tx_78070 USING btree (first_8);


--
-- Name: address_usa_tx_78070_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78070_first_9_index ON public.address_usa_tx_78070 USING btree (first_9);


--
-- Name: address_usa_tx_78071_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_esiid_index ON public.address_usa_tx_78071 USING btree (esiid);


--
-- Name: address_usa_tx_78071_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_1_index ON public.address_usa_tx_78071 USING btree (first_1);


--
-- Name: address_usa_tx_78071_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_2_index ON public.address_usa_tx_78071 USING btree (first_2);


--
-- Name: address_usa_tx_78071_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_3_index ON public.address_usa_tx_78071 USING btree (first_3);


--
-- Name: address_usa_tx_78071_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_4_index ON public.address_usa_tx_78071 USING btree (first_4);


--
-- Name: address_usa_tx_78071_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_5_index ON public.address_usa_tx_78071 USING btree (first_5);


--
-- Name: address_usa_tx_78071_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_6_index ON public.address_usa_tx_78071 USING btree (first_6);


--
-- Name: address_usa_tx_78071_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_7_index ON public.address_usa_tx_78071 USING btree (first_7);


--
-- Name: address_usa_tx_78071_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_8_index ON public.address_usa_tx_78071 USING btree (first_8);


--
-- Name: address_usa_tx_78071_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78071_first_9_index ON public.address_usa_tx_78071 USING btree (first_9);


--
-- Name: address_usa_tx_78072_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_esiid_index ON public.address_usa_tx_78072 USING btree (esiid);


--
-- Name: address_usa_tx_78072_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_1_index ON public.address_usa_tx_78072 USING btree (first_1);


--
-- Name: address_usa_tx_78072_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_2_index ON public.address_usa_tx_78072 USING btree (first_2);


--
-- Name: address_usa_tx_78072_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_3_index ON public.address_usa_tx_78072 USING btree (first_3);


--
-- Name: address_usa_tx_78072_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_4_index ON public.address_usa_tx_78072 USING btree (first_4);


--
-- Name: address_usa_tx_78072_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_5_index ON public.address_usa_tx_78072 USING btree (first_5);


--
-- Name: address_usa_tx_78072_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_6_index ON public.address_usa_tx_78072 USING btree (first_6);


--
-- Name: address_usa_tx_78072_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_7_index ON public.address_usa_tx_78072 USING btree (first_7);


--
-- Name: address_usa_tx_78072_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_8_index ON public.address_usa_tx_78072 USING btree (first_8);


--
-- Name: address_usa_tx_78072_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78072_first_9_index ON public.address_usa_tx_78072 USING btree (first_9);


--
-- Name: address_usa_tx_78076_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_esiid_index ON public.address_usa_tx_78076 USING btree (esiid);


--
-- Name: address_usa_tx_78076_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_1_index ON public.address_usa_tx_78076 USING btree (first_1);


--
-- Name: address_usa_tx_78076_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_2_index ON public.address_usa_tx_78076 USING btree (first_2);


--
-- Name: address_usa_tx_78076_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_3_index ON public.address_usa_tx_78076 USING btree (first_3);


--
-- Name: address_usa_tx_78076_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_4_index ON public.address_usa_tx_78076 USING btree (first_4);


--
-- Name: address_usa_tx_78076_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_5_index ON public.address_usa_tx_78076 USING btree (first_5);


--
-- Name: address_usa_tx_78076_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_6_index ON public.address_usa_tx_78076 USING btree (first_6);


--
-- Name: address_usa_tx_78076_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_7_index ON public.address_usa_tx_78076 USING btree (first_7);


--
-- Name: address_usa_tx_78076_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_8_index ON public.address_usa_tx_78076 USING btree (first_8);


--
-- Name: address_usa_tx_78076_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78076_first_9_index ON public.address_usa_tx_78076 USING btree (first_9);


--
-- Name: address_usa_tx_7807_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_1_index ON public.address_usa_tx_7807 USING btree (first_1);


--
-- Name: address_usa_tx_7807_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_2_index ON public.address_usa_tx_7807 USING btree (first_2);


--
-- Name: address_usa_tx_7807_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_3_index ON public.address_usa_tx_7807 USING btree (first_3);


--
-- Name: address_usa_tx_7807_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_4_index ON public.address_usa_tx_7807 USING btree (first_4);


--
-- Name: address_usa_tx_7807_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_5_index ON public.address_usa_tx_7807 USING btree (first_5);


--
-- Name: address_usa_tx_7807_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_6_index ON public.address_usa_tx_7807 USING btree (first_6);


--
-- Name: address_usa_tx_7807_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_7_index ON public.address_usa_tx_7807 USING btree (first_7);


--
-- Name: address_usa_tx_7807_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_8_index ON public.address_usa_tx_7807 USING btree (first_8);


--
-- Name: address_usa_tx_7807_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7807_first_9_index ON public.address_usa_tx_7807 USING btree (first_9);


--
-- Name: address_usa_tx_780_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_1_index ON public.address_usa_tx_780 USING btree (first_1);


--
-- Name: address_usa_tx_780_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_2_index ON public.address_usa_tx_780 USING btree (first_2);


--
-- Name: address_usa_tx_780_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_3_index ON public.address_usa_tx_780 USING btree (first_3);


--
-- Name: address_usa_tx_780_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_4_index ON public.address_usa_tx_780 USING btree (first_4);


--
-- Name: address_usa_tx_780_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_5_index ON public.address_usa_tx_780 USING btree (first_5);


--
-- Name: address_usa_tx_780_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_6_index ON public.address_usa_tx_780 USING btree (first_6);


--
-- Name: address_usa_tx_780_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_7_index ON public.address_usa_tx_780 USING btree (first_7);


--
-- Name: address_usa_tx_780_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_8_index ON public.address_usa_tx_780 USING btree (first_8);


--
-- Name: address_usa_tx_780_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_780_first_9_index ON public.address_usa_tx_780 USING btree (first_9);


--
-- Name: address_usa_tx_78102_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_esiid_index ON public.address_usa_tx_78102 USING btree (esiid);


--
-- Name: address_usa_tx_78102_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_1_index ON public.address_usa_tx_78102 USING btree (first_1);


--
-- Name: address_usa_tx_78102_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_2_index ON public.address_usa_tx_78102 USING btree (first_2);


--
-- Name: address_usa_tx_78102_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_3_index ON public.address_usa_tx_78102 USING btree (first_3);


--
-- Name: address_usa_tx_78102_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_4_index ON public.address_usa_tx_78102 USING btree (first_4);


--
-- Name: address_usa_tx_78102_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_5_index ON public.address_usa_tx_78102 USING btree (first_5);


--
-- Name: address_usa_tx_78102_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_6_index ON public.address_usa_tx_78102 USING btree (first_6);


--
-- Name: address_usa_tx_78102_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_7_index ON public.address_usa_tx_78102 USING btree (first_7);


--
-- Name: address_usa_tx_78102_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_8_index ON public.address_usa_tx_78102 USING btree (first_8);


--
-- Name: address_usa_tx_78102_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78102_first_9_index ON public.address_usa_tx_78102 USING btree (first_9);


--
-- Name: address_usa_tx_78104_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_esiid_index ON public.address_usa_tx_78104 USING btree (esiid);


--
-- Name: address_usa_tx_78104_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_1_index ON public.address_usa_tx_78104 USING btree (first_1);


--
-- Name: address_usa_tx_78104_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_2_index ON public.address_usa_tx_78104 USING btree (first_2);


--
-- Name: address_usa_tx_78104_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_3_index ON public.address_usa_tx_78104 USING btree (first_3);


--
-- Name: address_usa_tx_78104_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_4_index ON public.address_usa_tx_78104 USING btree (first_4);


--
-- Name: address_usa_tx_78104_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_5_index ON public.address_usa_tx_78104 USING btree (first_5);


--
-- Name: address_usa_tx_78104_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_6_index ON public.address_usa_tx_78104 USING btree (first_6);


--
-- Name: address_usa_tx_78104_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_7_index ON public.address_usa_tx_78104 USING btree (first_7);


--
-- Name: address_usa_tx_78104_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_8_index ON public.address_usa_tx_78104 USING btree (first_8);


--
-- Name: address_usa_tx_78104_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78104_first_9_index ON public.address_usa_tx_78104 USING btree (first_9);


--
-- Name: address_usa_tx_78107_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_esiid_index ON public.address_usa_tx_78107 USING btree (esiid);


--
-- Name: address_usa_tx_78107_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_1_index ON public.address_usa_tx_78107 USING btree (first_1);


--
-- Name: address_usa_tx_78107_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_2_index ON public.address_usa_tx_78107 USING btree (first_2);


--
-- Name: address_usa_tx_78107_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_3_index ON public.address_usa_tx_78107 USING btree (first_3);


--
-- Name: address_usa_tx_78107_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_4_index ON public.address_usa_tx_78107 USING btree (first_4);


--
-- Name: address_usa_tx_78107_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_5_index ON public.address_usa_tx_78107 USING btree (first_5);


--
-- Name: address_usa_tx_78107_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_6_index ON public.address_usa_tx_78107 USING btree (first_6);


--
-- Name: address_usa_tx_78107_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_7_index ON public.address_usa_tx_78107 USING btree (first_7);


--
-- Name: address_usa_tx_78107_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_8_index ON public.address_usa_tx_78107 USING btree (first_8);


--
-- Name: address_usa_tx_78107_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78107_first_9_index ON public.address_usa_tx_78107 USING btree (first_9);


--
-- Name: address_usa_tx_7810_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_1_index ON public.address_usa_tx_7810 USING btree (first_1);


--
-- Name: address_usa_tx_7810_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_2_index ON public.address_usa_tx_7810 USING btree (first_2);


--
-- Name: address_usa_tx_7810_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_3_index ON public.address_usa_tx_7810 USING btree (first_3);


--
-- Name: address_usa_tx_7810_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_4_index ON public.address_usa_tx_7810 USING btree (first_4);


--
-- Name: address_usa_tx_7810_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_5_index ON public.address_usa_tx_7810 USING btree (first_5);


--
-- Name: address_usa_tx_7810_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_6_index ON public.address_usa_tx_7810 USING btree (first_6);


--
-- Name: address_usa_tx_7810_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_7_index ON public.address_usa_tx_7810 USING btree (first_7);


--
-- Name: address_usa_tx_7810_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_8_index ON public.address_usa_tx_7810 USING btree (first_8);


--
-- Name: address_usa_tx_7810_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7810_first_9_index ON public.address_usa_tx_7810 USING btree (first_9);


--
-- Name: address_usa_tx_78116_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_esiid_index ON public.address_usa_tx_78116 USING btree (esiid);


--
-- Name: address_usa_tx_78116_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_1_index ON public.address_usa_tx_78116 USING btree (first_1);


--
-- Name: address_usa_tx_78116_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_2_index ON public.address_usa_tx_78116 USING btree (first_2);


--
-- Name: address_usa_tx_78116_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_3_index ON public.address_usa_tx_78116 USING btree (first_3);


--
-- Name: address_usa_tx_78116_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_4_index ON public.address_usa_tx_78116 USING btree (first_4);


--
-- Name: address_usa_tx_78116_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_5_index ON public.address_usa_tx_78116 USING btree (first_5);


--
-- Name: address_usa_tx_78116_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_6_index ON public.address_usa_tx_78116 USING btree (first_6);


--
-- Name: address_usa_tx_78116_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_7_index ON public.address_usa_tx_78116 USING btree (first_7);


--
-- Name: address_usa_tx_78116_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_8_index ON public.address_usa_tx_78116 USING btree (first_8);


--
-- Name: address_usa_tx_78116_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78116_first_9_index ON public.address_usa_tx_78116 USING btree (first_9);


--
-- Name: address_usa_tx_78118_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_esiid_index ON public.address_usa_tx_78118 USING btree (esiid);


--
-- Name: address_usa_tx_78118_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_1_index ON public.address_usa_tx_78118 USING btree (first_1);


--
-- Name: address_usa_tx_78118_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_2_index ON public.address_usa_tx_78118 USING btree (first_2);


--
-- Name: address_usa_tx_78118_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_3_index ON public.address_usa_tx_78118 USING btree (first_3);


--
-- Name: address_usa_tx_78118_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_4_index ON public.address_usa_tx_78118 USING btree (first_4);


--
-- Name: address_usa_tx_78118_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_5_index ON public.address_usa_tx_78118 USING btree (first_5);


--
-- Name: address_usa_tx_78118_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_6_index ON public.address_usa_tx_78118 USING btree (first_6);


--
-- Name: address_usa_tx_78118_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_7_index ON public.address_usa_tx_78118 USING btree (first_7);


--
-- Name: address_usa_tx_78118_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_8_index ON public.address_usa_tx_78118 USING btree (first_8);


--
-- Name: address_usa_tx_78118_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78118_first_9_index ON public.address_usa_tx_78118 USING btree (first_9);


--
-- Name: address_usa_tx_78119_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_esiid_index ON public.address_usa_tx_78119 USING btree (esiid);


--
-- Name: address_usa_tx_78119_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_1_index ON public.address_usa_tx_78119 USING btree (first_1);


--
-- Name: address_usa_tx_78119_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_2_index ON public.address_usa_tx_78119 USING btree (first_2);


--
-- Name: address_usa_tx_78119_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_3_index ON public.address_usa_tx_78119 USING btree (first_3);


--
-- Name: address_usa_tx_78119_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_4_index ON public.address_usa_tx_78119 USING btree (first_4);


--
-- Name: address_usa_tx_78119_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_5_index ON public.address_usa_tx_78119 USING btree (first_5);


--
-- Name: address_usa_tx_78119_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_6_index ON public.address_usa_tx_78119 USING btree (first_6);


--
-- Name: address_usa_tx_78119_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_7_index ON public.address_usa_tx_78119 USING btree (first_7);


--
-- Name: address_usa_tx_78119_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_8_index ON public.address_usa_tx_78119 USING btree (first_8);


--
-- Name: address_usa_tx_78119_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78119_first_9_index ON public.address_usa_tx_78119 USING btree (first_9);


--
-- Name: address_usa_tx_7811_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_1_index ON public.address_usa_tx_7811 USING btree (first_1);


--
-- Name: address_usa_tx_7811_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_2_index ON public.address_usa_tx_7811 USING btree (first_2);


--
-- Name: address_usa_tx_7811_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_3_index ON public.address_usa_tx_7811 USING btree (first_3);


--
-- Name: address_usa_tx_7811_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_4_index ON public.address_usa_tx_7811 USING btree (first_4);


--
-- Name: address_usa_tx_7811_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_5_index ON public.address_usa_tx_7811 USING btree (first_5);


--
-- Name: address_usa_tx_7811_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_6_index ON public.address_usa_tx_7811 USING btree (first_6);


--
-- Name: address_usa_tx_7811_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_7_index ON public.address_usa_tx_7811 USING btree (first_7);


--
-- Name: address_usa_tx_7811_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_8_index ON public.address_usa_tx_7811 USING btree (first_8);


--
-- Name: address_usa_tx_7811_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7811_first_9_index ON public.address_usa_tx_7811 USING btree (first_9);


--
-- Name: address_usa_tx_78122_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_esiid_index ON public.address_usa_tx_78122 USING btree (esiid);


--
-- Name: address_usa_tx_78122_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_1_index ON public.address_usa_tx_78122 USING btree (first_1);


--
-- Name: address_usa_tx_78122_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_2_index ON public.address_usa_tx_78122 USING btree (first_2);


--
-- Name: address_usa_tx_78122_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_3_index ON public.address_usa_tx_78122 USING btree (first_3);


--
-- Name: address_usa_tx_78122_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_4_index ON public.address_usa_tx_78122 USING btree (first_4);


--
-- Name: address_usa_tx_78122_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_5_index ON public.address_usa_tx_78122 USING btree (first_5);


--
-- Name: address_usa_tx_78122_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_6_index ON public.address_usa_tx_78122 USING btree (first_6);


--
-- Name: address_usa_tx_78122_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_7_index ON public.address_usa_tx_78122 USING btree (first_7);


--
-- Name: address_usa_tx_78122_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_8_index ON public.address_usa_tx_78122 USING btree (first_8);


--
-- Name: address_usa_tx_78122_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78122_first_9_index ON public.address_usa_tx_78122 USING btree (first_9);


--
-- Name: address_usa_tx_7812_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_1_index ON public.address_usa_tx_7812 USING btree (first_1);


--
-- Name: address_usa_tx_7812_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_2_index ON public.address_usa_tx_7812 USING btree (first_2);


--
-- Name: address_usa_tx_7812_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_3_index ON public.address_usa_tx_7812 USING btree (first_3);


--
-- Name: address_usa_tx_7812_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_4_index ON public.address_usa_tx_7812 USING btree (first_4);


--
-- Name: address_usa_tx_7812_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_5_index ON public.address_usa_tx_7812 USING btree (first_5);


--
-- Name: address_usa_tx_7812_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_6_index ON public.address_usa_tx_7812 USING btree (first_6);


--
-- Name: address_usa_tx_7812_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_7_index ON public.address_usa_tx_7812 USING btree (first_7);


--
-- Name: address_usa_tx_7812_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_8_index ON public.address_usa_tx_7812 USING btree (first_8);


--
-- Name: address_usa_tx_7812_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_7812_first_9_index ON public.address_usa_tx_7812 USING btree (first_9);


--
-- Name: address_usa_tx_78140_esiid_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_esiid_index ON public.address_usa_tx_78140 USING btree (esiid);


--
-- Name: address_usa_tx_78140_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_first_1_index ON public.address_usa_tx_78140 USING btree (first_1);


--
-- Name: address_usa_tx_78140_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_first_2_index ON public.address_usa_tx_78140 USING btree (first_2);


--
-- Name: address_usa_tx_78140_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_first_3_index ON public.address_usa_tx_78140 USING btree (first_3);


--
-- Name: address_usa_tx_78140_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_first_4_index ON public.address_usa_tx_78140 USING btree (first_4);


--
-- Name: address_usa_tx_78140_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_first_5_index ON public.address_usa_tx_78140 USING btree (first_5);


--
-- Name: address_usa_tx_78140_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_tx_78140_first_6_index ON public.address_usa_tx_78140 USING btree (first_6);


--
