-- Name: address_usa_tx_7685; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7685 (
)
INHERITS (public.address_usa_tx_768);


ALTER TABLE public.address_usa_tx_7685 OWNER TO postgres;

--
-- Name: address_usa_tx_76852; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76852 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76852 OWNER TO postgres;

--
-- Name: address_usa_tx_76853; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76853 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76853 OWNER TO postgres;

--
-- Name: address_usa_tx_76854; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76854 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76854 OWNER TO postgres;

--
-- Name: address_usa_tx_76856; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76856 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76856 OWNER TO postgres;

--
-- Name: address_usa_tx_76857; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76857 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76857 OWNER TO postgres;

--
-- Name: address_usa_tx_76858; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76858 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76858 OWNER TO postgres;

--
-- Name: address_usa_tx_76859; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76859 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7685);


ALTER TABLE public.address_usa_tx_76859 OWNER TO postgres;

--
-- Name: address_usa_tx_7686; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7686 (
)
INHERITS (public.address_usa_tx_768);


ALTER TABLE public.address_usa_tx_7686 OWNER TO postgres;

--
-- Name: address_usa_tx_76861; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76861 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7686);


ALTER TABLE public.address_usa_tx_76861 OWNER TO postgres;

--
-- Name: address_usa_tx_76862; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76862 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7686);


ALTER TABLE public.address_usa_tx_76862 OWNER TO postgres;

--
-- Name: address_usa_tx_76864; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76864 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7686);


ALTER TABLE public.address_usa_tx_76864 OWNER TO postgres;

--
-- Name: address_usa_tx_76865; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76865 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7686);


ALTER TABLE public.address_usa_tx_76865 OWNER TO postgres;

--
-- Name: address_usa_tx_76866; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76866 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7686);


ALTER TABLE public.address_usa_tx_76866 OWNER TO postgres;

--
-- Name: address_usa_tx_7687; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7687 (
)
INHERITS (public.address_usa_tx_768);


ALTER TABLE public.address_usa_tx_7687 OWNER TO postgres;

--
-- Name: address_usa_tx_76870; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76870 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7687);


ALTER TABLE public.address_usa_tx_76870 OWNER TO postgres;

--
-- Name: address_usa_tx_76871; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76871 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7687);


ALTER TABLE public.address_usa_tx_76871 OWNER TO postgres;

--
-- Name: address_usa_tx_76872; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76872 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7687);


ALTER TABLE public.address_usa_tx_76872 OWNER TO postgres;

--
-- Name: address_usa_tx_76875; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76875 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7687);


ALTER TABLE public.address_usa_tx_76875 OWNER TO postgres;

--
-- Name: address_usa_tx_76877; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76877 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7687);


ALTER TABLE public.address_usa_tx_76877 OWNER TO postgres;

--
-- Name: address_usa_tx_76878; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76878 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7687);


ALTER TABLE public.address_usa_tx_76878 OWNER TO postgres;

--
-- Name: address_usa_tx_7688; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7688 (
)
INHERITS (public.address_usa_tx_768);


ALTER TABLE public.address_usa_tx_7688 OWNER TO postgres;

--
-- Name: address_usa_tx_76882; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76882 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7688);


ALTER TABLE public.address_usa_tx_76882 OWNER TO postgres;

--
-- Name: address_usa_tx_76884; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76884 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7688);


ALTER TABLE public.address_usa_tx_76884 OWNER TO postgres;

--
-- Name: address_usa_tx_76886; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76886 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7688);


ALTER TABLE public.address_usa_tx_76886 OWNER TO postgres;

--
-- Name: address_usa_tx_76887; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76887 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7688);


ALTER TABLE public.address_usa_tx_76887 OWNER TO postgres;

--
-- Name: address_usa_tx_7689; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7689 (
)
INHERITS (public.address_usa_tx_768);


ALTER TABLE public.address_usa_tx_7689 OWNER TO postgres;

--
-- Name: address_usa_tx_76890; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76890 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7689);


ALTER TABLE public.address_usa_tx_76890 OWNER TO postgres;

--
-- Name: address_usa_tx_769; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_769 (
)
INHERITS (public.address_usa_tx_76);


ALTER TABLE public.address_usa_tx_769 OWNER TO postgres;

--
-- Name: address_usa_tx_7690; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7690 (
)
INHERITS (public.address_usa_tx_769);


ALTER TABLE public.address_usa_tx_7690 OWNER TO postgres;

--
-- Name: address_usa_tx_76901; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76901 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76901 OWNER TO postgres;

--
-- Name: address_usa_tx_76902; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76902 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76902 OWNER TO postgres;

--
-- Name: address_usa_tx_76903; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76903 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76903 OWNER TO postgres;

--
-- Name: address_usa_tx_76904; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76904 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76904 OWNER TO postgres;

--
-- Name: address_usa_tx_76905; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76905 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76905 OWNER TO postgres;

--
-- Name: address_usa_tx_76906; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76906 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76906 OWNER TO postgres;

--
-- Name: address_usa_tx_76908; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76908 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76908 OWNER TO postgres;

--
-- Name: address_usa_tx_76909; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76909 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7690);


ALTER TABLE public.address_usa_tx_76909 OWNER TO postgres;

--
-- Name: address_usa_tx_7693; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7693 (
)
INHERITS (public.address_usa_tx_769);


ALTER TABLE public.address_usa_tx_7693 OWNER TO postgres;

--
-- Name: address_usa_tx_76930; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76930 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76930 OWNER TO postgres;

--
-- Name: address_usa_tx_76932; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76932 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76932 OWNER TO postgres;

--
-- Name: address_usa_tx_76933; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76933 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76933 OWNER TO postgres;

--
-- Name: address_usa_tx_76934; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76934 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76934 OWNER TO postgres;

--
-- Name: address_usa_tx_76935; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76935 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76935 OWNER TO postgres;

--
-- Name: address_usa_tx_76936; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76936 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76936 OWNER TO postgres;

--
-- Name: address_usa_tx_76937; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76937 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76937 OWNER TO postgres;

--
-- Name: address_usa_tx_76939; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76939 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7693);


ALTER TABLE public.address_usa_tx_76939 OWNER TO postgres;

--
-- Name: address_usa_tx_7694; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7694 (
)
INHERITS (public.address_usa_tx_769);


ALTER TABLE public.address_usa_tx_7694 OWNER TO postgres;

--
-- Name: address_usa_tx_76940; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76940 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7694);


ALTER TABLE public.address_usa_tx_76940 OWNER TO postgres;

--
-- Name: address_usa_tx_76941; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76941 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7694);


ALTER TABLE public.address_usa_tx_76941 OWNER TO postgres;

--
-- Name: address_usa_tx_76943; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76943 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7694);


ALTER TABLE public.address_usa_tx_76943 OWNER TO postgres;

--
-- Name: address_usa_tx_76945; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76945 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7694);


ALTER TABLE public.address_usa_tx_76945 OWNER TO postgres;

--
-- Name: address_usa_tx_7695; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7695 (
)
INHERITS (public.address_usa_tx_769);


ALTER TABLE public.address_usa_tx_7695 OWNER TO postgres;

--
-- Name: address_usa_tx_76950; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76950 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7695);


ALTER TABLE public.address_usa_tx_76950 OWNER TO postgres;

--
-- Name: address_usa_tx_76951; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76951 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7695);


ALTER TABLE public.address_usa_tx_76951 OWNER TO postgres;

--
-- Name: address_usa_tx_76957; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76957 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7695);


ALTER TABLE public.address_usa_tx_76957 OWNER TO postgres;

--
-- Name: address_usa_tx_76958; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76958 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7695);


ALTER TABLE public.address_usa_tx_76958 OWNER TO postgres;

--
-- Name: address_usa_tx_7698; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7698 (
)
INHERITS (public.address_usa_tx_769);


ALTER TABLE public.address_usa_tx_7698 OWNER TO postgres;

--
-- Name: address_usa_tx_76982; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_76982 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7698);


ALTER TABLE public.address_usa_tx_76982 OWNER TO postgres;

--
-- Name: address_usa_tx_77; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77 (
)
INHERITS (public.address_usa_tx_7);


ALTER TABLE public.address_usa_tx_77 OWNER TO postgres;

--
-- Name: address_usa_tx_770; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_770 (
)
INHERITS (public.address_usa_tx_77);


ALTER TABLE public.address_usa_tx_770 OWNER TO postgres;

--
-- Name: address_usa_tx_7700; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7700 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7700 OWNER TO postgres;

--
-- Name: address_usa_tx_77001; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77001 (
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77001 OWNER TO postgres;

--
-- Name: address_usa_tx_77002; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77002 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77002 OWNER TO postgres;

--
-- Name: address_usa_tx_77003; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77003 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77003 OWNER TO postgres;

--
-- Name: address_usa_tx_77004; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77004 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77004 OWNER TO postgres;

--
-- Name: address_usa_tx_77005; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77005 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77005 OWNER TO postgres;

--
-- Name: address_usa_tx_77006; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77006 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77006 OWNER TO postgres;

--
-- Name: address_usa_tx_77007; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77007 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77007 OWNER TO postgres;

--
-- Name: address_usa_tx_77008; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77008 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77008 OWNER TO postgres;

--
-- Name: address_usa_tx_77009; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77009 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7700);


ALTER TABLE public.address_usa_tx_77009 OWNER TO postgres;

--
-- Name: address_usa_tx_7701; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7701 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7701 OWNER TO postgres;

--
-- Name: address_usa_tx_77010; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77010 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77010 OWNER TO postgres;

--
-- Name: address_usa_tx_77011; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77011 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77011 OWNER TO postgres;

--
-- Name: address_usa_tx_77012; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77012 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77012 OWNER TO postgres;

--
-- Name: address_usa_tx_77013; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77013 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77013 OWNER TO postgres;

--
-- Name: address_usa_tx_77014; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77014 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77014 OWNER TO postgres;

--
-- Name: address_usa_tx_77015; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77015 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77015 OWNER TO postgres;

--
-- Name: address_usa_tx_77016; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77016 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77016 OWNER TO postgres;

--
-- Name: address_usa_tx_77017; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77017 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77017 OWNER TO postgres;

--
-- Name: address_usa_tx_77018; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77018 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77018 OWNER TO postgres;

--
-- Name: address_usa_tx_77019; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77019 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7701);


ALTER TABLE public.address_usa_tx_77019 OWNER TO postgres;

--
-- Name: address_usa_tx_7702; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7702 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7702 OWNER TO postgres;

--
-- Name: address_usa_tx_77020; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77020 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77020 OWNER TO postgres;

--
-- Name: address_usa_tx_77021; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77021 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77021 OWNER TO postgres;

--
-- Name: address_usa_tx_77022; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77022 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77022 OWNER TO postgres;

--
-- Name: address_usa_tx_77023; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77023 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77023 OWNER TO postgres;

--
-- Name: address_usa_tx_77024; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77024 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77024 OWNER TO postgres;

--
-- Name: address_usa_tx_77025; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77025 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77025 OWNER TO postgres;

--
-- Name: address_usa_tx_77026; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77026 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77026 OWNER TO postgres;

--
-- Name: address_usa_tx_77027; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77027 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77027 OWNER TO postgres;

--
-- Name: address_usa_tx_77028; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77028 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77028 OWNER TO postgres;

--
-- Name: address_usa_tx_77029; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77029 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7702);


ALTER TABLE public.address_usa_tx_77029 OWNER TO postgres;

--
-- Name: address_usa_tx_7703; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7703 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7703 OWNER TO postgres;

--
-- Name: address_usa_tx_77030; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77030 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77030 OWNER TO postgres;

--
-- Name: address_usa_tx_77031; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77031 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77031 OWNER TO postgres;

--
-- Name: address_usa_tx_77032; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77032 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77032 OWNER TO postgres;

--
-- Name: address_usa_tx_77033; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77033 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77033 OWNER TO postgres;

--
-- Name: address_usa_tx_77034; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77034 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77034 OWNER TO postgres;

--
-- Name: address_usa_tx_77035; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77035 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77035 OWNER TO postgres;

--
-- Name: address_usa_tx_77036; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77036 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77036 OWNER TO postgres;

--
-- Name: address_usa_tx_77037; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77037 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77037 OWNER TO postgres;

--
-- Name: address_usa_tx_77038; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77038 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77038 OWNER TO postgres;

--
-- Name: address_usa_tx_77039; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77039 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7703);


ALTER TABLE public.address_usa_tx_77039 OWNER TO postgres;

--
-- Name: address_usa_tx_7704; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7704 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7704 OWNER TO postgres;

--
-- Name: address_usa_tx_77040; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77040 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77040 OWNER TO postgres;

--
-- Name: address_usa_tx_77041; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77041 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77041 OWNER TO postgres;

--
-- Name: address_usa_tx_77042; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77042 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77042 OWNER TO postgres;

--
-- Name: address_usa_tx_77043; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77043 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77043 OWNER TO postgres;

--
-- Name: address_usa_tx_77044; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77044 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77044 OWNER TO postgres;

--
-- Name: address_usa_tx_77045; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77045 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77045 OWNER TO postgres;

--
-- Name: address_usa_tx_77046; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77046 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77046 OWNER TO postgres;

--
-- Name: address_usa_tx_77047; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77047 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77047 OWNER TO postgres;

--
-- Name: address_usa_tx_77048; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77048 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77048 OWNER TO postgres;

--
-- Name: address_usa_tx_77049; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77049 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7704);


ALTER TABLE public.address_usa_tx_77049 OWNER TO postgres;

--
-- Name: address_usa_tx_7705; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7705 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7705 OWNER TO postgres;

--
-- Name: address_usa_tx_77050; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77050 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77050 OWNER TO postgres;

--
-- Name: address_usa_tx_77051; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77051 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77051 OWNER TO postgres;

--
-- Name: address_usa_tx_77053; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77053 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77053 OWNER TO postgres;

--
-- Name: address_usa_tx_77054; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77054 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77054 OWNER TO postgres;

--
-- Name: address_usa_tx_77055; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77055 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77055 OWNER TO postgres;

--
-- Name: address_usa_tx_77056; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77056 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77056 OWNER TO postgres;

--
-- Name: address_usa_tx_77057; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77057 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77057 OWNER TO postgres;

--
-- Name: address_usa_tx_77058; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77058 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77058 OWNER TO postgres;

--
-- Name: address_usa_tx_77059; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77059 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7705);


ALTER TABLE public.address_usa_tx_77059 OWNER TO postgres;

--
-- Name: address_usa_tx_7706; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7706 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7706 OWNER TO postgres;

--
-- Name: address_usa_tx_77060; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77060 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77060 OWNER TO postgres;

--
-- Name: address_usa_tx_77061; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77061 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77061 OWNER TO postgres;

--
-- Name: address_usa_tx_77062; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77062 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77062 OWNER TO postgres;

--
-- Name: address_usa_tx_77063; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77063 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77063 OWNER TO postgres;

--
-- Name: address_usa_tx_77064; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77064 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77064 OWNER TO postgres;

--
-- Name: address_usa_tx_77065; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77065 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77065 OWNER TO postgres;

--
-- Name: address_usa_tx_77066; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77066 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77066 OWNER TO postgres;

--
-- Name: address_usa_tx_77067; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77067 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77067 OWNER TO postgres;

--
-- Name: address_usa_tx_77068; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77068 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77068 OWNER TO postgres;

--
-- Name: address_usa_tx_77069; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77069 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7706);


ALTER TABLE public.address_usa_tx_77069 OWNER TO postgres;

--
-- Name: address_usa_tx_7707; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7707 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7707 OWNER TO postgres;

--
-- Name: address_usa_tx_77070; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77070 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77070 OWNER TO postgres;

--
-- Name: address_usa_tx_77071; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77071 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77071 OWNER TO postgres;

--
-- Name: address_usa_tx_77072; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77072 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77072 OWNER TO postgres;

--
-- Name: address_usa_tx_77073; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77073 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77073 OWNER TO postgres;

--
-- Name: address_usa_tx_77074; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77074 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77074 OWNER TO postgres;

--
-- Name: address_usa_tx_77075; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77075 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77075 OWNER TO postgres;

--
-- Name: address_usa_tx_77076; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77076 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77076 OWNER TO postgres;

--
-- Name: address_usa_tx_77077; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77077 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77077 OWNER TO postgres;

--
-- Name: address_usa_tx_77078; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77078 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77078 OWNER TO postgres;

--
-- Name: address_usa_tx_77079; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77079 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7707);


ALTER TABLE public.address_usa_tx_77079 OWNER TO postgres;

--
-- Name: address_usa_tx_7708; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7708 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7708 OWNER TO postgres;

--
-- Name: address_usa_tx_77080; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77080 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77080 OWNER TO postgres;

--
-- Name: address_usa_tx_77081; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77081 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77081 OWNER TO postgres;

--
-- Name: address_usa_tx_77082; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77082 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77082 OWNER TO postgres;

--
-- Name: address_usa_tx_77083; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77083 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77083 OWNER TO postgres;

--
-- Name: address_usa_tx_77084; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77084 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77084 OWNER TO postgres;

--
-- Name: address_usa_tx_77085; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77085 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77085 OWNER TO postgres;

--
-- Name: address_usa_tx_77086; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77086 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77086 OWNER TO postgres;

--
-- Name: address_usa_tx_77087; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77087 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77087 OWNER TO postgres;

--
-- Name: address_usa_tx_77088; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77088 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77088 OWNER TO postgres;

--
-- Name: address_usa_tx_77089; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77089 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7708);


ALTER TABLE public.address_usa_tx_77089 OWNER TO postgres;

--
-- Name: address_usa_tx_7709; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7709 (
)
INHERITS (public.address_usa_tx_770);


ALTER TABLE public.address_usa_tx_7709 OWNER TO postgres;

--
-- Name: address_usa_tx_77090; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77090 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77090 OWNER TO postgres;

--
-- Name: address_usa_tx_77091; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77091 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77091 OWNER TO postgres;

--
-- Name: address_usa_tx_77092; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77092 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77092 OWNER TO postgres;

--
-- Name: address_usa_tx_77093; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77093 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77093 OWNER TO postgres;

--
-- Name: address_usa_tx_77094; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77094 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77094 OWNER TO postgres;

--
-- Name: address_usa_tx_77095; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77095 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77095 OWNER TO postgres;

--
-- Name: address_usa_tx_77096; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77096 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77096 OWNER TO postgres;

--
-- Name: address_usa_tx_77098; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77098 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77098 OWNER TO postgres;

--
-- Name: address_usa_tx_77099; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77099 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7709);


ALTER TABLE public.address_usa_tx_77099 OWNER TO postgres;

--
-- Name: address_usa_tx_772; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_772 (
)
INHERITS (public.address_usa_tx_77);


ALTER TABLE public.address_usa_tx_772 OWNER TO postgres;

--
-- Name: address_usa_tx_7720; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7720 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7720 OWNER TO postgres;

--
-- Name: address_usa_tx_77201; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77201 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7720);


ALTER TABLE public.address_usa_tx_77201 OWNER TO postgres;

--
-- Name: address_usa_tx_77204; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77204 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7720);


ALTER TABLE public.address_usa_tx_77204 OWNER TO postgres;

--
-- Name: address_usa_tx_7721; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7721 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7721 OWNER TO postgres;

--
-- Name: address_usa_tx_77210; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77210 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7721);


ALTER TABLE public.address_usa_tx_77210 OWNER TO postgres;

--
-- Name: address_usa_tx_7722; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7722 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7722 OWNER TO postgres;

--
-- Name: address_usa_tx_77227; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77227 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7722);


ALTER TABLE public.address_usa_tx_77227 OWNER TO postgres;

--
-- Name: address_usa_tx_77229; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77229 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7722);


ALTER TABLE public.address_usa_tx_77229 OWNER TO postgres;

--
-- Name: address_usa_tx_7723; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7723 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7723 OWNER TO postgres;

--
-- Name: address_usa_tx_77236; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77236 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7723);


ALTER TABLE public.address_usa_tx_77236 OWNER TO postgres;

--
-- Name: address_usa_tx_7725; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7725 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7725 OWNER TO postgres;

--
-- Name: address_usa_tx_77251; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77251 (
)
INHERITS (public.address_usa_tx_7725);


ALTER TABLE public.address_usa_tx_77251 OWNER TO postgres;

--
-- Name: address_usa_tx_77253; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77253 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7725);


ALTER TABLE public.address_usa_tx_77253 OWNER TO postgres;

--
-- Name: address_usa_tx_77256; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77256 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7725);


ALTER TABLE public.address_usa_tx_77256 OWNER TO postgres;

--
-- Name: address_usa_tx_7726; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7726 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7726 OWNER TO postgres;

--
-- Name: address_usa_tx_77262; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77262 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7726);


ALTER TABLE public.address_usa_tx_77262 OWNER TO postgres;

--
-- Name: address_usa_tx_77265; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77265 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7726);


ALTER TABLE public.address_usa_tx_77265 OWNER TO postgres;

--
-- Name: address_usa_tx_77267; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77267 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7726);


ALTER TABLE public.address_usa_tx_77267 OWNER TO postgres;

--
-- Name: address_usa_tx_7727; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7727 (
)
INHERITS (public.address_usa_tx_772);


ALTER TABLE public.address_usa_tx_7727 OWNER TO postgres;

--
-- Name: address_usa_tx_77274; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77274 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7727);


ALTER TABLE public.address_usa_tx_77274 OWNER TO postgres;

--
-- Name: address_usa_tx_773; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_773 (
)
INHERITS (public.address_usa_tx_77);


ALTER TABLE public.address_usa_tx_773 OWNER TO postgres;

--
-- Name: address_usa_tx_7730; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7730 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7730 OWNER TO postgres;

--
-- Name: address_usa_tx_77301; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77301 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7730);


ALTER TABLE public.address_usa_tx_77301 OWNER TO postgres;

--
-- Name: address_usa_tx_77302; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77302 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7730);


ALTER TABLE public.address_usa_tx_77302 OWNER TO postgres;

--
-- Name: address_usa_tx_77303; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77303 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7730);


ALTER TABLE public.address_usa_tx_77303 OWNER TO postgres;

--
-- Name: address_usa_tx_77304; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77304 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7730);


ALTER TABLE public.address_usa_tx_77304 OWNER TO postgres;

--
-- Name: address_usa_tx_77305; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77305 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7730);


ALTER TABLE public.address_usa_tx_77305 OWNER TO postgres;

--
-- Name: address_usa_tx_77306; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77306 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7730);


ALTER TABLE public.address_usa_tx_77306 OWNER TO postgres;

--
-- Name: address_usa_tx_7731; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7731 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7731 OWNER TO postgres;

--
-- Name: address_usa_tx_77316; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77316 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7731);


ALTER TABLE public.address_usa_tx_77316 OWNER TO postgres;

--
-- Name: address_usa_tx_77318; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77318 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7731);


ALTER TABLE public.address_usa_tx_77318 OWNER TO postgres;

--
-- Name: address_usa_tx_7732; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7732 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7732 OWNER TO postgres;

--
-- Name: address_usa_tx_77320; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77320 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7732);


ALTER TABLE public.address_usa_tx_77320 OWNER TO postgres;

--
-- Name: address_usa_tx_77325; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77325 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7732);


ALTER TABLE public.address_usa_tx_77325 OWNER TO postgres;

--
-- Name: address_usa_tx_77326; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77326 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7732);


ALTER TABLE public.address_usa_tx_77326 OWNER TO postgres;

--
-- Name: address_usa_tx_77327; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77327 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7732);


ALTER TABLE public.address_usa_tx_77327 OWNER TO postgres;

--
-- Name: address_usa_tx_77328; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77328 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7732);


ALTER TABLE public.address_usa_tx_77328 OWNER TO postgres;

--
-- Name: address_usa_tx_7733; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7733 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7733 OWNER TO postgres;

--
-- Name: address_usa_tx_77331; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77331 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77331 OWNER TO postgres;

--
-- Name: address_usa_tx_77332; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77332 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77332 OWNER TO postgres;

--
-- Name: address_usa_tx_77333; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77333 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77333 OWNER TO postgres;

--
-- Name: address_usa_tx_77334; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77334 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77334 OWNER TO postgres;

--
-- Name: address_usa_tx_77335; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77335 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77335 OWNER TO postgres;

--
-- Name: address_usa_tx_77336; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77336 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77336 OWNER TO postgres;

--
-- Name: address_usa_tx_77337; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77337 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77337 OWNER TO postgres;

--
-- Name: address_usa_tx_77338; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77338 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77338 OWNER TO postgres;

--
-- Name: address_usa_tx_77339; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77339 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7733);


ALTER TABLE public.address_usa_tx_77339 OWNER TO postgres;

--
-- Name: address_usa_tx_7734; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7734 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7734 OWNER TO postgres;

--
-- Name: address_usa_tx_77340; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77340 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77340 OWNER TO postgres;

--
-- Name: address_usa_tx_77342; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77342 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77342 OWNER TO postgres;

--
-- Name: address_usa_tx_77343; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77343 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77343 OWNER TO postgres;

--
-- Name: address_usa_tx_77345; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77345 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77345 OWNER TO postgres;

--
-- Name: address_usa_tx_77346; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77346 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77346 OWNER TO postgres;

--
-- Name: address_usa_tx_77347; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77347 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77347 OWNER TO postgres;

--
-- Name: address_usa_tx_77348; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77348 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7734);


ALTER TABLE public.address_usa_tx_77348 OWNER TO postgres;

--
-- Name: address_usa_tx_7735; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7735 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7735 OWNER TO postgres;

--
-- Name: address_usa_tx_77350; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77350 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77350 OWNER TO postgres;

--
-- Name: address_usa_tx_77351; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77351 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77351 OWNER TO postgres;

--
-- Name: address_usa_tx_77353; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77353 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77353 OWNER TO postgres;

--
-- Name: address_usa_tx_77354; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77354 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77354 OWNER TO postgres;

--
-- Name: address_usa_tx_77355; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77355 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77355 OWNER TO postgres;

--
-- Name: address_usa_tx_77356; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77356 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77356 OWNER TO postgres;

--
-- Name: address_usa_tx_77357; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77357 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77357 OWNER TO postgres;

--
-- Name: address_usa_tx_77358; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77358 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77358 OWNER TO postgres;

--
-- Name: address_usa_tx_77359; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77359 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7735);


ALTER TABLE public.address_usa_tx_77359 OWNER TO postgres;

--
-- Name: address_usa_tx_7736; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7736 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7736 OWNER TO postgres;

--
-- Name: address_usa_tx_77362; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77362 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7736);


ALTER TABLE public.address_usa_tx_77362 OWNER TO postgres;

--
-- Name: address_usa_tx_77363; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77363 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7736);


ALTER TABLE public.address_usa_tx_77363 OWNER TO postgres;

--
-- Name: address_usa_tx_77365; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77365 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7736);


ALTER TABLE public.address_usa_tx_77365 OWNER TO postgres;

--
-- Name: address_usa_tx_77367; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77367 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7736);


ALTER TABLE public.address_usa_tx_77367 OWNER TO postgres;

--
-- Name: address_usa_tx_77368; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77368 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7736);


ALTER TABLE public.address_usa_tx_77368 OWNER TO postgres;

--
-- Name: address_usa_tx_77369; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77369 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7736);


ALTER TABLE public.address_usa_tx_77369 OWNER TO postgres;

--
-- Name: address_usa_tx_7737; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7737 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7737 OWNER TO postgres;

--
-- Name: address_usa_tx_77371; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77371 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77371 OWNER TO postgres;

--
-- Name: address_usa_tx_77372; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77372 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77372 OWNER TO postgres;

--
-- Name: address_usa_tx_77373; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77373 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77373 OWNER TO postgres;

--
-- Name: address_usa_tx_77375; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77375 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77375 OWNER TO postgres;

--
-- Name: address_usa_tx_77376; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77376 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77376 OWNER TO postgres;

--
-- Name: address_usa_tx_77377; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77377 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77377 OWNER TO postgres;

--
-- Name: address_usa_tx_77378; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77378 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77378 OWNER TO postgres;

--
-- Name: address_usa_tx_77379; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77379 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7737);


ALTER TABLE public.address_usa_tx_77379 OWNER TO postgres;

--
-- Name: address_usa_tx_7738; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7738 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7738 OWNER TO postgres;

--
-- Name: address_usa_tx_77380; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77380 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77380 OWNER TO postgres;

--
-- Name: address_usa_tx_77381; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77381 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77381 OWNER TO postgres;

--
-- Name: address_usa_tx_77382; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77382 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77382 OWNER TO postgres;

--
-- Name: address_usa_tx_77383; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77383 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77383 OWNER TO postgres;

--
-- Name: address_usa_tx_77384; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77384 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77384 OWNER TO postgres;

--
-- Name: address_usa_tx_77385; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77385 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77385 OWNER TO postgres;

--
-- Name: address_usa_tx_77386; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77386 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77386 OWNER TO postgres;

--
-- Name: address_usa_tx_77387; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77387 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77387 OWNER TO postgres;

--
-- Name: address_usa_tx_77388; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77388 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77388 OWNER TO postgres;

--
-- Name: address_usa_tx_77389; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77389 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7738);


ALTER TABLE public.address_usa_tx_77389 OWNER TO postgres;

--
-- Name: address_usa_tx_7739; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7739 (
)
INHERITS (public.address_usa_tx_773);


ALTER TABLE public.address_usa_tx_7739 OWNER TO postgres;

--
-- Name: address_usa_tx_77390; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77390 (
)
INHERITS (public.address_usa_tx_7739);


ALTER TABLE public.address_usa_tx_77390 OWNER TO postgres;

--
-- Name: address_usa_tx_77391; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77391 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7739);


ALTER TABLE public.address_usa_tx_77391 OWNER TO postgres;

--
-- Name: address_usa_tx_77393; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77393 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7739);


ALTER TABLE public.address_usa_tx_77393 OWNER TO postgres;

--
-- Name: address_usa_tx_77396; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77396 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7739);


ALTER TABLE public.address_usa_tx_77396 OWNER TO postgres;

--
-- Name: address_usa_tx_774; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_774 (
)
INHERITS (public.address_usa_tx_77);


ALTER TABLE public.address_usa_tx_774 OWNER TO postgres;

--
-- Name: address_usa_tx_7740; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7740 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7740 OWNER TO postgres;

--
-- Name: address_usa_tx_77401; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77401 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7740);


ALTER TABLE public.address_usa_tx_77401 OWNER TO postgres;

--
-- Name: address_usa_tx_77406; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77406 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7740);


ALTER TABLE public.address_usa_tx_77406 OWNER TO postgres;

--
-- Name: address_usa_tx_77407; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77407 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7740);


ALTER TABLE public.address_usa_tx_77407 OWNER TO postgres;

--
-- Name: address_usa_tx_7741; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7741 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7741 OWNER TO postgres;

--
-- Name: address_usa_tx_77411; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77411 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7741);


ALTER TABLE public.address_usa_tx_77411 OWNER TO postgres;

--
-- Name: address_usa_tx_77414; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77414 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7741);


ALTER TABLE public.address_usa_tx_77414 OWNER TO postgres;

--
-- Name: address_usa_tx_77415; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77415 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7741);


ALTER TABLE public.address_usa_tx_77415 OWNER TO postgres;

--
-- Name: address_usa_tx_77417; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77417 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7741);


ALTER TABLE public.address_usa_tx_77417 OWNER TO postgres;

--
-- Name: address_usa_tx_77418; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77418 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7741);


ALTER TABLE public.address_usa_tx_77418 OWNER TO postgres;

--
-- Name: address_usa_tx_77419; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77419 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7741);


ALTER TABLE public.address_usa_tx_77419 OWNER TO postgres;

--
-- Name: address_usa_tx_7742; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7742 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7742 OWNER TO postgres;

--
-- Name: address_usa_tx_77420; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77420 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7742);


ALTER TABLE public.address_usa_tx_77420 OWNER TO postgres;

--
-- Name: address_usa_tx_77422; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77422 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7742);


ALTER TABLE public.address_usa_tx_77422 OWNER TO postgres;

--
-- Name: address_usa_tx_77423; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77423 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7742);


ALTER TABLE public.address_usa_tx_77423 OWNER TO postgres;

--
-- Name: address_usa_tx_77427; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77427 (
)
INHERITS (public.address_usa_tx_7742);


ALTER TABLE public.address_usa_tx_77427 OWNER TO postgres;

--
-- Name: address_usa_tx_77429; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77429 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7742);


ALTER TABLE public.address_usa_tx_77429 OWNER TO postgres;

--
-- Name: address_usa_tx_7743; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7743 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7743 OWNER TO postgres;

--
-- Name: address_usa_tx_77430; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77430 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7743);


ALTER TABLE public.address_usa_tx_77430 OWNER TO postgres;

--
-- Name: address_usa_tx_77433; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77433 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7743);


ALTER TABLE public.address_usa_tx_77433 OWNER TO postgres;

--
-- Name: address_usa_tx_77434; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77434 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7743);


ALTER TABLE public.address_usa_tx_77434 OWNER TO postgres;

--
-- Name: address_usa_tx_77435; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77435 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7743);


ALTER TABLE public.address_usa_tx_77435 OWNER TO postgres;

--
-- Name: address_usa_tx_77436; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77436 (
)
INHERITS (public.address_usa_tx_7743);


ALTER TABLE public.address_usa_tx_77436 OWNER TO postgres;

--
-- Name: address_usa_tx_77437; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77437 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7743);


ALTER TABLE public.address_usa_tx_77437 OWNER TO postgres;

--
-- Name: address_usa_tx_7744; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7744 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7744 OWNER TO postgres;

--
-- Name: address_usa_tx_77440; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77440 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77440 OWNER TO postgres;

--
-- Name: address_usa_tx_77441; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77441 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77441 OWNER TO postgres;

--
-- Name: address_usa_tx_77442; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77442 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77442 OWNER TO postgres;

--
-- Name: address_usa_tx_77444; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77444 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77444 OWNER TO postgres;

--
-- Name: address_usa_tx_77445; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77445 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77445 OWNER TO postgres;

--
-- Name: address_usa_tx_77446; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77446 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77446 OWNER TO postgres;

--
-- Name: address_usa_tx_77447; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77447 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77447 OWNER TO postgres;

--
-- Name: address_usa_tx_77448; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77448 (
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77448 OWNER TO postgres;

--
-- Name: address_usa_tx_77449; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77449 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7744);


ALTER TABLE public.address_usa_tx_77449 OWNER TO postgres;

--
-- Name: address_usa_tx_7745; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7745 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7745 OWNER TO postgres;

--
-- Name: address_usa_tx_77450; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77450 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77450 OWNER TO postgres;

--
-- Name: address_usa_tx_77451; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77451 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77451 OWNER TO postgres;

--
-- Name: address_usa_tx_77453; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77453 (
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77453 OWNER TO postgres;

--
-- Name: address_usa_tx_77454; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77454 (
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77454 OWNER TO postgres;

--
-- Name: address_usa_tx_77455; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77455 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77455 OWNER TO postgres;

--
-- Name: address_usa_tx_77456; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77456 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77456 OWNER TO postgres;

--
-- Name: address_usa_tx_77457; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77457 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77457 OWNER TO postgres;

--
-- Name: address_usa_tx_77458; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77458 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77458 OWNER TO postgres;

--
-- Name: address_usa_tx_77459; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77459 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7745);


ALTER TABLE public.address_usa_tx_77459 OWNER TO postgres;

--
-- Name: address_usa_tx_7746; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7746 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7746 OWNER TO postgres;

--
-- Name: address_usa_tx_77460; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77460 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77460 OWNER TO postgres;

--
-- Name: address_usa_tx_77461; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77461 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77461 OWNER TO postgres;

--
-- Name: address_usa_tx_77462; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77462 (
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77462 OWNER TO postgres;

--
-- Name: address_usa_tx_77463; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77463 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77463 OWNER TO postgres;

--
-- Name: address_usa_tx_77464; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77464 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77464 OWNER TO postgres;

--
-- Name: address_usa_tx_77465; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77465 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77465 OWNER TO postgres;

--
-- Name: address_usa_tx_77466; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77466 (
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77466 OWNER TO postgres;

--
-- Name: address_usa_tx_77468; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77468 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77468 OWNER TO postgres;

--
-- Name: address_usa_tx_77469; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77469 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7746);


ALTER TABLE public.address_usa_tx_77469 OWNER TO postgres;

--
-- Name: address_usa_tx_7747; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7747 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7747 OWNER TO postgres;

--
-- Name: address_usa_tx_77471; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77471 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77471 OWNER TO postgres;

--
-- Name: address_usa_tx_77473; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77473 (
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77473 OWNER TO postgres;

--
-- Name: address_usa_tx_77474; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77474 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77474 OWNER TO postgres;

--
-- Name: address_usa_tx_77476; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77476 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77476 OWNER TO postgres;

--
-- Name: address_usa_tx_77477; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77477 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77477 OWNER TO postgres;

--
-- Name: address_usa_tx_77478; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77478 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77478 OWNER TO postgres;

--
-- Name: address_usa_tx_77479; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77479 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7747);


ALTER TABLE public.address_usa_tx_77479 OWNER TO postgres;

--
-- Name: address_usa_tx_7748; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7748 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7748 OWNER TO postgres;

--
-- Name: address_usa_tx_77480; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77480 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77480 OWNER TO postgres;

--
-- Name: address_usa_tx_77481; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77481 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77481 OWNER TO postgres;

--
-- Name: address_usa_tx_77483; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77483 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77483 OWNER TO postgres;

--
-- Name: address_usa_tx_77484; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77484 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77484 OWNER TO postgres;

--
-- Name: address_usa_tx_77485; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77485 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77485 OWNER TO postgres;

--
-- Name: address_usa_tx_77486; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77486 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77486 OWNER TO postgres;

--
-- Name: address_usa_tx_77487; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77487 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77487 OWNER TO postgres;

--
-- Name: address_usa_tx_77488; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77488 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77488 OWNER TO postgres;

--
-- Name: address_usa_tx_77489; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77489 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7748);


ALTER TABLE public.address_usa_tx_77489 OWNER TO postgres;

--
-- Name: address_usa_tx_7749; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7749 (
)
INHERITS (public.address_usa_tx_774);


ALTER TABLE public.address_usa_tx_7749 OWNER TO postgres;

--
-- Name: address_usa_tx_77493; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77493 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7749);


ALTER TABLE public.address_usa_tx_77493 OWNER TO postgres;

--
-- Name: address_usa_tx_77494; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77494 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7749);


ALTER TABLE public.address_usa_tx_77494 OWNER TO postgres;

--
-- Name: address_usa_tx_77496; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77496 (
)
INHERITS (public.address_usa_tx_7749);


ALTER TABLE public.address_usa_tx_77496 OWNER TO postgres;

--
-- Name: address_usa_tx_77498; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77498 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7749);


ALTER TABLE public.address_usa_tx_77498 OWNER TO postgres;

--
-- Name: address_usa_tx_775; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_775 (
)
INHERITS (public.address_usa_tx_77);


ALTER TABLE public.address_usa_tx_775 OWNER TO postgres;

--
-- Name: address_usa_tx_7750; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7750 (
)
INHERITS (public.address_usa_tx_775);


ALTER TABLE public.address_usa_tx_7750 OWNER TO postgres;

--
-- Name: address_usa_tx_77501; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77501 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77501 OWNER TO postgres;

--
-- Name: address_usa_tx_77502; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77502 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77502 OWNER TO postgres;

--
-- Name: address_usa_tx_77503; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77503 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77503 OWNER TO postgres;

--
-- Name: address_usa_tx_77504; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77504 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77504 OWNER TO postgres;

--
-- Name: address_usa_tx_77505; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77505 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77505 OWNER TO postgres;

--
-- Name: address_usa_tx_77506; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77506 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77506 OWNER TO postgres;

--
-- Name: address_usa_tx_77507; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77507 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7750);


ALTER TABLE public.address_usa_tx_77507 OWNER TO postgres;

--
-- Name: address_usa_tx_7751; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_7751 (
)
INHERITS (public.address_usa_tx_775);


ALTER TABLE public.address_usa_tx_7751 OWNER TO postgres;

--
-- Name: address_usa_tx_77510; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77510 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7751);


ALTER TABLE public.address_usa_tx_77510 OWNER TO postgres;

--
-- Name: address_usa_tx_77511; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77511 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer
)
INHERITS (public.address_usa_tx_7751);


ALTER TABLE public.address_usa_tx_77511 OWNER TO postgres;

--
-- Name: address_usa_tx_77512; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.address_usa_tx_77512 (
)
INHERITS (public.address_usa_tx_7751);


ALTER TABLE public.address_usa_tx_77512 OWNER TO postgres;

--
-- Name: address_usa_tx_77513; Type: TABLE; Schema: public; Owner: postgres
--

