sf-trees

Data source: data.sfgov.org

Custom SQL query returning 45 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
90158 108211 6 19 524 45th Ave 2 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
143885 108210 6 19 524 45th Ave 1 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
175259 218146 2 19 31 Ashton Ave 3 7 1 1     7     5994143.80732 2090112.0989599999 37.7187138908262 -122.46225842838601 (37.7187138908262, -122.462258428386)
9555 105225 5 19 175 Spruce St 1 7 1 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
85803 106833 6 19 174 STILLINGS AVE 1 7 1 1           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791)
89880 99852 6 19 86 Nordhoff St 1 7 1 1           6000395.0 2095652.0 37.734283150969794 -122.44104786104499 (37.7342831509698, -122.441047861045)
88432 99828 6 19 2398 Broadway 2 7 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
83945 103563 6 19 878 14th St 1 7 1 1     15   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
84454 103564 6 19 878 14th St 2 7 1 1     13   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
93035 103565 6 19 878 14th St 3 7 1 1     9   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
57173 247138 2 19 500 27th St 8 7 1 1     5     6003171.95048 2100074.35789 37.7465837047841 -122.43176270469499 (37.7465837047841, -122.431762704695)
175549 247137 2 19 500 27th St 7 7 1 1     3     6003179.078430001 2100075.39017 37.7465869432333 -122.431738130709 (37.7465869432333, -122.431738130709)
64677 247136 2 19 500 27th St 6 7 1 1     3     6003181.95614 2100090.46758 37.7466285054035 -122.43172925621501 (37.7466285054035, -122.431729256215)
35777 226865 2 19 1100 San Jose Ave 9 7 1 1     1     6004824.42349 2096711.0552700001 37.7374423749661 -122.425809268297 (37.7374423749661, -122.425809268297)
87429 108624 7 19 101 GENEBERN WAY 1 7 1 1           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144)
91961 103591 6 19 55X Laguna St 3 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
109308 103590 6 19 55X Laguna St 2 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
116755 103589 6 19 55X Laguna St 1 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
94696 107828 2 19 2601 Van Ness Ave 2 7 1 1     35   Permit Number 774138 6005744.5 2119283.2 37.799472043237294 -122.424233014169 (37.7994720432373, -122.424233014169)
80457 104540 7 19 1101 Van Ness Ave 4 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
84515 104544 7 19 1101 Van Ness Ave 8 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
94698 104538 7 19 1101 Van Ness Ave 1 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
97796 104543 7 19 1101 Van Ness Ave 7 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
98516 104542 7 19 1101 Van Ness Ave 6 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
125858 104539 7 19 1101 Van Ness Ave 2 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
138525 104568 7 19 1101 Van Ness Ave 9 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
140502 104541 7 19 1101 Van Ness Ave 5 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
52800 129325 2 19 1101 Greenwich St 3 7 1 1     4     6007543.5223900005 2119858.96336 37.801154360655 -122.41804858037399 (37.801154360655, -122.418048580374)
65360 129326 2 19 1101 Greenwich St 4 7 1 1     4     6007546.3898 2119859.39883 37.801155717731 -122.41803868875401 (37.801155717731, -122.418038688754)
169303 129327 2 19 1101 Greenwich St 5 7 1 1     2     6007552.17158 2119860.88653 37.801160127991295 -122.41801878675899 (37.8011601279913, -122.418018786759)
171563 129328 2 19 1101 Greenwich St 6 7 1 1     1     6007553.95221 2119861.40094 37.8011616406485 -122.418012661478 (37.8011616406485, -122.418012661478)
170842 129329 2 19 1101 Greenwich St 7 7 1 1     1     6007555.7240699995 2119861.47467 37.8011619428155 -122.41800653528601 (37.8011619428155, -122.418006535286)
60902 129330 2 19 1101 Greenwich St 8 7 1 1     2     6007557.40785 2119862.6523599997 37.8011652712212 -122.41800079219601 (37.8011652712212, -122.418000792196)
179802 129331 2 19 1101 Greenwich St 9 7 1 1     2     6007561.62509 2119863.3782 37.8011675015458 -122.41798625015899 (37.8011675015458, -122.417986250159)
31573 129332 2 19 1101 Greenwich St 10 7 1 1     1     6007563.684280001 2119863.77685 37.8011687120311 -122.417979152724 (37.8011687120311, -122.417979152724)
74501 129333 2 19 1101 Greenwich St 12 7 1 1     1     6007566.1830400005 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228)
102075 109040 6 19 654 Precita Ave   7 1 1     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152)
150004 247945 2 19 15 Joy St 1 7 1 1     4     6010344.08085 2098894.91993 37.743749172086794 -122.406879009554 (37.7437491720868, -122.406879009554)
170127 201932 2 19 190 Boutwell St 2 7 1 1     8 Width 9ft   6010626.2158 2095614.29555 37.734757064092605 -122.405672426066 (37.7347570640926, -122.405672426066)
86324 121732 3 19 1301 Vermont St 7 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
104252 121734 3 19 1301 Vermont St 9 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
46609 202031 2 19 1319 Fitzgerald Ave 1 7 1 1     6 Width 7ft   6013998.1976 2090972.78897 37.7222004121965 -122.3936894751 (37.7222004121965, -122.3936894751)
176479 202032 2 19 1319 Fitzgerald Ave 2 7 1 1     9 Width 7ft   6014005.50578 2090967.22182 37.7221855320171 -122.393663822829 (37.7221855320171, -122.393663822829)
49652 202033 2 19 1319 Fitzgerald Ave 3 7 1 1     10 Width 7ft   6014010.86588 2090963.17222 37.722174710472004 -122.39364501082198 (37.722174710472, -122.393645010822)
Powered by Datasette · Query took 23.335ms · Data source: data.sfgov.org