Created
June 6, 2014 19:55
-
-
Save allthesignals/605c39cc1d241922cb6d to your computer and use it in GitHub Desktop.
SQL dump of Hubway stations (requires PostGIS)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- 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