Sheffield Farms Stable (Q7492664)

  • matcher place: Manhattan (way 400014249), New York (relation 175905), Manhattan (relation 2552485), Manhattan Community Board 9 (relation 7339672), Manhattan (relation 8186559), Manhattan (relation 8398124)
  • view on Wikidata
  • Wikipedia: English
  • English Wikipedia categories: 1903 establishments in New York (state), Agricultural buildings and structures on the National Register of Historic Places in New York (state), Buildings and structures completed in 1903, Buildings and structures on the National Register of Historic Places in Manhattan, Columbia University campus, Manhattan Registered Historic Place stubs, Manhattan building and structure stubs, Stables in the United States
  • Overpass query: show query – Overpass Turbo 
    [timeout:300][out:json];
(
    node(around:1000,40.81667,-73.95833)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[building][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[historic][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[product][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[amenity=shelter][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)[amenity=stables][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)[amenity=stables][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[amenity=stables][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[amenity=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)["boundary"="protected_area"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)["heritage:operator"="nrhp"][~"^(addr:housenumber|.*name.*)$"~".",i];
    way(around:1000,40.81667,-73.95833)["heritage:operator"="nrhp"][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)["heritage:operator"="nrhp"][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)["landuse"="greenhouse_horticulture"][name];
    way(around:1000,40.81667,-73.95833)["landuse"="greenhouse_horticulture"][name];
    rel(around:1000,40.81667,-73.95833)["landuse"="greenhouse_horticulture"][name];
    rel(around:1000,40.81667,-73.95833)[site=university][~"^(addr:housenumber|.*name.*)$"~".",i];
    rel(around:1000,40.81667,-73.95833)[type=site][~"^(addr:housenumber|.*name.*)$"~".",i];
    node(around:1000,40.81667,-73.95833)["ref:nrhp"=05001285];
    way(around:1000,40.81667,-73.95833)["ref:nrhp"=05001285];
    rel(around:1000,40.81667,-73.95833)["ref:nrhp"=05001285];
);
out center tags;
Summary from English Wikipedia (enwiki)

Sheffield Farms Stable was a historic stable located in Manhattanville, New York, New York. Designed by Frank A. Rooke, it was a six-story, light colored brick building with terracotta ornament. It was originally built in 1903 as a two-story stable building for the Sheffield Farms dairy, then expanded to its present size in 1909. It housed horses used for the delivery of pasteurized milk until July 1938. It was sold in 1942, after which it housed a real estate company, insurance company, and warehouse.

Wikidata location: 40.8167, -73.9583 view on OSM or edit on OSM

matches

login to upload wikidata tags

no matches found

Search criteria from Wikidata

view with query.wikidata.org

agricultural structure (Q10480682) building=farm_auxiliary
National Register of Historic Places listed place (Q19558910) heritage:operator=nrhp
stable (Q214252) building=stable
product (Q2424752) product
building (Q41176) building=yes, building
shelter (Q989946) amenity=shelter

Search criteria from categories

Agricultural buildings and structures on the National Register of Historic Places in New York (state) boundary=protected_area, building=farm, building=farm_auxiliary, building=barn, historic
Buildings and structures on the National Register of Historic Places in Manhattan boundary=protected_area, historic
Columbia University campus building=university, site=university, amenity=university, type=site