Skip to content

Instantly share code, notes, and snippets.

@dphiffer

dphiffer/wikidata_flatiron.csv

Created June 14, 2017 13:40
Show Gist options
  • Save dphiffer/d4560491df8c311cea657d2b879765fb to your computer and use it in GitHub Desktop.
Save dphiffer/d4560491df8c311cea657d2b879765fb to your computer and use it in GitHub Desktop.
Download ZIP
select * from entity where lat > 40.738403 and lat < 40.744255 and lng > -73.999201 and lng < -73.976885;
Raw
wikidata_flatiron.csv
id name instance_of lat lng
Q63751 Rubin Museum of Art Q207694 40.740111111111 -73.997805555556
Q904191 Theodore Roosevelt Birthplace National Historic Site Q41176 40.738889 -73.989722
Q1427377 Flatiron District Q123705 40.7408 -73.9896
Q2478033 23rd Street Q55488 40.743889 -73.995556
Q2478345 23rd Street Q55488 40.7429 -73.9929
Q2515468 18th Street Q928830 40.740833 -73.997778
Q3163335 Jazz Standard 40.7422 -73.9838
Q4557667 18th Street Q55488 40.7398 -73.995
Q4631696 23rd Street Q55488 40.7388 -73.9832
Q5123167 City Gallery, New York 40.744 -73.991
Q5167051 Cookfox 40.7407 -73.9947
Q5277881 Dinacharya Institute 40.7417 -73.9829
Q5914090 House at 203 East 29th Street Q3947 40.7425 -73.980278
Q6175579 Jefferson School of Social Science 40.7389 -73.996
Q6727871 Madison Avenue Baptist Church Q16970 40.7438 -73.9819
Q6728106 Madison Square Theatre Q24354 40.7422 -73.9901
Q6815573 Memorial to Victims of the Injustice of the Holocaust Q860861 40.7424 -73.9867
Q7071907 O'Neill Building Q41176 40.7415 -73.9939
Q7175816 Peter McManus Cafe 40.7418 -73.9975
Q7576400 Spero Building Q811979 40.740833333333 -73.991944444444
Q18159286 William Henry Seward Q860861 40.7415 -73.9888
Q18619578 William and Anita Newman Library 40.740114 -73.983352
Q19833951 45 East 22nd Street Q41176 40.739924 -73.987236
Q1499859 New York Life Building Q11303 40.742777777778 -73.985555555556
Q1925855 Metropolitan Life North Building Q11303 40.7416 -73.9866
Q3328431 Museum of Comic and Cartoon Art Q207694 40.7401 -73.9871
Q3701950 Scribner Building Q655686 40.740278 -73.990833
Q3936149 Calvary Church Q16970 40.739 -73.987
Q4051157 The Limelight 40.7411 -73.9938
Q4631693 23rd Street Q55488 40.7429 -73.9928
Q4642413 69th Infantry Regiment Q52371 40.7414 -73.9839
Q4781005 Appellate Division Courthouse of New York State Q41176 40.742222 -73.986667
Q4980581 Bryant Hall Building 40.7434 -73.9926
Q5268170 Dewey Arch Q143912 40.742167 -73.989
Q5447471 Fifth Avenue Hotel Q27686 40.7421 -73.9894
Q5593638 Gramercy Tavern Q11707 40.7386 -73.9885
Q5911529 Hotel Giraffe Q27686 40.7422 -73.9847
Q5911641 Hotel Kenmore Hall Q27686 40.7395 -73.9841
Q6182827 Jerome Mansion Q41176 40.7424 -73.9863
Q6469450 Ladies' Mile Historic District 40.74 -73.9919
Q6707253 Lyceum Theatre Q24354 40.7405 -73.986
Q6728103 Madison Square Presbyterian Church, New York City Q16970 40.7416 -73.9875
Q7122915 Packard Business College Q5001855 40.740598 -73.989416
Q7209933 Polish Institute of Arts and Sciences of America Q43229 40.7428 -73.9795
Q7617108 Still Mind Zendo Q1370598 40.7388 -73.994
Q7619503 Stony Brook Manhattan 40.7427 -73.984
Q7830506 Toy Center 40.7421 -73.9894
Q7887567 United Charities Building Q41176 40.739389 -73.986389
Q7980414 Weissman School of Arts and Sciences 40.7404 -73.9834
Q8026117 Winston Preparatory School 40.739791 -73.996917
Q13054782 Սուրբ Գրիգոր Լուսավորիչ եկեղեցի (Նյու Յորք) Q16970 40.741193 -73.980119
Q16237969 Masonic Hall 40.7429 -73.9922
Q16948222 Goelet Building Q41176 40.7392 -73.9896
Q17509809 Admiral David Glasgow Farragut Q860861 40.7426 -73.9877
Q26916567 2016 New York and New Jersey bombings Q179057 40.743631 -73.994308
Q30081196 Church Missions House Q41176 40.739305555556 -73.986666666667
Q220728 Flatiron Building Q11303 40.741111 -73.989722
Q939753 28th Street Q928830 40.74329 -73.984165
Q1075711 Silicon Alley 40.7421 -73.9911
Q1105759 Church of the Holy Communion and Buildings Q16970 40.741102777778 -73.993652777778
Q1107182 Rose Hill Q123705 40.742 -73.983
Q1276394 Sohmer Piano Building Q11755959 40.740809 -73.990401
Q1684488 Jazz Standard (Jazzclub) 40.742262 -73.983716
Q2528147 23rd Street Q55488 40.7413 -73.9893
Q2781236 69th Regiment Armory Q641226 40.7411 -73.9836
Q3584637 St. Vincent de Paul Church (Manhattan) Q317557 40.7436 -73.9937
Q3754550 Madison Square Garden Q1076486 40.742778 -73.985556
Q4631702 23rd Street Fire 40.7408 -73.9889
Q4631704 23rd Street Q928830 40.742893 -73.992865
Q4632835 28th Street Q55488 40.7419 -73.9809
Q4642412 69th Infantry Regiment Q52371 40.7414 -73.9839
Q4865849 Baruch College Campus High School Q9826 40.7419 -73.9858
Q4943860 Booth's Theatre Q24354 40.7425 -73.9927
Q5009224 CBS 30th Street Studio Q746369 40.7431 -73.9792
Q5024131 Calvary-St. George's Parish Q16970 40.7389 -73.9867
Q5090063 Chelsea Corners 40.74 -73.999
Q5359767 Eleven Madison Park Q11707 40.7417 -73.9872
Q5522338 Garden Theatre Q24354 40.743 -73.986
Q5593636 Gramercy Park Hotel Q27686 40.7385 -73.9858
Q6071145 Irish Repertory Theatre 40.7427 -73.9947
Q6728100 Madison Square North Historic District 40.7442 -73.9883
Q6728104 Madison Square Presbyterian Church Q16970 40.7416 -73.9875
Q6749325 Manhattan Village Academy Q9826 40.741868 -73.992019
Q7313980 Repertorio Español Q24354 40.741646 -73.982597
Q7589514 St. Leo's Church Q16970 40.7442 -73.9862
Q8071469 Zicklin School of Business Q1143635 40.7404 -73.9834
Q9026714 Madison Square Garden Q1378975 40.742778 -73.985556
Q17103456 Media Development Investment Fund Q163740 40.7408 -73.99344
Q118599 23rd Street Q79007 40.7421 -73.9911
Q652452 Metropolitan Life Insurance Company Tower Q11303 40.74124 -73.9874
Q953252 New York School of Applied Design Q19844914 40.743889 -73.982222
Q4957928 Brasserie Les Halles Q11707 40.7436 -73.9837
Q5093438 Chester A. Arthur Home Q41176 40.742778 -73.9825
Q5160680 Congregation Talmud Torah Adereth El 40.7432 -73.9815
Q5484279 Edificio del 304 Park Avenue South 40.74 -73.987222
Q5545985 George Washington Hotel Q27686 40.7396 -73.9846
Q6040186 Institute of Culinary Education Q5167149 40.7421 -73.9918
Q6105175 Reloj del 200 de la Quinta Avenida 40.741667 -73.99
Q6659659 Livingston Library 40.7428 -73.9921
Q7092848 One Madison Q11303 40.74064 -73.98807
Q7166065 Peoples Improv Theater 40.7405 -73.9847
Q7249874 Promotion Marketing Association, Inc. Q4830453 40.73861111 -73.98722222
Q7842633 Trinity Chapel Complex Q2977 40.743611 -73.990278
Q14707082 New York Merchandise Mart Q11303 40.7424 -73.9863
Q17027576 Relay Graduate School of Education Q13220391 40.7405 -73.9932
Q109873 Sixth Avenue Q7543083 40.742777777778 -73.992777777778
Q110000 Madison Square Q174782 40.742052777778 -73.987983333333
Q688909 Armory Show Q667276 40.741233333333 -73.983483333333
Q809633 Baruch College Q189004 40.740159 -73.98338
Q1274032 NoMad Q123705 40.7442 -73.9883
Q1279835 School of Visual Arts Q3918 40.73861111 -73.98222222
Q1501208 Kips Bay Q123705 40.741388888889 -73.978333333333
Q1990560 Chelsea Stratus Q11303 40.743883 -73.992539
Q2033264 23rd Street Q928830 40.7402 -73.9864
Q5116985 Church of Our Lady of the Scapular-St. Stephen Q16970 40.7425 -73.9813
Q5593640 Gramercy Theatre Q24354 40.7398 -73.985
Q6728105 United States Post Office Madison Square Station Q35054 40.739444 -73.983889
Q6940939 Museum of Mathematics Q33506 40.7437 -73.9883
Q7013959 New York School of Applied Design for Women Q383092 40.7441 -73.9817
Q7737487 The Grand Madison 40.7435 -73.9878
Q7765400 The Sound Factory Bar 40.7405 -73.9916
Q7891168 United States Post Office Old Chelsea Station Q35054 40.741667 -73.998889
Q22061003 Madison Square Fountain 40.741735 -73.988301
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment