sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9734 173682 3 103 450x Raymond Ave 1 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
9739 173683 3 103 450x Raymond Ave 2 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
17867 98680 1 55 199X Park St 6 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
19132 96505 3 150 2360X Harrison St 7 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
50161 96500 3 150 2360X Harrison St 1 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
77523 96504 3 150 2360X Harrison St 5 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
77569 98569 3 5 301X Francisco St 7 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
77797 116382 1 21 2501 25th St 3 1 1 11 2     3x3   6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
80122 98749 2 26 540X Eureka St 6 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
80335 98579 3 26 301X Francisco St 17 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
81171 96512 3 150 2360X Harrison St 14 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
81972 98746 2 26 540X Eureka St 3 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
82707 96509 3 150 2360X Harrison St 11 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
82915 95268 3 43 2245 Jones St 7 1 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
84977 98681 1 55 199X Park St 7 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
86909 120542 2 71 2450 California St 1 7 1 6 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
88001 96511 3 150 2360X Harrison St 13 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
88992 98678 1 55 199X Park St 4 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
89093 116527 3 41 5732 GEARY BLVD 1 2 1 6 2     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
89314 67338 1 21 2501 25th St 1 1 1 11 2 07/22/1992 12:00:00 AM   3x3 Permit Number 30822 6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671)
89957 113573 2 43 901 LOMBARD ST 4 1 1 4 2     3x3   6007813.0 2120272.0 37.802303618634795 -122.417145352251 (37.8023036186348, -122.417145352251)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
90673 98752 2 26 540X Eureka St 9 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
92105 98750 2 26 540X Eureka St 7 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
92501 97725 3 94 1000X Bay St 4 5 1 4 2     7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
92729 98679 1 55 199X Park St 5 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
93270 98756 2 26 540X Eureka St 13 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
94043 98566 3 26 301X Francisco St 4 1 1 4 2 05/04/2013 12:00:00 AM   3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
94595 98794 3 21 950@Washington Clay St 6 1 1 4 2     3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
94912 98754 2 26 540X Eureka St 11 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
95375 98676 1 55 199X Park St 2 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
95832 98577 3 94 301X Francisco St 15 1 1 4 2     6x7   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
96688 96513 3 150 2360X Harrison St 15 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
97136 96502 3 150 2360X Harrison St 3 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
97683 98677 1 55 199X Park St 3 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
99342 95260 3 51 2290X 14th Ave 8 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
101459 98790 3 18 950x CLAY ST 5 1 1 4 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
101534 96499 3 189 2500X Harrison St 9 1 1 4 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
102209 96492 3 189 2500X Harrison St 2 1 1 4 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
103298 107884 3 44 941 Washington St 2 1 1 4 2     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
104096 112062 2 37 1199 VISITACION AVE 4 1 1 4 2 08/18/2015 12:00:00 AM   4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
104719 95263 3 15 2245 Jones St 1 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
105255 98564 3 16 301X Francisco St 2 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
105856 113571 2 21 901 LOMBARD ST 2 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
106182 96506 3 150 2360X Harrison St 8 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
106816 95261 3 51 2290X 14th Ave 9 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
108157 113570 2 21 901 LOMBARD ST 1 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
108801 98744 2 16 540X Eureka St 1 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
109088 98806 3 44 950x CLAY ST 8 1 1 4 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
109673 107885 3 44 941 Washington St 3 1 1 4 2     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
110614 98755 2 26 540X Eureka St 12 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
110736 98753 2 26 540X Eureka St 10 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
111189 98571 3 5 301X Francisco St 9 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
111371 96501 3 150 2360X Harrison St 2 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
111421 95362 3 5 775X Broadway 2 1 1 20 2     3x3 Permit Number 778058 6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
112310 95267 3 125 2245 Jones St 6 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
112530 98567 3 16 301X Francisco St 5 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
116005 95264 3 15 2245 Jones St 2 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
117184 98682 1 55 199X Park St 8 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
117271 98572 3 26 301X Francisco St 10 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
117516 98793 3 21 950x CLAY ST 4 1 1 4 2     3x6 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
119088 95258 3 51 2290X 14th Ave 6 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
120376 112063 2 37 1199 VISITACION AVE 5 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
120761 98574 3 26 301X Francisco St 12 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
120920 95266 3 15 2245 Jones St 5 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
121500 42841 3 21 2245 Jones St 4 1 1 4 2 07/03/2000 12:00:00 AM     Permit Number 42773 6008051.69679947 2120116.37092576 37.8018897255523 -122.416308313185 (37.8018897255523, -122.416308313185)
121513 107883 3 44 941 Washington St 1 1 1 4 2         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772)
122189 95269 3 43 2245 Jones St 8 1 1 4 2     6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
122407 98792 3 21 950 Clay St 9 1 1 4 2 03/16/2012 12:00:00 AM   5x4 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
122517 98803 3 44 950x Clay St 2 1 1 4 2 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
122693 96497 3 189 2500X Harrison St 8 1 1 4 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
123118 112058 2 37 1199 VISITACION AVE 1 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
123219 98563 3 16 301X Francisco St 1 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
126470 98573 3 26 301X Francisco St 11 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
126599 98562 3 12 2035X Stockton St 5 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
128247 116052 2 5 650x KANSAS ST 8 1 1 4 2     4x4   6011530.0 2105347.0 37.761531458187 -122.403232137637 (37.761531458187, -122.403232137637)
138350 98747 2 26 540X Eureka St 4 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
138574 98575 3 26 301X Francisco St 13 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
138703 95262 3 51 2290X 14th Ave 10 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
138890 98565 3 16 301X Francisco St 3 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
139365 98751 2 26 540X Eureka St 8 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
140135 112060 2 37 1199 VISITACION AVE 2 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
140600 113574 2 43 901 LOMBARD ST 5 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
141095 112061 2 37 1199 VISITACION AVE 3 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141772 98748 2 26 540X Eureka St 5 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
142592 96085 3 51 2290X 14th Ave 11 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
142763 98802 3 44 950x CLAY ST 3 1 1 4 2 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
143508 95265 3 15 2245 Jones St 3 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
143933 113572 2 21 901 LOMBARD ST 3 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
144736 96510 3 150 2360X Harrison St 12 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
145208 95259 3 51 2290X 14th Ave 7 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
145524 96494 3 189 2500X Harrison St 4 1 1 4 2     5x5   6008744.0 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409)
80823 98972 3 98 825 Shotwell St 6 1 1 4 2   0 5x5   6008234.2 2102998.9 37.754899496003105 -122.414464835105 (37.7548994960031, -122.414464835105)
16453 96769 3 26 1300X Lane St 5 1 1 4 2   1 4x4   6015646.9436 2095179.7309 37.7338433188148 -122.388283573512 (37.7338433188148, -122.388283573512)
23164 76784 3 2 1501X 42nd Ave 7 1 1 4 2 05/14/1994 12:00:00 AM 1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.50150981087799 (37.7577472058325, -122.501509810878)
Powered by Datasette · Query took 7.786ms · Data source: data.sfgov.org