CREATE TABLE public.address_usa_pa_1908 (
)
INHERITS (public.address_usa_pa_190);


ALTER TABLE public.address_usa_pa_1908 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19081 (
)
INHERITS (public.address_usa_pa_1908);


ALTER TABLE public.address_usa_pa_19081 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19082 (
)
INHERITS (public.address_usa_pa_1908);


ALTER TABLE public.address_usa_pa_19082 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19083 (
)
INHERITS (public.address_usa_pa_1908);


ALTER TABLE public.address_usa_pa_19083 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19085 (
)
INHERITS (public.address_usa_pa_1908);


ALTER TABLE public.address_usa_pa_19085 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19086 (
)
INHERITS (public.address_usa_pa_1908);


ALTER TABLE public.address_usa_pa_19086 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19087 (
)
INHERITS (public.address_usa_pa_1908);


ALTER TABLE public.address_usa_pa_19087 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1909 (
)
INHERITS (public.address_usa_pa_190);


ALTER TABLE public.address_usa_pa_1909 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19090 (
)
INHERITS (public.address_usa_pa_1909);


ALTER TABLE public.address_usa_pa_19090 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19094 (
)
INHERITS (public.address_usa_pa_1909);


ALTER TABLE public.address_usa_pa_19094 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_19095 (
)
INHERITS (public.address_usa_pa_1909);


ALTER TABLE public.address_usa_pa_19095 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19096 (
)
INHERITS (public.address_usa_pa_1909);


ALTER TABLE public.address_usa_pa_19096 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_191 (
)
INHERITS (public.address_usa_pa_19);


ALTER TABLE public.address_usa_pa_191 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1910 (
)
INHERITS (public.address_usa_pa_191);


ALTER TABLE public.address_usa_pa_1910 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19102 (
)
INHERITS (public.address_usa_pa_1910);


ALTER TABLE public.address_usa_pa_19102 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19103 (
)
INHERITS (public.address_usa_pa_1910);


ALTER TABLE public.address_usa_pa_19103 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19104 (
)
INHERITS (public.address_usa_pa_1910);


ALTER TABLE public.address_usa_pa_19104 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19106 (
)
INHERITS (public.address_usa_pa_1910);


ALTER TABLE public.address_usa_pa_19106 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_19107 (
)
INHERITS (public.address_usa_pa_1910);


ALTER TABLE public.address_usa_pa_19107 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1911 (
)
INHERITS (public.address_usa_pa_191);


ALTER TABLE public.address_usa_pa_1911 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19111 (
)
INHERITS (public.address_usa_pa_1911);


ALTER TABLE public.address_usa_pa_19111 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19114 (
)
INHERITS (public.address_usa_pa_1911);


ALTER TABLE public.address_usa_pa_19114 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19115 (
)
INHERITS (public.address_usa_pa_1911);


ALTER TABLE public.address_usa_pa_19115 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19116 (
)
INHERITS (public.address_usa_pa_1911);


ALTER TABLE public.address_usa_pa_19116 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19118 (
)
INHERITS (public.address_usa_pa_1911);


ALTER TABLE public.address_usa_pa_19118 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19119 (
)
INHERITS (public.address_usa_pa_1911);


ALTER TABLE public.address_usa_pa_19119 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1912 (
)
INHERITS (public.address_usa_pa_191);


ALTER TABLE public.address_usa_pa_1912 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19120 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19120 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19121 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19121 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19122 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19122 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19123 (
)
INHERITS (public.address_usa_pa);


ALTER TABLE public.address_usa_pa_19123 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19124 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19124 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19125 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19125 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19126 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19126 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19127 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19127 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19128 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19128 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19129 (
)
INHERITS (public.address_usa_pa_1912);


ALTER TABLE public.address_usa_pa_19129 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_1913 (
)
INHERITS (public.address_usa_pa_191);


ALTER TABLE public.address_usa_pa_1913 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19130 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19130 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19131 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19131 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19132 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19132 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19134 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19134 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19135 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19135 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19136 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19136 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19137 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19137 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19138 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19138 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19139 (
)
INHERITS (public.address_usa_pa_1913);


ALTER TABLE public.address_usa_pa_19139 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1914 (
)
INHERITS (public.address_usa_pa_191);


ALTER TABLE public.address_usa_pa_1914 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19140 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19140 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19141 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19141 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19142 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19142 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19143 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19143 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19144 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19144 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19145 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19145 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19146 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19146 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19147 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19147 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19148 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19148 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19149 (
)
INHERITS (public.address_usa_pa_1914);


ALTER TABLE public.address_usa_pa_19149 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1915 (
)
INHERITS (public.address_usa_pa_191);


ALTER TABLE public.address_usa_pa_1915 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19150 (
)
INHERITS (public.address_usa_pa_1915);


ALTER TABLE public.address_usa_pa_19150 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19151 (
)
INHERITS (public.address_usa_pa_1915);


ALTER TABLE public.address_usa_pa_19151 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19152 (
)
INHERITS (public.address_usa_pa_1915);


ALTER TABLE public.address_usa_pa_19152 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19153 (
)
INHERITS (public.address_usa_pa_1915);


ALTER TABLE public.address_usa_pa_19153 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19154 (
)
INHERITS (public.address_usa_pa_1915);


ALTER TABLE public.address_usa_pa_19154 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_193 (
)
INHERITS (public.address_usa_pa_19);


ALTER TABLE public.address_usa_pa_193 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1930 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1930 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19301 (
)
INHERITS (public.address_usa_pa_1930);


ALTER TABLE public.address_usa_pa_19301 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1931 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1931 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19310 (
)
INHERITS (public.address_usa_pa_1931);


ALTER TABLE public.address_usa_pa_19310 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19311 (
)
INHERITS (public.address_usa_pa_1931);


ALTER TABLE public.address_usa_pa_19311 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19312 (
)
INHERITS (public.address_usa_pa_1931);


ALTER TABLE public.address_usa_pa_19312 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19317 (
)
INHERITS (public.address_usa_pa_1931);


ALTER TABLE public.address_usa_pa_19317 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1932 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1932 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19320 (
)
INHERITS (public.address_usa_pa_1932);


ALTER TABLE public.address_usa_pa_19320 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1933 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1933 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19330 (
)
INHERITS (public.address_usa_pa_1933);


ALTER TABLE public.address_usa_pa_19330 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_19333 (
)
INHERITS (public.address_usa_pa_1933);


ALTER TABLE public.address_usa_pa_19333 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19335 (
)
INHERITS (public.address_usa_pa_1933);


ALTER TABLE public.address_usa_pa_19335 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1934 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1934 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19341 (
)
INHERITS (public.address_usa_pa_1934);


ALTER TABLE public.address_usa_pa_19341 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19342 (
)
INHERITS (public.address_usa_pa_1934);


ALTER TABLE public.address_usa_pa_19342 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19343 (
)
INHERITS (public.address_usa_pa_1934);


ALTER TABLE public.address_usa_pa_19343 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19344 (
)
INHERITS (public.address_usa_pa_1934);


ALTER TABLE public.address_usa_pa_19344 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19348 (
)
INHERITS (public.address_usa_pa_1934);


ALTER TABLE public.address_usa_pa_19348 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1935 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1935 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19350 (
)
INHERITS (public.address_usa_pa_1935);


ALTER TABLE public.address_usa_pa_19350 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19352 (
)
INHERITS (public.address_usa_pa_1935);


ALTER TABLE public.address_usa_pa_19352 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19355 (
)
INHERITS (public.address_usa_pa_1935);


ALTER TABLE public.address_usa_pa_19355 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1936 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1936 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19362 (
)
INHERITS (public.address_usa_pa_1936);


ALTER TABLE public.address_usa_pa_19362 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19363 (
)
INHERITS (public.address_usa_pa_1936);


ALTER TABLE public.address_usa_pa_19363 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19365 (
)
INHERITS (public.address_usa_pa_1936);


ALTER TABLE public.address_usa_pa_19365 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1937 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1937 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19372 (
)
INHERITS (public.address_usa_pa_1937);


ALTER TABLE public.address_usa_pa_19372 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19373 (
)
INHERITS (public.address_usa_pa_1937);


ALTER TABLE public.address_usa_pa_19373 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1938 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1938 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19380 (
)
INHERITS (public.address_usa_pa_1938);


ALTER TABLE public.address_usa_pa_19380 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19382 (
)
INHERITS (public.address_usa_pa_1938);


ALTER TABLE public.address_usa_pa_19382 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1939 (
)
INHERITS (public.address_usa_pa_193);


ALTER TABLE public.address_usa_pa_1939 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19390 (
)
INHERITS (public.address_usa_pa_1939);


ALTER TABLE public.address_usa_pa_19390 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_194 (
)
INHERITS (public.address_usa_pa_19);


ALTER TABLE public.address_usa_pa_194 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1940 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1940 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19401 (
)
INHERITS (public.address_usa_pa_1940);


ALTER TABLE public.address_usa_pa_19401 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19403 (
)
INHERITS (public.address_usa_pa_1940);


ALTER TABLE public.address_usa_pa_19403 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19405 (
)
INHERITS (public.address_usa_pa_1940);


ALTER TABLE public.address_usa_pa_19405 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19406 (
)
INHERITS (public.address_usa_pa_1940);


ALTER TABLE public.address_usa_pa_19406 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19409 (
)
INHERITS (public.address_usa_pa_1940);


ALTER TABLE public.address_usa_pa_19409 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1942 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1942 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19422 (
)
INHERITS (public.address_usa_pa_1942);


ALTER TABLE public.address_usa_pa_19422 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19425 (
)
INHERITS (public.address_usa_pa_1942);


ALTER TABLE public.address_usa_pa_19425 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19426 (
)
INHERITS (public.address_usa_pa_1942);


ALTER TABLE public.address_usa_pa_19426 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19428 (
)
INHERITS (public.address_usa_pa_1942);


ALTER TABLE public.address_usa_pa_19428 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1943 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1943 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19437 (
)
INHERITS (public.address_usa_pa_1943);


ALTER TABLE public.address_usa_pa_19437 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19438 (
)
INHERITS (public.address_usa_pa_1943);


ALTER TABLE public.address_usa_pa_19438 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1944 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1944 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19440 (
)
INHERITS (public.address_usa_pa_1944);


ALTER TABLE public.address_usa_pa_19440 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19444 (
)
INHERITS (public.address_usa_pa_1944);


ALTER TABLE public.address_usa_pa_19444 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19446 (
)
INHERITS (public.address_usa_pa_1944);


ALTER TABLE public.address_usa_pa_19446 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1945 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1945 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19454 (
)
INHERITS (public.address_usa_pa_1945);


ALTER TABLE public.address_usa_pa_19454 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1946 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1946 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19460 (
)
INHERITS (public.address_usa_pa_1946);


ALTER TABLE public.address_usa_pa_19460 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19462 (
)
INHERITS (public.address_usa_pa_1946);


ALTER TABLE public.address_usa_pa_19462 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19464 (
)
INHERITS (public.address_usa_pa_1946);


ALTER TABLE public.address_usa_pa_19464 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19465 (
)
INHERITS (public.address_usa_pa_1946);


ALTER TABLE public.address_usa_pa_19465 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19468 (
)
INHERITS (public.address_usa_pa_1946);


ALTER TABLE public.address_usa_pa_19468 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1947 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1947 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19473 (
)
INHERITS (public.address_usa_pa_1947);


ALTER TABLE public.address_usa_pa_19473 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19475 (
)
INHERITS (public.address_usa_pa_1947);


ALTER TABLE public.address_usa_pa_19475 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1949 (
)
INHERITS (public.address_usa_pa_194);


ALTER TABLE public.address_usa_pa_1949 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19492 (
)
INHERITS (public.address_usa_pa_1949);


ALTER TABLE public.address_usa_pa_19492 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_195 (
)
INHERITS (public.address_usa_pa_19);


ALTER TABLE public.address_usa_pa_195 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1950 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1950 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19501 (
)
INHERITS (public.address_usa_pa_1950);


ALTER TABLE public.address_usa_pa_19501 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_19504 (
)
INHERITS (public.address_usa_pa_1950);


ALTER TABLE public.address_usa_pa_19504 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_19506 (
)
INHERITS (public.address_usa_pa_1950);


ALTER TABLE public.address_usa_pa_19506 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19507 (
)
INHERITS (public.address_usa_pa_1950);


ALTER TABLE public.address_usa_pa_19507 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19508 (
)
INHERITS (public.address_usa_pa_1950);


ALTER TABLE public.address_usa_pa_19508 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1951 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1951 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19510 (
)
INHERITS (public.address_usa_pa_1951);


ALTER TABLE public.address_usa_pa_19510 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19512 (
)
INHERITS (public.address_usa_pa_1951);


ALTER TABLE public.address_usa_pa_19512 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19518 (
)
INHERITS (public.address_usa_pa_1951);


ALTER TABLE public.address_usa_pa_19518 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1952 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1952 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19520 (
)
INHERITS (public.address_usa_pa_1952);


ALTER TABLE public.address_usa_pa_19520 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19522 (
)
INHERITS (public.address_usa_pa_1952);


ALTER TABLE public.address_usa_pa_19522 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19525 (
)
INHERITS (public.address_usa_pa_1952);


ALTER TABLE public.address_usa_pa_19525 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19526 (
)
INHERITS (public.address_usa_pa_1952);


ALTER TABLE public.address_usa_pa_19526 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1953 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1953 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19530 (
)
INHERITS (public.address_usa_pa_1953);


ALTER TABLE public.address_usa_pa_19530 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19533 (
)
INHERITS (public.address_usa_pa_1953);


ALTER TABLE public.address_usa_pa_19533 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19534 (
)
INHERITS (public.address_usa_pa_1953);


ALTER TABLE public.address_usa_pa_19534 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19539 (
)
INHERITS (public.address_usa_pa_1953);


ALTER TABLE public.address_usa_pa_19539 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1954 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1954 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19540 (
)
INHERITS (public.address_usa_pa_1954);


ALTER TABLE public.address_usa_pa_19540 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19541 (
)
INHERITS (public.address_usa_pa_1954);


ALTER TABLE public.address_usa_pa_19541 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19543 (
)
INHERITS (public.address_usa_pa_1954);


ALTER TABLE public.address_usa_pa_19543 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19547 (
)
INHERITS (public.address_usa_pa_1954);


ALTER TABLE public.address_usa_pa_19547 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1955 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1955 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19551 (
)
INHERITS (public.address_usa_pa_1955);


ALTER TABLE public.address_usa_pa_19551 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1956 (
)
INHERITS (public.address_usa_pa_195);


ALTER TABLE public.address_usa_pa_1956 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19565 (
)
INHERITS (public.address_usa_pa_1956);


ALTER TABLE public.address_usa_pa_19565 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19567 (
)
INHERITS (public.address_usa_pa_1956);


ALTER TABLE public.address_usa_pa_19567 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_196 (
)
INHERITS (public.address_usa_pa_19);


ALTER TABLE public.address_usa_pa_196 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1960 (
)
INHERITS (public.address_usa_pa_196);


ALTER TABLE public.address_usa_pa_1960 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19601 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19601 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19602 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19602 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19604 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19604 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19605 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19605 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19606 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19606 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19607 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19607 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19608 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19608 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19609 (
)
INHERITS (public.address_usa_pa_1960);


ALTER TABLE public.address_usa_pa_19609 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_1961 (
)
INHERITS (public.address_usa_pa_196);


ALTER TABLE public.address_usa_pa_1961 OWNER TO postgres;

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

CREATE TABLE public.address_usa_pa_19610 (
)
INHERITS (public.address_usa_pa_1961);


ALTER TABLE public.address_usa_pa_19610 OWNER TO phpuser;

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

CREATE TABLE public.address_usa_pa_19611 (
)
INHERITS (public.address_usa_pa_1961);


ALTER TABLE public.address_usa_pa_19611 OWNER TO postgres;

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

CREATE TABLE public.address_usa_ri (
)
INHERITS (public.address_usa);


ALTER TABLE public.address_usa_ri OWNER TO postgres;

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

CREATE TABLE public.address_usa_sc (
)
INHERITS (public.address_usa);


ALTER TABLE public.address_usa_sc OWNER TO postgres;

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

CREATE TABLE public.address_usa_sd (
)
INHERITS (public.address_usa);


ALTER TABLE public.address_usa_sd OWNER TO postgres;

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

CREATE TABLE public.address_usa_tn (
)
INHERITS (public.address_usa);


ALTER TABLE public.address_usa_tn OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx (
    display_address character varying(100),
    esiid character varying(50),
    premise_type character(1),
    tdsp character varying(50),
    tdsp_id integer,
    meter_read_cycle integer,
    meter_type character varying(10)
)
INHERITS (public.address_usa);


ALTER TABLE public.address_usa_tx OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_ (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_ OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_0 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_0 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_00 (
)
INHERITS (public.address_usa_tx_0);


ALTER TABLE public.address_usa_tx_00 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_000 (
)
INHERITS (public.address_usa_tx_00);


ALTER TABLE public.address_usa_tx_000 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_0000 (
)
INHERITS (public.address_usa_tx_000);


ALTER TABLE public.address_usa_tx_0000 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_01 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_01 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_02 (
)
INHERITS (public.address_usa_tx_0);


ALTER TABLE public.address_usa_tx_02 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_027 (
)
INHERITS (public.address_usa_tx_02);


ALTER TABLE public.address_usa_tx_027 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_0271 (
)
INHERITS (public.address_usa_tx_027);


ALTER TABLE public.address_usa_tx_0271 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_0279 (
)
INHERITS (public.address_usa_tx_027);


ALTER TABLE public.address_usa_tx_0279 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_03 (
)
INHERITS (public.address_usa_tx_0);


ALTER TABLE public.address_usa_tx_03 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_035 (
)
INHERITS (public.address_usa_tx_03);


ALTER TABLE public.address_usa_tx_035 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_0355 (
)
INHERITS (public.address_usa_tx_035);


ALTER TABLE public.address_usa_tx_0355 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_05 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_05 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_07 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_07 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_1 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_1 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_10 (
)
INHERITS (public.address_usa_tx_1);


ALTER TABLE public.address_usa_tx_10 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_100 (
)
INHERITS (public.address_usa_tx_10);


ALTER TABLE public.address_usa_tx_100 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_1000 (
)
INHERITS (public.address_usa_tx_100);


ALTER TABLE public.address_usa_tx_1000 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_11 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_11 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_12 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_12 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_14 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_14 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_15 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_15 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_16 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_16 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_160 (
)
INHERITS (public.address_usa_tx_16);


ALTER TABLE public.address_usa_tx_160 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_1600 (
)
INHERITS (public.address_usa_tx_160);


ALTER TABLE public.address_usa_tx_1600 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_20 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_20 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_21 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_21 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_3 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_3 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_30 (
)
INHERITS (public.address_usa_tx_3);


ALTER TABLE public.address_usa_tx_30 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_300 (
)
INHERITS (public.address_usa_tx_30);


ALTER TABLE public.address_usa_tx_300 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_3000 (
)
INHERITS (public.address_usa_tx_300);


ALTER TABLE public.address_usa_tx_3000 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_31 (
)
INHERITS (public.address_usa_tx_3);


ALTER TABLE public.address_usa_tx_31 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_319 (
)
INHERITS (public.address_usa_tx_31);


ALTER TABLE public.address_usa_tx_319 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_3195 (
)
INHERITS (public.address_usa_tx_319);


ALTER TABLE public.address_usa_tx_3195 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_4 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_41 (
)
INHERITS (public.address_usa_tx_4);


ALTER TABLE public.address_usa_tx_41 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_411 (
)
INHERITS (public.address_usa_tx_41);


ALTER TABLE public.address_usa_tx_411 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4115 (
)
INHERITS (public.address_usa_tx_411);


ALTER TABLE public.address_usa_tx_4115 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_42 (
)
INHERITS (public.address_usa_tx_4);


ALTER TABLE public.address_usa_tx_42 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_423 (
)
INHERITS (public.address_usa_tx_42);


ALTER TABLE public.address_usa_tx_423 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4231 (
)
INHERITS (public.address_usa_tx_423);


ALTER TABLE public.address_usa_tx_4231 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_43 (
)
INHERITS (public.address_usa_tx_4);


ALTER TABLE public.address_usa_tx_43 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_432 (
)
INHERITS (public.address_usa_tx_43);


ALTER TABLE public.address_usa_tx_432 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4321 (
)
INHERITS (public.address_usa_tx_432);


ALTER TABLE public.address_usa_tx_4321 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_44 (
)
INHERITS (public.address_usa_tx_4);


ALTER TABLE public.address_usa_tx_44 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_447 (
)
INHERITS (public.address_usa_tx_44);


ALTER TABLE public.address_usa_tx_447 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4470 (
)
INHERITS (public.address_usa_tx_447);


ALTER TABLE public.address_usa_tx_4470 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_45 (
)
INHERITS (public.address_usa_tx_4);


ALTER TABLE public.address_usa_tx_45 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_450 (
)
INHERITS (public.address_usa_tx_45);


ALTER TABLE public.address_usa_tx_450 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4503 (
)
INHERITS (public.address_usa_tx_450);


ALTER TABLE public.address_usa_tx_4503 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_456 (
)
INHERITS (public.address_usa_tx_45);


ALTER TABLE public.address_usa_tx_456 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4567 (
)
INHERITS (public.address_usa_tx_456);


ALTER TABLE public.address_usa_tx_4567 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_457 (
)
INHERITS (public.address_usa_tx_45);


ALTER TABLE public.address_usa_tx_457 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4575 (
)
INHERITS (public.address_usa_tx_457);


ALTER TABLE public.address_usa_tx_4575 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_459 (
)
INHERITS (public.address_usa_tx_45);


ALTER TABLE public.address_usa_tx_459 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_4594 (
)
INHERITS (public.address_usa_tx_459);


ALTER TABLE public.address_usa_tx_4594 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_5 (
)
INHERITS (public.address_usa_tx);


ALTER TABLE public.address_usa_tx_5 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_55 (
)
INHERITS (public.address_usa_tx_5);


ALTER TABLE public.address_usa_tx_55 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_557 (
)
INHERITS (public.address_usa_tx_55);


ALTER TABLE public.address_usa_tx_557 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_5570 (
)
INHERITS (public.address_usa_tx_557);


ALTER TABLE public.address_usa_tx_5570 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_56 (
)
INHERITS (public.address_usa_tx_5);


ALTER TABLE public.address_usa_tx_56 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_565 (
)
INHERITS (public.address_usa_tx_56);


ALTER TABLE public.address_usa_tx_565 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_5650 (
)
INHERITS (public.address_usa_tx_565);


ALTER TABLE public.address_usa_tx_5650 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_59 (
)
INHERITS (public.address_usa_tx_5);


ALTER TABLE public.address_usa_tx_59 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_596 (
)
INHERITS (public.address_usa_tx_59);


ALTER TABLE public.address_usa_tx_596 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_5968 (
)
INHERITS (public.address_usa_tx_596);


ALTER TABLE public.address_usa_tx_5968 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_7 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_70 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_706 (
)
INHERITS (public.address_usa_tx_70);


ALTER TABLE public.address_usa_tx_706 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7060 (
)
INHERITS (public.address_usa_tx_706);


ALTER TABLE public.address_usa_tx_7060 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_70601 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7063 (
)
INHERITS (public.address_usa_tx_706);


ALTER TABLE public.address_usa_tx_7063 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_70632 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_707 (
)
INHERITS (public.address_usa_tx_70);


ALTER TABLE public.address_usa_tx_707 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7070 (
)
INHERITS (public.address_usa_tx_707);


ALTER TABLE public.address_usa_tx_7070 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_70705 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_710 (
)
INHERITS (public.address_usa_tx_71);


ALTER TABLE public.address_usa_tx_710 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7100 (
)
INHERITS (public.address_usa_tx_710);


ALTER TABLE public.address_usa_tx_7100 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71007 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7106 (
)
INHERITS (public.address_usa_tx_710);


ALTER TABLE public.address_usa_tx_7106 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71060 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71069 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7108 (
)
INHERITS (public.address_usa_tx_710);


ALTER TABLE public.address_usa_tx_7108 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71081 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71082 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_716 (
)
INHERITS (public.address_usa_tx_71);


ALTER TABLE public.address_usa_tx_716 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7164 (
)
INHERITS (public.address_usa_tx_716);


ALTER TABLE public.address_usa_tx_7164 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71647 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_718 (
)
INHERITS (public.address_usa_tx_71);


ALTER TABLE public.address_usa_tx_718 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7185 (
)
INHERITS (public.address_usa_tx_718);


ALTER TABLE public.address_usa_tx_7185 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_71854 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_72 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_722 (
)
INHERITS (public.address_usa_tx_72);


ALTER TABLE public.address_usa_tx_722 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7220 (
)
INHERITS (public.address_usa_tx_722);


ALTER TABLE public.address_usa_tx_7220 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_72201 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_727 (
)
INHERITS (public.address_usa_tx_72);


ALTER TABLE public.address_usa_tx_727 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7275 (
)
INHERITS (public.address_usa_tx_727);


ALTER TABLE public.address_usa_tx_7275 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_72754 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_73 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_730 (
)
INHERITS (public.address_usa_tx_73);


ALTER TABLE public.address_usa_tx_730 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7306 (
)
INHERITS (public.address_usa_tx_730);


ALTER TABLE public.address_usa_tx_7306 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_73063 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_733 (
)
INHERITS (public.address_usa_tx_73);


ALTER TABLE public.address_usa_tx_733 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7330 (
)
INHERITS (public.address_usa_tx_733);


ALTER TABLE public.address_usa_tx_7330 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_73301 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_738 (
)
INHERITS (public.address_usa_tx_73);


ALTER TABLE public.address_usa_tx_738 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7385 (
)
INHERITS (public.address_usa_tx_738);


ALTER TABLE public.address_usa_tx_7385 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_73852 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_74 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_744 (
)
INHERITS (public.address_usa_tx_74);


ALTER TABLE public.address_usa_tx_744 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7446 (
)
INHERITS (public.address_usa_tx_744);


ALTER TABLE public.address_usa_tx_7446 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_74464 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_746 (
)
INHERITS (public.address_usa_tx_74);


ALTER TABLE public.address_usa_tx_746 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7460 (
)
INHERITS (public.address_usa_tx_746);


ALTER TABLE public.address_usa_tx_7460 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_74605 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7462 (
)
INHERITS (public.address_usa_tx_746);


ALTER TABLE public.address_usa_tx_7462 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_74626 (
)
INHERITS (public.address_usa_tx_7462);


ALTER TABLE public.address_usa_tx_74626 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7464 (
)
INHERITS (public.address_usa_tx_746);


ALTER TABLE public.address_usa_tx_7464 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_74640 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_74647 (
)
INHERITS (public.address_usa_tx_7464);


ALTER TABLE public.address_usa_tx_74647 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7466 (
)
INHERITS (public.address_usa_tx_746);


ALTER TABLE public.address_usa_tx_7466 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_74662 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7468 (
)
INHERITS (public.address_usa_tx_746);


ALTER TABLE public.address_usa_tx_7468 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_74684 (
)
INHERITS (public.address_usa_tx_7468);


ALTER TABLE public.address_usa_tx_74684 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_750 (
)
INHERITS (public.address_usa_tx_75);


ALTER TABLE public.address_usa_tx_750 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7500 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7500 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75001 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75002 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75005 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75006 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75007 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75009 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7501 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7501 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75010 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75011 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75013 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75015 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75019 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7502 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7502 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75020 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75021 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75022 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75023 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75024 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75025 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75028 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75029 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7503 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7503 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75032 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75033 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75034 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75035 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75036 (
)
INHERITS (public.address_usa_tx_7503);


ALTER TABLE public.address_usa_tx_75036 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75038 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75039 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7504 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7504 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75040 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75041 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75042 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75043 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75044 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75046 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75048 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7505 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7505 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75050 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75051 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75052 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75053 (
)
INHERITS (public.address_usa_tx_7505);


ALTER TABLE public.address_usa_tx_75053 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75054 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75056 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75057 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75058 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7506 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7506 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75060 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75061 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75062 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75063 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75065 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75067 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75068 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75069 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7507 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7507 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75070 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75071 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75072 (
)
INHERITS (public.address_usa_tx_7507);


ALTER TABLE public.address_usa_tx_75072 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75074 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75075 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75076 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75077 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75078 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7508 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7508 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75080 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75081 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75082 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75083 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75086 (
)
INHERITS (public.address_usa_tx_7508);


ALTER TABLE public.address_usa_tx_75086 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75087 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75088 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75089 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7509 (
)
INHERITS (public.address_usa_tx_750);


ALTER TABLE public.address_usa_tx_7509 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75090 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75091 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75092 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75093 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75094 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75098 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75099 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_751 (
)
INHERITS (public.address_usa_tx_75);


ALTER TABLE public.address_usa_tx_751 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7510 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7510 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75101 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75102 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75103 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75104 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75106 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75107 (
)
INHERITS (public.address_usa_tx_7510);


ALTER TABLE public.address_usa_tx_75107 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75109 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7511 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7511 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75110 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75114 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75115 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75116 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75117 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75119 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7512 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7512 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75120 (
)
INHERITS (public.address_usa_tx_7512);


ALTER TABLE public.address_usa_tx_75120 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75121 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75123 (
)
INHERITS (public.address_usa_tx_7512);


ALTER TABLE public.address_usa_tx_75123 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75124 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75125 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75126 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75127 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7513 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7513 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75132 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75134 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75135 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75137 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75138 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7514 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7514 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75140 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75141 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75142 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75143 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75144 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75146 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75147 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75148 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75149 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7515 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7515 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75150 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75151 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75152 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75153 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75154 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75155 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75156 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75157 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75158 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75159 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7516 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7516 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75160 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75161 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75163 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75164 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75165 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75166 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75167 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75168 (
)
INHERITS (public.address_usa_tx_7516);


ALTER TABLE public.address_usa_tx_75168 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75169 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7517 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7517 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75172 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75173 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7518 (
)
INHERITS (public.address_usa_tx_751);


ALTER TABLE public.address_usa_tx_7518 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75180 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75181 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75182 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75185 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75189 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_752 (
)
INHERITS (public.address_usa_tx_75);


ALTER TABLE public.address_usa_tx_752 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7520 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7520 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75201 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75202 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75203 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75204 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75205 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75206 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75207 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75208 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75209 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7521 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7521 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75210 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75211 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75212 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75214 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75215 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75216 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75217 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75218 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75219 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7522 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7522 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75220 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75223 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75224 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75225 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75226 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75227 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75228 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75229 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7523 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7523 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75230 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75231 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75232 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75233 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75234 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75235 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75236 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75237 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75238 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75239 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7524 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7524 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75240 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75241 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75242 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75243 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75244 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75246 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75247 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75248 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75249 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7525 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7525 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75251 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75252 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75253 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75254 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7526 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7526 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75260 (
)
INHERITS (public.address_usa_tx_7526);


ALTER TABLE public.address_usa_tx_75260 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75261 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75265 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7527 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7527 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75270 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75277 (
)
INHERITS (public.address_usa_tx_7527);


ALTER TABLE public.address_usa_tx_75277 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7528 (
)
INHERITS (public.address_usa_tx_752);


ALTER TABLE public.address_usa_tx_7528 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75287 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_753 (
)
INHERITS (public.address_usa_tx_75);


ALTER TABLE public.address_usa_tx_753 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7532 (
)
INHERITS (public.address_usa_tx_753);


ALTER TABLE public.address_usa_tx_7532 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75320 (
)
INHERITS (public.address_usa_tx_7532);


ALTER TABLE public.address_usa_tx_75320 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75321 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75323 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75326 (
)
INHERITS (public.address_usa_tx_7532);


ALTER TABLE public.address_usa_tx_75326 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7538 (
)
INHERITS (public.address_usa_tx_753);


ALTER TABLE public.address_usa_tx_7538 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75381 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7539 (
)
INHERITS (public.address_usa_tx_753);


ALTER TABLE public.address_usa_tx_7539 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_75390 (
)
INHERITS (public.address_usa_tx_7539);


ALTER TABLE public.address_usa_tx_75390 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75398 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_754 (
)
INHERITS (public.address_usa_tx_75);


ALTER TABLE public.address_usa_tx_754 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7540 (
)
INHERITS (public.address_usa_tx_754);


ALTER TABLE public.address_usa_tx_7540 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75401 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75402 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75403 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75404 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75407 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75409 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7541 (
)
INHERITS (public.address_usa_tx_754);


ALTER TABLE public.address_usa_tx_7541 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75410 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75411 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75412 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75413 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75414 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75415 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75416 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75417 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75418 OWNER TO postgres;

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

CREATE TABLE public.address_usa_tx_7542 (
)
INHERITS (public.address_usa_tx_754);


ALTER TABLE public.address_usa_tx_7542 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75420 OWNER TO postgres;

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

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


ALTER TABLE public.address_usa_tx_75421 OWNER TO postgres;

--
