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

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


ALTER TABLE public.address_usa_tx_78472 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78473 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78474 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78475 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78476 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78477 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78478 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7848 (
)
INHERITS (public.address_usa_tx_784);


ALTER TABLE public.address_usa_tx_7848 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78480 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_785 (
)
INHERITS (public.address_usa_tx_78);


ALTER TABLE public.address_usa_tx_785 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7850 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7850 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78501 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78502 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78503 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78504 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78505 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7851 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7851 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78516 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7852 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7852 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78520 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78521 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78522 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78523 (
)
INHERITS (public.address_usa_tx_7852);


ALTER TABLE public.address_usa_tx_78523 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78526 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7853 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7853 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78535 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78537 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78538 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78539 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7854 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7854 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78540 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78541 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78542 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78543 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78546 (
)
INHERITS (public.address_usa_tx_7854);


ALTER TABLE public.address_usa_tx_78546 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78547 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78548 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78549 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7855 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7855 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78550 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78551 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78552 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78553 (
)
INHERITS (public.address_usa_tx_7855);


ALTER TABLE public.address_usa_tx_78553 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78557 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78558 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78559 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7856 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7856 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78560 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78562 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78565 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78566 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78567 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78568 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78569 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7857 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7857 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78570 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78572 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78573 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78574 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78575 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78576 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78577 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78578 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78579 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7858 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7858 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78580 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78582 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78583 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78584 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78586 OWNER TO postgres;

--
-- Name: address_usa_tx_78588; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.address_usa_tx_78588 (
)
INHERITS (public.address_usa_tx_7858);


ALTER TABLE public.address_usa_tx_78588 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_78589 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7859 (
)
INHERITS (public.address_usa_tx_785);


ALTER TABLE public.address_usa_tx_7859 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78590 (
)
INHERITS (public.address_usa_tx_7859);


ALTER TABLE public.address_usa_tx_78590 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78592 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78593 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78594 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78595 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78596 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78597 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78598 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78599 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_786 (
)
INHERITS (public.address_usa_tx_78);


ALTER TABLE public.address_usa_tx_786 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7860 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7860 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78604 OWNER TO postgres;

--
-- Name: address_usa_tx_78606; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.address_usa_tx_78606 (
)
INHERITS (public.address_usa_tx_7860);


ALTER TABLE public.address_usa_tx_78606 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_tx_78608 (
)
INHERITS (public.address_usa_tx_7860);


ALTER TABLE public.address_usa_tx_78608 OWNER TO postgres;

--
-- Name: address_usa_tx_78609; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.address_usa_tx_78609 (
)
INHERITS (public.address_usa_tx_7860);


ALTER TABLE public.address_usa_tx_78609 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_tx_7861 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7861 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78615 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7862 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7862 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78620 (
)
INHERITS (public.address_usa_tx_7862);


ALTER TABLE public.address_usa_tx_78620 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78621 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78624 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78626 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78627 (
)
INHERITS (public.address_usa_tx_7862);


ALTER TABLE public.address_usa_tx_78627 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78628 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78629 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7863 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7863 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78633 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78634 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78638 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7864 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7864 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78642 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78644 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78648 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7865 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7865 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78650 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78651 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78653 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78657 (
)
INHERITS (public.address_usa_tx_7865);


ALTER TABLE public.address_usa_tx_78657 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78658 (
)
INHERITS (public.address_usa_tx_7865);


ALTER TABLE public.address_usa_tx_78658 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7866 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7866 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78660 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78664 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78665 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78667 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7867 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7867 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78674 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7868 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7868 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78680 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78681 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7869 (
)
INHERITS (public.address_usa_tx_786);


ALTER TABLE public.address_usa_tx_7869 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78691 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_787 (
)
INHERITS (public.address_usa_tx_78);


ALTER TABLE public.address_usa_tx_787 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7870 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7870 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78701 (
)
INHERITS (public.address_usa_tx_7870);


ALTER TABLE public.address_usa_tx_78701 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78703 (
)
INHERITS (public.address_usa_tx_7870);


ALTER TABLE public.address_usa_tx_78703 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78704 (
)
INHERITS (public.address_usa_tx_7870);


ALTER TABLE public.address_usa_tx_78704 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78705 (
)
INHERITS (public.address_usa_tx_7870);


ALTER TABLE public.address_usa_tx_78705 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7871 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7871 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78717 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78718 (
)
INHERITS (public.address_usa_tx_7871);


ALTER TABLE public.address_usa_tx_78718 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78719 (
)
INHERITS (public.address_usa_tx_7871);


ALTER TABLE public.address_usa_tx_78719 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7872 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7872 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78721 (
)
INHERITS (public.address_usa_tx_7872);


ALTER TABLE public.address_usa_tx_78721 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78723 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78725 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78726 (
)
INHERITS (public.address_usa_tx_7872);


ALTER TABLE public.address_usa_tx_78726 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78727 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78728 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78729 (
)
INHERITS (public.address_usa_tx_7872);


ALTER TABLE public.address_usa_tx_78729 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7873 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7873 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78731 (
)
INHERITS (public.address_usa_tx_7873);


ALTER TABLE public.address_usa_tx_78731 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78734 (
)
INHERITS (public.address_usa_tx_7873);


ALTER TABLE public.address_usa_tx_78734 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78735 (
)
INHERITS (public.address_usa_tx_7873);


ALTER TABLE public.address_usa_tx_78735 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78737 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78738 (
)
INHERITS (public.address_usa_tx_7873);


ALTER TABLE public.address_usa_tx_78738 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7874 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7874 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78741 (
)
INHERITS (public.address_usa_tx_7874);


ALTER TABLE public.address_usa_tx_78741 OWNER TO postgres;

--
-- Name: address_usa_tx_78745; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.address_usa_tx_78745 (
)
INHERITS (public.address_usa_tx_7874);


ALTER TABLE public.address_usa_tx_78745 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_78746 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78748 (
)
INHERITS (public.address_usa_tx_7874);


ALTER TABLE public.address_usa_tx_78748 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7875 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7875 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78750 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78751 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78752 (
)
INHERITS (public.address_usa_tx_7875);


ALTER TABLE public.address_usa_tx_78752 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78753 (
)
INHERITS (public.address_usa_tx_7875);


ALTER TABLE public.address_usa_tx_78753 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78756 (
)
INHERITS (public.address_usa_tx_7875);


ALTER TABLE public.address_usa_tx_78756 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78757 (
)
INHERITS (public.address_usa_tx_7875);


ALTER TABLE public.address_usa_tx_78757 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78758 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78759 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7876 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7876 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78761 (
)
INHERITS (public.address_usa_tx_7876);


ALTER TABLE public.address_usa_tx_78761 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78766 (
)
INHERITS (public.address_usa_tx_7876);


ALTER TABLE public.address_usa_tx_78766 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78767 (
)
INHERITS (public.address_usa_tx_7876);


ALTER TABLE public.address_usa_tx_78767 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7878 (
)
INHERITS (public.address_usa_tx_787);


ALTER TABLE public.address_usa_tx_7878 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78785 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_788 (
)
INHERITS (public.address_usa_tx_78);


ALTER TABLE public.address_usa_tx_788 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7880 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7880 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78801 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7882 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7882 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78827 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78828 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7883 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7883 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78830 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78832 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78833 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78834 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78836 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78837 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78839 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7884 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7884 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78840 OWNER TO postgres;

--
-- Name: address_usa_tx_78841; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.address_usa_tx_78841 (
)
INHERITS (public.address_usa_tx_7884);


ALTER TABLE public.address_usa_tx_78841 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_78843 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7885 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7885 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78851 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78852 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78853 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7886 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7886 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78860 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7887 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7887 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78870 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78872 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78873 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78875 (
)
INHERITS (public.address_usa_tx_7887);


ALTER TABLE public.address_usa_tx_78875 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78877 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7888 (
)
INHERITS (public.address_usa_tx_788);


ALTER TABLE public.address_usa_tx_7888 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78880 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78881 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_789 (
)
INHERITS (public.address_usa_tx_78);


ALTER TABLE public.address_usa_tx_789 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7893 (
)
INHERITS (public.address_usa_tx_789);


ALTER TABLE public.address_usa_tx_7893 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78933 (
)
INHERITS (public.address_usa_tx_7893);


ALTER TABLE public.address_usa_tx_78933 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78934 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78935 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7894 (
)
INHERITS (public.address_usa_tx_789);


ALTER TABLE public.address_usa_tx_7894 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78943 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_790 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_790 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7903 (
)
INHERITS (public.address_usa_tx_790);


ALTER TABLE public.address_usa_tx_7903 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79039 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7906 (
)
INHERITS (public.address_usa_tx_790);


ALTER TABLE public.address_usa_tx_7906 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79068 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7907 (
)
INHERITS (public.address_usa_tx_790);


ALTER TABLE public.address_usa_tx_7907 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79079 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7908 (
)
INHERITS (public.address_usa_tx_790);


ALTER TABLE public.address_usa_tx_7908 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79082 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7909 (
)
INHERITS (public.address_usa_tx_790);


ALTER TABLE public.address_usa_tx_7909 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79095 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79097 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_791 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_791 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7912 (
)
INHERITS (public.address_usa_tx_791);


ALTER TABLE public.address_usa_tx_7912 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79124 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_792 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_792 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7920 (
)
INHERITS (public.address_usa_tx_792);


ALTER TABLE public.address_usa_tx_7920 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79201 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7922 (
)
INHERITS (public.address_usa_tx_792);


ALTER TABLE public.address_usa_tx_7922 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79220 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79225 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79226 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79227 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79229 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7923 (
)
INHERITS (public.address_usa_tx_792);


ALTER TABLE public.address_usa_tx_7923 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79230 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79233 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79234 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79237 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79239 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7924 (
)
INHERITS (public.address_usa_tx_792);


ALTER TABLE public.address_usa_tx_7924 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79240 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79243 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79244 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79245 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79247 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79248 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7925 (
)
INHERITS (public.address_usa_tx_792);


ALTER TABLE public.address_usa_tx_7925 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_79250 (
)
INHERITS (public.address_usa_tx_7925);


ALTER TABLE public.address_usa_tx_79250 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79252 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79255 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79256 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79257 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79259 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7926 (
)
INHERITS (public.address_usa_tx_792);


ALTER TABLE public.address_usa_tx_7926 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79261 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_793 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_793 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7933 (
)
INHERITS (public.address_usa_tx_793);


ALTER TABLE public.address_usa_tx_7933 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79331 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7935 (
)
INHERITS (public.address_usa_tx_793);


ALTER TABLE public.address_usa_tx_7935 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79351 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79358 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7937 (
)
INHERITS (public.address_usa_tx_793);


ALTER TABLE public.address_usa_tx_7937 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79370 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_794 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_794 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7941 (
)
INHERITS (public.address_usa_tx_794);


ALTER TABLE public.address_usa_tx_7941 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_79414 (
)
INHERITS (public.address_usa_tx_7941);


ALTER TABLE public.address_usa_tx_79414 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_795 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_795 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7950 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7950 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79501 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79502 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79503 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79504 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79505 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79506 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79508 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7951 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7951 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79510 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79511 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79512 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79515 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79516 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79518 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7952 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7952 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79520 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79521 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79525 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79526 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79527 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79528 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79529 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7953 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7953 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79530 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79532 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79533 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79534 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79535 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79536 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79539 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7954 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7954 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79540 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79541 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79543 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79544 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79545 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79546 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79547 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79548 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79549 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7955 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7955 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79550 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79553 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79556 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7956 (
)
INHERITS (public.address_usa_tx_795);


ALTER TABLE public.address_usa_tx_7956 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79560 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79561 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79562 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79563 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79565 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79566 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79567 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_796 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_796 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7960 (
)
INHERITS (public.address_usa_tx_796);


ALTER TABLE public.address_usa_tx_7960 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79601 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79602 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79603 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79604 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79605 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79606 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79607 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79608 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7962 (
)
INHERITS (public.address_usa_tx_796);


ALTER TABLE public.address_usa_tx_7962 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_79625 (
)
INHERITS (public.address_usa_tx_7962);


ALTER TABLE public.address_usa_tx_79625 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7963 (
)
INHERITS (public.address_usa_tx_796);


ALTER TABLE public.address_usa_tx_7963 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79632 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7969 (
)
INHERITS (public.address_usa_tx_796);


ALTER TABLE public.address_usa_tx_7969 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79698 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_79699 (
)
INHERITS (public.address_usa_tx_7969);


ALTER TABLE public.address_usa_tx_79699 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_797 (
)
INHERITS (public.address_usa_tx_79);


ALTER TABLE public.address_usa_tx_797 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7970 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7970 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79701 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79702 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79703 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79704 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79705 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79706 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79707 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79708 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_79709 (
)
INHERITS (public.address_usa_tx_7970);


ALTER TABLE public.address_usa_tx_79709 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7971 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7971 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79710 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79711 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79712 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79713 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79714 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79718 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79719 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7972 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7972 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79720 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79721 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79726 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7973 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7973 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79730 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79731 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79732 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79733 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79734 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79735 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79738 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79739 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7974 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7974 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79741 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79742 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79743 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79744 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79745 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79747 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79748 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79749 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7975 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7975 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79751 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79752 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79754 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79755 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79756 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79758 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79759 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7976 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7976 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79760 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79761 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79762 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79763 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79764 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79765 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79766 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79767 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79768 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7977 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7977 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79770 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79772 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79776 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79777 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79778 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7978 (
)
INHERITS (public.address_usa_tx_797);


ALTER TABLE public.address_usa_tx_7978 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_79780 OWNER TO postgres;

--
