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

CREATE INDEX address_usa_ny_104_first_8_index ON public.address_usa_ny_104 USING btree (first_8);


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

CREATE INDEX address_usa_ny_104_first_9_index ON public.address_usa_ny_104 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10504_first_1_index ON public.address_usa_ny_10504 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10504_first_2_index ON public.address_usa_ny_10504 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10504_first_3_index ON public.address_usa_ny_10504 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10504_first_4_index ON public.address_usa_ny_10504 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10504_first_5_index ON public.address_usa_ny_10504 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10504_first_6_index ON public.address_usa_ny_10504 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10504_first_7_index ON public.address_usa_ny_10504 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10504_first_8_index ON public.address_usa_ny_10504 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10504_first_9_index ON public.address_usa_ny_10504 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10504_street_id_index ON public.address_usa_ny_10504 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10506_first_1_index ON public.address_usa_ny_10506 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10506_first_2_index ON public.address_usa_ny_10506 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10506_first_3_index ON public.address_usa_ny_10506 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10506_first_4_index ON public.address_usa_ny_10506 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10506_first_5_index ON public.address_usa_ny_10506 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10506_first_6_index ON public.address_usa_ny_10506 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10506_first_7_index ON public.address_usa_ny_10506 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10506_first_8_index ON public.address_usa_ny_10506 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10506_first_9_index ON public.address_usa_ny_10506 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10509_first_1_index ON public.address_usa_ny_10509 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10509_first_2_index ON public.address_usa_ny_10509 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10509_first_3_index ON public.address_usa_ny_10509 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10509_first_4_index ON public.address_usa_ny_10509 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10509_first_5_index ON public.address_usa_ny_10509 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10509_first_6_index ON public.address_usa_ny_10509 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10509_first_7_index ON public.address_usa_ny_10509 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10509_first_8_index ON public.address_usa_ny_10509 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10509_first_9_index ON public.address_usa_ny_10509 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1050_first_1_index ON public.address_usa_ny_1050 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1050_first_2_index ON public.address_usa_ny_1050 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1050_first_3_index ON public.address_usa_ny_1050 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1050_first_4_index ON public.address_usa_ny_1050 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1050_first_5_index ON public.address_usa_ny_1050 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1050_first_6_index ON public.address_usa_ny_1050 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1050_first_7_index ON public.address_usa_ny_1050 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1050_first_8_index ON public.address_usa_ny_1050 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1050_first_9_index ON public.address_usa_ny_1050 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10512_first_1_index ON public.address_usa_ny_10512 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10512_first_2_index ON public.address_usa_ny_10512 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10512_first_3_index ON public.address_usa_ny_10512 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10512_first_4_index ON public.address_usa_ny_10512 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10512_first_5_index ON public.address_usa_ny_10512 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10512_first_6_index ON public.address_usa_ny_10512 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10512_first_7_index ON public.address_usa_ny_10512 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10512_first_8_index ON public.address_usa_ny_10512 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10512_first_9_index ON public.address_usa_ny_10512 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10512_street_id_index ON public.address_usa_ny_10512 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10514_first_1_index ON public.address_usa_ny_10514 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10514_first_2_index ON public.address_usa_ny_10514 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10514_first_3_index ON public.address_usa_ny_10514 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10514_first_4_index ON public.address_usa_ny_10514 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10514_first_5_index ON public.address_usa_ny_10514 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10514_first_6_index ON public.address_usa_ny_10514 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10514_first_7_index ON public.address_usa_ny_10514 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10514_first_8_index ON public.address_usa_ny_10514 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10514_first_9_index ON public.address_usa_ny_10514 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10514_street_id_index ON public.address_usa_ny_10514 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10516_first_1_index ON public.address_usa_ny_10516 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10516_first_2_index ON public.address_usa_ny_10516 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10516_first_3_index ON public.address_usa_ny_10516 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10516_first_4_index ON public.address_usa_ny_10516 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10516_first_5_index ON public.address_usa_ny_10516 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10516_first_6_index ON public.address_usa_ny_10516 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10516_first_7_index ON public.address_usa_ny_10516 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10516_first_8_index ON public.address_usa_ny_10516 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10516_first_9_index ON public.address_usa_ny_10516 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1051_first_1_index ON public.address_usa_ny_1051 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1051_first_2_index ON public.address_usa_ny_1051 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1051_first_3_index ON public.address_usa_ny_1051 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1051_first_4_index ON public.address_usa_ny_1051 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1051_first_5_index ON public.address_usa_ny_1051 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1051_first_6_index ON public.address_usa_ny_1051 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1051_first_7_index ON public.address_usa_ny_1051 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1051_first_8_index ON public.address_usa_ny_1051 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1051_first_9_index ON public.address_usa_ny_1051 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10520_first_1_index ON public.address_usa_ny_10520 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10520_first_2_index ON public.address_usa_ny_10520 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10520_first_3_index ON public.address_usa_ny_10520 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10520_first_4_index ON public.address_usa_ny_10520 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10520_first_5_index ON public.address_usa_ny_10520 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10520_first_6_index ON public.address_usa_ny_10520 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10520_first_7_index ON public.address_usa_ny_10520 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10520_first_8_index ON public.address_usa_ny_10520 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10520_first_9_index ON public.address_usa_ny_10520 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10520_street_id_index ON public.address_usa_ny_10520 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10522_first_1_index ON public.address_usa_ny_10522 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10522_first_2_index ON public.address_usa_ny_10522 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10522_first_3_index ON public.address_usa_ny_10522 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10522_first_4_index ON public.address_usa_ny_10522 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10522_first_5_index ON public.address_usa_ny_10522 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10522_first_6_index ON public.address_usa_ny_10522 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10522_first_7_index ON public.address_usa_ny_10522 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10522_first_8_index ON public.address_usa_ny_10522 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10522_first_9_index ON public.address_usa_ny_10522 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10523_first_1_index ON public.address_usa_ny_10523 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10523_first_2_index ON public.address_usa_ny_10523 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10523_first_3_index ON public.address_usa_ny_10523 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10523_first_4_index ON public.address_usa_ny_10523 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10523_first_5_index ON public.address_usa_ny_10523 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10523_first_6_index ON public.address_usa_ny_10523 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10523_first_7_index ON public.address_usa_ny_10523 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10523_first_8_index ON public.address_usa_ny_10523 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10523_first_9_index ON public.address_usa_ny_10523 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10528_first_1_index ON public.address_usa_ny_10528 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10528_first_2_index ON public.address_usa_ny_10528 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10528_first_3_index ON public.address_usa_ny_10528 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10528_first_4_index ON public.address_usa_ny_10528 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10528_first_5_index ON public.address_usa_ny_10528 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10528_first_6_index ON public.address_usa_ny_10528 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10528_first_7_index ON public.address_usa_ny_10528 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10528_first_8_index ON public.address_usa_ny_10528 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10528_first_9_index ON public.address_usa_ny_10528 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1052_first_1_index ON public.address_usa_ny_1052 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1052_first_2_index ON public.address_usa_ny_1052 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1052_first_3_index ON public.address_usa_ny_1052 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1052_first_4_index ON public.address_usa_ny_1052 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1052_first_5_index ON public.address_usa_ny_1052 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1052_first_6_index ON public.address_usa_ny_1052 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1052_first_7_index ON public.address_usa_ny_1052 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1052_first_8_index ON public.address_usa_ny_1052 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1052_first_9_index ON public.address_usa_ny_1052 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10530_first_1_index ON public.address_usa_ny_10530 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10530_first_2_index ON public.address_usa_ny_10530 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10530_first_3_index ON public.address_usa_ny_10530 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10530_first_4_index ON public.address_usa_ny_10530 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10530_first_5_index ON public.address_usa_ny_10530 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10530_first_6_index ON public.address_usa_ny_10530 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10530_first_7_index ON public.address_usa_ny_10530 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10530_first_8_index ON public.address_usa_ny_10530 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10530_first_9_index ON public.address_usa_ny_10530 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10532_first_1_index ON public.address_usa_ny_10532 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10532_first_2_index ON public.address_usa_ny_10532 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10532_first_3_index ON public.address_usa_ny_10532 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10532_first_4_index ON public.address_usa_ny_10532 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10532_first_5_index ON public.address_usa_ny_10532 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10532_first_6_index ON public.address_usa_ny_10532 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10532_first_7_index ON public.address_usa_ny_10532 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10532_first_8_index ON public.address_usa_ny_10532 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10532_first_9_index ON public.address_usa_ny_10532 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10533_first_1_index ON public.address_usa_ny_10533 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10533_first_2_index ON public.address_usa_ny_10533 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10533_first_3_index ON public.address_usa_ny_10533 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10533_first_4_index ON public.address_usa_ny_10533 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10533_first_5_index ON public.address_usa_ny_10533 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10533_first_6_index ON public.address_usa_ny_10533 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10533_first_7_index ON public.address_usa_ny_10533 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10533_first_8_index ON public.address_usa_ny_10533 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10533_first_9_index ON public.address_usa_ny_10533 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10533_street_id_index ON public.address_usa_ny_10533 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10537_first_1_index ON public.address_usa_ny_10537 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10537_first_2_index ON public.address_usa_ny_10537 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10537_first_3_index ON public.address_usa_ny_10537 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10537_first_4_index ON public.address_usa_ny_10537 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10537_first_5_index ON public.address_usa_ny_10537 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10537_first_6_index ON public.address_usa_ny_10537 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10537_first_7_index ON public.address_usa_ny_10537 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10537_first_8_index ON public.address_usa_ny_10537 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10537_first_9_index ON public.address_usa_ny_10537 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10538_first_1_index ON public.address_usa_ny_10538 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10538_first_2_index ON public.address_usa_ny_10538 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10538_first_3_index ON public.address_usa_ny_10538 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10538_first_4_index ON public.address_usa_ny_10538 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10538_first_5_index ON public.address_usa_ny_10538 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10538_first_6_index ON public.address_usa_ny_10538 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10538_first_7_index ON public.address_usa_ny_10538 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10538_first_8_index ON public.address_usa_ny_10538 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10538_first_9_index ON public.address_usa_ny_10538 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1053_first_1_index ON public.address_usa_ny_1053 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1053_first_2_index ON public.address_usa_ny_1053 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1053_first_3_index ON public.address_usa_ny_1053 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1053_first_4_index ON public.address_usa_ny_1053 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1053_first_5_index ON public.address_usa_ny_1053 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1053_first_6_index ON public.address_usa_ny_1053 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1053_first_7_index ON public.address_usa_ny_1053 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1053_first_8_index ON public.address_usa_ny_1053 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1053_first_9_index ON public.address_usa_ny_1053 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10541_first_1_index ON public.address_usa_ny_10541 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10541_first_2_index ON public.address_usa_ny_10541 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10541_first_3_index ON public.address_usa_ny_10541 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10541_first_4_index ON public.address_usa_ny_10541 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10541_first_5_index ON public.address_usa_ny_10541 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10541_first_6_index ON public.address_usa_ny_10541 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10541_first_7_index ON public.address_usa_ny_10541 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10541_first_8_index ON public.address_usa_ny_10541 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10541_first_9_index ON public.address_usa_ny_10541 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10543_first_1_index ON public.address_usa_ny_10543 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10543_first_2_index ON public.address_usa_ny_10543 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10543_first_3_index ON public.address_usa_ny_10543 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10543_first_4_index ON public.address_usa_ny_10543 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10543_first_5_index ON public.address_usa_ny_10543 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10543_first_6_index ON public.address_usa_ny_10543 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10543_first_7_index ON public.address_usa_ny_10543 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10543_first_8_index ON public.address_usa_ny_10543 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10543_first_9_index ON public.address_usa_ny_10543 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10547_first_1_index ON public.address_usa_ny_10547 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10547_first_2_index ON public.address_usa_ny_10547 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10547_first_3_index ON public.address_usa_ny_10547 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10547_first_4_index ON public.address_usa_ny_10547 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10547_first_5_index ON public.address_usa_ny_10547 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10547_first_6_index ON public.address_usa_ny_10547 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10547_first_7_index ON public.address_usa_ny_10547 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10547_first_8_index ON public.address_usa_ny_10547 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10547_first_9_index ON public.address_usa_ny_10547 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10549_first_1_index ON public.address_usa_ny_10549 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10549_first_2_index ON public.address_usa_ny_10549 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10549_first_3_index ON public.address_usa_ny_10549 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10549_first_4_index ON public.address_usa_ny_10549 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10549_first_5_index ON public.address_usa_ny_10549 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10549_first_6_index ON public.address_usa_ny_10549 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10549_first_7_index ON public.address_usa_ny_10549 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10549_first_8_index ON public.address_usa_ny_10549 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10549_first_9_index ON public.address_usa_ny_10549 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10549_street_id_index ON public.address_usa_ny_10549 USING btree (street_id);


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

CREATE INDEX address_usa_ny_1054_first_1_index ON public.address_usa_ny_1054 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1054_first_2_index ON public.address_usa_ny_1054 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1054_first_3_index ON public.address_usa_ny_1054 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1054_first_4_index ON public.address_usa_ny_1054 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1054_first_5_index ON public.address_usa_ny_1054 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1054_first_6_index ON public.address_usa_ny_1054 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1054_first_7_index ON public.address_usa_ny_1054 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1054_first_8_index ON public.address_usa_ny_1054 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1054_first_9_index ON public.address_usa_ny_1054 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10550_first_1_index ON public.address_usa_ny_10550 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10550_first_2_index ON public.address_usa_ny_10550 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10550_first_3_index ON public.address_usa_ny_10550 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10550_first_4_index ON public.address_usa_ny_10550 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10550_first_5_index ON public.address_usa_ny_10550 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10550_first_6_index ON public.address_usa_ny_10550 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10550_first_7_index ON public.address_usa_ny_10550 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10550_first_8_index ON public.address_usa_ny_10550 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10550_first_9_index ON public.address_usa_ny_10550 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10550_street_id_index ON public.address_usa_ny_10550 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10552_first_1_index ON public.address_usa_ny_10552 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10552_first_2_index ON public.address_usa_ny_10552 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10552_first_3_index ON public.address_usa_ny_10552 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10552_first_4_index ON public.address_usa_ny_10552 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10552_first_5_index ON public.address_usa_ny_10552 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10552_first_6_index ON public.address_usa_ny_10552 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10552_first_7_index ON public.address_usa_ny_10552 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10552_first_8_index ON public.address_usa_ny_10552 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10552_first_9_index ON public.address_usa_ny_10552 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10552_street_id_index ON public.address_usa_ny_10552 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10560_first_1_index ON public.address_usa_ny_10560 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10560_first_2_index ON public.address_usa_ny_10560 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10560_first_3_index ON public.address_usa_ny_10560 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10560_first_4_index ON public.address_usa_ny_10560 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10560_first_5_index ON public.address_usa_ny_10560 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10560_first_6_index ON public.address_usa_ny_10560 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10560_first_7_index ON public.address_usa_ny_10560 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10560_first_8_index ON public.address_usa_ny_10560 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10560_first_9_index ON public.address_usa_ny_10560 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10562_first_1_index ON public.address_usa_ny_10562 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10562_first_2_index ON public.address_usa_ny_10562 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10562_first_3_index ON public.address_usa_ny_10562 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10562_first_4_index ON public.address_usa_ny_10562 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10562_first_5_index ON public.address_usa_ny_10562 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10562_first_6_index ON public.address_usa_ny_10562 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10562_first_7_index ON public.address_usa_ny_10562 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10562_first_8_index ON public.address_usa_ny_10562 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10562_first_9_index ON public.address_usa_ny_10562 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10562_street_id_index ON public.address_usa_ny_10562 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10566_first_1_index ON public.address_usa_ny_10566 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10566_first_2_index ON public.address_usa_ny_10566 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10566_first_3_index ON public.address_usa_ny_10566 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10566_first_4_index ON public.address_usa_ny_10566 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10566_first_5_index ON public.address_usa_ny_10566 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10566_first_6_index ON public.address_usa_ny_10566 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10566_first_7_index ON public.address_usa_ny_10566 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10566_first_8_index ON public.address_usa_ny_10566 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10566_first_9_index ON public.address_usa_ny_10566 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10566_street_id_index ON public.address_usa_ny_10566 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10567_first_1_index ON public.address_usa_ny_10567 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10567_first_2_index ON public.address_usa_ny_10567 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10567_first_3_index ON public.address_usa_ny_10567 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10567_first_4_index ON public.address_usa_ny_10567 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10567_first_5_index ON public.address_usa_ny_10567 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10567_first_6_index ON public.address_usa_ny_10567 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10567_first_7_index ON public.address_usa_ny_10567 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10567_first_8_index ON public.address_usa_ny_10567 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10567_first_9_index ON public.address_usa_ny_10567 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1056_first_1_index ON public.address_usa_ny_1056 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1056_first_2_index ON public.address_usa_ny_1056 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1056_first_3_index ON public.address_usa_ny_1056 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1056_first_4_index ON public.address_usa_ny_1056 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1056_first_5_index ON public.address_usa_ny_1056 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1056_first_6_index ON public.address_usa_ny_1056 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1056_first_7_index ON public.address_usa_ny_1056 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1056_first_8_index ON public.address_usa_ny_1056 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1056_first_9_index ON public.address_usa_ny_1056 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10573_first_1_index ON public.address_usa_ny_10573 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10573_first_2_index ON public.address_usa_ny_10573 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10573_first_3_index ON public.address_usa_ny_10573 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10573_first_4_index ON public.address_usa_ny_10573 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10573_first_5_index ON public.address_usa_ny_10573 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10573_first_6_index ON public.address_usa_ny_10573 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10573_first_7_index ON public.address_usa_ny_10573 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10573_first_8_index ON public.address_usa_ny_10573 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10573_first_9_index ON public.address_usa_ny_10573 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1057_first_1_index ON public.address_usa_ny_1057 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1057_first_2_index ON public.address_usa_ny_1057 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1057_first_3_index ON public.address_usa_ny_1057 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1057_first_4_index ON public.address_usa_ny_1057 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1057_first_5_index ON public.address_usa_ny_1057 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1057_first_6_index ON public.address_usa_ny_1057 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1057_first_7_index ON public.address_usa_ny_1057 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1057_first_8_index ON public.address_usa_ny_1057 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1057_first_9_index ON public.address_usa_ny_1057 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10580_first_1_index ON public.address_usa_ny_10580 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10580_first_2_index ON public.address_usa_ny_10580 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10580_first_3_index ON public.address_usa_ny_10580 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10580_first_4_index ON public.address_usa_ny_10580 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10580_first_5_index ON public.address_usa_ny_10580 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10580_first_6_index ON public.address_usa_ny_10580 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10580_first_7_index ON public.address_usa_ny_10580 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10580_first_8_index ON public.address_usa_ny_10580 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10580_first_9_index ON public.address_usa_ny_10580 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10583_first_1_index ON public.address_usa_ny_10583 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10583_first_2_index ON public.address_usa_ny_10583 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10583_first_3_index ON public.address_usa_ny_10583 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10583_first_4_index ON public.address_usa_ny_10583 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10583_first_5_index ON public.address_usa_ny_10583 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10583_first_6_index ON public.address_usa_ny_10583 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10583_first_7_index ON public.address_usa_ny_10583 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10583_first_8_index ON public.address_usa_ny_10583 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10583_first_9_index ON public.address_usa_ny_10583 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10589_first_1_index ON public.address_usa_ny_10589 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10589_first_2_index ON public.address_usa_ny_10589 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10589_first_3_index ON public.address_usa_ny_10589 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10589_first_4_index ON public.address_usa_ny_10589 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10589_first_5_index ON public.address_usa_ny_10589 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10589_first_6_index ON public.address_usa_ny_10589 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10589_first_7_index ON public.address_usa_ny_10589 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10589_first_8_index ON public.address_usa_ny_10589 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10589_first_9_index ON public.address_usa_ny_10589 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1058_first_1_index ON public.address_usa_ny_1058 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1058_first_2_index ON public.address_usa_ny_1058 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1058_first_3_index ON public.address_usa_ny_1058 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1058_first_4_index ON public.address_usa_ny_1058 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1058_first_5_index ON public.address_usa_ny_1058 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1058_first_6_index ON public.address_usa_ny_1058 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1058_first_7_index ON public.address_usa_ny_1058 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1058_first_8_index ON public.address_usa_ny_1058 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1058_first_9_index ON public.address_usa_ny_1058 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10590_first_1_index ON public.address_usa_ny_10590 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10590_first_2_index ON public.address_usa_ny_10590 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10590_first_3_index ON public.address_usa_ny_10590 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10590_first_4_index ON public.address_usa_ny_10590 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10590_first_5_index ON public.address_usa_ny_10590 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10590_first_6_index ON public.address_usa_ny_10590 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10590_first_7_index ON public.address_usa_ny_10590 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10590_first_8_index ON public.address_usa_ny_10590 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10590_first_9_index ON public.address_usa_ny_10590 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10591_first_1_index ON public.address_usa_ny_10591 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10591_first_2_index ON public.address_usa_ny_10591 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10591_first_3_index ON public.address_usa_ny_10591 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10591_first_4_index ON public.address_usa_ny_10591 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10591_first_5_index ON public.address_usa_ny_10591 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10591_first_6_index ON public.address_usa_ny_10591 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10591_first_7_index ON public.address_usa_ny_10591 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10591_first_8_index ON public.address_usa_ny_10591 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10591_first_9_index ON public.address_usa_ny_10591 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10594_first_1_index ON public.address_usa_ny_10594 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10594_first_2_index ON public.address_usa_ny_10594 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10594_first_3_index ON public.address_usa_ny_10594 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10594_first_4_index ON public.address_usa_ny_10594 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10594_first_5_index ON public.address_usa_ny_10594 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10594_first_6_index ON public.address_usa_ny_10594 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10594_first_7_index ON public.address_usa_ny_10594 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10594_first_8_index ON public.address_usa_ny_10594 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10594_first_9_index ON public.address_usa_ny_10594 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10594_street_id_index ON public.address_usa_ny_10594 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10595_first_1_index ON public.address_usa_ny_10595 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10595_first_2_index ON public.address_usa_ny_10595 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10595_first_3_index ON public.address_usa_ny_10595 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10595_first_4_index ON public.address_usa_ny_10595 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10595_first_5_index ON public.address_usa_ny_10595 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10595_first_6_index ON public.address_usa_ny_10595 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10595_first_7_index ON public.address_usa_ny_10595 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10595_first_8_index ON public.address_usa_ny_10595 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10595_first_9_index ON public.address_usa_ny_10595 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10598_first_1_index ON public.address_usa_ny_10598 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10598_first_2_index ON public.address_usa_ny_10598 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10598_first_3_index ON public.address_usa_ny_10598 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10598_first_4_index ON public.address_usa_ny_10598 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10598_first_5_index ON public.address_usa_ny_10598 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10598_first_6_index ON public.address_usa_ny_10598 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10598_first_7_index ON public.address_usa_ny_10598 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10598_first_8_index ON public.address_usa_ny_10598 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10598_first_9_index ON public.address_usa_ny_10598 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1059_first_1_index ON public.address_usa_ny_1059 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1059_first_2_index ON public.address_usa_ny_1059 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1059_first_3_index ON public.address_usa_ny_1059 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1059_first_4_index ON public.address_usa_ny_1059 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1059_first_5_index ON public.address_usa_ny_1059 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1059_first_6_index ON public.address_usa_ny_1059 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1059_first_7_index ON public.address_usa_ny_1059 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1059_first_8_index ON public.address_usa_ny_1059 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1059_first_9_index ON public.address_usa_ny_1059 USING btree (first_9);


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

CREATE INDEX address_usa_ny_105_first_1_index ON public.address_usa_ny_105 USING btree (first_1);


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

CREATE INDEX address_usa_ny_105_first_2_index ON public.address_usa_ny_105 USING btree (first_2);


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

CREATE INDEX address_usa_ny_105_first_3_index ON public.address_usa_ny_105 USING btree (first_3);


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

CREATE INDEX address_usa_ny_105_first_4_index ON public.address_usa_ny_105 USING btree (first_4);


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

CREATE INDEX address_usa_ny_105_first_5_index ON public.address_usa_ny_105 USING btree (first_5);


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

CREATE INDEX address_usa_ny_105_first_6_index ON public.address_usa_ny_105 USING btree (first_6);


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

CREATE INDEX address_usa_ny_105_first_7_index ON public.address_usa_ny_105 USING btree (first_7);


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

CREATE INDEX address_usa_ny_105_first_8_index ON public.address_usa_ny_105 USING btree (first_8);


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

CREATE INDEX address_usa_ny_105_first_9_index ON public.address_usa_ny_105 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10601_first_1_index ON public.address_usa_ny_10601 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10601_first_2_index ON public.address_usa_ny_10601 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10601_first_3_index ON public.address_usa_ny_10601 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10601_first_4_index ON public.address_usa_ny_10601 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10601_first_5_index ON public.address_usa_ny_10601 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10601_first_6_index ON public.address_usa_ny_10601 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10601_first_7_index ON public.address_usa_ny_10601 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10601_first_8_index ON public.address_usa_ny_10601 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10601_first_9_index ON public.address_usa_ny_10601 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10603_first_1_index ON public.address_usa_ny_10603 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10603_first_2_index ON public.address_usa_ny_10603 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10603_first_3_index ON public.address_usa_ny_10603 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10603_first_4_index ON public.address_usa_ny_10603 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10603_first_5_index ON public.address_usa_ny_10603 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10603_first_6_index ON public.address_usa_ny_10603 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10603_first_7_index ON public.address_usa_ny_10603 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10603_first_8_index ON public.address_usa_ny_10603 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10603_first_9_index ON public.address_usa_ny_10603 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10604_first_1_index ON public.address_usa_ny_10604 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10604_first_2_index ON public.address_usa_ny_10604 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10604_first_3_index ON public.address_usa_ny_10604 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10604_first_4_index ON public.address_usa_ny_10604 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10604_first_5_index ON public.address_usa_ny_10604 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10604_first_6_index ON public.address_usa_ny_10604 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10604_first_7_index ON public.address_usa_ny_10604 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10604_first_8_index ON public.address_usa_ny_10604 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10604_first_9_index ON public.address_usa_ny_10604 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10605_first_1_index ON public.address_usa_ny_10605 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10605_first_2_index ON public.address_usa_ny_10605 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10605_first_3_index ON public.address_usa_ny_10605 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10605_first_4_index ON public.address_usa_ny_10605 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10605_first_5_index ON public.address_usa_ny_10605 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10605_first_6_index ON public.address_usa_ny_10605 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10605_first_7_index ON public.address_usa_ny_10605 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10605_first_8_index ON public.address_usa_ny_10605 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10605_first_9_index ON public.address_usa_ny_10605 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10606_first_1_index ON public.address_usa_ny_10606 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10606_first_2_index ON public.address_usa_ny_10606 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10606_first_3_index ON public.address_usa_ny_10606 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10606_first_4_index ON public.address_usa_ny_10606 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10606_first_5_index ON public.address_usa_ny_10606 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10606_first_6_index ON public.address_usa_ny_10606 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10606_first_7_index ON public.address_usa_ny_10606 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10606_first_8_index ON public.address_usa_ny_10606 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10606_first_9_index ON public.address_usa_ny_10606 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10607_first_1_index ON public.address_usa_ny_10607 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10607_first_2_index ON public.address_usa_ny_10607 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10607_first_3_index ON public.address_usa_ny_10607 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10607_first_4_index ON public.address_usa_ny_10607 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10607_first_5_index ON public.address_usa_ny_10607 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10607_first_6_index ON public.address_usa_ny_10607 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10607_first_7_index ON public.address_usa_ny_10607 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10607_first_8_index ON public.address_usa_ny_10607 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10607_first_9_index ON public.address_usa_ny_10607 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10607_street_id_index ON public.address_usa_ny_10607 USING btree (street_id);


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

CREATE INDEX address_usa_ny_1060_first_1_index ON public.address_usa_ny_1060 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1060_first_2_index ON public.address_usa_ny_1060 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1060_first_3_index ON public.address_usa_ny_1060 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1060_first_4_index ON public.address_usa_ny_1060 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1060_first_5_index ON public.address_usa_ny_1060 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1060_first_6_index ON public.address_usa_ny_1060 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1060_first_7_index ON public.address_usa_ny_1060 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1060_first_8_index ON public.address_usa_ny_1060 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1060_first_9_index ON public.address_usa_ny_1060 USING btree (first_9);


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

CREATE INDEX address_usa_ny_106_first_1_index ON public.address_usa_ny_106 USING btree (first_1);


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

CREATE INDEX address_usa_ny_106_first_2_index ON public.address_usa_ny_106 USING btree (first_2);


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

CREATE INDEX address_usa_ny_106_first_3_index ON public.address_usa_ny_106 USING btree (first_3);


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

CREATE INDEX address_usa_ny_106_first_4_index ON public.address_usa_ny_106 USING btree (first_4);


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

CREATE INDEX address_usa_ny_106_first_5_index ON public.address_usa_ny_106 USING btree (first_5);


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

CREATE INDEX address_usa_ny_106_first_6_index ON public.address_usa_ny_106 USING btree (first_6);


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

CREATE INDEX address_usa_ny_106_first_7_index ON public.address_usa_ny_106 USING btree (first_7);


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

CREATE INDEX address_usa_ny_106_first_8_index ON public.address_usa_ny_106 USING btree (first_8);


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

CREATE INDEX address_usa_ny_106_first_9_index ON public.address_usa_ny_106 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10701_first_1_index ON public.address_usa_ny_10701 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10701_first_2_index ON public.address_usa_ny_10701 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10701_first_3_index ON public.address_usa_ny_10701 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10701_first_4_index ON public.address_usa_ny_10701 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10701_first_5_index ON public.address_usa_ny_10701 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10701_first_6_index ON public.address_usa_ny_10701 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10701_first_7_index ON public.address_usa_ny_10701 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10701_first_8_index ON public.address_usa_ny_10701 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10701_first_9_index ON public.address_usa_ny_10701 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10701_street_id_index ON public.address_usa_ny_10701 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10703_first_1_index ON public.address_usa_ny_10703 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10703_first_2_index ON public.address_usa_ny_10703 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10703_first_3_index ON public.address_usa_ny_10703 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10703_first_4_index ON public.address_usa_ny_10703 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10703_first_5_index ON public.address_usa_ny_10703 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10703_first_6_index ON public.address_usa_ny_10703 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10703_first_7_index ON public.address_usa_ny_10703 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10703_first_8_index ON public.address_usa_ny_10703 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10703_first_9_index ON public.address_usa_ny_10703 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10703_street_id_index ON public.address_usa_ny_10703 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10704_first_1_index ON public.address_usa_ny_10704 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10704_first_2_index ON public.address_usa_ny_10704 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10704_first_3_index ON public.address_usa_ny_10704 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10704_first_4_index ON public.address_usa_ny_10704 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10704_first_5_index ON public.address_usa_ny_10704 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10704_first_6_index ON public.address_usa_ny_10704 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10704_first_7_index ON public.address_usa_ny_10704 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10704_first_8_index ON public.address_usa_ny_10704 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10704_first_9_index ON public.address_usa_ny_10704 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10704_street_id_index ON public.address_usa_ny_10704 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10705_first_1_index ON public.address_usa_ny_10705 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10705_first_2_index ON public.address_usa_ny_10705 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10705_first_3_index ON public.address_usa_ny_10705 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10705_first_4_index ON public.address_usa_ny_10705 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10705_first_5_index ON public.address_usa_ny_10705 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10705_first_6_index ON public.address_usa_ny_10705 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10705_first_7_index ON public.address_usa_ny_10705 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10705_first_8_index ON public.address_usa_ny_10705 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10705_first_9_index ON public.address_usa_ny_10705 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10706_first_1_index ON public.address_usa_ny_10706 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10706_first_2_index ON public.address_usa_ny_10706 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10706_first_3_index ON public.address_usa_ny_10706 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10706_first_4_index ON public.address_usa_ny_10706 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10706_first_5_index ON public.address_usa_ny_10706 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10706_first_6_index ON public.address_usa_ny_10706 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10706_first_7_index ON public.address_usa_ny_10706 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10706_first_8_index ON public.address_usa_ny_10706 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10706_first_9_index ON public.address_usa_ny_10706 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10707_first_1_index ON public.address_usa_ny_10707 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10707_first_2_index ON public.address_usa_ny_10707 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10707_first_3_index ON public.address_usa_ny_10707 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10707_first_4_index ON public.address_usa_ny_10707 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10707_first_5_index ON public.address_usa_ny_10707 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10707_first_6_index ON public.address_usa_ny_10707 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10707_first_7_index ON public.address_usa_ny_10707 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10707_first_8_index ON public.address_usa_ny_10707 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10707_first_9_index ON public.address_usa_ny_10707 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10709_first_1_index ON public.address_usa_ny_10709 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10709_first_2_index ON public.address_usa_ny_10709 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10709_first_3_index ON public.address_usa_ny_10709 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10709_first_4_index ON public.address_usa_ny_10709 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10709_first_5_index ON public.address_usa_ny_10709 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10709_first_6_index ON public.address_usa_ny_10709 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10709_first_7_index ON public.address_usa_ny_10709 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10709_first_8_index ON public.address_usa_ny_10709 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10709_first_9_index ON public.address_usa_ny_10709 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1070_first_1_index ON public.address_usa_ny_1070 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1070_first_2_index ON public.address_usa_ny_1070 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1070_first_3_index ON public.address_usa_ny_1070 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1070_first_4_index ON public.address_usa_ny_1070 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1070_first_5_index ON public.address_usa_ny_1070 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1070_first_6_index ON public.address_usa_ny_1070 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1070_first_7_index ON public.address_usa_ny_1070 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1070_first_8_index ON public.address_usa_ny_1070 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1070_first_9_index ON public.address_usa_ny_1070 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10710_first_1_index ON public.address_usa_ny_10710 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10710_first_2_index ON public.address_usa_ny_10710 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10710_first_3_index ON public.address_usa_ny_10710 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10710_first_4_index ON public.address_usa_ny_10710 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10710_first_5_index ON public.address_usa_ny_10710 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10710_first_6_index ON public.address_usa_ny_10710 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10710_first_7_index ON public.address_usa_ny_10710 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10710_first_8_index ON public.address_usa_ny_10710 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10710_first_9_index ON public.address_usa_ny_10710 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1071_first_1_index ON public.address_usa_ny_1071 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1071_first_2_index ON public.address_usa_ny_1071 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1071_first_3_index ON public.address_usa_ny_1071 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1071_first_4_index ON public.address_usa_ny_1071 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1071_first_5_index ON public.address_usa_ny_1071 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1071_first_6_index ON public.address_usa_ny_1071 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1071_first_7_index ON public.address_usa_ny_1071 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1071_first_8_index ON public.address_usa_ny_1071 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1071_first_9_index ON public.address_usa_ny_1071 USING btree (first_9);


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

CREATE INDEX address_usa_ny_107_first_1_index ON public.address_usa_ny_107 USING btree (first_1);


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

CREATE INDEX address_usa_ny_107_first_2_index ON public.address_usa_ny_107 USING btree (first_2);


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

CREATE INDEX address_usa_ny_107_first_3_index ON public.address_usa_ny_107 USING btree (first_3);


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

CREATE INDEX address_usa_ny_107_first_4_index ON public.address_usa_ny_107 USING btree (first_4);


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

CREATE INDEX address_usa_ny_107_first_5_index ON public.address_usa_ny_107 USING btree (first_5);


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

CREATE INDEX address_usa_ny_107_first_6_index ON public.address_usa_ny_107 USING btree (first_6);


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

CREATE INDEX address_usa_ny_107_first_7_index ON public.address_usa_ny_107 USING btree (first_7);


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

CREATE INDEX address_usa_ny_107_first_8_index ON public.address_usa_ny_107 USING btree (first_8);


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

CREATE INDEX address_usa_ny_107_first_9_index ON public.address_usa_ny_107 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10801_first_1_index ON public.address_usa_ny_10801 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10801_first_2_index ON public.address_usa_ny_10801 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10801_first_3_index ON public.address_usa_ny_10801 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10801_first_4_index ON public.address_usa_ny_10801 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10801_first_5_index ON public.address_usa_ny_10801 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10801_first_6_index ON public.address_usa_ny_10801 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10801_first_7_index ON public.address_usa_ny_10801 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10801_first_8_index ON public.address_usa_ny_10801 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10801_first_9_index ON public.address_usa_ny_10801 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10801_street_id_index ON public.address_usa_ny_10801 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10803_first_1_index ON public.address_usa_ny_10803 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10803_first_2_index ON public.address_usa_ny_10803 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10803_first_3_index ON public.address_usa_ny_10803 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10803_first_4_index ON public.address_usa_ny_10803 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10803_first_5_index ON public.address_usa_ny_10803 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10803_first_6_index ON public.address_usa_ny_10803 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10803_first_7_index ON public.address_usa_ny_10803 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10803_first_8_index ON public.address_usa_ny_10803 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10803_first_9_index ON public.address_usa_ny_10803 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1080_first_1_index ON public.address_usa_ny_1080 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1080_first_2_index ON public.address_usa_ny_1080 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1080_first_3_index ON public.address_usa_ny_1080 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1080_first_4_index ON public.address_usa_ny_1080 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1080_first_5_index ON public.address_usa_ny_1080 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1080_first_6_index ON public.address_usa_ny_1080 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1080_first_7_index ON public.address_usa_ny_1080 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1080_first_8_index ON public.address_usa_ny_1080 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1080_first_9_index ON public.address_usa_ny_1080 USING btree (first_9);


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

CREATE INDEX address_usa_ny_108_first_1_index ON public.address_usa_ny_108 USING btree (first_1);


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

CREATE INDEX address_usa_ny_108_first_2_index ON public.address_usa_ny_108 USING btree (first_2);


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

CREATE INDEX address_usa_ny_108_first_3_index ON public.address_usa_ny_108 USING btree (first_3);


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

CREATE INDEX address_usa_ny_108_first_4_index ON public.address_usa_ny_108 USING btree (first_4);


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

CREATE INDEX address_usa_ny_108_first_5_index ON public.address_usa_ny_108 USING btree (first_5);


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

CREATE INDEX address_usa_ny_108_first_6_index ON public.address_usa_ny_108 USING btree (first_6);


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

CREATE INDEX address_usa_ny_108_first_7_index ON public.address_usa_ny_108 USING btree (first_7);


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

CREATE INDEX address_usa_ny_108_first_8_index ON public.address_usa_ny_108 USING btree (first_8);


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

CREATE INDEX address_usa_ny_108_first_9_index ON public.address_usa_ny_108 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10901_first_1_index ON public.address_usa_ny_10901 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10901_first_2_index ON public.address_usa_ny_10901 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10901_first_3_index ON public.address_usa_ny_10901 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10901_first_4_index ON public.address_usa_ny_10901 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10901_first_5_index ON public.address_usa_ny_10901 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10901_first_6_index ON public.address_usa_ny_10901 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10901_first_7_index ON public.address_usa_ny_10901 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10901_first_8_index ON public.address_usa_ny_10901 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10901_first_9_index ON public.address_usa_ny_10901 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10901_street_id_index ON public.address_usa_ny_10901 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10918_first_1_index ON public.address_usa_ny_10918 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10918_first_2_index ON public.address_usa_ny_10918 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10918_first_3_index ON public.address_usa_ny_10918 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10918_first_4_index ON public.address_usa_ny_10918 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10918_first_5_index ON public.address_usa_ny_10918 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10918_first_6_index ON public.address_usa_ny_10918 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10918_first_7_index ON public.address_usa_ny_10918 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10918_first_8_index ON public.address_usa_ny_10918 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10918_first_9_index ON public.address_usa_ny_10918 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1091_first_1_index ON public.address_usa_ny_1091 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1091_first_2_index ON public.address_usa_ny_1091 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1091_first_3_index ON public.address_usa_ny_1091 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1091_first_4_index ON public.address_usa_ny_1091 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1091_first_5_index ON public.address_usa_ny_1091 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1091_first_6_index ON public.address_usa_ny_1091 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1091_first_7_index ON public.address_usa_ny_1091 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1091_first_8_index ON public.address_usa_ny_1091 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1091_first_9_index ON public.address_usa_ny_1091 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10920_first_1_index ON public.address_usa_ny_10920 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10920_first_2_index ON public.address_usa_ny_10920 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10920_first_3_index ON public.address_usa_ny_10920 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10920_first_4_index ON public.address_usa_ny_10920 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10920_first_5_index ON public.address_usa_ny_10920 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10920_first_6_index ON public.address_usa_ny_10920 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10920_first_7_index ON public.address_usa_ny_10920 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10920_first_8_index ON public.address_usa_ny_10920 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10920_first_9_index ON public.address_usa_ny_10920 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10922_first_1_index ON public.address_usa_ny_10922 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10922_first_2_index ON public.address_usa_ny_10922 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10922_first_3_index ON public.address_usa_ny_10922 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10922_first_4_index ON public.address_usa_ny_10922 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10922_first_5_index ON public.address_usa_ny_10922 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10922_first_6_index ON public.address_usa_ny_10922 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10922_first_7_index ON public.address_usa_ny_10922 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10922_first_8_index ON public.address_usa_ny_10922 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10922_first_9_index ON public.address_usa_ny_10922 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10923_first_1_index ON public.address_usa_ny_10923 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10923_first_2_index ON public.address_usa_ny_10923 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10923_first_3_index ON public.address_usa_ny_10923 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10923_first_4_index ON public.address_usa_ny_10923 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10923_first_5_index ON public.address_usa_ny_10923 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10923_first_6_index ON public.address_usa_ny_10923 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10923_first_7_index ON public.address_usa_ny_10923 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10923_first_8_index ON public.address_usa_ny_10923 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10923_first_9_index ON public.address_usa_ny_10923 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10924_first_1_index ON public.address_usa_ny_10924 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10924_first_2_index ON public.address_usa_ny_10924 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10924_first_3_index ON public.address_usa_ny_10924 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10924_first_4_index ON public.address_usa_ny_10924 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10924_first_5_index ON public.address_usa_ny_10924 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10924_first_6_index ON public.address_usa_ny_10924 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10924_first_7_index ON public.address_usa_ny_10924 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10924_first_8_index ON public.address_usa_ny_10924 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10924_first_9_index ON public.address_usa_ny_10924 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10924_street_id_index ON public.address_usa_ny_10924 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10925_first_1_index ON public.address_usa_ny_10925 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10925_first_2_index ON public.address_usa_ny_10925 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10925_first_3_index ON public.address_usa_ny_10925 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10925_first_4_index ON public.address_usa_ny_10925 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10925_first_5_index ON public.address_usa_ny_10925 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10925_first_6_index ON public.address_usa_ny_10925 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10925_first_7_index ON public.address_usa_ny_10925 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10925_first_8_index ON public.address_usa_ny_10925 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10925_first_9_index ON public.address_usa_ny_10925 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10925_street_id_index ON public.address_usa_ny_10925 USING btree (street_id);


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

CREATE INDEX address_usa_ny_1092_first_1_index ON public.address_usa_ny_1092 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1092_first_2_index ON public.address_usa_ny_1092 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1092_first_3_index ON public.address_usa_ny_1092 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1092_first_4_index ON public.address_usa_ny_1092 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1092_first_5_index ON public.address_usa_ny_1092 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1092_first_6_index ON public.address_usa_ny_1092 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1092_first_7_index ON public.address_usa_ny_1092 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1092_first_8_index ON public.address_usa_ny_1092 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1092_first_9_index ON public.address_usa_ny_1092 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10930_first_1_index ON public.address_usa_ny_10930 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10930_first_2_index ON public.address_usa_ny_10930 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10930_first_3_index ON public.address_usa_ny_10930 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10930_first_4_index ON public.address_usa_ny_10930 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10930_first_5_index ON public.address_usa_ny_10930 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10930_first_6_index ON public.address_usa_ny_10930 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10930_first_7_index ON public.address_usa_ny_10930 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10930_first_8_index ON public.address_usa_ny_10930 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10930_first_9_index ON public.address_usa_ny_10930 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1093_first_1_index ON public.address_usa_ny_1093 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1093_first_2_index ON public.address_usa_ny_1093 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1093_first_3_index ON public.address_usa_ny_1093 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1093_first_4_index ON public.address_usa_ny_1093 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1093_first_5_index ON public.address_usa_ny_1093 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1093_first_6_index ON public.address_usa_ny_1093 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1093_first_7_index ON public.address_usa_ny_1093 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1093_first_8_index ON public.address_usa_ny_1093 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1093_first_9_index ON public.address_usa_ny_1093 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10940_first_1_index ON public.address_usa_ny_10940 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10940_first_2_index ON public.address_usa_ny_10940 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10940_first_3_index ON public.address_usa_ny_10940 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10940_first_4_index ON public.address_usa_ny_10940 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10940_first_5_index ON public.address_usa_ny_10940 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10940_first_6_index ON public.address_usa_ny_10940 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10940_first_7_index ON public.address_usa_ny_10940 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10940_first_8_index ON public.address_usa_ny_10940 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10940_first_9_index ON public.address_usa_ny_10940 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10941_first_1_index ON public.address_usa_ny_10941 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10941_first_2_index ON public.address_usa_ny_10941 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10941_first_3_index ON public.address_usa_ny_10941 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10941_first_4_index ON public.address_usa_ny_10941 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10941_first_5_index ON public.address_usa_ny_10941 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10941_first_6_index ON public.address_usa_ny_10941 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10941_first_7_index ON public.address_usa_ny_10941 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10941_first_8_index ON public.address_usa_ny_10941 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10941_first_9_index ON public.address_usa_ny_10941 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1094_first_1_index ON public.address_usa_ny_1094 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1094_first_2_index ON public.address_usa_ny_1094 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1094_first_3_index ON public.address_usa_ny_1094 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1094_first_4_index ON public.address_usa_ny_1094 USING btree (first_4);


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

CREATE INDEX address_usa_ny_1094_first_5_index ON public.address_usa_ny_1094 USING btree (first_5);


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

CREATE INDEX address_usa_ny_1094_first_6_index ON public.address_usa_ny_1094 USING btree (first_6);


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

CREATE INDEX address_usa_ny_1094_first_7_index ON public.address_usa_ny_1094 USING btree (first_7);


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

CREATE INDEX address_usa_ny_1094_first_8_index ON public.address_usa_ny_1094 USING btree (first_8);


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

CREATE INDEX address_usa_ny_1094_first_9_index ON public.address_usa_ny_1094 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10950_first_1_index ON public.address_usa_ny_10950 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10950_first_2_index ON public.address_usa_ny_10950 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10950_first_3_index ON public.address_usa_ny_10950 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10950_first_4_index ON public.address_usa_ny_10950 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10950_first_5_index ON public.address_usa_ny_10950 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10950_first_6_index ON public.address_usa_ny_10950 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10950_first_7_index ON public.address_usa_ny_10950 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10950_first_8_index ON public.address_usa_ny_10950 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10950_first_9_index ON public.address_usa_ny_10950 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10952_first_1_index ON public.address_usa_ny_10952 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10952_first_2_index ON public.address_usa_ny_10952 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10952_first_3_index ON public.address_usa_ny_10952 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10952_first_4_index ON public.address_usa_ny_10952 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10952_first_5_index ON public.address_usa_ny_10952 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10952_first_6_index ON public.address_usa_ny_10952 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10952_first_7_index ON public.address_usa_ny_10952 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10952_first_8_index ON public.address_usa_ny_10952 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10952_first_9_index ON public.address_usa_ny_10952 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10954_first_1_index ON public.address_usa_ny_10954 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10954_first_2_index ON public.address_usa_ny_10954 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10954_first_3_index ON public.address_usa_ny_10954 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10954_first_4_index ON public.address_usa_ny_10954 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10954_first_5_index ON public.address_usa_ny_10954 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10954_first_6_index ON public.address_usa_ny_10954 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10954_first_7_index ON public.address_usa_ny_10954 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10954_first_8_index ON public.address_usa_ny_10954 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10954_first_9_index ON public.address_usa_ny_10954 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10956_first_1_index ON public.address_usa_ny_10956 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10956_first_2_index ON public.address_usa_ny_10956 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10956_first_3_index ON public.address_usa_ny_10956 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10956_first_4_index ON public.address_usa_ny_10956 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10956_first_5_index ON public.address_usa_ny_10956 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10956_first_6_index ON public.address_usa_ny_10956 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10956_first_7_index ON public.address_usa_ny_10956 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10956_first_8_index ON public.address_usa_ny_10956 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10956_first_9_index ON public.address_usa_ny_10956 USING btree (first_9);


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

CREATE INDEX address_usa_ny_10956_street_id_index ON public.address_usa_ny_10956 USING btree (street_id);


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

CREATE INDEX address_usa_ny_10958_first_1_index ON public.address_usa_ny_10958 USING btree (first_1);


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

CREATE INDEX address_usa_ny_10958_first_2_index ON public.address_usa_ny_10958 USING btree (first_2);


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

CREATE INDEX address_usa_ny_10958_first_3_index ON public.address_usa_ny_10958 USING btree (first_3);


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

CREATE INDEX address_usa_ny_10958_first_4_index ON public.address_usa_ny_10958 USING btree (first_4);


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

CREATE INDEX address_usa_ny_10958_first_5_index ON public.address_usa_ny_10958 USING btree (first_5);


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

CREATE INDEX address_usa_ny_10958_first_6_index ON public.address_usa_ny_10958 USING btree (first_6);


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

CREATE INDEX address_usa_ny_10958_first_7_index ON public.address_usa_ny_10958 USING btree (first_7);


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

CREATE INDEX address_usa_ny_10958_first_8_index ON public.address_usa_ny_10958 USING btree (first_8);


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

CREATE INDEX address_usa_ny_10958_first_9_index ON public.address_usa_ny_10958 USING btree (first_9);


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

CREATE INDEX address_usa_ny_1095_first_1_index ON public.address_usa_ny_1095 USING btree (first_1);


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

CREATE INDEX address_usa_ny_1095_first_2_index ON public.address_usa_ny_1095 USING btree (first_2);


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

CREATE INDEX address_usa_ny_1095_first_3_index ON public.address_usa_ny_1095 USING btree (first_3);


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

CREATE INDEX address_usa_ny_1095_first_4_index ON public.address_usa_ny_1095 USING btree (first_4);


--
-- Name: address_usa_ny_1095_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1095_first_5_index ON public.address_usa_ny_1095 USING btree (first_5);


--
-- Name: address_usa_ny_1095_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1095_first_6_index ON public.address_usa_ny_1095 USING btree (first_6);


--
-- Name: address_usa_ny_1095_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1095_first_7_index ON public.address_usa_ny_1095 USING btree (first_7);


--
-- Name: address_usa_ny_1095_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1095_first_8_index ON public.address_usa_ny_1095 USING btree (first_8);


--
-- Name: address_usa_ny_1095_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1095_first_9_index ON public.address_usa_ny_1095 USING btree (first_9);


--
-- Name: address_usa_ny_10960_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_1_index ON public.address_usa_ny_10960 USING btree (first_1);


--
-- Name: address_usa_ny_10960_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_2_index ON public.address_usa_ny_10960 USING btree (first_2);


--
-- Name: address_usa_ny_10960_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_3_index ON public.address_usa_ny_10960 USING btree (first_3);


--
-- Name: address_usa_ny_10960_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_4_index ON public.address_usa_ny_10960 USING btree (first_4);


--
-- Name: address_usa_ny_10960_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_5_index ON public.address_usa_ny_10960 USING btree (first_5);


--
-- Name: address_usa_ny_10960_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_6_index ON public.address_usa_ny_10960 USING btree (first_6);


--
-- Name: address_usa_ny_10960_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_7_index ON public.address_usa_ny_10960 USING btree (first_7);


--
-- Name: address_usa_ny_10960_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_8_index ON public.address_usa_ny_10960 USING btree (first_8);


--
-- Name: address_usa_ny_10960_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10960_first_9_index ON public.address_usa_ny_10960 USING btree (first_9);


--
-- Name: address_usa_ny_10962_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_1_index ON public.address_usa_ny_10962 USING btree (first_1);


--
-- Name: address_usa_ny_10962_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_2_index ON public.address_usa_ny_10962 USING btree (first_2);


--
-- Name: address_usa_ny_10962_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_3_index ON public.address_usa_ny_10962 USING btree (first_3);


--
-- Name: address_usa_ny_10962_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_4_index ON public.address_usa_ny_10962 USING btree (first_4);


--
-- Name: address_usa_ny_10962_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_5_index ON public.address_usa_ny_10962 USING btree (first_5);


--
-- Name: address_usa_ny_10962_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_6_index ON public.address_usa_ny_10962 USING btree (first_6);


--
-- Name: address_usa_ny_10962_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_7_index ON public.address_usa_ny_10962 USING btree (first_7);


--
-- Name: address_usa_ny_10962_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_8_index ON public.address_usa_ny_10962 USING btree (first_8);


--
-- Name: address_usa_ny_10962_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10962_first_9_index ON public.address_usa_ny_10962 USING btree (first_9);


--
-- Name: address_usa_ny_10965_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_1_index ON public.address_usa_ny_10965 USING btree (first_1);


--
-- Name: address_usa_ny_10965_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_2_index ON public.address_usa_ny_10965 USING btree (first_2);


--
-- Name: address_usa_ny_10965_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_3_index ON public.address_usa_ny_10965 USING btree (first_3);


--
-- Name: address_usa_ny_10965_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_4_index ON public.address_usa_ny_10965 USING btree (first_4);


--
-- Name: address_usa_ny_10965_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_5_index ON public.address_usa_ny_10965 USING btree (first_5);


--
-- Name: address_usa_ny_10965_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_6_index ON public.address_usa_ny_10965 USING btree (first_6);


--
-- Name: address_usa_ny_10965_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_7_index ON public.address_usa_ny_10965 USING btree (first_7);


--
-- Name: address_usa_ny_10965_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_8_index ON public.address_usa_ny_10965 USING btree (first_8);


--
-- Name: address_usa_ny_10965_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10965_first_9_index ON public.address_usa_ny_10965 USING btree (first_9);


--
-- Name: address_usa_ny_1096_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_1_index ON public.address_usa_ny_1096 USING btree (first_1);


--
-- Name: address_usa_ny_1096_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_2_index ON public.address_usa_ny_1096 USING btree (first_2);


--
-- Name: address_usa_ny_1096_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_3_index ON public.address_usa_ny_1096 USING btree (first_3);


--
-- Name: address_usa_ny_1096_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_4_index ON public.address_usa_ny_1096 USING btree (first_4);


--
-- Name: address_usa_ny_1096_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_5_index ON public.address_usa_ny_1096 USING btree (first_5);


--
-- Name: address_usa_ny_1096_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_6_index ON public.address_usa_ny_1096 USING btree (first_6);


--
-- Name: address_usa_ny_1096_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_7_index ON public.address_usa_ny_1096 USING btree (first_7);


--
-- Name: address_usa_ny_1096_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_8_index ON public.address_usa_ny_1096 USING btree (first_8);


--
-- Name: address_usa_ny_1096_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1096_first_9_index ON public.address_usa_ny_1096 USING btree (first_9);


--
-- Name: address_usa_ny_10970_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_1_index ON public.address_usa_ny_10970 USING btree (first_1);


--
-- Name: address_usa_ny_10970_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_2_index ON public.address_usa_ny_10970 USING btree (first_2);


--
-- Name: address_usa_ny_10970_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_3_index ON public.address_usa_ny_10970 USING btree (first_3);


--
-- Name: address_usa_ny_10970_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_4_index ON public.address_usa_ny_10970 USING btree (first_4);


--
-- Name: address_usa_ny_10970_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_5_index ON public.address_usa_ny_10970 USING btree (first_5);


--
-- Name: address_usa_ny_10970_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_6_index ON public.address_usa_ny_10970 USING btree (first_6);


--
-- Name: address_usa_ny_10970_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_7_index ON public.address_usa_ny_10970 USING btree (first_7);


--
-- Name: address_usa_ny_10970_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_8_index ON public.address_usa_ny_10970 USING btree (first_8);


--
-- Name: address_usa_ny_10970_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10970_first_9_index ON public.address_usa_ny_10970 USING btree (first_9);


--
-- Name: address_usa_ny_10977_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_1_index ON public.address_usa_ny_10977 USING btree (first_1);


--
-- Name: address_usa_ny_10977_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_2_index ON public.address_usa_ny_10977 USING btree (first_2);


--
-- Name: address_usa_ny_10977_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_3_index ON public.address_usa_ny_10977 USING btree (first_3);


--
-- Name: address_usa_ny_10977_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_4_index ON public.address_usa_ny_10977 USING btree (first_4);


--
-- Name: address_usa_ny_10977_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_5_index ON public.address_usa_ny_10977 USING btree (first_5);


--
-- Name: address_usa_ny_10977_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_6_index ON public.address_usa_ny_10977 USING btree (first_6);


--
-- Name: address_usa_ny_10977_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_7_index ON public.address_usa_ny_10977 USING btree (first_7);


--
-- Name: address_usa_ny_10977_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_8_index ON public.address_usa_ny_10977 USING btree (first_8);


--
-- Name: address_usa_ny_10977_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_first_9_index ON public.address_usa_ny_10977 USING btree (first_9);


--
-- Name: address_usa_ny_10977_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10977_street_id_index ON public.address_usa_ny_10977 USING btree (street_id);


--
-- Name: address_usa_ny_1097_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_1_index ON public.address_usa_ny_1097 USING btree (first_1);


--
-- Name: address_usa_ny_1097_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_2_index ON public.address_usa_ny_1097 USING btree (first_2);


--
-- Name: address_usa_ny_1097_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_3_index ON public.address_usa_ny_1097 USING btree (first_3);


--
-- Name: address_usa_ny_1097_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_4_index ON public.address_usa_ny_1097 USING btree (first_4);


--
-- Name: address_usa_ny_1097_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_5_index ON public.address_usa_ny_1097 USING btree (first_5);


--
-- Name: address_usa_ny_1097_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_6_index ON public.address_usa_ny_1097 USING btree (first_6);


--
-- Name: address_usa_ny_1097_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_7_index ON public.address_usa_ny_1097 USING btree (first_7);


--
-- Name: address_usa_ny_1097_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_8_index ON public.address_usa_ny_1097 USING btree (first_8);


--
-- Name: address_usa_ny_1097_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1097_first_9_index ON public.address_usa_ny_1097 USING btree (first_9);


--
-- Name: address_usa_ny_10980_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_1_index ON public.address_usa_ny_10980 USING btree (first_1);


--
-- Name: address_usa_ny_10980_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_2_index ON public.address_usa_ny_10980 USING btree (first_2);


--
-- Name: address_usa_ny_10980_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_3_index ON public.address_usa_ny_10980 USING btree (first_3);


--
-- Name: address_usa_ny_10980_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_4_index ON public.address_usa_ny_10980 USING btree (first_4);


--
-- Name: address_usa_ny_10980_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_5_index ON public.address_usa_ny_10980 USING btree (first_5);


--
-- Name: address_usa_ny_10980_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_6_index ON public.address_usa_ny_10980 USING btree (first_6);


--
-- Name: address_usa_ny_10980_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_7_index ON public.address_usa_ny_10980 USING btree (first_7);


--
-- Name: address_usa_ny_10980_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_8_index ON public.address_usa_ny_10980 USING btree (first_8);


--
-- Name: address_usa_ny_10980_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10980_first_9_index ON public.address_usa_ny_10980 USING btree (first_9);


--
-- Name: address_usa_ny_10983_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_1_index ON public.address_usa_ny_10983 USING btree (first_1);


--
-- Name: address_usa_ny_10983_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_2_index ON public.address_usa_ny_10983 USING btree (first_2);


--
-- Name: address_usa_ny_10983_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_3_index ON public.address_usa_ny_10983 USING btree (first_3);


--
-- Name: address_usa_ny_10983_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_4_index ON public.address_usa_ny_10983 USING btree (first_4);


--
-- Name: address_usa_ny_10983_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_5_index ON public.address_usa_ny_10983 USING btree (first_5);


--
-- Name: address_usa_ny_10983_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_6_index ON public.address_usa_ny_10983 USING btree (first_6);


--
-- Name: address_usa_ny_10983_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_7_index ON public.address_usa_ny_10983 USING btree (first_7);


--
-- Name: address_usa_ny_10983_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_8_index ON public.address_usa_ny_10983 USING btree (first_8);


--
-- Name: address_usa_ny_10983_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10983_first_9_index ON public.address_usa_ny_10983 USING btree (first_9);


--
-- Name: address_usa_ny_10984_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_1_index ON public.address_usa_ny_10984 USING btree (first_1);


--
-- Name: address_usa_ny_10984_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_2_index ON public.address_usa_ny_10984 USING btree (first_2);


--
-- Name: address_usa_ny_10984_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_3_index ON public.address_usa_ny_10984 USING btree (first_3);


--
-- Name: address_usa_ny_10984_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_4_index ON public.address_usa_ny_10984 USING btree (first_4);


--
-- Name: address_usa_ny_10984_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_5_index ON public.address_usa_ny_10984 USING btree (first_5);


--
-- Name: address_usa_ny_10984_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_6_index ON public.address_usa_ny_10984 USING btree (first_6);


--
-- Name: address_usa_ny_10984_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_7_index ON public.address_usa_ny_10984 USING btree (first_7);


--
-- Name: address_usa_ny_10984_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_8_index ON public.address_usa_ny_10984 USING btree (first_8);


--
-- Name: address_usa_ny_10984_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10984_first_9_index ON public.address_usa_ny_10984 USING btree (first_9);


--
-- Name: address_usa_ny_10986_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_1_index ON public.address_usa_ny_10986 USING btree (first_1);


--
-- Name: address_usa_ny_10986_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_2_index ON public.address_usa_ny_10986 USING btree (first_2);


--
-- Name: address_usa_ny_10986_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_3_index ON public.address_usa_ny_10986 USING btree (first_3);


--
-- Name: address_usa_ny_10986_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_4_index ON public.address_usa_ny_10986 USING btree (first_4);


--
-- Name: address_usa_ny_10986_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_5_index ON public.address_usa_ny_10986 USING btree (first_5);


--
-- Name: address_usa_ny_10986_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_6_index ON public.address_usa_ny_10986 USING btree (first_6);


--
-- Name: address_usa_ny_10986_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_7_index ON public.address_usa_ny_10986 USING btree (first_7);


--
-- Name: address_usa_ny_10986_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_8_index ON public.address_usa_ny_10986 USING btree (first_8);


--
-- Name: address_usa_ny_10986_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10986_first_9_index ON public.address_usa_ny_10986 USING btree (first_9);


--
-- Name: address_usa_ny_10987_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_1_index ON public.address_usa_ny_10987 USING btree (first_1);


--
-- Name: address_usa_ny_10987_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_2_index ON public.address_usa_ny_10987 USING btree (first_2);


--
-- Name: address_usa_ny_10987_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_3_index ON public.address_usa_ny_10987 USING btree (first_3);


--
-- Name: address_usa_ny_10987_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_4_index ON public.address_usa_ny_10987 USING btree (first_4);


--
-- Name: address_usa_ny_10987_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_5_index ON public.address_usa_ny_10987 USING btree (first_5);


--
-- Name: address_usa_ny_10987_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_6_index ON public.address_usa_ny_10987 USING btree (first_6);


--
-- Name: address_usa_ny_10987_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_7_index ON public.address_usa_ny_10987 USING btree (first_7);


--
-- Name: address_usa_ny_10987_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_8_index ON public.address_usa_ny_10987 USING btree (first_8);


--
-- Name: address_usa_ny_10987_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10987_first_9_index ON public.address_usa_ny_10987 USING btree (first_9);


--
-- Name: address_usa_ny_10989_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_1_index ON public.address_usa_ny_10989 USING btree (first_1);


--
-- Name: address_usa_ny_10989_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_2_index ON public.address_usa_ny_10989 USING btree (first_2);


--
-- Name: address_usa_ny_10989_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_3_index ON public.address_usa_ny_10989 USING btree (first_3);


--
-- Name: address_usa_ny_10989_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_4_index ON public.address_usa_ny_10989 USING btree (first_4);


--
-- Name: address_usa_ny_10989_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_5_index ON public.address_usa_ny_10989 USING btree (first_5);


--
-- Name: address_usa_ny_10989_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_6_index ON public.address_usa_ny_10989 USING btree (first_6);


--
-- Name: address_usa_ny_10989_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_7_index ON public.address_usa_ny_10989 USING btree (first_7);


--
-- Name: address_usa_ny_10989_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_8_index ON public.address_usa_ny_10989 USING btree (first_8);


--
-- Name: address_usa_ny_10989_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10989_first_9_index ON public.address_usa_ny_10989 USING btree (first_9);


--
-- Name: address_usa_ny_1098_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_1_index ON public.address_usa_ny_1098 USING btree (first_1);


--
-- Name: address_usa_ny_1098_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_2_index ON public.address_usa_ny_1098 USING btree (first_2);


--
-- Name: address_usa_ny_1098_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_3_index ON public.address_usa_ny_1098 USING btree (first_3);


--
-- Name: address_usa_ny_1098_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_4_index ON public.address_usa_ny_1098 USING btree (first_4);


--
-- Name: address_usa_ny_1098_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_5_index ON public.address_usa_ny_1098 USING btree (first_5);


--
-- Name: address_usa_ny_1098_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_6_index ON public.address_usa_ny_1098 USING btree (first_6);


--
-- Name: address_usa_ny_1098_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_7_index ON public.address_usa_ny_1098 USING btree (first_7);


--
-- Name: address_usa_ny_1098_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_8_index ON public.address_usa_ny_1098 USING btree (first_8);


--
-- Name: address_usa_ny_1098_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1098_first_9_index ON public.address_usa_ny_1098 USING btree (first_9);


--
-- Name: address_usa_ny_10990_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_1_index ON public.address_usa_ny_10990 USING btree (first_1);


--
-- Name: address_usa_ny_10990_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_2_index ON public.address_usa_ny_10990 USING btree (first_2);


--
-- Name: address_usa_ny_10990_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_3_index ON public.address_usa_ny_10990 USING btree (first_3);


--
-- Name: address_usa_ny_10990_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_4_index ON public.address_usa_ny_10990 USING btree (first_4);


--
-- Name: address_usa_ny_10990_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_5_index ON public.address_usa_ny_10990 USING btree (first_5);


--
-- Name: address_usa_ny_10990_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_6_index ON public.address_usa_ny_10990 USING btree (first_6);


--
-- Name: address_usa_ny_10990_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_7_index ON public.address_usa_ny_10990 USING btree (first_7);


--
-- Name: address_usa_ny_10990_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_8_index ON public.address_usa_ny_10990 USING btree (first_8);


--
-- Name: address_usa_ny_10990_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10990_first_9_index ON public.address_usa_ny_10990 USING btree (first_9);


--
-- Name: address_usa_ny_10992_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_1_index ON public.address_usa_ny_10992 USING btree (first_1);


--
-- Name: address_usa_ny_10992_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_2_index ON public.address_usa_ny_10992 USING btree (first_2);


--
-- Name: address_usa_ny_10992_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_3_index ON public.address_usa_ny_10992 USING btree (first_3);


--
-- Name: address_usa_ny_10992_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_4_index ON public.address_usa_ny_10992 USING btree (first_4);


--
-- Name: address_usa_ny_10992_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_5_index ON public.address_usa_ny_10992 USING btree (first_5);


--
-- Name: address_usa_ny_10992_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_6_index ON public.address_usa_ny_10992 USING btree (first_6);


--
-- Name: address_usa_ny_10992_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_7_index ON public.address_usa_ny_10992 USING btree (first_7);


--
-- Name: address_usa_ny_10992_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_8_index ON public.address_usa_ny_10992 USING btree (first_8);


--
-- Name: address_usa_ny_10992_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10992_first_9_index ON public.address_usa_ny_10992 USING btree (first_9);


--
-- Name: address_usa_ny_10993_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_1_index ON public.address_usa_ny_10993 USING btree (first_1);


--
-- Name: address_usa_ny_10993_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_2_index ON public.address_usa_ny_10993 USING btree (first_2);


--
-- Name: address_usa_ny_10993_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_3_index ON public.address_usa_ny_10993 USING btree (first_3);


--
-- Name: address_usa_ny_10993_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_4_index ON public.address_usa_ny_10993 USING btree (first_4);


--
-- Name: address_usa_ny_10993_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_5_index ON public.address_usa_ny_10993 USING btree (first_5);


--
-- Name: address_usa_ny_10993_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_6_index ON public.address_usa_ny_10993 USING btree (first_6);


--
-- Name: address_usa_ny_10993_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_7_index ON public.address_usa_ny_10993 USING btree (first_7);


--
-- Name: address_usa_ny_10993_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_8_index ON public.address_usa_ny_10993 USING btree (first_8);


--
-- Name: address_usa_ny_10993_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_10993_first_9_index ON public.address_usa_ny_10993 USING btree (first_9);


--
-- Name: address_usa_ny_1099_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_1_index ON public.address_usa_ny_1099 USING btree (first_1);


--
-- Name: address_usa_ny_1099_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_2_index ON public.address_usa_ny_1099 USING btree (first_2);


--
-- Name: address_usa_ny_1099_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_3_index ON public.address_usa_ny_1099 USING btree (first_3);


--
-- Name: address_usa_ny_1099_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_4_index ON public.address_usa_ny_1099 USING btree (first_4);


--
-- Name: address_usa_ny_1099_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_5_index ON public.address_usa_ny_1099 USING btree (first_5);


--
-- Name: address_usa_ny_1099_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_6_index ON public.address_usa_ny_1099 USING btree (first_6);


--
-- Name: address_usa_ny_1099_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_7_index ON public.address_usa_ny_1099 USING btree (first_7);


--
-- Name: address_usa_ny_1099_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_8_index ON public.address_usa_ny_1099 USING btree (first_8);


--
-- Name: address_usa_ny_1099_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1099_first_9_index ON public.address_usa_ny_1099 USING btree (first_9);


--
-- Name: address_usa_ny_109_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_1_index ON public.address_usa_ny_109 USING btree (first_1);


--
-- Name: address_usa_ny_109_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_2_index ON public.address_usa_ny_109 USING btree (first_2);


--
-- Name: address_usa_ny_109_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_3_index ON public.address_usa_ny_109 USING btree (first_3);


--
-- Name: address_usa_ny_109_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_4_index ON public.address_usa_ny_109 USING btree (first_4);


--
-- Name: address_usa_ny_109_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_5_index ON public.address_usa_ny_109 USING btree (first_5);


--
-- Name: address_usa_ny_109_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_6_index ON public.address_usa_ny_109 USING btree (first_6);


--
-- Name: address_usa_ny_109_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_7_index ON public.address_usa_ny_109 USING btree (first_7);


--
-- Name: address_usa_ny_109_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_8_index ON public.address_usa_ny_109 USING btree (first_8);


--
-- Name: address_usa_ny_109_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_109_first_9_index ON public.address_usa_ny_109 USING btree (first_9);


--
-- Name: address_usa_ny_10_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_1_index ON public.address_usa_ny_10 USING btree (first_1);


--
-- Name: address_usa_ny_10_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_2_index ON public.address_usa_ny_10 USING btree (first_2);


--
-- Name: address_usa_ny_10_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_3_index ON public.address_usa_ny_10 USING btree (first_3);


--
-- Name: address_usa_ny_10_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_4_index ON public.address_usa_ny_10 USING btree (first_4);


--
-- Name: address_usa_ny_10_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_5_index ON public.address_usa_ny_10 USING btree (first_5);


--
-- Name: address_usa_ny_10_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_6_index ON public.address_usa_ny_10 USING btree (first_6);


--
-- Name: address_usa_ny_10_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_7_index ON public.address_usa_ny_10 USING btree (first_7);


--
-- Name: address_usa_ny_10_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_8_index ON public.address_usa_ny_10 USING btree (first_8);


--
-- Name: address_usa_ny_10_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_10_first_9_index ON public.address_usa_ny_10 USING btree (first_9);


--
-- Name: address_usa_ny_11001_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_1_index ON public.address_usa_ny_11001 USING btree (first_1);


--
-- Name: address_usa_ny_11001_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_2_index ON public.address_usa_ny_11001 USING btree (first_2);


--
-- Name: address_usa_ny_11001_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_3_index ON public.address_usa_ny_11001 USING btree (first_3);


--
-- Name: address_usa_ny_11001_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_4_index ON public.address_usa_ny_11001 USING btree (first_4);


--
-- Name: address_usa_ny_11001_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_5_index ON public.address_usa_ny_11001 USING btree (first_5);


--
-- Name: address_usa_ny_11001_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_6_index ON public.address_usa_ny_11001 USING btree (first_6);


--
-- Name: address_usa_ny_11001_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_7_index ON public.address_usa_ny_11001 USING btree (first_7);


--
-- Name: address_usa_ny_11001_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_8_index ON public.address_usa_ny_11001 USING btree (first_8);


--
-- Name: address_usa_ny_11001_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_first_9_index ON public.address_usa_ny_11001 USING btree (first_9);


--
-- Name: address_usa_ny_11001_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11001_street_id_index ON public.address_usa_ny_11001 USING btree (street_id);


--
-- Name: address_usa_ny_11003_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_1_index ON public.address_usa_ny_11003 USING btree (first_1);


--
-- Name: address_usa_ny_11003_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_2_index ON public.address_usa_ny_11003 USING btree (first_2);


--
-- Name: address_usa_ny_11003_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_3_index ON public.address_usa_ny_11003 USING btree (first_3);


--
-- Name: address_usa_ny_11003_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_4_index ON public.address_usa_ny_11003 USING btree (first_4);


--
-- Name: address_usa_ny_11003_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_5_index ON public.address_usa_ny_11003 USING btree (first_5);


--
-- Name: address_usa_ny_11003_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_6_index ON public.address_usa_ny_11003 USING btree (first_6);


--
-- Name: address_usa_ny_11003_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_7_index ON public.address_usa_ny_11003 USING btree (first_7);


--
-- Name: address_usa_ny_11003_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_8_index ON public.address_usa_ny_11003 USING btree (first_8);


--
-- Name: address_usa_ny_11003_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11003_first_9_index ON public.address_usa_ny_11003 USING btree (first_9);


--
-- Name: address_usa_ny_1100_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_1_index ON public.address_usa_ny_1100 USING btree (first_1);


--
-- Name: address_usa_ny_1100_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_2_index ON public.address_usa_ny_1100 USING btree (first_2);


--
-- Name: address_usa_ny_1100_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_3_index ON public.address_usa_ny_1100 USING btree (first_3);


--
-- Name: address_usa_ny_1100_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_4_index ON public.address_usa_ny_1100 USING btree (first_4);


--
-- Name: address_usa_ny_1100_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_5_index ON public.address_usa_ny_1100 USING btree (first_5);


--
-- Name: address_usa_ny_1100_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_6_index ON public.address_usa_ny_1100 USING btree (first_6);


--
-- Name: address_usa_ny_1100_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_7_index ON public.address_usa_ny_1100 USING btree (first_7);


--
-- Name: address_usa_ny_1100_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_8_index ON public.address_usa_ny_1100 USING btree (first_8);


--
-- Name: address_usa_ny_1100_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1100_first_9_index ON public.address_usa_ny_1100 USING btree (first_9);


--
-- Name: address_usa_ny_11020_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_1_index ON public.address_usa_ny_11020 USING btree (first_1);


--
-- Name: address_usa_ny_11020_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_2_index ON public.address_usa_ny_11020 USING btree (first_2);


--
-- Name: address_usa_ny_11020_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_3_index ON public.address_usa_ny_11020 USING btree (first_3);


--
-- Name: address_usa_ny_11020_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_4_index ON public.address_usa_ny_11020 USING btree (first_4);


--
-- Name: address_usa_ny_11020_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_5_index ON public.address_usa_ny_11020 USING btree (first_5);


--
-- Name: address_usa_ny_11020_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_6_index ON public.address_usa_ny_11020 USING btree (first_6);


--
-- Name: address_usa_ny_11020_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_7_index ON public.address_usa_ny_11020 USING btree (first_7);


--
-- Name: address_usa_ny_11020_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_8_index ON public.address_usa_ny_11020 USING btree (first_8);


--
-- Name: address_usa_ny_11020_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11020_first_9_index ON public.address_usa_ny_11020 USING btree (first_9);


--
-- Name: address_usa_ny_1102_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_1_index ON public.address_usa_ny_1102 USING btree (first_1);


--
-- Name: address_usa_ny_1102_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_2_index ON public.address_usa_ny_1102 USING btree (first_2);


--
-- Name: address_usa_ny_1102_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_3_index ON public.address_usa_ny_1102 USING btree (first_3);


--
-- Name: address_usa_ny_1102_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_4_index ON public.address_usa_ny_1102 USING btree (first_4);


--
-- Name: address_usa_ny_1102_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_5_index ON public.address_usa_ny_1102 USING btree (first_5);


--
-- Name: address_usa_ny_1102_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_6_index ON public.address_usa_ny_1102 USING btree (first_6);


--
-- Name: address_usa_ny_1102_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_7_index ON public.address_usa_ny_1102 USING btree (first_7);


--
-- Name: address_usa_ny_1102_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_8_index ON public.address_usa_ny_1102 USING btree (first_8);


--
-- Name: address_usa_ny_1102_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_1102_first_9_index ON public.address_usa_ny_1102 USING btree (first_9);


--
-- Name: address_usa_ny_11030_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_1_index ON public.address_usa_ny_11030 USING btree (first_1);


--
-- Name: address_usa_ny_11030_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_2_index ON public.address_usa_ny_11030 USING btree (first_2);


--
-- Name: address_usa_ny_11030_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_3_index ON public.address_usa_ny_11030 USING btree (first_3);


--
-- Name: address_usa_ny_11030_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_4_index ON public.address_usa_ny_11030 USING btree (first_4);


--
-- Name: address_usa_ny_11030_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_5_index ON public.address_usa_ny_11030 USING btree (first_5);


--
-- Name: address_usa_ny_11030_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_6_index ON public.address_usa_ny_11030 USING btree (first_6);


--
-- Name: address_usa_ny_11030_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_7_index ON public.address_usa_ny_11030 USING btree (first_7);


--
-- Name: address_usa_ny_11030_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_8_index ON public.address_usa_ny_11030 USING btree (first_8);


--
-- Name: address_usa_ny_11030_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11030_first_9_index ON public.address_usa_ny_11030 USING btree (first_9);


--
-- Name: address_usa_ny_1103_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_1_index ON public.address_usa_ny_1103 USING btree (first_1);


--
-- Name: address_usa_ny_1103_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_2_index ON public.address_usa_ny_1103 USING btree (first_2);


--
-- Name: address_usa_ny_1103_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_3_index ON public.address_usa_ny_1103 USING btree (first_3);


--
-- Name: address_usa_ny_1103_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_4_index ON public.address_usa_ny_1103 USING btree (first_4);


--
-- Name: address_usa_ny_1103_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_5_index ON public.address_usa_ny_1103 USING btree (first_5);


--
-- Name: address_usa_ny_1103_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_6_index ON public.address_usa_ny_1103 USING btree (first_6);


--
-- Name: address_usa_ny_1103_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_7_index ON public.address_usa_ny_1103 USING btree (first_7);


--
-- Name: address_usa_ny_1103_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_8_index ON public.address_usa_ny_1103 USING btree (first_8);


--
-- Name: address_usa_ny_1103_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1103_first_9_index ON public.address_usa_ny_1103 USING btree (first_9);


--
-- Name: address_usa_ny_110_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_1_index ON public.address_usa_ny_110 USING btree (first_1);


--
-- Name: address_usa_ny_110_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_2_index ON public.address_usa_ny_110 USING btree (first_2);


--
-- Name: address_usa_ny_110_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_3_index ON public.address_usa_ny_110 USING btree (first_3);


--
-- Name: address_usa_ny_110_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_4_index ON public.address_usa_ny_110 USING btree (first_4);


--
-- Name: address_usa_ny_110_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_5_index ON public.address_usa_ny_110 USING btree (first_5);


--
-- Name: address_usa_ny_110_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_6_index ON public.address_usa_ny_110 USING btree (first_6);


--
-- Name: address_usa_ny_110_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_7_index ON public.address_usa_ny_110 USING btree (first_7);


--
-- Name: address_usa_ny_110_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_8_index ON public.address_usa_ny_110 USING btree (first_8);


--
-- Name: address_usa_ny_110_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_110_first_9_index ON public.address_usa_ny_110 USING btree (first_9);


--
-- Name: address_usa_ny_11101_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_1_index ON public.address_usa_ny_11101 USING btree (first_1);


--
-- Name: address_usa_ny_11101_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_2_index ON public.address_usa_ny_11101 USING btree (first_2);


--
-- Name: address_usa_ny_11101_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_3_index ON public.address_usa_ny_11101 USING btree (first_3);


--
-- Name: address_usa_ny_11101_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_4_index ON public.address_usa_ny_11101 USING btree (first_4);


--
-- Name: address_usa_ny_11101_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_5_index ON public.address_usa_ny_11101 USING btree (first_5);


--
-- Name: address_usa_ny_11101_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_6_index ON public.address_usa_ny_11101 USING btree (first_6);


--
-- Name: address_usa_ny_11101_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_7_index ON public.address_usa_ny_11101 USING btree (first_7);


--
-- Name: address_usa_ny_11101_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_8_index ON public.address_usa_ny_11101 USING btree (first_8);


--
-- Name: address_usa_ny_11101_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_first_9_index ON public.address_usa_ny_11101 USING btree (first_9);


--
-- Name: address_usa_ny_11101_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11101_street_id_index ON public.address_usa_ny_11101 USING btree (street_id);


--
-- Name: address_usa_ny_11102_first_1_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_1_index ON public.address_usa_ny_11102 USING btree (first_1);


--
-- Name: address_usa_ny_11102_first_2_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_2_index ON public.address_usa_ny_11102 USING btree (first_2);


--
-- Name: address_usa_ny_11102_first_3_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_3_index ON public.address_usa_ny_11102 USING btree (first_3);


--
-- Name: address_usa_ny_11102_first_4_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_4_index ON public.address_usa_ny_11102 USING btree (first_4);


--
-- Name: address_usa_ny_11102_first_5_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_5_index ON public.address_usa_ny_11102 USING btree (first_5);


--
-- Name: address_usa_ny_11102_first_6_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_6_index ON public.address_usa_ny_11102 USING btree (first_6);


--
-- Name: address_usa_ny_11102_first_7_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_7_index ON public.address_usa_ny_11102 USING btree (first_7);


--
-- Name: address_usa_ny_11102_first_8_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_8_index ON public.address_usa_ny_11102 USING btree (first_8);


--
-- Name: address_usa_ny_11102_first_9_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX address_usa_ny_11102_first_9_index ON public.address_usa_ny_11102 USING btree (first_9);


--
-- Name: address_usa_ny_11103_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_1_index ON public.address_usa_ny_11103 USING btree (first_1);


--
-- Name: address_usa_ny_11103_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_2_index ON public.address_usa_ny_11103 USING btree (first_2);


--
-- Name: address_usa_ny_11103_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_3_index ON public.address_usa_ny_11103 USING btree (first_3);


--
-- Name: address_usa_ny_11103_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_4_index ON public.address_usa_ny_11103 USING btree (first_4);


--
-- Name: address_usa_ny_11103_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_5_index ON public.address_usa_ny_11103 USING btree (first_5);


--
-- Name: address_usa_ny_11103_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_6_index ON public.address_usa_ny_11103 USING btree (first_6);


--
-- Name: address_usa_ny_11103_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_7_index ON public.address_usa_ny_11103 USING btree (first_7);


--
-- Name: address_usa_ny_11103_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_8_index ON public.address_usa_ny_11103 USING btree (first_8);


--
-- Name: address_usa_ny_11103_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_first_9_index ON public.address_usa_ny_11103 USING btree (first_9);


--
-- Name: address_usa_ny_11103_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11103_street_id_index ON public.address_usa_ny_11103 USING btree (street_id);


--
-- Name: address_usa_ny_11104_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_1_index ON public.address_usa_ny_11104 USING btree (first_1);


--
-- Name: address_usa_ny_11104_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_2_index ON public.address_usa_ny_11104 USING btree (first_2);


--
-- Name: address_usa_ny_11104_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_3_index ON public.address_usa_ny_11104 USING btree (first_3);


--
-- Name: address_usa_ny_11104_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_4_index ON public.address_usa_ny_11104 USING btree (first_4);


--
-- Name: address_usa_ny_11104_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_5_index ON public.address_usa_ny_11104 USING btree (first_5);


--
-- Name: address_usa_ny_11104_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_6_index ON public.address_usa_ny_11104 USING btree (first_6);


--
-- Name: address_usa_ny_11104_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_7_index ON public.address_usa_ny_11104 USING btree (first_7);


--
-- Name: address_usa_ny_11104_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_8_index ON public.address_usa_ny_11104 USING btree (first_8);


--
-- Name: address_usa_ny_11104_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_first_9_index ON public.address_usa_ny_11104 USING btree (first_9);


--
-- Name: address_usa_ny_11104_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11104_street_id_index ON public.address_usa_ny_11104 USING btree (street_id);


--
-- Name: address_usa_ny_11105_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_1_index ON public.address_usa_ny_11105 USING btree (first_1);


--
-- Name: address_usa_ny_11105_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_2_index ON public.address_usa_ny_11105 USING btree (first_2);


--
-- Name: address_usa_ny_11105_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_3_index ON public.address_usa_ny_11105 USING btree (first_3);


--
-- Name: address_usa_ny_11105_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_4_index ON public.address_usa_ny_11105 USING btree (first_4);


--
-- Name: address_usa_ny_11105_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_5_index ON public.address_usa_ny_11105 USING btree (first_5);


--
-- Name: address_usa_ny_11105_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_6_index ON public.address_usa_ny_11105 USING btree (first_6);


--
-- Name: address_usa_ny_11105_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_7_index ON public.address_usa_ny_11105 USING btree (first_7);


--
-- Name: address_usa_ny_11105_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_8_index ON public.address_usa_ny_11105 USING btree (first_8);


--
-- Name: address_usa_ny_11105_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_first_9_index ON public.address_usa_ny_11105 USING btree (first_9);


--
-- Name: address_usa_ny_11105_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11105_street_id_index ON public.address_usa_ny_11105 USING btree (street_id);


--
-- Name: address_usa_ny_11106_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_1_index ON public.address_usa_ny_11106 USING btree (first_1);


--
-- Name: address_usa_ny_11106_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_2_index ON public.address_usa_ny_11106 USING btree (first_2);


--
-- Name: address_usa_ny_11106_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_3_index ON public.address_usa_ny_11106 USING btree (first_3);


--
-- Name: address_usa_ny_11106_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_4_index ON public.address_usa_ny_11106 USING btree (first_4);


--
-- Name: address_usa_ny_11106_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_5_index ON public.address_usa_ny_11106 USING btree (first_5);


--
-- Name: address_usa_ny_11106_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_6_index ON public.address_usa_ny_11106 USING btree (first_6);


--
-- Name: address_usa_ny_11106_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_7_index ON public.address_usa_ny_11106 USING btree (first_7);


--
-- Name: address_usa_ny_11106_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_8_index ON public.address_usa_ny_11106 USING btree (first_8);


--
-- Name: address_usa_ny_11106_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_first_9_index ON public.address_usa_ny_11106 USING btree (first_9);


--
-- Name: address_usa_ny_11106_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11106_street_id_index ON public.address_usa_ny_11106 USING btree (street_id);


--
-- Name: address_usa_ny_11109_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_1_index ON public.address_usa_ny_11109 USING btree (first_1);


--
-- Name: address_usa_ny_11109_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_2_index ON public.address_usa_ny_11109 USING btree (first_2);


--
-- Name: address_usa_ny_11109_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_3_index ON public.address_usa_ny_11109 USING btree (first_3);


--
-- Name: address_usa_ny_11109_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_4_index ON public.address_usa_ny_11109 USING btree (first_4);


--
-- Name: address_usa_ny_11109_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_5_index ON public.address_usa_ny_11109 USING btree (first_5);


--
-- Name: address_usa_ny_11109_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_6_index ON public.address_usa_ny_11109 USING btree (first_6);


--
-- Name: address_usa_ny_11109_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_7_index ON public.address_usa_ny_11109 USING btree (first_7);


--
-- Name: address_usa_ny_11109_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_8_index ON public.address_usa_ny_11109 USING btree (first_8);


--
-- Name: address_usa_ny_11109_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11109_first_9_index ON public.address_usa_ny_11109 USING btree (first_9);


--
-- Name: address_usa_ny_1110_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_1_index ON public.address_usa_ny_1110 USING btree (first_1);


--
-- Name: address_usa_ny_1110_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_2_index ON public.address_usa_ny_1110 USING btree (first_2);


--
-- Name: address_usa_ny_1110_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_3_index ON public.address_usa_ny_1110 USING btree (first_3);


--
-- Name: address_usa_ny_1110_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_4_index ON public.address_usa_ny_1110 USING btree (first_4);


--
-- Name: address_usa_ny_1110_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_5_index ON public.address_usa_ny_1110 USING btree (first_5);


--
-- Name: address_usa_ny_1110_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_6_index ON public.address_usa_ny_1110 USING btree (first_6);


--
-- Name: address_usa_ny_1110_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_7_index ON public.address_usa_ny_1110 USING btree (first_7);


--
-- Name: address_usa_ny_1110_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_8_index ON public.address_usa_ny_1110 USING btree (first_8);


--
-- Name: address_usa_ny_1110_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1110_first_9_index ON public.address_usa_ny_1110 USING btree (first_9);


--
-- Name: address_usa_ny_111_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_1_index ON public.address_usa_ny_111 USING btree (first_1);


--
-- Name: address_usa_ny_111_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_2_index ON public.address_usa_ny_111 USING btree (first_2);


--
-- Name: address_usa_ny_111_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_3_index ON public.address_usa_ny_111 USING btree (first_3);


--
-- Name: address_usa_ny_111_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_4_index ON public.address_usa_ny_111 USING btree (first_4);


--
-- Name: address_usa_ny_111_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_5_index ON public.address_usa_ny_111 USING btree (first_5);


--
-- Name: address_usa_ny_111_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_6_index ON public.address_usa_ny_111 USING btree (first_6);


--
-- Name: address_usa_ny_111_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_7_index ON public.address_usa_ny_111 USING btree (first_7);


--
-- Name: address_usa_ny_111_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_8_index ON public.address_usa_ny_111 USING btree (first_8);


--
-- Name: address_usa_ny_111_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_111_first_9_index ON public.address_usa_ny_111 USING btree (first_9);


--
-- Name: address_usa_ny_11201_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_1_index ON public.address_usa_ny_11201 USING btree (first_1);


--
-- Name: address_usa_ny_11201_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_2_index ON public.address_usa_ny_11201 USING btree (first_2);


--
-- Name: address_usa_ny_11201_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_3_index ON public.address_usa_ny_11201 USING btree (first_3);


--
-- Name: address_usa_ny_11201_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_4_index ON public.address_usa_ny_11201 USING btree (first_4);


--
-- Name: address_usa_ny_11201_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_5_index ON public.address_usa_ny_11201 USING btree (first_5);


--
-- Name: address_usa_ny_11201_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_6_index ON public.address_usa_ny_11201 USING btree (first_6);


--
-- Name: address_usa_ny_11201_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_7_index ON public.address_usa_ny_11201 USING btree (first_7);


--
-- Name: address_usa_ny_11201_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_8_index ON public.address_usa_ny_11201 USING btree (first_8);


--
-- Name: address_usa_ny_11201_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_first_9_index ON public.address_usa_ny_11201 USING btree (first_9);


--
-- Name: address_usa_ny_11201_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11201_street_id_index ON public.address_usa_ny_11201 USING btree (street_id);


--
-- Name: address_usa_ny_11203_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_1_index ON public.address_usa_ny_11203 USING btree (first_1);


--
-- Name: address_usa_ny_11203_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_2_index ON public.address_usa_ny_11203 USING btree (first_2);


--
-- Name: address_usa_ny_11203_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_3_index ON public.address_usa_ny_11203 USING btree (first_3);


--
-- Name: address_usa_ny_11203_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_4_index ON public.address_usa_ny_11203 USING btree (first_4);


--
-- Name: address_usa_ny_11203_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_5_index ON public.address_usa_ny_11203 USING btree (first_5);


--
-- Name: address_usa_ny_11203_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_6_index ON public.address_usa_ny_11203 USING btree (first_6);


--
-- Name: address_usa_ny_11203_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_7_index ON public.address_usa_ny_11203 USING btree (first_7);


--
-- Name: address_usa_ny_11203_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_8_index ON public.address_usa_ny_11203 USING btree (first_8);


--
-- Name: address_usa_ny_11203_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_first_9_index ON public.address_usa_ny_11203 USING btree (first_9);


--
-- Name: address_usa_ny_11203_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11203_street_id_index ON public.address_usa_ny_11203 USING btree (street_id);


--
-- Name: address_usa_ny_11204_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_1_index ON public.address_usa_ny_11204 USING btree (first_1);


--
-- Name: address_usa_ny_11204_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_2_index ON public.address_usa_ny_11204 USING btree (first_2);


--
-- Name: address_usa_ny_11204_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_3_index ON public.address_usa_ny_11204 USING btree (first_3);


--
-- Name: address_usa_ny_11204_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_4_index ON public.address_usa_ny_11204 USING btree (first_4);


--
-- Name: address_usa_ny_11204_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_5_index ON public.address_usa_ny_11204 USING btree (first_5);


--
-- Name: address_usa_ny_11204_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_6_index ON public.address_usa_ny_11204 USING btree (first_6);


--
-- Name: address_usa_ny_11204_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_7_index ON public.address_usa_ny_11204 USING btree (first_7);


--
-- Name: address_usa_ny_11204_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_8_index ON public.address_usa_ny_11204 USING btree (first_8);


--
-- Name: address_usa_ny_11204_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11204_first_9_index ON public.address_usa_ny_11204 USING btree (first_9);


--
-- Name: address_usa_ny_11205_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_1_index ON public.address_usa_ny_11205 USING btree (first_1);


--
-- Name: address_usa_ny_11205_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_2_index ON public.address_usa_ny_11205 USING btree (first_2);


--
-- Name: address_usa_ny_11205_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_3_index ON public.address_usa_ny_11205 USING btree (first_3);


--
-- Name: address_usa_ny_11205_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_4_index ON public.address_usa_ny_11205 USING btree (first_4);


--
-- Name: address_usa_ny_11205_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_5_index ON public.address_usa_ny_11205 USING btree (first_5);


--
-- Name: address_usa_ny_11205_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_6_index ON public.address_usa_ny_11205 USING btree (first_6);


--
-- Name: address_usa_ny_11205_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_7_index ON public.address_usa_ny_11205 USING btree (first_7);


--
-- Name: address_usa_ny_11205_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_8_index ON public.address_usa_ny_11205 USING btree (first_8);


--
-- Name: address_usa_ny_11205_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_first_9_index ON public.address_usa_ny_11205 USING btree (first_9);


--
-- Name: address_usa_ny_11205_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11205_street_id_index ON public.address_usa_ny_11205 USING btree (street_id);


--
-- Name: address_usa_ny_11206_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_1_index ON public.address_usa_ny_11206 USING btree (first_1);


--
-- Name: address_usa_ny_11206_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_2_index ON public.address_usa_ny_11206 USING btree (first_2);


--
-- Name: address_usa_ny_11206_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_3_index ON public.address_usa_ny_11206 USING btree (first_3);


--
-- Name: address_usa_ny_11206_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_4_index ON public.address_usa_ny_11206 USING btree (first_4);


--
-- Name: address_usa_ny_11206_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_5_index ON public.address_usa_ny_11206 USING btree (first_5);


--
-- Name: address_usa_ny_11206_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_6_index ON public.address_usa_ny_11206 USING btree (first_6);


--
-- Name: address_usa_ny_11206_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_7_index ON public.address_usa_ny_11206 USING btree (first_7);


--
-- Name: address_usa_ny_11206_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_8_index ON public.address_usa_ny_11206 USING btree (first_8);


--
-- Name: address_usa_ny_11206_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_first_9_index ON public.address_usa_ny_11206 USING btree (first_9);


--
-- Name: address_usa_ny_11206_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11206_street_id_index ON public.address_usa_ny_11206 USING btree (street_id);


--
-- Name: address_usa_ny_11207_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_1_index ON public.address_usa_ny_11207 USING btree (first_1);


--
-- Name: address_usa_ny_11207_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_2_index ON public.address_usa_ny_11207 USING btree (first_2);


--
-- Name: address_usa_ny_11207_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_3_index ON public.address_usa_ny_11207 USING btree (first_3);


--
-- Name: address_usa_ny_11207_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_4_index ON public.address_usa_ny_11207 USING btree (first_4);


--
-- Name: address_usa_ny_11207_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_5_index ON public.address_usa_ny_11207 USING btree (first_5);


--
-- Name: address_usa_ny_11207_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_6_index ON public.address_usa_ny_11207 USING btree (first_6);


--
-- Name: address_usa_ny_11207_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_7_index ON public.address_usa_ny_11207 USING btree (first_7);


--
-- Name: address_usa_ny_11207_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_8_index ON public.address_usa_ny_11207 USING btree (first_8);


--
-- Name: address_usa_ny_11207_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_first_9_index ON public.address_usa_ny_11207 USING btree (first_9);


--
-- Name: address_usa_ny_11207_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11207_street_id_index ON public.address_usa_ny_11207 USING btree (street_id);


--
-- Name: address_usa_ny_11208_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_1_index ON public.address_usa_ny_11208 USING btree (first_1);


--
-- Name: address_usa_ny_11208_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_2_index ON public.address_usa_ny_11208 USING btree (first_2);


--
-- Name: address_usa_ny_11208_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_3_index ON public.address_usa_ny_11208 USING btree (first_3);


--
-- Name: address_usa_ny_11208_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_4_index ON public.address_usa_ny_11208 USING btree (first_4);


--
-- Name: address_usa_ny_11208_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_5_index ON public.address_usa_ny_11208 USING btree (first_5);


--
-- Name: address_usa_ny_11208_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_6_index ON public.address_usa_ny_11208 USING btree (first_6);


--
-- Name: address_usa_ny_11208_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_7_index ON public.address_usa_ny_11208 USING btree (first_7);


--
-- Name: address_usa_ny_11208_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_8_index ON public.address_usa_ny_11208 USING btree (first_8);


--
-- Name: address_usa_ny_11208_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_first_9_index ON public.address_usa_ny_11208 USING btree (first_9);


--
-- Name: address_usa_ny_11208_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11208_street_id_index ON public.address_usa_ny_11208 USING btree (street_id);


--
-- Name: address_usa_ny_11209_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_1_index ON public.address_usa_ny_11209 USING btree (first_1);


--
-- Name: address_usa_ny_11209_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_2_index ON public.address_usa_ny_11209 USING btree (first_2);


--
-- Name: address_usa_ny_11209_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_3_index ON public.address_usa_ny_11209 USING btree (first_3);


--
-- Name: address_usa_ny_11209_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_4_index ON public.address_usa_ny_11209 USING btree (first_4);


--
-- Name: address_usa_ny_11209_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_5_index ON public.address_usa_ny_11209 USING btree (first_5);


--
-- Name: address_usa_ny_11209_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_6_index ON public.address_usa_ny_11209 USING btree (first_6);


--
-- Name: address_usa_ny_11209_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_7_index ON public.address_usa_ny_11209 USING btree (first_7);


--
-- Name: address_usa_ny_11209_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_8_index ON public.address_usa_ny_11209 USING btree (first_8);


--
-- Name: address_usa_ny_11209_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_first_9_index ON public.address_usa_ny_11209 USING btree (first_9);


--
-- Name: address_usa_ny_11209_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11209_street_id_index ON public.address_usa_ny_11209 USING btree (street_id);


--
-- Name: address_usa_ny_1120_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_1_index ON public.address_usa_ny_1120 USING btree (first_1);


--
-- Name: address_usa_ny_1120_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_2_index ON public.address_usa_ny_1120 USING btree (first_2);


--
-- Name: address_usa_ny_1120_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_3_index ON public.address_usa_ny_1120 USING btree (first_3);


--
-- Name: address_usa_ny_1120_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_4_index ON public.address_usa_ny_1120 USING btree (first_4);


--
-- Name: address_usa_ny_1120_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_5_index ON public.address_usa_ny_1120 USING btree (first_5);


--
-- Name: address_usa_ny_1120_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_6_index ON public.address_usa_ny_1120 USING btree (first_6);


--
-- Name: address_usa_ny_1120_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_7_index ON public.address_usa_ny_1120 USING btree (first_7);


--
-- Name: address_usa_ny_1120_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_8_index ON public.address_usa_ny_1120 USING btree (first_8);


--
-- Name: address_usa_ny_1120_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_1120_first_9_index ON public.address_usa_ny_1120 USING btree (first_9);


--
-- Name: address_usa_ny_11210_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_1_index ON public.address_usa_ny_11210 USING btree (first_1);


--
-- Name: address_usa_ny_11210_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_2_index ON public.address_usa_ny_11210 USING btree (first_2);


--
-- Name: address_usa_ny_11210_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_3_index ON public.address_usa_ny_11210 USING btree (first_3);


--
-- Name: address_usa_ny_11210_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_4_index ON public.address_usa_ny_11210 USING btree (first_4);


--
-- Name: address_usa_ny_11210_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_5_index ON public.address_usa_ny_11210 USING btree (first_5);


--
-- Name: address_usa_ny_11210_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_6_index ON public.address_usa_ny_11210 USING btree (first_6);


--
-- Name: address_usa_ny_11210_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_7_index ON public.address_usa_ny_11210 USING btree (first_7);


--
-- Name: address_usa_ny_11210_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_8_index ON public.address_usa_ny_11210 USING btree (first_8);


--
-- Name: address_usa_ny_11210_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_first_9_index ON public.address_usa_ny_11210 USING btree (first_9);


--
-- Name: address_usa_ny_11210_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11210_street_id_index ON public.address_usa_ny_11210 USING btree (street_id);


--
-- Name: address_usa_ny_11211_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_1_index ON public.address_usa_ny_11211 USING btree (first_1);


--
-- Name: address_usa_ny_11211_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_2_index ON public.address_usa_ny_11211 USING btree (first_2);


--
-- Name: address_usa_ny_11211_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_3_index ON public.address_usa_ny_11211 USING btree (first_3);


--
-- Name: address_usa_ny_11211_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_4_index ON public.address_usa_ny_11211 USING btree (first_4);


--
-- Name: address_usa_ny_11211_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_5_index ON public.address_usa_ny_11211 USING btree (first_5);


--
-- Name: address_usa_ny_11211_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_6_index ON public.address_usa_ny_11211 USING btree (first_6);


--
-- Name: address_usa_ny_11211_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_7_index ON public.address_usa_ny_11211 USING btree (first_7);


--
-- Name: address_usa_ny_11211_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_8_index ON public.address_usa_ny_11211 USING btree (first_8);


--
-- Name: address_usa_ny_11211_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_first_9_index ON public.address_usa_ny_11211 USING btree (first_9);


--
-- Name: address_usa_ny_11211_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11211_street_id_index ON public.address_usa_ny_11211 USING btree (street_id);


--
-- Name: address_usa_ny_11212_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_1_index ON public.address_usa_ny_11212 USING btree (first_1);


--
-- Name: address_usa_ny_11212_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_2_index ON public.address_usa_ny_11212 USING btree (first_2);


--
-- Name: address_usa_ny_11212_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_3_index ON public.address_usa_ny_11212 USING btree (first_3);


--
-- Name: address_usa_ny_11212_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_4_index ON public.address_usa_ny_11212 USING btree (first_4);


--
-- Name: address_usa_ny_11212_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_5_index ON public.address_usa_ny_11212 USING btree (first_5);


--
-- Name: address_usa_ny_11212_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_6_index ON public.address_usa_ny_11212 USING btree (first_6);


--
-- Name: address_usa_ny_11212_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_7_index ON public.address_usa_ny_11212 USING btree (first_7);


--
-- Name: address_usa_ny_11212_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_8_index ON public.address_usa_ny_11212 USING btree (first_8);


--
-- Name: address_usa_ny_11212_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_first_9_index ON public.address_usa_ny_11212 USING btree (first_9);


--
-- Name: address_usa_ny_11212_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11212_street_id_index ON public.address_usa_ny_11212 USING btree (street_id);


--
-- Name: address_usa_ny_11213_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_1_index ON public.address_usa_ny_11213 USING btree (first_1);


--
-- Name: address_usa_ny_11213_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_2_index ON public.address_usa_ny_11213 USING btree (first_2);


--
-- Name: address_usa_ny_11213_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_3_index ON public.address_usa_ny_11213 USING btree (first_3);


--
-- Name: address_usa_ny_11213_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_4_index ON public.address_usa_ny_11213 USING btree (first_4);


--
-- Name: address_usa_ny_11213_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_5_index ON public.address_usa_ny_11213 USING btree (first_5);


--
-- Name: address_usa_ny_11213_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_6_index ON public.address_usa_ny_11213 USING btree (first_6);


--
-- Name: address_usa_ny_11213_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_7_index ON public.address_usa_ny_11213 USING btree (first_7);


--
-- Name: address_usa_ny_11213_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_8_index ON public.address_usa_ny_11213 USING btree (first_8);


--
-- Name: address_usa_ny_11213_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_first_9_index ON public.address_usa_ny_11213 USING btree (first_9);


--
-- Name: address_usa_ny_11213_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11213_street_id_index ON public.address_usa_ny_11213 USING btree (street_id);


--
-- Name: address_usa_ny_11214_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_1_index ON public.address_usa_ny_11214 USING btree (first_1);


--
-- Name: address_usa_ny_11214_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_2_index ON public.address_usa_ny_11214 USING btree (first_2);


--
-- Name: address_usa_ny_11214_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_3_index ON public.address_usa_ny_11214 USING btree (first_3);


--
-- Name: address_usa_ny_11214_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_4_index ON public.address_usa_ny_11214 USING btree (first_4);


--
-- Name: address_usa_ny_11214_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_5_index ON public.address_usa_ny_11214 USING btree (first_5);


--
-- Name: address_usa_ny_11214_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_6_index ON public.address_usa_ny_11214 USING btree (first_6);


--
-- Name: address_usa_ny_11214_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_7_index ON public.address_usa_ny_11214 USING btree (first_7);


--
-- Name: address_usa_ny_11214_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_8_index ON public.address_usa_ny_11214 USING btree (first_8);


--
-- Name: address_usa_ny_11214_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_first_9_index ON public.address_usa_ny_11214 USING btree (first_9);


--
-- Name: address_usa_ny_11214_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11214_street_id_index ON public.address_usa_ny_11214 USING btree (street_id);


--
-- Name: address_usa_ny_11215_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_1_index ON public.address_usa_ny_11215 USING btree (first_1);


--
-- Name: address_usa_ny_11215_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_2_index ON public.address_usa_ny_11215 USING btree (first_2);


--
-- Name: address_usa_ny_11215_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_3_index ON public.address_usa_ny_11215 USING btree (first_3);


--
-- Name: address_usa_ny_11215_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_4_index ON public.address_usa_ny_11215 USING btree (first_4);


--
-- Name: address_usa_ny_11215_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_5_index ON public.address_usa_ny_11215 USING btree (first_5);


--
-- Name: address_usa_ny_11215_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_6_index ON public.address_usa_ny_11215 USING btree (first_6);


--
-- Name: address_usa_ny_11215_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_7_index ON public.address_usa_ny_11215 USING btree (first_7);


--
-- Name: address_usa_ny_11215_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_8_index ON public.address_usa_ny_11215 USING btree (first_8);


--
-- Name: address_usa_ny_11215_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_first_9_index ON public.address_usa_ny_11215 USING btree (first_9);


--
-- Name: address_usa_ny_11215_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11215_street_id_index ON public.address_usa_ny_11215 USING btree (street_id);


--
-- Name: address_usa_ny_11216_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_1_index ON public.address_usa_ny_11216 USING btree (first_1);


--
-- Name: address_usa_ny_11216_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_2_index ON public.address_usa_ny_11216 USING btree (first_2);


--
-- Name: address_usa_ny_11216_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_3_index ON public.address_usa_ny_11216 USING btree (first_3);


--
-- Name: address_usa_ny_11216_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_4_index ON public.address_usa_ny_11216 USING btree (first_4);


--
-- Name: address_usa_ny_11216_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_5_index ON public.address_usa_ny_11216 USING btree (first_5);


--
-- Name: address_usa_ny_11216_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_6_index ON public.address_usa_ny_11216 USING btree (first_6);


--
-- Name: address_usa_ny_11216_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_7_index ON public.address_usa_ny_11216 USING btree (first_7);


--
-- Name: address_usa_ny_11216_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_8_index ON public.address_usa_ny_11216 USING btree (first_8);


--
-- Name: address_usa_ny_11216_first_9_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_first_9_index ON public.address_usa_ny_11216 USING btree (first_9);


--
-- Name: address_usa_ny_11216_street_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11216_street_id_index ON public.address_usa_ny_11216 USING btree (street_id);


--
-- Name: address_usa_ny_11217_first_1_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_1_index ON public.address_usa_ny_11217 USING btree (first_1);


--
-- Name: address_usa_ny_11217_first_2_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_2_index ON public.address_usa_ny_11217 USING btree (first_2);


--
-- Name: address_usa_ny_11217_first_3_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_3_index ON public.address_usa_ny_11217 USING btree (first_3);


--
-- Name: address_usa_ny_11217_first_4_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_4_index ON public.address_usa_ny_11217 USING btree (first_4);


--
-- Name: address_usa_ny_11217_first_5_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_5_index ON public.address_usa_ny_11217 USING btree (first_5);


--
-- Name: address_usa_ny_11217_first_6_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_6_index ON public.address_usa_ny_11217 USING btree (first_6);


--
-- Name: address_usa_ny_11217_first_7_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_7_index ON public.address_usa_ny_11217 USING btree (first_7);


--
-- Name: address_usa_ny_11217_first_8_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX address_usa_ny_11217_first_8_index ON public.address_usa_ny_11217 USING btree (first_8);


--
