Skip to content

Instantly share code, notes, and snippets.

@allthesignals
Created June 6, 2014 19:55
Show Gist options
  • Save allthesignals/605c39cc1d241922cb6d to your computer and use it in GitHub Desktop.
Save allthesignals/605c39cc1d241922cb6d to your computer and use it in GitHub Desktop.
SQL dump of Hubway stations (requires PostGIS)
--
-- 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
--
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment