SQL dump of Hubway stations (requires PostGIS)

hubway_stations.sql

--
-- PostgreSQL database dump
-- psql dbname < hubway_stations.sql
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: hubway_stations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
--

CREATE TABLE hubway_stations (
    gid integer NOT NULL,
    terminal text,
    station character varying(100),
    the_geom geometry(Point,26986)
);


--
-- Name: hubway_stations_gid_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE hubway_stations_gid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: hubway_stations_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE hubway_stations_gid_seq OWNED BY hubway_stations.gid;


--
-- Name: gid; Type: DEFAULT; Schema: public; Owner: -
--

ALTER TABLE ONLY hubway_stations ALTER COLUMN gid SET DEFAULT nextval('hubway_stations_gid_seq'::regclass);


--
-- Data for Name: hubway_stations; Type: TABLE DATA; Schema: public; Owner: -
--

COPY hubway_stations (gid, terminal, station, the_geom) FROM stdin;
162	B32008	Mayor Martin J. Walsh - 28 State St.	01010000206A690000B52C496AE9DC0C41020BE0CE477F2B41
163	B32010	Kenmore Sq / Comm Ave	01010000206A690000566D74A528780C41CBAD448090762B41
164	B32011	Yawkey Way at Boylston St.	01010000206A6900008DCAB32E65750C41F2FA129DEA722B41
165	B32012	Northeastern U / North Parking Lot	01010000206A6900006DC840BB45890C410EB3D03356702B41
166	B32013	Brigham Cir / Huntington Ave	01010000206A6900000467841FC5620C41D5D2B4FC9B692B41
167	B32014	Seaport Hotel	01010000206A690000AEF6E25908060D415497A8EC91762B41
168	B32015	Landmark Centre	01010000206A690000FE970E68566A0C41763F025B1F722B41
169	B32016	Beacon St / Mass Ave	01010000206A69000010329F0BE5890C41942EEFCA25782B41
170	B32017	Dudley Square	01010000206A690000C0695FC9F1980C412674B7D3FC642B41
171	B32018	Boylston / Mass Ave	01010000206A690000A3F90C7D968E0C41E4A60BB21D752B41
172	B32019	Longwood Ave/Riverway	01010000206A6900000820603891560C41847AE0C0F96E2B41
173	B32020	BIDMC - Brookline at Burlington St	01010000206A690000424FC3B62B6E0C4103AC9661B0732B41
174	C32000	Tremont St. at Berkeley St.	01010000206A6900002A81687A41BE0C416832C2A986732B41
175	C32001	Roxbury Crossing Station	01010000206A690000FD684346D47C0C4130BC948E1F672B41
176	C32002	Boston Medical Center -  East Concord at Harrison Ave	01010000206A690000FC46E65F66B50C41B2B8866AB46B2B41
177	C32003	Back Bay / South End Station	01010000206A690000C85F210F3AAD0C41FA8666843D752B41
178	C32004	Columbus Ave. at Mass. Ave.	01010000206A69000080AEBD5D6F9F0C41D992F2EE7E6F2B41
179	C32005	Washington St. at Lenox St.	01010000206A69000047E3D24EF9A50C412552E746626A2B41
180	C32006	Washington St. at Rutland St.	01010000206A69000029830A6A87B20C4172BE393D9C6D2B41
181	C32007	Prudential Center / Belvidere	01010000206A690000A645A086C59C0C411420674E01742B41
182	C32008	Boylston at Fairfield	01010000206A690000C567E32D3D9D0C417086017D6F762B41
183	C32009	Dorchester Ave. at Gillette Park	01010000206A69000063C64CAF77DE0C41FE20E4325A722B41
184	C32010	Congress / Sleeper	01010000206A690000A4FC0C53A6F10C41D4DF52EF89782B41
185	C32012	Andrew Station - Dorchester Ave at Humboldt Pl	01010000206A69000084C744FCF6DE0C41932666B2CF662B41
186	C32013	JFK / UMASS Station	01010000206A690000890C9BBF58EE0C414C3520DDFA5D2B41
187	C32014	University of Massachusetts Boston	01010000206A69000027F7522E2E160D4183150DC47B562B41
188	C32015	Mt Pleasant Ave / Dudley Town Common	01010000206A690000A8C30B25ABAF0C41A32D7BAA10622B41
189	C32016	West Broadway at Dorchester St	01010000206A690000B45515B8AEFA0C410C941572726B2B41
190	C32017	South Boston Library - 646 East Broadway	01010000206A690000138B1ECFBE0D0D416E65C457366B2B41
191	C32018	E. Cottage St at Columbia Rd	01010000206A690000DE2A896844D20C41C00277BC075E2B41
192	C32019	Upham's Corner - Ramsey St at Dudley St	01010000206A69000006F76AB691C90C416FEA4390115B2B41
193	C32020	ID Building East	01010000206A690000545C31DA94270D41BB74030025732B41
194	C32021	ID Building West	01010000206A6900009C9284371D200D41A855135E22732B41
195	C32022	Newmarket Square	01010000206A6900001828FCD691C60C41A4B1F2D638632B41
196	C32023	Day Boulevard	01010000206A6900000251B3749E340D41CEB94386DF6B2B41
197	D32000	Cambridge St. at Joy St.	01010000206A69000093B1A4BF8FC90C41F050659D56812B41
198	D32001	New Balance - 20 Guest St.	01010000206A690000BD5C1DADE8FA0B41CA70A7225E7D2B41
199	D32002	Washington St. at Waltham St.	01010000206A690000C3D5706B20C00C41FCDE71DC24702B41
200	D32003	TD Garden - Causeway at Portal Park #2	01010000206A690000B6E3D127DCD60C41E8C8438C9B852B41
201	D32004	Franklin St. / Arch St.	01010000206A690000B3473702B0DB0C41F8BDC7DA3D7C2B41
202	D32005	Boston Public Library - 700 Boylston St.	01010000206A690000EF23F5DA5AAA0C41948A32903B772B41
203	D32006	Lewis Wharf - Atlantic Ave.	01010000206A6900005BBACC9411EE0C416E9B6354A4832B41
204	D32007	Boylston St. at Arlington St.	01010000206A6900000483E32514BC0C41A9DC946756792B41
205	D32008	Rowes Wharf - Atlantic Ave	01010000206A690000807C3935B5EE0C419F8840E1BD7D2B41
206	D32009	Faneuil Hall - Union St. at North St.	01010000206A690000B30615E5AEDE0C41621A0B10C2802B41
207	D32010	Cross St. at Hanover St.	01010000206A690000827112F0B3E00C4148B9B67AAB822B41
208	D32011	Stuart St. at Charles St.	01010000206A690000E8F29204A7C60C41820A5CAC7B782B41
209	D32012	Post Office Square	01010000206A6900001B8106079DE20C411FB14B2D777D2B41
210	D32013	Boylston St / Berkeley St	01010000206A690000986EAAE1DBB30C411039B4645F782B41
211	D32014	Tremont St / West St	01010000206A6900008245D3A24ECE0C4150EDE694E07B2B41
212	D32015	Chinatown Gate Plaza - Surface Rd. at Beach St.	01010000206A690000E6273C9269D80C4170774025C4782B41
141	A32000	Fan Pier	01010000206A690000EAF7D2027BFE0C41BCB32B418D7A2B41
142	A32001	Union Square - Brighton Ave. at Cambridge St.	01010000206A6900005C20910ED10F0C4159098DC92D7A2B41
143	A32002	Agganis Arena - 925 Comm Ave.	01010000206A69000048E9160F2C460C413CF91AB380782B41
144	A32003	B.U. Central - 725 Comm. Ave.	01010000206A690000B63A29ECB5600C416593B4DB7D772B41
145	A32004	Longwood Ave / Binney St	01010000206A69000089BE3896595F0C415CF70CAC826D2B41
146	A32005	Harvard Real Estate - Brighton Mills - 370 Western Ave	01010000206A69000091B60202E40D0C4112C2835E77812B41
147	A32006	Harvard University Housing - 111 Western Ave. at Soldiers Field Park 	01010000206A69000084294F5C343D0C41231182E077842B41
148	A32008	Buswell St. at Park Dr.	01010000206A69000071269D534D620C41D92E2214FA742B41
149	A32009	Tremont St / W Newton St	01010000206A6900003C792075C9AB0C41FD7D3AE9F16F2B41
150	A32010	South Station - 700 Atlantic Ave.	01010000206A6900002314466C70E20C41323B2D3379792B41
151	A32011	Innovation Lab - 125 Western Ave. at Batten Way	01010000206A6900000E4BD2F35A300C4192ED1A373D832B41
152	A32012	Packard's Corner - Comm. Ave. at Brighton Ave.	01010000206A690000684E27D396320C414640774559792B41
153	A32017	Allston Green District - Commonwealth Ave & Griggs St	01010000206A6900002ECE120262180C41593D07001C762B41
154	A32019	Harvard University Transportation Services - 175 North Harvard St	01010000206A690000F1BE9D3483240C419E508F1D50832B41
155	B32000	Newbury St / Hereford St	01010000206A690000544125B0F8930C41868BA16156762B41
156	B32002	Ruggles Station / Columbus Ave.	01010000206A690000BE1F14B2BF8D0C417733E2DD386B2B41
157	B32003	HMS / HSPH - Ave. Louis Pasteur at Longwood Ave.	01010000206A690000810BEA9CE6680C414CB40E7D4E6C2B41
158	B32004	Aquarium Station - 200 Atlantic Ave.	01010000206A6900002F1C877157EC0C415E54D6E714802B41
159	B32005	Christian Science Plaza	01010000206A6900002498694F4F940C415D90E2232C722B41
160	B32006	Colleges of the Fenway	01010000206A69000099E06080016E0C41FCD02C0CBE6E2B41
161	B32007	Seaport Square - Seaport Blvd. at Boston Wharf	01010000206A69000087559E6631FC0C414291070629792B41
213	D32017	The Esplanade - Beacon St. at Arlington St.	01010000206A690000ECCED8B4D6B50C41756BE7F15D7C2B41
214	D32018	Boston Convention & Exhibition Center	01010000206A6900007177C394E0FF0C41466EA3026F752B41
215	D32019	Boylston St / Washington St	01010000206A690000BA08CAEDE5CF0C41DDA0527F9F792B41
216	D32020	Charlestown - Main St at Austin St	01010000206A69000015131D6498CA0C41FA389CCBBF8D2B41
217	D32021	Charlestown - Warren St at Chelsea St	01010000206A69000043A700EBBAD50C41A84EFD40778A2B41
218	D32022	TD Garden - Causeway at Portal Park #1	01010000206A6900003DDCC12652D50C41634C9A6458852B41
219	D32023	Spaulding Rehabilitation Hospital - Charlestown Navy Yard	01010000206A69000001D173E1F3F20C41CAE3E70A25902B41
220	D32024	Charles St at Beacon St	01010000206A6900008EC7DAAF8DBD0C4135BB2D81CF7C2B41
221	D32025	Milk St at India St	01010000206A69000002AE38DBC2E80C412EFF3AE6F27E2B41
222	D32026	Hayes Square at Vine St.	01010000206A690000363D1BD828DF0C412A987698FD8E2B41
223	D32027	New Balance Store - Boylston at Dartmouth	01010000206A690000E0D5972925AC0C41B74BFEA3D7772B41
224	E32001	JP Monument - South St at Centre St	01010000206A690000D6FFD1EC5E480C41D6FEFB473B542B41
225	E32002	JP Center - Centre St at Seaverns Ave	01010000206A690000541C977FAD4B0C41969B080D94562B41
226	E32003	Hyde Square at Barbara St	01010000206A69000018A4E9298E540C414883AE95395E2B41
227	E32004	Egleston Square at Columbus Ave	01010000206A6900001EF3A67011740C4134FB0E84A9592B41
228	E32005	Green St T	01010000206A690000E4BD65BCBC5D0C418D3B13E135552B41
229	E32006	Jackson Square T at Centre St	01010000206A6900000C904844D46F0C4174072CC0E75F2B41
230	K32001	Coolidge Corner - Beacon St @ Centre St	01010000206A6900000965105F0A340C416548459F10702B41
231	K32002	Washington Square at Washington St. / Beacon St.	01010000206A69000006F9B92534160C414E66E35C096E2B41
232	K32003	Brookline Village - Station Street @ MBTA	01010000206A6900007961830776460C413237C2EA72682B41
233	K32004	JFK Crossing at Harvard St. / Thorndike St.	01010000206A6900005E9707FCD4260C4137A641B063742B41
234	M32001	Lechmere Station at Cambridge St / First St	01010000206A6900000F2BF5820DAC0C415BCB5D6275892B41
235	M32002	One Kendall Square at Hampshire St / Portland St	01010000206A6900002B2B89B000850C41F22F85B597852B41
236	M32003	One Broadway / Kendall Sq at Main St / 3rd St	01010000206A69000080D0EED6A0980C4101888DCC67822B41
237	M32004	Kendall T at Main St	01010000206A690000FDF0B12B50960C41BBDF99DC50822B41
238	M32005	MIT Stata Center at Vassar St / Main St	01010000206A690000F794CFC8ED880C4167CE258136822B41
239	M32006	MIT at Mass Ave / Amherst St	01010000206A690000A17B2AFF46810C410F939EE3787E2B41
240	M32007	Cambridge St - at Columbia St / Webster Ave	01010000206A690000DB2F912DF17D0C413CA18300668B2B41
241	M32009	Lafayette Square at Mass Ave / Main St / Columbia St	01010000206A6900001F8A0AF3A66E0C418F8CDB1C39832B41
242	M32010	Inman Square at Vellucci Plaza / Hampshire St	01010000206A690000FE224BC5E86B0C419B15D0B73E8C2B41
243	M32011	Central Square at Mass Ave / Essex St	01010000206A69000093E33F78AD670C415FC34A4384842B41
244	M32012	Central Sq Post Office / Cambridge City Hall at Mass Ave / Pleasant St	01010000206A690000E6A795957A610C416038B939A3852B41
245	M32013	Cambridge Main Library at Broadway / Trowbridge St	01010000206A69000039F45208F4520C41C5110C0DB28B2B41
246	M32014	Harvard University Housing - 115 Putnam Ave at Peabody Terrace	01010000206A690000857F09CE144B0C410F589919C9852B41
247	M32015	Harvard University River Houses / Plympton St at Memorial Drive	01010000206A690000FA6EAE3BBC400C4165D839058D882B41
248	M32016	Harvard Kennedy School at Bennett St / Eliot St	01010000206A69000067C52BA36E370C416D2DFF8A9F8A2B41
249	M32017	Harvard Square at Brattle St / Eliot St	01010000206A69000078F049B3BB390C416807635A7E8B2B41
250	M32018	Harvard Square at Mass Ave/ Dunster	01010000206A69000012EB4EC1A63F0C417C86DB41968B2B41
251	M32019	CambridgeSide Galleria - CambridgeSide PL at Land Blvd	01010000206A69000035AD04D61DAC0C41837EB56C3F862B41
252	M32020	Harvard Law School at Mass Ave / Jarvis St	01010000206A6900009A1211A0373C0C4128828E9187902B41
253	M32021	Harvard University Gund Hall at Quincy St / Kirkland S	01010000206A690000E9991330714B0C41D8E24B564A8E2B41
254	M32022	Lower Cambridgeport at Magazine St/Riverside Rd	01010000206A6900004D1889EB844C0C41E902E1D1747D2B41
255	M32023	Harvard University / SEAS Cruft-Pierce Halls at 29 Oxford St	01010000206A690000FA5AC182F4430C41D9FD6969958F2B41
256	M32024	Harvard University Radcliffe Quadrangle at Shepard St / Garden St	01010000206A690000DD953B9FD02E0C41BB347993A4912B41
257	M32025	Linear Park - Mass. Ave. at Cameron Ave. 	01010000206A6900007E38E5A2A7200C41C493085FD0A02B41
258	M32026	359 Broadway - Broadway at Fayette Street	01010000206A690000A457244F3D640C4168EA1F8875892B41
259	M32027	Biogen Idec - Binney St / Sixth St	01010000206A6900006347270EA6920C41A6224A7C6F852B41
260	M32029	Porter Square Station	01010000206A6900009A8506FA223E0C41D6D56A8757982B41
261	M32030	Dana Park	01010000206A69000074E91630AA5C0C419695627477812B41
262	M32031	Danehy Park	01010000206A690000DE1BEC6FDE1A0C41FEC8ABC92B992B41
263	\N	Rindge Ave	01010000206A69000020428DEA96240C4136305CAD7A9C2B41
264	\N	EF	01010000206A69000020428DEA96240C4136305CAD7A9C2B41
265	\N	Alewife T	01010000206A690000A12FD9EA85090C4102BB8C95669F2B41
266	M32032	Biomed - Kendall Street	01010000206A690000963C2A9EC19D0C41C5D6A3FD73832B41
267	S32001	Somerville City Hall	01010000206A690000E0E54A0C93780C41B74ED34605972B41
268	S32002	Union Square - Somerville	01010000206A69000008E9E358847B0C41A11D05801F912B41
269	S32003	Beacon St at Washington / Kirkland	01010000206A6900002914AA9BB55E0C41C87E6BB738902B41
270	S32004	Conway Park - Somerville Avenue	01010000206A6900002C353644CD5B0C4142C86B3662942B41
271	S32005	Wilson Square	01010000206A6900006ED14753194D0C41C6D71FA946962B41
272	S32006	Davis Square	01010000206A690000B794BA8CF6330C4144F27B0D24A02B41
273	S32008	Powder House Circle - Nathan Tufts Park	01010000206A6900002DDB1C93DA430C412B19F8FF8AA32B41
274	S32009	Packard Ave / Powderhouse Blvd	01010000206A69000077E487AAD1320C4132E2A0E9A5A62B41
275	S32010	Somerville Hospital at Highland Ave / Crocker St	01010000206A690000AC71F9560D570C414509EEC7CC9A2B41
276	S32011	Teele Square at 239 Holland St	01010000206A690000A0B3B84AD7290C416BAB0EB829A52B41
277	S32012	Summer St at Cutter St	01010000206A690000C2009BE3B23A0C411C02F57D8B9D2B41
278	S32013	Magoun Square at Trum Field	01010000206A69000053FE52380C5B0C41C3463A5A66A12B41
279	\N	Channel Ctr	01010000206A690000DEFA844989E90C41A6B982538A722B41
280	\N	Charles Circle	01010000206A690000B933DF25A4BA0C41B871107CCC802B41
\.


--
-- Name: hubway_stations_gid_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('hubway_stations_gid_seq', 280, true);


--
-- PostgreSQL database dump complete
--