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


ALTER TABLE public.address_usa_tx_77513 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77514 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77515 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77517 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77518 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77519 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7752 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77520 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77521 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77523 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77527 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7753 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77530 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77531 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77532 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77533 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77534 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77535 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77536 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77538 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77539 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7754 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77541 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77545 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77546 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77547 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77548 (
)
INHERITS (public.address_usa_tx_7754);


ALTER TABLE public.address_usa_tx_77548 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77549 (
)
INHERITS (public.address_usa_tx_7754);


ALTER TABLE public.address_usa_tx_77549 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_7755 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77550 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77551 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77552 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77553 (
)
INHERITS (public.address_usa_tx_7755);


ALTER TABLE public.address_usa_tx_77553 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77554 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77555 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7756 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77560 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77561 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77562 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77563 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77564 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77565 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77566 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77568 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7757 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77571 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77573 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77575 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77576 (
)
INHERITS (public.address_usa_tx_7757);


ALTER TABLE public.address_usa_tx_77576 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77577 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77578 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7758 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77580 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77581 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77582 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77583 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77584 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77585 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77586 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77587 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77588 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7759 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77590 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77591 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77592 (
)
INHERITS (public.address_usa_tx_7759);


ALTER TABLE public.address_usa_tx_77592 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77597 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77598 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_776 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7760 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7760 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77600 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7761 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7761 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77611 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77612 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77613 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77614 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77615 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77616 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77617 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77619 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7762 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7762 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77622 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77623 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77624 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77625 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77626 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77627 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77629 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7763 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7763 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77630 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77631 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77632 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77635 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77639 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7764 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7764 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77640 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77641 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77642 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77643 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77649 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7765 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7765 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77650 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77651 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77654 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77655 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77656 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77657 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77659 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7766 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7766 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77660 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77661 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77662 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77663 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77664 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77665 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77668 (
)
INHERITS (public.address_usa_tx_7766);


ALTER TABLE public.address_usa_tx_77668 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7767 (
)
INHERITS (public.address_usa_tx_776);


ALTER TABLE public.address_usa_tx_7767 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77670 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_777 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7770 (
)
INHERITS (public.address_usa_tx_777);


ALTER TABLE public.address_usa_tx_7770 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77700 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77701 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77702 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77703 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77704 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77705 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77706 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77707 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77708 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7771 (
)
INHERITS (public.address_usa_tx_777);


ALTER TABLE public.address_usa_tx_7771 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77713 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7772 (
)
INHERITS (public.address_usa_tx_777);


ALTER TABLE public.address_usa_tx_7772 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77720 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77723 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77725 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77726 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7777 (
)
INHERITS (public.address_usa_tx_777);


ALTER TABLE public.address_usa_tx_7777 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77777 (
)
INHERITS (public.address_usa_tx_7777);


ALTER TABLE public.address_usa_tx_77777 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_778 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7780 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7780 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77801 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77802 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77803 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77805 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77807 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7783 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7783 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77830 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77831 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77836 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77837 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77839 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7784 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7784 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77840 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77841 (
)
INHERITS (public.address_usa_tx_7784);


ALTER TABLE public.address_usa_tx_77841 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_77842 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77845 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7785 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7785 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77852 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77855 (
)
INHERITS (public.address_usa_tx_7785);


ALTER TABLE public.address_usa_tx_77855 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77856 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77857 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77858 (
)
INHERITS (public.address_usa_tx_7785);


ALTER TABLE public.address_usa_tx_77858 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_77859 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7786 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7786 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77861 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77862 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77863 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77864 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77865 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77867 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77868 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7787 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7787 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77870 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77871 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77872 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77873 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77875 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77876 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77878 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77879 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7788 (
)
INHERITS (public.address_usa_tx_778);


ALTER TABLE public.address_usa_tx_7788 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77880 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_779 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7790 (
)
INHERITS (public.address_usa_tx_779);


ALTER TABLE public.address_usa_tx_7790 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77901 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77903 (
)
INHERITS (public.address_usa_tx_7790);


ALTER TABLE public.address_usa_tx_77903 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77904 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77905 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7795 (
)
INHERITS (public.address_usa_tx_779);


ALTER TABLE public.address_usa_tx_7795 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77950 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77951 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77957 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7796 (
)
INHERITS (public.address_usa_tx_779);


ALTER TABLE public.address_usa_tx_7796 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77962 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77963 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77964 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77968 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7797 (
)
INHERITS (public.address_usa_tx_779);


ALTER TABLE public.address_usa_tx_7797 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77971 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_77972 (
)
INHERITS (public.address_usa_tx_7797);


ALTER TABLE public.address_usa_tx_77972 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77977 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77978 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77979 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7798 (
)
INHERITS (public.address_usa_tx_779);


ALTER TABLE public.address_usa_tx_7798 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77983 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7799 (
)
INHERITS (public.address_usa_tx_779);


ALTER TABLE public.address_usa_tx_7799 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77990 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77991 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77993 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77994 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_77995 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_780 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7800 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7800 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78001 (
)
INHERITS (public.address_usa_tx_7800);


ALTER TABLE public.address_usa_tx_78001 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78005 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7801 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7801 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78011 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78012 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78014 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78016 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78017 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78019 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7802 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7802 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78022 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78026 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7804 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7804 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78040 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78041 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78042 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78043 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78045 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78046 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7805 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7805 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78050 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78052 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78057 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78059 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7806 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7806 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78060 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78061 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78064 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78065 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78067 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7807 (
)
INHERITS (public.address_usa_tx_780);


ALTER TABLE public.address_usa_tx_7807 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78070 (
)
INHERITS (public.address_usa_tx_7807);


ALTER TABLE public.address_usa_tx_78070 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78071 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78072 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78076 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_781 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7810 (
)
INHERITS (public.address_usa_tx_781);


ALTER TABLE public.address_usa_tx_7810 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78102 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78104 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78107 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7811 (
)
INHERITS (public.address_usa_tx_781);


ALTER TABLE public.address_usa_tx_7811 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78116 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78118 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78119 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7812 (
)
INHERITS (public.address_usa_tx_781);


ALTER TABLE public.address_usa_tx_7812 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78122 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7814 (
)
INHERITS (public.address_usa_tx_781);


ALTER TABLE public.address_usa_tx_7814 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78140 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78141 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78142 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78145 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78146 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7815 (
)
INHERITS (public.address_usa_tx_781);


ALTER TABLE public.address_usa_tx_7815 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78151 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78159 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7816 (
)
INHERITS (public.address_usa_tx_781);


ALTER TABLE public.address_usa_tx_7816 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78162 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78163 (
)
INHERITS (public.address_usa_tx_7816);


ALTER TABLE public.address_usa_tx_78163 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_78164 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_782 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7820 (
)
INHERITS (public.address_usa_tx_782);


ALTER TABLE public.address_usa_tx_7820 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78201 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78202 (
)
INHERITS (public.address_usa_tx_7820);


ALTER TABLE public.address_usa_tx_78202 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7822 (
)
INHERITS (public.address_usa_tx_782);


ALTER TABLE public.address_usa_tx_7822 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78227 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7824 (
)
INHERITS (public.address_usa_tx_782);


ALTER TABLE public.address_usa_tx_7824 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78249 (
)
INHERITS (public.address_usa_tx_7824);


ALTER TABLE public.address_usa_tx_78249 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7825 (
)
INHERITS (public.address_usa_tx_782);


ALTER TABLE public.address_usa_tx_7825 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_tx_78255 (
)
INHERITS (public.address_usa_tx_7825);


ALTER TABLE public.address_usa_tx_78255 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_tx_78258 (
)
INHERITS (public.address_usa_tx_7825);


ALTER TABLE public.address_usa_tx_78258 OWNER TO phpuser;

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

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


ALTER TABLE public.address_usa_tx_783 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7833 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7833 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78330 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78332 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78333 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78335 (
)
INHERITS (public.address_usa_tx_7833);


ALTER TABLE public.address_usa_tx_78335 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78336 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78339 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7834 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7834 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78340 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78341 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78342 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78343 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78344 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78347 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78349 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7835 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7835 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78350 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78351 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78352 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78353 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78355 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78357 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78358 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78359 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7836 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7836 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78360 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78361 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78362 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78363 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78364 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78368 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78369 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7837 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7837 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78370 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78371 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78372 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78373 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78374 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78375 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78376 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78377 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78379 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7838 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7838 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78380 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78381 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78382 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78383 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78384 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78385 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78387 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78389 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7839 (
)
INHERITS (public.address_usa_tx_783);


ALTER TABLE public.address_usa_tx_7839 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78390 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78391 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78393 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_784 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7840 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78401 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78402 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78403 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78404 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78405 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78406 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78407 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78408 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78409 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7841 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78410 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78411 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78412 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78413 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78414 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78415 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78416 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78417 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78418 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78419 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7842 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78426 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78427 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7846 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78460 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78463 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78465 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78466 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78467 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78468 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_78469 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7847 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78470 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_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_78470 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_78471 (
    id bigint,
    address_1 character varying(100),
    address_2 character varying(100),
    city character varying(50),
    state character(2),
    zip character(5),
    zip_four character(4),
    first_1 character(1),
    first_2 character(2),
    first_3 character(3),
    first_4 character(4),
    first_5 character(5),
    first_6 character(6),
    first_7 character(7),
    first_8 character(8),
    first_9 character(9),
    street_id character varying(50),
    display_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_78471 OWNER TO postgres;

--
